TpOrderDetailExample.java 43 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373
  1. package com.minpay.db.table.model;
  2. import java.util.ArrayList;
  3. import java.util.List;
  4. public class TpOrderDetailExample {
  5. /**
  6. * This field was generated by MyBatis Generator.
  7. * This field corresponds to the database table tp_order_detail
  8. *
  9. * @mbggenerated
  10. */
  11. protected String orderByClause;
  12. /**
  13. * This field was generated by MyBatis Generator.
  14. * This field corresponds to the database table tp_order_detail
  15. *
  16. * @mbggenerated
  17. */
  18. protected boolean distinct;
  19. /**
  20. * This field was generated by MyBatis Generator.
  21. * This field corresponds to the database table tp_order_detail
  22. *
  23. * @mbggenerated
  24. */
  25. protected List<Criteria> oredCriteria;
  26. /**
  27. * This method was generated by MyBatis Generator.
  28. * This method corresponds to the database table tp_order_detail
  29. *
  30. * @mbggenerated
  31. */
  32. public TpOrderDetailExample() {
  33. oredCriteria = new ArrayList<Criteria>();
  34. }
  35. /**
  36. * This method was generated by MyBatis Generator.
  37. * This method corresponds to the database table tp_order_detail
  38. *
  39. * @mbggenerated
  40. */
  41. public void setOrderByClause(String orderByClause) {
  42. this.orderByClause = orderByClause;
  43. }
  44. /**
  45. * This method was generated by MyBatis Generator.
  46. * This method corresponds to the database table tp_order_detail
  47. *
  48. * @mbggenerated
  49. */
  50. public String getOrderByClause() {
  51. return orderByClause;
  52. }
  53. /**
  54. * This method was generated by MyBatis Generator.
  55. * This method corresponds to the database table tp_order_detail
  56. *
  57. * @mbggenerated
  58. */
  59. public void setDistinct(boolean distinct) {
  60. this.distinct = distinct;
  61. }
  62. /**
  63. * This method was generated by MyBatis Generator.
  64. * This method corresponds to the database table tp_order_detail
  65. *
  66. * @mbggenerated
  67. */
  68. public boolean isDistinct() {
  69. return distinct;
  70. }
  71. /**
  72. * This method was generated by MyBatis Generator.
  73. * This method corresponds to the database table tp_order_detail
  74. *
  75. * @mbggenerated
  76. */
  77. public List<Criteria> getOredCriteria() {
  78. return oredCriteria;
  79. }
  80. /**
  81. * This method was generated by MyBatis Generator.
  82. * This method corresponds to the database table tp_order_detail
  83. *
  84. * @mbggenerated
  85. */
  86. public void or(Criteria criteria) {
  87. oredCriteria.add(criteria);
  88. }
  89. /**
  90. * This method was generated by MyBatis Generator.
  91. * This method corresponds to the database table tp_order_detail
  92. *
  93. * @mbggenerated
  94. */
  95. public Criteria or() {
  96. Criteria criteria = createCriteriaInternal();
  97. oredCriteria.add(criteria);
  98. return criteria;
  99. }
  100. /**
  101. * This method was generated by MyBatis Generator.
  102. * This method corresponds to the database table tp_order_detail
  103. *
  104. * @mbggenerated
  105. */
  106. public Criteria createCriteria() {
  107. Criteria criteria = createCriteriaInternal();
  108. if (oredCriteria.size() == 0) {
  109. oredCriteria.add(criteria);
  110. }
  111. return criteria;
  112. }
  113. /**
  114. * This method was generated by MyBatis Generator.
  115. * This method corresponds to the database table tp_order_detail
  116. *
  117. * @mbggenerated
  118. */
  119. protected Criteria createCriteriaInternal() {
  120. Criteria criteria = new Criteria();
  121. return criteria;
  122. }
  123. /**
  124. * This method was generated by MyBatis Generator.
  125. * This method corresponds to the database table tp_order_detail
  126. *
  127. * @mbggenerated
  128. */
  129. public void clear() {
  130. oredCriteria.clear();
  131. orderByClause = null;
  132. distinct = false;
  133. }
  134. /**
  135. * This class was generated by MyBatis Generator.
  136. * This class corresponds to the database table tp_order_detail
  137. *
  138. * @mbggenerated
  139. */
  140. protected abstract static class GeneratedCriteria {
  141. protected List<Criterion> criteria;
  142. protected GeneratedCriteria() {
  143. super();
  144. criteria = new ArrayList<Criterion>();
  145. }
  146. public boolean isValid() {
  147. return criteria.size() > 0;
  148. }
  149. public List<Criterion> getCriteria() {
  150. return criteria;
  151. }
  152. protected void addCriterion(String condition) {
  153. if (condition == null) {
  154. throw new RuntimeException("Value for condition cannot be null");
  155. }
  156. criteria.add(new Criterion(condition));
  157. }
  158. protected void addCriterion(String condition, Object value, String property) {
  159. if (value == null) {
  160. throw new RuntimeException("Value for " + property + " cannot be null");
  161. }
  162. criteria.add(new Criterion(condition, value));
  163. }
  164. protected void addCriterion(String condition, Object value1, Object value2, String property) {
  165. if (value1 == null || value2 == null) {
  166. throw new RuntimeException("Between values for " + property + " cannot be null");
  167. }
  168. criteria.add(new Criterion(condition, value1, value2));
  169. }
  170. public Criteria andIdIsNull() {
  171. addCriterion("ODT_ID is null");
  172. return (Criteria) this;
  173. }
  174. public Criteria andIdIsNotNull() {
  175. addCriterion("ODT_ID is not null");
  176. return (Criteria) this;
  177. }
  178. public Criteria andIdEqualTo(String value) {
  179. if(value == null ){
  180. andIdIsNull();
  181. } else {
  182. addCriterion("ODT_ID =", value, "id");
  183. }
  184. return (Criteria) this;
  185. }
  186. public Criteria andIdNotEqualTo(String value) {
  187. if(value == null ){
  188. andIdIsNotNull();
  189. } else {
  190. addCriterion("ODT_ID <>", value, "id");
  191. }
  192. return (Criteria) this;
  193. }
  194. public Criteria andIdGreaterThan(String value) {
  195. addCriterion("ODT_ID >", value, "id");
  196. return (Criteria) this;
  197. }
  198. public Criteria andIdGreaterThanOrEqualTo(String value) {
  199. addCriterion("ODT_ID >=", value, "id");
  200. return (Criteria) this;
  201. }
  202. public Criteria andIdLessThan(String value) {
  203. addCriterion("ODT_ID <", value, "id");
  204. return (Criteria) this;
  205. }
  206. public Criteria andIdLessThanOrEqualTo(String value) {
  207. addCriterion("ODT_ID <=", value, "id");
  208. return (Criteria) this;
  209. }
  210. public Criteria andIdLike(String value) {
  211. addCriterion("ODT_ID like", value, "id");
  212. return (Criteria) this;
  213. }
  214. public Criteria andIdNotLike(String value) {
  215. addCriterion("ODT_ID not like", value, "id");
  216. return (Criteria) this;
  217. }
  218. public Criteria andIdIn(List<String> values) {
  219. addCriterion("ODT_ID in", values, "id");
  220. return (Criteria) this;
  221. }
  222. public Criteria andIdNotIn(List<String> values) {
  223. addCriterion("ODT_ID not in", values, "id");
  224. return (Criteria) this;
  225. }
  226. public Criteria andIdBetween(String value1, String value2) {
  227. addCriterion("ODT_ID between", value1, value2, "id");
  228. return (Criteria) this;
  229. }
  230. public Criteria andIdNotBetween(String value1, String value2) {
  231. addCriterion("ODT_ID not between", value1, value2, "id");
  232. return (Criteria) this;
  233. }
  234. public Criteria andOrdernoIsNull() {
  235. addCriterion("ODT_ORDERNO is null");
  236. return (Criteria) this;
  237. }
  238. public Criteria andOrdernoIsNotNull() {
  239. addCriterion("ODT_ORDERNO is not null");
  240. return (Criteria) this;
  241. }
  242. public Criteria andOrdernoEqualTo(String value) {
  243. if(value == null ){
  244. andOrdernoIsNull();
  245. } else {
  246. addCriterion("ODT_ORDERNO =", value, "orderno");
  247. }
  248. return (Criteria) this;
  249. }
  250. public Criteria andOrdernoNotEqualTo(String value) {
  251. if(value == null ){
  252. andOrdernoIsNotNull();
  253. } else {
  254. addCriterion("ODT_ORDERNO <>", value, "orderno");
  255. }
  256. return (Criteria) this;
  257. }
  258. public Criteria andOrdernoGreaterThan(String value) {
  259. addCriterion("ODT_ORDERNO >", value, "orderno");
  260. return (Criteria) this;
  261. }
  262. public Criteria andOrdernoGreaterThanOrEqualTo(String value) {
  263. addCriterion("ODT_ORDERNO >=", value, "orderno");
  264. return (Criteria) this;
  265. }
  266. public Criteria andOrdernoLessThan(String value) {
  267. addCriterion("ODT_ORDERNO <", value, "orderno");
  268. return (Criteria) this;
  269. }
  270. public Criteria andOrdernoLessThanOrEqualTo(String value) {
  271. addCriterion("ODT_ORDERNO <=", value, "orderno");
  272. return (Criteria) this;
  273. }
  274. public Criteria andOrdernoLike(String value) {
  275. addCriterion("ODT_ORDERNO like", value, "orderno");
  276. return (Criteria) this;
  277. }
  278. public Criteria andOrdernoNotLike(String value) {
  279. addCriterion("ODT_ORDERNO not like", value, "orderno");
  280. return (Criteria) this;
  281. }
  282. public Criteria andOrdernoIn(List<String> values) {
  283. addCriterion("ODT_ORDERNO in", values, "orderno");
  284. return (Criteria) this;
  285. }
  286. public Criteria andOrdernoNotIn(List<String> values) {
  287. addCriterion("ODT_ORDERNO not in", values, "orderno");
  288. return (Criteria) this;
  289. }
  290. public Criteria andOrdernoBetween(String value1, String value2) {
  291. addCriterion("ODT_ORDERNO between", value1, value2, "orderno");
  292. return (Criteria) this;
  293. }
  294. public Criteria andOrdernoNotBetween(String value1, String value2) {
  295. addCriterion("ODT_ORDERNO not between", value1, value2, "orderno");
  296. return (Criteria) this;
  297. }
  298. public Criteria andNameIsNull() {
  299. addCriterion("ODT_NAME is null");
  300. return (Criteria) this;
  301. }
  302. public Criteria andNameIsNotNull() {
  303. addCriterion("ODT_NAME is not null");
  304. return (Criteria) this;
  305. }
  306. public Criteria andNameEqualTo(String value) {
  307. if(value == null ){
  308. andNameIsNull();
  309. } else {
  310. addCriterion("ODT_NAME =", value, "name");
  311. }
  312. return (Criteria) this;
  313. }
  314. public Criteria andNameNotEqualTo(String value) {
  315. if(value == null ){
  316. andNameIsNotNull();
  317. } else {
  318. addCriterion("ODT_NAME <>", value, "name");
  319. }
  320. return (Criteria) this;
  321. }
  322. public Criteria andNameGreaterThan(String value) {
  323. addCriterion("ODT_NAME >", value, "name");
  324. return (Criteria) this;
  325. }
  326. public Criteria andNameGreaterThanOrEqualTo(String value) {
  327. addCriterion("ODT_NAME >=", value, "name");
  328. return (Criteria) this;
  329. }
  330. public Criteria andNameLessThan(String value) {
  331. addCriterion("ODT_NAME <", value, "name");
  332. return (Criteria) this;
  333. }
  334. public Criteria andNameLessThanOrEqualTo(String value) {
  335. addCriterion("ODT_NAME <=", value, "name");
  336. return (Criteria) this;
  337. }
  338. public Criteria andNameLike(String value) {
  339. addCriterion("ODT_NAME like", value, "name");
  340. return (Criteria) this;
  341. }
  342. public Criteria andNameNotLike(String value) {
  343. addCriterion("ODT_NAME not like", value, "name");
  344. return (Criteria) this;
  345. }
  346. public Criteria andNameIn(List<String> values) {
  347. addCriterion("ODT_NAME in", values, "name");
  348. return (Criteria) this;
  349. }
  350. public Criteria andNameNotIn(List<String> values) {
  351. addCriterion("ODT_NAME not in", values, "name");
  352. return (Criteria) this;
  353. }
  354. public Criteria andNameBetween(String value1, String value2) {
  355. addCriterion("ODT_NAME between", value1, value2, "name");
  356. return (Criteria) this;
  357. }
  358. public Criteria andNameNotBetween(String value1, String value2) {
  359. addCriterion("ODT_NAME not between", value1, value2, "name");
  360. return (Criteria) this;
  361. }
  362. public Criteria andCategoryIsNull() {
  363. addCriterion("ODT_CATEGORY is null");
  364. return (Criteria) this;
  365. }
  366. public Criteria andCategoryIsNotNull() {
  367. addCriterion("ODT_CATEGORY is not null");
  368. return (Criteria) this;
  369. }
  370. public Criteria andCategoryEqualTo(String value) {
  371. if(value == null ){
  372. andCategoryIsNull();
  373. } else {
  374. addCriterion("ODT_CATEGORY =", value, "category");
  375. }
  376. return (Criteria) this;
  377. }
  378. public Criteria andCategoryNotEqualTo(String value) {
  379. if(value == null ){
  380. andCategoryIsNotNull();
  381. } else {
  382. addCriterion("ODT_CATEGORY <>", value, "category");
  383. }
  384. return (Criteria) this;
  385. }
  386. public Criteria andCategoryGreaterThan(String value) {
  387. addCriterion("ODT_CATEGORY >", value, "category");
  388. return (Criteria) this;
  389. }
  390. public Criteria andCategoryGreaterThanOrEqualTo(String value) {
  391. addCriterion("ODT_CATEGORY >=", value, "category");
  392. return (Criteria) this;
  393. }
  394. public Criteria andCategoryLessThan(String value) {
  395. addCriterion("ODT_CATEGORY <", value, "category");
  396. return (Criteria) this;
  397. }
  398. public Criteria andCategoryLessThanOrEqualTo(String value) {
  399. addCriterion("ODT_CATEGORY <=", value, "category");
  400. return (Criteria) this;
  401. }
  402. public Criteria andCategoryLike(String value) {
  403. addCriterion("ODT_CATEGORY like", value, "category");
  404. return (Criteria) this;
  405. }
  406. public Criteria andCategoryNotLike(String value) {
  407. addCriterion("ODT_CATEGORY not like", value, "category");
  408. return (Criteria) this;
  409. }
  410. public Criteria andCategoryIn(List<String> values) {
  411. addCriterion("ODT_CATEGORY in", values, "category");
  412. return (Criteria) this;
  413. }
  414. public Criteria andCategoryNotIn(List<String> values) {
  415. addCriterion("ODT_CATEGORY not in", values, "category");
  416. return (Criteria) this;
  417. }
  418. public Criteria andCategoryBetween(String value1, String value2) {
  419. addCriterion("ODT_CATEGORY between", value1, value2, "category");
  420. return (Criteria) this;
  421. }
  422. public Criteria andCategoryNotBetween(String value1, String value2) {
  423. addCriterion("ODT_CATEGORY not between", value1, value2, "category");
  424. return (Criteria) this;
  425. }
  426. public Criteria andBrandIsNull() {
  427. addCriterion("ODT_BRAND is null");
  428. return (Criteria) this;
  429. }
  430. public Criteria andBrandIsNotNull() {
  431. addCriterion("ODT_BRAND is not null");
  432. return (Criteria) this;
  433. }
  434. public Criteria andBrandEqualTo(String value) {
  435. if(value == null ){
  436. andBrandIsNull();
  437. } else {
  438. addCriterion("ODT_BRAND =", value, "brand");
  439. }
  440. return (Criteria) this;
  441. }
  442. public Criteria andBrandNotEqualTo(String value) {
  443. if(value == null ){
  444. andBrandIsNotNull();
  445. } else {
  446. addCriterion("ODT_BRAND <>", value, "brand");
  447. }
  448. return (Criteria) this;
  449. }
  450. public Criteria andBrandGreaterThan(String value) {
  451. addCriterion("ODT_BRAND >", value, "brand");
  452. return (Criteria) this;
  453. }
  454. public Criteria andBrandGreaterThanOrEqualTo(String value) {
  455. addCriterion("ODT_BRAND >=", value, "brand");
  456. return (Criteria) this;
  457. }
  458. public Criteria andBrandLessThan(String value) {
  459. addCriterion("ODT_BRAND <", value, "brand");
  460. return (Criteria) this;
  461. }
  462. public Criteria andBrandLessThanOrEqualTo(String value) {
  463. addCriterion("ODT_BRAND <=", value, "brand");
  464. return (Criteria) this;
  465. }
  466. public Criteria andBrandLike(String value) {
  467. addCriterion("ODT_BRAND like", value, "brand");
  468. return (Criteria) this;
  469. }
  470. public Criteria andBrandNotLike(String value) {
  471. addCriterion("ODT_BRAND not like", value, "brand");
  472. return (Criteria) this;
  473. }
  474. public Criteria andBrandIn(List<String> values) {
  475. addCriterion("ODT_BRAND in", values, "brand");
  476. return (Criteria) this;
  477. }
  478. public Criteria andBrandNotIn(List<String> values) {
  479. addCriterion("ODT_BRAND not in", values, "brand");
  480. return (Criteria) this;
  481. }
  482. public Criteria andBrandBetween(String value1, String value2) {
  483. addCriterion("ODT_BRAND between", value1, value2, "brand");
  484. return (Criteria) this;
  485. }
  486. public Criteria andBrandNotBetween(String value1, String value2) {
  487. addCriterion("ODT_BRAND not between", value1, value2, "brand");
  488. return (Criteria) this;
  489. }
  490. public Criteria andOriginCountryIsNull() {
  491. addCriterion("ODT_ORIGIN_COUNTRY is null");
  492. return (Criteria) this;
  493. }
  494. public Criteria andOriginCountryIsNotNull() {
  495. addCriterion("ODT_ORIGIN_COUNTRY is not null");
  496. return (Criteria) this;
  497. }
  498. public Criteria andOriginCountryEqualTo(String value) {
  499. if(value == null ){
  500. andOriginCountryIsNull();
  501. } else {
  502. addCriterion("ODT_ORIGIN_COUNTRY =", value, "originCountry");
  503. }
  504. return (Criteria) this;
  505. }
  506. public Criteria andOriginCountryNotEqualTo(String value) {
  507. if(value == null ){
  508. andOriginCountryIsNotNull();
  509. } else {
  510. addCriterion("ODT_ORIGIN_COUNTRY <>", value, "originCountry");
  511. }
  512. return (Criteria) this;
  513. }
  514. public Criteria andOriginCountryGreaterThan(String value) {
  515. addCriterion("ODT_ORIGIN_COUNTRY >", value, "originCountry");
  516. return (Criteria) this;
  517. }
  518. public Criteria andOriginCountryGreaterThanOrEqualTo(String value) {
  519. addCriterion("ODT_ORIGIN_COUNTRY >=", value, "originCountry");
  520. return (Criteria) this;
  521. }
  522. public Criteria andOriginCountryLessThan(String value) {
  523. addCriterion("ODT_ORIGIN_COUNTRY <", value, "originCountry");
  524. return (Criteria) this;
  525. }
  526. public Criteria andOriginCountryLessThanOrEqualTo(String value) {
  527. addCriterion("ODT_ORIGIN_COUNTRY <=", value, "originCountry");
  528. return (Criteria) this;
  529. }
  530. public Criteria andOriginCountryLike(String value) {
  531. addCriterion("ODT_ORIGIN_COUNTRY like", value, "originCountry");
  532. return (Criteria) this;
  533. }
  534. public Criteria andOriginCountryNotLike(String value) {
  535. addCriterion("ODT_ORIGIN_COUNTRY not like", value, "originCountry");
  536. return (Criteria) this;
  537. }
  538. public Criteria andOriginCountryIn(List<String> values) {
  539. addCriterion("ODT_ORIGIN_COUNTRY in", values, "originCountry");
  540. return (Criteria) this;
  541. }
  542. public Criteria andOriginCountryNotIn(List<String> values) {
  543. addCriterion("ODT_ORIGIN_COUNTRY not in", values, "originCountry");
  544. return (Criteria) this;
  545. }
  546. public Criteria andOriginCountryBetween(String value1, String value2) {
  547. addCriterion("ODT_ORIGIN_COUNTRY between", value1, value2, "originCountry");
  548. return (Criteria) this;
  549. }
  550. public Criteria andOriginCountryNotBetween(String value1, String value2) {
  551. addCriterion("ODT_ORIGIN_COUNTRY not between", value1, value2, "originCountry");
  552. return (Criteria) this;
  553. }
  554. public Criteria andNormsIsNull() {
  555. addCriterion("ODT_NORMS is null");
  556. return (Criteria) this;
  557. }
  558. public Criteria andNormsIsNotNull() {
  559. addCriterion("ODT_NORMS is not null");
  560. return (Criteria) this;
  561. }
  562. public Criteria andNormsEqualTo(String value) {
  563. if(value == null ){
  564. andNormsIsNull();
  565. } else {
  566. addCriterion("ODT_NORMS =", value, "norms");
  567. }
  568. return (Criteria) this;
  569. }
  570. public Criteria andNormsNotEqualTo(String value) {
  571. if(value == null ){
  572. andNormsIsNotNull();
  573. } else {
  574. addCriterion("ODT_NORMS <>", value, "norms");
  575. }
  576. return (Criteria) this;
  577. }
  578. public Criteria andNormsGreaterThan(String value) {
  579. addCriterion("ODT_NORMS >", value, "norms");
  580. return (Criteria) this;
  581. }
  582. public Criteria andNormsGreaterThanOrEqualTo(String value) {
  583. addCriterion("ODT_NORMS >=", value, "norms");
  584. return (Criteria) this;
  585. }
  586. public Criteria andNormsLessThan(String value) {
  587. addCriterion("ODT_NORMS <", value, "norms");
  588. return (Criteria) this;
  589. }
  590. public Criteria andNormsLessThanOrEqualTo(String value) {
  591. addCriterion("ODT_NORMS <=", value, "norms");
  592. return (Criteria) this;
  593. }
  594. public Criteria andNormsLike(String value) {
  595. addCriterion("ODT_NORMS like", value, "norms");
  596. return (Criteria) this;
  597. }
  598. public Criteria andNormsNotLike(String value) {
  599. addCriterion("ODT_NORMS not like", value, "norms");
  600. return (Criteria) this;
  601. }
  602. public Criteria andNormsIn(List<String> values) {
  603. addCriterion("ODT_NORMS in", values, "norms");
  604. return (Criteria) this;
  605. }
  606. public Criteria andNormsNotIn(List<String> values) {
  607. addCriterion("ODT_NORMS not in", values, "norms");
  608. return (Criteria) this;
  609. }
  610. public Criteria andNormsBetween(String value1, String value2) {
  611. addCriterion("ODT_NORMS between", value1, value2, "norms");
  612. return (Criteria) this;
  613. }
  614. public Criteria andNormsNotBetween(String value1, String value2) {
  615. addCriterion("ODT_NORMS not between", value1, value2, "norms");
  616. return (Criteria) this;
  617. }
  618. public Criteria andValidityIsNull() {
  619. addCriterion("ODT_VALIDITY is null");
  620. return (Criteria) this;
  621. }
  622. public Criteria andValidityIsNotNull() {
  623. addCriterion("ODT_VALIDITY is not null");
  624. return (Criteria) this;
  625. }
  626. public Criteria andValidityEqualTo(String value) {
  627. if(value == null ){
  628. andValidityIsNull();
  629. } else {
  630. addCriterion("ODT_VALIDITY =", value, "validity");
  631. }
  632. return (Criteria) this;
  633. }
  634. public Criteria andValidityNotEqualTo(String value) {
  635. if(value == null ){
  636. andValidityIsNotNull();
  637. } else {
  638. addCriterion("ODT_VALIDITY <>", value, "validity");
  639. }
  640. return (Criteria) this;
  641. }
  642. public Criteria andValidityGreaterThan(String value) {
  643. addCriterion("ODT_VALIDITY >", value, "validity");
  644. return (Criteria) this;
  645. }
  646. public Criteria andValidityGreaterThanOrEqualTo(String value) {
  647. addCriterion("ODT_VALIDITY >=", value, "validity");
  648. return (Criteria) this;
  649. }
  650. public Criteria andValidityLessThan(String value) {
  651. addCriterion("ODT_VALIDITY <", value, "validity");
  652. return (Criteria) this;
  653. }
  654. public Criteria andValidityLessThanOrEqualTo(String value) {
  655. addCriterion("ODT_VALIDITY <=", value, "validity");
  656. return (Criteria) this;
  657. }
  658. public Criteria andValidityLike(String value) {
  659. addCriterion("ODT_VALIDITY like", value, "validity");
  660. return (Criteria) this;
  661. }
  662. public Criteria andValidityNotLike(String value) {
  663. addCriterion("ODT_VALIDITY not like", value, "validity");
  664. return (Criteria) this;
  665. }
  666. public Criteria andValidityIn(List<String> values) {
  667. addCriterion("ODT_VALIDITY in", values, "validity");
  668. return (Criteria) this;
  669. }
  670. public Criteria andValidityNotIn(List<String> values) {
  671. addCriterion("ODT_VALIDITY not in", values, "validity");
  672. return (Criteria) this;
  673. }
  674. public Criteria andValidityBetween(String value1, String value2) {
  675. addCriterion("ODT_VALIDITY between", value1, value2, "validity");
  676. return (Criteria) this;
  677. }
  678. public Criteria andValidityNotBetween(String value1, String value2) {
  679. addCriterion("ODT_VALIDITY not between", value1, value2, "validity");
  680. return (Criteria) this;
  681. }
  682. public Criteria andPriceExitIsNull() {
  683. addCriterion("ODT_PRICE_EXIT is null");
  684. return (Criteria) this;
  685. }
  686. public Criteria andPriceExitIsNotNull() {
  687. addCriterion("ODT_PRICE_EXIT is not null");
  688. return (Criteria) this;
  689. }
  690. public Criteria andPriceExitEqualTo(String value) {
  691. if(value == null ){
  692. andPriceExitIsNull();
  693. } else {
  694. addCriterion("ODT_PRICE_EXIT =", value, "priceExit");
  695. }
  696. return (Criteria) this;
  697. }
  698. public Criteria andPriceExitNotEqualTo(String value) {
  699. if(value == null ){
  700. andPriceExitIsNotNull();
  701. } else {
  702. addCriterion("ODT_PRICE_EXIT <>", value, "priceExit");
  703. }
  704. return (Criteria) this;
  705. }
  706. public Criteria andPriceExitGreaterThan(String value) {
  707. addCriterion("ODT_PRICE_EXIT >", value, "priceExit");
  708. return (Criteria) this;
  709. }
  710. public Criteria andPriceExitGreaterThanOrEqualTo(String value) {
  711. addCriterion("ODT_PRICE_EXIT >=", value, "priceExit");
  712. return (Criteria) this;
  713. }
  714. public Criteria andPriceExitLessThan(String value) {
  715. addCriterion("ODT_PRICE_EXIT <", value, "priceExit");
  716. return (Criteria) this;
  717. }
  718. public Criteria andPriceExitLessThanOrEqualTo(String value) {
  719. addCriterion("ODT_PRICE_EXIT <=", value, "priceExit");
  720. return (Criteria) this;
  721. }
  722. public Criteria andPriceExitLike(String value) {
  723. addCriterion("ODT_PRICE_EXIT like", value, "priceExit");
  724. return (Criteria) this;
  725. }
  726. public Criteria andPriceExitNotLike(String value) {
  727. addCriterion("ODT_PRICE_EXIT not like", value, "priceExit");
  728. return (Criteria) this;
  729. }
  730. public Criteria andPriceExitIn(List<String> values) {
  731. addCriterion("ODT_PRICE_EXIT in", values, "priceExit");
  732. return (Criteria) this;
  733. }
  734. public Criteria andPriceExitNotIn(List<String> values) {
  735. addCriterion("ODT_PRICE_EXIT not in", values, "priceExit");
  736. return (Criteria) this;
  737. }
  738. public Criteria andPriceExitBetween(String value1, String value2) {
  739. addCriterion("ODT_PRICE_EXIT between", value1, value2, "priceExit");
  740. return (Criteria) this;
  741. }
  742. public Criteria andPriceExitNotBetween(String value1, String value2) {
  743. addCriterion("ODT_PRICE_EXIT not between", value1, value2, "priceExit");
  744. return (Criteria) this;
  745. }
  746. public Criteria andPriceCifIsNull() {
  747. addCriterion("ODT_PRICE_CIF is null");
  748. return (Criteria) this;
  749. }
  750. public Criteria andPriceCifIsNotNull() {
  751. addCriterion("ODT_PRICE_CIF is not null");
  752. return (Criteria) this;
  753. }
  754. public Criteria andPriceCifEqualTo(String value) {
  755. if(value == null ){
  756. andPriceCifIsNull();
  757. } else {
  758. addCriterion("ODT_PRICE_CIF =", value, "priceCif");
  759. }
  760. return (Criteria) this;
  761. }
  762. public Criteria andPriceCifNotEqualTo(String value) {
  763. if(value == null ){
  764. andPriceCifIsNotNull();
  765. } else {
  766. addCriterion("ODT_PRICE_CIF <>", value, "priceCif");
  767. }
  768. return (Criteria) this;
  769. }
  770. public Criteria andPriceCifGreaterThan(String value) {
  771. addCriterion("ODT_PRICE_CIF >", value, "priceCif");
  772. return (Criteria) this;
  773. }
  774. public Criteria andPriceCifGreaterThanOrEqualTo(String value) {
  775. addCriterion("ODT_PRICE_CIF >=", value, "priceCif");
  776. return (Criteria) this;
  777. }
  778. public Criteria andPriceCifLessThan(String value) {
  779. addCriterion("ODT_PRICE_CIF <", value, "priceCif");
  780. return (Criteria) this;
  781. }
  782. public Criteria andPriceCifLessThanOrEqualTo(String value) {
  783. addCriterion("ODT_PRICE_CIF <=", value, "priceCif");
  784. return (Criteria) this;
  785. }
  786. public Criteria andPriceCifLike(String value) {
  787. addCriterion("ODT_PRICE_CIF like", value, "priceCif");
  788. return (Criteria) this;
  789. }
  790. public Criteria andPriceCifNotLike(String value) {
  791. addCriterion("ODT_PRICE_CIF not like", value, "priceCif");
  792. return (Criteria) this;
  793. }
  794. public Criteria andPriceCifIn(List<String> values) {
  795. addCriterion("ODT_PRICE_CIF in", values, "priceCif");
  796. return (Criteria) this;
  797. }
  798. public Criteria andPriceCifNotIn(List<String> values) {
  799. addCriterion("ODT_PRICE_CIF not in", values, "priceCif");
  800. return (Criteria) this;
  801. }
  802. public Criteria andPriceCifBetween(String value1, String value2) {
  803. addCriterion("ODT_PRICE_CIF between", value1, value2, "priceCif");
  804. return (Criteria) this;
  805. }
  806. public Criteria andPriceCifNotBetween(String value1, String value2) {
  807. addCriterion("ODT_PRICE_CIF not between", value1, value2, "priceCif");
  808. return (Criteria) this;
  809. }
  810. public Criteria andPriceSaleIsNull() {
  811. addCriterion("ODT_PRICE_SALE is null");
  812. return (Criteria) this;
  813. }
  814. public Criteria andPriceSaleIsNotNull() {
  815. addCriterion("ODT_PRICE_SALE is not null");
  816. return (Criteria) this;
  817. }
  818. public Criteria andPriceSaleEqualTo(String value) {
  819. if(value == null ){
  820. andPriceSaleIsNull();
  821. } else {
  822. addCriterion("ODT_PRICE_SALE =", value, "priceSale");
  823. }
  824. return (Criteria) this;
  825. }
  826. public Criteria andPriceSaleNotEqualTo(String value) {
  827. if(value == null ){
  828. andPriceSaleIsNotNull();
  829. } else {
  830. addCriterion("ODT_PRICE_SALE <>", value, "priceSale");
  831. }
  832. return (Criteria) this;
  833. }
  834. public Criteria andPriceSaleGreaterThan(String value) {
  835. addCriterion("ODT_PRICE_SALE >", value, "priceSale");
  836. return (Criteria) this;
  837. }
  838. public Criteria andPriceSaleGreaterThanOrEqualTo(String value) {
  839. addCriterion("ODT_PRICE_SALE >=", value, "priceSale");
  840. return (Criteria) this;
  841. }
  842. public Criteria andPriceSaleLessThan(String value) {
  843. addCriterion("ODT_PRICE_SALE <", value, "priceSale");
  844. return (Criteria) this;
  845. }
  846. public Criteria andPriceSaleLessThanOrEqualTo(String value) {
  847. addCriterion("ODT_PRICE_SALE <=", value, "priceSale");
  848. return (Criteria) this;
  849. }
  850. public Criteria andPriceSaleLike(String value) {
  851. addCriterion("ODT_PRICE_SALE like", value, "priceSale");
  852. return (Criteria) this;
  853. }
  854. public Criteria andPriceSaleNotLike(String value) {
  855. addCriterion("ODT_PRICE_SALE not like", value, "priceSale");
  856. return (Criteria) this;
  857. }
  858. public Criteria andPriceSaleIn(List<String> values) {
  859. addCriterion("ODT_PRICE_SALE in", values, "priceSale");
  860. return (Criteria) this;
  861. }
  862. public Criteria andPriceSaleNotIn(List<String> values) {
  863. addCriterion("ODT_PRICE_SALE not in", values, "priceSale");
  864. return (Criteria) this;
  865. }
  866. public Criteria andPriceSaleBetween(String value1, String value2) {
  867. addCriterion("ODT_PRICE_SALE between", value1, value2, "priceSale");
  868. return (Criteria) this;
  869. }
  870. public Criteria andPriceSaleNotBetween(String value1, String value2) {
  871. addCriterion("ODT_PRICE_SALE not between", value1, value2, "priceSale");
  872. return (Criteria) this;
  873. }
  874. public Criteria andCountIsNull() {
  875. addCriterion("ODT_COUNT is null");
  876. return (Criteria) this;
  877. }
  878. public Criteria andCountIsNotNull() {
  879. addCriterion("ODT_COUNT is not null");
  880. return (Criteria) this;
  881. }
  882. public Criteria andCountEqualTo(String value) {
  883. if(value == null ){
  884. andCountIsNull();
  885. } else {
  886. addCriterion("ODT_COUNT =", value, "count");
  887. }
  888. return (Criteria) this;
  889. }
  890. public Criteria andCountNotEqualTo(String value) {
  891. if(value == null ){
  892. andCountIsNotNull();
  893. } else {
  894. addCriterion("ODT_COUNT <>", value, "count");
  895. }
  896. return (Criteria) this;
  897. }
  898. public Criteria andCountGreaterThan(String value) {
  899. addCriterion("ODT_COUNT >", value, "count");
  900. return (Criteria) this;
  901. }
  902. public Criteria andCountGreaterThanOrEqualTo(String value) {
  903. addCriterion("ODT_COUNT >=", value, "count");
  904. return (Criteria) this;
  905. }
  906. public Criteria andCountLessThan(String value) {
  907. addCriterion("ODT_COUNT <", value, "count");
  908. return (Criteria) this;
  909. }
  910. public Criteria andCountLessThanOrEqualTo(String value) {
  911. addCriterion("ODT_COUNT <=", value, "count");
  912. return (Criteria) this;
  913. }
  914. public Criteria andCountLike(String value) {
  915. addCriterion("ODT_COUNT like", value, "count");
  916. return (Criteria) this;
  917. }
  918. public Criteria andCountNotLike(String value) {
  919. addCriterion("ODT_COUNT not like", value, "count");
  920. return (Criteria) this;
  921. }
  922. public Criteria andCountIn(List<String> values) {
  923. addCriterion("ODT_COUNT in", values, "count");
  924. return (Criteria) this;
  925. }
  926. public Criteria andCountNotIn(List<String> values) {
  927. addCriterion("ODT_COUNT not in", values, "count");
  928. return (Criteria) this;
  929. }
  930. public Criteria andCountBetween(String value1, String value2) {
  931. addCriterion("ODT_COUNT between", value1, value2, "count");
  932. return (Criteria) this;
  933. }
  934. public Criteria andCountNotBetween(String value1, String value2) {
  935. addCriterion("ODT_COUNT not between", value1, value2, "count");
  936. return (Criteria) this;
  937. }
  938. public Criteria andSumAmtIsNull() {
  939. addCriterion("ODT_SUM_AMT is null");
  940. return (Criteria) this;
  941. }
  942. public Criteria andSumAmtIsNotNull() {
  943. addCriterion("ODT_SUM_AMT is not null");
  944. return (Criteria) this;
  945. }
  946. public Criteria andSumAmtEqualTo(String value) {
  947. if(value == null ){
  948. andSumAmtIsNull();
  949. } else {
  950. addCriterion("ODT_SUM_AMT =", value, "sumAmt");
  951. }
  952. return (Criteria) this;
  953. }
  954. public Criteria andSumAmtNotEqualTo(String value) {
  955. if(value == null ){
  956. andSumAmtIsNotNull();
  957. } else {
  958. addCriterion("ODT_SUM_AMT <>", value, "sumAmt");
  959. }
  960. return (Criteria) this;
  961. }
  962. public Criteria andSumAmtGreaterThan(String value) {
  963. addCriterion("ODT_SUM_AMT >", value, "sumAmt");
  964. return (Criteria) this;
  965. }
  966. public Criteria andSumAmtGreaterThanOrEqualTo(String value) {
  967. addCriterion("ODT_SUM_AMT >=", value, "sumAmt");
  968. return (Criteria) this;
  969. }
  970. public Criteria andSumAmtLessThan(String value) {
  971. addCriterion("ODT_SUM_AMT <", value, "sumAmt");
  972. return (Criteria) this;
  973. }
  974. public Criteria andSumAmtLessThanOrEqualTo(String value) {
  975. addCriterion("ODT_SUM_AMT <=", value, "sumAmt");
  976. return (Criteria) this;
  977. }
  978. public Criteria andSumAmtLike(String value) {
  979. addCriterion("ODT_SUM_AMT like", value, "sumAmt");
  980. return (Criteria) this;
  981. }
  982. public Criteria andSumAmtNotLike(String value) {
  983. addCriterion("ODT_SUM_AMT not like", value, "sumAmt");
  984. return (Criteria) this;
  985. }
  986. public Criteria andSumAmtIn(List<String> values) {
  987. addCriterion("ODT_SUM_AMT in", values, "sumAmt");
  988. return (Criteria) this;
  989. }
  990. public Criteria andSumAmtNotIn(List<String> values) {
  991. addCriterion("ODT_SUM_AMT not in", values, "sumAmt");
  992. return (Criteria) this;
  993. }
  994. public Criteria andSumAmtBetween(String value1, String value2) {
  995. addCriterion("ODT_SUM_AMT between", value1, value2, "sumAmt");
  996. return (Criteria) this;
  997. }
  998. public Criteria andSumAmtNotBetween(String value1, String value2) {
  999. addCriterion("ODT_SUM_AMT not between", value1, value2, "sumAmt");
  1000. return (Criteria) this;
  1001. }
  1002. public Criteria andMarginLevelIsNull() {
  1003. addCriterion("ODT_Margin_level is null");
  1004. return (Criteria) this;
  1005. }
  1006. public Criteria andMarginLevelIsNotNull() {
  1007. addCriterion("ODT_Margin_level is not null");
  1008. return (Criteria) this;
  1009. }
  1010. public Criteria andMarginLevelEqualTo(String value) {
  1011. if(value == null ){
  1012. andMarginLevelIsNull();
  1013. } else {
  1014. addCriterion("ODT_Margin_level =", value, "marginLevel");
  1015. }
  1016. return (Criteria) this;
  1017. }
  1018. public Criteria andMarginLevelNotEqualTo(String value) {
  1019. if(value == null ){
  1020. andMarginLevelIsNotNull();
  1021. } else {
  1022. addCriterion("ODT_Margin_level <>", value, "marginLevel");
  1023. }
  1024. return (Criteria) this;
  1025. }
  1026. public Criteria andMarginLevelGreaterThan(String value) {
  1027. addCriterion("ODT_Margin_level >", value, "marginLevel");
  1028. return (Criteria) this;
  1029. }
  1030. public Criteria andMarginLevelGreaterThanOrEqualTo(String value) {
  1031. addCriterion("ODT_Margin_level >=", value, "marginLevel");
  1032. return (Criteria) this;
  1033. }
  1034. public Criteria andMarginLevelLessThan(String value) {
  1035. addCriterion("ODT_Margin_level <", value, "marginLevel");
  1036. return (Criteria) this;
  1037. }
  1038. public Criteria andMarginLevelLessThanOrEqualTo(String value) {
  1039. addCriterion("ODT_Margin_level <=", value, "marginLevel");
  1040. return (Criteria) this;
  1041. }
  1042. public Criteria andMarginLevelLike(String value) {
  1043. addCriterion("ODT_Margin_level like", value, "marginLevel");
  1044. return (Criteria) this;
  1045. }
  1046. public Criteria andMarginLevelNotLike(String value) {
  1047. addCriterion("ODT_Margin_level not like", value, "marginLevel");
  1048. return (Criteria) this;
  1049. }
  1050. public Criteria andMarginLevelIn(List<String> values) {
  1051. addCriterion("ODT_Margin_level in", values, "marginLevel");
  1052. return (Criteria) this;
  1053. }
  1054. public Criteria andMarginLevelNotIn(List<String> values) {
  1055. addCriterion("ODT_Margin_level not in", values, "marginLevel");
  1056. return (Criteria) this;
  1057. }
  1058. public Criteria andMarginLevelBetween(String value1, String value2) {
  1059. addCriterion("ODT_Margin_level between", value1, value2, "marginLevel");
  1060. return (Criteria) this;
  1061. }
  1062. public Criteria andMarginLevelNotBetween(String value1, String value2) {
  1063. addCriterion("ODT_Margin_level not between", value1, value2, "marginLevel");
  1064. return (Criteria) this;
  1065. }
  1066. }
  1067. /**
  1068. * This class was generated by MyBatis Generator.
  1069. * This class corresponds to the database table tp_order_detail
  1070. *
  1071. * @mbggenerated do_not_delete_during_merge
  1072. */
  1073. public static class Criteria extends GeneratedCriteria {
  1074. protected Criteria() {
  1075. super();
  1076. }
  1077. }
  1078. /**
  1079. * This class was generated by MyBatis Generator.
  1080. * This class corresponds to the database table tp_order_detail
  1081. *
  1082. * @mbggenerated
  1083. */
  1084. public static class Criterion {
  1085. private String condition;
  1086. private Object value;
  1087. private Object secondValue;
  1088. private boolean noValue;
  1089. private boolean singleValue;
  1090. private boolean betweenValue;
  1091. private boolean listValue;
  1092. public String getCondition() {
  1093. return condition;
  1094. }
  1095. public Object getValue() {
  1096. return value;
  1097. }
  1098. public Object getSecondValue() {
  1099. return secondValue;
  1100. }
  1101. public boolean isNoValue() {
  1102. return noValue;
  1103. }
  1104. public boolean isSingleValue() {
  1105. return singleValue;
  1106. }
  1107. public boolean isBetweenValue() {
  1108. return betweenValue;
  1109. }
  1110. public boolean isListValue() {
  1111. return listValue;
  1112. }
  1113. protected Criterion(String condition) {
  1114. super();
  1115. this.condition = condition;
  1116. this.noValue = true;
  1117. }
  1118. protected Criterion(String condition, Object value) {
  1119. super();
  1120. this.condition = condition;
  1121. this.value = value;
  1122. if (value instanceof List<?>) {
  1123. this.listValue = true;
  1124. } else {
  1125. this.singleValue = true;
  1126. }
  1127. }
  1128. protected Criterion(String condition, Object value, Object secondValue) {
  1129. super();
  1130. this.condition = condition;
  1131. this.value = value;
  1132. this.secondValue = secondValue;
  1133. this.betweenValue = true;
  1134. }
  1135. }
  1136. }