| | |
| | | } |
| | | } |
| | | // 为新建的源单关联信息,设置内码 |
| | | IDBService dbService = ServiceHelper.GetService<IDBService>(); |
| | | IDBService dbService = Kingdee.K3.SCM.App.ServiceHelper.GetService<IDBService>(); |
| | | dbService.AutoSetPrimaryKey(this.Context, allNewLinkRows.ToArray(), linkEntry.DynamicObjectType); |
| | | } |
| | | /// <summary> |
| | |
| | | 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, |
| | |
| | | /// <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; |
| | | } |
| | |
| | | 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"]; //基本单位实发数量 |
| | | |