public ActionResult StatusReport(StatusReportModel model) { ClientVisitSearchCriteria criteria = new ClientVisitSearchCriteria(); criteria.StatusIds = model.StatusIds; criteria.IsActualInVisitGroup = true; criteria.StatusDateFrom = model.StatusDateFrom; criteria.StetusDateTo = (model.StatusDateTo); //criteria.Lastname = "Иванов1"; //criteria.Firstname = "Иван"; //criteria.Secondname = "Иванович"; List <ClientVisitInfo> clientVisits = clientBusinessLogic.ClientVisit_Find( criteria, new List <SortCriteria <ClientVisitSortField> >(), new PageRequest() { PageNumber = 1, PageSize = int.MaxValue }).Data; var Statuses = ReferencesProvider.GetReferenceItems(Constants.ClientVisitStatusRef); List <string> listStatus = new List <string>(); listStatus = Statuses.Where(item => (model.StatusIds).Contains(item.Id)).Select(a => a.Name).ToList(); StatusReport printedForm = new StatusReport(clientVisits, model.StatusDateFrom, model.StatusDateTo, listStatus); return(File(printedForm.GetExcel(), System.Net.Mime.MediaTypeNames.Application.Octet, string.Format("Отчет по статусам {0}.xlsx", DateTime.Now.ToShortDateString()))); }
public PrintedFormsModel() { PartyJournal = new PartyJournalModel(); BSOFailForm13 = new BSOFailForm13Model(); BSOOperativeInformation = new BSOOperativeInformationModel(); BSOReportForm10 = new BSOReportForm10Model(); BSOReportForm10Full = new BSOReportForm10FullModel(); SMSBaseReport = new SMSBaseReportModel(); AllocationBSO = new AllocationBSOModel(); BSOMoveReportYear = new BSOMoveReportYearModel(); ScenarioForm2 = new ScenarioForm2Model(); ClientVisitReport = new ClientVisitReportModel(); SNILSReport = new SNILSReportModel(); StatusReport = new StatusReportModel(); }