HttpServer.cs 51 KB

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