// =============================================================================== // 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))); }