Ejemplo n.º 1
0
 private void ReadRecordFromFile()
 {
     if (File.Exists("D:\\" + GetBanciDate() + GetBanci() + "\\" + GetBanciDate() + GetBanci() + ".csv"))
     {
         DataTable dt = new DataTable();
         dt.Columns.Add("日期", typeof(string));
         dt.Columns.Add("班次", typeof(string));
         dt.Columns.Add("机台号", typeof(string));
         dt.Columns.Add("机台穴号", typeof(string));
         dt.Columns.Add("产品barcode", typeof(string));
         DataTable dt1 = Csvfile.GetFromCsv("D:\\" + GetBanciDate() + GetBanci() + "\\" + GetBanciDate() + GetBanci() + ".csv", 1, dt);
         if (dt1.Rows.Count > 0)
         {
             foreach (DataRow item in dt1.Rows)
             {
                 RecordItem ri = new RecordItem();
                 ri.日期        = item["日期"].ToString();
                 ri.班次        = item["班次"].ToString();
                 ri.机台号       = item["机台号"].ToString();
                 ri.机台穴号      = item["机台穴号"].ToString();
                 ri.产品barcode = item["产品barcode"].ToString();
                 lock (LockObject)
                 {
                     recordItemList.Add(ri);
                 }
             }
         }
     }
     else
     {
         MsgText = AddMessage("本地记录不存在");
     }
 }
        private async void ReUpLoad()
        {
            DataTable dt = new DataTable();
            DataTable dt1;

            dt.Columns.Add("BLDATE", typeof(string));
            dt.Columns.Add("BLID", typeof(string));
            dt.Columns.Add("BLNAME", typeof(string));
            dt.Columns.Add("BLUID", typeof(string));
            dt.Columns.Add("BLMID", typeof(string));
            dt.Columns.Add("Bar", typeof(string));
            string filename = @"D:\NotUpdate.csv";

            UpdateCount = 0;
            if (File.Exists(filename))
            {
                dt1 = Csvfile.GetFromCsv(filename, 1, dt);
                if (dt1.Rows.Count > 0)
                {
                    File.Delete(filename);
                    foreach (DataRow item in dt1.Rows)
                    {
                        DP6SQLROW dP6SQLROW = new DP6SQLROW();
                        dP6SQLROW.BLDATE = item[0].ToString();
                        dP6SQLROW.BLID   = item[1].ToString();
                        dP6SQLROW.BLMID  = item[4].ToString();
                        dP6SQLROW.BLNAME = item[2].ToString();
                        dP6SQLROW.BLUID  = item[3].ToString();
                        dP6SQLROW.Bar    = item[5].ToString();
                        bool r;
                        using (var releaser = await m_lock.LockAsync())
                        {
                            r = await Update_A_Row(dP6SQLROW);
                        }
                        if (r)//更具是否上传成功,写入不同的记录文档
                        {
                            lock (DisEq)
                            {
                                _BarcodeRecord.Enqueue(dP6SQLROW);
                            }
                            WriteRecordtoExcel(dP6SQLROW, true);
                            UpdateCount++;
                            //上传成功
                        }
                        else
                        {
                            WriteRecordtoExcel(dP6SQLROW, false);
                            //上传失败
                        }
                    }
                }
            }
            LastReUpdateStr = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            Inifile.INIWriteValue(iniParameterPath, "ReUpLoad", "LastReUpdateStr", LastReUpdateStr);
        }
        private void ReadBarcodeRecordfromCSV()
        {
            //"Date", "Barcode", "MachineID", "UserID", "ProductName", "MachineName", "FactoryArea", "FactorySeparation"
            string    filepath = "D:\\生产记录\\条码" + GlobalVar.GetBanci() + ".csv";
            DataTable dt       = new DataTable();
            DataTable dt1;

            dt.Columns.Add("Date", typeof(string));
            dt.Columns.Add("Barcode", typeof(string));
            dt.Columns.Add("MachineID", typeof(string));
            dt.Columns.Add("UserID", typeof(string));

            dt.Columns.Add("ProductName", typeof(string));
            dt.Columns.Add("MachineName", typeof(string));
            dt.Columns.Add("FactoryArea", typeof(string));
            dt.Columns.Add("FactorySeparation", typeof(string));
            dt.Columns.Add("ZhiJuClass", typeof(string));
            dt.Columns.Add("Barcodeproofing", typeof(string));
            dt.Columns.Add("scancodetype", typeof(string));
            dt.Columns.Add("CCD", typeof(string));
            dt.Columns.Add("NNNN", typeof(string));
            try
            {
                if (File.Exists(filepath))
                {
                    dt1 = Csvfile.GetFromCsv(filepath, 1, dt);
                    if (dt1.Rows.Count > 0)
                    {
                        foreach (DataRow item in dt1.Rows)
                        {
                            MESDataItem tr = new MESDataItem()
                            {
                                Date = item[0].ToString(), Index = item[1].ToString(), Barcode = item[2].ToString(), MachineID = item[3].ToString(), UserID = item[4].ToString(), ProductName = item[5].ToString(), MachineName = item[6].ToString(), FactoryArea = item[7].ToString(), FactorySeparation = item[8].ToString()
                            };
                            lock (GlobalVar.obj1)
                            {
                                //GlobalVar.AlarmRecord.Add(tr);
                                GlobalVar.MESDataRecordQueue.Enqueue(tr);
                            }
                        }
                        GlobalVar.AddMessage("读取条码记录完成");
                    }
                }
                else
                {
                    GlobalVar.AddMessage("条码记录不存在");
                }
            }
            catch (Exception ex)
            {
                GlobalVar.AddMessage(ex.Message);
            }
        }
        private void LoadBarCsvFromFile()
        {
            DataTable dt = new DataTable();
            DataTable dt1;

            dt.Columns.Add("BLDATE", typeof(string));
            dt.Columns.Add("BLID", typeof(string));
            dt.Columns.Add("BLNAME", typeof(string));
            dt.Columns.Add("BLUID", typeof(string));
            dt.Columns.Add("BLMID", typeof(string));
            dt.Columns.Add("Bar", typeof(string));
            string bcstr    = GetBanci();
            string filename = @"D:\Record\" + bcstr + ".csv";

            try
            {
                if (File.Exists(filename))
                {
                    dt1 = Csvfile.GetFromCsv(filename, 1, dt);
                    if (dt1.Rows.Count > 0)
                    {
                        foreach (DataRow item in dt1.Rows)
                        {
                            DP6SQLROW dp6 = new DP6SQLROW();
                            dp6.BLDATE = item[0].ToString();
                            dp6.BLID   = item[1].ToString();
                            dp6.BLNAME = item[2].ToString();
                            dp6.BLUID  = item[3].ToString();
                            dp6.BLMID  = item[4].ToString();
                            dp6.Bar    = item[5].ToString();
                            lock (DisEq)
                            {
                                _BarcodeRecord.Enqueue(dp6);
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MsgText = AddMessage(ex.Message);
            }
        }
        private void ReadAlarmRecordfromCSV()
        {
            string    filepath = "D:\\报警记录\\报警记录" + GlobalVar.GetBanci() + ".csv";
            DataTable dt       = new DataTable();
            DataTable dt1;

            dt.Columns.Add("AlarmDate", typeof(string));
            dt.Columns.Add("MachineID", typeof(string));
            dt.Columns.Add("UserID", typeof(string));
            dt.Columns.Add("AlarmMessage", typeof(string));
            try
            {
                if (File.Exists(filepath))
                {
                    dt1 = Csvfile.GetFromCsv(filepath, 1, dt);
                    if (dt1.Rows.Count > 0)
                    {
                        foreach (DataRow item in dt1.Rows)
                        {
                            AlarmTableItem tr = new AlarmTableItem()
                            {
                                AlarmDate = item[0].ToString(), MachineID = item[1].ToString(), UserID = item[2].ToString(), AlarmMessage = item[3].ToString()
                            };
                            lock (GlobalVar.obj)
                            {
                                //GlobalVar.AlarmRecord.Add(tr);
                                GlobalVar.AlarmRecordQueue.Enqueue(tr);
                            }
                        }
                        GlobalVar.AddMessage("读取报警记录完成");
                    }
                }
                else
                {
                    GlobalVar.AddMessage("报警记录不存在");
                }
            }
            catch (Exception ex)
            {
                GlobalVar.AddMessage(ex.Message);
            }
        }