| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090 |
- using System;
- using System.Collections.Generic;
- using System.Data;
- using System.Dynamic;
- using System.IO;
- using System.Net;
- using System.Net.Http;
- using System.Net.Sockets;
- using System.Security.Cryptography;
- using System.Text;
- using System.Text.RegularExpressions;
- using System.Windows.Forms;
- using Newtonsoft.Json;
- using Newtonsoft.Json.Linq;
- using UAS_MES_NEW.DataOperate;
- using UAS_MES_NEW.Entity;
- namespace UAS_MES_NEW.PublicMethod
- {
- public class BindItem
- {
- [JsonProperty("bindKey")]
- public string BindKey { get; set; }
- [JsonProperty("bindValue")]
- public string BindValue { get; set; }
- [JsonProperty("keyType")]
- public string KeyType { get; set; }
- [JsonProperty("keyValue")]
- public string KeyValue { get; set; }
- [JsonProperty("hashType")]
- public string HashType { get; set; }
- [JsonProperty("hashKey")]
- public string HashKey { get; set; }
- }
- public class BindItemYS
- {
- [JsonProperty("barcd")]
- public string barcd { get; set; }
- }
- public class RootObject
- {
- [JsonProperty("productModuleType")]
- public string ProductModuleType { get; set; }
- [JsonProperty("productMainClass")]
- public string ProductMainClass { get; set; }
- [JsonProperty("productMediumClass")]
- public string ProductMediumClass { get; set; }
- [JsonProperty("productSubClass")]
- public string ProductSubClass { get; set; }
- [JsonProperty("task")]
- public string Task { get; set; }
- [JsonProperty("processType")]
- public string ProcessType { get; set; }
- [JsonProperty("userId")]
- public string UserId { get; set; }
- [JsonProperty("bindList")]
- public List<BindItem> BindList { get; set; }
- }
- public class RootObjectYS {
- [JsonProperty("nub")]
- public string nub { get; set; }
- [JsonProperty("login_key")]
- public string login_key { get; set; }
- [JsonProperty("ebeln")]
- public string ebeln { get; set; }
- [JsonProperty("ebelp")]
- public string ebelp { get; set; }
- [JsonProperty("pkcde")]
- public string pkcde { get; set; }
- [JsonProperty("brgew")]
- public double brgew { get; set; }
- [JsonProperty("mak01")]
- public string mak01 { get; set; }
- [JsonProperty("bindList")]
- public List<BindItemYS> BindList { get; set; }
- }
- public class DeviceInfo
- {
- [JsonProperty("tool_name")]
- public string ToolName { get; set; }
- [JsonProperty("response")]
- public string Response { get; set; }
- [JsonProperty("status")]
- public int Status { get; set; }
- [JsonProperty("product_name")]
- public string ProductName { get; set; }
- [JsonProperty("product_mode")]
- public string ProductMode { get; set; }
- [JsonProperty("material_code")]
- public string MaterialCode { get; set; }
- [JsonProperty("batch_no")]
- public string BatchNo { get; set; }
- [JsonProperty("production_date")]
- public string ProductionDate { get; set; }
- [JsonProperty("big_box_no")]
- public string BigBoxNo { get; set; }
- [JsonProperty("box_no")]
- public string BoxNo { get; set; }
- [JsonProperty("reserve10")]
- public string Reserve10 { get; set; }
- [JsonProperty("packing_num")]
- public int PackingNum { get; set; }
- [JsonProperty("soft_version")]
- public string SoftVersion { get; set; }
- [JsonProperty("hd_version")]
- public string HdVersion { get; set; }
- [JsonProperty("voltage")]
- public string Voltage { get; set; }
- [JsonProperty("power")]
- public string Power { get; set; }
- [JsonProperty("order_no")]
- public string OrderNo { get; set; }
- // 使用字典或列表来存储序列化的数组数据
- public List<string> DSN { get; set; } = new List<string>();
- public List<string> MacStart { get; set; } = new List<string>();
- public List<string> MacEnd { get; set; } = new List<string>();
- public List<string> DeviceId { get; set; } = new List<string>();
- public List<string> DevEnNo { get; set; } = new List<string>();
- public List<string> Reserve3 { get; set; } = new List<string>();
- public List<string> Reserve4 { get; set; } = new List<string>();
- }
- public class Thailand
- {
- [JsonProperty("tool_name")]
- public string ToolName { get; set; }
- [JsonProperty("response")]
- public string Response { get; set; }
- [JsonProperty("status")]
- public int Status { get; set; }
- [JsonProperty("product_name")]
- public string ProductName { get; set; }
- [JsonProperty("product_mode")]
- public string ProductMode { get; set; }
- [JsonProperty("big_box_no")]
- public string BigBoxNo { get; set; }
- [JsonProperty("packing_num")]
- public int PackingNum { get; set; }
- [JsonProperty("order_num")]
- public string OrderNum { get; set; }
- // 使用字典或列表来存储序列化的数组数据
- public List<string> sn { get; set; } = new List<string>();
- public List<string> product_id { get; set; } = new List<string>();
- public List<string> en { get; set; } = new List<string>();
- }
- public class DeviceInfoConverter : JsonConverter<DeviceInfo>
- {
- public override DeviceInfo ReadJson(JsonReader reader, System.Type objectType, DeviceInfo existingValue, bool hasExistingValue, JsonSerializer serializer)
- {
- JObject jsonObject = JObject.Load(reader);
- DeviceInfo deviceInfo = new DeviceInfo();
- // 解析基本字段
- serializer.Populate(jsonObject.CreateReader(), deviceInfo);
- // 解析数组字段
- ParseArrayFields(jsonObject, deviceInfo);
- return deviceInfo;
- }
- public override void WriteJson(JsonWriter writer, DeviceInfo value, JsonSerializer serializer)
- {
- throw new NotImplementedException();
- }
- private void ParseArrayFields(JObject jsonObject, DeviceInfo deviceInfo)
- {
- int index = 0;
- // 解析 d_sn 数组
- while (true)
- {
- string key = $"d_sn{index}";
- if (jsonObject.TryGetValue(key, out JToken value))
- {
- deviceInfo.DSN.Add(value.ToString());
- index++;
- }
- else
- {
- break;
- }
- }
- // 解析 mac_start 数组
- index = 0;
- while (true)
- {
- string key = $"mac_start{index}";
- if (jsonObject.TryGetValue(key, out JToken value))
- {
- deviceInfo.MacStart.Add(value.ToString());
- index++;
- }
- else
- {
- break;
- }
- }
- // 解析 mac_end 数组
- index = 0;
- while (true)
- {
- string key = $"mac_end{index}";
- if (jsonObject.TryGetValue(key, out JToken value))
- {
- deviceInfo.MacEnd.Add(value.ToString());
- index++;
- }
- else
- {
- break;
- }
- }
- // 解析 dev_en_no 数组
- index = 0;
- while (true)
- {
- string key = $"dev_en_no{index}";
- if (jsonObject.TryGetValue(key, out JToken value))
- {
- deviceInfo.DevEnNo.Add(value.ToString());
- index++;
- }
- else
- {
- break;
- }
- }
- // 解析 reserve3 数组
- index = 0;
- while (true)
- {
- string key = $"reserve3_{index}";
- if (jsonObject.TryGetValue(key, out JToken value))
- {
- deviceInfo.Reserve3.Add(value.ToString());
- index++;
- }
- else
- {
- break;
- }
- }
- // 解析 reserve4 数组
- index = 0;
- while (true)
- {
- string key = $"reserve4_{index}";
- if (jsonObject.TryGetValue(key, out JToken value))
- {
- deviceInfo.Reserve4.Add(value.ToString());
- index++;
- }
- else
- {
- break;
- }
- }
- // 解析 DeviceId 数组
- index = 0;
- while (true)
- {
- string key = $"DeviceId{index}";
- if (jsonObject.TryGetValue(key, out JToken value))
- {
- deviceInfo.DeviceId.Add(value.ToString());
- index++;
- }
- else
- {
- break;
- }
- }
- }
- }
- public class HttpServer
- {
- static DataHelper dh = new DataHelper();
- public static int SN_SERVICE_PORT = 21610;
- public static int MAX_BUF_SIZE = 8192;
- static string ComputeSha256Hash(string input)
- {
- using (SHA256 sha256 = SHA256.Create())
- {
- byte[] bytes = Encoding.UTF8.GetBytes(input);
- byte[] hashBytes = sha256.ComputeHash(bytes);
- StringBuilder builder = new StringBuilder();
- for (int i = 0; i < hashBytes.Length; i++)
- {
- builder.Append(hashBytes[i].ToString("x2"));
- }
- return builder.ToString().ToUpper();
- }
- }
- //获取SN的EN号,彩盒标机身标一个工站一起打印,需要SN单个获取
- public static string GetEN(string iSN)
- {
- 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");
- string prefix = "";
- string regcode = "";
- string makecode = "";
- string prebigxbox = "";
- int packing_num = 0;
- string po = "";
- int noType = 0;
- string ms_id = "";
- if (dt.Rows.Count > 0)
- {
- prefix = dt.Rows[0]["PREFIX_EN_NO"].ToString();
- regcode = dt.Rows[0]["pr_regcode"].ToString();
- makecode = dt.Rows[0]["ms_makecode"].ToString();
- prebigxbox = dt.Rows[0]["PREFIX_BIG_BOX"].ToString();
- packing_num = int.Parse(dt.Rows[0]["packing_num"].ToString());
- po = dt.Rows[0]["PO_SN"].ToString();
- noType = int.Parse(dt.Rows[0]["noType"].ToString());
- ms_id = dt.Rows[0]["ms_id"].ToString();
- }
- if (po == "")
- {
- BaseUtil.ShowError("工单或线别未匹配到PO号,不允许执行该操作");
- }
- dynamic obj = new ExpandoObject();
- obj.tool_name = "zte";
- obj.request = "Storage2";
- obj.User = "mes";
- obj.password = "258456";
- obj.po_sn = po;
- obj.wholeDeviceCode = iSN;
- obj.reg_code = regcode;
- obj.prefix_en_no = prefix;
- obj.prefix_big_box = prebigxbox;
- obj.packing_num = packing_num;
- obj.noType = noType;
- obj.isn = iSN;
- string json = JsonConvert.SerializeObject(obj, Formatting.Indented);
- string returnstr = ToServerReq(json);
- dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + json + "',sysdate,'GETEN')", "insert");
- dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + returnstr + "',sysdate,'GETEN')", "insert");
- JObject deviceObj = JObject.Parse(returnstr);
- string WholeDeviceCode = deviceObj["WholeDeviceCode"].ToString();
- string SN = deviceObj["SN"].ToString();
- string dev_en_no = deviceObj["dev_en_no"].ToString();
- string mac = deviceObj["mac"].ToString();
- string mac_start = deviceObj["mac_start"].ToString();
- string mac_end = deviceObj["mac_end"].ToString();
- string reg_code = deviceObj["reg_code"].ToString();
- string reserve3 = deviceObj["reserve3"].ToString();
- string status = deviceObj["status"].ToString();
- string device_type = deviceObj["device_type"].ToString();
- string en_no = deviceObj["en_no"].ToString();
- if (dh.CheckExist("ZTEDATA", "zd_sn='" + iSN + "' and zd_makecode='" + makecode + "' and zd_type='彩盒机身标'"))
- {
- dh.ExecuteSql("delete from ZTEDATA where zd_sn='" + iSN + "' and zd_makecode='" + makecode + "' and zd_type='彩盒机身标'", "delete");
- }
- switch (status)
- {
- case "-1":
- BaseUtil.ShowError("未获取到EN号");
- break;
- case "-2":
- BaseUtil.ShowError("没有写入这个序号的设备");
- break;
- case "-3":
- BaseUtil.ShowError("用户名或密码错误");
- break;
- case "-4":
- BaseUtil.ShowError("该序号还未写入设备");
- break;
- case "-5":
- BaseUtil.ShowError("未知错误");
- break;
- case "-6":
- BaseUtil.ShowError("装箱数量<=0");
- break;
- case "-7":
- BaseUtil.ShowError("该序号设备已经产生EN号");
- break;
- case "-8":
- BaseUtil.ShowError("该线体数据已包完");
- break;
- default:
- break;
- }
- 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)" +
- "values(ZTEDATA_seq.nextval,'" + SN + "','" + WholeDeviceCode + "','" + dev_en_no + "','" + iSN + "','" + makecode + "','彩盒机身标','','" + mac + "','" + mac_start + "','" + mac_end + "','" + reserve3 + "','" + en_no + "','" + device_type + "','" + reg_code + "')", "insert");
- return dev_en_no;
- }
- //获取外箱号信息
- public static void GetOutBoxInfo(string iBox)
- {
- dynamic obj = new ExpandoObject();
- var expandoDict = obj as IDictionary<string, object>;
- 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");
- string makecode = "";
- string po = "";
- string notype = "";
- for (int i = 0; i < dt.Rows.Count; i++)
- {
- string enNoKey = $"en_no{i}";
- string enNoValue = dt.Rows[i]["ZD_DEV_EN_NO"].ToString();
- expandoDict[enNoKey] = enNoValue;
- makecode = dt.Rows[i]["pd_makecode"].ToString();
- po = dt.Rows[i]["po_sn"].ToString();
- notype = dt.Rows[i]["NOTYPE"].ToString();
- }
- obj.request = "Q_wai_xiang";
- obj.packing_num = dt.Rows.Count;
- obj.User = "mes";
- obj.po_sn = po;
- obj.password = "258456";
- obj.tool_name = "zte";
- obj.noType = notype;
- if (po == "")
- {
- BaseUtil.ShowError("工单未维护客户PO号,不允许执行该操作");
- }
- string json = JsonConvert.SerializeObject(obj, Formatting.Indented);
- string returnstr = ToServerReq(json);
- dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + json + "',sysdate,'GetOutBoxInfo')", "insert");
- var settings = new JsonSerializerSettings
- {
- Converters = new List<JsonConverter> { new DeviceInfoConverter() }
- };
- DeviceInfo deviceInfo = JsonConvert.DeserializeObject<DeviceInfo>(returnstr, settings);
- //将返回的信息存入数据库
- for (int i = 0; i < deviceInfo.DSN.Count; i++)
- {
- if (dh.CheckExist("ZTEDATA", "zd_sn='" + deviceInfo.DSN[i] + "' and zd_makecode='" + makecode + "' and zd_type='BOX'"))
- {
- dh.ExecuteSql("delete from ZTEDATA where zd_sn='" + deviceInfo.DSN[i] + "' and zd_makecode='" + makecode + "' and zd_type='BOX'", "delete");
- }
- 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, " +
- "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)" +
- "values(ZTEDATA_seq.nextval,'" + deviceInfo.DSN[i] + "','" + makecode + "','BOX','" + deviceInfo.DSN[i] + "','" + deviceInfo.ProductMode + "','" + deviceInfo.ProductName + "','" + deviceInfo.MaterialCode + "','" + deviceInfo.BatchNo + "','" + deviceInfo.SoftVersion + "','" + deviceInfo.HdVersion + "'," +
- "'" + deviceInfo.Voltage + "','" + deviceInfo.Power + "','" + deviceInfo.OrderNo + "','" + deviceInfo.BigBoxNo + "','" + deviceInfo.DSN[i] + "'," +
- "'" + deviceInfo.DevEnNo[i] + "', '" + deviceInfo.Reserve3[i] + "','" + deviceInfo.DeviceId[i] + "','" + deviceInfo.MacStart[i] + "','" + deviceInfo.MacEnd[i] + "','" + deviceInfo.ProductionDate + "',sysdate)", "insert");
- }
- dh.ExecuteSql("update package set pa_zxcode ='" + deviceInfo.BigBoxNo + "' where pa_outboxcode='" + iBox + "'", "update");
- if (returnstr.Length > 1000)
- {
- returnstr = returnstr.Substring(0, 1000);
- }
- dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + returnstr + "',sysdate,'GetOutBoxInfo')", "insert");
- }
- public static void GetOutBoxInfoYLF(string iBox)
- {
- dynamic obj = new ExpandoObject();
- var expandoDict = obj as IDictionary<string, object>;
- 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");
- string makecode = "";
- string po = "";
- string notype = "";
- for (int i = 0; i < dt.Rows.Count; i++)
- {
- string enNoKey = $"en_no{i}";
- string enNoValue = dt.Rows[i]["ZD_D_SN"].ToString();
- expandoDict[enNoKey] = enNoValue;
- makecode = dt.Rows[i]["pd_makecode"].ToString();
- po = dt.Rows[i]["po_sn"].ToString();
- notype = dt.Rows[i]["NOTYPE"].ToString();
- }
- obj.request = "Q_wai_xiang";
- obj.packing_num = dt.Rows.Count;
- obj.User = "mes";
- obj.po_sn = po;
- obj.password = "258456";
- obj.tool_name = "zte";
- obj.noType = notype;
- if (po == "")
- {
- BaseUtil.ShowError("工单未维护客户PO号,不允许执行该操作");
- }
- string json = JsonConvert.SerializeObject(obj, Formatting.Indented);
- string returnstr = ToServerReq(json);
- dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + json + "',sysdate,'GetOutBoxInfo')", "insert");
- var settings = new JsonSerializerSettings
- {
- Converters = new List<JsonConverter> { new DeviceInfoConverter() }
- };
- DeviceInfo deviceInfo = JsonConvert.DeserializeObject<DeviceInfo>(returnstr, settings);
- //将返回的信息存入数据库
- for (int i = 0; i < deviceInfo.DSN.Count; i++)
- {
- if (dh.CheckExist("ZTEDATA", "zd_sn='" + deviceInfo.DSN[i] + "' and zd_makecode='" + makecode + "' and zd_type='BOX'"))
- {
- dh.ExecuteSql("delete from ZTEDATA where zd_sn='" + deviceInfo.DSN[i] + "' and zd_makecode='" + makecode + "' and zd_type='BOX'", "delete");
- }
- 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, " +
- "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)" +
- "values(ZTEDATA_seq.nextval,'" + deviceInfo.DSN[i] + "','" + makecode + "','BOX','" + deviceInfo.DSN[i] + "','" + deviceInfo.ProductMode + "','" + deviceInfo.ProductName + "','" + deviceInfo.MaterialCode + "','" + deviceInfo.BatchNo + "','" + deviceInfo.SoftVersion + "','" + deviceInfo.HdVersion + "'," +
- "'" + deviceInfo.Voltage + "','" + deviceInfo.Power + "','" + deviceInfo.OrderNo + "','" + deviceInfo.BigBoxNo + "','" + deviceInfo.DSN[i] + "'," +
- "'" + deviceInfo.DevEnNo[i] + "', '" + deviceInfo.Reserve3[i] + "','" + deviceInfo.DeviceId[i] + "','" + deviceInfo.MacStart[i] + "','" + deviceInfo.MacEnd[i] + "','" + deviceInfo.ProductionDate + "',sysdate)", "insert");
- }
- dh.ExecuteSql("update package set pa_zxcode ='" + deviceInfo.BigBoxNo + "' where pa_outboxcode='" + iBox + "'", "update");
- if (returnstr.Length > 1000)
- {
- returnstr = returnstr.Substring(0, 1000);
- }
- dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + returnstr + "',sysdate,'GetOutBoxInfo')", "insert");
- }
- //获取栈板信息
- public static void GetPalletInfo(string iBox)
- {
- 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");
- dynamic obj = new ExpandoObject();
- var expandoDict = obj as IDictionary<string, object>;
- string po = "";
- string makecode = "";
- string linecode = "";
- for (int i = 0; i < dt.Rows.Count; i++)
- {
- string enNoKey = $"big_box_no{i}";
- string enNoValue = dt.Rows[i]["pa_zxcode"].ToString();
- expandoDict[enNoKey] = enNoValue;
- po = dt.Rows[i]["po_sn"].ToString();
- makecode = dt.Rows[i]["pa_makecode"].ToString();
- linecode = dt.Rows[i]["sc_linecode"].ToString();
- }
- obj.request = "pallet";
- obj.packing_num = dt.Rows.Count;
- obj.User = "mes";
- obj.po_sn = po;
- obj.password = "258456";
- obj.tool_name = "zte";
- obj.mes_po = makecode;
- obj.line_code = linecode;
- if (po == "")
- {
- BaseUtil.ShowError("工单未维护客户PO号,不允许执行该操作");
- }
- string json = JsonConvert.SerializeObject(obj, Formatting.Indented);
- dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + json + "',sysdate,'GetPalletInfo')", "insert");
- string returnstr = ToServerReq(json);
- JObject deviceObj = JObject.Parse(returnstr);
- string pallet_no = deviceObj["pallet_no"].ToString();
- string palltecode = deviceObj["palletNo"].ToString();
- dh.ExecuteSql("update package set pa_zxcode ='" + palltecode + "',pa_detno='" + pallet_no + "' where pa_outboxcode='" + iBox + "'", "update");
- if (returnstr.Length > 1000)
- {
- returnstr = returnstr.Substring(0, 1000);
- }
- dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + returnstr + "',sysdate,'GetPalletInfo')", "insert");
- }
- public static void SendPowerCode(string iSN)
- {
- 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");
- dynamic obj = new ExpandoObject();
- var expandoDict = obj as IDictionary<string, object>;
- string part_sn = "";
- string part_ar = "";
- string SN = "";
- string notype = "";
- for (int i = 0; i < dt.Rows.Count; i++)
- {
- if (dt.Rows[i]["pr_detail"].ToString().Contains("电源"))
- {
- part_sn = dt.Rows[i]["cm_barcode"].ToString();
- }
- if (dt.Rows[i]["pr_detail"].ToString().Contains("报警器"))
- {
- part_ar = dt.Rows[i]["cm_barcode"].ToString();
- }
- SN = dt.Rows[i]["ms_code"].ToString();
- notype = dt.Rows[i]["notype"].ToString();
- }
- obj.request = "bindSN";
- obj.noType = notype;
- obj.User = "test";
- obj.password = "123456";
- obj.tool_name = "zte";
- obj.part_sn = part_sn;
- obj.part_ar = part_ar;
- obj.SN = SN;
- string json = JsonConvert.SerializeObject(obj, Formatting.Indented);
- dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + json + "',sysdate,'SendPowerCode')", "insert");
- string returnstr = ToServerReq(json);
- if (returnstr.Length > 1000)
- {
- returnstr = returnstr.Substring(0, 1000);
- }
- dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + returnstr + "',sysdate,'SendPowerCode')", "insert");
- }
- public static async void SendBoxDataYS(string iBox)
- {
- 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");
- var root = new RootObjectYS
- {
- nub = iBox,
- login_key = "PRD90904837",
- ebeln = dt.Rows[0]["ma_custpo"].ToString(),
- ebelp = dt.Rows[0]["ma_custpodetno"].ToString(),
- pkcde = iBox,
- brgew = 0,
- mak01 = "mak01",
- BindList = new List<BindItemYS>()
- };
- dt = (DataTable)dh.ExecuteSql("select pd_barcode from packagedetail where pd_outboxcode='" + iBox + "' order by pd_barcode", "select");
- for (int i = 0; i < dt.Rows.Count; i++)
- {
- root.BindList.Add(new BindItemYS
- {
- barcd = dt.Rows[i]["pd_barcode"].ToString()
- });
- }
- var httpClientHandler = new HttpClientHandler();
- httpClientHandler.ServerCertificateCustomValidationCallback = (message, cert, chain, errors) => { return true; };
- using (var client = new HttpClient(httpClientHandler))
- {
- StringBuilder sbText = new StringBuilder();
- string json = JsonConvert.SerializeObject(root, Formatting.Indented);
- var content = new StringContent(json, Encoding.UTF8, "application/json");
- await Console.Out.WriteLineAsync(json);
- try
- {
- var response = await client.PostAsync("https://xi.hikvision.com:8850/RESTAdapter/outsourcing/CALLBACKPACKINGINFO", content);
- if (response.IsSuccessStatusCode)
- {
- string returnstr = await response.Content.ReadAsStringAsync();
- JObject deviceObj = JObject.Parse(returnstr);
- string code = deviceObj["code"]["code"].ToString();
- string msg = deviceObj["code"]["msg"].ToString();
- if (code == "0000")
- {
- dh.ExecuteSql("update packagedetail set pd_issuccess=-1 where pd_outboxcode='" + iBox + "'", "update");
- dh.ExecuteSql("update package set pa_issuccess=-1 where pa_outboxcode='" + iBox + "'", "update");
- //MessageBox.Show(ZD_BIG_BOX_NO + "上传星云成功");
- }
- else
- {
- dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + msg + "',sysdate,'SendBoxData')", "insert");
- MessageBox.Show(msg);
- }
- }
- else
- {
- BaseUtil.ShowError(response.StatusCode.ToString());
- }
- }
- catch (Exception ex)
- {
- dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + ex.Message + "',sysdate,'SendBoxData')", "insert");
- }
- }
- }
- //发送外箱号数据,打印前获取
- public static async void SendBoxData(string iBox)
- {
- 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();
- 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");
- string PRODUCT_MODE = "";
- string po_sn = "";
- string pr_code = "";
- string ZD_BIG_BOX_NO = "";
- if (dt.Rows.Count > 0)
- {
- PRODUCT_MODE = dt.Rows[0]["PRODUCT_MODE"].ToString();
- po_sn = dt.Rows[0]["batch_no"].ToString();
- pr_code = dt.Rows[0]["pr_code"].ToString();
- ZD_BIG_BOX_NO = dt.Rows[0]["ZD_BIG_BOX_NO"].ToString();
- }
- var root = new RootObject
- {
- ProductModuleType = "整机",
- ProductMainClass = "固网_CPE",
- ProductMediumClass = "CPE",
- ProductSubClass = PRODUCT_MODE,
- Task = po_sn,
- ProcessType = "生产过程",
- UserId = User.UserName,
- BindList = new List<BindItem>()
- };
- root.BindList.Add(new BindItem
- {
- BindKey = "cartonSn",
- BindValue = ZD_BIG_BOX_NO,
- KeyType = "macbox",
- KeyValue = sn,
- HashType = "SHA256",
- HashKey = ComputeSha256Hash(sn)
- });
- 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");
- 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");
- for (int i = 0; i < dt.Rows.Count; i++)
- {
- for (int j = 0; j < dt1.Rows.Count; j++)
- {
- if (dt1.Rows[j]["pid_valuetype"].ToString() == "SHA256")
- {
- root.BindList.Add(new BindItem
- {
- BindKey = "mac",
- BindValue = dt.Rows[i]["ZD_MAC_START"].ToString(),
- KeyType = dt1.Rows[j]["pid_item"].ToString(),
- KeyValue = dt1.Rows[j]["pid_item"].ToString(),
- HashType = "SHA256",
- HashKey = ComputeSha256Hash(sn),
- });
- }
- else
- {
- string sql = dt1.Rows[j]["pid_sql"].ToString();
- string value = "";
- if (sql != "")
- {
- Regex ConnoteA = new Regex("{\\w+}");
- foreach (Match mch in ConnoteA.Matches(sql))
- {
- string x = mch.Value.Trim();
- sql = sql.Replace(x, "'" + dt.Rows[i]["pd_barcode"].ToString() + "'");
- }
- DataTable Param = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
- if (Param.Rows.Count > 0)
- {
- value = Param.Rows[0][0].ToString();
- }
- }
- else
- {
- value = dt1.Rows[j]["pid_value"].ToString();
- }
- root.BindList.Add(new BindItem
- {
- BindKey = "mac",
- BindValue = dt.Rows[i]["ZD_MAC_START"].ToString(),
- KeyType = dt1.Rows[j]["pid_item"].ToString(),
- KeyValue = value,
- HashType = "NON-HASH",
- HashKey = value,
- });
- }
- }
- }
- var httpClientHandler = new HttpClientHandler();
- httpClientHandler.ServerCertificateCustomValidationCallback = (message, cert, chain, errors) => { return true; };
- using (var client = new HttpClient(httpClientHandler))
- {
- client.DefaultRequestHeaders.Add("apikey", "60e7107a86284a6d842e551704e69253");
- client.DefaultRequestHeaders.Add("AppCode", "91678314583d4c2bbf185bc5573ac73d");
- StringBuilder sbText = new StringBuilder();
- string json = JsonConvert.SerializeObject(root, Formatting.Indented);
- var content = new StringContent(json, Encoding.UTF8, "application/json");
- await Console.Out.WriteLineAsync(json);
- try
- {
- var response = await client.PostAsync("https://172.30.30.10:29001/api/mds-web-outservice/v1/api/rest/mds/saveFmKeyHashcodeInfoBatch", content);
- if (response.IsSuccessStatusCode)
- {
- string returnstr = await response.Content.ReadAsStringAsync();
- JObject deviceObj = JObject.Parse(returnstr);
- string code = deviceObj["code"]["code"].ToString();
- string msg = deviceObj["code"]["msg"].ToString();
- if (code == "0000")
- {
- dh.ExecuteSql("update packagedetail set pd_issuccess=-1 where pd_outboxcode='" + iBox + "'", "update");
- dh.ExecuteSql("update package set pa_issuccess=-1 where pa_outboxcode='" + iBox + "'", "update");
- //MessageBox.Show(ZD_BIG_BOX_NO + "上传星云成功");
- }
- else
- {
- dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + msg + "',sysdate,'SendBoxData')", "insert");
- MessageBox.Show(msg);
- }
- }
- else
- {
- BaseUtil.ShowError(response.StatusCode.ToString());
- }
- }
- catch (Exception ex)
- {
- dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + ex.Message + "',sysdate,'SendBoxData')", "insert");
- }
- }
- }
- public static string GetMingPai_Thailand(string iSN)
- {
- 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");
- string po = "";
- string makecode = "";
- string ms_id = "";
- if (dt.Rows.Count > 0)
- {
- po = dt.Rows[0]["po_sn"].ToString();
- makecode = dt.Rows[0]["ms_makecode"].ToString();
- ms_id = dt.Rows[0]["ms_id"].ToString();
- }
- dynamic obj = new ExpandoObject();
- obj.tool_name = "zte";
- obj.request = "ajc_mingpai";
- obj.User = "1453";
- obj.password = "12345678";
- obj.po_sn = po;
- obj.product_id = iSN;
- if (po == "")
- {
- BaseUtil.ShowError("工单未维护客户PO号,不允许执行该操作");
- }
- string json = JsonConvert.SerializeObject(obj, Formatting.Indented);
- dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + json + "',sysdate,'GETEN_THA')", "insert");
- string returnstr = ToServerReq(json);
- JObject deviceObj = JObject.Parse(returnstr);
- string tool_name = deviceObj["tool_name"].ToString();
- string response = deviceObj["response"].ToString();
- string sn = deviceObj["sn"].ToString();
- string status = deviceObj["status"].ToString();
- string product_id = deviceObj["product_id"].ToString();
- string dev_mac = deviceObj["dev_mac"].ToString();
- string wifi_mac = deviceObj["wifi_mac"].ToString();
- string en = deviceObj["en"].ToString();
- string en_prefix = deviceObj["en_prefix"].ToString();
- string product_name = deviceObj["product_name"].ToString();
- string vendor = deviceObj["vendor"].ToString();
- string esim_iccid = deviceObj["esim_iccid"].ToString();
- string exsim_iccid = deviceObj["exsim_iccid"].ToString();
- string fg_ver = deviceObj["4g_ver"].ToString();
- string fg_type = deviceObj["4g_type"].ToString();
- if (dh.CheckExist("ZTEDATA", "zd_sn='" + iSN + "' and zd_makecode='" + makecode + "' and zd_type='铭牌标'"))
- {
- dh.ExecuteSql("delete from ZTEDATA where zd_sn='" + iSN + "' and zd_makecode='" + makecode + "' and zd_type='铭牌标'", "delete");
- }
- dh.ExecuteSql("update makeserial set ms_sncode='" + sn + "' where ms_id='" + ms_id + "'", "update");
- 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)" +
- "values(ZTEDATA_seq.nextval,'" + vendor + "','" + sn + "','" + sn + "','" + iSN + "','" + makecode + "','铭牌标','','" + wifi_mac + "'" +
- ",'" + en + "','" + product_name + "')", "insert");
- dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + returnstr + "',sysdate,'GETEN_THA')", "insert");
- return sn;
- }
- public static string GetCaiHe_Thailand(string iSN)
- {
- 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");
- string po = "";
- string makecode = "";
- string ms_id = "";
- if (dt.Rows.Count > 0)
- {
- po = dt.Rows[0]["po_sn"].ToString();
- makecode = dt.Rows[0]["ms_makecode"].ToString();
- ms_id = dt.Rows[0]["ms_id"].ToString();
- }
- dynamic obj = new ExpandoObject();
- obj.tool_name = "zte";
- obj.request = "ajc_cai_he";
- obj.User = "1453";
- obj.password = "12345678";
- obj.po_sn = po;
- obj.product_id = iSN;
- if (po == "")
- {
- BaseUtil.ShowError("工单未维护客户PO号,不允许执行该操作");
- }
- string json = JsonConvert.SerializeObject(obj, Formatting.Indented);
- dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + json + "',sysdate,'GETEN_THA')", "insert");
- string returnstr = ToServerReq(json);
- JObject deviceObj = JObject.Parse(returnstr);
- string tool_name = deviceObj["tool_name"].ToString();
- string response = deviceObj["response"].ToString();
- string sn = deviceObj["sn"].ToString();
- string status = deviceObj["status"].ToString();
- string product_id = deviceObj["product_id"].ToString();
- string dev_mac = deviceObj["dev_mac"].ToString();
- string wifi_mac = deviceObj["wifi_mac"].ToString();
- string en = deviceObj["en"].ToString();
- if (dh.CheckExist("ZTEDATA", "zd_sn='" + iSN + "' and zd_makecode='" + makecode + "' and zd_type='彩盒标'"))
- {
- dh.ExecuteSql("delete from ZTEDATA where zd_sn='" + iSN + "' and zd_makecode='" + makecode + "' and zd_type='彩盒标'", "delete");
- }
- dh.ExecuteSql("update makeserial set ms_sncode='" + sn + "' where ms_id='" + ms_id + "'", "update");
- 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)" +
- "values(ZTEDATA_seq.nextval,'" + sn + "','" + sn + "','" + iSN + "','" + makecode + "','彩盒标','','" + wifi_mac + "'" +
- ",'" + en + "')", "insert");
- dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + returnstr + "',sysdate,'GETEN_THA')", "insert");
- return sn;
- }
- public static void GetOutBoxInf_Thailand(string iBox)
- {
- dynamic obj = new ExpandoObject();
- var expandoDict = obj as IDictionary<string, object>;
- 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");
- string makecode = "";
- string po = "";
- int notype = 0;
- int PACKING_NUM = 0;
- for (int i = 0; i < dt.Rows.Count; i++)
- {
- string enNoKey = $"sn{i}";
- string enNoValue = dt.Rows[i]["ZD_DEV_EN_NO"].ToString();
- expandoDict[enNoKey] = enNoValue;
- makecode = dt.Rows[i]["pd_makecode"].ToString();
- po = dt.Rows[i]["ma_custpo"].ToString();
- notype = int.Parse(dt.Rows[i]["notype"].ToString());
- PACKING_NUM = int.Parse(dt.Rows[i]["PACKING_NUM"].ToString());
- }
- obj.request = "ajc_wai_xiang";
- obj.packing_num = PACKING_NUM;
- obj.User = "test";
- obj.po_sn = po;
- obj.password = "123456";
- obj.tool_name = "AJC";
- obj.noType = notype;
- if (po == "")
- {
- BaseUtil.ShowError("工单未维护客户PO号,不允许执行该操作");
- }
- string json = JsonConvert.SerializeObject(obj, Formatting.Indented);
- string returnstr = ToServerReq(json);
- dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + json + "',sysdate,'GetOutBoxInfo')", "insert");
- var settings = new JsonSerializerSettings
- {
- Converters = new List<JsonConverter> { new DeviceInfoConverter() }
- };
- Thailand deviceInfo = JsonConvert.DeserializeObject<Thailand>(returnstr, settings);
- //将返回的信息存入数据库
- for (int i = 0; i < deviceInfo.product_id.Count; i++)
- {
- if (dh.CheckExist("ZTEDATA", "zd_sn='" + deviceInfo.product_id[i] + "' and zd_makecode='" + makecode + "' and zd_type='BOX'"))
- {
- dh.ExecuteSql("delete from ZTEDATA where zd_sn='" + deviceInfo.product_id[i] + "' and zd_makecode='" + makecode + "' and zd_type='BOX'", "delete");
- }
- dh.ExecuteSql("insert into ZTEDATA(ZD_ID,ZD_SN, ZD_MAKECODE, ZD_TYPE,ZD_product_mode, ZD_PRODUCTNAME, " +
- "ZD_ORDER_NO, ZD_BIG_BOX_NO, ZD_D_SN, ZD_DEV_EN_NO,ZD_DEVICEID,zd_custom ,ZD_INDATE)" +
- "values(ZTEDATA_seq.nextval,'" + deviceInfo.sn[i] + "','" + makecode + "','BOX','" + deviceInfo.ProductMode + "','" + deviceInfo.ProductName + "'," +
- ",'" + deviceInfo.OrderNum + "','" + deviceInfo.BigBoxNo + "','" + deviceInfo.sn[i] + "','" + deviceInfo.en[i] + "','" + deviceInfo.product_id[i] + "','Thailand'," +
- ",sysdate)", "insert");
- }
- dh.ExecuteSql("update package set pa_zxcode ='" + deviceInfo.BigBoxNo + "' where pa_outboxcode='" + iBox + "'", "update");
- if (returnstr.Length > 1000)
- {
- returnstr = returnstr.Substring(0, 1000);
- }
- dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + returnstr + "',sysdate,'GetOutBoxInfo')", "insert");
- }
- public static readonly uint PROTOCOL_FLAG = 0x4C4F4F54;
- public static string ToServerReq(string strJSON)
- {
- int nRet = 0;
- string strServerIP = "192.168.1.160";
- string strResp = "";
- IPAddress ip = IPAddress.Parse(strServerIP);
- Socket clientSocket = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp);
- while (true)
- {
- try
- {
- clientSocket.Connect(new IPEndPoint(ip, SN_SERVICE_PORT));
- }
- catch
- {
- nRet = -13;
- break;
- }
- try
- {
- FACT_DATA_HEAD stHead = new FACT_DATA_HEAD(null);
- byte[] bytJson = Encoding.UTF8.GetBytes(strJSON); //Encoding.ASCII.GetBytes(strJSON);
- stHead.setDataLen(bytJson.Length);
- byte[] bytBuf = new byte[FACT_DATA_HEAD.MY_LEN + bytJson.Length];
- byte[] bytSrcHead = stHead.getBytes();
- Array.Copy(bytSrcHead, 0, bytBuf, 0, bytSrcHead.Length);
- Array.Copy(bytJson, 0, bytBuf, FACT_DATA_HEAD.MY_LEN, bytJson.Length);
- clientSocket.Send(bytBuf);
- }
- catch
- {
- nRet = -12;
- break;
- }
- //判定接口回传的flag和本地传过去的是否一致
- byte[] bytRecv = new byte[MAX_BUF_SIZE];
- int nRecvSize = 0, nSize = 0;
- nRecvSize = clientSocket.Receive(bytRecv, 0, FACT_DATA_HEAD.MY_LEN, SocketFlags.None);
- if (nRecvSize > 0)
- {
- FACT_DATA_HEAD stHead = new FACT_DATA_HEAD(bytRecv);
- if (stHead.getFlag() == FACT_DATA_HEAD.PROTOCOL_FLAG)
- {
- int nPos = 0;
- nSize = stHead.getDatalen();
- while (nPos < nSize)
- {
- nRecvSize = clientSocket.Receive(bytRecv, nPos, nSize - nPos, SocketFlags.None);
- if (nRecvSize < 0)
- {
- nRet = -14;
- break;
- }
- nPos += nRecvSize;
- }
- strResp = Encoding.Default.GetString(bytRecv, 0, nSize);
- }
- else nRet = -11;
- }
- else nRet = -10;
- break;
- }
- if (nRet > -13) clientSocket.Shutdown(SocketShutdown.Both);
- clientSocket.Close();
- return strResp;
- }
- }
- }
|