From b6349cb2b3a868c8c917ca221bb7eaf6f272bdd2 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期一, 22 八月 2022 10:59:55 +0800
Subject: [PATCH] 功能模块添加过滤器
---
VueWebApi/DLL/DAL/QualityManagementDAL.cs | 18 ++++++++----------
1 files changed, 8 insertions(+), 10 deletions(-)
diff --git a/VueWebApi/DLL/DAL/QualityManagementDAL.cs b/VueWebApi/DLL/DAL/QualityManagementDAL.cs
index aee0a95..fb94930 100644
--- a/VueWebApi/DLL/DAL/QualityManagementDAL.cs
+++ b/VueWebApi/DLL/DAL/QualityManagementDAL.cs
@@ -29,7 +29,7 @@
{
if (defectcode != "" && defectcode != null)
{
- search += "and A.code=@defectcode ";
+ search += "and A.code like '%'+@defectcode+'%' ";
dynamicParams.Add("@defectcode", defectcode);
}
if (defectname != "" && defectname != null)
@@ -211,7 +211,7 @@
{
if (stanedcode != "" && stanedcode != null)
{
- search += "and A.code=@stanedcode ";
+ search += "and A.code like '%'+@stanedcode+'%' ";
dynamicParams.Add("@stanedcode", stanedcode);
}
if (stanedname != "" && stanedname != null)
@@ -400,21 +400,21 @@
{
mes.code = "200";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔鎴愬姛!";
+ mes.Message = "鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔澶辫触!";
+ mes.Message = "鎿嶄綔澶辫触!";
mes.data = null;
}
}
if (opertype == "Update")
{
//鍒犻櫎宸ュ簭妫�楠屾爣鍑嗗瓙琛�
- sql = @"delete from TStepCheckStandard where code=@stepstaned_code";
+ sql = @"delete from TStepCheckStandardSub where stepstaned_code=@stepstaned_code";
list.Add(new { str = sql, parm = new { stepstaned_code = json.code} });
//淇敼宸ュ簭妫�楠屾爣鍑嗕富琛�
sql = @"update TStepCheckStandard set name=@stepstaned_name,descr=@stepstaned_desc where code=@stepstaned_code";
@@ -433,14 +433,14 @@
{
mes.code = "200";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔鎴愬姛!";
+ mes.Message = "鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔澶辫触!";
+ mes.Message = "鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -467,7 +467,7 @@
{
if (itemcode != "" && itemcode != null)
{
- search += "and A.code=@itemcode ";
+ search += "and A.code like '%'+@itemcode+'%' ";
dynamicParams.Add("@itemcode", itemcode);
}
if (itemname != "" && itemname != null)
@@ -636,8 +636,6 @@
return mes;
}
#endregion
-
-
}
}
\ No newline at end of file
--
Gitblit v1.9.3