数据导出

zzr99

2022-04-20 330fb0fa0c0cc61b52857771f3875268c8b190c0

 WebAPI/Controllers/Sc_GroupOrderBillController.cs

@@ -101,7 +101,7 @@
            string msg1 = _value.ToString();
            try
            {
                //委外工序发出反序列化
                //组托单反序列化
                msg1 = "[" + msg1.ToString() + "]";
                List<GroupOrderBill> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<GroupOrderBill>>(msg1);
                //获取年月日并拼接成字符串
@@ -140,6 +140,8 @@
                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;
@@ -305,7 +307,7 @@
            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 = "删除成功！";
@@ -336,6 +338,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,7 +376,7 @@
            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 = "修改成功！";