private void baseLoad() { //绑定部门--没有矿级信息 var dep = from d in dc.Department where d.Deptnumber != SessionBox.GetUserSession().DeptNumber&& d.Deptnumber.Substring(0, 4) == SessionBox.GetUserSession().DeptNumber.Substring(0, 4) && d.Deptnumber.Substring(7) == "00" select new { deptID = d.Deptnumber, deptName = d.Deptname //, //pyall = dc.F_PINYIN(d.Deptname) }; DepartmentSearchStore.DataSource = dep; DepartmentSearchStore.DataBind(); //初始化地点 var place = from pl in dc.Place where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber select new { placID = pl.Placeid, placName = pl.Placename //, //pyall = dc.F_PINYIN(pl.Placename) }; PlaceSearchStore.DataSource = place; PlaceSearchStore.DataBind(); }
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; } }