已添加23个文件
已修改14个文件
已删除1个文件
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | EDIBroker GlobalOTDTable_CARRC_Export |
| | | { |
| | | MDSDefinition: GlobalOTDTable |
| | | TimeZone: 'ACT' |
| | | UseOSTimeZone: false |
| | | EDIModelLink.Source Source11 |
| | | { |
| | | EDIMLTable CapacityAllocationResultsRuleConfiguration |
| | | { |
| | | PrimaryKeyColumns: ModuleMaterialCode |
| | | PrimaryKeyColumns: PanelMaterialCode |
| | | PrimaryKeyColumns: StockingPointID |
| | | TargetType: CapacityAllocationResultsRuleConfiguration |
| | | TypeIndex: CapacityAllocationResultsRuleConfigurationTypeIndex |
| | | EDIMLColumn Division { Attribute: Division ValueType: String } |
| | | EDIMLColumn ModuleMaterialCode { Attribute: ModuleMaterialCode ValueType: String } |
| | | EDIMLColumn PanelMaterialCode { Attribute: PanelMaterialCode ValueType: String } |
| | | EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String } |
| | | } |
| | | } |
| | | EDITransformation.Transformation Transformation11 |
| | | { |
| | | EDITableTransformation |
| | | { |
| | | InputTable: CapacityAllocationResultsRuleConfiguration |
| | | OutputTable: CapacityAllocationResultsRuleConfiguration |
| | | EDIColumnMatch { InputColumn: Division OutputColumn: Division } |
| | | EDIColumnMatch { InputColumn: ModuleMaterialCode OutputColumn: ModuleMaterialCode } |
| | | EDIColumnMatch { InputColumn: PanelMaterialCode OutputColumn: PanelMaterialCode } |
| | | EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID } |
| | | } |
| | | } |
| | | EDIXLSLink.Destination Destination12 |
| | | { |
| | | FileName: 'Destination12' |
| | | EDIXLSLinkTable CapacityAllocationResultsRuleConfiguration |
| | | { |
| | | Columns: |
| | | [ |
| | | EDIXLSLinkColumn Division { ValueType: String } |
| | | EDIXLSLinkColumn ModuleMaterialCode { ValueType: String } |
| | | EDIXLSLinkColumn PanelMaterialCode { ValueType: String } |
| | | EDIXLSLinkColumn StockingPointID { ValueType: String } |
| | | ] |
| | | } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | EDIBroker GlobalOTDTable_CARRC_Import |
| | | { |
| | | MDSDefinition: GlobalOTDTable |
| | | TimeZone: 'ACT' |
| | | UseOSTimeZone: false |
| | | EDIModelLink.Destination Destination13 |
| | | { |
| | | EDIMLTable CapacityAllocationResultsRuleConfiguration |
| | | { |
| | | PrimaryKeyColumns: ModuleMaterialCode |
| | | PrimaryKeyColumns: PanelMaterialCode |
| | | PrimaryKeyColumns: StockingPointID |
| | | TargetType: CapacityAllocationResultsRuleConfiguration |
| | | TypeIndex: CapacityAllocationResultsRuleConfigurationTypeIndex |
| | | EDIMLColumn Division { Attribute: Division ValueType: String } |
| | | EDIMLColumn ModuleMaterialCode { Attribute: ModuleMaterialCode ValueType: String } |
| | | EDIMLColumn PanelMaterialCode { Attribute: PanelMaterialCode ValueType: String } |
| | | EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String } |
| | | } |
| | | } |
| | | EDITransformation.Transformation Transformation12 |
| | | { |
| | | EDITableTransformation |
| | | { |
| | | InputTable: CapacityAllocationResultsRuleCo |
| | | OutputTable: CapacityAllocationResultsRuleConfiguration |
| | | EDIColumnMatch { InputColumn: Division OutputColumn: Division } |
| | | EDIColumnMatch { InputColumn: ModuleMaterialCode OutputColumn: ModuleMaterialCode } |
| | | EDIColumnMatch { InputColumn: PanelMaterialCode OutputColumn: PanelMaterialCode } |
| | | EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID } |
| | | } |
| | | } |
| | | EDIXLSLink.Source Source12 |
| | | { |
| | | FileName: '产è½åé
ç»æè§å.xlsx' |
| | | EDIXLSLinkTable CapacityAllocationResultsRuleCo |
| | | { |
| | | Columns: |
| | | [ |
| | | EDIXLSLinkColumn Division { ValueType: String } |
| | | EDIXLSLinkColumn ModuleMaterialCode { ValueType: String } |
| | | EDIXLSLinkColumn PanelMaterialCode { ValueType: String } |
| | | EDIXLSLinkColumn StockingPointID { ValueType: String } |
| | | ] |
| | | } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | EDIBroker GlobalOTDTable_CAR_Export |
| | | { |
| | | MDSDefinition: GlobalOTDTable |
| | | TimeZone: 'ACT' |
| | | UseOSTimeZone: false |
| | | EDIModelLink.Source Source13 |
| | | { |
| | | EDIMLTable CapacityAllocationResults |
| | | { |
| | | TargetType: CapacityAllocationResults |
| | | EDIMLColumn Date { Attribute: Date ValueType: Date } |
| | | EDIMLColumn Description { Attribute: Description ValueType: String } |
| | | EDIMLColumn Division { Attribute: Division ValueType: String } |
| | | EDIMLColumn ID { Attribute: ID ValueType: String } |
| | | EDIMLColumn ManufacturedDate { Attribute: ManufacturedDate ValueType: Date } |
| | | EDIMLColumn ModuleBase { Attribute: ModuleBase ValueType: String } |
| | | EDIMLColumn ModuleMaterialCode { Attribute: ModuleMaterialCode ValueType: String } |
| | | EDIMLColumn ModuleMeasurementUnit { Attribute: ModuleMeasurementUnit ValueType: String } |
| | | EDIMLColumn NumberOfModules { Attribute: NumberOfModules ValueType: Real } |
| | | EDIMLColumn NumberOfPanels { Attribute: NumberOfPanels ValueType: Real } |
| | | EDIMLColumn PanelBase { Attribute: PanelBase ValueType: String } |
| | | EDIMLColumn PanelMaterialCode { Attribute: PanelMaterialCode ValueType: String } |
| | | EDIMLColumn PanelMeasurementUnit { Attribute: PanelMeasurementUnit ValueType: String } |
| | | EDIMLColumn ProductID { Attribute: ProductID ValueType: String } |
| | | EDIMLColumn RequirementDate { Attribute: RequirementDate ValueType: Date } |
| | | EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String } |
| | | EDIMLColumn UserQuantity { Attribute: UserQuantity ValueType: Real } |
| | | EDIMLColumn VersionNumber { Attribute: VersionNumber ValueType: String } |
| | | } |
| | | } |
| | | EDITransformation.Transformation Transformation13 |
| | | { |
| | | EDITableTransformation |
| | | { |
| | | InputTable: CapacityAllocationResults |
| | | OutputTable: CapacityAllocationResults |
| | | EDIColumnMatch { InputColumn: Date OutputColumn: Date } |
| | | EDIColumnMatch { InputColumn: Description OutputColumn: Description } |
| | | EDIColumnMatch { InputColumn: ID OutputColumn: ID } |
| | | EDIColumnMatch { InputColumn: ManufacturedDate OutputColumn: ManufacturedDate } |
| | | EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID } |
| | | EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID } |
| | | EDIColumnMatch { InputColumn: UserQuantity OutputColumn: UserQuantity } |
| | | } |
| | | } |
| | | EDIXLSLink.Destination Destination14 |
| | | { |
| | | FileName: 'Destination14' |
| | | EDIXLSLinkTable CapacityAllocationResults |
| | | { |
| | | Columns: |
| | | [ |
| | | EDIXLSLinkColumn Date { ValueType: Date } |
| | | EDIXLSLinkColumn Description { ValueType: String } |
| | | EDIXLSLinkColumn ID { ValueType: String } |
| | | EDIXLSLinkColumn ProductID { ValueType: String } |
| | | EDIXLSLinkColumn StockingPointID { ValueType: String } |
| | | EDIXLSLinkColumn UserQuantity { ValueType: Real } |
| | | EDIXLSLinkColumn ManufacturedDate { ValueType: Date } |
| | | ] |
| | | } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Relation CapacityAllocationResultsRuleConfiguration_CapacityAllocationResults_CapacityAllocationResults_CapacityAllocationResultsRuleConfiguration |
| | | { |
| | | #keys: '1[414702.0.387791788]' |
| | | DefaultRelationStrategy |
| | | { |
| | | } |
| | | RelationSide.LeftSide CapacityAllocationResults |
| | | { |
| | | #keys: '3[414702.0.387791790][414702.0.387791789][414702.0.387791791]' |
| | | Cardinality: '1toN' |
| | | ObjectDefinition: CapacityAllocationResultsRuleConfiguration |
| | | OwningSide: 'Reference' |
| | | } |
| | | RelationSide.RightSide CapacityAllocationResultsRuleConfiguration |
| | | { |
| | | #keys: '3[414702.0.387791793][414702.0.387791792][414702.0.387791794]' |
| | | Cardinality: '0to1' |
| | | ObjectDefinition: CapacityAllocationResults |
| | | OwningSide: 'Reference' |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute Date |
| | | { |
| | | #keys: '3[414702.0.388471426][414702.0.388471425][414702.0.388471427]' |
| | | ValueType: Date |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute Description |
| | | { |
| | | #keys: '3[414702.0.388471436][414702.0.388471435][414702.0.388471437]' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute ID |
| | | { |
| | | #keys: '3[414702.0.388471446][414702.0.388471445][414702.0.388471447]' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute ManufacturedDate |
| | | { |
| | | #keys: '3[414702.0.388471486][414702.0.388471485][414702.0.388471487]' |
| | | ValueType: Date |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute ProductID |
| | | { |
| | | #keys: '3[414702.0.388471456][414702.0.388471455][414702.0.388471457]' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute StockingPointID |
| | | { |
| | | #keys: '3[414702.0.388471466][414702.0.388471465][414702.0.388471467]' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute UserQuantity |
| | | { |
| | | #keys: '3[414702.0.388471476][414702.0.388471475][414702.0.388471477]' |
| | | ValueType: Real |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | DeclarativeReferenceRelation CalcCapacityAllocationResultsRuleConfiguration |
| | | { |
| | | #keys: '1[414702.0.388304510]' |
| | | Expression: |
| | | [* |
| | | targetCapacityAllocationResultsRuleConfiguration := select( this.GlobalOTDTable(), CapacityAllocationResultsRuleConfiguration, tempCARRC, |
| | | tempCARRC.ModuleMaterialCode() = this.ModuleMaterialCode() and |
| | | tempCARRC.PanelMaterialCode() = this.PanelMaterialCode() ); |
| | | |
| | | return targetCapacityAllocationResultsRuleConfiguration; |
| | | *] |
| | | Relation: CapacityAllocationResultsRuleConfiguration |
| | | } |
| | |
| | | #parent: #root |
| | | StaticMethod CreateDate ( |
| | | GlobalOTDTable globalOTDTable, |
| | | MacroPlan macroPlan |
| | | MacroPlan macroPlan, |
| | | Scenario scenario |
| | | ) |
| | | { |
| | | TextBody: |
| | |
| | | } |
| | | |
| | | traverse ( finaleProductInStockingPoint_MPs, Elements, fpispmp ) { |
| | | capacityAllocationResultsRuleConfiguration := select( globalOTDTable, CapacityAllocationResultsRuleConfiguration, tempCARRC, tempCARRC.ModuleMaterialCode() = fpispmp.ProductID() and tempCARRC.StockingPointID() = fpispmp.StockingPointID() ); |
| | | capacityAllocationResultsRuleConfigurations := selectset( globalOTDTable, CapacityAllocationResultsRuleConfiguration, tempCARRC, tempCARRC.ModuleMaterialCode() = fpispmp.ProductID() and tempCARRC.StockingPointID() = fpispmp.StockingPointID() ); |
| | | info( "ç产ç产åï¼", fpispmp.ProductID(), "------产åå¨åºåç¹-------ï¼", fpispmp.StockingPointID() ); |
| | | traverse ( period_MPS, Elements, pmp ) { |
| | | // CapacityAllocationResults::IterativeGeneration( globalOTDTable, pisp, 1, null( NewSupply ), -1.0, pmp.StartDate() ); èç |
| | | CapacityAllocationResults::IterativeGeneration2( fpispmp, pmp.StartDate(), capacityAllocationResultsRuleConfiguration, 0, 0.0 ); |
| | | CapacityAllocationResults::IterativeGeneration2( globalOTDTable, fpispmp, pmp.StartDate(), capacityAllocationResultsRuleConfigurations, 0, null( NewSupply ), 0.0 ); |
| | | } |
| | | } |
| | | |
| | | traverse ( globalOTDTable, CapacityAllocationResults, car ) { |
| | | car.VersionNumber( scenario.Name() ); |
| | | } |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod Export ( |
| | | GlobalOTDTable globalOTDTable |
| | | ) as BinaryValue |
| | | { |
| | | TextBody: |
| | | [* |
| | | binaryData := globalOTDTable.GlobalOTDTable_CAR_Export().ExecuteToXLS( true ); |
| | | |
| | | return binaryData.AsBinaryValue(); |
| | | *] |
| | | } |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod IterativeGeneration2 ( |
| | | GlobalOTDTable globalOTDTable, |
| | | ProductInStockingPoint_MP pisp, |
| | | Date targetDate, |
| | | CapacityAllocationResultsRuleConfiguration carrcs, |
| | | CapacityAllocationResultsRuleConfigurations carrcs, |
| | | Number numberOfLayers, |
| | | Real firstLevelSupply |
| | | NewSupply firstLevelSupply, |
| | | Real currentLayerDependentDemandQuantity |
| | | ) |
| | | { |
| | | TextBody: |
| | | [* |
| | | numberOfLayers++; |
| | | info( "屿°ï¼", numberOfLayers, " ç®æ æ¶é´ï¼", targetDate.Format( "Y-M2-D2" ) ); |
| | | |
| | | info( "ç®æ æ¶é´ï¼", targetDate.Format( "Y-M2-D2" ) ); |
| | | info( pisp.Name() ); |
| | | traverse ( pisp, ProductInStockingPointInPeriodPlanning.astype( ProductInStockingPointInPeriodPlanningLeaf ), pispippl, pispippl.Start().Date() = targetDate ) { |
| | | traverse ( pispippl, NewSupply, ns, ns.Quantity() > 0 ) { |
| | | info( "å½åä¾åºçpispï¼", ns.ProductInStockingPointInPeriodPlanningLeaf().ProductInStockingPoint_MP().Name() ); |
| | | if ( numberOfLayers = 1 ) { |
| | | firstLevelSupply := ns.Quantity(); |
| | | firstLevelSupply := ns; |
| | | } |
| | | |
| | | if ( guard( ns.PeriodTask_MP().astype( PeriodTaskOperation ).DependentDemand( relsize ) > 0, false ) ) { |
| | | ontype( ns.PeriodTask_MP() ) { |
| | | PeriodTaskOperation as pto : { |
| | | info( "Operation卿任å¡..." ); |
| | | traverse ( ns, PeriodTask_MP.astype( PeriodTaskOperation ).DependentDemand, dd ) { |
| | | CapacityAllocationResults::IterativeGeneration2( dd.ProductInStockingPointInPeriodPlanningLeaf().ProductInStockingPoint_MP(), |
| | | currentLayerDependentDemandQuantity := currentLayerDependentDemandQuantity * |
| | | ns.ProcessOutput().astype( OperationOutput ).Quantity() * |
| | | dd.ProcessInput().astype( OperationInput ).Quantity(); |
| | | info( "屿°ï¼", numberOfLayers, " å½åä¾åºçpispï¼", ns.ProductInStockingPointInPeriodPlanningLeaf().ProductInStockingPoint_MP().Name(), " æ»ä¾åºå¼ï¼", ns.Quantity(), " éè¦ä¾åºå¼ï¼", currentLayerDependentDemandQuantity, |
| | | " å½åéæ±pispï¼", dd.ProductInStockingPointInPeriodPlanningLeaf().ProductInStockingPoint_MP().Name(), " éæ±å¼ï¼", currentLayerDependentDemandQuantity ); |
| | | info( "-----------------------------------------------------------------------------------------------------------------" ); |
| | | CapacityAllocationResults::IterativeGeneration2( globalOTDTable, |
| | | dd.ProductInStockingPointInPeriodPlanningLeaf().ProductInStockingPoint_MP(), |
| | | targetDate, |
| | | carrcs, |
| | | numberOfLayers, |
| | | firstLevelSupply |
| | | firstLevelSupply, |
| | | currentLayerDependentDemandQuantity |
| | | ); |
| | | } |
| | | carrc := select( carrcs, Elements, carrc, carrc.PanelMaterialCode() = ns.ProductInStockingPointInPeriodPlanningLeaf().ProductInStockingPoint_MP().ProductID() ); |
| | | if ( not isnull( carrc ) ) { |
| | | info( "æ¾å°é¢æ¿ç©æ..." ); |
| | | globalOTDTable.CapacityAllocationResults( relnew, |
| | | PanelBase := pto.Operation().UnitID(), |
| | | PanelMaterialCode := ns.ProductInStockingPointInPeriodPlanningLeaf().ProductInStockingPoint_MP().ProductID(), |
| | | NumberOfPanels := currentLayerDependentDemandQuantity, |
| | | PanelMeasurementUnit := ns.ProductInStockingPointInPeriodPlanningLeaf().ProductInStockingPoint_MP().UnitOfMeasureName(), |
| | | ModuleMaterialCode := firstLevelSupply.ProductInStockingPointInPeriodPlanningLeaf().ProductInStockingPoint_MP().ProductID(), |
| | | NumberOfModules := firstLevelSupply.Quantity(), |
| | | ModuleMeasurementUnit := firstLevelSupply.ProductInStockingPointInPeriodPlanningLeaf().ProductInStockingPoint_MP().UnitOfMeasureName(), |
| | | ModuleBase := guard( firstLevelSupply.PeriodTask_MP().astype( PeriodTaskOperation ).Operation().UnitID(), "车éè¿è¾" ), |
| | | Division := carrc.Division(), |
| | | RequirementDate := ns.Start().Date(), |
| | | Date := ns.Start().Date(), |
| | | Description := "", |
| | | ID := OS::GenerateGUIDAsString(), |
| | | ProductID := ns.ProductInStockingPointInPeriodPlanningLeaf().ProductInStockingPoint_MP().ProductID(), |
| | | StockingPointID := "", |
| | | UserQuantity := currentLayerDependentDemandQuantity, |
| | | ManufacturedDate := Date::MinDate() |
| | | ); |
| | | |
| | | } |
| | | info( "-----------------------------------------------------------------------------------------------------------------" ); |
| | | } |
| | | |
| | | PeriodTaskLaneLeg as ptll : { |
| | | targetDependentDemand := select( ptll, DependentDemand, dd, dd.ProductInStockingPointInPeriodPlanningLeaf().ProductInStockingPoint_MP().ProductID() = ns.ProductInStockingPointInPeriodPlanningLeaf().ProductInStockingPoint_MP().ProductID() ); |
| | | currentLayerDependentDemandQuantity := ifexpr( numberOfLayers = 1, targetDependentDemand.Quantity(), currentLayerDependentDemandQuantity ); |
| | | info( "屿°ï¼", numberOfLayers," å½åä¾åºçpispï¼", ns.ProductInStockingPointInPeriodPlanningLeaf().ProductInStockingPoint_MP().Name(), " æ»ä¾åºå¼ï¼", ns.Quantity(), " éè¦ä¾åºå¼ï¼", currentLayerDependentDemandQuantity, |
| | | " å½åéæ±pispï¼", targetDependentDemand.ProductInStockingPointInPeriodPlanningLeaf().ProductInStockingPoint_MP().Name(), " éæ±å¼ï¼", currentLayerDependentDemandQuantity ); |
| | | info( "LaneLeg卿任å¡..." ); |
| | | info( "-----------------------------------------------------------------------------------------------------------------" ); |
| | | CapacityAllocationResults::IterativeGeneration2( globalOTDTable, |
| | | targetDependentDemand.ProductInStockingPointInPeriodPlanningLeaf().ProductInStockingPoint_MP(), |
| | | targetDate, |
| | | carrcs, |
| | | numberOfLayers, |
| | | firstLevelSupply, |
| | | currentLayerDependentDemandQuantity |
| | | ); |
| | | } |
| | | } |
| | | |
| | | firstLevelSupply := 0.0; |
| | | if ( numberOfLayers = 1 ) { |
| | | firstLevelSupply := null( NewSupply ); |
| | | } |
| | | } |
| | | } |
| | | *] |
| | |
| | | { |
| | | #keys: '3[414702.0.374991437][414702.0.374991436][414702.0.374991438]' |
| | | Description: '模ç»ç©æç¼ç ' |
| | | IsReadOnly: true |
| | | ValueType: String |
| | | } |
| | |
| | | { |
| | | #keys: '3[414702.0.374991427][414702.0.374991426][414702.0.374991428]' |
| | | Description: '颿¿ç©æç¼ç ' |
| | | IsReadOnly: true |
| | | ValueType: String |
| | | } |
| | |
| | | Attribute StockingPointID |
| | | { |
| | | #keys: '3[414702.0.375010145][414702.0.375010144][414702.0.375010146]' |
| | | Description: 'åºåç¹ID' |
| | | Description: '模ç»äº§æååºåç¹ID' |
| | | IsReadOnly: true |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod Export ( |
| | | GlobalOTDTable globalOTDTable |
| | | ) as BinaryValue |
| | | { |
| | | TextBody: |
| | | [* |
| | | // hongjli Sep-25-2023 (created) |
| | | binaryValue := globalOTDTable.GlobalOTDTable_CARRC_Export().ExecuteToXLS( true ).AsBinaryValue(); |
| | | |
| | | return binaryValue; |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod Import ( |
| | | GlobalOTDTable globalOTDTable, |
| | | String base64String |
| | | ) |
| | | { |
| | | TextBody: |
| | | [* |
| | | binaryData := BinaryData::FromBase64EncodedString( base64String ); |
| | | |
| | | globalOTDTable.GlobalOTDTable_CARRC_Import().ExecuteFromXLS( &binaryData, true ); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | TypeIndex CapacityAllocationResultsRuleConfigurationTypeIndex |
| | | { |
| | | Attributes: |
| | | [ |
| | | TypeIndexAttribute |
| | | { |
| | | ModelElement: ModuleMaterialCode |
| | | } |
| | | TypeIndexAttribute |
| | | { |
| | | ModelElement: PanelMaterialCode |
| | | } |
| | | TypeIndexAttribute |
| | | { |
| | | ModelElement: StockingPointID |
| | | } |
| | | ] |
| | | } |
| | |
| | | #keys: '[414702.0.340554926]' |
| | | Body: |
| | | [* |
| | | CapacityAllocationResults::CreateDate( GlobalOTDTable, MacroPlan ); |
| | | CapacityAllocationResults::CreateDate( GlobalOTDTable, MacroPlan, SelectionScenario.Data() ); |
| | | *] |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_GUIButtonBase_OnClick' |
| | |
| | | Properties: |
| | | [ |
| | | DataBinding: 'DataHolderDialogData.Data.ModuleMaterialCode' |
| | | Label: '模æ¿ç©æç¼ç ' |
| | | Label: '模æ¿äº§æåID' |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | |
| | | Properties: |
| | | [ |
| | | DataBinding: 'DataHolderDialogData.Data.StockingPointID' |
| | | Label: 'åºåç¹ID' |
| | | Label: '模ç»äº§æååºåç¹ID' |
| | | Taborder: 3 |
| | | ] |
| | | } |
| | |
| | | StockingPointID := efStockingPointID.Text() |
| | | ); |
| | | } else { |
| | | data.PanelMaterialCode( efPanelMaterialCode.Text() ); |
| | | data.ModuleMaterialCode( efModuleMaterialCode.Text() ); |
| | | data.Division( efDivision.Text() ); |
| | | data.StockingPointID( efStockingPointID.Text() ); |
| | | DataHolderDialogData.Data().PanelMaterialCode( efPanelMaterialCode.Text() ); |
| | | DataHolderDialogData.Data().ModuleMaterialCode( efModuleMaterialCode.Text() ); |
| | | DataHolderDialogData.Data().Division( efDivision.Text() ); |
| | | DataHolderDialogData.Data().StockingPointID( efStockingPointID.Text() ); |
| | | DataHolderDialogData.Data().Commit(); |
| | | } |
| | | |
| | | |
| | |
| | | Quintiq file version 2.0 |
| | | Component ListCapacityAllocationResults |
| | | { |
| | | #keys: '[414702.0.338762075]' |
| | | #keys: '[414702.0.390053833]' |
| | | BaseType: 'WebList' |
| | | Children: |
| | | [ |
| | | Component DataExtractorCapacityAllocationResults |
| | | { |
| | | #keys: '[414702.0.338762076]' |
| | | #keys: '[414702.0.390053834]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'GlobalOTDTable' |
| | | Source: 'GlobalOTDTable' |
| | | DataType: 'structured[CapacityAllocationResultsRuleConfiguration]' |
| | | Source: 'FormCapacityAllocationResultsRuleConfiguration.DataHolderSelectCapacityAllocationResultsRuleConfiguration' |
| | | Taborder: 0 |
| | | Transformation: 'CapacityAllocationResults' |
| | | Transformation: 'Elements.CapacityAllocationResults' |
| | | ] |
| | | } |
| | | #child: listActionBarPageCapacityAllocationResults |
| | | Component DataSetLevelCapacityAllocationResults |
| | | { |
| | | #keys: '[414702.0.338762081]' |
| | | #keys: '[414702.0.390053839]' |
| | | BaseType: 'WebDataSetLevel' |
| | | Children: |
| | | [ |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"VersionNumber","title":"VersionNumber","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"VersionNumber"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"PanelMeasurementUnit","title":"PanelMeasurementUnit","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"PanelMeasurementUnit"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"PanelMaterialCode","title":"PanelMaterialCode","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"PanelMaterialCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"NumberOfPanels","title":"NumberOfPanels","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"NumberOfPanels"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"PanelMeasurementUnit","title":"PanelMeasurementUnit","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"PanelMeasurementUnit"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ModuleMaterialCode","title":"ModuleMaterialCode","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ModuleMaterialCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"NumberOfModules","title":"NumberOfModules","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"NumberOfModules"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ModuleMeasurementUnit","title":"ModuleMeasurementUnit","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ModuleMeasurementUnit"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ModuleMeasurementUnit","title":"ModuleMeasurementUnit","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ModuleMeasurementUnit"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Division","title":"Division","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Division"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"RequirementDate","title":"RequirementDate","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"RequirementDate"}}]' |
| | | Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Date","title":"Date","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Date"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Description","title":"Description","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Description"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ID","title":"ID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProductID","title":"ProductID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProductID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"StockingPointID","title":"StockingPointID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"StockingPointID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"UserQuantity","title":"UserQuantity","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"UserQuantity"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ManufacturedDate","title":"ManufacturedDate","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ManufacturedDate"}}]' |
| | | ContextMenu: 'listContextMenuCapacityAllocationResults' |
| | | Taborder: 2 |
| | | ] |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelCapacityAllocationResults |
| | | { |
| | | #keys: '[414702.0.391687385]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | Component ButtonGenerateCapacityAllocationResults id:ButtonGenerateCapacityAllocationResults_570 |
| | | { |
| | | #keys: '[414702.0.391717497]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Image: 'PROCESS' |
| | | Label: 'çææ°æ®' |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | Component Export id:Export_398 |
| | | { |
| | | #keys: '[414702.0.392048461]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Image: 'EXPORT1' |
| | | Label: '导åº' |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | FixedSize: true |
| | | Orientation: 'horizontal' |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | |
| | | Quintiq file version 2.0 |
| | | Component listActionBarPageCapacityAllocationResults |
| | | { |
| | | #keys: '[414702.0.338762078]' |
| | | #keys: '[414702.0.390053836]' |
| | | BaseType: 'listActionBarPage' |
| | | Properties: |
| | | [ |
| | |
| | | Quintiq file version 2.0 |
| | | Component listContextMenuCapacityAllocationResults |
| | | { |
| | | #keys: '[414702.0.338762083]' |
| | | #keys: '[414702.0.390053841]' |
| | | BaseType: 'listContextMenu' |
| | | Properties: |
| | | [ |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: PanelCapacityAllocationResults/ButtonGenerateCapacityAllocationResults_570 |
| | | Response OnClick () id:Response_FormCapacityAllocationResults_ButtonGenerateCapacityAllocationResults_OnClick_39 |
| | | { |
| | | #keys: '[414702.0.391717496]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | CapacityAllocationResults::CreateDate( GlobalOTDTable, MacroPlan, DataHolderActiveScenario.Data() ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: PanelCapacityAllocationResults/Export_398 |
| | | Response OnClick () id:Response_PanelCapacityAllocationResults_Export_OnClick |
| | | { |
| | | #keys: '[414702.0.391791234]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | Application.Download( "产è½åé
ç»æ.xlsx", CapacityAllocationResults::Export( GlobalOTDTable ).AsBinaryData() ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
| | |
| | | Children: |
| | | [ |
| | | #child: ListCapacityAllocationResults |
| | | Component ButtonGenerateCapacityAllocationResults |
| | | { |
| | | #keys: '[414702.0.340677556]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Image: 'PROCESS' |
| | | Label: 'çææ°æ®' |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | #child: PanelCapacityAllocationResults |
| | | ] |
| | | Properties: |
| | | [ |
| | |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 0 |
| | | Taborder: 1 |
| | | ] |
| | | ResponseDefinitions: |
| | | [ |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelImportAndExport |
| | | { |
| | | #keys: '[414702.0.391512140]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | Component Import |
| | | { |
| | | #keys: '[414702.0.390081531]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Image: 'IMPORT1' |
| | | Label: '导å
¥' |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | Component Export |
| | | { |
| | | #keys: '[414702.0.391512453]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Image: 'EXPORT1' |
| | | Label: '导åº' |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | FixedSize: true |
| | | Orientation: 'horizontal' |
| | | Taborder: 0 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: DataHolderSelectCapacityAllocationResultsRuleConfiguration |
| | | Response OnDataChanged () id:Response_FormCapacityAllocationResultsRuleConfiguration_DataHolderSelectCapacityAllocationResultsRuleConfiguration_OnDataChanged |
| | | { |
| | | #keys: '[414702.0.391379706]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebComponent_OnDataChanged' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | traverse ( this.Data(), Elements, e ) { |
| | | info( "颿¿ç©æIDï¼", e.PanelMaterialCode() ); |
| | | } |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: PanelImportAndExport/Export |
| | | Response OnClick () id:Response_PanelImportAndExport_Export_OnClick |
| | | { |
| | | #keys: '[414702.0.391658465]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | Application.Download( "产è½åé
ç»æè§å.xlsx", CapacityAllocationResultsRuleConfiguration::Export( GlobalOTDTable ).AsBinaryData() ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: PanelImportAndExport/Import |
| | | Response OnClick () id:Response_PanelImportAndExport_Import_OnClick |
| | | { |
| | | #keys: '[414702.0.391899822]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | try { |
| | | uploadJsonString := Application.GetFile(); |
| | | if ( uploadJsonString <> "" ) { |
| | | uploadJson := JSON::Parse( uploadJsonString ); |
| | | |
| | | fileName := uploadJson.Get( "name" ).GetString(); |
| | | base64String := uploadJson.Get( "data" ).GetString(); |
| | | CapacityAllocationResultsRuleConfiguration::Import( GlobalOTDTable, base64String ); |
| | | |
| | | WebMessageBox::Success( "ä¸ä¼ æå", true ); |
| | | } |
| | | } onerror { |
| | | WebMessageBox::Error( e.GeneralInformation(), true ); |
| | | } |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
| | |
| | | Children: |
| | | [ |
| | | #child: ListCapacityAllocationResultsRuleConfiguration |
| | | Component DataHolderSelectCapacityAllocationResultsRuleConfiguration |
| | | { |
| | | #keys: '[414702.0.390054479]' |
| | | BaseType: 'WebDataHolder' |
| | | Databinding: 'structured[CapacityAllocationResultsRuleConfiguration]*' |
| | | Children: |
| | | [ |
| | | Component DataExtractorSelectCapacityAllocationResultsRuleConfiguration |
| | | { |
| | | #keys: '[414702.0.391186862]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'CapacityAllocationResultsRuleConfiguration' |
| | | ExtractionMode: 'Selected' |
| | | Source: 'ListCapacityAllocationResultsRuleConfiguration' |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | #child: PanelImportAndExport |
| | | ] |
| | | Properties: |
| | | [ |