/// <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"); } } }