From 4aa0b9c9c2c56ec1af1dc3ee8ef12c9374b3d1ff Mon Sep 17 00:00:00 2001
From: wxw <Administrator@DESKTOP-5BIMHQ3>
Date: 星期四, 27 十一月 2025 11:36:08 +0800
Subject: [PATCH] 修改车间记录列表数据显示异常问题
---
Wms/WMS.BLL/BllPdaServer/PdaSoServer.cs | 297 ++++++++++++++++++++++++++++++++---------------------------
1 files changed, 161 insertions(+), 136 deletions(-)
diff --git a/Wms/WMS.BLL/BllPdaServer/PdaSoServer.cs b/Wms/WMS.BLL/BllPdaServer/PdaSoServer.cs
index bf46865..1bb1eb6 100644
--- a/Wms/WMS.BLL/BllPdaServer/PdaSoServer.cs
+++ b/Wms/WMS.BLL/BllPdaServer/PdaSoServer.cs
@@ -42,7 +42,7 @@
/// <param name="boxNo"></param>
/// <param name="palletNoNew"></param>
/// <param name="userId"></param>
- public async Task SoSetPinPick34(string soNo, string soDetailId, string palletNo, string boxNo , string palletNoNew, int userId)
+ public async Task SoSetPinPick34(string soNo, string soDetailId, string palletNo, string boxNo, string palletNoNew, int userId)
{
Db.BeginTran();
try
@@ -85,16 +85,13 @@
throw Oops.Bah("鍑哄簱鍗曠殑鐘舵�佷笉鏄鍦ㄦ墽琛岋紝涓嶈兘鎷ｈ揣");
}
//鍑哄簱鍗曟槑缁�
- var noticeDetail = await Db.Queryable<BllExportNoticeDetail>()
- .FirstAsync(m => m.IsDel == "0" && m.Id == int.Parse(soDetailId));
+ var noticeDetail = await Db.Queryable<BllExportNoticeDetail>().FirstAsync(m => m.IsDel == "0" && m.Id == int.Parse(soDetailId));
if (noticeDetail == null)
{
throw Oops.Bah("鏈煡璇㈠埌璇ュ嚭搴撳崟鏄庣粏鐨勪俊鎭�");
}
//鍑哄簱鍒嗛厤淇℃伅
- var allot = await Db.Queryable<BllExportAllot>().FirstAsync(m =>
- m.IsDel == "0" && (m.Status == "2" || m.Status == "3" || m.Status == "5") && m.SONo == soNo &&
- m.SODetailNo == int.Parse(soDetailId) && m.PalletNo == palletNo);
+ var allot = await Db.Queryable<BllExportAllot>().FirstAsync(m => m.IsDel == "0" && (m.Status == "2" || m.Status == "3" || m.Status == "5") && m.SONo == soNo && m.SODetailNo == int.Parse(soDetailId) && m.PalletNo == palletNo);
if (allot == null)
{
throw Oops.Bah("鏈煡璇㈠埌璇ユ墭鐩樼殑鍒嗛厤淇℃伅");
@@ -122,25 +119,33 @@
bool isNew = false;
var pinStockDetail = Db.Queryable<DataStockDetail>().First(m => m.IsDel == "0" && m.PalletNo == palletNoNew && m.SkuNo == stockDetail.SkuNo && m.LotNo == stockDetail.LotNo);
-
- if (pinStockDetail != null)
+ //var pinStockDetail = Db.Queryable<DataStockDetail>().First(m => m.IsDel == "0" && m.PalletNo == palletNoNew);
+
+ if (pinStockDetail != null)
{
+ //淇敼鎵樼洏琛ㄧ姸鎬佽鎵樼洏琛ㄥ拰搴撳瓨鏄庣粏琛ㄤ繚鎸佷竴鑷�
+ string uptPalletStatusSql = $@"update SysPallets set Status='1' where PalletNo='{palletNoNew}'";
+ int uptPalletStatus = Db.Ado.ExecuteCommand(uptPalletStatusSql);
+ Db.CommitTran();
+
if (palletNo != palletNoNew)//闈炴暣鎵樻嫞璐�
{
- var pinStockDetails = Db.Queryable<DataStockDetail>().Where(m => m.IsDel == "0" && m.PalletNo == palletNoNew && m.Id!= pinStockDetail.Id).ToList();
- if (pinStockDetails.Count(m=>m.SONo != notice.SONo) > 0)
+ //var pinStockDetails = Db.Queryable<DataStockDetail>().Where(m => m.IsDel == "0" && m.PalletNo == palletNoNew && m.Id != pinStockDetail.Id).ToList();
+ var pinStockDetails = Db.Queryable<DataStockDetail>().Where(m => m.IsDel == "0" && m.PalletNo == palletNoNew).ToList();
+ //鍙厑璁哥粦瀹氬悓涓�涓嚭搴撳崟涓嬬殑鐗╂枡
+ if (pinStockDetails.Count(m => m.SONo != notice.SONo) > 0)
{
throw Oops.Bah("鎷兼墭鎵樼洏涓婂彧鑳芥斁鍚屼竴涓嚭搴撳崟涓嬬殑鐗╂枡锛�");
}
}
-
+
sdId = pinStockDetail.Id;
}
else
{
isNew = true;
- var newPalletInfo = await Db.Queryable<SysPallets>().FirstAsync(m => m.IsDel == "0" && m.PalletNo == palletNoNew && m.Status == "0");
+ var newPalletInfo = await Db.Queryable<SysPallets>().FirstAsync(m => m.IsDel == "0" && m.PalletNo == palletNoNew);//&& m.Status == "0"
if (newPalletInfo == null)
{
throw Oops.Bah("鏂版墭鐩樹俊鎭笉瀛樺湪锛�");
@@ -148,6 +153,7 @@
if (newPalletInfo.Status == "0")
{
var pinStockDetails = Db.Queryable<DataStockDetail>().Where(m => m.IsDel == "0" && m.PalletNo == palletNoNew && (m.SkuNo != stockDetail.SkuNo || m.LotNo != stockDetail.LotNo)).ToList();
+ //鍙厑璁哥粦瀹氬悓涓�涓嚭搴撳崟涓嬬殑鐗╂枡
if (pinStockDetails.Count(m => m.SONo != notice.SONo) > 0)
{
throw Oops.Bah("涓�涓墭鐩樺彧鑳芥帴鍙椾竴涓嚭搴撳崟鎷兼墭锛�");
@@ -159,9 +165,9 @@
newPalletInfo.Status = "1";
await Db.Updateable(newPalletInfo).ExecuteCommandAsync();
}
-
+
}
-
+
var sd = new DataStockDetail();
if (isNew)
{
@@ -207,6 +213,10 @@
sd.UDF5 = "1";
//鏂板鎷兼墭搴撳瓨鏄庣粏淇℃伅
sdId = await Db.Insertable(sd).ExecuteReturnIdentityAsync();
+
+ //淇敼鎵樼洏琛ㄧ姸鎬佽鎵樼洏琛ㄥ拰搴撳瓨鏄庣粏琛ㄤ繚鎸佷竴鑷�
+ string uptPalletStatusSql = $@"update SysPallets set Status='1' where PalletNo='{palletNoNew}'";
+ int uptPalletStatus = Db.Ado.ExecuteCommand(uptPalletStatusSql);
}
#endregion
@@ -234,10 +244,10 @@
{
throw Oops.Bah($"褰撳墠{item.BoxNo}宸叉嫞璐у畬鎴愶紝璇峰嬁閲嶅鎷ｈ揣");
}
- if (item.SkuNo != allot.SkuNo || item.LotNo != allot.LotNo)
- {
- throw Oops.Bah("褰撳墠鎵樼洏涓婃湁鍏朵粬涓嶅悓鐗╂枡鎵规锛屾嫞璐уけ璐�");
- }
+ //if (item.SkuNo != allot.SkuNo || item.LotNo != allot.LotNo)
+ //{
+ // throw Oops.Bah("褰撳墠鎵樼洏涓婃湁鍏朵粬涓嶅悓鐗╂枡鎵规锛屾嫞璐уけ璐�");
+ //}
//娣诲姞鎷ｈ揣鏄庣粏
var completeDetail = new BllCompleteDetail()
{
@@ -347,9 +357,9 @@
}
boxInfos = boxInfo.ToList();
var comDetailList = await Db.Queryable<BllCompleteDetail>().Where(m => m.IsDel == "0" && m.ExportAllotId == allot.Id && m.PalletNo == palletNo).ToListAsync();
-
+
//鏁寸鎷ｈ揣
-
+
if (boxInfo.Any(m => m.PalletNo != palletNo))
{
throw Oops.Bah("璇ユ墭鐩樹笌绠辩爜娌℃湁缁戝畾鍏崇郴");
@@ -359,7 +369,7 @@
//{
// throw Oops.Bah("鎷ｈ揣鏁伴噺涓嶈兘澶т簬绠卞唴鍓╀綑寰呮嫞鏁伴噺");
//}
-
+
foreach (var item in boxInfos)
{
if (comDetailList.Any(m => m.BoxNo == item.BoxNo))
@@ -367,7 +377,7 @@
throw Oops.Bah($"褰撳墠{item.BoxNo}宸叉嫞璐у畬鎴愶紝璇峰嬁閲嶅鎷ｈ揣");
}
}
-
+
var comList = new List<BllCompleteDetail>();
foreach (var item in boxInfos)
@@ -403,20 +413,20 @@
item.BindNo = null;//鎵樼洏缁戝畾鍙�
item.PalletNo = palletNoNew;
}
-
+
item.Status = "5";//绠辨敮鐘舵�侊紝0锛氭湭缁勬墭 1锛氬凡缁勬墭 2锛氬凡鍏ュ簱 3锛氬凡鍑哄簱 4:宸插垎閰� 5锛氬凡鎷ｈ揣
await Db.Updateable(item).ExecuteCommandAsync();
pickQty += item.Qty;
-
+
}
-
+
await Db.Insertable(comList).ExecuteCommandAsync();
//淇敼鍑哄簱鍒嗛厤淇℃伅
allot.CompleteQty += pickQty;
allot.Status = allot.Qty <= allot.CompleteQty ? "5" : "3";
allot.UpdateTime = DateTime.Now;
-
+
await Db.Updateable(allot).ExecuteCommandAsync();
//鍒犻櫎鎴栦慨鏀瑰簱瀛樻槑缁�
@@ -446,28 +456,32 @@
var locateStr = stockDetail.LocatNo;
await Db.Deleteable(stockDetail).ExecuteCommandAsync();
- //鏀瑰彉鎵樼洏鐘舵��
- var pallet = await Db.Queryable<SysPallets>().FirstAsync(m => m.PalletNo == palletNo && m.IsDel == "0");
- if (pallet == null)
+ var detailOther = Db.Queryable<DataStockDetail>().Where(w => w.IsDel == "0" && w.PalletNo == stockDetail.PalletNo && w.Id != stockDetail.Id).ToList();
+ if (detailOther.Count <= 0)
{
- throw Oops.Bah("鏈湪鎵樼洏琛ㄤ腑鏌ヨ鍒版墭鐩樹俊鎭�");
- }
- pallet.Status = "0";
- await Db.Updateable(pallet).ExecuteCommandAsync();
+ //鏀瑰彉鎵樼洏鐘舵��
+ var pallet = await Db.Queryable<SysPallets>().FirstAsync(m => m.PalletNo == palletNo && m.IsDel == "0");
+ if (pallet == null)
+ {
+ throw Oops.Bah("鏈湪鎵樼洏琛ㄤ腑鏌ヨ鍒版墭鐩樹俊鎭�");
+ }
+ pallet.Status = "0";
+ await Db.Updateable(pallet).ExecuteCommandAsync();
- //鏇存敼鍌ㄤ綅鐘舵�佷负绌哄偍浣�
- var locate = Db.Queryable<SysStorageLocat>().First(m => m.IsDel == "0" && m.LocatNo == locateStr);
- if (locate != null)
- {
- locate.Status = "0";
- Db.Updateable(locate).ExecuteCommand();
+ //鏇存敼鍌ㄤ綅鐘舵�佷负绌哄偍浣�
+ var locate = Db.Queryable<SysStorageLocat>().First(m => m.IsDel == "0" && m.LocatNo == locateStr);
+ if (locate != null)
+ {
+ locate.Status = "0";
+ Db.Updateable(locate).ExecuteCommand();
+ }
}
}
else
{
await Db.Updateable(stockDetail).ExecuteCommandAsync();
}
-
+
//淇敼鍑哄簱鍗曟槑缁嗘嫞璐ф暟閲�
noticeDetail.CompleteQty += pickQty;
await Db.Updateable(noticeDetail).ExecuteCommandAsync();
@@ -498,7 +512,7 @@
pinStockDetail.LockQty += pickQty;
await Db.Updateable(pinStockDetail).ExecuteCommandAsync();
}
- }
+ }
//娣诲姞鎿嶄綔鏃ュ織璁板綍
var k = new OperationSOServer().AddLogOperationSo("PDA妯″潡", "鎷ｈ揣鎷兼墭", soNo, "鎷ｈ揣", $"鍦≒DA涓婂鍑哄簱鍗曞彿涓猴細{soNo}鐨勫師鎵樼洏鐮佷负锛歿palletNo}锛屾柊鎵樼洏鐮佷负锛歿palletNoNew}鐨勬嫞璐ф嫾鎵樻搷浣�", userId);
@@ -552,16 +566,13 @@
throw Oops.Bah("鍑哄簱鍗曠殑鐘舵�佷笉鏄鍦ㄦ墽琛岋紝涓嶈兘鎷ｈ揣");
}
//鍑哄簱鍗曟槑缁�
- var noticeDetail = await Db.Queryable<BllExportNoticeDetail>()
- .FirstAsync(m => m.IsDel == "0" && m.Id == int.Parse(soDetailId));
+ var noticeDetail = await Db.Queryable<BllExportNoticeDetail>().FirstAsync(m => m.IsDel == "0" && m.Id == int.Parse(soDetailId));
if (noticeDetail == null)
{
throw Oops.Bah("鏈煡璇㈠埌璇ュ嚭搴撳崟鏄庣粏鐨勪俊鎭�");
}
//鍑哄簱鍒嗛厤淇℃伅
- var allot = await Db.Queryable<BllExportAllot>().FirstAsync(m =>
- m.IsDel == "0" && (m.Status == "2" || m.Status == "3") && m.SONo == soNo &&
- m.SODetailNo == int.Parse(soDetailId) && m.PalletNo == palletNo);
+ var allot = await Db.Queryable<BllExportAllot>().FirstAsync(m => m.IsDel == "0" && (m.Status == "2" || m.Status == "3") && m.SONo == soNo && m.SODetailNo == int.Parse(soDetailId) && m.PalletNo == palletNo);
if (allot == null)
{
throw Oops.Bah("鏈煡璇㈠埌璇ユ墭鐩樼殑鍒嗛厤淇℃伅");
@@ -596,12 +607,19 @@
#region 鎷兼墭淇℃伅
bool isNew = false;
- var pinStockDetail = await Db.Queryable<DataStockDetail>().FirstAsync(m => m.IsDel == "0" && m.PalletNo == palletNoNew && m.SkuNo== stockDetail.SkuNo && m.LotNo == stockDetail.LotNo);
+ var pinStockDetail = await Db.Queryable<DataStockDetail>().FirstAsync(m => m.IsDel == "0" && m.PalletNo == palletNoNew && m.SkuNo == stockDetail.SkuNo && m.LotNo == stockDetail.LotNo);
+ //var pinStockDetail = await Db.Queryable<DataStockDetail>().FirstAsync(m => m.IsDel == "0" && m.PalletNo == palletNoNew);
if (pinStockDetail != null)
{
+ //淇敼鎵樼洏琛ㄧ姸鎬佽鎵樼洏琛ㄥ拰搴撳瓨鏄庣粏琛ㄤ繚鎸佷竴鑷�
+ string uptPalletStatusSql = $@"update SysPallets set Status='1' where PalletNo='{palletNoNew}'";
+ int uptPalletStatus = Db.Ado.ExecuteCommand(uptPalletStatusSql);
+ Db.CommitTran();
+
if (palletNo != palletNoNew)//闈炴暣鎵樻嫞璐�
{
- var pinStockDetails = Db.Queryable<DataStockDetail>().Where(m => m.IsDel == "0" && m.PalletNo == palletNoNew && m.Id != pinStockDetail.Id).ToList();
+ //var pinStockDetails = Db.Queryable<DataStockDetail>().Where(m => m.IsDel == "0" && m.PalletNo == palletNoNew && m.Id != pinStockDetail.Id).ToList();
+ var pinStockDetails = Db.Queryable<DataStockDetail>().Where(m => m.IsDel == "0" && m.PalletNo == palletNoNew).ToList();
if (pinStockDetails.Count(m => m.SONo != notice.SONo) > 0)
{
throw Oops.Bah("鎷兼墭鎵樼洏涓婂彧鑳芥斁鍚屼竴涓嚭搴撳崟涓嬬殑鐗╂枡锛�");
@@ -612,8 +630,13 @@
{
isNew = true;
- var newPalletInfo = await Db.Queryable<SysPallets>().FirstAsync(m => m.IsDel == "0" && m.PalletNo == palletNoNew && m.Status == "0");
+ //var newPalletInfo = await Db.Queryable<SysPallets>().FirstAsync(m => m.IsDel == "0" && m.PalletNo == palletNoNew && m.Status == "0");
+ var newPalletInfo = await Db.Queryable<SysPallets>().FirstAsync(m => m.IsDel == "0" && m.PalletNo == palletNoNew);
if (newPalletInfo == null)
+ {
+ throw Oops.Bah("鏂版墭鐩樹俊鎭笉瀛樺湪锛�");
+ }
+ if (newPalletInfo.Status == "0")
{
var pinStockDetails = Db.Queryable<DataStockDetail>().Where(m => m.IsDel == "0" && m.PalletNo == palletNoNew && (m.SkuNo != stockDetail.SkuNo && m.LotNo != stockDetail.LotNo)).ToList();
if (pinStockDetails.Count(m => m.SONo != notice.SONo) > 0)
@@ -631,54 +654,58 @@
if (isNew)
{
- var sd = new DataStockDetail();
+ var sd = new DataStockDetail
+ {
+ LotNo = stockDetail.LotNo,
+ LotText = stockDetail.LotText,
+ SupplierLot = stockDetail.SupplierLot,
+ SkuNo = stockDetail.SkuNo,
+ SkuName = stockDetail.SkuName,
+ Standard = stockDetail.Standard,
- sd.LotNo = stockDetail.LotNo;
- sd.LotText = stockDetail.LotText;
- sd.SupplierLot = stockDetail.SupplierLot;
- sd.SkuNo = stockDetail.SkuNo;
- sd.SkuName = stockDetail.SkuName;
- sd.Standard = stockDetail.Standard;
+ Qty = int.Parse(PickQty),
+ LockQty = int.Parse(PickQty),
- sd.Qty = int.Parse(PickQty);
- sd.LockQty = int.Parse(PickQty);
+ FrozenQty = 0,
+ InspectQty = 0,
+ ASNNo = "",
+ ASNDetailNo = null,
+ SONo = soNo,//鍑哄簱鍗曞彿
+ WareHouseNo = "",
+ RoadwayNo = "",
+ AreaNo = "",
+ LocatNo = "",
+ PalletNo = palletNoNew,
+ PalletNo2 = "",
+ PalletNo3 = "",
+ //PalletType = item.PalletType,
+ CompleteTime = nowDate,
+ ProductionTime = stockDetail.ProductionTime,
+ ExpirationTime = stockDetail.ExpirationTime,
+ Status = "2",//鐘舵�侊紝宸插垎閰�
+ InspectMark = stockDetail.InspectMark,
+ InspectStatus = stockDetail.InspectStatus,
+ BitPalletMark = "0",
+ PackagNo = noticeDetail.PackagNo,
+ IsBale = stockDetail.IsBale,
+ IsBelt = stockDetail.IsBelt,
+ Demo = stockDetail.Demo,
+ OwnerName = stockDetail.OwnerName,
+ OwnerNo = stockDetail.OwnerNo,
+ SupplierName = stockDetail.SupplierName,
+ SupplierNo = stockDetail.SupplierNo,
- sd.FrozenQty = 0;
- sd.InspectQty = 0;
- sd.ASNNo = "";
- sd.ASNDetailNo = null;
- sd.SONo = soNo;//鍑哄簱鍗曞彿
- sd.WareHouseNo = "";
- sd.RoadwayNo = "";
- sd.AreaNo = "";
- sd.LocatNo = "";
- sd.PalletNo = palletNoNew;
- sd.PalletNo2 = "";
- sd.PalletNo3 = "";
- //PalletType = item.PalletType,
- sd.CompleteTime = nowDate;
- sd.ProductionTime = stockDetail.ProductionTime;
- sd.ExpirationTime = stockDetail.ExpirationTime;
- sd.Status = "2";//鐘舵�侊紝宸插垎閰�
- sd.InspectMark = stockDetail.InspectMark;
- sd.InspectStatus = stockDetail.InspectStatus;
- sd.BitPalletMark = "0";
- sd.PackagNo = noticeDetail.PackagNo;
- sd.IsBale = stockDetail.IsBale;
- sd.IsBelt = stockDetail.IsBelt;
- sd.Demo = stockDetail.Demo;
- sd.OwnerName = stockDetail.OwnerName;
- sd.OwnerNo = stockDetail.OwnerNo;
- sd.SupplierName = stockDetail.SupplierName;
- sd.SupplierNo = stockDetail.SupplierNo;
-
- sd.IsDel = "0";
- sd.CreateUser = userId;
- sd.CreateTime = nowDate;
- sd.UDF5 = "1";
-
+ IsDel = "0",
+ CreateUser = userId,
+ CreateTime = nowDate,
+ UDF5 = "1"
+ };
//鏂板鎷兼墭搴撳瓨鏄庣粏淇℃伅
await Db.Insertable(sd).ExecuteReturnIdentityAsync();
+
+ //淇敼鎵樼洏琛ㄧ姸鎬佽鎵樼洏琛ㄥ拰搴撳瓨鏄庣粏琛ㄤ繚鎸佷竴鑷�
+ string uptPalletStatusSql = $@"update SysPallets set Status='1' where PalletNo='{palletNoNew}'";
+ int uptPalletStatus = Db.Ado.ExecuteCommand(uptPalletStatusSql);
}
else
{
@@ -805,8 +832,8 @@
await Db.Updateable(pallet).ExecuteCommandAsync();
//鏇存敼鍌ㄤ綅鐘舵�佷负绌哄偍浣�
- var locate = Db.Queryable<SysStorageLocat>().First(m=>m.IsDel == "0" && m.LocatNo == locateStr);
- if (locate!=null)
+ var locate = Db.Queryable<SysStorageLocat>().First(m => m.IsDel == "0" && m.LocatNo == locateStr);
+ if (locate != null)
{
locate.Status = "0";
Db.Updateable(locate).ExecuteCommand();
@@ -818,8 +845,7 @@
noticeDetail.CompleteQty += int.Parse(PickQty);
await Db.Updateable(noticeDetail).ExecuteCommandAsync();
- var num = await Db.Queryable<BllExportNoticeDetail>()
- .CountAsync(m => m.IsDel == "0" && m.SONo == soNo && m.CompleteQty < m.Qty);
+ var num = await Db.Queryable<BllExportNoticeDetail>().CountAsync(m => m.IsDel == "0" && m.SONo == soNo && m.CompleteQty < m.Qty);
if (num <= 0)
{
notice.Status = "4"; //鏇存敼涓烘墽琛屽畬鎴�
@@ -1525,7 +1551,7 @@
//搴撳瓨鏄庣粏
var stockDetail = await Db.Queryable<DataStockDetail>()
- .FirstAsync(m => m.IsDel == "0" && m.PalletNo == palletNo
+ .FirstAsync(m => m.IsDel == "0" && m.PalletNo == palletNo
&& m.SkuNo == boxInfos.First().SkuNo && m.LotNo == boxInfos.First().LotNo);
if (stockDetail == null)
{
@@ -1580,7 +1606,7 @@
else
{
await Db.Updateable(stockDetail).ExecuteCommandAsync();
- }
+ }
stock.Qty -= pickQty;
stock.LockQty -= pickQty;
if (stock.Qty <= 0)
@@ -1623,14 +1649,14 @@
//娣诲姞鎿嶄綔鏃ュ織璁板綍
- var k = new OperationSOServer().AddLogOperationSo("PDA妯″潡", "杞﹂棿鍑哄簱",
+ var k = new OperationSOServer().AddLogOperationSo("PDA妯″潡", "杞﹂棿鍑哄簱",
boxNo, "鍑哄簱", $"鍦≒DA涓婂绠卞彿涓猴細{boxNo}鐨勬墭鐩樼爜涓猴細{palletNo}鐨勬嫞璐ф搷浣�", userId);
Db.CommitTran();
}
- catch (AppFriendlyException e)
- {
- Db.RollbackTran();
- }
+ //catch (AppFriendlyException e)
+ //{
+ // Db.RollbackTran();
+ //}
catch (Exception e)
{
Db.RollbackTran();
@@ -1639,7 +1665,7 @@
}
// 杞﹂棿Pda鎷ｈ揣-鏁伴噺
- public async Task ChejianPickNum(PdaSoVm model, int userId)
+ public async Task ChejianPickNum(PdaSoVm model, int userId)
{
Db.BeginTran();
try
@@ -1660,10 +1686,10 @@
{
throw Oops.Bah("鐗╂枡鏁伴噺涓嶅彲涓簄ull");
}
- else
+ else
{
skuNum = decimal.Parse(model.PickQty);
- if (skuNum <= 0)
+ if (skuNum <= 0)
{
throw Oops.Bah("鐗╂枡鏁伴噺搴斿ぇ浜�0锛�");
}
@@ -1675,9 +1701,9 @@
{
throw Oops.Bah("鐗╂枡涓嶅瓨鍦紝璇锋鏌ョ墿鏂欑紪鐮佹槸鍚︽嫰鍗达紒");
}
- else
+ else
{
- if (skuModel.IsPasteCode != "0")
+ if (skuModel.IsPasteCode != "0")
{
throw Oops.Bah("璇ョ墿鏂欎负璐存爣鐗╂枡锛岃鍒版爣绛鹃〉闈㈡嫞璐э紒");
}
@@ -1687,7 +1713,7 @@
//搴撳瓨鏄庣粏
var stockDetail = await Db.Queryable<DataStockDetail>()
.FirstAsync(m => m.IsDel == "0" && m.PalletNo == model.PalletNo
- && m.SkuNo == model.SkuNo && m.LotNo == model.LotNo);
+ && m.SkuNo == model.SkuNo && m.LotNo == model.LotNo);
if (stockDetail == null)
{
throw Oops.Bah("鏈煡璇㈠埌璇ユ墭鐩樹笂璐х墿鐨勫簱瀛樻槑缁嗕俊鎭紒");
@@ -1775,14 +1801,13 @@
#endregion
//娣诲姞鎿嶄綔鏃ュ織璁板綍
- var k = new OperationSOServer().AddLogOperationSo("PDA妯″潡", "杞﹂棿鍑哄簱",
- skuModel.SkuName, "鎷ｈ揣", $"鍦≒DA杞﹂棿鍑哄簱椤典笂瀵癸細锛歿skuModel.SkuName}鐨勭墿鏂欒繘琛屾嫞璐ф搷浣�", userId);
+ var k = new OperationSOServer().AddLogOperationSo("PDA妯″潡", "杞﹂棿鍑哄簱", skuModel.SkuName, "鎷ｈ揣", $"鍦≒DA杞﹂棿鍑哄簱椤典笂瀵癸細{skuModel.SkuName}鐨勭墿鏂欒繘琛屾嫞璐ф搷浣�", userId);
Db.CommitTran();
}
- catch (AppFriendlyException e)
- {
- Db.RollbackTran();
- }
+ //catch (AppFriendlyException e)
+ //{
+ // Db.RollbackTran();
+ //}
catch (Exception e)
{
Db.RollbackTran();
@@ -1866,12 +1891,12 @@
//}
if (type == "1")//骞冲簱鍑哄簱鑾峰彇鍗曟嵁
{
- var allotList = await Db.Queryable<BllExportAllot>().Where(m => m.IsDel == "0" && m.Status == "1" && m.PalletNo == palletNo).Select(m => m.SONo).Distinct().Where(m => !string.IsNullOrWhiteSpace(m)).ToListAsync();
+ var allotList = await Db.Queryable<BllExportAllot>().Where(m => m.IsDel == "0" && m.Status == "1" && m.PalletNo == palletNo).OrderByDescending(m => m.SONo).Select(m => m.SONo).Distinct().Where(m => !string.IsNullOrWhiteSpace(m)).ToListAsync();
return allotList;
}
var noticeList = Db.Queryable<BllExportNotice>().Where(w => w.IsDel == "0" && (w.Status == "3" || w.Status == "4")).Select(s => s.SONo).ToList();
//鑾峰彇鐘舵�佷负寰呮嫞璐ф垨鑰呴儴鍒嗘嫞璐х殑鍑哄簱鍗�
- var allotList2 = await Db.Queryable<BllExportAllot>().Where(m => m.IsDel == "0" && (m.Status == "2" || m.Status == "3" || m.Status == "5") && m.PalletNo == palletNo && noticeList.Contains(m.SONo)).Select(m => m.SONo).Distinct().Where(m => !string.IsNullOrWhiteSpace(m)).ToListAsync();
+ var allotList2 = await Db.Queryable<BllExportAllot>().Where(m => m.IsDel == "0" && (m.Status == "2" || m.Status == "3" || m.Status == "5") && m.PalletNo == palletNo && noticeList.Contains(m.SONo)).OrderByDescending(m => m.SONo).Select(m => m.SONo).Distinct().Where(m => !string.IsNullOrWhiteSpace(m)).ToListAsync();
//var allotList = Db.Queryable<BllExportAllot>().Where(m => m.IsDel == "0" && m.PalletNo == palletNo).Select(m => m.SONo).Distinct().Where(m => !string.IsNullOrWhiteSpace(m)).ToList();
//鑾峰彇鍑哄簱鍗曟嵁涓嶄负寰呮嫞璐� 鎵ц瀹屾瘯 璁㈠崟鍏抽棴 绛夊緟鎵ц鐨勫崟鎹�
@@ -1887,18 +1912,18 @@
if (string.IsNullOrWhiteSpace(soNo))//鍒ゆ柇鎵樼洏鏄惁涓虹┖
{
throw Oops.Bah("鍑哄簱鍗曚负绌猴紝璇烽�夋嫨鍑哄簱鍗�");
- }
+ }
if (string.IsNullOrWhiteSpace(soDetailId))
{
throw Oops.Bah("鍑哄簱鏄庣粏涓虹┖锛岃閫夋嫨鐗╂枡-鎵规");
}
-
+
var allotList = await Db.Queryable<BllExportAllot>().Where(m => m.IsDel == "0" && m.Status == "0" && m.SONo == soNo && m.SODetailNo == int.Parse(soDetailId)).Select(m => m.PalletNo).Distinct().Where(m => !string.IsNullOrWhiteSpace(m)).ToListAsync();
return allotList;
-
+
}
-
+
//鑾峰彇鎵樼洏涓惈鏈夌殑鎵ц涓殑鍗曟嵁
@@ -1906,7 +1931,7 @@
{
if (type == "1")//骞冲簱鍑哄簱鑾峰彇鍗曟嵁
{
- var allotList = await Db.Queryable<BllExportAllot>().Where(m => m.IsDel == "0" && (m.Status == "1" || m.Status =="0")).Select(m => m.SONo).Distinct().Where(m => !string.IsNullOrWhiteSpace(m)).ToListAsync();
+ var allotList = await Db.Queryable<BllExportAllot>().Where(m => m.IsDel == "0" && (m.Status == "1" || m.Status == "0")).Select(m => m.SONo).Distinct().Where(m => !string.IsNullOrWhiteSpace(m)).ToListAsync();
return allotList;
}
//鑾峰彇鐘舵�佷负寰呮嫞璐ф垨鑰呴儴鍒嗘嫞璐х殑鍑哄簱鍗�
@@ -1928,7 +1953,7 @@
}
//鑾峰彇鐘舵�佷负寰呮嫞璐ф垨鑰呴儴鍒嗘嫞璐х殑鍑哄簱鍗�
var allotList = Db.Queryable<BllExportAllot>().Where(m => m.IsDel == "0" && m.SONo == soNo && (m.Status == "0" || m.Status == "1"));
-
+
var list = await allotList.GroupBy(m => new { m.SODetailNo, m.SkuNo, m.SkuName, m.LotNo }).Select(m => new DetailIdSkuLotNo()
{
SoDetailId = m.SODetailNo,
@@ -2125,7 +2150,7 @@
/// <param name="boxNo"></param>
/// <returns></returns>
/// <exception cref="Exception"></exception>
- public decimal CheckBoxForPick(string palletNo ,string boxNo)
+ public decimal CheckBoxForPick(string palletNo, string boxNo)
{
try
{
@@ -2386,7 +2411,7 @@
pallet.Status = "0";
await Db.Updateable(pallet).ExecuteCommandAsync();
}
-
+
//淇敼鍑哄簱鍗曟槑缁嗘嫞璐ф暟閲�
noticeDetail.CompleteQty += pickQty;
await Db.Updateable(noticeDetail).ExecuteCommandAsync();
@@ -3053,7 +3078,7 @@
await Db.Updateable(item).ExecuteCommandAsync();
}
pickQty += decimal.Parse(pickQty1);
- }
+ }
}
//鏀瑰彉搴撳唴绠辩爜鏄惁闆剁淇℃伅
if (biaoShi == "1" || biaoShi == "2")
@@ -3194,7 +3219,7 @@
/// <returns></returns>
/// <exception cref="Exception"></exception>
public async Task SoSetPickCode34(string soNo, string soDetailId, string palletNo, List<string> boxNoList, int userId)
- {
+ {
try
{
#region 鍒ゆ柇
@@ -3797,7 +3822,7 @@
else
{
stockDetail.Status = "0";
- }
+ }
if (stockDetail.Qty <= 0)
{
await Db.Deleteable(stockDetail).ExecuteCommandAsync();
@@ -4025,7 +4050,7 @@
{
endroad = new AllotLocation().RoadwayToStationNum(locat.RoadwayNo, model.OutMode);
}
-
+
outDtoList.Add(new OutCommandDto()
{
TaskNo = exTask.TaskNo, // 浠诲姟鍙�
@@ -4110,8 +4135,8 @@
var info = Db.Queryable<BllExportAllot>()
.LeftJoin<DataStockDetail>((a, b) => a.PalletNo == b.PalletNo)
- .Where(a=>a.IsDel == "0" && (a.Status == "0"||a.Status =="1") && a.SONo == soNo)
- .GroupBy((a,b) => new { a.SkuNo, a.SkuName, a.LotNo}).Select((a,b) => new BoxInfo()
+ .Where(a => a.IsDel == "0" && (a.Status == "0" || a.Status == "1") && a.SONo == soNo)
+ .GroupBy((a, b) => new { a.SkuNo, a.SkuName, a.LotNo }).Select((a, b) => new BoxInfo()
{
SkuNo = a.SkuNo,
SkuName = a.SkuName,
@@ -4136,15 +4161,15 @@
}
//鑾峰彇骞冲簱鍗曟嵁涓墭鐩樹綅缃俊鎭�
- public async Task<List<BoxInfo>> GetPingKuLocationInfo(string soNo,string skuno,string lotno)
+ public async Task<List<BoxInfo>> GetPingKuLocationInfo(string soNo, string skuno, string lotno)
{
var info = Db.Queryable<BllExportAllot>()
.LeftJoin<DataStockDetail>((a, b) => a.PalletNo == b.PalletNo)
- .LeftJoin<SysWareHouse>((a,b,c)=>b.WareHouseNo == c.WareHouseNo)
- .LeftJoin<SysStorageArea>((a,b,c,d)=>b.AreaNo == d.AreaNo)
+ .LeftJoin<SysWareHouse>((a, b, c) => b.WareHouseNo == c.WareHouseNo)
+ .LeftJoin<SysStorageArea>((a, b, c, d) => b.AreaNo == d.AreaNo)
.Where(a => a.IsDel == "0" && (a.Status == "0" || a.Status == "1") && a.SONo == soNo && a.SkuNo == skuno && a.LotNo == lotno)
- .GroupBy((a, b,c,d) => new { a.PalletNo, b.LocatNo,c.WareHouseName,d.AreaName }).Select((a, b,c,d) => new BoxInfo()
+ .GroupBy((a, b, c, d) => new { a.PalletNo, b.LocatNo, c.WareHouseName, d.AreaName }).Select((a, b, c, d) => new BoxInfo()
{
PalletNo = a.PalletNo,
LocatNo = b.LocatNo,
@@ -4364,7 +4389,7 @@
}
//鍙栨牱鍑哄簱鎷ｈ揣(鏍囩)
- public async Task SampleSoSetPick(string soType, string soNo, string soDetailId, string palletNo, string boxNo, string boxNo3,
+ public async Task SampleSoSetPick(string soType, string soNo, string soDetailId, string palletNo, string boxNo, string boxNo3,
string pickQty1, string asnNo, int userId)
{
Db.BeginTran();
--
Gitblit v1.8.0