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