From f5f720f3dbd2e40d97e0fba51004976aad53d858 Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期四, 13 三月 2025 15:42:12 +0800
Subject: [PATCH] 1.生产退料页面优化
---
service/Warehouse/InventoryManager.cs | 48 +++++++++++++++++++++---------------------------
1 files changed, 21 insertions(+), 27 deletions(-)
diff --git a/service/Warehouse/InventoryManager.cs b/service/Warehouse/InventoryManager.cs
index 4107f50..c3ccba8 100644
--- a/service/Warehouse/InventoryManager.cs
+++ b/service/Warehouse/InventoryManager.cs
@@ -16,9 +16,7 @@
// 妫�鏌ュ簱浣嶄唬鐮佹槸鍚︿负绌�
if (string.IsNullOrEmpty(p_section_code))
- {
throw new Exception("002[璇锋壂搴撲綅鏉＄爜锛�");
- }
// 鏌ヨ搴撳尯搴撲綅淇℃伅
var depotSection = Db.Queryable<MesDepotSections, MesDepots>((a, b) =>
@@ -32,9 +30,7 @@
// 濡傛灉搴撲綅浠ｇ爜涓嶅瓨鍦紝鍒欒繑鍥為敊璇俊鎭�
if (depotSection == null)
- {
throw new Exception("搴撲綅缂栫爜 " + p_section_code + " 涓嶅瓨鍦紝璇风‘璁わ紒");
- }
// 杩斿洖鎴愬姛淇℃伅
return "浠撳簱锛�" + depotSection.DepotName + " 搴撲綅锛�" +
@@ -52,9 +48,7 @@
// 妫�鏌ュ簱浣嶄唬鐮佹槸鍚︿负绌�
if (string.IsNullOrEmpty(p_section_code))
- {
throw new Exception("002[璇锋壂搴撲綅鏉＄爜锛�");
- }
// 鏌ヨ搴撳尯搴撲綅淇℃伅
var depotSection = Db.Queryable<MesDepotSections, MesDepots>((a, b) =>
@@ -63,14 +57,12 @@
))
.Where((a, b) => a.DepotSectionCode == p_section_code)
.Select((a, b) => new
- { a.DepotSectionName, b.DepotCode, b.DepotName, b.DepotId })
+ { a.DepotSectionName, b.DepotCode, b.DepotName, b.DepotId,b.FSubsidiary })
.Single();
// 濡傛灉搴撲綅浠ｇ爜涓嶅瓨鍦紝鍒欒繑鍥為敊璇俊鎭�
if (depotSection == null)
- {
throw new Exception("搴撲綅缂栫爜 " + p_section_code + " 涓嶅瓨鍦紝璇风‘璁わ紒");
- }
// 妫�鏌ユ槸鍚﹀凡缁忔敹璐�
var c_num = Db.Queryable<MesInvItemIns, MesInvItemInCDetails>((a, b) =>
@@ -80,20 +72,14 @@
.Where((a, b) => b.ItemBarcode == p_item_barcode)
.Count();
- if (c_num > 0)
- {
- throw new Exception("002[鏉＄爜閲嶅鎵弿锛岃鏍稿锛�");
- }
+ if (c_num > 0) throw new Exception("002[鏉＄爜閲嶅鎵弿锛岃鏍稿锛�");
// 鏌ヨ鏉＄爜淇℃伅
c_num = Db.Queryable<MesInvItemStocks>()
.Where(t => t.ItemBarcode == p_item_barcode)
.Count();
- if (c_num > 0)
- {
- throw new Exception("002[鏉＄爜宸插湪搴撳瓨涓紝璇锋牳瀵癸紒");
- }
+ if (c_num > 0) throw new Exception("002[鏉＄爜宸插湪搴撳瓨涓紝璇锋牳瀵癸紒");
// 鏌ヨ鏉＄爜璇︾粏淇℃伅
var c_mes_inv_item_barcodes = Db.Queryable<MesInvItemBarcodes>()
@@ -101,14 +87,10 @@
.Single();
if (c_mes_inv_item_barcodes == null)
- {
throw new Exception("002[鏉＄爜涓嶅瓨鍦紝璇锋牳瀵癸紒");
- }
if (c_mes_inv_item_barcodes.ComeFlg != 0)
- {
throw new Exception("002[鏉＄爜涓嶆槸鏈熷垵鏉＄爜锛屾棤娉曠敤鏈熷垵鍏ュ簱锛�");
- }
UseTransaction(db =>
{
@@ -144,9 +126,15 @@
BillNo = billNo,
SuppId = c_mes_inv_item_barcodes.SuppId,
SuppNo = c_mes_inv_item_barcodes.SuppNo,
- UrgentFlag = c_mes_inv_item_barcodes.UrgentFlag == null ? null : c_mes_inv_item_barcodes.UrgentFlag.Value ? "1" : "0",
+ UrgentFlag = c_mes_inv_item_barcodes.UrgentFlag == null
+ ?
+ null
+ : c_mes_inv_item_barcodes.UrgentFlag.Value
+ ? "1"
+ : "0",
CbillNo = c_mes_inv_item_barcodes.BillNo,
- Fstatus = 0
+ Fstatus = 0,
+ ReceiveOrgId = depotSection.FSubsidiary,
};
db.Insertable(newMesInvItemIns)
.IgnoreColumns(true)
@@ -186,7 +174,8 @@
UrgentFlag = c_mes_inv_item_barcodes.UrgentFlag,
BoardStyle = c_mes_inv_item_barcodes.BoardStyle,
TaskNo = c_mes_inv_item_barcodes.TaskNo,
- ItemId = c_mes_inv_item_barcodes.ItemId
+ ItemId = c_mes_inv_item_barcodes.ItemId,
+ ReceiveOrgId = depotSection.FSubsidiary,
}).IgnoreColumns(true).ExecuteCommand();
@@ -226,8 +215,11 @@
ItemNo = c_mes_inv_item_barcodes.ItemNo,
LotNo = c_mes_inv_item_barcodes.LotNo,
Quantity = c_mes_inv_item_barcodes.Quantity,
- EpFlag = c_mes_inv_item_barcodes.EpFlag == null ? null : (byte)(c_mes_inv_item_barcodes.EpFlag.Value ? 1 : 0),
+ EpFlag = c_mes_inv_item_barcodes.EpFlag == null
+ ? null
+ : (byte)(c_mes_inv_item_barcodes.EpFlag.Value ? 1 : 0),
DepotsCode = depotSection.DepotCode,
+ DepotId = depotSection.DepotId,
DepotsId = depotSection.DepotId,
DepotSectionsCode = p_section_code,
CheckDate = c_mes_inv_item_barcodes.CreateDate,
@@ -237,7 +229,9 @@
WorkLine = c_mes_inv_item_barcodes.WorkLine,
// ItemUnit = c_mes_inv_item_barcodes.Unit,
SuppNo = c_mes_inv_item_barcodes.SuppNo,
- ItemId = c_mes_inv_item_barcodes.ItemId
+ ItemId = c_mes_inv_item_barcodes.ItemId,
+ IndepUserCode = c_user,
+ StockOrgId = depotSection.FSubsidiary,
// Fsubsidiary = c_organize
}).IgnoreColumns(true).ExecuteCommand();
@@ -245,7 +239,7 @@
});
var mesItems = Db.Queryable<MesItems>()
- .Where(s=>s.Id == c_mes_inv_item_barcodes.ItemId)
+ .Where(s => s.Id == c_mes_inv_item_barcodes.ItemId)
.First();
query.itemNo = mesItems.ItemNo;
--
Gitblit v1.9.3