优化

zrg

2025-11-26 999e1007eb2b1d4a1f5b19a0addc686b2e30ef2d

 WebAPI/Controllers/Sc_GroupOrderBillController.cs

@@ -39,7 +39,7 @@
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "请输入装箱码！";
                    objJsonResult.Message = "[3783-2-003]请输入装箱码！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
@@ -51,7 +51,7 @@
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = ds.Tables[0].Rows[0][1].ToString();//该装箱单已扫码！
                        objJsonResult.Message = "[0000-1-038]" + ds.Tables[0].Rows[0][1].ToString();//该装箱单已扫码！
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
@@ -65,7 +65,7 @@
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "false！无数据，请确认装箱码是否存在！";
                    objJsonResult.Message = "[3783-2-004]false！无数据，请确认装箱码是否存在！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
@@ -73,7 +73,7 @@
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "Sucess！";
                    objJsonResult.Message = "[0000-1-037]Sucess！";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
@@ -82,7 +82,7 @@
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.Message = "[0000-1-038]Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
@@ -101,20 +101,32 @@
            string msg1 = _value.ToString();
            try
            {
                //委外工序发出反序列化
                
                //组托单反序列化
                msg1 = "[" + msg1.ToString() + "]";
                List<GroupOrderBill> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<GroupOrderBill>>(msg1);
                //获取年月日并拼接成字符串
                string year = DateTime.Now.Year.ToString();
                string month = DateTime.Now.Month.ToString();
                string day = DateTime.Now.Day.ToString();
                string nowDate = year + month + day;
                //string month = DateTime.Now.Month.ToString();
                //string day = DateTime.Now.Day.ToString();
                string nowDate = DateTime.Now.ToString("yyyyMMdd");
                string HBillType = this.HBillType;//组托单类型
                long HInterID = list[0].HInterID;//递入type得到的单据ID
                string HBillNo = list[0].HBillNo;//递入type得到的单据No
                string HMaker = list[0].HMaker;//制单人
                string HBatchNo = list[0].HBatchNo;//入库批次
                string HBarCode_Cus = list[0].HBarCode_Cus;//客户标签（黑标号）
                long HOrgID = list[0].HOrgID;//递入type得到的单据ID
                //校验黑标号唯一性
                ds = oCN.RunProcReturn($"select * from Sc_PackUnionBillMain where HBarCode_Cus ='{HBarCode_Cus}'", "Sc_PackUnionBillMain");
                if (ds.Tables[0].Rows.Count > 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = $"[3783-2-007]黑标号{HBarCode_Cus}已存在";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                //生成唯一条码
                ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + nowDate + "'", "h_p_WMS_GetMaxNo");    //获取最大流水号
                oCN.RunProc("exec h_p_WMS_SetMaxNo '" + nowDate + "'");
@@ -127,32 +139,34 @@
                    "(" +
                        "HYear, HBillType, HInterID, HBillNo, HMaker" +
                        ", HMakeDate, HPeriod, HDate, HRemark, HICMOInterID" +
                        ", HICMOBillNo, HBarCode_Pack, HMaterID, HUnitID,HBatchNo,HBarCode_Cus" +
                        ", HICMOBillNo, HBarCode_Pack, HMaterID, HUnitID,HBatchNo,HBarCode_Cus,HProdOrgID" +
                    ")" +
                    "values" +
                    "(" +
                        "'"+ year + "', '" + HBillType + "'," + HInterID + ", '" + HBillNo + "', '" + HMaker + "'" +
                        ",GETDATE(),0,GETDATE(),' ',0" +
                        ",' ','"+ HBarCode_Pack + "',0,0,'" + HBatchNo +"','" + HBarCode_Cus +
                        ",' ','"+ HBarCode_Pack + "',0,0,'" + HBatchNo +"','" + HBarCode_Cus +"','"+ HOrgID+
                    "')"
                );
                //插入子表
                oCN.RunProc("exec h_p_SaveGroupOrder " + HInterID + "");
                //根据子表汇总生成Sc_PackUnionBillSub_Sum表记录
                oCN.RunProc("exec h_p_Sc_PackUnionBill_SumSubBill " + HInterID + ",'','',''");
                //插入条码档案表
                oCN.RunProc("exec h_p_SaveGroupOrderCodeToGy_BarCodeBill " + HInterID + "");
                oCN.Commit();
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "新增单据成功！";
                objJsonResult.Message = "[0000-1-050]新增单据成功！";
                objJsonResult.data = null;
                return objJsonResult;
            }
            catch (Exception e)
            {
                oCN.RollBack();
                //oCN.RollBack();
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.Message = "[0000-1-051]Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
@@ -187,7 +201,7 @@
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "无数据！";
                    objJsonResult.Message = "[0000-1-045]无数据！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
@@ -195,7 +209,7 @@
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "Sucess！";
                    objJsonResult.Message = "[0000-1-037]Sucess！";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
@@ -205,7 +219,7 @@
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.Message = "[0000-1-010]Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
@@ -305,10 +319,10 @@
            try
            {
                SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
                oCn.RunProc("Delete from KF_PonderationBillMain_Temp where HBarCode = " + BarCode + " and HBillType = '2601'");
                oCn.RunProc("Delete from KF_PonderationBillMain_Temp where HBarCode = '" + BarCode + "' and HBillType = '2601'");
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "删除成功！";
                objJsonResult.Message = "[0000-1-008]删除成功！";
                objJsonResult.data = null;
                return objJsonResult;
            }
@@ -316,7 +330,7 @@
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "删除失败！";
                objJsonResult.Message = "[0000-1-007]删除失败！";
                objJsonResult.data = e.ToString();
                return objJsonResult;
            }
@@ -336,6 +350,7 @@
            {
                SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
                oCN.BeginTran();
                oCn.RunProc("Delete from Sc_PackUnionBillMain where HInterID = " + HInterID);
                oCn.RunProc("Delete from Sc_PackUnionBillSub where HInterID = " + HInterID + " and HEntryID = " + HEntryID);
                //重新刷新更新 汇总子表 的记录和条码档案
                oCn.RunProc("Delete from Sc_PackUnionBillSub_Sum where HInterID = " + HInterID);
@@ -373,10 +388,10 @@
            try
            {
                SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
                oCn.RunProc("update Sc_PackUnionBillMain set HBarCode_Cus = " + HBarCode_Cus + " where HInterID = " + HInterID);
                oCn.RunProc("update Sc_PackUnionBillMain set HBarCode_Cus = '" + HBarCode_Cus + "' where HInterID = " + HInterID);
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "修改成功！";
                objJsonResult.Message = "[[0000-1-067]]修改成功！";
                objJsonResult.data = null;
                return objJsonResult;
            }
@@ -384,7 +399,7 @@
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "修改失败！";
                objJsonResult.Message = "[0000-1-066]修改失败！";
                objJsonResult.data = e.ToString();
                return objJsonResult;
            }