From d48e486d63ae2a0fc454c27c79b8f12115e4bcbe Mon Sep 17 00:00:00 2001
From: yanjinhui <3306209981@qq.com>
Date: 星期六, 18 十月 2025 16:20:45 +0800
Subject: [PATCH] 修改
---
新建文件夹/WIDESEA_WMSServer/WIDESEA_SquareCabinServices/InventoryServices.cs | 172 +++++++++++++++------------------------------------------
1 files changed, 45 insertions(+), 127 deletions(-)
diff --git "a/\346\226\260\345\273\272\346\226\207\344\273\266\345\244\271/WIDESEA_WMSServer/WIDESEA_SquareCabinServices/InventoryServices.cs" "b/\346\226\260\345\273\272\346\226\207\344\273\266\345\244\271/WIDESEA_WMSServer/WIDESEA_SquareCabinServices/InventoryServices.cs"
index 6f83567..5932661 100644
--- "a/\346\226\260\345\273\272\346\226\207\344\273\266\345\244\271/WIDESEA_WMSServer/WIDESEA_SquareCabinServices/InventoryServices.cs"
+++ "b/\346\226\260\345\273\272\346\226\207\344\273\266\345\244\271/WIDESEA_WMSServer/WIDESEA_SquareCabinServices/InventoryServices.cs"
@@ -79,136 +79,46 @@
}
+
+
+
/// <summary>
- /// wcs鍥炰紶缁欐垜璋冪敤鎴戠殑鏂规硶
+ /// wcs鍥炰紶缁欐垜璋冪敤鎴戠殑鏂规硶 涓嶇鏄叆搴� 鍑哄簱 鐩樼偣閮戒細璋冪敤杩欎釜鎺ュ彛
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
- //public ApiResponse<Dt_Inventory> OrderFeedback(EdiOrderCallbackRequest request)
- //{
- // try
- // {
- // if (request == null || request.details == null || !request.details.Any())
- // {
- // return new ApiResponse<Dt_Inventory> { code = "500", msg = "璇锋眰鍙傛暟鏃犳晥" };
- // }
- // BaseDal.Db.Ado.BeginTran();//寮�鍚簨鍔�
- // foreach (var detail in request.details)
- // {
- // // 鍏堟煡搴撳瓨鏄惁瀛樺湪锛堟寜鐓т骇鍝佺紪鍙峰拰鎵规鏉ュ鎵撅級
- // var entity = BaseDal.Db.Queryable<Dt_Inventory>()
- // .First(x => x.Goods_no == detail.productCode && x.Batch_num == detail.batchNo);
- // //灏嗛泦鍚堜腑鐨勬暟閲忚繘琛岀疮鍔�
- // // 瀹夊叏杞崲
-
- // //姝ｅ父鍑哄叆搴�
- // decimal orderQty = detail.orderDetails?.Sum(x => decimal.TryParse(x.quantity, out var q) ? q : 0) ?? 0;
- // //鐩樼偣鐩樹簭
- // decimal diffQty = detail.stocktakingDetails?.Sum(x => Convert.ToDecimal(x.differenceQuantity)) ?? 0;
- // if (entity == null)
- // {
- // // 濡傛灉涓嶅瓨鍦紝鏂板缓涓�鏉�
- // entity = new Dt_Inventory
- // {
- // Goods_no = detail.productCode ?? detail.productName,
- // Reservoirarea = "榛樿搴撳尯",
- // Batch_num = detail.batchNo,
- // //涓氬姟搴撳瓨
- // Business_qty = 0,
- // //瀹為檯搴撳瓨
- // Actual_qty = 0
- // };
- // }
-
- // switch (request.orderType)
- // {
- // case "1": // 鍏ュ簱
- // entity.Business_qty += orderQty;
- // entity.Actual_qty += orderQty;
- // break;
-
- // case "2": // 鍑哄簱
- // entity.Business_qty -= orderQty;
- // entity.Actual_qty -= orderQty;
- // if (entity.Business_qty < 0) entity.Business_qty = 0; // 鍙�夛細闃叉璐熸暟
- // if (entity.Actual_qty < 0) entity.Actual_qty = 0;
- // break;
-
- // case "3": // 鐩樼偣
- // if (detail.stocktakingDetails != null && detail.stocktakingDetails.Any())
- // {
- // foreach (var stock in detail.stocktakingDetails)
- // {
- // //姣忔閮藉彧鎷夸竴鏉℃槑缁嗕腑鐨勬暟閲�
- // decimal diff = Convert.ToDecimal(stock.differenceQuantity);
- // if (stock.IsProfit == "1") // 鐩樼泩
- // {
- // entity.Business_qty += diff;//濡傛灉鐩樼泩浜嗗浜嗭紝灏卞皢涓氬姟鏁伴噺+锛岀洏浜忓垯鐩稿弽
- // entity.PalletCode = stock.palletCode;
- // }
- // else // 鐩樹簭
- // {
- // entity.Business_qty -= diff;
- // entity.PalletCode = stock.palletCode;
- // }
- // }
- // }
- // break;
- // }
-
- // // 淇濆瓨鏁版嵁
- // if (entity.Id == 0) // 鏂板缓
- // BaseDal.Db.Insertable(entity).ExecuteCommand();
- // else // 鏇存柊
- // BaseDal.Db.Updateable(entity).ExecuteCommand();
- // }
- // BaseDal.Db.Ado.CommitTran(); // 鎻愪氦浜嬪姟
- // return new ApiResponse<Dt_Inventory> { code = "0", msg = "鎴愬姛" };
- // }
- // catch (Exception ex)
- // {
- // BaseDal.Db.Ado.RollbackTran();//鍥炴粴浜嬪姟
- // return new ApiResponse<Dt_Inventory> { code = "500", msg = ex.Message };
- // }
- //}
-
-
public ApiResponse<Dt_InventoryInfo> OrderFeedback(EdiOrderCallbackRequest request)
{
try
{
+ // 1锔忊儯 鏍￠獙璇锋眰
if (request == null || request.details == null || !request.details.Any())
{
return new ApiResponse<Dt_InventoryInfo> { code = "500", msg = "璇锋眰鍙傛暟鏃犳晥" };
}
- BaseDal.Db.Ado.BeginTran(); // 寮�鍚簨鍔�
+ // 2锔忊儯 寮�鍚簨鍔�
+ BaseDal.Db.Ado.BeginTran();
foreach (var detail in request.details)
{
- // 鍏ュ簱鏁伴噺锛堣嚜鍔ㄥ彇姝ｏ級
+ // 3锔忊儯 璁＄畻鍏ュ簱鏁伴噺锛堝彇姝ｏ級
decimal orderQty = detail.orderDetails?
.Sum(x => decimal.TryParse(x.quantity, out var q) ? Math.Abs(q) : 0)
?? 0;
- // 鐩樼偣宸紓鏁�
- decimal diffQty = detail.stocktakingDetails?
- .Sum(x => Convert.ToDecimal(x.differenceQuantity))
- ?? 0;
-
- // 鏌ヨ鐜版湁搴撳瓨鏄庣粏
+ // 5锔忊儯 鏌ヨ搴撳瓨璇︽儏
var entity = BaseDal.Db.Queryable<Dt_InventoryInfo>()
.First(x => x.MaterielCode == detail.productCode && x.BatchNo == detail.batchNo);
if (entity == null)
{
- //涓嶅瓨鍦ㄥ垯鏂板缓搴撳瓨鏄庣粏璁板綍
entity = new Dt_InventoryInfo
{
PalletCode = detail.orderDetails?.FirstOrDefault()?.palletCode ?? "",
- WarehouseCode = 1.ToString(), // 榛樿搴撴埧缂栧彿
+ WarehouseCode = "001",
LocationCode = "",
- StockStatus = 1, // 绔嬪簱鍥哄畾涓� 1
+ StockStatus = 1,
MaterielCode = detail.productCode ?? detail.productName,
MaterielName = detail.productName ?? "",
MaterielSpec = detail.productSpecifications ?? "",
@@ -224,7 +134,7 @@
};
}
- // 鎵规琛ㄨ褰曪紙鐢ㄤ簬姹囨�伙級
+ // 6锔忊儯 鏌ヨ搴撳瓨鎵规淇℃伅
var batch = BaseDal.Db.Queryable<Dt_Inventory_Batch>()
.First(x => x.MaterielCode == detail.productCode && x.BatchNo == detail.batchNo);
@@ -247,9 +157,10 @@
};
}
+ // 7锔忊儯 鎸夎鍗曠被鍨嬫墽琛屼笉鍚岄�昏緫
switch (request.orderType)
{
- case "1": // 鍏ュ簱
+ case "1": //鍏ュ簱
entity.StockQuantity += orderQty;
entity.InDate = DateTime.Now;
entity.Remark = "鍏ュ簱鍗曞洖浼�";
@@ -270,33 +181,28 @@
batch.Remark = "鍑哄簱鍗曞洖浼�";
break;
- case "3": //鐩樼偣
- if (detail.stocktakingDetails != null && detail.stocktakingDetails.Any())
+ case "3": // 鐩樼偣
+ decimal diff = detail.ea ?? 0; // 宸紓鏁�
+ int flag = detail.isLossOrProfit ?? 3; // 1=鐩樹簭, 2=鐩樼泩, 3=鐩樹腑
+
+ if (flag == 1) // 鐩樹簭
{
- foreach (var stock in detail.stocktakingDetails)
- {
- decimal diff = Convert.ToDecimal(stock.differenceQuantity);
- if (stock.IsProfit == "1") // 鐩樼泩
- {
- entity.SupplyQuantity += Math.Abs(diff);
- batch.SupplyQuantity += Math.Abs(diff);
- }
- else // 鐩樹簭
- {
- entity.SupplyQuantity -= Math.Abs(diff);
- batch.SupplyQuantity -= Math.Abs(diff);
- if (entity.SupplyQuantity < 0) entity.SupplyQuantity = 0;
- if (batch.SupplyQuantity < 0) batch.SupplyQuantity = 0;
- }
- entity.PalletCode = stock.palletCode;
- entity.Remark = "鐩樼偣鍗曞洖浼�";
- batch.Remark = "鐩樼偣鍗曞洖浼�";
- }
+ batch.SupplyQuantity = batch.StockQuantity - diff;
+ batch.Remark = "鐩樼偣鍗曞洖浼� - 鐩樹簭";
+ }
+ else if (flag == 2) // 鐩樼泩
+ {
+ batch.SupplyQuantity = batch.StockQuantity + diff;
+ batch.Remark = "鐩樼偣鍗曞洖浼� - 鐩樼泩";
+ }
+ else // 鐩樹腑
+ {
+ batch.Remark = "鐩樼偣鍗曞洖浼� - 鐩樹腑";
}
break;
}
- //淇濆瓨鍒版暟鎹簱
+ // 8锔忊儯 淇濆瓨鏁版嵁
if (entity.Id == 0)
BaseDal.Db.Insertable(entity).ExecuteCommand();
else
@@ -308,13 +214,25 @@
BaseDal.Db.Updateable(batch).ExecuteCommand();
}
+ // 9锔忊儯 鎻愪氦浜嬪姟
BaseDal.Db.Ado.CommitTran();
- return new ApiResponse<Dt_InventoryInfo> { code = "0", msg = "鎴愬姛" };
+
+ return new ApiResponse<Dt_InventoryInfo>
+ {
+ code = "0",
+ msg = "鎴愬姛"
+ };
}
catch (Exception ex)
{
+ // 馃敓 鍥炴粴浜嬪姟
BaseDal.Db.Ado.RollbackTran();
- return new ApiResponse<Dt_InventoryInfo> { code = "500", msg = ex.Message };
+
+ return new ApiResponse<Dt_InventoryInfo>
+ {
+ code = "500",
+ msg = $"澶勭悊澶辫触: {ex.Message}"
+ };
}
}
--
Gitblit v1.9.3