mes-client/UAS_MES_JH/FunctionCode/Special/Special_Orin.cs

using System;
using System.Collections.Generic;
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.Special
{
    public partial class Special_Orin : Form
    {
        DataHelper dh;

        LogStringBuilder sql = new LogStringBuilder();
        DataTable dt = new DataTable();
        DataTable dbfind;
        ExcelHandler eh;
        DataTable dbbom;

        Thread thread;


        public Special_Orin()
        {
            InitializeComponent();
        }

        private void Special_BoxSplit_Load(object sender, EventArgs e)
        {
            eh = new ExcelHandler();
            dh = SystemInf.dh;

        }

        private void Pr_code_DbChange(object sender, EventArgs e)
        {

            BaseUtil.SetFormValue(this.Controls, dbfind);
        }

        private void normalButton2_Click(object sender, EventArgs e)
        {
            DialogResult result = openFileDialog1.ShowDialog();
            if (result == DialogResult.OK)
            {
                textBox1.Text = openFileDialog1.FileName;
            }
        }

        //创建打印进程
        private void NewPrint()
        {
            try
            {
                BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt);

                int number = 0;

                List<string> snlist = new List<string>();
                List<string> gglist = new List<string>();
                List<string> cmlist = new List<string>();
                List<string> soclist = new List<string>();
                List<string> wifilist = new List<string>();
                List<string> gslist = new List<string>();
                List<string> emmclist = new List<string>();
                List<string> ddrlist = new List<string>();
                List<string> mfilist = new List<string>();

                for (int i = 0; i < dt.Rows.Count; i++)
                {

                    if (dt.Rows[i]["原材料SN"].ToString().Trim().Length > 2)
                    {
                        snlist.Add(dt.Rows[i]["原材料SN"].ToString().Trim());
                        gglist.Add(dt.Rows[i]["型号"].ToString().Trim());
                        cmlist.Add(dt.Rows[i]["触摸型号"].ToString().Trim());
                        soclist.Add(dt.Rows[i]["SOC"].ToString().Trim());
                        wifilist.Add(dt.Rows[i]["WIFI"].ToString().Trim());
                        gslist.Add(dt.Rows[i]["GSensor"].ToString().Trim());
                        emmclist.Add(dt.Rows[i]["EMMC"].ToString().Trim());
                        ddrlist.Add(dt.Rows[i]["DDR"].ToString().Trim());
                        mfilist.Add(dt.Rows[i]["MFI"].ToString().Trim());

                        number++;
                    }



                    // dh.ExecuteSql("MERGE INTO SNIMEI a USING ( SELECT '" + dt.Rows[i]["SN"].ToString() + "' as SN FROM dual ) b ON (a.SN = b.SN) WHEN MATCHED THEN UPDATE SET a.IMEI1 = '" + dt.Rows[i]["IMEI1"].ToString() + "', a.IMEI2 = '" + dt.Rows[i]["IMEI2"].ToString() + "',a.BT = '" + dt.Rows[i]["BT"].ToString() + "', a.WIFI = '" + dt.Rows[i]["WIFI"].ToString() + "' WHEN NOT MATCHED THEN INSERT (a.SN, a.IMEI1, a.IMEI2,a.BT, a.WIFI) VALUES ('" + dt.Rows[i]["SN"].ToString() + "', '" + dt.Rows[i]["IMEI1"].ToString() + "', '" + dt.Rows[i]["IMEI2"].ToString() + "','" + dt.Rows[i]["BT"].ToString() + "','" + dt.Rows[i]["WIFI"].ToString() + "')", "insert");
                }

                sql.Clear();
                sql.Append("insert into tt_orin(OR_SNT,OR_GGT,OR_CMT,OR_SOCT,OR_WIFIT,OR_GST,OR_EMMCT,OR_DDRT,OR_MFIT)");
                sql.Append("values(:sn,:gg,:cm,:soc,:wifi,:gs,:emmc,:ddr,:mfi)");

                dh.BatchInsert(sql.GetString(), new string[] { "sn", "gg", "cm", "soc", "wifi", "gs", "emmc", "ddr", "mfi" }, snlist.ToArray(), gglist.ToArray(), cmlist.ToArray(), soclist.ToArray(), wifilist.ToArray(), gslist.ToArray(), emmclist.ToArray(), ddrlist.ToArray(), mfilist.ToArray());


                sql.Clear();
                sql.Append("merge  into orin using tt_orin  on (OR_SN = OR_SNT) when  MATCHED then UPDATE set OR_GG = OR_GGT,OR_CM=OR_CMT,OR_SOC=OR_SOCT,OR_WIFI=OR_WIFIT,OR_GS=OR_GST,OR_EMMC=OR_EMMCT,OR_DDR=OR_DDRT,OR_MFI=OR_MFIT,OR_INDATE = SYSDATE when not MATCHED then insert  (OR_SN,OR_GG,OR_CM,OR_SOC,OR_WIFI,OR_GS,OR_EMMC,OR_DDR,OR_MFI,OR_INDATE)");
                sql.Append(" values (OR_SNT,OR_GGT,OR_CMT,OR_SOCT,OR_WIFIT,OR_GST,OR_EMMCT,OR_DDRT,OR_MFIT,SYSDATE)");
                dh.ExecuteSql(sql.GetString(), "insert");

                dh.ExecuteSql("delete tt_orin", "delete");
                MessageBox.Show("导入成功！记录：" + dt.Rows.Count + "行");
            }
            catch (Exception ex)
            {
                dh.ExecuteSql("delete tt_orin", "delete");
                MessageBox.Show(ex.Message);
            }


        }

        private void normalButton3_Click(object sender, EventArgs e)
        {
            if (textBox1.Text == "")
            {
                MessageBox.Show("文件地址不可为空");
                return;
            }
            dt = eh.ImportExcel(textBox1.Text, "IMEI");



            thread = new Thread(NewPrint);
            SetLoadingWindow stw = new SetLoadingWindow(thread, "请稍候...");
            BaseUtil.SetFormCenter(stw);
            stw.ShowDialog();

            //for (int i = 0; i < dt.Rows.Count; i++)
            //{
            //    MessageBox.Show(dt.Rows[i]["RefDes"].ToString()+":"+ dt.Rows[i]["Layer"].ToString());
            //}



        }
    }
}