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