//根据查询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)); }