From 2dc994f4e8f55e6c762577fe97a27934102dbff5 Mon Sep 17 00:00:00 2001
From: YL <YL@LAPTOP-SE03PLUR>
Date: 星期三, 08 十二月 2021 23:50:15 +0800
Subject: [PATCH] nothing

---
 WebAPI/Controllers/BaseSet/Gy_MaterialController.cs |   11 ++++++++++-
 1 files changed, 10 insertions(+), 1 deletions(-)

diff --git a/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs b/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs
index 515fc32..0c3a0cc 100644
--- a/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs
+++ b/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs
@@ -898,7 +898,7 @@
         /// <returns></returns>
         [Route("Gy_Material/InitializeProdInBill")]
         [HttpGet]
-        public object InitializeProdInBill(long hmainid, string user)
+        public object InitializeProdInBill(long hmainid, string user,string userID)
         {
             DAL.ClsGy_MouldFile oBill = new DAL.ClsGy_MouldFile();
             try
@@ -921,8 +921,16 @@
                 ", 0," + dr["HDeptID"].ToString() +  ",' ',0"  +
 
                 ") ";
+                string sql1 = string.Format(@"Insert Into Sc_MouldStockBillSub   (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark,HSourceInterID,
+                HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HMaterID,HPropertyID,HSecUnitRate,HSecUnitID,HUnitID,
+                HBatchNo,HQtyMust,HQty,HPrice,HMoney,HDesignLife,HLeaveLife,HUseLife,HWHID,HSCWHID,HSPID,HSCSPID,HSPGroupID,HCorrespondentTypeID,HCorrespondentID,
+                HStockOrgID,HOWNERID,HOtherOrgID,HOWNERTYPEID) values(" + HInterID+ ",1,'',getdate(),0,'',0,0,'','',"+
+                "0,0,"+dr["HInterID"].ToString()+",0,0,0,"+ dr["HUnitID"].ToString()+",0,"+ dr["HProdQty"].ToString() +","+ dr["HProdQty"].ToString()+",0,"+
+                "0,"+ dr["HDesignLife"].ToString()+","+ dr["HLeaveLife"].ToString() + ","+dr["HUseLife"].ToString() + "," + dr["HWHID"].ToString() + ",0," + dr["HSPID"].ToString()+",0,0"
+                + ",0,0,"+ userID + ",0,0,'')");
                 //涓昏〃
                 oCN.RunProc(sql);
+                oCN.RunProc(sql1);
 
                 objJsonResult.code = "0";
                 objJsonResult.count = 1;
@@ -939,6 +947,7 @@
                 objJsonResult.data = null;
             }
             return objJsonResult;
+        
         }
 
         #region [妯″叿妗f瀹℃牳銆佸弽瀹℃牳]

--
Gitblit v1.9.1