优化

zrg

2025-11-26 999e1007eb2b1d4a1f5b19a0addc686b2e30ef2d

 WebAPI/Controllers/Sc_GroupOrderBillController.cs

@@ -116,8 +116,9 @@
                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");
                ds = oCN.RunProcReturn($"select * from Sc_PackUnionBillMain where HBarCode_Cus ='{HBarCode_Cus}'", "Sc_PackUnionBillMain");
                if (ds.Tables[0].Rows.Count > 0)
                {
                    objJsonResult.code = "0";
@@ -138,13 +139,13 @@
                    "(" +
                        "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+
                    "')"
                );
                //插入子表