From 92fea996bf287e90c590cb30c0b1aac5969d0f17 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周一, 01 9月 2025 15:48:14 +0800
Subject: [PATCH] 增加 主
---
wcs/yunneiWCS/yunneiWCS/wcf/yunneiWcf.cs | 159 +++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 159 insertions(+), 0 deletions(-)
diff --git a/wcs/yunneiWCS/yunneiWCS/wcf/yunneiWcf.cs b/wcs/yunneiWCS/yunneiWCS/wcf/yunneiWcf.cs
index 2fdd92a..9293210 100644
--- a/wcs/yunneiWCS/yunneiWCS/wcf/yunneiWcf.cs
+++ b/wcs/yunneiWCS/yunneiWCS/wcf/yunneiWcf.cs
@@ -903,6 +903,130 @@
return msg;
}
+ /// <summary>鏌ユ壘鍑哄叆搴撹褰曠粰MES [EditBy shaocx,2025-09-01]
+ ///
+ /// </summary>
+ /// <param name="page">鍒嗛〉</param>
+ /// <returns></returns>
+ public resMsg<Wms_outInStockRecord_V2_Mes> findOutInStockRecord_V2_Mes(paging page, Wms_outInStockRecord_V2_Mes value)
+ {
+ resMsg<Wms_outInStockRecord_V2_Mes> msg = new resMsg<Wms_outInStockRecord_V2_Mes>();
+ msg.status = 400;
+ try
+ {
+ using (dbmodel mod = new dbmodel())
+ {
+ string sql = "SELECT * FROM [LA20025].[dbo].[Wms_outInStockRecord_V2_Mes] ";
+ sql = sql + " WHERE 1=1 ";
+ if (!string.IsNullOrEmpty(value.sourcePlace))//璧风偣
+ {
+ sql = sql + " and sourcePlace='" + value.sourcePlace + "' ";
+ }
+ if (!string.IsNullOrEmpty(value.toPlace))//鐩爣鐐�
+ {
+ sql = sql + " and toPlace='" + value.toPlace + "' ";
+ }
+ if (!string.IsNullOrEmpty(value.containerCode))//鎵樼洏鍙�
+ {
+ sql = sql + " and containerCode like'%" + value.containerCode + "%' ";
+ }
+ if (!string.IsNullOrEmpty(value.materialCode))//鐗╂枡缂栧彿
+ {
+ sql = sql + " and materialCode like '%" + value.materialCode + "%'";
+ }
+ if (!string.IsNullOrEmpty(value.materialName))//鐗╂枡鍚嶇О
+ {
+ sql = sql + " and materialName like '%" + value.materialName + "%' ";
+ }
+ if (!string.IsNullOrEmpty(value.version))//鏈哄瀷
+ {
+ sql = sql + " and version like '%" + value.version + "%' ";
+ }
+ if (!string.IsNullOrEmpty(value.supplier))//渚涘簲鍟�
+ {
+ sql = sql + " and supplier like '%" + value.supplier + "%'";
+ }
+ if (value.isSendToMes != null && value.isSendToMes != 0)
+ {
+ sql = sql + " and isSendToMes = '" + value.isSendToMes + "' ";
+ }
+ //if (value.positionType == (byte)positionType.浣欐枡鍥炲簱)//鏄惁鏌ヨ浣欐枡
+ //{
+ // sql = sql + " and positionType =" + value.positionType;
+ //}
+ 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_V2_Mes> dataList = mod.Database.SqlQuery<Wms_outInStockRecord_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_V2_Mes> fenyeRerult = new List<Wms_outInStockRecord_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", "findOutInStockRecord_V2_Mes", ex.ToString());
+ }
+
+ return msg;
+ }
+
+
/// <summary>鏌ユ壘鍏ュ簱鍗曟祦姘村彿
///
/// </summary>
@@ -943,6 +1067,41 @@
return res;
}
+
+ /// <summary>鏌ユ壘鍑哄叆搴撹褰曟帹琛宮es璇︽儏
+ ///
+ /// </summary>
+ /// <param name="inStockCode"></param>
+ /// <returns></returns>
+ public resMsg<Wms_outInStockRecord_Details_V2_Mes> findOutInStockRecord_Details_V2_Mes(long mainId)
+ {
+ resMsg<Wms_outInStockRecord_Details_V2_Mes> res = new resMsg<Wms_outInStockRecord_Details_V2_Mes>();
+ res.status = 400;
+ try
+ {
+ using (dbmodel mod = new dbmodel())
+ {
+
+ List<Wms_outInStockRecord_Details_V2_Mes> instockList = mod.Wms_outInStockRecord_Details_V2_Mes.Where(x => x.mainId == mainId).ToList();
+ if (instockList.Count > 0)
+ {
+ res.status = 200;
+ res.date = instockList;
+ }
+ else
+ {
+ res.msg = "鏌ヤ笉鍒版槑缁�";
+ }
+
+ }
+ }
+ catch (Exception)
+ {
+ res.msg = "鏌ヨ寮傚父";
+ }
+ return res;
+ }
+
/// <summary>淇敼鍏ュ簱鍗曟祦姘村彿
///
/// </summary>
--
Gitblit v1.9.3