Exemplo n.º 1
0
        public ActionResult ExportTrouble()
        {
            var    troubleList = new List <HseSafetyTroubleView>();
            string txtDate     = Request["txtDate"];

            Expression <Func <HseSafetyTroubleEntity, bool> > predicate = x => x.Id > 0 && x.IsDeleted == false;

            if (!string.IsNullOrEmpty(txtDate))
            {
                DateTime dateTime = Convert.ToDateTime(txtDate);
                DateTime dateAdd  = dateTime.AddDays(1);
                predicate = predicate.AndAlso(a => a.OccurrenceDate == dateTime);
            }

            var list = _hseSafetyTroubleService.GetList <HseSafetyTroubleView>(predicate).OrderByDescending(x => x.Id).ToList();

            troubleList = (from s in list
                           select new HseSafetyTroubleView
            {
                Id = s.Id,
                ReportedUserName = s.ReportedUserName,
                CreatedUserID = s.CreatedUserID,
                OccurrenceDate = s.OccurrenceDate,
                Location = SafetyReportHelper.GetLocation(s.Location) == "" ? s.OtherLocation : SafetyReportHelper.GetLocation(s.Location),
                OtherLocation = s.OtherLocation,
                Description = s.Description,
                CreatedDate = s.CreatedDate
            }).ToList();

            return(ExportToTroubleCsv(troubleList));
        }
        public HseInjuredSafetyIncidentView GetSafetyReportById(int id, string type)
        {
            var safetyReport = new HseInjuredSafetyIncidentView();
            var _hseInjuredSafetyIncidentService = new BaseService <HseInjuredSafetyIncidentEntity>("CAAdmin");
            var _hseSafetyTroubleService         = new BaseService <HseSafetyTroubleEntity>("CAAdmin");

            if (type == "SafetyTrouble")
            {
                safetyReport = (from s in _hseSafetyTroubleService.Repository.Entities.ToList()
                                where s.Id == id && s.IsDeleted == false
                                select new HseInjuredSafetyIncidentView
                {
                    ReportedUserName = s.ReportedUserName,
                    CreatedUserID = s.CreatedUserID,
                    OccurrenceDate = s.OccurrenceDate,
                    Location = SafetyReportHelper.GetLocation(s.Location),
                    OtherLocation = s.OtherLocation,
                    Description = s.Description,
                    type = "SafetyTrouble",
                    SafetyReportImages = GetImgListById(id, type)
                }).FirstOrDefault();
            }
            else
            {
                safetyReport = (from s in _hseInjuredSafetyIncidentService.Repository.Entities.ToList()
                                where s.Id == id && s.IsDeleted == false
                                select new HseInjuredSafetyIncidentView
                {
                    PatientInfo = s.PatientInfo,
                    PatientLillyId = s.PatientLillyId,
                    PatientName = s.PatientName,
                    ReportedUserName = s.ReportedUserName,
                    CreatedUserID = s.CreatedUserID,
                    OccurrenceDate = s.OccurrenceDate,
                    Location = SafetyReportHelper.GetLocation(s.Location),
                    OtherLocation = s.OtherLocation,
                    InjuredType = SafetyReportHelper.GetInjuredType(s.InjuredType),
                    InjurySites = SafetyReportHelper.GetInjurySites(s.InjurySites),
                    OtherInjurySites = s.OtherInjurySites,
                    Description = s.Description,
                    type = "SafetyIncident",
                    SafetyReportImages = GetImgListById(id, type)
                }).FirstOrDefault();
            }

            return(safetyReport);
        }
Exemplo n.º 3
0
        public ActionResult ExportIncident()
        {
            var    incidentList = new List <HseInjuredSafetyIncidentView>();
            string txtDate      = Request["txtDate"];

            Expression <Func <HseInjuredSafetyIncidentEntity, bool> > predicate = x => x.Id > 0 && x.IsDeleted == false;

            if (!string.IsNullOrEmpty(txtDate))
            {
                DateTime dateTime = Convert.ToDateTime(txtDate);
                DateTime dateAdd  = dateTime.AddDays(1);
                predicate = predicate.AndAlso(a => a.OccurrenceDate == dateTime);
            }

            var list = _hseInjuredSafetyIncidentService.GetList <HseInjuredSafetyIncidentView>(predicate).OrderByDescending(x => x.Id).ToList();

            incidentList = (from m in list
                            select new HseInjuredSafetyIncidentView
            {
                Id = m.Id,
                PatientInfo = m.PatientInfo,
                PatientName = m.PatientName == null ? m.ReportedUserName : m.PatientName,
                PatientLillyId = m.PatientLillyId == null ? m.CreatedUserID : m.PatientLillyId,
                OccurrenceDate = m.OccurrenceDate,
                Location = SafetyReportHelper.GetLocation(m.Location) == "" ? m.OtherLocation : SafetyReportHelper.GetLocation(m.Location),
                OtherLocation = m.OtherLocation,
                InjuredType = SafetyReportHelper.GetInjuredType(m.InjuredType),
                InjurySites = SafetyReportHelper.GetInjurySites(m.InjurySites) == "" ? m.OtherInjurySites : SafetyReportHelper.GetInjurySites(m.InjurySites),
                OtherInjurySites = m.OtherInjurySites,
                Description = m.Description,
                ReportedUserName = m.ReportedUserName,
                CreatedUserID = m.CreatedUserID,
                CreatedDate = m.CreatedDate
            }).ToList();

            return(ExportToIncidentCsv(incidentList));
        }
