From 437b5cd5f34c9c2f16c6a939b178afe6cdb64f27 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期四, 21 七月 2022 18:56:48 +0800
Subject: [PATCH] 用户清单导入
---
VueWebApi/DLL/DAL/QualityManagementDAL.cs | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/VueWebApi/DLL/DAL/QualityManagementDAL.cs b/VueWebApi/DLL/DAL/QualityManagementDAL.cs
index aee0a95..8e6d5f0 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)
@@ -414,7 +414,7 @@
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";
@@ -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)
--
Gitblit v1.9.3