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_requiretypes.
\r
14 * @author DBFlute(AutoGenerator)
\r
16 @SuppressWarnings("unchecked")
\r
17 public abstract class AbstractBsTRequiretypesCQ extends AbstractConditionQuery {
\r
19 // ===================================================================================
\r
22 public AbstractBsTRequiretypesCQ(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_requiretypes";
\r
33 public String getTableSqlName() {
\r
34 return "t_requiretypes";
\r
37 // ===================================================================================
\r
42 * Equal(=). And NullOrEmptyIgnored, OnceRegistered. {UQ : VARCHAR(12)}
\r
43 * @param requirement The value of requirement as equal.
\r
45 public void setRequirement_Equal(String requirement) {
\r
46 regRequirement(CK_EQ, fRES(requirement));
\r
50 * NotEqual(!=). And NullOrEmptyIgnored, OnceRegistered.
\r
51 * @param requirement The value of requirement as notEqual.
\r
53 public void setRequirement_NotEqual(String requirement) {
\r
54 regRequirement(CK_NE, fRES(requirement));
\r
58 * GreaterThan(>). And NullOrEmptyIgnored, OnceRegistered.
\r
59 * @param requirement The value of requirement as greaterThan.
\r
61 public void setRequirement_GreaterThan(String requirement) {
\r
62 regRequirement(CK_GT, fRES(requirement));
\r
66 * LessThan(<). And NullOrEmptyIgnored, OnceRegistered.
\r
67 * @param requirement The value of requirement as lessThan.
\r
69 public void setRequirement_LessThan(String requirement) {
\r
70 regRequirement(CK_LT, fRES(requirement));
\r
74 * GreaterEqual(>=). And NullOrEmptyIgnored, OnceRegistered.
\r
75 * @param requirement The value of requirement as greaterEqual.
\r
77 public void setRequirement_GreaterEqual(String requirement) {
\r
78 regRequirement(CK_GE, fRES(requirement));
\r
82 * LessEqual(<=). And NullOrEmptyIgnored, OnceRegistered.
\r
83 * @param requirement The value of requirement as lessEqual.
\r
85 public void setRequirement_LessEqual(String requirement) {
\r
86 regRequirement(CK_LE, fRES(requirement));
\r
90 * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnceRegistered.
\r
91 * @param requirement The value of requirement as prefixSearch.
\r
93 public void setRequirement_PrefixSearch(String requirement) {
\r
94 regRequirement(CK_PS, fRES(requirement));
\r
98 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
99 * @param requirement The value of requirement as likeSearch.
\r
100 * @param likeSearchOption The option of like-search. (NotNull)
\r
102 public void setRequirement_LikeSearch(String requirement, jp.sourceforge.ea2ddl.dao.allcommon.cbean.coption.LikeSearchOption likeSearchOption) {
\r
103 registerLikeSearchQuery(CK_LS, fRES(requirement), getCValueRequirement(), "Requirement", "Requirement", "requirement", likeSearchOption);
\r
107 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
108 * @param requirementList The collection of requirement as inScope.
\r
110 public void setRequirement_InScope(Collection<String> requirementList) {
\r
111 regRequirement(CK_INS, cTL(requirementList));
\r
115 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
116 * @param requirement The collection of requirement as inScope.
\r
117 * @param inScopeOption The option of in-scope. (NotNull)
\r
119 public void setRequirement_InScope(String requirement, jp.sourceforge.ea2ddl.dao.allcommon.cbean.coption.InScopeOption inScopeOption) {
\r
120 registerInScopeQuery(CK_INS, fRES(requirement), getCValueRequirement(), "Requirement", "Requirement", "requirement", inScopeOption);
\r
124 * IsNull(is null). And OnceRegistered.
\r
126 public void setRequirement_IsNull() { regRequirement(CK_ISN, DUMMY_OBJECT); }
\r
129 * IsNotNull(is not null). And OnceRegistered.
\r
131 public void setRequirement_IsNotNull() { regRequirement(CK_ISNN, DUMMY_OBJECT); }
\r
133 protected void regRequirement(ConditionKey key, Object value) {
\r
134 registerQuery(key, value, getCValueRequirement(), "Requirement", "Requirement", "requirement");
\r
136 protected void registerInlineRequirement(ConditionKey key, Object value) {
\r
137 registerInlineQuery(key, value, getCValueRequirement(), "Requirement", "Requirement", "requirement");
\r
139 abstract protected ConditionValue getCValueRequirement();
\r
142 * Equal(=). And NullOrEmptyIgnored, OnceRegistered. {VARCHAR(50)}
\r
143 * @param description The value of description as equal.
\r
145 public void setDescription_Equal(String description) {
\r
146 regDescription(CK_EQ, fRES(description));
\r
150 * NotEqual(!=). And NullOrEmptyIgnored, OnceRegistered.
\r
151 * @param description The value of description as notEqual.
\r
153 public void setDescription_NotEqual(String description) {
\r
154 regDescription(CK_NE, fRES(description));
\r
158 * GreaterThan(>). And NullOrEmptyIgnored, OnceRegistered.
\r
159 * @param description The value of description as greaterThan.
\r
161 public void setDescription_GreaterThan(String description) {
\r
162 regDescription(CK_GT, fRES(description));
\r
166 * LessThan(<). And NullOrEmptyIgnored, OnceRegistered.
\r
167 * @param description The value of description as lessThan.
\r
169 public void setDescription_LessThan(String description) {
\r
170 regDescription(CK_LT, fRES(description));
\r
174 * GreaterEqual(>=). And NullOrEmptyIgnored, OnceRegistered.
\r
175 * @param description The value of description as greaterEqual.
\r
177 public void setDescription_GreaterEqual(String description) {
\r
178 regDescription(CK_GE, fRES(description));
\r
182 * LessEqual(<=). And NullOrEmptyIgnored, OnceRegistered.
\r
183 * @param description The value of description as lessEqual.
\r
185 public void setDescription_LessEqual(String description) {
\r
186 regDescription(CK_LE, fRES(description));
\r
190 * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnceRegistered.
\r
191 * @param description The value of description as prefixSearch.
\r
193 public void setDescription_PrefixSearch(String description) {
\r
194 regDescription(CK_PS, fRES(description));
\r
198 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
199 * @param description The value of description as likeSearch.
\r
200 * @param likeSearchOption The option of like-search. (NotNull)
\r
202 public void setDescription_LikeSearch(String description, jp.sourceforge.ea2ddl.dao.allcommon.cbean.coption.LikeSearchOption likeSearchOption) {
\r
203 registerLikeSearchQuery(CK_LS, fRES(description), getCValueDescription(), "Description", "Description", "description", likeSearchOption);
\r
207 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
208 * @param descriptionList The collection of description as inScope.
\r
210 public void setDescription_InScope(Collection<String> descriptionList) {
\r
211 regDescription(CK_INS, cTL(descriptionList));
\r
215 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
216 * @param description The collection of description as inScope.
\r
217 * @param inScopeOption The option of in-scope. (NotNull)
\r
219 public void setDescription_InScope(String description, jp.sourceforge.ea2ddl.dao.allcommon.cbean.coption.InScopeOption inScopeOption) {
\r
220 registerInScopeQuery(CK_INS, fRES(description), getCValueDescription(), "Description", "Description", "description", inScopeOption);
\r
224 * IsNull(is null). And OnceRegistered.
\r
226 public void setDescription_IsNull() { regDescription(CK_ISN, DUMMY_OBJECT); }
\r
229 * IsNotNull(is not null). And OnceRegistered.
\r
231 public void setDescription_IsNotNull() { regDescription(CK_ISNN, DUMMY_OBJECT); }
\r
233 protected void regDescription(ConditionKey key, Object value) {
\r
234 registerQuery(key, value, getCValueDescription(), "Description", "Description", "description");
\r
236 protected void registerInlineDescription(ConditionKey key, Object value) {
\r
237 registerInlineQuery(key, value, getCValueDescription(), "Description", "Description", "description");
\r
239 abstract protected ConditionValue getCValueDescription();
\r
242 * Equal(=). And NullIgnored, OnceRegistered. {DOUBLE}
\r
243 * @param numericweight The value of numericweight as equal.
\r
245 public void setNumericweight_Equal(java.math.BigDecimal numericweight) {
\r
246 regNumericweight(CK_EQ, numericweight);
\r
250 * NotEqual(!=). And NullIgnored, OnceRegistered.
\r
251 * @param numericweight The value of numericweight as notEqual.
\r
253 public void setNumericweight_NotEqual(java.math.BigDecimal numericweight) {
\r
254 regNumericweight(CK_NE, numericweight);
\r
258 * GreaterThan(>). And NullIgnored, OnceRegistered.
\r
259 * @param numericweight The value of numericweight as greaterThan.
\r
261 public void setNumericweight_GreaterThan(java.math.BigDecimal numericweight) {
\r
262 regNumericweight(CK_GT, numericweight);
\r
266 * LessThan(<). And NullIgnored, OnceRegistered.
\r
267 * @param numericweight The value of numericweight as lessThan.
\r
269 public void setNumericweight_LessThan(java.math.BigDecimal numericweight) {
\r
270 regNumericweight(CK_LT, numericweight);
\r
274 * GreaterEqual(>=). And NullIgnored, OnceRegistered.
\r
275 * @param numericweight The value of numericweight as greaterEqual.
\r
277 public void setNumericweight_GreaterEqual(java.math.BigDecimal numericweight) {
\r
278 regNumericweight(CK_GE, numericweight);
\r
282 * LessEqual(<=). And NullIgnored, OnceRegistered.
\r
283 * @param numericweight The value of numericweight as lessEqual.
\r
285 public void setNumericweight_LessEqual(java.math.BigDecimal numericweight) {
\r
286 regNumericweight(CK_LE, numericweight);
\r
290 * InScope(in (1, 2)). And NullIgnored, NullElementIgnored, SeveralRegistered.
\r
291 * @param numericweightList The collection of numericweight as inScope.
\r
293 public void setNumericweight_InScope(Collection<java.math.BigDecimal> numericweightList) {
\r
294 regNumericweight(CK_INS, cTL(numericweightList));
\r
298 * IsNull(is null). And OnceRegistered.
\r
300 public void setNumericweight_IsNull() { regNumericweight(CK_ISN, DUMMY_OBJECT); }
\r
303 * IsNotNull(is not null). And OnceRegistered.
\r
305 public void setNumericweight_IsNotNull() { regNumericweight(CK_ISNN, DUMMY_OBJECT); }
\r
307 protected void regNumericweight(ConditionKey key, Object value) {
\r
308 registerQuery(key, value, getCValueNumericweight(), "NumericWeight", "Numericweight", "numericweight");
\r
310 protected void registerInlineNumericweight(ConditionKey key, Object value) {
\r
311 registerInlineQuery(key, value, getCValueNumericweight(), "NumericWeight", "Numericweight", "numericweight");
\r
313 abstract protected ConditionValue getCValueNumericweight();
\r
316 * Equal(=). And NullOrEmptyIgnored, OnceRegistered. {VARCHAR(255)}
\r
317 * @param notes The value of notes as equal.
\r
319 public void setNotes_Equal(String notes) {
\r
320 regNotes(CK_EQ, fRES(notes));
\r
324 * NotEqual(!=). And NullOrEmptyIgnored, OnceRegistered.
\r
325 * @param notes The value of notes as notEqual.
\r
327 public void setNotes_NotEqual(String notes) {
\r
328 regNotes(CK_NE, fRES(notes));
\r
332 * GreaterThan(>). And NullOrEmptyIgnored, OnceRegistered.
\r
333 * @param notes The value of notes as greaterThan.
\r
335 public void setNotes_GreaterThan(String notes) {
\r
336 regNotes(CK_GT, fRES(notes));
\r
340 * LessThan(<). And NullOrEmptyIgnored, OnceRegistered.
\r
341 * @param notes The value of notes as lessThan.
\r
343 public void setNotes_LessThan(String notes) {
\r
344 regNotes(CK_LT, fRES(notes));
\r
348 * GreaterEqual(>=). And NullOrEmptyIgnored, OnceRegistered.
\r
349 * @param notes The value of notes as greaterEqual.
\r
351 public void setNotes_GreaterEqual(String notes) {
\r
352 regNotes(CK_GE, fRES(notes));
\r
356 * LessEqual(<=). And NullOrEmptyIgnored, OnceRegistered.
\r
357 * @param notes The value of notes as lessEqual.
\r
359 public void setNotes_LessEqual(String notes) {
\r
360 regNotes(CK_LE, fRES(notes));
\r
364 * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnceRegistered.
\r
365 * @param notes The value of notes as prefixSearch.
\r
367 public void setNotes_PrefixSearch(String notes) {
\r
368 regNotes(CK_PS, fRES(notes));
\r
372 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
373 * @param notes The value of notes as likeSearch.
\r
374 * @param likeSearchOption The option of like-search. (NotNull)
\r
376 public void setNotes_LikeSearch(String notes, jp.sourceforge.ea2ddl.dao.allcommon.cbean.coption.LikeSearchOption likeSearchOption) {
\r
377 registerLikeSearchQuery(CK_LS, fRES(notes), getCValueNotes(), "Notes", "Notes", "notes", likeSearchOption);
\r
381 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
382 * @param notesList The collection of notes as inScope.
\r
384 public void setNotes_InScope(Collection<String> notesList) {
\r
385 regNotes(CK_INS, cTL(notesList));
\r
389 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
390 * @param notes The collection of notes as inScope.
\r
391 * @param inScopeOption The option of in-scope. (NotNull)
\r
393 public void setNotes_InScope(String notes, jp.sourceforge.ea2ddl.dao.allcommon.cbean.coption.InScopeOption inScopeOption) {
\r
394 registerInScopeQuery(CK_INS, fRES(notes), getCValueNotes(), "Notes", "Notes", "notes", inScopeOption);
\r
398 * IsNull(is null). And OnceRegistered.
\r
400 public void setNotes_IsNull() { regNotes(CK_ISN, DUMMY_OBJECT); }
\r
403 * IsNotNull(is not null). And OnceRegistered.
\r
405 public void setNotes_IsNotNull() { regNotes(CK_ISNN, DUMMY_OBJECT); }
\r
407 protected void regNotes(ConditionKey key, Object value) {
\r
408 registerQuery(key, value, getCValueNotes(), "Notes", "Notes", "notes");
\r
410 protected void registerInlineNotes(ConditionKey key, Object value) {
\r
411 registerInlineQuery(key, value, getCValueNotes(), "Notes", "Notes", "notes");
\r
413 abstract protected ConditionValue getCValueNotes();
\r
415 // Very Internal (for Suppressing Warn about 'Not Use Import')
\r
416 protected String getConditionBeanClassNameInternally() { return TRequiretypesCB.class.getName(); }
\r
417 protected String getConditionQueryClassNameInternally() { return TRequiretypesCQ.class.getName(); }
\r