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 );
|
}
|
}
|
*]
|
}
|
