Ejemplo n.º 1
0
        //perqfr 第二许可人对不上  jz 没有 地点没有
        public TicketEntity GetDetail(string ticketid, string ticketStr)
        {
            var       db = new TicketContext();
            DataTable dt;

            switch (ticketStr)
            {
            case "红雁池":
                dt = db.HyGetDetail(ticketid);
                break;

            default:
                dt = db.GetDetail(ticketid);
                break;
            }
            if (dt == null || dt.Rows.Count == 0)
            {
                return(null);
            }
            var result = new TicketEntity()
            {
                TicketId       = dt.Rows[0].Field <string>("gzpid"),
                TicketCode     = dt.Rows[0].Field <string>("gzpbh"),
                Unit           = dt.Rows[0].Field <string>("jz"),
                Category       = dt.Rows[0].Field <string>("category"),
                DutyPerson     = dt.Rows[0].Field <string>("pergzfzr"),
                DutyPerson2    = dt.Rows[0].Field <string>("pergzfzrx"),
                StartTime      = dt.Rows[0].Field <DateTime?>("xkgzdate"),
                Content        = dt.Rows[0].Field <string>("gznr"),
                ApprovePerson  = dt.Rows[0].Field <string>("perxkgzxkr"),
                ApprovePerson2 = dt.Rows[0].Field <string>("perqfr"),
                EndTime        = dt.Rows[0].Field <DateTime?>("pzjsdate"),
                TicketStatus   = dt.Rows[0].Field <string>("gzpstatus"),
                EndTime2       = dt.Rows[0].Field <DateTime?>("yqdate"),
                DeptName       = dt.Rows[0].Field <string>("bz"),
                WorkMate       = dt.Rows[0].Field <string>("cy"),
                Place          = dt.Rows[0].Field <string>("gzdd"),
                OtherTickets   = new Dictionary <string, int>()
            };

            switch (ticketStr)
            {
            case "红雁池":
                var OtherTickets = db.HYgetNum(ticketid);
                result.OtherTickets.Add("一级动火证", OtherTickets.FirstOrDefault(x => x.Key == "一级动火工作票").Value);
                result.OtherTickets.Add("二级动火证", OtherTickets.FirstOrDefault(x => x.Key == "二级动火工作票").Value);
                result.OtherTickets.Add("风险作业审批单", OtherTickets.FirstOrDefault(x => x.Key == "").Value);
                result.OtherTickets.Add("热控保护措施票", OtherTickets.FirstOrDefault(x => x.Key == "热控保护措施票").Value);
                result.OtherTickets.Add("继电保护措施票", OtherTickets.FirstOrDefault(x => x.Key == "继电保护措施票").Value);
                result.OtherTickets.Add("作业安全措施票", OtherTickets.FirstOrDefault(x => x.Key == "作业安全措施票").Value);
                break;

            default:
                result.OtherTickets.Add("一级动火证", db.GetNum1(result.TicketCode));
                result.OtherTickets.Add("二级动火证", db.GetNum2(result.TicketCode));
                result.OtherTickets.Add("风险作业审批单", db.GetNum3(result.TicketCode));
                result.OtherTickets.Add("热控保护措施票", db.GetNum4(result.TicketCode));
                result.OtherTickets.Add("继电保护措施票", db.GetNum5(result.TicketCode));
                result.OtherTickets.Add("作业安全措施票", db.GetNum6(result.TicketCode));
                break;
            }



            return(result);
        }
Ejemplo n.º 2
0
        public List <TicketEntity> GetStatistical(string deptname, string[] units, DateTime Start, DateTime End, string TeamType, string ticketStr)
        {
            var       db     = new TicketContext();
            var       result = new List <TicketEntity>();
            DataTable dt;

            switch (ticketStr)
            {
            case "红雁池":
                dt = db.HyGetStatistical(deptname, units, Start, End, TeamType);
                break;

            default:
                dt = db.GetStatistical(deptname, units, Start, End, TeamType);
                break;
            }

            if (dt == null && dt.Rows.Count == 0)
            {
                return(result);
            }



            foreach (DataRow item in dt.Rows)
            {
                var entity = new TicketEntity()
                {
                    TicketId      = item.Field <string>("gzpid"),
                    TicketCode    = item.Field <string>("gzpbh"),
                    Unit          = item.Field <string>("jz"),
                    Category      = item.Field <string>("category"),
                    DutyPerson    = item.Field <string>("pergzfzr"),
                    DutyPerson2   = item.Field <string>("pergzfzrx"),
                    StartTime     = item.Field <DateTime?>("xkgzdate"),
                    Content       = item.Field <string>("gznr"),
                    OtherTickets  = new Dictionary <string, int>(),
                    ApprovePerson = item.Field <string>("perxkgzxkr"),
                    EndTime       = item.Field <DateTime?>("pzjsdate"),
                    TicketStatus  = item.Field <string>("gzpstatus")
                };
                switch (ticketStr)
                {
                case "红雁池":
                    var OtherTickets = db.HYgetNum(entity.TicketId);
                    entity.OtherTickets.Add("一级动火证", OtherTickets.FirstOrDefault(x => x.Key == "一级动火工作票").Value);
                    entity.OtherTickets.Add("二级动火证", OtherTickets.FirstOrDefault(x => x.Key == "二级动火工作票").Value);
                    entity.OtherTickets.Add("风险作业审批单", OtherTickets.FirstOrDefault(x => x.Key == "").Value);
                    entity.OtherTickets.Add("热控保护措施票", OtherTickets.FirstOrDefault(x => x.Key == "热控保护措施票").Value);
                    entity.OtherTickets.Add("继电保护措施票", OtherTickets.FirstOrDefault(x => x.Key == "继电保护措施票").Value);
                    entity.OtherTickets.Add("作业安全措施票", OtherTickets.FirstOrDefault(x => x.Key == "作业安全措施票").Value);
                    break;

                default:
                    entity.OtherTickets.Add("一级动火证", db.GetNum1(entity.TicketCode));
                    entity.OtherTickets.Add("二级动火证", db.GetNum2(entity.TicketCode));
                    entity.OtherTickets.Add("风险作业审批单", db.GetNum3(entity.TicketCode));
                    entity.OtherTickets.Add("热控保护措施票", db.GetNum4(entity.TicketCode));
                    entity.OtherTickets.Add("继电保护措施票", db.GetNum5(entity.TicketCode));
                    entity.OtherTickets.Add("作业安全措施票", db.GetNum6(entity.TicketCode));
                    break;
                }

                result.Add(entity);
            }

            //var faultids = result.Select(x => x.FaultId).ToList();
            //IRepository rep = new RepositoryFactory().BaseRepository();
            //var query = from q in rep.IQueryable<FaultRelationEntity>()
            //            where faultids.Contains(q.FaultId)
            //            select q.FaultId;
            //var allocated = query.ToList();
            //result.ForEach(x => x.Allocated = allocated.Any(y => y == x.FaultId));

            return(result);
        }