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