Ejemplo n.º 1
0
        private void QueryBuilder1_ActiveUnionSubQueryChanging(object sender, ActiveQueryBuilder.View.SubQueryChangingEventArgs e)
        {
            string sql = textBox1.Text.Trim();

            if (string.IsNullOrEmpty(sql))
            {
                return;
            }
            try
            {
                switch (_mode)
                {
                case ModeEditor.Entire:
                    queryBuilder1.SQLContext.ParseSelect(sql);
                    break;

                case ModeEditor.SubQuery:
                    queryBuilder1.SQLContext.ParseSelect(sql);
                    break;

                case ModeEditor.Expression:
                    queryBuilder1.SQLContext.ParseSelect(sql);
                    break;

                default:
                    throw new ArgumentOutOfRangeException();
                }
            }
            catch
            {
                e.Abort = true;
            }
        }
Ejemplo n.º 2
0
        private void Builder_ActiveUnionSubQueryChanging(object sender, ActiveQueryBuilder.View.SubQueryChangingEventArgs e)
        {
            var exception = CheckSql();

            if (exception == null)
            {
                return;
            }

            e.Abort = true;

            ErrorBox.Show(exception.Message, Builder.SyntaxProvider);
            _errorPosition = exception.ErrorPos.pos;
        }
Ejemplo n.º 3
0
        private void QueryBuilder1_ActiveUnionSubQueryChanging(object sender,
                                                               ActiveQueryBuilder.View.SubQueryChangingEventArgs e)
        {
            if (e.OldSubQuery != null && _dictionarySubQuery.ContainsKey(e.OldSubQuery))
            {
                _dictionarySubQuery.Remove(e.OldSubQuery);
                e.OldSubQuery.QueryColumnList.ElementAdded    -= QueryColumnList_ElementAdded;
                e.OldSubQuery.QueryColumnList.ElementRemoving -= QueryColumnListOnElementRemoving;
            }

            if (e.NewSubQuery == null || _dictionarySubQuery.ContainsKey(e.NewSubQuery))
            {
                return;
            }

            e.NewSubQuery.QueryColumnList.ElementAdded    += QueryColumnList_ElementAdded;
            e.NewSubQuery.QueryColumnList.ElementRemoving += QueryColumnListOnElementRemoving;


            _dictionarySubQuery.Add(e.NewSubQuery, new Dictionary <QueryColumnListItem, string>());
        }