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(); }
public ActionResult GetBSOReportForm10Full(BSOReportForm10FullModel model) { string delivery = string.Empty; BSOListModel bsoListModel = new BSOListModel(); bsoListModel.SearchCriteriaModel.StatusDateFrom = model.DateForm10FullFrom; bsoListModel.SearchCriteriaModel.StatusDateTo = model.DateForm10FullTo; List <string> ListDelivery = new List <string>(); List <ReferenceUniversalItem> ListDeliveryPointUniversal = referenceBusinessLogic.GetUniversalList(Constants.DeliveryPointRef); List <DeliveryCenter> listDeliveryCenter = referenceBusinessLogic.GetDeliveryCenterList(); //для Администраторов ограничений по точкам - нет if (Role.Administrator.Id == Role.GetRealRole(CurrentUser).Id || Role.AdministratorBSO.Id == Role.GetRealRole(CurrentUser).Id) { if (model.DeliveryPointIds.Count > 0) { bsoListModel.SearchCriteriaModel.DeliveryPointIds = model.DeliveryPointIds; foreach (var item in model.DeliveryPointIds) { delivery = listDeliveryCenter.Where(a => a.Id == ListDeliveryPointUniversal.Where(b => b.Id == item).Select(c => c.DeliveryCenterId).FirstOrDefault()).Select(d => d.DisplayName).FirstOrDefault(); ListDelivery.Add(delivery); } } else { delivery = "Все точки"; } } else { //для ответственного if (Role.ResponsibleBSO == Role.GetRealRole(CurrentUser)) { if (model.DeliveryPointIds.Count > 0) { bsoListModel.SearchCriteriaModel.DeliveryPointIds = model.DeliveryPointIds; } else {//все точки для ответственного model.DeliveryPoints = ReferencesProvider.GetDeliveryPointsForResponsibleBSO(CurrentUser.Id, false); foreach (var item in model.DeliveryPoints) { if (item.Value != "") { model.DeliveryPointIds.Add(long.Parse(item.Value)); } } bsoListModel.SearchCriteriaModel.DeliveryPointIds = model.DeliveryPointIds; } foreach (var item in model.DeliveryPointIds) { delivery = listDeliveryCenter.Where(a => a.Id == ListDeliveryPointUniversal.Where(b => b.Id == item).Select(c => c.DeliveryCenterId).FirstOrDefault()).Select(d => d.DisplayName).FirstOrDefault(); ListDelivery.Add(delivery); } } else { //для всех остальных, только по их собственной точке bsoListModel.SearchCriteriaModel.DeliveryPointIds = new List <long>() { CurrentUser.DeliveryPoint.Id }; model.DeliveryPointIds = new List <long>() { CurrentUser.DeliveryPoint.Id }; delivery = listDeliveryCenter.Where(a => a.Id == ListDeliveryPointUniversal.Where(b => b.Id == CurrentUser.DeliveryPoint.Id).Select(c => c.DeliveryCenterId).FirstOrDefault()).Select(d => d.DisplayName).FirstOrDefault(); ListDelivery.Add(delivery); } } BSOSearchCriteria criteria = bsoListModel.SearchCriteriaModel.GetBSOSearchCriteria(); List <BSOInfo> listBSOinRangeDate = bsoBusinessLogic.BSO_Find( criteria, new List <SortCriteria <BSOSortField> >(), new PageRequest() { PageNumber = 1, PageSize = int.MaxValue }).Data; List <BSOHistoryItem> listHistory = new List <BSOHistoryItem>(); if (listBSOinRangeDate.Count > 0) { List <long> listBSO_IDs = listBSOinRangeDate.Select(a => a.Id).ToList(); listHistory = bsoBusinessLogic.BSO_GetListHistory(new DateTime(2000, 1, 1), (DateTime)bsoListModel.SearchCriteriaModel.StatusDateTo, listBSO_IDs); } List <BSOInfo> listBSOBeforeDate = bsoBusinessLogic.BSO_Find( new BSOSearchCriteria() { StatusDateTo = bsoListModel.SearchCriteriaModel.StatusDateFrom, DeliveryPointIds = bsoListModel.SearchCriteriaModel.DeliveryPointIds }, new List <SortCriteria <BSOSortField> >(), new PageRequest() { PageNumber = 1, PageSize = int.MaxValue }).Data; List <BSOInfo> listBSOAllDate = bsoBusinessLogic.BSO_Find( new BSOSearchCriteria() { StatusDateTo = bsoListModel.SearchCriteriaModel.StatusDateTo, DeliveryPointIds = bsoListModel.SearchCriteriaModel.DeliveryPointIds }, new List <SortCriteria <BSOSortField> >(), new PageRequest() { PageNumber = 1, PageSize = int.MaxValue }).Data; //фильтруем по DeliveryPointId //if (dicDeliveryPoint.Count > 0) //{ // listHistory = listHistory.Where(a => dicDeliveryPoint.Keys.Contains(a.DeliveryPointId)).ToList(); //} BSOReportForm10Full printedForm = new BSOReportForm10Full(listHistory, listBSOBeforeDate, listBSOinRangeDate, listBSOAllDate, ListDelivery.Distinct().ToList(), model.DateForm10FullFrom, model.DateForm10FullTo, CurrentUser); return(File(printedForm.GetExcel(), System.Net.Mime.MediaTypeNames.Application.Octet, string.Format("Отчет по движению ВС с группировкой по пулам номеров БСО. Форма №10.xls"))); }