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);
}
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;
}
public void Visit(UnionQuery component)
{
sql.Append(Environment.NewLine + (component.UnionAll ? "UNION ALL (" : "UNION ("));
component.Query.Accept(this);
sql.Append(")");
}
public void Visit(UnionQuery component)
{
throw new NotImplementedException();
}
