From f3bdc703bebd49d6149c5fd053cd8f57d50efc44 Mon Sep 17 00:00:00 2001
From: admin <qiutairan163@163.com>
Date: 星期三, 03 十二月 2025 17:04:58 +0800
Subject: [PATCH] 开发获取需要质检的批次号GetInspectLotNoList接口
---
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