private void Gridload() { //绑定隐患录入信息 var data = from yh in dc.Getyhinput from ny in dc.Nyhinput from m in dc.NyhinputMore where yh.Yhputinid == ny.Yhputinid && yh.Unitid == SessionBox.GetUserSession().DeptNumber //多人排查 如果为排查人也可看到 && yh.Yhputinid == m.Yhputinid && (ny.Inputpersonid == SessionBox.GetUserSession().PersonNumber || m.Personid == SessionBox.GetUserSession().PersonNumber) && yh.Intime >= System.DateTime.Today.AddDays(-7) //查询最近7天的信息 orderby yh.Intime descending select new { YHPutinID = yh.Yhputinid, DeptName = yh.Deptname, PlaceName = yh.Placename, YHContent = yh.Yhcontent, Remarks = yh.Remarks, BanCi = yh.Banci, Name = yh.Name, INTime = yh.Intime, PCTime = yh.Pctime, YHType = yh.Typename, Status = yh.Status }; if (data.Count() > 0) { YHputinStore.DataSource = data; YHputinStore.DataBind(); } }
private void Gridload() { //绑定隐患录入信息 var data = from yh in dc.Yhinput 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 d in dc.Department from pl in dc.Place where yh.Yhnumber == ha.HNumber && yh.Deptid == d.Deptnumber && yh.Placeid == pl.Placeid && ha.HNumber == hao.HNumber && ha.Processid == p.Processid && p.Worktaskid == w.Worktaskid && w.Professionalid == cs.Infoid && hao.HBjw == "引用" && yh.Inputpersonid == SessionBox.GetUserSession().PersonNumber && yh.Intime >= System.DateTime.Today.AddDays(-7) //查询最近7天的信息 orderby yh.Intime descending select new { YHPutinID = yh.Yhputinid, DeptName = d.Deptname, PlaceName = pl.Placename, YHContent = hao.HBm, Remarks = yh.Remarks, BanCi = yh.Banci, //Name = per.Name, PCTime = yh.Pctime, YHType = cs.Infoname, Status = yh.Status }; YHputinStore.DataSource = data; YHputinStore.DataBind(); }