工艺路线：导入功能(包含子表)

duhe

2025-04-18 315b12766c0ea48059c79c48bc57f0d40c65438d

工艺路线：导入功能(包含子表)

 BLL/bin/Release/BLL.dll

Binary files differ

 BLL/bin/Release/BLL.pdb

Binary files differ

 BLL/bin/Release/DAL.dll

Binary files differ

 BLL/bin/Release/DAL.pdb

Binary files differ

 BLL/bin/Release/DBUtility.dll

Binary files differ

 BLL/bin/Release/DBUtility.pdb

Binary files differ

 BLL/bin/Release/Model.dll

Binary files differ

 BLL/bin/Release/Model.pdb

Binary files differ

 BLL/bin/Release/Pub_Class.dll

Binary files differ

 BLL/bin/Release/Pub_Class.pdb

Binary files differ

 BLL/bin/Release/Pub_Control.dll

Binary files differ

 BLL/bin/Release/Pub_Control.pdb

Binary files differ

 BLL/bin/Release/SQLHelper.dll

Binary files differ

 BLL/bin/Release/SQLHelper.pdb

Binary files differ

 DAL/bin/Release/DAL.dll

Binary files differ

 DAL/bin/Release/DAL.pdb

Binary files differ

 DAL/bin/Release/DBUtility.dll

Binary files differ

 DAL/bin/Release/DBUtility.pdb

Binary files differ

 DAL/bin/Release/Model.dll

Binary files differ

 DAL/bin/Release/Model.pdb

Binary files differ

 DAL/bin/Release/Pub_Class.dll

Binary files differ

 DAL/bin/Release/Pub_Class.pdb

Binary files differ

 DAL/bin/Release/Pub_Control.dll

Binary files differ

 DAL/bin/Release/Pub_Control.pdb

Binary files differ

 DAL/bin/Release/SQLHelper.dll

Binary files differ

 DAL/bin/Release/SQLHelper.pdb

Binary files differ

 DBUtility/bin/Release/DBUtility.dll

Binary files differ

 DBUtility/bin/Release/DBUtility.pdb

Binary files differ

 DBUtility/bin/Release/Pub_Class.dll

Binary files differ

 DBUtility/bin/Release/Pub_Class.pdb

Binary files differ

 DBUtility/bin/Release/Pub_Control.dll

Binary files differ

 DBUtility/bin/Release/Pub_Control.pdb

Binary files differ

 DBUtility/bin/Release/SQLHelper.dll

Binary files differ

 DBUtility/bin/Release/SQLHelper.pdb

Binary files differ

 DBUtility/obj/Release/DBUtility.csproj.AssemblyReference.cache

Binary files differ

 DBUtility/obj/Release/DBUtility.dll

Binary files differ

 DBUtility/obj/Release/DBUtility.pdb

Binary files differ

 Model/bin/Release/DBUtility.dll

Binary files differ

 Model/bin/Release/DBUtility.pdb

Binary files differ

 Model/bin/Release/Model.dll

Binary files differ

 Model/bin/Release/Model.pdb

Binary files differ

 Model/bin/Release/Pub_Class.dll

Binary files differ

 Model/bin/Release/Pub_Class.pdb

Binary files differ

 Model/bin/Release/Pub_Control.dll

Binary files differ

 Model/bin/Release/Pub_Control.pdb

Binary files differ

 Model/bin/Release/SQLHelper.dll

Binary files differ

 Model/bin/Release/SQLHelper.pdb

Binary files differ

 Model/obj/Release/Model.csproj.AssemblyReference.cache

Binary files differ

 Model/obj/Release/Model.dll

Binary files differ

 Model/obj/Release/Model.pdb

Binary files differ

 Pub_Class/bin/Release/Pub_Class.dll

Binary files differ

 Pub_Class/bin/Release/Pub_Class.pdb

Binary files differ

 Pub_Control/bin/Release/Pub_Class.dll

Binary files differ

 Pub_Control/bin/Release/Pub_Class.pdb

Binary files differ

 Pub_Control/bin/Release/Pub_Control.dll

Binary files differ

 Pub_Control/bin/Release/Pub_Control.pdb

Binary files differ

 SQLHelper/bin/Release/Pub_Class.dll

Binary files differ

 SQLHelper/bin/Release/Pub_Class.pdb

Binary files differ

 SQLHelper/bin/Release/SQLHelper.dll

Binary files differ

 SQLHelper/bin/Release/SQLHelper.pdb

Binary files differ

 SQLHelper/obj/Release/SQLHelper.csproj.AssemblyReference.cache

Binary files differ

 SQLHelper/obj/Release/SQLHelper.dll

Binary files differ

 SQLHelper/obj/Release/SQLHelper.pdb

Binary files differ

 SyntacticSugar/obj/Release/SyntacticSugar.csproj.AssemblyReference.cache

Binary files differ

 SyntacticSugar/obj/Release/SyntacticSugar.csproj.FileListAbsolute.txt

@@ -3,4 +3,3 @@
D:\网站发布\后端代码\MES-WEB-API\MES-WEB-API\SyntacticSugar\obj\Release\SyntacticSugar.csproj.CoreCompileInputs.cache
D:\网站发布\后端代码\MES-WEB-API\MES-WEB-API\SyntacticSugar\obj\Release\SyntacticSugar.dll
D:\网站发布\后端代码\MES-WEB-API\MES-WEB-API\SyntacticSugar\obj\Release\SyntacticSugar.pdb
D:\网站发布\后端代码\MES-WEB-API\MES-WEB-API\SyntacticSugar\obj\Release\SyntacticSugar.csproj.AssemblyReference.cache

 WebAPI/Controllers/JHGL/Gy_RoutingBillController.cs

@@ -26,6 +26,7 @@
        public DAL.ClsGy_Process_View oProcHlp = new DAL.ClsGy_Process_View();
        DAL.ClsGy_WorkCenter_View oCenHlp = new DAL.ClsGy_WorkCenter_View();
        DAL.ClsGy_Warehouse_View oCenWare = new DAL.ClsGy_Warehouse_View();
        DAL.ClsGy_Source_View oSourceHlp = new DAL.ClsGy_Source_View();
        Gy_RoutingBill_temporary omdelMian = new Gy_RoutingBill_temporary();
        public string BillType = "3301";
        Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
