public DataTable GetDdlRptMemCri(string GenPrefix, string reportId, bool bAll, int topN, string keyId, string dbConnectionString, string dbPassword, string filterTxt, UsrImpr ui, UsrCurr uc)
{
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
return(dac.GetDdlRptMemCri(GenPrefix, reportId, bAll, topN, keyId, dbConnectionString, dbPassword, filterTxt, ui, uc));
}
}
public int CountRptCri(string ReportCriId, string dbConnectionString, string dbPassword)
{
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
return(dac.CountRptCri(ReportCriId, dbConnectionString, dbPassword));
}
}
public string GetRptWizId(string reportId, string dbConnectionString, string dbPassword)
{
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
return(dac.GetRptWizId(reportId, dbConnectionString, dbPassword));
}
}
/* For backward compatibility only - to be deleted */
public DataTable GetIn(string reportId, string programName, string RequiredValid, UsrImpr ui, UsrCurr uc, string dbConnectionString, string dbPassword)
{
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
return(dac.GetIn(reportId, programName, 0, RequiredValid, true, string.Empty, ui, uc, dbConnectionString, dbPassword));
}
}
public DataTable GetDdlAccessCd(bool bAll, string keyId, string dbConnectionString, string dbPassword, UsrImpr ui, UsrCurr uc)
{
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
return(dac.GetDdlAccessCd(bAll, keyId, dbConnectionString, dbPassword, ui, uc));
}
}
public DataTable GetReportColumns(string GenPrefix, string reportId, string dbConnectionString, string dbPassword)
{
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
return(dac.GetReportColumns(GenPrefix, reportId, dbConnectionString, dbPassword));
}
}
public void MkReportGetIn(string GenPrefix, string reportCriId, string procedureName, string appDatabase, string sysDatabase, string dbConnectionString, string dbPassword)
{
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
dac.MkReportGetIn(GenPrefix, reportCriId, procedureName, appDatabase, sysDatabase, dbConnectionString, dbPassword);
}
}
public void UpdMemViewdt(string GenPrefix, string RptMemCriId, string dbConnectionString, string dbPassword)
{
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
dac.UpdMemViewdt(GenPrefix, RptMemCriId, dbConnectionString, dbPassword);
}
}
public void UpdSqlReport(string reportId, string programName, DataView dvCri, Int32 usrId, DataSet ds, string dbConnectionString, string dbPassword)
{
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
dac.UpdSqlReport(reportId, programName, dvCri, usrId, ds, dbConnectionString, dbPassword);
}
}
public string MemSqlReport(string PublicAccess, string RptMemCriId, string RptMemFldId, string RptMemCriName, string RptMemCriDesc, string RptMemCriLink, string reportId, string programName, DataView dvCri, Int32 usrId, DataSet ds, string dbConnectionString, string dbPassword)
{
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
return(dac.MemSqlReport(PublicAccess, RptMemCriId, RptMemFldId, RptMemCriName, RptMemCriDesc, RptMemCriLink, reportId, programName, dvCri, usrId, ds, dbConnectionString, dbPassword));
}
}
public DataTable GetGaugeValue(string reportId, string dbConnectionString, string dbPassword)
{
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
return(dac.GetGaugeValue(reportId, dbConnectionString, dbPassword));
}
}
public DataTable GetSqlReport(string reportId, string programName, DataView dvCri, UsrImpr ui, UsrCurr uc, DataSet ds, string dbConnectionString, string dbPassword, bool bUpd, bool bXls, bool bVal, int commandTimeOut = 1800)
{
using (SqlReportAccessBase dac = GetSqlReportAccess(commandTimeOut))
{
return(dac.GetSqlReport(reportId, programName, dvCri, ui, uc, ds, dbConnectionString, dbPassword, bUpd, bXls, bVal));
}
}
public void DelMemFld(string GenPrefix, string MemFldId, string dbConnectionString, string dbPassword)
{
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
dac.DelMemFld(GenPrefix, MemFldId, dbConnectionString, dbPassword);
}
}
public string UpdMemFld(string GenPrefix, string PublicAccess, string RptMemFldId, string RptMemFldName, Int32 usrId, string dbConnectionString, string dbPassword)
{
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
return(dac.UpdMemFld(GenPrefix, PublicAccess, RptMemFldId, RptMemFldName, usrId, dbConnectionString, dbPassword));
}
}
public DataTable GetIn(string reportId, string programName, int TotalCnt, string RequiredValid, bool bAll, string keyid, UsrImpr ui, UsrCurr uc, string dbConnectionString, string dbPassword)
{
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
return(dac.GetIn(reportId, programName, TotalCnt, RequiredValid, bAll, keyid, ui, uc, dbConnectionString, dbPassword));
}
}
public DataTable GetReportObjHlp(string GenPrefix, Int32 ReportId, Int16 CultureId, string dbConnectionString, string dbPassword)
{
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
return(dac.GetReportObjHlp(GenPrefix, ReportId, CultureId, dbConnectionString, dbPassword));
}
}
public void DelMemCri(string GenPrefix, string reportId, string MemCriId, string dbConnectionString, string dbPassword)
{
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
dac.DelMemCri(GenPrefix, reportId, MemCriId, "Y", dbConnectionString, dbPassword);
}
}
public DataTable GetDocImage(string ReportId, Int16 TemplateId, string dbConnectionString, string dbPassword)
{
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
return(dac.GetDocImage(ReportId, TemplateId, dbConnectionString, dbPassword));
}
}
public DataTable GetRptCriteria(Int32 rowsExpected, string GenPrefix, Int32 reportId, Int32 usrId, string dbConnectionString, string dbPassword)
{
DataTable dt = null;
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
dt = dac.GetRptCriteria(GenPrefix, reportId, usrId, dbConnectionString, dbPassword);
}
if (dt.Rows.Count != rowsExpected)
{
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
dac.DelRptCriteria(GenPrefix, reportId, usrId, dbConnectionString, dbPassword);
dac.IniRptCriteria(GenPrefix, reportId, usrId, dbConnectionString, dbPassword);
dt = dac.GetRptCriteria(GenPrefix, reportId, usrId, dbConnectionString, dbPassword);
}
}
return(dt);
}
public DataTable GetMemCri(string GenPrefix, byte rowsExpected, string reportId, string MemCriId, string dbConnectionString, string dbPassword)
{
DataTable dt = null;
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
dt = dac.GetMemCri(GenPrefix, reportId, MemCriId, dbConnectionString, dbPassword);
}
if (dt.Rows.Count != rowsExpected)
{
using (SqlReportAccessBase dac = GetSqlReportAccess())
{
dac.DelMemCri(GenPrefix, reportId, MemCriId, "N", dbConnectionString, dbPassword);
dac.IniMemCri(GenPrefix, reportId, MemCriId, dbConnectionString, dbPassword);
dt = dac.GetMemCri(GenPrefix, reportId, MemCriId, dbConnectionString, dbPassword);
}
}
return(dt);
}
