From c98af02dd7bf50587aeb85781708164ecc8c5004 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期五, 21 三月 2025 13:09:27 +0800
Subject: [PATCH] 1.增加报工记录报表接口
---
VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs | 250 +++++++++++++++++++++++++++++++++++++++----------
1 files changed, 199 insertions(+), 51 deletions(-)
diff --git a/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs b/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs
index 9765700..b9ac68b 100644
--- a/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs
@@ -12,7 +12,147 @@
{
public static ToMessage mes = new ToMessage(); //瀹氫箟鍏ㄥ眬杩斿洖淇℃伅瀵硅薄
- #region[杞﹂棿鐪嬫澘,涓婄敓浜т俊鎭痌
+ #region[鍦ｆ玻浠撳簱鐪嬫澘宸︿笂,閲囪喘寰呭叆搴揮
+ public static ToMessage ProcureOutsourcLeftTop()
+ {
+ var sql = "";
+ try
+ {
+ sql = @"select * from h_v_SFKanBan_ProcureNotReceived";
+ 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 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 wkshopcode)
{
string sql = "";
@@ -20,7 +160,7 @@
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";
+ 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";
@@ -38,7 +178,7 @@
}
#endregion
- #region[杞﹂棿鐪嬫澘,涓嬪乏杩戜竴鍛ㄤ笉鑹秼鍔縘
+ #region[鍦ｆ玻杞﹂棿鐪嬫澘,涓嬪乏杩戜竴鍛ㄤ笉鑹秼鍔縘
public static ToMessage WorkShopProduceBottomLeftData(string wkshopcode)
{
string sql = "";
@@ -47,7 +187,7 @@
{
//瀛樺偍杩囩▼鍚�(褰撳墠鏃堕棿寰�鍓嶄竴鍛�)
string[] wkshoplist = Array.ConvertAll<string, string>(wkshopcode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string鍒嗗壊杞瑂tring[]
- sql = @"h_p_JLKanBan_WorkshopBottomLeft";
+ sql = @"h_p_SFKanBan_WorkshopBottomLeft";
for (int i = 0; i < wkshoplist.Length; i++)
{
var dynamicParams = new DynamicParameters();
@@ -55,7 +195,6 @@
var dt = DapperHelper.selectProcedure(sql, dynamicParams);
dir.Add(wkshoplist[i].ToString(), dt);
}
-
mes.code = "200";
mes.message = "鏌ヨ鎴愬姛!";
mes.data = dir;
@@ -71,7 +210,7 @@
}
#endregion
- #region[杞﹂棿鐪嬫澘,涓嬪彸杩戜竴鏈堜笉鑹粺璁
+ #region[鍦ｆ玻杞﹂棿鐪嬫澘,涓嬪彸杩戜竴鏈堜笉鑹粺璁
public static ToMessage WorkShopProduceBottomRightData(string wkshopcode)
{
string sql = "";
@@ -79,7 +218,7 @@
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";
+ 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";
@@ -98,47 +237,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 +265,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,21 +293,58 @@
}
#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());
- 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