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/QualityManagementDAL.cs | 37 ++++++++++++++-----------------------
1 files changed, 14 insertions(+), 23 deletions(-)
diff --git a/VueWebApi/DLL/DAL/QualityManagementDAL.cs b/VueWebApi/DLL/DAL/QualityManagementDAL.cs
index e32bb19..788f8bc 100644
--- a/VueWebApi/DLL/DAL/QualityManagementDAL.cs
+++ b/VueWebApi/DLL/DAL/QualityManagementDAL.cs
@@ -686,13 +686,8 @@
search += "and A.check_result=@checkresult ";
dynamicParams.Add("@checkresult", checkresult);
}
- if (search == "")
- {
- search = "and 1=1 ";
- }
- search = search.Substring(3);//鎴彇绱㈠紩2鍚庨潰鐨勫瓧绗�
// --------------鏌ヨ鎸囧畾鏁版嵁--------------
- var total = 0; //鎬绘潯鏁�
+ var total = 0; //鎬绘潯鏁�(棣栨銆佸贰妫�銆佸畬宸ユ楠�)
var sql = @"select A.id,A.wo_code,A.partcode,B.partname,B.partspec,A.step_code,S.stepname,A.checkstaned_code,T.name as checkstaned_name,A.check_user,
A.check_type,A.check_result,A.check_descr,A.check_qty,U.username as lm_user,A.lm_date
from TStepCheckRecord A
@@ -700,7 +695,7 @@
left join TStep S on A.step_code=S.stepcode
left join TStepCheckStandard T on A.checkstaned_code=T.code
left join TUser U on A.check_user=U.usercode
- where " + search;
+ where A.check_type in('FirstCheck','PatroCheck','EndCheck') " + search;
var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
mes.code = "200";
mes.Message = "鏌ヨ鎴愬姛!";
@@ -794,11 +789,6 @@
search += "and A.check_result=@checkresult ";
dynamicParams.Add("@checkresult", checkresult);
}
- if (search == "")
- {
- search = "and 1=1 ";
- }
- search = search.Substring(3);//鎴彇绱㈠紩2鍚庨潰鐨勫瓧绗�
// --------------鏌ヨ鎸囧畾鏁版嵁--------------
var total = 0; //鎬绘潯鏁�
var sql = @"select
@@ -848,7 +838,7 @@
left join TStep S on A.step_code=S.stepcode
left join TStepCheckStandard T on A.checkstaned_code=T.code
left join TUser U on A.check_user=U.usercode
- where " + search;
+ where A.check_type in('FirstCheck','PatroCheck','EndCheck') " + search;
DataTable data = DapperHelper.selectdata(sql, dynamicParams);
data.TableName = "Table"; //璁剧疆DataTable鐨勫悕绉�
string msg = DownLoad.DataTableToExcel(data, "宸ュ簭妫�楠岃褰�");
@@ -915,20 +905,21 @@
// --------------鏌ヨ鎸囧畾鏁版嵁--------------
var total = 0; //鎬绘潯鏁�
var sql = @"select * from(
- select code,name,status,checktype,sampmethod,sampscare,suitobject,descr,suitpart,
- case when suitobject='P' then
+ select A.code,A.name,A.status,A.checktype,A.sampmethod,A.sampscare,A.suitobject,A.descr,A.suitpart,A.lm_date,U.username,
+ case when A.suitobject='P' then
STUFF(( SELECT ';' + partname
FROM TMateriel_Info
- where PATINDEX('%;' + RTRIM(TMateriel_Info.partcode) + ';%',';' + TStepCheckStandard.suitpart + ';')>0
+ where PATINDEX('%;' + RTRIM(TMateriel_Info.partcode) + ';%',';' + A.suitpart + ';')>0
FOR XML PATH('')), 1, 1,'')
- when suitobject='PY'
+ when A.suitobject='PY'
then
STUFF(( SELECT ';' + name
FROM T_Dict
- where PATINDEX('%;' + RTRIM(T_Dict.code) + ';%',';' + TStepCheckStandard.suitpart + ';')>0
+ where PATINDEX('%;' + RTRIM(T_Dict.code) + ';%',';' + A.suitpart + ';')>0
FOR XML PATH('')), 1, 1,'')
end as suitpartname
- from TStepCheckStandard
+ from TStepCheckStandard A
+ left join TUser U on A.lm_user=U.usercode
) as AA
where " + search;
var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
@@ -956,7 +947,7 @@
try
{
sql = @"select A.stepcheckitem_seq,A.stepcheckitem_code,B.name as stepcheckitem_name,A.required,
- A.numberjudge,A.unit,A.decimal,A.standvalue,A.uppervalue,A.lowervalue
+ A.numberjudge,A.unit,A.decimalnum,A.standvalue,A.uppervalue,A.lowervalue,A.stepcheckitem_desc
from TStepCheckStandardSub A
inner join TStepCheckItem B on A.stepcheckitem_code=B.code
where A.stepstaned_code=@qualityinsptcode";
@@ -1030,7 +1021,7 @@
required = arra[i]["required"].ToString(),
numberjudge = arra[i]["numberjudge"].ToString(),
unit = arra[i]["unit"].ToString(),
- decimalnum = Convert.ToInt32(arra[i]["decimalnum"].ToString()),
+ decimalnum = arra[i]["decimalnum"].ToString(),
standvalue = arra[i]["standvalue"].ToString(),
uppervalue = arra[i]["uppervalue"].ToString(),
lowervalue = arra[i]["lowervalue"].ToString(),
@@ -1043,7 +1034,7 @@
break;
case "Update"://淇敼
//鍒ゆ柇鏄惁鐢熸垚妫�楠岃褰�(鍏ュ巶妫�楠�(InCheck) 鍑哄巶妫�楠�(OutCheck) FirstCheck锛堥妫�锛� PatroCheck(宸℃) EndCheck(瀹屽伐妫�))
- sql = @"select * from TStepCheckRecord where checkstaned_code=@qualityinsptcode and checktype=@checktype";
+ sql = @"select * from TStepCheckRecord where checkstaned_code=@qualityinsptcode and check_type=@checktype";
dynamicParams.Add("@qualityinsptcode", qualityinsptcode);
dynamicParams.Add("@checktype", checktype);
var data = DapperHelper.selectdata(sql, dynamicParams);
@@ -1094,7 +1085,7 @@
required = arra[i]["required"].ToString(),
numberjudge = arra[i]["numberjudge"].ToString(),
unit = arra[i]["unit"].ToString(),
- decimalnum = Convert.ToInt32(arra[i]["decimalnum"].ToString()),
+ decimalnum = arra[i]["decimalnum"].ToString(),
standvalue = arra[i]["standvalue"].ToString(),
uppervalue = arra[i]["uppervalue"].ToString(),
lowervalue = arra[i]["lowervalue"].ToString(),
--
Gitblit v1.9.3