From f862d5003ac180b79cd14478fd17dba1b4b28a82 Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期三, 12 三月 2025 08:19:13 +0800
Subject: [PATCH] 1.采购入库优化 2.生产领料优化 3.生产不补料优化
---
service/Wom/WomdaaManager.cs | 13 ++++++++-----
1 files changed, 8 insertions(+), 5 deletions(-)
diff --git a/service/Wom/WomdaaManager.cs b/service/Wom/WomdaaManager.cs
index 8ef6de9..425e39d 100644
--- a/service/Wom/WomdaaManager.cs
+++ b/service/Wom/WomdaaManager.cs
@@ -17,9 +17,9 @@
public List<string> GetProductionPickDaa001(WarehouseQuery query)
{
var sql =
- "SELECT DAA001 FROM WOMDAA A LEFT JOIN (SELECT COUNT(1) UN_NUM, PID FROM WOMDAB WHERE DAB006 > DAB007 GROUP BY PID) B ON A.ID = B.PID WHERE DAA001 LIKE '%" +
+ "SELECT DAA001 FROM WOMDAA A LEFT JOIN (SELECT COUNT(1) UN_NUM, PID FROM WOMDAB WHERE DAB006 > DAB007 GROUP BY DAB002) B ON A.GUID = B.daaGuid WHERE DAA001 = " +
query.daa001 +
- "%' and DAA018 != '瀹屽伐' AND DAA022 = 1 AND UN_NUM > 0 AND ROWNUM <= 10 order by a.id desc";
+ " and DAA018 != '瀹屽伐' AND DAA022 = 1 AND UN_NUM > 0 AND ROWNUM <= 10 order by a.id desc";
return Db.Ado.SqlQuery<string>(sql);
}
@@ -77,7 +77,9 @@
daa001 = query.daa001,
barcodeNum = barcodeNum,
splitNum = splitNum,
- barcode = query.barcode
+ barcode = query.barcode,
+ strMsg = _strMsg,
+ result = _intSum
};
return dto;
@@ -161,7 +163,8 @@
var womdaa = Db.Queryable<Womdaa, MesItems>((a, i) =>
new JoinQueryInfos(JoinType.Left,
a.Daa002 == i.ItemId.ToString()))
- .Where((a, i) => a.Daa001 == query.daa001)
+ .Where((a, i) => a.Daa001 == query.daa001
+ && a.Fstatus == 1)
.Select((a, i) => new
{
a.Daa001, a.CaaGuid
@@ -183,7 +186,7 @@
a.Daa001 == query.daa001 && d.IssueType == "1")
.Select((a, b, c, d) => new Womdab
{
- Pid = b.Pid,
+ //Pid = b.Pid,
Dab003 = b.Dab003,
Dab006 = b.Dab006,
Dab007 = b.Dab007,
--
Gitblit v1.9.3