public DataTable GetReportList()
{
string query = "select report_code, report_name from " + ConfigManager.GetReportTableName() + " order by report_order;";
DataTable dtReportList = GetDataTable(query);
return(dtReportList);
}
public DataTable GetReportArguments(string reportCode)
{
try
{
string query = "select * from " + ConfigManager.GetReportTableName() + " where upper(report_code) ='" + reportCode.ToUpper() + "'";
LogWriter.WriteLog(query);
DataTable dtReportArgs = GetDataTable(query);
return(dtReportArgs);
}
catch (Exception)
{
throw;
}
}
public string GetConnectionStringForReport(string REPORT_CODE)
{
string query = "select connection_string from " + ConfigManager.GetReportTableName() + " Where report_code='" + REPORT_CODE + "'";
DataTable dtConSring = GetDataTable(query);
if (dtConSring.Rows.Count > 0 && !dtConSring.Rows[0][0].ToString().Trim().Equals(string.Empty))
{
return(dtConSring.Rows[0][0].ToString());
}
else
{
return(string.Empty);
}
}
public DataTable GetReportList(string roleName)
{
string query = string.Format("select report_code, report_name from {0} where report_code in (select report_code from report_authorization where role = '{1}') order by report_order", ConfigManager.GetReportTableName(), roleName);
DataTable dtReportList = GetDataTable(query);
return(dtReportList);
}
public DataRow GetReportConfigInfo(string reportCode)
{
DataTable dataTable = new DataTable();
try
{
string query = "select field_caps, sql_from,detail_fieldsets from " + ConfigManager.GetReportTableName() + " where upper(report_code) ='" + reportCode.ToUpper() + "'";
using (MySqlConnection dbConnection = new MySqlConnection(ConnectionString))
{
using (MySqlDataAdapter adapter = new MySqlDataAdapter())
{
adapter.SelectCommand = new MySqlCommand(query, dbConnection);
adapter.Fill(dataTable);
return(dataTable.Rows[0]);
}
}
}
catch (Exception ex)
{
throw new Exception("From GetDataTable method:" + ex.Message);
}
return(null);
}