//批量删除用户权限
public bool DelAuths(int userId, List <String> auths)
{
var sqlList = new List <string>();
foreach (var auth in auths)
{
var str = auth.Split(',');
sqlList.Add("delete T_UserAuthority where AuthObjId=" + str[0] + " AND AuthType=" + str[1] + " AND UserId=" + userId + ")");
}
try
{
DbHelperSql.ExecuteSqlTran(sqlList);
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// 批量删除用户角色
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public bool DeleteUserInGroups(ArrayList list)
{
var sqlList = new ArrayList();
for (var i = 0; i < list.Count; i++)
{
var val = list[i].ToString().Split(',');
sqlList.Add("delete T_UserInGroups where GroupId=" + val[0] + " and UserId=" + val[1]);
}
try
{
DbHelperSql.ExecuteSqlTran(sqlList);
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// 批量添加用户角色
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public bool AddUserInGroups(ArrayList list)
{
var sqlList = new ArrayList();
for (var i = 0; i < list.Count; i++)
{
var val = list[i].ToString().Split(',');
sqlList.Add("insert into T_UserInGroups(GroupId,UserId) values (" + val[0] + "," + val[1] + ")");
}
try
{
DbHelperSql.ExecuteSqlTran(sqlList);
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// 批量添加权限
/// </summary>
/// <returns></returns>
public bool AddAuths(List <int> users, List <String> auths)
{
var sqlList = new List <string>();
foreach (var userId in users)
{
foreach (var auth in auths)
{
var str = auth.Split(',');
sqlList.Add("insert into T_UserAuthority(AuthObjId,AuthType,UserId) values(" + str[0] + "," + str[1] + "," + userId + ")");
}
}
try
{
DbHelperSql.ExecuteSqlTran(sqlList);
return(true);
}
catch
{
return(false);
}
}
