mes-client/UAS_MES_HYSX/PublicMethod/HttpServer.cs

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.Threading.Tasks;
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; }

        [JsonProperty("OrderNum")]
        public string OrderNum { 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 List<string> Reserve11 { get; set; } = new List<string>();
        public List<string> Reserve12 { get; set; } = new List<string>();
        public List<string> Reserve13 { get; set; } = new List<string>();
        public List<string> Reserve14 { get; set; } = new List<string>();
        public List<string> Reserve15 { get; set; } = new List<string>();
        public List<string> Reserve16 { get; set; } = new List<string>();
        public List<string> Reserve17 { get; set; } = new List<string>();
        public List<string> Reserve18 { get; set; } = new List<string>();
        public List<string> Reserve19 { get; set; } = new List<string>();
        public List<string> Reserve20 { get; set; } = new List<string>();
        public List<string> Reserve21 { get; set; } = new List<string>();
        public List<string> Reserve22 { get; set; } = new List<string>();
        public List<string> product_id { get; set; } = new List<string>();
        public List<string> sn { get; set; } = new List<string>();
        public List<string> en { 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;
                }
            }

            index = 0;
            while (true)
            {
                string key = $"reserve11_{index}";
                if (jsonObject.TryGetValue(key, out JToken value))
                {
                    deviceInfo.Reserve11.Add(value.ToString());
                    index++;
                }
                else
                {
                    break;
                }
            }

            index = 0;
            while (true)
            {
                string key = $"reserve12_{index}";
                if (jsonObject.TryGetValue(key, out JToken value))
                {
                    deviceInfo.Reserve12.Add(value.ToString());
                    index++;
                }
                else
                {
                    break;
                }
            }

            index = 0;
            while (true)
            {
                string key = $"reserve13_{index}";
                if (jsonObject.TryGetValue(key, out JToken value))
                {
                    deviceInfo.Reserve13.Add(value.ToString());
                    index++;
                }
                else
                {
                    break;
                }
            }

            index = 0;
            while (true)
            {
                string key = $"reserve14_{index}";
                if (jsonObject.TryGetValue(key, out JToken value))
                {
                    deviceInfo.Reserve14.Add(value.ToString());
                    index++;
                }
                else
                {
                    break;
                }
            }

            index = 0;
            while (true)
            {
                string key = $"reserve15_{index}";
                if (jsonObject.TryGetValue(key, out JToken value))
                {
                    deviceInfo.Reserve15.Add(value.ToString());
                    index++;
                }
                else
                {
                    break;
                }
            }

            index = 0;
            while (true)
            {
                string key = $"reserve16_{index}";
                if (jsonObject.TryGetValue(key, out JToken value))
                {
                    deviceInfo.Reserve16.Add(value.ToString());
                    index++;
                }
                else
                {
                    break;
                }
            }

            index = 0;
            while (true)
            {
                string key = $"reserve17_{index}";
                if (jsonObject.TryGetValue(key, out JToken value))
                {
                    deviceInfo.Reserve17.Add(value.ToString());
                    index++;
                }
                else
                {
                    break;
                }
            }

            index = 0;
            while (true)
            {
                string key = $"reserve18_{index}";
                if (jsonObject.TryGetValue(key, out JToken value))
                {
                    deviceInfo.Reserve18.Add(value.ToString());
                    index++;
                }
                else
                {
                    break;
                }
            }

            index = 0;
            while (true)
            {
                string key = $"reserve19_{index}";
                if (jsonObject.TryGetValue(key, out JToken value))
                {
                    deviceInfo.Reserve19.Add(value.ToString());
                    index++;
                }
                else
                {
                    break;
                }
            }

            index = 0;
            while (true)
            {
                string key = $"reserve20_{index}";
                if (jsonObject.TryGetValue(key, out JToken value))
                {
                    deviceInfo.Reserve20.Add(value.ToString());
                    index++;
                }
                else
                {
                    break;
                }
            }
            index = 0;
            while (true)
            {
                string key = $"reserve21_{index}";
                if (jsonObject.TryGetValue(key, out JToken value))
                {
                    deviceInfo.Reserve21.Add(value.ToString());
                    index++;
                }
                else
                {
                    break;
                }
            }

            index = 0;
            while (true)
            {
                string key = $"reserve22_{index}";
                if (jsonObject.TryGetValue(key, out JToken value))
                {
                    deviceInfo.Reserve22.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;
                }
            }

            index = 0;
            while (true)
            {
                string key = $"product_id{index}";
                if (jsonObject.TryGetValue(key, out JToken value))
                {
                    deviceInfo.product_id.Add(value.ToString());
                    index++;
                }
                else
                {
                    break;
                }
            }

            index = 0;
            while (true)
            {
                string key = $"sn{index}";
                if (jsonObject.TryGetValue(key, out JToken value))
                {
                    deviceInfo.sn.Add(value.ToString());
                    index++;
                }
                else
                {
                    break;
                }
            }

            index = 0;
            while (true)
            {
                string key = $"en{index}";
                if (jsonObject.TryGetValue(key, out JToken value))
                {
                    deviceInfo.en.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 = 32784;
        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();
            string dev_para = deviceObj["dev_para"].ToString();
            string reserve9 = deviceObj["reserve9"].ToString();
            string reserve10 = deviceObj["reserve10"].ToString();
            string reserve11 = deviceObj["reserve11"].ToString();
            string reserve12 = deviceObj["reserve12"].ToString();
            string reserve13 = deviceObj["reserve13"].ToString();
            string reserve14 = deviceObj["reserve14"].ToString();
            string reserve15 = deviceObj["reserve15"].ToString();
            string reserve16 = deviceObj["reserve16"].ToString();
            string reserve17 = deviceObj["reserve17"].ToString();
            string reserve18 = deviceObj["reserve18"].ToString();
            string reserve19 = deviceObj["reserve19"].ToString();
            string reserve20 = deviceObj["reserve20"].ToString();
            string reserve21 = deviceObj["reserve21"].ToString();
            string reserve22 = deviceObj["reserve22"].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":
                    if (dev_en_no == "")
                    {
                        BaseUtil.ShowError("该序号已入库");
                    }
                    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,ZD_RESERVE9,ZD_RESERVE10,ZD_RESERVE11, ZD_RESERVE12, ZD_RESERVE13, ZD_RESERVE14, ZD_RESERVE15, ZD_RESERVE16, ZD_RESERVE17, ZD_RESERVE18, ZD_RESERVE19, ZD_RESERVE20, ZD_RESERVE21,ZD_RESERVE22,zd_dev_para)" +
                "values(ZTEDATA_seq.nextval,'" + SN + "','" + WholeDeviceCode + "','" + dev_en_no + "','" + iSN + "','" + makecode + "','彩盒机身标','','" + mac + "','" + mac_start + "','" + mac_end + "','" + reserve3 + "','" + en_no + "','" + device_type + "','" + reg_code + "','" + reserve9 + "','" + reserve10 + "','" + reserve11 + "','" + reserve12 + "','" + reserve13 + "','" + reserve14 + "','" + reserve15 + "','" + reserve16 + "','" + reserve17 + "','" + reserve18 + "','" + reserve19 + "','" + reserve20 + "','" + reserve21 + "','" + reserve22 + "','" + dev_para + "')", "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 ZD_D_SN,nvl(NOTYPE,0)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 = "";
            int notype = 0;
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                string enNoKey = $"en_no{i}";
                string enNoValue = "";
                if (int.Parse(dt.Rows[i]["NOTYPE"].ToString()) == 0)
                {
                    enNoValue = dt.Rows[i]["ZD_DEV_EN_NO"].ToString();
                }
                else if (int.Parse(dt.Rows[i]["NOTYPE"].ToString()) == 4)
                {
                    enNoValue = dt.Rows[i]["ZD_D_SN"].ToString();
                }
                else
                {
                    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 = int.Parse(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);
            if (deviceInfo.DSN.Count == 0)
            {
                BaseUtil.ShowError("获取数据异常，不允许执行该操作");
            }

            //将返回的信息存入数据库
            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,ZD_RESERVE11, ZD_RESERVE12, ZD_RESERVE13, ZD_RESERVE14, ZD_RESERVE15, ZD_RESERVE16, ZD_RESERVE17, ZD_RESERVE18, ZD_RESERVE19, ZD_RESERVE20, ZD_RESERVE21,ZD_RESERVE22)" +
                    "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,'" + deviceInfo.Reserve11[i] + "','" + deviceInfo.Reserve12[i] + "','" + deviceInfo.Reserve13[i] + "'" +
                    ",'" + deviceInfo.Reserve14[i] + "','" + deviceInfo.Reserve15[i] + "','" + deviceInfo.Reserve16[i] + "','" + deviceInfo.Reserve17[i] + "','" + deviceInfo.Reserve18[i] + "','" + deviceInfo.Reserve19[i] + "','" + deviceInfo.Reserve20[i] + "','" + deviceInfo.Reserve21[i] + "','" + deviceInfo.Reserve22[i] + "')", "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 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");
            string makecode = "";
            string po = "";
            int notype = 0;
            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 = int.Parse(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 = User.UserLineCode;
            }
            if (po == "")
            {
                BaseUtil.ShowError("工单未维护客户PO号，不允许执行该操作");
            }
            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,ZD_D_SN,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 ztedata on zd_makecode=cm_makecode and cm_sncode=ZD_DEV_EN_NO   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]["ZD_D_SN"].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("update craftmaterial set cm_ifupload=-1 where cm_sncode='" + iSN + "'", "update");
            dh.ExecuteSql("insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE)values(EISDATA_seq.nextval,'" + returnstr + "',sysdate,'SendPowerCode')", "insert");
        }

        public static async Task SendPowerCodeAsync(string iSN)
        {
            try
            {
                // 异步执行数据库查询
                DataTable dt = await Task.Run(() =>
                    (DataTable)dh.ExecuteSql(
                        "select NOTYPE,cm_barcode,pr_detail,pr_spec,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_spec"].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);

                // 异步执行插入操作
                await Task.Run(() =>
                    dh.ExecuteSql(
                        "insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE) " +
                        "values(EISDATA_seq.nextval,'" + json.Replace("'", "''") + "',sysdate,'SendPowerCode')",
                        "insert")
                    );
                dh.ExecuteSql("update craftmaterial set cm_ifupload=-1 where cm_sncode='" + iSN + "'", "update");
                // 异步发送请求（假设ToServerReq可以被异步化）
                string returnstr = await ToServerReqAsync(json); // 需要实现异步版本

                if (returnstr.Length > 1000)
                {
                    returnstr = returnstr.Substring(0, 1000);
                }

                // 异步执行第二次插入操作
                await Task.Run(() =>
                    dh.ExecuteSql(
                        "insert into EISDATA(ED_ID, ED_DATA, ED_INDATE, ED_TYPE) " +
                        "values(EISDATA_seq.nextval,'" + returnstr.Replace("'", "''") + "',sysdate,'SendPowerCode')",
                        "insert"));
            }
            catch (Exception ex)
            {
                // 记录异常
                Console.WriteLine($"SendPowerCodeAsync error: {ex.Message}");
                throw;
            }
        }

        private static async Task<string> ToServerReqAsync(string json)
        {
            // 这里需要根据实际的ToServerReq实现改为异步
            // 例如，如果是HTTP请求：
            // using (var client = new HttpClient())
            // {
            //     var response = await client.PostAsync(url, new StringContent(json));
            //     return await response.Content.ReadAsStringAsync();
            // }

            // 如果原方法是同步的，可以这样包装：
            return await Task.Run(() => ToServerReq(json));
        }

        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");
            string username = "WST_HYSX";
            string password = "c5e^4{RSt}";
            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))
            {
                var authString = $"{username}:{password}";
                var base64Auth = Convert.ToBase64String(Encoding.UTF8.GetBytes(authString));
                client.DefaultRequestHeaders.Authorization =new System.Net.Http.Headers.AuthenticationHeaderValue("Basic", base64Auth);
                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");
                        }
                        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='30-00SC50L001'", "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 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 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]["ma_custpo"].ToString();
                makecode = dt.Rows[0]["ms_makecode"].ToString();
                ms_id = dt.Rows[0]["ms_id"].ToString();
            }
            dynamic obj = new ExpandoObject();
            obj.tool_name = "AJC";
            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();
            switch (status)
            {
                case "-1":
                        BaseUtil.ShowError("该序号已入库");
                    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;
            }
            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("insert into ZTEDATA(ZD_ID,ZD_D_SN,ZD_DEV_EN_NO,ZD_SN, ZD_MAKECODE, ZD_TYPE, ZD_VALUE,zd_mac,zd_enno)" +
               "values(ZTEDATA_seq.nextval,'" + product_id + "','" + product_id + "','" + 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 string GetMingPai_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  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]["ma_custpo"].ToString();
                makecode = dt.Rows[0]["ms_makecode"].ToString();
                ms_id = dt.Rows[0]["ms_id"].ToString();
            }
            dynamic obj = new ExpandoObject();
            obj.tool_name = "AJC";
            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 vendor = deviceObj["vendor"].ToString();
            string product_name = deviceObj["product_name"].ToString();
            string en = deviceObj["en"].ToString();
            string en_prefix = deviceObj["en_prefix"].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();
            switch (status)
            {
                case "-1":
                    BaseUtil.ShowError("该序号已入库");
                    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;
            }
            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("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," +
                "ZD_ESIMICCID, ZD_EXSIM_ICCID, ZD_4G_VER, ZD_4G_TYPE)" +
            "values(ZTEDATA_seq.nextval,'" + vendor + "','" + sn + "','" + product_id + "','" + iSN + "','" + makecode + "','彩盒标','','" + wifi_mac + "'" +
            ",'" + en + "','" + product_name + "','" + esim_iccid + "','" + exsim_iccid + "','" + fg_ver + "','" + fg_type + "')", "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(pr_outboxinnerqty,0)PACKING_NUM,nvl(notype,1)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 product on pr_code=ma_prodcode left join zte_order on batch_no=ma_custpo  where  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() }
            };

            DeviceInfo deviceInfo = JsonConvert.DeserializeObject<DeviceInfo>(returnstr, settings);
            if (deviceInfo.Status == -5)
            {
                BaseUtil.ShowError("未知错误，不允许操作");
            }
            //将返回的信息存入数据库
            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.88";
            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 (Exception ex)
                {
                    nRet = -13;
                    dh.ExecuteSql("insert into getdataerror(id,err,datetime)values(getdataerror_seq.nextval,'" + ex.Message + ex.StackTrace + "',sysdate)", "insert");
                    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 (Exception ex)
                {
                    nRet = -12;
                    dh.ExecuteSql("insert into getdataerror(id,err,datetime)values(getdataerror_seq.nextval,'" + ex.Message + ex.StackTrace + "',sysdate)", "insert");
                    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;
        }
    }
}