public DataSet LoadEPR020(ReportCriteriaDTO.EPR020 argCriteria) { DataSet dsReturn = null; ReportDAO dao = new ReportDAO(CommonLib.Common.CurrentDatabase); dsReturn = dao.LoadEPR020(argCriteria); return(dsReturn); }
public DataSet LoadEPR020(ReportCriteriaDTO.EPR020 argCriteria) { DataSet dsReturn = null; Database db = m_db; DataRequest req = new DataRequest(); req.CommandText = "S_EPR020_LoadIssueSummary"; req.CommandType = CommandType.StoredProcedure; req.Parameters.Add("@pDtm_DateFrom", argCriteria.DateFrom); req.Parameters.Add("@pDtm_DateTo", argCriteria.DateTo); req.Parameters.Add("@pVar_FromLocation", CheckNull(argCriteria.FromLocation)); req.Parameters.Add("@pVar_ToLocation", CheckNull(argCriteria.ToLocation)); req.Parameters.Add("@pVar_PartNoFrom", CheckNull(argCriteria.PartNoFrom)); req.Parameters.Add("@pVar_PartNoTo", CheckNull(argCriteria.PartNoTo)); dsReturn = m_db.ExecuteDataSet(req); return(dsReturn); }