public virtual String GetInQueryValues(string[] values, bool encode)
{
string inQuery = string.Empty;
inQuery = SqlUtil.Encode(values, encode);
return(inQuery);
}
public virtual SqlStringBuilder AppendLessThanOrEqual(string junction, string column, string value)
{
if (!string.IsNullOrEmpty(value))
{
AppendInternal(junction, column, "<=", SqlUtil.Encode(value, true));
}
return(this);
}
public virtual String GetInQueryValues(string values, bool encode)
{
if (encode)
{
String[] split = values.Split(',');
values = SqlUtil.Encode(split, encode);
}
return(values);
}
public virtual SqlStringBuilder AppendRange(string junction, string column, string from, string to)
{
if (!string.IsNullOrEmpty(from) || !string.IsNullOrEmpty(to))
{
StringBuilder sb = new StringBuilder();
if (!string.IsNullOrEmpty(from))
{
sb.AppendFormat("{0} >= {1}", column, SqlUtil.Encode(from, true));
}
if (!string.IsNullOrEmpty(from) && !string.IsNullOrEmpty(to))
{
sb.AppendFormat(" {0} ", SqlUtil.AND);
}
if (!string.IsNullOrEmpty(to))
{
sb.AppendFormat("{0} <= {1}", column, SqlUtil.Encode(to, true));
}
AppendInternal(junction, sb.ToString());
}
return(this);
}
/// <summary>
/// 用SQL 表达式对特殊值进行编码，可选值用单引号括起
/// </summary>
/// <param name="values"></param>
/// <param name="surround"></param>
/// <returns></returns>
public static String Encode(String[] values, bool surround)
{
if (values == null || values.Length < 1)
{
return(SqlUtil.NULL);
}
StringBuilder csv = new StringBuilder();
foreach (String value in values)
{
if (!String.IsNullOrEmpty(value))
{
if (csv.Length > 0)
{
csv.Append(",");
}
csv.Append(SqlUtil.Encode(value.Trim(), surround));
}
}
return(csv.ToString());
}
