public async Task <ActionResult> UpdateModule(string id)
{
//获取菜单已经绑定的按钮
var menubuttons = await SysMenuButtonDAL.QueryAsync(u => u.MenuID == Convert.ToInt32(id), null, null);
//回去权限按钮字典
(List <SysDictionary> list, long count)buttons = await SysDictionaryDAL.QueryAsync(w => w.Status == 1 && w.Parent.DictNo == AuthorizeName.PermissionButton);
ViewBag.ButtonList = buttons.list.Select(s => new SelectListItem
{
Text = s.DictName,
Value = s.DictNo.ToString(),
Selected = menubuttons.list.Exists(e => e.ButtonCode == s.DictNo)
}).ToList();
(List <SysMenu> list, long count)menus = await SysMenuDAL.QueryAsync(w => w.Status == 1);
ViewBag.SysMenuList = menus.list.Select(s => new SelectListItem
{
Text = s.MenuName,
Value = s.Id.ToString()
}).ToList();
SysMenuView model = new SysMenuView()
{
};
if (!string.IsNullOrEmpty(id) && id != "0")
{
int _id = Convert.ToInt32(id);
var tempModel = await new SysMenuDAL().GetByOneAsync(w => w.Id == _id);
model = _mapper.Map <SysMenuView>(tempModel);
}
return(View(model));
}
public async Task <ActionResult> CreateModule(string id, string parentid = "")
{
(List <SysDictionary> list, long count)buttons = await SysDictionaryDAL.QueryAsync(w => w.Status == 1 && w.Parent.DictNo == AuthorizeName.PermissionButton);
ViewBag.ButtonList = buttons.list.Select(s => new SelectListItem {
Text = s.DictName, Value = s.DictNo.ToString()
}).ToList();
(List <SysMenu> list, long count)menus = await SysMenuDAL.QueryAsync(w => w.Status == 1);
//var lists = menus.list.Select(s => new SysMenuTreeNode
//{
// name = s.MenuName,
// id = s.Id.ToString()
//}).ToList();
ViewBag.SysMenuList = menus.list.Select(s => new SelectListItem {
Text = s.MenuName, Value = s.Id.ToString()
}).ToList();
SysMenuView model = new SysMenuView()
{
Status = 1
};
if (!string.IsNullOrEmpty(parentid))
{
model.ParentID = Convert.ToInt32(parentid);
}
return(View(model));
}
public async Task <ActionResult> UpdateModule(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> GetTree(long id, int type = 1)
{
//已授权的角色菜单
var roleMenus = await SysRoleMenuDAL.QueryUserRole(u => u.RoleId == Convert.ToInt32(id), null, null);
var roleButtons = await SysRoleButtonDAL.QueryAsync(u => u.RoleId == Convert.ToInt32(id), null, null);
//所有状态为有效的菜单
(List <SysMenu> list, long count)menus = await SysMenuDAL.QueryAsync(w => w.Status == 1);
var lists = menus.list.Select(s =>
{
var btns = s.SysMenuButtons ?? new List <SysMenuButton>();
var newBtns = btns.Select(b => new TreeNode
{
id = b.Id.ToString(),
name = b.ButtonCode,
title = b.ButtonName,
ischecked = roleButtons.list.Exists(e => e.ButtonId == b.Id)
}).ToList();
var strbtns = Newtonsoft.Json.JsonConvert.SerializeObject(newBtns);
return(new SysMenuTreeNode
{
ischecked = roleMenus.list.Exists(ss => ss.MenuId == s.Id),
name = s.MenuName,
title = s.MenuName,
pid = (s.ParentID ?? 0).ToString(),
id = s.Id.ToString(),
//buttons = newBtns,
jsonButtons = strbtns
});
}).ToList();
return(Json(lists));
}
public SysMenuBLL()
{
handle = new SysMenuDAL();
}
public void Initialize()
{
var sysUserDAL = new SysUserDAL();
var sysMenuDAL = new SysMenuDAL();
var sysDictionary = new SysDictionaryDAL();
var siteInfoDAL = new SiteInfoDAL();
if (sysUserDAL.Count() == 0)
{
//初始化用户
sysUserDAL.Insert(new Entity.SysUser
{
UserName = "******",
Password = "******",
UserType = Entity.Enum.UserType.SuperUser,
CreateBy = "admin",
CreateDt = DateTime.Now,
Email = "*****@*****.**"
});
}
if (sysMenuDAL.Count() == 0)
{
var menuList = new List <SysMenu>();
var menuid1 = sysMenuDAL.Insert(new SysMenu {
MenuName = "权限管理", ParentID = 0, Description = "", MenuUrl = "#", IconUrl = "#", Sort = 1, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
var menuList1 = new List <SysMenu>();
menuList1.Add(new SysMenu {
MenuName = "用户管理", ParentID = menuid1, Description = "", MenuUrl = "/Admin/SysUser/Index", IconUrl = "#", Sort = 2, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
menuList1.Add(new SysMenu {
MenuName = "角色管理", ParentID = menuid1, Description = "", MenuUrl = "/Admin/SysRole/Index", IconUrl = "#", Sort = 3, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
menuList1.Add(new SysMenu {
MenuName = "菜单管理", ParentID = menuid1, Description = "", MenuUrl = "/Admin/SysMenu/Index", IconUrl = "#", Sort = 4, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
sysMenuDAL.BatchInsert(menuList1);
var menuList2 = new List <SysMenu>();
var menuid2 = sysMenuDAL.Insert(new SysMenu {
MenuName = "文章管理", ParentID = 0, Description = "", MenuUrl = "#", IconUrl = "#", Sort = 1, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
menuList2.Add(new SysMenu {
MenuName = "文章列表", ParentID = menuid2, Description = "", MenuUrl = "/Admin/Article/Index", IconUrl = "#", Sort = 6, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
menuList2.Add(new SysMenu {
MenuName = "文章分类", ParentID = menuid2, Description = "", MenuUrl = "/Admin/ArticleType/Index", IconUrl = "#", Sort = 7, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
sysMenuDAL.BatchInsert(menuList2);
var menuList3 = new List <SysMenu>();
var menuid3 = sysMenuDAL.Insert(new SysMenu {
MenuName = "系统设置", ParentID = 0, Description = "", MenuUrl = "#", IconUrl = "#", Sort = 99, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
menuList3.Add(new SysMenu {
MenuName = "字典管理", ParentID = menuid3, Description = "", MenuUrl = "/Admin/SysDictionary/Index", IconUrl = "#", Sort = 9, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
menuList3.Add(new SysMenu {
MenuName = "站点信息", ParentID = menuid3, Description = "", MenuUrl = "/Admin/SiteInfo/Index", IconUrl = "#", Sort = 9, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
menuList3.Add(new SysMenu {
MenuName = "更新日志", ParentID = menuid3, Description = "", MenuUrl = "/Admin/SysUpdateLog/Index", IconUrl = "#", Sort = 9, Status = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
sysMenuDAL.BatchInsert(menuList3);
}
if (sysDictionary.Count() == 0)
{
var dic1 = (new SysDictionary {
DictName = "权限按钮", DictNo = "PermissionButton", ParentID = 0, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
long id1 = sysDictionary.Insert(dic1);
var dicList = new List <SysDictionary>();
dicList.Add(new SysDictionary {
DictName = "新增", DictNo = "add", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
dicList.Add(new SysDictionary {
DictName = "修改", DictNo = "update", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
dicList.Add(new SysDictionary {
DictName = "删除", DictNo = "delete", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
dicList.Add(new SysDictionary {
DictName = "导出", DictNo = "export", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
dicList.Add(new SysDictionary {
DictName = "导入", DictNo = "import", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
dicList.Add(new SysDictionary {
DictName = "打印", DictNo = "Print", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
dicList.Add(new SysDictionary {
DictName = "审核", DictNo = "Auth", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
dicList.Add(new SysDictionary {
DictName = "查看", DictNo = "show", ParentID = id1, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
sysDictionary.BatchInsert(dicList);
var dic2 = (new SysDictionary {
DictName = "站点设置", DictNo = "SiteSetting", ParentID = 0, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
long id2 = sysDictionary.Insert(dic2);
var dic3 = (new SysDictionary {
DictName = "简语描述", DictNo = "Index_Sketch", ParentID = id2, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
long id3 = sysDictionary.Insert(dic3);
var dicList2 = new List <SysDictionary>();
dicList2.Add(new SysDictionary {
DictName = "字典配置1", DictNo = "01", ParentID = id3, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
dicList2.Add(new SysDictionary {
DictName = "字典配置2", DictNo = "02", ParentID = id3, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
dicList2.Add(new SysDictionary {
DictName = "字典配置3", DictNo = "03", ParentID = id3, Sort = 1, CreateDt = DateTime.Now, CreateBy = "admin"
});
sysDictionary.BatchInsert(dicList2);
}
if (siteInfoDAL.Count() == 0)
{
var siteinfo = (new SiteInfo
{
SiteName = "FreeSql",
Status = 1,
Headline = ".NETCore最方便的ORM",
Abstract = "FreeSql 是一个功能强大的 .NETStandard 库，用于对象关系映射程序(O/RM)，支持 .NETCore 2.1+ 或 .NETFramework 4.6.1+",
CreateDt = DateTime.Now,
CreateBy = "admin"
});
siteInfoDAL.Insert(siteinfo);
}
}
public SysMenuBLL()
{
dal = new SysMenuDAL();
}
