| | |
| | | [* |
| | | // 甄兰鸽 Jun-25-2024 (created) |
| | | info( '-----------Search start-------' ); |
| | | table := selectobject( this,InterfaceDataset.CustomerDemandIDS, report, not report.IsShow() ); |
| | | //清空之前存储的显示数据 |
| | | idscolumns := selectuniquevalues( table, Column, idscolumn, idscolumn.TimeUnit() = search.TimeUnit() and idscolumn.StartDate() >= search.StartDate() and idscolumn.StartDate() <= search.EndDate(), idscolumn.StartDate() ); |
| | | this.Clear( idscolumns ); |
| | | traverse( table, Row, row, ( search.Unit() = FinancialProductionReport::GetDefaultAllUnit() or row.Factory() = search.Unit() ) |
| | | and ( products.Size() = 0 or products.Find( row.Name() ) > -1 ) ){ |
| | | |
| | | showrow := selectobject( this, Row, showrow, showrow.Name() = row.Name() and showrow.Factory() = search.Unit() ); |
| | | if( isnull( showrow ) ){ |
| | | showrow := this.Row( relnew, Name := row.Name(), Factory := search.Unit() ); |
| | | } |
| | | traverse( row, Cell, cell, cell.Column().TimeUnit() = search.TimeUnit() ){ |
| | | column := selectobject( this, Column, column, column.Name() = cell.Column().Name() ); |
| | | if( not isnull( column ) ){ |
| | | showcell := selectobject( showrow, Cell, showcell, showcell.Column() = column ); |
| | | if( isnull( showcell ) ){ |
| | | showcell := column.Cell( relnew, Value := '' ); |
| | | showrow.Cell( relinsert, showcell ); |
| | | } |
| | | showcell.Value( [String]( [Number]cell.Value() + [Number]showcell.Value() ) ); |
| | | } |
| | | } |
| | | } |
| | | //table := selectobject( this,InterfaceDataset.CustomerDemandIDS, report, not report.IsShow() ); |
| | | ////清空之前存储的显示数据 |
| | | //idscolumns := selectuniquevalues( table, Column, idscolumn, idscolumn.TimeUnit() = search.TimeUnit() and idscolumn.StartDate() >= search.StartDate() and idscolumn.StartDate() <= search.EndDate(), idscolumn.StartDate() ); |
| | | //this.Clear( idscolumns ); |
| | | //traverse( table, Row, row, ( search.Unit() = FinancialProductionReport::GetDefaultAllUnit() or row.Factory() = search.Unit() ) |
| | | // and ( products.Size() = 0 or products.Find( row.Name() ) > -1 ) ){ |
| | | // |
| | | // showrow := selectobject( this, Row, showrow, showrow.Name() = row.Name() and showrow.Factory() = search.Unit() ); |
| | | // if( isnull( showrow ) ){ |
| | | // showrow := this.Row( relnew, Name := row.Name(), Factory := search.Unit() ); |
| | | // } |
| | | // traverse( row, Cell, cell, cell.Column().TimeUnit() = search.TimeUnit() ){ |
| | | // column := selectobject( this, Column, column, column.Name() = cell.Column().Name() ); |
| | | // if( not isnull( column ) ){ |
| | | // showcell := selectobject( showrow, Cell, showcell, showcell.Column() = column ); |
| | | // if( isnull( showcell ) ){ |
| | | // showcell := column.Cell( relnew, Value := '' ); |
| | | // showrow.Cell( relinsert, showcell ); |
| | | // } |
| | | // showcell.Value( [String]( [Number]cell.Value() + [Number]showcell.Value() ) ); |
| | | // } |
| | | // } |
| | | //} |
| | | info( '-----------Search end-------' ); |
| | | *] |
| | | } |