GlobalContext.cs 32 KB

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