void Init() { try { string ExIoExcelPath = System.Environment.CurrentDirectory + "\\排版.xlsx"; if (File.Exists(ExIoExcelPath)) { FileInfo existingFile = new FileInfo(ExIoExcelPath); using (ExcelPackage package = new ExcelPackage(existingFile)) { // get the first worksheet in the workbook ExcelWorksheet worksheet = package.Workbook.Worksheets[2]; for (int i = 0; i < 96; i++) { BordIndex[i] = int.Parse(worksheet.Cells[i / 12 + 1, i % 12 + 1].Value.ToString()); } } string ip = Inifile.INIGetStringValue(iniParameterPath, "FX5U", "Ip", "192.168.0.20"); int port = int.Parse(Inifile.INIGetStringValue(iniParameterPath, "FX5U", "Port", "504")); Fx5u = new Fx5u(ip, port); Scan5 = new Scan(); string COM = Inifile.INIGetStringValue(iniParameterPath, "Scan", "Scan5", "COM3"); Scan5.ini(COM); Run(); } else { throw new Exception("排版文件不存在"); } } catch (Exception ex) { AddMessage(ex.Message); } }
void Init() { PM.Text = _PM = Inifile.INIGetStringValue(iniParameterPath, "BigData", "PM", "X1621"); GROUP1.Text = _GROUP1 = Inifile.INIGetStringValue(iniParameterPath, "BigData", "GROUP1", "NA"); TRACK.Text = _TRACK = Inifile.INIGetStringValue(iniParameterPath, "BigData", "TRACK", "0102"); MACID.Text = _MACID = Inifile.INIGetStringValue(iniParameterPath, "BigData", "MACID", "007"); WORKSTATION.Text = _WORKSTATION = Inifile.INIGetStringValue(iniParameterPath, "BigData", "WORKSTATION", "X1621"); LIGHT_ID.Text = _LIGHT_ID = Inifile.INIGetStringValue(iniParameterPath, "BigData", "LIGHT_ID", "007"); LampGreenElapse = int.Parse(Inifile.INIGetStringValue(iniParameterPath, "BigData", "LampGreenElapse", "0")); LampGreenFlickerElapse = int.Parse(Inifile.INIGetStringValue(iniParameterPath, "BigData", "LampGreenFlickerElapse", "0")); LampYellowElapse = int.Parse(Inifile.INIGetStringValue(iniParameterPath, "BigData", "LampYellowElapse", "0")); LampYellowFlickerElapse = int.Parse(Inifile.INIGetStringValue(iniParameterPath, "BigData", "LampYellowFlickerElapse", "0")); LampRedElapse = int.Parse(Inifile.INIGetStringValue(iniParameterPath, "BigData", "LampRedElapse", "0")); LastBanci = Inifile.INIGetStringValue(iniParameterPath, "Summary", "LastBanci", "null"); #region 报警文档 try { ExcelPackage.LicenseContext = LicenseContext.NonCommercial; if (File.Exists(alarmExcelPath)) { FileInfo existingFile = new FileInfo(alarmExcelPath); using (ExcelPackage package = new ExcelPackage(existingFile)) { // get the first worksheet in the workbook ExcelWorksheet worksheet = package.Workbook.Worksheets[0]; for (int i = 1; i <= worksheet.Dimension.End.Row; i++) { AlarmData ad = new AlarmData(); ad.Code = worksheet.Cells["A" + i.ToString()].Value == null ? "Null" : worksheet.Cells["A" + i.ToString()].Value.ToString(); ad.Content = worksheet.Cells["B" + i.ToString()].Value == null ? "Null" : worksheet.Cells["B" + i.ToString()].Value.ToString(); ad.Type = worksheet.Cells["C" + i.ToString()].Value == null ? "Null" : worksheet.Cells["C" + i.ToString()].Value.ToString(); ad.Start = DateTime.Now; ad.End = DateTime.Now; ad.State = false; AlarmList.Add(ad); } AddMessage("读取到" + worksheet.Dimension.End.Row.ToString() + "条报警"); } } else { AddMessage("X1621串线下料机报警.xlsx 文件不存在"); } } catch (Exception ex) { AddMessage(ex.Message); } #endregion string ip = Inifile.INIGetStringValue(iniParameterPath, "FX5U", "Ip", "192.168.0.20"); int port = int.Parse(Inifile.INIGetStringValue(iniParameterPath, "FX5U", "Port", "504")); Fx5u = new Fx5u(ip, port); ip = Inifile.INIGetStringValue(iniParameterPath, "FX5U", "Ip2", "192.168.0.20"); port = int.Parse(Inifile.INIGetStringValue(iniParameterPath, "FX5U", "Port2", "504")); Fx5u_2 = new Fx5u(ip, port); ScanA = new Scan(); string COM = Inifile.INIGetStringValue(iniParameterPath, "Scan", "ScanA", "COM3"); ScanA.ini(COM); ScanB = new Scan(); COM = Inifile.INIGetStringValue(iniParameterPath, "Scan", "ScanB", "COM3"); ScanB.ini(COM); UpdateUI(); CardRun(); Task.Run(() => { Run(); }); BigDataRun(); #region 更新本地时间 try { SXJLibrary.Oracle oraDB = new SXJLibrary.Oracle("qddb04.eavarytech.com", "mesdb04", "ictdata", "ictdata*168"); if (oraDB.isConnect()) { string oracleTime = oraDB.OraclDateTime(); AddMessage("更新数据库时间到本地" + oracleTime); } oraDB.disconnect(); } catch (Exception ex) { AddMessage(ex.Message); } #endregion }