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)); }