public void Delete(HT_ReportInfo pReportInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@HT_ReportID", SqlDbType.Int, pReportInfo.HT_ReportID));
RunProcedure("sp_HT_Report_Delete", colParam);
}
public DataTable Get(HT_ReportInfo pReportInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@HT_ReportID", SqlDbType.Int, pReportInfo.HT_ReportID));
return(RunProcedureGet("sp_HT_Report_Get", colParam));
}
public DataTable GetByName(HT_ReportInfo pReportInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@ReportName", SqlDbType.NVarChar, pReportInfo.ReportName));
return(RunProcedureGet("sp_HT_Report_GetByName", colParam));
}
public void Add(HT_ReportInfo pReportInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@ReportName", SqlDbType.NVarChar, pReportInfo.ReportName));
colParam.Add(CreateParam("@Detail", SqlDbType.NText, pReportInfo.Detail));
RunProcedure("sp_HT_Report_Add", colParam);
}
public List <HT_ReportInfo> GetList(HT_ReportInfo pReportInfo)
{
List <HT_ReportInfo> oReportInfoList = new List <HT_ReportInfo>();
DataTable dtb = Get(pReportInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oReportInfo = new HT_ReportInfo();
oReportInfo.HT_ReportID = int.Parse(dtb.Rows[i]["HT_ReportID"].ToString());
oReportInfo.ReportName = dtb.Rows[i]["ReportName"].ToString();
oReportInfo.Detail = dtb.Rows[i]["Detail"].ToString();
oReportInfoList.Add(oReportInfo);
}
}
return(oReportInfoList.Count == 0 ? null : oReportInfoList);
}
public void Delete(HT_ReportInfo pReportInfo)
{
oDHT_Report.Delete(pReportInfo);
mErrorMessage = oDHT_Report.ErrorMessages;
mErrorNumber = oDHT_Report.ErrorNumber;
}
public void Add(HT_ReportInfo pReportInfo)
{
oDHT_Report.Add(pReportInfo);
mErrorMessage = oDHT_Report.ErrorMessages;
mErrorNumber = oDHT_Report.ErrorNumber;
}
public DataTable Get(HT_ReportInfo pReportInfo)
{
return(oDHT_Report.Get(pReportInfo));
}
