From 7d66f12e74e6b0566331a0406da020bce387c807 Mon Sep 17 00:00:00 2001
From: zjh <2207896513@qq.com>
Date: 星期二, 18 三月 2025 15:20:46 +0800
Subject: [PATCH] ERP生产订单接口字段完善
---
StandardPda/MES.Service/service/WomcaaManager.cs | 181 ++++++++++++---------------------------------
1 files changed, 49 insertions(+), 132 deletions(-)
diff --git a/StandardPda/MES.Service/service/WomcaaManager.cs b/StandardPda/MES.Service/service/WomcaaManager.cs
index c3199ae..12dfdad 100644
--- a/StandardPda/MES.Service/service/WomcaaManager.cs
+++ b/StandardPda/MES.Service/service/WomcaaManager.cs
@@ -1,19 +1,12 @@
-锘縰sing Dm;
-using MES.Service.DB;
+锘縰sing MES.Service.DB;
using MES.Service.Dto.webApi;
using MES.Service.Modes;
using SqlSugar;
-using System.Net.NetworkInformation;
-using System.Runtime.CompilerServices;
namespace MES.Service.service;
public class WomcaaManager : Repository<Womcaa>
{
- //褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉�
-
- //杩欓噷闈㈠啓鐨勪唬鐮佷笉浼氱粰瑕嗙洊,濡傛灉瑕侀噸鏂扮敓鎴愯鍒犻櫎 WomcaaManager.cs
-
private readonly WomcabManager _womcabManager = new();
public bool SaveList(List<ErpWOM> rohIns)
@@ -37,14 +30,13 @@
return UpdateData(db, mesWomcaa, mesWomcabs) ? 1 : 0;
case "2":
case "4":
- //kyy 2024-09-13 鍙樻洿
case "5":
return SaveOrUpdateData(db, mesWomcaa, mesWomcabs)
? 1
: 0;
default:
throw new NotImplementedException(
- $"type娌℃湁{womErpCaa.Type}杩欎釜绫诲瀷");
+ $"type绫诲瀷涓簕womErpCaa.Type}鐨勪笉瀛樺湪");
}
}) > 0;
}
@@ -58,17 +50,15 @@
db.Deleteable<Womcab>()
.Where(s => s.Eid == mesWomcaa.Erpid).ExecuteCommand();
- //鍗曟潯鎻掑叆蹇界暐绌哄瓧娈�
var orUpdate = db.Insertable(mesWomcaa)
.IgnoreColumns(true).ExecuteCommand() > 0;
- //鎵归噺鎻掑叆蹇界暐绌哄瓧娈�
var baOrUpdate = db.Insertable(mesWomcabs).PageSize(1)
.IgnoreColumnsNull()
.ExecuteCommand() > 0;
if (orUpdate && baOrUpdate) return true;
- throw new NotImplementedException("鎻掑叆鎴栨洿鏂板け璐�");
+ throw new NotImplementedException("鏇存柊澶辫触");
}
private bool UpdateData(SqlSugarScope db, Womcaa mesWomcaa,
@@ -86,125 +76,52 @@
private Womcaa MapErpCAAtoWomcaa(ErpCAA dto)
{
- //string jabs="0";
-
- //var entity = new Womcaa
- //{
- // Erpid = Convert.ToDecimal(dto.Id),
- // Caa001 = dto.FBillNo,
- // Caa004 = dto.FBillType,
- // Caa005 = dto.FConveyDate,
- // Caa006 = dto.FMaterialId,
- // Caa009 = dto.FUnitId,
- // Caa010 = dto.FPlanStartDate,
- // Caa011 = dto.FPlanFinishDate,
- // Caa012 = Convert.ToDecimal(dto.FQty),
- // Caa013 = dto.FBomId,
- // Caa015 = dto.FSaleOrderNo,
- // Caa015Head = dto.FSaleOrderEntrySeq,
- // Caa016 = dto.FDescription,
- // Caa017 = 0,
- // Caa018 = Convert.ToDecimal(dto.PLAN_ID),
- // Caa019 = dto.PLAN_SEQ,
- // Caa020 = dto.PLAN_NUM,
- // Caa021 = dto.FWorkShopID,
- // Fstatus = 0,
- // Caa022 = Convert.ToDecimal(dto.FQty),
- // Caa023 = dto.FStatus,
- // Caa024 = 0,
- // RoutingId = dto.FRoutingId,
- // WorkShopId = dto.FREMWorkShopId,
- // DepotCode = dto.FStockId,
- // CreateDate = dto.FDate,
- // WorkGroupId = dto.FWorkGroupId,
- // PlanId = dto.FPlannerID,
- // StockInlimith = dto.FStockInLimitH,
- // StockInlimitl = dto.FStockInLimitL,
- // Mtono = dto.FMTONO,
- // Lot = dto.FLot,
- // CreateType = dto.FCreateType,
- // SrcBillType = dto.FSrcBillType,
- // SrcBillNo = dto.FSrcBillNo,
- // SrcBillentryseq = dto.FSrcBillEntrySeq,
- // SaleOrderNo = dto.FSaleOrderNo,
- // SaleOrderEntryseq = dto.FSaleOrderEntrySeq,
- // ForceCloserid = dto.FForceCloserId,
- // CloseType = dto.FCloseType,
- // SrcSplitBillno = dto.FSrcSplitBillNo,
- // F_ZSXG_KH = dto.F_ZSXG_KH,
- // F_ZJXF_YHRQ = dto.F_ZJXF_YHRQ,
- // PrdOrg = dto.erP_SCZZ,
- // TrustOrg = dto.erP_WTZZ,
- // TbTime = DateTime.Now,
- // JaBs = "0"
- //};
-
- //if (dto.Type == "5")
- //{
- // entity.IsXg = 1;
- //}
- //else
- //{
- // entity.IsXg = 0;
- //}
-
- //if (dto.FStatus == "6" || dto.FStatus == "7")
- //{
- // entity.JaBs = "1";
- // entity.JaTime = DateTime.Now;
- //}
-
var entity = new Womcaa
{
- Erpid = Convert.ToInt32(dto.Id), /// ERPID
- Caa001 = dto.FBillNo, /// 鍗曞彿
- Caa021 = dto.FWorkShopID, /// 宸ヤ綔杞﹂棿
- RoutingId = dto.FRoutingId, /// 宸ヨ壓璺嚎
- WorkShopId = dto.FREMWorkShopId, /// 浜х嚎
- DepotCode = dto.FStockId, /// 浠撳簱
- CreateDate = dto.FDate, /// 鍗曟嵁鏃ユ湡
- Caa004 = dto.FBillType, /// 鍗曟嵁绫诲瀷
- Caa023 = dto.FStatus, /// 鐘舵�� 瀹屽伐锛屾湭瀹屽伐
- Caa006 = dto.FMaterialId, /// 浜у搧缂栫爜
- Caa009 = dto.FUnitId, /// 鍗曚綅
+ Erpid = Convert.ToInt32(dto.Id),
+ Caa001 = dto.FBillNo,
+ Caa021 = dto.FWorkShopID,
+ RoutingId = dto.FRoutingId,
+ WorkShopId = dto.FREMWorkShopId,
+ DepotCode = dto.FStockId,
+ CreateDate = dto.FDate,
+ Caa004 = dto.FBillType,
+ Caa023 = dto.FStatus,
+ Caa006 = dto.FMaterialId,
+ Caa009 = dto.FUnitId,
Caa012 = !string.IsNullOrEmpty(dto.FQty)
? Convert.ToDecimal(dto.FQty)
- : null, /// 鏁伴噺
- WorkGroupId = dto.FWorkGroupId, /// 璁″垝缁�
- PlanId = dto.FPlannerID, /// 璁″垝鍛�
- Caa010 = dto.FPlanStartDate, /// 棰勮寮�宸ユ椂闂�
- Caa011 = dto.FPlanFinishDate, /// 棰勮瀹屽伐鏃堕棿
- Caa005 = dto.FConveyDate, /// 寮�鍗曟棩鏈�
- StockInlimith = dto.FStockInLimitH, /// 鍏ュ簱涓婇檺
- StockInlimitl = dto.FStockInLimitL, /// 鍏ュ簱涓嬮檺
- Mtono = dto.FMTONO, /// 璁″垝璺熻釜鍙�
- Lot = dto.FLot, /// 鎵瑰彿
- Caa013 = dto.FBomId, /// BOM鐗堟
+ : null,
+ WorkGroupId = dto.FWorkGroupId,
+ PlanId = dto.FPlannerID,
+ Caa010 = dto.FPlanStartDate,
+ Caa011 = dto.FPlanFinishDate,
+ Caa005 = dto.FConveyDate,
+ StockInlimith = dto.FStockInLimitH,
+ StockInlimitl = dto.FStockInLimitL,
+ Mtono = dto.FMTONO,
+ Lot = dto.FLot,
+ Caa013 = dto.FBomId,
- CreateType = dto.FCreateType, /// 鐢熸垚鏂瑰紡
+ CreateType = dto.FCreateType,
Caa018 = !string.IsNullOrEmpty(dto.PLAN_ID)
? Convert.ToInt32(dto.PLAN_ID)
- : null, /// ERP婧愬崟ID
- Caa019 = dto.PLAN_SEQ, /// ERP婧愬崟琛屽彿
- Caa020 = dto.PLAN_NUM, /// ERP婧愬崟鍗曞彿(浠诲姟鍗曞彿)
- SrcBillType = dto.FSrcBillType, /// 婧愬崟绫诲瀷
- SrcBillNo = dto.FSrcBillNo, /// 婧愬崟缂栧彿
- SrcBillentryseq = dto.FSrcBillEntrySeq, /// 婧愬崟鍒嗗綍琛屽彿
- SaleOrderNo = dto.FSaleOrderNo, /// 闇�姹傚崟鎹彿
- SaleOrderEntryseq = dto.FSaleOrderEntrySeq, /// 闇�姹傚崟鎹鍙�
- ForceCloserid = dto.FForceCloserId, /// 缁撴浜�
- CloseType = dto.FCloseType, /// 缁撴绫诲瀷
- SrcSplitBillno = dto.FSrcSplitBillNo, /// 婧愭媶鍒嗚鍗曠紪鍙�
- Caa016 = dto.FDescription, /// 澶囨敞
- BTBZ = dto.BTBZ, /// 澶囨敞
- PrdOrg = dto.FPrdOrgId, /// 鐢熶骇缁勭粐ID
- TrustOrg = dto.FEnTrustOrgId, /// 濮旀墭缁勭粐ID
- Typea = dto.TypeA, /// 鍗曟嵁鐘舵��
-
-
- //娌冨皵鏂板
- WR_F_SCDD_SCTZD = dto.F_SCDD_SCTZD,
- WR_F_SCDD_XH = dto.F_SCDD_XH
+ : null,
+ Caa019 = Convert.ToInt32(dto.PLAN_SEQ),
+ Caa020 = dto.PLAN_NUM,
+ SrcBillType = dto.FSrcBillType,
+ SrcBillNo = dto.FSrcBillNo,
+ SrcBillentryseq = dto.FSrcBillEntrySeq,
+ SaleOrderNo = dto.FSaleOrderNo,
+ SaleOrderEntryseq = dto.FSaleOrderEntrySeq,
+ ForceCloserid = dto.FForceCloserId,
+ CloseType = dto.FCloseType,
+ SrcSplitBillno = dto.FSrcSplitBillNo,
+ Caa016 = dto.FDescription,
+ //BTBZ = dto.BTBZ,
+ PrdOrg = dto.FPrdOrgId,
+ TrustOrg = dto.FEnTrustOrgId
+ //Typea = dto.TypeA
};
@@ -240,19 +157,19 @@
Cab009 = dto.FUnitID,
SupplyType = dto.FSupplyType,
Cab012 = Convert.ToDecimal(dto.FStdQty),
- Freplacegroup = Convert.ToInt32(dto.FReplaceGroup),
+ FreplaceGroup = Convert.ToInt32(dto.FReplaceGroup),
UseRate = Convert.ToDecimal(dto.FUseRate),
MaterialType = dto.FMaterialType,
- Cab014 = dto.FIsKeyItem,
+ Cab014 = Convert.ToInt32(dto.FIsKeyItem),
Numerator = Convert.ToDecimal(dto.FNumerator),
Denominator = Convert.ToDecimal(dto.FDenominator),
Pid = Convert.ToDecimal(dto.FID),
Eid = Convert.ToDecimal(dto.FID),
- SCRAPQTY = Convert.ToDecimal(dto.FFixScrapQty),
- SCRAPRATE = Convert.ToDecimal(dto.FScrapRate),
- Typeb = dto.TypeB,
- WR_F_XIFG_Base_qtr = dto.F_XIFG_Base_qtr,
- WR_F_XIFG_Base_83g = dto.F_XIFG_Base_83g
+ Scrapqty = Convert.ToDecimal(dto.FFixScrapQty),
+ Scraprate = Convert.ToDecimal(dto.FScrapRate),
+ TypeB = dto.TypeB
+ // WR_F_XIFG_Base_qtr = dto.F_XIFG_Base_qtr,
+ // WR_F_XIFG_Base_83g = dto.F_XIFG_Base_83g
};
var entity = Db.Queryable<Womcab>()
--
Gitblit v1.9.3