/// <summary>
/// Condition value setting
/// 条件値設定
/// </summary>
/// <param name="column"></param>
/// <param name="attribute"></param>
/// <param name="value"></param>
/// <param name="equal"></param>
private void AddConditionValue(string column, DataAccessAttribute attribute, string value, bool equal)
{
value = this.EscapeSingleQuotation(value.ToString());
if (equal)
{
WhereSql.AppendLine(string.Format("{0}.{1} = '{2}'", attribute.TableName, column, value.ToString()));
}
else
{
WhereSql.AppendLine(string.Format("{0}.{1} != '{2}'", attribute.TableName, column, value.ToString()));
}
}
/// <summary>
/// Condition value (in) setting
/// 条件値(in)設定
/// </summary>
/// <param name="column"></param>
/// <param name="attribute"></param>
/// <param name="values"></param>
/// <param name="equal"></param>
private void AddInConditionValue(string column, DataAccessAttribute attribute, string[] values, bool equal)
{
for (int i = 0; i < values.Length; i++)
{
values[i] = EscapeSingleQuotation(values[i]);
}
if (equal)
{
WhereSql.AppendLine(string.Format("{0}.{1} in ({2})", attribute.TableName, column, string.Format("'{0}'", string.Join("','", values))));
}
else
{
WhereSql.AppendLine(string.Format("{0}.{1} not in ({2})", attribute.TableName, column, string.Format("'{0}'", string.Join("','", values))));
}
}
/// <summary>
/// And Or statement setting
/// And Or 文設定
/// </summary>
/// <param name="andOr"></param>
private void AddOperator(bool isAnd)
{
if (string.IsNullOrEmpty(WhereSql.ToString()))
{
WhereSql.AppendLine("where");
}
else
{
if (isAnd)
{
WhereSql.AppendLine("and");
}
else
{
WhereSql.AppendLine("or");
}
}
}