mes-client/UAS_MES_JH/FunctionCode/Make/Make_Sndown.cs

using System;
using System.Data;
using System.Threading;
using System.Windows.Forms;
using UAS_MES_NEW.DataOperate;
using UAS_MES_NEW.Entity;
using UAS_MES_NEW.PublicForm;
using UAS_MES_NEW.PublicMethod;

namespace UAS_MES_NEW.Make
{
    public partial class Make_Sndown : Form
    {
        DataHelper dh;

        LogStringBuilder sql = new LogStringBuilder();

        AutoSizeFormClass asc = new AutoSizeFormClass();

        DataTable ComBoxData = new DataTable();


        DataTable Dbfind;
        public Make_Sndown()
        {
            InitializeComponent();
        }

        private void Query_OnlineTraceBack_Load(object sender, EventArgs e)
        {
            asc.controllInitializeSize(this);
            dh = SystemInf.dh;


            //工单号放大镜配置
            ma_code.TableName = "make left join product on ma_prodcode=pr_code";
            ma_code.SelectField = "ma_code # 工单号,ma_prodcode # 产品编号,ma_qty # 工单数量,pr_detail # 产品名称,ma_softversion # 软件版本";
            ma_code.FormName = Name;
            ma_code.SetValueField = new string[] { "ma_code" };
            ma_code.Condition = "ma_statuscode='STARTED'";
            ma_code.DbChange += Ma_code_DbChange;

            DataTable dt = (DataTable)dh.ExecuteSql(" select li_code,li_name from line ", "select");
            linecode.DisplayMember = "li_name";
            linecode.ValueMember = "li_code";
            linecode.DataSource = dt;
            linecode.Text = "";




        }



        private void Ma_code_DbChange(object sender, EventArgs e)
        {

            Dbfind = ma_code.ReturnData;
            BaseUtil.SetFormValue(this.Controls, Dbfind);
            // Query.PerformClick();
        }

        private void Query_OnlineTraceBack_SizeChanged(object sender, EventArgs e)
        {
            asc.controlAutoSize(this);
        }

        private void Query_Click(object sender, EventArgs e)
        {
            if (dh.CheckExist("make", "ma_code='" + ma_code.Text + "'"))
            {
                string condition = BaseUtil.GetScreenSqlCondition(ma_code, linecode, ms_stepcode, sncode);
                sql.Clear();
                sql.Append("select sp_id,sp_sncode,sp_makecode,sp_prodcode,li_name,st_name,sp_date from steppassed left join line on sp_linecode = li_code left join step on sp_stepcode = st_code ");
                sql.Append(condition);
                sql.Append("and sp_date between to_date('" + BeginDate.Value.ToString("yyyy-MM-dd HH:mm:ss") + "', 'yyyy-mm-dd hh24:mi:ss') and to_date('" + EndDate.Value.ToString("yyyy-MM-dd HH:mm:ss") + "', 'yyyy-mm-dd hh24:mi:ss') and not EXISTS (select 1 from makedown where (md_sncode = sp_sncode or md_code = sp_sncode) and md_status = 0 and md_macode = sp_makecode)");
                sql.Append(" order by sp_date asc ");
                DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                BaseUtil.FillDgvWithDataTable(SnInf, dt);

                checkBox1.Checked = false;
                Count.Text = "";
            }
            else
            {
                MessageBox.Show("工单号" + ma_code.Text + "不存在");
                //BaseUtil.CleanDataGridView(SnInf);
                //ma_code.Text = "";
            }

        }



        private void normalButton1_Click(object sender, EventArgs e)
        {
            Thread InitPrint;
            InitPrint = new Thread(InPrint);
            SetLoadingWindow stw = new SetLoadingWindow(InitPrint, "SN锁定中");
            BaseUtil.SetFormCenter(stw);
            stw.ShowDialog();


        }

