//得到用户的所有信息
public ActionResult GetAllUserInfos()
{
//json数据：{total:"",row:""}
//分页的数据
int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]);
int pageSize = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
////SearchName
string txtSearchUserName = Request["txtSerachUserName"];
//处理分页过滤事件
ModelDataQuery pm = new ModelDataQuery();
pm.pageIndex = pageIndex;
pm.pageSize = pageSize;
pm.UserName = txtSearchUserName;
pm.total = 0;
//放置依赖刷新
var data = from u in _iUserInfoService.LoadSearchData(pm)
select new { u.UserID, u.UserName, u.Password, u.CreateOperatorID, u.CreateOperatorName, u.CreateTime, u.ModiOperatorID, u.ModiOperatorName, u.ModiTime, u.Notes };
var result = new { total = pm.total, rows = data };
return(Json(result, JsonRequestBehavior.AllowGet));
}
//得到所有的用户权限信息
public ActionResult GetActionUserInfoShow()
{
//json数据：{total:"",row:""}
//
//分页的数据
//
int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]);
int pageSize = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
////SearchName
string txtResourceName = Request["txtResourceName"];
//处理分页过滤事件
ModelDataQuery pm = new ModelDataQuery();
pm.pageIndex = pageIndex;
pm.pageSize = pageSize;
pm.ResourceName = txtResourceName;
pm.total = 0;
////放置依赖刷新
var data = from u in t_resourceservice.LoadDataActionInfo(pm)
select new { u.ResourceID, u.ResourceName, u.ResDescription, u.CreateOperatorID, u.CreateOperatorName, u.CreateTime, u.ModiOperatorID, u.ModiOperatorName, u.ModiTime, u.Notes };
////var data = _userInfoService.LoadPagerEntities(pageSize, pageIndex, out total, u => true, true, u => u.ID);
var result = new { total = pm.total, rows = data };
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 实现对用户角色的绑定
/// </summary>
/// <returns></returns>
public ActionResult GetAllUserRoleInfo()
{
//首先获取从前台传递过来的参数
int pageIndex = Request["page"] == null ? 1 : Convert.ToInt32(Request["page"]);
int pageSize = Request["rows"] == null ? 10 : Convert.ToInt32(Request["rows"]);
//获取从前台传递过来的需要多条件模糊查询的数据
string txtSerachRoleName = Request["txtSerachRoleName"];
//定义对象，得到所有的参数
ModelDataQuery roleInfo = new ModelDataQuery();
roleInfo.pageIndex = pageIndex;
roleInfo.pageSize = pageSize;
roleInfo.RoleName = txtSerachRoleName;
roleInfo.total = 0;
//获取所有的总数输入
var data = from n in _roleService.LoadRoleInfo(roleInfo)
select new { n.RoleID, n.RoleName, n.RoleDescription, n.Notes };
//var data = _roleService.LoadPagerEntities(pageSize, pageIndex, out total, c => true, true, d => d.ID);
var jsonResult = new { total = roleInfo.total, rows = data };
return(Json(jsonResult, JsonRequestBehavior.AllowGet));
}
public IQueryable <T_Resource> LoadDataActionInfo(ModelDataQuery resourceInfo)
{
//首先拿到所有的数据
var temp = resource.LoadEntities(u => true);
//然后进行权限名称过滤
if (!string.IsNullOrEmpty(resourceInfo.ResourceName))
{
temp = temp.Where <T_Resource>(c => c.ResourceName.Contains(resourceInfo.ResourceName));
}
//返回总数
resourceInfo.total = temp.Count();
//最后实现分页
return(temp.Skip <T_Resource>(resourceInfo.pageSize * (resourceInfo.pageIndex - 1)).Take <T_Resource>(resourceInfo.pageSize).AsQueryable());
}
public IQueryable <T_User> LoadSearchData(ModelDataQuery query)
{
//拿到所有的数据
var temp = user.LoadEntities(u => true);
//进行的过滤
if (!string.IsNullOrEmpty(query.UserName))
{
temp = temp.Where <T_User>(u => u.UserName.Contains(query.UserName));
}
//返回总数
query.total = temp.Count();
//做分页查询
return(temp.Skip <T_User>(query.pageSize * (query.pageIndex - 1)).Take <T_User>(query.pageSize).AsQueryable());
//return temp.Skip(query.pageSize * (query.pageIndex - 1)).Take(query.pageSize).AsQueryable();
}
public IQueryable <T_Role> LoadRoleInfo(ModelDataQuery roleInfo)
{
//首先查询出所有的数据
var temp = role.LoadEntities(c => true);
//判断角色名称
if (!string.IsNullOrEmpty(roleInfo.RoleName))
{
temp = temp.Where <T_Role>(c => c.RoleName.Contains(roleInfo.RoleName));
}
//获取总数total
roleInfo.total = temp.Count();
//获取总数返回
return(temp.Skip <T_Role>(roleInfo.pageSize * (roleInfo.pageIndex - 1)).Take <T_Role>(roleInfo.pageSize).AsQueryable());
//return temp.Skip<T_Role>(roleInfo.pageSize * (roleInfo.pageIndex - 1)).Take(roleInfo.pageSize);
}
