From 242e0bea5bce35582c7066892669871e78a3495f Mon Sep 17 00:00:00 2001
From: yuyou_x <2336760928@qq.com>
Date: 星期三, 27 三月 2024 11:29:14 +0800
Subject: [PATCH] 修改平库出库后未恢复储位信息，修改创建入库单时获取物料数据源
---
Wms/WMS.BLL/BllAsnServer/ArrivalNoticeServer.cs | 45 ++++++++++++++++------
Wms/WMS.BLL/BllPdaServer/PdaSoServer.cs | 18 +++++++++
Wms/Wms/Controllers/BllAsnController.cs | 5 ++
3 files changed, 56 insertions(+), 12 deletions(-)
diff --git a/Wms/WMS.BLL/BllAsnServer/ArrivalNoticeServer.cs b/Wms/WMS.BLL/BllAsnServer/ArrivalNoticeServer.cs
index c8a1d77..9922b6d 100644
--- a/Wms/WMS.BLL/BllAsnServer/ArrivalNoticeServer.cs
+++ b/Wms/WMS.BLL/BllAsnServer/ArrivalNoticeServer.cs
@@ -153,39 +153,58 @@
try
{
string skuType = string.Empty;
+ int IsPack = 0; //0锛氫笉绠� 1锛氳创 2锛氫笉璐�
+ /**
+ * 鎴愬搧璐� 0
+ * 閲囪喘鍙创鍙笉璐� 1
+ * 涓棿鍝佷笉璐� 2
+ * 閫�璐ц创 3
+ * 浣欐枡閫�鍥炲彲璐村彲涓嶈创 4
+ * 鍏跺畠鍙创鍙笉璐� 5
+ * 浠ｅ偍涓嶈创 6
+ * 瀵勫瓨涓嶈创 7
+ */
switch (model.Type)//0锛氬師鏂� 1锛氬寘鏉� 2锛氭垚鍝� 3锛氳�楁潗 4锛氬崐鎴愬搧
{
case "0"://鎴愬搧鍏ュ簱
skuType = "(2)";
+ IsPack = 1; //璐�
+ break;
+ case "1"://閲囪喘鍏ュ簱
+ skuType = "(0,1,3)";
+ break;
+ case "2"://涓棿鍝佸叆搴�
+ skuType = "(4)";
+ IsPack = 2; //涓嶈创
break;
case "3"://閫�璐у叆搴�
skuType = "(2)";
+ IsPack = 1; //璐�
+ break;
+ case "4"://杞﹂棿浣欐枡閫�鍥炲叆搴�
+ skuType = "(0,1,3)";
break;
case "5"://鍏跺畠鍏ュ簱
skuType = "(0,1,3)";
break;
case "6"://浠ｅ偍鍏ュ簱
skuType = "(2)";
- break;
- case "1"://閲囪喘鍏ュ簱
- skuType = "(0,1,3)";
- break;
- case "4"://杞﹂棿浣欐枡閫�鍥炲叆搴�
- skuType = "(0,1,3)";
- break;
- case "2"://涓棿鍝佸叆搴�
- skuType = "(4)";
+ IsPack = 2; //涓嶈创
break;
case "7"://瀵勫瓨鍏ュ簱
- skuType = "(3)";
+ //skuType = "(3)";
+ IsPack = 2; //涓嶈创
break;
default: //鍏跺畠
- skuType = "(0,1,2,3,4)";
+ //skuType = "(0,1,2,3,4)";
break;
}
Expression<Func<SysMaterials, bool>> item = Expressionable.Create<SysMaterials>()
- .AndIF(true, it => skuType.Contains(it.Type))
+ .AndIF(model.Type != "7", it => skuType.Contains(it.Type))
+ .AndIF(model.Type == "7", it => it.SkuNo == "100088")
+ .AndIF(IsPack == 1, it => it.PackagNo != "")
+ .AndIF(IsPack == 2, it => it.PackagNo == "")
.AndIF(true, it => it.IsDel == "0")
.And(it => it.SkuNo != "100099")
.AndIF(!string.IsNullOrWhiteSpace(model.SkuNo),
@@ -201,6 +220,8 @@
.Includes(x => x.PackagInfo)
.ToList();
+
+
return data.Select(m => new MaterialsDto()
{
//Id = m.Id,
diff --git a/Wms/WMS.BLL/BllPdaServer/PdaSoServer.cs b/Wms/WMS.BLL/BllPdaServer/PdaSoServer.cs
index 46fad24..b563a8d 100644
--- a/Wms/WMS.BLL/BllPdaServer/PdaSoServer.cs
+++ b/Wms/WMS.BLL/BllPdaServer/PdaSoServer.cs
@@ -1233,6 +1233,20 @@
#endregion
+ #region 楠岃瘉鍌ㄤ綅鐘舵�佹槸鍚︽甯�
+
+ var locat = Db.Queryable<SysStorageLocat>().First(a=>a.IsDel == "0" && a.LocatNo == result.LocatNo);
+ if (locat == null)
+ {
+ throw new Exception("鏈幏鍙栧埌瀵瑰簲鍌ㄤ綅淇℃伅锛岃妫�鏌�!");
+ }
+ if (locat.Status != "1")
+ {
+ throw new Exception("褰撳墠鍌ㄤ綅涓嶆槸鏈夌墿鍝侊紝璇锋鏌�!");
+ }
+
+ #endregion
+
//鑾峰彇搴撳瓨鏄庣粏淇℃伅
var stockDetail = Db.Queryable<DataStockDetail>().Where(s => s.IsDel == "0" && s.PalletNo == palletNo).ToList();
//楠岃瘉搴撳瓨鏄庣粏淇℃伅鏄惁瀛樺湪
@@ -1284,6 +1298,10 @@
item.AreaNo = "";//鎵�灞炲尯鍩熸洿鏀癸紙鏀逛负绌猴級
Db.Updateable(item).ExecuteCommand();
}
+ //鍙樻洿鍌ㄤ綅鐘舵��
+ locat.Status = "0";//鍌ㄤ綅鏇存敼锛堟敼涓虹┖鍌ㄤ綅锛�
+ Db.Updateable(locat).ExecuteCommand();
+
//鍑哄簱娴佹按锛堟洿鏀圭姸鎬侊級
var allot = Db.Queryable<BllExportAllot>().Where(m => m.IsDel == "0" && m.Status == "1" && m.PalletNo == palletNo && m.SONo == soNo).ToList();
diff --git a/Wms/Wms/Controllers/BllAsnController.cs b/Wms/Wms/Controllers/BllAsnController.cs
index 3336b84..e31f593 100644
--- a/Wms/Wms/Controllers/BllAsnController.cs
+++ b/Wms/Wms/Controllers/BllAsnController.cs
@@ -97,6 +97,11 @@
return Ok(new { code = 1, msg = e.Message });
}
}
+ /// <summary>
+ /// 鑾峰彇娣诲姞鏄庣粏鏁版嵁婧�
+ /// </summary>
+ /// <param name="model"></param>
+ /// <returns></returns>
[HttpPost]
public IActionResult GetMaterialsList(GetMaterialsVm model)
{
--
Gitblit v1.8.0