// ===============================================================================
// Query Update
// ============
public int QueryUpdate(Dch客室利用台帳 dch客室利用台帳, Dch客室利用台帳CB cb)
{
AssertObjectNotNull("dch客室利用台帳", dch客室利用台帳); AssertConditionBeanNotNull(cb);
SetupCommonColumnOfUpdateIfNeeds(dch客室利用台帳);
FilterEntityOfUpdate(dch客室利用台帳); AssertEntityOfUpdate(dch客室利用台帳);
return(this.Dao.UpdateByQuery(cb, dch客室利用台帳));
}
// ===============================================================================
// Page Select
// ===========
#region Page Select
public virtual PagingResultBean <Dch客室利用台帳> SelectPage(Dch客室利用台帳CB cb)
{
AssertConditionBeanNotNull(cb);
PagingInvoker <Dch客室利用台帳> invoker = new PagingInvoker <Dch客室利用台帳>(TableDbName);
return(invoker.InvokePaging(new InternalSelectPagingHandler(this, cb)));
}
// ===============================================================================
// Entity Select
// =============
#region Entity Select
public virtual Dch客室利用台帳 SelectEntity(Dch客室利用台帳CB cb)
{
AssertConditionBeanNotNull(cb);
if (!cb.HasWhereClause() && cb.FetchSize != 1) // if no condition for one
{
throwSelectEntityConditionNotFoundException(cb);
}
int preSafetyMaxResultSize = xcheckSafetyResultAsOne(cb);
IList <Dch客室利用台帳> 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((Dch客室利用台帳)ls[0]);
}
private Dch客室利用台帳CB BuildPKCB(long?id)
{
AssertObjectNotNull("id", id);
Dch客室利用台帳CB cb = NewMyConditionBean();
cb.Query().SetId_Equal(id);
return(cb);
}
// ===============================================================================
// MySelf InScope
// ==============
public void MyselfInScope(SubQuery <Dch客室利用台帳CB> subQuery)
{
assertObjectNotNull("subQuery<Dch客室利用台帳CB>", subQuery);
Dch客室利用台帳CB cb = new Dch客室利用台帳CB(); cb.xsetupForInScopeRelation(this); subQuery.Invoke(cb);
String subQueryPropertyName = keepMyselfInScopeSubQuery(cb.Query()); // for saving query-value.
registerInScopeSubQuery(cb.Query(), "id", "id", subQueryPropertyName);
}
public void ExistsDch客室利用台帳List(SubQuery <Dch客室利用台帳CB> subQuery)
{
assertObjectNotNull("subQuery<Dch客室利用台帳CB>", subQuery);
Dch客室利用台帳CB cb = new Dch客室利用台帳CB(); cb.xsetupForExistsReferrer(this); subQuery.Invoke(cb);
String subQueryPropertyName = keep客室コード_ExistsSubQuery_Dch客室利用台帳List(cb.Query());
registerExistsSubQuery(cb.Query(), "客室コード", "客室コード", subQueryPropertyName);
}
public virtual Dch客室利用台帳 SelectEntityWithDeletedCheck(Dch客室利用台帳CB cb)
{
AssertConditionBeanNotNull(cb);
Dch客室利用台帳 entity = SelectEntity(cb);
AssertEntityNotDeleted(entity, cb);
return(entity);
}
protected void xscalarSubQuery(String function, SubQuery <Dch客室利用台帳CB> subQuery, String operand)
{
assertObjectNotNull("subQuery<Dch客室利用台帳CB>", subQuery);
Dch客室利用台帳CB cb = new Dch客室利用台帳CB(); cb.xsetupForScalarCondition(this); subQuery.Invoke(cb);
String subQueryPropertyName = keepScalarSubQuery(cb.Query()); // for saving query-value.
registerScalarSubQuery(function, cb.Query(), subQueryPropertyName, operand);
}
public void NotInScopeDch客室利用台帳List(SubQuery <Dch客室利用台帳CB> subQuery)
{
assertObjectNotNull("subQuery<Dch客室利用台帳CB>", subQuery);
Dch客室利用台帳CB cb = new Dch客室利用台帳CB(); cb.xsetupForInScopeRelation(this); subQuery.Invoke(cb);
String subQueryPropertyName = keep客室コード_NotInScopeSubQuery_Dch客室利用台帳List(cb.Query());
registerNotInScopeSubQuery(cb.Query(), "客室コード", "客室コード", subQueryPropertyName);
}
public void xsderiveDch客室利用台帳List(String function, SubQuery <Dch客室利用台帳CB> subQuery, String aliasName)
{
assertObjectNotNull("subQuery<Dch客室利用台帳CB>", subQuery);
Dch客室利用台帳CB cb = new Dch客室利用台帳CB(); cb.xsetupForDerivedReferrer(this); subQuery.Invoke(cb);
String subQueryPropertyName = keep客室コード_SpecifyDerivedReferrer_Dch客室利用台帳List(cb.Query());
registerSpecifyDerivedReferrer(function, cb.Query(), "客室コード", "客室コード", subQueryPropertyName, aliasName);
}
public void xqderiveDch客室利用台帳List(String function, SubQuery <Dch客室利用台帳CB> subQuery, String operand, Object value)
{
assertObjectNotNull("subQuery<Dch客室利用台帳CB>", subQuery);
Dch客室利用台帳CB cb = new Dch客室利用台帳CB(); cb.xsetupForDerivedReferrer(this); subQuery.Invoke(cb);
String subQueryPropertyName = keep客室コード_QueryDerivedReferrer_Dch客室利用台帳List(cb.Query()); // for saving query-value.
String parameterPropertyName = keep客室コード_QueryDerivedReferrer_Dch客室利用台帳ListParameter(value);
registerQueryDerivedReferrer(function, cb.Query(), "客室コード", "客室コード", subQueryPropertyName, operand, value, parameterPropertyName);
}
// ===============================================================================
// Purpose Type
// ============
public void xsetupForColumnQuery(Dch客室利用台帳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 Dch客室利用台帳CBColQySpQyCall(mainCB));
}
public List <Dch客室利用台帳> Get未終了客室利用台帳()
{
var 客室利用台帳cb = new Dch客室利用台帳CB();
客室利用台帳cb.SetupSelect_Mst客室マスタ();
客室利用台帳cb.Query().Set終了実績日時_IsNull();
客室利用台帳cb.Query().AddOrderBy_開始予定日時_Asc();
var 客室利用台帳List = 客室利用台帳Bhv.SelectList(客室利用台帳cb).ToList();
return(客室利用台帳List.Any() ? 客室利用台帳List : new List <Dch客室利用台帳>());
}
public int QueryDelete(Dch客室利用台帳CB cb)
{
AssertConditionBeanNotNull(cb);
return(this.Dao.DeleteByQuery(cb));
}
public InternalSelectPagingHandler(Dch客室利用台帳Bhv bhv, Dch客室利用台帳CB cb)
{
_bhv = bhv; _cb = cb;
}
public Dch客室利用台帳CBColQySpQyCall(Dch客室利用台帳CB mainCB) {
_mainCB = mainCB;
}
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);
}
// ===============================================================================
// Delegate Method
// ===============
#region Delegate Method
protected int DelegateSelectCount(Dch客室利用台帳CB cb)
{
AssertConditionBeanNotNull(cb); return(this.Dao.SelectCount(cb));
}
protected Dch客室利用台帳CB xcreateColumnQueryCB() {
Dch客室利用台帳CB cb = new Dch客室利用台帳CB();
cb.xsetupForColumnQuery((Dch客室利用台帳CB)this);
return cb;
}
protected IList <Dch客室利用台帳> DelegateSelectList(Dch客室利用台帳CB cb)
{
AssertConditionBeanNotNull(cb); return(this.Dao.SelectList(cb));
}
// ===============================================================================
// Count Select
// ============
#region Count Select
public virtual int SelectCount(Dch客室利用台帳CB cb)
{
AssertConditionBeanNotNull(cb);
return(this.DelegateSelectCount(cb));
}
// ===============================================================================
// List Select
// ===========
#region List Select
public virtual ListResultBean <Dch客室利用台帳> SelectList(Dch客室利用台帳CB cb)
{
AssertConditionBeanNotNull(cb);
return(new ResultBeanBuilder <Dch客室利用台帳>(TableDbName).BuildListResultBean(cb, this.DelegateSelectList(cb)));
}
