新增 采购入库单 审核同步 接口

chenhaozhe

2025-10-16 7b30c6a4efb1762cf08153077cf4a8906eb79a59

 WebAPI/Controllers/CGGL/Kf_POStockInBillController.cs

@@ -2102,9 +2102,9 @@
        public object Kf_POStockInBillSaveApi([FromBody] JObject sMainSub)
        {
            try
            {
            { 
                oCN.BeginTran();
                LogService.Write("生产入库单同步,保存方法执行：" + sMainSub.ToString());
                LogService.Write("采购入库单同步,保存方法执行：" + sMainSub.ToString());

                var model = sMainSub["model"].ToString();
                var entry = sMainSub["model"]["HENTRY"].ToString();
@@ -2113,8 +2113,7 @@
                List<ClsKf_ICStockBillMain> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsKf_ICStockBillMain>>(model);
                List<ClsKf_ICStockBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsKf_ICStockBillSub>>(entry);


                // 判断 数据库中是否存在id和单据号相等的打单据，存在，则重建，只有id号相等，则申请新的id号
                // 判断 数据库中是否存在id和单据号相等的单据，存在，则重建，只有id号相等，则申请新的id号
                var ds1 = oCN.RunProcReturn($@"
                select hmainid HInterID, 单据号 HBillNO from h_v_Kf_POStockInBillList where hmainid = {mainList[0].HInterID}
                ", "h_v_Kf_POStockInBillList");
@@ -2142,7 +2141,7 @@

                    }
                }

               
                // 主表
                // 主表插入
                oCN.RunProc($@"Insert Into Kf_ICStockBillMain 
@@ -2185,90 +2184,7 @@
                // 子表插入
                foreach (var osub in subList)
                {

                    LogService.Write($@"Insert into Kf_ICStockBillSub 
                    (HInterID,HEntryID,HMaterID,HUnitID,HQtyMust,HQty,HPrice
                    ,HMoney,HOrderPrice,HWHID,HSPID,HRelationQty,HBatchNo
                    ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType
                    ,HPOOrderInterID,HPOOrderEntryID ,HPOOrderBillNo
                    ,HPropertyID,HSecUnitID,HSecUnitRate,HPlanMode,HRemark,HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo
                    ,HTaxRate,HTaxPrice,HlineTotal) 
                    values (
                        '{osub.HInterID}', 
                        '{osub.HEntryID}', 
                        '{osub.HMaterID}',
                        '{osub.HUnitID}', 
                        '{osub.HQtyMust}', 
                        '{osub.HQty}',
                        '{osub.HPrice}',
                        '{osub.HMoney}',
                        '{osub.HOrderPrice}',
                        '{osub.HWHID}',
                        '{osub.HSPID}',
                        '{osub.HRelationQty}',
                        '{osub.HBatchNo}',
                        '{osub.HSourceInterID}',
                        '{osub.HSourceEntryID}',
                        '{osub.HSourceBillNo}',
                        '{osub.HSourceBillType}',
                        '{osub.HPOOrderInterID}',
                        '{osub.HPOOrderEntryID}',
                        '{osub.HPOOrderBillNo}',
                        '{osub.HPropertyID}',
                        '{osub.HSecUnitID}',
                        '{osub.HSecUnitRate}',
                        '{osub.HPlanMode}',
                        '{osub.HRemark}',
                        '{osub.HSeOrderInterID}',
                        '{osub.HSeOrderEntryID}',
                        '{osub.HSeOrderBillNo}',
                        '{osub.HTaxRate}',
                        '{osub.HTaxPrice}',
                        '{osub.HlineTotal}'
                    )
                    ");

                    LogService.Write($@"Insert into Kf_ICStockBillSub 
                    (HInterID,HEntryID,HMaterID,HUnitID,HQtyMust,HQty,HPrice
                    ,HMoney,HOrderPrice,HWHID,HSPID,HRelationQty,HBatchNo
                    ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType
                    ,HPOOrderInterID,HPOOrderEntryID ,HPOOrderBillNo
                    ,HPropertyID,HSecUnitID,HSecUnitRate,HPlanMode,HRemark,HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo
                    ,HTaxRate,HTaxPrice,HlineTotal) 
                    values (
                        '{osub.HInterID}', 
                        '{osub.HEntryID}', 
                        '{osub.HMaterID}',
                        '{osub.HUnitID}', 
                        '{osub.HQtyMust}', 
                        '{osub.HQty}',
                        '{osub.HPrice}',
                        '{osub.HMoney}',
                        '{osub.HOrderPrice}',
                        '{osub.HWHID}',
                        '{osub.HSPID}',
                        '{osub.HRelationQty}',
                        '{osub.HBatchNo}',
                        '{osub.HSourceInterID}',
                        '{osub.HSourceEntryID}',
                        '{osub.HSourceBillNo}',
                        '{osub.HSourceBillType}',
                        '{osub.HPOOrderInterID}',
                        '{osub.HPOOrderEntryID}',
                        '{osub.HPOOrderBillNo}',
                        '{osub.HPropertyID}',
                        '{osub.HSecUnitID}',
                        '{osub.HSecUnitRate}',
                        '{osub.HPlanMode}',
                        '{osub.HRemark}',
                        '{osub.HSeOrderInterID}',
                        '{osub.HSeOrderEntryID}',
                        '{osub.HSeOrderBillNo}',
                        '{osub.HTaxRate}',
                        '{osub.HTaxPrice}',
                        '{osub.HlineTotal}'
                    )
                    ");
                   
                    oCN.RunProc($@"Insert into Kf_ICStockBillSub 
                    (HInterID,HEntryID,HMaterID,HUnitID,HQtyMust,HQty,HPrice
                    ,HMoney,HOrderPrice,HWHID,HSPID,HRelationQty,HBatchNo