From 1e8ea8ab3c8bd260f855cea27f5710bda782cce3 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期四, 09 五月 2024 17:02:11 +0800
Subject: [PATCH] 圣沣看板接口开发 app 首件、巡检、完工检图标
---
VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs | 259 ++++++++++++++++++++++++++++++++++++++-------------
1 files changed, 192 insertions(+), 67 deletions(-)
diff --git a/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs b/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs
index 9765700..afeb0c6 100644
--- a/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs
@@ -12,17 +12,14 @@
{
public static ToMessage mes = new ToMessage(); //瀹氫箟鍏ㄥ眬杩斿洖淇℃伅瀵硅薄
- #region[杞﹂棿鐪嬫澘,涓婄敓浜т俊鎭痌
- public static ToMessage WorkShopProduceTopData(string wkshopcode)
+ #region[鍦ｆ玻浠撳簱鐪嬫澘宸︿笂,閲囪喘寰呭叆搴揮
+ public static ToMessage ProcureOutsourcLeftTop()
{
- string sql = "";
- var dynamicParams = new DynamicParameters();
+ var sql = "";
try
{
- string[] wkshoplist = Array.ConvertAll<string, string>(wkshopcode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string鍒嗗壊杞瑂tring[]
- sql = @"select * from h_v_JLKanBan_WorkshopTop where wkshp_code in @wkshoplist";
- dynamicParams.Add("@wkshoplist", wkshoplist);
- var data = DapperHelper.selectdata(sql, dynamicParams);
+ sql = @"select * from h_v_SFKanBan_ProcureNotReceived";
+ var data = DapperHelper.selecttable(sql);
mes.code = "200";
mes.message = "鏌ヨ鎴愬姛!";
mes.data = data;
@@ -38,27 +35,158 @@
}
#endregion
- #region[杞﹂棿鐪嬫澘,涓嬪乏杩戜竴鍛ㄤ笉鑹秼鍔縘
- public static ToMessage WorkShopProduceBottomLeftData(string wkshopcode)
+ #region[鍦ｆ玻浠撳簱鐪嬫澘宸︿笅,浜у搧浠ｅ彂璐
+ public static ToMessage ProductConsignmentLeftBottom()
+ {
+ var sql = "";
+ try
+ {
+ sql = @"select * from h_v_SFKanBan_ProductionNotDeliver";
+ var data = DapperHelper.selecttable(sql);
+ mes.code = "200";
+ mes.message = "鏌ヨ鎴愬姛!";
+ mes.data = data;
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[鍦ｆ玻浠撳簱鐪嬫澘鍙充笂,杩戜竴鍛ㄩ噰璐緟鍏ュ簱鐗╂枡鎺掕TOP5]
+ public static ToMessage ProcureOutsourcRightTop()
+ {
+ var sql = "";
+ try
+ {
+ sql = @"select * from h_v_SFKanBan_ProcureNotReceivedSumTop";
+ var data = DapperHelper.selecttable(sql);
+ mes.code = "200";
+ mes.message = "鏌ヨ鎴愬姛!";
+ mes.data = data;
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[鍦ｆ玻浠撳簱鐪嬫澘鍙充笅,杩戜竴鍛ㄩ攢鍞緟鍙戣揣浜у搧鎺掕TOP5]
+ public static ToMessage ProductionStockedInRightBottom()
+ {
+ var sql = "";
+ try
+ {
+ sql = @"select * from h_v_SFKanBan_ProductionNotDeliverSumTop";
+ var data = DapperHelper.selecttable(sql);
+ mes.code = "200";
+ mes.message = "鏌ヨ鎴愬姛!";
+ mes.data = data;
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+
+ #region[鍦ｆ玻鐢熶骇鐪嬫澘宸︿笂,鐢熶骇寰呭叆搴揮
+ public static ToMessage ProductionStockedInLeftTop()
+ {
+ var sql = "";
+ try
+ {
+ sql = @"select * from h_v_SFKanBan_ProductionNotReceived";
+ var data = DapperHelper.selecttable(sql);
+ mes.code = "200";
+ mes.message = "鏌ヨ鎴愬姛!";
+ mes.data = data;
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[鍦ｆ玻鐢熶骇鐪嬫澘鍙充笂,杩戜竴鍛ㄧ敓浜у緟鍏ュ簱浜у搧鎺掕TOP10]
+ public static ToMessage ProductionStockedInRightTop()
+ {
+ var sql = "";
+ try
+ {
+ sql = @"select * from h_v_SFKanBan_ProductionNotReceivedSumTop";
+ var data = DapperHelper.selecttable(sql);
+ mes.code = "200";
+ mes.message = "鏌ヨ鎴愬姛!";
+ mes.data = data;
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+
+ #region[鍦ｆ玻杞﹂棿鐪嬫澘,涓婄敓浜т俊鎭痌
+ public static ToMessage WorkShopProduceTopData()
+ {
+ string sql = "";
+ try
+ {
+ sql = @"select * from h_v_SFKanBan_WorkshopTop";
+ var data = DapperHelper.selecttable(sql);
+ mes.code = "200";
+ mes.message = "鏌ヨ鎴愬姛!";
+ mes.data = data;
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[鍦ｆ玻杞﹂棿鐪嬫澘,涓嬪乏杩戜竴鍛ㄤ笉鑹秼鍔縘
+ public static ToMessage WorkShopProduceBottomLeftData()
{
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_JLKanBan_WorkshopBottomLeft";
- 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);
- }
-
+ sql = @"h_p_SFKanBan_WorkshopBottomLeft";
+ var data = DapperHelper.lissql(sql);
mes.code = "200";
mes.message = "鏌ヨ鎴愬姛!";
- mes.data = dir;
+ mes.data = data;
}
catch (Exception e)
{
@@ -71,17 +199,14 @@
}
#endregion
- #region[杞﹂棿鐪嬫澘,涓嬪彸杩戜竴鏈堜笉鑹粺璁
- public static ToMessage WorkShopProduceBottomRightData(string wkshopcode)
+ #region[鍦ｆ玻杞﹂棿鐪嬫澘,涓嬪彸杩戜竴鏈堜笉鑹粺璁
+ public static ToMessage WorkShopProduceBottomRightData()
{
string sql = "";
- var dynamicParams = new DynamicParameters();
try
{
- string[] wkshoplist = Array.ConvertAll<string, string>(wkshopcode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string鍒嗗壊杞瑂tring[]
- sql = @"select * from h_v_JLKanBan_WorkshopBottomRight where wkshp_code in @wkshoplist";
- dynamicParams.Add("@wkshoplist", wkshoplist);
- var data = DapperHelper.selectdata(sql, dynamicParams);
+ sql = @"select * from h_v_SFKanBan_WorkshopBottomRight";
+ var data = DapperHelper.selecttable(sql);
mes.code = "200";
mes.message = "鏌ヨ鎴愬姛!";
mes.data = data;
@@ -98,47 +223,19 @@
#endregion
- #region[杞﹂棿缁煎悎鐪嬫澘,宸︿笂鐢熶骇璁㈠崟]
+ #region[鍦ｆ玻杞﹂棿缁煎悎鐪嬫澘,宸︿笂鐢熶骇璁㈠崟]
public static ToMessage WorkShopCompreLeftTop(string wkshopcode)
{
var sql = "";
- var dynamicParams = new DynamicParameters();
Dictionary<object, object> dir = new Dictionary<object, object>();
- Dictionary<object, object> dir0 = new Dictionary<object, object>();
- Dictionary<object, object> dir1 = new Dictionary<object, object>();
try
{
- string[] wkshoplist = Array.ConvertAll<string, string>(wkshopcode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string鍒嗗壊杞瑂tring[]
- sql = @"select * from h_v_JLKanBan_WorkShopCompreLeftTop";
+ sql = @"select * from h_v_SFKanBan_WorkShopCompreLeftTop";
var data = DapperHelper.selecttable(sql);
- sql = @"select * from h_v_JLKanBan_WorkShopCompreLeftCenter";
+ sql = @"select * from h_v_SFKanBan_WorkShopCompreLeftCenter";
var data1 = DapperHelper.selecttable(sql);
- for (int i = 0; i < wkshoplist.Length; i++)
- {
- var top0 = data.AsEnumerable()
- .Where(row => row.Field<string>("wkshp_code") == wkshoplist[i].ToString()) // 娣诲姞鏌ヨ鏉′欢
- .Select(group => new
- {
- wkshp_code = group.Field<string>("wkshp_code"),
- plan_qty = group.Field<decimal>("plan_qty"),
- good_qty = group.Field<decimal>("good_qty")
- }).DefaultIfEmpty(new { wkshp_code = wkshoplist[i].ToString(), plan_qty = 0m, good_qty = 0m })//涓虹┖鏃舵寚瀹氶粯璁ゅ��
- .ToList();
- dir0.Add(wkshoplist[i].ToString(), top0);
-
- var top1 = data1.AsEnumerable()
- .Where(row => row.Field<string>("wkshp_code") == wkshoplist[i].ToString()) // 娣诲姞鏌ヨ鏉′欢
- .Select(group => new
- {
- wkshp_code = group.Field<string>("wkshp_code"),
- plan_qty = group.Field<decimal>("plan_qty"),
- quantity = group.Field<decimal>("quantity")
- }).DefaultIfEmpty(new { wkshp_code = wkshoplist[i].ToString(), plan_qty = 0m, quantity = 0m })//涓虹┖鏃舵寚瀹氶粯璁ゅ��
- .ToList();
- dir1.Add(wkshoplist[i].ToString(), top1);
- }
- dir.Add("LeftTop", dir0);
- dir.Add("LeftBottom", dir1);
+ dir.Add("LeftTop", data);
+ dir.Add("LeftBottom", data1);
mes.code = "200";
mes.message = "鏌ヨ鎴愬姛!";
mes.data = dir;
@@ -154,16 +251,16 @@
}
#endregion
- #region[杞﹂棿缁煎悎鐪嬫澘,鍙充笂閿�鍞鍗昡
+ #region[鍦ｆ玻杞﹂棿缁煎悎鐪嬫澘,鍙充笂閿�鍞鍗昡
public static ToMessage WorkShopCompreRightTop()
{
var sql = "";
Dictionary<object, object> dir = new Dictionary<object, object>();
try
{
- sql = @"select * from h_v_JLKanBan_WorkShopCompreRightTop";
+ sql = @"select * from h_v_SFKanBan_WorkShopCompreRightTop";
var data = DapperHelper.selecttable(sql);
- sql = @"select * from h_v_JLKanBan_WorkShopCompreRightCenter";
+ sql = @"select * from h_v_SFKanBan_WorkShopCompreRightCenter";
var data1 = DapperHelper.selecttable(sql);
dir.Add("RightTop", data);
dir.Add("RightBottom", data1);
@@ -182,14 +279,42 @@
}
#endregion
- #region[杞﹂棿缁煎悎鐪嬫澘,鍙充笅搴撳瓨]
+ #region[鍦ｆ玻杞﹂棿缁煎悎鐪嬫澘,宸︿笅閲囪喘璁㈠崟]
+ public static ToMessage WorkShopCompreLeftBottom()
+ {
+ var sql = "";
+ Dictionary<object, object> dir = new Dictionary<object, object>();
+ try
+ {
+ sql = @"select * from h_v_SFKanBan_WorkShopCompreLeftBottom_Top";
+ var data = DapperHelper.selecttable(sql);
+ sql = @"select * from h_v_SFKanBan_WorkShopCompreLeftBottom_Bottom";
+ var data1 = DapperHelper.selecttable(sql);
+ dir.Add("BottomLeftTop", data);
+ dir.Add("BottomLeftBottom", data1);
+ mes.code = "200";
+ mes.message = "鏌ヨ鎴愬姛!";
+ mes.data = dir;
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[鍦ｆ玻杞﹂棿缁煎悎鐪嬫澘,鍙充笅搴撳瓨]
public static ToMessage WorkShopCompreRightBottom()
{
var sql = "";
Dictionary<object, object> dir = new Dictionary<object, object>();
try
{
- sql = @"select * from h_v_JLKanBan_WorkShopCompreRightBottom";
+ 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());
--
Gitblit v1.9.3