From 1afd9dafa4d1ec83f4f94c2ceae41b03179b533f Mon Sep 17 00:00:00 2001 From: zyf <1071160500@qq.com> Date: 星期三, 11 十二月 2024 09:54:10 +0800 Subject: [PATCH] Revert "销售退货通知单完善、销售收货通知单增加" --- MES.Service/service/WomcaaManager.cs | 18 ++++++++++++++++-- 1 files changed, 16 insertions(+), 2 deletions(-) diff --git a/MES.Service/service/WomcaaManager.cs b/MES.Service/service/WomcaaManager.cs index f6f8b8d..e9cb774 100644 --- a/MES.Service/service/WomcaaManager.cs +++ b/MES.Service/service/WomcaaManager.cs @@ -4,6 +4,7 @@ using SqlSugar; namespace MES.Service.service; +using DbType = System.Data.DbType; public class WomcaaManager : Repository<Womcaa> { @@ -55,8 +56,18 @@ var orUpdate = base.Insert(mesWomcaa); var baOrUpdate = _womcabManager.InsertRange(mesWomcabs); + + var inputParam = mesWomcaa.Erpid; + + // 浣跨敤 SqlSugar 鎵ц瀛樺偍杩囩▼ + Db.Ado.ExecuteCommand( + "BEGIN PRC_UPDATE_DAA(:P_ID); END;", + new SugarParameter("P_ID", inputParam, + DbType.Decimal)); + if (orUpdate && baOrUpdate) return true; throw new NotImplementedException("鎻掑叆鎴栨洿鏂板け璐�"); + } private bool UpdateData(SqlSugarScope db, Womcaa mesWomcaa, @@ -113,7 +124,8 @@ Caa016 = dto.FMemoItem, Caa018 = Convert.ToDecimal(dto.planId), Caa019 = Convert.ToDecimal(dto.planSeq), - Caa020 = dto.planNum + Caa020 = dto.planNum, + FMOENTRYID = Convert.ToDecimal(dto.FMOENTRYID) }; var single = base.GetSingle(it => it.Erpid == entity.Erpid); @@ -155,7 +167,9 @@ Cab014 = dto.FIsKeyItem, Numerator = dto.FNumerator, Denominator = dto.FDenominator, - Eid = Convert.ToDecimal(dto.PID) + Eid = Convert.ToDecimal(dto.PID), + SCRAPQTY = Convert.ToDecimal(dto.FFixScrapQty), + SCRAPRATE = Convert.ToDecimal(dto.FScrapRate) }; var entity = Db.Queryable<Womcab>() -- Gitblit v1.9.3