1 package jp.sourceforge.ea2ddl.dao.cbean.cq.bs;
\r
3 import java.util.Collection;
\r
5 import jp.sourceforge.ea2ddl.dao.allcommon.cbean.*;
\r
6 import jp.sourceforge.ea2ddl.dao.allcommon.cbean.ckey.*;
\r
7 import jp.sourceforge.ea2ddl.dao.allcommon.cbean.cvalue.ConditionValue;
\r
8 import jp.sourceforge.ea2ddl.dao.allcommon.cbean.sqlclause.SqlClause;
\r
9 import jp.sourceforge.ea2ddl.dao.cbean.*;
\r
10 import jp.sourceforge.ea2ddl.dao.cbean.cq.*;
\r
13 * The abstract condition-query of t_attributetag.
\r
14 * @author DBFlute(AutoGenerator)
\r
16 @SuppressWarnings("unchecked")
\r
17 public abstract class AbstractBsTAttributetagCQ extends AbstractConditionQuery {
\r
19 // ===================================================================================
\r
22 public AbstractBsTAttributetagCQ(ConditionQuery childQuery, SqlClause sqlClause, String aliasName, int nestLevel) {
\r
23 super(childQuery, sqlClause, aliasName, nestLevel);
\r
26 // ===================================================================================
\r
29 public String getTableDbName() {
\r
30 return "t_attributetag";
\r
33 public String getTableSqlName() {
\r
34 return "t_attributetag";
\r
37 // ===================================================================================
\r
42 * Equal(=). And NullIgnored, OnceRegistered. {UQ : COUNTER : NotNull}
\r
43 * @param propertyid The value of propertyid as equal.
\r
45 public void setPropertyid_Equal(java.lang.Integer propertyid) {
\r
46 regPropertyid(CK_EQ, propertyid);
\r
50 * NotEqual(!=). And NullIgnored, OnceRegistered.
\r
51 * @param propertyid The value of propertyid as notEqual.
\r
53 public void setPropertyid_NotEqual(java.lang.Integer propertyid) {
\r
54 regPropertyid(CK_NE, propertyid);
\r
58 * GreaterThan(>). And NullIgnored, OnceRegistered.
\r
59 * @param propertyid The value of propertyid as greaterThan.
\r
61 public void setPropertyid_GreaterThan(java.lang.Integer propertyid) {
\r
62 regPropertyid(CK_GT, propertyid);
\r
66 * LessThan(<). And NullIgnored, OnceRegistered.
\r
67 * @param propertyid The value of propertyid as lessThan.
\r
69 public void setPropertyid_LessThan(java.lang.Integer propertyid) {
\r
70 regPropertyid(CK_LT, propertyid);
\r
74 * GreaterEqual(>=). And NullIgnored, OnceRegistered.
\r
75 * @param propertyid The value of propertyid as greaterEqual.
\r
77 public void setPropertyid_GreaterEqual(java.lang.Integer propertyid) {
\r
78 regPropertyid(CK_GE, propertyid);
\r
82 * LessEqual(<=). And NullIgnored, OnceRegistered.
\r
83 * @param propertyid The value of propertyid as lessEqual.
\r
85 public void setPropertyid_LessEqual(java.lang.Integer propertyid) {
\r
86 regPropertyid(CK_LE, propertyid);
\r
90 * InScope(in (1, 2)). And NullIgnored, NullElementIgnored, SeveralRegistered.
\r
91 * @param propertyidList The collection of propertyid as inScope.
\r
93 public void setPropertyid_InScope(Collection<java.lang.Integer> propertyidList) {
\r
94 regPropertyid(CK_INS, cTL(propertyidList));
\r
97 protected void regPropertyid(ConditionKey key, Object value) {
\r
98 registerQuery(key, value, getCValuePropertyid(), "PropertyID", "Propertyid", "propertyid");
\r
100 protected void registerInlinePropertyid(ConditionKey key, Object value) {
\r
101 registerInlineQuery(key, value, getCValuePropertyid(), "PropertyID", "Propertyid", "propertyid");
\r
103 abstract protected ConditionValue getCValuePropertyid();
\r
106 * Equal(=). And NullIgnored, OnceRegistered. {INTEGER}
\r
107 * @param elementid The value of elementid as equal.
\r
109 public void setElementid_Equal(java.lang.Integer elementid) {
\r
110 regElementid(CK_EQ, elementid);
\r
114 * NotEqual(!=). And NullIgnored, OnceRegistered.
\r
115 * @param elementid The value of elementid as notEqual.
\r
117 public void setElementid_NotEqual(java.lang.Integer elementid) {
\r
118 regElementid(CK_NE, elementid);
\r
122 * GreaterThan(>). And NullIgnored, OnceRegistered.
\r
123 * @param elementid The value of elementid as greaterThan.
\r
125 public void setElementid_GreaterThan(java.lang.Integer elementid) {
\r
126 regElementid(CK_GT, elementid);
\r
130 * LessThan(<). And NullIgnored, OnceRegistered.
\r
131 * @param elementid The value of elementid as lessThan.
\r
133 public void setElementid_LessThan(java.lang.Integer elementid) {
\r
134 regElementid(CK_LT, elementid);
\r
138 * GreaterEqual(>=). And NullIgnored, OnceRegistered.
\r
139 * @param elementid The value of elementid as greaterEqual.
\r
141 public void setElementid_GreaterEqual(java.lang.Integer elementid) {
\r
142 regElementid(CK_GE, elementid);
\r
146 * LessEqual(<=). And NullIgnored, OnceRegistered.
\r
147 * @param elementid The value of elementid as lessEqual.
\r
149 public void setElementid_LessEqual(java.lang.Integer elementid) {
\r
150 regElementid(CK_LE, elementid);
\r
154 * InScope(in (1, 2)). And NullIgnored, NullElementIgnored, SeveralRegistered.
\r
155 * @param elementidList The collection of elementid as inScope.
\r
157 public void setElementid_InScope(Collection<java.lang.Integer> elementidList) {
\r
158 regElementid(CK_INS, cTL(elementidList));
\r
162 * IsNull(is null). And OnceRegistered.
\r
164 public void setElementid_IsNull() { regElementid(CK_ISN, DUMMY_OBJECT); }
\r
167 * IsNotNull(is not null). And OnceRegistered.
\r
169 public void setElementid_IsNotNull() { regElementid(CK_ISNN, DUMMY_OBJECT); }
\r
171 protected void regElementid(ConditionKey key, Object value) {
\r
172 registerQuery(key, value, getCValueElementid(), "ElementID", "Elementid", "elementid");
\r
174 protected void registerInlineElementid(ConditionKey key, Object value) {
\r
175 registerInlineQuery(key, value, getCValueElementid(), "ElementID", "Elementid", "elementid");
\r
177 abstract protected ConditionValue getCValueElementid();
\r
180 * Equal(=). And NullOrEmptyIgnored, OnceRegistered. {VARCHAR(255)}
\r
181 * @param property The value of property as equal.
\r
183 public void setProperty_Equal(String property) {
\r
184 regProperty(CK_EQ, fRES(property));
\r
188 * NotEqual(!=). And NullOrEmptyIgnored, OnceRegistered.
\r
189 * @param property The value of property as notEqual.
\r
191 public void setProperty_NotEqual(String property) {
\r
192 regProperty(CK_NE, fRES(property));
\r
196 * GreaterThan(>). And NullOrEmptyIgnored, OnceRegistered.
\r
197 * @param property The value of property as greaterThan.
\r
199 public void setProperty_GreaterThan(String property) {
\r
200 regProperty(CK_GT, fRES(property));
\r
204 * LessThan(<). And NullOrEmptyIgnored, OnceRegistered.
\r
205 * @param property The value of property as lessThan.
\r
207 public void setProperty_LessThan(String property) {
\r
208 regProperty(CK_LT, fRES(property));
\r
212 * GreaterEqual(>=). And NullOrEmptyIgnored, OnceRegistered.
\r
213 * @param property The value of property as greaterEqual.
\r
215 public void setProperty_GreaterEqual(String property) {
\r
216 regProperty(CK_GE, fRES(property));
\r
220 * LessEqual(<=). And NullOrEmptyIgnored, OnceRegistered.
\r
221 * @param property The value of property as lessEqual.
\r
223 public void setProperty_LessEqual(String property) {
\r
224 regProperty(CK_LE, fRES(property));
\r
228 * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnceRegistered.
\r
229 * @param property The value of property as prefixSearch.
\r
231 public void setProperty_PrefixSearch(String property) {
\r
232 regProperty(CK_PS, fRES(property));
\r
236 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
237 * @param property The value of property as likeSearch.
\r
238 * @param likeSearchOption The option of like-search. (NotNull)
\r
240 public void setProperty_LikeSearch(String property, jp.sourceforge.ea2ddl.dao.allcommon.cbean.coption.LikeSearchOption likeSearchOption) {
\r
241 registerLikeSearchQuery(CK_LS, fRES(property), getCValueProperty(), "Property", "Property", "property", likeSearchOption);
\r
245 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
246 * @param propertyList The collection of property as inScope.
\r
248 public void setProperty_InScope(Collection<String> propertyList) {
\r
249 regProperty(CK_INS, cTL(propertyList));
\r
253 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
254 * @param property The collection of property as inScope.
\r
255 * @param inScopeOption The option of in-scope. (NotNull)
\r
257 public void setProperty_InScope(String property, jp.sourceforge.ea2ddl.dao.allcommon.cbean.coption.InScopeOption inScopeOption) {
\r
258 registerInScopeQuery(CK_INS, fRES(property), getCValueProperty(), "Property", "Property", "property", inScopeOption);
\r
262 * IsNull(is null). And OnceRegistered.
\r
264 public void setProperty_IsNull() { regProperty(CK_ISN, DUMMY_OBJECT); }
\r
267 * IsNotNull(is not null). And OnceRegistered.
\r
269 public void setProperty_IsNotNull() { regProperty(CK_ISNN, DUMMY_OBJECT); }
\r
271 protected void regProperty(ConditionKey key, Object value) {
\r
272 registerQuery(key, value, getCValueProperty(), "Property", "Property", "property");
\r
274 protected void registerInlineProperty(ConditionKey key, Object value) {
\r
275 registerInlineQuery(key, value, getCValueProperty(), "Property", "Property", "property");
\r
277 abstract protected ConditionValue getCValueProperty();
\r
280 * Equal(=). And NullOrEmptyIgnored, OnceRegistered. {VARCHAR(255)}
\r
281 * @param value The value of value as equal.
\r
283 public void setValue_Equal(String value) {
\r
284 regValue(CK_EQ, fRES(value));
\r
288 * NotEqual(!=). And NullOrEmptyIgnored, OnceRegistered.
\r
289 * @param value The value of value as notEqual.
\r
291 public void setValue_NotEqual(String value) {
\r
292 regValue(CK_NE, fRES(value));
\r
296 * GreaterThan(>). And NullOrEmptyIgnored, OnceRegistered.
\r
297 * @param value The value of value as greaterThan.
\r
299 public void setValue_GreaterThan(String value) {
\r
300 regValue(CK_GT, fRES(value));
\r
304 * LessThan(<). And NullOrEmptyIgnored, OnceRegistered.
\r
305 * @param value The value of value as lessThan.
\r
307 public void setValue_LessThan(String value) {
\r
308 regValue(CK_LT, fRES(value));
\r
312 * GreaterEqual(>=). And NullOrEmptyIgnored, OnceRegistered.
\r
313 * @param value The value of value as greaterEqual.
\r
315 public void setValue_GreaterEqual(String value) {
\r
316 regValue(CK_GE, fRES(value));
\r
320 * LessEqual(<=). And NullOrEmptyIgnored, OnceRegistered.
\r
321 * @param value The value of value as lessEqual.
\r
323 public void setValue_LessEqual(String value) {
\r
324 regValue(CK_LE, fRES(value));
\r
328 * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnceRegistered.
\r
329 * @param value The value of value as prefixSearch.
\r
331 public void setValue_PrefixSearch(String value) {
\r
332 regValue(CK_PS, fRES(value));
\r
336 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
337 * @param value The value of value as likeSearch.
\r
338 * @param likeSearchOption The option of like-search. (NotNull)
\r
340 public void setValue_LikeSearch(String value, jp.sourceforge.ea2ddl.dao.allcommon.cbean.coption.LikeSearchOption likeSearchOption) {
\r
341 registerLikeSearchQuery(CK_LS, fRES(value), getCValueValue(), "VALUE", "Value", "value", likeSearchOption);
\r
345 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
346 * @param valueList The collection of value as inScope.
\r
348 public void setValue_InScope(Collection<String> valueList) {
\r
349 regValue(CK_INS, cTL(valueList));
\r
353 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
354 * @param value The collection of value as inScope.
\r
355 * @param inScopeOption The option of in-scope. (NotNull)
\r
357 public void setValue_InScope(String value, jp.sourceforge.ea2ddl.dao.allcommon.cbean.coption.InScopeOption inScopeOption) {
\r
358 registerInScopeQuery(CK_INS, fRES(value), getCValueValue(), "VALUE", "Value", "value", inScopeOption);
\r
362 * IsNull(is null). And OnceRegistered.
\r
364 public void setValue_IsNull() { regValue(CK_ISN, DUMMY_OBJECT); }
\r
367 * IsNotNull(is not null). And OnceRegistered.
\r
369 public void setValue_IsNotNull() { regValue(CK_ISNN, DUMMY_OBJECT); }
\r
371 protected void regValue(ConditionKey key, Object value) {
\r
372 registerQuery(key, value, getCValueValue(), "VALUE", "Value", "value");
\r
374 protected void registerInlineValue(ConditionKey key, Object value) {
\r
375 registerInlineQuery(key, value, getCValueValue(), "VALUE", "Value", "value");
\r
377 abstract protected ConditionValue getCValueValue();
\r
380 * Equal(=). And NullOrEmptyIgnored, OnceRegistered. {LONGCHAR(2147483647)}
\r
381 * @param notes The value of notes as equal.
\r
383 public void setNotes_Equal(String notes) {
\r
384 regNotes(CK_EQ, fRES(notes));
\r
388 * NotEqual(!=). And NullOrEmptyIgnored, OnceRegistered.
\r
389 * @param notes The value of notes as notEqual.
\r
391 public void setNotes_NotEqual(String notes) {
\r
392 regNotes(CK_NE, fRES(notes));
\r
396 * GreaterThan(>). And NullOrEmptyIgnored, OnceRegistered.
\r
397 * @param notes The value of notes as greaterThan.
\r
399 public void setNotes_GreaterThan(String notes) {
\r
400 regNotes(CK_GT, fRES(notes));
\r
404 * LessThan(<). And NullOrEmptyIgnored, OnceRegistered.
\r
405 * @param notes The value of notes as lessThan.
\r
407 public void setNotes_LessThan(String notes) {
\r
408 regNotes(CK_LT, fRES(notes));
\r
412 * GreaterEqual(>=). And NullOrEmptyIgnored, OnceRegistered.
\r
413 * @param notes The value of notes as greaterEqual.
\r
415 public void setNotes_GreaterEqual(String notes) {
\r
416 regNotes(CK_GE, fRES(notes));
\r
420 * LessEqual(<=). And NullOrEmptyIgnored, OnceRegistered.
\r
421 * @param notes The value of notes as lessEqual.
\r
423 public void setNotes_LessEqual(String notes) {
\r
424 regNotes(CK_LE, fRES(notes));
\r
428 * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnceRegistered.
\r
429 * @param notes The value of notes as prefixSearch.
\r
431 public void setNotes_PrefixSearch(String notes) {
\r
432 regNotes(CK_PS, fRES(notes));
\r
436 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
437 * @param notes The value of notes as likeSearch.
\r
438 * @param likeSearchOption The option of like-search. (NotNull)
\r
440 public void setNotes_LikeSearch(String notes, jp.sourceforge.ea2ddl.dao.allcommon.cbean.coption.LikeSearchOption likeSearchOption) {
\r
441 registerLikeSearchQuery(CK_LS, fRES(notes), getCValueNotes(), "NOTES", "Notes", "notes", likeSearchOption);
\r
445 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
446 * @param notesList The collection of notes as inScope.
\r
448 public void setNotes_InScope(Collection<String> notesList) {
\r
449 regNotes(CK_INS, cTL(notesList));
\r
453 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
454 * @param notes The collection of notes as inScope.
\r
455 * @param inScopeOption The option of in-scope. (NotNull)
\r
457 public void setNotes_InScope(String notes, jp.sourceforge.ea2ddl.dao.allcommon.cbean.coption.InScopeOption inScopeOption) {
\r
458 registerInScopeQuery(CK_INS, fRES(notes), getCValueNotes(), "NOTES", "Notes", "notes", inScopeOption);
\r
462 * IsNull(is null). And OnceRegistered.
\r
464 public void setNotes_IsNull() { regNotes(CK_ISN, DUMMY_OBJECT); }
\r
467 * IsNotNull(is not null). And OnceRegistered.
\r
469 public void setNotes_IsNotNull() { regNotes(CK_ISNN, DUMMY_OBJECT); }
\r
471 protected void regNotes(ConditionKey key, Object value) {
\r
472 registerQuery(key, value, getCValueNotes(), "NOTES", "Notes", "notes");
\r
474 protected void registerInlineNotes(ConditionKey key, Object value) {
\r
475 registerInlineQuery(key, value, getCValueNotes(), "NOTES", "Notes", "notes");
\r
477 abstract protected ConditionValue getCValueNotes();
\r
480 * Equal(=). And NullOrEmptyIgnored, OnceRegistered. {VARCHAR(40)}
\r
481 * @param eaGuid The value of eaGuid as equal.
\r
483 public void setEaGuid_Equal(String eaGuid) {
\r
484 regEaGuid(CK_EQ, fRES(eaGuid));
\r
488 * NotEqual(!=). And NullOrEmptyIgnored, OnceRegistered.
\r
489 * @param eaGuid The value of eaGuid as notEqual.
\r
491 public void setEaGuid_NotEqual(String eaGuid) {
\r
492 regEaGuid(CK_NE, fRES(eaGuid));
\r
496 * GreaterThan(>). And NullOrEmptyIgnored, OnceRegistered.
\r
497 * @param eaGuid The value of eaGuid as greaterThan.
\r
499 public void setEaGuid_GreaterThan(String eaGuid) {
\r
500 regEaGuid(CK_GT, fRES(eaGuid));
\r
504 * LessThan(<). And NullOrEmptyIgnored, OnceRegistered.
\r
505 * @param eaGuid The value of eaGuid as lessThan.
\r
507 public void setEaGuid_LessThan(String eaGuid) {
\r
508 regEaGuid(CK_LT, fRES(eaGuid));
\r
512 * GreaterEqual(>=). And NullOrEmptyIgnored, OnceRegistered.
\r
513 * @param eaGuid The value of eaGuid as greaterEqual.
\r
515 public void setEaGuid_GreaterEqual(String eaGuid) {
\r
516 regEaGuid(CK_GE, fRES(eaGuid));
\r
520 * LessEqual(<=). And NullOrEmptyIgnored, OnceRegistered.
\r
521 * @param eaGuid The value of eaGuid as lessEqual.
\r
523 public void setEaGuid_LessEqual(String eaGuid) {
\r
524 regEaGuid(CK_LE, fRES(eaGuid));
\r
528 * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnceRegistered.
\r
529 * @param eaGuid The value of eaGuid as prefixSearch.
\r
531 public void setEaGuid_PrefixSearch(String eaGuid) {
\r
532 regEaGuid(CK_PS, fRES(eaGuid));
\r
536 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
537 * @param eaGuid The value of eaGuid as likeSearch.
\r
538 * @param likeSearchOption The option of like-search. (NotNull)
\r
540 public void setEaGuid_LikeSearch(String eaGuid, jp.sourceforge.ea2ddl.dao.allcommon.cbean.coption.LikeSearchOption likeSearchOption) {
\r
541 registerLikeSearchQuery(CK_LS, fRES(eaGuid), getCValueEaGuid(), "ea_guid", "EaGuid", "eaGuid", likeSearchOption);
\r
545 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
546 * @param eaGuidList The collection of eaGuid as inScope.
\r
548 public void setEaGuid_InScope(Collection<String> eaGuidList) {
\r
549 regEaGuid(CK_INS, cTL(eaGuidList));
\r
553 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
554 * @param eaGuid The collection of eaGuid as inScope.
\r
555 * @param inScopeOption The option of in-scope. (NotNull)
\r
557 public void setEaGuid_InScope(String eaGuid, jp.sourceforge.ea2ddl.dao.allcommon.cbean.coption.InScopeOption inScopeOption) {
\r
558 registerInScopeQuery(CK_INS, fRES(eaGuid), getCValueEaGuid(), "ea_guid", "EaGuid", "eaGuid", inScopeOption);
\r
562 * IsNull(is null). And OnceRegistered.
\r
564 public void setEaGuid_IsNull() { regEaGuid(CK_ISN, DUMMY_OBJECT); }
\r
567 * IsNotNull(is not null). And OnceRegistered.
\r
569 public void setEaGuid_IsNotNull() { regEaGuid(CK_ISNN, DUMMY_OBJECT); }
\r
571 protected void regEaGuid(ConditionKey key, Object value) {
\r
572 registerQuery(key, value, getCValueEaGuid(), "ea_guid", "EaGuid", "eaGuid");
\r
574 protected void registerInlineEaGuid(ConditionKey key, Object value) {
\r
575 registerInlineQuery(key, value, getCValueEaGuid(), "ea_guid", "EaGuid", "eaGuid");
\r
577 abstract protected ConditionValue getCValueEaGuid();
\r
579 // Very Internal (for Suppressing Warn about 'Not Use Import')
\r
580 protected String getConditionBeanClassNameInternally() { return TAttributetagCB.class.getName(); }
\r
581 protected String getConditionQueryClassNameInternally() { return TAttributetagCQ.class.getName(); }
\r