From c40039183a5c7f9a09953c19f60cf3b45110c2cb Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期四, 14 九月 2023 17:31:40 +0800 Subject: [PATCH] 生产领料单:新增或复制保存时,后端不再重新生成单据内码 --- WebAPI/Controllers/ReportPlatFormController.cs | 27 +++++++++++++++------------ 1 files changed, 15 insertions(+), 12 deletions(-) diff --git a/WebAPI/Controllers/ReportPlatFormController.cs b/WebAPI/Controllers/ReportPlatFormController.cs index a1295de..8a91897 100644 --- a/WebAPI/Controllers/ReportPlatFormController.cs +++ b/WebAPI/Controllers/ReportPlatFormController.cs @@ -70,28 +70,31 @@ try { - ds = oCN.RunProcReturn("select * from Gy_SourceRelationSet where HSourceID='" + HSourceID + "' and HUserName='"+ HSourceName + "'", "Gy_SourceRelationSet"); + ds = oCN.RunProcReturn("select * from Gy_SourceRelationSet where HSourceID='" + HSourceID + "' and HUserName='" + HUserName + "'", "Gy_SourceRelationSet"); + if (ds.Tables[0].Rows.Count > 0) { - objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "褰撳墠浜哄憳鍒涘缓姝ょ敓浜ц祫婧�,涓嶅厑璁搁噸澶嶅垱寤猴紒"; objJsonResult.data = null; - return objJsonResult; + } - oCN.BeginTran(); - //鍐欏叆浜х嚎缁戝畾 - string sql = string.Format(@"insert into Gy_SourceRelationSet (HSourceID,HUserName,HGroupID,HManagerID,HRemark,HCreateDate,HCreator,HNowFlag,HCheckManID) + else + { + oCN.BeginTran(); + //鍐欏叆浜х嚎缁戝畾 + string sql = string.Format(@"insert into Gy_SourceRelationSet (HSourceID,HUserName,HGroupID,HManagerID,HRemark,HCreateDate,HCreator,HNowFlag,HCheckManID) values('" + HSourceID + "','" + HUserName + "','" + HGroupID + "','" + HManagerID + "','" + HRemark + "','" + DateTime.Parse(HCreateDate).ToShortDateString() + "','" + HUserName + "','0','')"); - oCN.RunProc(sql); - oCN.Commit(); + oCN.RunProc(sql); + oCN.Commit(); - objJsonResult.code = "1"; - objJsonResult.count = 1; - objJsonResult.Message = "淇濆瓨鎴愬姛锛�"; - objJsonResult.data = null; + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "淇濆瓨鎴愬姛锛�"; + objJsonResult.data = null; + } } catch (Exception e) { -- Gitblit v1.9.1