HttpServer.cs 51 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Data;
  4. using System.Dynamic;
  5. using System.IO;
  6. using System.Net;
  7. using System.Net.Http;
  8. using System.Net.Sockets;
  9. using System.Security.Cryptography;
  10. using System.Text;
  11. using System.Text.RegularExpressions;
  12. using System.Windows.Forms;
  13. using Newtonsoft.Json;
  14. using Newtonsoft.Json.Linq;
  15. using UAS_MES_NEW.DataOperate;
  16. using UAS_MES_NEW.Entity;
  17. namespace UAS_MES_NEW.PublicMethod
  18. {
  19. public class BindItem
  20. {
  21. [JsonProperty("bindKey")]
  22. public string BindKey { get; set; }
  23. [JsonProperty("bindValue")]
  24. public string BindValue { get; set; }
  25. [JsonProperty("keyType")]
  26. public string KeyType { get; set; }
  27. [JsonProperty("keyValue")]
  28. public string KeyValue { get; set; }
  29. [JsonProperty("hashType")]
  30. public string HashType { get; set; }
  31. [JsonProperty("hashKey")]
  32. public string HashKey { get; set; }
  33. }
  34. public class BindItemYS
  35. {
  36. [JsonProperty("barcd")]
  37. public string barcd { get; set; }
  38. }
  39. public class RootObject
  40. {
  41. [JsonProperty("productModuleType")]
  42. public string ProductModuleType { get; set; }
  43. [JsonProperty("productMainClass")]
  44. public string ProductMainClass { get; set; }
  45. [JsonProperty("productMediumClass")]
  46. public string ProductMediumClass { get; set; }
  47. [JsonProperty("productSubClass")]
  48. public string ProductSubClass { get; set; }
  49. [JsonProperty("task")]
  50. public string Task { get; set; }
  51. [JsonProperty("processType")]
  52. public string ProcessType { get; set; }
  53. [JsonProperty("userId")]
  54. public string UserId { get; set; }
  55. [JsonProperty("bindList")]
  56. public List<BindItem> BindList { get; set; }
  57. }
  58. public class RootObjectYS
  59. {
  60. [JsonProperty("nub")]
  61. public string nub { get; set; }
  62. [JsonProperty("login_key")]
  63. public string login_key { get; set; }
  64. [JsonProperty("ebeln")]
  65. public string ebeln { get; set; }
  66. [JsonProperty("ebelp")]
  67. public string ebelp { get; set; }
  68. [JsonProperty("pkcde")]
  69. public string pkcde { get; set; }
  70. [JsonProperty("brgew")]
  71. public double brgew { get; set; }
  72. [JsonProperty("mak01")]
  73. public string mak01 { get; set; }
  74. [JsonProperty("bindList")]
  75. public List<BindItemYS> BindList { get; set; }
  76. }
  77. public class DeviceInfo
  78. {
  79. [JsonProperty("tool_name")]
  80. public string ToolName { get; set; }
  81. [JsonProperty("response")]
  82. public string Response { get; set; }
  83. [JsonProperty("status")]
  84. public int Status { get; set; }
  85. [JsonProperty("product_name")]
  86. public string ProductName { get; set; }
  87. [JsonProperty("product_mode")]
  88. public string ProductMode { get; set; }
  89. [JsonProperty("material_code")]
  90. public string MaterialCode { get; set; }
  91. [JsonProperty("batch_no")]
  92. public string BatchNo { get; set; }
  93. [JsonProperty("production_date")]
  94. public string ProductionDate { get; set; }
  95. [JsonProperty("big_box_no")]
  96. public string BigBoxNo { get; set; }
  97. [JsonProperty("box_no")]
  98. public string BoxNo { get; set; }
  99. [JsonProperty("reserve10")]
  100. public string Reserve10 { get; set; }
  101. [JsonProperty("packing_num")]
  102. public int PackingNum { get; set; }
  103. [JsonProperty("soft_version")]
  104. public string SoftVersion { get; set; }
  105. [JsonProperty("hd_version")]
  106. public string HdVersion { get; set; }
  107. [JsonProperty("voltage")]
  108. public string Voltage { get; set; }
  109. [JsonProperty("power")]
  110. public string Power { get; set; }
  111. [JsonProperty("order_no")]
  112. public string OrderNo { get; set; }
  113. // 使用字典或列表来存储序列化的数组数据
  114. public List<string> DSN { get; set; } = new List<string>();
  115. public List<string> MacStart { get; set; } = new List<string>();
  116. public List<string> MacEnd { get; set; } = new List<string>();
  117. public List<string> DeviceId { get; set; } = new List<string>();
  118. public List<string> DevEnNo { get; set; } = new List<string>();
  119. public List<string> Reserve3 { get; set; } = new List<string>();
  120. public List<string> Reserve4 { get; set; } = new List<string>();
  121. }
  122. public class Thailand
  123. {
  124. [JsonProperty("tool_name")]
  125. public string ToolName { get; set; }
  126. [JsonProperty("response")]
  127. public string Response { get; set; }
  128. [JsonProperty("status")]
  129. public int Status { get; set; }
  130. [JsonProperty("product_name")]
  131. public string ProductName { get; set; }
  132. [JsonProperty("product_mode")]
  133. public string ProductMode { get; set; }
  134. [JsonProperty("big_box_no")]
  135. public string BigBoxNo { get; set; }
  136. [JsonProperty("packing_num")]
  137. public int PackingNum { get; set; }
  138. [JsonProperty("order_num")]
  139. public string OrderNum { get; set; }
  140. // 使用字典或列表来存储序列化的数组数据
  141. public List<string> sn { get; set; } = new List<string>();
  142. public List<string> product_id { get; set; } = new List<string>();
  143. public List<string> en { get; set; } = new List<string>();
  144. }
  145. public class DeviceInfoConverter : JsonConverter<DeviceInfo>
  146. {
  147. public override DeviceInfo ReadJson(JsonReader reader, System.Type objectType, DeviceInfo existingValue, bool hasExistingValue, JsonSerializer serializer)
  148. {
  149. JObject jsonObject = JObject.Load(reader);
  150. DeviceInfo deviceInfo = new DeviceInfo();
  151. // 解析基本字段
  152. serializer.Populate(jsonObject.CreateReader(), deviceInfo);
  153. // 解析数组字段
  154. ParseArrayFields(jsonObject, deviceInfo);
  155. return deviceInfo;
  156. }
  157. public override void WriteJson(JsonWriter writer, DeviceInfo value, JsonSerializer serializer)
  158. {
  159. throw new NotImplementedException();
  160. }
  161. private void ParseArrayFields(JObject jsonObject, DeviceInfo deviceInfo)
  162. {
  163. int index = 0;
  164. // 解析 d_sn 数组
  165. while (true)
  166. {
  167. string key = $"d_sn{index}";
  168. if (jsonObject.TryGetValue(key, out JToken value))
  169. {
  170. deviceInfo.DSN.Add(value.ToString());
  171. index++;
  172. }
  173. else
  174. {
  175. break;
  176. }
  177. }
  178. // 解析 mac_start 数组
  179. index = 0;
  180. while (true)
  181. {
  182. string key = $"mac_start{index}";
  183. if (jsonObject.TryGetValue(key, out JToken value))
  184. {
  185. deviceInfo.MacStart.Add(value.ToString());
  186. index++;
  187. }
  188. else
  189. {
  190. break;
  191. }
  192. }
  193. // 解析 mac_end 数组
  194. index = 0;
  195. while (true)
  196. {
  197. string key = $"mac_end{index}";
  198. if (jsonObject.TryGetValue(key, out JToken value))
  199. {
  200. deviceInfo.MacEnd.Add(value.ToString());
  201. index++;
  202. }
  203. else
  204. {
  205. break;
  206. }
  207. }
  208. // 解析 dev_en_no 数组
  209. index = 0;
  210. while (true)
  211. {
  212. string key = $"dev_en_no{index}";
  213. if (jsonObject.TryGetValue(key, out JToken value))
  214. {
  215. deviceInfo.DevEnNo.Add(value.ToString());
  216. index++;
  217. }
  218. else
  219. {
  220. break;
  221. }
  222. }
  223. // 解析 reserve3 数组
  224. index = 0;
  225. while (true)
  226. {
  227. string key = $"reserve3_{index}";
  228. if (jsonObject.TryGetValue(key, out JToken value))
  229. {
  230. deviceInfo.Reserve3.Add(value.ToString());
  231. index++;
  232. }
  233. else
  234. {
  235. break;
  236. }
  237. }
  238. // 解析 reserve4 数组
  239. index = 0;
  240. while (true)
  241. {
  242. string key = $"reserve4_{index}";
  243. if (jsonObject.TryGetValue(key, out JToken value))
  244. {
  245. deviceInfo.Reserve4.Add(value.ToString());
  246. index++;
  247. }
  248. else
  249. {
  250. break;
  251. }
  252. }
  253. // 解析 DeviceId 数组
  254. index = 0;
  255. while (true)
  256. {
  257. string key = $"DeviceId{index}";
  258. if (jsonObject.TryGetValue(key, out JToken value))
  259. {
  260. deviceInfo.DeviceId.Add(value.ToString());
  261. index++;
  262. }
  263. else
  264. {
  265. break;
  266. }
  267. }
  268. }
  269. }
  270. public class HttpServer
  271. {
  272. static DataHelper dh = new DataHelper();
  273. public static int SN_SERVICE_PORT = 21610;
  274. public static int MAX_BUF_SIZE = 8192;
  275. static string ComputeSha256Hash(string input)
  276. {
  277. using (SHA256 sha256 = SHA256.Create())
  278. {
  279. byte[] bytes = Encoding.UTF8.GetBytes(input);
  280. byte[] hashBytes = sha256.ComputeHash(bytes);
  281. StringBuilder builder = new StringBuilder();
  282. for (int i = 0; i < hashBytes.Length; i++)
  283. {
  284. builder.Append(hashBytes[i].ToString("x2"));
  285. }
  286. return builder.ToString().ToUpper();
  287. }
  288. }
  289. //获取SN的EN号,彩盒标机身标一个工站一起打印,需要SN单个获取
  290. public static string GetEN(string iSN)
  291. {
  292. DataTable dt = (DataTable)dh.ExecuteSql("select nvl(noType,0)noType,nvl(packing_num,0)packing_num,PO_SN,ms_id,pr_outboxinnerqty,ma_custpo,ms_makecode,pr_prefix,PREFIX_EN_NO,PREFIX_BIG_BOX,pr_prebigxbox,pr_regcode from makeserial left join product on ms_prodcode=pr_code left join make on ma_code=ms_makecode left join ZTE_ORDER on ma_custpo=BATCH_NO where (ms_sncode ='" + iSN + "' or ms_firstsn='" + iSN + "') and RESERVE9='" + User.UserLineCode + "' order by ms_id desc", "select");
  293. string prefix = "";
  294. string regcode = "";
  295. string makecode = "";
  296. string prebigxbox = "";
  297. int packing_num = 0;
  298. string po = "";
  299. int noType = 0;
  300. string ms_id = "";
  301. if (dt.Rows.Count > 0)
  302. {
  303. prefix = dt.Rows[0]["PREFIX_EN_NO"].ToString();
  304. regcode = dt.Rows[0]["pr_regcode"].ToString();
  305. makecode = dt.Rows[0]["ms_makecode"].ToString();
  306. prebigxbox = dt.Rows[0]["PREFIX_BIG_BOX"].ToString();
  307. packing_num = int.Parse(dt.Rows[0]["packing_num"].ToString());
  308. po = dt.Rows[0]["PO_SN"].ToString();
  309. noType = int.Parse(dt.Rows[0]["noType"].ToString());
  310. ms_id = dt.Rows[0]["ms_id"].ToString();
  311. }
  312. if (po == "")
  313. {
  314. BaseUtil.ShowError("工单或线别未匹配到PO号,不允许执行该操作");
  315. }
  316. dynamic obj = new ExpandoObject();
  317. obj.tool_name = "zte";
  318. obj.request = "Storage2";
  319. obj.User = "mes";
  320. obj.password = "258456";
  321. obj.po_sn = po;
  322. obj.wholeDeviceCode = iSN;
  323. obj.reg_code = regcode;
  324. obj.prefix_en_no = prefix;
  325. obj.prefix_big_box = prebigxbox;
  326. obj.packing_num = packing_num;
  327. obj.noType = noType;
  328. obj.isn = iSN;
  329. string json = JsonConvert.SerializeObject(obj, Formatting.Indented);
  330. string returnstr = ToServerReq(json);
  331. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + json + "',sysdate,'GETEN')", "insert");
  332. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + returnstr + "',sysdate,'GETEN')", "insert");
  333. JObject deviceObj = JObject.Parse(returnstr);
  334. string WholeDeviceCode = deviceObj["WholeDeviceCode"].ToString();
  335. string SN = deviceObj["SN"].ToString();
  336. string dev_en_no = deviceObj["dev_en_no"].ToString();
  337. string mac = deviceObj["mac"].ToString();
  338. string mac_start = deviceObj["mac_start"].ToString();
  339. string mac_end = deviceObj["mac_end"].ToString();
  340. string reg_code = deviceObj["reg_code"].ToString();
  341. string reserve3 = deviceObj["reserve3"].ToString();
  342. string status = deviceObj["status"].ToString();
  343. string device_type = deviceObj["device_type"].ToString();
  344. string en_no = deviceObj["en_no"].ToString();
  345. if (dh.CheckExist("ZTEDATA", "zd_sn='" + iSN + "' and zd_makecode='" + makecode + "' and zd_type='彩盒机身标'"))
  346. {
  347. dh.ExecuteSql("delete from ZTEDATA where zd_sn='" + iSN + "' and zd_makecode='" + makecode + "' and zd_type='彩盒机身标'", "delete");
  348. }
  349. switch (status)
  350. {
  351. case "-1":
  352. if (dev_en_no == "")
  353. {
  354. BaseUtil.ShowError("该序号已入库");
  355. }
  356. break;
  357. case "-2":
  358. BaseUtil.ShowError("没有写入这个序号的设备");
  359. break;
  360. case "-3":
  361. BaseUtil.ShowError("用户名或密码错误");
  362. break;
  363. case "-4":
  364. BaseUtil.ShowError("该序号还未写入设备");
  365. break;
  366. case "-5":
  367. BaseUtil.ShowError("未知错误");
  368. break;
  369. case "-6":
  370. BaseUtil.ShowError("装箱数量<=0");
  371. break;
  372. case "-7":
  373. BaseUtil.ShowError("该序号设备已经产生EN号");
  374. break;
  375. case "-8":
  376. BaseUtil.ShowError("该线体数据已包完");
  377. break;
  378. default:
  379. break;
  380. }
  381. dh.ExecuteSql("insert into ZTEDATA(ZD_ID,ZD_D_SN,zd_WholeDeviceCode,ZD_DEV_EN_NO,ZD_SN, ZD_MAKECODE, ZD_TYPE, ZD_VALUE,zd_mac,ZD_MAC_START, ZD_MAC_END,ZD_RESERVE3,zd_enno,zd_devicetype,zd_regcode)" +
  382. "values(ZTEDATA_seq.nextval,'" + SN + "','" + WholeDeviceCode + "','" + dev_en_no + "','" + iSN + "','" + makecode + "','彩盒机身标','','" + mac + "','" + mac_start + "','" + mac_end + "','" + reserve3 + "','" + en_no + "','" + device_type + "','" + reg_code + "')", "insert");
  383. return dev_en_no;
  384. }
  385. //获取外箱号信息
  386. public static void GetOutBoxInfo(string iBox)
  387. {
  388. dynamic obj = new ExpandoObject();
  389. var expandoDict = obj as IDictionary<string, object>;
  390. DataTable dt = (DataTable)dh.ExecuteSql("select NOTYPE,po_sn,ma_custpo,pd_barcode,pd_makecode,ZD_DEV_EN_NO from packagedetail left join ZTEDATA on zd_makecode=pd_makecode and pd_barcode=ZD_DEV_EN_NO left join make on ma_code=pd_makecode left join ZTE_ORDER on ma_custpo=BATCH_NO where pd_outboxcode='" + iBox + "' and RESERVE9='" + User.UserLineCode + "'", "select");
  391. string makecode = "";
  392. string po = "";
  393. string notype = "";
  394. for (int i = 0; i < dt.Rows.Count; i++)
  395. {
  396. string enNoKey = $"en_no{i}";
  397. string enNoValue = dt.Rows[i]["ZD_DEV_EN_NO"].ToString();
  398. expandoDict[enNoKey] = enNoValue;
  399. makecode = dt.Rows[i]["pd_makecode"].ToString();
  400. po = dt.Rows[i]["po_sn"].ToString();
  401. notype = dt.Rows[i]["NOTYPE"].ToString();
  402. }
  403. obj.request = "Q_wai_xiang";
  404. obj.packing_num = dt.Rows.Count;
  405. obj.User = "mes";
  406. obj.po_sn = po;
  407. obj.password = "258456";
  408. obj.tool_name = "zte";
  409. obj.noType = notype;
  410. if (po == "")
  411. {
  412. BaseUtil.ShowError("工单未维护客户PO号,不允许执行该操作");
  413. }
  414. string json = JsonConvert.SerializeObject(obj, Formatting.Indented);
  415. string returnstr = ToServerReq(json);
  416. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + json + "',sysdate,'GetOutBoxInfo')", "insert");
  417. var settings = new JsonSerializerSettings
  418. {
  419. Converters = new List<JsonConverter> { new DeviceInfoConverter() }
  420. };
  421. DeviceInfo deviceInfo = JsonConvert.DeserializeObject<DeviceInfo>(returnstr, settings);
  422. //将返回的信息存入数据库
  423. for (int i = 0; i < deviceInfo.DSN.Count; i++)
  424. {
  425. if (dh.CheckExist("ZTEDATA", "zd_sn='" + deviceInfo.DSN[i] + "' and zd_makecode='" + makecode + "' and zd_type='BOX'"))
  426. {
  427. dh.ExecuteSql("delete from ZTEDATA where zd_sn='" + deviceInfo.DSN[i] + "' and zd_makecode='" + makecode + "' and zd_type='BOX'", "delete");
  428. }
  429. dh.ExecuteSql("insert into ZTEDATA(ZD_ID,ZD_SN, ZD_MAKECODE, ZD_TYPE, ZD_VALUE,ZD_product_mode, ZD_PRODUCTNAME, ZD_MATERIAL_CODE, ZD_BATCH_NO, ZD_SOFT_VERSION, ZD_HD_VERSION, " +
  430. "ZD_VOLTAGE, ZD_POWER, ZD_ORDER_NO, ZD_BIG_BOX_NO, ZD_D_SN, ZD_DEV_EN_NO, ZD_RESERVE3, ZD_DEVICEID, ZD_MAC_START, ZD_MAC_END,zd_production_date, ZD_INDATE)" +
  431. "values(ZTEDATA_seq.nextval,'" + deviceInfo.DSN[i] + "','" + makecode + "','BOX','" + deviceInfo.DSN[i] + "','" + deviceInfo.ProductMode + "','" + deviceInfo.ProductName + "','" + deviceInfo.MaterialCode + "','" + deviceInfo.BatchNo + "','" + deviceInfo.SoftVersion + "','" + deviceInfo.HdVersion + "'," +
  432. "'" + deviceInfo.Voltage + "','" + deviceInfo.Power + "','" + deviceInfo.OrderNo + "','" + deviceInfo.BigBoxNo + "','" + deviceInfo.DSN[i] + "'," +
  433. "'" + deviceInfo.DevEnNo[i] + "', '" + deviceInfo.Reserve3[i] + "','" + deviceInfo.DeviceId[i] + "','" + deviceInfo.MacStart[i] + "','" + deviceInfo.MacEnd[i] + "','" + deviceInfo.ProductionDate + "',sysdate)", "insert");
  434. }
  435. dh.ExecuteSql("update package set pa_zxcode ='" + deviceInfo.BigBoxNo + "' where pa_outboxcode='" + iBox + "'", "update");
  436. if (returnstr.Length > 1000)
  437. {
  438. returnstr = returnstr.Substring(0, 1000);
  439. }
  440. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + returnstr + "',sysdate,'GetOutBoxInfo')", "insert");
  441. }
  442. public static void GetOutBoxInfoYLF(string iBox)
  443. {
  444. dynamic obj = new ExpandoObject();
  445. var expandoDict = obj as IDictionary<string, object>;
  446. DataTable dt = (DataTable)dh.ExecuteSql("select nvl(NOTYPE,0)NOTYPE,po_sn,ma_custpo,pd_barcode,pd_makecode,ZD_D_SN from packagedetail left join ZTEDATA on zd_makecode=pd_makecode and pd_barcode=zd_sn left join make on ma_code=pd_makecode left join ZTE_ORDER on ma_custpo=BATCH_NO where pd_outboxcode='" + iBox + "' and RESERVE9='" + User.UserLineCode + "'", "select");
  447. string makecode = "";
  448. string po = "";
  449. int notype =0;
  450. for (int i = 0; i < dt.Rows.Count; i++)
  451. {
  452. string enNoKey = $"en_no{i}";
  453. string enNoValue = dt.Rows[i]["ZD_D_SN"].ToString();
  454. expandoDict[enNoKey] = enNoValue;
  455. makecode = dt.Rows[i]["pd_makecode"].ToString();
  456. po = dt.Rows[i]["po_sn"].ToString();
  457. notype =int.Parse( dt.Rows[i]["NOTYPE"].ToString());
  458. }
  459. obj.request = "Q_wai_xiang";
  460. obj.packing_num = dt.Rows.Count;
  461. obj.User = "mes";
  462. obj.po_sn = po;
  463. obj.password = "258456";
  464. obj.tool_name = "zte";
  465. obj.noType = notype;
  466. if (po == "")
  467. {
  468. BaseUtil.ShowError("工单未维护客户PO号,不允许执行该操作");
  469. }
  470. string json = JsonConvert.SerializeObject(obj, Formatting.Indented);
  471. string returnstr = ToServerReq(json);
  472. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + json + "',sysdate,'GetOutBoxInfo')", "insert");
  473. var settings = new JsonSerializerSettings
  474. {
  475. Converters = new List<JsonConverter> { new DeviceInfoConverter() }
  476. };
  477. DeviceInfo deviceInfo = JsonConvert.DeserializeObject<DeviceInfo>(returnstr, settings);
  478. //将返回的信息存入数据库
  479. for (int i = 0; i < deviceInfo.DSN.Count; i++)
  480. {
  481. if (dh.CheckExist("ZTEDATA", "zd_sn='" + deviceInfo.DSN[i] + "' and zd_makecode='" + makecode + "' and zd_type='BOX'"))
  482. {
  483. dh.ExecuteSql("delete from ZTEDATA where zd_sn='" + deviceInfo.DSN[i] + "' and zd_makecode='" + makecode + "' and zd_type='BOX'", "delete");
  484. }
  485. dh.ExecuteSql("insert into ZTEDATA(ZD_ID,ZD_SN, ZD_MAKECODE, ZD_TYPE, ZD_VALUE,ZD_product_mode, ZD_PRODUCTNAME, ZD_MATERIAL_CODE, ZD_BATCH_NO, ZD_SOFT_VERSION, ZD_HD_VERSION, " +
  486. "ZD_VOLTAGE, ZD_POWER, ZD_ORDER_NO, ZD_BIG_BOX_NO, ZD_D_SN, ZD_DEV_EN_NO, ZD_RESERVE3, ZD_DEVICEID, ZD_MAC_START, ZD_MAC_END,zd_production_date, ZD_INDATE)" +
  487. "values(ZTEDATA_seq.nextval,'" + deviceInfo.DSN[i] + "','" + makecode + "','BOX','" + deviceInfo.DSN[i] + "','" + deviceInfo.ProductMode + "','" + deviceInfo.ProductName + "','" + deviceInfo.MaterialCode + "','" + deviceInfo.BatchNo + "','" + deviceInfo.SoftVersion + "','" + deviceInfo.HdVersion + "'," +
  488. "'" + deviceInfo.Voltage + "','" + deviceInfo.Power + "','" + deviceInfo.OrderNo + "','" + deviceInfo.BigBoxNo + "','" + deviceInfo.DSN[i] + "'," +
  489. "'" + deviceInfo.DevEnNo[i] + "', '" + deviceInfo.Reserve3[i] + "','" + deviceInfo.DeviceId[i] + "','" + deviceInfo.MacStart[i] + "','" + deviceInfo.MacEnd[i] + "','" + deviceInfo.ProductionDate + "',sysdate)", "insert");
  490. }
  491. dh.ExecuteSql("update package set pa_zxcode ='" + deviceInfo.BigBoxNo + "' where pa_outboxcode='" + iBox + "'", "update");
  492. if (returnstr.Length > 1000)
  493. {
  494. returnstr = returnstr.Substring(0, 1000);
  495. }
  496. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + returnstr + "',sysdate,'GetOutBoxInfo')", "insert");
  497. }
  498. //获取栈板信息
  499. public static void GetPalletInfo(string iBox)
  500. {
  501. DataTable dt = (DataTable)dh.ExecuteSql("select po_sn,sc_linecode,ma_custpo,pa_zxcode,pa_outboxcode,pa_makecode from package left join source on pa_sccode=sc_code left join make on pa_makecode=ma_code left join ZTE_ORDER on ma_custpo=BATCH_NO where pa_mothercode='" + iBox + "' and RESERVE9='" + User.UserLineCode + "'", "select");
  502. dynamic obj = new ExpandoObject();
  503. var expandoDict = obj as IDictionary<string, object>;
  504. string po = "";
  505. string makecode = "";
  506. string linecode = "";
  507. for (int i = 0; i < dt.Rows.Count; i++)
  508. {
  509. string enNoKey = $"big_box_no{i}";
  510. string enNoValue = dt.Rows[i]["pa_zxcode"].ToString();
  511. expandoDict[enNoKey] = enNoValue;
  512. po = dt.Rows[i]["po_sn"].ToString();
  513. makecode = dt.Rows[i]["pa_makecode"].ToString();
  514. linecode = dt.Rows[i]["sc_linecode"].ToString();
  515. }
  516. obj.request = "pallet";
  517. obj.packing_num = dt.Rows.Count;
  518. obj.User = "mes";
  519. obj.po_sn = po;
  520. obj.password = "258456";
  521. obj.tool_name = "zte";
  522. obj.mes_po = makecode;
  523. obj.line_code = linecode;
  524. if (po == "")
  525. {
  526. BaseUtil.ShowError("工单未维护客户PO号,不允许执行该操作");
  527. }
  528. string json = JsonConvert.SerializeObject(obj, Formatting.Indented);
  529. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + json + "',sysdate,'GetPalletInfo')", "insert");
  530. string returnstr = ToServerReq(json);
  531. JObject deviceObj = JObject.Parse(returnstr);
  532. string pallet_no = deviceObj["pallet_no"].ToString();
  533. string palltecode = deviceObj["palletNo"].ToString();
  534. dh.ExecuteSql("update package set pa_zxcode ='" + palltecode + "',pa_detno='" + pallet_no + "' where pa_outboxcode='" + iBox + "'", "update");
  535. if (returnstr.Length > 1000)
  536. {
  537. returnstr = returnstr.Substring(0, 1000);
  538. }
  539. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + returnstr + "',sysdate,'GetPalletInfo')", "insert");
  540. }
  541. public static void SendPowerCode(string iSN)
  542. {
  543. DataTable dt = (DataTable)dh.ExecuteSql("select NOTYPE,cm_barcode,pr_detail,ms_code from craftmaterial left join makeserial on ms_sncode=cm_sncode and ms_makecode=cm_makecode left join make on ma_code=cm_makecode left join ZTE_ORDER on ma_custpo=batch_no left join product on cm_fsoncode=pr_code where cm_sncode='" + iSN + "' and cm_status=0", "select");
  544. dynamic obj = new ExpandoObject();
  545. var expandoDict = obj as IDictionary<string, object>;
  546. string part_sn = "";
  547. string part_ar = "";
  548. string SN = "";
  549. string notype = "";
  550. for (int i = 0; i < dt.Rows.Count; i++)
  551. {
  552. if (dt.Rows[i]["pr_detail"].ToString().Contains("电源"))
  553. {
  554. part_sn = dt.Rows[i]["cm_barcode"].ToString();
  555. }
  556. if (dt.Rows[i]["pr_detail"].ToString().Contains("报警器"))
  557. {
  558. part_ar = dt.Rows[i]["cm_barcode"].ToString();
  559. }
  560. SN = dt.Rows[i]["ms_code"].ToString();
  561. notype = dt.Rows[i]["notype"].ToString();
  562. }
  563. obj.request = "bindSN";
  564. obj.noType = notype;
  565. obj.User = "test";
  566. obj.password = "123456";
  567. obj.tool_name = "zte";
  568. obj.part_sn = part_sn;
  569. obj.part_ar = part_ar;
  570. obj.SN = SN;
  571. string json = JsonConvert.SerializeObject(obj, Formatting.Indented);
  572. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + json + "',sysdate,'SendPowerCode')", "insert");
  573. string returnstr = ToServerReq(json);
  574. if (returnstr.Length > 1000)
  575. {
  576. returnstr = returnstr.Substring(0, 1000);
  577. }
  578. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + returnstr + "',sysdate,'SendPowerCode')", "insert");
  579. }
  580. public static async void SendBoxDataYS(string iBox)
  581. {
  582. DataTable dt = (DataTable)dh.ExecuteSql("select ma_custpo,ma_custpodetno,ZD_BIG_BOX_NO,pr_code,PRODUCT_MODE,ms_makecode,po_sn from makeserial left join product on ms_prodcode=pr_code left join make on ma_code=ms_makecode left join zte_order on ma_custpo=batch_no left join ztedata on ZD_DEV_EN_NO=ms_sncode and zd_makecode=ms_makecode where ms_outboxcode ='" + iBox + "' and zd_type='BOX' order by ms_id desc", "select");
  583. var root = new RootObjectYS
  584. {
  585. nub = iBox,
  586. login_key = "PRD90904837",
  587. ebeln = dt.Rows[0]["ma_custpo"].ToString(),
  588. ebelp = dt.Rows[0]["ma_custpodetno"].ToString(),
  589. pkcde = iBox,
  590. brgew = 0,
  591. mak01 = "mak01",
  592. BindList = new List<BindItemYS>()
  593. };
  594. dt = (DataTable)dh.ExecuteSql("select pd_barcode from packagedetail where pd_outboxcode='" + iBox + "' order by pd_barcode", "select");
  595. for (int i = 0; i < dt.Rows.Count; i++)
  596. {
  597. root.BindList.Add(new BindItemYS
  598. {
  599. barcd = dt.Rows[i]["pd_barcode"].ToString()
  600. });
  601. }
  602. var httpClientHandler = new HttpClientHandler();
  603. httpClientHandler.ServerCertificateCustomValidationCallback = (message, cert, chain, errors) => { return true; };
  604. using (var client = new HttpClient(httpClientHandler))
  605. {
  606. StringBuilder sbText = new StringBuilder();
  607. string json = JsonConvert.SerializeObject(root, Formatting.Indented);
  608. var content = new StringContent(json, Encoding.UTF8, "application/json");
  609. await Console.Out.WriteLineAsync(json);
  610. try
  611. {
  612. var response = await client.PostAsync("https://xi.hikvision.com:8850/RESTAdapter/outsourcing/CALLBACKPACKINGINFO", content);
  613. if (response.IsSuccessStatusCode)
  614. {
  615. string returnstr = await response.Content.ReadAsStringAsync();
  616. JObject deviceObj = JObject.Parse(returnstr);
  617. string code = deviceObj["code"]["code"].ToString();
  618. string msg = deviceObj["code"]["msg"].ToString();
  619. if (code == "0000")
  620. {
  621. dh.ExecuteSql("update packagedetail set pd_issuccess=-1 where pd_outboxcode='" + iBox + "'", "update");
  622. dh.ExecuteSql("update package set pa_issuccess=-1 where pa_outboxcode='" + iBox + "'", "update");
  623. //MessageBox.Show(ZD_BIG_BOX_NO + "上传星云成功");
  624. }
  625. else
  626. {
  627. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + msg + "',sysdate,'SendBoxData')", "insert");
  628. MessageBox.Show(msg);
  629. }
  630. }
  631. else
  632. {
  633. BaseUtil.ShowError(response.StatusCode.ToString());
  634. }
  635. }
  636. catch (Exception ex)
  637. {
  638. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + ex.Message + "',sysdate,'SendBoxData')", "insert");
  639. }
  640. }
  641. }
  642. //发送外箱号数据,打印前获取
  643. public static async void SendBoxData(string iBox)
  644. {
  645. string sn = dh.getFieldDataByCondition("packagedetail left join ztedata on pd_barcode=ZD_DEV_EN_NO and pd_makecode=zd_makecode ", "replace(wm_concat(replace(ZD_MAC_START,'-','')),',','-')", "pd_outboxcode='" + iBox + "' and zd_type='BOX'").ToString();
  646. DataTable dt = (DataTable)dh.ExecuteSql("select batch_no,ZD_BIG_BOX_NO,pr_code,PRODUCT_MODE,ms_makecode,po_sn from makeserial left join product on ms_prodcode=pr_code left join make on ma_code=ms_makecode left join zte_order on ma_custpo=batch_no left join ztedata on ZD_DEV_EN_NO=ms_sncode and zd_makecode=ms_makecode where ms_outboxcode ='" + iBox + "' and zd_type='BOX' order by ms_id desc", "select");
  647. string PRODUCT_MODE = "";
  648. string po_sn = "";
  649. string pr_code = "";
  650. string ZD_BIG_BOX_NO = "";
  651. if (dt.Rows.Count > 0)
  652. {
  653. PRODUCT_MODE = dt.Rows[0]["PRODUCT_MODE"].ToString();
  654. po_sn = dt.Rows[0]["batch_no"].ToString();
  655. pr_code = dt.Rows[0]["pr_code"].ToString();
  656. ZD_BIG_BOX_NO = dt.Rows[0]["ZD_BIG_BOX_NO"].ToString();
  657. }
  658. var root = new RootObject
  659. {
  660. ProductModuleType = "整机",
  661. ProductMainClass = "固网_CPE",
  662. ProductMediumClass = "CPE",
  663. ProductSubClass = PRODUCT_MODE,
  664. Task = po_sn,
  665. ProcessType = "生产过程",
  666. UserId = User.UserName,
  667. BindList = new List<BindItem>()
  668. };
  669. root.BindList.Add(new BindItem
  670. {
  671. BindKey = "cartonSn",
  672. BindValue = ZD_BIG_BOX_NO,
  673. KeyType = "macbox",
  674. KeyValue = sn,
  675. HashType = "SHA256",
  676. HashKey = ComputeSha256Hash(sn)
  677. });
  678. dt = (DataTable)dh.ExecuteSql("select pd_barcode,replace(ZD_MAC_START,'-','')ZD_MAC_START from packagedetail left join ztedata on pd_barcode=ZD_DEV_EN_NO and pd_makecode=zd_makecode where pd_outboxcode='" + iBox + "' and zd_type='BOX' order by pd_barcode", "select");
  679. DataTable dt1 = (DataTable)dh.ExecuteSql("select pid_sql,pid_item,pid_value,pid_valuetype from productitem left join productitemdetail on pid_piid=pi_id where pi_prodcode='" + pr_code + "'", "select");
  680. for (int i = 0; i < dt.Rows.Count; i++)
  681. {
  682. for (int j = 0; j < dt1.Rows.Count; j++)
  683. {
  684. if (dt1.Rows[j]["pid_valuetype"].ToString() == "SHA256")
  685. {
  686. root.BindList.Add(new BindItem
  687. {
  688. BindKey = "mac",
  689. BindValue = dt.Rows[i]["ZD_MAC_START"].ToString(),
  690. KeyType = dt1.Rows[j]["pid_item"].ToString(),
  691. KeyValue = dt1.Rows[j]["pid_item"].ToString(),
  692. HashType = "SHA256",
  693. HashKey = ComputeSha256Hash(sn),
  694. });
  695. }
  696. else
  697. {
  698. string sql = dt1.Rows[j]["pid_sql"].ToString();
  699. string value = "";
  700. if (sql != "")
  701. {
  702. Regex ConnoteA = new Regex("{\\w+}");
  703. foreach (Match mch in ConnoteA.Matches(sql))
  704. {
  705. string x = mch.Value.Trim();
  706. sql = sql.Replace(x, "'" + dt.Rows[i]["pd_barcode"].ToString() + "'");
  707. }
  708. DataTable Param = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
  709. if (Param.Rows.Count > 0)
  710. {
  711. value = Param.Rows[0][0].ToString();
  712. }
  713. }
  714. else
  715. {
  716. value = dt1.Rows[j]["pid_value"].ToString();
  717. }
  718. root.BindList.Add(new BindItem
  719. {
  720. BindKey = "mac",
  721. BindValue = dt.Rows[i]["ZD_MAC_START"].ToString(),
  722. KeyType = dt1.Rows[j]["pid_item"].ToString(),
  723. KeyValue = value,
  724. HashType = "NON-HASH",
  725. HashKey = value,
  726. });
  727. }
  728. }
  729. }
  730. var httpClientHandler = new HttpClientHandler();
  731. httpClientHandler.ServerCertificateCustomValidationCallback = (message, cert, chain, errors) => { return true; };
  732. using (var client = new HttpClient(httpClientHandler))
  733. {
  734. client.DefaultRequestHeaders.Add("apikey", "60e7107a86284a6d842e551704e69253");
  735. client.DefaultRequestHeaders.Add("AppCode", "91678314583d4c2bbf185bc5573ac73d");
  736. StringBuilder sbText = new StringBuilder();
  737. string json = JsonConvert.SerializeObject(root, Formatting.Indented);
  738. var content = new StringContent(json, Encoding.UTF8, "application/json");
  739. await Console.Out.WriteLineAsync(json);
  740. try
  741. {
  742. var response = await client.PostAsync("https://172.30.30.10:29001/api/mds-web-outservice/v1/api/rest/mds/saveFmKeyHashcodeInfoBatch", content);
  743. if (response.IsSuccessStatusCode)
  744. {
  745. string returnstr = await response.Content.ReadAsStringAsync();
  746. JObject deviceObj = JObject.Parse(returnstr);
  747. string code = deviceObj["code"]["code"].ToString();
  748. string msg = deviceObj["code"]["msg"].ToString();
  749. if (code == "0000")
  750. {
  751. dh.ExecuteSql("update packagedetail set pd_issuccess=-1 where pd_outboxcode='" + iBox + "'", "update");
  752. dh.ExecuteSql("update package set pa_issuccess=-1 where pa_outboxcode='" + iBox + "'", "update");
  753. //MessageBox.Show(ZD_BIG_BOX_NO + "上传星云成功");
  754. }
  755. else
  756. {
  757. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + msg + "',sysdate,'SendBoxData')", "insert");
  758. MessageBox.Show(msg);
  759. }
  760. }
  761. else
  762. {
  763. BaseUtil.ShowError(response.StatusCode.ToString());
  764. }
  765. }
  766. catch (Exception ex)
  767. {
  768. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + ex.Message + "',sysdate,'SendBoxData')", "insert");
  769. }
  770. }
  771. }
  772. public static string GetMingPai_Thailand(string iSN)
  773. {
  774. DataTable dt = (DataTable)dh.ExecuteSql("select po_sn,ms_id,ma_custpo,ms_makecode,pr_prefix,PREFIX_EN_NO,PREFIX_BIG_BOX,pr_prebigxbox,pr_regcode from makeserial left join product on ms_prodcode=pr_code left join make on ma_code=ms_makecode left join ZTE_ORDER on ma_custpo=batch_no where ms_sncode ='" + iSN + "' or ms_firstsn='" + iSN + "' and RESERVE9='" + User.UserLineCode + "' order by ms_id desc", "select");
  775. string po = "";
  776. string makecode = "";
  777. string ms_id = "";
  778. if (dt.Rows.Count > 0)
  779. {
  780. po = dt.Rows[0]["po_sn"].ToString();
  781. makecode = dt.Rows[0]["ms_makecode"].ToString();
  782. ms_id = dt.Rows[0]["ms_id"].ToString();
  783. }
  784. dynamic obj = new ExpandoObject();
  785. obj.tool_name = "zte";
  786. obj.request = "ajc_mingpai";
  787. obj.User = "1453";
  788. obj.password = "12345678";
  789. obj.po_sn = po;
  790. obj.product_id = iSN;
  791. if (po == "")
  792. {
  793. BaseUtil.ShowError("工单未维护客户PO号,不允许执行该操作");
  794. }
  795. string json = JsonConvert.SerializeObject(obj, Formatting.Indented);
  796. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + json + "',sysdate,'GETEN_THA')", "insert");
  797. string returnstr = ToServerReq(json);
  798. JObject deviceObj = JObject.Parse(returnstr);
  799. string tool_name = deviceObj["tool_name"].ToString();
  800. string response = deviceObj["response"].ToString();
  801. string sn = deviceObj["sn"].ToString();
  802. string status = deviceObj["status"].ToString();
  803. string product_id = deviceObj["product_id"].ToString();
  804. string dev_mac = deviceObj["dev_mac"].ToString();
  805. string wifi_mac = deviceObj["wifi_mac"].ToString();
  806. string en = deviceObj["en"].ToString();
  807. string en_prefix = deviceObj["en_prefix"].ToString();
  808. string product_name = deviceObj["product_name"].ToString();
  809. string vendor = deviceObj["vendor"].ToString();
  810. string esim_iccid = deviceObj["esim_iccid"].ToString();
  811. string exsim_iccid = deviceObj["exsim_iccid"].ToString();
  812. string fg_ver = deviceObj["4g_ver"].ToString();
  813. string fg_type = deviceObj["4g_type"].ToString();
  814. if (dh.CheckExist("ZTEDATA", "zd_sn='" + iSN + "' and zd_makecode='" + makecode + "' and zd_type='铭牌标'"))
  815. {
  816. dh.ExecuteSql("delete from ZTEDATA where zd_sn='" + iSN + "' and zd_makecode='" + makecode + "' and zd_type='铭牌标'", "delete");
  817. }
  818. dh.ExecuteSql("update makeserial set ms_sncode='" + sn + "' where ms_id='" + ms_id + "'", "update");
  819. dh.ExecuteSql("insert into ZTEDATA(ZD_ID,zd_vendor,ZD_D_SN,ZD_DEV_EN_NO,ZD_SN, ZD_MAKECODE, ZD_TYPE, ZD_VALUE,zd_mac,zd_enno,ZD_PRODUCTNAME)" +
  820. "values(ZTEDATA_seq.nextval,'" + vendor + "','" + sn + "','" + sn + "','" + iSN + "','" + makecode + "','铭牌标','','" + wifi_mac + "'" +
  821. ",'" + en + "','" + product_name + "')", "insert");
  822. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + returnstr + "',sysdate,'GETEN_THA')", "insert");
  823. return sn;
  824. }
  825. public static string GetCaiHe_Thailand(string iSN)
  826. {
  827. DataTable dt = (DataTable)dh.ExecuteSql("select ms_id,ma_custpo,ms_makecode,pr_prefix,PREFIX_EN_NO,PREFIX_BIG_BOX,pr_prebigxbox,pr_regcode from makeserial left join product on ms_prodcode=pr_code left join make on ma_code=ms_makecode left join ZTE_ORDER on ma_custpo=batch_no where RESERVE9='" + User.UserLineCode + "' and ms_sncode ='" + iSN + "' or ms_firstsn='" + iSN + "' order by ms_id desc", "select");
  828. string po = "";
  829. string makecode = "";
  830. string ms_id = "";
  831. if (dt.Rows.Count > 0)
  832. {
  833. po = dt.Rows[0]["po_sn"].ToString();
  834. makecode = dt.Rows[0]["ms_makecode"].ToString();
  835. ms_id = dt.Rows[0]["ms_id"].ToString();
  836. }
  837. dynamic obj = new ExpandoObject();
  838. obj.tool_name = "zte";
  839. obj.request = "ajc_cai_he";
  840. obj.User = "1453";
  841. obj.password = "12345678";
  842. obj.po_sn = po;
  843. obj.product_id = iSN;
  844. if (po == "")
  845. {
  846. BaseUtil.ShowError("工单未维护客户PO号,不允许执行该操作");
  847. }
  848. string json = JsonConvert.SerializeObject(obj, Formatting.Indented);
  849. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + json + "',sysdate,'GETEN_THA')", "insert");
  850. string returnstr = ToServerReq(json);
  851. JObject deviceObj = JObject.Parse(returnstr);
  852. string tool_name = deviceObj["tool_name"].ToString();
  853. string response = deviceObj["response"].ToString();
  854. string sn = deviceObj["sn"].ToString();
  855. string status = deviceObj["status"].ToString();
  856. string product_id = deviceObj["product_id"].ToString();
  857. string dev_mac = deviceObj["dev_mac"].ToString();
  858. string wifi_mac = deviceObj["wifi_mac"].ToString();
  859. string en = deviceObj["en"].ToString();
  860. if (dh.CheckExist("ZTEDATA", "zd_sn='" + iSN + "' and zd_makecode='" + makecode + "' and zd_type='彩盒标'"))
  861. {
  862. dh.ExecuteSql("delete from ZTEDATA where zd_sn='" + iSN + "' and zd_makecode='" + makecode + "' and zd_type='彩盒标'", "delete");
  863. }
  864. dh.ExecuteSql("update makeserial set ms_sncode='" + sn + "' where ms_id='" + ms_id + "'", "update");
  865. dh.ExecuteSql("insert into ZTEDATA(ZD_ID,ZD_D_SN,ZD_DEV_EN_NO,ZD_SN, ZD_MAKECODE, ZD_TYPE, ZD_VALUE,zd_mac,zd_enno,ZD_PRODUCTNAME)" +
  866. "values(ZTEDATA_seq.nextval,'" + sn + "','" + sn + "','" + iSN + "','" + makecode + "','彩盒标','','" + wifi_mac + "'" +
  867. ",'" + en + "')", "insert");
  868. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + returnstr + "',sysdate,'GETEN_THA')", "insert");
  869. return sn;
  870. }
  871. public static void GetOutBoxInf_Thailand(string iBox)
  872. {
  873. dynamic obj = new ExpandoObject();
  874. var expandoDict = obj as IDictionary<string, object>;
  875. DataTable dt = (DataTable)dh.ExecuteSql("select nvl(PACKING_NUM,0)PACKING_NUM,nvl(notype,0)notype,ma_custpo,pd_barcode,pd_makecode,ZD_DEV_EN_NO from packagedetail left join ZTEDATA on zd_makecode=pd_makecode and pd_barcode=ZD_DEV_EN_NO left join make on ma_code=pd_makecode left join zte_order on batch_no=ma_custpo where RESERVE9='" + User.UserLineCode + "' and pd_outboxcode='" + iBox + "'", "select");
  876. string makecode = "";
  877. string po = "";
  878. int notype = 0;
  879. int PACKING_NUM = 0;
  880. for (int i = 0; i < dt.Rows.Count; i++)
  881. {
  882. string enNoKey = $"sn{i}";
  883. string enNoValue = dt.Rows[i]["ZD_DEV_EN_NO"].ToString();
  884. expandoDict[enNoKey] = enNoValue;
  885. makecode = dt.Rows[i]["pd_makecode"].ToString();
  886. po = dt.Rows[i]["ma_custpo"].ToString();
  887. notype = int.Parse(dt.Rows[i]["notype"].ToString());
  888. PACKING_NUM = int.Parse(dt.Rows[i]["PACKING_NUM"].ToString());
  889. }
  890. obj.request = "ajc_wai_xiang";
  891. obj.packing_num = PACKING_NUM;
  892. obj.User = "test";
  893. obj.po_sn = po;
  894. obj.password = "123456";
  895. obj.tool_name = "AJC";
  896. obj.noType = notype;
  897. if (po == "")
  898. {
  899. BaseUtil.ShowError("工单未维护客户PO号,不允许执行该操作");
  900. }
  901. string json = JsonConvert.SerializeObject(obj, Formatting.Indented);
  902. string returnstr = ToServerReq(json);
  903. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + json + "',sysdate,'GetOutBoxInfo')", "insert");
  904. var settings = new JsonSerializerSettings
  905. {
  906. Converters = new List<JsonConverter> { new DeviceInfoConverter() }
  907. };
  908. Thailand deviceInfo = JsonConvert.DeserializeObject<Thailand>(returnstr, settings);
  909. //将返回的信息存入数据库
  910. for (int i = 0; i < deviceInfo.product_id.Count; i++)
  911. {
  912. if (dh.CheckExist("ZTEDATA", "zd_sn='" + deviceInfo.product_id[i] + "' and zd_makecode='" + makecode + "' and zd_type='BOX'"))
  913. {
  914. dh.ExecuteSql("delete from ZTEDATA where zd_sn='" + deviceInfo.product_id[i] + "' and zd_makecode='" + makecode + "' and zd_type='BOX'", "delete");
  915. }
  916. dh.ExecuteSql("insert into ZTEDATA(ZD_ID,ZD_SN, ZD_MAKECODE, ZD_TYPE,ZD_product_mode, ZD_PRODUCTNAME, " +
  917. "ZD_ORDER_NO, ZD_BIG_BOX_NO, ZD_D_SN, ZD_DEV_EN_NO,ZD_DEVICEID,zd_custom ,ZD_INDATE)" +
  918. "values(ZTEDATA_seq.nextval,'" + deviceInfo.sn[i] + "','" + makecode + "','BOX','" + deviceInfo.ProductMode + "','" + deviceInfo.ProductName + "'," +
  919. ",'" + deviceInfo.OrderNum + "','" + deviceInfo.BigBoxNo + "','" + deviceInfo.sn[i] + "','" + deviceInfo.en[i] + "','" + deviceInfo.product_id[i] + "','Thailand'," +
  920. ",sysdate)", "insert");
  921. }
  922. dh.ExecuteSql("update package set pa_zxcode ='" + deviceInfo.BigBoxNo + "' where pa_outboxcode='" + iBox + "'", "update");
  923. if (returnstr.Length > 1000)
  924. {
  925. returnstr = returnstr.Substring(0, 1000);
  926. }
  927. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + returnstr + "',sysdate,'GetOutBoxInfo')", "insert");
  928. }
  929. public static readonly uint PROTOCOL_FLAG = 0x4C4F4F54;
  930. public static string ToServerReq(string strJSON)
  931. {
  932. int nRet = 0;
  933. string strServerIP = "192.168.1.160";
  934. string strResp = "";
  935. IPAddress ip = IPAddress.Parse(strServerIP);
  936. Socket clientSocket = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp);
  937. while (true)
  938. {
  939. try
  940. {
  941. clientSocket.Connect(new IPEndPoint(ip, SN_SERVICE_PORT));
  942. }
  943. catch
  944. {
  945. nRet = -13;
  946. break;
  947. }
  948. try
  949. {
  950. FACT_DATA_HEAD stHead = new FACT_DATA_HEAD(null);
  951. byte[] bytJson = Encoding.UTF8.GetBytes(strJSON); //Encoding.ASCII.GetBytes(strJSON);
  952. stHead.setDataLen(bytJson.Length);
  953. byte[] bytBuf = new byte[FACT_DATA_HEAD.MY_LEN + bytJson.Length];
  954. byte[] bytSrcHead = stHead.getBytes();
  955. Array.Copy(bytSrcHead, 0, bytBuf, 0, bytSrcHead.Length);
  956. Array.Copy(bytJson, 0, bytBuf, FACT_DATA_HEAD.MY_LEN, bytJson.Length);
  957. clientSocket.Send(bytBuf);
  958. }
  959. catch
  960. {
  961. nRet = -12;
  962. break;
  963. }
  964. //判定接口回传的flag和本地传过去的是否一致
  965. byte[] bytRecv = new byte[MAX_BUF_SIZE];
  966. int nRecvSize = 0, nSize = 0;
  967. nRecvSize = clientSocket.Receive(bytRecv, 0, FACT_DATA_HEAD.MY_LEN, SocketFlags.None);
  968. if (nRecvSize > 0)
  969. {
  970. FACT_DATA_HEAD stHead = new FACT_DATA_HEAD(bytRecv);
  971. if (stHead.getFlag() == FACT_DATA_HEAD.PROTOCOL_FLAG)
  972. {
  973. int nPos = 0;
  974. nSize = stHead.getDatalen();
  975. while (nPos < nSize)
  976. {
  977. nRecvSize = clientSocket.Receive(bytRecv, nPos, nSize - nPos, SocketFlags.None);
  978. if (nRecvSize < 0)
  979. {
  980. nRet = -14;
  981. break;
  982. }
  983. nPos += nRecvSize;
  984. }
  985. strResp = Encoding.Default.GetString(bytRecv, 0, nSize);
  986. }
  987. else nRet = -11;
  988. }
  989. else nRet = -10;
  990. break;
  991. }
  992. if (nRet > -13) clientSocket.Shutdown(SocketShutdown.Both);
  993. clientSocket.Close();
  994. return strResp;
  995. }
  996. }
  997. }