TOrderBillNewExample.java 40 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353
  1. package com.goafanti.common.model;
  2. import java.math.BigDecimal;
  3. import java.util.ArrayList;
  4. import java.util.Date;
  5. import java.util.List;
  6. public class TOrderBillNewExample {
  7. /**
  8. * This field was generated by MyBatis Generator. This field corresponds to the database table t_order_bill_new
  9. * @mbg.generated Mon Feb 17 11:41:23 CST 2020
  10. */
  11. protected String orderByClause;
  12. /**
  13. * This field was generated by MyBatis Generator. This field corresponds to the database table t_order_bill_new
  14. * @mbg.generated Mon Feb 17 11:41:23 CST 2020
  15. */
  16. protected boolean distinct;
  17. /**
  18. * This field was generated by MyBatis Generator. This field corresponds to the database table t_order_bill_new
  19. * @mbg.generated Mon Feb 17 11:41:23 CST 2020
  20. */
  21. protected List<Criteria> oredCriteria;
  22. /**
  23. * This method was generated by MyBatis Generator. This method corresponds to the database table t_order_bill_new
  24. * @mbg.generated Mon Feb 17 11:41:23 CST 2020
  25. */
  26. public TOrderBillNewExample() {
  27. oredCriteria = new ArrayList<Criteria>();
  28. }
  29. /**
  30. * This method was generated by MyBatis Generator. This method corresponds to the database table t_order_bill_new
  31. * @mbg.generated Mon Feb 17 11:41:23 CST 2020
  32. */
  33. public void setOrderByClause(String orderByClause) {
  34. this.orderByClause = orderByClause;
  35. }
  36. /**
  37. * This method was generated by MyBatis Generator. This method corresponds to the database table t_order_bill_new
  38. * @mbg.generated Mon Feb 17 11:41:23 CST 2020
  39. */
  40. public String getOrderByClause() {
  41. return orderByClause;
  42. }
  43. /**
  44. * This method was generated by MyBatis Generator. This method corresponds to the database table t_order_bill_new
  45. * @mbg.generated Mon Feb 17 11:41:23 CST 2020
  46. */
  47. public void setDistinct(boolean distinct) {
  48. this.distinct = distinct;
  49. }
  50. /**
  51. * This method was generated by MyBatis Generator. This method corresponds to the database table t_order_bill_new
  52. * @mbg.generated Mon Feb 17 11:41:23 CST 2020
  53. */
  54. public boolean isDistinct() {
  55. return distinct;
  56. }
  57. /**
  58. * This method was generated by MyBatis Generator. This method corresponds to the database table t_order_bill_new
  59. * @mbg.generated Mon Feb 17 11:41:23 CST 2020
  60. */
  61. public List<Criteria> getOredCriteria() {
  62. return oredCriteria;
  63. }
  64. /**
  65. * This method was generated by MyBatis Generator. This method corresponds to the database table t_order_bill_new
  66. * @mbg.generated Mon Feb 17 11:41:23 CST 2020
  67. */
  68. public void or(Criteria criteria) {
  69. oredCriteria.add(criteria);
  70. }
  71. /**
  72. * This method was generated by MyBatis Generator. This method corresponds to the database table t_order_bill_new
  73. * @mbg.generated Mon Feb 17 11:41:23 CST 2020
  74. */
  75. public Criteria or() {
  76. Criteria criteria = createCriteriaInternal();
  77. oredCriteria.add(criteria);
  78. return criteria;
  79. }
  80. /**
  81. * This method was generated by MyBatis Generator. This method corresponds to the database table t_order_bill_new
  82. * @mbg.generated Mon Feb 17 11:41:23 CST 2020
  83. */
  84. public Criteria createCriteria() {
  85. Criteria criteria = createCriteriaInternal();
  86. if (oredCriteria.size() == 0) {
  87. oredCriteria.add(criteria);
  88. }
  89. return criteria;
  90. }
  91. /**
  92. * This method was generated by MyBatis Generator. This method corresponds to the database table t_order_bill_new
  93. * @mbg.generated Mon Feb 17 11:41:23 CST 2020
  94. */
  95. protected Criteria createCriteriaInternal() {
  96. Criteria criteria = new Criteria();
  97. return criteria;
  98. }
  99. /**
  100. * This method was generated by MyBatis Generator. This method corresponds to the database table t_order_bill_new
  101. * @mbg.generated Mon Feb 17 11:41:23 CST 2020
  102. */
  103. public void clear() {
  104. oredCriteria.clear();
  105. orderByClause = null;
  106. distinct = false;
  107. }
  108. /**
  109. * This class was generated by MyBatis Generator. This class corresponds to the database table t_order_bill_new
  110. * @mbg.generated Mon Feb 17 11:41:23 CST 2020
  111. */
  112. protected abstract static class GeneratedCriteria {
  113. protected List<Criterion> criteria;
  114. protected GeneratedCriteria() {
  115. super();
  116. criteria = new ArrayList<Criterion>();
  117. }
  118. public boolean isValid() {
  119. return criteria.size() > 0;
  120. }
  121. public List<Criterion> getAllCriteria() {
  122. return criteria;
  123. }
  124. public List<Criterion> getCriteria() {
  125. return criteria;
  126. }
  127. protected void addCriterion(String condition) {
  128. if (condition == null) {
  129. throw new RuntimeException("Value for condition cannot be null");
  130. }
  131. criteria.add(new Criterion(condition));
  132. }
  133. protected void addCriterion(String condition, Object value, String property) {
  134. if (value == null) {
  135. throw new RuntimeException("Value for " + property + " cannot be null");
  136. }
  137. criteria.add(new Criterion(condition, value));
  138. }
  139. protected void addCriterion(String condition, Object value1, Object value2, String property) {
  140. if (value1 == null || value2 == null) {
  141. throw new RuntimeException("Between values for " + property + " cannot be null");
  142. }
  143. criteria.add(new Criterion(condition, value1, value2));
  144. }
  145. public Criteria andBillNoIsNull() {
  146. addCriterion("bill_no is null");
  147. return (Criteria) this;
  148. }
  149. public Criteria andBillNoIsNotNull() {
  150. addCriterion("bill_no is not null");
  151. return (Criteria) this;
  152. }
  153. public Criteria andBillNoEqualTo(String value) {
  154. addCriterion("bill_no =", value, "billNo");
  155. return (Criteria) this;
  156. }
  157. public Criteria andBillNoNotEqualTo(String value) {
  158. addCriterion("bill_no <>", value, "billNo");
  159. return (Criteria) this;
  160. }
  161. public Criteria andBillNoGreaterThan(String value) {
  162. addCriterion("bill_no >", value, "billNo");
  163. return (Criteria) this;
  164. }
  165. public Criteria andBillNoGreaterThanOrEqualTo(String value) {
  166. addCriterion("bill_no >=", value, "billNo");
  167. return (Criteria) this;
  168. }
  169. public Criteria andBillNoLessThan(String value) {
  170. addCriterion("bill_no <", value, "billNo");
  171. return (Criteria) this;
  172. }
  173. public Criteria andBillNoLessThanOrEqualTo(String value) {
  174. addCriterion("bill_no <=", value, "billNo");
  175. return (Criteria) this;
  176. }
  177. public Criteria andBillNoLike(String value) {
  178. addCriterion("bill_no like", value, "billNo");
  179. return (Criteria) this;
  180. }
  181. public Criteria andBillNoNotLike(String value) {
  182. addCriterion("bill_no not like", value, "billNo");
  183. return (Criteria) this;
  184. }
  185. public Criteria andBillNoIn(List<String> values) {
  186. addCriterion("bill_no in", values, "billNo");
  187. return (Criteria) this;
  188. }
  189. public Criteria andBillNoNotIn(List<String> values) {
  190. addCriterion("bill_no not in", values, "billNo");
  191. return (Criteria) this;
  192. }
  193. public Criteria andBillNoBetween(String value1, String value2) {
  194. addCriterion("bill_no between", value1, value2, "billNo");
  195. return (Criteria) this;
  196. }
  197. public Criteria andBillNoNotBetween(String value1, String value2) {
  198. addCriterion("bill_no not between", value1, value2, "billNo");
  199. return (Criteria) this;
  200. }
  201. public Criteria andOrderNoIsNull() {
  202. addCriterion("order_no is null");
  203. return (Criteria) this;
  204. }
  205. public Criteria andOrderNoIsNotNull() {
  206. addCriterion("order_no is not null");
  207. return (Criteria) this;
  208. }
  209. public Criteria andOrderNoEqualTo(String value) {
  210. addCriterion("order_no =", value, "orderNo");
  211. return (Criteria) this;
  212. }
  213. public Criteria andOrderNoNotEqualTo(String value) {
  214. addCriterion("order_no <>", value, "orderNo");
  215. return (Criteria) this;
  216. }
  217. public Criteria andOrderNoGreaterThan(String value) {
  218. addCriterion("order_no >", value, "orderNo");
  219. return (Criteria) this;
  220. }
  221. public Criteria andOrderNoGreaterThanOrEqualTo(String value) {
  222. addCriterion("order_no >=", value, "orderNo");
  223. return (Criteria) this;
  224. }
  225. public Criteria andOrderNoLessThan(String value) {
  226. addCriterion("order_no <", value, "orderNo");
  227. return (Criteria) this;
  228. }
  229. public Criteria andOrderNoLessThanOrEqualTo(String value) {
  230. addCriterion("order_no <=", value, "orderNo");
  231. return (Criteria) this;
  232. }
  233. public Criteria andOrderNoLike(String value) {
  234. addCriterion("order_no like", value, "orderNo");
  235. return (Criteria) this;
  236. }
  237. public Criteria andOrderNoNotLike(String value) {
  238. addCriterion("order_no not like", value, "orderNo");
  239. return (Criteria) this;
  240. }
  241. public Criteria andOrderNoIn(List<String> values) {
  242. addCriterion("order_no in", values, "orderNo");
  243. return (Criteria) this;
  244. }
  245. public Criteria andOrderNoNotIn(List<String> values) {
  246. addCriterion("order_no not in", values, "orderNo");
  247. return (Criteria) this;
  248. }
  249. public Criteria andOrderNoBetween(String value1, String value2) {
  250. addCriterion("order_no between", value1, value2, "orderNo");
  251. return (Criteria) this;
  252. }
  253. public Criteria andOrderNoNotBetween(String value1, String value2) {
  254. addCriterion("order_no not between", value1, value2, "orderNo");
  255. return (Criteria) this;
  256. }
  257. public Criteria andCreaterIsNull() {
  258. addCriterion("creater is null");
  259. return (Criteria) this;
  260. }
  261. public Criteria andCreaterIsNotNull() {
  262. addCriterion("creater is not null");
  263. return (Criteria) this;
  264. }
  265. public Criteria andCreaterEqualTo(String value) {
  266. addCriterion("creater =", value, "creater");
  267. return (Criteria) this;
  268. }
  269. public Criteria andCreaterNotEqualTo(String value) {
  270. addCriterion("creater <>", value, "creater");
  271. return (Criteria) this;
  272. }
  273. public Criteria andCreaterGreaterThan(String value) {
  274. addCriterion("creater >", value, "creater");
  275. return (Criteria) this;
  276. }
  277. public Criteria andCreaterGreaterThanOrEqualTo(String value) {
  278. addCriterion("creater >=", value, "creater");
  279. return (Criteria) this;
  280. }
  281. public Criteria andCreaterLessThan(String value) {
  282. addCriterion("creater <", value, "creater");
  283. return (Criteria) this;
  284. }
  285. public Criteria andCreaterLessThanOrEqualTo(String value) {
  286. addCriterion("creater <=", value, "creater");
  287. return (Criteria) this;
  288. }
  289. public Criteria andCreaterLike(String value) {
  290. addCriterion("creater like", value, "creater");
  291. return (Criteria) this;
  292. }
  293. public Criteria andCreaterNotLike(String value) {
  294. addCriterion("creater not like", value, "creater");
  295. return (Criteria) this;
  296. }
  297. public Criteria andCreaterIn(List<String> values) {
  298. addCriterion("creater in", values, "creater");
  299. return (Criteria) this;
  300. }
  301. public Criteria andCreaterNotIn(List<String> values) {
  302. addCriterion("creater not in", values, "creater");
  303. return (Criteria) this;
  304. }
  305. public Criteria andCreaterBetween(String value1, String value2) {
  306. addCriterion("creater between", value1, value2, "creater");
  307. return (Criteria) this;
  308. }
  309. public Criteria andCreaterNotBetween(String value1, String value2) {
  310. addCriterion("creater not between", value1, value2, "creater");
  311. return (Criteria) this;
  312. }
  313. public Criteria andCreateTimeIsNull() {
  314. addCriterion("create_time is null");
  315. return (Criteria) this;
  316. }
  317. public Criteria andCreateTimeIsNotNull() {
  318. addCriterion("create_time is not null");
  319. return (Criteria) this;
  320. }
  321. public Criteria andCreateTimeEqualTo(Date value) {
  322. addCriterion("create_time =", value, "createTime");
  323. return (Criteria) this;
  324. }
  325. public Criteria andCreateTimeNotEqualTo(Date value) {
  326. addCriterion("create_time <>", value, "createTime");
  327. return (Criteria) this;
  328. }
  329. public Criteria andCreateTimeGreaterThan(Date value) {
  330. addCriterion("create_time >", value, "createTime");
  331. return (Criteria) this;
  332. }
  333. public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
  334. addCriterion("create_time >=", value, "createTime");
  335. return (Criteria) this;
  336. }
  337. public Criteria andCreateTimeLessThan(Date value) {
  338. addCriterion("create_time <", value, "createTime");
  339. return (Criteria) this;
  340. }
  341. public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
  342. addCriterion("create_time <=", value, "createTime");
  343. return (Criteria) this;
  344. }
  345. public Criteria andCreateTimeIn(List<Date> values) {
  346. addCriterion("create_time in", values, "createTime");
  347. return (Criteria) this;
  348. }
  349. public Criteria andCreateTimeNotIn(List<Date> values) {
  350. addCriterion("create_time not in", values, "createTime");
  351. return (Criteria) this;
  352. }
  353. public Criteria andCreateTimeBetween(Date value1, Date value2) {
  354. addCriterion("create_time between", value1, value2, "createTime");
  355. return (Criteria) this;
  356. }
  357. public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
  358. addCriterion("create_time not between", value1, value2, "createTime");
  359. return (Criteria) this;
  360. }
  361. public Criteria andUpdateTimeIsNull() {
  362. addCriterion("update_time is null");
  363. return (Criteria) this;
  364. }
  365. public Criteria andUpdateTimeIsNotNull() {
  366. addCriterion("update_time is not null");
  367. return (Criteria) this;
  368. }
  369. public Criteria andUpdateTimeEqualTo(Date value) {
  370. addCriterion("update_time =", value, "updateTime");
  371. return (Criteria) this;
  372. }
  373. public Criteria andUpdateTimeNotEqualTo(Date value) {
  374. addCriterion("update_time <>", value, "updateTime");
  375. return (Criteria) this;
  376. }
  377. public Criteria andUpdateTimeGreaterThan(Date value) {
  378. addCriterion("update_time >", value, "updateTime");
  379. return (Criteria) this;
  380. }
  381. public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
  382. addCriterion("update_time >=", value, "updateTime");
  383. return (Criteria) this;
  384. }
  385. public Criteria andUpdateTimeLessThan(Date value) {
  386. addCriterion("update_time <", value, "updateTime");
  387. return (Criteria) this;
  388. }
  389. public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
  390. addCriterion("update_time <=", value, "updateTime");
  391. return (Criteria) this;
  392. }
  393. public Criteria andUpdateTimeIn(List<Date> values) {
  394. addCriterion("update_time in", values, "updateTime");
  395. return (Criteria) this;
  396. }
  397. public Criteria andUpdateTimeNotIn(List<Date> values) {
  398. addCriterion("update_time not in", values, "updateTime");
  399. return (Criteria) this;
  400. }
  401. public Criteria andUpdateTimeBetween(Date value1, Date value2) {
  402. addCriterion("update_time between", value1, value2, "updateTime");
  403. return (Criteria) this;
  404. }
  405. public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
  406. addCriterion("update_time not between", value1, value2, "updateTime");
  407. return (Criteria) this;
  408. }
  409. public Criteria andPayeeIdIsNull() {
  410. addCriterion("payee_id is null");
  411. return (Criteria) this;
  412. }
  413. public Criteria andPayeeIdIsNotNull() {
  414. addCriterion("payee_id is not null");
  415. return (Criteria) this;
  416. }
  417. public Criteria andPayeeIdEqualTo(String value) {
  418. addCriterion("payee_id =", value, "payeeId");
  419. return (Criteria) this;
  420. }
  421. public Criteria andPayeeIdNotEqualTo(String value) {
  422. addCriterion("payee_id <>", value, "payeeId");
  423. return (Criteria) this;
  424. }
  425. public Criteria andPayeeIdGreaterThan(String value) {
  426. addCriterion("payee_id >", value, "payeeId");
  427. return (Criteria) this;
  428. }
  429. public Criteria andPayeeIdGreaterThanOrEqualTo(String value) {
  430. addCriterion("payee_id >=", value, "payeeId");
  431. return (Criteria) this;
  432. }
  433. public Criteria andPayeeIdLessThan(String value) {
  434. addCriterion("payee_id <", value, "payeeId");
  435. return (Criteria) this;
  436. }
  437. public Criteria andPayeeIdLessThanOrEqualTo(String value) {
  438. addCriterion("payee_id <=", value, "payeeId");
  439. return (Criteria) this;
  440. }
  441. public Criteria andPayeeIdLike(String value) {
  442. addCriterion("payee_id like", value, "payeeId");
  443. return (Criteria) this;
  444. }
  445. public Criteria andPayeeIdNotLike(String value) {
  446. addCriterion("payee_id not like", value, "payeeId");
  447. return (Criteria) this;
  448. }
  449. public Criteria andPayeeIdIn(List<String> values) {
  450. addCriterion("payee_id in", values, "payeeId");
  451. return (Criteria) this;
  452. }
  453. public Criteria andPayeeIdNotIn(List<String> values) {
  454. addCriterion("payee_id not in", values, "payeeId");
  455. return (Criteria) this;
  456. }
  457. public Criteria andPayeeIdBetween(String value1, String value2) {
  458. addCriterion("payee_id between", value1, value2, "payeeId");
  459. return (Criteria) this;
  460. }
  461. public Criteria andPayeeIdNotBetween(String value1, String value2) {
  462. addCriterion("payee_id not between", value1, value2, "payeeId");
  463. return (Criteria) this;
  464. }
  465. public Criteria andPayerIdIsNull() {
  466. addCriterion("payer_id is null");
  467. return (Criteria) this;
  468. }
  469. public Criteria andPayerIdIsNotNull() {
  470. addCriterion("payer_id is not null");
  471. return (Criteria) this;
  472. }
  473. public Criteria andPayerIdEqualTo(String value) {
  474. addCriterion("payer_id =", value, "payerId");
  475. return (Criteria) this;
  476. }
  477. public Criteria andPayerIdNotEqualTo(String value) {
  478. addCriterion("payer_id <>", value, "payerId");
  479. return (Criteria) this;
  480. }
  481. public Criteria andPayerIdGreaterThan(String value) {
  482. addCriterion("payer_id >", value, "payerId");
  483. return (Criteria) this;
  484. }
  485. public Criteria andPayerIdGreaterThanOrEqualTo(String value) {
  486. addCriterion("payer_id >=", value, "payerId");
  487. return (Criteria) this;
  488. }
  489. public Criteria andPayerIdLessThan(String value) {
  490. addCriterion("payer_id <", value, "payerId");
  491. return (Criteria) this;
  492. }
  493. public Criteria andPayerIdLessThanOrEqualTo(String value) {
  494. addCriterion("payer_id <=", value, "payerId");
  495. return (Criteria) this;
  496. }
  497. public Criteria andPayerIdLike(String value) {
  498. addCriterion("payer_id like", value, "payerId");
  499. return (Criteria) this;
  500. }
  501. public Criteria andPayerIdNotLike(String value) {
  502. addCriterion("payer_id not like", value, "payerId");
  503. return (Criteria) this;
  504. }
  505. public Criteria andPayerIdIn(List<String> values) {
  506. addCriterion("payer_id in", values, "payerId");
  507. return (Criteria) this;
  508. }
  509. public Criteria andPayerIdNotIn(List<String> values) {
  510. addCriterion("payer_id not in", values, "payerId");
  511. return (Criteria) this;
  512. }
  513. public Criteria andPayerIdBetween(String value1, String value2) {
  514. addCriterion("payer_id between", value1, value2, "payerId");
  515. return (Criteria) this;
  516. }
  517. public Criteria andPayerIdNotBetween(String value1, String value2) {
  518. addCriterion("payer_id not between", value1, value2, "payerId");
  519. return (Criteria) this;
  520. }
  521. public Criteria andTransactionAmountIsNull() {
  522. addCriterion("transaction_amount is null");
  523. return (Criteria) this;
  524. }
  525. public Criteria andTransactionAmountIsNotNull() {
  526. addCriterion("transaction_amount is not null");
  527. return (Criteria) this;
  528. }
  529. public Criteria andTransactionAmountEqualTo(BigDecimal value) {
  530. addCriterion("transaction_amount =", value, "transactionAmount");
  531. return (Criteria) this;
  532. }
  533. public Criteria andTransactionAmountNotEqualTo(BigDecimal value) {
  534. addCriterion("transaction_amount <>", value, "transactionAmount");
  535. return (Criteria) this;
  536. }
  537. public Criteria andTransactionAmountGreaterThan(BigDecimal value) {
  538. addCriterion("transaction_amount >", value, "transactionAmount");
  539. return (Criteria) this;
  540. }
  541. public Criteria andTransactionAmountGreaterThanOrEqualTo(BigDecimal value) {
  542. addCriterion("transaction_amount >=", value, "transactionAmount");
  543. return (Criteria) this;
  544. }
  545. public Criteria andTransactionAmountLessThan(BigDecimal value) {
  546. addCriterion("transaction_amount <", value, "transactionAmount");
  547. return (Criteria) this;
  548. }
  549. public Criteria andTransactionAmountLessThanOrEqualTo(BigDecimal value) {
  550. addCriterion("transaction_amount <=", value, "transactionAmount");
  551. return (Criteria) this;
  552. }
  553. public Criteria andTransactionAmountIn(List<BigDecimal> values) {
  554. addCriterion("transaction_amount in", values, "transactionAmount");
  555. return (Criteria) this;
  556. }
  557. public Criteria andTransactionAmountNotIn(List<BigDecimal> values) {
  558. addCriterion("transaction_amount not in", values, "transactionAmount");
  559. return (Criteria) this;
  560. }
  561. public Criteria andTransactionAmountBetween(BigDecimal value1, BigDecimal value2) {
  562. addCriterion("transaction_amount between", value1, value2, "transactionAmount");
  563. return (Criteria) this;
  564. }
  565. public Criteria andTransactionAmountNotBetween(BigDecimal value1, BigDecimal value2) {
  566. addCriterion("transaction_amount not between", value1, value2, "transactionAmount");
  567. return (Criteria) this;
  568. }
  569. public Criteria andTransactionSubjectIsNull() {
  570. addCriterion("transaction_subject is null");
  571. return (Criteria) this;
  572. }
  573. public Criteria andTransactionSubjectIsNotNull() {
  574. addCriterion("transaction_subject is not null");
  575. return (Criteria) this;
  576. }
  577. public Criteria andTransactionSubjectEqualTo(Integer value) {
  578. addCriterion("transaction_subject =", value, "transactionSubject");
  579. return (Criteria) this;
  580. }
  581. public Criteria andTransactionSubjectNotEqualTo(Integer value) {
  582. addCriterion("transaction_subject <>", value, "transactionSubject");
  583. return (Criteria) this;
  584. }
  585. public Criteria andTransactionSubjectGreaterThan(Integer value) {
  586. addCriterion("transaction_subject >", value, "transactionSubject");
  587. return (Criteria) this;
  588. }
  589. public Criteria andTransactionSubjectGreaterThanOrEqualTo(Integer value) {
  590. addCriterion("transaction_subject >=", value, "transactionSubject");
  591. return (Criteria) this;
  592. }
  593. public Criteria andTransactionSubjectLessThan(Integer value) {
  594. addCriterion("transaction_subject <", value, "transactionSubject");
  595. return (Criteria) this;
  596. }
  597. public Criteria andTransactionSubjectLessThanOrEqualTo(Integer value) {
  598. addCriterion("transaction_subject <=", value, "transactionSubject");
  599. return (Criteria) this;
  600. }
  601. public Criteria andTransactionSubjectIn(List<Integer> values) {
  602. addCriterion("transaction_subject in", values, "transactionSubject");
  603. return (Criteria) this;
  604. }
  605. public Criteria andTransactionSubjectNotIn(List<Integer> values) {
  606. addCriterion("transaction_subject not in", values, "transactionSubject");
  607. return (Criteria) this;
  608. }
  609. public Criteria andTransactionSubjectBetween(Integer value1, Integer value2) {
  610. addCriterion("transaction_subject between", value1, value2, "transactionSubject");
  611. return (Criteria) this;
  612. }
  613. public Criteria andTransactionSubjectNotBetween(Integer value1, Integer value2) {
  614. addCriterion("transaction_subject not between", value1, value2, "transactionSubject");
  615. return (Criteria) this;
  616. }
  617. public Criteria andTransactionChannelIsNull() {
  618. addCriterion("transaction_channel is null");
  619. return (Criteria) this;
  620. }
  621. public Criteria andTransactionChannelIsNotNull() {
  622. addCriterion("transaction_channel is not null");
  623. return (Criteria) this;
  624. }
  625. public Criteria andTransactionChannelEqualTo(Integer value) {
  626. addCriterion("transaction_channel =", value, "transactionChannel");
  627. return (Criteria) this;
  628. }
  629. public Criteria andTransactionChannelNotEqualTo(Integer value) {
  630. addCriterion("transaction_channel <>", value, "transactionChannel");
  631. return (Criteria) this;
  632. }
  633. public Criteria andTransactionChannelGreaterThan(Integer value) {
  634. addCriterion("transaction_channel >", value, "transactionChannel");
  635. return (Criteria) this;
  636. }
  637. public Criteria andTransactionChannelGreaterThanOrEqualTo(Integer value) {
  638. addCriterion("transaction_channel >=", value, "transactionChannel");
  639. return (Criteria) this;
  640. }
  641. public Criteria andTransactionChannelLessThan(Integer value) {
  642. addCriterion("transaction_channel <", value, "transactionChannel");
  643. return (Criteria) this;
  644. }
  645. public Criteria andTransactionChannelLessThanOrEqualTo(Integer value) {
  646. addCriterion("transaction_channel <=", value, "transactionChannel");
  647. return (Criteria) this;
  648. }
  649. public Criteria andTransactionChannelIn(List<Integer> values) {
  650. addCriterion("transaction_channel in", values, "transactionChannel");
  651. return (Criteria) this;
  652. }
  653. public Criteria andTransactionChannelNotIn(List<Integer> values) {
  654. addCriterion("transaction_channel not in", values, "transactionChannel");
  655. return (Criteria) this;
  656. }
  657. public Criteria andTransactionChannelBetween(Integer value1, Integer value2) {
  658. addCriterion("transaction_channel between", value1, value2, "transactionChannel");
  659. return (Criteria) this;
  660. }
  661. public Criteria andTransactionChannelNotBetween(Integer value1, Integer value2) {
  662. addCriterion("transaction_channel not between", value1, value2, "transactionChannel");
  663. return (Criteria) this;
  664. }
  665. public Criteria andRemarksIsNull() {
  666. addCriterion("remarks is null");
  667. return (Criteria) this;
  668. }
  669. public Criteria andRemarksIsNotNull() {
  670. addCriterion("remarks is not null");
  671. return (Criteria) this;
  672. }
  673. public Criteria andRemarksEqualTo(String value) {
  674. addCriterion("remarks =", value, "remarks");
  675. return (Criteria) this;
  676. }
  677. public Criteria andRemarksNotEqualTo(String value) {
  678. addCriterion("remarks <>", value, "remarks");
  679. return (Criteria) this;
  680. }
  681. public Criteria andRemarksGreaterThan(String value) {
  682. addCriterion("remarks >", value, "remarks");
  683. return (Criteria) this;
  684. }
  685. public Criteria andRemarksGreaterThanOrEqualTo(String value) {
  686. addCriterion("remarks >=", value, "remarks");
  687. return (Criteria) this;
  688. }
  689. public Criteria andRemarksLessThan(String value) {
  690. addCriterion("remarks <", value, "remarks");
  691. return (Criteria) this;
  692. }
  693. public Criteria andRemarksLessThanOrEqualTo(String value) {
  694. addCriterion("remarks <=", value, "remarks");
  695. return (Criteria) this;
  696. }
  697. public Criteria andRemarksLike(String value) {
  698. addCriterion("remarks like", value, "remarks");
  699. return (Criteria) this;
  700. }
  701. public Criteria andRemarksNotLike(String value) {
  702. addCriterion("remarks not like", value, "remarks");
  703. return (Criteria) this;
  704. }
  705. public Criteria andRemarksIn(List<String> values) {
  706. addCriterion("remarks in", values, "remarks");
  707. return (Criteria) this;
  708. }
  709. public Criteria andRemarksNotIn(List<String> values) {
  710. addCriterion("remarks not in", values, "remarks");
  711. return (Criteria) this;
  712. }
  713. public Criteria andRemarksBetween(String value1, String value2) {
  714. addCriterion("remarks between", value1, value2, "remarks");
  715. return (Criteria) this;
  716. }
  717. public Criteria andRemarksNotBetween(String value1, String value2) {
  718. addCriterion("remarks not between", value1, value2, "remarks");
  719. return (Criteria) this;
  720. }
  721. public Criteria andConfirmSignIsNull() {
  722. addCriterion("confirm_sign is null");
  723. return (Criteria) this;
  724. }
  725. public Criteria andConfirmSignIsNotNull() {
  726. addCriterion("confirm_sign is not null");
  727. return (Criteria) this;
  728. }
  729. public Criteria andConfirmSignEqualTo(Integer value) {
  730. addCriterion("confirm_sign =", value, "confirmSign");
  731. return (Criteria) this;
  732. }
  733. public Criteria andConfirmSignNotEqualTo(Integer value) {
  734. addCriterion("confirm_sign <>", value, "confirmSign");
  735. return (Criteria) this;
  736. }
  737. public Criteria andConfirmSignGreaterThan(Integer value) {
  738. addCriterion("confirm_sign >", value, "confirmSign");
  739. return (Criteria) this;
  740. }
  741. public Criteria andConfirmSignGreaterThanOrEqualTo(Integer value) {
  742. addCriterion("confirm_sign >=", value, "confirmSign");
  743. return (Criteria) this;
  744. }
  745. public Criteria andConfirmSignLessThan(Integer value) {
  746. addCriterion("confirm_sign <", value, "confirmSign");
  747. return (Criteria) this;
  748. }
  749. public Criteria andConfirmSignLessThanOrEqualTo(Integer value) {
  750. addCriterion("confirm_sign <=", value, "confirmSign");
  751. return (Criteria) this;
  752. }
  753. public Criteria andConfirmSignIn(List<Integer> values) {
  754. addCriterion("confirm_sign in", values, "confirmSign");
  755. return (Criteria) this;
  756. }
  757. public Criteria andConfirmSignNotIn(List<Integer> values) {
  758. addCriterion("confirm_sign not in", values, "confirmSign");
  759. return (Criteria) this;
  760. }
  761. public Criteria andConfirmSignBetween(Integer value1, Integer value2) {
  762. addCriterion("confirm_sign between", value1, value2, "confirmSign");
  763. return (Criteria) this;
  764. }
  765. public Criteria andConfirmSignNotBetween(Integer value1, Integer value2) {
  766. addCriterion("confirm_sign not between", value1, value2, "confirmSign");
  767. return (Criteria) this;
  768. }
  769. public Criteria andDeleteSignIsNull() {
  770. addCriterion("delete_sign is null");
  771. return (Criteria) this;
  772. }
  773. public Criteria andDeleteSignIsNotNull() {
  774. addCriterion("delete_sign is not null");
  775. return (Criteria) this;
  776. }
  777. public Criteria andDeleteSignEqualTo(Byte value) {
  778. addCriterion("delete_sign =", value, "deleteSign");
  779. return (Criteria) this;
  780. }
  781. public Criteria andDeleteSignNotEqualTo(Byte value) {
  782. addCriterion("delete_sign <>", value, "deleteSign");
  783. return (Criteria) this;
  784. }
  785. public Criteria andDeleteSignGreaterThan(Byte value) {
  786. addCriterion("delete_sign >", value, "deleteSign");
  787. return (Criteria) this;
  788. }
  789. public Criteria andDeleteSignGreaterThanOrEqualTo(Byte value) {
  790. addCriterion("delete_sign >=", value, "deleteSign");
  791. return (Criteria) this;
  792. }
  793. public Criteria andDeleteSignLessThan(Byte value) {
  794. addCriterion("delete_sign <", value, "deleteSign");
  795. return (Criteria) this;
  796. }
  797. public Criteria andDeleteSignLessThanOrEqualTo(Byte value) {
  798. addCriterion("delete_sign <=", value, "deleteSign");
  799. return (Criteria) this;
  800. }
  801. public Criteria andDeleteSignIn(List<Byte> values) {
  802. addCriterion("delete_sign in", values, "deleteSign");
  803. return (Criteria) this;
  804. }
  805. public Criteria andDeleteSignNotIn(List<Byte> values) {
  806. addCriterion("delete_sign not in", values, "deleteSign");
  807. return (Criteria) this;
  808. }
  809. public Criteria andDeleteSignBetween(Byte value1, Byte value2) {
  810. addCriterion("delete_sign between", value1, value2, "deleteSign");
  811. return (Criteria) this;
  812. }
  813. public Criteria andDeleteSignNotBetween(Byte value1, Byte value2) {
  814. addCriterion("delete_sign not between", value1, value2, "deleteSign");
  815. return (Criteria) this;
  816. }
  817. public Criteria andFinancialPayNoIsNull() {
  818. addCriterion("financial_pay_no is null");
  819. return (Criteria) this;
  820. }
  821. public Criteria andFinancialPayNoIsNotNull() {
  822. addCriterion("financial_pay_no is not null");
  823. return (Criteria) this;
  824. }
  825. public Criteria andFinancialPayNoEqualTo(String value) {
  826. addCriterion("financial_pay_no =", value, "financialPayNo");
  827. return (Criteria) this;
  828. }
  829. public Criteria andFinancialPayNoNotEqualTo(String value) {
  830. addCriterion("financial_pay_no <>", value, "financialPayNo");
  831. return (Criteria) this;
  832. }
  833. public Criteria andFinancialPayNoGreaterThan(String value) {
  834. addCriterion("financial_pay_no >", value, "financialPayNo");
  835. return (Criteria) this;
  836. }
  837. public Criteria andFinancialPayNoGreaterThanOrEqualTo(String value) {
  838. addCriterion("financial_pay_no >=", value, "financialPayNo");
  839. return (Criteria) this;
  840. }
  841. public Criteria andFinancialPayNoLessThan(String value) {
  842. addCriterion("financial_pay_no <", value, "financialPayNo");
  843. return (Criteria) this;
  844. }
  845. public Criteria andFinancialPayNoLessThanOrEqualTo(String value) {
  846. addCriterion("financial_pay_no <=", value, "financialPayNo");
  847. return (Criteria) this;
  848. }
  849. public Criteria andFinancialPayNoLike(String value) {
  850. addCriterion("financial_pay_no like", value, "financialPayNo");
  851. return (Criteria) this;
  852. }
  853. public Criteria andFinancialPayNoNotLike(String value) {
  854. addCriterion("financial_pay_no not like", value, "financialPayNo");
  855. return (Criteria) this;
  856. }
  857. public Criteria andFinancialPayNoIn(List<String> values) {
  858. addCriterion("financial_pay_no in", values, "financialPayNo");
  859. return (Criteria) this;
  860. }
  861. public Criteria andFinancialPayNoNotIn(List<String> values) {
  862. addCriterion("financial_pay_no not in", values, "financialPayNo");
  863. return (Criteria) this;
  864. }
  865. public Criteria andFinancialPayNoBetween(String value1, String value2) {
  866. addCriterion("financial_pay_no between", value1, value2, "financialPayNo");
  867. return (Criteria) this;
  868. }
  869. public Criteria andFinancialPayNoNotBetween(String value1, String value2) {
  870. addCriterion("financial_pay_no not between", value1, value2, "financialPayNo");
  871. return (Criteria) this;
  872. }
  873. public Criteria andFinancialPayTimeIsNull() {
  874. addCriterion("financial_pay_time is null");
  875. return (Criteria) this;
  876. }
  877. public Criteria andFinancialPayTimeIsNotNull() {
  878. addCriterion("financial_pay_time is not null");
  879. return (Criteria) this;
  880. }
  881. public Criteria andFinancialPayTimeEqualTo(Date value) {
  882. addCriterion("financial_pay_time =", value, "financialPayTime");
  883. return (Criteria) this;
  884. }
  885. public Criteria andFinancialPayTimeNotEqualTo(Date value) {
  886. addCriterion("financial_pay_time <>", value, "financialPayTime");
  887. return (Criteria) this;
  888. }
  889. public Criteria andFinancialPayTimeGreaterThan(Date value) {
  890. addCriterion("financial_pay_time >", value, "financialPayTime");
  891. return (Criteria) this;
  892. }
  893. public Criteria andFinancialPayTimeGreaterThanOrEqualTo(Date value) {
  894. addCriterion("financial_pay_time >=", value, "financialPayTime");
  895. return (Criteria) this;
  896. }
  897. public Criteria andFinancialPayTimeLessThan(Date value) {
  898. addCriterion("financial_pay_time <", value, "financialPayTime");
  899. return (Criteria) this;
  900. }
  901. public Criteria andFinancialPayTimeLessThanOrEqualTo(Date value) {
  902. addCriterion("financial_pay_time <=", value, "financialPayTime");
  903. return (Criteria) this;
  904. }
  905. public Criteria andFinancialPayTimeIn(List<Date> values) {
  906. addCriterion("financial_pay_time in", values, "financialPayTime");
  907. return (Criteria) this;
  908. }
  909. public Criteria andFinancialPayTimeNotIn(List<Date> values) {
  910. addCriterion("financial_pay_time not in", values, "financialPayTime");
  911. return (Criteria) this;
  912. }
  913. public Criteria andFinancialPayTimeBetween(Date value1, Date value2) {
  914. addCriterion("financial_pay_time between", value1, value2, "financialPayTime");
  915. return (Criteria) this;
  916. }
  917. public Criteria andFinancialPayTimeNotBetween(Date value1, Date value2) {
  918. addCriterion("financial_pay_time not between", value1, value2, "financialPayTime");
  919. return (Criteria) this;
  920. }
  921. public Criteria andTypeIsNull() {
  922. addCriterion("type is null");
  923. return (Criteria) this;
  924. }
  925. public Criteria andTypeIsNotNull() {
  926. addCriterion("type is not null");
  927. return (Criteria) this;
  928. }
  929. public Criteria andTypeEqualTo(Integer value) {
  930. addCriterion("type =", value, "type");
  931. return (Criteria) this;
  932. }
  933. public Criteria andTypeNotEqualTo(Integer value) {
  934. addCriterion("type <>", value, "type");
  935. return (Criteria) this;
  936. }
  937. public Criteria andTypeGreaterThan(Integer value) {
  938. addCriterion("type >", value, "type");
  939. return (Criteria) this;
  940. }
  941. public Criteria andTypeGreaterThanOrEqualTo(Integer value) {
  942. addCriterion("type >=", value, "type");
  943. return (Criteria) this;
  944. }
  945. public Criteria andTypeLessThan(Integer value) {
  946. addCriterion("type <", value, "type");
  947. return (Criteria) this;
  948. }
  949. public Criteria andTypeLessThanOrEqualTo(Integer value) {
  950. addCriterion("type <=", value, "type");
  951. return (Criteria) this;
  952. }
  953. public Criteria andTypeIn(List<Integer> values) {
  954. addCriterion("type in", values, "type");
  955. return (Criteria) this;
  956. }
  957. public Criteria andTypeNotIn(List<Integer> values) {
  958. addCriterion("type not in", values, "type");
  959. return (Criteria) this;
  960. }
  961. public Criteria andTypeBetween(Integer value1, Integer value2) {
  962. addCriterion("type between", value1, value2, "type");
  963. return (Criteria) this;
  964. }
  965. public Criteria andTypeNotBetween(Integer value1, Integer value2) {
  966. addCriterion("type not between", value1, value2, "type");
  967. return (Criteria) this;
  968. }
  969. public Criteria andDeleteTimeIsNull() {
  970. addCriterion("delete_time is null");
  971. return (Criteria) this;
  972. }
  973. public Criteria andDeleteTimeIsNotNull() {
  974. addCriterion("delete_time is not null");
  975. return (Criteria) this;
  976. }
  977. public Criteria andDeleteTimeEqualTo(Date value) {
  978. addCriterion("delete_time =", value, "deleteTime");
  979. return (Criteria) this;
  980. }
  981. public Criteria andDeleteTimeNotEqualTo(Date value) {
  982. addCriterion("delete_time <>", value, "deleteTime");
  983. return (Criteria) this;
  984. }
  985. public Criteria andDeleteTimeGreaterThan(Date value) {
  986. addCriterion("delete_time >", value, "deleteTime");
  987. return (Criteria) this;
  988. }
  989. public Criteria andDeleteTimeGreaterThanOrEqualTo(Date value) {
  990. addCriterion("delete_time >=", value, "deleteTime");
  991. return (Criteria) this;
  992. }
  993. public Criteria andDeleteTimeLessThan(Date value) {
  994. addCriterion("delete_time <", value, "deleteTime");
  995. return (Criteria) this;
  996. }
  997. public Criteria andDeleteTimeLessThanOrEqualTo(Date value) {
  998. addCriterion("delete_time <=", value, "deleteTime");
  999. return (Criteria) this;
  1000. }
  1001. public Criteria andDeleteTimeIn(List<Date> values) {
  1002. addCriterion("delete_time in", values, "deleteTime");
  1003. return (Criteria) this;
  1004. }
  1005. public Criteria andDeleteTimeNotIn(List<Date> values) {
  1006. addCriterion("delete_time not in", values, "deleteTime");
  1007. return (Criteria) this;
  1008. }
  1009. public Criteria andDeleteTimeBetween(Date value1, Date value2) {
  1010. addCriterion("delete_time between", value1, value2, "deleteTime");
  1011. return (Criteria) this;
  1012. }
  1013. public Criteria andDeleteTimeNotBetween(Date value1, Date value2) {
  1014. addCriterion("delete_time not between", value1, value2, "deleteTime");
  1015. return (Criteria) this;
  1016. }
  1017. }
  1018. /**
  1019. * This class was generated by MyBatis Generator. This class corresponds to the database table t_order_bill_new
  1020. * @mbg.generated Mon Feb 17 11:41:23 CST 2020
  1021. */
  1022. public static class Criterion {
  1023. private String condition;
  1024. private Object value;
  1025. private Object secondValue;
  1026. private boolean noValue;
  1027. private boolean singleValue;
  1028. private boolean betweenValue;
  1029. private boolean listValue;
  1030. private String typeHandler;
  1031. public String getCondition() {
  1032. return condition;
  1033. }
  1034. public Object getValue() {
  1035. return value;
  1036. }
  1037. public Object getSecondValue() {
  1038. return secondValue;
  1039. }
  1040. public boolean isNoValue() {
  1041. return noValue;
  1042. }
  1043. public boolean isSingleValue() {
  1044. return singleValue;
  1045. }
  1046. public boolean isBetweenValue() {
  1047. return betweenValue;
  1048. }
  1049. public boolean isListValue() {
  1050. return listValue;
  1051. }
  1052. public String getTypeHandler() {
  1053. return typeHandler;
  1054. }
  1055. protected Criterion(String condition) {
  1056. super();
  1057. this.condition = condition;
  1058. this.typeHandler = null;
  1059. this.noValue = true;
  1060. }
  1061. protected Criterion(String condition, Object value, String typeHandler) {
  1062. super();
  1063. this.condition = condition;
  1064. this.value = value;
  1065. this.typeHandler = typeHandler;
  1066. if (value instanceof List<?>) {
  1067. this.listValue = true;
  1068. } else {
  1069. this.singleValue = true;
  1070. }
  1071. }
  1072. protected Criterion(String condition, Object value) {
  1073. this(condition, value, null);
  1074. }
  1075. protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
  1076. super();
  1077. this.condition = condition;
  1078. this.value = value;
  1079. this.secondValue = secondValue;
  1080. this.typeHandler = typeHandler;
  1081. this.betweenValue = true;
  1082. }
  1083. protected Criterion(String condition, Object value, Object secondValue) {
  1084. this(condition, value, secondValue, null);
  1085. }
  1086. }
  1087. /**
  1088. * This class was generated by MyBatis Generator.
  1089. * This class corresponds to the database table t_order_bill_new
  1090. *
  1091. * @mbggenerated do_not_delete_during_merge Tue Nov 20 11:14:40 CST 2018
  1092. */
  1093. public static class Criteria extends GeneratedCriteria {
  1094. protected Criteria() {
  1095. super();
  1096. }
  1097. }
  1098. }