From 7ff74f599084561338eef1230db5aa45f74565f8 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期一, 15 四月 2024 18:03:33 +0800
Subject: [PATCH] 1.ERP订单关闭增加单据id 2.MES工单关闭增加源单id关联
---
VueWebCoreApi/DLL/DAL/MouldManagerDAL.cs | 41 ++++++++++++++++++++++++-----------------
1 files changed, 24 insertions(+), 17 deletions(-)
diff --git a/VueWebCoreApi/DLL/DAL/MouldManagerDAL.cs b/VueWebCoreApi/DLL/DAL/MouldManagerDAL.cs
index 713538e..769a0b6 100644
--- a/VueWebCoreApi/DLL/DAL/MouldManagerDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/MouldManagerDAL.cs
@@ -102,7 +102,7 @@
#endregion
#region[妯″叿娓呭崟鏂板缂栬緫]
- public static ToMessage AddUpdateMouldManger(string mouldcode, string mouldname, string mouldspec, string surplife, string resilife, string status, string mouldpart, string opertype, User us)
+ public static ToMessage AddUpdateMouldManger(string mouldcode, string mouldname, string mouldspec,string warehousecode,string location_code, string surplife, string resilife, string status, string mouldpart, string opertype, User us)
{
var sql = "";
var dynamicParams = new DynamicParameters();
@@ -112,8 +112,8 @@
if (opertype == "Add")
{
//鍐欏叆妯″叿娓呭崟琛�
- sql = @"insert into TMouldInfo(code,name,spec,status,surp_life,resi_life,lm_user,lm_date)
- values(@code,@name,@spec,@status,@surp_life,@resi_life,@lm_user,@lm_date)";
+ sql = @"insert into TMouldInfo(code,name,spec,status,surp_life,resi_life,lm_user,lm_date,warehousecode,location_code)
+ values(@code,@name,@spec,@status,@surp_life,@resi_life,@lm_user,@lm_date,@warehousecode,@location_code)";
list.Add(new
{
str = sql,
@@ -125,6 +125,8 @@
status = status,
surp_life = surplife,
resi_life = resilife,
+ warehousecode=warehousecode,
+ location_code=location_code,
lm_user = us.usercode,
lm_date = DateTime.Now.ToString()
}
@@ -169,7 +171,7 @@
{
//淇敼妯″叿娓呭崟琛�
sql = @"update TMouldInfo set name=@name,spec=@spec,status=@status,
- surp_life=@surp_life,resi_life=@resi_life,lm_user=@lm_user,lm_date=@lm_date where code=@code";
+ surp_life=@surp_life,resi_life=@resi_life,lm_user=@lm_user,lm_date=@lm_date,warehousecode=@warehousecode,location_code=@location_code where code=@code";
list.Add(new
{
str = sql,
@@ -181,6 +183,8 @@
status = status,
surp_life = surplife,
resi_life = resilife,
+ warehousecode = warehousecode,
+ location_code = location_code,
lm_user = us.usercode,
lm_date = DateTime.Now.ToString()
}
@@ -250,6 +254,7 @@
string search = "";
try
{
+ dynamicParams.Add("@mouldcode", mouldcode);
if (opendate != "" && opendate != null)
{
search += "and AA.operdate between @opendate and @closedate ";
@@ -258,44 +263,46 @@
}
// --------------鏌ヨ鎸囧畾鏁版嵁--------------
var total = 0; //鎬绘潯鏁�
- var sql = @"select * from (
+ var sql = @"select top 100 percent AA.*,U.username as operusername from (
select '鐐规' as opertype,chk_user as operuser,chk_date as operdate,chk_result as operresult
- from TMouldchk_Proc_Main where mould_code='001'
+ from TMouldchk_Proc_Main where mould_code=@mouldcode
union all
select '淇濆吇' as opertype,maint_user as operuser,maint_date as operdate,maint_result as operresult
- from TMouldmaint_Proc_Main where mould_code='001'
+ from TMouldmaint_Proc_Main where mould_code=@mouldcode
union all
select '寰呯淮淇�' as opertype,request_person as operuser,request_date as operdate,'缁翠慨鐢宠' as operresult
- from TMould_RepairRequest where mould_code='001'
+ from TMould_RepairRequest where mould_code=@mouldcode
union all
select '宸茬淮淇�' as opertype,repair_person as operuser,repair_date as operdate,'缁翠慨瀹屾垚' as operresult
from TMould_RepairRequest A
inner join TMould_Repair B on A.docu_code=B.source_wo
- where A.mould_code='001' and B.repair_person<>''
+ where A.mould_code=@mouldcode and B.repair_person<>''
union all
select '宸查獙璇�' as opertype,verify_person as operuser,verify_date as operdate,B.verify_result as operresult
from TMould_RepairRequest A
inner join TMould_Repair B on A.docu_code=B.source_wo
- where A.mould_code='001' and B.verify_person<>''
+ where A.mould_code=@mouldcode and B.verify_person<>''
union all
select '宸蹭笂鏈�' as opertype,lm_user as operuser,lm_date as operdate,eqp_code as operresult
- from TMould_UpDownReord where mould_code='001' and type='UP'
+ from TMould_UpDownReord where mould_code=@mouldcode and type='UP'
union all
select '宸蹭笅鏈�' as opertype,lm_user as operuser,lm_date as operdate,eqp_code as operresult
- from TMould_UpDownReord where mould_code='001' and type='DOWN'
+ from TMould_UpDownReord where mould_code=@mouldcode and type='DOWN'
union all
select '宸插叆搴�' as opertype,lm_user as operuser,lm_date as operdate,warehouse_code as operresult
- from TMould_InOutReord where mould_code='001' and type='IN'
+ from TMould_InOutReord where mould_code=@mouldcode and type='IN'
union all
select '宸插嚭搴�' as opertype,lm_user as operuser,lm_date as operdate,warehouse_code as operresult
- from TMould_InOutReord where mould_code='001' and type='OUT'
+ from TMould_InOutReord where mould_code=@mouldcode and type='OUT'
union all
select '宸插鍊�' as opertype,lm_user as operuser,lm_date as operdate,description as operresult
- from TMould_LendOutReord where mould_code='001' and type='OUT'
+ from TMould_LendOutReord where mould_code=@mouldcode and type='OUT'
union all
select '宸插綊杩�' as opertype,lm_user as operuser,lm_date as operdate,description as operresult
- from TMould_LendOutReord where mould_code='001' and type='IN'
- ) as AA where 1=1 "+search+" order by AA.operdate desc ";
+ from TMould_LendOutReord where mould_code=@mouldcode and type='IN'
+ ) as AA
+ left join TUser U on AA.operuser=U.usercode
+ where 1=1 " + search+" order by AA.operdate desc ";
var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
mes.code = "200";
mes.message = "鏌ヨ鎴愬姛!";
--
Gitblit v1.9.3