| | |
|---|
| | | if( isnull( unitrow ) ){ |
|---|
| | | unitrow := table.FinancialSalesRow( relnew, Name := product.Value(), Unit := unit.Value() ); |
|---|
| | | } |
|---|
| | | // allrow := selectobject( table, FinancialSalesRow, allrow, allrow.Name() = product.Value() and allrow.Unit() = allunit ); |
|---|
| | | // if( isnull( unitrow ) ){ |
|---|
| | | // allrow := table.FinancialSalesRow( relnew, Name := product.Value(), Unit := allunit ); |
|---|
| | | // } |
|---|
| | | |
|---|
| | | traverse( row, FinancialSalesCell, cell, cell.Value() <> '0' and cell.FinancialSalesColumn() <> productcolumn and cell.FinancialSalesColumn() <> unitcolumn and cnv2.Convert( cell.FinancialSalesColumn().Name() ) <> beforeyearday ){ |
|---|
| | | column := cell.FinancialSalesColumn(); |
|---|
| | |
|---|
| | | } |
|---|
| | | tablecolumn := construct( FinancialSalesColumn ); |
|---|
| | | //获取被导入报表的日期列 |
|---|
| | | tablecolumn := selectobject( table, FinancialSalesColumn, fscolumn, not fscolumn.IsDay() and fscolumn.Name() = periodname ); |
|---|
| | | tablecolumn := selectobject( table, FinancialSalesColumn, fscolumn, fscolumn.Name() = periodname ); |
|---|
| | | if( isnull( tablecolumn ) ){ |
|---|
| | | tablecolumn := table.FinancialSalesColumn( relnew, Name := periodname, Period := yearday.Date() ); |
|---|
| | | } |
|---|
| | |
|---|
| | | unitcell.IsUpdate( true ); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | // allcell := selectobject( allrow, FinancialSalesCell, allcell, allcell.FinancialSalesColumn() = tablecolumn ); |
|---|
| | | // if( isnull( allcell ) ){ |
|---|
| | | // allcell := tablecolumn.FinancialSalesCell( relnew, Value := cell.Value() ); |
|---|
| | | // allrow.FinancialSalesCell( relinsert, allcell ); |
|---|
| | | // }else{ |
|---|
| | | // if( [Real]allcell.Value() <> quantity ){ |
|---|
| | | // allcell.Value( [String]( [Number]quantity ) ); |
|---|
| | | // allcell.IsUpdate( true ); |
|---|
| | | // } |
|---|
| | | // } |
|---|
| | | } |
|---|
| | | } |
|---|
| | | } |
|---|
