public List <SmsBase> SMSBase_GetAll(SmsBase.SmsBaseGet smsGet) { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.AddInputParameter("@CreateDateFrom", SqlDbType.DateTime, smsGet.CreateDateFrom); parameters.AddInputParameter("@CreateDateTo", SqlDbType.DateTime, smsGet.CreateDateTo); List <SmsBase> result = Execute_GetList(SmsMaterializer.Instance, "SMSBase_GetAll", parameters); return(result); }
public ActionResult GetSMSBaseReport(SMSBaseReportModel model) { SmsBase.SmsBaseGet get = new SmsBase.SmsBaseGet() { CreateDateFrom = model.SmsBaseDateFrom, CreateDateTo = model.SmsBaseDateTo.AddDays(1) }; List <SmsBase> listSmsBase = smsBusinessLogic.SMSBase_GetAll(get); SMSBaseReport printedForm = new SMSBaseReport(listSmsBase, model.SmsBaseDateFrom, model.SmsBaseDateTo); return(File(printedForm.GetExcel(), System.Net.Mime.MediaTypeNames.Application.Octet, string.Format("Отчет по отправленным смс сообщениям.xls"))); }
public List <SmsBase> SMSBase_GetAll(SmsBase.SmsBaseGet smsGet) { return(SmsMessageDao.Instance.SMSBase_GetAll(smsGet)); }