From 7c78ddfc867ac8cf06cc911bb59977d9381deb12 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期五, 26 七月 2024 14:20:39 +0800
Subject: [PATCH] 车间看板新增车间参数
---
VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs | 53 ++++++++++++++++++++++++++++++++++++++---------------
1 files changed, 38 insertions(+), 15 deletions(-)
diff --git a/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs b/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs
index afeb0c6..b9ac68b 100644
--- a/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs
@@ -153,13 +153,16 @@
#region[鍦ｆ玻杞﹂棿鐪嬫澘,涓婄敓浜т俊鎭痌
- public static ToMessage WorkShopProduceTopData()
+ public static ToMessage WorkShopProduceTopData(string wkshopcode)
{
string sql = "";
+ var dynamicParams = new DynamicParameters();
try
{
- sql = @"select * from h_v_SFKanBan_WorkshopTop";
- var data = DapperHelper.selecttable(sql);
+ string[] wkshoplist = Array.ConvertAll<string, string>(wkshopcode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string鍒嗗壊杞瑂tring[]
+ sql = @"select * from h_v_SFKanBan_WorkshopTop where wkshp_code in @wkshoplist";
+ dynamicParams.Add("@wkshoplist", wkshoplist);
+ var data = DapperHelper.selectdata(sql, dynamicParams);
mes.code = "200";
mes.message = "鏌ヨ鎴愬姛!";
mes.data = data;
@@ -176,17 +179,25 @@
#endregion
#region[鍦ｆ玻杞﹂棿鐪嬫澘,涓嬪乏杩戜竴鍛ㄤ笉鑹秼鍔縘
- public static ToMessage WorkShopProduceBottomLeftData()
+ public static ToMessage WorkShopProduceBottomLeftData(string wkshopcode)
{
string sql = "";
Dictionary<object, object> dir = new Dictionary<object, object>();
try
{
+ //瀛樺偍杩囩▼鍚�(褰撳墠鏃堕棿寰�鍓嶄竴鍛�)
+ string[] wkshoplist = Array.ConvertAll<string, string>(wkshopcode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string鍒嗗壊杞瑂tring[]
sql = @"h_p_SFKanBan_WorkshopBottomLeft";
- var data = DapperHelper.lissql(sql);
+ for (int i = 0; i < wkshoplist.Length; i++)
+ {
+ var dynamicParams = new DynamicParameters();
+ dynamicParams.Add("@wkshop_code", wkshoplist[i].ToString());
+ var dt = DapperHelper.selectProcedure(sql, dynamicParams);
+ dir.Add(wkshoplist[i].ToString(), dt);
+ }
mes.code = "200";
mes.message = "鏌ヨ鎴愬姛!";
- mes.data = data;
+ mes.data = dir;
}
catch (Exception e)
{
@@ -200,13 +211,16 @@
#endregion
#region[鍦ｆ玻杞﹂棿鐪嬫澘,涓嬪彸杩戜竴鏈堜笉鑹粺璁
- public static ToMessage WorkShopProduceBottomRightData()
+ public static ToMessage WorkShopProduceBottomRightData(string wkshopcode)
{
string sql = "";
+ var dynamicParams = new DynamicParameters();
try
{
- sql = @"select * from h_v_SFKanBan_WorkshopBottomRight";
- var data = DapperHelper.selecttable(sql);
+ string[] wkshoplist = Array.ConvertAll<string, string>(wkshopcode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string鍒嗗壊杞瑂tring[]
+ sql = @"select * from h_v_SFKanBan_WorkshopBottomRight where wkshp_code in @wkshoplist";
+ dynamicParams.Add("@wkshoplist", wkshoplist);
+ var data = DapperHelper.selectdata(sql, dynamicParams);
mes.code = "200";
mes.message = "鏌ヨ鎴愬姛!";
mes.data = data;
@@ -316,12 +330,21 @@
{
sql = @"select * from h_v_SFKanBan_WorkShopCompreRightBottom";
var data = DapperHelper.selecttable(sql);
- dir.Add("Y", data.Rows[0]["BaseQuantity"].ToString());
- dir.Add("B", data.Rows[1]["BaseQuantity"].ToString());
- dir.Add("C", data.Rows[2]["BaseQuantity"].ToString());
- mes.code = "200";
- mes.message = "鏌ヨ鎴愬姛!";
- mes.data = dir;
+ if (data.Rows.Count > 0)
+ {
+ dir.Add("Y", data.Rows[0]["BaseQuantity"].ToString());
+ dir.Add("B", data.Rows[1]["BaseQuantity"].ToString());
+ dir.Add("C", data.Rows[2]["BaseQuantity"].ToString());
+ mes.code = "200";
+ mes.message = "鏌ヨ鎴愬姛!";
+ mes.data = dir;
+ }
+ else
+ {
+ mes.code = "200";
+ mes.message = "鏌ヨ鎴愬姛!";
+ mes.data = null;
+ }
}
catch (Exception e)
{
--
Gitblit v1.9.3