From ece3372b4f7500483092a90f2a1e40f3586f6f1b Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期四, 23 六月 2022 18:47:14 +0800
Subject: [PATCH] 存货档案、工艺路线(新增、编辑、删除、关联工艺路线)
---
VueWebApi/DLL/DAL/DeviceManagerDAL.cs | 43 +++++++++++++++++++++++++++++++++++--------
1 files changed, 35 insertions(+), 8 deletions(-)
diff --git a/VueWebApi/DLL/DAL/DeviceManagerDAL.cs b/VueWebApi/DLL/DAL/DeviceManagerDAL.cs
index 1745424..8dde061 100644
--- a/VueWebApi/DLL/DAL/DeviceManagerDAL.cs
+++ b/VueWebApi/DLL/DAL/DeviceManagerDAL.cs
@@ -59,7 +59,7 @@
//寰幆鍐欏叆璁惧绫诲瀷琛�
for (int i = 0; i < json.Count; i++)
{
- sql = @"insert into TRoleType(code,name,lm_user,lm_date,remark) values(@code,@name,@username,@createdate,@description)";
+ sql = @"insert into TEqpType(code,name,lm_user,lm_date,remark) values(@code,@name,@username,@createdate,@description)";
list.Add(new
{
str = sql,
@@ -112,8 +112,8 @@
//鍒ゆ柇璁惧绫诲瀷涓嬫槸鍚﹀叧鑱旇澶囩粍
sql = @"select * from TEqpGroup where eqptype_code=@devicetypecode and is_delete<>'1'";
dynamicParams.Add("@devicetypecode", devicetypecode);
- var data = DapperHelper.select<TreeObejct>(sql, dynamicParams);
- if (data.Count > 0)
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ if (data.Rows.Count > 0)
{
mes.code = "300";
mes.count = 0;
@@ -125,8 +125,8 @@
//鍒ゆ柇璁惧鏈夋棤鍏宠仈璁惧绫诲瀷
sql = @"select * from TEqpInfo where eqptype_code=@devicetypecode and is_delete<>'1'";
dynamicParams.Add("@devicetypecode", devicetypecode);
- var data0 = DapperHelper.select<TreeObejct>(sql, dynamicParams);
- if (data0.Count > 0)
+ var data0 = DapperHelper.selectdata(sql, dynamicParams);
+ if (data0.Rows.Count > 0)
{
mes.code = "300";
mes.count = 0;
@@ -288,8 +288,8 @@
//鍒ゆ柇璁惧缁勪笅鏄惁鍏宠仈璁惧
sql = @"select * from TEqpInfo where eqpgroup_code=@devicegroupcode and is_delete<>'1'";
dynamicParams.Add("@devicegroupcode", devicegroupcode);
- var data = DapperHelper.select<TreeObejct>(sql, dynamicParams);
- if (data.Count > 0)
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ if (data.Rows.Count > 0)
{
mes.code = "300";
mes.count = 0;
@@ -382,6 +382,33 @@
}
#endregion
+ #region[鎵�灞炶溅闂存煡鎵炬墍灞炰骇绾挎帴鍙
+ public static ToMessage WorkShopSelectLine(string workshopcode)
+ {
+ string sql = "";
+ var dynamicParams = new DynamicParameters();
+ List<TreeObejct> list = new List<TreeObejct>();
+ try
+ {
+ //鑾峰彇瑙掕壊绫诲瀷闆嗗悎(鍖呭惈缁戝畾鏍囪瘑)
+ dynamicParams.Add("@workshop_code", workshopcode);
+ var data = DapperHelper.selectProcedure("h_p_T_WorkShopSelectLine", 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 DeviceMangerSearch(string deviceCode, string deviceName, string status, string workShop, string deviceType, string deviceGroup, int startNum, int endNum, string prop, string order)
{
@@ -401,7 +428,7 @@
}
if (status != "" && status != null)
{
- search += "and A.status=@status ";
+ search += "and A.enable=@status ";
dynamicParams.Add("@status", status);
}
if (workShop != "" && workShop != null)
--
Gitblit v1.9.3