From dac60fce253e085b3c4f4ee049a795f16aed2eba Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期一, 08 五月 2023 18:15:39 +0800
Subject: [PATCH] 物流检验记录接口修改 末道工序完工报工自动关单方法开发 登录登出记录接口修改(去掉update,保留insert)
---
VueWebApi/DLL/DAL/ReportManagerDAL.cs | 11 +++--------
1 files changed, 3 insertions(+), 8 deletions(-)
diff --git a/VueWebApi/DLL/DAL/ReportManagerDAL.cs b/VueWebApi/DLL/DAL/ReportManagerDAL.cs
index bc93b07..320a62c 100644
--- a/VueWebApi/DLL/DAL/ReportManagerDAL.cs
+++ b/VueWebApi/DLL/DAL/ReportManagerDAL.cs
@@ -1406,7 +1406,7 @@
}
if (checkuser != "" && checkuser != null)
{
- search += "and U.usercode like '%'+@checkuser+'%' ";
+ search += "and U.username like '%'+@checkuser+'%' ";
dynamicParams.Add("@checkuser", checkuser);
}
if (opencheckdate != "" && opencheckdate != null)
@@ -1415,14 +1415,9 @@
dynamicParams.Add("@opencheckdate", opencheckdate + " 00:00:00");
dynamicParams.Add("@closecheckdate", closecheckdate + " 23:59:59");
}
- if (search == "")
- {
- search = "and 1=1 ";
- }
- search = search.Substring(3);//鎴彇绱㈠紩2鍚庨潰鐨勫瓧绗�
// --------------鏌ヨ鎸囧畾鏁版嵁--------------
var total = 0; //鎬绘潯鏁�
- var sql = @"select A.check_type,A.check_typename,A.sampmethod,M.partcode,M.partname,M.partspec,R.hbatchno,
+ var sql = @"select A.id,A.check_type,A.check_typename,A.sampmethod,M.partcode,M.partname,M.partspec,R.hbatchno,
A.hbarcode,A.customer_code,C.name as customer_name,U.usercode,U.username,A.lm_date,A.check_result
from TStepCheckRecord A
inner join TStepCheckRecordSub B on A.id=B.m_id
@@ -1430,7 +1425,7 @@
left join T_BarCodeBill R on A.hbarcode=R.hbarcode
left join TCustomer C on A.customer_code=C.code
left join TUser U on A.check_user=U.usercode
- where " + search;
+ where A.check_type in('InCheck','OutCheck') " + search;
var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
mes.code = "200";
mes.Message = "鏌ヨ鎴愬姛!";
--
Gitblit v1.9.3