| | |
| | | error( Translations::MP_FinancialProductionReport_ImportIndetifyIllegalTime() ); |
| | | } |
| | | period := cnv2.Convert( indexcolumn.Name() ); |
| | | // info( "开始时间:", this.SalesForecastInputSource().PlanningStartDate().Format( "Y-M2-D2" ), |
| | | // "结束时间:", this.SalesForecastInputSource().PlanningEndDate().Format( "Y-M2-D2" ), |
| | | // "列时间:", cnv2.Convert( indexColumn.name() ).Format( "Y-M2-D2" ) ); |
| | | |
| | | // 判断是否在计划周期内 |
| | | if ( period <= startofthisyear or period >= startofnextyear ) { |
| | | if ( period < startofthisyear or period > startofnextyear ) { |
| | | error( Translations::MP_FinancialProductionReport_ImportIndetifyOverPeriod() ); |
| | | } |
| | | indexcolumn := indexcolumn.NextColumn(); |
| | |
| | | |
| | | FinancialProductionReport::XMLImportFinancialProductionReportXMLHeaders( tableXML ); |
| | | xlstable := FinancialProductionReport::XMLImportFinancialProductionReportXML( tableXML ); |
| | | |
| | | |
| | | xlstable.SyncRows(); |
| | | |
| | | |
| | | xlstable.Name( sheetName ); |
| | | xlstable.IsImport( true ); |
| | | this.FinancialProductionReport( relinsert, &xlstable ); |
| | |
| | | |
| | | // (导入前)给空值赋予默认值(N/A),并且删除空行数据和数据校验 |
| | | xlstable.IdentifyNullValues(); |
| | | |
| | | |
| | | xlstable.ImportVerification(); |
| | | } |
| | | //导入后处理数据 |
| | |
| | | // "结束时间:", this.SalesForecastInputSource().PlanningEndDate().Format( "Y-M2-D2" ), |
| | | // "列时间:", cnv2.Convert( indexColumn.name() ).Format( "Y-M2-D2" ) ); |
| | | // 判断是否在计划周期内 |
| | | if ( period <= startofthisyear or period >= startofnextyear ) { |
| | | if ( period < startofthisyear or period > startofnextyear ) { |
| | | error( Translations::MP_FinancialProductionReport_ImportIndetifyOverPeriod() ); |
| | | } |
| | | indexcolumn := indexcolumn.NextColumn(); |