From 4d4e3ad417beccd49f1fe61a158bb1bc3a3537c2 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 27 十二月 2022 15:18:17 +0800
Subject: [PATCH] 采购订单,erp同步接口开发
---
VueWebApi/DLL/DAL/ProductionManagementDAL.cs | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/VueWebApi/DLL/DAL/ProductionManagementDAL.cs b/VueWebApi/DLL/DAL/ProductionManagementDAL.cs
index 066e8fe..0f078a3 100644
--- a/VueWebApi/DLL/DAL/ProductionManagementDAL.cs
+++ b/VueWebApi/DLL/DAL/ProductionManagementDAL.cs
@@ -163,7 +163,7 @@
else
{
- sql = @"insert into TK_Wrk_Man(wo_code,wotype,status,wkshp_code,plan_qty,stck_code,materiel_code,sourceid,m_po,lm_user,lm_date) values(@wo_code,@wotype,@status,@wkshp_code,@plan_qty,@stck_code,@materiel_code,@sourceid,@m_po,@username,@CreateDate)";
+ sql = @"insert into TK_Wrk_Man(wo_code,wotype,status,wkshp_code,plan_qty,stck_code,materiel_code,sourceid,m_po,lm_user,lm_date) values(@wo_code,@wotype,@status,@wkshp_code,@plan_qty,@stck_code,@materiel_code,@sourceid,@m_po,@username,@CreateDate,@saleOrderDeliveryDate)";
list.Add(new
{
str = sql,
@@ -179,7 +179,8 @@
sourceid = erporderid,
m_po = erpordercode,
username = username,
- CreateDate = DateTime.Now.ToString()
+ CreateDate = DateTime.Now.ToString(),
+ saleOrderDeliveryDate = Convert.ToDateTime(saleOrderDeliveryDate)
}
});
}
@@ -3291,7 +3292,7 @@
A.plan_qty AdvaScheQty,
U.name AdvaScheUom,
isnull(E.sched_qty,0) AdvaScheYPQty,
- CONVERT(varchar(100), B.saleOrderDeliveryDate, 23) AdvaScheEndDate,
+ CONVERT(varchar(100), A.saleOrderDeliveryDate, 23) AdvaScheEndDate,
convert(varchar(20),isnull(E.sched_qty,0))+'/'+convert(varchar(20),isnull(A.plan_qty,0)) AdvaScheSpeed,
A.route_code AdvaScheRoutid,
F.name AdvaScheRoutName,
@@ -3302,7 +3303,6 @@
(case when CONVERT(varchar(100), H.maxtime, 23)<=CONVERT(varchar(100), E.plan_enddate, 23) then 'Y' when H.MAXTime is null then 'Y' else 'N' end) Flag,
(case when A.PiroQue='1' then '鐗规��' when A.PiroQue='2' then '绱ф��' when A.PiroQue='3' then '姝ｅ父' end) AdvaSchePiroQue
from TK_Wrk_Man A
- left join TKimp_Ewo B on A.m_po=B.wo
left join TMateriel_Info C on C.partcode= A.materiel_code
left join T_Dict D on C.stocktype_code= d.code
left join TK_Wrk_Step E on E.wo_code=A.wo_code
--
Gitblit v1.9.3