按拼音模糊匹配查询条件的生成类-白红宇的个人博客

按拼音模糊匹配查询条件的生成类

发布日期：2021-06-30 19:07:47 浏览次数：2 分类：技术文章

本文共 2180 字，大约阅读时间需要 7 分钟。

转载了好几个地方，很难确定最早的出处。

将源码贴出来先。

using

System;

using

System.Text;

using

System.IO;

namespace

{

class test

{

private static string[] startChars = {

"啊", "芭", "擦","搭","蛾","发","噶","哈",

"击","击","喀","垃","妈","拿","哦","啪","期","然", "撒","塌","挖","挖","挖","昔","压","匝"};

private static string[] endChars = {

"澳", "怖", "错","堕","贰","咐","过","祸",

"啊","骏","阔","络","穆","诺","沤","瀑","群","弱", "所","唾","啊","啊","误","迅","孕","座"};

/// <summary>

/// 根据字符和对应的中文字符,转成SQL查询条件

/// </summary>

/// <param name="cChar">要转化的字符,[A-Z]</param>

/// <param name="strFieldName">条件左值</param>

/// <returns>SQL条件</returns>

/// <remarks> Sxf 2001-1-4 ***** JY 2002-1-4 </remarks>

public static string GetCharCondition(char cChar, string strFieldName)

{

string strWord;

int Index = (int)(char.ToUpper(cChar)) - (int)'A';

if (Index >= 0 && Index < 26)

strWord = startChars[Index];

else

strWord = startChars[0];

//return string.Format("(({0}>='{1}' AND {0}<'[') OR ({0} >= '{3}' AND {0} < '{

{') OR {0}>='{2}')",

//strFieldName, char.ToUpper(cChar), strWord, char.ToLower(cChar));

return string.Format("(({0} >= '{3}' AND {0} <= 'zzzzzzzz') OR {0}>='{2}')",

strFieldName, char.ToUpper(cChar), strWord, char.ToLower(cChar));

}

/// <summary>

/// 将指定字段值的每个字符分割，这样可以生成同音查询的SQL

/// </summary>

/// <param name="fieldName">字段名</param>

/// <param name="fieldValue">字段值</param>

/// <returns>生成的可以进行同音查询的SQL</returns>

public static string GetCharFullCondition(string fieldName, string fieldValue)

{

StringBuilder sql = new StringBuilder(1024);

int i = 1;

foreach (char c in fieldValue)

{

if (i > 1)

sql.Append(" AND ");

int index = (int)(char.ToUpper(c)) - (int)'A';

string startWord, endWord;

if (index >= 0 && index < 26)

{

startWord = startChars[index];

endWord = endChars[index];

}

else

{

startWord = startChars[0];

endWord = endChars[0];

}

string subStr = String.Format("SUBSTRING({0}, {1}, {2})", fieldName, i, 1);

sql.AppendFormat("({0} BETWEEN '{1}' AND '{2}')", subStr, startWord, endWord);

++i;

}

return sql.ToString();

}

转载地址：https://linuxstyle.blog.csdn.net/article/details/1536924 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！

上一篇：数组的进一步使用

下一篇：浅析ado.net获取数据库元数据信息

发表评论

关于作者

喝酒易醉，品茶养心，人生如梦，品茶悟道，何以解忧？唯有杜康！

-- 愿君每日到此一游！

发表评论

最新留言

关于作者

推荐文章