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)); } }