public JResult AddRoleMenu(BaseRoleMenuModel model)
{
return _baseservice.AddRoleMenu(model);
}
/// <summary>
/// 给角色赋相应的权限
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddRoleMenu(BaseRoleMenuModel model)
{
//删除角色对应数据
const string sql = @"delete from sys_role_menu where roleid=@roleid;";
var menuids = model.menuid.TrimEnd(',').Split(',');
string sqlAdd = string.Empty;
foreach (var menuid in menuids)
{
sqlAdd = sqlAdd + "INSERT INTO `sys_role_menu` (`innerid`,`roleid`,`menuid`) VALUES (uuid(),'" + model.roleid + "','" + menuid + "');";
}
using (var conn = Helper.GetConnection())
{
var tran = conn.BeginTransaction();
try
{
conn.Execute(sql, new { roleid = model.roleid }, tran);
conn.Execute(sqlAdd, tran);
tran.Commit();
return 1;
}
catch (Exception ex)
{
tran.Rollback();
return 0;
}
}
}
