private void BuildRoleMenu(List <RoleMenuEntity> lstRoleMenu, GridView gvw)
{
for (int index = 0; index < gvw.Rows.Count; index++)
{
RoleMenuEntity roleMenu = new RoleMenuEntity();
HiddenField hdnAccessId = (HiddenField)gvw.Rows[index].FindControl("hdnAccessId");
HiddenField hdnMenuId = (HiddenField)gvw.Rows[index].FindControl("hdnMenuId");
CheckBox chkAdd = (CheckBox)gvw.Rows[index].FindControl("chkAdd");
CheckBox chkEdit = (CheckBox)gvw.Rows[index].FindControl("chkEdit");
CheckBox chkDel = (CheckBox)gvw.Rows[index].FindControl("chkDel");
CheckBox chkView = (CheckBox)gvw.Rows[index].FindControl("chkView");
int menuAccessId = 0;
int menuId = 0;
int.TryParse(hdnAccessId.Value, out menuAccessId);
int.TryParse(hdnMenuId.Value, out menuId);
roleMenu.MenuAccessID = menuAccessId;
roleMenu.MenuID = menuId;
roleMenu.CanAdd = chkAdd.Checked;
roleMenu.CanEdit = chkEdit.Checked;
roleMenu.CanDelete = chkDel.Checked;
roleMenu.CanView = chkView.Checked;
lstRoleMenu.Add(roleMenu);
}
}
public static IRoleMenu GetMenuAccessByUser(int userId, int menuId)
{
string strExecution = "[admin].[uspGetMenuAccessByUser]";
IRoleMenu roleMenu = null;
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddIntegerParam("@UserId", userId);
oDq.AddIntegerParam("@MenuId", menuId);
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
roleMenu = new RoleMenuEntity(reader);
}
reader.Close();
}
return(roleMenu);
}
public void AddMenuIds(long roleId, long[] menuIds)
{
var role = _dbContext.Roles.SingleOrDefault(t => t.Id == roleId);
if (role == null)
{
throw new ArgumentException("roleId不存在:" + roleId);
}
DeleteRoleMenus(roleId);
foreach (var menuId in menuIds)
{
var entity = new RoleMenuEntity()
{
RoleId = roleId,
MenuId = menuId,
};
_dbContext.RoleMenus.Add(entity);
}
_dbContext.SaveChanges();
}
public static List <IRoleMenu> GetMenuByRole(int roleId, int mainId)
{
string strExecution = "[admin].[uspGetMenuByRole]";
List <IRoleMenu> lstMenu = new List <IRoleMenu>();
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddIntegerParam("@RoleId", roleId);
oDq.AddIntegerParam("@MainId", mainId);
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
IRoleMenu menu = new RoleMenuEntity(reader);
lstMenu.Add(menu);
}
reader.Close();
}
return(lstMenu);
}
/// <summary>
/// 基础选单
/// </summary>
/// <param name="id">选单编号</param>
/// <param name="roleMenu">选单对象</param>
/// <returns></returns>
public List <TreeViewModel> Operation(string id, RoleMenuEntity roleMenu)
{
string[] arrayName = new string[4] {
"添加", "修改", "删除", "其他"
};
string[] arrayValue = new string[4] {
"NF-add", "NF-edit", "NF-delete", "NF-Details"
};
int[] checkstateArray = null;
if (roleMenu != null)
{
checkstateArray = new int[4] {
roleMenu.RmAdd, roleMenu.RmUpdate, roleMenu.RmDelete, roleMenu.RmOther
};
}
List <TreeViewModel> list = new List <TreeViewModel>();
TreeViewModel treeView;
for (int i = 0; i < 4; i++)
{
treeView = new TreeViewModel();
// 选中状态
treeView.checkstate = roleMenu == null ? 0: checkstateArray[i];
// 父节点
treeView.parentId = id;
treeView.complete = true;
treeView.hasChildren = false;
treeView.isexpand = true;
treeView.showcheck = true;
treeView.text = arrayName[i];
treeView.value = arrayValue[i];
treeView.ChildNodes = new List <TreeViewModel>();
// 编号Id
treeView.id = id + "-" + i;
treeView.parentnodes = id;
list.Add(treeView);
}
return(list);
}
public static IRoleMenu GetMenuAccessByUser(int userId, int menuId)
{
IRoleMenu roleMenu = null;
using (SqlDataHelper helper = new SqlDataHelper(ConnectionString))
{
helper.CommandText = "[webadmin].[uspGetMenuAccessByUser]";
helper.CommandType = CommandType.StoredProcedure;
helper.Parameters.Add("@UserId", userId);
helper.Parameters.Add("@MenuId", menuId);
helper.Open();
helper.ExecuteReader(CommandBehavior.CloseConnection);
while (helper.DataReader.Read())
{
roleMenu = new RoleMenuEntity(helper.DataReader);
}
helper.Close();
}
return(roleMenu);
}
public static List <IRoleMenu> GetMenuByRole(int roleId, int mainId)
{
List <IRoleMenu> lstMenu = new List <IRoleMenu>();
using (SqlDataHelper helper = new SqlDataHelper(ConnectionString))
{
helper.CommandText = "[webadmin].[uspGetMenuByRole]";
helper.CommandType = CommandType.StoredProcedure;
helper.Parameters.Add("@RoleId", roleId);
helper.Parameters.Add("@MainId", mainId);
helper.Open();
helper.ExecuteReader(CommandBehavior.CloseConnection);
while (helper.DataReader.Read())
{
IRoleMenu menu = new RoleMenuEntity(helper.DataReader);
lstMenu.Add(menu);
}
helper.Close();
}
return(lstMenu);
}
