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