c# 号查询的方法文本框带号

寂小魔

于 2012-08-02 16:20:38 发布

阅读量601

点赞数

文章标签： c# string sql

本文链接：https://blog.csdn.net/mimrc7993/article/details/7823508

版权

        /// <summary>
        /// *转%，sql的模糊查询
        /// </summary>
        /// <param name="key">字段名</param>
        /// <param name="value">字段值</param>
        /// <returns>T-SQL</returns>
        public static string SelectCmd(string key,string value)
        {
            if ((value.IndexOf("*") != 0) && (value.LastIndexOf("*") != (value.Length - 1)))
            {
                value = " " + key + " = '" + value + "'";
            }
            else
            {
                if ((value.IndexOf("*") == 0) && (value.LastIndexOf("*") == (value.Length - 1)))
                {
                    value = " " + key + " like '" + "%" + value.TrimEnd('*').TrimStart('*') + "%" + "'";
                }
                else
                {
                    if (value.IndexOf("*") == 0)
                    {
                        value = " " + key + " like '" + "%" + value.TrimStart('*') + "'";
                    }
                    else if (value.LastIndexOf("*") == (value.Length - 1))
                    {
                        value = " " + key + " like '" + value.TrimEnd('*') + "%" + "'";
                    }
                }
            }
            return value;            
        }
//还未写完整，继续奋斗中，有错误欢迎指出。谢谢