From 4704a266830cf05b877dfb3cc572fb1ca8680b3d Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期四, 02 一月 2025 09:12:38 +0800
Subject: [PATCH] 11
---
service/Warehouse/MesItemBlManager.cs | 30 +++++++++++++++++-------------
1 files changed, 17 insertions(+), 13 deletions(-)
diff --git a/service/Warehouse/MesItemBlManager.cs b/service/Warehouse/MesItemBlManager.cs
index 2d70ca7..ff46948 100644
--- a/service/Warehouse/MesItemBlManager.cs
+++ b/service/Warehouse/MesItemBlManager.cs
@@ -14,12 +14,12 @@
/// 鑾峰彇鐢熶骇琛ユ枡鍗曞彿鍒楄〃
/// </summary>
/// <returns>琛ユ枡鍗曞彿鍒楄〃</returns>
- public List<string> GetSCBLBillNo()
+ public List<string> GetSCBLBillNo(WarehouseQuery query)
{
var list = Db.Queryable<MesItemBl>()
.Where(s => (s.Bl018 ?? false) == true
&& (s.Bl019 ?? false) == false
- && s.Bl008 == "鐢熶骇琛ユ枡")
+ && s.Bl008 == query.type)
.Select(s => s.BlNo)
.ToList();
return list;
@@ -505,8 +505,8 @@
// Mblnr = stockBarcode.Mblnr,
// Zeile = stockBarcode.Zeile,
// RohInId = stockBarcode.RohInId,
- // BarcodeStatus = 0,
- // OldQty = query.Num,
+ Barcodestatus = false,
+ Oldqty = query.Num as long?,
// Unit = stockBarcode.Unit,
// WeightUnit = stockBarcode.WeightUnit,
Factory = stockBarcode.Factory,
@@ -519,8 +519,9 @@
// MemoBad = stockBarcode.MemoBad,
ComeFlg = 5,
// Memo = stockBarcode.Memo,
+ SuppId = stockBarcode.SuppId,
SuppNo = stockBarcode.SuppNo,
- // InsDate = stockBarcode.InsDate, // Added InsDate
+ InsDate = stockBarcode.IndepDate, // Added InsDate
ItemId = stockBarcode.ItemId
// ItemUnit = stockBarcode.ItemUnit // Added ItemUnit
}).IgnoreColumns(true).ExecuteCommand();
@@ -891,12 +892,12 @@
#region 鐢熶骇瓒呴
- public List<string> GetSccList()
+ public List<string> GetSccList(WarehouseQuery query)
{
var list = Db.Queryable<MesItemBl>()
.Where(s => (s.Bl018 ?? false) == true
&& (s.Bl019 ?? false) == false
- && s.Bl008 == "鐢熶骇瓒呴")
+ && s.Bl008 == query.type)
.Select(s => s.BlNo)
.ToList();
return list;
@@ -1692,18 +1693,21 @@
// 鑾峰彇鏈�缁堢殑寰呭鐞嗗垪琛�
+ // 鑾峰彇琛ユ枡鍗曟槑缁嗕腑鏈畬鎴愮殑璁板綍
+ // 閫氳繃宸﹁繛鎺ユ煡璇㈣ˉ鏂欏崟(MesItemBl)鍜岃ˉ鏂欏崟鏄庣粏(MesItemBlDetail)琛�
+ // 鏉′欢: 1.琛ユ枡鍗曞彿鍖归厤 2.璁″垝鏁伴噺(Bld007)鍑忓幓宸茶ˉ鏁伴噺(Bld008)澶т簬0(鍗虫湭瀹屾垚鐨�)
var pendingList = Db.Queryable<MesItemBl, MesItemBlDetail>((a, b) =>
new JoinQueryInfos(JoinType.Left, a.Id == b.Mid))
.Where((a, b) => a.BlNo == query.blNo
&& (b.Bld007 ?? 0) - (b.Bld008 ?? 0) > 0)
.Select((a, b) => new MesItemBlDetail
{
- Bld012 = b.Bld012,
- Bld002 = b.Bld002,
- Bld003 = b.Bld003,
- Bld004 = b.Bld004,
- Bld007 = b.Bld007,
- Bld008 = b.Bld008
+ Bld012 = b.Bld012, // 鐗╂枡ID
+ Bld002 = b.Bld002, // 鐗╂枡缂栧彿
+ Bld003 = b.Bld003, // 鐗╂枡鍚嶇О
+ Bld004 = b.Bld004, // 鐗╂枡瑙勬牸
+ Bld007 = b.Bld007, // 璁″垝鏁伴噺
+ Bld008 = b.Bld008 // 宸茶ˉ鏁伴噺
})
.ToList();
--
Gitblit v1.9.3