T - SQL 模糊多条件查询实现[,分隔]
if (Distribution_Address !="")
{
if (Distribution_Address.Trim().Length == 0)
{
strSql = " 1=1";
}
else
{
int start =0;//设定替换前的字符串长度
int end = 0;//设定替换后的字符串长度
string temptxt = Distribution_Address.Trim();
do
{
start = temptxt.Length;
temptxt = temptxt.Replace("，", ",").Replace(" ", " ");
end = temptxt.Length;
} while (start != end);//如果替换前后长度变化,则继续替换
string[] tempStr = temptxt.Split(',');
strSql += "and (";
foreach (string temp in tempStr)
{
if (strSql.Trim().Length != 0)
strSql += String.Format("(C_Address like '%{0}%')", temp);
strSql += "or";
}
strSql += " 1=2 )";
}
}