コード例 #1
0
ファイル: PrintedFormsModel.cs プロジェクト: openzones/OMI
 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();
 }
コード例 #2
0
        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")));
        }