From 6b5de286683ac86026b2e9109166ced0332cfdad Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周四, 04 9月 2025 10:10:25 +0800
Subject: [PATCH] 处理推送
---
wcs/yunneiWCS/yunneiWCS/wcf/yunneiWcf.cs | 108 +++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 107 insertions(+), 1 deletions(-)
diff --git a/wcs/yunneiWCS/yunneiWCS/wcf/yunneiWcf.cs b/wcs/yunneiWCS/yunneiWCS/wcf/yunneiWcf.cs
index 9293210..60c4d10 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>鏌ユ壘鍏ュ簱鍗曟祦姘村彿
///
@@ -2220,7 +2325,8 @@
preLog = "浜哄伐鍒嗘嫞";
}
- OutInStockRecord_V2_MesHandler.AddRecordForPersonDelete(mod, OutInFlag.鍑哄簱, "浜哄伐鍒犻櫎搴撳瓨:" + preLog, record_delteList, modfiyStock);//鍫嗗灈鏈轰换鍔″畬鎴愬悗鐨勫嚭搴�
+ OutInStockRecord_V2_MesHandler.AddRecordForPersonDelete(mod, OutInFlag.鍑哄簱, "浜哄伐鍒犻櫎搴撳瓨:" + preLog,
+ record_delteList, modfiyStock, (currentStock != null ? currentStock.positionName : ""));//鍫嗗灈鏈轰换鍔″畬鎴愬悗鐨勫嚭搴�
int res = mod.SaveChanges();
if (res > 0)
--
Gitblit v1.9.3