@@ -1412,6 +1413,598 @@
        }
        #endregion

        #region 工艺路线_孙表 文件上传
        [Route("Gy_RoutingBill/Gy_RoutingBillimport_WorkQty")]
        [HttpPost]
        public object Gy_RoutingBillimport_WorkQty()
        {
            try
            {
                var WorkBookName = HttpContext.Current.Request["WorkBookName"];
                DBUtility.ClsPub.HOrgID = long.Parse(HttpContext.Current.Request["HOrgID"]);
                Int64 HOrgID = long.Parse(HttpContext.Current.Request["HOrgID"]);
                //获取文件名称
                var file = HttpContext.Current.Request.Files[0];
                //获取文件物理路径
                string ExcelPath = HttpContext.Current.Server.MapPath("~/" + file.FileName);
                //保存文件
                file.SaveAs(ExcelPath);

                NpoiHelper np = new NpoiHelper();
                DataSet ExcelDs = np.ReadExcel(ExcelPath, 1, 2, WorkBookName);

                //删除文件
                File.Delete(ExcelPath);

                //创建临时表
                DataTable tb2 = new DataTable("dt2");
                DataTable tb3 = new DataTable("dt3");

                //添加列名
                for (int i = 0; i < ExcelDs.Tables[0].Columns.Count; i++)
                {
                    tb2.Columns.Add(ExcelDs.Tables[0].Rows[0][i].ToString());
                }

                //添加数据
                for (int i = 1; i < ExcelDs.Tables[0].Rows.Count; i++)
                {
                    DataRow row = tb2.NewRow();
                    for (int j = 0; j < ExcelDs.Tables[0].Columns.Count; j++)
                    {
                        row[j] = ExcelDs.Tables[0].Rows[i][j].ToString();
                    }
                    tb2.Rows.Add(row);
                }


                var error = "";

                //查询工艺路线没有的列
                if (!tb2.Columns.Contains("产品代码"))
                    error += "没有找到【产品代码】的标题,";

                if (!tb2.Columns.Contains("工序序号"))
                    error += "没有找到【工序序号】的标题,";

                if (!tb2.Columns.Contains("工序"))
                    error += "没有找到【工序】的标题,";

                if (!tb2.Columns.Contains("加工数量"))
                    error += "没有找到【加工数量】的标题,";

                //if (!tb2.Columns.Contains("工作中心"))
                //    error += "没有找到【工作中心】的标题,";

                //if (!tb2.Columns.Contains("本道开工余量"))
                //    error += "没有找到【本道开工余量】的标题,";

                //if (!tb2.Columns.Contains("本道固定开工天数"))
                //    error += "没有找到【本道固定开工天数】的标题,";

                //if (!tb2.Columns.Contains("班产定额"))
                //    error += "没有找到【班产定额】的标题,";

                //if (!tb2.Columns.Contains("工序工价"))
                //    error += "没有找到【工序工价】的标题,";

                //if (!tb2.Columns.Contains("工艺参数"))
                //    error += "没有找到【工艺参数】的标题,";

                //if (!tb2.Columns.Contains("图纸编号"))
                //    error += "没有找到【图纸编号】的标题,";

                //if (!tb2.Columns.Contains("本工序确认记录"))
                //    error += "没有找到【本工序确认记录】的标题,";

                //if (!tb2.Columns.Contains("图号版本"))
                //    error += "没有找到【图号版本】的标题,";

                //if (!tb2.Columns.Contains("总装图号"))
                //    error += "没有找到【总装图号】的标题,";

                //if (!tb2.Columns.Contains("材质"))
                //    error += "没有找到【材质】的标题,";

                //if (!tb2.Columns.Contains("成品编号"))
                //    error += "没有找到【成品编号】的标题,";

                //if (!tb2.Columns.Contains("版本"))
                //    error += "没有找到【版本】的标题,";

                //if (!tb2.Columns.Contains("模具编号"))
                //    error += "没有找到【模具编号】的标题,";

                //if (!tb2.Columns.Contains("程序号"))
                //    error += "没有找到【程序号】的标题,";

                //if (!tb2.Columns.Contains("良率"))
                //    error += "没有找到【良率】的标题";

                //if (!tb2.Columns.Contains("不良品仓"))
                //    error += "没有找到【不良品仓】的标题";

                //if (!tb2.Columns.Contains("报废品仓"))
                //    error += "没有找到【报废品仓】的标题";

                //if (!tb2.Columns.Contains("良品仓"))
                //    error += "没有找到【良品仓】的标题";

                if (!tb2.Columns.Contains("生产资源代码"))
                    error += "没有找到【生产资源代码】的标题,";

                //if (!tb2.Columns.Contains("生产资源"))
                //    error += "没有找到【生产资源】的标题,";

                if (error.Length > 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = $"Excel模板存在错误,{error}\r\n";
                    objJsonResult.data = null;
                    return objJsonResult;
                }


                //数据校验
                objJsonResult = (json)Checkdata_WorkQty(tb2);
                if (objJsonResult.code == "0")
                {
                    return objJsonResult;
                }

                //删除临时表数据
                oCN.RunProc("delete from diyipi_WorkQty");

                //临时表添加数据
                for (int i = 0; i < tb2.Rows.Count; i++)
                {
                    string sql_temp = "insert into diyipi_WorkQty(工艺路线代码,工艺路线名称, 产品代码,产品名称,工序序号,工序代码,工序,工作中心,加工数量" +
                                //", 良率, 工序工价, 不合格单价, 报废单价, 本道固定开工天数, 本道开工余量, 上道等待天数" +
                                //", 上道循环周期, 自动转移, 外协标记, 供应商代码, 供应商, 工艺参数, 图纸编号" +
                                //", 本工序确认记录, 备注, 图号版本, 总装图号, 材质, 成品编号, 版本" +
                                //", 模具编号, 程序号, 班产定额, 时间单位,不良品仓,报废品仓,良品仓" +
                                ",生产资源代码,HOrgID" +
                                ") " +
                                " values(" +
                                "'" + tb2.Rows[i]["工艺路线代码"].ToString() + "'" +
                                ",'" + tb2.Rows[i]["工艺路线名称"].ToString() + "'" +
                                ",'" + tb2.Rows[i]["产品代码"].ToString() + "'" +
                                ",'" + tb2.Rows[i]["产品名称"].ToString() + "'" +
                                ",'" + tb2.Rows[i]["工序序号"].ToString() + "'" +
                                ",'" + tb2.Rows[i]["工序代码"].ToString() + "'" +
                                ",'" + tb2.Rows[i]["工序"].ToString() + "'" +
                                ",'" + tb2.Rows[i]["工作中心"].ToString() + "'" +
                                ",'" + tb2.Rows[i]["加工数量"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["良率"].ToString() + "'" +
                                //",'" + (tb2.Rows[i]["工序工价"].ToString() == "" ? "0" : tb2.Rows[i]["工序工价"].ToString()) + "'" +
                                //",'" + tb2.Rows[i]["不合格单价"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["报废单价"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["本道固定开工天数"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["本道开工余量"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["上道等待天数"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["上道循环周期"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["自动转移"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["外协标记"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["供应商代码"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["供应商"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["工艺参数"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["图纸编号"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["本工序确认记录"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["备注"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["图号版本"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["总装图号"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["材质"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["成品编号"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["版本"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["模具编号"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["程序号"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["班产定额"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["时间单位"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["不良品仓"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["报废品仓"].ToString() + "'" +
                                //",'" + tb2.Rows[i]["良品仓"].ToString() + "'" +
                                ",'" + tb2.Rows[i]["生产资源代码"].ToString() + "'" +
                                "," + HOrgID + "" +
                                ")";
                    oCN.RunProc(sql_temp);
                }

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = error;
                objJsonResult.data = tb2;
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }


        //数据检验
        private object Checkdata_WorkQty(DataTable dt)
        {
            bool b = false;
            string sErrMsg = "";
            string sMsg = "";
            for (int i = 0; i <= dt.Rows.Count - 1; i++)
            {
                string sHNumber = "";
                string sHNamePoc = "";
                string sHNumberCen = "";
                Single sWorkQty = 0;
                Single sHPassRate = 0;
                string sHNumberSource = "";

                sHNumber = DBUtility.ClsPub.isStrNull(dt.Rows[i]["产品代码"].ToString());
                sHNamePoc = DBUtility.ClsPub.isStrNull(dt.Rows[i]["工序序号"].ToString());
                sHNamePoc = DBUtility.ClsPub.isStrNull(dt.Rows[i]["工序"].ToString());
                sWorkQty = DBUtility.ClsPub.isSingle(dt.Rows[i]["加工数量"].ToString());

                //sHNumberCen = DBUtility.ClsPub.isStrNull(dt.Rows[i]["工作中心"].ToString());
                //sHPassRate = DBUtility.ClsPub.isSingle(dt.Rows[i]["良率"].ToString());

                sHNumberSource = DBUtility.ClsPub.isStrNull(dt.Rows[i]["生产资源代码"].ToString());

                if (sHNumber != "")
                {
                    //记录检验数据的所在行
                    int index = i + 1;

                    //得到物料内码
                    if (!oMaterHlp.GetInfoByNumber(sHNumber))
                    {
                        sMsg = "[" + sHNumber + "]物料不存在";
                        if (sErrMsg.Contains(sMsg) == false)
                        {
                            sErrMsg = sErrMsg + "[" + sHNumber + "]物料不存在\r\n";
                        }
                        b = true;
                    }

                    //得到工序内码
                    if (!oProcHlp.GetInfoByName(sHNamePoc))
                    {
                        sMsg = "[" + sHNamePoc + "]工序不存在";
                        if (sErrMsg.Contains(sMsg) == false)
                        {
                            sErrMsg = sErrMsg + "[" + sHNamePoc + "]工序不存在\r\n";
                        }
                        b = true;
                    }

                    //加工数量不能小于等于零
                    if (sWorkQty < 0)
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "第" + index + "行加工数量不能小于等于零！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }

                    ////良率不能小于等于零
                    //if (sHPassRate <= 0)
                    //{
                    //    objJsonResult.code = "0";
                    //    objJsonResult.count = 0;
                    //    objJsonResult.Message = "第" + index + "行良率不能小于等于零！";
                    //    objJsonResult.data = null;
                    //    return objJsonResult;
                    //}

                    ////审核代码是否合理
                    //if (!DBUtility.ClsPub.AllowNumber(sHNumber))
                    //{
                    //    objJsonResult.code = "0";
                    //    objJsonResult.count = 0;
                    //    objJsonResult.Message = "物料代码中不能出现连续‘.’并且首位末位不能为‘.’！";
                    //    objJsonResult.data = null;
                    //    return objJsonResult;
                    //}


                    ////得到工作中心内码
                    //if (!oCenHlp.GetInfoByName(sHNumberCen))
                    //{
                    //    sMsg = "[" + sHNumberCen + "]工作中心不存在";
                    //    if (sErrMsg.Contains(sMsg) == false)
                    //    {
                    //        sErrMsg = sErrMsg + "[" + sHNumberCen + "]工作中心不存在\r\n";
                    //    }
                    //    b = true;
                    //}


                    //拆分【生产资源代码】，并逐个验证
                    if (sHNumberSource != "")
                    {
                        char[] delimiter = new char[] { ',' };
                        string[] sHNumberSourceList = sHNumberSource.Split(delimiter, StringSplitOptions.RemoveEmptyEntries);
                        for (int t = 0; t < sHNumberSourceList.Length; t++)
                        {
                            if (!oSourceHlp.GetInfoByNumber(sHNumberSourceList[t]))
                            {
                                sMsg = "[" + sHNumberSourceList[t] + "]生产资源不存在";
                                if (sErrMsg.Contains(sMsg) == false)
                                {
                                    sErrMsg = sErrMsg + "[" + sHNumberSourceList[t] + "]生产资源不存在\r\n";
                                }
                                b = true;
                            }
                        }
                    }
                }
            }
            if (b == true)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = sErrMsg;
                objJsonResult.data = null;
                return objJsonResult;
            }
            else
            {
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = sErrMsg;
                objJsonResult.data = null;
                return objJsonResult;
            }

        }
        #endregion

        #region 工艺路线_孙表 导入(保存)
        [Route("Gy_RoutingBill/Gy_RoutingBill_WorkQty_btnSave")]
        [HttpPost]
        public object Gy_RoutingBill_WorkQty_btnSave([FromBody] JObject sMainSub)
        {
            var _value = sMainSub["sMainSub"].ToString();
            string msg1 = _value.ToString();
            oCN.BeginTran();

            //保存主表
            objJsonResult = RoutAddBillMain_WorkQty(msg1);

            if (objJsonResult.code == "0")
            {
                oCN.RollBack();
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = objJsonResult.Message;
                objJsonResult.data = null;
                return objJsonResult;
            }

            oCN.Commit();
            objJsonResult.code = "1";
            objJsonResult.count = 1;
            objJsonResult.Message = objJsonResult.Message;
            objJsonResult.data = null;
            return objJsonResult;
        }

        public json RoutAddBillMain_WorkQty(string msg1)
        {
            string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
            string msg2 = sArray[0].ToString();
            string msg3 = sArray[1].ToString();
            string user = sArray[2].ToString();

            try
            {
                if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Edit", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "无保存权限！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                //表头字段
                omdelMian = Newtonsoft.Json.JsonConvert.DeserializeObject<Gy_RoutingBill_temporary>(msg2);

                string finalErrMsg = "";

                //获取导入表中的最新数据
                DataSet dsMain = oCN.RunProcReturn("select  distinct 产品代码 from  diyipi_WorkQty", "diyipi_WorkQty");
                if (dsMain.Tables[0].Rows.Count > 0)
                {
                    for(int i=0;i< dsMain.Tables[0].Rows.Count; i++)
                    {
                        string HMaterNumber = DBUtility.ClsPub.isStrNull(dsMain.Tables[0].Rows[0]["产品代码"]);
                        if (!oMaterHlp.GetInfoByNumber(HMaterNumber))
                        {
                            string sMsg = "物料【" + HMaterNumber + "】不存在！";
                            if (finalErrMsg.Contains(sMsg) == false)
                            {
                                finalErrMsg = finalErrMsg + "物料【" + HMaterNumber + "】不存在！\r\n";
                            }
                            continue;
                        }

                        //获取该物料导入的数据中是否存在多个工艺路线，如果存在，则报错
                        string HBillNo = "";
                        Int64 HInterID = 0;
                        DataSet dsHBillNo = oCN.RunProcReturn("select  distinct 工艺路线代码,工艺路线名称 from  diyipi_WorkQty where 产品代码 = '" + HMaterNumber + "'", "diyipi_WorkQty");
                        if (dsHBillNo.Tables[0].Rows.Count > 1)
                        {
                            string sMsg = "物料【" + HMaterNumber + "】存在多组【工艺路线代码，工艺路线名称】！";
                            if (finalErrMsg.Contains(sMsg) == false)
                            {
                                finalErrMsg = finalErrMsg + "物料【" + HMaterNumber + "】存在多组【工艺路线代码，工艺路线名称】！\r\n";
                            }
                            continue;
                        }
                        else                                                     //物料对应工艺路线唯一，获取工艺路线主内码与工艺路线代码
                        {
                            //生成唯一的工艺路线代码
                            HBillNo = DBUtility.ClsPub.isStrNull(dsHBillNo.Tables[0].Rows[0]["工艺路线代码"]);
                            if (HBillNo == "")
                            {
                                DataSet dataSet = oCN.RunProcReturn($"select HBillNo  from  Gy_RoutingBillMain where HBillNo='1' ", "Gy_RoutingBillMain");
                                while (1 == 1)
                                {
                                    if (HBillNo != "")
                                    {
                                        if (dataSet.Tables[0].Rows.Count == 0)
                                        {
                                            break;
                                        }
                                    }
                                    HBillNo = DBUtility.ClsPub.CreateBillCode(BillType, ref DBUtility.ClsPub.sExeReturnInfo, true);
                                    dataSet = oCN.RunProcReturn($"select HBillNo  from  Gy_RoutingBillMain where HBillNo='{HBillNo}' ", "Gy_RoutingBillMain");
                                }
                            }

                            //生成唯一的工艺路线内码
                            if (HInterID == 0)
                            {
                                while (1 == 1)
                                {
                                    HInterID = DBUtility.ClsPub.CreateBillID_Prod(BillType, ref DBUtility.ClsPub.sExeReturnInfo);//获得一个新的id
                                    DataSet dataSet = oCN.RunProcReturn("select * from Gy_RoutingBillMain where HInterID=" + HInterID, "Gy_RoutingBillMain");
                                    if (dataSet.Tables[0].Rows.Count == 0)
                                    {
                                        break;
                                    }
                                }
                            }
                        }

                        //拼接主表插入语句
                        string sqlMain = "insert into Gy_RoutingBillMain" +
                            "(HInterID,HYear,HPeriod,HBillType,HBillNo,HName,HDate,HMaker,HMakeDate,HRemark,HOrgID" +
                            ",HMaterID,HMaterNumber,HUnitID,HUnitNumber,HStandard,HRoutingGroupID) " +
                            "values(" +
                            "" + HInterID + "" +
                            "," + DateTime.Now.Year + "" +
                            "," + DateTime.Now.Month + "" +
                            ",'" + BillType + "'" +
                            ",'" + HBillNo + "'" +
                            ", ''" +
                            "," + "convert(varchar(100),getdate(),23)" + "" +
                            ",'" + user + "'" +
                            ", getdate()" +
                            ",'" + "批量导入(包含孙表)" + "'" +
                            "," + omdelMian.HOrgID +
                            "," + oMaterHlp.omodel.HItemID + "" +
                            ",'" + oMaterHlp.omodel.HNumber + "'" +
                            "," + oMaterHlp.omodel.HUnitID + "" +
                            ",'" + oMaterHlp.omodel.HUnitNumber + "'" +
                            "," + 1 + "" +
                            "," + 0 + "" +
                            ")";

                        //获取该物料的工艺路线信息子表数据
                        DataSet dsSub = oCN.RunProcReturn("select * from diyipi_WorkQty where 产品代码 = '" + HMaterNumber + "' order by 工序序号", "diyipi_WorkQty");
                        for(int j = 0; j < dsSub.Tables[0].Rows.Count; j++)
                        {
                            string HProcNumber = DBUtility.ClsPub.isStrNull(dsSub.Tables[0].Rows[j]["工序代码"]);
                            //得到工序内码
                            if (!oProcHlp.GetInfoByNumber(HProcNumber))
                            {
                                string sMsg = "工序【" + HProcNumber + "】不存在！";
                                if (finalErrMsg.Contains(sMsg) == false)
                                {
                                    finalErrMsg = finalErrMsg + "工序【" + HProcNumber + "】不存在！\r\n";
                                }
                                continue;
                            }
                            else
                            {
                                string sqlSub = "insert into Gy_RoutingBillSub" +
                                    "(HInterID,HEntryID,HProcNo,HProcID,HCenterID,HWorkQty,HSortProcFlag,HRemark,HTimeUnit,HReadyTime,HQueueTime,HMoveTime) " +
                                    "values(" +
                                    "" + HInterID + "" +
                                    "," + (j + 1) + "" +
                                    "," + DBUtility.ClsPub.isLong(dsSub.Tables[0].Rows[j]["工序序号"]) +
                                    "," + oProcHlp.omodel.HItemID + "" +
                                    "," + 0 + "" +
                                    "," + DBUtility.ClsPub.isDoule(dsSub.Tables[0].Rows[j]["加工数量"]) +
                                    ",1" + 
                                    ",'批量导入(包括孙表)'" +
                                    ", 0" +
                                    ", 0" +
                                    ", 0" +
                                    ", 0" +
                                    ")";

                                char[] delimiter = new char[] { ',' };
                                string HSourceNumberList = DBUtility.ClsPub.isStrNull(dsSub.Tables[0].Rows[j]["生产资源代码"]);
                                string[] sHNumberSourceList = HSourceNumberList.Split(delimiter, StringSplitOptions.RemoveEmptyEntries);
                                for(int t = 0; t < sHNumberSourceList.Length; t++)
                                {
                                    //得到生产资源内码
                                    if (!oSourceHlp.GetInfoByNumber(sHNumberSourceList[t]))
                                    {
                                        string sMsg = "生产资源【" + HProcNumber + "】不存在！";
                                        if (finalErrMsg.Contains(sMsg) == false)
                                        {
                                            finalErrMsg = finalErrMsg + "生产资源【" + HProcNumber + "】不存在！\r\n";
                                        }
                                        continue;
                                    }
                                    else
                                    {
                                        string sqlSub_WorkQty = "insert into Gy_RoutingBillSub_WorkQty" +
                                            "(HInterID,HEntryID,HEntrySubID,HRemark,HSourceID) " +
                                            "values(" +
                                            "" + HInterID + "" +
                                            "," + (j+1) + "" +
                                            "," + (t+1) + "" +
                                            ", '批量导入(包括孙表)'" +
                                            "," + oSourceHlp.omodel.HItemID + "" +
                                            ")";

                                        oCN.RunProc(sqlSub_WorkQty);
                                    }
                                }
                                oCN.RunProc(sqlSub);
                            }
                        }
                        oCN.RunProc(sqlMain);
                        oCN.RunProc("update Gy_RoutingBillMain set HStandard = 0 where HMaterID = " + oMaterHlp.omodel.HItemID + " and HInterID <>" + HInterID);
                    }
                }

                if (finalErrMsg.Length > 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = finalErrMsg;
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                oCN.RunProc("delete from diyipi_WorkQty");

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "导入完成,共" + dsMain.Tables[0].Rows.Count + "个工艺路线";
                objJsonResult.data = null;
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region  工艺路线 审核、反审核
        /// <summary>
        /// 

 WebAPI/Properties/PublishProfiles/FolderProfile1.pubxml.user

@@ -4,7 +4,7 @@
-->
<Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
  <PropertyGroup>
    <History>True|2025-04-17T03:20:10.9926709Z;True|2025-04-17T11:01:50.8902725+08:00;True|2025-04-17T10:53:40.1335186+08:00;True|2025-04-17T10:50:33.6109824+08:00;True|2025-04-17T10:31:35.1972930+08:00;True|2025-04-17T10:27:13.0718237+08:00;False|2025-04-17T10:27:05.4243104+08:00;True|2025-04-17T10:21:17.1039399+08:00;True|2025-04-17T10:17:30.5257362+08:00;True|2025-04-17T09:04:16.5959099+08:00;False|2025-04-17T09:04:08.5643163+08:00;True|2025-04-16T16:50:10.4001088+08:00;True|2025-04-16T16:37:30.0492166+08:00;False|2025-04-16T16:37:20.9070255+08:00;True|2025-04-15T14:55:05.4396103+08:00;True|2025-04-15T14:48:11.6729078+08:00;True|2025-04-15T14:18:53.0805178+08:00;True|2025-04-15T13:48:11.5252569+08:00;True|2025-04-15T13:37:14.4720847+08:00;True|2025-04-15T11:19:10.1766439+08:00;True|2025-04-15T11:16:15.9677953+08:00;True|2025-04-15T11:01:18.4337723+08:00;False|2025-04-15T11:01:06.9132978+08:00;True|2025-04-15T10:55:53.9650790+08:00;False|2025-04-15T10:55:45.2763971+08:00;True|2025-04-09T11:24:21.9466324+08:00;True|2025-04-09T11:14:25.0603792+08:00;True|2025-04-09T11:03:10.0252216+08:00;False|2025-04-09T11:03:01.0837419+08:00;True|2025-04-08T15:00:39.6673341+08:00;True|2025-04-08T14:55:20.5714659+08:00;True|2025-04-08T14:41:57.1855163+08:00;True|2025-04-08T13:31:03.4382266+08:00;True|2025-04-08T11:20:45.0300955+08:00;True|2025-04-08T10:59:59.6997668+08:00;False|2025-04-08T10:59:53.2827828+08:00;True|2025-04-08T10:48:17.4232977+08:00;False|2025-04-08T10:48:09.5363986+08:00;True|2025-04-03T13:53:30.6471699+08:00;False|2025-04-03T13:53:22.8762999+08:00;True|2025-04-02T12:47:31.3375226+08:00;False|2025-04-02T12:47:24.2095072+08:00;True|2025-04-01T16:29:52.7465502+08:00;False|2025-04-01T16:29:33.7844649+08:00;True|2025-03-28T16:22:29.8664470+08:00;True|2025-03-28T15:53:12.1106288+08:00;False|2025-03-28T15:53:01.4674242+08:00;True|2025-03-28T13:34:17.5506822+08:00;False|2025-03-28T13:34:09.5853308+08:00;True|2025-03-26T12:42:08.9630741+08:00;True|2025-03-26T12:40:07.7144561+08:00;True|2025-03-26T12:30:37.3503331+08:00;True|2025-03-26T12:26:47.5061658+08:00;True|2025-03-26T10:54:47.2556717+08:00;True|2025-03-26T10:49:59.7897145+08:00;True|2025-03-26T10:47:02.6195828+08:00;False|2025-03-26T10:46:54.9421244+08:00;True|2025-03-26T01:10:19.1227462+08:00;True|2025-03-26T01:00:04.3583740+08:00;True|2025-03-26T00:38:57.4757071+08:00;True|2025-03-26T00:28:24.9370188+08:00;True|2025-03-26T00:04:05.4507425+08:00;True|2025-03-25T23:06:56.2284828+08:00;False|2025-03-25T23:06:46.7023339+08:00;True|2025-03-25T22:57:08.3127897+08:00;False|2025-03-25T22:55:05.8028873+08:00;False|2025-03-25T22:54:51.2053101+08:00;False|2025-03-04T11:23:36.7757604+08:00;True|2025-02-12T14:05:06.1068587+08:00;False|2025-02-12T14:03:43.3961038+08:00;True|2025-01-18T09:42:50.3629397+08:00;True|2025-01-18T09:39:16.1773412+08:00;True|2025-01-17T11:15:39.4147082+08:00;False|2025-01-17T11:15:09.0033498+08:00;True|2025-01-14T10:20:31.1504093+08:00;False|2025-01-14T10:19:59.1429931+08:00;True|2025-01-10T16:29:54.8671377+08:00;False|2025-01-10T16:29:05.0650370+08:00;True|2025-01-04T14:30:56.5041884+08:00;True|2025-01-04T14:26:52.7448761+08:00;True|2025-01-04T14:23:27.9956967+08:00;True|2025-01-04T14:12:46.2410106+08:00;True|2025-01-04T14:09:33.1727375+08:00;True|2025-01-04T14:07:16.3373347+08:00;False|2025-01-04T14:06:33.4982458+08:00;True|2024-12-31T13:36:55.7394582+08:00;False|2024-12-31T13:35:58.6205647+08:00;True|2024-12-28T15:59:32.1394796+08:00;True|2024-12-28T13:48:20.4283118+08:00;True|2024-12-28T13:43:39.8159616+08:00;True|2024-12-28T13:23:58.4183285+08:00;True|2024-12-28T13:19:13.0583263+08:00;True|2024-12-28T13:12:03.2648502+08:00;True|2024-12-28T13:04:22.6803754+08:00;False|2024-12-28T13:03:56.5993252+08:00;True|2024-12-28T10:50:06.1597154+08:00;True|2024-12-28T10:27:58.7075320+08:00;False|2024-12-28T10:27:09.9450571+08:00;True|2024-12-24T10:52:25.3403292+08:00;False|2024-12-24T10:51:41.8017370+08:00;True|2024-12-23T15:45:21.7729300+08:00;True|2024-12-23T15:31:38.8549407+08:00;True|2024-12-23T15:20:26.2361671+08:00;True|2024-12-23T13:40:03.2774116+08:00;False|2024-12-23T13:39:39.8510770+08:00;True|2024-12-23T13:11:15.3232454+08:00;True|2024-12-23T13:05:43.3057458+08:00;True|2024-12-16T10:57:23.0694936+08:00;True|2024-12-16T10:03:48.1938775+08:00;True|2024-12-16T09:38:57.3052219+08:00;False|2024-12-16T09:38:31.7097388+08:00;True|2024-12-16T09:25:38.3751534+08:00;False|2024-12-16T09:24:19.3952981+08:00;True|2024-12-11T22:41:13.2881405+08:00;False|2024-12-11T22:40:26.3239379+08:00;True|2024-12-11T22:14:41.4392948+08:00;True|2024-12-11T22:03:03.6823866+08:00;True|2024-12-11T21:48:51.7423044+08:00;False|2024-12-11T21:47:55.6236616+08:00;True|2024-12-02T14:57:10.0773563+08:00;False|2024-12-02T14:56:35.6440156+08:00;True|2024-11-26T08:55:53.9125170+08:00;True|2024-11-26T08:24:31.3112433+08:00;False|2024-11-26T08:23:46.0894924+08:00;True|2024-11-20T10:16:03.7893118+08:00;False|2024-11-20T10:15:23.2632533+08:00;True|2024-11-20T09:06:55.2799108+08:00;False|2024-11-20T09:05:45.8751214+08:00;True|2024-11-15T10:50:02.2079520+08:00;False|2024-11-15T10:49:22.4156447+08:00;True|2024-11-11T16:53:33.6615343+08:00;False|2024-11-11T16:52:17.7499691+08:00;False|2024-11-06T11:32:23.8339166+08:00;True|2024-10-24T20:08:16.1196372+08:00;True|2024-10-24T14:53:21.0804405+08:00;False|2024-10-24T14:50:14.4659302+08:00;</History>
    <History>True|2025-04-18T05:54:27.4746888Z;False|2025-04-18T13:53:45.2296528+08:00;False|2025-04-18T13:53:29.7890054+08:00;False|2025-04-18T13:53:23.5770264+08:00;False|2025-04-18T13:53:18.0054565+08:00;True|2025-04-18T13:51:28.8449212+08:00;True|2025-04-18T13:24:50.1548645+08:00;True|2025-04-18T13:17:41.8781012+08:00;True|2025-04-18T13:07:11.4243777+08:00;True|2025-04-18T13:03:51.8972162+08:00;True|2025-04-18T12:59:24.3674835+08:00;True|2025-04-18T12:54:51.7546338+08:00;True|2025-04-18T12:51:54.3531129+08:00;False|2025-04-18T12:51:42.0198325+08:00;True|2025-04-18T09:11:06.5087174+08:00;False|2025-04-18T09:10:56.3178793+08:00;True|2025-04-17T11:20:10.9926709+08:00;True|2025-04-17T11:01:50.8902725+08:00;True|2025-04-17T10:53:40.1335186+08:00;True|2025-04-17T10:50:33.6109824+08:00;True|2025-04-17T10:31:35.1972930+08:00;True|2025-04-17T10:27:13.0718237+08:00;False|2025-04-17T10:27:05.4243104+08:00;True|2025-04-17T10:21:17.1039399+08:00;True|2025-04-17T10:17:30.5257362+08:00;True|2025-04-17T09:04:16.5959099+08:00;False|2025-04-17T09:04:08.5643163+08:00;True|2025-04-16T16:50:10.4001088+08:00;True|2025-04-16T16:37:30.0492166+08:00;False|2025-04-16T16:37:20.9070255+08:00;True|2025-04-15T14:55:05.4396103+08:00;True|2025-04-15T14:48:11.6729078+08:00;True|2025-04-15T14:18:53.0805178+08:00;True|2025-04-15T13:48:11.5252569+08:00;True|2025-04-15T13:37:14.4720847+08:00;True|2025-04-15T11:19:10.1766439+08:00;True|2025-04-15T11:16:15.9677953+08:00;True|2025-04-15T11:01:18.4337723+08:00;False|2025-04-15T11:01:06.9132978+08:00;True|2025-04-15T10:55:53.9650790+08:00;False|2025-04-15T10:55:45.2763971+08:00;True|2025-04-09T11:24:21.9466324+08:00;True|2025-04-09T11:14:25.0603792+08:00;True|2025-04-09T11:03:10.0252216+08:00;False|2025-04-09T11:03:01.0837419+08:00;True|2025-04-08T15:00:39.6673341+08:00;True|2025-04-08T14:55:20.5714659+08:00;True|2025-04-08T14:41:57.1855163+08:00;True|2025-04-08T13:31:03.4382266+08:00;True|2025-04-08T11:20:45.0300955+08:00;True|2025-04-08T10:59:59.6997668+08:00;False|2025-04-08T10:59:53.2827828+08:00;True|2025-04-08T10:48:17.4232977+08:00;False|2025-04-08T10:48:09.5363986+08:00;True|2025-04-03T13:53:30.6471699+08:00;False|2025-04-03T13:53:22.8762999+08:00;True|2025-04-02T12:47:31.3375226+08:00;False|2025-04-02T12:47:24.2095072+08:00;True|2025-04-01T16:29:52.7465502+08:00;False|2025-04-01T16:29:33.7844649+08:00;True|2025-03-28T16:22:29.8664470+08:00;True|2025-03-28T15:53:12.1106288+08:00;False|2025-03-28T15:53:01.4674242+08:00;True|2025-03-28T13:34:17.5506822+08:00;False|2025-03-28T13:34:09.5853308+08:00;True|2025-03-26T12:42:08.9630741+08:00;True|2025-03-26T12:40:07.7144561+08:00;True|2025-03-26T12:30:37.3503331+08:00;True|2025-03-26T12:26:47.5061658+08:00;True|2025-03-26T10:54:47.2556717+08:00;True|2025-03-26T10:49:59.7897145+08:00;True|2025-03-26T10:47:02.6195828+08:00;False|2025-03-26T10:46:54.9421244+08:00;True|2025-03-26T01:10:19.1227462+08:00;True|2025-03-26T01:00:04.3583740+08:00;True|2025-03-26T00:38:57.4757071+08:00;True|2025-03-26T00:28:24.9370188+08:00;True|2025-03-26T00:04:05.4507425+08:00;True|2025-03-25T23:06:56.2284828+08:00;False|2025-03-25T23:06:46.7023339+08:00;True|2025-03-25T22:57:08.3127897+08:00;False|2025-03-25T22:55:05.8028873+08:00;False|2025-03-25T22:54:51.2053101+08:00;False|2025-03-04T11:23:36.7757604+08:00;True|2025-02-12T14:05:06.1068587+08:00;False|2025-02-12T14:03:43.3961038+08:00;True|2025-01-18T09:42:50.3629397+08:00;True|2025-01-18T09:39:16.1773412+08:00;True|2025-01-17T11:15:39.4147082+08:00;False|2025-01-17T11:15:09.0033498+08:00;True|2025-01-14T10:20:31.1504093+08:00;False|2025-01-14T10:19:59.1429931+08:00;True|2025-01-10T16:29:54.8671377+08:00;False|2025-01-10T16:29:05.0650370+08:00;True|2025-01-04T14:30:56.5041884+08:00;True|2025-01-04T14:26:52.7448761+08:00;True|2025-01-04T14:23:27.9956967+08:00;True|2025-01-04T14:12:46.2410106+08:00;True|2025-01-04T14:09:33.1727375+08:00;True|2025-01-04T14:07:16.3373347+08:00;False|2025-01-04T14:06:33.4982458+08:00;True|2024-12-31T13:36:55.7394582+08:00;False|2024-12-31T13:35:58.6205647+08:00;True|2024-12-28T15:59:32.1394796+08:00;True|2024-12-28T13:48:20.4283118+08:00;True|2024-12-28T13:43:39.8159616+08:00;True|2024-12-28T13:23:58.4183285+08:00;True|2024-12-28T13:19:13.0583263+08:00;True|2024-12-28T13:12:03.2648502+08:00;True|2024-12-28T13:04:22.6803754+08:00;False|2024-12-28T13:03:56.5993252+08:00;True|2024-12-28T10:50:06.1597154+08:00;True|2024-12-28T10:27:58.7075320+08:00;False|2024-12-28T10:27:09.9450571+08:00;True|2024-12-24T10:52:25.3403292+08:00;False|2024-12-24T10:51:41.8017370+08:00;True|2024-12-23T15:45:21.7729300+08:00;True|2024-12-23T15:31:38.8549407+08:00;True|2024-12-23T15:20:26.2361671+08:00;True|2024-12-23T13:40:03.2774116+08:00;False|2024-12-23T13:39:39.8510770+08:00;True|2024-12-23T13:11:15.3232454+08:00;True|2024-12-23T13:05:43.3057458+08:00;True|2024-12-16T10:57:23.0694936+08:00;True|2024-12-16T10:03:48.1938775+08:00;True|2024-12-16T09:38:57.3052219+08:00;False|2024-12-16T09:38:31.7097388+08:00;True|2024-12-16T09:25:38.3751534+08:00;False|2024-12-16T09:24:19.3952981+08:00;True|2024-12-11T22:41:13.2881405+08:00;False|2024-12-11T22:40:26.3239379+08:00;True|2024-12-11T22:14:41.4392948+08:00;True|2024-12-11T22:03:03.6823866+08:00;True|2024-12-11T21:48:51.7423044+08:00;False|2024-12-11T21:47:55.6236616+08:00;True|2024-12-02T14:57:10.0773563+08:00;False|2024-12-02T14:56:35.6440156+08:00;True|2024-11-26T08:55:53.9125170+08:00;True|2024-11-26T08:24:31.3112433+08:00;False|2024-11-26T08:23:46.0894924+08:00;True|2024-11-20T10:16:03.7893118+08:00;False|2024-11-20T10:15:23.2632533+08:00;True|2024-11-20T09:06:55.2799108+08:00;False|2024-11-20T09:05:45.8751214+08:00;True|2024-11-15T10:50:02.2079520+08:00;False|2024-11-15T10:49:22.4156447+08:00;True|2024-11-11T16:53:33.6615343+08:00;False|2024-11-11T16:52:17.7499691+08:00;False|2024-11-06T11:32:23.8339166+08:00;True|2024-10-24T20:08:16.1196372+08:00;True|2024-10-24T14:53:21.0804405+08:00;False|2024-10-24T14:50:14.4659302+08:00;</History>
    <_PublishTargetUrl>D:\网站发布\智云MESWMS\API</_PublishTargetUrl>
  </PropertyGroup>
  <ItemGroup>
@@ -45,28 +45,28 @@
      <publishTime>02/22/2013 16:43:40</publishTime>
    </File>
    <File Include="bin/BLL.dll">
      <publishTime>04/17/2025 11:19:27</publishTime>
      <publishTime>04/18/2025 13:54:11</publishTime>
    </File>
    <File Include="bin/BLL.pdb">
      <publishTime>04/17/2025 11:19:27</publishTime>
      <publishTime>04/18/2025 13:54:11</publishTime>
    </File>
    <File Include="bin/BouncyCastle.Crypto.dll">
      <publishTime>12/18/2020 05:32:28</publishTime>
    </File>
    <File Include="bin/DAL.dll">
      <publishTime>04/17/2025 11:19:26</publishTime>
      <publishTime>04/18/2025 13:54:09</publishTime>
    </File>
    <File Include="bin/DAL.pdb">
      <publishTime>04/17/2025 11:19:26</publishTime>
      <publishTime>04/18/2025 13:54:09</publishTime>
    </File>
    <File Include="bin/Dapper.dll">
      <publishTime>07/22/2016 22:52:40</publishTime>
    </File>
    <File Include="bin/DBUtility.dll">
      <publishTime>04/17/2025 11:19:21</publishTime>
      <publishTime>04/18/2025 13:54:01</publishTime>
    </File>
    <File Include="bin/DBUtility.pdb">
      <publishTime>04/17/2025 11:19:21</publishTime>
      <publishTime>04/18/2025 13:54:01</publishTime>
    </File>
    <File Include="bin/Grpc.Core.Api.dll">
      <publishTime>03/22/2022 13:17:26</publishTime>
@@ -111,10 +111,10 @@
      <publishTime>07/25/2012 19:48:56</publishTime>
    </File>
    <File Include="bin/Model.dll">
      <publishTime>04/17/2025 11:19:22</publishTime>
      <publishTime>04/18/2025 13:54:02</publishTime>
    </File>
    <File Include="bin/Model.pdb">
      <publishTime>04/17/2025 11:19:22</publishTime>
      <publishTime>04/18/2025 13:54:02</publishTime>
    </File>
    <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs">
      <publishTime>04/06/2023 15:57:02</publishTime>
@@ -147,34 +147,34 @@
      <publishTime>10/23/2021 17:07:54</publishTime>
    </File>
    <File Include="bin/Pub_Class.dll">
      <publishTime>04/17/2025 11:19:16</publishTime>
      <publishTime>04/18/2025 13:53:57</publishTime>
    </File>
    <File Include="bin/Pub_Class.pdb">
      <publishTime>04/17/2025 11:19:16</publishTime>
      <publishTime>04/18/2025 13:53:57</publishTime>
    </File>
    <File Include="bin/Pub_Control.dll">
      <publishTime>04/17/2025 11:19:17</publishTime>
      <publishTime>04/18/2025 13:54:00</publishTime>
    </File>
    <File Include="bin/Pub_Control.pdb">
      <publishTime>04/17/2025 11:19:17</publishTime>
      <publishTime>04/18/2025 13:54:00</publishTime>
    </File>
    <File Include="bin/RestSharp.dll">
      <publishTime>08/31/2012 06:22:50</publishTime>
    </File>
    <File Include="bin/SQLHelper.dll">
      <publishTime>04/17/2025 11:19:18</publishTime>
      <publishTime>04/18/2025 13:54:00</publishTime>
    </File>
    <File Include="bin/SQLHelper.pdb">
      <publishTime>04/17/2025 11:19:18</publishTime>
      <publishTime>04/18/2025 13:54:00</publishTime>
    </File>
    <File Include="bin/Swashbuckle.Core.dll">
      <publishTime>02/16/2015 01:57:08</publishTime>
    </File>
    <File Include="bin/SyntacticSugar.dll">
      <publishTime>04/17/2025 11:19:14</publishTime>
      <publishTime>04/18/2025 13:53:57</publishTime>
    </File>
    <File Include="bin/SyntacticSugar.pdb">
      <publishTime>04/17/2025 11:19:14</publishTime>
      <publishTime>04/18/2025 13:53:57</publishTime>
    </File>
    <File Include="bin/System.Buffers.dll">
      <publishTime>07/19/2017 18:01:28</publishTime>
@@ -285,22 +285,22 @@
      <publishTime>05/09/2023 10:43:40</publishTime>
    </File>
    <File Include="bin/TopSdk.dll">
      <publishTime>04/17/2025 10:58:18</publishTime>
      <publishTime>04/18/2025 13:54:03</publishTime>
    </File>
    <File Include="bin/TopSdk.pdb">
      <publishTime>04/17/2025 10:58:18</publishTime>
      <publishTime>04/18/2025 13:54:03</publishTime>
    </File>
    <File Include="bin/WebActivatorEx.dll">
      <publishTime>11/24/2014 19:18:48</publishTime>
    </File>
    <File Include="bin/WebAPI.dll">
      <publishTime>04/17/2025 11:19:39</publishTime>
      <publishTime>04/18/2025 13:54:17</publishTime>
    </File>
    <File Include="bin/WebAPI.pdb">
      <publishTime>04/17/2025 11:19:39</publishTime>
      <publishTime>04/18/2025 13:54:17</publishTime>
    </File>
    <File Include="bin/WebAPI.XmlSerializers.dll">
      <publishTime>04/17/2025 11:19:44</publishTime>
      <publishTime>04/18/2025 13:54:21</publishTime>
    </File>
    <File Include="bin/WebGrease.dll">
      <publishTime>07/18/2013 01:03:52</publishTime>
@@ -495,7 +495,7 @@
      <publishTime>05/06/2024 13:47:57</publishTime>
    </File>
    <File Include="Web.config">
      <publishTime>04/17/2025 11:20:09</publishTime>
      <publishTime>04/18/2025 13:54:26</publishTime>
    </File>
  </ItemGroup>
</Project>

 sdk_dingding/TopSdk/bin/Release/TopSdk.dll

Binary files differ

 sdk_dingding/TopSdk/bin/Release/TopSdk.pdb

Binary files differ

 sdk_dingding/TopSdk/obj/Release/TopSdk.dll

Binary files differ

 sdk_dingding/TopSdk/obj/Release/TopSdk.pdb

Binary files differ