From bd14d44a46cd191d0deb15b6f752f9477b818398 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期五, 22 九月 2023 17:53:46 +0800
Subject: [PATCH] 修改车间看板判断条件
---
VueWebApi/DLL/DAL/ErpSyncMesDAL.cs | 138 +++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 136 insertions(+), 2 deletions(-)
diff --git a/VueWebApi/DLL/DAL/ErpSyncMesDAL.cs b/VueWebApi/DLL/DAL/ErpSyncMesDAL.cs
index 94f4db8..2002ae7 100644
--- a/VueWebApi/DLL/DAL/ErpSyncMesDAL.cs
+++ b/VueWebApi/DLL/DAL/ErpSyncMesDAL.cs
@@ -1,6 +1,7 @@
锘縰sing Dapper;
using System;
using System.Collections.Generic;
+using System.Data;
using System.Linq;
using System.Web;
using VueWebApi.Tools;
@@ -11,8 +12,45 @@
{
public static ToMessage mes = new ToMessage(); //瀹氫箟鍏ㄥ眬杩斿洖淇℃伅瀵硅薄
+ #region[鍒堕�犳ā鍨嬶細鍗曚綅鍚屾]
+ public static ToMessage SeaveSearchUnit(string username)
+ {
+ var sql = "";
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ //瀛樺偍杩囩▼鍚�
+ sql = @"h_p_IFCLD_ERPUnit";
+ dynamicParams.Add("@username", username);
+ bool a = DapperHelper.IsProcedure(sql, dynamicParams);
+ if (a)
+ {
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "鍚屾鍗曚綅鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "鍚屾鍗曚綅澶辫触!";
+ mes.data = null;
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
#region[鍒堕�犳ā鍨嬶細瀛樿揣鍒嗙被鍚屾]
- public static ToMessage SeaveSearchInventoryClass(string username)
+ public static ToMessage SeaveSearchInventoryClass()
{
var sql = "";
var dynamicParams = new DynamicParameters();
@@ -20,7 +58,7 @@
{
//瀛樺偍杩囩▼鍚�
sql = @"h_p_IFCLD_ERPInventory_Class";
- bool a = DapperHelper.IsProcedure(sql, dynamicParams);
+ bool a = DapperHelper.IsProcedureNo(sql);
if (a)
{
mes.code = "200";
@@ -157,5 +195,101 @@
return mes;
}
#endregion
+
+ #region[鐢熶骇绠＄悊锛氱敓浜ц鍗曞悓姝
+ public static ToMessage SeaveSearchErpOrder(string stu_torgcode,string stu_torgtypecode)
+ {
+ var sql = "";
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ if (stu_torgcode == "" || stu_torgcode == null)
+ {
+ stu_torgcode = "";
+ }
+ if (stu_torgtypecode == "D")
+ {
+ sql = @" with CTE as (
+ select id, org_code,org_name, parent_id
+ from TOrganization A
+ where org_code =@stu_torgcode
+ union all
+ select A.id,A.org_code,A.org_name,A.parent_id
+ from TOrganization A
+ inner join CTE on A.parent_id = CTE.id
+ )
+ select org_code,org_name from CTE";
+ dynamicParams.Add("@stu_torgcode", stu_torgcode);
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ stu_torgcode=string.Join(",", data.AsEnumerable().Select(row => row.Field<string>("org_code")));
+ //stu_torgcode = string.Join(",", data.AsEnumerable().Select(row => $"'{row.Field<string>("org_code")}'"));
+ //LogHelper.WriteLogData("鑾峰彇杞﹂棿缂栫爜锛�"+stu_torgcode);
+ }
+ //瀛樺偍杩囩▼鍚�
+ sql = @"h_p_IFCLD_ERPMO";
+ dynamicParams.Add("@stu_torgcode", stu_torgcode);
+ dynamicParams.Add("@stu_torgtypecode", stu_torgtypecode);
+ bool a = DapperHelper.IsProcedure(sql, dynamicParams);
+ if (a)
+ {
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "鍚屾鐢熶骇璁㈠崟鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "鍚屾鐢熶骇璁㈠崟澶辫触!";
+ mes.data = null;
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[閲囪喘绠＄悊锛氶噰璐鍗曞悓姝
+ public static ToMessage SeaveSearchErpPurchaseOrder()
+ {
+ var sql = "";
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ //瀛樺偍杩囩▼鍚�
+ sql = @"h_p_IFCLD_ERPPurchaseOrder";
+ bool a = DapperHelper.IsProcedureNo(sql);
+ if (a)
+ {
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "鍚屾閲囪喘璁㈠崟鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "鍚屾閲囪喘璁㈠崟澶辫触!";
+ mes.data = null;
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
}
}
\ No newline at end of file
--
Gitblit v1.9.3