//根据查询SQL,产生提供给报表生成需要的 XML 数据，字段值为空也产生数据
public static void FullGenNodeXmlData(HttpResponse Response, string QuerySQL, bool ToCompress)
{
MyDbCommand ReportDataCommand = new MyDbCommand(QuerySQL, ReportConn);
MyDbDataReader ReportDataReader = ReportDataCommand.ExecuteReader();
string Text = XMLReportData.FromDataReader(ReportDataReader);
GridReportDataResponse.Response(Response, Text, ToCompress ? ResponseDataType.ZipBinary : ResponseDataType.PlainText);
}
public static string TextFromOneSQL(string QuerySQL)
{
DataSet ReportDataSet = new DataSet();
MyDbDataAdapter ReportDataAdapter = new MyDbDataAdapter(QuerySQL, ReportConn);
ReportDataAdapter.Fill(ReportDataSet);
return(XMLReportData.FromDataSet(ReportDataSet));
}
public static string TextFromMultiSQL(ArrayList QueryList)
{
DataSet ReportDataSet = new DataSet();
foreach (ReportQueryItem item in QueryList)
{
MyDbDataAdapter DataAdapter = new MyDbDataAdapter(item.QuerySQL, ReportConn);
DataAdapter.Fill(ReportDataSet, item.RecordsetName);
}
return(XMLReportData.FromDataSet(ReportDataSet));
}
