财务产量/销量报表刷新导出报错

lazhen

2024-10-22 712d2f68e0d1e9e111aa5d870283f4edf2da3739

财务产量/销量报表刷新导出报错

 _Main/BL/Type_FinancialProductionSource/StaticMethod_Download.qbl

@@ -38,12 +38,21 @@
          row                     := c.FinancialProductionRow();
          //Factory
          InventorySummarySource::CreateCellElement( xmlDOM, searchunitcolumn, row.Factory() );
          //Generation
          InventorySummarySource::CreateCellElement( xmlDOM, generationcolumn, row.Product_MP().Generation() );
          //Power
          InventorySummarySource::CreateCellElement( xmlDOM, powercolumn, row.Product_MP().Power() );
          //MLBMQBS
          InventorySummarySource::CreateCellElement( xmlDOM, mlbmqbcolumn, row.Product_MP().MQBMLB() );
          if( not isnull( row.Product_MP() ) ){
            //Generation
            InventorySummarySource::CreateCellElement( xmlDOM, generationcolumn, row.Product_MP().Generation() );
            //Power
            InventorySummarySource::CreateCellElement( xmlDOM, powercolumn, row.Product_MP().Power() );
            //MLBMQBS
            InventorySummarySource::CreateCellElement( xmlDOM, mlbmqbcolumn, row.Product_MP().MQBMLB() );
          }else{
            //Generation
            InventorySummarySource::CreateCellElement( xmlDOM, generationcolumn, '' );
            //Power
            InventorySummarySource::CreateCellElement( xmlDOM, powercolumn, '' );
            //MLBMQBS
            InventorySummarySource::CreateCellElement( xmlDOM, mlbmqbcolumn, '' );
          }
          //Product
          InventorySummarySource::CreateCellElement( xmlDOM, productcolumnelement, row.Name() );
          //Unit

 _Main/BL/Type_FinancialProductionSource/StaticMethod_Initialize.qbl

@@ -38,7 +38,7 @@
          productids.Add( pisp.ProductID() );
          //当product planning的日期区间在需要的日期区间内 
          traverse( pisp, ProductInStockingPointInPeriod, pispip, not pispip.Period_MP().IsHistorical() and pispip.Period_MP().StartDate() < startofnextyear and pispip.NewSupplyQuantity() <> 0 ){
            dayperiodtime     := ( pispip.Start() + Duration::Days( 1 ) ).Date();
            dayperiodtime     := pispip.Start().Date();
            dayperiodname     := dayperiodtime.Format( "M2/D2/Y" );
            periodtime        := dayperiodtime.StartOfMonth();
            periodname        := periodtime.Format( "M2/D2/Y" );

 _Main/BL/Type_FinancialSalesSource/StaticMethod_Download.qbl

@@ -38,12 +38,21 @@
          row                     := c.FinancialSalesRow();
          //Factory
          InventorySummarySource::CreateCellElement( xmlDOM, searchunitcolumn, row.Factory() );
          //Generation
          InventorySummarySource::CreateCellElement( xmlDOM, generationcolumn, row.Product_MP().Generation() );
          //Power
          InventorySummarySource::CreateCellElement( xmlDOM, powercolumn, row.Product_MP().Power() );
          //MLBMQBS
          InventorySummarySource::CreateCellElement( xmlDOM, mlbmqbcolumn, row.Product_MP().MQBMLB() );
          if( not isnull( row.Product_MP() ) ){
            //Generation
            InventorySummarySource::CreateCellElement( xmlDOM, generationcolumn, row.Product_MP().Generation() );
            //Power
            InventorySummarySource::CreateCellElement( xmlDOM, powercolumn, row.Product_MP().Power() );
            //MLBMQBS
            InventorySummarySource::CreateCellElement( xmlDOM, mlbmqbcolumn, row.Product_MP().MQBMLB() );
          }else{
            //Generation
            InventorySummarySource::CreateCellElement( xmlDOM, generationcolumn, '' );
            //Power
            InventorySummarySource::CreateCellElement( xmlDOM, powercolumn, '' );
            //MLBMQBS
            InventorySummarySource::CreateCellElement( xmlDOM, mlbmqbcolumn, '' );
          }
          //Product
          InventorySummarySource::CreateCellElement( xmlDOM, productcolumnelement, row.Name() );
          //Unit

 _Main/BL/Type_FinancialSalesSource/StaticMethod_InitializeNew.qbl

@@ -81,7 +81,7 @@
          traverse( pisp, ProductInStockingPointInPeriod, pispip, not pispip.Period_MP().IsHistorical()
                    and pispip.Period_MP().StartDate() < startofnextyear 
                    and ( pispip.DependentDemandAndSalesDemandQuantity() <> 0 or pispip.NewSupplyQuantity() <> 0 ) ){
            dayperiodtime   := ( pispip.Start() + Duration::Days( 1 ) ).Date();
            dayperiodtime   := pispip.Start().Date();
            dayperiodname   := dayperiodtime.Format( "M2/D2/Y" );
            periodtime      := dayperiodtime.StartOfMonth();
            periodname      := periodtime.Format( "M2/D2/Y" );