/// <summary> /// 显示员工列表 /// </summary> /// <returns></returns> public List <UserInfo> Show(string name = "", int id = -1) { string sql = "select UserInfo.ID,UName,RealName,Phone,Email,Name,Status from UserInfo join Depart on Depart.ID=DepartId"; List <UserInfo> list = SqlDbHelper.GetList <UserInfo>(sql); if (name != null) { list = list.Where(m => m.RealName.Contains(name)).ToList(); } if (id != -1) { list = list.Where(m => m.DepartId.Equals(id)).ToList(); } return(list); }
/// <summary> /// 绑定下拉列表 /// </summary> /// <returns></returns> public List <Depart> Bind() { List <Depart> list = SqlDbHelper.GetList <Depart>("select * from Depart"); return(list); }