GlobalContext.cs 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506
  1. using System;
  2. using System.Data;
  3. using StandardLibrary;
  4. using MainForm.Models;
  5. using MainForm.DbHelper;
  6. using MainForm.ClassFile.ProjectClass;
  7. namespace MainForm
  8. {
  9. /// <summary>
  10. /// 全局变量
  11. /// </summary>
  12. public class GlobalContext
  13. {
  14. #region 变量
  15. //消息委托和事件
  16. public static Action Set; // 更新UI的委托方法
  17. public static Action Save; // 保存的委托方法
  18. public static Action Close; // 关闭的委托方法
  19. /// <summary>
  20. /// 日志文件保存位置
  21. /// </summary>
  22. public static string FilePath = AppDomain.CurrentDomain.BaseDirectory + "Config.ini";
  23. public static string MainDir = @"D:\MESFile\";
  24. public static string WorkLogDir = MainDir + @"WorkLog\"; // 运行日志
  25. public static string PlcLogDir = MainDir + @"PLCLog\"; // plc写入日志
  26. public static string MqttLogDir = MainDir + @"MqttLog\"; // mqtt日志
  27. public static string ProcessDataDir = MainDir + @"ProcessData\"; // 加工数据日志
  28. public static string OneCheckDataDir = MainDir + @"OneCheckData\"; // 点检数据日志
  29. public static string SQLLogDir = MainDir + @"SQLLog\"; // sql日志
  30. public static string DBDir = @"D:\LocalDataBase\";
  31. public static string MESConfig = MainDir + @"MESConfig.ini"; // MES接口的配置文件
  32. public static string MqttServerPath = AppDomain.CurrentDomain.BaseDirectory + @"\ThingsMode\MqttServer.exe";
  33. public static string MqttServerName = "MqttServer";
  34. /// <summary>
  35. /// 点检数据文件
  36. /// </summary>
  37. public static string CheckOneDataPath = AppDomain.CurrentDomain.BaseDirectory + "CheckOneData.ini";
  38. // 产线及产品信息
  39. public static string Project_Code; // 项⽬编码
  40. public static string Factory_Code; // ⼯⼚ID
  41. public static string Process_Section_Code; // ⼯段编码
  42. public static string LineCode; // 线体编码
  43. public static string LineName; // 线体名称
  44. public static string ProgramName; // 程序名
  45. public static string WorkOrderCode; // 车间订单号
  46. public static string BatchNumber; // 批次号(splcode)
  47. public static string Mtltmrk; // 产品型号(mtltmrk)
  48. public static string S1_work_station; // [S1] ⼯站
  49. public static string S1_device_code; // [S1] 装备编码
  50. public static string S1_station; // [S1] ⼯位Id
  51. public static string S2_work_station; // [S2] ⼯站
  52. public static string S2_device_code; // [S2] 装备编码
  53. public static string S2_station; // [S2] ⼯位Id
  54. public static string S3_work_station; // [S3] ⼯站
  55. public static string S3_device_code; // [S3] 装备编码
  56. public static string S3_station; // [S3] ⼯位Id
  57. public static string S4_1_work_station; // [S4_1] ⼯站
  58. public static string S4_1_device_code; // [S4_1] 装备编码
  59. public static string S4_1_station; // [S4_1] ⼯位Id
  60. public static string S4_3_work_station; // [S4_3] ⼯站
  61. public static string S4_3_device_code; // [S4_3] 装备编码
  62. public static string S4_3_station; // [S4_3] ⼯位Id
  63. public static string S4_4_work_station; // [S4_4] ⼯站
  64. public static string S4_4_device_code; // [S4_4] 装备编码
  65. public static string S4_4_station; // [S4_4] ⼯位Id
  66. public static string S4_5_work_station; // [S4_5] ⼯站
  67. public static string S4_5_device_code; // [S4_5] 装备编码
  68. public static string S4_5_station; // [S4_5] ⼯位Id
  69. public static string S5_work_station; // [S5] ⼯站
  70. public static string S5_device_code; // [S5] 装备编码
  71. public static string S5_station; // [S5] ⼯位Id
  72. public static string S6_device_code; // [S5] 装备编码
  73. public static string S6_station; // [S5] ⼯位Id
  74. public static string S7_device_code; // [S5] 装备编码
  75. public static string S7_station; // [S5] ⼯位Id
  76. public static string S8_device_code; // [S5] 装备编码
  77. public static string S8_station; // [S5] ⼯位Id
  78. public static string S9_device_code; // [S5] 装备编码
  79. public static string S9_station; // [S5] ⼯位Id
  80. // 设备
  81. //public static string PCAddress="192.168.1.244";
  82. public static bool IsUsePLC1;
  83. public static bool IsUsePLC2;
  84. public static bool IsUsePLC3;
  85. public static bool IsUsePLC4;
  86. public static bool IsUsePLC5;
  87. public static bool IsUsePLC6;
  88. public static bool IsUsePLC7;
  89. public static bool IsUsePLC8;
  90. public static bool IsUsePLC9;
  91. public static string Machine1Address;
  92. public static string Machine2Address;
  93. public static string Machine3Address;
  94. public static string Machine4Address;
  95. public static string Machine5Address;
  96. public static string Machine6Address;
  97. public static string Machine7Address;
  98. public static string Machine8Address;
  99. public static string Machine9Address;
  100. public static string PC1Address;
  101. public static string PC2Address;
  102. public static string PC3Address;
  103. public static string PC4Address;
  104. public static string PC5Address;
  105. public static string PC6Address;
  106. public static string PC7Address;
  107. public static string PC8Address;
  108. public static string PC9Address;
  109. public static int MachinePort;
  110. public static string AtlasAddressLeft;
  111. public static string AtlasAddressRight;
  112. public static int AtlasAddressPort;
  113. // TCP
  114. public static string QrCodeTCPAddress1;
  115. public static int QrCodeTCPPort1;
  116. public static string QrCodeTCPAddress2;
  117. public static int QrCodeTCPPort2;
  118. public static string QrCodeTCPAddress3;
  119. public static int QrCodeTCPPort3;
  120. public static string QrCodeTCPAddress4;
  121. public static int QrCodeTCPPort4;
  122. public static string QrCodeTCPAddress5;
  123. public static int QrCodeTCPPort5;
  124. // MES
  125. public static bool IsUseMES; // 是否 启用MES
  126. public static string MESAppId; // 应用ID;mes_test
  127. public static string MESAppKey; // API接口名称;mes
  128. public static string MESUserId; // 用户ID
  129. public static string ServerHost; // 主服务器地址
  130. public static string StationInMESUrl; // 入站接口Url
  131. public static string StationOutMESUrl; // 出站接口Url
  132. public static string ServerIp; // 主服务器IP-解析所得
  133. //public static string StationInMESUrl; // 入站接口Url
  134. //public static string StationOutMESUrl; // 出站接口Url
  135. public static bool IsSendStationIn; // 启用上传进站
  136. public static bool IsSendProcessData; // 启用上传出站
  137. public static bool IsSendCheckOneData; // 启用上传点检
  138. public static bool IsSendWorkingData; // 启用上传状态
  139. public static bool IsSendAlarmData; // 启用上传报警
  140. public static bool IsUseMESRoute; // 启用边线MES软件
  141. public static bool MESIsConnect; // MES是否正常连接
  142. public static string MESLaserLPath; // 三点激光数据本地存放地址
  143. public static string MESLaserRPath; // 三点激光数据本地存放地址
  144. public static string UpFileUrl; // 文档库地址
  145. public static string UpFilePath; // 本地文件路径
  146. public static bool IsSendUpFile; // 启用上传文件
  147. // IOT - MQTT
  148. public static bool IsUseIot; // 是否 启用IOT
  149. public static string MQTTServerHost; // 服务器IP
  150. public static int MQTTServerPort; // 服务器Port
  151. public static bool IsMqttSendProcessData; // 上传过站数据
  152. public static bool IsMqttDeviceState; // 上传设备状态
  153. public static bool IsMqttFaultLog; // 上传故障⽇志
  154. public static bool IsMqttSensorData; // 上传传感器数据
  155. public static bool IsMqttStationInputBegin; // 上传节拍⽇志
  156. public static bool IsMqttOperateLog; // 上传操作记录
  157. public static bool IsMqttEquiConfig; // 上传装备配置
  158. public static bool IsMqttProcConfig; // 上传⼯艺配置
  159. public static string MQTTAppId; // IOT应用ID
  160. public static string MQTTAppPwd; // IOT登录密码
  161. // IOT-AGV
  162. public static bool IsUseAGV; // 是否 启用AGV
  163. public static string AGVHttpHost; // Http 服务器地址
  164. public static string AGVHttpIp; // Http IP地址
  165. public static string AGVMQTTHost; // MQTT IP地址
  166. public static int AGVMQTTPort; // MQTT端口
  167. public static string AGVMQTTDeviceCode; // MQTT设备Code
  168. public static bool AGVMQTTIsConnect; // AGV MQTT是否正常连接
  169. // MES进出站 配置信息
  170. public static string S1_MachineId; // 工站1 - 壳体清洁上料装备
  171. public static string S1_StationId; // 工站1 - 壳体清洁上料装备
  172. public static string S2_MachineId; // 工站2 - 上盖板上料装备
  173. public static string S2_StationId; // 工站2 - 上盖板上料装备
  174. public static string S3_MachineId; // 工站3 - 点散热胶装备
  175. public static string S3_StationId; // 工站3 - 点散热胶装备
  176. public static string S3_StationId_1; // 工站3 - 点散热胶装备
  177. public static string S3_StationId_2; // 工站3 - 点散热胶装备
  178. public static string S4_MachineId; // 工站4 - 胶线检测装备
  179. public static string S4_StationId; // 工站4 - 胶线检测装备
  180. public static string S5_MachineId; // 工站5 - ADD板上料组装装备
  181. public static string S5_StationId; // 工站5 - ADD板上料组装装备
  182. public static string S6_MachineId; // 工站6 - 组上盖板装备
  183. public static string S6_StationId; // 工站6 - 组上盖板装备
  184. public static string S7_MachineId; // 工站7 - 上盖板锁螺丝装备
  185. public static string S7_StationId; // 工站7 - 上盖板锁螺丝装备
  186. public static string S7_StationId_1; // 工站7 - 上盖板锁螺丝装备
  187. public static string S7_StationId_2; // 工站7 - 上盖板锁螺丝装备
  188. public static string S8_MachineId; // 工站8 - NG下料装备
  189. public static string S8_StationId; // 工站8 - NG下料装备
  190. public static string S9_MachineId; // 工站9 - 产品下料装备
  191. public static string S9_StationId; // 工站9 - 产品下料装备
  192. // 本地数据库
  193. public static string Server;
  194. public static string User;
  195. public static string PassWord;
  196. //其它
  197. public static string CurrentUser = "";
  198. public static string MacStr = "";
  199. #region 是否可连接PLC-用户手动控制用(后加)
  200. public static bool _IsCon_Funs1 = true;
  201. public static bool _IsCon_Funs2 = true;
  202. public static bool _IsCon_Funs3 = true;
  203. public static bool _IsCon_Funs4 = true;
  204. public static bool _IsCon_Funs5 = true;
  205. public static bool _IsCon_plc1Heat = true;
  206. public static bool _IsCon_plc1Alarm = true;
  207. #endregion 是否可连接PLC-用户手动控制用(后加)
  208. #endregion 变量
  209. #region 常量
  210. //产品常量
  211. public const string ConstLineCode = "A1";
  212. public const string ConstLineName = "A1产线";
  213. public const string ConstProgramName = "A1程序名";
  214. public const string ConstSono = " ";
  215. public const string ConstWorkOrderCode = " ";
  216. public const string ConstBatchNumber = " ";
  217. public const string ConstMtltmrk = " ";
  218. public const string ConstSupplierCode = " ";
  219. //设备常量
  220. public const string ConstMachine1Address = "192.168.10.87";
  221. public const string ConstMachine2Address = "192.168.2.1";
  222. public const string ConstMachine3Address = "192.168.4.111";
  223. public const string ConstMachine4Address = "192.168.4.1";
  224. public const string ConstMachine5Address = "192.168.6.111";
  225. public const string ConstMachine6Address = "192.168.6.1";
  226. public const string ConstMachine7Address = "192.168.6.71";
  227. public const string ConstMachine8Address = "192.168.6.81";
  228. public const string ConstMachine9Address = "192.168.1.91";
  229. public const string ConstPc1Address = "192.168.1.10";
  230. public const string ConstPc2Address = "192.168.1.10";
  231. public const string ConstPc3Address = "192.168.1.10";
  232. public const string ConstPc4Address = "192.168.1.10";
  233. public const string ConstPc5Address = "192.168.1.10";
  234. public const string ConstPc6Address = "192.168.1.10";
  235. public const string ConstPc7Address = "192.168.1.10";
  236. public const string ConstPc8Address = "192.168.1.10";
  237. public const string ConstPc9Address = "192.168.1.10";
  238. public const string ConstMachinePort = "1217";
  239. //MES常量
  240. public const string ConstServerHost = "10.1.19.33:8080";
  241. public const string ConstIsSend = "false";
  242. #endregion 常量
  243. public GlobalContext()
  244. {
  245. UpdateData();
  246. }
  247. /// <summary>
  248. /// 更新全局变量
  249. /// </summary>
  250. public static void UpdateData()
  251. {
  252. try
  253. {
  254. // 产线及产品信息
  255. Project_Code = IniFile.INIGetStringValue(FilePath, "Product", "ProjectCode", "");
  256. Factory_Code = IniFile.INIGetStringValue(FilePath, "Product", "FactoryCode", "");
  257. Process_Section_Code = IniFile.INIGetStringValue(FilePath, "Product", "ProcessSectionCode", "");
  258. LineCode = IniFile.INIGetStringValue(FilePath, "Product", "LineCode", ConstLineCode);
  259. LineName = IniFile.INIGetStringValue(FilePath, "Product", "LineName", ConstLineName);
  260. ProgramName = IniFile.INIGetStringValue(FilePath, "Product", "ProgramName", ConstProgramName);
  261. MESLaserLPath = IniFile.INIGetStringValue(FilePath, "MES", "MESLaserLPath", "");
  262. MESLaserRPath = IniFile.INIGetStringValue(FilePath, "MES", "MESLaserRPath", "");
  263. WorkOrderCode = IniFile.INIGetStringValue(FilePath, "Product", "WorkOrderCode", ConstWorkOrderCode); // 车间订单号
  264. BatchNumber = IniFile.INIGetStringValue(FilePath, "Product", "BatchNumber", ConstBatchNumber); // 批次号(splcode)
  265. Mtltmrk = IniFile.INIGetStringValue(FilePath, "Product", "Mtltmrk", ConstMtltmrk); // 产品型号(mtltmrk)
  266. // 工位信息
  267. S1_work_station = IniFile.INIGetStringValue(FilePath, "Station", "s1_work_station", ""); // [S1] ⼯站
  268. S1_device_code = IniFile.INIGetStringValue(FilePath, "Station", "s1_device_code", ""); // [S1] 装备编码
  269. S1_station = IniFile.INIGetStringValue(FilePath, "Station", "s1_station", ""); // [S1] ⼯位Id
  270. S2_work_station = IniFile.INIGetStringValue(FilePath, "Station", "s2_work_station", ""); // [S2] ⼯站
  271. S2_device_code = IniFile.INIGetStringValue(FilePath, "Station", "s2_device_code", ""); // [S2] 装备编码
  272. S2_station = IniFile.INIGetStringValue(FilePath, "Station", "s2_station", ""); // [S2] ⼯位Id
  273. S3_work_station = IniFile.INIGetStringValue(FilePath, "Station", "s3_work_station", ""); // [S3] ⼯站
  274. S3_device_code = IniFile.INIGetStringValue(FilePath, "Station", "s3_device_code", ""); // [S3] 装备编码
  275. S3_station = IniFile.INIGetStringValue(FilePath, "Station", "s3_station", ""); // [S3] ⼯位Id
  276. S4_1_work_station = IniFile.INIGetStringValue(FilePath, "Station", "s4_1_work_station", ""); // [S4_1] ⼯站
  277. S4_1_device_code = IniFile.INIGetStringValue(FilePath, "Station", "s4_1_device_code", ""); // [S4_1] 装备编码
  278. S4_1_station = IniFile.INIGetStringValue(FilePath, "Station", "s4_1_station", ""); // [S4_1] ⼯位Id
  279. S4_3_work_station = IniFile.INIGetStringValue(FilePath, "Station", "s4_3_work_station", ""); // [S4_3] ⼯站
  280. S4_3_device_code = IniFile.INIGetStringValue(FilePath, "Station", "s4_3_device_code", ""); // [S4_3] 装备编码
  281. S4_3_station = IniFile.INIGetStringValue(FilePath, "Station", "s4_3_station", ""); // [S4_3] ⼯位Id
  282. S4_4_work_station = IniFile.INIGetStringValue(FilePath, "Station", "s4_4_work_station", ""); // [S4_4] ⼯站
  283. S4_4_device_code = IniFile.INIGetStringValue(FilePath, "Station", "s4_4_device_code", ""); // [S4_4] 装备编码
  284. S4_4_station = IniFile.INIGetStringValue(FilePath, "Station", "s4_4_station", ""); // [S4_4] ⼯位Id
  285. S4_5_work_station = IniFile.INIGetStringValue(FilePath, "Station", "s4_5_work_station", ""); // [S4_5] ⼯站
  286. S4_5_device_code = IniFile.INIGetStringValue(FilePath, "Station", "s4_5_device_code", ""); // [S4_5] 装备编码
  287. S4_5_station = IniFile.INIGetStringValue(FilePath, "Station", "s4_5_station", ""); // [S4_5] ⼯位Id
  288. S5_work_station = IniFile.INIGetStringValue(FilePath, "Station", "s5_work_station", ""); // [S5] ⼯站
  289. S5_device_code = IniFile.INIGetStringValue(FilePath, "Station", "s5_device_code", ""); // [S5] 装备编码
  290. S5_station = IniFile.INIGetStringValue(FilePath, "Station", "s5_station", ""); // [S5] ⼯位Id
  291. // 设备
  292. IsUsePLC1 = bool.Parse(IniFile.INIGetStringValue(FilePath, "Machine", "IsUsePLC1", "false"));
  293. IsUsePLC2 = bool.Parse(IniFile.INIGetStringValue(FilePath, "Machine", "IsUsePLC2", "false"));
  294. IsUsePLC3 = bool.Parse(IniFile.INIGetStringValue(FilePath, "Machine", "IsUsePLC3", "false"));
  295. IsUsePLC4 = bool.Parse(IniFile.INIGetStringValue(FilePath, "Machine", "IsUsePLC4", "false"));
  296. IsUsePLC5 = bool.Parse(IniFile.INIGetStringValue(FilePath, "Machine", "IsUsePLC5", "false"));
  297. IsUsePLC6 = bool.Parse(IniFile.INIGetStringValue(FilePath, "Machine", "IsUsePLC6", "false"));
  298. IsUsePLC7 = bool.Parse(IniFile.INIGetStringValue(FilePath, "Machine", "IsUsePLC7", "false"));
  299. IsUsePLC8 = bool.Parse(IniFile.INIGetStringValue(FilePath, "Machine", "IsUsePLC8", "false"));
  300. IsUsePLC9 = bool.Parse(IniFile.INIGetStringValue(FilePath, "Machine", "IsUsePLC9", "false"));
  301. Machine1Address = IniFile.INIGetStringValue(FilePath, "Machine", "Machine1Address", ConstMachine1Address);
  302. Machine2Address = IniFile.INIGetStringValue(FilePath, "Machine", "Machine2Address", ConstMachine2Address);
  303. Machine3Address = IniFile.INIGetStringValue(FilePath, "Machine", "Machine3Address", ConstMachine3Address);
  304. Machine4Address = IniFile.INIGetStringValue(FilePath, "Machine", "Machine4Address", ConstMachine4Address);
  305. Machine5Address = IniFile.INIGetStringValue(FilePath, "Machine", "Machine5Address", ConstMachine5Address);
  306. Machine6Address = IniFile.INIGetStringValue(FilePath, "Machine", "Machine6Address", ConstMachine6Address);
  307. Machine7Address = IniFile.INIGetStringValue(FilePath, "Machine", "Machine7Address", ConstMachine7Address);
  308. Machine8Address = IniFile.INIGetStringValue(FilePath, "Machine", "Machine8Address", ConstMachine8Address);
  309. Machine9Address = IniFile.INIGetStringValue(FilePath, "Machine", "Machine9Address", ConstMachine9Address);
  310. PC1Address = IniFile.INIGetStringValue(FilePath, "Machine", "Pc1Address", ConstPc1Address);
  311. PC2Address = IniFile.INIGetStringValue(FilePath, "Machine", "Pc2Address", ConstPc2Address);
  312. PC3Address = IniFile.INIGetStringValue(FilePath, "Machine", "Pc3Address", ConstPc3Address);
  313. PC4Address = IniFile.INIGetStringValue(FilePath, "Machine", "Pc4Address", ConstPc4Address);
  314. PC5Address = IniFile.INIGetStringValue(FilePath, "Machine", "Pc5Address", ConstPc5Address);
  315. PC6Address = IniFile.INIGetStringValue(FilePath, "Machine", "Pc6Address", ConstPc6Address);
  316. PC7Address = IniFile.INIGetStringValue(FilePath, "Machine", "Pc7Address", ConstPc7Address);
  317. PC8Address = IniFile.INIGetStringValue(FilePath, "Machine", "Pc8Address", ConstPc8Address);
  318. PC9Address = IniFile.INIGetStringValue(FilePath, "Machine", "Pc9Address", ConstPc9Address);
  319. MachinePort = int.Parse(IniFile.INIGetStringValue(FilePath, "Machine", "MachinePort", ConstMachinePort));
  320. AtlasAddressLeft = IniFile.INIGetStringValue(FilePath, "Machine", "AtlasAddressLeft", "");
  321. AtlasAddressRight = IniFile.INIGetStringValue(FilePath, "Machine", "AtlasAddressRight", "");
  322. AtlasAddressPort = int.Parse(IniFile.INIGetStringValue(FilePath, "Machine", "AtlasAddressPort", ""));
  323. QrCodeTCPAddress1 = IniFile.INIGetStringValue(FilePath, "TCP", "TCPAddress1", "127.0.0.1");
  324. QrCodeTCPPort1 = int.Parse(IniFile.INIGetStringValue(FilePath, "TCP", "TCPPort1", "0"));
  325. QrCodeTCPAddress2 = IniFile.INIGetStringValue(FilePath, "TCP", "TCPAddress2", "127.0.0.1");
  326. QrCodeTCPPort2 = int.Parse(IniFile.INIGetStringValue(FilePath, "TCP", "TCPPort2", "0"));
  327. QrCodeTCPAddress3 = IniFile.INIGetStringValue(FilePath, "TCP", "TCPAddress3", "127.0.0.1");
  328. QrCodeTCPPort3 = int.Parse(IniFile.INIGetStringValue(FilePath, "TCP", "TCPPort3", "0"));
  329. QrCodeTCPAddress4 = IniFile.INIGetStringValue(FilePath, "TCP", "TCPAddress4", "127.0.0.1");
  330. QrCodeTCPPort4 = int.Parse(IniFile.INIGetStringValue(FilePath, "TCP", "TCPPort4", "0"));
  331. QrCodeTCPAddress5 = IniFile.INIGetStringValue(FilePath, "TCP", "TCPAddress5", "127.0.0.1");
  332. QrCodeTCPPort5 = int.Parse(IniFile.INIGetStringValue(FilePath, "TCP", "TCPPort5", "0"));
  333. // MES
  334. MESAppId = IniFile.INIGetStringValue(FilePath, "MES", "MESAppId", "mes_test");
  335. MESAppKey = IniFile.INIGetStringValue(FilePath, "MES", "MESAppKey", "mes");
  336. MESUserId = IniFile.INIGetStringValue(FilePath, "MES", "MESUserId", "mes_userid");
  337. ServerHost = IniFile.INIGetStringValue(FilePath, "MES", "ServerHost", ConstServerHost);
  338. StationInMESUrl = IniFile.INIGetStringValue(FilePath, "MES", "StationInMESUrl", "");
  339. StationInMESUrl = string.Format(StationInMESUrl, ServerHost);
  340. StationOutMESUrl = IniFile.INIGetStringValue(FilePath, "MES", "StationOutMESUrl", "");
  341. StationOutMESUrl = string.Format(StationOutMESUrl, ServerHost);
  342. if (ServerHost.Contains(":"))
  343. {
  344. string[] mesServers = ServerHost.Split(':');
  345. ServerIp = mesServers[0];
  346. ServerIp = ServerHost.Replace("\\", "/");
  347. mesServers = ServerHost.Split('/');
  348. if (mesServers.Length > 3)
  349. ServerIp = mesServers[2];
  350. }
  351. else
  352. {
  353. ServerHost = ServerHost.Replace("\\", "/");
  354. string[] mesServers = ServerHost.Split('/');
  355. if (mesServers.Length > 3)
  356. ServerIp = mesServers[2];
  357. }
  358. //StationInMESUrl = IniFile.INIGetStringValue(MESConfig, "MES", "StationInMESUrl", "");
  359. //StationInMESUrl = string.Format(StationInMESUrl, ServerHost);
  360. //StationOutMESUrl = IniFile.INIGetStringValue(MESConfig, "MES", "StationOutMESUrl", "");
  361. //StationOutMESUrl = string.Format(StationOutMESUrl, ServerHost);
  362. IsUseMES = bool.Parse(IniFile.INIGetStringValue(FilePath, "MES", "IsUseMES", ConstIsSend));
  363. IsSendStationIn = bool.Parse(IniFile.INIGetStringValue(FilePath, "MES", "IsSendStationIn", ConstIsSend));
  364. IsSendProcessData = bool.Parse(IniFile.INIGetStringValue(FilePath, "MES", "IsSendProcessData", ConstIsSend));
  365. IsSendCheckOneData = bool.Parse(IniFile.INIGetStringValue(FilePath, "MES", "IsSendCheckOneData", ConstIsSend));
  366. IsSendWorkingData = bool.Parse(IniFile.INIGetStringValue(FilePath, "MES", "IsSendWorkingData", ConstIsSend));
  367. IsSendAlarmData = bool.Parse(IniFile.INIGetStringValue(FilePath, "MES", "IsSendAlarmData", ConstIsSend));
  368. IsUseMESRoute = bool.Parse(IniFile.INIGetStringValue(FilePath, "MES", "IsUseMESRoute", ConstIsSend));
  369. // MQTT
  370. IsUseIot = bool.Parse(IniFile.INIGetStringValue(FilePath, "MQTT", "IsUseIot", "false"));
  371. MQTTServerHost = IniFile.INIGetStringValue(FilePath, "MQTT", "MQTTServerHost", "127.0.0.1");
  372. MQTTServerPort = int.Parse(IniFile.INIGetStringValue(FilePath, "MQTT", "MQTTServerPort", "80"));
  373. IsMqttSendProcessData = bool.Parse(IniFile.INIGetStringValue(FilePath, "MQTT", "IsMqttSendProcessData", ConstIsSend));
  374. IsMqttDeviceState = bool.Parse(IniFile.INIGetStringValue(FilePath, "MQTT", "IsMqttDeviceState", ConstIsSend));
  375. IsMqttFaultLog = bool.Parse(IniFile.INIGetStringValue(FilePath, "MQTT", "IsMqttFaultLog", ConstIsSend));
  376. IsMqttSensorData = bool.Parse(IniFile.INIGetStringValue(FilePath, "MQTT", "IsMqttSensorData", ConstIsSend));
  377. IsMqttStationInputBegin = bool.Parse(IniFile.INIGetStringValue(FilePath, "MQTT", "IsMqttStationInputBegin", ConstIsSend));
  378. IsMqttOperateLog = bool.Parse(IniFile.INIGetStringValue(FilePath, "MQTT", "IsMqttOperateLog", ConstIsSend));
  379. IsMqttEquiConfig = bool.Parse(IniFile.INIGetStringValue(FilePath, "MQTT", "IsMqttEquiConfig", ConstIsSend));
  380. IsMqttProcConfig = bool.Parse(IniFile.INIGetStringValue(FilePath, "MQTT", "IsMqttProcConfig", ConstIsSend));
  381. MQTTAppId = IniFile.INIGetStringValue(FilePath, "MQTT", "MQTTAppId", "AKPKTSQAS46NKE4NHY");
  382. MQTTAppPwd = IniFile.INIGetStringValue(FilePath, "MQTT", "MQTTAppPwd", "pwd");
  383. // AGV配置
  384. IsUseAGV = bool.Parse(IniFile.INIGetStringValue(FilePath, "AGV", "IsUseAGV", "false")); // 是否 启用AGV
  385. AGVHttpHost = IniFile.INIGetStringValue(FilePath, "AGV", "AGVHttpHost", "127.0.0.1:80"); // Http IP地址
  386. string[] AGVHttps = AGVHttpHost.Split(':');
  387. AGVHttpIp = AGVHttps[0];
  388. AGVMQTTHost = IniFile.INIGetStringValue(FilePath, "AGV", "AGVMQTTHost", "127.0.0.1"); // MQTT IP地址
  389. AGVMQTTPort = int.Parse(IniFile.INIGetStringValue(FilePath, "AGV", "AGVMQTTPort", "80")); // MQTT端口
  390. AGVMQTTDeviceCode = IniFile.INIGetStringValue(FilePath, "AGV", "AGVMQTTDeviceCode", ""); // portCode
  391. // 入出站参数
  392. S1_MachineId = IniFile.INIGetStringValue(FilePath, "StationOut", "S1_MachineId", "MId");
  393. S1_StationId = IniFile.INIGetStringValue(FilePath, "StationOut", "S1_StationId", "SId");
  394. S2_MachineId = IniFile.INIGetStringValue(FilePath, "StationOut", "S2_MachineId", "MId");
  395. S2_StationId = IniFile.INIGetStringValue(FilePath, "StationOut", "S2_StationId", "SId");
  396. S3_MachineId = IniFile.INIGetStringValue(FilePath, "StationOut", "S3_MachineId", "MId");
  397. S3_StationId = IniFile.INIGetStringValue(FilePath, "StationOut", "S3_StationId", "SId");
  398. S3_StationId_1 = IniFile.INIGetStringValue(FilePath, "StationOut", "S3_StationId_1", "SId");
  399. S3_StationId_2 = IniFile.INIGetStringValue(FilePath, "StationOut", "S3_StationId_2", "SId");
  400. S4_MachineId = IniFile.INIGetStringValue(FilePath, "StationOut", "S4_MachineId", "MId");
  401. S4_StationId = IniFile.INIGetStringValue(FilePath, "StationOut", "S4_StationId", "SId");
  402. S5_MachineId = IniFile.INIGetStringValue(FilePath, "StationOut", "S5_MachineId", "MId");
  403. S5_StationId = IniFile.INIGetStringValue(FilePath, "StationOut", "S5_StationId", "SId");
  404. S6_MachineId = IniFile.INIGetStringValue(FilePath, "StationOut", "S6_MachineId", "MId");
  405. S6_StationId = IniFile.INIGetStringValue(FilePath, "StationOut", "S6_StationId", "SId");
  406. S7_MachineId = IniFile.INIGetStringValue(FilePath, "StationOut", "S7_MachineId", "MId");
  407. S7_StationId = IniFile.INIGetStringValue(FilePath, "StationOut", "S7_StationId", "SId");
  408. S7_StationId_1 = IniFile.INIGetStringValue(FilePath, "StationOut", "S7_StationId_1", "SId");
  409. S7_StationId_2 = IniFile.INIGetStringValue(FilePath, "StationOut", "S7_StationId_2", "SId");
  410. S8_MachineId = IniFile.INIGetStringValue(FilePath, "StationOut", "S8_MachineId", "MId");
  411. S8_StationId = IniFile.INIGetStringValue(FilePath, "StationOut", "S8_StationId", "SId");
  412. S9_MachineId = IniFile.INIGetStringValue(FilePath, "StationOut", "S9_MachineId", "MId");
  413. S9_StationId = IniFile.INIGetStringValue(FilePath, "StationOut", "S9_StationId", "SId");
  414. // 本地数据库
  415. Server = IniFile.INIGetStringValue(FilePath, "LocalDB", "Server", @"localhost");
  416. User = IniFile.INIGetStringValue(FilePath, "LocalDB", "User", "sa");
  417. PassWord = IniFile.INIGetStringValue(FilePath, "LocalDB", "PassWord", "Aa123456");
  418. MacStr = IPHelper.GetMoAddress();
  419. // 同步一次数据库当前订单信息到配置文件-后加的(加完后,设置页修改订单信息的功能不可用)
  420. //SyncCurOrderInfo();
  421. Set?.Invoke();
  422. }
  423. catch (Exception ex) { }
  424. }
  425. /// <summary>
  426. /// 同步数据量存储的当前订单信息到配置文件中
  427. /// </summary>
  428. public static void SyncCurOrderInfo()
  429. {
  430. #region 校验配置文件是否和数据库实际订单一致,如果配置文件的订单和数据库不一致,以数据库优先
  431. string sql = @" SELECT TOP 1
  432. WorkOrderNum,
  433. BatchNumber,
  434. ProductMtltmrk,
  435. SupplierCode
  436. FROM OrderTable
  437. WHERE WorkOrderStatus = '正在处理订单'
  438. ORDER BY
  439. CreatedTime DESC ";
  440. SqlHelper _sqlHelper = new SqlHelper();
  441. DataTable dt_data = _sqlHelper.Db.SqlQueryable<OrderTable>(sql).ToDataTable(); // 查询订单数据
  442. if (dt_data != null && dt_data.Rows.Count > 0)
  443. {
  444. string _workOrderNum = dt_data.Rows[0][1].ToString().Trim();
  445. if (WorkOrderCode != _workOrderNum)
  446. {
  447. IniFile.INIWriteValue(FilePath, "Product", "WorkOrderCode", dt_data.Rows[0][0].ToString().Trim());
  448. IniFile.INIWriteValue(FilePath, "Product", "BatchNumber", dt_data.Rows[0][1].ToString().Trim());
  449. IniFile.INIWriteValue(FilePath, "Product", "Mtltmrk", dt_data.Rows[0][2].ToString().Trim());
  450. }
  451. else
  452. {
  453. IniFile.INIWriteValue(FilePath, "Product", "WorkOrderCode", string.Empty);
  454. IniFile.INIWriteValue(FilePath, "Product", "BatchNumber", string.Empty);
  455. IniFile.INIWriteValue(FilePath, "Product", "Mtltmrk", string.Empty);
  456. }
  457. }
  458. else
  459. {
  460. IniFile.INIWriteValue(FilePath, "Product", "WorkOrderCode", string.Empty);
  461. IniFile.INIWriteValue(FilePath, "Product", "BatchNumber", string.Empty);
  462. IniFile.INIWriteValue(FilePath, "Product", "Mtltmrk", string.Empty);
  463. }
  464. #endregion
  465. }
  466. }
  467. }