StringBuilder begin = new StringBuilder();
int index = 1;
foreach (char item in brxm)
{
if (item != '-')
{
index++;
begin.Append(string.Format("{0}", item));
}
else
{
break;
}
}
string end1 = brxm.Substring(index);
sqlStr.Append(string.Format("and(sampid >='{0}' and sampid <='{1}')", begin, end1));
//string[] array = brxm.Split('-');
//sqlStr.Append(string.Format("and(sampid >='{0}' and sampid<='{1}')",array[0],array[1]));