TOrderMidExample.java 37 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233
  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 TOrderMidExample {
  7. /**
  8. * This field was generated by MyBatis Generator. This field corresponds to the database table t_order_mid
  9. * @mbg.generated Mon Jul 06 11:48:54 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_mid
  14. * @mbg.generated Mon Jul 06 11:48:54 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_mid
  19. * @mbg.generated Mon Jul 06 11:48:54 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_mid
  24. * @mbg.generated Mon Jul 06 11:48:54 CST 2020
  25. */
  26. public TOrderMidExample() {
  27. oredCriteria = new ArrayList<Criteria>();
  28. }
  29. /**
  30. * This method was generated by MyBatis Generator. This method corresponds to the database table t_order_mid
  31. * @mbg.generated Mon Jul 06 11:48:54 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_mid
  38. * @mbg.generated Mon Jul 06 11:48:54 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_mid
  45. * @mbg.generated Mon Jul 06 11:48:54 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_mid
  52. * @mbg.generated Mon Jul 06 11:48:54 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_mid
  59. * @mbg.generated Mon Jul 06 11:48:54 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_mid
  66. * @mbg.generated Mon Jul 06 11:48:54 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_mid
  73. * @mbg.generated Mon Jul 06 11:48:54 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_mid
  82. * @mbg.generated Mon Jul 06 11:48:54 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_mid
  93. * @mbg.generated Mon Jul 06 11:48:54 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_mid
  101. * @mbg.generated Mon Jul 06 11:48:54 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_mid
  110. * @mbg.generated Mon Jul 06 11:48:54 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 andIdIsNull() {
  146. addCriterion("id is null");
  147. return (Criteria) this;
  148. }
  149. public Criteria andIdIsNotNull() {
  150. addCriterion("id is not null");
  151. return (Criteria) this;
  152. }
  153. public Criteria andIdEqualTo(Integer value) {
  154. addCriterion("id =", value, "id");
  155. return (Criteria) this;
  156. }
  157. public Criteria andIdNotEqualTo(Integer value) {
  158. addCriterion("id <>", value, "id");
  159. return (Criteria) this;
  160. }
  161. public Criteria andIdGreaterThan(Integer value) {
  162. addCriterion("id >", value, "id");
  163. return (Criteria) this;
  164. }
  165. public Criteria andIdGreaterThanOrEqualTo(Integer value) {
  166. addCriterion("id >=", value, "id");
  167. return (Criteria) this;
  168. }
  169. public Criteria andIdLessThan(Integer value) {
  170. addCriterion("id <", value, "id");
  171. return (Criteria) this;
  172. }
  173. public Criteria andIdLessThanOrEqualTo(Integer value) {
  174. addCriterion("id <=", value, "id");
  175. return (Criteria) this;
  176. }
  177. public Criteria andIdIn(List<Integer> values) {
  178. addCriterion("id in", values, "id");
  179. return (Criteria) this;
  180. }
  181. public Criteria andIdNotIn(List<Integer> values) {
  182. addCriterion("id not in", values, "id");
  183. return (Criteria) this;
  184. }
  185. public Criteria andIdBetween(Integer value1, Integer value2) {
  186. addCriterion("id between", value1, value2, "id");
  187. return (Criteria) this;
  188. }
  189. public Criteria andIdNotBetween(Integer value1, Integer value2) {
  190. addCriterion("id not between", value1, value2, "id");
  191. return (Criteria) this;
  192. }
  193. public Criteria andOrderNoIsNull() {
  194. addCriterion("order_no is null");
  195. return (Criteria) this;
  196. }
  197. public Criteria andOrderNoIsNotNull() {
  198. addCriterion("order_no is not null");
  199. return (Criteria) this;
  200. }
  201. public Criteria andOrderNoEqualTo(String value) {
  202. addCriterion("order_no =", value, "orderNo");
  203. return (Criteria) this;
  204. }
  205. public Criteria andOrderNoNotEqualTo(String value) {
  206. addCriterion("order_no <>", value, "orderNo");
  207. return (Criteria) this;
  208. }
  209. public Criteria andOrderNoGreaterThan(String value) {
  210. addCriterion("order_no >", value, "orderNo");
  211. return (Criteria) this;
  212. }
  213. public Criteria andOrderNoGreaterThanOrEqualTo(String value) {
  214. addCriterion("order_no >=", value, "orderNo");
  215. return (Criteria) this;
  216. }
  217. public Criteria andOrderNoLessThan(String value) {
  218. addCriterion("order_no <", value, "orderNo");
  219. return (Criteria) this;
  220. }
  221. public Criteria andOrderNoLessThanOrEqualTo(String value) {
  222. addCriterion("order_no <=", value, "orderNo");
  223. return (Criteria) this;
  224. }
  225. public Criteria andOrderNoLike(String value) {
  226. addCriterion("order_no like", value, "orderNo");
  227. return (Criteria) this;
  228. }
  229. public Criteria andOrderNoNotLike(String value) {
  230. addCriterion("order_no not like", value, "orderNo");
  231. return (Criteria) this;
  232. }
  233. public Criteria andOrderNoIn(List<String> values) {
  234. addCriterion("order_no in", values, "orderNo");
  235. return (Criteria) this;
  236. }
  237. public Criteria andOrderNoNotIn(List<String> values) {
  238. addCriterion("order_no not in", values, "orderNo");
  239. return (Criteria) this;
  240. }
  241. public Criteria andOrderNoBetween(String value1, String value2) {
  242. addCriterion("order_no between", value1, value2, "orderNo");
  243. return (Criteria) this;
  244. }
  245. public Criteria andOrderNoNotBetween(String value1, String value2) {
  246. addCriterion("order_no not between", value1, value2, "orderNo");
  247. return (Criteria) this;
  248. }
  249. public Criteria andSalesmanIdIsNull() {
  250. addCriterion("salesman_id is null");
  251. return (Criteria) this;
  252. }
  253. public Criteria andSalesmanIdIsNotNull() {
  254. addCriterion("salesman_id is not null");
  255. return (Criteria) this;
  256. }
  257. public Criteria andSalesmanIdEqualTo(String value) {
  258. addCriterion("salesman_id =", value, "salesmanId");
  259. return (Criteria) this;
  260. }
  261. public Criteria andSalesmanIdNotEqualTo(String value) {
  262. addCriterion("salesman_id <>", value, "salesmanId");
  263. return (Criteria) this;
  264. }
  265. public Criteria andSalesmanIdGreaterThan(String value) {
  266. addCriterion("salesman_id >", value, "salesmanId");
  267. return (Criteria) this;
  268. }
  269. public Criteria andSalesmanIdGreaterThanOrEqualTo(String value) {
  270. addCriterion("salesman_id >=", value, "salesmanId");
  271. return (Criteria) this;
  272. }
  273. public Criteria andSalesmanIdLessThan(String value) {
  274. addCriterion("salesman_id <", value, "salesmanId");
  275. return (Criteria) this;
  276. }
  277. public Criteria andSalesmanIdLessThanOrEqualTo(String value) {
  278. addCriterion("salesman_id <=", value, "salesmanId");
  279. return (Criteria) this;
  280. }
  281. public Criteria andSalesmanIdLike(String value) {
  282. addCriterion("salesman_id like", value, "salesmanId");
  283. return (Criteria) this;
  284. }
  285. public Criteria andSalesmanIdNotLike(String value) {
  286. addCriterion("salesman_id not like", value, "salesmanId");
  287. return (Criteria) this;
  288. }
  289. public Criteria andSalesmanIdIn(List<String> values) {
  290. addCriterion("salesman_id in", values, "salesmanId");
  291. return (Criteria) this;
  292. }
  293. public Criteria andSalesmanIdNotIn(List<String> values) {
  294. addCriterion("salesman_id not in", values, "salesmanId");
  295. return (Criteria) this;
  296. }
  297. public Criteria andSalesmanIdBetween(String value1, String value2) {
  298. addCriterion("salesman_id between", value1, value2, "salesmanId");
  299. return (Criteria) this;
  300. }
  301. public Criteria andSalesmanIdNotBetween(String value1, String value2) {
  302. addCriterion("salesman_id not between", value1, value2, "salesmanId");
  303. return (Criteria) this;
  304. }
  305. public Criteria andFinanceIdIsNull() {
  306. addCriterion("finance_id is null");
  307. return (Criteria) this;
  308. }
  309. public Criteria andFinanceIdIsNotNull() {
  310. addCriterion("finance_id is not null");
  311. return (Criteria) this;
  312. }
  313. public Criteria andFinanceIdEqualTo(String value) {
  314. addCriterion("finance_id =", value, "financeId");
  315. return (Criteria) this;
  316. }
  317. public Criteria andFinanceIdNotEqualTo(String value) {
  318. addCriterion("finance_id <>", value, "financeId");
  319. return (Criteria) this;
  320. }
  321. public Criteria andFinanceIdGreaterThan(String value) {
  322. addCriterion("finance_id >", value, "financeId");
  323. return (Criteria) this;
  324. }
  325. public Criteria andFinanceIdGreaterThanOrEqualTo(String value) {
  326. addCriterion("finance_id >=", value, "financeId");
  327. return (Criteria) this;
  328. }
  329. public Criteria andFinanceIdLessThan(String value) {
  330. addCriterion("finance_id <", value, "financeId");
  331. return (Criteria) this;
  332. }
  333. public Criteria andFinanceIdLessThanOrEqualTo(String value) {
  334. addCriterion("finance_id <=", value, "financeId");
  335. return (Criteria) this;
  336. }
  337. public Criteria andFinanceIdLike(String value) {
  338. addCriterion("finance_id like", value, "financeId");
  339. return (Criteria) this;
  340. }
  341. public Criteria andFinanceIdNotLike(String value) {
  342. addCriterion("finance_id not like", value, "financeId");
  343. return (Criteria) this;
  344. }
  345. public Criteria andFinanceIdIn(List<String> values) {
  346. addCriterion("finance_id in", values, "financeId");
  347. return (Criteria) this;
  348. }
  349. public Criteria andFinanceIdNotIn(List<String> values) {
  350. addCriterion("finance_id not in", values, "financeId");
  351. return (Criteria) this;
  352. }
  353. public Criteria andFinanceIdBetween(String value1, String value2) {
  354. addCriterion("finance_id between", value1, value2, "financeId");
  355. return (Criteria) this;
  356. }
  357. public Criteria andFinanceIdNotBetween(String value1, String value2) {
  358. addCriterion("finance_id not between", value1, value2, "financeId");
  359. return (Criteria) this;
  360. }
  361. public Criteria andSalesmanNameIsNull() {
  362. addCriterion("salesman_name is null");
  363. return (Criteria) this;
  364. }
  365. public Criteria andSalesmanNameIsNotNull() {
  366. addCriterion("salesman_name is not null");
  367. return (Criteria) this;
  368. }
  369. public Criteria andSalesmanNameEqualTo(String value) {
  370. addCriterion("salesman_name =", value, "salesmanName");
  371. return (Criteria) this;
  372. }
  373. public Criteria andSalesmanNameNotEqualTo(String value) {
  374. addCriterion("salesman_name <>", value, "salesmanName");
  375. return (Criteria) this;
  376. }
  377. public Criteria andSalesmanNameGreaterThan(String value) {
  378. addCriterion("salesman_name >", value, "salesmanName");
  379. return (Criteria) this;
  380. }
  381. public Criteria andSalesmanNameGreaterThanOrEqualTo(String value) {
  382. addCriterion("salesman_name >=", value, "salesmanName");
  383. return (Criteria) this;
  384. }
  385. public Criteria andSalesmanNameLessThan(String value) {
  386. addCriterion("salesman_name <", value, "salesmanName");
  387. return (Criteria) this;
  388. }
  389. public Criteria andSalesmanNameLessThanOrEqualTo(String value) {
  390. addCriterion("salesman_name <=", value, "salesmanName");
  391. return (Criteria) this;
  392. }
  393. public Criteria andSalesmanNameLike(String value) {
  394. addCriterion("salesman_name like", value, "salesmanName");
  395. return (Criteria) this;
  396. }
  397. public Criteria andSalesmanNameNotLike(String value) {
  398. addCriterion("salesman_name not like", value, "salesmanName");
  399. return (Criteria) this;
  400. }
  401. public Criteria andSalesmanNameIn(List<String> values) {
  402. addCriterion("salesman_name in", values, "salesmanName");
  403. return (Criteria) this;
  404. }
  405. public Criteria andSalesmanNameNotIn(List<String> values) {
  406. addCriterion("salesman_name not in", values, "salesmanName");
  407. return (Criteria) this;
  408. }
  409. public Criteria andSalesmanNameBetween(String value1, String value2) {
  410. addCriterion("salesman_name between", value1, value2, "salesmanName");
  411. return (Criteria) this;
  412. }
  413. public Criteria andSalesmanNameNotBetween(String value1, String value2) {
  414. addCriterion("salesman_name not between", value1, value2, "salesmanName");
  415. return (Criteria) this;
  416. }
  417. public Criteria andFinanceNameIsNull() {
  418. addCriterion("finance_name is null");
  419. return (Criteria) this;
  420. }
  421. public Criteria andFinanceNameIsNotNull() {
  422. addCriterion("finance_name is not null");
  423. return (Criteria) this;
  424. }
  425. public Criteria andFinanceNameEqualTo(String value) {
  426. addCriterion("finance_name =", value, "financeName");
  427. return (Criteria) this;
  428. }
  429. public Criteria andFinanceNameNotEqualTo(String value) {
  430. addCriterion("finance_name <>", value, "financeName");
  431. return (Criteria) this;
  432. }
  433. public Criteria andFinanceNameGreaterThan(String value) {
  434. addCriterion("finance_name >", value, "financeName");
  435. return (Criteria) this;
  436. }
  437. public Criteria andFinanceNameGreaterThanOrEqualTo(String value) {
  438. addCriterion("finance_name >=", value, "financeName");
  439. return (Criteria) this;
  440. }
  441. public Criteria andFinanceNameLessThan(String value) {
  442. addCriterion("finance_name <", value, "financeName");
  443. return (Criteria) this;
  444. }
  445. public Criteria andFinanceNameLessThanOrEqualTo(String value) {
  446. addCriterion("finance_name <=", value, "financeName");
  447. return (Criteria) this;
  448. }
  449. public Criteria andFinanceNameLike(String value) {
  450. addCriterion("finance_name like", value, "financeName");
  451. return (Criteria) this;
  452. }
  453. public Criteria andFinanceNameNotLike(String value) {
  454. addCriterion("finance_name not like", value, "financeName");
  455. return (Criteria) this;
  456. }
  457. public Criteria andFinanceNameIn(List<String> values) {
  458. addCriterion("finance_name in", values, "financeName");
  459. return (Criteria) this;
  460. }
  461. public Criteria andFinanceNameNotIn(List<String> values) {
  462. addCriterion("finance_name not in", values, "financeName");
  463. return (Criteria) this;
  464. }
  465. public Criteria andFinanceNameBetween(String value1, String value2) {
  466. addCriterion("finance_name between", value1, value2, "financeName");
  467. return (Criteria) this;
  468. }
  469. public Criteria andFinanceNameNotBetween(String value1, String value2) {
  470. addCriterion("finance_name not between", value1, value2, "financeName");
  471. return (Criteria) this;
  472. }
  473. public Criteria andFinalReceivablesIsNull() {
  474. addCriterion("final_receivables is null");
  475. return (Criteria) this;
  476. }
  477. public Criteria andFinalReceivablesIsNotNull() {
  478. addCriterion("final_receivables is not null");
  479. return (Criteria) this;
  480. }
  481. public Criteria andFinalReceivablesEqualTo(BigDecimal value) {
  482. addCriterion("final_receivables =", value, "finalReceivables");
  483. return (Criteria) this;
  484. }
  485. public Criteria andFinalReceivablesNotEqualTo(BigDecimal value) {
  486. addCriterion("final_receivables <>", value, "finalReceivables");
  487. return (Criteria) this;
  488. }
  489. public Criteria andFinalReceivablesGreaterThan(BigDecimal value) {
  490. addCriterion("final_receivables >", value, "finalReceivables");
  491. return (Criteria) this;
  492. }
  493. public Criteria andFinalReceivablesGreaterThanOrEqualTo(BigDecimal value) {
  494. addCriterion("final_receivables >=", value, "finalReceivables");
  495. return (Criteria) this;
  496. }
  497. public Criteria andFinalReceivablesLessThan(BigDecimal value) {
  498. addCriterion("final_receivables <", value, "finalReceivables");
  499. return (Criteria) this;
  500. }
  501. public Criteria andFinalReceivablesLessThanOrEqualTo(BigDecimal value) {
  502. addCriterion("final_receivables <=", value, "finalReceivables");
  503. return (Criteria) this;
  504. }
  505. public Criteria andFinalReceivablesIn(List<BigDecimal> values) {
  506. addCriterion("final_receivables in", values, "finalReceivables");
  507. return (Criteria) this;
  508. }
  509. public Criteria andFinalReceivablesNotIn(List<BigDecimal> values) {
  510. addCriterion("final_receivables not in", values, "finalReceivables");
  511. return (Criteria) this;
  512. }
  513. public Criteria andFinalReceivablesBetween(BigDecimal value1, BigDecimal value2) {
  514. addCriterion("final_receivables between", value1, value2, "finalReceivables");
  515. return (Criteria) this;
  516. }
  517. public Criteria andFinalReceivablesNotBetween(BigDecimal value1, BigDecimal value2) {
  518. addCriterion("final_receivables not between", value1, value2, "finalReceivables");
  519. return (Criteria) this;
  520. }
  521. public Criteria andFinalReceivablesTimeIsNull() {
  522. addCriterion("final_Receivables_time is null");
  523. return (Criteria) this;
  524. }
  525. public Criteria andFinalReceivablesTimeIsNotNull() {
  526. addCriterion("final_Receivables_time is not null");
  527. return (Criteria) this;
  528. }
  529. public Criteria andFinalReceivablesTimeEqualTo(Date value) {
  530. addCriterion("final_Receivables_time =", value, "finalReceivablesTime");
  531. return (Criteria) this;
  532. }
  533. public Criteria andFinalReceivablesTimeNotEqualTo(Date value) {
  534. addCriterion("final_Receivables_time <>", value, "finalReceivablesTime");
  535. return (Criteria) this;
  536. }
  537. public Criteria andFinalReceivablesTimeGreaterThan(Date value) {
  538. addCriterion("final_Receivables_time >", value, "finalReceivablesTime");
  539. return (Criteria) this;
  540. }
  541. public Criteria andFinalReceivablesTimeGreaterThanOrEqualTo(Date value) {
  542. addCriterion("final_Receivables_time >=", value, "finalReceivablesTime");
  543. return (Criteria) this;
  544. }
  545. public Criteria andFinalReceivablesTimeLessThan(Date value) {
  546. addCriterion("final_Receivables_time <", value, "finalReceivablesTime");
  547. return (Criteria) this;
  548. }
  549. public Criteria andFinalReceivablesTimeLessThanOrEqualTo(Date value) {
  550. addCriterion("final_Receivables_time <=", value, "finalReceivablesTime");
  551. return (Criteria) this;
  552. }
  553. public Criteria andFinalReceivablesTimeIn(List<Date> values) {
  554. addCriterion("final_Receivables_time in", values, "finalReceivablesTime");
  555. return (Criteria) this;
  556. }
  557. public Criteria andFinalReceivablesTimeNotIn(List<Date> values) {
  558. addCriterion("final_Receivables_time not in", values, "finalReceivablesTime");
  559. return (Criteria) this;
  560. }
  561. public Criteria andFinalReceivablesTimeBetween(Date value1, Date value2) {
  562. addCriterion("final_Receivables_time between", value1, value2, "finalReceivablesTime");
  563. return (Criteria) this;
  564. }
  565. public Criteria andFinalReceivablesTimeNotBetween(Date value1, Date value2) {
  566. addCriterion("final_Receivables_time not between", value1, value2, "finalReceivablesTime");
  567. return (Criteria) this;
  568. }
  569. public Criteria andInvoiceAmountIsNull() {
  570. addCriterion("invoice_amount is null");
  571. return (Criteria) this;
  572. }
  573. public Criteria andInvoiceAmountIsNotNull() {
  574. addCriterion("invoice_amount is not null");
  575. return (Criteria) this;
  576. }
  577. public Criteria andInvoiceAmountEqualTo(BigDecimal value) {
  578. addCriterion("invoice_amount =", value, "invoiceAmount");
  579. return (Criteria) this;
  580. }
  581. public Criteria andInvoiceAmountNotEqualTo(BigDecimal value) {
  582. addCriterion("invoice_amount <>", value, "invoiceAmount");
  583. return (Criteria) this;
  584. }
  585. public Criteria andInvoiceAmountGreaterThan(BigDecimal value) {
  586. addCriterion("invoice_amount >", value, "invoiceAmount");
  587. return (Criteria) this;
  588. }
  589. public Criteria andInvoiceAmountGreaterThanOrEqualTo(BigDecimal value) {
  590. addCriterion("invoice_amount >=", value, "invoiceAmount");
  591. return (Criteria) this;
  592. }
  593. public Criteria andInvoiceAmountLessThan(BigDecimal value) {
  594. addCriterion("invoice_amount <", value, "invoiceAmount");
  595. return (Criteria) this;
  596. }
  597. public Criteria andInvoiceAmountLessThanOrEqualTo(BigDecimal value) {
  598. addCriterion("invoice_amount <=", value, "invoiceAmount");
  599. return (Criteria) this;
  600. }
  601. public Criteria andInvoiceAmountIn(List<BigDecimal> values) {
  602. addCriterion("invoice_amount in", values, "invoiceAmount");
  603. return (Criteria) this;
  604. }
  605. public Criteria andInvoiceAmountNotIn(List<BigDecimal> values) {
  606. addCriterion("invoice_amount not in", values, "invoiceAmount");
  607. return (Criteria) this;
  608. }
  609. public Criteria andInvoiceAmountBetween(BigDecimal value1, BigDecimal value2) {
  610. addCriterion("invoice_amount between", value1, value2, "invoiceAmount");
  611. return (Criteria) this;
  612. }
  613. public Criteria andInvoiceAmountNotBetween(BigDecimal value1, BigDecimal value2) {
  614. addCriterion("invoice_amount not between", value1, value2, "invoiceAmount");
  615. return (Criteria) this;
  616. }
  617. public Criteria andCreateTimeIsNull() {
  618. addCriterion("create_time is null");
  619. return (Criteria) this;
  620. }
  621. public Criteria andCreateTimeIsNotNull() {
  622. addCriterion("create_time is not null");
  623. return (Criteria) this;
  624. }
  625. public Criteria andCreateTimeEqualTo(Date value) {
  626. addCriterion("create_time =", value, "createTime");
  627. return (Criteria) this;
  628. }
  629. public Criteria andCreateTimeNotEqualTo(Date value) {
  630. addCriterion("create_time <>", value, "createTime");
  631. return (Criteria) this;
  632. }
  633. public Criteria andCreateTimeGreaterThan(Date value) {
  634. addCriterion("create_time >", value, "createTime");
  635. return (Criteria) this;
  636. }
  637. public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
  638. addCriterion("create_time >=", value, "createTime");
  639. return (Criteria) this;
  640. }
  641. public Criteria andCreateTimeLessThan(Date value) {
  642. addCriterion("create_time <", value, "createTime");
  643. return (Criteria) this;
  644. }
  645. public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
  646. addCriterion("create_time <=", value, "createTime");
  647. return (Criteria) this;
  648. }
  649. public Criteria andCreateTimeIn(List<Date> values) {
  650. addCriterion("create_time in", values, "createTime");
  651. return (Criteria) this;
  652. }
  653. public Criteria andCreateTimeNotIn(List<Date> values) {
  654. addCriterion("create_time not in", values, "createTime");
  655. return (Criteria) this;
  656. }
  657. public Criteria andCreateTimeBetween(Date value1, Date value2) {
  658. addCriterion("create_time between", value1, value2, "createTime");
  659. return (Criteria) this;
  660. }
  661. public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
  662. addCriterion("create_time not between", value1, value2, "createTime");
  663. return (Criteria) this;
  664. }
  665. public Criteria andBuyerNameIsNull() {
  666. addCriterion("buyer_name is null");
  667. return (Criteria) this;
  668. }
  669. public Criteria andBuyerNameIsNotNull() {
  670. addCriterion("buyer_name is not null");
  671. return (Criteria) this;
  672. }
  673. public Criteria andBuyerNameEqualTo(String value) {
  674. addCriterion("buyer_name =", value, "buyerName");
  675. return (Criteria) this;
  676. }
  677. public Criteria andBuyerNameNotEqualTo(String value) {
  678. addCriterion("buyer_name <>", value, "buyerName");
  679. return (Criteria) this;
  680. }
  681. public Criteria andBuyerNameGreaterThan(String value) {
  682. addCriterion("buyer_name >", value, "buyerName");
  683. return (Criteria) this;
  684. }
  685. public Criteria andBuyerNameGreaterThanOrEqualTo(String value) {
  686. addCriterion("buyer_name >=", value, "buyerName");
  687. return (Criteria) this;
  688. }
  689. public Criteria andBuyerNameLessThan(String value) {
  690. addCriterion("buyer_name <", value, "buyerName");
  691. return (Criteria) this;
  692. }
  693. public Criteria andBuyerNameLessThanOrEqualTo(String value) {
  694. addCriterion("buyer_name <=", value, "buyerName");
  695. return (Criteria) this;
  696. }
  697. public Criteria andBuyerNameLike(String value) {
  698. addCriterion("buyer_name like", value, "buyerName");
  699. return (Criteria) this;
  700. }
  701. public Criteria andBuyerNameNotLike(String value) {
  702. addCriterion("buyer_name not like", value, "buyerName");
  703. return (Criteria) this;
  704. }
  705. public Criteria andBuyerNameIn(List<String> values) {
  706. addCriterion("buyer_name in", values, "buyerName");
  707. return (Criteria) this;
  708. }
  709. public Criteria andBuyerNameNotIn(List<String> values) {
  710. addCriterion("buyer_name not in", values, "buyerName");
  711. return (Criteria) this;
  712. }
  713. public Criteria andBuyerNameBetween(String value1, String value2) {
  714. addCriterion("buyer_name between", value1, value2, "buyerName");
  715. return (Criteria) this;
  716. }
  717. public Criteria andBuyerNameNotBetween(String value1, String value2) {
  718. addCriterion("buyer_name not between", value1, value2, "buyerName");
  719. return (Criteria) this;
  720. }
  721. public Criteria andOrderReceivablesIsNull() {
  722. addCriterion("order_receivables is null");
  723. return (Criteria) this;
  724. }
  725. public Criteria andOrderReceivablesIsNotNull() {
  726. addCriterion("order_receivables is not null");
  727. return (Criteria) this;
  728. }
  729. public Criteria andOrderReceivablesEqualTo(BigDecimal value) {
  730. addCriterion("order_receivables =", value, "orderReceivables");
  731. return (Criteria) this;
  732. }
  733. public Criteria andOrderReceivablesNotEqualTo(BigDecimal value) {
  734. addCriterion("order_receivables <>", value, "orderReceivables");
  735. return (Criteria) this;
  736. }
  737. public Criteria andOrderReceivablesGreaterThan(BigDecimal value) {
  738. addCriterion("order_receivables >", value, "orderReceivables");
  739. return (Criteria) this;
  740. }
  741. public Criteria andOrderReceivablesGreaterThanOrEqualTo(BigDecimal value) {
  742. addCriterion("order_receivables >=", value, "orderReceivables");
  743. return (Criteria) this;
  744. }
  745. public Criteria andOrderReceivablesLessThan(BigDecimal value) {
  746. addCriterion("order_receivables <", value, "orderReceivables");
  747. return (Criteria) this;
  748. }
  749. public Criteria andOrderReceivablesLessThanOrEqualTo(BigDecimal value) {
  750. addCriterion("order_receivables <=", value, "orderReceivables");
  751. return (Criteria) this;
  752. }
  753. public Criteria andOrderReceivablesIn(List<BigDecimal> values) {
  754. addCriterion("order_receivables in", values, "orderReceivables");
  755. return (Criteria) this;
  756. }
  757. public Criteria andOrderReceivablesNotIn(List<BigDecimal> values) {
  758. addCriterion("order_receivables not in", values, "orderReceivables");
  759. return (Criteria) this;
  760. }
  761. public Criteria andOrderReceivablesBetween(BigDecimal value1, BigDecimal value2) {
  762. addCriterion("order_receivables between", value1, value2, "orderReceivables");
  763. return (Criteria) this;
  764. }
  765. public Criteria andOrderReceivablesNotBetween(BigDecimal value1, BigDecimal value2) {
  766. addCriterion("order_receivables not between", value1, value2, "orderReceivables");
  767. return (Criteria) this;
  768. }
  769. public Criteria andOrderArrearsIsNull() {
  770. addCriterion("order_arrears is null");
  771. return (Criteria) this;
  772. }
  773. public Criteria andOrderArrearsIsNotNull() {
  774. addCriterion("order_arrears is not null");
  775. return (Criteria) this;
  776. }
  777. public Criteria andOrderArrearsEqualTo(BigDecimal value) {
  778. addCriterion("order_arrears =", value, "orderArrears");
  779. return (Criteria) this;
  780. }
  781. public Criteria andOrderArrearsNotEqualTo(BigDecimal value) {
  782. addCriterion("order_arrears <>", value, "orderArrears");
  783. return (Criteria) this;
  784. }
  785. public Criteria andOrderArrearsGreaterThan(BigDecimal value) {
  786. addCriterion("order_arrears >", value, "orderArrears");
  787. return (Criteria) this;
  788. }
  789. public Criteria andOrderArrearsGreaterThanOrEqualTo(BigDecimal value) {
  790. addCriterion("order_arrears >=", value, "orderArrears");
  791. return (Criteria) this;
  792. }
  793. public Criteria andOrderArrearsLessThan(BigDecimal value) {
  794. addCriterion("order_arrears <", value, "orderArrears");
  795. return (Criteria) this;
  796. }
  797. public Criteria andOrderArrearsLessThanOrEqualTo(BigDecimal value) {
  798. addCriterion("order_arrears <=", value, "orderArrears");
  799. return (Criteria) this;
  800. }
  801. public Criteria andOrderArrearsIn(List<BigDecimal> values) {
  802. addCriterion("order_arrears in", values, "orderArrears");
  803. return (Criteria) this;
  804. }
  805. public Criteria andOrderArrearsNotIn(List<BigDecimal> values) {
  806. addCriterion("order_arrears not in", values, "orderArrears");
  807. return (Criteria) this;
  808. }
  809. public Criteria andOrderArrearsBetween(BigDecimal value1, BigDecimal value2) {
  810. addCriterion("order_arrears between", value1, value2, "orderArrears");
  811. return (Criteria) this;
  812. }
  813. public Criteria andOrderArrearsNotBetween(BigDecimal value1, BigDecimal value2) {
  814. addCriterion("order_arrears not between", value1, value2, "orderArrears");
  815. return (Criteria) this;
  816. }
  817. public Criteria andCostAmountIsNull() {
  818. addCriterion("cost_amount is null");
  819. return (Criteria) this;
  820. }
  821. public Criteria andCostAmountIsNotNull() {
  822. addCriterion("cost_amount is not null");
  823. return (Criteria) this;
  824. }
  825. public Criteria andCostAmountEqualTo(BigDecimal value) {
  826. addCriterion("cost_amount =", value, "costAmount");
  827. return (Criteria) this;
  828. }
  829. public Criteria andCostAmountNotEqualTo(BigDecimal value) {
  830. addCriterion("cost_amount <>", value, "costAmount");
  831. return (Criteria) this;
  832. }
  833. public Criteria andCostAmountGreaterThan(BigDecimal value) {
  834. addCriterion("cost_amount >", value, "costAmount");
  835. return (Criteria) this;
  836. }
  837. public Criteria andCostAmountGreaterThanOrEqualTo(BigDecimal value) {
  838. addCriterion("cost_amount >=", value, "costAmount");
  839. return (Criteria) this;
  840. }
  841. public Criteria andCostAmountLessThan(BigDecimal value) {
  842. addCriterion("cost_amount <", value, "costAmount");
  843. return (Criteria) this;
  844. }
  845. public Criteria andCostAmountLessThanOrEqualTo(BigDecimal value) {
  846. addCriterion("cost_amount <=", value, "costAmount");
  847. return (Criteria) this;
  848. }
  849. public Criteria andCostAmountIn(List<BigDecimal> values) {
  850. addCriterion("cost_amount in", values, "costAmount");
  851. return (Criteria) this;
  852. }
  853. public Criteria andCostAmountNotIn(List<BigDecimal> values) {
  854. addCriterion("cost_amount not in", values, "costAmount");
  855. return (Criteria) this;
  856. }
  857. public Criteria andCostAmountBetween(BigDecimal value1, BigDecimal value2) {
  858. addCriterion("cost_amount between", value1, value2, "costAmount");
  859. return (Criteria) this;
  860. }
  861. public Criteria andCostAmountNotBetween(BigDecimal value1, BigDecimal value2) {
  862. addCriterion("cost_amount not between", value1, value2, "costAmount");
  863. return (Criteria) this;
  864. }
  865. public Criteria andDepNameIsNull() {
  866. addCriterion("dep_name is null");
  867. return (Criteria) this;
  868. }
  869. public Criteria andDepNameIsNotNull() {
  870. addCriterion("dep_name is not null");
  871. return (Criteria) this;
  872. }
  873. public Criteria andDepNameEqualTo(String value) {
  874. addCriterion("dep_name =", value, "depName");
  875. return (Criteria) this;
  876. }
  877. public Criteria andDepNameNotEqualTo(String value) {
  878. addCriterion("dep_name <>", value, "depName");
  879. return (Criteria) this;
  880. }
  881. public Criteria andDepNameGreaterThan(String value) {
  882. addCriterion("dep_name >", value, "depName");
  883. return (Criteria) this;
  884. }
  885. public Criteria andDepNameGreaterThanOrEqualTo(String value) {
  886. addCriterion("dep_name >=", value, "depName");
  887. return (Criteria) this;
  888. }
  889. public Criteria andDepNameLessThan(String value) {
  890. addCriterion("dep_name <", value, "depName");
  891. return (Criteria) this;
  892. }
  893. public Criteria andDepNameLessThanOrEqualTo(String value) {
  894. addCriterion("dep_name <=", value, "depName");
  895. return (Criteria) this;
  896. }
  897. public Criteria andDepNameLike(String value) {
  898. addCriterion("dep_name like", value, "depName");
  899. return (Criteria) this;
  900. }
  901. public Criteria andDepNameNotLike(String value) {
  902. addCriterion("dep_name not like", value, "depName");
  903. return (Criteria) this;
  904. }
  905. public Criteria andDepNameIn(List<String> values) {
  906. addCriterion("dep_name in", values, "depName");
  907. return (Criteria) this;
  908. }
  909. public Criteria andDepNameNotIn(List<String> values) {
  910. addCriterion("dep_name not in", values, "depName");
  911. return (Criteria) this;
  912. }
  913. public Criteria andDepNameBetween(String value1, String value2) {
  914. addCriterion("dep_name between", value1, value2, "depName");
  915. return (Criteria) this;
  916. }
  917. public Criteria andDepNameNotBetween(String value1, String value2) {
  918. addCriterion("dep_name not between", value1, value2, "depName");
  919. return (Criteria) this;
  920. }
  921. }
  922. /**
  923. * This class was generated by MyBatis Generator. This class corresponds to the database table t_order_mid
  924. * @mbg.generated Mon Jul 06 11:48:54 CST 2020
  925. */
  926. public static class Criterion {
  927. private String condition;
  928. private Object value;
  929. private Object secondValue;
  930. private boolean noValue;
  931. private boolean singleValue;
  932. private boolean betweenValue;
  933. private boolean listValue;
  934. private String typeHandler;
  935. public String getCondition() {
  936. return condition;
  937. }
  938. public Object getValue() {
  939. return value;
  940. }
  941. public Object getSecondValue() {
  942. return secondValue;
  943. }
  944. public boolean isNoValue() {
  945. return noValue;
  946. }
  947. public boolean isSingleValue() {
  948. return singleValue;
  949. }
  950. public boolean isBetweenValue() {
  951. return betweenValue;
  952. }
  953. public boolean isListValue() {
  954. return listValue;
  955. }
  956. public String getTypeHandler() {
  957. return typeHandler;
  958. }
  959. protected Criterion(String condition) {
  960. super();
  961. this.condition = condition;
  962. this.typeHandler = null;
  963. this.noValue = true;
  964. }
  965. protected Criterion(String condition, Object value, String typeHandler) {
  966. super();
  967. this.condition = condition;
  968. this.value = value;
  969. this.typeHandler = typeHandler;
  970. if (value instanceof List<?>) {
  971. this.listValue = true;
  972. } else {
  973. this.singleValue = true;
  974. }
  975. }
  976. protected Criterion(String condition, Object value) {
  977. this(condition, value, null);
  978. }
  979. protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
  980. super();
  981. this.condition = condition;
  982. this.value = value;
  983. this.secondValue = secondValue;
  984. this.typeHandler = typeHandler;
  985. this.betweenValue = true;
  986. }
  987. protected Criterion(String condition, Object value, Object secondValue) {
  988. this(condition, value, secondValue, null);
  989. }
  990. }
  991. /**
  992. * This class was generated by MyBatis Generator.
  993. * This class corresponds to the database table t_order_mid
  994. *
  995. * @mbg.generated do_not_delete_during_merge Fri Dec 06 16:24:51 CST 2019
  996. */
  997. public static class Criteria extends GeneratedCriteria {
  998. protected Criteria() {
  999. super();
  1000. }
  1001. }
  1002. }