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

chenhaozhe

2025-11-26 b5234c3a70322686d27b3afc23309650d1067523

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

@@ -443,8 +443,8 @@
                //反序列化
                msg2 = "[" + msg2.ToString() + "]";

                List<Models.ClsGy_Maintain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsGy_Maintain>>(msg2);

                var list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsGy_Maintain>>(msg2);
                string HNumber = list[0].HNumber;
                string HName = list[0].HName;
                string HShortNumber = list[0].HNumber;
@@ -480,6 +480,20 @@
                    return objJsonResult;
                }

                // æ–°å¢žæ—¶åˆ¤æ–­æ˜¯å¦å­˜åœ¨é‡å¤ä»£ç 
                var dsRepeatCheck = oCN.RunProcReturn($@"
                    select top 1 HItemID from Gy_Maintain where HStopflag = 0 and HNumber = '{HNumber}'
                ", "Gy_Maintain");

                if(dsRepeatCheck.Tables[0].Rows.Count > 0)
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "代码重复！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }


                //若MAINDI重复则重新获取