Merge branch 'dev' of http://47.101.211.7:10101/r/VWED into dev-zlg
已添加150个文件
已修改10个文件
已删除2个文件
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Method OnCreate |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-18-2024 (created) |
| | | *] |
| | | InterfaceProperties { Accessibility: 'Module' } |
| | | } |
| | |
| | | { |
| | | #keys: '2[110880.4.1188154382][110880.4.1188154375]' |
| | | Description: 'MP' |
| | | OnCreate: 'this.OnCreate();' |
| | | Parent: UnitPeriodTimeBase |
| | | StructuredName: 'UnitPeriodTimes' |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #root |
| | | #parent: #DomainModel |
| | | Dataset RecycleBin |
| | | { |
| | | #keys: '2[412672.0.1084213478][412672.0.1084213477]' |
| | | DefaultMDSName: 'RecycleBin' |
| | | InstanceType: RecycleBin |
| | | WithStorage: false |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Relation ExportXMLData_ExportXMLManager_ExportXMLManager_ExportXMLData |
| | | { |
| | | #keys: '1[412672.0.1084249088]' |
| | | DefaultRelationStrategy |
| | | { |
| | | } |
| | | RelationSide.LeftSide ExportXMLManager |
| | | { |
| | | #keys: '3[412672.0.1084249090][412672.0.1084249089][412672.0.1084249091]' |
| | | Cardinality: '0to1' |
| | | ObjectDefinition: ExportXMLData |
| | | OwningSide: 'Reference' |
| | | } |
| | | RelationSide.RightSide ExportXMLData |
| | | { |
| | | #keys: '3[412672.0.1084249093][412672.0.1084249092][412672.0.1084249094]' |
| | | Cardinality: '1toN' |
| | | ObjectDefinition: ExportXMLManager |
| | | OwningSide: 'Owned' |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Relation ExportXMLManager_RecycleBin_RecycleBin_ExportXMLManager |
| | | { |
| | | #keys: '1[412672.0.1084249075]' |
| | | DefaultRelationStrategy |
| | | { |
| | | } |
| | | RelationSide.LeftSide RecycleBin |
| | | { |
| | | #keys: '3[412672.0.1084249077][412672.0.1084249076][412672.0.1084249078]' |
| | | Cardinality: '0to1' |
| | | ObjectDefinition: ExportXMLManager |
| | | OwningSide: 'Reference' |
| | | } |
| | | RelationSide.RightSide ExportXMLManager |
| | | { |
| | | #keys: '3[412672.0.1084249080][412672.0.1084249079][412672.0.1084249081]' |
| | | Cardinality: '1toN' |
| | | ObjectDefinition: RecycleBin |
| | | OwningSide: 'Owned' |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Relation GeneralExcelImportAndExportDataSource_RecycleBin_RecycleBin_GeneralExcelImportAndExportDataSource |
| | | { |
| | | #keys: '1[412672.0.1087854694]' |
| | | DefaultRelationStrategy |
| | | { |
| | | } |
| | | RelationSide.LeftSide RecycleBin |
| | | { |
| | | #keys: '3[412672.0.1087854696][412672.0.1087854695][412672.0.1087854697]' |
| | | Cardinality: '0to1' |
| | | ObjectDefinition: GeneralExcelImportAndExportDataSource |
| | | OwningSide: 'Reference' |
| | | } |
| | | RelationSide.RightSide GeneralExcelImportAndExportDataSource |
| | | { |
| | | #keys: '3[412672.0.1087854699][412672.0.1087854698][412672.0.1087854700]' |
| | | Cardinality: '1toN' |
| | | ObjectDefinition: RecycleBin |
| | | OwningSide: 'Owned' |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Relation LocalColumn_LocalCell_LocalCell_LocalColumn |
| | | { |
| | | #keys: '1[412672.0.1084249675]' |
| | | DefaultRelationStrategy |
| | | { |
| | | } |
| | | RelationSide.LeftSide LocalCell |
| | | { |
| | | #keys: '3[412672.0.1084249677][412672.0.1084249676][412672.0.1084249678]' |
| | | Cardinality: '1toN' |
| | | ObjectDefinition: LocalColumn |
| | | OwningSide: 'Reference' |
| | | } |
| | | RelationSide.RightSide LocalColumn |
| | | { |
| | | #keys: '3[412672.0.1084249680][412672.0.1084249679][412672.0.1084249681]' |
| | | Cardinality: '0to1' |
| | | ObjectDefinition: LocalCell |
| | | OwningSide: 'Reference' |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Relation LocalColumn_LocalTable_LocalTable_LocalColumn |
| | | { |
| | | #keys: '1[412672.0.1084249662]' |
| | | DefaultRelationStrategy |
| | | { |
| | | } |
| | | RelationSide.LeftSide LocalTable |
| | | { |
| | | #keys: '3[412672.0.1084249664][412672.0.1084249663][412672.0.1084249665]' |
| | | Cardinality: '0to1' |
| | | ObjectDefinition: LocalColumn |
| | | OwningSide: 'Reference' |
| | | } |
| | | RelationSide.RightSide LocalColumn |
| | | { |
| | | #keys: '3[412672.0.1084249667][412672.0.1084249666][412672.0.1084249668]' |
| | | Cardinality: '1toN' |
| | | ObjectDefinition: LocalTable |
| | | OwningSide: 'Owned' |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Relation LocalRow_LocalCell_LocalCell_LocalRow |
| | | { |
| | | #keys: '1[412672.0.1084249636]' |
| | | DefaultRelationStrategy |
| | | { |
| | | } |
| | | RelationSide.LeftSide LocalCell |
| | | { |
| | | #keys: '3[412672.0.1084249638][412672.0.1084249637][412672.0.1084249639]' |
| | | Cardinality: '1toN' |
| | | ObjectDefinition: LocalRow |
| | | OwningSide: 'Owned' |
| | | } |
| | | RelationSide.RightSide LocalRow |
| | | { |
| | | #keys: '3[412672.0.1084249641][412672.0.1084249640][412672.0.1084249642]' |
| | | Cardinality: '0to1' |
| | | ObjectDefinition: LocalCell |
| | | OwningSide: 'Reference' |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Relation LocalRow_LocalTable_LocalTable_LocalRow |
| | | { |
| | | #keys: '1[412672.0.1084249649]' |
| | | DefaultRelationStrategy |
| | | { |
| | | } |
| | | RelationSide.LeftSide LocalTable |
| | | { |
| | | #keys: '3[412672.0.1084249651][412672.0.1084249650][412672.0.1084249652]' |
| | | Cardinality: '0to1' |
| | | ObjectDefinition: LocalRow |
| | | OwningSide: 'Reference' |
| | | } |
| | | RelationSide.RightSide LocalRow |
| | | { |
| | | #keys: '3[412672.0.1084249654][412672.0.1084249653][412672.0.1084249655]' |
| | | Cardinality: '1toN' |
| | | ObjectDefinition: LocalTable |
| | | OwningSide: 'Owned' |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Relation LocalTable_RecycleBin_RecycleBin_LocalTable |
| | | { |
| | | #keys: '1[412672.0.1084249623]' |
| | | DefaultRelationStrategy |
| | | { |
| | | } |
| | | RelationSide.LeftSide RecycleBin |
| | | { |
| | | #keys: '3[412672.0.1084249625][412672.0.1084249624][412672.0.1084249626]' |
| | | Cardinality: '0to1' |
| | | ObjectDefinition: LocalTable |
| | | OwningSide: 'Reference' |
| | | } |
| | | RelationSide.RightSide LocalTable |
| | | { |
| | | #keys: '3[412672.0.1084249628][412672.0.1084249627][412672.0.1084249629]' |
| | | Cardinality: '1toN' |
| | | ObjectDefinition: RecycleBin |
| | | OwningSide: 'Owned' |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Relation ShiftPlan_UnitPeriodTime_UnitPeriodTime_ShiftPlan |
| | | { |
| | | #keys: '1[412672.0.1066680007]' |
| | | DefaultRelationStrategy |
| | | { |
| | | } |
| | | RelationSide.LeftSide UnitPeriodTime |
| | | { |
| | | #keys: '3[412672.0.1066680009][412672.0.1066680008][412672.0.1066680010]' |
| | | Cardinality: '0to1' |
| | | ObjectDefinition: ShiftPlan |
| | | OwningSide: 'Reference' |
| | | } |
| | | RelationSide.RightSide ShiftPlan |
| | | { |
| | | #keys: '3[412672.0.1066680012][412672.0.1066680011][412672.0.1066680013]' |
| | | Cardinality: '0to1' |
| | | ObjectDefinition: UnitPeriodTime |
| | | OwningSide: 'Owned' |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Relation TransferPlanCell_TransferPlanColumn_TransferPlanColumn_TransferPlanCell |
| | | { |
| | | #keys: '1[413988.0.1292031952]' |
| | | DefaultRelationStrategy |
| | | { |
| | | } |
| | | RelationSide.LeftSide TransferPlanColumn |
| | | { |
| | | #keys: '3[413988.0.1292031954][413988.0.1292031953][413988.0.1292031955]' |
| | | Cardinality: '0to1' |
| | | ObjectDefinition: TransferPlanCell |
| | | OwningSide: 'Reference' |
| | | } |
| | | RelationSide.RightSide TransferPlanCell |
| | | { |
| | | #keys: '3[413988.0.1292031957][413988.0.1292031956][413988.0.1292031958]' |
| | | Cardinality: '1toN' |
| | | ObjectDefinition: TransferPlanColumn |
| | | OwningSide: 'Owned' |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Relation TransferPlanCell_TransferPlanRow_TransferPlanRow_TransferPlanCell |
| | | { |
| | | #keys: '1[413988.0.1292031965]' |
| | | DefaultRelationStrategy |
| | | { |
| | | } |
| | | RelationSide.LeftSide TransferPlanRow |
| | | { |
| | | #keys: '3[413988.0.1292031967][413988.0.1292031966][413988.0.1292031968]' |
| | | Cardinality: '0to1' |
| | | ObjectDefinition: TransferPlanCell |
| | | OwningSide: 'Reference' |
| | | } |
| | | RelationSide.RightSide TransferPlanCell |
| | | { |
| | | #keys: '3[413988.0.1292031970][413988.0.1292031969][413988.0.1292031971]' |
| | | Cardinality: '1toN' |
| | | ObjectDefinition: TransferPlanRow |
| | | OwningSide: 'Reference' |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Relation TransferPlanColumn_MacroPlan_MacroPlan_TransferPlanColumn |
| | | { |
| | | #keys: '1[413988.0.1292031939]' |
| | | DefaultRelationStrategy |
| | | { |
| | | } |
| | | RelationSide.LeftSide MacroPlan |
| | | { |
| | | #keys: '3[413988.0.1292031941][413988.0.1292031940][413988.0.1292031942]' |
| | | Cardinality: '0to1' |
| | | ObjectDefinition: TransferPlanColumn |
| | | OwningSide: 'Reference' |
| | | } |
| | | RelationSide.RightSide TransferPlanColumn |
| | | { |
| | | #keys: '3[413988.0.1292031944][413988.0.1292031943][413988.0.1292031945]' |
| | | Cardinality: '1toN' |
| | | ObjectDefinition: MacroPlan |
| | | OwningSide: 'Owned' |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Relation TransferPlanRow_MacroPlan_MacroPlan_TransferPlanRow |
| | | { |
| | | #keys: '1[413988.0.1292031926]' |
| | | DefaultRelationStrategy |
| | | { |
| | | } |
| | | RelationSide.LeftSide MacroPlan |
| | | { |
| | | #keys: '3[413988.0.1292031928][413988.0.1292031927][413988.0.1292031929]' |
| | | Cardinality: '0to1' |
| | | ObjectDefinition: TransferPlanRow |
| | | OwningSide: 'Reference' |
| | | } |
| | | RelationSide.RightSide TransferPlanRow |
| | | { |
| | | #keys: '3[413988.0.1292031931][413988.0.1292031930][413988.0.1292031932]' |
| | | Cardinality: '1toN' |
| | | ObjectDefinition: MacroPlan |
| | | OwningSide: 'Owned' |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod Compared ( |
| | | RecycleBin recycleBin, |
| | | const ArchivePR baseVersion, |
| | | const ArchivePR compareVersion |
| | | ) as LocalTable |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-20-2024 (created) |
| | | localTable := recycleBin.LocalTable( relnew,Name := baseVersion.Name() + "__" + compareVersion.Name()); |
| | | |
| | | baseVersionFile := OSFile::Construct(); |
| | | compareVersionFile := OSFile::Construct(); |
| | | |
| | | try { |
| | | baseVersionFile.Open( baseVersion.FilePath(), "Read", false ); |
| | | baseVersionDataSource := GeneralExcelImportAndExportDataSource::Upload( recycleBin, baseVersionFile.ReadBinary(), baseVersion.FilePath() ); |
| | | baseVersionDataSource.ReadStructure(); |
| | | |
| | | compareVersionFile.Open( compareVersion.FilePath(), "Read", false ); |
| | | compareVersionDataSource := GeneralExcelImportAndExportDataSource::Upload( recycleBin, compareVersionFile.ReadBinary(), compareVersion.FilePath() ); |
| | | compareVersionDataSource.ReadStructure(); |
| | | |
| | | baseVersionTable := select( baseVersionDataSource, GeneralExcelImportAndExportDataTable, tempGEIAEDT, true ); |
| | | compareVersionTable := select( compareVersionDataSource, GeneralExcelImportAndExportDataTable, tempGEIAEDT, true ); |
| | | |
| | | if( not isnull( baseVersionTable ) and not isnull( compareVersionTable )){ |
| | | |
| | | //çæè¡æ°æ® |
| | | rowKeys := construct( Strings ); |
| | | baseVersionRowTree := NamedValueTree::Create(); |
| | | baseVersionRows := construct( GeneralExcelImportAndExportDataRows ,constcontent); |
| | | compareVersionRowTree := NamedValueTree::Create(); |
| | | compareVersionRows := construct( GeneralExcelImportAndExportDataRows ,constcontent); |
| | | ArchivePR::FillRows( baseVersionTable,rowKeys,baseVersionRowTree,baseVersionRows ); |
| | | ArchivePR::FillRows( compareVersionTable,rowKeys,compareVersionRowTree,compareVersionRows ); |
| | | |
| | | // çæåæ°æ® |
| | | columnTree := NamedValueTree::Create(); |
| | | columns := construct( LocalColumns ); |
| | | ArchivePR::GenerateColumnIndex( baseVersionTable,localTable,columnTree,columns ); |
| | | ArchivePR::GenerateColumnIndex( compareVersionTable,localTable,columnTree,columns ); |
| | | columnNames := selectvalues( columns,Elements,column,true,column.Name() ); |
| | | |
| | | // çææ°æ® |
| | | |
| | | for ( rowIndex := 0; rowIndex < rowKeys.Size(); rowIndex++ ) { |
| | | rowKey := rowKeys.Element( rowIndex ); |
| | | |
| | | baseVersionCellTree := NamedValueTree::Create(); |
| | | baseVersionCells := construct( GeneralExcelImportAndExportDataCells ,constcontent); |
| | | |
| | | compareVersionCellTree := NamedValueTree::Create(); |
| | | compareVersionCells := construct( GeneralExcelImportAndExportDataCells ,constcontent); |
| | | |
| | | ArchivePR::FillCells( rowKey,baseVersionRowTree,baseVersionRows,baseVersionCellTree,baseVersionCells ); |
| | | ArchivePR::FillCells( rowKey,compareVersionRowTree,compareVersionRows,compareVersionCellTree,compareVersionCells ); |
| | | |
| | | row := localTable.LocalRow( relnew,Index := localTable.GetRowIndexCache() ); |
| | | |
| | | traverse( columnNames,Elements,columnName ){ |
| | | columnHandle := columnTree.GetHandle( columnName ); |
| | | columnIndex := columnTree.Root().Child( columnHandle ).GetValueAsNumber(); |
| | | column := columns.Element( columnIndex ); |
| | | |
| | | baseVersionCell := constnull( GeneralExcelImportAndExportDataCell ); |
| | | baseVersionCellHandle := baseVersionCellTree.GetHandle( columnName ); |
| | | try{ |
| | | baseVersionCellIndex := baseVersionCellTree.Root().Child( baseVersionCellHandle ).GetValueAsNumber(); |
| | | baseVersionCell := baseVersionCells.Element( baseVersionCellIndex ); |
| | | }onerror{} |
| | | |
| | | compareVersionCell := constnull( GeneralExcelImportAndExportDataCell ); |
| | | compareVersionCellHandle := compareVersionCellTree.GetHandle( columnName ); |
| | | try{ |
| | | compareVersionCellIndex := compareVersionCellTree.Root().Child( compareVersionCellHandle ).GetValueAsNumber(); |
| | | compareVersionCell := compareVersionCells.Element( compareVersionCellIndex ); |
| | | }onerror{} |
| | | |
| | | if( columnName = "产å°" or columnName = "车å" or columnName = "å卿ºé¶ä»¶å·" or columnName = "å卿ºåä½ç " ){ |
| | | row.LocalCell( relnew,LocalCell_DemandComparison,LocalColumn := column, |
| | | BaseVersionValue := ifexpr( isnull( baseVersionCell ), "空", baseVersionCell.Value()), |
| | | CompareVersionValue := ifexpr( isnull( compareVersionCell ),"空",compareVersionCell.Value())); |
| | | column.IsAttrbuteColumn( true ); |
| | | if( columnName = "å卿ºé¶ä»¶å·" ){ |
| | | row.CustomName( ifexpr( isnull( baseVersionCell ), ifexpr( isnull( compareVersionCell ),"空",compareVersionCell.Value()), baseVersionCell.Value()) ); |
| | | } |
| | | }else{ |
| | | row.LocalCell( relnew,LocalCell_DemandComparison,LocalColumn := column, |
| | | BaseVersion := ifexpr( isnull( baseVersionCell ),0,[Real]baseVersionCell.Value()), |
| | | CompareVersion := ifexpr( isnull( compareVersionCell ), 0 ,[Real]compareVersionCell.Value() )); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | // åç»å é¤ |
| | | baseVersionDataSource.Delete(); |
| | | compareVersionDataSource.Delete(); |
| | | |
| | | baseVersionFile.Close(); |
| | | compareVersionFile.Close(); |
| | | } onerror { |
| | | if( not isnull( baseVersionFile )){ |
| | | baseVersionFile.Close(); |
| | | } |
| | | if( not isnull( compareVersionFile )){ |
| | | compareVersionFile.Close(); |
| | | } |
| | | error( e ); |
| | | } |
| | | |
| | | return localTable; |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod FillCells ( |
| | | String rowName, |
| | | NamedValueTree rowTree, |
| | | constcontent GeneralExcelImportAndExportDataRows rows, |
| | | NamedValueTree cellTree, |
| | | constcontent GeneralExcelImportAndExportDataCells cells |
| | | ) |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-22-2024 (created) |
| | | rowHandel := rowTree.GetHandle( rowName ); |
| | | try{ |
| | | rowIndex := rowTree.Root().Child( rowHandel ).GetValueAsNumber(); |
| | | row := rows.Element( rowIndex ); |
| | | |
| | | temp_cells := selectsortedset( row,GeneralExcelImportAndExportDataCell,cell,true,cell.GeneralExcelImportAndExportDataColumn().ColumnIndex() ); |
| | | for( i := 0 ; i<temp_cells.Size();i++ ){ |
| | | cell := temp_cells.Element( i ); |
| | | tempHandle := cellTree.GetHandle( cell.GeneralExcelImportAndExportDataColumn().Name() ); |
| | | |
| | | cells.Add( cell ); |
| | | cellTree.Root().AddChild( tempHandle,cells.Size() - 1 ); |
| | | |
| | | } |
| | | }onerror{} |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod FillRows ( |
| | | const GeneralExcelImportAndExportDataTable general, |
| | | Strings rowKeys, |
| | | NamedValueTree rowTree, |
| | | constcontent GeneralExcelImportAndExportDataRows rows |
| | | ) |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-22-2024 (created) |
| | | rowKeyColumn1 := select( general, GeneralExcelImportAndExportDataColumn, column, column.Name() = "产å°" ); |
| | | rowKeyColumn2 := select( general, GeneralExcelImportAndExportDataColumn, column, column.Name() = "车å" ); |
| | | rowKeyColumn3 := select( general, GeneralExcelImportAndExportDataColumn, column, column.Name() = "å卿ºé¶ä»¶å·" ); |
| | | rowKeyColumn4 := select( general, GeneralExcelImportAndExportDataColumn, column, column.Name() = "å卿ºåä½ç " ); |
| | | tempRowKeyCells1 := selectset( rowKeyColumn1,GeneralExcelImportAndExportDataCell,cell,true ); |
| | | tempRowKeyCells2 := selectset( rowKeyColumn2,GeneralExcelImportAndExportDataCell,cell,true ); |
| | | tempRowKeyCells3 := selectset( rowKeyColumn3,GeneralExcelImportAndExportDataCell,cell,true ); |
| | | tempRowKeyCells4 := selectset( rowKeyColumn4,GeneralExcelImportAndExportDataCell,cell,true ); |
| | | |
| | | for( i := 0; i< tempRowKeyCells1.Size(); i++ ){ |
| | | tempRowKeyCell1 := tempRowKeyCells1.Element( i ); |
| | | tempRowKeyCell2 := tempRowKeyCells2.Element( i ); |
| | | tempRowKeyCell3 := tempRowKeyCells3.Element( i ); |
| | | tempRowKeyCell4 := tempRowKeyCells4.Element( i ); |
| | | |
| | | rowKey := tempRowKeyCell1.Value() + tempRowKeyCell2.Value() + tempRowKeyCell3.Value() + tempRowKeyCell4.Value(); |
| | | |
| | | tempHandle := rowTree.GetHandle( rowKey ); |
| | | rowTree.Root().AddChild( tempHandle ,i); |
| | | rows.Add( tempRowKeyCell1.GeneralExcelImportAndExportDataRow()); |
| | | rowKeys.Add( rowKey ); |
| | | } |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod GenerateColumnIndex ( |
| | | const GeneralExcelImportAndExportDataTable table, |
| | | LocalTable localTable, |
| | | NamedValueTree columnTree, |
| | | LocalColumns columns |
| | | ) |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-22-2024 (created) |
| | | tableColumns := selectset( table,GeneralExcelImportAndExportDataColumn,column,true ); |
| | | for( i := 0; i< tableColumns.Size(); i++ ){ |
| | | generalColumn := tableColumns.Element( i ); |
| | | tempHandle := columnTree.GetHandle( generalColumn.Name() ); |
| | | |
| | | nameValue := guard( columnTree.Root().Child( tempHandle ),null( NamedValue )); |
| | | if( isnull( nameValue )){ |
| | | index := 999; |
| | | if( generalColumn.Name() = "产å°" ){ |
| | | index := 1; |
| | | }else if( generalColumn.Name() = "车å" ){ |
| | | index := 2; |
| | | }else if( generalColumn.Name() = "å卿ºé¶ä»¶å·" ){ |
| | | index := 3; |
| | | }else if( generalColumn.Name() = "å卿ºåä½ç " ){ |
| | | index := 4; |
| | | }else{ |
| | | // 2023/01/01 |
| | | index := [Number]generalColumn.Name().ReplaceAll( "/", "" ); |
| | | } |
| | | column := localTable.LocalColumn( relnew, Name := generalColumn.Name(),Index := index ); |
| | | columns.Add( column ); |
| | | columnTree.Root().AddChild( tempHandle,columns.Size() - 1 ); |
| | | } |
| | | } |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute Priority |
| | | { |
| | | #keys: '3[412672.0.1084249112][412672.0.1084249111][412672.0.1084249113]' |
| | | ValueType: Number |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute XML |
| | | { |
| | | #keys: '3[412672.0.1084249102][412672.0.1084249101][412672.0.1084249103]' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #root |
| | | #parent: #DomainModel |
| | | Type ExportXMLData |
| | | { |
| | | #keys: '5[412672.0.1084249058][412672.0.1084249056][0.0.0][412672.0.1084249057][412672.0.1084249059]' |
| | | BaseType: Object |
| | | StructuredName: 'ExportXMLDatas' |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute FinalXML |
| | | { |
| | | #keys: '3[412672.0.1084249132][412672.0.1084249131][412672.0.1084249133]' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute Name |
| | | { |
| | | #keys: '3[412672.0.1084249122][412672.0.1084249121][412672.0.1084249123]' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Function CalcFinalXML |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-20-2024 (created) |
| | | xmlTemplate := '<?xml version="1.0" encoding="UTF-16"?><table><name>'+ this.Name() +'</name>'; |
| | | |
| | | datas := selectsortedset( this,ExportXMLData,data,true,data.Priority() ); |
| | | |
| | | traverse( datas,Elements,data ){ |
| | | xmlTemplate := xmlTemplate + data.XML(); |
| | | } |
| | | |
| | | xmlTemplate := xmlTemplate + "</table>"; |
| | | |
| | | this.FinalXML( xmlTemplate ); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Method Export () as BinaryValue |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-21-2024 (created) |
| | | tableGroupHandle := TableGroupHandle::Create( "tableGroupHandle" ); |
| | | tableHandle := TableHandle::ImportXML( BinaryValue::Construct( this.FinalXML() ) ); |
| | | tableGroupHandle.Add( tableHandle ); |
| | | binaryData := XLS::SaveTableGroupToBinaryData( tableGroupHandle, true ); |
| | | |
| | | return binaryData.AsBinaryValue(); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod AwaitLocalTableXMLData ( |
| | | const Strings columnXMLData, |
| | | RecycleBin owner |
| | | ) |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-21-2024 (created) |
| | | manager := select( owner,ExportXMLManager,manager,manager.Name() = "LocalTableXML" ); |
| | | if( isnull( manager )){ |
| | | manager := owner.ExportXMLManager( relnew,Name := "LocalTableXML" ); |
| | | }else{ |
| | | manager.ExportXMLData( relflush ); |
| | | } |
| | | traverse( columnXMLData,Elements,element,element.TrimBoth() <> "" ){ |
| | | data := manager.ExportXMLData( relnew, XML := element); |
| | | if( element.LikeUserLocale( "Product ID" )){ |
| | | data.Priority( 1 ); |
| | | }else if( element.LikeUserLocale( "Attribute" )){ |
| | | data.Priority( 2 ); |
| | | }else if( element.LikeUserLocale( "产å°" )){ |
| | | data.Priority( 3 ); |
| | | }else if( element.LikeUserLocale( "车å" )){ |
| | | data.Priority( 4 ); |
| | | }else if( element.LikeUserLocale( "å卿ºé¶ä»¶å·" )){ |
| | | data.Priority( 5 ); |
| | | }else if( element.LikeUserLocale( "å卿ºåä½ç " )){ |
| | | data.Priority( 6 ); |
| | | }else{ |
| | | data.Priority( [Number]element.SubString( 14,10 ).ReplaceAll( "/","") ); |
| | | } |
| | | } |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod AwaitShiftPlanXMLData ( |
| | | const Strings columnXMLData, |
| | | RecycleBin owner |
| | | ) |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-20-2024 (created) |
| | | manager := select( owner,ExportXMLManager,manager,manager.Name() = "ShiftPlanXML" ); |
| | | if( isnull( manager )){ |
| | | manager := owner.ExportXMLManager( relnew,Name := "ShiftPlanXML" ); |
| | | }else{ |
| | | manager.ExportXMLData( relflush ); |
| | | } |
| | | traverse( columnXMLData,Elements,element,element.TrimBoth() <> "" ){ |
| | | data := manager.ExportXMLData( relnew, XML := element); |
| | | if( element.LikeUserLocale( "Unit" )){ |
| | | data.Priority( 1 ); |
| | | }else if( element.LikeUserLocale( "Attribute" )){ |
| | | data.Priority( 2 ); |
| | | }else{ |
| | | data.Priority( [Number]element.SubString( 14,10 ).ReplaceAll( "-","") ); |
| | | } |
| | | } |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #root |
| | | #parent: #DomainModel |
| | | Type ExportXMLManager |
| | | { |
| | | #keys: '5[412672.0.1084249053][412672.0.1084249051][0.0.0][412672.0.1084249052][412672.0.1084249054]' |
| | | BaseType: Object |
| | | StructuredName: 'ExportXMLManagers' |
| | | } |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod Upload ( |
| | | Archive archive, |
| | | RecycleBin recycleBin, |
| | | BinaryValue binaryValue, |
| | | String filePath |
| | | ) as GeneralExcelImportAndExportDataSource |
| | | ) const as GeneralExcelImportAndExportDataSource |
| | | { |
| | | TextBody: |
| | | [* |
| | | fileName := filePath.Tokenize( "\" ).Element( filePath.Tokenize( "\" ).Size() - 1 ); |
| | | |
| | | generalExcelImportAndExportDataSource := archive.GeneralExcelImportAndExportDataSource( relnew, |
| | | generalExcelImportAndExportDataSource := recycleBin.GeneralExcelImportAndExportDataSource( relnew, |
| | | FileBinaryValue := binaryValue, |
| | | Name := fileName, |
| | | IsXLSX := fileName.EndsWith( "xlsx" ), |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #root |
| | | #parent: #DomainModel |
| | | Type LocalCell |
| | | { |
| | | #keys: '5[412672.0.1084249620][412672.0.1084249618][0.0.0][412672.0.1084249619][412672.0.1084249621]' |
| | | BaseType: Object |
| | | StructuredName: 'LocalCells' |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute BaseVersion |
| | | { |
| | | #keys: '3[412672.0.1087844729][412672.0.1087844728][412672.0.1087844730]' |
| | | ValueType: Real |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute BaseVersionValue |
| | | { |
| | | #keys: '3[412672.0.1087874641][412672.0.1087874640][412672.0.1087874642]' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute CompareVersion |
| | | { |
| | | #keys: '3[412672.0.1087844726][412672.0.1087844725][412672.0.1087844727]' |
| | | ValueType: Real |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute CompareVersionValue |
| | | { |
| | | #keys: '3[412672.0.1087874649][412672.0.1087874648][412672.0.1087874650]' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute Gap |
| | | { |
| | | #keys: '3[412672.0.1087844732][412672.0.1087844731][412672.0.1087844733]' |
| | | ValueType: Real |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Function CalcGap |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-21-2024 (created) |
| | | |
| | | value := this.BaseVersion() - this.CompareVersion(); |
| | | |
| | | this.Gap( value ); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Method GetAttributeByName ( |
| | | String attributeName |
| | | ) const declarative as String |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-21-2024 (created) |
| | | value := ""; |
| | | |
| | | if( attributeName = "BaseVersion" ){ |
| | | if( not this.LocalColumn().IsAttrbuteColumn() ){ |
| | | value := this.BaseVersion().Format( "N(Dec)" ); |
| | | } |
| | | } |
| | | if( attributeName = "CompareVersion" ){ |
| | | if( not this.LocalColumn().IsAttrbuteColumn() ){ |
| | | value := this.CompareVersion().Format( "N(Dec)" ); |
| | | } |
| | | } |
| | | if( attributeName = "Gap" ){ |
| | | if( not this.LocalColumn().IsAttrbuteColumn() ){ |
| | | value := this.Gap().Format( "N(Dec)" ); |
| | | } |
| | | } |
| | | if( attributeName = "BaseVersionValue" ){ |
| | | if( not this.LocalColumn().IsAttrbuteColumn() ){ |
| | | value := "0"; |
| | | }else{ |
| | | value := this.BaseVersionValue(); |
| | | } |
| | | } |
| | | if( attributeName = "CompareVersionValue" ){ |
| | | if( not this.LocalColumn().IsAttrbuteColumn() ){ |
| | | value := "0"; |
| | | }else{ |
| | | value := this.CompareVersionValue(); |
| | | } |
| | | } |
| | | |
| | | return value; |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod AsyncExport ( |
| | | RecycleBin recycleBin, |
| | | const constcontent LocalRows rows, |
| | | const constcontent LocalColumns columns |
| | | ) |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-20-2024 (created) |
| | | sortColumns := selectsortedset( columns,Elements,column,true,column.Index()); |
| | | |
| | | attributeNames := LocalCell_DemandComparison::GetAttributeNames(); |
| | | |
| | | columnstring := emit( "" ); |
| | | flag := true; |
| | | traverse( sortColumns,Elements,sortColumn ){ |
| | | if( flag ){ |
| | | attributeXML := rows -> LocalCell_DemandComparison::GetColumnXML( sortColumn,attributeNames,"attribute" ); |
| | | columnstring := columnstring.Merge( attributeXML ) |
| | | flag := false; |
| | | } |
| | | |
| | | cellxml := rows -> LocalCell_DemandComparison::GetColumnXML( sortColumn,attributeNames ,"data"); |
| | | columnstring := columnstring.Merge( cellxml); |
| | | } |
| | | |
| | | columnstring -> GroupAll() -> ExportXMLManager::AwaitLocalTableXMLData( recycleBin ); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod GetAttributeNames () const declarative as owning Strings |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-21-2024 (created) |
| | | attributeNames := construct( Strings ); |
| | | |
| | | attributeNames.Add( "BaseVersion" ); |
| | | attributeNames.Add( "CompareVersion" ); |
| | | attributeNames.Add( "BaseVersionValue" ); |
| | | attributeNames.Add( "CompareVersionValue" ); |
| | | attributeNames.Add( "Gap" ); |
| | | |
| | | return &attributeNames; |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod GetColumnXML ( |
| | | const constcontent LocalRows rows, |
| | | const LocalColumn column, |
| | | const Strings attributeNames, |
| | | String type |
| | | ) const as String |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-21-2024 (created) |
| | | // rislai Jun-20-2024 (created) |
| | | columnXML := ""; |
| | | cells := selectsortedset( column, LocalCell.astype( LocalCell_DemandComparison ), cell, |
| | | exists( rows,Elements,element,element = cell.LocalRow()), cell.LocalRow().Index()); |
| | | if( type = "data" ){ |
| | | columnXML := ""; |
| | | if( column.IsAttrbuteColumn() ){ |
| | | columnXML := "<column><name>" + column.Name() + "</name><type>String</type>"; |
| | | }else{ |
| | | columnXML := "<column><name>" + column.Name() + "</name><type>Number</type>"; |
| | | } |
| | | traverse ( cells, Elements, cell ) { |
| | | traverse( attributeNames ,Elements,e ){ |
| | | cellXML := '<cell value="' + cell.GetAttributeByName( e ) + '"/>' |
| | | columnXML := columnXML + cellXML; |
| | | } |
| | | } |
| | | columnXML := columnXML + "</column>"; |
| | | } |
| | | if( type = "attribute" ){ |
| | | columnXML1 := "<column><name>Product ID</name><type>String</type>"; |
| | | columnXML2 := "<column><name>Attribute</name><type>String</type>"; |
| | | |
| | | traverse ( cells, Elements, cell ) { |
| | | flag := true; |
| | | traverse( attributeNames ,Elements,e ){ |
| | | if( flag ){ |
| | | cellXML := '<cell value="' + cell.LocalRow().Name() + '"/>' |
| | | columnXML1 := columnXML1 + cellXML; |
| | | flag := false; |
| | | }else{ |
| | | cellXML := '<cell value=" "/>' |
| | | columnXML1 := columnXML1 + cellXML; |
| | | } |
| | | cellXML := '<cell value="' + e + '"/>' |
| | | columnXML2 := columnXML2 + cellXML; |
| | | } |
| | | } |
| | | columnXML := columnXML1 + "</column>" + columnXML2 + "</column>"; |
| | | } |
| | | |
| | | return columnXML; |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #root |
| | | #parent: #DomainModel |
| | | TypeSpecialization LocalCell_DemandComparison |
| | | { |
| | | #keys: '2[412672.0.1087844722][412672.0.1087844717]' |
| | | Parent: LocalCell |
| | | StructuredName: 'LocalCell_DemandComparisons' |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute Index |
| | | { |
| | | #keys: '3[412672.0.1086931887][412672.0.1086931886][412672.0.1086931888]' |
| | | ValueType: Number |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute IsAttrbuteColumn |
| | | { |
| | | #keys: '3[412672.0.1087874665][412672.0.1087874664][412672.0.1087874666]' |
| | | ValueType: Boolean |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute Name |
| | | { |
| | | #keys: '3[412672.0.1086931874][412672.0.1086931873][412672.0.1086931875]' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #root |
| | | #parent: #DomainModel |
| | | Type LocalColumn |
| | | { |
| | | #keys: '5[412672.0.1084249599][412672.0.1084249597][0.0.0][412672.0.1084249598][412672.0.1084249600]' |
| | | BaseType: Object |
| | | StructuredName: 'LocalColumns' |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute CustomName |
| | | { |
| | | #keys: '3[412672.0.1094515780][412672.0.1094515779][412672.0.1094515781]' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute Index |
| | | { |
| | | #keys: '3[412672.0.1086931843][412672.0.1086931842][412672.0.1086931844]' |
| | | ValueType: Number |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute Name |
| | | { |
| | | #keys: '3[412672.0.1087844675][412672.0.1087844674][412672.0.1087844676]' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Function CalcName |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-22-2024 (created) |
| | | |
| | | value := ifexpr( this.CustomName() = "",[String]this.Index(),this.CustomName() ); |
| | | |
| | | this.Name( value ); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #root |
| | | #parent: #DomainModel |
| | | Type LocalRow |
| | | { |
| | | #keys: '5[412672.0.1084249610][412672.0.1084249608][0.0.0][412672.0.1084249609][412672.0.1084249611]' |
| | | BaseType: Object |
| | | StructuredName: 'LocalRows' |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute Name |
| | | { |
| | | #keys: '3[412672.0.1094514009][412672.0.1094514008][412672.0.1094514010]' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute RowIndexCache |
| | | { |
| | | #keys: '3[412672.0.1086954704][412672.0.1086954703][412672.0.1086954705]' |
| | | ValueType: Number |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Method GetRowIndexCache () declarative as Number |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-20-2024 (created) |
| | | this.RowIndexCache( this.RowIndexCache() + 1 ); |
| | | |
| | | return this.RowIndexCache(); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #root |
| | | #parent: #DomainModel |
| | | Type LocalTable |
| | | { |
| | | #keys: '5[412672.0.1084249615][412672.0.1084249613][0.0.0][412672.0.1084249614][412672.0.1084249616]' |
| | | BaseType: Object |
| | | StructuredName: 'LocalTables' |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod IsAnyDurationContained ( |
| | | DateTime start1, |
| | | DateTime end1, |
| | | DateTime start2, |
| | | DateTime end2 |
| | | ) const declarative as Boolean |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-19-2024 (created) |
| | | return ( start1 <= start2 and end1 >= end2 ) or ( start2 <= start1 and end2 >= end1 ); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute UpperLimitOfTransferCapacityAGW |
| | | { |
| | | #keys: '3[413988.0.1291510952][413988.0.1291510951][413988.0.1291510953]' |
| | | ValueType: Number |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute UpperLimitOfTransferCapacityKW |
| | | { |
| | | #keys: '3[413988.0.1291510942][413988.0.1291510941][413988.0.1291510943]' |
| | | ValueType: Number |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute UpperLimitOfTransferCapacityPL |
| | | { |
| | | #keys: '3[413988.0.1291510932][413988.0.1291510931][413988.0.1291510933]' |
| | | ValueType: Number |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute UpperLimitOfTransferCapacityZKG |
| | | { |
| | | #keys: '3[413988.0.1291510909][413988.0.1291510908][413988.0.1291510910]' |
| | | ValueType: Number |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute UpperLimitOfTransferCapacityZKM |
| | | { |
| | | #keys: '3[413988.0.1291510922][413988.0.1291510921][413988.0.1291510923]' |
| | | ValueType: Number |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #root |
| | | #parent: #DomainModel |
| | | Type Period_MP #extension |
| | | { |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod OnLogin () as Key |
| | | { |
| | | TextBody: |
| | | [* |
| | | // lihongji May-15-2024 (created) |
| | | folder := DomainModel::Domain().MDSFolderDefinitions().FindFolder( "/root" ); |
| | | |
| | | datasetName := typeof( RecycleBin ).Name() + "_" + QuintiqUser::CurrentUser().ShortName(); |
| | | |
| | | oinfo := MDSEditor::Editor().ObjectInfos( typeof( RecycleBin ).Name(), folder.FolderID(), datasetName ); |
| | | |
| | | o := select( oinfo, Elements, o, o.IsLoaded() ); |
| | | emptydataset := isnull( o ); |
| | | |
| | | key := Key::ZeroKey(); |
| | | if ( emptydataset ) { |
| | | mdsrb := MDSRecycleBin::CreateMDS( datasetName, DMF_Utility::StorageState_MemoryOnly() ); |
| | | key := mdsrb.MDSID(); |
| | | } else { |
| | | MDSRecycleBin::LoadMDSAndConvert( o.MDSID(), DMF_Utility::StorageState_MemoryOnly() ); |
| | | key := o.MDSID().MDSKey(); |
| | | } |
| | | |
| | | return key; |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #root |
| | | #parent: #DomainModel |
| | | Type RecycleBin |
| | | { |
| | | #keys: '5[412672.0.1084213474][412672.0.1084213472][0.0.0][412672.0.1084213473][412672.0.1084213475]' |
| | | BaseType: Object |
| | | StructuredName: 'RecycleBins' |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute Color |
| | | { |
| | | #keys: '3[412672.0.1082947207][412672.0.1082947206][412672.0.1082947208]' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute CustomRemark |
| | | { |
| | | #keys: '3[412672.0.1067124406][412672.0.1067124405][412672.0.1067124407]' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute EventType |
| | | { |
| | | #keys: '3[412672.0.1082947252][412672.0.1082947251][412672.0.1082947253]' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute Outcome |
| | | { |
| | | #keys: '3[412672.0.1066680021][412672.0.1066680020][412672.0.1066680022]' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute Remark |
| | | { |
| | | #keys: '3[412672.0.1066680031][412672.0.1066680030][412672.0.1066680032]' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Function CalcColor |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-19-2024 (created) |
| | | // Red,Cyan,LightBlue,LightOrange |
| | | // æ³å®èåæ¥ï¼ææå
ï¼æææ¥ï¼è°ä¼ |
| | | value := "White" |
| | | if( this.EventType() = "å¨å
"){ |
| | | value := "Cyan"; |
| | | } |
| | | if( this.EventType() = "卿¥"){ |
| | | value := "LightBlue"; |
| | | } |
| | | if( this.EventType() = "æ³å®è忥"){ |
| | | value := "Red"; |
| | | } |
| | | if( this.EventType() = "è°ä¼"){ |
| | | value := "LightOrange"; |
| | | } |
| | | |
| | | |
| | | this.Color( value ); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Function CalcEventType |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-19-2024 (created) |
| | | value := this.CalculateEventType(); |
| | | |
| | | this.EventType( value ); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Function CalcOutcome |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-18-2024 (created) |
| | | capacity := ifexpr( this.UnitPeriodTime().IsUtilizationInUOM(), [Real]this.UnitPeriodTime().UsedCapacity().HoursAsReal(), this.UnitPeriodTime().UtilizationPercentage() * this.UnitPeriodTime().MaximumLoadPercentage() / 100 ) |
| | | |
| | | value := ifexpr( capacity = 0,"", this.UnitPeriodTime().ShiftPatternName()); |
| | | |
| | | this.Outcome( value ); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Function CalcRemark |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-18-2024 (created) |
| | | |
| | | value := ifexpr( this.CustomRemark() = "",this.CalculateRemark( ),this.CustomRemark()); |
| | | |
| | | this.Remark( value ); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Method CalculateEventType () const declarative as String |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-19-2024 (created) |
| | | values := construct( Strings ); |
| | | |
| | | traverse( this.UnitPeriodTime().Unit().UnitCalendar(),Participation,participation,participation.Event().Type() = LibCal_Event::TYPE_UNAVAILABLE()){ |
| | | event := participation.Event(); |
| | | |
| | | if( this.UnitPeriodTime().Start().Date() >= event.EarliestStart() and this.UnitPeriodTime().End().Date() <= event.LatestEnd() ){ |
| | | intervals := selectset( event,LeadingParticipation.ExplicitTimeInterval,interval,LocalTool::IsAnyDurationContained( interval.Start(),interval.End(),this.UnitPeriodTime().Start(),this.UnitPeriodTime().End())); |
| | | |
| | | traverse( intervals,Elements,interval){ |
| | | values.Add( ifexpr( isnull( interval.Participation().Event().EventType().Parent()),interval.Participation().Event().EventType().ID(),interval.Participation().Event().EventType().Parent().ID() )); |
| | | } |
| | | } |
| | | } |
| | | values := selectuniquevalues( values,Elements,value,true,value ); |
| | | |
| | | result := ""; |
| | | flag := true; |
| | | traverse( values,Elements,value ,flag){ |
| | | if( value = "è°ä¼" and result <> "è°ä¼"){ |
| | | result := "è°ä¼"; |
| | | }else if( value = "æ³å®è忥" and result <> "æ³å®è忥"){ |
| | | result := "æ³å®è忥"; |
| | | }else if( value = "å¨å
" and result <> "å¨å
"){ |
| | | result := "å¨å
"; |
| | | }else if( value = "卿¥" and result <> "卿¥"){ |
| | | result := "卿¥"; |
| | | } |
| | | } |
| | | |
| | | return result; |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Method CalculateRemark () const declarative as String |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-18-2024 (created) |
| | | values := construct( Strings ); |
| | | |
| | | traverse( this.UnitPeriodTime().Unit().UnitCalendar(),Participation,participation,participation.Event().Type() = LibCal_Event::TYPE_UNAVAILABLE()){ |
| | | event := participation.Event(); |
| | | |
| | | if( this.UnitPeriodTime().Start().Date() >= event.EarliestStart() and this.UnitPeriodTime().End().Date() <= event.LatestEnd() ){ |
| | | intervals := selectset( event,LeadingParticipation.ExplicitTimeInterval,interval,LocalTool::IsAnyDurationContained( interval.Start(),interval.End(),this.UnitPeriodTime().Start(),this.UnitPeriodTime().End())); |
| | | |
| | | traverse( intervals,Elements,interval){ |
| | | values.Add( interval.Participation().Event().Subject() ); |
| | | } |
| | | } |
| | | } |
| | | values := selectuniquevalues( values,Elements,value,true,value ); |
| | | |
| | | result := ""; |
| | | traverse( values,Elements,value ){ |
| | | result := result + value + ";"; |
| | | } |
| | | |
| | | return ifexpr( result = "",result,result.SubString( 0,result.Length() - 1 ) ); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Method GetAttributeByName ( |
| | | String attributeName |
| | | ) const declarative as String |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-20-2024 (created) |
| | | value := ""; |
| | | if( attributeName = "Remark" ){ |
| | | value := this.Remark(); |
| | | } |
| | | if( attributeName = "Outcome" ){ |
| | | value := this.Outcome(); |
| | | } |
| | | return value; |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Method SetRemark ( |
| | | String remark |
| | | ) |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-18-2024 (created) |
| | | this.CustomRemark( remark ); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod AsyncExport ( |
| | | RecycleBin recycleBin, |
| | | const constcontent Units rows, |
| | | const constcontent Period_MPs columns |
| | | ) |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-20-2024 (created) |
| | | sortColumns := selectsortedset( columns,Elements,column,true,column.StartDate()); |
| | | |
| | | attributeNames := ShiftPlan::GetAttributeNames(); |
| | | |
| | | columnstring := emit( "" ); |
| | | flag := true; |
| | | traverse( sortColumns,Elements,sortColumn ){ |
| | | if( flag ){ |
| | | attributeXML := rows -> ShiftPlan::GetShiftPlanColumnXML( sortColumn,attributeNames,"attribute" ); |
| | | columnstring := columnstring.Merge( attributeXML ) |
| | | flag := false; |
| | | } |
| | | |
| | | cellxml := rows -> ShiftPlan::GetShiftPlanColumnXML( sortColumn,attributeNames ,"data"); |
| | | columnstring := columnstring.Merge( cellxml); |
| | | } |
| | | |
| | | columnstring -> GroupAll() -> ExportXMLManager::AwaitShiftPlanXMLData( recycleBin ); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod Create ( |
| | | UnitPeriodTime owner |
| | | ) |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-17-2024 (created) |
| | | owner.ShiftPlan( relnew ); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod GetAttributeNames () const declarative as owning Strings |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-20-2024 (created) |
| | | attributeNames := construct( Strings ); |
| | | |
| | | attributeNames.Add( "Outcome" ); |
| | | attributeNames.Add( "Remark" ); |
| | | |
| | | return &attributeNames; |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod GetShiftPlanColumnXML ( |
| | | const constcontent Units rows, |
| | | const Period_MP column, |
| | | const Strings attributeNames, |
| | | String type |
| | | ) const as String |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-20-2024 (created) |
| | | columnXML := ""; |
| | | cells := selectsortedset( column, UnitPeriod.astype( UnitPeriodTime ).ShiftPlan, cell, |
| | | exists( rows,Elements,element,element = cell.UnitPeriodTime().Unit()), cell.UnitPeriodTime().Unit().ID()); |
| | | if( type = "data" ){ |
| | | columnXML := "<column><name>" + column.StartDate().Format( "Y-M2-D2 ")+ "</name><type>String</type>"; |
| | | traverse ( cells, Elements, cell ) { |
| | | traverse( attributeNames ,Elements,e ){ |
| | | cellXML := '<cell value="' + cell.GetAttributeByName( e ) + '"/>' |
| | | columnXML := columnXML + cellXML; |
| | | } |
| | | } |
| | | columnXML := columnXML + "</column>"; |
| | | } |
| | | if( type = "attribute" ){ |
| | | columnXML1 := "<column><name>Unit</name><type>String</type>"; |
| | | columnXML2 := "<column><name>Attribute</name><type>String</type>"; |
| | | |
| | | traverse ( cells, Elements, cell ) { |
| | | flag := true; |
| | | traverse( attributeNames ,Elements,e ){ |
| | | if( flag ){ |
| | | cellXML := '<cell value="' + cell.UnitPeriodTime().Unit().ID() + '"/>' |
| | | columnXML1 := columnXML1 + cellXML; |
| | | flag := false; |
| | | }else{ |
| | | cellXML := '<cell value=" "/>' |
| | | columnXML1 := columnXML1 + cellXML; |
| | | } |
| | | cellXML := '<cell value="' + e + '"/>' |
| | | columnXML2 := columnXML2 + cellXML; |
| | | } |
| | | } |
| | | columnXML := columnXML1 + "</column>" + columnXML2 + "</column>"; |
| | | } |
| | | |
| | | return columnXML; |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #root |
| | | #parent: #DomainModel |
| | | Type ShiftPlan |
| | | { |
| | | #keys: '5[412672.0.1057415075][412672.0.1057415073][0.0.0][412672.0.1057415074][412672.0.1057415076]' |
| | | BaseType: Object |
| | | StructuredName: 'ShiftPlans' |
| | | } |
| | |
| | | StaticMethod Test ( |
| | | ScenarioManager scenarioManager, |
| | | MacroPlan macroPlan, |
| | | Archive archive |
| | | Archive archive, |
| | | RecycleBin recycleBin |
| | | ) |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-9-2024 (created) |
| | | baseVersion := select( archive,ArchivePR,pr,true ); |
| | | baseVersionFile := OSFile::Construct(); |
| | | baseVersionFile.Open( baseVersion.FilePath(), "Read", false ); |
| | | baseVersionBinaryData := baseVersionFile.ReadBinary(); |
| | | baseVersionDataSource := GeneralExcelImportAndExportDataSource::Upload( recycleBin, baseVersionBinaryData, baseVersion.FilePath() ); |
| | | baseVersionDataSource.ReadStructure(); |
| | | |
| | | traverse( macroPlan,Routing,rt ){ |
| | | rt.UphillRouting( relflush ); |
| | | } |
| | | baseVersionTables := selectset( baseVersionDataSource, GeneralExcelImportAndExportDataTable, tempGEIAEDT, true ); |
| | | |
| | | baseVersionTable := baseVersionTables.Element( 0 ); |
| | | |
| | | baseVersionRow := select( baseVersionTable, GeneralExcelImportAndExportDataRow, tempGEIAEDR, tempGEIAEDR.RowNr() = 999 ); |
| | | |
| | | info( isnull( baseVersionRow )); |
| | | |
| | | |
| | | //testTree := NamedValueTree::Create(); |
| | | // |
| | | //testTreeHandel := testTree.GetHandle( "test1" ); |
| | | //testTreeHandel2 := testTree.GetHandle( "test2" ); |
| | | // |
| | | //testTree.Root().AddChild( testTreeHandel,1 ); |
| | | // |
| | | //info( testTree.Root().Child( testTreeHandel ).GetValueAsNumber() ); |
| | | //try{ |
| | | // info( testTree.Root().Child( testTreeHandel2 ).GetValueAsNumber() ); |
| | | //}onerror{ |
| | | // testTree.Root().AddChild( testTreeHandel,2 ); |
| | | //} |
| | | //info( testTree.Root().Child( testTreeHandel ).GetValueAsNumber() ); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute Value |
| | | { |
| | | #keys: '3[413988.0.1292032065][413988.0.1292032064][413988.0.1292032066]' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | StaticMethod GenerateReport ( |
| | | MacroPlan macroPlan |
| | | ) |
| | | { |
| | | TextBody: |
| | | [* |
| | | macroPlan.TransferPlanRow( relflush ); |
| | | macroPlan.TransferPlanColumn( relflush ); |
| | | |
| | | rowNr := 0; |
| | | |
| | | // çæè°æ¨è®¡å |
| | | traverse ( macroPlan, Unit, u, u.HasCapacityTypeTransportQuantity() ) { |
| | | traverse ( u, Lane.LaneLeg.Trip, t ) { |
| | | traverse ( t, ProductInTrip, pit, pit.Quantity() > 0.0 ) { |
| | | // æ¾è¡ |
| | | tpr := TransferPlanRow::FindTransferPlanRowTypeIndex( t.LaneLeg().AsOriginStockingPointLeg().StockingPoint_MP().Name(), |
| | | t.LaneLeg().AsDestinationStockingPointLeg().StockingPoint_MP().Name(), |
| | | pit.Product_MP().ID() ); |
| | | if ( isnull( tpr ) ) { |
| | | tpr := macroPlan.TransferPlanRow( relnew, |
| | | RowNr := rowNr, |
| | | SourceStockpoingPointID := t.LaneLeg().AsOriginStockingPointLeg().StockingPoint_MP().Name(), |
| | | TargetStockpoingPointID := t.LaneLeg().AsDestinationStockingPointLeg().StockingPoint_MP().Name(), |
| | | ProductID := pit.Product_MP().ID() ); |
| | | } |
| | | |
| | | // æ¾å |
| | | tpc := TransferPlanColumn::FindTransferPlanColumnTypeIndex( t.Departure().Date() ); |
| | | if ( isnull( tpc ) ) { |
| | | tpc := macroPlan.TransferPlanColumn( relnew, |
| | | ColumnDate := t.Departure().Date() ); |
| | | } |
| | | |
| | | // èµå¼åå
æ ¼ |
| | | cell := select( tpc, TransferPlanCell, tempTPC, tempTPC.TransferPlanRow() = tpr ); |
| | | if ( isnull( cell ) ) { |
| | | cell := tpc.TransferPlanCell( relnew, Value := [String]pit.Quantity().Round( 0 ) ); |
| | | cell.TransferPlanRow( relset, tpr ); |
| | | } else { |
| | | cell.Value( [String] ( [Number]cell.Value() + pit.Quantity().Round( 0 ) ) ); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | // è¡¥é½ç©ºå |
| | | indexDate := minselect( macroPlan, TransferPlanColumn, tempTPC, true, tempTPC.ColumnDate() ).ColumnDate(); |
| | | endDate := maxselect( macroPlan, TransferPlanColumn, tempTPC, true, tempTPC.ColumnDate() ).ColumnDate(); |
| | | while ( indexDate <= endDate ) { |
| | | if ( isnull( TransferPlanColumn::FindTransferPlanColumnTypeIndex( indexDate ) ) ) { |
| | | macroPlan.TransferPlanColumn( relnew, |
| | | ColumnDate := indexDate ); |
| | | } |
| | | indexDate := indexDate + 1; |
| | | } |
| | | |
| | | |
| | | // çæäº§åå |
| | | minDateTPC := macroPlan.TransferPlanColumn( relnew, |
| | | ColumnDate := Date::MinDate() ); |
| | | traverse ( macroPlan, TransferPlanRow, tpr ) { |
| | | productCell := minDateTPC.TransferPlanCell( relnew, Value := tpr.ProductID() ); |
| | | productCell.TransferPlanRow( relset, tpr ); |
| | | } |
| | | |
| | | // è°æ¨æ°éè°æ´ |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #root |
| | | #parent: #DomainModel |
| | | Type TransferPlanCell |
| | | { |
| | | #keys: '5[413988.0.1292031923][413988.0.1292031921][0.0.0][413988.0.1292031922][413988.0.1292031924]' |
| | | BaseType: Object |
| | | StructuredName: 'TransferPlanCells' |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute ColumnDate |
| | | { |
| | | #keys: '3[413988.0.1292032055][413988.0.1292032054][413988.0.1292032056]' |
| | | IsReadOnly: true |
| | | ValueType: Date |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute ColumnIndex |
| | | { |
| | | #keys: '3[413988.0.1292032025][413988.0.1292032024][413988.0.1292032026]' |
| | | ValueType: Number |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute ColumnName |
| | | { |
| | | #keys: '3[413988.0.1292032045][413988.0.1292032044][413988.0.1292032046]' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Function CalcColumnName |
| | | { |
| | | TextBody: |
| | | [* |
| | | // lihongji Jun-24-2024 (created) |
| | | |
| | | value := ifexpr( this.ColumnDate().IsMinInfinity(), "", this.ColumnDate().Format( "Y/M2/D2" ) ); |
| | | |
| | | this.ColumnName( value ); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | TypeIndex TransferPlanColumnTypeIndex |
| | | { |
| | | Attributes: |
| | | [ |
| | | TypeIndexAttribute |
| | | { |
| | | ModelElement: ColumnDate |
| | | } |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #root |
| | | #parent: #DomainModel |
| | | Type TransferPlanColumn |
| | | { |
| | | #keys: '5[413988.0.1292031918][413988.0.1292031916][0.0.0][413988.0.1292031917][413988.0.1292031919]' |
| | | BaseType: Object |
| | | StructuredName: 'TransferPlanColumns' |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute Name |
| | | { |
| | | #keys: '3[413988.0.1292032011][413988.0.1292032010][413988.0.1292032012]' |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute ProductID |
| | | { |
| | | #keys: '3[413988.0.1292031981][413988.0.1292031980][413988.0.1292031982]' |
| | | IsReadOnly: true |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute RowNr |
| | | { |
| | | #keys: '3[413988.0.1292032032][413988.0.1292032031][413988.0.1292032033]' |
| | | ValueType: Number |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute SourceStockpoingPointID |
| | | { |
| | | #keys: '3[413988.0.1292031991][413988.0.1292031990][413988.0.1292031992]' |
| | | IsReadOnly: true |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Attribute TargetStockpoingPointID |
| | | { |
| | | #keys: '3[413988.0.1292032001][413988.0.1292032000][413988.0.1292032002]' |
| | | IsReadOnly: true |
| | | ValueType: String |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Function CalcName |
| | | { |
| | | TextBody: |
| | | [* |
| | | // lihongji Jun-24-2024 (created) |
| | | |
| | | value := this.SourceStockpoingPointID() + " to " + this.TargetStockpoingPointID(); |
| | | |
| | | this.Name( value ); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | TypeIndex TransferPlanRowTypeIndex |
| | | { |
| | | Attributes: |
| | | [ |
| | | TypeIndexAttribute |
| | | { |
| | | ModelElement: SourceStockpoingPointID |
| | | } |
| | | TypeIndexAttribute |
| | | { |
| | | ModelElement: TargetStockpoingPointID |
| | | } |
| | | TypeIndexAttribute |
| | | { |
| | | ModelElement: ProductID |
| | | } |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #root |
| | | #parent: #DomainModel |
| | | Type TransferPlanRow |
| | | { |
| | | #keys: '5[413988.0.1292031913][413988.0.1292031911][0.0.0][413988.0.1292031912][413988.0.1292031914]' |
| | | BaseType: Object |
| | | StructuredName: 'TransferPlanRows' |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Method OnCreate #extension |
| | | { |
| | | TextBody: |
| | | [* |
| | | // rislai Jun-18-2024 (created) |
| | | ShiftPlan::Create( this ); |
| | | *] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #root |
| | | #parent: #DomainModel |
| | | TypeSpecialization UnitPeriodTime #extension |
| | | { |
| | | } |
| | |
| | | ] |
| | | DataRepresentation.Default |
| | | { |
| | | FormatString: 'D-MM-YOnMax(-)OnMin(-)' |
| | | FormatString: 'Y-M2-D2OnMax(-)OnMin(-)' |
| | | InheritFormatting: false |
| | | } |
| | | } |
| | |
| | | ] |
| | | DataRepresentation.Default |
| | | { |
| | | FormatString: 'D-MM-YOnMax(-)OnMin(-)' |
| | | FormatString: 'Y-M2-D2 H2:m:sOnMax(-)OnMin(-)' |
| | | InheritFormatting: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | TypeRepresentation ShiftPlan |
| | | { |
| | | AttributeRepresentation Remark |
| | | { |
| | | AttributeKey: '[412672.0.1066680030]' |
| | | Conditional: |
| | | [ |
| | | DataRepresentation.Conditional |
| | | { |
| | | BackgroundColor: '$FFCC99' |
| | | ConditionBody: 'object.Color() = "LightOrange"' |
| | | ConversionBody: '' |
| | | DefaultBackgroundColor: false |
| | | InheritConversion: false |
| | | } |
| | | DataRepresentation.Conditional |
| | | { |
| | | BackgroundColor: 'Red' |
| | | ConditionBody: 'object.Color() = "Red"' |
| | | ConversionBody: '' |
| | | DefaultBackgroundColor: false |
| | | InheritConversion: false |
| | | } |
| | | DataRepresentation.Conditional |
| | | { |
| | | BackgroundColor: '$33CCCC' |
| | | ConditionBody: 'object.Color() = "Cyan"' |
| | | ConversionBody: '' |
| | | DefaultBackgroundColor: false |
| | | InheritConversion: false |
| | | } |
| | | DataRepresentation.Conditional |
| | | { |
| | | BackgroundColor: '$99CCFF' |
| | | ConditionBody: 'object.Color() = "LightBlue"' |
| | | ConversionBody: '' |
| | | DefaultBackgroundColor: false |
| | | InheritConversion: false |
| | | } |
| | | ] |
| | | } |
| | | RelationRepresentation UnitPeriodTime { RelationKey: '[412672.0.1066680008]' Visibility: 'Normal' } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component ActionBarGroupPlanViews #extension |
| | | { |
| | | Children: |
| | | [ |
| | | Component ButtonShiftPlan |
| | | { |
| | | #keys: '[412672.0.1064451018]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Image: 'COMPASSES' |
| | | Label: 'çæ¬¡è®¡å' |
| | | Taborder: 8 |
| | | ] |
| | | } |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component ActionBarGroupScenarioComparisonViews #extension |
| | | { |
| | | Children: |
| | | [ |
| | | Component ButtonScenarioComparisonDemandComparison |
| | | { |
| | | #keys: '[412672.0.1090347286]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Image: 'EQUALS' |
| | | Label: '鿱坹æ¯' |
| | | Taborder: 8 |
| | | ] |
| | | } |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component ActionBarPagePlan #extension |
| | | { |
| | | Children: |
| | | [ |
| | | #child: ActionBarGroupPlanViews |
| | | #child: abgSecondDevelopmentPlan |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component ActionBarPageScenarioComparison #extension |
| | | { |
| | | Children: |
| | | [ |
| | | #child: ActionBarGroupScenarioComparisonViews |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component abgSecondDevelopmentPlan |
| | | { |
| | | #keys: '[413988.0.1290310419]' |
| | | BaseType: 'WebActionBarGroup' |
| | | Children: |
| | | [ |
| | | Component bTransferPlan |
| | | { |
| | | #keys: '[413988.0.1290300652]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Image: 'HAND_TRUCK_BOX' |
| | | Label: 'Transfer plan' |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | Component bBlank |
| | | { |
| | | #keys: '[413988.0.1291640400]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Category: 'Actions-2' |
| | | Taborder: 3 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: #root |
| | | Method OnCreated () id:Method_ApplicationMacroPlanner_OnCreated #extension |
| | | { |
| | | Body: |
| | | [* |
| | | // On created of Application |
| | | |
| | | // Restore active MacroPlan scenario to DataHolderActiveScenario |
| | | // and Dropdown |
| | | if( not isnull( ScenarioManager ) ) |
| | | { |
| | | if( not isnull( MacroPlan ) ) |
| | | { |
| | | scenario := select( ScenarioManager, ScenarioMP, sce, |
| | | sce.DatasetMDSID() = MacroPlan.MDSID() ) |
| | | |
| | | if( not isnull( scenario ) ) |
| | | { |
| | | DataHolderActiveScenario.Data( scenario ); |
| | | DataHolderMacroPlanner.Data( MacroPlan ); |
| | | } |
| | | } |
| | | } |
| | | // Sync user and roles ( sync during fresh startup without scenario creation ) |
| | | if( not isnull( SWF_WorkflowDataset ) ) |
| | | { |
| | | SWF_WorkflowDataset.OnUserLogin(); |
| | | } |
| | | |
| | | mdsidkey := RecycleBin::OnLogin(); |
| | | |
| | | componentmds := ApplicationScope.ComponentMDS(); |
| | | mdsinstance := select( componentmds, ComponentMDSKinds.ComponentMDSInstances, m, m.MDSID().MDSKey() = mdsidkey ); |
| | | if ( not isnull( mdsinstance ) and not mdsinstance.IsSelected() ) { |
| | | mdsinstance.ComponentMDSKind().SelectInstance( mdsinstance ); |
| | | componentmds.Apply(); |
| | | } |
| | | |
| | | DataHolderCurrentUser.Data( QuintiqUser::CurrentUser().ShortName() ); |
| | | // Also open a default view |
| | | ApplicationMacroPlanner.OpenView( 'Scenarios', ButtonScenarios1 ); |
| | | *] |
| | | } |
| | |
| | | { |
| | | Body: |
| | | [* |
| | | Test::Test( ScenarioManager,MacroPlan,Archive ); |
| | | Test::Test( ScenarioManager,MacroPlan,Archive,RecycleBin ); |
| | | |
| | | WebMessageBox::Success( "Success"); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: ActionBarGroupPlanViews/ButtonShiftPlan |
| | | Response OnClick () id:Response_MacroPlanner_ActionBarGroupPlanViews_ButtonShiftPlan_OnClick |
| | | { |
| | | #keys: '[412672.0.1067373094]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | GroupServerCalls: true |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | ApplicationMacroPlanner.OpenView( 'ShiftPlan', this ); |
| | | *] |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: ActionBarGroupScenarioComparisonViews/ButtonScenarioComparisonDemandComparison |
| | | Response OnClick () id:Response_MacroPlanner_ActionBarGroupScenarioComparisonViews_ButtonScenarioComparisonDemandComparison_OnClick |
| | | { |
| | | #keys: '[412672.0.1090347405]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | // Open view |
| | | ApplicationMacroPlanner.OpenView( 'DemandComparison', this ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: abgSecondDevelopmentPlan/bTransferPlan |
| | | Response OnClick () id:Response_MacroPlanner_abgSecondDevelopmentPlan_bTransferPlan_OnClick |
| | | { |
| | | #keys: '[413988.0.1290322113]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | GroupServerCalls: true |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | ApplicationScope.ViewManager().ResetUserViewById( "TransferPlan", true); |
| | | *] |
| | | } |
| | | } |
| | |
| | | #child: applicationFixedPageActionBarPageDef |
| | | #child: applicationDevelopmentActionBarPageDef_1 |
| | | #child: abpAlgorithmPostProcessing |
| | | #child: ActionBarPagePlan |
| | | #child: ActionBarPageReport |
| | | #child: ActionBarPageScenarioComparison |
| | | ] |
| | | } |
| | | Component dhBinaryDataPR id:dhBinaryDataPR_688 |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component pnlActions |
| | | { |
| | | #keys: '[413988.0.1292313213]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | Component btnOk |
| | | { |
| | | #keys: '[413988.0.1292313217]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Label: 'OK' |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | Component btnCancel |
| | | { |
| | | #keys: '[413988.0.1292313219]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Label: 'Cancel' |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Alignment: 'trailing' |
| | | Border: true |
| | | ExcludeFromActiveComponent: true |
| | | FixedSize: true |
| | | Orientation: 'horizontal' |
| | | Padding: 'true' |
| | | Style: 'footer' |
| | | Taborder: 1 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component pnlContent |
| | | { |
| | | #keys: '[413988.0.1292313211]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | Component npUpperLimitOfTransferCapacityZKG |
| | | { |
| | | #keys: '[413988.0.1292313261]' |
| | | BaseType: 'WebNumberPicker' |
| | | Properties: |
| | | [ |
| | | Label: 'ZKG(pcs)' |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | Component npUpperLimitOfTransferCapacityZKM |
| | | { |
| | | #keys: '[413988.0.1292313339]' |
| | | BaseType: 'WebNumberPicker' |
| | | Properties: |
| | | [ |
| | | Label: 'ZKM(pcs)' |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | | Component npUpperLimitOfTransferCapacityPL |
| | | { |
| | | #keys: '[413988.0.1292313341]' |
| | | BaseType: 'WebNumberPicker' |
| | | Properties: |
| | | [ |
| | | Label: 'PL(pcs)' |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | Component npUpperLimitOfTransferCapacityKW |
| | | { |
| | | #keys: '[413988.0.1292313343]' |
| | | BaseType: 'WebNumberPicker' |
| | | Properties: |
| | | [ |
| | | Label: 'KW(pcs)' |
| | | Taborder: 3 |
| | | ] |
| | | } |
| | | Component npUpperLimitOfTransferCapacityAGW |
| | | { |
| | | #keys: '[413988.0.1292313345]' |
| | | BaseType: 'WebNumberPicker' |
| | | Properties: |
| | | [ |
| | | Label: 'AGW(pcs)' |
| | | Taborder: 4 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Padding: 'true' |
| | | Taborder: 0 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: pnlActions/btnCancel |
| | | Response OnClick () id:Response_pnlActions_btnCancel_OnClick |
| | | { |
| | | #keys: '[413988.0.1292313223]' |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | GroupServerCalls: true |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | Form.Close(); |
| | | *] |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: pnlActions/btnOk |
| | | Response OnClick () id:Response_pnlActions_btnOk_OnClick |
| | | { |
| | | #keys: '[413988.0.1292313222]' |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | GroupServerCalls: true |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | Form.ApplyChanges(); |
| | | Form.Close(); |
| | | *] |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #root |
| | | #parent: MacroPlannerWebApp |
| | | OrphanComponent DialogUpperLimitOfTransferCapacity |
| | | { |
| | | #keys: '[413988.0.1292313209]' |
| | | BaseType: 'WebForm' |
| | | Children: |
| | | [ |
| | | #child: pnlContent |
| | | #child: pnlActions |
| | | ] |
| | | Properties: |
| | | [ |
| | | Alignment: 'trailing' |
| | | EnterButton: 'btnOk' |
| | | EscapeButton: 'btnCancel' |
| | | ExcludeFromActiveComponent: true |
| | | Padding: 'false' |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component MatrixEditorTimeCapacities id:MatrixEditorTimeCapacities_656 |
| | | { |
| | | #keys: '[412672.0.1064460829]' |
| | | BaseType: 'WebMatrixEditor' |
| | | Children: |
| | | [ |
| | | Component MatrixEditorCellUnitPeriodTime |
| | | { |
| | | #keys: '[412672.0.1064460830]' |
| | | BaseType: 'WebMatrixEditorCell' |
| | | Children: |
| | | [ |
| | | Component DataExtractorUnitPeriodTime |
| | | { |
| | | #keys: '[412672.0.1064460831]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'structured[Unit]' |
| | | Source: 'ApplicationMacroPlanner.DataHolderUnit' |
| | | Taborder: 0 |
| | | Transformation: 'Elements.UnitPeriod.astype(UnitPeriodTime).ShiftPlan' |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Attributes: 'Outcome;Remark' |
| | | Column: 'UnitPeriodTime.Period_MP' |
| | | Row: 'UnitPeriodTime.Unit' |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | Component MatrixEditorRowsUnit |
| | | { |
| | | #keys: '[412672.0.1064460832]' |
| | | BaseType: 'WebMatrixEditorHeaderLevel' |
| | | Children: |
| | | [ |
| | | Component DataExtractorUnit |
| | | { |
| | | #keys: '[412672.0.1064460833]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'structured[Unit]' |
| | | FixedFilter: 'object.HasCapacityTypeTime()' |
| | | Source: 'ApplicationMacroPlanner.DataHolderUnit' |
| | | Taborder: 0 |
| | | Transformation: 'Elements.astype(Unit)' |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Legend: 'Name' |
| | | SortCriteria: 'DisplayIndex' |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | | Component MatrixEditorColumnsPeriod |
| | | { |
| | | #keys: '[412672.0.1064460834]' |
| | | BaseType: 'WebMatrixEditorHeaderLevel' |
| | | Children: |
| | | [ |
| | | Component DataExtractorPeriod |
| | | { |
| | | #keys: '[412672.0.1064460835]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'structured[Period_MP]' |
| | | Source: 'ApplicationMacroPlanner.DataHolderPeriods' |
| | | Taborder: 0 |
| | | Transformation: 'Elements' |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Legend: 'StartDate' |
| | | SortCriteria: 'StartDate' |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | #child: matrixEditorActionBarPageTime_1 |
| | | #child: matrixeditorContextMenuTime_1 |
| | | ] |
| | | Properties: |
| | | [ |
| | | AllowAttributeConfiguration: true |
| | | AllowMultipleAttributes: true |
| | | Columns: 'MatrixEditorColumnsPeriod' |
| | | ContextMenu: 'matrixeditorContextMenuTime' |
| | | Rows: 'MatrixEditorRowsUnit' |
| | | ShowSingleAttribute: true |
| | | Taborder: 1 |
| | | ] |
| | | ResponseDefinitions: |
| | | [ |
| | | DelegatedResponseDefinition OnClick id:Responsedef_MatrixEditorTimeCapacities_656_WebMenu_OnClick |
| | | { |
| | | #keys: '[412672.0.1064460817]' |
| | | Initiator: 'WebMenu' |
| | | IsInherited: false |
| | | ResponseType: 'OnClick' |
| | | Arguments: |
| | | [ |
| | | ResponseDefinitionArgument selection |
| | | { |
| | | #keys: '[4387.0.17266428]' |
| | | Binding: 'this.Selection()' |
| | | } |
| | | ] |
| | | } |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelMatrix id:PanelMatrix_675 |
| | | { |
| | | #keys: '[412672.0.1064460828]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | #child: MatrixEditorTimeCapacities_656 |
| | | #child: pOperation |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 0 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component matrixEditorActionBarPageTime id:matrixEditorActionBarPageTime_1 |
| | | { |
| | | #keys: '[412672.0.1064460836]' |
| | | BaseType: 'matrixEditorActionBarPage' |
| | | Properties: |
| | | [ |
| | | Taborder: 3 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component matrixeditorContextMenuTime id:matrixeditorContextMenuTime_1 |
| | | { |
| | | #keys: '[412672.0.1064460837]' |
| | | BaseType: 'matrixeditorContextMenu' |
| | | Children: |
| | | [ |
| | | Component MenuCopy |
| | | { |
| | | #keys: '[138034.3.1296123318]' |
| | | BaseType: 'MenuCopy' |
| | | IsDerived: true |
| | | Properties: |
| | | [ |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | Component MenuSeparator |
| | | { |
| | | #keys: '[412672.0.1064460838]' |
| | | BaseType: 'WebMenu' |
| | | Properties: |
| | | [ |
| | | Separator: true |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 4 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component pOperation |
| | | { |
| | | #keys: '[412672.0.1084334216]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | Component bExport id:bExport_187 |
| | | { |
| | | #keys: '[412672.0.1084305542]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Image: 'EXPORT1' |
| | | Label: '导åº' |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | Component bDownload id:bDownload_774 |
| | | { |
| | | #keys: '[412672.0.1084305565]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Image: 'DOWNLOAD' |
| | | Label: 'ä¸è½½' |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | | Component dhXMLDataListener |
| | | { |
| | | #keys: '[412672.0.1084305593]' |
| | | BaseType: 'WebDataHolder' |
| | | Databinding: 'ExportXMLManager' |
| | | Children: |
| | | [ |
| | | Component DataExtractor510 |
| | | { |
| | | #keys: '[412672.0.1084305608]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'RecycleBin' |
| | | FixedFilter: 'object.Name() = "ShiftPlanXML"' |
| | | Source: 'RecycleBin' |
| | | Taborder: 0 |
| | | Transformation: 'ExportXMLManager' |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | FixedSize: true |
| | | Orientation: 'horizontal' |
| | | Taborder: 0 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: MatrixEditorTimeCapacities_656 |
| | | Response OnUpdateValue ( |
| | | ShiftPlan cell, |
| | | String value, |
| | | String oldvalue |
| | | ) id:Response_MatrixEditorTimeCapacities_656_OnUpdateValue_317 |
| | | { |
| | | #keys: '[412672.0.1064460818]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebMatrixEditor_OnUpdateValue' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | cell.SetRemark( value ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: pOperation/bDownload_774 |
| | | Response OnClick () id:Response_pOperation_bDownload_OnClick |
| | | { |
| | | #keys: '[412672.0.1084305701]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | Precondition: |
| | | [* |
| | | flag := true; |
| | | feedback := ""; |
| | | if( isnull( dhXMLDataListener.Data() )){ |
| | | flag := false; |
| | | feedback := "å½åæ ä¸è½½æ°æ®ï¼ç¹å»å¯¼åºå建ä¸è½½æ°æ®ã" |
| | | } |
| | | return flag; |
| | | *] |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | binaryValue := dhXMLDataListener.Data( ).Export(); |
| | | |
| | | Application.Download( "çæ¬¡è®¡å_" + DateTime::Now().Format( "YM2D2H2mmss" ) + ".xlsx", binaryValue.AsBinaryData() ); |
| | | |
| | | dhXMLDataListener.Data( ).Delete(); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: pOperation/bExport_187 |
| | | Response OnClick () id:Response_pOperation_bExport_OnClick |
| | | { |
| | | #keys: '[412672.0.1083032516]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | rows := selectset( DataHolderUnit.Data(),Elements,unit,unit.HasCapacityTypeTime() ); |
| | | columns := DataHolderPeriods.Data( ); |
| | | ShiftPlan::AsyncExport( RecycleBin, rows, columns ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #root |
| | | #parent: MacroPlannerWebApp |
| | | OrphanComponent FormShihtPlan |
| | | { |
| | | #keys: '[412672.0.1064470671]' |
| | | BaseType: 'WebForm' |
| | | Children: |
| | | [ |
| | | #child: PanelMatrix_675 |
| | | ] |
| | | Properties: |
| | | [ |
| | | Image: 'COMPASSES' |
| | | Title: 'çæ¬¡è®¡å' |
| | | ] |
| | | } |
| | |
| | | |
| | | webFileBinaryData := BinaryData::FromBase64EncodedString( base64String ).AsBinaryValue(); |
| | | |
| | | generalExcelImportAndExportDataSource := GeneralExcelImportAndExportDataSource::Upload( Archive, webFileBinaryData, fileName ); |
| | | generalExcelImportAndExportDataSource := GeneralExcelImportAndExportDataSource::Upload( RecycleBin, webFileBinaryData, fileName ); |
| | | generalExcelImportAndExportDataSource.ReadStructure(); |
| | | |
| | | selection := select( generalExcelImportAndExportDataSource, GeneralExcelImportAndExportDataTable, tempGEIAEDT, tempGEIAEDT.Name() = "Sheet1" ); |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component MatrixEditor |
| | | { |
| | | #keys: '[412672.0.1085881196]' |
| | | BaseType: 'WebMatrixEditor' |
| | | Children: |
| | | [ |
| | | Component MatrixEditorCell |
| | | { |
| | | #keys: '[412672.0.1085881197]' |
| | | BaseType: 'WebMatrixEditorCell' |
| | | Children: |
| | | [ |
| | | Component DataExtractorCells |
| | | { |
| | | #keys: '[412672.0.1085881198]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'LocalTable' |
| | | Source: 'dhComparisonData' |
| | | Taborder: 0 |
| | | Transformation: 'LocalRow.LocalCell.astype(LocalCell_DemandComparison)' |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Attributes: 'BaseVersionValue;CompareVersionValue;BaseVersion;CompareVersion;Gap' |
| | | Column: 'LocalColumn' |
| | | Row: 'LocalRow' |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | Component MatrixEditorRows |
| | | { |
| | | #keys: '[412672.0.1085881201]' |
| | | BaseType: 'WebMatrixEditorHeaderLevel' |
| | | Children: |
| | | [ |
| | | Component DataExtractorRows |
| | | { |
| | | #keys: '[412672.0.1085881202]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'LocalTable' |
| | | Source: 'dhComparisonData' |
| | | Taborder: 0 |
| | | Transformation: 'LocalRow' |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Legend: 'Name' |
| | | SortCriteria: 'Index' |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | | Component MatrixEditorColumns |
| | | { |
| | | #keys: '[412672.0.1085881205]' |
| | | BaseType: 'WebMatrixEditorHeaderLevel' |
| | | Children: |
| | | [ |
| | | Component DataExtractorColumns |
| | | { |
| | | #keys: '[412672.0.1085881206]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'LocalTable' |
| | | Source: 'dhComparisonData' |
| | | Taborder: 0 |
| | | Transformation: 'LocalColumn' |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Legend: 'Name' |
| | | SortCriteria: 'Index' |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | #child: matrixEditorActionBarPageDemandComparison |
| | | #child: matrixeditorContextMenuDemandComparison |
| | | ] |
| | | Properties: |
| | | [ |
| | | AllowMultipleAttributes: true |
| | | Columns: 'MatrixEditorColumns' |
| | | ContextMenu: 'matrixeditorContextMenuDemandComparison' |
| | | Rows: 'MatrixEditorRows' |
| | | Taborder: 0 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelDemandComparison |
| | | { |
| | | #keys: '[412672.0.1085881181]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | #child: MatrixEditor |
| | | Component dhComparisonData |
| | | { |
| | | #keys: '[412672.0.1085881305]' |
| | | BaseType: 'WebDataHolder' |
| | | Databinding: 'LocalTable' |
| | | Properties: |
| | | [ |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 1 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelOperation |
| | | { |
| | | #keys: '[412672.0.1085881251]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | #child: PanelOperation11 |
| | | Component ButtonCompare |
| | | { |
| | | #keys: '[412672.0.1085802121]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Label: 'å¼å§å¯¹æ¯' |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | | #child: pOperation_715 |
| | | ] |
| | | Properties: |
| | | [ |
| | | FixedSize: true |
| | | Orientation: 'horizontal' |
| | | Taborder: 0 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component PanelOperation11 |
| | | { |
| | | #keys: '[412672.0.1085801711]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | Component DropDownListCompareVersion id:DropDownListCompareVersion_85 |
| | | { |
| | | #keys: '[412672.0.1085801792]' |
| | | BaseType: 'WebDropDownList' |
| | | Databinding: 'ArchivePR' |
| | | Children: |
| | | [ |
| | | Component DataExtractorOperation876 id:DataExtractorOperation876_293 |
| | | { |
| | | #keys: '[412672.0.1085801793]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'Archive' |
| | | FilterArguments: 'baseSelection:QMacroPlanner::FormDemandComparison.dhBaseVersion' |
| | | FixedFilter: 'object <> baseSelection' |
| | | Source: 'Archive' |
| | | Taborder: 0 |
| | | Transformation: 'ArchivePR' |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | DisplayField: 'Name' |
| | | Label: '对æ¯éæ±çæ¬ï¼' |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | Component dhBaseVersion id:dhBaseVersion_357 |
| | | { |
| | | #keys: '[412672.0.1085801820]' |
| | | BaseType: 'WebDataHolder' |
| | | Databinding: 'ArchivePR' |
| | | Properties: |
| | | [ |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | | Component DropDownListBaseVersion id:DropDownListBaseVersion_668 |
| | | { |
| | | #keys: '[412672.0.1085801851]' |
| | | BaseType: 'WebDropDownList' |
| | | Databinding: 'ArchivePR' |
| | | Children: |
| | | [ |
| | | Component DataExtractorOperation id:DataExtractorOperation_669 |
| | | { |
| | | #keys: '[412672.0.1085801852]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'Archive' |
| | | Source: 'Archive' |
| | | Taborder: 0 |
| | | Transformation: 'ArchivePR' |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | DisplayField: 'Name' |
| | | Label: 'åºåéæ±çæ¬ï¼' |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | FixedSize: true |
| | | Orientation: 'horizontal' |
| | | Taborder: 0 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component matrixEditorActionBarPageDemandComparison |
| | | { |
| | | #keys: '[412672.0.1085881209]' |
| | | BaseType: 'matrixEditorActionBarPage' |
| | | Properties: |
| | | [ |
| | | Taborder: 3 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component matrixeditorContextMenuDemandComparison |
| | | { |
| | | #keys: '[412672.0.1085881212]' |
| | | BaseType: 'matrixeditorContextMenu' |
| | | Properties: |
| | | [ |
| | | Taborder: 4 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component pOperation id:pOperation_715 |
| | | { |
| | | #keys: '[412672.0.1092111928]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | Component bExport |
| | | { |
| | | #keys: '[412672.0.1092111929]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Image: 'EXPORT1' |
| | | Label: '导åº' |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | Component bDownload |
| | | { |
| | | #keys: '[412672.0.1092111930]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Image: 'DOWNLOAD' |
| | | Label: 'ä¸è½½' |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | | Component dhXMLDataListener |
| | | { |
| | | #keys: '[412672.0.1092111931]' |
| | | BaseType: 'WebDataHolder' |
| | | Databinding: 'ExportXMLManager' |
| | | Children: |
| | | [ |
| | | Component DataExtractor510 |
| | | { |
| | | #keys: '[412672.0.1092111932]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'RecycleBin' |
| | | FixedFilter: 'object.Name() = "LocalTableXML"' |
| | | Source: 'RecycleBin' |
| | | Taborder: 0 |
| | | Transformation: 'ExportXMLManager' |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | FixedSize: true |
| | | Orientation: 'horizontal' |
| | | Taborder: 2 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: PanelDemandComparison/dhComparisonData |
| | | Response OnDataChanged () id:Response_PanelDemandComparison_dhComparisonData_OnDataChanged |
| | | { |
| | | #keys: '[412672.0.1093351461]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebComponent_OnDataChanged' |
| | | GroupServerCalls: true |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | PanelDemandComparison.Title( this.Data().Name() ); |
| | | *] |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: PanelOperation11/DropDownListBaseVersion_668 |
| | | Response OnSelectionChanged ( |
| | | ArchivePR selection |
| | | ) id:Response_PanelOperation11_DropDownListBaseVersion_OnSelectionChanged_168 |
| | | { |
| | | #keys: '[412672.0.1085801849]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebDropDownList_OnSelectionChanged' |
| | | GroupServerCalls: true |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | dhBaseVersion.Data( selection ); |
| | | this.Tooltip( selection.Name() ); |
| | | *] |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: PanelOperation11/DropDownListCompareVersion_85 |
| | | Response OnSelectionChanged ( |
| | | ArchivePR selection |
| | | ) id:Response_PanelOperation11_DropDownListCompareVersion_OnSelectionChanged |
| | | { |
| | | #keys: '[412672.0.1093350988]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebDropDownList_OnSelectionChanged' |
| | | GroupServerCalls: true |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | this.Tooltip( selection.Name() ); |
| | | *] |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: PanelOperation/ButtonCompare |
| | | Response OnClick () id:Response_PanelOperation_ButtonCompare_OnClick |
| | | { |
| | | #keys: '[412672.0.1085802211]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | table := ArchivePR::Compared( RecycleBin,DropDownListBaseVersion.Data(),DropDownListCompareVersion.Data() ); |
| | | dhComparisonData.Data( table ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: pOperation_715/bDownload |
| | | Response OnClick () id:Response_pOperation_715_bDownload_OnClick |
| | | { |
| | | #keys: '[412672.0.1092111926]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | Precondition: |
| | | [* |
| | | flag := true; |
| | | feedback := ""; |
| | | if( isnull( dhXMLDataListener.Data() )){ |
| | | flag := false; |
| | | feedback := "å½åæ ä¸è½½æ°æ®ï¼ç¹å»å¯¼åºå建ä¸è½½æ°æ®ã" |
| | | } |
| | | return flag; |
| | | *] |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | binaryValue := dhXMLDataListener.Data( ).Export(); |
| | | |
| | | Application.Download( "éæ±çæ¬å¯¹æ¯_" + DateTime::Now().Format( "YM2D2H2mmss" ) + ".xlsx", binaryValue.AsBinaryData() ); |
| | | |
| | | dhXMLDataListener.Data( ).Delete(); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: pOperation_715/bExport |
| | | Response OnClick () id:Response_pOperation_715_bExport_OnClick |
| | | { |
| | | #keys: '[412672.0.1092111927]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | rows := selectset( dhComparisonData.Data(),LocalRow,row,true ); |
| | | columns := selectset( dhComparisonData.Data( ),LocalColumn,column,true ); |
| | | LocalCell_DemandComparison::AsyncExport( RecycleBin, rows, columns ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #root |
| | | #parent: MacroPlannerWebApp |
| | | OrphanComponent FormDemandComparison |
| | | { |
| | | #keys: '[412672.0.1085881113]' |
| | | BaseType: 'WebForm' |
| | | Children: |
| | | [ |
| | | #child: PanelDemandComparison |
| | | #child: PanelOperation |
| | | ] |
| | | Properties: |
| | | [ |
| | | Image: 'EQUALS' |
| | | Title: '鿱坹æ¯' |
| | | ] |
| | | } |
| | |
| | | |
| | | webFileBinaryData := BinaryData::FromBase64EncodedString( base64String ).AsBinaryValue(); |
| | | |
| | | generalExcelImportAndExportDataSource := GeneralExcelImportAndExportDataSource::Upload( Archive, webFileBinaryData, fileName ); |
| | | generalExcelImportAndExportDataSource := GeneralExcelImportAndExportDataSource::Upload( RecycleBin, webFileBinaryData, fileName ); |
| | | generalExcelImportAndExportDataSource.ReadStructure(); |
| | | |
| | | selection := select( generalExcelImportAndExportDataSource, GeneralExcelImportAndExportDataTable, tempGEIAEDT, tempGEIAEDT.Name() = "Sheet1" ); |
| | |
| | | |
| | | webFileBinaryData := BinaryData::FromBase64EncodedString( base64String ).AsBinaryValue(); |
| | | |
| | | generalExcelImportAndExportDataSource := GeneralExcelImportAndExportDataSource::Upload( Archive, webFileBinaryData, fileName ); |
| | | generalExcelImportAndExportDataSource := GeneralExcelImportAndExportDataSource::Upload( RecycleBin, webFileBinaryData, fileName ); |
| | | generalExcelImportAndExportDataSource.ReadStructure(); |
| | | |
| | | selection := select( generalExcelImportAndExportDataSource, GeneralExcelImportAndExportDataTable, tempGEIAEDT, tempGEIAEDT.Name() = "Sheet1" ); |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component MatrixEditor872 |
| | | { |
| | | #keys: '[413988.0.1290322866]' |
| | | BaseType: 'WebMatrixEditor' |
| | | Children: |
| | | [ |
| | | Component MatrixEditorCell590 |
| | | { |
| | | #keys: '[413988.0.1290322867]' |
| | | BaseType: 'WebMatrixEditorCell' |
| | | Children: |
| | | [ |
| | | Component DataExtractor862 |
| | | { |
| | | #keys: '[413988.0.1290322868]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'MacroPlan' |
| | | Source: 'MacroPlan' |
| | | Taborder: 0 |
| | | Transformation: 'TransferPlanColumn.TransferPlanCell' |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Attributes: 'Value' |
| | | Column: 'TransferPlanColumn' |
| | | Row: 'TransferPlanRow' |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | Component MatrixEditorRows481 |
| | | { |
| | | #keys: '[413988.0.1290322871]' |
| | | BaseType: 'WebMatrixEditorHeaderLevel' |
| | | Children: |
| | | [ |
| | | Component DataExtractor661 |
| | | { |
| | | #keys: '[413988.0.1290322872]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'MacroPlan' |
| | | Source: 'MacroPlan' |
| | | Taborder: 0 |
| | | Transformation: 'TransferPlanRow' |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Legend: 'Name' |
| | | SortCriteria: 'SourceStockpoingPointID;TargetStockpoingPointID;ProductID' |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | | Component MatrixEditorColumns681 |
| | | { |
| | | #keys: '[413988.0.1290322875]' |
| | | BaseType: 'WebMatrixEditorHeaderLevel' |
| | | Children: |
| | | [ |
| | | Component DataExtractor445 |
| | | { |
| | | #keys: '[413988.0.1290322876]' |
| | | BaseType: 'WebDataExtractor' |
| | | Properties: |
| | | [ |
| | | DataType: 'MacroPlan' |
| | | Source: 'MacroPlan' |
| | | Taborder: 0 |
| | | Transformation: 'TransferPlanColumn' |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Legend: 'ColumnName' |
| | | SortCriteria: 'ColumnDate' |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | #child: matrixEditorActionBarPage493 |
| | | #child: matrixeditorContextMenu367 |
| | | ] |
| | | Properties: |
| | | [ |
| | | Columns: 'MatrixEditorColumns681' |
| | | ContextMenu: 'matrixeditorContextMenu367' |
| | | Rows: 'MatrixEditorRows481' |
| | | Taborder: 0 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component matrixEditorActionBarPage493 |
| | | { |
| | | #keys: '[413988.0.1290322879]' |
| | | BaseType: 'matrixEditorActionBarPage' |
| | | Properties: |
| | | [ |
| | | Taborder: 3 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component matrixeditorContextMenu367 |
| | | { |
| | | #keys: '[413988.0.1290322882]' |
| | | BaseType: 'matrixeditorContextMenu' |
| | | Properties: |
| | | [ |
| | | Taborder: 4 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component pContent |
| | | { |
| | | #keys: '[413988.0.1290370837]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | #child: MatrixEditor872 |
| | | ] |
| | | Properties: |
| | | [ |
| | | Taborder: 1 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | Component pHeader |
| | | { |
| | | #keys: '[413988.0.1290370823]' |
| | | BaseType: 'WebPanel' |
| | | Children: |
| | | [ |
| | | Component bDownload |
| | | { |
| | | #keys: '[413988.0.1290361218]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Label: 'Download' |
| | | Taborder: 0 |
| | | ] |
| | | } |
| | | Component bMaximumDailyTransferCapacity |
| | | { |
| | | #keys: '[413988.0.1290361230]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Label: 'Maximum daily transfer capacity' |
| | | Taborder: 1 |
| | | ] |
| | | } |
| | | Component bGenerateReport |
| | | { |
| | | #keys: '[413988.0.1292223250]' |
| | | BaseType: 'WebButton' |
| | | Properties: |
| | | [ |
| | | Label: 'Generate report' |
| | | Taborder: 2 |
| | | ] |
| | | } |
| | | ] |
| | | Properties: |
| | | [ |
| | | Border: true |
| | | FixedSize: true |
| | | Orientation: 'horizontal' |
| | | Taborder: 0 |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: pHeader/bDownload |
| | | Response OnClick () id:Response_pHeader_bDownload_OnClick |
| | | { |
| | | #keys: '[413988.0.1292330526]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | QuillAction |
| | | { |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: pHeader/bGenerateReport |
| | | Response OnClick () id:Response_pHeader_bGenerateReport_OnClick |
| | | { |
| | | #keys: '[413988.0.1292330696]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | Precondition: |
| | | [* |
| | | return not isnull( MacroPlan ); |
| | | *] |
| | | QuillAction |
| | | { |
| | | Body: |
| | | [* |
| | | TransferPlanCell::GenerateReport( MacroPlan ); |
| | | |
| | | WebMessageBox::Success( Translations::A_VWED_Success() ); |
| | | *] |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #parent: pHeader/bMaximumDailyTransferCapacity |
| | | Response OnClick () id:Response_pHeader_bMaximumDailyTransferCapacity_OnClick |
| | | { |
| | | #keys: '[413988.0.1292330611]' |
| | | CanBindMultiple: false |
| | | DefinitionID: 'Responsedef_WebButton_OnClick' |
| | | QuillAction |
| | | { |
| | | GroupServerCalls: false |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | #root |
| | | #parent: MacroPlannerWebApp |
| | | OrphanComponent FormTransferPlan |
| | | { |
| | | #keys: '[413988.0.1290321873]' |
| | | BaseType: 'WebForm' |
| | | Children: |
| | | [ |
| | | #child: pContent |
| | | #child: pHeader |
| | | ] |
| | | Properties: |
| | | [ |
| | | Image: 'HAND_TRUCK_BOX' |
| | | Title: 'Transfer plan' |
| | | ] |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | { |
| | | viewcontents |
| | | { |
| | | page: '' |
| | | group: '' |
| | | index: 0 |
| | | image: 'EQUALS' |
| | | description: '' |
| | | } |
| | | formatversion: 2 |
| | | id: 'DemandComparison' |
| | | name: 'DemandComparison' |
| | | isglobal: false |
| | | isroot: true |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | { |
| | | viewcontents |
| | | { |
| | | page: '' |
| | | group: '' |
| | | index: 0 |
| | | image: 'COMPASSES' |
| | | description: '' |
| | | } |
| | | formatversion: 2 |
| | | id: 'ShiftPlan' |
| | | name: 'ShiftPlan' |
| | | isglobal: false |
| | | isroot: true |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | Quintiq file version 2.0 |
| | | { |
| | | viewcontents |
| | | { |
| | | forms |
| | | { |
| | | form_FormTransferPlan |
| | | { |
| | | title: 'QMacroPlanner::FormTransferPlan' |
| | | shown: true |
| | | componentID: 'QMacroPlanner::FormTransferPlan' |
| | | layout |
| | | { |
| | | mode: 'open' |
| | | rowPosition: 1 |
| | | rowSpan: 14 |
| | | columnPosition: 1 |
| | | columnSpan: 12 |
| | | } |
| | | components: null |
| | | } |
| | | form_FormOptimizerPuzzles |
| | | { |
| | | title: 'Optimizer Puzzles' |
| | | shown: false |
| | | componentID: 'FormOptimizerPuzzles' |
| | | layout |
| | | { |
| | | mode: 'dockright' |
| | | index: 0 |
| | | } |
| | | components |
| | | { |
| | | FormOptimizerPuzzles_ListOptimizerPuzzles |
| | | { |
| | | } |
| | | FormOptimizerPuzzles_DataSetLevelOptimizerPuzzles |
| | | { |
| | | groupDepth: -1 |
| | | column_All_constraints |
| | | { |
| | | columnId: 'All constraints' |
| | | dataPath: 'All constraints' |
| | | dataType: 'string' |
| | | title: 'All constraints' |
| | | index: 0 |
| | | subtotals: '' |
| | | width: 32 |
| | | } |
| | | column_Name |
| | | { |
| | | columnId: 'Name' |
| | | dataPath: 'Name' |
| | | dataType: 'string' |
| | | title: 'Name' |
| | | index: 1 |
| | | subtotals: '' |
| | | width: 109 |
| | | } |
| | | column_Description |
| | | { |
| | | columnId: 'Description' |
| | | dataPath: 'Description' |
| | | dataType: 'string' |
| | | title: 'Description' |
| | | index: 2 |
| | | subtotals: '' |
| | | width: 207 |
| | | } |
| | | } |
| | | } |
| | | } |
| | | form_FormKPI |
| | | { |
| | | title: 'KPI Dashboard' |
| | | shown: true |
| | | componentID: 'FormKPI' |
| | | layout |
| | | { |
| | | mode: 'dockright' |
| | | index: 1 |
| | | } |
| | | components |
| | | { |
| | | FormKPI_PanelKPI |
| | | { |
| | | sizeRatio: 1 |
| | | activeChild: 'PanelKPISelection' |
| | | } |
| | | FormKPI_PanelKPIDashboard |
| | | { |
| | | sizeRatio: 1 |
| | | } |
| | | FormKPI_PanelKPISelection |
| | | { |
| | | sizeRatio: 1 |
| | | } |
| | | FormKPI_ListKPISelection |
| | | { |
| | | QuillViewData |
| | | { |
| | | Food_KPISetting: 'Cost of sales;Fulfillment;Fulfillment target;Inventory holding cost;Labor cost;Margin;Safety stock;Sales;Sourcing cost;Total CO2 emission;Transportation cost;Volume' |
| | | } |
| | | } |
| | | FormKPI_DataSetLevelKPISelection |
| | | { |
| | | groupDepth: -1 |
| | | column_All_constraints |
| | | { |
| | | columnId: 'All constraints' |
| | | dataPath: 'All constraints' |
| | | dataType: 'string' |
| | | title: 'All constraints' |
| | | index: 0 |
| | | subtotals: '' |
| | | width: 32 |
| | | } |
| | | column_Name |
| | | { |
| | | columnId: 'Name' |
| | | dataPath: 'Name' |
| | | dataType: 'string' |
| | | title: 'Name' |
| | | index: 1 |
| | | subtotals: '' |
| | | width: 200 |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | userconfigurableinformation |
| | | { |
| | | } |
| | | page: '' |
| | | group: '' |
| | | index: 0 |
| | | image: 'WALLET_OPEN' |
| | | description: '' |
| | | } |
| | | formatversion: 2 |
| | | id: 'TransferPlan' |
| | | name: 'TransferPlan' |
| | | isglobal: false |
| | | isroot: true |
| | | } |