添加基础资料重复代码校验

chenhaozhe

2025-11-26 b5234c3a70322686d27b3afc23309650d1067523

 WebAPI/Controllers/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/Gy_RepairCheckBillController.cs

@@ -347,6 +347,19 @@
                    return objJsonResult;
                }

                // ä»£ç  é™¤åŽ»è‡ªèº«å¤– ä¸èƒ½é‡å¤
                var dsHNumberCheck = oCN.RunProcReturn($@"
                    select top 1 HItemID from Gy_RepairCheck where HStopflag = 0 and HNumber = '{HNumber}' and HItemID != {HItemID}
                ", "Gy_Repair");

                if (dsHNumberCheck.Tables[0].Rows.Count > 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "保存失败！代码重复!";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                //若MAINDI重复则重新获取
                oCN.BeginTran();
@@ -485,6 +498,18 @@
                    return objJsonResult;
                }

                var dsHNumberCheck = oCN.RunProcReturn($@"
                    select top 1 HItemID from Gy_RepairCheck where HStopflag = 0 and HNumber = '{HNumber}'
                ", "Gy_Repair");

                if (dsHNumberCheck.Tables[0].Rows.Count > 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "保存失败！代码重复!";
                    objJsonResult.data = null;
                    return objJsonResult;
                }


                //若MAINDI重复则重新获取