HttpServer.cs 51 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092
  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 GetCaiHe_Thailand(string iSN)
  773. {
  774. 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 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]["ma_custpo"].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 = "AJC";
  786. obj.request = "ajc_cai_he";
  787. obj.User = "1453";
  788. obj.password = "12345678";
  789. obj.po_sn = po;
  790. obj.product_id = iSN.Substring(4,16);
  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. if (dh.CheckExist("ZTEDATA", "zd_sn='" + iSN + "' and zd_makecode='" + makecode + "' and zd_type='彩盒标'"))
  808. {
  809. dh.ExecuteSql("delete from ZTEDATA where zd_sn='" + iSN + "' and zd_makecode='" + makecode + "' and zd_type='彩盒标'", "delete");
  810. }
  811. 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)" +
  812. "values(ZTEDATA_seq.nextval,'" + product_id + "','" + product_id + "','" + iSN + "','" + makecode + "','彩盒标','','" + wifi_mac + "'" +
  813. ",'" + en + "')", "insert");
  814. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + returnstr + "',sysdate,'GETEN_THA')", "insert");
  815. return sn;
  816. }
  817. public static string GetMingPai_Thailand(string iSN)
  818. {
  819. 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");
  820. string po = "";
  821. string makecode = "";
  822. string ms_id = "";
  823. if (dt.Rows.Count > 0)
  824. {
  825. po = dt.Rows[0]["ma_custpo"].ToString();
  826. makecode = dt.Rows[0]["ms_makecode"].ToString();
  827. ms_id = dt.Rows[0]["ms_id"].ToString();
  828. }
  829. dynamic obj = new ExpandoObject();
  830. obj.tool_name = "AJC";
  831. obj.request = "ajc_mingpai";
  832. obj.User = "1453";
  833. obj.password = "12345678";
  834. obj.po_sn = po;
  835. obj.product_id = iSN.Substring(4, 16);
  836. if (po == "")
  837. {
  838. BaseUtil.ShowError("工单未维护客户PO号,不允许执行该操作");
  839. }
  840. string json = JsonConvert.SerializeObject(obj, Formatting.Indented);
  841. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + json + "',sysdate,'GETEN_THA')", "insert");
  842. string returnstr = ToServerReq(json);
  843. JObject deviceObj = JObject.Parse(returnstr);
  844. string tool_name = deviceObj["tool_name"].ToString();
  845. string response = deviceObj["response"].ToString();
  846. string sn = deviceObj["sn"].ToString();
  847. string status = deviceObj["status"].ToString();
  848. string product_id = deviceObj["product_id"].ToString();
  849. string dev_mac = deviceObj["dev_mac"].ToString();
  850. string wifi_mac = deviceObj["wifi_mac"].ToString();
  851. string vendor = deviceObj["vendor"].ToString();
  852. string product_name = deviceObj["product_name"].ToString();
  853. string en = deviceObj["en"].ToString();
  854. string en_prefix = deviceObj["en_prefix"].ToString();
  855. string esim_iccid = deviceObj["esim_iccid"].ToString();
  856. string exsim_iccid = deviceObj["exsim_iccid"].ToString();
  857. string fg_ver = deviceObj["4g_ver"].ToString();
  858. string fg_type = deviceObj["4g_type"].ToString();
  859. if (dh.CheckExist("ZTEDATA", "zd_sn='" + iSN + "' and zd_makecode='" + makecode + "' and zd_type='彩盒标'"))
  860. {
  861. dh.ExecuteSql("delete from ZTEDATA where zd_sn='" + iSN + "' and zd_makecode='" + makecode + "' and zd_type='彩盒标'", "delete");
  862. }
  863. 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," +
  864. "ZD_ESIMICCID, ZD_EXSIM_ICCID, ZD_4G_VER, ZD_4G_TYPE)" +
  865. "values(ZTEDATA_seq.nextval,'"+ vendor + "','" + sn + "','" + product_id + "','" + iSN + "','" + makecode + "','彩盒标','','" + wifi_mac + "'" +
  866. ",'" + en + "','"+ product_name + "','"+ esim_iccid + "','"+ exsim_iccid + "','"+ fg_ver + "','"+ fg_type + "')", "insert");
  867. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + returnstr + "',sysdate,'GETEN_THA')", "insert");
  868. return sn;
  869. }
  870. public static void GetOutBoxInf_Thailand(string iBox)
  871. {
  872. dynamic obj = new ExpandoObject();
  873. var expandoDict = obj as IDictionary<string, object>;
  874. 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");
  875. string makecode = "";
  876. string po = "";
  877. int notype = 0;
  878. int PACKING_NUM = 0;
  879. for (int i = 0; i < dt.Rows.Count; i++)
  880. {
  881. string enNoKey = $"sn{i}";
  882. string enNoValue = dt.Rows[i]["ZD_DEV_EN_NO"].ToString();
  883. expandoDict[enNoKey] = enNoValue;
  884. makecode = dt.Rows[i]["pd_makecode"].ToString();
  885. po = dt.Rows[i]["ma_custpo"].ToString();
  886. notype = int.Parse(dt.Rows[i]["notype"].ToString());
  887. PACKING_NUM = int.Parse(dt.Rows[i]["PACKING_NUM"].ToString());
  888. }
  889. obj.request = "ajc_wai_xiang";
  890. obj.packing_num = PACKING_NUM;
  891. obj.User = "test";
  892. obj.po_sn = po;
  893. obj.password = "123456";
  894. obj.tool_name = "AJC";
  895. obj.noType = notype;
  896. if (po == "")
  897. {
  898. BaseUtil.ShowError("工单未维护客户PO号,不允许执行该操作");
  899. }
  900. string json = JsonConvert.SerializeObject(obj, Formatting.Indented);
  901. string returnstr = ToServerReq(json);
  902. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + json + "',sysdate,'GetOutBoxInfo')", "insert");
  903. var settings = new JsonSerializerSettings
  904. {
  905. Converters = new List<JsonConverter> { new DeviceInfoConverter() }
  906. };
  907. Thailand deviceInfo = JsonConvert.DeserializeObject<Thailand>(returnstr, settings);
  908. //将返回的信息存入数据库
  909. for (int i = 0; i < deviceInfo.product_id.Count; i++)
  910. {
  911. if (dh.CheckExist("ZTEDATA", "zd_sn='" + deviceInfo.product_id[i] + "' and zd_makecode='" + makecode + "' and zd_type='BOX'"))
  912. {
  913. dh.ExecuteSql("delete from ZTEDATA where zd_sn='" + deviceInfo.product_id[i] + "' and zd_makecode='" + makecode + "' and zd_type='BOX'", "delete");
  914. }
  915. dh.ExecuteSql("insert into ZTEDATA(ZD_ID,ZD_SN, ZD_MAKECODE, ZD_TYPE,ZD_product_mode, ZD_PRODUCTNAME, " +
  916. "ZD_ORDER_NO, ZD_BIG_BOX_NO, ZD_D_SN, ZD_DEV_EN_NO,ZD_DEVICEID,zd_custom ,ZD_INDATE)" +
  917. "values(ZTEDATA_seq.nextval,'" + deviceInfo.sn[i] + "','" + makecode + "','BOX','" + deviceInfo.ProductMode + "','" + deviceInfo.ProductName + "'," +
  918. ",'" + deviceInfo.OrderNum + "','" + deviceInfo.BigBoxNo + "','" + deviceInfo.sn[i] + "','" + deviceInfo.en[i] + "','" + deviceInfo.product_id[i] + "','Thailand'," +
  919. ",sysdate)", "insert");
  920. }
  921. dh.ExecuteSql("update package set pa_zxcode ='" + deviceInfo.BigBoxNo + "' where pa_outboxcode='" + iBox + "'", "update");
  922. if (returnstr.Length > 1000)
  923. {
  924. returnstr = returnstr.Substring(0, 1000);
  925. }
  926. dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + returnstr + "',sysdate,'GetOutBoxInfo')", "insert");
  927. }
  928. public static readonly uint PROTOCOL_FLAG = 0x4C4F4F54;
  929. public static string ToServerReq(string strJSON)
  930. {
  931. int nRet = 0;
  932. string strServerIP = "192.168.1.160";
  933. string strResp = "";
  934. IPAddress ip = IPAddress.Parse(strServerIP);
  935. Socket clientSocket = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp);
  936. while (true)
  937. {
  938. try
  939. {
  940. clientSocket.Connect(new IPEndPoint(ip, SN_SERVICE_PORT));
  941. }
  942. catch
  943. {
  944. nRet = -13;
  945. break;
  946. }
  947. try
  948. {
  949. FACT_DATA_HEAD stHead = new FACT_DATA_HEAD(null);
  950. byte[] bytJson = Encoding.UTF8.GetBytes(strJSON); //Encoding.ASCII.GetBytes(strJSON);
  951. stHead.setDataLen(bytJson.Length);
  952. byte[] bytBuf = new byte[FACT_DATA_HEAD.MY_LEN + bytJson.Length];
  953. byte[] bytSrcHead = stHead.getBytes();
  954. Array.Copy(bytSrcHead, 0, bytBuf, 0, bytSrcHead.Length);
  955. Array.Copy(bytJson, 0, bytBuf, FACT_DATA_HEAD.MY_LEN, bytJson.Length);
  956. clientSocket.Send(bytBuf);
  957. }
  958. catch
  959. {
  960. nRet = -12;
  961. break;
  962. }
  963. //判定接口回传的flag和本地传过去的是否一致
  964. byte[] bytRecv = new byte[MAX_BUF_SIZE];
  965. int nRecvSize = 0, nSize = 0;
  966. nRecvSize = clientSocket.Receive(bytRecv, 0, FACT_DATA_HEAD.MY_LEN, SocketFlags.None);
  967. if (nRecvSize > 0)
  968. {
  969. FACT_DATA_HEAD stHead = new FACT_DATA_HEAD(bytRecv);
  970. if (stHead.getFlag() == FACT_DATA_HEAD.PROTOCOL_FLAG)
  971. {
  972. int nPos = 0;
  973. nSize = stHead.getDatalen();
  974. while (nPos < nSize)
  975. {
  976. nRecvSize = clientSocket.Receive(bytRecv, nPos, nSize - nPos, SocketFlags.None);
  977. if (nRecvSize < 0)
  978. {
  979. nRet = -14;
  980. break;
  981. }
  982. nPos += nRecvSize;
  983. }
  984. strResp = Encoding.Default.GetString(bytRecv, 0, nSize);
  985. }
  986. else nRet = -11;
  987. }
  988. else nRet = -10;
  989. break;
  990. }
  991. if (nRet > -13) clientSocket.Shutdown(SocketShutdown.Both);
  992. clientSocket.Close();
  993. return strResp;
  994. }
  995. }
  996. }