王 垚
2021-09-13 527469d17b75d42349bf17234ef3e34cc36e8920
src/BLL/Demo.BillView/PRD/Pro_MaterialRequisitionAuditDayPlan.cs
@@ -145,7 +145,7 @@
                }
            }
            // 为新建的源单关联信息,设置内码
            IDBService dbService = ServiceHelper.GetService<IDBService>();
            IDBService dbService = Kingdee.K3.SCM.App.ServiceHelper.GetService<IDBService>();
            dbService.AutoSetPrimaryKey(this.Context, allNewLinkRows.ToArray(), linkEntry.DynamicObjectType);
        }
        /// <summary>
@@ -159,13 +159,12 @@
                return;
            string FentryId = string.Join(",", FentryIdList.ToArray());
            List<string> sqlList = new List<string>();
            //          string sql = string.Format(@"/*dialect*/
            //update a set FBASEACTUALQTY = b.FBASEACTUALQTY
            // from T_PRD_PICKMTRLDATA_LK a
            // join T_PRD_PICKMTRLDATA b on a.FENTRYID = b.FENTRYID
            // where a.FSTABLENAME = 'T_PRD_PPBOMENTRY' and a.FENTRYID in ({0})", FentryId);
            //          sqlList.Add(sql);
            string sql = string.Format(@"/*dialect*/
            update a set FSTOCKAPPQTY = FAPPQTY,FSTOCKACTUALQTY=FACTUALQTY
             from T_PRD_PICKMTRLDATA a
             where  a.FENTRYID in ({0})", FentryId);
            sqlList.Add(sql);
            sql = string.Format(@"/*dialect*/
update a set
FSrcBillType='PRD_PPBOM',
FSrcBillNo = b.FPPBOMBILLNO,
@@ -186,7 +185,7 @@
        /// <returns></returns>
        private DynamicObject[] LoadPurchaseOrder(HashSet<string> poBillNos)
        {
            IViewService viewService = ServiceHelper.GetService<IViewService>();
            IViewService viewService = Kingdee.K3.SCM.App.ServiceHelper.GetService<IViewService>();
            string formId = "PRD_PPBOM";
            // 指定需要加载的销售订单字段
@@ -238,7 +237,7 @@
        /// <returns></returns>
        private string GetPOEntryTableNumber()
        {
            IBusinessFlowService bfMetaService = ServiceHelper.GetService<IBusinessFlowService>();
            IBusinessFlowService bfMetaService = Kingdee.K3.SCM.App.ServiceHelper.GetService<IBusinessFlowService>();
            var tableDefine = bfMetaService.LoadTableDefine(this.Context, POFormId, "FEntity");
            return tableDefine.TableNumber;
        }
@@ -257,7 +256,7 @@
            linkRow["RuleId"] = "PRD_PPBOM2PICKMTRL_NORMAL";
            linkRow["SBillId"] = ((DynamicObject)srcRow.Parent)[0];
            linkRow["STableId"] = ((DynamicObject)srcRow.Parent)[0];
            linkRow["SId"] = srcRow[0];
            linkRow["SId"] = toRow["PPBomEntryId"];
            linkRow["BaseActualQtyOld"] = remainQty;
            linkRow["BaseActualQty"] = toRow["ACTUALQTY"]; //基本单位实发数量