多条件查询

public DataSet DBChaxincaipin(string fooddalei,string foodxiaolei,string foodsmell,string dangqianstate,string foodname,string jifeidanjia,string text)
       {

           objSqlConnection = GetCon.Getstring();
           DataSet objDataSet = new DataSet();
           string sql = "select foodname as 菜品名称,fooddalei as 菜品大类,foodxiaolei as 菜品小类,foodsmell as 菜品风味,jiliangdanwei as 计量单位,jifeidanjia as 计费单价,dangqianstate as 当前状态,addsay as 补充说明 from foodinformation where ";
           //List表示可以通过索引访问的对象的强类型列表，提供用于对列表进行搜索、排序和操作的方法
           List<string> ll = new List<string>();
           if (fooddalei != "")
           {
               //食物大类
               ll.Add("fooddalei like'%" +fooddalei  + "%'");
           }
           if (foodxiaolei != "")
           {
               //食物小类
               ll.Add("foodxiaolei like'%" + foodxiaolei + "%'");
           }

           if (foodsmell != "")
           {
               //食物风味
               ll.Add("foodsmell like'%" + foodsmell + "%'");
           }

           if (dangqianstate != "")
           {
               //当前状态
               ll.Add("dangqianstate like'%" + dangqianstate + "%'");
           }
           if (foodname != "")
           {
               //食物名称
               ll.Add("foodname like'%" + foodname + "%'");
           }
           if (jifeidanjia != "")
           {
               ll.Add("jifeidanjia between "+ jifeidanjia +" and "+text);
           }
           sql += ll[0];

           for (int i = 1; i < ll.Count; i++)
           {
               sql = sql + " and " + ll[i];
           }

           try
           {
               objda = new SqlDataAdapter(sql, objSqlConnection);
               objda.Fill(objDataSet);
           }
           catch (Exception ex)
           {
               throw ex;
           }

           return objDataSet;
       }