예제 #1
0
 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));
     }
 }
예제 #2
0
 public int CountRptCri(string ReportCriId, string dbConnectionString, string dbPassword)
 {
     using (SqlReportAccessBase dac = GetSqlReportAccess())
     {
         return(dac.CountRptCri(ReportCriId, dbConnectionString, dbPassword));
     }
 }
예제 #3
0
 public string GetRptWizId(string reportId, string dbConnectionString, string dbPassword)
 {
     using (SqlReportAccessBase dac = GetSqlReportAccess())
     {
         return(dac.GetRptWizId(reportId, dbConnectionString, dbPassword));
     }
 }
예제 #4
0
 /* 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));
     }
 }
예제 #5
0
 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));
     }
 }
예제 #6
0
 public DataTable GetReportColumns(string GenPrefix, string reportId, string dbConnectionString, string dbPassword)
 {
     using (SqlReportAccessBase dac = GetSqlReportAccess())
     {
         return(dac.GetReportColumns(GenPrefix, reportId, dbConnectionString, dbPassword));
     }
 }
예제 #7
0
 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);
     }
 }
예제 #8
0
 public void UpdMemViewdt(string GenPrefix, string RptMemCriId, string dbConnectionString, string dbPassword)
 {
     using (SqlReportAccessBase dac = GetSqlReportAccess())
     {
         dac.UpdMemViewdt(GenPrefix, RptMemCriId, dbConnectionString, dbPassword);
     }
 }
예제 #9
0
 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);
     }
 }
예제 #10
0
 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));
     }
 }
예제 #11
0
 public DataTable GetGaugeValue(string reportId, string dbConnectionString, string dbPassword)
 {
     using (SqlReportAccessBase dac = GetSqlReportAccess())
     {
         return(dac.GetGaugeValue(reportId, dbConnectionString, dbPassword));
     }
 }
예제 #12
0
 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));
     }
 }
예제 #13
0
 public void DelMemFld(string GenPrefix, string MemFldId, string dbConnectionString, string dbPassword)
 {
     using (SqlReportAccessBase dac = GetSqlReportAccess())
     {
         dac.DelMemFld(GenPrefix, MemFldId, dbConnectionString, dbPassword);
     }
 }
예제 #14
0
 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));
     }
 }
예제 #15
0
 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));
     }
 }
예제 #16
0
 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));
     }
 }
예제 #17
0
 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);
     }
 }
예제 #18
0
 public DataTable GetDocImage(string ReportId, Int16 TemplateId, string dbConnectionString, string dbPassword)
 {
     using (SqlReportAccessBase dac = GetSqlReportAccess())
     {
         return(dac.GetDocImage(ReportId, TemplateId, dbConnectionString, dbPassword));
     }
 }
예제 #19
0
        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);
        }
예제 #20
0
        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);
        }