/// <summary>
/// 得到用户组拥有的权限菜单
/// </summary>
/// <returns></returns>
public List <SysAdminGrouprMenuModel> GetMenuByGroupID(int gid)
{
List <SysAdminGrouprMenuModel> list = new List <SysAdminGrouprMenuModel>();
string sqltxt = @"SELECT A.ID ,
A.GID ,
A.GName ,
A.MID ,
A.MName ,
A.MType ,
A.PermissionType ,
A.AddTime ,
A.IsEdit ,
B.FatherID ,
CASE a.PermissionType
WHEN 1 THEN '查看'
WHEN 2 THEN '编辑'
WHEN 3 THEN '修改'
WHEN 4 THEN '禁用'
END AS PermissionTypeName,
CASE a.MType
WHEN 1 THEN '菜单'
WHEN 2 THEN '按钮'
END AS MTypeName,
CASE a.IsEdit
WHEN 0 THEN '否'
WHEN 1 THEN '是'
END AS IsEditName
FROM dbo.SysAdminGrouprMenu A WITH ( NOLOCK )
INNER JOIN dbo.SysAdminMenu B WITH ( NOLOCK ) ON A.MID = B.ID
where GID=@gid";
SqlParameter[] paramter = { new SqlParameter("@gid", gid) };
DataTable dt = helper.Query(sqltxt, paramter).Tables[0];
foreach (DataRow item in dt.Rows)
{
SysAdminGrouprMenuModel model = new SysAdminGrouprMenuModel();
model.AddTime = DateTime.Parse(item["AddTime"].ToString());
model.FatherID = int.Parse(item["FatherID"].ToString());
model.GID = int.Parse(item["GID"].ToString());
model.GName = item["GName"].ToString();
model.ID = int.Parse(item["ID"].ToString());
model.IsEdit = int.Parse(item["IsEdit"].ToString());
model.MID = int.Parse(item["MID"].ToString());
model.MName = item["MName"].ToString();
model.MType = int.Parse(item["MType"].ToString());
model.PermissionType = int.Parse(item["PermissionType"].ToString());
model.PermissionTypeName = item["PermissionTypeName"].ToString();
model.MenuTypeName = item["MTypeName"].ToString();
model.IsEditName = item["IsEditName"].ToString();
list.Add(model);
}
return(list);
}
/// <summary>
/// 更改用户组菜单权限
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdatePermissionByID(SysAdminGrouprMenuModel model)
{
int rowcount = 0;
string sqltxt = @" UPDATE dbo.SysAdminGrouprMenu WITH(ROWLOCK)
SET PermissionType=@type
WHERE ID=@id";
SqlParameter[] paramter = { new SqlParameter("@type", model.PermissionType), new SqlParameter("@id", model.ID) };
rowcount = helper.ExecuteSql(sqltxt, paramter);
return(rowcount);
}
/// <summary>
/// 插入和修改菜单权限
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddUserGroupPermission(SysAdminGrouprMenuModel model)
{
int rowcount = 0;
string sqltxt = @"IF NOT EXISTS ( SELECT 1
FROM dbo.SysAdminGrouprMenu
WHERE GID = @GID
AND MID = @id )
BEGIN
INSERT INTO dbo.SysAdminGrouprMenu
( GID ,
GName ,
MID ,
MName ,
MType ,
PermissionType ,
AddTime ,
IsEdit
)
SELECT @GID ,
@GName ,
ID ,
MenuName ,
MenuType ,
@PermissionType ,
GETDATE() ,
CASE @GID
WHEN 1 THEN 0
ELSE 1
END AS IsEdit
FROM dbo.SysAdminMenu WITH ( NOLOCK )
WHERE ID = @id
END";
SqlParameter[] paramter =
{
new SqlParameter("@GID", model.GID),
new SqlParameter("@GName", model.GName),
new SqlParameter("@PermissionType", model.PermissionType),
new SqlParameter("@id", model.MID),
};
rowcount = helper.ExecuteSql(sqltxt, paramter);
return(rowcount);
}
public ActionResult AddPermissions(AddPermissionsViewModel model)
{
if (string.IsNullOrWhiteSpace(model.MenuListstr))
{
return(View());
}
string[] menuids = model.MenuListstr.TrimEnd('|').Split('|');
foreach (string item in menuids)
{
string[] idtype = item.Split(',');
SysAdminGrouprMenuModel gmodel = new SysAdminGrouprMenuModel();
gmodel.MID = int.Parse(idtype[0]);
gmodel.GID = model.gid;
gmodel.PermissionType = int.Parse(idtype[1]);
gmodel.GName = model.gname;
int rowcount = mbll.AddUserGroupPermission(gmodel);
}
return(RedirectToAction("GroupAndMenu", "SysSettings", new { area = "AdminArea" }));
}
public ActionResult GroupAndMenu(SysAdminGrouprMenuModel SinglePermissions)
{
int rowcount = mbll.UpdatePermissionByID(SinglePermissions);
return(RedirectToAction("GroupAndMenu", "SysSettings", new { area = "AdminArea" }));
}
/// <summary>
/// 更改用户组菜单权限
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdatePermissionByID(SysAdminGrouprMenuModel model)
{
return(dal.UpdatePermissionByID(model));
}
/// <summary>
/// 插入和修改菜单权限
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddUserGroupPermission(SysAdminGrouprMenuModel model)
{
return(dal.AddUserGroupPermission(model));
}
