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 | 26 +++++++++++++++++++-------
1 files changed, 19 insertions(+), 7 deletions(-)
diff --git a/MES.Service/service/WomcaaManager.cs b/MES.Service/service/WomcaaManager.cs
index 4203eb1..e9cb774 100644
--- a/MES.Service/service/WomcaaManager.cs
+++ b/MES.Service/service/WomcaaManager.cs
@@ -2,10 +2,9 @@
using MES.Service.Dto.webApi;
using MES.Service.Modes;
using SqlSugar;
-using System;
-using System.Security.Cryptography;
namespace MES.Service.service;
+using DbType = System.Data.DbType;
public class WomcaaManager : Repository<Womcaa>
{
@@ -57,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,
@@ -76,8 +85,7 @@
private Womcaa MapErpCAAtoWomcaa(ErpCAA dto)
{
-
- var entity = new Womcaa
+ var entity = new Womcaa
{
Erpid = Convert.ToDecimal(dto.Id),
Caa001 = dto.FBillNo,
@@ -116,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);
@@ -158,10 +167,13 @@
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>().Where(s => s.Erpid == womcab.Erpid).Single();
+ var entity = Db.Queryable<Womcab>()
+ .Where(s => s.Erpid == womcab.Erpid).Single();
if (entity != null) womcab.Id = entity.Id;
womcabList.Add(womcab);
--
Gitblit v1.9.3