From 2697966bbe8ad54491553f407c42eaaedfc20afb Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期二, 19 十一月 2024 16:23:47 +0800
Subject: [PATCH] 1
---
service/Warehouse/MesInvItemInCDetailsManager.cs | 10 +++++-----
1 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/service/Warehouse/MesInvItemInCDetailsManager.cs b/service/Warehouse/MesInvItemInCDetailsManager.cs
index 01ccc2e..908645c 100644
--- a/service/Warehouse/MesInvItemInCDetailsManager.cs
+++ b/service/Warehouse/MesInvItemInCDetailsManager.cs
@@ -769,8 +769,8 @@
var result = Db.Queryable<MesInvItemIns, MesDepots, MesSupplier>(
(a, b, c) =>
new JoinQueryInfos(JoinType.Left,
- a.DepotsCode == b.DepotCode,
- JoinType.Left, a.SuppNo == c.SuppNo))
+ a.DepotsId == b.DepotId,
+ JoinType.Left, a.SuppId == c.Id.ToString()))
.WhereIF(UtilityHelper.CheckGuid(parsedGuid),
(a, b, c) => a.Guid == parsedGuid)
.Select((a, b, c) => new MesInvItemIns
@@ -843,7 +843,7 @@
(g, c, d) => new JoinQueryInfos(
JoinType.Left,
g.ItemId == c.Id, JoinType.Inner,
- d.Id == Convert.ToDecimal(c.ItemUnit)
+ d.Id.ToString() == c.Fpurchaseunitid
)
).WhereIF(UtilityHelper.CheckGuid(parsedGuid),
(g, c, d) => g.ItemInId == parsedGuid)
@@ -961,7 +961,7 @@
(g, c, d, a) => new JoinQueryInfos(
JoinType.Left,
g.ItemId == c.Id , JoinType.Inner,
- d.Id == Convert.ToDecimal(c.ItemUnit),
+ d.Id.ToString() == c.Fpurchaseunitid,
JoinType.Inner, a.Ebeln == g.WorkNo && g.CbillNo == a.CbillNo
)
).Where((g, c, d, a) => g.BillNo == billNo).Select<Material>(
@@ -987,7 +987,7 @@
FRealQty = d.FRealQty,
FStockId = d.FStockId,
FLot = d.FLot,
- FUnitID = d.FUnitID,
+ FUintId = d.FUnitID,
FSRCENTRYID = d.FsrcEntryId,
F_MES_ENTRYID = d.FMesEntryid
}).ToList();
--
Gitblit v1.9.3