public ActionResult GetPoleDataById()
{
int id = int.Parse(Request.Params["poleid"]);
//查找第一个杆塔编号的详细信息
var taskdet = (from a in medc.ps_inspector_detail
join b in medc.ps_inspectiontask_main
on a.taskId equals b.id
join c in medc.ps_inspectiontask_detail
on b.id equals c.taskid
where c.poleid == id
select new { linecode = c.lineCode, polecode = c.poleCode, bugtype = c.bugType, buglevel = c.bugLevel, isbug = c.isBug, intactRate = c.intactRate, bugTypeName = c.bugTypeName, bugLevelName = c.bugLevelName, bugDesc = c.bugDesc, inspectTime = c.inspectTime, inspectorName = c.discovererName, discovererName = c.discovererName, discoverTime = c.discoverTime, issuedByName = b.issuedByName, issuedTime = b.issuedTime }).FirstOrDefault();
TaskBugDet bugdet = null;
DataSource ds = new DataSource();
if (taskdet != null)
{
bugdet = new TaskBugDet()
{
linecode = taskdet.linecode,
polecode = taskdet.polecode,
isbug = taskdet.isbug,
intactRate = taskdet.intactRate,
bugtype = taskdet.bugtype,
buglevel = taskdet.buglevel,
bugLevelName = taskdet.bugLevelName,
bugTypeName = taskdet.bugTypeName,
bugDesc = taskdet.bugDesc,
inspectorName = taskdet.inspectorName,
inspectTime = taskdet.inspectTime,
discovererName = taskdet.discovererName,
discoverTime = taskdet.discoverTime,
issuedByName = taskdet.issuedByName,
issuedTime = taskdet.issuedTime
};
ds.bugdet = bugdet;
}
else
{
ds.bugdet = null;
}
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));
}
