public DataSet LoadEPR010(ReportCriteriaDTO.EPR010 argCriteria) { DataSet dsReturn = null; ReportDAO dao = new ReportDAO(CommonLib.Common.CurrentDatabase); dsReturn = dao.LoadEPR010(argCriteria); return(dsReturn); }
public DataSet LoadEPR010(ReportCriteriaDTO.EPR010 argCriteria) { DataSet dsReturn = null; Database db = m_db; DataRequest req = new DataRequest(); req.CommandText = "S_EPR010_LoadSummaryTransaction"; req.CommandType = CommandType.StoredProcedure; req.Parameters.Add("@pDtm_DateFrom", argCriteria.DateFrom); req.Parameters.Add("@pDtm_DateTo", argCriteria.DateTo); req.Parameters.Add("@pVar_LocationFrom", CheckNull(argCriteria.LocationFrom)); req.Parameters.Add("@pVar_LocationTo", CheckNull(argCriteria.LocationTo)); req.Parameters.Add("@pVar_PartNoFrom", CheckNull(argCriteria.PartNoFrom)); req.Parameters.Add("@pVar_PartNoTo", CheckNull(argCriteria.PartNoTo)); req.Parameters.Add("@pVar_TransactionClass", CheckNull(argCriteria.TransactionClass)); req.Parameters.Add("@pVar_InOutClass", CheckNull(argCriteria.InOutClass)); dsReturn = m_db.ExecuteDataSet(req); return(dsReturn); }