public void Update(UserMenuInfo menuInfo) { var sqlString = $@"UPDATE {TableName} SET {nameof(UserMenuInfo.SystemId)} = @{nameof(UserMenuInfo.SystemId)}, {nameof(UserMenuInfo.GroupIdCollection)} = @{nameof(UserMenuInfo.GroupIdCollection)}, {nameof(UserMenuInfo.IsDisabled)} = @{nameof(UserMenuInfo.IsDisabled)}, {nameof(UserMenuInfo.ParentId)} = @{nameof(UserMenuInfo.ParentId)}, {nameof(UserMenuInfo.Taxis)} = @{nameof(UserMenuInfo.Taxis)}, {nameof(UserMenuInfo.Text)} = @{nameof(UserMenuInfo.Text)}, {nameof(UserMenuInfo.IconClass)} = @{nameof(UserMenuInfo.IconClass)}, {nameof(UserMenuInfo.Href)} = @{nameof(UserMenuInfo.Href)}, {nameof(UserMenuInfo.Target)} = @{nameof(UserMenuInfo.Target)} WHERE {nameof(UserMenuInfo.Id)} = @{nameof(UserMenuInfo.Id)}"; IDataParameter[] parameters = { GetParameter(nameof(UserMenuInfo.SystemId), DataType.VarChar, 50, menuInfo.SystemId), GetParameter(nameof(UserMenuInfo.GroupIdCollection), DataType.VarChar, 200, menuInfo.GroupIdCollection), GetParameter(nameof(UserMenuInfo.IsDisabled), DataType.Boolean, menuInfo.IsDisabled), GetParameter(nameof(UserMenuInfo.ParentId), DataType.Integer, menuInfo.ParentId), GetParameter(nameof(UserMenuInfo.Taxis), DataType.Integer, menuInfo.Taxis), GetParameter(nameof(UserMenuInfo.Text), DataType.VarChar, 50, menuInfo.Text), GetParameter(nameof(UserMenuInfo.IconClass), DataType.VarChar, 50, menuInfo.IconClass), GetParameter(nameof(UserMenuInfo.Href), DataType.VarChar, 200, menuInfo.Href), GetParameter(nameof(UserMenuInfo.Target), DataType.VarChar, 50, menuInfo.Target), GetParameter(nameof(UserMenuInfo.Id), DataType.Integer, menuInfo.Id) }; ExecuteNonQuery(sqlString, parameters); UserMenuManager.ClearCache(); }
public void Delete(int menuId) { var sqlString = $"DELETE FROM {TableName} WHERE {nameof(UserMenuInfo.Id)} = @{nameof(UserMenuInfo.Id)} OR {nameof(UserMenuInfo.ParentId)} = @{nameof(UserMenuInfo.ParentId)}"; var parms = new IDataParameter[] { GetParameter($"@{nameof(UserMenuInfo.Id)}", DataType.Integer, menuId), GetParameter($"@{nameof(UserMenuInfo.ParentId)}", DataType.Integer, menuId) }; ExecuteNonQuery(sqlString, parms); UserMenuManager.ClearCache(); }
public int Insert(UserMenuInfo menuInfo) { var sqlString = $@" INSERT INTO {TableName} ( {nameof(UserMenuInfo.SystemId)}, {nameof(UserMenuInfo.GroupIdCollection)}, {nameof(UserMenuInfo.IsDisabled)}, {nameof(UserMenuInfo.ParentId)}, {nameof(UserMenuInfo.Taxis)}, {nameof(UserMenuInfo.Text)}, {nameof(UserMenuInfo.IconClass)}, {nameof(UserMenuInfo.Href)}, {nameof(UserMenuInfo.Target)} ) VALUES ( @{nameof(UserMenuInfo.SystemId)}, @{nameof(UserMenuInfo.GroupIdCollection)}, @{nameof(UserMenuInfo.IsDisabled)}, @{nameof(UserMenuInfo.ParentId)}, @{nameof(UserMenuInfo.Taxis)}, @{nameof(UserMenuInfo.Text)}, @{nameof(UserMenuInfo.IconClass)}, @{nameof(UserMenuInfo.Href)}, @{nameof(UserMenuInfo.Target)} )"; var parms = new IDataParameter[] { GetParameter($"@{nameof(UserMenuInfo.SystemId)}", DataType.VarChar, 50, menuInfo.SystemId), GetParameter($"@{nameof(UserMenuInfo.GroupIdCollection)}", DataType.VarChar, 200, menuInfo.GroupIdCollection), GetParameter($"@{nameof(UserMenuInfo.IsDisabled)}", DataType.Boolean, menuInfo.IsDisabled), GetParameter($"@{nameof(UserMenuInfo.ParentId)}", DataType.Integer, menuInfo.ParentId), GetParameter($"@{nameof(UserMenuInfo.Taxis)}", DataType.Integer, menuInfo.Taxis), GetParameter($"@{nameof(UserMenuInfo.Text)}", DataType.VarChar, 50, menuInfo.Text), GetParameter($"@{nameof(UserMenuInfo.IconClass)}", DataType.VarChar, 50, menuInfo.IconClass), GetParameter($"@{nameof(UserMenuInfo.Href)}", DataType.VarChar, 200, menuInfo.Href), GetParameter($"@{nameof(UserMenuInfo.Target)}", DataType.VarChar, 50, menuInfo.Target) }; var menuId = ExecuteNonQueryAndReturnId(TableName, nameof(UserMenuInfo.Id), sqlString, parms); UserMenuManager.ClearCache(); return(menuId); }