public Column[] GetVisibleColumns(HiddenLevel visibleLevel)
{
List <Column> l = new List <Column>();
foreach (Column c in AllColumns)
{
if (c.HiddenLevel <= visibleLevel)
{
l.Add(c);
}
}
return(l.ToArray());
}
private void UserControl_Initialized(object sender, EventArgs e)
{
DataGridControllerResult = new DataGridController();
DataGridControllerResult.Grid = dataGridResult;
CommandBinding b;
b = new CommandBinding(ApplicationCommands.Find, FindCommand_Executed);
dataGridResult.CommandBindings.Add(b);
b = new CommandBinding(SearchCommands.FindNext, FindNextCommand_Executed);
dataGridResult.CommandBindings.Add(b);
b = new CommandBinding(SearchCommands.FindPrevious, FindPreviousCommand_Executed);
dataGridResult.CommandBindings.Add(b);
b = new CommandBinding(QueryCommands.NormalizeSQL, textBoxConditionCommandNormalizeSql_Executed);
textBoxCondition.CommandBindings.Add(b);
VisibleLevel = HiddenLevel.Hidden;
}
internal Column(Selectable owner, Column basedOn) : base(null)
{
_owner = owner;
Schema = basedOn.Schema;
Index = basedOn.Index;
TableName = basedOn.TableName;
Name = basedOn.Name;
BaseType = basedOn.BaseType;
DataLength = basedOn.DataLength;
Precision = basedOn.Precision;
WithTimeZone = basedOn.WithTimeZone;
IsSupportedType = basedOn.IsSupportedType;
DataType = basedOn.DataType;
ValueType = basedOn.ValueType;
DefaultValue = basedOn.DefaultValue;
NotNull = basedOn.NotNull;
Comment = basedOn.Comment;
HiddenLevel = basedOn.HiddenLevel;
}
private void UpdateHiddenLevelDisplayItems()
{
Column oid = Target.Columns["oid"];
bool hasOid = (oid != null && oid.HiddenLevel == HiddenLevel.Hidden);
HiddenLevel lv = hasOid ? HiddenLevel.Hidden : HiddenLevel.Visible;
HiddenLevelDisplayItem sel = null;
List <HiddenLevelDisplayItem> l = new List <HiddenLevelDisplayItem>();
foreach (HiddenLevelDisplayItem item in (HiddenLevelDisplayItem[])Resources["DefaultHiddenLevelDisplayItems"])
{
if (item.Level == lv)
{
sel = item;
}
if (hasOid || item.Level != HiddenLevel.Hidden)
{
l.Add(item);
}
}
HiddenLevelItems = l.ToArray();
comboBoxSystemColumn.ItemsSource = HiddenLevelItems;
comboBoxSystemColumn.SelectedItem = sel;
}
public string GetSelectSQL(string alias, string[] where, string[] orderBy, int?limit, HiddenLevel visibleLevel)
{
int whereOffset;
return(GetSelectSQL(alias, where, orderBy, limit, visibleLevel, out whereOffset));
}
public string GetSelectSQL(string alias, string[] where, string[] orderBy, int?limit, HiddenLevel visibleLevel, out int whereOffset)
{
StringBuilder bufW = new StringBuilder();
if (0 < where.Length)
{
bufW.AppendLine(where[0]);
for (int i = 1; i < where.Length; i++)
{
bufW.Append(" ");
bufW.AppendLine(where[i]);
}
}
StringBuilder bufO = new StringBuilder();
if (0 < orderBy.Length)
{
bufO.Append(orderBy[0]);
for (int i = 1; i < orderBy.Length; i++)
{
bufO.Append(", ");
bufO.Append(orderBy[i]);
}
}
return(GetSelectSQL(alias, bufW.ToString().TrimEnd(), bufO.ToString(), limit, visibleLevel, out whereOffset));
}
public string GetSelectSQL(string alias, string where, string[] orderBy, int?limit, HiddenLevel visibleLevel)
{
StringBuilder bufO = new StringBuilder();
if (0 < orderBy.Length)
{
bufO.Append(orderBy[0]);
for (int i = 1; i < orderBy.Length; i++)
{
bufO.Append(", ");
bufO.Append(orderBy[i]);
}
}
return(GetSelectSQL(alias, where, bufO.ToString(), limit, visibleLevel));
}
public string GetSelectSQL(string alias, string where, string orderBy, int?limit, HiddenLevel visibleLevel, out int whereOffset)
{
StringBuilder buf = new StringBuilder();
buf.AppendLine("select");
buf.AppendLine(GetColumnsSQL(alias, visibleLevel));
buf.Append("from ");
buf.Append(EscapedIdentifier(null));
if (!string.IsNullOrEmpty(alias))
{
buf.Append(" as ");
buf.Append(alias);
}
buf.AppendLine();
whereOffset = buf.Length;
if (!string.IsNullOrEmpty(where))
{
buf.Append("where ");
whereOffset = buf.Length;
buf.AppendLine(where);
}
if (!string.IsNullOrEmpty(orderBy))
{
buf.Append("order by ");
buf.AppendLine(orderBy);
}
if (limit.HasValue)
{
buf.Append("limit ");
buf.Append(limit.Value);
buf.AppendLine();
}
return(buf.ToString());
}
public string GetColumnsSQL(string alias, HiddenLevel visibleLevel)
{
return(GetColumnsSQL(alias, Columns.GetVisibleColumns(visibleLevel)));
}
