//获取用户列表
public static List <user_account> QueryUsers(string name, string mobile, string hosp, string dept, UserStatusType?status, QueryDateRangeType range, int page, out string Count)
{
using (var db = new RescueEntities())
{
var Querysql = from t in db.user_account select t;
if (!string.IsNullOrEmpty(name))
{
Querysql = Querysql.Where(t => t.name.Contains(name));
}
if (!string.IsNullOrEmpty(mobile))
{
Querysql = Querysql.Where(t => t.mobile_number.Contains(mobile));
}
if (!string.IsNullOrEmpty(hosp))
{
Querysql = Querysql.Where(t => t.hospital_name.Contains(hosp));
}
if (!string.IsNullOrEmpty(dept))
{
Querysql = Querysql.Where(t => t.department_name.Contains(dept));
}
if (status != null && status.Value.ToString() != "全部")
{
Querysql = Querysql.Where(t => t.status != UserStatusType.已删除 && t.status == status);
}
Count = Querysql.Count().ToString();
return(Querysql.OrderBy(t => t.status).Take(page * 15).Skip((page - 1) * 15).ToList());
}
}
public ActionResult UserListtable(string name = null, string mobile = null, string hosp = null, string dept = null, UserStatusType?status = null, QueryDateRangeType range = QueryDateRangeType.全部, string page = "1")
{
string Count = String.Empty;
var list = AdminMgr.QueryUsers(name, mobile, hosp, dept, status, range, Convert.ToInt32(page), out Count);
ViewBag.Count = Count;
return(PartialView("UserListtable", list));
}
