//
// GridCellValueChanging event allows to prevent the cell value changing or modify the new cell value.
// Note: Some columns hide/unhide dynamically but this does not affect the column index in the event parameters -
// it includes hidden columns.
// private void queryBuilder1_GridCellValueChanging(UnionSubQuery unionSubQuery, QueryColumnList criteriaList, QueryColumnListItem criteriaItem, int column, int row, object oldValue, ref object newValue, ref bool abort)
private void QBuilder_QueryColumnListItemChanging(QueryColumnList queryColumnList, QueryColumnListItem queryColumnListItem,
QueryColumnListItemProperty property, int conditionIndex, object oldValue, ref object newValue, ref bool abort)
{
if (!CbQueryColumnListItemChanging.Checked)
{
return;
}
AddRowToReport("QueryColumnListItemChanging. Changes column \"" + property + "\"");
if (property == QueryColumnListItemProperty.Expression) // Prevent changes in the Expression column.
{
abort = true;
}
else if (property == QueryColumnListItemProperty.Alias) // Alias column. Lets add the underscore char in the beginning of all aliases, for example.
{
if (newValue != null && newValue is string)
{
var s = (string)newValue;
if (s.Length > 0 && !s.StartsWith("_"))
{
s = "_" + s;
newValue = s;
}
}
}
}
private void QBuilder_QueryColumnListItemChanged(QueryColumnList queryColumnList, QueryColumnListItem queryColumnListItem,
QueryColumnListItemProperty property, int conditionIndex, object newValue)
{
if (CbQueryColumnListItemChanged.Checked != true)
{
return;
}
AddRowToReport("QueryColumnListItemChanged property \"" + property + "\" changed");
}
//
// GridCellValueChanging event allows to prevent the cell value changing or modify the new cell value.
// Note: Some columns hide/unhide dynamically but this does not affect the column index in the event parameters -
// it includes hidden columns.
//
private void QBuilder_OnQueryColumnListItemChanging(QueryColumnList querycolumnlist, QueryColumnListItem querycolumnlistitem,
QueryColumnListItemProperty property, int conditionindex, object oldvalue, ref object newValue, ref bool abort)
{
if (CbQueryColumnListItemChanging.IsChecked != true)
{
return;
}
BoxLogEvents.Text = "QueryColumnListItemChanging Changing the value for property \"" + property + "\"" +
Environment.NewLine + BoxLogEvents.Text;
if (property == QueryColumnListItemProperty.Expression) // Prevent changes in the Expression column.
{
abort = true;
return;
}
if (property != QueryColumnListItemProperty.Alias)
{
return;
}
var s = newValue as string;
if (s == null)
{
return;
}
if (s.Length <= 0 || s.StartsWith("_"))
{
return;
}
s = "_" + s;
newValue = s;
}
private void QueryBuilder1_QueryColumnListItemChanging(QueryColumnList queryColumnList, QueryColumnListItem queryColumnListItem,
QueryColumnListItemProperty property, int conditionIndex, object oldValue, ref object newValue, ref bool abort)
{
}
private void QBuilder_OnQueryColumnListItemChanged(QueryColumnList querycolumnlist,
QueryColumnListItem querycolumnlistitem, QueryColumnListItemProperty property, int conditionindex,
object newvalue)
{
if (CbQueryColumnListItemChanged.IsChecked != true)
{
return;
}
BoxLogEvents.Text = "QueryColumnListItemChanged property \"" + property + "\" changed" +
Environment.NewLine + BoxLogEvents.Text;
}
