//修改权限
public bool UpdatePermission(PermissionIDListModel permissionIDListModel)
{
StringBuilder sbUpdatePermission = new StringBuilder();
//先删除所有权限
sbUpdatePermission.AppendLine("Delete from dbo.UserPermission Where UserID = " + permissionIDListModel.UserId);
sbUpdatePermission.AppendLine("Insert into dbo.UserPermission(UserID,ActionID)");
sbUpdatePermission.Append("Values");
foreach (PermissionActionID actionIDlist in permissionIDListModel.ActionIDList)
{
if (actionIDlist.ActionID == 0)
{
continue;
}
sbUpdatePermission.Append("(");
sbUpdatePermission.Append(permissionIDListModel.UserId + ",");
sbUpdatePermission.Append(actionIDlist.ActionID);
sbUpdatePermission.Append("),");
}
//移除最后一个字符','
string permissionSql = sbUpdatePermission.ToString().Substring(0, sbUpdatePermission.ToString().Length - 1);
int iResult = DBHelper.ExcuteNoQuerySql(permissionSql);
if (iResult >= 1)
{
return(true);
}
else
{
return(false);
}
}
//获取用户权限
public List <PermissionActionID> GetUserPermission(PermissionIDListModel permissionIDListModel)
{
List <PermissionActionID> permissionActionList = new List <PermissionActionID>();
DataTable dtUserPermission = userInfoDAL.GetUserPermission(permissionIDListModel);
permissionActionList = dtUserPermission.toList <PermissionActionID>();
return(permissionActionList);
}
//获取用户权限
public DataTable GetUserPermission(PermissionIDListModel permissionIDListModel)
{
StringBuilder sbSI = new StringBuilder();
sbSI.AppendLine("Select ActionID From dbo.UserPermission With(Nolock)");
sbSI.AppendLine("Where UserID =" + permissionIDListModel.UserId);
DataTable dtUserInfo = DBHelper.SearchSql(sbSI.ToString());
return(dtUserInfo);
}
//修改权限
public PermissionSetStatus UpdatePermission(PermissionIDListModel permissionIDListModel)
{
PermissionSetStatus permissionSetStatus = new PermissionSetStatus();
bool iResult = userInfoDAL.UpdatePermission(permissionIDListModel);
if (iResult)
{
permissionSetStatus.IsSucceed = true;
}
else
{
permissionSetStatus.IsSucceed = false;
}
return(permissionSetStatus);
}
public List <PermissionActionID> GetUserPermission(PermissionIDListModel permissionIDListModel)
{
return(userInfoBLL.GetUserPermission(permissionIDListModel));
}
public PermissionSetStatus SetPermission(PermissionIDListModel permissionIDListModel)
{
return(userInfoBLL.UpdatePermission(permissionIDListModel));
}
