public void PYsearch(string py, string store) { switch (store.Trim()) { case "DepartmentSearchStore": var dept = from d in dc.Department where d.Deptnumber.Substring(0, 4) == SessionBox.GetUserSession().DeptNumber.Substring(0, 4) && d.Deptnumber.Substring(7) == "00" && dc.F_PINYIN(d.Deptname).ToLower().Contains(py.ToLower()) select new { deptID = d.Deptnumber, deptName = d.Deptname }; DepartmentSearchStore.DataSource = dept; DepartmentSearchStore.DataBind(); break; case "PlaceSearchStore": var place = from pl in dc.Place where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber && dc.F_PINYIN(pl.Placename).ToLower().Contains(py.ToLower()) select new { placID = pl.Placeid, placName = pl.Placename //, //pyall = dc.F_PINYIN(pl.Placename) }; PlaceSearchStore.DataSource = place; PlaceSearchStore.DataBind(); break; } }
public void PYsearch(string py, string store) { if (py.Trim() == "") { return; } switch (store.Trim()) { case "placeStore": var place = from pl in dc.Place where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber && (dc.F_PINYIN(pl.Placename).ToLower().Contains(py.ToLower()) || pl.Placename.Contains(py.Trim())) select new { placID = pl.Placeid, placName = pl.Placename }; placeStore.DataSource = place; placeStore.DataBind(); break; case "PCpersonStore": var q = from p in dc.Person where p.Maindeptid == SessionBox.GetUserSession().DeptNumber && (dc.F_PINYIN(p.Name).ToLower().Contains(py.ToLower()) || p.Name.Contains(py.Trim())) select new { p.Personnumber, p.Name }; PCpersonStore.DataSource = q.Distinct(); PCpersonStore.DataBind(); break; } }
public void PYsearch(string py, string store) { HBBLL hb = new HBBLL(); switch (store.Trim()) { //case "perStore": // var data = hb.GetLeaderRole(py, SessionBox.GetUserSession().DeptNumber, 431); // var q = from p in data // select new // { // Personnumber = p.personnumber, // Name = p.name // }; // perStore.DataSource = q; // perStore.DataBind(); // break; case "placeStore": var place = from pl in dc.Place where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber&& pl.Placestatus == 1 && (dc.F_PINYIN(pl.Placename) + pl.Placename).ToLower().Contains(py.ToLower()) select new { pl.Placeid, pl.Placename }; placeStore.DataSource = place; placeStore.DataBind(); break; } }
public void PYsearch(string py, string store) { if (py.Trim() == "") { return; } switch (store.Trim()) { case "placeStore": var place = from pl in dc.Place where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber && (dc.F_PINYIN(pl.Placename).ToLower().Contains(py.ToLower()) || pl.Placename.Contains(py.Trim())) select new { placID = pl.Placeid, placName = pl.Placename }; placeStore.DataSource = place; placeStore.DataBind(); break; case "PersStore": if (cbbforcheckDept.SelectedIndex == -1) { return; } var q = from p in dc.Person where p.Areadeptid == cbbforcheckDept.SelectedItem.Value && (dc.F_PINYIN(p.Name).ToLower().Contains(py.ToLower()) || p.Name.Contains(py.Trim())) select new { p.Personnumber, p.Name }; PersStore.DataSource = q; PersStore.DataBind(); break; } }
public void PYsearch(string py, string store) { if (py.Trim() == "") { return; } switch (store.Trim()) { case "DeptStore": var dept = from d in dc.Department where (d.Deptnumber.Substring(0, 2) == "13" || d.Deptnumber.Substring(0, 4) == "2364") && //1303为集团公司处级,2364为设备管理中心 (d.Deptnumber.Substring(7) == "00" || d.Deptlevel == "正科级") && (d.Visualfield != 3 || d.Visualfield == null) && (dc.F_PINYIN(d.Deptname).ToLower().Contains(py.ToLower()) || d.Deptname.Contains(py.Trim())) select new { d.Deptnumber, d.Deptname }; DeptStore.DataSource = dept.Distinct(); DeptStore.DataBind(); break; case "personStore": var person = from pl in dc.Person where (pl.Areadeptid == hdnKindid.Value.ToString() || pl.Maindeptid == hdnKindid.Value.ToString()) && (pl.Visualfield != 3 || pl.Visualfield == null) && (dc.F_PINYIN(pl.Name).ToLower().Contains(py.ToLower()) || pl.Name.Contains(py.Trim())) select new { pl.Personnumber, pl.Name }; personStore.DataSource = person.Distinct(); personStore.DataBind(); break; } }
public void PYsearch(string py, string store) { if (py.Trim() == "") { return; } switch (store.Trim()) { case "WorkTaskStore": var gzrw = dc.Worktasks.Where( p => p.Professionalid == decimal.Parse(cbbSbsdy.SelectedItem.Value) && dc.F_PINYIN(p.Worktask).ToLower().Contains(py.ToLower()) ); WorkTaskStore.DataSource = gzrw; WorkTaskStore.DataBind(); break; } }
public void PYsearch(string py, string store) { if (py.Trim() == "") { return; } var person = from pl in dc.Person where pl.Maindeptid == cbbUnit.SelectedItem.Value && (dc.F_PINYIN(pl.Name).ToLower().Contains(py.ToLower()) || pl.Name.Contains(py.Trim())) select new { pl.Personnumber, pl.Name }; personStore.DataSource = person.Distinct(); personStore.DataBind(); }
public void PYsearch(string py, string store) { switch (store.Trim()) { case "placeStore": var place = from pl in dc.Place where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber&& pl.Placestatus == 1 && (dc.F_PINYIN(pl.Placename) + pl.Placename).ToLower().Contains(py.ToLower()) select new { pl.Placeid, pl.Placename }; placeStore.DataSource = place; placeStore.DataBind(); break; } }
private void placeLoad() { var place = from pl in dc.Place join a in dc.Placeareas on pl.Pareasid equals a.Pareasid into bb from ba in bb.DefaultIfEmpty() where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber select new { pl.Placeid, pl.Placename, py = dc.F_PINYIN(pl.Placename).ToLower(), ba.Pareasname }; Store1.DataSource = place; Store1.DataBind(); //bindPlan(); bindYH(GetPlanPlace()); }
public void PYsearch(string py, string store) { if (py.Trim() == "") { return; } switch (store.Trim()) { case "personStore": var person = from r in dc.Person from d in dc.Department where r.Deptid == d.Deptnumber && r.Maindeptid == SessionBox.GetUserSession().DeptNumber && (r.Pinyin.ToLower().Contains(py.ToLower()) || r.Lightnumber.ToLower().Contains(py.ToLower()) || r.Name.Contains(py.Trim())) select new { pernID = r.Personid, pernName = r.Name, pernLightNumber = r.Lightnumber, persNnmber = r.Personnumber, DeptName = d.Deptname }; personStore.DataSource = person; personStore.DataBind(); break; case "placeStore": var place = from pl in dc.Place where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber && (dc.F_PINYIN(pl.Placename).ToLower().Contains(py.ToLower()) || pl.Placename.Contains(py.Trim())) select new { placID = pl.Placeid, placName = pl.Placename }; placeStore.DataSource = place; placeStore.DataBind(); break; } }
public void PYsearch(string py, string store) { if (py.Trim() == "") { return; } switch (store.Trim()) { case "deptStore": if (PublicCode.BugCreate(SessionBox.GetUserSession().DeptNumber)) { string areadept = dc.Person.First(p => p.Personnumber == SessionBox.GetUserSession().PersonNumber).Areadeptid; var dept = from d in dc.Department where d.Deptnumber.Substring(0, 4) == SessionBox.GetUserSession().DeptNumber.Substring(0, 4) && d.Deptnumber != areadept && d.Fatherid != areadept && (dc.F_PINYIN(d.Deptname).ToLower().Contains(py.ToLower()) || d.Deptname.Contains(py.Trim())) select new { deptID = d.Deptnumber, deptName = d.Deptname }; deptStore.DataSource = dept.Distinct(); deptStore.DataBind(); } else { var dept = from d in dc.Department where d.Deptnumber.Substring(0, 4) == SessionBox.GetUserSession().DeptNumber.Substring(0, 4) && (d.Deptnumber.Substring(7) == "00" || d.Deptlevel == "正科级") && d.Deptstatus == "1" && (dc.F_PINYIN(d.Deptname).ToLower().Contains(py.ToLower()) || d.Deptname.Contains(py.Trim())) select new { deptID = d.Deptnumber, deptName = d.Deptname }; deptStore.DataSource = dept.Distinct(); deptStore.DataBind(); } break; case "placeStore": if (PublicCode.BugCreate(SessionBox.GetUserSession().DeptNumber)) { decimal areaid = (from p in dc.Person from d in dc.Department from a in dc.Placeareas where p.Personnumber == SessionBox.GetUserSession().PersonNumber && p.Areadeptid == d.Deptnumber && d.Deptname.Replace(" ", "") == a.Pareasname select a).First().Pareasid; var place = from pl in dc.Place where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber && pl.Pareasid != areaid && pl.Placestatus == 1 && (dc.F_PINYIN(pl.Placename).ToLower().Contains(py.ToLower()) || pl.Placename.Contains(py.Trim())) select new { placID = pl.Placeid, placName = pl.Placename }; placeStore.DataSource = place; placeStore.DataBind(); } else { var place = from pl in dc.Place where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber&& pl.Placestatus == 1 && (dc.F_PINYIN(pl.Placename).ToLower().Contains(py.ToLower()) || pl.Placename.Contains(py.Trim())) select new { placID = pl.Placeid, placName = pl.Placename }; placeStore.DataSource = place; placeStore.DataBind(); } break; case "yhStore": //修改多列显示 var hazard = from yh in dc.Getyhandhazusing where yh.Deptnumber == SessionBox.GetUserSession().DeptNumber && (yh.Conpyfirst.ToLower().Contains(py.ToLower()) || yh.Yhcontent.Contains(py.Trim()) || yh.Yhnumber.ToLower().Contains(py.ToLower())) select new { yhNumber = yh.Yhid, yhContent = yh.Yhcontent, Gzrwname = yh.Levelname, Gxname = yh.Typename }; yhStore.DataSource = hazard; yhStore.DataBind(); break; case "PCpersonStore": if (cbbJctype.SelectedItem.Value == "2") { //局端排查人 var person = from p in dc.Person from d in dc.Department where p.Areadeptid == d.Deptnumber && p.Visualfield == 3 && p.Personstatus == 1 && (dc.F_PINYIN(p.Name).ToLower().Contains(py.ToLower()) || p.Name.Contains(py.Trim())) select new { p.Personnumber, p.Name, d.Deptname }; PCpersonStore.DataSource = person; PCpersonStore.DataBind(); } else { var person = from pl in dc.Vgetpl from p in dc.Person where pl.Moduletag == "HiddenDanage_HDprocess" && pl.Operatortag == "YH_fcfk" && pl.Unitid == SessionBox.GetUserSession().DeptNumber && (dc.F_PINYIN(pl.Name).ToLower().Contains(py.ToLower()) || pl.Name.Contains(py.Trim())) && pl.Personnumber == p.Personnumber && p.Personstatus == 1 select new { pl.Personnumber, pl.Name }; PCpersonStore.DataSource = person.Distinct(); PCpersonStore.DataBind(); } break; case "WorkTaskStore": var gzrw = dc.Worktasks.Where( p => p.Professionalid == decimal.Parse(cbbSbsdy.SelectedItem.Value) && dc.F_PINYIN(p.Worktask).ToLower().Contains(py.ToLower()) ); WorkTaskStore.DataSource = gzrw; WorkTaskStore.DataBind(); break; } }
public void PYsearch(string py, string store) { if (py.Trim() == "") { return; } switch (store.Trim()) { case "deptStore": var dept = from d in dc.Department where d.Deptnumber.Substring(0, 4) == SessionBox.GetUserSession().DeptNumber.Substring(0, 4) && d.Deptnumber.Substring(7) == "00" && (dc.F_PINYIN(d.Deptname).ToLower().Contains(py.ToLower()) || d.Deptname.Contains(py.Trim())) select new { deptID = d.Deptnumber, deptName = d.Deptname }; deptStore.DataSource = dept; deptStore.DataBind(); break; case "placeStore": var place = from pl in dc.Place where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber && (dc.F_PINYIN(pl.Placename).ToLower().Contains(py.ToLower()) || pl.Placename.Contains(py.Trim())) select new { placID = pl.Placeid, placName = pl.Placename }; placeStore.DataSource = place; placeStore.DataBind(); break; case "yhStore": //修改多列显示 //var hazard = from hd in dc.Gethazardusing // from ore in dc.HazardsOre // where hd.HNumber==ore.HNumber && hd.Deptnumber == SessionBox.GetUserSession().DeptNumber // && (ore.HFPinyin.ToLower().Contains(py.ToLower()) || ore.HBm.Contains(py.Trim())) // select new // { // yhNumber = hd.HNumber, // yhContent = hd.HBm, // hd.Gzrwname // }; var hazard = from ha in dc.Hazards from ore in dc.HazardsOre from p in dc.Process from w in dc.Worktasks where ha.HNumber == ore.HNumber && ha.Processid == p.Processid && p.Worktaskid == w.Worktaskid && ore.Deptnumber == SessionBox.GetUserSession().DeptNumber&& ore.HBjw == "引用" && // && ore.YhSwBjw=="隐患" (ore.HFPinyin.ToLower().Contains(py.ToLower()) || ore.HBm.Contains(py.Trim())) select new { yhNumber = ha.HNumber, yhContent = ore.HBm, Gzrwname = w.Worktask, Gxname = p.Name }; yhStore.DataSource = hazard; yhStore.DataBind(); break; case "PCpersonStore": var person = from pl in dc.Vgetpl where pl.Moduletag == "HiddenDanage_HDprocess" && pl.Operatortag == "YH_fcfk" && pl.Unitid == SessionBox.GetUserSession().DeptNumber && (dc.F_PINYIN(pl.Name).ToLower().Contains(py.ToLower()) || pl.Name.Contains(py.Trim())) select new { pl.Personnumber, pl.Name }; PCpersonStore.DataSource = person; PCpersonStore.DataBind(); break; case "WorkTaskStore": var gzrw = dc.Worktasks.Where( p => p.Professionalid == decimal.Parse(cbbSbsdy.SelectedItem.Value) && dc.F_PINYIN(p.Worktask).ToLower().Contains(py.ToLower()) ); WorkTaskStore.DataSource = gzrw; WorkTaskStore.DataBind(); break; } }
public void PYsearch(string py, string store) { if (py.Trim() == "") { return; } switch (store.Trim()) { case "personStore": if (PublicCode.BugCreate(SessionBox.GetUserSession().DeptNumber)) { string areadept = dc.Person.First(p => p.Personnumber == SessionBox.GetUserSession().PersonNumber).Areadeptid; var person = from r in dc.Person from d in dc.Department where r.Deptid == d.Deptnumber && r.Maindeptid == SessionBox.GetUserSession().DeptNumber && r.Areadeptid != areadept && r.Personstatus == 1 && (r.Pinyin.ToLower().Contains(py.ToLower()) || r.Lightnumber.ToLower().Contains(py.ToLower()) || r.Name.Contains(py.Trim())) select new { pernID = r.Personid, pernName = r.Name, pernLightNumber = r.Lightnumber, persNnmber = r.Personnumber, DeptName = d.Deptname }; personStore.DataSource = person; personStore.DataBind(); } else { var person = from r in dc.Person from d in dc.Department where r.Deptid == d.Deptnumber && r.Maindeptid == SessionBox.GetUserSession().DeptNumber&& r.Personstatus == 1 && (r.Pinyin.ToLower().Contains(py.ToLower()) || r.Lightnumber.ToLower().Contains(py.ToLower()) || r.Name.Contains(py.Trim())) select new { pernID = r.Personid, pernName = r.Name, pernLightNumber = r.Lightnumber, persNnmber = r.Personnumber, DeptName = d.Deptname }; personStore.DataSource = person; personStore.DataBind(); } break; case "placeStore": if (PublicCode.BugCreate(SessionBox.GetUserSession().DeptNumber)) { decimal areaid = (from p in dc.Person from d in dc.Department from a in dc.Placeareas where p.Personnumber == SessionBox.GetUserSession().PersonNumber && p.Areadeptid == d.Deptnumber && d.Deptname.Replace(" ", "") == a.Pareasname select a).First().Pareasid; var place = from pl in dc.Place where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber && pl.Pareasid != areaid && (dc.F_PINYIN(pl.Placename).ToLower().Contains(py.ToLower()) || pl.Placename.Contains(py.Trim())) select new { placID = pl.Placeid, placName = pl.Placename }; placeStore.DataSource = place; placeStore.DataBind(); } else { var place = from pl in dc.Place where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber&& pl.Placestatus == 1 && (dc.F_PINYIN(pl.Placename).ToLower().Contains(py.ToLower()) || pl.Placename.Contains(py.Trim())) select new { placID = pl.Placeid, placName = pl.Placename }; placeStore.DataSource = place; placeStore.DataBind(); } break; case "yhStore": var hazard = from yh in dc.Getswandhazusing where yh.Deptnumber == SessionBox.GetUserSession().DeptNumber && (yh.Conpyfirst.ToLower().Contains(py.ToLower()) || yh.Swcontent.Contains(py.Trim()) || yh.Swnumber.ToLower().Contains(py.ToLower())) select new { yhNumber = yh.Swid, yhContent = yh.Swcontent, Gzrwname = yh.Levelname, Gxname = yh.Typename }; yhStore.DataSource = hazard; yhStore.DataBind(); break; case "PCpersonStore": var person1 = from pl in dc.Vgetpl from p in dc.Person where pl.Moduletag == "HiddenDanage_HDprocess" && pl.Operatortag == "YH_fcfk" && pl.Unitid == SessionBox.GetUserSession().DeptNumber && (dc.F_PINYIN(pl.Name).ToLower().Contains(py.ToLower()) || pl.Name.Contains(py.Trim())) && pl.Personnumber == p.Personnumber && p.Personstatus == 1 select new { pl.Personnumber, pl.Name }; PCpersonStore.DataSource = person1.Distinct(); PCpersonStore.DataBind(); break; case "WorkTaskStore": var gzrw = dc.Worktasks.Where( p => p.Professionalid == decimal.Parse(cbbSbsdy.SelectedItem.Value) && dc.F_PINYIN(p.Worktask).ToLower().Contains(py.ToLower()) ); WorkTaskStore.DataSource = gzrw; WorkTaskStore.DataBind(); break; } }