1 package jp.sourceforge.ea2ddl.dao.cbean.cq.bs;
\r
3 import java.util.Collection;
\r
5 import org.seasar.dbflute.cbean.*;
\r
6 import org.seasar.dbflute.cbean.ckey.*;
\r
7 import org.seasar.dbflute.cbean.coption.*;
\r
8 import org.seasar.dbflute.cbean.cvalue.ConditionValue;
\r
9 import org.seasar.dbflute.cbean.sqlclause.SqlClause;
\r
10 import org.seasar.dbflute.dbmeta.DBMetaProvider;
\r
11 import jp.sourceforge.ea2ddl.dao.allcommon.*;
\r
12 import jp.sourceforge.ea2ddl.dao.cbean.*;
\r
13 import jp.sourceforge.ea2ddl.dao.cbean.cq.*;
\r
16 * The abstract condition-query of t_clients.
\r
17 * @author DBFlute(AutoGenerator)
\r
19 public abstract class AbstractBsTClientsCQ extends AbstractConditionQuery {
\r
21 // ===================================================================================
\r
24 protected final DBMetaProvider _dbmetaProvider = new DBMetaInstanceHandler();
\r
26 // ===================================================================================
\r
29 public AbstractBsTClientsCQ(ConditionQuery childQuery, SqlClause sqlClause, String aliasName, int nestLevel) {
\r
30 super(childQuery, sqlClause, aliasName, nestLevel);
\r
33 // ===================================================================================
\r
37 protected DBMetaProvider getDBMetaProvider() {
\r
38 return _dbmetaProvider;
\r
41 // ===================================================================================
\r
44 public String getTableDbName() {
\r
48 public String getTableSqlName() {
\r
52 // ===================================================================================
\r
57 * Equal(=). And NullOrEmptyIgnored, OnlyOnceRegistered. {UQ : VARCHAR(255)}
\r
58 * @param name The value of name as equal.
\r
60 public void setName_Equal(String name) {
\r
61 regName(CK_EQ, fRES(name));
\r
65 * NotEqual(!=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
66 * @param name The value of name as notEqual.
\r
68 public void setName_NotEqual(String name) {
\r
69 regName(CK_NE, fRES(name));
\r
73 * GreaterThan(>). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
74 * @param name The value of name as greaterThan.
\r
76 public void setName_GreaterThan(String name) {
\r
77 regName(CK_GT, fRES(name));
\r
81 * LessThan(<). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
82 * @param name The value of name as lessThan.
\r
84 public void setName_LessThan(String name) {
\r
85 regName(CK_LT, fRES(name));
\r
89 * GreaterEqual(>=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
90 * @param name The value of name as greaterEqual.
\r
92 public void setName_GreaterEqual(String name) {
\r
93 regName(CK_GE, fRES(name));
\r
97 * LessEqual(<=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
98 * @param name The value of name as lessEqual.
\r
100 public void setName_LessEqual(String name) {
\r
101 regName(CK_LE, fRES(name));
\r
105 * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
106 * @param name The value of name as prefixSearch.
\r
108 public void setName_PrefixSearch(String name) {
\r
109 regName(CK_PS, fRES(name));
\r
113 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
114 * @param nameList The collection of name as inScope.
\r
116 public void setName_InScope(Collection<String> nameList) {
\r
117 regName(CK_INS, cTL(nameList));
\r
121 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
122 * @param name The value of name as likeSearch.
\r
123 * @param likeSearchOption The option of like-search. (NotNull)
\r
125 public void setName_LikeSearch(String name, LikeSearchOption likeSearchOption) {
\r
126 regLSQ(CK_LS, fRES(name), getCValueName(), "Name", likeSearchOption);
\r
130 * NotLikeSearch(not like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
131 * @param name The value of name as notLikeSearch.
\r
132 * @param likeSearchOption The option of not-like-search. (NotNull)
\r
134 public void setName_NotLikeSearch(String name, LikeSearchOption likeSearchOption) {
\r
135 regLSQ(CK_NLS, fRES(name), getCValueName(), "Name", likeSearchOption);
\r
139 * IsNull(is null). And OnlyOnceRegistered.
\r
141 public void setName_IsNull() { regName(CK_ISN, DOBJ); }
\r
144 * IsNotNull(is not null). And OnlyOnceRegistered.
\r
146 public void setName_IsNotNull() { regName(CK_ISNN, DOBJ); }
\r
148 protected void regName(ConditionKey k, Object v) { regQ(k, v, getCValueName(), "Name"); }
\r
149 abstract protected ConditionValue getCValueName();
\r
152 * Equal(=). And NullOrEmptyIgnored, OnlyOnceRegistered. {VARCHAR(255)}
\r
153 * @param organisation The value of organisation as equal.
\r
155 public void setOrganisation_Equal(String organisation) {
\r
156 regOrganisation(CK_EQ, fRES(organisation));
\r
160 * NotEqual(!=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
161 * @param organisation The value of organisation as notEqual.
\r
163 public void setOrganisation_NotEqual(String organisation) {
\r
164 regOrganisation(CK_NE, fRES(organisation));
\r
168 * GreaterThan(>). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
169 * @param organisation The value of organisation as greaterThan.
\r
171 public void setOrganisation_GreaterThan(String organisation) {
\r
172 regOrganisation(CK_GT, fRES(organisation));
\r
176 * LessThan(<). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
177 * @param organisation The value of organisation as lessThan.
\r
179 public void setOrganisation_LessThan(String organisation) {
\r
180 regOrganisation(CK_LT, fRES(organisation));
\r
184 * GreaterEqual(>=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
185 * @param organisation The value of organisation as greaterEqual.
\r
187 public void setOrganisation_GreaterEqual(String organisation) {
\r
188 regOrganisation(CK_GE, fRES(organisation));
\r
192 * LessEqual(<=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
193 * @param organisation The value of organisation as lessEqual.
\r
195 public void setOrganisation_LessEqual(String organisation) {
\r
196 regOrganisation(CK_LE, fRES(organisation));
\r
200 * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
201 * @param organisation The value of organisation as prefixSearch.
\r
203 public void setOrganisation_PrefixSearch(String organisation) {
\r
204 regOrganisation(CK_PS, fRES(organisation));
\r
208 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
209 * @param organisationList The collection of organisation as inScope.
\r
211 public void setOrganisation_InScope(Collection<String> organisationList) {
\r
212 regOrganisation(CK_INS, cTL(organisationList));
\r
216 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
217 * @param organisation The value of organisation as likeSearch.
\r
218 * @param likeSearchOption The option of like-search. (NotNull)
\r
220 public void setOrganisation_LikeSearch(String organisation, LikeSearchOption likeSearchOption) {
\r
221 regLSQ(CK_LS, fRES(organisation), getCValueOrganisation(), "Organisation", likeSearchOption);
\r
225 * NotLikeSearch(not like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
226 * @param organisation The value of organisation as notLikeSearch.
\r
227 * @param likeSearchOption The option of not-like-search. (NotNull)
\r
229 public void setOrganisation_NotLikeSearch(String organisation, LikeSearchOption likeSearchOption) {
\r
230 regLSQ(CK_NLS, fRES(organisation), getCValueOrganisation(), "Organisation", likeSearchOption);
\r
234 * IsNull(is null). And OnlyOnceRegistered.
\r
236 public void setOrganisation_IsNull() { regOrganisation(CK_ISN, DOBJ); }
\r
239 * IsNotNull(is not null). And OnlyOnceRegistered.
\r
241 public void setOrganisation_IsNotNull() { regOrganisation(CK_ISNN, DOBJ); }
\r
243 protected void regOrganisation(ConditionKey k, Object v) { regQ(k, v, getCValueOrganisation(), "Organisation"); }
\r
244 abstract protected ConditionValue getCValueOrganisation();
\r
247 * Equal(=). And NullOrEmptyIgnored, OnlyOnceRegistered. {VARCHAR(50)}
\r
248 * @param phone1 The value of phone1 as equal.
\r
250 public void setPhone1_Equal(String phone1) {
\r
251 regPhone1(CK_EQ, fRES(phone1));
\r
255 * NotEqual(!=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
256 * @param phone1 The value of phone1 as notEqual.
\r
258 public void setPhone1_NotEqual(String phone1) {
\r
259 regPhone1(CK_NE, fRES(phone1));
\r
263 * GreaterThan(>). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
264 * @param phone1 The value of phone1 as greaterThan.
\r
266 public void setPhone1_GreaterThan(String phone1) {
\r
267 regPhone1(CK_GT, fRES(phone1));
\r
271 * LessThan(<). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
272 * @param phone1 The value of phone1 as lessThan.
\r
274 public void setPhone1_LessThan(String phone1) {
\r
275 regPhone1(CK_LT, fRES(phone1));
\r
279 * GreaterEqual(>=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
280 * @param phone1 The value of phone1 as greaterEqual.
\r
282 public void setPhone1_GreaterEqual(String phone1) {
\r
283 regPhone1(CK_GE, fRES(phone1));
\r
287 * LessEqual(<=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
288 * @param phone1 The value of phone1 as lessEqual.
\r
290 public void setPhone1_LessEqual(String phone1) {
\r
291 regPhone1(CK_LE, fRES(phone1));
\r
295 * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
296 * @param phone1 The value of phone1 as prefixSearch.
\r
298 public void setPhone1_PrefixSearch(String phone1) {
\r
299 regPhone1(CK_PS, fRES(phone1));
\r
303 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
304 * @param phone1List The collection of phone1 as inScope.
\r
306 public void setPhone1_InScope(Collection<String> phone1List) {
\r
307 regPhone1(CK_INS, cTL(phone1List));
\r
311 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
312 * @param phone1 The value of phone1 as likeSearch.
\r
313 * @param likeSearchOption The option of like-search. (NotNull)
\r
315 public void setPhone1_LikeSearch(String phone1, LikeSearchOption likeSearchOption) {
\r
316 regLSQ(CK_LS, fRES(phone1), getCValuePhone1(), "Phone1", likeSearchOption);
\r
320 * NotLikeSearch(not like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
321 * @param phone1 The value of phone1 as notLikeSearch.
\r
322 * @param likeSearchOption The option of not-like-search. (NotNull)
\r
324 public void setPhone1_NotLikeSearch(String phone1, LikeSearchOption likeSearchOption) {
\r
325 regLSQ(CK_NLS, fRES(phone1), getCValuePhone1(), "Phone1", likeSearchOption);
\r
329 * IsNull(is null). And OnlyOnceRegistered.
\r
331 public void setPhone1_IsNull() { regPhone1(CK_ISN, DOBJ); }
\r
334 * IsNotNull(is not null). And OnlyOnceRegistered.
\r
336 public void setPhone1_IsNotNull() { regPhone1(CK_ISNN, DOBJ); }
\r
338 protected void regPhone1(ConditionKey k, Object v) { regQ(k, v, getCValuePhone1(), "Phone1"); }
\r
339 abstract protected ConditionValue getCValuePhone1();
\r
342 * Equal(=). And NullOrEmptyIgnored, OnlyOnceRegistered. {VARCHAR(50)}
\r
343 * @param phone2 The value of phone2 as equal.
\r
345 public void setPhone2_Equal(String phone2) {
\r
346 regPhone2(CK_EQ, fRES(phone2));
\r
350 * NotEqual(!=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
351 * @param phone2 The value of phone2 as notEqual.
\r
353 public void setPhone2_NotEqual(String phone2) {
\r
354 regPhone2(CK_NE, fRES(phone2));
\r
358 * GreaterThan(>). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
359 * @param phone2 The value of phone2 as greaterThan.
\r
361 public void setPhone2_GreaterThan(String phone2) {
\r
362 regPhone2(CK_GT, fRES(phone2));
\r
366 * LessThan(<). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
367 * @param phone2 The value of phone2 as lessThan.
\r
369 public void setPhone2_LessThan(String phone2) {
\r
370 regPhone2(CK_LT, fRES(phone2));
\r
374 * GreaterEqual(>=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
375 * @param phone2 The value of phone2 as greaterEqual.
\r
377 public void setPhone2_GreaterEqual(String phone2) {
\r
378 regPhone2(CK_GE, fRES(phone2));
\r
382 * LessEqual(<=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
383 * @param phone2 The value of phone2 as lessEqual.
\r
385 public void setPhone2_LessEqual(String phone2) {
\r
386 regPhone2(CK_LE, fRES(phone2));
\r
390 * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
391 * @param phone2 The value of phone2 as prefixSearch.
\r
393 public void setPhone2_PrefixSearch(String phone2) {
\r
394 regPhone2(CK_PS, fRES(phone2));
\r
398 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
399 * @param phone2List The collection of phone2 as inScope.
\r
401 public void setPhone2_InScope(Collection<String> phone2List) {
\r
402 regPhone2(CK_INS, cTL(phone2List));
\r
406 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
407 * @param phone2 The value of phone2 as likeSearch.
\r
408 * @param likeSearchOption The option of like-search. (NotNull)
\r
410 public void setPhone2_LikeSearch(String phone2, LikeSearchOption likeSearchOption) {
\r
411 regLSQ(CK_LS, fRES(phone2), getCValuePhone2(), "Phone2", likeSearchOption);
\r
415 * NotLikeSearch(not like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
416 * @param phone2 The value of phone2 as notLikeSearch.
\r
417 * @param likeSearchOption The option of not-like-search. (NotNull)
\r
419 public void setPhone2_NotLikeSearch(String phone2, LikeSearchOption likeSearchOption) {
\r
420 regLSQ(CK_NLS, fRES(phone2), getCValuePhone2(), "Phone2", likeSearchOption);
\r
424 * IsNull(is null). And OnlyOnceRegistered.
\r
426 public void setPhone2_IsNull() { regPhone2(CK_ISN, DOBJ); }
\r
429 * IsNotNull(is not null). And OnlyOnceRegistered.
\r
431 public void setPhone2_IsNotNull() { regPhone2(CK_ISNN, DOBJ); }
\r
433 protected void regPhone2(ConditionKey k, Object v) { regQ(k, v, getCValuePhone2(), "Phone2"); }
\r
434 abstract protected ConditionValue getCValuePhone2();
\r
437 * Equal(=). And NullOrEmptyIgnored, OnlyOnceRegistered. {VARCHAR(50)}
\r
438 * @param mobile The value of mobile as equal.
\r
440 public void setMobile_Equal(String mobile) {
\r
441 regMobile(CK_EQ, fRES(mobile));
\r
445 * NotEqual(!=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
446 * @param mobile The value of mobile as notEqual.
\r
448 public void setMobile_NotEqual(String mobile) {
\r
449 regMobile(CK_NE, fRES(mobile));
\r
453 * GreaterThan(>). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
454 * @param mobile The value of mobile as greaterThan.
\r
456 public void setMobile_GreaterThan(String mobile) {
\r
457 regMobile(CK_GT, fRES(mobile));
\r
461 * LessThan(<). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
462 * @param mobile The value of mobile as lessThan.
\r
464 public void setMobile_LessThan(String mobile) {
\r
465 regMobile(CK_LT, fRES(mobile));
\r
469 * GreaterEqual(>=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
470 * @param mobile The value of mobile as greaterEqual.
\r
472 public void setMobile_GreaterEqual(String mobile) {
\r
473 regMobile(CK_GE, fRES(mobile));
\r
477 * LessEqual(<=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
478 * @param mobile The value of mobile as lessEqual.
\r
480 public void setMobile_LessEqual(String mobile) {
\r
481 regMobile(CK_LE, fRES(mobile));
\r
485 * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
486 * @param mobile The value of mobile as prefixSearch.
\r
488 public void setMobile_PrefixSearch(String mobile) {
\r
489 regMobile(CK_PS, fRES(mobile));
\r
493 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
494 * @param mobileList The collection of mobile as inScope.
\r
496 public void setMobile_InScope(Collection<String> mobileList) {
\r
497 regMobile(CK_INS, cTL(mobileList));
\r
501 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
502 * @param mobile The value of mobile as likeSearch.
\r
503 * @param likeSearchOption The option of like-search. (NotNull)
\r
505 public void setMobile_LikeSearch(String mobile, LikeSearchOption likeSearchOption) {
\r
506 regLSQ(CK_LS, fRES(mobile), getCValueMobile(), "Mobile", likeSearchOption);
\r
510 * NotLikeSearch(not like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
511 * @param mobile The value of mobile as notLikeSearch.
\r
512 * @param likeSearchOption The option of not-like-search. (NotNull)
\r
514 public void setMobile_NotLikeSearch(String mobile, LikeSearchOption likeSearchOption) {
\r
515 regLSQ(CK_NLS, fRES(mobile), getCValueMobile(), "Mobile", likeSearchOption);
\r
519 * IsNull(is null). And OnlyOnceRegistered.
\r
521 public void setMobile_IsNull() { regMobile(CK_ISN, DOBJ); }
\r
524 * IsNotNull(is not null). And OnlyOnceRegistered.
\r
526 public void setMobile_IsNotNull() { regMobile(CK_ISNN, DOBJ); }
\r
528 protected void regMobile(ConditionKey k, Object v) { regQ(k, v, getCValueMobile(), "Mobile"); }
\r
529 abstract protected ConditionValue getCValueMobile();
\r
532 * Equal(=). And NullOrEmptyIgnored, OnlyOnceRegistered. {VARCHAR(50)}
\r
533 * @param fax The value of fax as equal.
\r
535 public void setFax_Equal(String fax) {
\r
536 regFax(CK_EQ, fRES(fax));
\r
540 * NotEqual(!=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
541 * @param fax The value of fax as notEqual.
\r
543 public void setFax_NotEqual(String fax) {
\r
544 regFax(CK_NE, fRES(fax));
\r
548 * GreaterThan(>). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
549 * @param fax The value of fax as greaterThan.
\r
551 public void setFax_GreaterThan(String fax) {
\r
552 regFax(CK_GT, fRES(fax));
\r
556 * LessThan(<). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
557 * @param fax The value of fax as lessThan.
\r
559 public void setFax_LessThan(String fax) {
\r
560 regFax(CK_LT, fRES(fax));
\r
564 * GreaterEqual(>=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
565 * @param fax The value of fax as greaterEqual.
\r
567 public void setFax_GreaterEqual(String fax) {
\r
568 regFax(CK_GE, fRES(fax));
\r
572 * LessEqual(<=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
573 * @param fax The value of fax as lessEqual.
\r
575 public void setFax_LessEqual(String fax) {
\r
576 regFax(CK_LE, fRES(fax));
\r
580 * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
581 * @param fax The value of fax as prefixSearch.
\r
583 public void setFax_PrefixSearch(String fax) {
\r
584 regFax(CK_PS, fRES(fax));
\r
588 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
589 * @param faxList The collection of fax as inScope.
\r
591 public void setFax_InScope(Collection<String> faxList) {
\r
592 regFax(CK_INS, cTL(faxList));
\r
596 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
597 * @param fax The value of fax as likeSearch.
\r
598 * @param likeSearchOption The option of like-search. (NotNull)
\r
600 public void setFax_LikeSearch(String fax, LikeSearchOption likeSearchOption) {
\r
601 regLSQ(CK_LS, fRES(fax), getCValueFax(), "Fax", likeSearchOption);
\r
605 * NotLikeSearch(not like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
606 * @param fax The value of fax as notLikeSearch.
\r
607 * @param likeSearchOption The option of not-like-search. (NotNull)
\r
609 public void setFax_NotLikeSearch(String fax, LikeSearchOption likeSearchOption) {
\r
610 regLSQ(CK_NLS, fRES(fax), getCValueFax(), "Fax", likeSearchOption);
\r
614 * IsNull(is null). And OnlyOnceRegistered.
\r
616 public void setFax_IsNull() { regFax(CK_ISN, DOBJ); }
\r
619 * IsNotNull(is not null). And OnlyOnceRegistered.
\r
621 public void setFax_IsNotNull() { regFax(CK_ISNN, DOBJ); }
\r
623 protected void regFax(ConditionKey k, Object v) { regQ(k, v, getCValueFax(), "Fax"); }
\r
624 abstract protected ConditionValue getCValueFax();
\r
627 * Equal(=). And NullOrEmptyIgnored, OnlyOnceRegistered. {VARCHAR(50)}
\r
628 * @param email The value of email as equal.
\r
630 public void setEmail_Equal(String email) {
\r
631 regEmail(CK_EQ, fRES(email));
\r
635 * NotEqual(!=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
636 * @param email The value of email as notEqual.
\r
638 public void setEmail_NotEqual(String email) {
\r
639 regEmail(CK_NE, fRES(email));
\r
643 * GreaterThan(>). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
644 * @param email The value of email as greaterThan.
\r
646 public void setEmail_GreaterThan(String email) {
\r
647 regEmail(CK_GT, fRES(email));
\r
651 * LessThan(<). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
652 * @param email The value of email as lessThan.
\r
654 public void setEmail_LessThan(String email) {
\r
655 regEmail(CK_LT, fRES(email));
\r
659 * GreaterEqual(>=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
660 * @param email The value of email as greaterEqual.
\r
662 public void setEmail_GreaterEqual(String email) {
\r
663 regEmail(CK_GE, fRES(email));
\r
667 * LessEqual(<=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
668 * @param email The value of email as lessEqual.
\r
670 public void setEmail_LessEqual(String email) {
\r
671 regEmail(CK_LE, fRES(email));
\r
675 * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
676 * @param email The value of email as prefixSearch.
\r
678 public void setEmail_PrefixSearch(String email) {
\r
679 regEmail(CK_PS, fRES(email));
\r
683 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
684 * @param emailList The collection of email as inScope.
\r
686 public void setEmail_InScope(Collection<String> emailList) {
\r
687 regEmail(CK_INS, cTL(emailList));
\r
691 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
692 * @param email The value of email as likeSearch.
\r
693 * @param likeSearchOption The option of like-search. (NotNull)
\r
695 public void setEmail_LikeSearch(String email, LikeSearchOption likeSearchOption) {
\r
696 regLSQ(CK_LS, fRES(email), getCValueEmail(), "Email", likeSearchOption);
\r
700 * NotLikeSearch(not like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
701 * @param email The value of email as notLikeSearch.
\r
702 * @param likeSearchOption The option of not-like-search. (NotNull)
\r
704 public void setEmail_NotLikeSearch(String email, LikeSearchOption likeSearchOption) {
\r
705 regLSQ(CK_NLS, fRES(email), getCValueEmail(), "Email", likeSearchOption);
\r
709 * IsNull(is null). And OnlyOnceRegistered.
\r
711 public void setEmail_IsNull() { regEmail(CK_ISN, DOBJ); }
\r
714 * IsNotNull(is not null). And OnlyOnceRegistered.
\r
716 public void setEmail_IsNotNull() { regEmail(CK_ISNN, DOBJ); }
\r
718 protected void regEmail(ConditionKey k, Object v) { regQ(k, v, getCValueEmail(), "Email"); }
\r
719 abstract protected ConditionValue getCValueEmail();
\r
722 * Equal(=). And NullOrEmptyIgnored, OnlyOnceRegistered. {VARCHAR(255)}
\r
723 * @param roles The value of roles as equal.
\r
725 public void setRoles_Equal(String roles) {
\r
726 regRoles(CK_EQ, fRES(roles));
\r
730 * NotEqual(!=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
731 * @param roles The value of roles as notEqual.
\r
733 public void setRoles_NotEqual(String roles) {
\r
734 regRoles(CK_NE, fRES(roles));
\r
738 * GreaterThan(>). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
739 * @param roles The value of roles as greaterThan.
\r
741 public void setRoles_GreaterThan(String roles) {
\r
742 regRoles(CK_GT, fRES(roles));
\r
746 * LessThan(<). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
747 * @param roles The value of roles as lessThan.
\r
749 public void setRoles_LessThan(String roles) {
\r
750 regRoles(CK_LT, fRES(roles));
\r
754 * GreaterEqual(>=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
755 * @param roles The value of roles as greaterEqual.
\r
757 public void setRoles_GreaterEqual(String roles) {
\r
758 regRoles(CK_GE, fRES(roles));
\r
762 * LessEqual(<=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
763 * @param roles The value of roles as lessEqual.
\r
765 public void setRoles_LessEqual(String roles) {
\r
766 regRoles(CK_LE, fRES(roles));
\r
770 * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
771 * @param roles The value of roles as prefixSearch.
\r
773 public void setRoles_PrefixSearch(String roles) {
\r
774 regRoles(CK_PS, fRES(roles));
\r
778 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
779 * @param rolesList The collection of roles as inScope.
\r
781 public void setRoles_InScope(Collection<String> rolesList) {
\r
782 regRoles(CK_INS, cTL(rolesList));
\r
786 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
787 * @param roles The value of roles as likeSearch.
\r
788 * @param likeSearchOption The option of like-search. (NotNull)
\r
790 public void setRoles_LikeSearch(String roles, LikeSearchOption likeSearchOption) {
\r
791 regLSQ(CK_LS, fRES(roles), getCValueRoles(), "Roles", likeSearchOption);
\r
795 * NotLikeSearch(not like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
796 * @param roles The value of roles as notLikeSearch.
\r
797 * @param likeSearchOption The option of not-like-search. (NotNull)
\r
799 public void setRoles_NotLikeSearch(String roles, LikeSearchOption likeSearchOption) {
\r
800 regLSQ(CK_NLS, fRES(roles), getCValueRoles(), "Roles", likeSearchOption);
\r
804 * IsNull(is null). And OnlyOnceRegistered.
\r
806 public void setRoles_IsNull() { regRoles(CK_ISN, DOBJ); }
\r
809 * IsNotNull(is not null). And OnlyOnceRegistered.
\r
811 public void setRoles_IsNotNull() { regRoles(CK_ISNN, DOBJ); }
\r
813 protected void regRoles(ConditionKey k, Object v) { regQ(k, v, getCValueRoles(), "Roles"); }
\r
814 abstract protected ConditionValue getCValueRoles();
\r
817 * Equal(=). And NullOrEmptyIgnored, OnlyOnceRegistered. {VARCHAR(255)}
\r
818 * @param notes The value of notes as equal.
\r
820 public void setNotes_Equal(String notes) {
\r
821 regNotes(CK_EQ, fRES(notes));
\r
825 * NotEqual(!=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
826 * @param notes The value of notes as notEqual.
\r
828 public void setNotes_NotEqual(String notes) {
\r
829 regNotes(CK_NE, fRES(notes));
\r
833 * GreaterThan(>). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
834 * @param notes The value of notes as greaterThan.
\r
836 public void setNotes_GreaterThan(String notes) {
\r
837 regNotes(CK_GT, fRES(notes));
\r
841 * LessThan(<). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
842 * @param notes The value of notes as lessThan.
\r
844 public void setNotes_LessThan(String notes) {
\r
845 regNotes(CK_LT, fRES(notes));
\r
849 * GreaterEqual(>=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
850 * @param notes The value of notes as greaterEqual.
\r
852 public void setNotes_GreaterEqual(String notes) {
\r
853 regNotes(CK_GE, fRES(notes));
\r
857 * LessEqual(<=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
858 * @param notes The value of notes as lessEqual.
\r
860 public void setNotes_LessEqual(String notes) {
\r
861 regNotes(CK_LE, fRES(notes));
\r
865 * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
866 * @param notes The value of notes as prefixSearch.
\r
868 public void setNotes_PrefixSearch(String notes) {
\r
869 regNotes(CK_PS, fRES(notes));
\r
873 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
874 * @param notesList The collection of notes as inScope.
\r
876 public void setNotes_InScope(Collection<String> notesList) {
\r
877 regNotes(CK_INS, cTL(notesList));
\r
881 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
882 * @param notes The value of notes as likeSearch.
\r
883 * @param likeSearchOption The option of like-search. (NotNull)
\r
885 public void setNotes_LikeSearch(String notes, LikeSearchOption likeSearchOption) {
\r
886 regLSQ(CK_LS, fRES(notes), getCValueNotes(), "Notes", likeSearchOption);
\r
890 * NotLikeSearch(not like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
891 * @param notes The value of notes as notLikeSearch.
\r
892 * @param likeSearchOption The option of not-like-search. (NotNull)
\r
894 public void setNotes_NotLikeSearch(String notes, LikeSearchOption likeSearchOption) {
\r
895 regLSQ(CK_NLS, fRES(notes), getCValueNotes(), "Notes", likeSearchOption);
\r
899 * IsNull(is null). And OnlyOnceRegistered.
\r
901 public void setNotes_IsNull() { regNotes(CK_ISN, DOBJ); }
\r
904 * IsNotNull(is not null). And OnlyOnceRegistered.
\r
906 public void setNotes_IsNotNull() { regNotes(CK_ISNN, DOBJ); }
\r
908 protected void regNotes(ConditionKey k, Object v) { regQ(k, v, getCValueNotes(), "Notes"); }
\r
909 abstract protected ConditionValue getCValueNotes();
\r
911 // ===================================================================================
\r
914 // Very Internal (for Suppressing Warn about 'Not Use Import')
\r
915 String xCB() { return TClientsCB.class.getName(); }
\r
916 String xCQ() { return TClientsCQ.class.getName(); }
\r
917 String xLSO() { return LikeSearchOption.class.getName(); }
\r