// for OutsideSql
protected void ThrowOutsideSqlLikeSearchOptionSplitUnsupportedException(LikeSearchOption option, Object resourceBean, String currentName)
{
String msg = "Look! Read the message below." + GetLineSeparator();
msg = msg + "/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *" + GetLineSeparator();
msg = msg + "The splitByXxx() of LikeSearchOption is unsupported at OutsideSql!" + GetLineSeparator();
msg = msg + GetLineSeparator();
msg = msg + "[Advice]" + GetLineSeparator();
msg = msg + "Please confirm your method call:" + GetLineSeparator();
msg = msg + " For example:" + GetLineSeparator();
msg = msg + " before (x):" + GetLineSeparator();
String beanName = resourceBean.GetType().Name;
String methodName = "Set" + InitCap(currentName) + "_LikeSearch(value, likeSearchOption);";
msg = msg + " " + beanName + " pmb = new " + beanName + "();" + GetLineSeparator();
msg = msg + " LikeSearchOption likeSearchOption = new LikeSearchOption().likeContain();" + GetLineSeparator();
msg = msg + " likeSearchOption.SplitBySpace(); // *No! Don't invoke this!" + GetLineSeparator();
msg = msg + " pmb." + methodName + GetLineSeparator();
msg = msg + " after (o):" + GetLineSeparator();
msg = msg + " " + beanName + " pmb = new " + beanName + "();" + GetLineSeparator();
msg = msg + " LikeSearchOption likeSearchOption = new LikeSearchOption().LikeContain();" + GetLineSeparator();
msg = msg + " pmb." + methodName + GetLineSeparator();
msg = msg + GetLineSeparator();
msg = msg + "[Target LikeSearchOption]" + GetLineSeparator() + option + GetLineSeparator();
msg = msg + GetLineSeparator();
msg = msg + "[Target ParameterBean]" + GetLineSeparator() + resourceBean + GetLineSeparator();
msg = msg + "* * * * * * * * * */";
throw new UnsupportedOperationException(msg);
}
// for OutsideSql
protected LikeSearchOption GetLikeSearchOption(Type type, String currentName, Object resourceBean)
{
PropertyInfo pi = type.GetProperty(currentName + "InternalLikeSearchOption");
LikeSearchOption option = (LikeSearchOption)pi.GetValue(resourceBean, null);
if (option == null)
{
ThrowLikeSearchOptionNotFoundException(resourceBean, currentName);
}
if (option.isSplit())
{
ThrowOutsideSqlLikeSearchOptionSplitUnsupportedException(option, resourceBean, currentName);
}
return(option);
}
protected override void doAddWhereClause(List <String> conditionList, String columnName, ConditionValue value, ConditionOption option)
{
if (option == null)
{
String msg = "The argument[option] should not be null: columnName=" + columnName + " value=" + value;
throw new IllegalArgumentException(msg);
}
if (!(option is LikeSearchOption))
{
String msg = "The argument[option] should be LikeSearchOption: columnName=" + columnName + " value=" + value;
throw new IllegalArgumentException(msg);
}
LikeSearchOption myOption = (LikeSearchOption)option;
conditionList.add(buildBindClauseWithRearOption(columnName, value.getLikeSearchLocation(), myOption.getRearOption()));
}
public ConditionValue setNotLikeSearch(String value, LikeSearchOption option)
{
if (_notLikeSearch == null)
{
_notLikeSearch = new ArrayList <NotLikeSearchValue>();
_notLikeSearch4Spare = new ArrayList <NotLikeSearchValue>();
}
if (_notLikeSearch.isEmpty() && !_notLikeSearch4Spare.isEmpty())
{
for (int index = 0; index < _notLikeSearch4Spare.size(); index++)
{
_notLikeSearch.add(_notLikeSearch4Spare.get(index));
}
}
NotLikeSearchValue notLikeSearchValue = new NotLikeSearchValue(value, option);
_notLikeSearch.add(notLikeSearchValue);
_notLikeSearch4Spare.add(notLikeSearchValue);
return(this);
}
public void Setメールアドレス_NotLikeSearch(String v, LikeSearchOption option)
{
regLSQ(CK_NLS, fRES(v), getCValueメールアドレス(), "メールアドレス", option);
}
public void Set電話番号_NotLikeSearch(String v, LikeSearchOption option)
{
regLSQ(CK_NLS, fRES(v), getCValue電話番号(), "電話番号", option);
}
public void Set会社名カナ_NotLikeSearch(String v, LikeSearchOption option)
{
regLSQ(CK_NLS, fRES(v), getCValue会社名カナ(), "会社名カナ", option);
}
public void Set会社名_LikeSearch(String v, LikeSearchOption option)
{
regLSQ(CK_LS, fRES(v), getCValue会社名(), "会社名", option);
}
public void Setメニュー名称_LikeSearch(String v, LikeSearchOption option)
{
regLSQ(CK_LS, fRES(v), getCValueメニュー名称(), "メニュー名称", option);
}
public void Set客室コード_NotLikeSearch(String v, LikeSearchOption option)
{
regLSQ(CK_NLS, fRES(v), getCValue客室コード(), "客室コード", option);
}
public NotLikeSearchValue(String value, LikeSearchOption option)
{
_value = value;
_option = option;
}
public void Set対象年月_NotLikeSearch(String v, LikeSearchOption option)
{
regLSQ(CK_NLS, fRES(v), getCValue対象年月(), "対象年月", option);
}
// for OutsideSql
protected bool IsLastLoop4LikeSearch(int pos, LikeSearchOption likeSearchOption)
{
return(_names.Length == (pos + 1) && likeSearchOption != null);
}
public void SetupValueAndType(InternalValueAndType valueAndType)
{
Object value = valueAndType.TargetValue;
Type type = valueAndType.TargetType;
// LikeSearchOption handling here is for OutsideSql.
LikeSearchOption likeSearchOption = null;
String rearOption = null;
for (int pos = 1; pos < _names.Length; ++pos)
{
if (value == null)
{
break;
}
String currentName = _names[pos];
if (pos == 1) // at the First Loop
{
if (HasLikeSearchOption(type, currentName))
{
likeSearchOption = GetLikeSearchOption(type, currentName, value);
}
}
if (value is System.Collections.IDictionary)
{
System.Collections.IDictionary map = (System.Collections.IDictionary)value;
value = map[currentName];
if (IsLastLoop4LikeSearch(pos, likeSearchOption) && IsValidStringValue(value)) // at the Last Loop
{
value = likeSearchOption.generateRealValue((String)value);
rearOption = likeSearchOption.getRearOption();
}
type = (value != null ? value.GetType() : type);
continue;
}
if (value is NgMap)
{
NgMap map = (NgMap)value;
value = map.getAsNg(currentName);
if (IsLastLoop4LikeSearch(pos, likeSearchOption) && IsValidStringValue(value)) // at the Last Loop
{
value = likeSearchOption.generateRealValue((String)value);
rearOption = likeSearchOption.getRearOption();
}
type = (value != null ? value.GetType() : type);
continue;
}
PropertyInfo pi = type.GetProperty(currentName);
if (pi != null)
{
value = pi.GetValue(value, null);
if (IsLastLoop4LikeSearch(pos, likeSearchOption) && IsValidStringValue(value)) // at the Last Loop
{
value = likeSearchOption.generateRealValue((String)value);
rearOption = likeSearchOption.getRearOption();
}
type = (value != null ? value.GetType() : pi.PropertyType);
continue;
}
if (pos == 1 && typeof(MapParameterBean).IsAssignableFrom(type))
{
MapParameterBean pmb = (MapParameterBean)value;
IDictionary <String, Object> map = pmb.ParameterMap;
Object elementValue = (map != null && map.ContainsKey(currentName) ? map[currentName] : null);
if (elementValue != null)
{
value = elementValue;
type = elementValue.GetType();
continue;
}
}
ThrowBindOrEmbeddedCommentNotFoundPropertyException(_expression, type, currentName, _specifiedSql, _bind);
}
valueAndType.TargetValue = value;
valueAndType.TargetType = type;
valueAndType.RearOption = rearOption;
}
public void Set会員コード_LikeSearch(String v, LikeSearchOption option)
{
regLSQ(CK_LS, fRES(v), getCValue会員コード(), "会員コード", option);
}
public void Set名字_LikeSearch(String v, LikeSearchOption option)
{
regLSQ(CK_LS, fRES(v), getCValue名字(), "名字", option);
}
public void Set職位英字名称_NotLikeSearch(String v, LikeSearchOption option)
{
regLSQ(CK_NLS, fRES(v), getCValue職位英字名称(), "職位英字名称", option);
}
public void Set名前_NotLikeSearch(String v, LikeSearchOption option)
{
regLSQ(CK_NLS, fRES(v), getCValue名前(), "名前", option);
}
public void Set客室番号_LikeSearch(String v, LikeSearchOption option)
{
regLSQ(CK_LS, fRES(v), getCValue客室番号(), "客室番号", option);
}
public void Set氏名カナ_LikeSearch(String v, LikeSearchOption option)
{
regLSQ(CK_LS, fRES(v), getCValue氏名カナ(), "氏名カナ", option);
}
public void Set備考_NotLikeSearch(String v, LikeSearchOption option)
{
regLSQ(CK_NLS, fRES(v), getCValue備考(), "備考", option);
}
public void SetDummy_NotLikeSearch(String v, LikeSearchOption option)
{
regLSQ(CK_NLS, fRES(v), getCValueDummy(), "dummy", option);
}
