SQLString

最新推荐文章于 2022-08-13 18:02:18 发布

zyy1990052820080643

最新推荐文章于 2022-08-13 18:02:18 发布

阅读量1.3k

点赞数 1

文章标签： string sql class

本文链接：https://blog.csdn.net/zyy1990052820080643/article/details/6494956

版权

using System;
using System.Collections;

namespace BookShop.Common
{
/// <summary>
/// SQLString 的摘要说明。
/// </summary>
public class SqlStringConstructor
{
  /// <summary>
  /// 公有静态方法，将文本转换成适合在Sql语句里使用的字符串。
  /// </summary>
  /// <returns>转换后文本</returns>
  public static String GetQuotedString(String pStr)
  {
   return ("'" + pStr.Replace("'","''") + "'");
  }

  /// <summary>
  /// 根据条件哈希表,构造SQL语句中的AND条件子句
  /// </summary>
  /// <param name="conditionHash">条件哈希表</param>
  /// <returns>AND关系条件子句</returns>
        public static String GetConditionClause(Hashtable queryItems)
        {

            int Count = 0;
            String Where = "";

            //根据哈希表，循环生成条件子句
            foreach (DictionaryEntry item in queryItems)
            {
                if (Count == 0)
                    Where = " where ";
                else
                    Where += " and ";

                //根据查询列的数据类型，决定是否加单引号
                if (item.Value.GetType().ToString() == "System.String" )
                {
                    Where += item.Key.ToString()
                        + " like "
                        + SqlStringConstructor.GetQuotedString("%"
                        + item.Value.ToString()
                        + "%");

                }
                else if (item.Value.GetType().ToString() == "System.DateTime[]")
                {
                    string[] time = item.Value.ToString().Split(',');
                        Where += item.Key.ToString()
                               + " between "
                               + SqlStringConstructor.GetQuotedString(((DateTime[])item.Value)[0].ToString()) + " and " + SqlStringConstructor.GetQuotedString(((DateTime[])item.Value)[1].ToString());




                }

                else
                {
                    Where += item.Key.ToString() + "= " + item.Value.ToString();
                }
                Count++;
            }
            return Where;
        }
}
}