PointChangeSQLBuilder.java 39 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231
  1. package com.miniframe.model.system;
  2. import java.util.ArrayList;
  3. import java.util.Date;
  4. import java.util.List;
  5. public class PointChangeSQLBuilder {
  6. protected String orderByClause;
  7. protected boolean distinct;
  8. protected List<Criteria> oredCriteria;
  9. public PointChangeSQLBuilder() {
  10. oredCriteria = new ArrayList<Criteria>();
  11. }
  12. public void setOrderByClause(String orderByClause) {
  13. this.orderByClause = orderByClause;
  14. }
  15. public String getOrderByClause() {
  16. return orderByClause;
  17. }
  18. public void setDistinct(boolean distinct) {
  19. this.distinct = distinct;
  20. }
  21. public boolean isDistinct() {
  22. return distinct;
  23. }
  24. public List<Criteria> getOredCriteria() {
  25. return oredCriteria;
  26. }
  27. public void or(Criteria criteria) {
  28. oredCriteria.add(criteria);
  29. }
  30. public Criteria or() {
  31. Criteria criteria = createCriteriaInternal();
  32. oredCriteria.add(criteria);
  33. return criteria;
  34. }
  35. public Criteria createCriteria() {
  36. Criteria criteria = createCriteriaInternal();
  37. if (oredCriteria.size() == 0) {
  38. oredCriteria.add(criteria);
  39. }
  40. return criteria;
  41. }
  42. protected Criteria createCriteriaInternal() {
  43. Criteria criteria = new Criteria();
  44. return criteria;
  45. }
  46. public void clear() {
  47. oredCriteria.clear();
  48. orderByClause = null;
  49. distinct = false;
  50. }
  51. protected abstract static class GeneratedCriteria {
  52. protected List<Criterion> criteria;
  53. protected GeneratedCriteria() {
  54. super();
  55. criteria = new ArrayList<Criterion>();
  56. }
  57. public boolean isValid() {
  58. return criteria.size() > 0;
  59. }
  60. public List<Criterion> getAllCriteria() {
  61. return criteria;
  62. }
  63. public List<Criterion> getCriteria() {
  64. return criteria;
  65. }
  66. protected void addCriterion(String condition) {
  67. if (condition == null) {
  68. throw new RuntimeException("Value for condition cannot be null");
  69. }
  70. criteria.add(new Criterion(condition));
  71. }
  72. protected void addCriterion(String condition, Object value, String property) {
  73. if (value == null) {
  74. throw new RuntimeException("Value for " + property + " cannot be null");
  75. }
  76. criteria.add(new Criterion(condition, value));
  77. }
  78. protected void addCriterion(String condition, Object value1, Object value2, String property) {
  79. if (value1 == null || value2 == null) {
  80. throw new RuntimeException("Between values for " + property + " cannot be null");
  81. }
  82. criteria.add(new Criterion(condition, value1, value2));
  83. }
  84. public Criteria andIdIsNull() {
  85. addCriterion("id is null");
  86. return (Criteria) this;
  87. }
  88. public Criteria andIdIsNotNull() {
  89. addCriterion("id is not null");
  90. return (Criteria) this;
  91. }
  92. public Criteria andIdEqualTo(String value) {
  93. addCriterion("id =", value, "id");
  94. return (Criteria) this;
  95. }
  96. public Criteria andIdNotEqualTo(String value) {
  97. addCriterion("id <>", value, "id");
  98. return (Criteria) this;
  99. }
  100. public Criteria andIdGreaterThan(String value) {
  101. addCriterion("id >", value, "id");
  102. return (Criteria) this;
  103. }
  104. public Criteria andIdGreaterThanOrEqualTo(String value) {
  105. addCriterion("id >=", value, "id");
  106. return (Criteria) this;
  107. }
  108. public Criteria andIdLessThan(String value) {
  109. addCriterion("id <", value, "id");
  110. return (Criteria) this;
  111. }
  112. public Criteria andIdLessThanOrEqualTo(String value) {
  113. addCriterion("id <=", value, "id");
  114. return (Criteria) this;
  115. }
  116. public Criteria andIdLike(String value) {
  117. addCriterion("id like", value, "id");
  118. return (Criteria) this;
  119. }
  120. public Criteria andIdNotLike(String value) {
  121. addCriterion("id not like", value, "id");
  122. return (Criteria) this;
  123. }
  124. public Criteria andIdIn(List<String> values) {
  125. addCriterion("id in", values, "id");
  126. return (Criteria) this;
  127. }
  128. public Criteria andIdNotIn(List<String> values) {
  129. addCriterion("id not in", values, "id");
  130. return (Criteria) this;
  131. }
  132. public Criteria andIdBetween(String value1, String value2) {
  133. addCriterion("id between", value1, value2, "id");
  134. return (Criteria) this;
  135. }
  136. public Criteria andIdNotBetween(String value1, String value2) {
  137. addCriterion("id not between", value1, value2, "id");
  138. return (Criteria) this;
  139. }
  140. public Criteria andCreateTimeIsNull() {
  141. addCriterion("create_time is null");
  142. return (Criteria) this;
  143. }
  144. public Criteria andCreateTimeIsNotNull() {
  145. addCriterion("create_time is not null");
  146. return (Criteria) this;
  147. }
  148. public Criteria andCreateTimeEqualTo(Date value) {
  149. addCriterion("create_time =", value, "createTime");
  150. return (Criteria) this;
  151. }
  152. public Criteria andCreateTimeNotEqualTo(Date value) {
  153. addCriterion("create_time <>", value, "createTime");
  154. return (Criteria) this;
  155. }
  156. public Criteria andCreateTimeGreaterThan(Date value) {
  157. addCriterion("create_time >", value, "createTime");
  158. return (Criteria) this;
  159. }
  160. public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
  161. addCriterion("create_time >=", value, "createTime");
  162. return (Criteria) this;
  163. }
  164. public Criteria andCreateTimeLessThan(Date value) {
  165. addCriterion("create_time <", value, "createTime");
  166. return (Criteria) this;
  167. }
  168. public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
  169. addCriterion("create_time <=", value, "createTime");
  170. return (Criteria) this;
  171. }
  172. public Criteria andCreateTimeIn(List<Date> values) {
  173. addCriterion("create_time in", values, "createTime");
  174. return (Criteria) this;
  175. }
  176. public Criteria andCreateTimeNotIn(List<Date> values) {
  177. addCriterion("create_time not in", values, "createTime");
  178. return (Criteria) this;
  179. }
  180. public Criteria andCreateTimeBetween(Date value1, Date value2) {
  181. addCriterion("create_time between", value1, value2, "createTime");
  182. return (Criteria) this;
  183. }
  184. public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
  185. addCriterion("create_time not between", value1, value2, "createTime");
  186. return (Criteria) this;
  187. }
  188. public Criteria andUpdateTimeIsNull() {
  189. addCriterion("update_time is null");
  190. return (Criteria) this;
  191. }
  192. public Criteria andUpdateTimeIsNotNull() {
  193. addCriterion("update_time is not null");
  194. return (Criteria) this;
  195. }
  196. public Criteria andUpdateTimeEqualTo(Date value) {
  197. addCriterion("update_time =", value, "updateTime");
  198. return (Criteria) this;
  199. }
  200. public Criteria andUpdateTimeNotEqualTo(Date value) {
  201. addCriterion("update_time <>", value, "updateTime");
  202. return (Criteria) this;
  203. }
  204. public Criteria andUpdateTimeGreaterThan(Date value) {
  205. addCriterion("update_time >", value, "updateTime");
  206. return (Criteria) this;
  207. }
  208. public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
  209. addCriterion("update_time >=", value, "updateTime");
  210. return (Criteria) this;
  211. }
  212. public Criteria andUpdateTimeLessThan(Date value) {
  213. addCriterion("update_time <", value, "updateTime");
  214. return (Criteria) this;
  215. }
  216. public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
  217. addCriterion("update_time <=", value, "updateTime");
  218. return (Criteria) this;
  219. }
  220. public Criteria andUpdateTimeIn(List<Date> values) {
  221. addCriterion("update_time in", values, "updateTime");
  222. return (Criteria) this;
  223. }
  224. public Criteria andUpdateTimeNotIn(List<Date> values) {
  225. addCriterion("update_time not in", values, "updateTime");
  226. return (Criteria) this;
  227. }
  228. public Criteria andUpdateTimeBetween(Date value1, Date value2) {
  229. addCriterion("update_time between", value1, value2, "updateTime");
  230. return (Criteria) this;
  231. }
  232. public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
  233. addCriterion("update_time not between", value1, value2, "updateTime");
  234. return (Criteria) this;
  235. }
  236. public Criteria andContentIsNull() {
  237. addCriterion("content is null");
  238. return (Criteria) this;
  239. }
  240. public Criteria andContentIsNotNull() {
  241. addCriterion("content is not null");
  242. return (Criteria) this;
  243. }
  244. public Criteria andContentEqualTo(String value) {
  245. addCriterion("content =", value, "content");
  246. return (Criteria) this;
  247. }
  248. public Criteria andContentNotEqualTo(String value) {
  249. addCriterion("content <>", value, "content");
  250. return (Criteria) this;
  251. }
  252. public Criteria andContentGreaterThan(String value) {
  253. addCriterion("content >", value, "content");
  254. return (Criteria) this;
  255. }
  256. public Criteria andContentGreaterThanOrEqualTo(String value) {
  257. addCriterion("content >=", value, "content");
  258. return (Criteria) this;
  259. }
  260. public Criteria andContentLessThan(String value) {
  261. addCriterion("content <", value, "content");
  262. return (Criteria) this;
  263. }
  264. public Criteria andContentLessThanOrEqualTo(String value) {
  265. addCriterion("content <=", value, "content");
  266. return (Criteria) this;
  267. }
  268. public Criteria andContentLike(String value) {
  269. addCriterion("content like", value, "content");
  270. return (Criteria) this;
  271. }
  272. public Criteria andContentNotLike(String value) {
  273. addCriterion("content not like", value, "content");
  274. return (Criteria) this;
  275. }
  276. public Criteria andContentIn(List<String> values) {
  277. addCriterion("content in", values, "content");
  278. return (Criteria) this;
  279. }
  280. public Criteria andContentNotIn(List<String> values) {
  281. addCriterion("content not in", values, "content");
  282. return (Criteria) this;
  283. }
  284. public Criteria andContentBetween(String value1, String value2) {
  285. addCriterion("content between", value1, value2, "content");
  286. return (Criteria) this;
  287. }
  288. public Criteria andContentNotBetween(String value1, String value2) {
  289. addCriterion("content not between", value1, value2, "content");
  290. return (Criteria) this;
  291. }
  292. public Criteria andMoneyIsNull() {
  293. addCriterion("money is null");
  294. return (Criteria) this;
  295. }
  296. public Criteria andMoneyIsNotNull() {
  297. addCriterion("money is not null");
  298. return (Criteria) this;
  299. }
  300. public Criteria andMoneyEqualTo(String value) {
  301. addCriterion("money =", value, "money");
  302. return (Criteria) this;
  303. }
  304. public Criteria andMoneyNotEqualTo(String value) {
  305. addCriterion("money <>", value, "money");
  306. return (Criteria) this;
  307. }
  308. public Criteria andMoneyGreaterThan(String value) {
  309. addCriterion("money >", value, "money");
  310. return (Criteria) this;
  311. }
  312. public Criteria andMoneyGreaterThanOrEqualTo(String value) {
  313. addCriterion("money >=", value, "money");
  314. return (Criteria) this;
  315. }
  316. public Criteria andMoneyLessThan(String value) {
  317. addCriterion("money <", value, "money");
  318. return (Criteria) this;
  319. }
  320. public Criteria andMoneyLessThanOrEqualTo(String value) {
  321. addCriterion("money <=", value, "money");
  322. return (Criteria) this;
  323. }
  324. public Criteria andMoneyLike(String value) {
  325. addCriterion("money like", value, "money");
  326. return (Criteria) this;
  327. }
  328. public Criteria andMoneyNotLike(String value) {
  329. addCriterion("money not like", value, "money");
  330. return (Criteria) this;
  331. }
  332. public Criteria andMoneyIn(List<String> values) {
  333. addCriterion("money in", values, "money");
  334. return (Criteria) this;
  335. }
  336. public Criteria andMoneyNotIn(List<String> values) {
  337. addCriterion("money not in", values, "money");
  338. return (Criteria) this;
  339. }
  340. public Criteria andMoneyBetween(String value1, String value2) {
  341. addCriterion("money between", value1, value2, "money");
  342. return (Criteria) this;
  343. }
  344. public Criteria andMoneyNotBetween(String value1, String value2) {
  345. addCriterion("money not between", value1, value2, "money");
  346. return (Criteria) this;
  347. }
  348. public Criteria andInvoiceStateIsNull() {
  349. addCriterion("invoice_state is null");
  350. return (Criteria) this;
  351. }
  352. public Criteria andInvoiceStateIsNotNull() {
  353. addCriterion("invoice_state is not null");
  354. return (Criteria) this;
  355. }
  356. public Criteria andInvoiceStateEqualTo(String value) {
  357. addCriterion("invoice_state =", value, "invoiceState");
  358. return (Criteria) this;
  359. }
  360. public Criteria andInvoiceStateNotEqualTo(String value) {
  361. addCriterion("invoice_state <>", value, "invoiceState");
  362. return (Criteria) this;
  363. }
  364. public Criteria andInvoiceStateGreaterThan(String value) {
  365. addCriterion("invoice_state >", value, "invoiceState");
  366. return (Criteria) this;
  367. }
  368. public Criteria andInvoiceStateGreaterThanOrEqualTo(String value) {
  369. addCriterion("invoice_state >=", value, "invoiceState");
  370. return (Criteria) this;
  371. }
  372. public Criteria andInvoiceStateLessThan(String value) {
  373. addCriterion("invoice_state <", value, "invoiceState");
  374. return (Criteria) this;
  375. }
  376. public Criteria andInvoiceStateLessThanOrEqualTo(String value) {
  377. addCriterion("invoice_state <=", value, "invoiceState");
  378. return (Criteria) this;
  379. }
  380. public Criteria andInvoiceStateLike(String value) {
  381. addCriterion("invoice_state like", value, "invoiceState");
  382. return (Criteria) this;
  383. }
  384. public Criteria andInvoiceStateNotLike(String value) {
  385. addCriterion("invoice_state not like", value, "invoiceState");
  386. return (Criteria) this;
  387. }
  388. public Criteria andInvoiceStateIn(List<String> values) {
  389. addCriterion("invoice_state in", values, "invoiceState");
  390. return (Criteria) this;
  391. }
  392. public Criteria andInvoiceStateNotIn(List<String> values) {
  393. addCriterion("invoice_state not in", values, "invoiceState");
  394. return (Criteria) this;
  395. }
  396. public Criteria andInvoiceStateBetween(String value1, String value2) {
  397. addCriterion("invoice_state between", value1, value2, "invoiceState");
  398. return (Criteria) this;
  399. }
  400. public Criteria andInvoiceStateNotBetween(String value1, String value2) {
  401. addCriterion("invoice_state not between", value1, value2, "invoiceState");
  402. return (Criteria) this;
  403. }
  404. public Criteria andUidIsNull() {
  405. addCriterion("uid is null");
  406. return (Criteria) this;
  407. }
  408. public Criteria andUidIsNotNull() {
  409. addCriterion("uid is not null");
  410. return (Criteria) this;
  411. }
  412. public Criteria andUidEqualTo(String value) {
  413. addCriterion("uid =", value, "uid");
  414. return (Criteria) this;
  415. }
  416. public Criteria andUidNotEqualTo(String value) {
  417. addCriterion("uid <>", value, "uid");
  418. return (Criteria) this;
  419. }
  420. public Criteria andUidGreaterThan(String value) {
  421. addCriterion("uid >", value, "uid");
  422. return (Criteria) this;
  423. }
  424. public Criteria andUidGreaterThanOrEqualTo(String value) {
  425. addCriterion("uid >=", value, "uid");
  426. return (Criteria) this;
  427. }
  428. public Criteria andUidLessThan(String value) {
  429. addCriterion("uid <", value, "uid");
  430. return (Criteria) this;
  431. }
  432. public Criteria andUidLessThanOrEqualTo(String value) {
  433. addCriterion("uid <=", value, "uid");
  434. return (Criteria) this;
  435. }
  436. public Criteria andUidLike(String value) {
  437. addCriterion("uid like", value, "uid");
  438. return (Criteria) this;
  439. }
  440. public Criteria andUidNotLike(String value) {
  441. addCriterion("uid not like", value, "uid");
  442. return (Criteria) this;
  443. }
  444. public Criteria andUidIn(List<String> values) {
  445. addCriterion("uid in", values, "uid");
  446. return (Criteria) this;
  447. }
  448. public Criteria andUidNotIn(List<String> values) {
  449. addCriterion("uid not in", values, "uid");
  450. return (Criteria) this;
  451. }
  452. public Criteria andUidBetween(String value1, String value2) {
  453. addCriterion("uid between", value1, value2, "uid");
  454. return (Criteria) this;
  455. }
  456. public Criteria andUidNotBetween(String value1, String value2) {
  457. addCriterion("uid not between", value1, value2, "uid");
  458. return (Criteria) this;
  459. }
  460. public Criteria andPointIsNull() {
  461. addCriterion("point is null");
  462. return (Criteria) this;
  463. }
  464. public Criteria andPointIsNotNull() {
  465. addCriterion("point is not null");
  466. return (Criteria) this;
  467. }
  468. public Criteria andPointEqualTo(String value) {
  469. addCriterion("point =", value, "point");
  470. return (Criteria) this;
  471. }
  472. public Criteria andPointNotEqualTo(String value) {
  473. addCriterion("point <>", value, "point");
  474. return (Criteria) this;
  475. }
  476. public Criteria andPointGreaterThan(String value) {
  477. addCriterion("point >", value, "point");
  478. return (Criteria) this;
  479. }
  480. public Criteria andPointGreaterThanOrEqualTo(String value) {
  481. addCriterion("point >=", value, "point");
  482. return (Criteria) this;
  483. }
  484. public Criteria andPointLessThan(String value) {
  485. addCriterion("point <", value, "point");
  486. return (Criteria) this;
  487. }
  488. public Criteria andPointLessThanOrEqualTo(String value) {
  489. addCriterion("point <=", value, "point");
  490. return (Criteria) this;
  491. }
  492. public Criteria andPointLike(String value) {
  493. addCriterion("point like", value, "point");
  494. return (Criteria) this;
  495. }
  496. public Criteria andPointNotLike(String value) {
  497. addCriterion("point not like", value, "point");
  498. return (Criteria) this;
  499. }
  500. public Criteria andPointIn(List<String> values) {
  501. addCriterion("point in", values, "point");
  502. return (Criteria) this;
  503. }
  504. public Criteria andPointNotIn(List<String> values) {
  505. addCriterion("point not in", values, "point");
  506. return (Criteria) this;
  507. }
  508. public Criteria andPointBetween(String value1, String value2) {
  509. addCriterion("point between", value1, value2, "point");
  510. return (Criteria) this;
  511. }
  512. public Criteria andPointNotBetween(String value1, String value2) {
  513. addCriterion("point not between", value1, value2, "point");
  514. return (Criteria) this;
  515. }
  516. public Criteria andDirectionIsNull() {
  517. addCriterion("direction is null");
  518. return (Criteria) this;
  519. }
  520. public Criteria andDirectionIsNotNull() {
  521. addCriterion("direction is not null");
  522. return (Criteria) this;
  523. }
  524. public Criteria andDirectionEqualTo(String value) {
  525. addCriterion("direction =", value, "direction");
  526. return (Criteria) this;
  527. }
  528. public Criteria andDirectionNotEqualTo(String value) {
  529. addCriterion("direction <>", value, "direction");
  530. return (Criteria) this;
  531. }
  532. public Criteria andDirectionGreaterThan(String value) {
  533. addCriterion("direction >", value, "direction");
  534. return (Criteria) this;
  535. }
  536. public Criteria andDirectionGreaterThanOrEqualTo(String value) {
  537. addCriterion("direction >=", value, "direction");
  538. return (Criteria) this;
  539. }
  540. public Criteria andDirectionLessThan(String value) {
  541. addCriterion("direction <", value, "direction");
  542. return (Criteria) this;
  543. }
  544. public Criteria andDirectionLessThanOrEqualTo(String value) {
  545. addCriterion("direction <=", value, "direction");
  546. return (Criteria) this;
  547. }
  548. public Criteria andDirectionLike(String value) {
  549. addCriterion("direction like", value, "direction");
  550. return (Criteria) this;
  551. }
  552. public Criteria andDirectionNotLike(String value) {
  553. addCriterion("direction not like", value, "direction");
  554. return (Criteria) this;
  555. }
  556. public Criteria andDirectionIn(List<String> values) {
  557. addCriterion("direction in", values, "direction");
  558. return (Criteria) this;
  559. }
  560. public Criteria andDirectionNotIn(List<String> values) {
  561. addCriterion("direction not in", values, "direction");
  562. return (Criteria) this;
  563. }
  564. public Criteria andDirectionBetween(String value1, String value2) {
  565. addCriterion("direction between", value1, value2, "direction");
  566. return (Criteria) this;
  567. }
  568. public Criteria andDirectionNotBetween(String value1, String value2) {
  569. addCriterion("direction not between", value1, value2, "direction");
  570. return (Criteria) this;
  571. }
  572. public Criteria andInvoiceIdIsNull() {
  573. addCriterion("invoice_id is null");
  574. return (Criteria) this;
  575. }
  576. public Criteria andInvoiceIdIsNotNull() {
  577. addCriterion("invoice_id is not null");
  578. return (Criteria) this;
  579. }
  580. public Criteria andInvoiceIdEqualTo(String value) {
  581. addCriterion("invoice_id =", value, "invoiceId");
  582. return (Criteria) this;
  583. }
  584. public Criteria andInvoiceIdNotEqualTo(String value) {
  585. addCriterion("invoice_id <>", value, "invoiceId");
  586. return (Criteria) this;
  587. }
  588. public Criteria andInvoiceIdGreaterThan(String value) {
  589. addCriterion("invoice_id >", value, "invoiceId");
  590. return (Criteria) this;
  591. }
  592. public Criteria andInvoiceIdGreaterThanOrEqualTo(String value) {
  593. addCriterion("invoice_id >=", value, "invoiceId");
  594. return (Criteria) this;
  595. }
  596. public Criteria andInvoiceIdLessThan(String value) {
  597. addCriterion("invoice_id <", value, "invoiceId");
  598. return (Criteria) this;
  599. }
  600. public Criteria andInvoiceIdLessThanOrEqualTo(String value) {
  601. addCriterion("invoice_id <=", value, "invoiceId");
  602. return (Criteria) this;
  603. }
  604. public Criteria andInvoiceIdLike(String value) {
  605. addCriterion("invoice_id like", value, "invoiceId");
  606. return (Criteria) this;
  607. }
  608. public Criteria andInvoiceIdNotLike(String value) {
  609. addCriterion("invoice_id not like", value, "invoiceId");
  610. return (Criteria) this;
  611. }
  612. public Criteria andInvoiceIdIn(List<String> values) {
  613. addCriterion("invoice_id in", values, "invoiceId");
  614. return (Criteria) this;
  615. }
  616. public Criteria andInvoiceIdNotIn(List<String> values) {
  617. addCriterion("invoice_id not in", values, "invoiceId");
  618. return (Criteria) this;
  619. }
  620. public Criteria andInvoiceIdBetween(String value1, String value2) {
  621. addCriterion("invoice_id between", value1, value2, "invoiceId");
  622. return (Criteria) this;
  623. }
  624. public Criteria andInvoiceIdNotBetween(String value1, String value2) {
  625. addCriterion("invoice_id not between", value1, value2, "invoiceId");
  626. return (Criteria) this;
  627. }
  628. public Criteria andGoodsCodeIsNull() {
  629. addCriterion("goods_code is null");
  630. return (Criteria) this;
  631. }
  632. public Criteria andGoodsCodeIsNotNull() {
  633. addCriterion("goods_code is not null");
  634. return (Criteria) this;
  635. }
  636. public Criteria andGoodsCodeEqualTo(String value) {
  637. addCriterion("goods_code =", value, "goodsCode");
  638. return (Criteria) this;
  639. }
  640. public Criteria andGoodsCodeNotEqualTo(String value) {
  641. addCriterion("goods_code <>", value, "goodsCode");
  642. return (Criteria) this;
  643. }
  644. public Criteria andGoodsCodeGreaterThan(String value) {
  645. addCriterion("goods_code >", value, "goodsCode");
  646. return (Criteria) this;
  647. }
  648. public Criteria andGoodsCodeGreaterThanOrEqualTo(String value) {
  649. addCriterion("goods_code >=", value, "goodsCode");
  650. return (Criteria) this;
  651. }
  652. public Criteria andGoodsCodeLessThan(String value) {
  653. addCriterion("goods_code <", value, "goodsCode");
  654. return (Criteria) this;
  655. }
  656. public Criteria andGoodsCodeLessThanOrEqualTo(String value) {
  657. addCriterion("goods_code <=", value, "goodsCode");
  658. return (Criteria) this;
  659. }
  660. public Criteria andGoodsCodeLike(String value) {
  661. addCriterion("goods_code like", value, "goodsCode");
  662. return (Criteria) this;
  663. }
  664. public Criteria andGoodsCodeNotLike(String value) {
  665. addCriterion("goods_code not like", value, "goodsCode");
  666. return (Criteria) this;
  667. }
  668. public Criteria andGoodsCodeIn(List<String> values) {
  669. addCriterion("goods_code in", values, "goodsCode");
  670. return (Criteria) this;
  671. }
  672. public Criteria andGoodsCodeNotIn(List<String> values) {
  673. addCriterion("goods_code not in", values, "goodsCode");
  674. return (Criteria) this;
  675. }
  676. public Criteria andGoodsCodeBetween(String value1, String value2) {
  677. addCriterion("goods_code between", value1, value2, "goodsCode");
  678. return (Criteria) this;
  679. }
  680. public Criteria andGoodsCodeNotBetween(String value1, String value2) {
  681. addCriterion("goods_code not between", value1, value2, "goodsCode");
  682. return (Criteria) this;
  683. }
  684. public Criteria andParamIsNull() {
  685. addCriterion("param is null");
  686. return (Criteria) this;
  687. }
  688. public Criteria andParamIsNotNull() {
  689. addCriterion("param is not null");
  690. return (Criteria) this;
  691. }
  692. public Criteria andParamEqualTo(String value) {
  693. addCriterion("param =", value, "param");
  694. return (Criteria) this;
  695. }
  696. public Criteria andParamNotEqualTo(String value) {
  697. addCriterion("param <>", value, "param");
  698. return (Criteria) this;
  699. }
  700. public Criteria andParamGreaterThan(String value) {
  701. addCriterion("param >", value, "param");
  702. return (Criteria) this;
  703. }
  704. public Criteria andParamGreaterThanOrEqualTo(String value) {
  705. addCriterion("param >=", value, "param");
  706. return (Criteria) this;
  707. }
  708. public Criteria andParamLessThan(String value) {
  709. addCriterion("param <", value, "param");
  710. return (Criteria) this;
  711. }
  712. public Criteria andParamLessThanOrEqualTo(String value) {
  713. addCriterion("param <=", value, "param");
  714. return (Criteria) this;
  715. }
  716. public Criteria andParamLike(String value) {
  717. addCriterion("param like", value, "param");
  718. return (Criteria) this;
  719. }
  720. public Criteria andParamNotLike(String value) {
  721. addCriterion("param not like", value, "param");
  722. return (Criteria) this;
  723. }
  724. public Criteria andParamIn(List<String> values) {
  725. addCriterion("param in", values, "param");
  726. return (Criteria) this;
  727. }
  728. public Criteria andParamNotIn(List<String> values) {
  729. addCriterion("param not in", values, "param");
  730. return (Criteria) this;
  731. }
  732. public Criteria andParamBetween(String value1, String value2) {
  733. addCriterion("param between", value1, value2, "param");
  734. return (Criteria) this;
  735. }
  736. public Criteria andParamNotBetween(String value1, String value2) {
  737. addCriterion("param not between", value1, value2, "param");
  738. return (Criteria) this;
  739. }
  740. public Criteria andGoodsPriceIsNull() {
  741. addCriterion("goods_price is null");
  742. return (Criteria) this;
  743. }
  744. public Criteria andGoodsPriceIsNotNull() {
  745. addCriterion("goods_price is not null");
  746. return (Criteria) this;
  747. }
  748. public Criteria andGoodsPriceEqualTo(String value) {
  749. addCriterion("goods_price =", value, "goodsPrice");
  750. return (Criteria) this;
  751. }
  752. public Criteria andGoodsPriceNotEqualTo(String value) {
  753. addCriterion("goods_price <>", value, "goodsPrice");
  754. return (Criteria) this;
  755. }
  756. public Criteria andGoodsPriceGreaterThan(String value) {
  757. addCriterion("goods_price >", value, "goodsPrice");
  758. return (Criteria) this;
  759. }
  760. public Criteria andGoodsPriceGreaterThanOrEqualTo(String value) {
  761. addCriterion("goods_price >=", value, "goodsPrice");
  762. return (Criteria) this;
  763. }
  764. public Criteria andGoodsPriceLessThan(String value) {
  765. addCriterion("goods_price <", value, "goodsPrice");
  766. return (Criteria) this;
  767. }
  768. public Criteria andGoodsPriceLessThanOrEqualTo(String value) {
  769. addCriterion("goods_price <=", value, "goodsPrice");
  770. return (Criteria) this;
  771. }
  772. public Criteria andGoodsPriceLike(String value) {
  773. addCriterion("goods_price like", value, "goodsPrice");
  774. return (Criteria) this;
  775. }
  776. public Criteria andGoodsPriceNotLike(String value) {
  777. addCriterion("goods_price not like", value, "goodsPrice");
  778. return (Criteria) this;
  779. }
  780. public Criteria andGoodsPriceIn(List<String> values) {
  781. addCriterion("goods_price in", values, "goodsPrice");
  782. return (Criteria) this;
  783. }
  784. public Criteria andGoodsPriceNotIn(List<String> values) {
  785. addCriterion("goods_price not in", values, "goodsPrice");
  786. return (Criteria) this;
  787. }
  788. public Criteria andGoodsPriceBetween(String value1, String value2) {
  789. addCriterion("goods_price between", value1, value2, "goodsPrice");
  790. return (Criteria) this;
  791. }
  792. public Criteria andGoodsPriceNotBetween(String value1, String value2) {
  793. addCriterion("goods_price not between", value1, value2, "goodsPrice");
  794. return (Criteria) this;
  795. }
  796. public Criteria andTypeIsNull() {
  797. addCriterion("type is null");
  798. return (Criteria) this;
  799. }
  800. public Criteria andTypeIsNotNull() {
  801. addCriterion("type is not null");
  802. return (Criteria) this;
  803. }
  804. public Criteria andTypeEqualTo(String value) {
  805. addCriterion("type =", value, "type");
  806. return (Criteria) this;
  807. }
  808. public Criteria andTypeNotEqualTo(String value) {
  809. addCriterion("type <>", value, "type");
  810. return (Criteria) this;
  811. }
  812. public Criteria andTypeGreaterThan(String value) {
  813. addCriterion("type >", value, "type");
  814. return (Criteria) this;
  815. }
  816. public Criteria andTypeGreaterThanOrEqualTo(String value) {
  817. addCriterion("type >=", value, "type");
  818. return (Criteria) this;
  819. }
  820. public Criteria andTypeLessThan(String value) {
  821. addCriterion("type <", value, "type");
  822. return (Criteria) this;
  823. }
  824. public Criteria andTypeLessThanOrEqualTo(String value) {
  825. addCriterion("type <=", value, "type");
  826. return (Criteria) this;
  827. }
  828. public Criteria andTypeLike(String value) {
  829. addCriterion("type like", value, "type");
  830. return (Criteria) this;
  831. }
  832. public Criteria andTypeNotLike(String value) {
  833. addCriterion("type not like", value, "type");
  834. return (Criteria) this;
  835. }
  836. public Criteria andTypeIn(List<String> values) {
  837. addCriterion("type in", values, "type");
  838. return (Criteria) this;
  839. }
  840. public Criteria andTypeNotIn(List<String> values) {
  841. addCriterion("type not in", values, "type");
  842. return (Criteria) this;
  843. }
  844. public Criteria andTypeBetween(String value1, String value2) {
  845. addCriterion("type between", value1, value2, "type");
  846. return (Criteria) this;
  847. }
  848. public Criteria andTypeNotBetween(String value1, String value2) {
  849. addCriterion("type not between", value1, value2, "type");
  850. return (Criteria) this;
  851. }
  852. public Criteria andPointOrderIdIsNull() {
  853. addCriterion("point_order_id is null");
  854. return (Criteria) this;
  855. }
  856. public Criteria andPointOrderIdIsNotNull() {
  857. addCriterion("point_order_id is not null");
  858. return (Criteria) this;
  859. }
  860. public Criteria andPointOrderIdEqualTo(String value) {
  861. addCriterion("point_order_id =", value, "pointOrderId");
  862. return (Criteria) this;
  863. }
  864. public Criteria andPointOrderIdNotEqualTo(String value) {
  865. addCriterion("point_order_id <>", value, "pointOrderId");
  866. return (Criteria) this;
  867. }
  868. public Criteria andPointOrderIdGreaterThan(String value) {
  869. addCriterion("point_order_id >", value, "pointOrderId");
  870. return (Criteria) this;
  871. }
  872. public Criteria andPointOrderIdGreaterThanOrEqualTo(String value) {
  873. addCriterion("point_order_id >=", value, "pointOrderId");
  874. return (Criteria) this;
  875. }
  876. public Criteria andPointOrderIdLessThan(String value) {
  877. addCriterion("point_order_id <", value, "pointOrderId");
  878. return (Criteria) this;
  879. }
  880. public Criteria andPointOrderIdLessThanOrEqualTo(String value) {
  881. addCriterion("point_order_id <=", value, "pointOrderId");
  882. return (Criteria) this;
  883. }
  884. public Criteria andPointOrderIdLike(String value) {
  885. addCriterion("point_order_id like", value, "pointOrderId");
  886. return (Criteria) this;
  887. }
  888. public Criteria andPointOrderIdNotLike(String value) {
  889. addCriterion("point_order_id not like", value, "pointOrderId");
  890. return (Criteria) this;
  891. }
  892. public Criteria andPointOrderIdIn(List<String> values) {
  893. addCriterion("point_order_id in", values, "pointOrderId");
  894. return (Criteria) this;
  895. }
  896. public Criteria andPointOrderIdNotIn(List<String> values) {
  897. addCriterion("point_order_id not in", values, "pointOrderId");
  898. return (Criteria) this;
  899. }
  900. public Criteria andPointOrderIdBetween(String value1, String value2) {
  901. addCriterion("point_order_id between", value1, value2, "pointOrderId");
  902. return (Criteria) this;
  903. }
  904. public Criteria andPointOrderIdNotBetween(String value1, String value2) {
  905. addCriterion("point_order_id not between", value1, value2, "pointOrderId");
  906. return (Criteria) this;
  907. }
  908. }
  909. public static class Criteria extends GeneratedCriteria {
  910. protected Criteria() {
  911. super();
  912. }
  913. }
  914. public static class Criterion {
  915. private String condition;
  916. private Object value;
  917. private Object secondValue;
  918. private boolean noValue;
  919. private boolean singleValue;
  920. private boolean betweenValue;
  921. private boolean listValue;
  922. private String typeHandler;
  923. public String getCondition() {
  924. return condition;
  925. }
  926. public Object getValue() {
  927. return value;
  928. }
  929. public Object getSecondValue() {
  930. return secondValue;
  931. }
  932. public boolean isNoValue() {
  933. return noValue;
  934. }
  935. public boolean isSingleValue() {
  936. return singleValue;
  937. }
  938. public boolean isBetweenValue() {
  939. return betweenValue;
  940. }
  941. public boolean isListValue() {
  942. return listValue;
  943. }
  944. public String getTypeHandler() {
  945. return typeHandler;
  946. }
  947. protected Criterion(String condition) {
  948. super();
  949. this.condition = condition;
  950. this.typeHandler = null;
  951. this.noValue = true;
  952. }
  953. protected Criterion(String condition, Object value, String typeHandler) {
  954. super();
  955. this.condition = condition;
  956. this.value = value;
  957. this.typeHandler = typeHandler;
  958. if (value instanceof List<?>) {
  959. this.listValue = true;
  960. } else {
  961. this.singleValue = true;
  962. }
  963. }
  964. protected Criterion(String condition, Object value) {
  965. this(condition, value, null);
  966. }
  967. protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
  968. super();
  969. this.condition = condition;
  970. this.value = value;
  971. this.secondValue = secondValue;
  972. this.typeHandler = typeHandler;
  973. this.betweenValue = true;
  974. }
  975. protected Criterion(String condition, Object value, Object secondValue) {
  976. this(condition, value, secondValue, null);
  977. }
  978. }
  979. }