mes-client/UAS-出货标签管理/PowerSetting.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Windows.Forms;

namespace UAS_LabelMachine
{
    public partial class PowerSetting : Form
    {
        public PowerSetting()
        {
            InitializeComponent();
        }

        DataHelper dh;

        DataTable dt;

        string condition = "";

        private void PowerSetting_Load(object sender, EventArgs e)
        {
            dh = new DataHelper();
            LoadData();
            ChooseAll.ChooseAll(PowerSetDGV);
        }

        private void AddRow_Click(object sender, EventArgs e)
        {
            if (PowerSetDGV.DataSource as DataTable != null)
                (PowerSetDGV.DataSource as DataTable).Rows.Add();
        }

        private void SaveGrid_Click(object sender, EventArgs e)
        {
            dt = (DataTable)PowerSetDGV.DataSource;
            string sql = "insert into labelprintpower(lpp_id,lpp_emcode,LPP_CLEANDETAIL,LPP_GENCODE,LPP_LABELMATAIN,LPP_SAVEDETAIL,LPP_COLLECTSTRATEGY,";
            sql += "LPP_ALLCOLLECT) values(labelprintpower_seq.nextval,:lpp_emcode,:LPP_CLEANDETAIL,:LPP_GENCODE,:LPP_LABELMATAIN,:LPP_SAVEDETAIL,";
            sql += ":LPP_COLLECTSTRATEGY,:LPP_ALLCOLLECT)";
            dh.UpDateTableByCondition(dt.GetChanges(), "labelprintpower", "lpp_id", sql.ToLower());
            LoadData();
        }

        private void Delete_Click(object sender, EventArgs e)
        {
            dt = (DataTable)PowerSetDGV.DataSource;
            List<string> deleteid = new List<string>();
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (PowerSetDGV.Rows[i].Cells["Choose"].FormattedValue.ToString() == "True")
                {
                    deleteid.Add(PowerSetDGV.Rows[i].Cells["lpp_id"].Value.ToString());
                }
            }
            if (deleteid.ToArray().Length > 0)
            {
                dh.DeleteDataByID("labelprintpower", "lpp_id", deleteid.ToArray());
                LoadData();
            }
        }

        private void LoadData()
        {
            string sql = " select lpp_emcode,em_name,lpp_id,LPP_CLEANDETAIL,LPP_GENCODE,LPP_LABELMATAIN,LPP_SAVEDETAIL,LPP_COLLECTSTRATEGY,LPP_ALLCOLLECT from labelprintpower left join employee on em_code = lpp_emcode " + condition;
            dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
            BaseUtil.FillDgvWithDataTable(PowerSetDGV, dt);
        }

        private void Screen_Click(object sender, EventArgs e)
        {
            condition = BaseUtil.GetScreenSqlCondition(em_code, em_name);
            LoadData();
        }
    }
}