GlobalContext.cs 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498
  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. // IOT - MQTT
  143. public static bool IsUseIot; // 是否 启用IOT
  144. public static string MQTTServerHost; // 服务器IP
  145. public static int MQTTServerPort; // 服务器Port
  146. public static bool IsMqttSendProcessData; // 上传过站数据
  147. public static bool IsMqttDeviceState; // 上传设备状态
  148. public static bool IsMqttFaultLog; // 上传故障⽇志
  149. public static bool IsMqttSensorData; // 上传传感器数据
  150. public static bool IsMqttStationInputBegin; // 上传节拍⽇志
  151. public static bool IsMqttOperateLog; // 上传操作记录
  152. public static bool IsMqttEquiConfig; // 上传装备配置
  153. public static bool IsMqttProcConfig; // 上传⼯艺配置
  154. public static string MQTTAppId; // IOT应用ID
  155. public static string MQTTAppPwd; // IOT登录密码
  156. // IOT-AGV
  157. public static bool IsUseAGV; // 是否 启用AGV
  158. public static string AGVHttpHost; // Http 服务器地址
  159. public static string AGVHttpIp; // Http IP地址
  160. public static string AGVMQTTHost; // MQTT IP地址
  161. public static int AGVMQTTPort; // MQTT端口
  162. public static string AGVMQTTDeviceCode; // MQTT设备Code
  163. public static bool AGVMQTTIsConnect; // AGV MQTT是否正常连接
  164. // MES进出站 配置信息
  165. public static string S1_MachineId; // 工站1 - 壳体清洁上料装备
  166. public static string S1_StationId; // 工站1 - 壳体清洁上料装备
  167. public static string S2_MachineId; // 工站2 - 上盖板上料装备
  168. public static string S2_StationId; // 工站2 - 上盖板上料装备
  169. public static string S3_MachineId; // 工站3 - 点散热胶装备
  170. public static string S3_StationId; // 工站3 - 点散热胶装备
  171. public static string S3_StationId_1; // 工站3 - 点散热胶装备
  172. public static string S3_StationId_2; // 工站3 - 点散热胶装备
  173. public static string S4_MachineId; // 工站4 - 胶线检测装备
  174. public static string S4_StationId; // 工站4 - 胶线检测装备
  175. public static string S5_MachineId; // 工站5 - ADD板上料组装装备
  176. public static string S5_StationId; // 工站5 - ADD板上料组装装备
  177. public static string S6_MachineId; // 工站6 - 组上盖板装备
  178. public static string S6_StationId; // 工站6 - 组上盖板装备
  179. public static string S7_MachineId; // 工站7 - 上盖板锁螺丝装备
  180. public static string S7_StationId; // 工站7 - 上盖板锁螺丝装备
  181. public static string S7_StationId_1; // 工站7 - 上盖板锁螺丝装备
  182. public static string S7_StationId_2; // 工站7 - 上盖板锁螺丝装备
  183. public static string S8_MachineId; // 工站8 - NG下料装备
  184. public static string S8_StationId; // 工站8 - NG下料装备
  185. public static string S9_MachineId; // 工站9 - 产品下料装备
  186. public static string S9_StationId; // 工站9 - 产品下料装备
  187. // 本地数据库
  188. public static string Server;
  189. public static string User;
  190. public static string PassWord;
  191. //其它
  192. public static string CurrentUser = "";
  193. public static string MacStr = "";
  194. #region 是否可连接PLC-用户手动控制用(后加)
  195. public static bool _IsCon_Funs1 = true;
  196. public static bool _IsCon_Funs2 = true;
  197. public static bool _IsCon_Funs3 = true;
  198. public static bool _IsCon_Funs4 = true;
  199. public static bool _IsCon_Funs5 = true;
  200. public static bool _IsCon_plc1Heat = true;
  201. public static bool _IsCon_plc1Alarm = true;
  202. #endregion 是否可连接PLC-用户手动控制用(后加)
  203. #endregion 变量
  204. #region 常量
  205. //产品常量
  206. public const string ConstLineCode = "A1";
  207. public const string ConstLineName = "A1产线";
  208. public const string ConstProgramName = "A1程序名";
  209. public const string ConstSono = " ";
  210. public const string ConstWorkOrderCode = " ";
  211. public const string ConstBatchNumber = " ";
  212. public const string ConstMtltmrk = " ";
  213. public const string ConstSupplierCode = " ";
  214. //设备常量
  215. public const string ConstMachine1Address = "192.168.10.87";
  216. public const string ConstMachine2Address = "192.168.2.1";
  217. public const string ConstMachine3Address = "192.168.4.111";
  218. public const string ConstMachine4Address = "192.168.4.1";
  219. public const string ConstMachine5Address = "192.168.6.111";
  220. public const string ConstMachine6Address = "192.168.6.1";
  221. public const string ConstMachine7Address = "192.168.6.71";
  222. public const string ConstMachine8Address = "192.168.6.81";
  223. public const string ConstMachine9Address = "192.168.1.91";
  224. public const string ConstPc1Address = "192.168.1.10";
  225. public const string ConstPc2Address = "192.168.1.10";
  226. public const string ConstPc3Address = "192.168.1.10";
  227. public const string ConstPc4Address = "192.168.1.10";
  228. public const string ConstPc5Address = "192.168.1.10";
  229. public const string ConstPc6Address = "192.168.1.10";
  230. public const string ConstPc7Address = "192.168.1.10";
  231. public const string ConstPc8Address = "192.168.1.10";
  232. public const string ConstPc9Address = "192.168.1.10";
  233. public const string ConstMachinePort = "1217";
  234. //MES常量
  235. public const string ConstServerHost = "10.1.19.33:8080";
  236. public const string ConstIsSend = "false";
  237. #endregion 常量
  238. public GlobalContext()
  239. {
  240. UpdateData();
  241. }
  242. /// <summary>
  243. /// 更新全局变量
  244. /// </summary>
  245. public static void UpdateData()
  246. {
  247. try
  248. {
  249. // 产线及产品信息
  250. Project_Code = IniFile.INIGetStringValue(FilePath, "Product", "ProjectCode", "");
  251. Factory_Code = IniFile.INIGetStringValue(FilePath, "Product", "FactoryCode", "");
  252. Process_Section_Code = IniFile.INIGetStringValue(FilePath, "Product", "ProcessSectionCode", "");
  253. LineCode = IniFile.INIGetStringValue(FilePath, "Product", "LineCode", ConstLineCode);
  254. LineName = IniFile.INIGetStringValue(FilePath, "Product", "LineName", ConstLineName);
  255. ProgramName = IniFile.INIGetStringValue(FilePath, "Product", "ProgramName", ConstProgramName);
  256. WorkOrderCode = IniFile.INIGetStringValue(FilePath, "Product", "WorkOrderCode", ConstWorkOrderCode); // 车间订单号
  257. BatchNumber = IniFile.INIGetStringValue(FilePath, "Product", "BatchNumber", ConstBatchNumber); // 批次号(splcode)
  258. Mtltmrk = IniFile.INIGetStringValue(FilePath, "Product", "Mtltmrk", ConstMtltmrk); // 产品型号(mtltmrk)
  259. // 工位信息
  260. S1_work_station = IniFile.INIGetStringValue(FilePath, "Station", "s1_work_station", ""); // [S1] ⼯站
  261. S1_device_code = IniFile.INIGetStringValue(FilePath, "Station", "s1_device_code", ""); // [S1] 装备编码
  262. S1_station = IniFile.INIGetStringValue(FilePath, "Station", "s1_station", ""); // [S1] ⼯位Id
  263. S2_work_station = IniFile.INIGetStringValue(FilePath, "Station", "s2_work_station", ""); // [S2] ⼯站
  264. S2_device_code = IniFile.INIGetStringValue(FilePath, "Station", "s2_device_code", ""); // [S2] 装备编码
  265. S2_station = IniFile.INIGetStringValue(FilePath, "Station", "s2_station", ""); // [S2] ⼯位Id
  266. S3_work_station = IniFile.INIGetStringValue(FilePath, "Station", "s3_work_station", ""); // [S3] ⼯站
  267. S3_device_code = IniFile.INIGetStringValue(FilePath, "Station", "s3_device_code", ""); // [S3] 装备编码
  268. S3_station = IniFile.INIGetStringValue(FilePath, "Station", "s3_station", ""); // [S3] ⼯位Id
  269. S4_1_work_station = IniFile.INIGetStringValue(FilePath, "Station", "s4_1_work_station", ""); // [S4_1] ⼯站
  270. S4_1_device_code = IniFile.INIGetStringValue(FilePath, "Station", "s4_1_device_code", ""); // [S4_1] 装备编码
  271. S4_1_station = IniFile.INIGetStringValue(FilePath, "Station", "s4_1_station", ""); // [S4_1] ⼯位Id
  272. S4_3_work_station = IniFile.INIGetStringValue(FilePath, "Station", "s4_3_work_station", ""); // [S4_3] ⼯站
  273. S4_3_device_code = IniFile.INIGetStringValue(FilePath, "Station", "s4_3_device_code", ""); // [S4_3] 装备编码
  274. S4_3_station = IniFile.INIGetStringValue(FilePath, "Station", "s4_3_station", ""); // [S4_3] ⼯位Id
  275. S4_4_work_station = IniFile.INIGetStringValue(FilePath, "Station", "s4_4_work_station", ""); // [S4_4] ⼯站
  276. S4_4_device_code = IniFile.INIGetStringValue(FilePath, "Station", "s4_4_device_code", ""); // [S4_4] 装备编码
  277. S4_4_station = IniFile.INIGetStringValue(FilePath, "Station", "s4_4_station", ""); // [S4_4] ⼯位Id
  278. S4_5_work_station = IniFile.INIGetStringValue(FilePath, "Station", "s4_5_work_station", ""); // [S4_5] ⼯站
  279. S4_5_device_code = IniFile.INIGetStringValue(FilePath, "Station", "s4_5_device_code", ""); // [S4_5] 装备编码
  280. S4_5_station = IniFile.INIGetStringValue(FilePath, "Station", "s4_5_station", ""); // [S4_5] ⼯位Id
  281. S5_work_station = IniFile.INIGetStringValue(FilePath, "Station", "s5_work_station", ""); // [S5] ⼯站
  282. S5_device_code = IniFile.INIGetStringValue(FilePath, "Station", "s5_device_code", ""); // [S5] 装备编码
  283. S5_station = IniFile.INIGetStringValue(FilePath, "Station", "s5_station", ""); // [S5] ⼯位Id
  284. // 设备
  285. IsUsePLC1 = bool.Parse(IniFile.INIGetStringValue(FilePath, "Machine", "IsUsePLC1", "false"));
  286. IsUsePLC2 = bool.Parse(IniFile.INIGetStringValue(FilePath, "Machine", "IsUsePLC2", "false"));
  287. IsUsePLC3 = bool.Parse(IniFile.INIGetStringValue(FilePath, "Machine", "IsUsePLC3", "false"));
  288. IsUsePLC4 = bool.Parse(IniFile.INIGetStringValue(FilePath, "Machine", "IsUsePLC4", "false"));
  289. IsUsePLC5 = bool.Parse(IniFile.INIGetStringValue(FilePath, "Machine", "IsUsePLC5", "false"));
  290. IsUsePLC6 = bool.Parse(IniFile.INIGetStringValue(FilePath, "Machine", "IsUsePLC6", "false"));
  291. IsUsePLC7 = bool.Parse(IniFile.INIGetStringValue(FilePath, "Machine", "IsUsePLC7", "false"));
  292. IsUsePLC8 = bool.Parse(IniFile.INIGetStringValue(FilePath, "Machine", "IsUsePLC8", "false"));
  293. IsUsePLC9 = bool.Parse(IniFile.INIGetStringValue(FilePath, "Machine", "IsUsePLC9", "false"));
  294. Machine1Address = IniFile.INIGetStringValue(FilePath, "Machine", "Machine1Address", ConstMachine1Address);
  295. Machine2Address = IniFile.INIGetStringValue(FilePath, "Machine", "Machine2Address", ConstMachine2Address);
  296. Machine3Address = IniFile.INIGetStringValue(FilePath, "Machine", "Machine3Address", ConstMachine3Address);
  297. Machine4Address = IniFile.INIGetStringValue(FilePath, "Machine", "Machine4Address", ConstMachine4Address);
  298. Machine5Address = IniFile.INIGetStringValue(FilePath, "Machine", "Machine5Address", ConstMachine5Address);
  299. Machine6Address = IniFile.INIGetStringValue(FilePath, "Machine", "Machine6Address", ConstMachine6Address);
  300. Machine7Address = IniFile.INIGetStringValue(FilePath, "Machine", "Machine7Address", ConstMachine7Address);
  301. Machine8Address = IniFile.INIGetStringValue(FilePath, "Machine", "Machine8Address", ConstMachine8Address);
  302. Machine9Address = IniFile.INIGetStringValue(FilePath, "Machine", "Machine9Address", ConstMachine9Address);
  303. PC1Address = IniFile.INIGetStringValue(FilePath, "Machine", "Pc1Address", ConstPc1Address);
  304. PC2Address = IniFile.INIGetStringValue(FilePath, "Machine", "Pc2Address", ConstPc2Address);
  305. PC3Address = IniFile.INIGetStringValue(FilePath, "Machine", "Pc3Address", ConstPc3Address);
  306. PC4Address = IniFile.INIGetStringValue(FilePath, "Machine", "Pc4Address", ConstPc4Address);
  307. PC5Address = IniFile.INIGetStringValue(FilePath, "Machine", "Pc5Address", ConstPc5Address);
  308. PC6Address = IniFile.INIGetStringValue(FilePath, "Machine", "Pc6Address", ConstPc6Address);
  309. PC7Address = IniFile.INIGetStringValue(FilePath, "Machine", "Pc7Address", ConstPc7Address);
  310. PC8Address = IniFile.INIGetStringValue(FilePath, "Machine", "Pc8Address", ConstPc8Address);
  311. PC9Address = IniFile.INIGetStringValue(FilePath, "Machine", "Pc9Address", ConstPc9Address);
  312. MachinePort = int.Parse(IniFile.INIGetStringValue(FilePath, "Machine", "MachinePort", ConstMachinePort));
  313. AtlasAddressLeft = IniFile.INIGetStringValue(FilePath, "Machine", "AtlasAddressLeft", "");
  314. AtlasAddressRight = IniFile.INIGetStringValue(FilePath, "Machine", "AtlasAddressRight", "");
  315. AtlasAddressPort = int.Parse(IniFile.INIGetStringValue(FilePath, "Machine", "AtlasAddressPort", ""));
  316. QrCodeTCPAddress1 = IniFile.INIGetStringValue(FilePath, "TCP", "TCPAddress1", "127.0.0.1");
  317. QrCodeTCPPort1 = int.Parse(IniFile.INIGetStringValue(FilePath, "TCP", "TCPPort1", "0"));
  318. QrCodeTCPAddress2 = IniFile.INIGetStringValue(FilePath, "TCP", "TCPAddress2", "127.0.0.1");
  319. QrCodeTCPPort2 = int.Parse(IniFile.INIGetStringValue(FilePath, "TCP", "TCPPort2", "0"));
  320. QrCodeTCPAddress3 = IniFile.INIGetStringValue(FilePath, "TCP", "TCPAddress3", "127.0.0.1");
  321. QrCodeTCPPort3 = int.Parse(IniFile.INIGetStringValue(FilePath, "TCP", "TCPPort3", "0"));
  322. QrCodeTCPAddress4 = IniFile.INIGetStringValue(FilePath, "TCP", "TCPAddress4", "127.0.0.1");
  323. QrCodeTCPPort4 = int.Parse(IniFile.INIGetStringValue(FilePath, "TCP", "TCPPort4", "0"));
  324. QrCodeTCPAddress5 = IniFile.INIGetStringValue(FilePath, "TCP", "TCPAddress5", "127.0.0.1");
  325. QrCodeTCPPort5 = int.Parse(IniFile.INIGetStringValue(FilePath, "TCP", "TCPPort5", "0"));
  326. // MES
  327. MESAppId = IniFile.INIGetStringValue(FilePath, "MES", "MESAppId", "mes_test");
  328. MESAppKey = IniFile.INIGetStringValue(FilePath, "MES", "MESAppKey", "mes");
  329. MESUserId = IniFile.INIGetStringValue(FilePath, "MES", "MESUserId", "mes_userid");
  330. ServerHost = IniFile.INIGetStringValue(FilePath, "MES", "ServerHost", ConstServerHost);
  331. StationInMESUrl = IniFile.INIGetStringValue(FilePath, "MES", "StationInMESUrl", "");
  332. StationInMESUrl = string.Format(StationInMESUrl, ServerHost);
  333. StationOutMESUrl = IniFile.INIGetStringValue(FilePath, "MES", "StationOutMESUrl", "");
  334. StationOutMESUrl = string.Format(StationOutMESUrl, ServerHost);
  335. if (ServerHost.Contains(":"))
  336. {
  337. string[] mesServers = ServerHost.Split(':');
  338. ServerIp = mesServers[0];
  339. ServerIp = ServerHost.Replace("\\", "/");
  340. mesServers = ServerHost.Split('/');
  341. if (mesServers.Length > 3)
  342. ServerIp = mesServers[2];
  343. }
  344. else
  345. {
  346. ServerHost = ServerHost.Replace("\\", "/");
  347. string[] mesServers = ServerHost.Split('/');
  348. if (mesServers.Length > 3)
  349. ServerIp = mesServers[2];
  350. }
  351. //StationInMESUrl = IniFile.INIGetStringValue(MESConfig, "MES", "StationInMESUrl", "");
  352. //StationInMESUrl = string.Format(StationInMESUrl, ServerHost);
  353. //StationOutMESUrl = IniFile.INIGetStringValue(MESConfig, "MES", "StationOutMESUrl", "");
  354. //StationOutMESUrl = string.Format(StationOutMESUrl, ServerHost);
  355. IsUseMES = bool.Parse(IniFile.INIGetStringValue(FilePath, "MES", "IsUseMES", ConstIsSend));
  356. IsSendStationIn = bool.Parse(IniFile.INIGetStringValue(FilePath, "MES", "IsSendStationIn", ConstIsSend));
  357. IsSendProcessData = bool.Parse(IniFile.INIGetStringValue(FilePath, "MES", "IsSendProcessData", ConstIsSend));
  358. IsSendCheckOneData = bool.Parse(IniFile.INIGetStringValue(FilePath, "MES", "IsSendCheckOneData", ConstIsSend));
  359. IsSendWorkingData = bool.Parse(IniFile.INIGetStringValue(FilePath, "MES", "IsSendWorkingData", ConstIsSend));
  360. IsSendAlarmData = bool.Parse(IniFile.INIGetStringValue(FilePath, "MES", "IsSendAlarmData", ConstIsSend));
  361. IsUseMESRoute = bool.Parse(IniFile.INIGetStringValue(FilePath, "MES", "IsUseMESRoute", ConstIsSend));
  362. // MQTT
  363. IsUseIot = bool.Parse(IniFile.INIGetStringValue(FilePath, "MQTT", "IsUseIot", "false"));
  364. MQTTServerHost = IniFile.INIGetStringValue(FilePath, "MQTT", "MQTTServerHost", "127.0.0.1");
  365. MQTTServerPort = int.Parse(IniFile.INIGetStringValue(FilePath, "MQTT", "MQTTServerPort", "80"));
  366. IsMqttSendProcessData = bool.Parse(IniFile.INIGetStringValue(FilePath, "MQTT", "IsMqttSendProcessData", ConstIsSend));
  367. IsMqttDeviceState = bool.Parse(IniFile.INIGetStringValue(FilePath, "MQTT", "IsMqttDeviceState", ConstIsSend));
  368. IsMqttFaultLog = bool.Parse(IniFile.INIGetStringValue(FilePath, "MQTT", "IsMqttFaultLog", ConstIsSend));
  369. IsMqttSensorData = bool.Parse(IniFile.INIGetStringValue(FilePath, "MQTT", "IsMqttSensorData", ConstIsSend));
  370. IsMqttStationInputBegin = bool.Parse(IniFile.INIGetStringValue(FilePath, "MQTT", "IsMqttStationInputBegin", ConstIsSend));
  371. IsMqttOperateLog = bool.Parse(IniFile.INIGetStringValue(FilePath, "MQTT", "IsMqttOperateLog", ConstIsSend));
  372. IsMqttEquiConfig = bool.Parse(IniFile.INIGetStringValue(FilePath, "MQTT", "IsMqttEquiConfig", ConstIsSend));
  373. IsMqttProcConfig = bool.Parse(IniFile.INIGetStringValue(FilePath, "MQTT", "IsMqttProcConfig", ConstIsSend));
  374. MQTTAppId = IniFile.INIGetStringValue(FilePath, "MQTT", "MQTTAppId", "AKPKTSQAS46NKE4NHY");
  375. MQTTAppPwd = IniFile.INIGetStringValue(FilePath, "MQTT", "MQTTAppPwd", "pwd");
  376. // AGV配置
  377. IsUseAGV = bool.Parse(IniFile.INIGetStringValue(FilePath, "AGV", "IsUseAGV", "false")); // 是否 启用AGV
  378. AGVHttpHost = IniFile.INIGetStringValue(FilePath, "AGV", "AGVHttpHost", "127.0.0.1:80"); // Http IP地址
  379. string[] AGVHttps = AGVHttpHost.Split(':');
  380. AGVHttpIp = AGVHttps[0];
  381. AGVMQTTHost = IniFile.INIGetStringValue(FilePath, "AGV", "AGVMQTTHost", "127.0.0.1"); // MQTT IP地址
  382. AGVMQTTPort = int.Parse(IniFile.INIGetStringValue(FilePath, "AGV", "AGVMQTTPort", "80")); // MQTT端口
  383. AGVMQTTDeviceCode = IniFile.INIGetStringValue(FilePath, "AGV", "AGVMQTTDeviceCode", ""); // portCode
  384. // 入出站参数
  385. S1_MachineId = IniFile.INIGetStringValue(FilePath, "StationOut", "S1_MachineId", "MId");
  386. S1_StationId = IniFile.INIGetStringValue(FilePath, "StationOut", "S1_StationId", "SId");
  387. S2_MachineId = IniFile.INIGetStringValue(FilePath, "StationOut", "S2_MachineId", "MId");
  388. S2_StationId = IniFile.INIGetStringValue(FilePath, "StationOut", "S2_StationId", "SId");
  389. S3_MachineId = IniFile.INIGetStringValue(FilePath, "StationOut", "S3_MachineId", "MId");
  390. S3_StationId = IniFile.INIGetStringValue(FilePath, "StationOut", "S3_StationId", "SId");
  391. S3_StationId_1 = IniFile.INIGetStringValue(FilePath, "StationOut", "S3_StationId_1", "SId");
  392. S3_StationId_2 = IniFile.INIGetStringValue(FilePath, "StationOut", "S3_StationId_2", "SId");
  393. S4_MachineId = IniFile.INIGetStringValue(FilePath, "StationOut", "S4_MachineId", "MId");
  394. S4_StationId = IniFile.INIGetStringValue(FilePath, "StationOut", "S4_StationId", "SId");
  395. S5_MachineId = IniFile.INIGetStringValue(FilePath, "StationOut", "S5_MachineId", "MId");
  396. S5_StationId = IniFile.INIGetStringValue(FilePath, "StationOut", "S5_StationId", "SId");
  397. S6_MachineId = IniFile.INIGetStringValue(FilePath, "StationOut", "S6_MachineId", "MId");
  398. S6_StationId = IniFile.INIGetStringValue(FilePath, "StationOut", "S6_StationId", "SId");
  399. S7_MachineId = IniFile.INIGetStringValue(FilePath, "StationOut", "S7_MachineId", "MId");
  400. S7_StationId = IniFile.INIGetStringValue(FilePath, "StationOut", "S7_StationId", "SId");
  401. S7_StationId_1 = IniFile.INIGetStringValue(FilePath, "StationOut", "S7_StationId_1", "SId");
  402. S7_StationId_2 = IniFile.INIGetStringValue(FilePath, "StationOut", "S7_StationId_2", "SId");
  403. S8_MachineId = IniFile.INIGetStringValue(FilePath, "StationOut", "S8_MachineId", "MId");
  404. S8_StationId = IniFile.INIGetStringValue(FilePath, "StationOut", "S8_StationId", "SId");
  405. S9_MachineId = IniFile.INIGetStringValue(FilePath, "StationOut", "S9_MachineId", "MId");
  406. S9_StationId = IniFile.INIGetStringValue(FilePath, "StationOut", "S9_StationId", "SId");
  407. // 本地数据库
  408. Server = IniFile.INIGetStringValue(FilePath, "LocalDB", "Server", @"localhost");
  409. User = IniFile.INIGetStringValue(FilePath, "LocalDB", "User", "sa");
  410. PassWord = IniFile.INIGetStringValue(FilePath, "LocalDB", "PassWord", "Aa123456");
  411. MacStr = IPHelper.GetMoAddress();
  412. // 同步一次数据库当前订单信息到配置文件-后加的(加完后,设置页修改订单信息的功能不可用)
  413. //SyncCurOrderInfo();
  414. Set?.Invoke();
  415. }
  416. catch (Exception ex) { }
  417. }
  418. /// <summary>
  419. /// 同步数据量存储的当前订单信息到配置文件中
  420. /// </summary>
  421. public static void SyncCurOrderInfo()
  422. {
  423. #region 校验配置文件是否和数据库实际订单一致,如果配置文件的订单和数据库不一致,以数据库优先
  424. string sql = @" SELECT TOP 1
  425. WorkOrderNum,
  426. BatchNumber,
  427. ProductMtltmrk,
  428. SupplierCode
  429. FROM OrderTable
  430. WHERE WorkOrderStatus = '正在处理订单'
  431. ORDER BY
  432. CreatedTime DESC ";
  433. SqlHelper _sqlHelper = new SqlHelper();
  434. DataTable dt_data = _sqlHelper.Db.SqlQueryable<OrderTable>(sql).ToDataTable(); // 查询订单数据
  435. if (dt_data != null && dt_data.Rows.Count > 0)
  436. {
  437. string _workOrderNum = dt_data.Rows[0][1].ToString().Trim();
  438. if (WorkOrderCode != _workOrderNum)
  439. {
  440. IniFile.INIWriteValue(FilePath, "Product", "WorkOrderCode", dt_data.Rows[0][0].ToString().Trim());
  441. IniFile.INIWriteValue(FilePath, "Product", "BatchNumber", dt_data.Rows[0][1].ToString().Trim());
  442. IniFile.INIWriteValue(FilePath, "Product", "Mtltmrk", dt_data.Rows[0][2].ToString().Trim());
  443. }
  444. else
  445. {
  446. IniFile.INIWriteValue(FilePath, "Product", "WorkOrderCode", string.Empty);
  447. IniFile.INIWriteValue(FilePath, "Product", "BatchNumber", string.Empty);
  448. IniFile.INIWriteValue(FilePath, "Product", "Mtltmrk", string.Empty);
  449. }
  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. #endregion
  458. }
  459. }
  460. }