//根据查询SQL,产生提供给报表生成需要的 或 JSON 数据,采用 Oracle 数据引擎, 根据RecordsetQuerySQL获取报表明细数据,根据ParameterQuerySQL获取报表参数数据 protected static void DoGenEntireData(System.Web.UI.Page DataPage, string RecordsetQuerySQL, string ParameterQuerySQL, ResponseDataType DataType, bool IsJSON) { OracleConnection myConn = new OracleConnection(OracleConnStr); myConn.Open(); OracleDataAdapter myda = new OracleDataAdapter(RecordsetQuerySQL, myConn); DataSet myds = new DataSet(); myda.Fill(myds); OracleCommand mycmd = new OracleCommand(ParameterQuerySQL, myConn); OracleDataReader mydr = mycmd.ExecuteReader(CommandBehavior.CloseConnection); if (IsJSON) { string ParameterPart = JSONReportData.GenParameterText(mydr); JSONReportData.GenEntireData(DataPage, myds, ref ParameterPart, DataType); } else { string ParameterPart = XMLReportData.GenParameterText(mydr); XMLReportData.GenEntireData(DataPage, myds, ref ParameterPart, DataType); } myConn.Close(); }