Hashtable hs = new Hashtable();
string name = "Carl"; // 可以通过其他方式获得值 比如request
string sex = "男";
string ange = "";
if ((!name.Equals(""))&&name!=null)
{
hs.Add("name", name);
}
if ((!sex.Equals("")) && sex != null)
{
hs.Add("sex", sex);
}
if((!ange.Equals(""))&&ange!=null){
hs.Add("ange", ange);
}
string temp="where ";
foreach (DictionaryEntry dicEntry in hs)
{
temp = temp + "Employee." + dicEntry.Key + " like '%" + dicEntry.Value + "%' and ";
}
if (temp.Equals("where ")) temp = " ";
else
{
int len = temp.Length - 5;
temp = temp.Substring(0, len);
}
Console.WriteLine(temp);
注意:Hashtable 是无序排出的,对有顺序要求的不可以这样 可以考虑ArrayList。