.Net MVC 分页排序查询综合 - 系统用户类

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web.Mvc;
using System.Linq.Dynamic;
using System.Web.Routing;


namespace lktec.am7.Entity
{
public class SysUsers : Pager<SysUser>
{
#region 初始化对象
public SysUsers()

{

Db db=new Db();//Entity Framework DbContext类 数据对象集合

source = db.SysUser;//SysUser定义为 IDbSet<SysUser> SysUser
}
#endregion


#region 前台属性列表
/// <summary>
/// 地址参数信息
/// </summary>
protected override RouteValueDictionary routeData
{
get
{
RouteValueDictionary dict = base.routeData;
if (!string.IsNullOrWhiteSpace(UID)) dict.Add("UID", UID);
if (!string.IsNullOrWhiteSpace(Phone)) dict.Add("Phone", Phone);
if (!string.IsNullOrWhiteSpace(Email)) dict.Add("Email", Email);
if (!string.IsNullOrWhiteSpace(Department)) dict.Add("Department", Department);
if (Status.HasValue) dict.Add("Status", Status.Value);
return dict;
}
}
#endregion


#region 用户查询条件变量
/// <summary>
/// 用户账号
/// </summary>
public string UID { set; get; }


/// <summary>
/// 手机
/// </summary>
public string Phone { set; get; }


/// <summary>
/// 邮箱
/// </summary>
public string Email { set; get; }


/// <summary>
/// 部门
/// </summary>
public string Department { set; get; }


/// <summary>
/// 状态
/// </summary>
public int? Status { set; get; }
#endregion


#region 用户查询
/// <summary>
/// 更新查询条件
/// </summary>
protected override void Update()
{
#region 用户查询条件 这里填写用户针对某个对象进行查询
if (!string.IsNullOrWhiteSpace(UID)) source = source.Where(u => (u.UID.Contains(UID) || u.NickName.Contains(UID)));
if (!string.IsNullOrEmpty(Phone)) source = source.Where(u => (u.Telephone.Contains(Phone) || u.Mobile.Contains(Phone)));
if (!string.IsNullOrEmpty(Email)) source = source.Where(u => u.Email.Contains(Email));
if (!string.IsNullOrEmpty(Department)) source = source.Where(u => u.Department.Contains(Department));
if (Status.HasValue) { source = source.Where(u => u.Status == Status.Value); }
#endregion


base.Update();
}
#endregion
}
}