From 30846c0d13ee4136d68ba509b05281378db951c6 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期四, 19 九月 2024 14:14:27 +0800
Subject: [PATCH] 生成委外订单接口
---
MES.Service/service/WomdaaManager.cs | 14 ++++----------
1 files changed, 4 insertions(+), 10 deletions(-)
diff --git a/MES.Service/service/WomdaaManager.cs b/MES.Service/service/WomdaaManager.cs
index bab21e5..39ecd65 100644
--- a/MES.Service/service/WomdaaManager.cs
+++ b/MES.Service/service/WomdaaManager.cs
@@ -13,7 +13,7 @@
//鑾峰彇宸ュ崟鍙�
public List<string> GetProductionPickDaa001(WarehouseQuery query)
{
- string sql =
+ 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 '%" +
query.daa001 +
"%' and DAA018 != '瀹屽伐' AND DAA022 = 1 AND UN_NUM > 0 AND ROWNUM <= 10 order by a.id desc";
@@ -24,10 +24,7 @@
//鏍规嵁宸ュ崟鍙疯繑鍥炰骇鍝佸瀷鍙峰拰寰呴鐗╂枡
public ProductionPickDto GetItemsByDaa001(WarehouseQuery query)
{
- if (string.IsNullOrEmpty(query.daa001))
- {
- throw new Exception("宸ュ崟鍙蜂负绌�");
- }
+ if (string.IsNullOrEmpty(query.daa001)) throw new Exception("宸ュ崟鍙蜂负绌�");
var womdaa = Db.Queryable<Womdaa, MesItems>((a, i) =>
new JoinQueryInfos(JoinType.Left,
@@ -38,10 +35,7 @@
i.ItemModel
}).First();
- if (womdaa?.ItemModel == null)
- {
- throw new Exception("宸ュ崟鍙蜂笉瀛樺湪");
- }
+ if (womdaa?.ItemModel == null) throw new Exception("宸ュ崟鍙蜂笉瀛樺湪");
var dto = new ProductionPickDto
{
@@ -58,7 +52,7 @@
))
.Where((a, b, c) =>
a.Daa001 == query.daa001) // WHERE DAA001 = 'SCDD003681-1'
- .Select((a, b, c) => new Womdab()
+ .Select((a, b, c) => new Womdab
{
Pid = b.Pid,
Dab003 = b.Dab003,
--
Gitblit v1.9.3