| | |
| | | as DynamicObjectCollection; |
| | | foreach (var entryRow in entryRows) |
| | | { |
| | | |
| | | string srcFormId = "PRD_PPBOM"; |
| | | string srcSrcBillNo = entryRow["FPPBOMBILLNO"]?.ToString(); |
| | | string FPPBOMFID = entryRow["FPPOMFID"]?.ToString(); |
| | |
| | | } |
| | | } |
| | | // 为新建的源单关联信息,设置内码 |
| | | IDBService dbService = ServiceHelper.GetService<IDBService>(); |
| | | IDBService dbService = Kingdee.K3.SCM.App.ServiceHelper.GetService<IDBService>(); |
| | | dbService.AutoSetPrimaryKey(this.Context, allNewLinkRows.ToArray(), linkEntry.DynamicObjectType); |
| | | } |
| | | |
| | |
| | | if (FentryIdList.Count > 0) |
| | | { |
| | | string FentryId = string.Join(",", FentryIdList.ToArray()); |
| | | sql = string.Format(@"/*dialect*/ |
| | | update a set FBASEQTY = FQTY |
| | | from T_STK_STKTRANSFERINENTRY_LK a |
| | | join T_STK_STKTRANSFERINENTRY b on a.FENTRYID = b.FENTRYID |
| | | where |
| | | --a.FSTABLENAME = 'T_PRD_PPBOMENTRY' and |
| | | a.FENTRYID in ({0})", FentryId); |
| | | sqlList.Add(sql); |
| | | // sql = string.Format(@"/*dialect*/ |
| | | //update a set FBASEQTY = FQTY |
| | | //from T_STK_STKTRANSFERINENTRY_LK a |
| | | //join T_STK_STKTRANSFERINENTRY b on a.FENTRYID = b.FENTRYID |
| | | //where |
| | | //--a.FSTABLENAME = 'T_PRD_PPBOMENTRY' and |
| | | //a.FENTRYID in ({0})", FentryId); |
| | | // sqlList.Add(sql); |
| | | sql = string.Format(@"/*dialect*/update T_STK_STKTRANSFERINENTRY_R |
| | | set FSrcBillTypeId = 'PRD_PPBOM',FSRCBILLNO=b.FPPBOMBILLNO |
| | | ,FTRANSRESERVELINK=1 |
| | |
| | | /// <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"; |
| | | |
| | | // 指定需要加载的用料清单字段 |
| | |
| | | /// <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; |
| | | } |