        private void InPrint()
        {
            try
            {
                int count = SnInf.Rows.Count;
                int check = 0;
                for (int i = 0; i < count; i++)
                {
                    DataGridViewCheckBoxCell checkCell = (DataGridViewCheckBoxCell)SnInf.Rows[i].Cells["choose1"];
                    Boolean flag = Convert.ToBoolean(checkCell.Value);
                    if (flag == true)
                    {
                        if (!dh.CheckExist("MAKEDOWN", "(MD_SNCODE = '" + SnInf.Rows[i].Cells["sp_sncode"].Value.ToString() + "' or MD_CODE = '" + SnInf.Rows[i].Cells["sp_sncode"].Value.ToString() + "') and  MD_MACODE = '" + SnInf.Rows[i].Cells["sp_makecode"].Value.ToString() + "' and  MD_STATUS = 0 "))
                        {
                            sql.Clear();
                            sql.Append("INSERT INTO MAKEDOWN (MD_ID,MD_MSID,MD_LINECODE,MD_STEPCODE,");
                            sql.Append("MD_SNCODE,MD_PRODCODE,MD_MACODE, MD_CODE,");
                            sql.Append("MD_DOWNDATE,MD_DOWNMAN,MD_STATUS) select  MAKEDOWN_seq.nextval,ms_id,'" + SnInf.Rows[i].Cells["li_name"].Value.ToString() + "',");
                            sql.Append("'" + SnInf.Rows[i].Cells["st_name"].Value.ToString() + "',ms_sncode,'" + SnInf.Rows[i].Cells["sp_prodcode"].Value.ToString() + "','" + SnInf.Rows[i].Cells["sp_makecode"].Value.ToString() + "',ms_code,sysdate,'" + User.UserCode + "','0' from makeserial where (ms_sncode = '" + SnInf.Rows[i].Cells["sp_sncode"].Value.ToString() + "' or ms_code = '" + SnInf.Rows[i].Cells["sp_sncode"].Value.ToString() + "') and ms_makecode = '" + SnInf.Rows[i].Cells["sp_makecode"].Value.ToString() + "'");
                            //执行
                            dh.ExecuteSql(sql.GetString(), "insert");
                            check++;
                        }
                    }
                }
                MessageBox.Show(check + "条数据下地锁定成功");
                Thread.Sleep(500);
                Query_Click(null, null);
            }
            catch (Exception EX)
            {
                MessageBox.Show(EX.Message);
            }

        }

        private void Query_OnlineTraceBack_FormClosing(object sender, FormClosingEventArgs e)
        {
            dh.Dispose();
        }

        private void checkBox1_CheckedChanged(object sender, EventArgs e)
        {
            int count = SnInf.Rows.Count;
            for (int i = 0; i < count; i++)
            {
                DataGridViewCheckBoxCell checkCell = (DataGridViewCheckBoxCell)SnInf.Rows[i].Cells["choose1"];
                Boolean flag = Convert.ToBoolean(checkCell.Value);
                if (flag != checkBox1.Checked)
                {
                    checkCell.Value = checkBox1.Checked;
                }
                else
                {
                    continue;
                }
            }
            countcheck();
        }

        private void normalButton2_Click(object sender, EventArgs e)
        {

        }

        private void countcheck()
        {
            int checkedRowCount = 0;

            foreach (DataGridViewRow row in SnInf.Rows)
            {
                DataGridViewCheckBoxCell checkBoxCell = row.Cells["choose1"] as DataGridViewCheckBoxCell;

                if (checkBoxCell != null && Convert.ToBoolean(checkBoxCell.Value) == true)
                {
                    checkedRowCount++;
                }
            }

            Count.Text = checkedRowCount.ToString();
        }





        private void ma_code_UserControlTextChanged(object sender, EventArgs e)
        {
            DataTable dt = (DataTable)dh.ExecuteSql(" select mcd_stepcode,mcd_stepname from MAKECRAFTDETAIL where mcd_macode = '" + ma_code.Text + "' order by mcd_detno asc  ", "select");
            ms_stepcode.DisplayMember = "mcd_stepname";
            ms_stepcode.ValueMember = "mcd_stepcode";
            ms_stepcode.DataSource = dt;
            ms_stepcode.Text = "";
        }





        private void SnInf_CurrentCellDirtyStateChanged(object sender, EventArgs e)
        {
            if (SnInf.CurrentCell is DataGridViewCheckBoxCell)
            {
                SnInf.CommitEdit(DataGridViewDataErrorContexts.Commit);
                countcheck();
                // 执行你的操作，使用 checkedRows
            }
        }

        private void normalButton2_Click_1(object sender, EventArgs e)
        {
            //Data表示导出数据
            //Templet表示导出模板
            folderBrowserDialog1.Description = "选择导出的路径";
            DialogResult result = folderBrowserDialog1.ShowDialog();
            if (result == DialogResult.OK)
            {
                string FolderPath = folderBrowserDialog1.SelectedPath;
                ExcelHandler eh = new ExcelHandler();
                //DataTable dt = (DataTable)SnInf.DataSource;
                //导出Excel的时候返回一个文件名，用户选择是否打开
                string filePath = eh.ExportExcel(SnInf, FolderPath);
                //用户选择导出之后是否立即打开
                MessageBoxButtons messButton = MessageBoxButtons.YesNo;
                string openFile = MessageBox.Show(this.ParentForm, "是否打开文件" + filePath, "提示", messButton).ToString();
                if (openFile == "Yes")
                {
                    System.Diagnostics.Process.Start(filePath);
                }
            }
        }
    }
}