From 195b4a9f4ce855f550070ba90b9f3c57471e1d5b Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期三, 04 九月 2024 18:10:18 +0800 Subject: [PATCH] 物料添加单个流转卡数量,批量生成流转卡优化,到货确认模块添加添康科技客户 --- WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs | 17 ++++++++++++----- 1 files changed, 12 insertions(+), 5 deletions(-) diff --git a/WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs b/WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs index 5cdf611..28e33cc 100644 --- a/WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs +++ b/WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs @@ -1065,7 +1065,7 @@ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql = string.Format(@"exec h_p_Sc_GetProcessExchangeBillSubTech "); - ds = oCN.RunProcReturn(sql + HInterID, "h_p_Sc_GetProcessExchangeBillSubTech"); + ds = oCN.RunProcReturn(sql + " '" + HInterID + "'", "h_p_Sc_GetProcessExchangeBillSubTech"); //娣诲姞鍒楀悕 foreach (DataColumn col in ds.Tables[0].Columns) @@ -2083,18 +2083,24 @@ DateTime dt = DateTime.Now; string sql = ""; + Int64 HInterID = 0; string HBillNo = ""; Int64 HICMOInterID = 0; Int64 HICMOEntryID = 0; string HICMOBillNo = ""; double HQty = 0; + double HProQty = 0; + foreach (Model.ClsSc_ProcessExchangeBillSub_BatchSplit oItemSub in ls) { - HBillNo = DBUtility.ClsPub.CreateBillCode_Prod("3772", ref DBUtility.ClsPub.sExeReturnInfo, true); + //HBillNo = DBUtility.ClsPub.CreateBillCode_Prod("3772", ref DBUtility.ClsPub.sExeReturnInfo, true); + HInterID = oItemSub.HInterID; + HBillNo = oItemSub.HBillNo; HICMOInterID = oItemSub.HICMOInterID; HICMOEntryID = oItemSub.HICMOEntryID; HICMOBillNo = oItemSub.HICMOBillNo; HQty = oItemSub.HQty; + HProQty = oItemSub.HProQty; sql = "select * from h_v_Sc_ProcessExchangeBill_BatchSplit where hmainid = " + oItemSub.HICMOInterID + " and hentryid = " + oItemSub.HICMOEntryID; @@ -2102,6 +2108,7 @@ //涓昏〃璧嬪�� if (ds.Tables[0].Rows.Count > 0 && ds != null) { + oBill.omodel.HInterID = HInterID; oBill.omodel.HBillNo = HBillNo; oBill.omodel.HBillSubType = "3772"; oBill.omodel.HMainSourceBillSubType = "3710"; @@ -2112,7 +2119,7 @@ oBill.omodel.HYear = DBUtility.ClsPub.isLong(oItemSub.HDate.Year); oBill.omodel.HPeriod = DBUtility.ClsPub.isLong(oItemSub.HDate.Month); oBill.omodel.HRemark = ""; - oBill.omodel.HBatchNo = ""; + oBill.omodel.HBatchNo = oItemSub.HBatchNo; oBill.omodel.HMainMaterID = 0; oBill.omodel.HKeyMaterID = 0; oBill.omodel.HNo = 0; @@ -2205,7 +2212,7 @@ oBill.omodel.HRemark_New = ""; oBill.omodel.HWeight_New = 0; oBill.omodel.HPlanOrderProcNo = ds.Tables[0].Rows[0]["HPlanOrderProcNo"].ToString(); - oBill.omodel.HMouldNum = "0"; + oBill.omodel.HMouldNum = "0"; } //瀛愯〃璧嬪�� for(int i = 0; i < ds.Tables[0].Rows.Count; i++) @@ -2239,7 +2246,7 @@ oItemSubs.HWorkerID = 0; oItemSubs.HWorkerNumber = ""; oItemSubs.HSourceID = 0; - oItemSubs.HQty = HQty; + oItemSubs.HQty = HProQty; oItemSubs.HTimeUnit = ""; oItemSubs.HPlanWorkTimes = 0; oItemSubs.HPlanBeginDate = Convert.ToDateTime(dt.ToShortDateString().ToString()); -- Gitblit v1.9.1