public virtual void UnionAll(UnionQuery <Mst従業員マスタCB> unionQuery)
        {
            Mst従業員マスタCB cb = new Mst従業員マスタCB();

            cb.xsetupForUnion(this); xsyncUQ(cb); unionQuery.Invoke(cb);
            Mst従業員マスタCQ cq = cb.Query(); Query().xsetUnionAllQuery(cq);
        }
        public virtual void UnionAll(UnionQuery <DmyプロシージャCB> unionQuery)
        {
            DmyプロシージャCB cb = new DmyプロシージャCB();

            cb.xsetupForUnion(this); xsyncUQ(cb); unionQuery.Invoke(cb);
            DmyプロシージャCQ cq = cb.Query(); Query().xsetUnionAllQuery(cq);
        }
        public virtual void UnionAll(UnionQuery <Dch従業員職位履歴台帳CB> unionQuery)
        {
            Dch従業員職位履歴台帳CB cb = new Dch従業員職位履歴台帳CB();

            cb.xsetupForUnion(this); xsyncUQ(cb); unionQuery.Invoke(cb);
            Dch従業員職位履歴台帳CQ cq = cb.Query(); Query().xsetUnionAllQuery(cq);
        }
        public virtual void UnionAll(UnionQuery <Kbnメニュー区分CB> unionQuery)
        {
            Kbnメニュー区分CB cb = new Kbnメニュー区分CB();

            cb.xsetupForUnion(this); xsyncUQ(cb); unionQuery.Invoke(cb);
            Kbnメニュー区分CQ cq = cb.Query(); Query().xsetUnionAllQuery(cq);
        }
Exemple #5
0
        public void UnionQuery()
        {
            var query = new UnionQuery()
            {
                SomethingId = 12
            };
            var sql = QueryHelper.ResolveSql(query.Sql, query);

            Assert.IsTrue(sql.Equals(
                              @"SELECT [This] FROM [That] WHERE [SomethingId]=@somethingId ORDER BY [Whatever]
            UNION
            SELECT [That] FROM [This] [Whatever]='bingo' AND [SomethingId]=@somethingId ORDER BY [Another]"));
        }
            private void Expand(UnionQuery unionQuery)
            {
                var first = true;

                foreach (var query in unionQuery.Queries)
                {
                    if (first)
                    {
                        first = false;
                    }
                    else
                    {
                        builder.AppendLine().Append("union");
                        if (unionQuery.UnionType == UnionType.All)
                        {
                            builder.Append(" all");
                        }
                        builder.AppendLine();
                    }
                    ExpandExpression(query);
                }
            }
 public void xregisterUnionQuerySynchronizer(UnionQuery <ConditionBean> unionQuerySynchronizer)
 {
     _unionQuerySynchronizer = unionQuerySynchronizer;
 }
Exemple #8
0
 public void Visit(UnionQuery component)
 {
     sql.Append(Environment.NewLine + (component.UnionAll ? "UNION ALL (" : "UNION ("));
     component.Query.Accept(this);
     sql.Append(")");
 }
Exemple #9
0
 public void Visit(UnionQuery component)
 {
     throw new NotImplementedException();
 }