//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); }
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); }