From 40f0fed3160d717d5f32a3c310fc3fffb07eef9c Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周二, 02 9月 2025 14:56:14 +0800
Subject: [PATCH] 323232
---
wcs/yunneiWCS/yunneiWCS/wcf/yunneiWcf.cs | 105 ++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 105 insertions(+), 0 deletions(-)
diff --git a/wcs/yunneiWCS/yunneiWCS/wcf/yunneiWcf.cs b/wcs/yunneiWCS/yunneiWCS/wcf/yunneiWcf.cs
index 9293210..86a42a7 100644
--- a/wcs/yunneiWCS/yunneiWCS/wcf/yunneiWcf.cs
+++ b/wcs/yunneiWCS/yunneiWCS/wcf/yunneiWcf.cs
@@ -1026,6 +1026,111 @@
return msg;
}
+ /// <summary>鏌ユ壘鍑哄叆搴撹褰曟槑缁嗙粰MES [EditBy shaocx,2025-09-01]
+ ///
+ /// </summary>
+ /// <param name="page">鍒嗛〉</param>
+ /// <returns></returns>
+ public resMsg<Wms_outInStockRecord_Details_V2_Mes> findOutInStockRecord_Details_V2_Mes_Page(paging page, Wms_outInStockRecord_Details_V2_Mes value)
+ {
+ resMsg<Wms_outInStockRecord_Details_V2_Mes> msg = new resMsg<Wms_outInStockRecord_Details_V2_Mes>();
+ msg.status = 400;
+ try
+ {
+ using (dbmodel mod = new dbmodel())
+ {
+ string sql = "SELECT * FROM [LA20025].[dbo].[Wms_outInStockRecord_Details_V2_Mes] ";
+ sql = sql + " WHERE 1=1 ";
+
+ if (!string.IsNullOrEmpty(value.containerCode))//鎵樼洏鍙�
+ {
+ sql = sql + " and containerCode like '%" + value.containerCode + "%'";
+ }
+ if (!string.IsNullOrEmpty(value.productCode))//鐗╂枡缂栧彿
+ {
+ sql = sql + " and productCode like '%" + value.productCode + "%'";
+ }
+ if (!string.IsNullOrEmpty(value.productName))//鐗╂枡鍚嶇О
+ {
+ sql = sql + " and productName like '%" + value.productName + "%' ";
+ }
+ if (!string.IsNullOrEmpty(value.serialNumber))//娴佹按鍙�
+ {
+ sql = sql + " and serialNumber like '%" + value.serialNumber + "%' ";
+ }
+
+ if (page.startDateTime != DateTime.Parse("1900-01-01 0:00:00") && page.startDateTime != DateTime.Parse("0001-01-01 0:00:00"))//璧峰鏃堕棿
+ {
+ sql = sql + " and CreateTime >'" + page.startDateTime + "'";
+ }
+ if (page.endDateTime != DateTime.Parse("1900-01-01 0:00:00") && page.endDateTime != DateTime.Parse("0001-01-01 0:00:00"))//鎴鏃堕棿
+ {
+ sql = sql + " and CreateTime <'" + page.endDateTime + "'";
+ }
+
+ sql = sql + " order by CreateTime desc";
+ List<Wms_outInStockRecord_Details_V2_Mes> dataList = mod.Database.SqlQuery<Wms_outInStockRecord_Details_V2_Mes>(sql).ToList();
+
+ if (dataList.Count > 0)
+ {
+ //msg.quantity = (int)dataList.Sum(x => x.quantity);
+ msg.totalNum = dataList.Count;
+ msg.dateAll = dataList;
+ //鍒嗛〉璁＄畻
+ List<Wms_outInStockRecord_Details_V2_Mes> fenyeRerult = new List<Wms_outInStockRecord_Details_V2_Mes>();
+ msg.status = 200;
+
+ //鍋囧姣忛〉鏁伴噺 澶т簬鐩樼偣鏁版嵁
+ if (page.pagesize > dataList.Count)
+ {
+ msg.date = dataList;
+ msg.total = 1;
+ }
+ else
+ {
+ #region 鍒嗛〉璁＄畻
+ int a = page.pagesize;
+ int b = page.pagenum;
+ int c = (int)Math.Ceiling((double)dataList.Count / a);
+ msg.total = c;
+ int d = dataList.Count % a;
+ int e = 0;
+ int f = a * (b - 1);
+ if (d != 0 && b == c)
+ {
+ e = d + f;
+ }
+ else
+ {
+ e = a + f;
+ }
+ for (int i = f; i < e; i++)
+ {
+ fenyeRerult.Add(dataList[i]);
+ }
+
+ msg.date = fenyeRerult;
+ #endregion
+ }
+
+ }
+ else
+ {
+ msg.status = 200;
+ msg.msg = "鏌ユ壘鏁版嵁涓�0,璇锋洿鎹㈡煡璇㈡潯浠�";
+ }
+
+ }
+ }
+ catch (Exception ex)
+ {
+ msg.msg = "鏌ヨ澶辫触";
+ WZ.Useful.Commons.LogTextHelper.WriteLine("IyunneiWcf", "Wms_outInStockRecord_Details_V2_Mes", ex.ToString());
+ }
+
+ return msg;
+ }
+
/// <summary>鏌ユ壘鍏ュ簱鍗曟祦姘村彿
///
--
Gitblit v1.9.3