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_operationposts.
\r
17 * @author DBFlute(AutoGenerator)
\r
19 public abstract class AbstractBsTOperationpostsCQ extends AbstractConditionQuery {
\r
21 // ===================================================================================
\r
24 protected final DBMetaProvider _dbmetaProvider = new DBMetaInstanceHandler();
\r
26 // ===================================================================================
\r
29 public AbstractBsTOperationpostsCQ(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
45 return "t_operationposts";
\r
48 public String getTableSqlName() {
\r
49 return "t_operationposts";
\r
52 // ===================================================================================
\r
57 * Equal(=). And NullIgnored, OnlyOnceRegistered. {UQ : INTEGER}
\r
58 * @param operationid The value of operationid as equal.
\r
60 public void setOperationid_Equal(java.lang.Integer operationid) {
\r
61 regOperationid(CK_EQ, operationid);
\r
65 * NotEqual(!=). And NullIgnored, OnlyOnceRegistered.
\r
66 * @param operationid The value of operationid as notEqual.
\r
68 public void setOperationid_NotEqual(java.lang.Integer operationid) {
\r
69 regOperationid(CK_NE, operationid);
\r
73 * GreaterThan(>). And NullIgnored, OnlyOnceRegistered.
\r
74 * @param operationid The value of operationid as greaterThan.
\r
76 public void setOperationid_GreaterThan(java.lang.Integer operationid) {
\r
77 regOperationid(CK_GT, operationid);
\r
81 * LessThan(<). And NullIgnored, OnlyOnceRegistered.
\r
82 * @param operationid The value of operationid as lessThan.
\r
84 public void setOperationid_LessThan(java.lang.Integer operationid) {
\r
85 regOperationid(CK_LT, operationid);
\r
89 * GreaterEqual(>=). And NullIgnored, OnlyOnceRegistered.
\r
90 * @param operationid The value of operationid as greaterEqual.
\r
92 public void setOperationid_GreaterEqual(java.lang.Integer operationid) {
\r
93 regOperationid(CK_GE, operationid);
\r
97 * LessEqual(<=). And NullIgnored, OnlyOnceRegistered.
\r
98 * @param operationid The value of operationid as lessEqual.
\r
100 public void setOperationid_LessEqual(java.lang.Integer operationid) {
\r
101 regOperationid(CK_LE, operationid);
\r
105 * InScope(in (1, 2)). And NullIgnored, NullElementIgnored, SeveralRegistered.
\r
106 * @param operationidList The collection of operationid as inScope.
\r
108 public void setOperationid_InScope(Collection<java.lang.Integer> operationidList) {
\r
109 regOperationid(CK_INS, cTL(operationidList));
\r
113 * IsNull(is null). And OnlyOnceRegistered.
\r
115 public void setOperationid_IsNull() { regOperationid(CK_ISN, DOBJ); }
\r
118 * IsNotNull(is not null). And OnlyOnceRegistered.
\r
120 public void setOperationid_IsNotNull() { regOperationid(CK_ISNN, DOBJ); }
\r
122 protected void regOperationid(ConditionKey k, Object v) { regQ(k, v, getCValueOperationid(), "OperationID"); }
\r
123 abstract protected ConditionValue getCValueOperationid();
\r
126 * Equal(=). And NullOrEmptyIgnored, OnlyOnceRegistered. {UQ : VARCHAR(255)}
\r
127 * @param postcondition The value of postcondition as equal.
\r
129 public void setPostcondition_Equal(String postcondition) {
\r
130 regPostcondition(CK_EQ, fRES(postcondition));
\r
134 * NotEqual(!=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
135 * @param postcondition The value of postcondition as notEqual.
\r
137 public void setPostcondition_NotEqual(String postcondition) {
\r
138 regPostcondition(CK_NE, fRES(postcondition));
\r
142 * GreaterThan(>). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
143 * @param postcondition The value of postcondition as greaterThan.
\r
145 public void setPostcondition_GreaterThan(String postcondition) {
\r
146 regPostcondition(CK_GT, fRES(postcondition));
\r
150 * LessThan(<). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
151 * @param postcondition The value of postcondition as lessThan.
\r
153 public void setPostcondition_LessThan(String postcondition) {
\r
154 regPostcondition(CK_LT, fRES(postcondition));
\r
158 * GreaterEqual(>=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
159 * @param postcondition The value of postcondition as greaterEqual.
\r
161 public void setPostcondition_GreaterEqual(String postcondition) {
\r
162 regPostcondition(CK_GE, fRES(postcondition));
\r
166 * LessEqual(<=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
167 * @param postcondition The value of postcondition as lessEqual.
\r
169 public void setPostcondition_LessEqual(String postcondition) {
\r
170 regPostcondition(CK_LE, fRES(postcondition));
\r
174 * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
175 * @param postcondition The value of postcondition as prefixSearch.
\r
177 public void setPostcondition_PrefixSearch(String postcondition) {
\r
178 regPostcondition(CK_PS, fRES(postcondition));
\r
182 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
183 * @param postconditionList The collection of postcondition as inScope.
\r
185 public void setPostcondition_InScope(Collection<String> postconditionList) {
\r
186 regPostcondition(CK_INS, cTL(postconditionList));
\r
190 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
191 * @param postcondition The value of postcondition as likeSearch.
\r
192 * @param likeSearchOption The option of like-search. (NotNull)
\r
194 public void setPostcondition_LikeSearch(String postcondition, LikeSearchOption likeSearchOption) {
\r
195 regLSQ(CK_LS, fRES(postcondition), getCValuePostcondition(), "PostCondition", likeSearchOption);
\r
199 * NotLikeSearch(not like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
200 * @param postcondition The value of postcondition as notLikeSearch.
\r
201 * @param likeSearchOption The option of not-like-search. (NotNull)
\r
203 public void setPostcondition_NotLikeSearch(String postcondition, LikeSearchOption likeSearchOption) {
\r
204 regLSQ(CK_NLS, fRES(postcondition), getCValuePostcondition(), "PostCondition", likeSearchOption);
\r
208 * IsNull(is null). And OnlyOnceRegistered.
\r
210 public void setPostcondition_IsNull() { regPostcondition(CK_ISN, DOBJ); }
\r
213 * IsNotNull(is not null). And OnlyOnceRegistered.
\r
215 public void setPostcondition_IsNotNull() { regPostcondition(CK_ISNN, DOBJ); }
\r
217 protected void regPostcondition(ConditionKey k, Object v) { regQ(k, v, getCValuePostcondition(), "PostCondition"); }
\r
218 abstract protected ConditionValue getCValuePostcondition();
\r
221 * Equal(=). And NullOrEmptyIgnored, OnlyOnceRegistered. {VARCHAR(255)}
\r
222 * @param type The value of type as equal.
\r
224 public void setType_Equal(String type) {
\r
225 regType(CK_EQ, fRES(type));
\r
229 * NotEqual(!=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
230 * @param type The value of type as notEqual.
\r
232 public void setType_NotEqual(String type) {
\r
233 regType(CK_NE, fRES(type));
\r
237 * GreaterThan(>). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
238 * @param type The value of type as greaterThan.
\r
240 public void setType_GreaterThan(String type) {
\r
241 regType(CK_GT, fRES(type));
\r
245 * LessThan(<). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
246 * @param type The value of type as lessThan.
\r
248 public void setType_LessThan(String type) {
\r
249 regType(CK_LT, fRES(type));
\r
253 * GreaterEqual(>=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
254 * @param type The value of type as greaterEqual.
\r
256 public void setType_GreaterEqual(String type) {
\r
257 regType(CK_GE, fRES(type));
\r
261 * LessEqual(<=). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
262 * @param type The value of type as lessEqual.
\r
264 public void setType_LessEqual(String type) {
\r
265 regType(CK_LE, fRES(type));
\r
269 * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnlyOnceRegistered.
\r
270 * @param type The value of type as prefixSearch.
\r
272 public void setType_PrefixSearch(String type) {
\r
273 regType(CK_PS, fRES(type));
\r
277 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
278 * @param typeList The collection of type as inScope.
\r
280 public void setType_InScope(Collection<String> typeList) {
\r
281 regType(CK_INS, cTL(typeList));
\r
285 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
286 * @param type The value of type as likeSearch.
\r
287 * @param likeSearchOption The option of like-search. (NotNull)
\r
289 public void setType_LikeSearch(String type, LikeSearchOption likeSearchOption) {
\r
290 regLSQ(CK_LS, fRES(type), getCValueType(), "Type", likeSearchOption);
\r
294 * NotLikeSearch(not like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
295 * @param type The value of type as notLikeSearch.
\r
296 * @param likeSearchOption The option of not-like-search. (NotNull)
\r
298 public void setType_NotLikeSearch(String type, LikeSearchOption likeSearchOption) {
\r
299 regLSQ(CK_NLS, fRES(type), getCValueType(), "Type", likeSearchOption);
\r
303 * IsNull(is null). And OnlyOnceRegistered.
\r
305 public void setType_IsNull() { regType(CK_ISN, DOBJ); }
\r
308 * IsNotNull(is not null). And OnlyOnceRegistered.
\r
310 public void setType_IsNotNull() { regType(CK_ISNN, DOBJ); }
\r
312 protected void regType(ConditionKey k, Object v) { regQ(k, v, getCValueType(), "Type"); }
\r
313 abstract protected ConditionValue getCValueType();
\r
316 * Equal(=). And NullOrEmptyIgnored, OnlyOnceRegistered. {LONGCHAR(2147483647)}
\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, OnlyOnceRegistered.
\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, OnlyOnceRegistered.
\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, OnlyOnceRegistered.
\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, OnlyOnceRegistered.
\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, OnlyOnceRegistered.
\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, OnlyOnceRegistered.
\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 * InScope(in ('a', 'b')). And NullOrEmptyIgnored, NullOrEmptyElementIgnored, SeveralRegistered.
\r
373 * @param notesList The collection of notes as inScope.
\r
375 public void setNotes_InScope(Collection<String> notesList) {
\r
376 regNotes(CK_INS, cTL(notesList));
\r
380 * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
381 * @param notes The value of notes as likeSearch.
\r
382 * @param likeSearchOption The option of like-search. (NotNull)
\r
384 public void setNotes_LikeSearch(String notes, LikeSearchOption likeSearchOption) {
\r
385 regLSQ(CK_LS, fRES(notes), getCValueNotes(), "Notes", likeSearchOption);
\r
389 * NotLikeSearch(not like 'xxx%' escape ...). And NullOrEmptyIgnored, SeveralRegistered.
\r
390 * @param notes The value of notes as notLikeSearch.
\r
391 * @param likeSearchOption The option of not-like-search. (NotNull)
\r
393 public void setNotes_NotLikeSearch(String notes, LikeSearchOption likeSearchOption) {
\r
394 regLSQ(CK_NLS, fRES(notes), getCValueNotes(), "Notes", likeSearchOption);
\r
398 * IsNull(is null). And OnlyOnceRegistered.
\r
400 public void setNotes_IsNull() { regNotes(CK_ISN, DOBJ); }
\r
403 * IsNotNull(is not null). And OnlyOnceRegistered.
\r
405 public void setNotes_IsNotNull() { regNotes(CK_ISNN, DOBJ); }
\r
407 protected void regNotes(ConditionKey k, Object v) { regQ(k, v, getCValueNotes(), "Notes"); }
\r
408 abstract protected ConditionValue getCValueNotes();
\r
410 // ===================================================================================
\r
413 // Very Internal (for Suppressing Warn about 'Not Use Import')
\r
414 String xCB() { return TOperationpostsCB.class.getName(); }
\r
415 String xCQ() { return TOperationpostsCQ.class.getName(); }
\r
416 String xLSO() { return LikeSearchOption.class.getName(); }
\r