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;
}
}