Exemplo n.º 4
0
        public ActionResult GetIncidentList()
        {
            string txtDate = Request["txtDate"];
            Expression <Func <HseInjuredSafetyIncidentEntity, bool> > predicate;

            predicate = p => p.IsDeleted == false;

            if (!string.IsNullOrEmpty(txtDate))
            {
                DateTime dateTime = Convert.ToDateTime(txtDate);
                DateTime dateAdd  = dateTime.AddDays(1);
                predicate = predicate.AndAlso(a => a.OccurrenceDate == dateTime);
            }

            var param = new PageParameter();

            TryUpdateModel(param);
            //实现对用户和多条件的分页的查询,rows表示一共多少条,page表示当前第几页
            param.length = param.length == 0 ? 10 : param.length;
            var iTotal        = param.iRecordsTotal;
            var incidentCount = _hseInjuredSafetyIncidentService.Repository.Entities.Where(predicate).Count();

            // 取当前页
            var page = (int)Math.Floor(param.start / param.length * 1.0d) + 1;

            if (incidentCount != 0)
            {
                iTotal = incidentCount;
                var incidentList = _hseInjuredSafetyIncidentService.Repository.Entities.Where(predicate).OrderByDescending(o => o.OccurrenceDate).ToList().Skip((page - 1) * param.length).Take(param.length).ToList();

                var t = from m in incidentList
                        select new
                {
                    Id               = m.Id,
                    PatientInfo      = m.PatientInfo,
                    PatientName      = m.PatientName,
                    PatientLillyId   = m.PatientLillyId,
                    OccurrenceDate   = m.OccurrenceDate,
                    Location         = SafetyReportHelper.GetLocation(m.Location) == "" ? m.OtherLocation : SafetyReportHelper.GetLocation(m.Location),
                    OtherLocation    = m.OtherLocation,
                    InjuredType      = SafetyReportHelper.GetInjuredType(m.InjuredType),
                    InjurySites      = SafetyReportHelper.GetInjurySites(m.InjurySites) == "" ? m.OtherInjurySites : SafetyReportHelper.GetInjurySites(m.InjurySites),
                    OtherInjurySites = m.OtherInjurySites,
                    Description      = m.Description,
                    ReportedUserName = m.ReportedUserName,
                    CreatedUserID    = m.CreatedUserID,
                    CreatedDate      = m.CreatedDate
                };

                return(Json(new
                {
                    sEcho = param.draw,
                    iTotalRecords = iTotal,
                    iTotalDisplayRecords = iTotal,
                    aaData = t
                }, JsonRequestBehavior.AllowGet));
            }
            else
            {
                var t = from m in _hseInjuredSafetyIncidentService.Repository.Entities.Where(predicate).OrderByDescending(o => o.OccurrenceDate).ToList().Skip((page - 1) * param.length).Take(param.length).ToList()
                        select new
                {
                    Id               = m.Id,
                    PatientInfo      = m.PatientInfo,
                    PatientName      = m.PatientName,
                    PatientLillyId   = m.PatientLillyId,
                    OccurrenceDate   = m.OccurrenceDate,
                    Location         = SafetyReportHelper.GetLocation(m.Location) == "" ? m.OtherLocation : SafetyReportHelper.GetLocation(m.Location),
                    OtherLocation    = m.OtherLocation,
                    InjuredType      = SafetyReportHelper.GetInjuredType(m.InjuredType),
                    InjurySites      = SafetyReportHelper.GetInjurySites(m.InjurySites) == "" ? m.OtherInjurySites : SafetyReportHelper.GetInjurySites(m.InjurySites),
                    OtherInjurySites = m.OtherInjurySites,
                    Description      = m.Description,
                    ReportedUserName = m.ReportedUserName,
                    CreatedUserID    = m.CreatedUserID,
                    CreatedDate      = m.CreatedDate
                };

                return(Json(new
                {
                    sEcho = param.draw,
                    iTotalRecords = iTotal,
                    iTotalDisplayRecords = iTotal,
                    aaData = t
                }, JsonRequestBehavior.AllowGet));
            }
        }