From 4da743d3d8b1cd3c9c1bd118c74ef1aa297b2a3a Mon Sep 17 00:00:00 2001
From: admin <qiutairan163@163.com>
Date: 星期五, 28 十一月 2025 16:04:06 +0800
Subject: [PATCH] AddMate增加“是否批次管理”判断
---
Wms/WMS.BLL/DataServer/StockDetailServer.cs | 60 +++++++++++++++++++++++++++++-------------------------------
1 files changed, 29 insertions(+), 31 deletions(-)
diff --git a/Wms/WMS.BLL/DataServer/StockDetailServer.cs b/Wms/WMS.BLL/DataServer/StockDetailServer.cs
index 410570c..edaa9b0 100644
--- a/Wms/WMS.BLL/DataServer/StockDetailServer.cs
+++ b/Wms/WMS.BLL/DataServer/StockDetailServer.cs
@@ -14,11 +14,11 @@
namespace WMS.BLL.DataServer
{
- public class StockDetailServer:DbHelper<DataStockDetail>,IStockDetailServer
+ public class StockDetailServer : DbHelper<DataStockDetail>, IStockDetailServer
{
private static readonly SqlSugarScope Db = DataContext.Db;
- public StockDetailServer():base(Db)
+ public StockDetailServer() : base(Db)
{
}
@@ -38,17 +38,14 @@
/// <param name="bitBoxMark">闆剁鏍囪</param>
/// <param name="inspectStatus">璐ㄩ噺鐘舵��</param>
/// <returns></returns>
- public List<StockDetailDto> GetBindList(string skuNo, string skuName, string palletNo, string lotNo, string boxNo, string status,
- string inspectMark, string bitPalletMark, string bitBoxMark, string inspectStatus, string ownerNo, string ownerName,
- string startTime, string endTime, string WareHouseNo, string AreaNo)
+ public List<StockDetailDto> GetBindList(string skuNo, string skuName, string palletNo, string lotNo, string boxNo, string status, string inspectMark, string bitPalletMark, string bitBoxMark, string inspectStatus, string ownerNo, string ownerName, string startTime, string endTime, string WareHouseNo, string AreaNo)
{
- string str = "select detail.*,house.WareHouseNo + '-' + house.WareHouseName as WareHouseName,roadway.RoadwayNo + '-' + roadway.RoadwayName as RoadwayName," +
- "area.AreaNo + '-' + area.AreaName as AreaName " +
- "from DataStockDetail detail " +
- "left join SysStorageRoadway roadway on detail.RoadwayNo = roadway.RoadwayNo " +
- "left join SysWareHouse house on detail.WareHouseNo = house.WareHouseNo " +
- "left join SysStorageArea area on detail.AreaNo = area.AreaNo " +
- "where detail.IsDel = @isdel";
+ string str = $@"select detail.*,house.WareHouseNo+'-'+house.WareHouseName as WareHouseName,roadway.RoadwayNo+'-'+roadway.RoadwayName as RoadwayName,area.AreaNo+'-'+area.AreaName as AreaName
+from DataStockDetail detail
+left join SysStorageRoadway roadway on detail.RoadwayNo=roadway.RoadwayNo
+left join SysWareHouse house on detail.WareHouseNo=house.WareHouseNo
+left join SysStorageArea area on detail.AreaNo=area.AreaNo
+where detail.IsDel=@isdel";
//鍒ゆ柇鐗╂枡鍙锋槸鍚︿负绌�
if (!string.IsNullOrEmpty(skuNo))
{
@@ -72,7 +69,7 @@
//鍒ゆ柇闆舵墭鏍囪鏄惁涓虹┖
if (!string.IsNullOrEmpty(bitPalletMark))
{
- str += " and detail.BitPalletMark = @bitpalletmark";
+ str += " and detail.BitPalletMark=@bitpalletmark";
}
//鍒ゆ柇璐т富缂栫爜鏄惁涓虹┖
if (!string.IsNullOrEmpty(ownerNo))
@@ -86,29 +83,30 @@
}
if (!string.IsNullOrEmpty(startTime))
{
- str += $" and detail.CompleteTime >= '{startTime}'";
+ str += $" and detail.CompleteTime>='{startTime}'";
}
if (!string.IsNullOrEmpty(endTime))
{
endTime = Convert.ToDateTime(endTime).AddDays(1).ToString();
- str += $" and detail.CompleteTime < '{endTime}'";
+ str += $" and detail.CompleteTime<'{endTime}'";
}
- if (!string.IsNullOrEmpty(WareHouseNo))
- {
- str += $" and detail.WareHouseNo = '{WareHouseNo}'";
- }
+ //閲嶅鏉′欢
+ //if (!string.IsNullOrEmpty(WareHouseNo))
+ //{
+ // str += $" and detail.WareHouseNo = '{WareHouseNo}'";
+ //}
if (!string.IsNullOrEmpty(WareHouseNo))
{
- str += $" and detail.WareHouseNo = '{WareHouseNo}'";
+ str += $" and detail.WareHouseNo='{WareHouseNo}'";
}
if (!string.IsNullOrEmpty(AreaNo))
{
- str += $" and detail.AreaNo = '{AreaNo}'";
+ str += $" and detail.AreaNo='{AreaNo}'";
}
int i = 0;
//鍦ㄧ鐮佹槑缁嗕腑鑾峰彇鐩稿簲鏁版嵁
- string boxstr = "select StockDetailId from DataBoxInfo Where IsDel = @isdel";
+ string boxstr = "select StockDetailId from DataBoxInfo Where IsDel=@isdel";
//鍒ゆ柇绠辩爜鏄惁涓虹┖
if (!string.IsNullOrEmpty(boxNo))
{
@@ -118,27 +116,27 @@
//鍒ゆ柇绠辨敮鐘舵�佹槸鍚︿负绌�
if (!string.IsNullOrEmpty(status))
{
- boxstr += " and Status = @status";
+ boxstr += " and Status=@status";
i = 1;
}
//鍒ゆ柇妫�楠屾爣璁版槸鍚︿负绌�
if (!string.IsNullOrEmpty(inspectMark))
{
- boxstr += " and InspectMark = @inspectmark";
- str += " and detail.InspectMark = @inspectmark";
+ boxstr += " and InspectMark=@inspectmark";
+ str += " and detail.InspectMark=@inspectmark";
i = 1;
}
//鍒ゆ柇闆剁鏍囪鏄惁涓虹┖
if (!string.IsNullOrEmpty(bitBoxMark))
{
- boxstr += " and BitBoxMark = @bitboxmark";
+ boxstr += " and BitBoxMark=@bitboxmark";
i = 1;
}
//鍒ゆ柇璐ㄩ噺鐘舵�佹槸鍚︿负绌�
if (!string.IsNullOrEmpty(inspectStatus))
{
- boxstr += " and InspectStatus = @inspectstatus";
- str += " and detail.InspectStatus = @inspectstatus";
+ boxstr += " and InspectStatus=@inspectstatus";
+ str += " and detail.InspectStatus=@inspectstatus";
i = 1;
}
//灏嗙鐮佹暟鎹繘琛屾帓搴�
@@ -174,11 +172,11 @@
}
if (!string.IsNullOrEmpty(arr))
{
- str += $" and Id in ({arr})";
+ str += $" and detail.Id in ({arr})";
}
else
{
- str += " and Id = ''";
+ str += " and detail.Id=''";
}
}
@@ -251,7 +249,7 @@
/// <param name="bitBoxMark">闆剁鏍囪</param>
/// <param name="inspectStatus">璐ㄩ噺鐘舵��</param>
/// <returns></returns>
- public List<DataStockDetail> GetBindListDaoChu(string skuNo, string skuName, string palletNo, string lotNo, string boxNo,
+ public List<DataStockDetail> GetBindListDaoChu(string skuNo, string skuName, string palletNo, string lotNo, string boxNo,
string status, string inspectMark, string bitPalletMark, string bitBoxMark, string inspectStatus)
{
string str = "select Id,LotNo,LotText,SupplierLot,SkuNo,SkuName,Qty,LockQty,FrozenQty,AreaNo,LocatNo,PalletNo,PalletNo2," +
--
Gitblit v1.8.0