private object PageUser(HttpContext context, PagedUserArgs <UserInfo> query)
{
var server = context.GetInstanceFromItems <UserRoleBLL>();
query = server.List(query);
var json = new Json(query);
json.ClassName = string.Empty;
return(json.ToJsonString());
}
/// <summary>
/// 根据角色 取用户
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private object PageUser(HttpContext context)
{
var query = new PagedUserArgs <UserInfo>();
query.PageIndex = context.Request.Form["PageIndex"].ToInt32(1);
query.PageSize = context.Request.Form["PageSize"].ToInt32(10);
query.NameIn = context.Request.Form["Name"];
query.Role = context.Request.Form["Role"].ToInt64();
query.IsInRole = context.Request.Form["IsIn"].ToInt32() > 0;
return(this.PageUser(context, query));
}
private string PageUser(HttpContext context)
{
PagedUserArgs <UserInfo> query = new PagedUserArgs <UserInfo>();
query.PageIndex = context.Request.Form["PageIndex"].ToInt32(1);
query.PageSize = context.Request.Form["PageSize"].ToInt32(10);
query.NameIn = context.Request.Form["Name"].Trim();
var server = context.GetInstanceFromItems <UserBLL>();
query = server.List(query);
var json = new Json(query);
json.ClassName = "";
return(json.ToJsonString());
}
private string PageResult(HttpContext context)
{
PagedUserArgs <UserInfo> query = new PagedUserArgs <UserInfo>();
query.PageIndex = context.Request.Form["PageIndex"].ToInt32(1);
query.PageSize = context.Request.Form["PageSize"].ToInt32(20);
query.NameIn = context.Request.Form["Name"].Trim();
query.FullNameIn = context.Request.Form["FullName"].Trim();
query.Sex = context.Request.Form["Sex"].ToInt32(0);
var server = context.GetInstanceFromCache <UserBLL>();
//server.SavePassword(1000, "admin");
query = server.List(query);
var json = new Json(query);
json.ClassName = "";
return(json.ToJsonString());
}
public PagedUserArgs <UserInfo> List(PagedUserArgs <UserInfo> query)
{
if (query == null)
{
query = new PagedUserArgs <UserInfo>();
}
var db = this.GetDatabase();
IQueryable <UserInfo> rs = this.GetQueryable(query, db.UserInfo);
query.ResultCount = rs.Count();
rs = rs.OrderByDescending(item => item.Id);
if (query.PageIndex > 0 && query.PageSize > 0)
{
rs = rs.Skip((query.PageIndex - 1) * query.PageSize).Take(query.PageSize);
}
query.Results = rs.ToArray();
var dataTable = new System.Data.DataTable();
dataTable.Columns.Add("Id", Int64.MinValue.GetType());
dataTable.Columns.Add("Name", string.Empty.GetType());
dataTable.Columns.Add("FullName", string.Empty.GetType());
foreach (var data in query.Results)
{
var dataRow = dataTable.NewRow();
dataRow["Id"] = data.Id;
dataRow["Name"] = data.Name;
dataRow["FullName"] = data.FullName;
dataTable.Rows.Add(dataRow);
}
var array = dataTable.ToArray <UserInfo>();
var list = dataTable.ToList <UserInfo>();
return(query);
}
public PagedUserArgs <UserInfo> List(PagedUserArgs <UserInfo> query)
{
if (query == null)
{
return(new PagedUserArgs <UserInfo>());
}
var db = this.GetDatabase();
var rs = db.UserInfo.Where(item => 1 == 1);
if (!string.IsNullOrEmpty(query.NameIn))
{
rs = rs.Where(item => item.Name.Contains(query.NameIn));
}
if (query.IsInRole)
{
rs = rs.Where(item => db.UserRole.Any(obj => obj.User == item.Id && obj.Role == query.Role));
}
else
{
rs = rs.Where(item => !db.UserRole.Any(obj => obj.User == item.Id && obj.Role == query.Role));
}
query.ResultCount = rs.Count();
rs = rs.OrderByDescending(item => item.Id);
if (query.PageIndex > 0 && query.PageSize > 0)
{
rs = rs.Skip((query.PageIndex - 1) * query.PageSize).Take(query.PageSize);
}
query.Results = rs.ToArray();
return(query);
}
public IQueryable <UserInfo> GetQueryable(PagedUserArgs <UserInfo> query, IQueryable <UserInfo> rs)
{
if (query == null)
{
return(rs);
}
if (!string.IsNullOrEmpty(query.NameIn))
{
rs = rs.Where(item => item.Name.Contains(query.NameIn));
}
if (!string.IsNullOrEmpty(query.FullNameIn))
{
rs = rs.Where(item => item.FullName.Contains(query.FullNameIn));
}
if (query.Sex > 0)
{
rs = rs.Where(item => item.Sex == query.Sex);
}
return(rs);
}
public PagedUserArgs <UserInfo> List(PagedUserArgs <UserInfo> query)
{
return(UserDAL.List(query));
}
