From 2560a7e73dacbca9404e4f6f31596323c8e95fef Mon Sep 17 00:00:00 2001
From: admin <qiutairan163@163.com>
Date: 星期三, 26 十一月 2025 15:17:26 +0800
Subject: [PATCH] 格式化代码
---
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