From 0e9f21b97c6d0d38350586d43c2b4e3e6949bc07 Mon Sep 17 00:00:00 2001
From: admin <qiutairan163@163.com>
Date: 星期五, 12 十二月 2025 11:40:39 +0800
Subject: [PATCH] 库存统计GetDataStockList默认统计去除LotText分组
---
Wms/WMS.BLL/BllQualityServer/QualityInspectServer.cs | 25 +++++++++++++++++++++++++
1 files changed, 25 insertions(+), 0 deletions(-)
diff --git a/Wms/WMS.BLL/BllQualityServer/QualityInspectServer.cs b/Wms/WMS.BLL/BllQualityServer/QualityInspectServer.cs
index c818606..a389d14 100644
--- a/Wms/WMS.BLL/BllQualityServer/QualityInspectServer.cs
+++ b/Wms/WMS.BLL/BllQualityServer/QualityInspectServer.cs
@@ -1,6 +1,7 @@
锘縰sing System;
using System.Collections.Generic;
using System.Data;
+using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Model.InterFaceModel;
@@ -87,6 +88,30 @@
/// <summary>
+ /// 鑾峰彇闇�瑕佽川妫�鐨勬壒娆″彿
+ /// </summary>
+ /// <param name="pageIndex">椤电爜</param>
+ /// <param name="pageSize">椤靛ぇ灏�</param>
+ /// <returns></returns>
+ public IEnumerable<string> GetInspectLotNoList(int pageIndex, int pageSize)
+ {
+ int index = (pageIndex <= 1) ? 1 : pageIndex;
+ int size = (pageSize <= 100) ? 100 : pageSize;
+
+ string lotnoSql = $@"select LotNo
+ from DataStockDetail
+ where isnull(InspectStatus,'')='0' and isnull(ASNNo,'')!='' and isnull(SkuNo,'')!=''
+ group by LotNo
+ order by LotNo
+ offset {(index - 1) * size} rows fetch next {size} rows only";
+ DataTable lotnoDt = Db.Ado.GetDataTable(lotnoSql);
+
+ var result = lotnoDt.Rows.Cast<DataRow>().Select(e => e["LotNo"] + "");
+ return result;
+ }
+
+
+ /// <summary>
/// 娣诲姞鐗╂枡璐ㄦ淇℃伅
/// </summary>
/// <param name="model">璐ㄦ淇℃伅瀹炰綋妯″瀷</param>
--
Gitblit v1.8.0