package pwc.taxtech.atms.vat.entity; import java.math.BigDecimal; import java.util.ArrayList; import java.util.Date; import java.util.List; public class BalanceStdExample { /** * This field was generated by MyBatis Generator. * This field corresponds to the database table TAX_PROJECT.BALANCE_STD * * @mbg.generated */ protected String orderByClause; /** * This field was generated by MyBatis Generator. * This field corresponds to the database table TAX_PROJECT.BALANCE_STD * * @mbg.generated */ protected boolean distinct; /** * This field was generated by MyBatis Generator. * This field corresponds to the database table TAX_PROJECT.BALANCE_STD * * @mbg.generated */ protected List<Criteria> oredCriteria; /** * This method was generated by MyBatis Generator. * This method corresponds to the database table TAX_PROJECT.BALANCE_STD * * @mbg.generated */ public BalanceStdExample() { oredCriteria = new ArrayList<Criteria>(); } /** * This method was generated by MyBatis Generator. * This method corresponds to the database table TAX_PROJECT.BALANCE_STD * * @mbg.generated */ public void setOrderByClause(String orderByClause) { this.orderByClause = orderByClause; } /** * This method was generated by MyBatis Generator. * This method corresponds to the database table TAX_PROJECT.BALANCE_STD * * @mbg.generated */ public String getOrderByClause() { return orderByClause; } /** * This method was generated by MyBatis Generator. * This method corresponds to the database table TAX_PROJECT.BALANCE_STD * * @mbg.generated */ public void setDistinct(boolean distinct) { this.distinct = distinct; } /** * This method was generated by MyBatis Generator. * This method corresponds to the database table TAX_PROJECT.BALANCE_STD * * @mbg.generated */ public boolean isDistinct() { return distinct; } /** * This method was generated by MyBatis Generator. * This method corresponds to the database table TAX_PROJECT.BALANCE_STD * * @mbg.generated */ public List<Criteria> getOredCriteria() { return oredCriteria; } /** * This method was generated by MyBatis Generator. * This method corresponds to the database table TAX_PROJECT.BALANCE_STD * * @mbg.generated */ public void or(Criteria criteria) { oredCriteria.add(criteria); } /** * This method was generated by MyBatis Generator. * This method corresponds to the database table TAX_PROJECT.BALANCE_STD * * @mbg.generated */ public Criteria or() { Criteria criteria = createCriteriaInternal(); oredCriteria.add(criteria); return criteria; } /** * This method was generated by MyBatis Generator. * This method corresponds to the database table TAX_PROJECT.BALANCE_STD * * @mbg.generated */ public Criteria createCriteria() { Criteria criteria = createCriteriaInternal(); if (oredCriteria.size() == 0) { oredCriteria.add(criteria); } return criteria; } /** * This method was generated by MyBatis Generator. * This method corresponds to the database table TAX_PROJECT.BALANCE_STD * * @mbg.generated */ protected Criteria createCriteriaInternal() { Criteria criteria = new Criteria(); return criteria; } /** * This method was generated by MyBatis Generator. * This method corresponds to the database table TAX_PROJECT.BALANCE_STD * * @mbg.generated */ public void clear() { oredCriteria.clear(); orderByClause = null; distinct = false; } /** * This class was generated by MyBatis Generator. * This class corresponds to the database table TAX_PROJECT.BALANCE_STD * * @mbg.generated */ protected abstract static class GeneratedCriteria { protected List<Criterion> criteria; protected GeneratedCriteria() { super(); criteria = new ArrayList<Criterion>(); } public boolean isValid() { return criteria.size() > 0; } public List<Criterion> getAllCriteria() { return criteria; } public List<Criterion> getCriteria() { return criteria; } protected void addCriterion(String condition) { if (condition == null) { throw new RuntimeException("Value for condition cannot be null"); } criteria.add(new Criterion(condition)); } protected void addCriterion(String condition, Object value, String property) { if (value == null) { throw new RuntimeException("Value for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value)); } protected void addCriterion(String condition, Object value1, Object value2, String property) { if (value1 == null || value2 == null) { throw new RuntimeException("Between values for " + property + " cannot be null"); } criteria.add(new Criterion(condition, value1, value2)); } public Criteria andBalanceIdIsNull() { addCriterion("BALANCE_ID is null"); return (Criteria) this; } public Criteria andBalanceIdIsNotNull() { addCriterion("BALANCE_ID is not null"); return (Criteria) this; } public Criteria andBalanceIdEqualTo(String value) { addCriterion("BALANCE_ID =", value, "balanceId"); return (Criteria) this; } public Criteria andBalanceIdNotEqualTo(String value) { addCriterion("BALANCE_ID <>", value, "balanceId"); return (Criteria) this; } public Criteria andBalanceIdGreaterThan(String value) { addCriterion("BALANCE_ID >", value, "balanceId"); return (Criteria) this; } public Criteria andBalanceIdGreaterThanOrEqualTo(String value) { addCriterion("BALANCE_ID >=", value, "balanceId"); return (Criteria) this; } public Criteria andBalanceIdLessThan(String value) { addCriterion("BALANCE_ID <", value, "balanceId"); return (Criteria) this; } public Criteria andBalanceIdLessThanOrEqualTo(String value) { addCriterion("BALANCE_ID <=", value, "balanceId"); return (Criteria) this; } public Criteria andBalanceIdLike(String value) { addCriterion("BALANCE_ID like", value, "balanceId"); return (Criteria) this; } public Criteria andBalanceIdNotLike(String value) { addCriterion("BALANCE_ID not like", value, "balanceId"); return (Criteria) this; } public Criteria andBalanceIdIn(List<String> values) { addCriterion("BALANCE_ID in", values, "balanceId"); return (Criteria) this; } public Criteria andBalanceIdNotIn(List<String> values) { addCriterion("BALANCE_ID not in", values, "balanceId"); return (Criteria) this; } public Criteria andBalanceIdBetween(String value1, String value2) { addCriterion("BALANCE_ID between", value1, value2, "balanceId"); return (Criteria) this; } public Criteria andBalanceIdNotBetween(String value1, String value2) { addCriterion("BALANCE_ID not between", value1, value2, "balanceId"); return (Criteria) this; } public Criteria andPeriodIdIsNull() { addCriterion("PERIOD_ID is null"); return (Criteria) this; } public Criteria andPeriodIdIsNotNull() { addCriterion("PERIOD_ID is not null"); return (Criteria) this; } public Criteria andPeriodIdEqualTo(Integer value) { addCriterion("PERIOD_ID =", value, "periodId"); return (Criteria) this; } public Criteria andPeriodIdNotEqualTo(Integer value) { addCriterion("PERIOD_ID <>", value, "periodId"); return (Criteria) this; } public Criteria andPeriodIdGreaterThan(Integer value) { addCriterion("PERIOD_ID >", value, "periodId"); return (Criteria) this; } public Criteria andPeriodIdGreaterThanOrEqualTo(Integer value) { addCriterion("PERIOD_ID >=", value, "periodId"); return (Criteria) this; } public Criteria andPeriodIdLessThan(Integer value) { addCriterion("PERIOD_ID <", value, "periodId"); return (Criteria) this; } public Criteria andPeriodIdLessThanOrEqualTo(Integer value) { addCriterion("PERIOD_ID <=", value, "periodId"); return (Criteria) this; } public Criteria andPeriodIdIn(List<Integer> values) { addCriterion("PERIOD_ID in", values, "periodId"); return (Criteria) this; } public Criteria andPeriodIdNotIn(List<Integer> values) { addCriterion("PERIOD_ID not in", values, "periodId"); return (Criteria) this; } public Criteria andPeriodIdBetween(Integer value1, Integer value2) { addCriterion("PERIOD_ID between", value1, value2, "periodId"); return (Criteria) this; } public Criteria andPeriodIdNotBetween(Integer value1, Integer value2) { addCriterion("PERIOD_ID not between", value1, value2, "periodId"); return (Criteria) this; } public Criteria andAcctCodeIsNull() { addCriterion("ACCT_CODE is null"); return (Criteria) this; } public Criteria andAcctCodeIsNotNull() { addCriterion("ACCT_CODE is not null"); return (Criteria) this; } public Criteria andAcctCodeEqualTo(String value) { addCriterion("ACCT_CODE =", value, "acctCode"); return (Criteria) this; } public Criteria andAcctCodeNotEqualTo(String value) { addCriterion("ACCT_CODE <>", value, "acctCode"); return (Criteria) this; } public Criteria andAcctCodeGreaterThan(String value) { addCriterion("ACCT_CODE >", value, "acctCode"); return (Criteria) this; } public Criteria andAcctCodeGreaterThanOrEqualTo(String value) { addCriterion("ACCT_CODE >=", value, "acctCode"); return (Criteria) this; } public Criteria andAcctCodeLessThan(String value) { addCriterion("ACCT_CODE <", value, "acctCode"); return (Criteria) this; } public Criteria andAcctCodeLessThanOrEqualTo(String value) { addCriterion("ACCT_CODE <=", value, "acctCode"); return (Criteria) this; } public Criteria andAcctCodeLike(String value) { addCriterion("ACCT_CODE like", value, "acctCode"); return (Criteria) this; } public Criteria andAcctCodeNotLike(String value) { addCriterion("ACCT_CODE not like", value, "acctCode"); return (Criteria) this; } public Criteria andAcctCodeIn(List<String> values) { addCriterion("ACCT_CODE in", values, "acctCode"); return (Criteria) this; } public Criteria andAcctCodeNotIn(List<String> values) { addCriterion("ACCT_CODE not in", values, "acctCode"); return (Criteria) this; } public Criteria andAcctCodeBetween(String value1, String value2) { addCriterion("ACCT_CODE between", value1, value2, "acctCode"); return (Criteria) this; } public Criteria andAcctCodeNotBetween(String value1, String value2) { addCriterion("ACCT_CODE not between", value1, value2, "acctCode"); return (Criteria) this; } public Criteria andBegDebitBalIsNull() { addCriterion("BEG_DEBIT_BAL is null"); return (Criteria) this; } public Criteria andBegDebitBalIsNotNull() { addCriterion("BEG_DEBIT_BAL is not null"); return (Criteria) this; } public Criteria andBegDebitBalEqualTo(BigDecimal value) { addCriterion("BEG_DEBIT_BAL =", value, "begDebitBal"); return (Criteria) this; } public Criteria andBegDebitBalNotEqualTo(BigDecimal value) { addCriterion("BEG_DEBIT_BAL <>", value, "begDebitBal"); return (Criteria) this; } public Criteria andBegDebitBalGreaterThan(BigDecimal value) { addCriterion("BEG_DEBIT_BAL >", value, "begDebitBal"); return (Criteria) this; } public Criteria andBegDebitBalGreaterThanOrEqualTo(BigDecimal value) { addCriterion("BEG_DEBIT_BAL >=", value, "begDebitBal"); return (Criteria) this; } public Criteria andBegDebitBalLessThan(BigDecimal value) { addCriterion("BEG_DEBIT_BAL <", value, "begDebitBal"); return (Criteria) this; } public Criteria andBegDebitBalLessThanOrEqualTo(BigDecimal value) { addCriterion("BEG_DEBIT_BAL <=", value, "begDebitBal"); return (Criteria) this; } public Criteria andBegDebitBalIn(List<BigDecimal> values) { addCriterion("BEG_DEBIT_BAL in", values, "begDebitBal"); return (Criteria) this; } public Criteria andBegDebitBalNotIn(List<BigDecimal> values) { addCriterion("BEG_DEBIT_BAL not in", values, "begDebitBal"); return (Criteria) this; } public Criteria andBegDebitBalBetween(BigDecimal value1, BigDecimal value2) { addCriterion("BEG_DEBIT_BAL between", value1, value2, "begDebitBal"); return (Criteria) this; } public Criteria andBegDebitBalNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("BEG_DEBIT_BAL not between", value1, value2, "begDebitBal"); return (Criteria) this; } public Criteria andBegCreditBalIsNull() { addCriterion("BEG_CREDIT_BAL is null"); return (Criteria) this; } public Criteria andBegCreditBalIsNotNull() { addCriterion("BEG_CREDIT_BAL is not null"); return (Criteria) this; } public Criteria andBegCreditBalEqualTo(BigDecimal value) { addCriterion("BEG_CREDIT_BAL =", value, "begCreditBal"); return (Criteria) this; } public Criteria andBegCreditBalNotEqualTo(BigDecimal value) { addCriterion("BEG_CREDIT_BAL <>", value, "begCreditBal"); return (Criteria) this; } public Criteria andBegCreditBalGreaterThan(BigDecimal value) { addCriterion("BEG_CREDIT_BAL >", value, "begCreditBal"); return (Criteria) this; } public Criteria andBegCreditBalGreaterThanOrEqualTo(BigDecimal value) { addCriterion("BEG_CREDIT_BAL >=", value, "begCreditBal"); return (Criteria) this; } public Criteria andBegCreditBalLessThan(BigDecimal value) { addCriterion("BEG_CREDIT_BAL <", value, "begCreditBal"); return (Criteria) this; } public Criteria andBegCreditBalLessThanOrEqualTo(BigDecimal value) { addCriterion("BEG_CREDIT_BAL <=", value, "begCreditBal"); return (Criteria) this; } public Criteria andBegCreditBalIn(List<BigDecimal> values) { addCriterion("BEG_CREDIT_BAL in", values, "begCreditBal"); return (Criteria) this; } public Criteria andBegCreditBalNotIn(List<BigDecimal> values) { addCriterion("BEG_CREDIT_BAL not in", values, "begCreditBal"); return (Criteria) this; } public Criteria andBegCreditBalBetween(BigDecimal value1, BigDecimal value2) { addCriterion("BEG_CREDIT_BAL between", value1, value2, "begCreditBal"); return (Criteria) this; } public Criteria andBegCreditBalNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("BEG_CREDIT_BAL not between", value1, value2, "begCreditBal"); return (Criteria) this; } public Criteria andBegBalIsNull() { addCriterion("BEG_BAL is null"); return (Criteria) this; } public Criteria andBegBalIsNotNull() { addCriterion("BEG_BAL is not null"); return (Criteria) this; } public Criteria andBegBalEqualTo(BigDecimal value) { addCriterion("BEG_BAL =", value, "begBal"); return (Criteria) this; } public Criteria andBegBalNotEqualTo(BigDecimal value) { addCriterion("BEG_BAL <>", value, "begBal"); return (Criteria) this; } public Criteria andBegBalGreaterThan(BigDecimal value) { addCriterion("BEG_BAL >", value, "begBal"); return (Criteria) this; } public Criteria andBegBalGreaterThanOrEqualTo(BigDecimal value) { addCriterion("BEG_BAL >=", value, "begBal"); return (Criteria) this; } public Criteria andBegBalLessThan(BigDecimal value) { addCriterion("BEG_BAL <", value, "begBal"); return (Criteria) this; } public Criteria andBegBalLessThanOrEqualTo(BigDecimal value) { addCriterion("BEG_BAL <=", value, "begBal"); return (Criteria) this; } public Criteria andBegBalIn(List<BigDecimal> values) { addCriterion("BEG_BAL in", values, "begBal"); return (Criteria) this; } public Criteria andBegBalNotIn(List<BigDecimal> values) { addCriterion("BEG_BAL not in", values, "begBal"); return (Criteria) this; } public Criteria andBegBalBetween(BigDecimal value1, BigDecimal value2) { addCriterion("BEG_BAL between", value1, value2, "begBal"); return (Criteria) this; } public Criteria andBegBalNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("BEG_BAL not between", value1, value2, "begBal"); return (Criteria) this; } public Criteria andEndBalIsNull() { addCriterion("END_BAL is null"); return (Criteria) this; } public Criteria andEndBalIsNotNull() { addCriterion("END_BAL is not null"); return (Criteria) this; } public Criteria andEndBalEqualTo(BigDecimal value) { addCriterion("END_BAL =", value, "endBal"); return (Criteria) this; } public Criteria andEndBalNotEqualTo(BigDecimal value) { addCriterion("END_BAL <>", value, "endBal"); return (Criteria) this; } public Criteria andEndBalGreaterThan(BigDecimal value) { addCriterion("END_BAL >", value, "endBal"); return (Criteria) this; } public Criteria andEndBalGreaterThanOrEqualTo(BigDecimal value) { addCriterion("END_BAL >=", value, "endBal"); return (Criteria) this; } public Criteria andEndBalLessThan(BigDecimal value) { addCriterion("END_BAL <", value, "endBal"); return (Criteria) this; } public Criteria andEndBalLessThanOrEqualTo(BigDecimal value) { addCriterion("END_BAL <=", value, "endBal"); return (Criteria) this; } public Criteria andEndBalIn(List<BigDecimal> values) { addCriterion("END_BAL in", values, "endBal"); return (Criteria) this; } public Criteria andEndBalNotIn(List<BigDecimal> values) { addCriterion("END_BAL not in", values, "endBal"); return (Criteria) this; } public Criteria andEndBalBetween(BigDecimal value1, BigDecimal value2) { addCriterion("END_BAL between", value1, value2, "endBal"); return (Criteria) this; } public Criteria andEndBalNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("END_BAL not between", value1, value2, "endBal"); return (Criteria) this; } public Criteria andEndDebitBalIsNull() { addCriterion("END_DEBIT_BAL is null"); return (Criteria) this; } public Criteria andEndDebitBalIsNotNull() { addCriterion("END_DEBIT_BAL is not null"); return (Criteria) this; } public Criteria andEndDebitBalEqualTo(BigDecimal value) { addCriterion("END_DEBIT_BAL =", value, "endDebitBal"); return (Criteria) this; } public Criteria andEndDebitBalNotEqualTo(BigDecimal value) { addCriterion("END_DEBIT_BAL <>", value, "endDebitBal"); return (Criteria) this; } public Criteria andEndDebitBalGreaterThan(BigDecimal value) { addCriterion("END_DEBIT_BAL >", value, "endDebitBal"); return (Criteria) this; } public Criteria andEndDebitBalGreaterThanOrEqualTo(BigDecimal value) { addCriterion("END_DEBIT_BAL >=", value, "endDebitBal"); return (Criteria) this; } public Criteria andEndDebitBalLessThan(BigDecimal value) { addCriterion("END_DEBIT_BAL <", value, "endDebitBal"); return (Criteria) this; } public Criteria andEndDebitBalLessThanOrEqualTo(BigDecimal value) { addCriterion("END_DEBIT_BAL <=", value, "endDebitBal"); return (Criteria) this; } public Criteria andEndDebitBalIn(List<BigDecimal> values) { addCriterion("END_DEBIT_BAL in", values, "endDebitBal"); return (Criteria) this; } public Criteria andEndDebitBalNotIn(List<BigDecimal> values) { addCriterion("END_DEBIT_BAL not in", values, "endDebitBal"); return (Criteria) this; } public Criteria andEndDebitBalBetween(BigDecimal value1, BigDecimal value2) { addCriterion("END_DEBIT_BAL between", value1, value2, "endDebitBal"); return (Criteria) this; } public Criteria andEndDebitBalNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("END_DEBIT_BAL not between", value1, value2, "endDebitBal"); return (Criteria) this; } public Criteria andEndCreditBalIsNull() { addCriterion("END_CREDIT_BAL is null"); return (Criteria) this; } public Criteria andEndCreditBalIsNotNull() { addCriterion("END_CREDIT_BAL is not null"); return (Criteria) this; } public Criteria andEndCreditBalEqualTo(BigDecimal value) { addCriterion("END_CREDIT_BAL =", value, "endCreditBal"); return (Criteria) this; } public Criteria andEndCreditBalNotEqualTo(BigDecimal value) { addCriterion("END_CREDIT_BAL <>", value, "endCreditBal"); return (Criteria) this; } public Criteria andEndCreditBalGreaterThan(BigDecimal value) { addCriterion("END_CREDIT_BAL >", value, "endCreditBal"); return (Criteria) this; } public Criteria andEndCreditBalGreaterThanOrEqualTo(BigDecimal value) { addCriterion("END_CREDIT_BAL >=", value, "endCreditBal"); return (Criteria) this; } public Criteria andEndCreditBalLessThan(BigDecimal value) { addCriterion("END_CREDIT_BAL <", value, "endCreditBal"); return (Criteria) this; } public Criteria andEndCreditBalLessThanOrEqualTo(BigDecimal value) { addCriterion("END_CREDIT_BAL <=", value, "endCreditBal"); return (Criteria) this; } public Criteria andEndCreditBalIn(List<BigDecimal> values) { addCriterion("END_CREDIT_BAL in", values, "endCreditBal"); return (Criteria) this; } public Criteria andEndCreditBalNotIn(List<BigDecimal> values) { addCriterion("END_CREDIT_BAL not in", values, "endCreditBal"); return (Criteria) this; } public Criteria andEndCreditBalBetween(BigDecimal value1, BigDecimal value2) { addCriterion("END_CREDIT_BAL between", value1, value2, "endCreditBal"); return (Criteria) this; } public Criteria andEndCreditBalNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("END_CREDIT_BAL not between", value1, value2, "endCreditBal"); return (Criteria) this; } public Criteria andDebitBalIsNull() { addCriterion("DEBIT_BAL is null"); return (Criteria) this; } public Criteria andDebitBalIsNotNull() { addCriterion("DEBIT_BAL is not null"); return (Criteria) this; } public Criteria andDebitBalEqualTo(BigDecimal value) { addCriterion("DEBIT_BAL =", value, "debitBal"); return (Criteria) this; } public Criteria andDebitBalNotEqualTo(BigDecimal value) { addCriterion("DEBIT_BAL <>", value, "debitBal"); return (Criteria) this; } public Criteria andDebitBalGreaterThan(BigDecimal value) { addCriterion("DEBIT_BAL >", value, "debitBal"); return (Criteria) this; } public Criteria andDebitBalGreaterThanOrEqualTo(BigDecimal value) { addCriterion("DEBIT_BAL >=", value, "debitBal"); return (Criteria) this; } public Criteria andDebitBalLessThan(BigDecimal value) { addCriterion("DEBIT_BAL <", value, "debitBal"); return (Criteria) this; } public Criteria andDebitBalLessThanOrEqualTo(BigDecimal value) { addCriterion("DEBIT_BAL <=", value, "debitBal"); return (Criteria) this; } public Criteria andDebitBalIn(List<BigDecimal> values) { addCriterion("DEBIT_BAL in", values, "debitBal"); return (Criteria) this; } public Criteria andDebitBalNotIn(List<BigDecimal> values) { addCriterion("DEBIT_BAL not in", values, "debitBal"); return (Criteria) this; } public Criteria andDebitBalBetween(BigDecimal value1, BigDecimal value2) { addCriterion("DEBIT_BAL between", value1, value2, "debitBal"); return (Criteria) this; } public Criteria andDebitBalNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("DEBIT_BAL not between", value1, value2, "debitBal"); return (Criteria) this; } public Criteria andCreditBalIsNull() { addCriterion("CREDIT_BAL is null"); return (Criteria) this; } public Criteria andCreditBalIsNotNull() { addCriterion("CREDIT_BAL is not null"); return (Criteria) this; } public Criteria andCreditBalEqualTo(BigDecimal value) { addCriterion("CREDIT_BAL =", value, "creditBal"); return (Criteria) this; } public Criteria andCreditBalNotEqualTo(BigDecimal value) { addCriterion("CREDIT_BAL <>", value, "creditBal"); return (Criteria) this; } public Criteria andCreditBalGreaterThan(BigDecimal value) { addCriterion("CREDIT_BAL >", value, "creditBal"); return (Criteria) this; } public Criteria andCreditBalGreaterThanOrEqualTo(BigDecimal value) { addCriterion("CREDIT_BAL >=", value, "creditBal"); return (Criteria) this; } public Criteria andCreditBalLessThan(BigDecimal value) { addCriterion("CREDIT_BAL <", value, "creditBal"); return (Criteria) this; } public Criteria andCreditBalLessThanOrEqualTo(BigDecimal value) { addCriterion("CREDIT_BAL <=", value, "creditBal"); return (Criteria) this; } public Criteria andCreditBalIn(List<BigDecimal> values) { addCriterion("CREDIT_BAL in", values, "creditBal"); return (Criteria) this; } public Criteria andCreditBalNotIn(List<BigDecimal> values) { addCriterion("CREDIT_BAL not in", values, "creditBal"); return (Criteria) this; } public Criteria andCreditBalBetween(BigDecimal value1, BigDecimal value2) { addCriterion("CREDIT_BAL between", value1, value2, "creditBal"); return (Criteria) this; } public Criteria andCreditBalNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("CREDIT_BAL not between", value1, value2, "creditBal"); return (Criteria) this; } public Criteria andYearDebitBalIsNull() { addCriterion("YEAR_DEBIT_BAL is null"); return (Criteria) this; } public Criteria andYearDebitBalIsNotNull() { addCriterion("YEAR_DEBIT_BAL is not null"); return (Criteria) this; } public Criteria andYearDebitBalEqualTo(BigDecimal value) { addCriterion("YEAR_DEBIT_BAL =", value, "yearDebitBal"); return (Criteria) this; } public Criteria andYearDebitBalNotEqualTo(BigDecimal value) { addCriterion("YEAR_DEBIT_BAL <>", value, "yearDebitBal"); return (Criteria) this; } public Criteria andYearDebitBalGreaterThan(BigDecimal value) { addCriterion("YEAR_DEBIT_BAL >", value, "yearDebitBal"); return (Criteria) this; } public Criteria andYearDebitBalGreaterThanOrEqualTo(BigDecimal value) { addCriterion("YEAR_DEBIT_BAL >=", value, "yearDebitBal"); return (Criteria) this; } public Criteria andYearDebitBalLessThan(BigDecimal value) { addCriterion("YEAR_DEBIT_BAL <", value, "yearDebitBal"); return (Criteria) this; } public Criteria andYearDebitBalLessThanOrEqualTo(BigDecimal value) { addCriterion("YEAR_DEBIT_BAL <=", value, "yearDebitBal"); return (Criteria) this; } public Criteria andYearDebitBalIn(List<BigDecimal> values) { addCriterion("YEAR_DEBIT_BAL in", values, "yearDebitBal"); return (Criteria) this; } public Criteria andYearDebitBalNotIn(List<BigDecimal> values) { addCriterion("YEAR_DEBIT_BAL not in", values, "yearDebitBal"); return (Criteria) this; } public Criteria andYearDebitBalBetween(BigDecimal value1, BigDecimal value2) { addCriterion("YEAR_DEBIT_BAL between", value1, value2, "yearDebitBal"); return (Criteria) this; } public Criteria andYearDebitBalNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("YEAR_DEBIT_BAL not between", value1, value2, "yearDebitBal"); return (Criteria) this; } public Criteria andYearCreditBalIsNull() { addCriterion("YEAR_CREDIT_BAL is null"); return (Criteria) this; } public Criteria andYearCreditBalIsNotNull() { addCriterion("YEAR_CREDIT_BAL is not null"); return (Criteria) this; } public Criteria andYearCreditBalEqualTo(BigDecimal value) { addCriterion("YEAR_CREDIT_BAL =", value, "yearCreditBal"); return (Criteria) this; } public Criteria andYearCreditBalNotEqualTo(BigDecimal value) { addCriterion("YEAR_CREDIT_BAL <>", value, "yearCreditBal"); return (Criteria) this; } public Criteria andYearCreditBalGreaterThan(BigDecimal value) { addCriterion("YEAR_CREDIT_BAL >", value, "yearCreditBal"); return (Criteria) this; } public Criteria andYearCreditBalGreaterThanOrEqualTo(BigDecimal value) { addCriterion("YEAR_CREDIT_BAL >=", value, "yearCreditBal"); return (Criteria) this; } public Criteria andYearCreditBalLessThan(BigDecimal value) { addCriterion("YEAR_CREDIT_BAL <", value, "yearCreditBal"); return (Criteria) this; } public Criteria andYearCreditBalLessThanOrEqualTo(BigDecimal value) { addCriterion("YEAR_CREDIT_BAL <=", value, "yearCreditBal"); return (Criteria) this; } public Criteria andYearCreditBalIn(List<BigDecimal> values) { addCriterion("YEAR_CREDIT_BAL in", values, "yearCreditBal"); return (Criteria) this; } public Criteria andYearCreditBalNotIn(List<BigDecimal> values) { addCriterion("YEAR_CREDIT_BAL not in", values, "yearCreditBal"); return (Criteria) this; } public Criteria andYearCreditBalBetween(BigDecimal value1, BigDecimal value2) { addCriterion("YEAR_CREDIT_BAL between", value1, value2, "yearCreditBal"); return (Criteria) this; } public Criteria andYearCreditBalNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("YEAR_CREDIT_BAL not between", value1, value2, "yearCreditBal"); return (Criteria) this; } public Criteria andCarryoverDebitIsNull() { addCriterion("CARRYOVER_DEBIT is null"); return (Criteria) this; } public Criteria andCarryoverDebitIsNotNull() { addCriterion("CARRYOVER_DEBIT is not null"); return (Criteria) this; } public Criteria andCarryoverDebitEqualTo(BigDecimal value) { addCriterion("CARRYOVER_DEBIT =", value, "carryoverDebit"); return (Criteria) this; } public Criteria andCarryoverDebitNotEqualTo(BigDecimal value) { addCriterion("CARRYOVER_DEBIT <>", value, "carryoverDebit"); return (Criteria) this; } public Criteria andCarryoverDebitGreaterThan(BigDecimal value) { addCriterion("CARRYOVER_DEBIT >", value, "carryoverDebit"); return (Criteria) this; } public Criteria andCarryoverDebitGreaterThanOrEqualTo(BigDecimal value) { addCriterion("CARRYOVER_DEBIT >=", value, "carryoverDebit"); return (Criteria) this; } public Criteria andCarryoverDebitLessThan(BigDecimal value) { addCriterion("CARRYOVER_DEBIT <", value, "carryoverDebit"); return (Criteria) this; } public Criteria andCarryoverDebitLessThanOrEqualTo(BigDecimal value) { addCriterion("CARRYOVER_DEBIT <=", value, "carryoverDebit"); return (Criteria) this; } public Criteria andCarryoverDebitIn(List<BigDecimal> values) { addCriterion("CARRYOVER_DEBIT in", values, "carryoverDebit"); return (Criteria) this; } public Criteria andCarryoverDebitNotIn(List<BigDecimal> values) { addCriterion("CARRYOVER_DEBIT not in", values, "carryoverDebit"); return (Criteria) this; } public Criteria andCarryoverDebitBetween(BigDecimal value1, BigDecimal value2) { addCriterion("CARRYOVER_DEBIT between", value1, value2, "carryoverDebit"); return (Criteria) this; } public Criteria andCarryoverDebitNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("CARRYOVER_DEBIT not between", value1, value2, "carryoverDebit"); return (Criteria) this; } public Criteria andCarryoverCreditIsNull() { addCriterion("CARRYOVER_CREDIT is null"); return (Criteria) this; } public Criteria andCarryoverCreditIsNotNull() { addCriterion("CARRYOVER_CREDIT is not null"); return (Criteria) this; } public Criteria andCarryoverCreditEqualTo(BigDecimal value) { addCriterion("CARRYOVER_CREDIT =", value, "carryoverCredit"); return (Criteria) this; } public Criteria andCarryoverCreditNotEqualTo(BigDecimal value) { addCriterion("CARRYOVER_CREDIT <>", value, "carryoverCredit"); return (Criteria) this; } public Criteria andCarryoverCreditGreaterThan(BigDecimal value) { addCriterion("CARRYOVER_CREDIT >", value, "carryoverCredit"); return (Criteria) this; } public Criteria andCarryoverCreditGreaterThanOrEqualTo(BigDecimal value) { addCriterion("CARRYOVER_CREDIT >=", value, "carryoverCredit"); return (Criteria) this; } public Criteria andCarryoverCreditLessThan(BigDecimal value) { addCriterion("CARRYOVER_CREDIT <", value, "carryoverCredit"); return (Criteria) this; } public Criteria andCarryoverCreditLessThanOrEqualTo(BigDecimal value) { addCriterion("CARRYOVER_CREDIT <=", value, "carryoverCredit"); return (Criteria) this; } public Criteria andCarryoverCreditIn(List<BigDecimal> values) { addCriterion("CARRYOVER_CREDIT in", values, "carryoverCredit"); return (Criteria) this; } public Criteria andCarryoverCreditNotIn(List<BigDecimal> values) { addCriterion("CARRYOVER_CREDIT not in", values, "carryoverCredit"); return (Criteria) this; } public Criteria andCarryoverCreditBetween(BigDecimal value1, BigDecimal value2) { addCriterion("CARRYOVER_CREDIT between", value1, value2, "carryoverCredit"); return (Criteria) this; } public Criteria andCarryoverCreditNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("CARRYOVER_CREDIT not between", value1, value2, "carryoverCredit"); return (Criteria) this; } public Criteria andYearCarryoverDebitIsNull() { addCriterion("YEAR_CARRYOVER_DEBIT is null"); return (Criteria) this; } public Criteria andYearCarryoverDebitIsNotNull() { addCriterion("YEAR_CARRYOVER_DEBIT is not null"); return (Criteria) this; } public Criteria andYearCarryoverDebitEqualTo(BigDecimal value) { addCriterion("YEAR_CARRYOVER_DEBIT =", value, "yearCarryoverDebit"); return (Criteria) this; } public Criteria andYearCarryoverDebitNotEqualTo(BigDecimal value) { addCriterion("YEAR_CARRYOVER_DEBIT <>", value, "yearCarryoverDebit"); return (Criteria) this; } public Criteria andYearCarryoverDebitGreaterThan(BigDecimal value) { addCriterion("YEAR_CARRYOVER_DEBIT >", value, "yearCarryoverDebit"); return (Criteria) this; } public Criteria andYearCarryoverDebitGreaterThanOrEqualTo(BigDecimal value) { addCriterion("YEAR_CARRYOVER_DEBIT >=", value, "yearCarryoverDebit"); return (Criteria) this; } public Criteria andYearCarryoverDebitLessThan(BigDecimal value) { addCriterion("YEAR_CARRYOVER_DEBIT <", value, "yearCarryoverDebit"); return (Criteria) this; } public Criteria andYearCarryoverDebitLessThanOrEqualTo(BigDecimal value) { addCriterion("YEAR_CARRYOVER_DEBIT <=", value, "yearCarryoverDebit"); return (Criteria) this; } public Criteria andYearCarryoverDebitIn(List<BigDecimal> values) { addCriterion("YEAR_CARRYOVER_DEBIT in", values, "yearCarryoverDebit"); return (Criteria) this; } public Criteria andYearCarryoverDebitNotIn(List<BigDecimal> values) { addCriterion("YEAR_CARRYOVER_DEBIT not in", values, "yearCarryoverDebit"); return (Criteria) this; } public Criteria andYearCarryoverDebitBetween(BigDecimal value1, BigDecimal value2) { addCriterion("YEAR_CARRYOVER_DEBIT between", value1, value2, "yearCarryoverDebit"); return (Criteria) this; } public Criteria andYearCarryoverDebitNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("YEAR_CARRYOVER_DEBIT not between", value1, value2, "yearCarryoverDebit"); return (Criteria) this; } public Criteria andYearCarryoverCreditIsNull() { addCriterion("YEAR_CARRYOVER_CREDIT is null"); return (Criteria) this; } public Criteria andYearCarryoverCreditIsNotNull() { addCriterion("YEAR_CARRYOVER_CREDIT is not null"); return (Criteria) this; } public Criteria andYearCarryoverCreditEqualTo(BigDecimal value) { addCriterion("YEAR_CARRYOVER_CREDIT =", value, "yearCarryoverCredit"); return (Criteria) this; } public Criteria andYearCarryoverCreditNotEqualTo(BigDecimal value) { addCriterion("YEAR_CARRYOVER_CREDIT <>", value, "yearCarryoverCredit"); return (Criteria) this; } public Criteria andYearCarryoverCreditGreaterThan(BigDecimal value) { addCriterion("YEAR_CARRYOVER_CREDIT >", value, "yearCarryoverCredit"); return (Criteria) this; } public Criteria andYearCarryoverCreditGreaterThanOrEqualTo(BigDecimal value) { addCriterion("YEAR_CARRYOVER_CREDIT >=", value, "yearCarryoverCredit"); return (Criteria) this; } public Criteria andYearCarryoverCreditLessThan(BigDecimal value) { addCriterion("YEAR_CARRYOVER_CREDIT <", value, "yearCarryoverCredit"); return (Criteria) this; } public Criteria andYearCarryoverCreditLessThanOrEqualTo(BigDecimal value) { addCriterion("YEAR_CARRYOVER_CREDIT <=", value, "yearCarryoverCredit"); return (Criteria) this; } public Criteria andYearCarryoverCreditIn(List<BigDecimal> values) { addCriterion("YEAR_CARRYOVER_CREDIT in", values, "yearCarryoverCredit"); return (Criteria) this; } public Criteria andYearCarryoverCreditNotIn(List<BigDecimal> values) { addCriterion("YEAR_CARRYOVER_CREDIT not in", values, "yearCarryoverCredit"); return (Criteria) this; } public Criteria andYearCarryoverCreditBetween(BigDecimal value1, BigDecimal value2) { addCriterion("YEAR_CARRYOVER_CREDIT between", value1, value2, "yearCarryoverCredit"); return (Criteria) this; } public Criteria andYearCarryoverCreditNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("YEAR_CARRYOVER_CREDIT not between", value1, value2, "yearCarryoverCredit"); return (Criteria) this; } public Criteria andDebitNetIsNull() { addCriterion("DEBIT_NET is null"); return (Criteria) this; } public Criteria andDebitNetIsNotNull() { addCriterion("DEBIT_NET is not null"); return (Criteria) this; } public Criteria andDebitNetEqualTo(BigDecimal value) { addCriterion("DEBIT_NET =", value, "debitNet"); return (Criteria) this; } public Criteria andDebitNetNotEqualTo(BigDecimal value) { addCriterion("DEBIT_NET <>", value, "debitNet"); return (Criteria) this; } public Criteria andDebitNetGreaterThan(BigDecimal value) { addCriterion("DEBIT_NET >", value, "debitNet"); return (Criteria) this; } public Criteria andDebitNetGreaterThanOrEqualTo(BigDecimal value) { addCriterion("DEBIT_NET >=", value, "debitNet"); return (Criteria) this; } public Criteria andDebitNetLessThan(BigDecimal value) { addCriterion("DEBIT_NET <", value, "debitNet"); return (Criteria) this; } public Criteria andDebitNetLessThanOrEqualTo(BigDecimal value) { addCriterion("DEBIT_NET <=", value, "debitNet"); return (Criteria) this; } public Criteria andDebitNetIn(List<BigDecimal> values) { addCriterion("DEBIT_NET in", values, "debitNet"); return (Criteria) this; } public Criteria andDebitNetNotIn(List<BigDecimal> values) { addCriterion("DEBIT_NET not in", values, "debitNet"); return (Criteria) this; } public Criteria andDebitNetBetween(BigDecimal value1, BigDecimal value2) { addCriterion("DEBIT_NET between", value1, value2, "debitNet"); return (Criteria) this; } public Criteria andDebitNetNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("DEBIT_NET not between", value1, value2, "debitNet"); return (Criteria) this; } public Criteria andCreditNetIsNull() { addCriterion("CREDIT_NET is null"); return (Criteria) this; } public Criteria andCreditNetIsNotNull() { addCriterion("CREDIT_NET is not null"); return (Criteria) this; } public Criteria andCreditNetEqualTo(BigDecimal value) { addCriterion("CREDIT_NET =", value, "creditNet"); return (Criteria) this; } public Criteria andCreditNetNotEqualTo(BigDecimal value) { addCriterion("CREDIT_NET <>", value, "creditNet"); return (Criteria) this; } public Criteria andCreditNetGreaterThan(BigDecimal value) { addCriterion("CREDIT_NET >", value, "creditNet"); return (Criteria) this; } public Criteria andCreditNetGreaterThanOrEqualTo(BigDecimal value) { addCriterion("CREDIT_NET >=", value, "creditNet"); return (Criteria) this; } public Criteria andCreditNetLessThan(BigDecimal value) { addCriterion("CREDIT_NET <", value, "creditNet"); return (Criteria) this; } public Criteria andCreditNetLessThanOrEqualTo(BigDecimal value) { addCriterion("CREDIT_NET <=", value, "creditNet"); return (Criteria) this; } public Criteria andCreditNetIn(List<BigDecimal> values) { addCriterion("CREDIT_NET in", values, "creditNet"); return (Criteria) this; } public Criteria andCreditNetNotIn(List<BigDecimal> values) { addCriterion("CREDIT_NET not in", values, "creditNet"); return (Criteria) this; } public Criteria andCreditNetBetween(BigDecimal value1, BigDecimal value2) { addCriterion("CREDIT_NET between", value1, value2, "creditNet"); return (Criteria) this; } public Criteria andCreditNetNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("CREDIT_NET not between", value1, value2, "creditNet"); return (Criteria) this; } public Criteria andYearDebitNetIsNull() { addCriterion("YEAR_DEBIT_NET is null"); return (Criteria) this; } public Criteria andYearDebitNetIsNotNull() { addCriterion("YEAR_DEBIT_NET is not null"); return (Criteria) this; } public Criteria andYearDebitNetEqualTo(BigDecimal value) { addCriterion("YEAR_DEBIT_NET =", value, "yearDebitNet"); return (Criteria) this; } public Criteria andYearDebitNetNotEqualTo(BigDecimal value) { addCriterion("YEAR_DEBIT_NET <>", value, "yearDebitNet"); return (Criteria) this; } public Criteria andYearDebitNetGreaterThan(BigDecimal value) { addCriterion("YEAR_DEBIT_NET >", value, "yearDebitNet"); return (Criteria) this; } public Criteria andYearDebitNetGreaterThanOrEqualTo(BigDecimal value) { addCriterion("YEAR_DEBIT_NET >=", value, "yearDebitNet"); return (Criteria) this; } public Criteria andYearDebitNetLessThan(BigDecimal value) { addCriterion("YEAR_DEBIT_NET <", value, "yearDebitNet"); return (Criteria) this; } public Criteria andYearDebitNetLessThanOrEqualTo(BigDecimal value) { addCriterion("YEAR_DEBIT_NET <=", value, "yearDebitNet"); return (Criteria) this; } public Criteria andYearDebitNetIn(List<BigDecimal> values) { addCriterion("YEAR_DEBIT_NET in", values, "yearDebitNet"); return (Criteria) this; } public Criteria andYearDebitNetNotIn(List<BigDecimal> values) { addCriterion("YEAR_DEBIT_NET not in", values, "yearDebitNet"); return (Criteria) this; } public Criteria andYearDebitNetBetween(BigDecimal value1, BigDecimal value2) { addCriterion("YEAR_DEBIT_NET between", value1, value2, "yearDebitNet"); return (Criteria) this; } public Criteria andYearDebitNetNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("YEAR_DEBIT_NET not between", value1, value2, "yearDebitNet"); return (Criteria) this; } public Criteria andYearCreditNetIsNull() { addCriterion("YEAR_CREDIT_NET is null"); return (Criteria) this; } public Criteria andYearCreditNetIsNotNull() { addCriterion("YEAR_CREDIT_NET is not null"); return (Criteria) this; } public Criteria andYearCreditNetEqualTo(BigDecimal value) { addCriterion("YEAR_CREDIT_NET =", value, "yearCreditNet"); return (Criteria) this; } public Criteria andYearCreditNetNotEqualTo(BigDecimal value) { addCriterion("YEAR_CREDIT_NET <>", value, "yearCreditNet"); return (Criteria) this; } public Criteria andYearCreditNetGreaterThan(BigDecimal value) { addCriterion("YEAR_CREDIT_NET >", value, "yearCreditNet"); return (Criteria) this; } public Criteria andYearCreditNetGreaterThanOrEqualTo(BigDecimal value) { addCriterion("YEAR_CREDIT_NET >=", value, "yearCreditNet"); return (Criteria) this; } public Criteria andYearCreditNetLessThan(BigDecimal value) { addCriterion("YEAR_CREDIT_NET <", value, "yearCreditNet"); return (Criteria) this; } public Criteria andYearCreditNetLessThanOrEqualTo(BigDecimal value) { addCriterion("YEAR_CREDIT_NET <=", value, "yearCreditNet"); return (Criteria) this; } public Criteria andYearCreditNetIn(List<BigDecimal> values) { addCriterion("YEAR_CREDIT_NET in", values, "yearCreditNet"); return (Criteria) this; } public Criteria andYearCreditNetNotIn(List<BigDecimal> values) { addCriterion("YEAR_CREDIT_NET not in", values, "yearCreditNet"); return (Criteria) this; } public Criteria andYearCreditNetBetween(BigDecimal value1, BigDecimal value2) { addCriterion("YEAR_CREDIT_NET between", value1, value2, "yearCreditNet"); return (Criteria) this; } public Criteria andYearCreditNetNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("YEAR_CREDIT_NET not between", value1, value2, "yearCreditNet"); return (Criteria) this; } public Criteria andCreateTimeIsNull() { addCriterion("CREATE_TIME is null"); return (Criteria) this; } public Criteria andCreateTimeIsNotNull() { addCriterion("CREATE_TIME is not null"); return (Criteria) this; } public Criteria andCreateTimeEqualTo(Date value) { addCriterion("CREATE_TIME =", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeNotEqualTo(Date value) { addCriterion("CREATE_TIME <>", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeGreaterThan(Date value) { addCriterion("CREATE_TIME >", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) { addCriterion("CREATE_TIME >=", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeLessThan(Date value) { addCriterion("CREATE_TIME <", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeLessThanOrEqualTo(Date value) { addCriterion("CREATE_TIME <=", value, "createTime"); return (Criteria) this; } public Criteria andCreateTimeIn(List<Date> values) { addCriterion("CREATE_TIME in", values, "createTime"); return (Criteria) this; } public Criteria andCreateTimeNotIn(List<Date> values) { addCriterion("CREATE_TIME not in", values, "createTime"); return (Criteria) this; } public Criteria andCreateTimeBetween(Date value1, Date value2) { addCriterion("CREATE_TIME between", value1, value2, "createTime"); return (Criteria) this; } public Criteria andCreateTimeNotBetween(Date value1, Date value2) { addCriterion("CREATE_TIME not between", value1, value2, "createTime"); return (Criteria) this; } public Criteria andUpdateTimeIsNull() { addCriterion("UPDATE_TIME is null"); return (Criteria) this; } public Criteria andUpdateTimeIsNotNull() { addCriterion("UPDATE_TIME is not null"); return (Criteria) this; } public Criteria andUpdateTimeEqualTo(Date value) { addCriterion("UPDATE_TIME =", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeNotEqualTo(Date value) { addCriterion("UPDATE_TIME <>", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeGreaterThan(Date value) { addCriterion("UPDATE_TIME >", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) { addCriterion("UPDATE_TIME >=", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeLessThan(Date value) { addCriterion("UPDATE_TIME <", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeLessThanOrEqualTo(Date value) { addCriterion("UPDATE_TIME <=", value, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeIn(List<Date> values) { addCriterion("UPDATE_TIME in", values, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeNotIn(List<Date> values) { addCriterion("UPDATE_TIME not in", values, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeBetween(Date value1, Date value2) { addCriterion("UPDATE_TIME between", value1, value2, "updateTime"); return (Criteria) this; } public Criteria andUpdateTimeNotBetween(Date value1, Date value2) { addCriterion("UPDATE_TIME not between", value1, value2, "updateTime"); return (Criteria) this; } public Criteria andSubPropIsNull() { addCriterion("SUB_PROP is null"); return (Criteria) this; } public Criteria andSubPropIsNotNull() { addCriterion("SUB_PROP is not null"); return (Criteria) this; } public Criteria andSubPropEqualTo(Integer value) { addCriterion("SUB_PROP =", value, "subProp"); return (Criteria) this; } public Criteria andSubPropNotEqualTo(Integer value) { addCriterion("SUB_PROP <>", value, "subProp"); return (Criteria) this; } public Criteria andSubPropGreaterThan(Integer value) { addCriterion("SUB_PROP >", value, "subProp"); return (Criteria) this; } public Criteria andSubPropGreaterThanOrEqualTo(Integer value) { addCriterion("SUB_PROP >=", value, "subProp"); return (Criteria) this; } public Criteria andSubPropLessThan(Integer value) { addCriterion("SUB_PROP <", value, "subProp"); return (Criteria) this; } public Criteria andSubPropLessThanOrEqualTo(Integer value) { addCriterion("SUB_PROP <=", value, "subProp"); return (Criteria) this; } public Criteria andSubPropIn(List<Integer> values) { addCriterion("SUB_PROP in", values, "subProp"); return (Criteria) this; } public Criteria andSubPropNotIn(List<Integer> values) { addCriterion("SUB_PROP not in", values, "subProp"); return (Criteria) this; } public Criteria andSubPropBetween(Integer value1, Integer value2) { addCriterion("SUB_PROP between", value1, value2, "subProp"); return (Criteria) this; } public Criteria andSubPropNotBetween(Integer value1, Integer value2) { addCriterion("SUB_PROP not between", value1, value2, "subProp"); return (Criteria) this; } } /** * This class was generated by MyBatis Generator. * This class corresponds to the database table TAX_PROJECT.BALANCE_STD * * @mbg.generated do_not_delete_during_merge */ public static class Criteria extends GeneratedCriteria { protected Criteria() { super(); } } /** * This class was generated by MyBatis Generator. * This class corresponds to the database table TAX_PROJECT.BALANCE_STD * * @mbg.generated */ public static class Criterion { private String condition; private Object value; private Object secondValue; private boolean noValue; private boolean singleValue; private boolean betweenValue; private boolean listValue; private String typeHandler; public String getCondition() { return condition; } public Object getValue() { return value; } public Object getSecondValue() { return secondValue; } public boolean isNoValue() { return noValue; } public boolean isSingleValue() { return singleValue; } public boolean isBetweenValue() { return betweenValue; } public boolean isListValue() { return listValue; } public String getTypeHandler() { return typeHandler; } protected Criterion(String condition) { super(); this.condition = condition; this.typeHandler = null; this.noValue = true; } protected Criterion(String condition, Object value, String typeHandler) { super(); this.condition = condition; this.value = value; this.typeHandler = typeHandler; if (value instanceof List<?>) { this.listValue = true; } else { this.singleValue = true; } } protected Criterion(String condition, Object value) { this(condition, value, null); } protected Criterion(String condition, Object value, Object secondValue, String typeHandler) { super(); this.condition = condition; this.value = value; this.secondValue = secondValue; this.typeHandler = typeHandler; this.betweenValue = true; } protected Criterion(String condition, Object value, Object secondValue) { this(condition, value, secondValue, null); } } }