王 垚
2022-06-16 39859af283ea5780b454084808c46251ae1505c5
WebAPI/Controllers/Sc_GroupOrderBillController.cs
@@ -115,6 +115,16 @@
                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 = $"黑标号{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 + "'");