public async Task <IActionResult> List(string searchContent, string seniorQueryJson, int page = 1, int limit = 10, string sidx = "CreateDt", string sord = "desc")
{
try
{
SysRole query = null;
if (!string.IsNullOrEmpty(seniorQueryJson))
{
query = Newtonsoft.Json.JsonConvert.DeserializeObject <SysRole>(seniorQueryJson);
}
System.Linq.Expressions.Expression <Func <SysRole, bool> > predicate = ExpressionBuilder.True <SysRole>();
predicate = predicate.And(b => b.Id > 0);
if (searchContent != null)
{
predicate = predicate.And(b => b.RoleName.IndexOf(searchContent) != -1);
}
PageInfo pageinfo = new PageInfo {
};
(List <SysRole> list, long count)datas = await SysRoleDAL.QueryAsync(predicate, null, pageinfo);
var lists = datas.list;
return(lists.GetJson <SysRole>(sidx, sord, page, limit, SysTool.GetPropertyNameArray <SysRole>()));
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <ActionResult> Update([FromBody] SysRoleView model)
{
var resdata = await AutoException.Excute <SysRole>(async (result) =>
{
model.UpdateBy = "admin";
model.UpdateDt = DateTime.Now;
var res = await SysRoleDAL.UpdateAsync(model);
result.Data = model;
if (!res)
{
throw new Exception("数据修改异常，JSON:" + Newtonsoft.Json.JsonConvert.SerializeObject(model));
}
else
{
if (!string.IsNullOrEmpty(model.authids))
{
string[] idstr = model.authids.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
List <SysRoleMenu> rolelist = (from p in idstr
select new SysRoleMenu
{
RoleId = model.Id,
MenuId = Convert.ToInt32(p),
Status = 1,
CreateDt = DateTime.Now,
CreateBy = model.UpdateBy
}).ToList();
await SysRoleMenuDAL.BatchInsertAsync(rolelist);
}
}
}, false);
return(Json(resdata));
}
public async Task <ActionResult> CreateModule(string id)
{
(List <SysRole> list, long count)role = await SysRoleDAL.QueryAsync(w => w.Status == 1);
ViewBag.RoleList = role.list.Select(s => new SelectListItem {
Text = s.RoleName, Value = s.Id.ToString()
}).ToList();
SysUser model = new SysUser()
{
};
return(View(model));
}
public async Task <ActionResult> Delete(string id)
{
var resdata = await AutoException.Excute <long>(async (result) =>
{
string[] idstr = id.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
foreach (var item in idstr)
{
var bl = await SysRoleDAL.DeleteAsync(Convert.ToInt32(item));
if (!bl)
{
throw new Exception("数据删除异常，ID:" + item);
}
}
}, true);
return(Json(resdata));
}
public async Task <ActionResult> AuthModule(string id)
{
//var roleMenus = await SysRoleMenuDAL.QueryUserRole(u => u.RoleId == Convert.ToInt32(id), null, null);
//(List<SysMenu> list, long count) menus = await SysMenuDAL.QueryAsync(w => w.Status == 1);
//ViewBag.Menus = menus.list.Select(s => new SelectListItem { Selected = roleMenus.list.Exists(ss => ss.RoleId == s.Id), Text = s.MenuName, Value = s.Id.ToString() }).ToList();
SysRole model = new SysRole()
{
};
if (!string.IsNullOrEmpty(id) && id != "0")
{
int _id = Convert.ToInt32(id);
model = await SysRoleDAL.GetByOneAsync(w => w.Id == _id);
}
return(View(model));
}
public async Task <ActionResult> UpdateModule(string id)
{
var userroles = await SysUserRoleDAL.QueryUserRole(u => u.UserId == Convert.ToInt32(id), null, null);
(List <SysRole> list, long count)role = await SysRoleDAL.QueryAsync(w => w.Status == 1);
ViewBag.RoleList = role.list.Select(s => new SelectListItem {
Selected = userroles.list.Exists(ss => ss.RoleId == s.Id), Text = s.RoleName, Value = s.Id.ToString()
}).ToList();
SysUser model = new SysUser()
{
};
if (!string.IsNullOrEmpty(id) && id != "0")
{
int _id = Convert.ToInt32(id);
model = await SysUserDAL.GetByOneAsync(w => w.Id == _id);
}
return(View(model));
}
