斯莫尔后端代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yangle
2025-04-29 0a0d8bdfc13d6b780aa37b3b08e702fc96e6b892 
 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,31 @@


            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;//客户标签（黑标号）


                //校验黑标号唯一性


                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 + "'");


@@ -140,19 +151,21 @@


                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 +200,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无数据！";


                    objJsonResult.Message = "[0000-1-045]无数据！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -195,7 +208,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 +218,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 +318,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 +329,7 @@


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "删除失败！";


                objJsonResult.Message = "[0000-1-007]删除失败！";


                objJsonResult.data = e.ToString();


                return objJsonResult;


            }


@@ -336,6 +349,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 +387,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 +398,7 @@


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "修改失败！";


                objJsonResult.Message = "[0000-1-066]修改失败！";


                objJsonResult.data = e.ToString();


                return objJsonResult;


            }