| | |
| | | //外租库入库费用:取自财务产量报表的产量,在产品表根据发动机号找到对应的Generation 和横纵制,在发动机成本参数表里找到对应的包装容量和入库单价,用公式计算,月度进行汇总 |
| | | traverse( owner, FinancialProductionSource, source, not source.IsImport() ){//财务产量报表非导入 |
| | | traverse( source, FinancialProductionReport, report, not report.IsShow() ){//财务产量报表不显示 |
| | | traverse( report, FinancialProductionRow, row, row.Unit() = ccunit and exists( row, FinancialProductionCell, cell, cell.Value() <> '0' and not cell.FinancialProductionColumn().IsDay() ) ){//财务产量报表里的长春产量, 不为0 |
| | | traverse( report, FinancialProductionRow, row, row.Unit() = ccunit and exists( row, FinancialProductionCell, cell, cell.Value() <> '0') ){//财务产量报表里的长春产量, 不为0 |
| | | product := row.Product_MP(); |
| | | productparents := product.GetAllParent(); |
| | | if( exists( productparents, Elements, e, e.ID() = produtparent ) ){//查询产品类型是发动机 |
| | |
| | | if( not isnull( enginecosts ) and enginecosts.Size() > 0 ){ |
| | | ccrow := table.GetRow( row.Name() ); |
| | | products.Add( product ); |
| | | traverse( row, FinancialProductionCell, cell, cell.Value() <> '0' and not cell.FinancialProductionColumn().IsDay() ){ |
| | | traverse( row, FinancialProductionCell, cell, cell.Value() <> '0' ){ |
| | | cellcolumn := cell.FinancialProductionColumn(); |
| | | enginecost := selectobject( enginecosts, Elements, engine, engine.StartDate() <= cellcolumn.Period() and engine.EndDate() >= cellcolumn.Period() ); |
| | | if( not isnull( enginecost ) ){ |
| | |
| | | //外租库出库费用:出库量等于长春销量,取自财务销量报表的销量,在产品表根据发动机号找到对应的Generation 和横纵制,在发动机成本参数表里找到对应的包装容量和出库单价,用公式计算,月度进行汇总 |
| | | traverse( owner, FinancialSalesSource, source, not source.IsImport() ){//财务销量报表非导入 |
| | | traverse( source, FinancialSalesReport, report, not report.IsShow() ){//财务销量报表不显示 |
| | | traverse( report, FinancialSalesRow, row, row.Unit() = ccunit and exists( row, FinancialSalesCell, cell, cell.Value() <> '0' and not cell.FinancialSalesColumn().IsDay() ) ){//财务销量报表里的长春产量, 不为0 |
| | | traverse( report, FinancialSalesRow, row, row.Unit() = ccunit and exists( row, FinancialSalesCell, cell, cell.Value() <> '0' ) ){//财务销量报表里的长春产量, 不为0 |
| | | product := row.Product_MP(); |
| | | productparents := product.GetAllParent(); |
| | | if( exists( productparents, Elements, e, e.ID() = produtparent ) ){//查询产品类型是发动机 |
| | |
| | | if( not isnull( enginecosts ) and enginecosts.Size() > 0 ){ |
| | | ccrow := table.GetRow( row.Name() ); |
| | | products.Add( product ); |
| | | traverse( row, FinancialSalesCell, cell, cell.Value() <> '0' and not cell.FinancialSalesColumn().IsDay() ){ |
| | | traverse( row, FinancialSalesCell, cell, cell.Value() <> '0' ){ |
| | | cellcolumn := cell.FinancialSalesColumn(); |
| | | enginecost := selectobject( enginecosts, Elements, engine, engine.StartDate() <= cellcolumn.Period() and engine.EndDate() >= cellcolumn.Period() ); |
| | | if( not isnull( enginecost ) ){ |