From 4e839864f61b1f7378024a995abf42971ceea29b Mon Sep 17 00:00:00 2001
From: 快乐的昕的电脑 <快乐的昕的电脑@DESKTOP-C2BQPQU>
Date: 星期六, 20 十二月 2025 08:41:14 +0800
Subject: [PATCH] 生产工单编码转id
---
MES.Service/Modes/Womcaa.cs | 6 ++
MES.Service/service/WomcaaManager.cs | 132 +++++++++++++++++++++++++++++++++++++++++++-
2 files changed, 135 insertions(+), 3 deletions(-)
diff --git a/MES.Service/Modes/Womcaa.cs b/MES.Service/Modes/Womcaa.cs
index afc4714..66acbec 100644
--- a/MES.Service/Modes/Womcaa.cs
+++ b/MES.Service/Modes/Womcaa.cs
@@ -433,4 +433,10 @@
/// </summary>
[SugarColumn(ColumnName = "DOCUMENT_STATUS")]
public string? DocumentStatus { get; set; }
+
+ /// <summary>
+ /// 瀹㈡埛id
+ /// </summary>
+ [SugarColumn(ColumnName = "cust_number")]
+ public string? CustNumber { get; set; }
}
\ No newline at end of file
diff --git a/MES.Service/service/WomcaaManager.cs b/MES.Service/service/WomcaaManager.cs
index 1b2d1da..57342c4 100644
--- a/MES.Service/service/WomcaaManager.cs
+++ b/MES.Service/service/WomcaaManager.cs
@@ -193,9 +193,9 @@
SrcBillentryseq = dto.FSrcBillEntrySeq, /// 婧愬崟鍒嗗綍琛屽彿
SaleOrderNo = dto.FSaleOrderNo, /// 闇�姹傚崟鎹彿
SaleOrderEntryseq = dto.FSaleOrderEntrySeq, /// 闇�姹傚崟鎹鍙�
-
-
-
+
+
+ CustNumber = dto.CustNumber, /// 瀹㈡埛缂栧彿
ErpSczz = Convert.ToInt32(dto.FPrdOrgId), /// 鐢熶骇缁勭粐ID
ErpWtzz = Convert.ToInt32(dto.FEnTrustOrgId), /// 濮旀墭缁勭粐ID
Btbz = dto.Btbz, /// 濮旀墭缁勭粐ID
@@ -213,6 +213,104 @@
SynchronousDate = DateTime.Now,
DocumentStatus = dto.FDocumentStatus
};
+
+ //宸ヤ綔涓績缂栫爜杞琁D,Caa021 = dto.FWorkShopID0
+ var entityCaa021 = Db.Queryable<SysDepartment>()
+ .Where(x => x.Departmentcode == dto.FWorkShopID0)
+ .Select(x => x.Id.ToString())
+ .First();
+ if (!string.IsNullOrWhiteSpace(entityCaa021))
+ {
+ entity.Caa021 = entityCaa021;
+ }
+ else
+ {
+ entity.Caa021 = "0";
+ }
+
+ //浠撳簱缂栫爜杞琁D,DepotCode = dto.FStockId,
+ var entityDepotCode = Db.Queryable<MesDepots>()
+ .Where(x => x.DepotCode == dto.FStockId)
+ .Select(x => x.DepotId.ToString())
+ .First();
+ if (!string.IsNullOrWhiteSpace(entityDepotCode))
+ {
+ entity.DepotCode = entityDepotCode;
+ }
+ else
+ {
+ entity.DepotCode = "0";
+ }
+
+ //浜у搧(鐗╂枡)缂栫爜杞琁D,Caa006 = dto.FMaterialId, ///
+ var entityCaa006 = Db.Queryable<MesItems>()
+ .Where(x => x.ItemNo == dto.FMaterialId)
+ .Select(x => x.Id.ToString())
+ .First();
+ if (!string.IsNullOrWhiteSpace(entityCaa006))
+ {
+ entity.Caa006 = entityCaa006;
+ }
+ else
+ {
+ entity.Caa006 = "0";
+ }
+
+ //鍗曚綅缂栫爜杞琁D,Caa009 = dto.FUnitId,
+ var entityCaa009 = Db.Queryable<MesUnit>()
+ .Where(x => x.Fnumber == dto.FUnitId)
+ .Select(x => x.Id.ToString())
+ .First();
+ if (!string.IsNullOrWhiteSpace(entityCaa009))
+ {
+ entity.Caa009 = entityCaa009;
+ }
+ else
+ {
+ entity.Caa009 = "0";
+ }
+
+ //璁″垝鍛樼紪鐮佽浆ID,PlanId = dto.FPlannerID,
+ var entityPlanId = Db.Queryable<MesStaff>()
+ .Where(x => x.StaffNo == dto.FPlannerID)
+ .Select(x => x.Id.ToString())
+ .First();
+ if (!string.IsNullOrWhiteSpace(entityPlanId))
+ {
+ entity.PlanId = entityPlanId;
+ }
+ else
+ {
+ entity.PlanId = "0";
+ }
+
+ //缁撴浜虹紪鐮佽浆ID,ForceCloserid = dto.FForceCloserId,
+ var entityForceCloserid = Db.Queryable<MesStaff>()
+ .Where(x => x.StaffNo == dto.FForceCloserId)
+ .Select(x => x.Id.ToString())
+ .First();
+ if (!string.IsNullOrWhiteSpace(entityForceCloserid))
+ {
+ entity.ForceCloserid = entityForceCloserid;
+ }
+ else
+ {
+ entity.ForceCloserid = "0";
+ }
+
+ //瀹㈡埛缂栫爜杞琁D,CustNumber = dto.CustNumber,
+ var entityCustNumber = Db.Queryable<MesStaff>()
+ .Where(x => x.StaffNo == dto.CustNumber)
+ .Select(x => x.Id.ToString())
+ .First();
+ if (!string.IsNullOrWhiteSpace(entityCustNumber))
+ {
+ entity.CustNumber = entityCustNumber;
+ }
+ else
+ {
+ entity.CustNumber = "0";
+ }
//鏍规嵁鍗曞彿+鍗曞埆锛岃幏鍙栧搴旂殑id
var singleId = Db.Queryable<Womcaa>()
@@ -296,6 +394,34 @@
// ParentItemName = dto.F_XIFG_Base_apv /// 鐖堕」鐗╂枡鍚嶇О
};
+ //浠撳簱缂栫爜杞琁D,DepotCode = dto.FStockID,
+ var entityDepotCode = Db.Queryable<MesDepots>()
+ .Where(x => x.DepotCode == dto.FStockID)
+ .Select(x => x.DepotId.ToString())
+ .First();
+ if (!string.IsNullOrWhiteSpace(entityDepotCode))
+ {
+ womcab.DepotCode = entityDepotCode;
+ }
+ else
+ {
+ womcab.DepotCode = "0";
+ }
+
+ //鍗曚綅缂栫爜杞琁D,Cab009 = dto.FUnitID,
+ var entityCab009 = Db.Queryable<MesUnit>()
+ .Where(x => x.Fnumber == dto.FUnitID)
+ .Select(x => x.Id.ToString())
+ .First();
+ if (!string.IsNullOrWhiteSpace(entityCab009))
+ {
+ womcab.Cab009 = entityCab009;
+ }
+ else
+ {
+ womcab.Cab009 = "0";
+ }
+
//鏍规嵁鍗曞彿+鍗曞埆+鏉愭枡鍝佸彿锛岃幏鍙栧搴旂殑id
var singleId = Db.Queryable<Womcab>()
.Where(x => x.Cab001 == dto.FBillNo && x.Cab003 == dto.FMaterialID2 && x.Cab002 == Convert.ToInt32(dto.FBillNoType))
--
Gitblit v1.9.3