From a4139771f09730b92fbb1672acc53e60987acee5 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期四, 01 六月 2023 20:51:25 +0800
Subject: [PATCH] 生产入库有源单接口修改
---
VueWebApi/DLL/DAL/ProductionManagementDAL.cs | 130 +++++++++++++++++++++---------------------
1 files changed, 65 insertions(+), 65 deletions(-)
diff --git a/VueWebApi/DLL/DAL/ProductionManagementDAL.cs b/VueWebApi/DLL/DAL/ProductionManagementDAL.cs
index 8348835..11c17c9 100644
--- a/VueWebApi/DLL/DAL/ProductionManagementDAL.cs
+++ b/VueWebApi/DLL/DAL/ProductionManagementDAL.cs
@@ -4790,77 +4790,77 @@
});
//鑾峰彇ERP鍏ュ簱琛╯ql
- //DataTable dt = DapperHelper.lissql("h_p_MesInErpProductWareHous");
+ DataTable dt = DapperHelper.lissql("h_p_MesInErpProductWareHous");
//鍐欏叆ERP鍏ュ簱璁板綍涓昏〃
- //sql = @"" + dt.Rows[0]["cname"].ToString() + "";
- //list.Add(new
- //{
- // str = sql,
- // parm = new
- // {
- // code = obj["head"]["hbillno"].ToString(),
- // sourceVoucherId = obj["head"]["sourceVoucherId"].ToString(),
- // sourceVoucherCode = obj["head"]["sourceVoucherCode"].ToString(),
- // saleOrderId = obj["head"]["saleOrderId"].ToString(),
- // saleOrderCode = obj["head"]["saleOrderCode"].ToString(),
- // rdDirectionFlag = obj["head"]["rdDirectionFlag"].ToString(),
- // makerid = obj["head"]["makerid"].ToString(),
- // maker = obj["head"]["maker"].ToString(),
- // accountingyear = obj["head"]["accountingyear"].ToString(),
- // VoucherYear = obj["head"]["VoucherYear"].ToString(),
- // VoucherPeriod = obj["head"]["VoucherPeriod"].ToString(),
- // ManufactureOrderCode = obj["head"]["ManufactureOrderCode"].ToString(),
- // idbusitype = obj["head"]["idbusitype"].ToString(),
- // iddepartment = obj["head"]["iddepartment"].ToString(),
- // idrdstyle = obj["head"]["idrdstyle"].ToString(),
- // idwarehouse = obj["head"]["idwarehouse"].ToString(),
- // voucherState = obj["head"]["voucherState"].ToString(),
- // idvouchertype = obj["head"]["idvouchertype"].ToString(),
- // voucherdate = obj["head"]["voucherdate"].ToString(),
- // madedate = obj["head"]["madedate"].ToString(),
- // createdtime = obj["head"]["createdtime"].ToString(),
- // DataSource = obj["head"]["DataSource"].ToString(),
+ sql = @"" + dt.Rows[0]["cname"].ToString() + "";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ code = obj["head"]["hbillno"].ToString(),
+ sourceVoucherId = obj["head"]["sourceVoucherId"].ToString(),
+ sourceVoucherCode = obj["head"]["sourceVoucherCode"].ToString(),
+ saleOrderId = obj["head"]["saleOrderId"].ToString(),
+ saleOrderCode = obj["head"]["saleOrderCode"].ToString(),
+ rdDirectionFlag = obj["head"]["rdDirectionFlag"].ToString(),
+ makerid = obj["head"]["makerid"].ToString(),
+ maker = obj["head"]["maker"].ToString(),
+ accountingyear = obj["head"]["accountingyear"].ToString(),
+ VoucherYear = obj["head"]["VoucherYear"].ToString(),
+ VoucherPeriod = obj["head"]["VoucherPeriod"].ToString(),
+ ManufactureOrderCode = obj["head"]["ManufactureOrderCode"].ToString(),
+ idbusitype = obj["head"]["idbusitype"].ToString(),
+ iddepartment = obj["head"]["iddepartment"].ToString(),
+ idrdstyle = obj["head"]["idrdstyle"].ToString(),
+ idwarehouse = obj["head"]["idwarehouse"].ToString(),
+ voucherState = obj["head"]["voucherState"].ToString(),
+ idvouchertype = obj["head"]["idvouchertype"].ToString(),
+ voucherdate = obj["head"]["voucherdate"].ToString(),
+ madedate = obj["head"]["madedate"].ToString(),
+ createdtime = obj["head"]["createdtime"].ToString(),
+ DataSource = obj["head"]["DataSource"].ToString(),
- // }
- //});
+ }
+ });
//鍐欏叆ERP銆丮ES鍏ュ簱璁板綍瀛愯〃
for (int j = 0; j < subsum_arra.Count; j++)
{
//鍐欏叆ERP鍏ュ簱璁板綍瀛愯〃
- //sql = @"" + dt.Rows[1]["cname"].ToString() + "";
- //list.Add(new
- //{
- // str = sql,
- // parm = new
- // {
- // code= subsum_arra[j]["code"].ToString(),
- // arrivalQuantity = subsum_arra[j]["arrivalQuantity"].ToString(),
- // quantity = subsum_arra[j]["quantity"].ToString(),
- // compositionQuantity = subsum_arra[j]["compositionQuantity"].ToString(),
- // baseQuantity = subsum_arra[j]["baseQuantity"].ToString(),
- // sourceVoucherId = subsum_arra[j]["sourceVoucherId"].ToString(),
- // sourceVoucherCode = subsum_arra[j]["sourceVoucherCode"].ToString(),
- // sourceVoucherDetailId = subsum_arra[j]["sourceVoucherDetailId"].ToString(),
- // idsourcevouchertype = subsum_arra[j]["idsourcevouchertype"].ToString(),
- // saleOrderId = subsum_arra[j]["saleOrderId"].ToString(),
- // saleOrderCode = subsum_arra[j]["saleOrderCode"].ToString(),
- // saleOrderDetailId = subsum_arra[j]["saleOrderDetailId"].ToString(),
- // ManufactureOrderId = subsum_arra[j]["ManufactureOrderId"].ToString(),
- // ManufactureOrderCode = subsum_arra[j]["ManufactureOrderCode"].ToString(),
- // ManufactureOrderDetailId = subsum_arra[j]["ManufactureOrderDetailId"].ToString(),
- // idbusiTypeByMergedFlow = subsum_arra[j]["idbusiTypeByMergedFlow"].ToString(),
- // idinventory = subsum_arra[j]["idinventory"].ToString(),
- // idbaseunit = subsum_arra[j]["idbaseunit"].ToString(),
- // idunit= subsum_arra[j]["idunit"].ToString(),
- // idwarehouse = subsum_arra[j]["idwarehouse"].ToString(),
- // SourceVoucherIdByMergedFlow = subsum_arra[j]["SourceVoucherIdByMergedFlow"].ToString(),
- // SourceVoucherCodeByMergedFlow = subsum_arra[j]["SourceVoucherCodeByMergedFlow"].ToString(),
- // SourceVoucherDetailIdByMergedFlow = subsum_arra[j]["SourceVoucherDetailIdByMergedFlow"].ToString(),
- // idsourceVoucherTypeByMergedFlow = subsum_arra[j]["idsourceVoucherTypeByMergedFlow"].ToString(),
- // createdtime = subsum_arra[j]["createdtime"].ToString(),
- // DataSource = subsum_arra[j]["DataSource"].ToString()
- // }
- //});
+ sql = @"" + dt.Rows[1]["cname"].ToString() + "";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ code = subsum_arra[j]["code"].ToString(),
+ arrivalQuantity = subsum_arra[j]["arrivalQuantity"].ToString(),
+ quantity = subsum_arra[j]["quantity"].ToString(),
+ compositionQuantity = subsum_arra[j]["compositionQuantity"].ToString(),
+ baseQuantity = subsum_arra[j]["baseQuantity"].ToString(),
+ sourceVoucherId = subsum_arra[j]["sourceVoucherId"].ToString(),
+ sourceVoucherCode = subsum_arra[j]["sourceVoucherCode"].ToString(),
+ sourceVoucherDetailId = subsum_arra[j]["sourceVoucherDetailId"].ToString(),
+ idsourcevouchertype = subsum_arra[j]["idsourcevouchertype"].ToString(),
+ saleOrderId = subsum_arra[j]["saleOrderId"].ToString(),
+ saleOrderCode = subsum_arra[j]["saleOrderCode"].ToString(),
+ saleOrderDetailId = subsum_arra[j]["saleOrderDetailId"].ToString(),
+ ManufactureOrderId = subsum_arra[j]["ManufactureOrderId"].ToString(),
+ ManufactureOrderCode = subsum_arra[j]["ManufactureOrderCode"].ToString(),
+ ManufactureOrderDetailId = subsum_arra[j]["ManufactureOrderDetailId"].ToString(),
+ idbusiTypeByMergedFlow = subsum_arra[j]["idbusiTypeByMergedFlow"].ToString(),
+ idinventory = subsum_arra[j]["idinventory"].ToString(),
+ idbaseunit = subsum_arra[j]["idbaseunit"].ToString(),
+ idunit = subsum_arra[j]["idunit"].ToString(),
+ idwarehouse = subsum_arra[j]["idwarehouse"].ToString(),
+ SourceVoucherIdByMergedFlow = subsum_arra[j]["SourceVoucherIdByMergedFlow"].ToString(),
+ SourceVoucherCodeByMergedFlow = subsum_arra[j]["SourceVoucherCodeByMergedFlow"].ToString(),
+ SourceVoucherDetailIdByMergedFlow = subsum_arra[j]["SourceVoucherDetailIdByMergedFlow"].ToString(),
+ idsourceVoucherTypeByMergedFlow = subsum_arra[j]["idsourceVoucherTypeByMergedFlow"].ToString(),
+ createdtime = subsum_arra[j]["createdtime"].ToString(),
+ DataSource = subsum_arra[j]["DataSource"].ToString()
+ }
+ });
//鍐欏叆MES鍏ュ簱璁板綍瀛愯〃
sql = @"insert into TK_WMS_Inwh_Sub(hbillno,rownumber,materiel_code,storehouse_code,qty)
values(@hbillno,@rownumber,@materiel_code,@storehouse_code,@qty)";
--
Gitblit v1.9.3