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