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()); }