01|02|03| ====> (01,02,03)用于in id数组这种查询方式

//01|02|03| ====> (01,02,03)
string s = "(";
for (int i = 0; i < countryid.Split('|').Length; i++)
{
if (i > 0 && i < countryid.Split('|').Length-1)
{
s += ",";
}
s +=countryid.Split('|')[i];
}
s += ")";

string.Format(" CountryID in {0} ", s)

转载于:https://www.cnblogs.com/thinkingthigh/archive/2013/05/09/3069496.html