From d07f25c163706ac46a83bd2c63db1e3c52715222 Mon Sep 17 00:00:00 2001
From: zhaowc <526854230@qq.com>
Date: 星期四, 27 三月 2025 15:54:25 +0800
Subject: [PATCH] 解决问题
---
Wms/WMS.BLL/BllPdaServer/PdaAsnServer.cs | 163 +++++++++++++++++++++++++++++++++---------------------
1 files changed, 100 insertions(+), 63 deletions(-)
diff --git a/Wms/WMS.BLL/BllPdaServer/PdaAsnServer.cs b/Wms/WMS.BLL/BllPdaServer/PdaAsnServer.cs
index 716f754..3ff3e48 100644
--- a/Wms/WMS.BLL/BllPdaServer/PdaAsnServer.cs
+++ b/Wms/WMS.BLL/BllPdaServer/PdaAsnServer.cs
@@ -44,7 +44,7 @@
try
{
//model.Type锛氬崟鎹被鍨� 鍦ㄨ繖閲屼唬琛ㄥ墠绔〉绛剧被鍨嬶細鍗虫爣绛鹃〉绛撅細璐存爣鐗╂枡锛� 鏁伴噺椤电锛氫笉璐磋〃鐗╂枡锛屽師鍥狅細鎳掑緱鍔犲弬鏁�
- var data = Db.Queryable<BllArrivalNotice>().Where(m => m.IsDel == "0" && m.Status != "3" && m.Status != "4").Select(m => m.ASNNo).ToList();
+ var data = Db.Queryable<BllArrivalNotice>().Where(m => m.IsDel == "0" && m.Status !="2" && m.Status != "3" && m.Status != "4").Select(m => m.ASNNo).ToList();
var list = new List<ArrivalNoticeDetailDto>();
if (model.Type.Contains("0"))//0璐存爣
{
@@ -257,6 +257,42 @@
else
{
sqlMsg = "-1:鎵樼洏鍙蜂笉瀛樺湪!";
+ }
+
+ return sqlMsg;
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ }
+
+
+
+ /// <summary>
+ /// 楠岃瘉鍦扮爜鏄惁瀛樺湪
+ /// </summary>
+ /// <param name="locatNo">鍦扮爜</param>
+ /// <returns>"":鍙娇鐢� -1:涓嶅彲浣跨敤锛堝師鍥�)</returns>
+ public string IsEnableLocatNo(string locatNo)
+ {
+ string sqlMsg = "";
+ string sqlString = string.Empty;
+ try
+ {
+ sqlString = $"select * from SysStorageLocat where LocatNo = '{locatNo}' and WareHouseNo = 'W02' and isdel = '0';";
+ var models = Db.Ado.SqlQuery<PalletBindVm>(sqlString);
+
+ if (models.Count > 0)
+ {
+ if (models[0].Status != "0")
+ {
+ sqlMsg = "-1:姝ゅ簱浣嶄娇鐢ㄤ腑锛岃鍦ㄥ簱鍐呰鏍稿疄!";
+ }
+ }
+ else
+ {
+ sqlMsg = "-1:搴撲綅涓嶅瓨鍦�!";
}
return sqlMsg;
@@ -1762,8 +1798,8 @@
SupplierLot = "",
InspectMark = "0",
BitPalletMark = "1",
- IsBale = "0",
- IsBelt = "0",
+ IsBale = arrivalnotice.IsBale,
+ IsBelt = arrivalnotice.IsBelt,
CreateUser = userId
};
// 鎻掑叆鎵樼洏缁戝畾琛�
@@ -1836,8 +1872,8 @@
BitPalletMark = "1",
InspectStatus = sku.IsInspect,// 缁勭洏鐨勬椂鍊欏氨瑕侀粯璁よ瀹氬ソ鏄惁鍚堟牸
PackagNo = sku.PackagNo,
- IsBale = null,
- IsBelt = null,
+ IsBale = arrivalnotice.IsBale,
+ IsBelt = arrivalnotice.IsBelt,
CreateUser = userId,
CreateTime = serverTime
};
@@ -1921,62 +1957,62 @@
#region 娴嬭瘯鐗堟湰
- //璇诲彇json鏂囦欢锛屾坊鍔犳暟鎹�
- var ss = AppDomain.CurrentDomain.BaseDirectory;
- string filePath = Path.Combine(ss, "CreateBoxInfo.json");
- string json = File.ReadAllText(filePath);
- var person = JsonConvert.DeserializeObject<List<BllBoxInfo>>(json);
+ ////璇诲彇json鏂囦欢锛屾坊鍔犳暟鎹�
+ //var ss = AppDomain.CurrentDomain.BaseDirectory;
+ //string filePath = Path.Combine(ss, "CreateBoxInfo.json");
+ //string json = File.ReadAllText(filePath);
+ //var person = JsonConvert.DeserializeObject<List<BllBoxInfo>>(json);
var comTime = DateTime.Now;
- //娣诲姞绠辩爜淇℃伅琛ㄤ腑 //鏆傛椂杩欎簺鍐�--娣诲姞鏁版嵁锛屽悗缁渶瑕佸拰璧嬬爜绯荤粺瀵规帴鍚� 鏍规嵁鏄庣‘杩斿洖鐨勬暟鎹牸寮忔洿鏀�
- foreach (var item in person)
- {
- if (item.BoxNo!= boxNo)
- {
- continue;
- }
+ ////娣诲姞绠辩爜淇℃伅琛ㄤ腑 //鏆傛椂杩欎簺鍐�--娣诲姞鏁版嵁锛屽悗缁渶瑕佸拰璧嬬爜绯荤粺瀵规帴鍚� 鏍规嵁鏄庣‘杩斿洖鐨勬暟鎹牸寮忔洿鏀�
+ //foreach (var item in person)
+ //{
+ // if (item.BoxNo!= boxNo)
+ // {
+ // continue;
+ // }
- var sku = Db.Queryable<SysMaterials>().First(m=>m.IsDel =="0" && m.SkuNo == item.SkuNo);
- if (sku == null)
- {
- continue;
- }
- var boxInfo = new BllBoxInfo()
- {
- ASNNo = "",
- //ASNDetailNo = 0,
- OrderCode = "",
- //BindNo = 0,
- BoxNo = item.BoxNo,
- BoxNo2 = item.BoxNo2,
- BoxNo3 = item.BoxNo3,
- PalletNo = "",
- Qty = item.Qty,
- FullQty = item.FullQty,
- Status = "0",
- SkuNo = item.SkuNo,
- SkuName = sku.SkuName,
- LotNo = item.LotNo,
- LotText = item.LotText,
- SupplierLot = item.SupplierLot,
- ProductionTime = item.ProductionTime,
- ExpirationTime = item.ExpirationTime,
- //CompleteTime = comTime,
- InspectMark = item.InspectMark,
- BitBoxMark = item.BitBoxMark,
- InspectStatus = item.InspectStatus,
- Origin = "璧嬬爜",
- Standard = item.Standard,
- PackageStandard = item.PackageStandard,
- StoreTime = item.StoreTime,
- QtyOrd = item.QtyOrd,
- QtyCount = item.QtyCount,
- CreateUser = 0,
- CreateTime = comTime,
- };
- list.Add(boxInfo);
- }
- Db.Insertable(list).ExecuteCommand();
+ // var sku = Db.Queryable<SysMaterials>().First(m=>m.IsDel =="0" && m.SkuNo == item.SkuNo);
+ // if (sku == null)
+ // {
+ // continue;
+ // }
+ // var boxInfo = new BllBoxInfo()
+ // {
+ // ASNNo = "",
+ // //ASNDetailNo = 0,
+ // OrderCode = "",
+ // //BindNo = 0,
+ // BoxNo = item.BoxNo,
+ // BoxNo2 = item.BoxNo2,
+ // BoxNo3 = item.BoxNo3,
+ // PalletNo = "",
+ // Qty = item.Qty,
+ // FullQty = item.FullQty,
+ // Status = "0",
+ // SkuNo = item.SkuNo,
+ // SkuName = sku.SkuName,
+ // LotNo = item.LotNo,
+ // LotText = item.LotText,
+ // SupplierLot = item.SupplierLot,
+ // ProductionTime = item.ProductionTime,
+ // ExpirationTime = item.ExpirationTime,
+ // //CompleteTime = comTime,
+ // InspectMark = item.InspectMark,
+ // BitBoxMark = item.BitBoxMark,
+ // InspectStatus = item.InspectStatus,
+ // Origin = "璧嬬爜",
+ // Standard = item.Standard,
+ // PackageStandard = item.PackageStandard,
+ // StoreTime = item.StoreTime,
+ // QtyOrd = item.QtyOrd,
+ // QtyCount = item.QtyCount,
+ // CreateUser = 0,
+ // CreateTime = comTime,
+ // };
+ // list.Add(boxInfo);
+ //}
+ //Db.Insertable(list).ExecuteCommand();
#endregion
@@ -1989,7 +2025,7 @@
{ "Token", token }, //鍒嗛厤鐨勪护鐗岋紙鍙橀噺锛�
{ "Barcode", boxNo },//瑕佹煡璇㈢殑鏉＄爜
{ "getParent", getParentVal },//鏄惁鏌ヨ鐖剁爜
- { "getChildren", getChildrenVal } //鏄惁鏌ヨ瀛愮爜
+ { "getChildren", getChildrenVal } //鏄惁鏌ヨ瀛愮爜 aaa
};
//绋嬪簭姝ｅ紡鍙戝竷鍚庢斁寮�
@@ -2014,10 +2050,10 @@
throw new Exception("鑾峰彇淇℃伅涓嶄竴鑷�");
}
- var sku = Db.Queryable<SysMaterials>().First(m => m.IsDel == "0" && m.SkuNo == fuMaModel.Product.ProductCode);
+ var sku = Db.Queryable<SysMaterials>().First(m => m.IsDel == "0" && m.SkuNo == fuMaModel.MaterialNum);
if (sku == null)
{
- throw new Exception("鏈煡璇㈠埌绠辩爜涓殑鐗╂枡淇℃伅");
+ throw new Exception("鏈煡璇㈠埌绠辩爜涓拰璧嬬爜鎻愪緵鐨勭墿鏂欎俊鎭竴鑷寸殑鏁版嵁");
}
var boxInfo = new BllBoxInfo()
{
@@ -2546,6 +2582,7 @@
DateTime proTime;
DateTime expTime;
+ DateTime sortTime;
var bl1 = DateTime.TryParse(detail.Lot1, out proTime);
var bl2 = DateTime.TryParse(detail.Lot2, out expTime);
@@ -2574,8 +2611,8 @@
SupplierLot = detail.SupplierLot,
InspectMark = "0",
BitPalletMark = "1",
- IsBale = "0",
- IsBelt = "0",
+ IsBale = detail.IsBale,
+ IsBelt = detail.IsBelt,
CreateUser = userId,
Demo = model.Demo,
--
Gitblit v1.8.0