From 291558a5ddd495195047a23a27b44ce5b0bbca5a Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期五, 15 十一月 2024 11:06:00 +0800
Subject: [PATCH] 1.T8入库记录(查询、删除) 2.T+入库记录(查询、删除) 3.生产入库记录查询增加部门查询条件 4.看板视图根据配置文件区分T8还是T+
---
VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs | 137 +++++++++++++++++++++++++++++++++++++++++----
1 files changed, 125 insertions(+), 12 deletions(-)
diff --git a/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs b/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs
index 6546719..6f17394 100644
--- a/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs
@@ -11,6 +11,8 @@
public class KanBanManagerentDAL
{
public static ToMessage mes = new ToMessage(); //瀹氫箟鍏ㄥ眬杩斿洖淇℃伅瀵硅薄
+ public static string ErpPath = AppSetting.GetAppSetting("ErpPath"); //鑾峰彇ERP閰嶇疆
+
#region[杞﹂棿鐪嬫澘,涓婄敓浜т俊鎭痌
public static ToMessage WorkShopProduceTopData(string wkshopcode)
@@ -19,7 +21,7 @@
var dynamicParams = new DynamicParameters();
try
{
- string[] wkshoplist = Array.ConvertAll<string, string>(wkshopcode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string鍒嗗壊杞瑂tring[]
+ 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);
@@ -109,9 +111,29 @@
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";
+ switch (ErpPath)
+ {
+ case "T+":
+ sql = @"select * from h_v_JLKanBan_TCloundWorkShopCompreLeftTop";
+ break;
+ case "T8":
+ sql = @"select * from h_v_JLKanBan_T8WorkShopCompreLeftTop";
+ break;
+ default:
+ break;
+ }
var data = DapperHelper.selecttable(sql);
- sql = @"select * from h_v_JLKanBan_WorkShopCompreLeftCenter";
+ switch (ErpPath)
+ {
+ case "T+":
+ sql = @"select * from h_v_JLKanBan_TCloundWorkShopCompreLeftCenter";
+ break;
+ case "T8":
+ sql = @"select * from h_v_JLKanBan_T8WorkShopCompreLeftCenter";
+ break;
+ default:
+ break;
+ }
var data1 = DapperHelper.selecttable(sql);
for (int i = 0; i < wkshoplist.Length; i++)
{
@@ -161,9 +183,30 @@
Dictionary<object, object> dir = new Dictionary<object, object>();
try
{
- sql = @"select * from h_v_JLKanBan_WorkShopCompreRightTop";
+ switch (ErpPath)
+ {
+ case "T+":
+ sql = @"select * from h_v_JLKanBan_TCloundWorkShopCompreRightTop";
+ break;
+ case "T8":
+ sql = @"select * from h_v_JLKanBan_T8WorkShopCompreRightTop";
+ break;
+ default:
+ break;
+ }
var data = DapperHelper.selecttable(sql);
- sql = @"select * from h_v_JLKanBan_WorkShopCompreRightCenter";
+ switch (ErpPath)
+ {
+ case "T+":
+ sql = @"select * from h_v_JLKanBan_TCloundWorkShopCompreRightCenter";
+ break;
+ case "T8":
+ sql = @"select * from h_v_JLKanBan_T8WorkShopCompreRightCenter";
+ break;
+ default:
+ break;
+ }
+
var data1 = DapperHelper.selecttable(sql);
dir.Add("RightTop", data);
dir.Add("RightBottom", data1);
@@ -189,9 +232,29 @@
Dictionary<object, object> dir = new Dictionary<object, object>();
try
{
- sql = @"select * from h_v_JLKanBan_WorkShopCompreLeftBottom_Top";
+ switch (ErpPath)
+ {
+ case "T+":
+ sql = @"select * from h_v_JLKanBan_TCloundWorkShopCompreLeftBottom_Top";
+ break;
+ case "T8":
+ sql = @"select * from h_v_JLKanBan_T8WorkShopCompreLeftBottom_Top";
+ break;
+ default:
+ break;
+ }
var data = DapperHelper.selecttable(sql);
- sql = @"select * from h_v_JLKanBan_WorkShopCompreLeftBottom_Bottom";
+ switch (ErpPath)
+ {
+ case "T+":
+ sql = @"select * from h_v_JLKanBan_TCloundWorkShopCompreLeftBottom_Bottom";
+ break;
+ case "T8":
+ sql = @"select * from h_v_JLKanBan_T8WorkShopCompreLeftBottom_Bottom";
+ break;
+ default:
+ break;
+ }
var data1 = DapperHelper.selecttable(sql);
dir.Add("BottomLeftTop", data);
dir.Add("BottomLeftBottom", data1);
@@ -217,7 +280,17 @@
Dictionary<object, object> dir = new Dictionary<object, object>();
try
{
- sql = @"select * from h_v_JLKanBan_WorkShopCompreRightBottom";
+ switch (ErpPath)
+ {
+ case "T+":
+ sql = @"select * from h_v_JLKanBan_TCloundWorkShopCompreRightBottom";
+ break;
+ case "T8":
+ sql = @"select * from h_v_JLKanBan_T8WorkShopCompreRightBottom";
+ break;
+ default:
+ break;
+ }
var data = DapperHelper.selecttable(sql);
dir.Add("Y", data.Rows[0]["BaseQuantity"].ToString());
dir.Add("B", data.Rows[1]["BaseQuantity"].ToString());
@@ -245,7 +318,17 @@
try
{
//鑾峰彇浠撳簱鐢熶骇鍔犲伐鍗曞緟鍏ュ簱鍒楄〃
- sql = @"select * from h_v_JLKanBan_WareHouseTopLeft order by voucherdate";
+ switch (ErpPath)
+ {
+ case "T+":
+ sql = @"select * from h_v_JLKanBan_TCloundWareHouseTopLeft order by voucherdate";
+ break;
+ case "T8":
+ sql = @"select * from h_v_JLKanBan_T8WareHouseTopLeft order by voucherdate";
+ break;
+ default:
+ break;
+ }
var data = DapperHelper.selecttable(sql);
mes.code = "200";
mes.message = "鏌ヨ鎴愬姛!";
@@ -269,7 +352,17 @@
try
{
//鑾峰彇浠撳簱鐢熶骇鍔犲伐鍗曞緟鍏ュ簱鍒楄〃
- sql = @"select * from h_v_JLKanBan_WareHouseTopBottom order by voucherdate";
+ switch (ErpPath)
+ {
+ case "T+":
+ sql = @"select * from h_v_JLKanBan_TCloundWareHouseTopBottom order by voucherdate";
+ break;
+ case "T8":
+ sql = @"select * from h_v_JLKanBan_T8WareHouseTopBottom order by voucherdate";
+ break;
+ default:
+ break;
+ }
var data = DapperHelper.selecttable(sql);
mes.code = "200";
mes.message = "鏌ヨ鎴愬姛!";
@@ -292,7 +385,17 @@
string sql = "";
try
{
- sql = @"select * from h_v_JLKanBan_WareHouseRightTop";
+ switch (ErpPath)
+ {
+ case "T+":
+ sql = @"select * from h_v_JLKanBan_TCloundWareHouseRightTop";
+ break;
+ case "T8":
+ sql = @"select * from h_v_JLKanBan_T8WareHouseRightTop";
+ break;
+ default:
+ break;
+ }
var data = DapperHelper.selecttable(sql);
mes.code = "200";
mes.message = "鏌ヨ鎴愬姛!";
@@ -315,7 +418,17 @@
string sql = "";
try
{
- sql = @"select * from h_v_JLKanBan_WareHouseRightBottom";
+ switch (ErpPath)
+ {
+ case "T+":
+ sql = @"select * from h_v_JLKanBan_TCloundWareHouseRightBottom";
+ break;
+ case "T8":
+ sql = @"select * from h_v_JLKanBan_T8WareHouseRightBottom";
+ break;
+ default:
+ break;
+ }
var data = DapperHelper.selecttable(sql);
mes.code = "200";
mes.message = "鏌ヨ鎴愬姛!";
--
Gitblit v1.9.3