// ===============================================================================
// Entity Select
// =============
#region Entity Select
public virtual Kbnメニュー区分 SelectEntity(Kbnメニュー区分CB cb)
{
AssertConditionBeanNotNull(cb);
if (!cb.HasWhereClause() && cb.FetchSize != 1) // if no condition for one
{
throwSelectEntityConditionNotFoundException(cb);
}
int preSafetyMaxResultSize = xcheckSafetyResultAsOne(cb);
IList <Kbnメニュー区分> ls = null;
try {
ls = this.DelegateSelectList(cb);
} catch (DangerousResultSizeException e) {
ThrowEntityDuplicatedException("{over safetyMaxResultSize '1'}", cb, e);
return(null); // unreachable
} finally {
xrestoreSafetyResult(cb, preSafetyMaxResultSize);
}
if (ls.Count == 0)
{
return(null);
}
AssertEntitySelectedAsOne(ls, cb);
return((Kbnメニュー区分)ls[0]);
}
// ===============================================================================
// Page Select
// ===========
#region Page Select
public virtual PagingResultBean <Kbnメニュー区分> SelectPage(Kbnメニュー区分CB cb)
{
AssertConditionBeanNotNull(cb);
PagingInvoker <Kbnメニュー区分> invoker = new PagingInvoker <Kbnメニュー区分>(TableDbName);
return(invoker.InvokePaging(new InternalSelectPagingHandler(this, cb)));
}
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);
}
// ===============================================================================
// Query Update
// ============
public int QueryUpdate(Kbnメニュー区分 kbnメニュー区分, Kbnメニュー区分CB cb)
{
AssertObjectNotNull("kbnメニュー区分", kbnメニュー区分); AssertConditionBeanNotNull(cb);
SetupCommonColumnOfUpdateIfNeeds(kbnメニュー区分);
FilterEntityOfUpdate(kbnメニュー区分); AssertEntityOfUpdate(kbnメニュー区分);
return(this.Dao.UpdateByQuery(cb, kbnメニュー区分));
}
protected Kbnメニュー区分CB xcreateColumnQueryCB()
{
Kbnメニュー区分CB cb = new Kbnメニュー区分CB();
cb.xsetupForColumnQuery((Kbnメニュー区分CB)this);
return(cb);
}
public virtual Kbnメニュー区分 SelectEntityWithDeletedCheck(Kbnメニュー区分CB cb)
{
AssertConditionBeanNotNull(cb);
Kbnメニュー区分 entity = SelectEntity(cb);
AssertEntityNotDeleted(entity, cb);
return(entity);
}
// ===============================================================================
// MySelf InScope
// ==============
public void MyselfInScope(SubQuery <Kbnメニュー区分CB> subQuery)
{
assertObjectNotNull("subQuery<Kbnメニュー区分CB>", subQuery);
Kbnメニュー区分CB cb = new Kbnメニュー区分CB(); cb.xsetupForInScopeRelation(this); subQuery.Invoke(cb);
String subQueryPropertyName = keepMyselfInScopeSubQuery(cb.Query()); // for saving query-value.
registerInScopeSubQuery(cb.Query(), "メニューコード", "メニューコード", subQueryPropertyName);
}
protected void xscalarSubQuery(String function, SubQuery <Kbnメニュー区分CB> subQuery, String operand)
{
assertObjectNotNull("subQuery<Kbnメニュー区分CB>", subQuery);
Kbnメニュー区分CB cb = new Kbnメニュー区分CB(); cb.xsetupForScalarCondition(this); subQuery.Invoke(cb);
String subQueryPropertyName = keepScalarSubQuery(cb.Query()); // for saving query-value.
registerScalarSubQuery(function, cb.Query(), subQueryPropertyName, operand);
}
private Kbnメニュー区分CB BuildPKCB(String メニューコード)
{
AssertObjectNotNull("メニューコード", メニューコード);
Kbnメニュー区分CB cb = NewMyConditionBean();
cb.Query().Setメニューコード_Equal(メニューコード);
return(cb);
}
public void NotInScopeKbnメニュー区分(SubQuery <Kbnメニュー区分CB> subQuery)
{
assertObjectNotNull("subQuery<Kbnメニュー区分CB>", subQuery);
Kbnメニュー区分CB cb = new Kbnメニュー区分CB(); cb.xsetupForInScopeRelation(this); subQuery.Invoke(cb);
String subQueryPropertyName = keepメニューコード_NotInScopeSubQuery_Kbnメニュー区分(cb.Query());
registerNotInScopeSubQuery(cb.Query(), "メニューコード", "メニューコード", subQueryPropertyName);
}
// ===============================================================================
// Purpose Type
// ============
public void xsetupForColumnQuery(Kbnメニュー区分CB mainCB)
{
xinheritSubQueryInfo(mainCB.LocalCQ);
//xchangePurposeSqlClause(HpCBPurpose.COLUMN_QUERY);
_forColumnQuery = true; // old style
// inherits a parent query to synchronize real name
// (and also for suppressing query check)
Specify().xsetSyncQyCall(new Kbnメニュー区分CBColQySpQyCall(mainCB));
}
// ===============================================================================
// Count Select
// ============
#region Count Select
public virtual int SelectCount(Kbnメニュー区分CB cb)
{
AssertConditionBeanNotNull(cb);
return(this.DelegateSelectCount(cb));
}
protected IList <Kbnメニュー区分> DelegateSelectList(Kbnメニュー区分CB cb)
{
AssertConditionBeanNotNull(cb); return(this.Dao.SelectList(cb));
}
// ===============================================================================
// Delegate Method
// ===============
#region Delegate Method
protected int DelegateSelectCount(Kbnメニュー区分CB cb)
{
AssertConditionBeanNotNull(cb); return(this.Dao.SelectCount(cb));
}
public int QueryDelete(Kbnメニュー区分CB cb)
{
AssertConditionBeanNotNull(cb);
return(this.Dao.DeleteByQuery(cb));
}
public InternalSelectPagingHandler(Kbnメニュー区分Bhv bhv, Kbnメニュー区分CB cb)
{
_bhv = bhv; _cb = cb;
}
public Kbnメニュー区分CBColQySpQyCall(Kbnメニュー区分CB mainCB)
{
_mainCB = mainCB;
}
// ===============================================================================
// List Select
// ===========
#region List Select
public virtual ListResultBean <Kbnメニュー区分> SelectList(Kbnメニュー区分CB cb)
{
AssertConditionBeanNotNull(cb);
return(new ResultBeanBuilder <Kbnメニュー区分>(TableDbName).BuildListResultBean(cb, this.DelegateSelectList(cb)));
}
