在服务器端写查询LINQ的过滤条件

---备注

在服务器端写查询LINQ

//根据条件查询数据

public IList<TabRegulation> GetRegulationListByWhere(Dictionary<string, string> keyWords)
{
var qry_resources = from mylist in DbContext.TabRegulations
select mylist;

foreach (string key in keyWords.Keys)
{
switch (key)
{
//case "bt":
// var qry_resourcesbt = from mylist in DbContext.TabRegulations
// select mylist;
// //result = RegulationList.Where<TabRegulation>(n => n.RTitle.Contains(keyWords[key])).ToList();
// break;
//case "wh":
// result = result.Where<TabRegulation>(n => n.RNumber.Contains(keyWords[key])).ToList();
// break;
//case "bbdw":
// result = result.Where<TabRegulation>(n => n.Agency.Contains(keyWords[key])).ToList();
// break;
//case "bbrq":
// DateTime dt = Convert.ToDateTime(keyWords[key]);
// List<TabRegulation> result1 = new List<TabRegulation>();
// foreach (TabRegulation d in result)
// {
// (((DateTime)(d.ReleaseDate)).ToString()).Contains(keyWords[key].ToString());
// result1.Add(d);
// }
// result = result1;
// break;
//case "ssrq":
// result = result.Where<TabRegulation>(n => n.ApplyDate.ToString().Contains(keyWords[key])).ToList();
// break;
}
}

return qry_resources.ToList() as IList<TabRegulation>;
}