public ActionResult GetPoleIdById() { int id = int.Parse(Session["taskid"].ToString()); var result = (from im in medc.ps_inspectiontask_main join d in medc.ps_inspector_detail on im.id equals d.taskId where im.id == id select new { taskid = im.id, taskcode = im.inspectionTaskCode, taskname = im.inspectionTaskName, linecode = im.lineCode, linename = im.lineName, startpole = im.startPoleCode, endpole = im.endPoleCode, createuser = im.issuedByName, createtime = im.issuedTime, taskstatus = im.taskStatusName, finishtime = im.finishTime, common = im.common, inspetorname = d.inspectorName, linid = im.lineId }).FirstOrDefault(); InspectorDetail detas = new InspectorDetail() { taskid = result.taskid, taskcode = result.taskcode, taskname = result.taskname, linecode = result.linecode, linename = result.linename, startpole = result.startpole, endpole = result.endpole, createtime = result.createtime, createuser = result.createuser, taskstatus = result.taskstatus, finishtime = result.finishtime, common = result.common, inspetorname = result.inspetorname, linid = result.linid }; //查询所有缺陷类型信息 var bugtype = (from b in medc.ps_systemconfig where b.configName == "缺陷类型" && b.isStart == 1 select b).ToList(); //查询所有的缺陷级别信息 var buglevel = (from b in medc.ps_systemconfig where b.configName == "缺陷级别" && b.isStart == 1 select b).ToList(); var idetails = (from r in medc.ps_inspectiontask_detail where r.taskid == id select r).ToList(); DataSource ds = new DataSource(); ds.inspectordetails = detas; ds.bugtypelist = bugtype; ds.buglevellist = buglevel; ds.taskdetails = idetails; string jsonstr = JsonConvert.SerializeObject(ds); return(Content(jsonstr)); }
public ActionResult GetDetailData() { int id = int.Parse(Session["taskid"].ToString()); var result = (from im in medc.ps_inspectiontask_main where im.id == id select new { taskcode = im.inspectionTaskCode, taskname = im.inspectionTaskName, linename = im.lineName, startpole = im.startPoleCode, endpole = im.endPoleCode, createuser = im.issuedByName, createtime = im.issuedTime, taskstatus = im.taskStatusName, finishtime = im.finishTime, common = im.common, linid = im.lineId }).FirstOrDefault(); //获得巡检员信息列表 var inspectors = (from i in medc.ps_inspector_detail where i.taskId == id select i).ToList(); InspectorDetail detas = new InspectorDetail() { taskcode = result.taskcode, taskname = result.taskname, linename = result.linename, startpole = result.startpole, endpole = result.endpole, createtime = result.createtime, createuser = result.createuser, taskstatus = result.taskstatus, finishtime = result.finishtime, common = result.common, linid = result.linid }; //查询该线路下的所有杆塔信息 var polelist = (from p in medc.ps_pole_info where p.lineId == result.linid select p).ToList(); TaskBugDet bugdet = null; if (polelist.Count() > 0) { //查找第一个杆塔编号的详细信息 var taskdet = (from a in medc.ps_inspectiontask_detail join b in medc.ps_inspectiontask_main on a.taskid equals b.id where a.poleid == polelist.FirstOrDefault().id&&a.taskid == id select new { linecode = a.lineCode, polecode = a.poleCode, isbug = a.isBug, intactRate = a.intactRate, bugTypeName = a.bugTypeName, bugLevelName = a.bugLevelName, bugDesc = a.bugDesc, inspectTime = a.inspectTime, discovererName = a.discovererName, discoverTime = a.discoverTime, issuedByName = b.issuedByName, issuedTime = b.issuedTime }).FirstOrDefault(); if (taskdet != null) { bugdet = new TaskBugDet() { linecode = taskdet.linecode, polecode = taskdet.polecode, isbug = taskdet.isbug, intactRate = taskdet.intactRate, bugLevelName = taskdet.bugLevelName, bugTypeName = taskdet.bugTypeName, bugDesc = taskdet.bugDesc, inspectTime = taskdet.inspectTime, discovererName = taskdet.discovererName, discoverTime = taskdet.discoverTime, issuedByName = taskdet.issuedByName, issuedTime = taskdet.issuedTime }; } } DataSource ds = new DataSource(); ds.inspectordetails = detas; ds.polelist = polelist; if (inspectors.Count() > 0) { ds.insdet = inspectors; } else { ds.insdet = null; } if (bugdet != null) { ds.bugdet = bugdet; } else { ds.bugdet = null; } string jsonstr = JsonConvert.SerializeObject(ds); return(Content(jsonstr)); }