From 5b84275a7ce63b83c778c5ac050b8c039cd4fac8 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 06 八月 2024 17:46:25 +0800
Subject: [PATCH] 1.修改接口：UpdateMesOrderStepSearch --工单派发 2.修改接口：MesOrderNewStepContent --工单派发 3.修改接口：RouteSelectStep--工单派发 4.新增组织架构类型接口：TOrganTypeDate 5.新增组织架构车间接口：TorgWkshop 6.新增车间查找设备接口：WkshopEqpPermissions 7.新增往来单位基础资料接口：CustomerTypePermissions 8.新增往来单位类型查找往来单位资料接口：CustomerTypeSearchPermissions 9.新增工序关联工作站接口 10.修改工序工价提交接口(增加了设备)
---
VueWebCoreApi/DLL/DAL/GeneralBasicDataDAL.cs | 126 +++++++++++++++++++++++++++++++++++++++++
1 files changed, 125 insertions(+), 1 deletions(-)
diff --git a/VueWebCoreApi/DLL/DAL/GeneralBasicDataDAL.cs b/VueWebCoreApi/DLL/DAL/GeneralBasicDataDAL.cs
index ae4fc9d..07182b6 100644
--- a/VueWebCoreApi/DLL/DAL/GeneralBasicDataDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/GeneralBasicDataDAL.cs
@@ -13,7 +13,7 @@
{
public class GeneralBasicDataDAL
{
- public static DataTable dt; //瀹氫箟鍏ㄥ眬鍙橀噺dt
+ public static DataTable dt; //瀹氫箟鍏ㄥ眬鍙橀噺dt
public static bool res; //瀹氫箟鍏ㄥ眬鍙橀噺dt
public static ToMessage mes = new ToMessage(); //瀹氫箟鍏ㄥ眬杩斿洖淇℃伅瀵硅薄
public static string strProcName = ""; //瀹氫箟鍏ㄥ眬sql鍙橀噺
@@ -21,7 +21,31 @@
public static SqlParameter[] parameters; //瀹氫箟鍏ㄥ眬SqlParameter鍙傛暟鏁扮粍
public static dynamic CompanyCode = AppSetting.GetAppSetting("CompanyCode");
public static dynamic CompanyName = AppSetting.GetAppSetting("CompanyName");
+
+ #region[缁勭粐鏋舵瀯绫诲瀷璧勬枡]
+ public static ToMessage TOrganTypeDate()
+ {
+ var sql = "";
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ sql = @"select torgtype_code,torgtype_name from TOrganType where torgtype_code<>'C'";
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ 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 PrentOrganization()
@@ -57,6 +81,30 @@
try
{
sql = @"select * from TOrganization where status='Y' and parent_id<>'0' or leve<>'0'";
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ 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 TorgWkshop()
+ {
+ var sql = "";
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ sql = @"select * from TOrganization where status='Y' and torgtype_code='W'";
var data = DapperHelper.selectdata(sql, dynamicParams);
mes.code = "200";
mes.message = "鏌ヨ鎴愬姛!";
@@ -364,6 +412,32 @@
}
#endregion
+ #region[杞﹂棿鏌ユ壘璁惧鍩虹璧勬枡]
+ public static ToMessage WkshopEqpPermissions(string wkshopcode)
+ {
+ var sql = "";
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ string[] wkshopcodelist = Array.ConvertAll<string, string>(wkshopcode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string鍒嗗壊杞瑂tring[]
+ sql = @"select code,name from TEqpInfo where enable='Y' and torg_code in @torg_code";
+ dynamicParams.Add("@torg_code", wkshopcodelist);
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ 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 EqpTypecodeSeachEqpPermissions(string eqptypecode)
{
@@ -534,6 +608,30 @@
}
#endregion
+ #region[寰�鏉ュ崟浣嶇被鍨嬪熀纭�璧勬枡]
+ public static ToMessage CustomerTypePermissions()
+ {
+ var sql = "";
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ sql = @"select code,name from TCustomerType";
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ 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 CustomerPermissions()
{
@@ -558,6 +656,32 @@
}
#endregion
+ #region[寰�鏉ュ崟浣嶇被鍨嬫煡鎵惧線鏉ュ崟浣嶅熀纭�璧勬枡]
+ public static ToMessage CustomerTypeSearchPermissions(string customertypecode)
+ {
+ var sql = "";
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ string[] customerTypecodelist = Array.ConvertAll<string, string>(customertypecode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string鍒嗗壊杞瑂tring[]
+ sql = @"select code,name from TCustomer where customertype in @customerTypecodelist";
+ dynamicParams.Add("@customerTypecodelist", customerTypecodelist);
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ 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 InventoryTreePermissions()
{
--
Gitblit v1.9.3