private void Gridload()
{
//绑定三违录入信息
var data = from sw in dc.Nswinput
from ha in dc.Getswandhazusing
from per1 in dc.Person
from per2 in dc.Person
join pl in dc.Place on sw.Placeid equals pl.Placeid into gg
from ga in gg.DefaultIfEmpty()
where sw.Swid == ha.Swid &&
sw.Pcpersonid == per1.Personnumber && sw.Swpersonid == per2.Personnumber &&
ha.Deptnumber == SessionBox.GetUserSession().DeptNumber &&
(sw.Inputpersonid == SessionBox.GetUserSession().PersonNumber || sw.Pcpersonid == SessionBox.GetUserSession().PersonNumber)
orderby sw.Intime descending
select new
{
ID = sw.Id,
PlaceName = ga.Placename == null ? "已删除" : ga.Placename,
SWContent = ha.Swcontent,
BanCi = sw.Banci,
Levelname = ha.Levelname,
//Name = per.Name,
PCTime = sw.Pctime,
PCname = per1.Name,
Name = per2.Name,
Isend = sw.Isend.Value == 1 ? true : false,
sw.Remarks
};
SWinputStore.DataSource = data;
SWinputStore.DataBind();
}
private void Gridload()
{
//绑定三违录入信息
var data = from sw in dc.Swinput
from ha in dc.Hazards
from hao in dc.HazardsOre
from p in dc.Process
from w in dc.Worktasks
from cs in dc.CsBaseinfoset
from cs1 in dc.CsBaseinfoset
from pl in dc.Place
from per1 in dc.Person
from per2 in dc.Person
where sw.Swnumber.Trim() == ha.HNumber && sw.Placeid == pl.Placeid && ha.HNumber == hao.HNumber &&
sw.Pcpersonid == per1.Personnumber && sw.Swpersonid == per2.Personnumber &&
ha.Processid == p.Processid && p.Worktaskid == w.Worktaskid && w.Professionalid == cs.Infoid && hao.HBjw == "引用" &&
hao.SwLevelid == cs1.Infoid &&
(sw.Inputpersonid == SessionBox.GetUserSession().PersonNumber || sw.Pcpersonid == SessionBox.GetUserSession().PersonNumber)
orderby sw.Intime descending
select new
{
ID = sw.Id,
PlaceName = pl.Placename,
SWContent = hao.SwBm,
BanCi = sw.Banci,
Levelname = cs1.Infoname,
//Name = per.Name,
PCTime = sw.Pctime,
PCname = per1.Name,
Name = per2.Name,
Isend = sw.Isend.Value == 1?true:false,
sw.Remarks
};
SWinputStore.DataSource = data;
SWinputStore.DataBind();
}
