From 14a48ba934fabee90b5d52471ca47883f6007732 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期三, 20 七月 2022 11:40:39 +0800
Subject: [PATCH] Excel 角色清单导入，工序检验扫码
---
VueWebApi/DLL/DAL/MaterialManagerDAL.cs | 18 ++++++++++--------
1 files changed, 10 insertions(+), 8 deletions(-)
diff --git a/VueWebApi/DLL/DAL/MaterialManagerDAL.cs b/VueWebApi/DLL/DAL/MaterialManagerDAL.cs
index 61c8a7c..f93a04f 100644
--- a/VueWebApi/DLL/DAL/MaterialManagerDAL.cs
+++ b/VueWebApi/DLL/DAL/MaterialManagerDAL.cs
@@ -28,22 +28,22 @@
{
if (warehousecode != "" && warehousecode != null)
{
- search += "and code like '%'+@warehousecode+'%' ";
+ search += "and A.code like '%'+@warehousecode+'%' ";
dynamicParams.Add("@warehousecode", warehousecode);
}
if (warehousename != "" && warehousename != null)
{
- search += "and name like '%'+@warehousename+'%' ";
+ search += "and A.name like '%'+@warehousename+'%' ";
dynamicParams.Add("@warehousename", warehousename);
}
if (description != "" && description != null)
{
- search += "and description like '%'+@description+'%' ";
+ search += "and A.description like '%'+@description+'%' ";
dynamicParams.Add("@description", description);
}
if (createuser != "" && createuser != null)
{
- search += "and lm_user like '%'+@createuser+'%' ";
+ search += "and T.username like '%'+@createuser+'%' ";
dynamicParams.Add("@createuser", createuser);
}
if (search == "")
@@ -52,8 +52,9 @@
}
// --------------鏌ヨ鎸囧畾鏁版嵁--------------
var total = 0; //鎬绘潯鏁�
- var sql = @"select id,code,name,description,lm_user,lm_date from T_Sec_Stck
- where is_delete<>'1' " + search;
+ var sql = @"select A.id,A.code,A.name,A.description,T.username as lm_user,A.lm_date from T_Sec_Stck A
+ left join TUser T on A.lm_user=T.usercode
+ where A.is_delete<>'1' " + search;
var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
mes.code = "200";
mes.Message = "鏌ヨ鎴愬姛!";
@@ -244,7 +245,7 @@
}
if (createuser != "" && createuser != null)
{
- search += "and A.lm_user like '%'+@createuser+'%' ";
+ search += "and U.username like '%'+@createuser+'%' ";
dynamicParams.Add("@createuser", createuser);
}
if (stockcode != "" && stockcode != null)
@@ -258,9 +259,10 @@
}
// --------------鏌ヨ鎸囧畾鏁版嵁--------------
var total = 0; //鎬绘潯鏁�
- var sql = @"select A.id,A.code,A.name,A.description,A.stock_code,B.name as stock_name,A.lm_user,A.lm_date
+ var sql = @"select A.id,A.code,A.name,A.description,A.stock_code,B.name as stock_name,U.username as lm_user,A.lm_date
from T_Sec_Loca A
left join T_Sec_Stck B on A.stock_code=B.code
+ left join TUser U on A.lm_user=U.usercode
where A.is_delete<>'1' " + search;
var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
mes.code = "200";
--
Gitblit v1.9.3