Quintiq file version 2.0
#parent: #root
StaticMethod Download (
  MacroPlan macroPlan
) as BinaryValue
{
  Description: '下载发动机管线数据'
  TextBody:
  [*
    
    table := selectobject( macroPlan, MachiningPipelineSource.Report, table, table.IsShow() );
    
    xmlDOMI := XMLDOMImplementation::Create();
    xmlDOM  := xmlDOMI.CreateDocumentFromString( '<?xml version="1.0" encoding="UTF-16"?><table><name>' + table.Name() + '</name></table>' );
    
    tableElement := xmlDOM.GetElementByTagName( "table", 0 );
    //Product
    productcolumnelement := xmlDOM.CreateElement( "column" );
    productnameelement   := xmlDOM.CreateElement( "name" );
    producttypeelement   := xmlDOM.CreateElement( "type" );
    productnameelement.TextContent( 'Product' );
    producttypeelement.TextContent( "String" );
    productcolumnelement.AppendChild( productnameelement );
    productcolumnelement.AppendChild( producttypeelement );
    //Attribute
    attricolumnelement := xmlDOM.CreateElement( "column" );
    attrinameelement   := xmlDOM.CreateElement( "name" );
    attritypeelement   := xmlDOM.CreateElement( "type" );
    attrinameelement.TextContent( 'Attribute' );
    attritypeelement.TextContent( "String" );
    attricolumnelement.AppendChild( attrinameelement );
    attricolumnelement.AppendChild( attritypeelement );
    
    tableElement.AppendChild( productcolumnelement ); 
    tableElement.AppendChild( attricolumnelement );
    traverse ( table, Column, column ) {
      columnelement := xmlDOM.CreateElement( "column" );
      nameelement   := xmlDOM.CreateElement( "name" );
      typeelement   := xmlDOM.CreateElement( "type" );
      nameelement.TextContent( column.Name() );
      typeelement.TextContent( "String" );
      columnelement.AppendChild( nameelement );
      columnelement.AppendChild( typeelement );
      
      cells := selectsortedset( column, Cell, cell, cell.Row().RowNr() );
    
      traverse ( cells, Elements, c ) {
        if( column.Index() = 0 ){
          row := c.Row();
          //Product
          productcellElement1 := xmlDOM.CreateElement( "cell" );
          productcellElement1.SetAttribute( "value", row.Name() );
          productcolumnelement.AppendChild( productcellElement1 );
          productcellElement2 := xmlDOM.CreateElement( "cell" );
          productcellElement2.SetAttribute( "value", row.Name() );
          productcolumnelement.AppendChild( productcellElement2 );
          productcellElement3 := xmlDOM.CreateElement( "cell" );
          productcellElement3.SetAttribute( "value", row.Name() );
          productcolumnelement.AppendChild( productcellElement3 );
          productcellElement4 := xmlDOM.CreateElement( "cell" );
          productcellElement4.SetAttribute( "value", row.Name() );
          productcolumnelement.AppendChild( productcellElement4 );
          productcellElement5 := xmlDOM.CreateElement( "cell" );
          productcellElement5.SetAttribute( "value", row.Name() );
          productcolumnelement.AppendChild( productcellElement5 );
          productcellElement6 := xmlDOM.CreateElement( "cell" );
          productcellElement6.SetAttribute( "value", row.Name() );
          productcolumnelement.AppendChild( productcellElement6 );
          productcellElement7 := xmlDOM.CreateElement( "cell" );
          productcellElement7.SetAttribute( "value", row.Name() );
          productcolumnelement.AppendChild( productcellElement7 );
          productcellElement8 := xmlDOM.CreateElement( "cell" );
          productcellElement8.SetAttribute( "value", row.Name() );
          productcolumnelement.AppendChild( productcellElement8 );
          productcellElement9 := xmlDOM.CreateElement( "cell" );
          productcellElement9.SetAttribute( "value", row.Name() );
          productcolumnelement.AppendChild( productcellElement9 );
          //Attribute
          //长春装配计划
          ccaqcellElement := xmlDOM.CreateElement( "cell" );
          ccaqcellElement.SetAttribute( "value", 'CC装配计划' );//CCAssemblyPlanQty
          attricolumnelement.AppendChild( ccaqcellElement );
          //长春生产计划
          ccpqcellElement := xmlDOM.CreateElement( "cell" );
          ccpqcellElement.SetAttribute( "value", 'CC机加计划' );//CCProductionQty
          attricolumnelement.AppendChild( ccpqcellElement );
          //长春调拨计划
          cctqcellElement := xmlDOM.CreateElement( "cell" );
          cctqcellElement.SetAttribute( "value", 'CC to DL' );//CCTransferQty
          attricolumnelement.AppendChild( cctqcellElement );
          //长春库存
          cciqcellElement := xmlDOM.CreateElement( "cell" );
          cciqcellElement.SetAttribute( "value", 'CC库存' );//CCInventoryQty
          attricolumnelement.AppendChild( cciqcellElement );
          //大连装配计划
          dlaqcellElement := xmlDOM.CreateElement( "cell" );
          dlaqcellElement.SetAttribute( "value", 'DL装配计划' );//DLAssemblyPlanQty
          attricolumnelement.AppendChild( dlaqcellElement );
          //大连生产计划
          dlpqcellElement := xmlDOM.CreateElement( "cell" );
          dlpqcellElement.SetAttribute( "value", 'DL机加计划' );//DLProductionQty
          attricolumnelement.AppendChild( dlpqcellElement );
          //大连调拨计划
          dltqcellElement := xmlDOM.CreateElement( "cell" );
          dltqcellElement.SetAttribute( "value", 'DL to CC' );//DLTransferQty
          attricolumnelement.AppendChild( dltqcellElement );
          //大连库存
          dliqcellElement := xmlDOM.CreateElement( "cell" );
          dliqcellElement.SetAttribute( "value", 'DL库存' );//DLInventoryQty
          attricolumnelement.AppendChild( dliqcellElement );
          //长春 + 大连 库存
          tiqcellElement := xmlDOM.CreateElement( "cell" );
          tiqcellElement.SetAttribute( "value", 'CC + DL库存' );//TotalInventoryQty
          attricolumnelement.AppendChild( tiqcellElement );
        }
        //长春装配计划
        ccaqcellElement := xmlDOM.CreateElement( "cell" );
        ccaqcellElement.SetAttribute( "value", [String]c.CCAssemblyPlanQty() );
        columnelement.AppendChild( ccaqcellElement );
        //长春生产计划
        ccpqcellElement := xmlDOM.CreateElement( "cell" );
        ccpqcellElement.SetAttribute( "value", [String]c.CCProductionQty() );
        columnelement.AppendChild( ccpqcellElement );
        //长春调拨计划
        cctqcellElement := xmlDOM.CreateElement( "cell" );
        cctqcellElement.SetAttribute( "value", [String]c.CCTransferQty() );
        columnelement.AppendChild( cctqcellElement );
        //长春库存
        cciqcellElement := xmlDOM.CreateElement( "cell" );
        cciqcellElement.SetAttribute( "value", [String]c.CCInventoryQty() );
        columnelement.AppendChild( cciqcellElement );
        //大连装配计划
        dlaqcellElement := xmlDOM.CreateElement( "cell" );
        dlaqcellElement.SetAttribute( "value", [String]c.DLAssemblyPlanQty() );
        columnelement.AppendChild( dlaqcellElement );
        //大连生产计划
        dlpqcellElement := xmlDOM.CreateElement( "cell" );
        dlpqcellElement.SetAttribute( "value", [String]c.DLProductionQty() );
        columnelement.AppendChild( dlpqcellElement );
        //大连调拨计划
        dltqcellElement := xmlDOM.CreateElement( "cell" );
        dltqcellElement.SetAttribute( "value", [String]c.DLTransferQty() );
        columnelement.AppendChild( dltqcellElement );
        //大连库存
        dliqcellElement := xmlDOM.CreateElement( "cell" );
        dliqcellElement.SetAttribute( "value", [String]c.DLInventoryQty() );
        columnelement.AppendChild( dliqcellElement );
        //长春 + 大连 库存
        tiqcellElement := xmlDOM.CreateElement( "cell" );
        tiqcellElement.SetAttribute( "value", [String]c.TotalInventoryQty() );
        columnelement.AppendChild( tiqcellElement );
      }
      tableElement.AppendChild( columnelement );  
    }
    
    xmlString := xmlDOMI.CreateSerializer().WriteToString( xmlDOM );
    
    //info( xmlString );
    
    tableGroupHandle := TableGroupHandle::Create( MachiningPipelineReport::GetDefaultName() );
    tableHandle      := TableHandle::ImportXML( BinaryValue::Construct( xmlString ) );
    tableGroupHandle.Add( tableHandle );
    
    binaryData := XLS::SaveTableGroupToBinaryData( tableGroupHandle, true );
    
    return binaryData.AsBinaryValue();
  *]
}