public void Delete(int groupId)
{
var parms = new IDataParameter[]
{
GetParameter(ParmGroupId, EDataType.Integer, groupId)
};
ExecuteNonQuery(SqlDelete, parms);
UserGroupManager.ClearCache();
}
public void Delete(int groupId)
{
var sqlString = $"DELETE FROM {TableName} WHERE Id = @Id";
var parms = new IDataParameter[]
{
GetParameter("@Id", DataType.Integer, groupId)
};
ExecuteNonQuery(sqlString, parms);
UserGroupManager.ClearCache();
}
public void Update(UserGroupInfo groupInfo)
{
var updateParms = new IDataParameter[]
{
GetParameter(ParmGroupName, EDataType.NVarChar, 50, groupInfo.GroupName),
GetParameter(ParmIsDefault, EDataType.VarChar, 18, groupInfo.IsDefault.ToString()),
GetParameter(ParmDescription, EDataType.NVarChar, 255, groupInfo.Description),
GetParameter(ParmExtendValues, EDataType.NText, groupInfo.Additional.ToString()),
GetParameter(ParmGroupId, EDataType.Integer, groupInfo.GroupId)
};
ExecuteNonQuery(SqlUpdate, updateParms);
UserGroupManager.ClearCache();
}
public void Update(UserGroupInfo groupInfo)
{
var sqlString = $@"UPDATE {TableName} SET
{nameof(UserGroupInfo.GroupName)} = @{nameof(UserGroupInfo.GroupName)},
{nameof(UserGroupInfo.AdminName)} = @{nameof(UserGroupInfo.AdminName)}
WHERE {nameof(UserGroupInfo.Id)} = @{nameof(UserGroupInfo.Id)}";
IDataParameter[] parameters =
{
GetParameter(nameof(UserGroupInfo.GroupName), DataType.VarChar, 200, groupInfo.GroupName),
GetParameter(nameof(UserGroupInfo.AdminName), DataType.VarChar, 200, groupInfo.AdminName),
GetParameter(nameof(UserGroupInfo.Id), DataType.Integer, groupInfo.Id)
};
ExecuteNonQuery(sqlString, parameters);
UserGroupManager.ClearCache();
}
public int Insert(UserGroupInfo groupInfo)
{
var sqlString =
$@"
INSERT INTO {TableName} (
{nameof(UserGroupInfo.GroupName)},
{nameof(UserGroupInfo.AdminName)}
) VALUES (
@{nameof(UserGroupInfo.GroupName)},
@{nameof(UserGroupInfo.AdminName)}
)";
var parms = new IDataParameter[]
{
GetParameter($"@{nameof(UserGroupInfo.GroupName)}", DataType.VarChar, 200, groupInfo.GroupName),
GetParameter($"@{nameof(UserGroupInfo.AdminName)}", DataType.VarChar, 200, groupInfo.AdminName)
};
var groupId = ExecuteNonQueryAndReturnId(TableName, nameof(UserGroupInfo.Id), sqlString, parms);
UserGroupManager.ClearCache();
return(groupId);
}
public int Insert(UserGroupInfo groupInfo)
{
int groupId;
var sqlString = "INSERT INTO bairong_UserGroup (GroupName, IsDefault, Description, ExtendValues) VALUES (@GroupName, @IsDefault, @Description, @ExtendValues)";
var insertParms = new IDataParameter[]
{
GetParameter(ParmGroupName, EDataType.NVarChar, 50, groupInfo.GroupName),
GetParameter(ParmIsDefault, EDataType.VarChar, 18, groupInfo.IsDefault.ToString()),
GetParameter(ParmDescription, EDataType.NVarChar, 255, groupInfo.Description),
GetParameter(ParmExtendValues, EDataType.NText, groupInfo.Additional.ToString())
};
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
groupId = ExecuteNonQueryAndReturnId(trans, sqlString, insertParms);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
UserGroupManager.ClearCache();
return(groupId);
}
public IHttpActionResult Submit([FromBody] UserGroupInfo itemObj)
{
try
{
var request = new AuthenticatedRequest();
if (!request.IsAdminLoggin ||
!request.AdminPermissionsImpl.HasSystemPermissions(ConfigManager.SettingsPermissions.User))
{
return(Unauthorized());
}
if (itemObj.Id == -1)
{
if (UserGroupManager.IsExists(itemObj.GroupName))
{
return(BadRequest("保存失败，已存在相同名称的用户组！"));
}
var groupInfo = new UserGroupInfo
{
GroupName = itemObj.GroupName,
AdminName = itemObj.AdminName
};
DataProvider.UserGroupDao.Insert(groupInfo);
request.AddAdminLog("新增用户组", $"用户组:{groupInfo.GroupName}");
}
else if (itemObj.Id == 0)
{
ConfigManager.SystemConfigInfo.UserDefaultGroupAdminName = itemObj.AdminName;
DataProvider.ConfigDao.Update(ConfigManager.Instance);
UserGroupManager.ClearCache();
request.AddAdminLog("修改用户组", "用户组:默认用户组");
}
else if (itemObj.Id > 0)
{
var groupInfo = UserGroupManager.GetUserGroupInfo(itemObj.Id);
if (groupInfo.GroupName != itemObj.GroupName && UserGroupManager.IsExists(itemObj.GroupName))
{
return(BadRequest("保存失败，已存在相同名称的用户组！"));
}
groupInfo.GroupName = itemObj.GroupName;
groupInfo.AdminName = itemObj.AdminName;
DataProvider.UserGroupDao.Update(groupInfo);
request.AddAdminLog("修改用户组", $"用户组:{groupInfo.GroupName}");
}
return(Ok(new
{
Value = UserGroupManager.GetUserGroupInfoList()
}));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
