Quintiq file version 2.0
|
#parent: #root
|
StaticMethod GetIDSFullTable (
|
const Archive archive,
|
Number year
|
) as BinaryValue
|
{
|
TextBody:
|
[*
|
// Administrator May-30-2024 (created)
|
// Akari May-18-2024 (created)
|
// 调用接口
|
url := "/IDSPPACurve/GetIDSFullTableXML" + "?year=" +[String]year;
|
|
i := HTTPInterface::Create( archive.JavaInterfaceAddress(), archive.JavaInterfacePort() );
|
i.URL( url );
|
i.PostMethod( false );
|
|
i.TimeOut( Duration::Minutes( 5 ) );
|
|
i.Call( );
|
|
htmlresult := i.Result();
|
|
respJSON := JSON::Parse( htmlresult );
|
|
code := respJSON.Get( "code" ).GetNumber();
|
message := respJSON.Get( "message" ).GetString();
|
xmlTemplate := "";
|
if( code = 200 ){
|
xmlTemplate := message;
|
}else{
|
error( message );
|
}
|
|
tableHandle := TableHandle::ImportXML( BinaryValue::Construct( xmlTemplate ) );
|
XLS::SaveTable( tableHandle, OS::TempPath() + "template.xlsx" );
|
file := OSFile::Construct();
|
file.Open( OS::TempPath() + "template.xlsx", "Read", true );
|
data := file.ReadBinary();
|
return data;
|
*]
|
}
|
