From b2322f6e919ffc2efd1fa5af21ec2b54b6a070bc Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期一, 27 三月 2023 23:01:30 +0800
Subject: [PATCH] 工序出站扫码，明细；条码生成添加炉号等字段；
---
WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs | 9 ++++++---
1 files changed, 6 insertions(+), 3 deletions(-)
diff --git a/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs b/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs
index 099cf8e..acdf976 100644
--- a/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs
+++ b/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs
@@ -2190,6 +2190,7 @@
List<ClsSc_StationOutBillSub_Emp> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsSc_StationOutBillSub_Emp>>(msg2);
List<ClsSc_StationOutBillSub_Emp> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsSc_StationOutBillSub_Emp>>(msg3);
+ long HInterID = mainList[0].HInterID;
long HWorkEmpID = subList[0].HWorkEmpID;
long HWorkSourceID = subList[0].HWorkSourceID;
decimal HQty = subList[0].HQty;
@@ -2197,21 +2198,23 @@
decimal HProcPrice = subList[0].HProcPrice;
decimal HMoney = subList[0].HMoney;
long HWorkProcID = mainList[0].HWorkProcID;
-
+ var EntryID = 0;
foreach (ClsSc_StationOutBillSub_Emp oSub in subList)
{
//ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList where hmainid=" + HInterID + " and 鍗曟嵁鍙�='" + HBillNo + "'", "h_v_IF_ICMOBillList");
if ((OperationType == 1 || OperationType == 2))//鏂板 && ds.Tables[0].Rows.Count == 0
{
+ EntryID++;
+
string sql = string.Empty;
sql = $@"
Insert into Sc_StationOutBillSub_Emp
(HInterID,HEntryID,HBillNo_bak ,HRemark ,HSourceInterID
,HSourceEntryID ,HSourceBillNo ,HSourceBillType ,HRelationQty ,HRelationMoney
,HWorkEmpID ,HWorkSourceID ,HQty ,HRate ,HProcPrice ,HMoney ,HWorkProcID)
- values(" + 1 + "," + 2 + "," + "'" + mainList[0].HBillNo_bak + "','" + "HRemark" + "'," + 0 + "," + 0 + ",'" + " " + "','" + "HSource" + "'," +
- "0" + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + ")";
+ values(" + HInterID + "," + EntryID + "," + "'" + mainList[0].HBillNo_bak + "','" + mainList[0].HRemark + "'," + 0 + "," + 0 + ",'" + " " + "','" + " " + "'," +
+ "0" + "," + 0 + "," + oSub.HWorkEmpID + "," + oSub.HWorkSourceID + "," + oSub.HQty + "," + oSub.HRate + "," + oSub.HProcPrice + "," + oSub.HMoney + "," + HWorkProcID + ")";
oCN.RunProc(sql);
}
--
Gitblit v1.9.1