linq to sql的多条件动态查询(上)

void ShowData() 
    {
        using (DBDataContext db = new DBDataContext(Database.ConnectionString))
        {
            Expression<Func<T_Bargin, bool>> expr = n => GetCondition(n);
            var _query = db.T_Bargins.Where<T_Bargin>(expr.Compile()).Select(b => new { b.F_Money, b.F_Name });
            foreach (var item in _query)
            {
                Response.Write(item.F_Name + "&nbsp;" + item.F_Money.ToString() +  "<br/>");
            }
        }     
    }


    //得到合同金额大于6000,或合同名称中包含"江华"字的条件
    private bool GetCondition(T_Bargin _Table)
    {       

        bool _result = false;

        decimal _MinMoney = 6000;

        if (_MinMoney > 0)
        {
            _result |= _Table.F_Money >= _MinMoney;
        }

        string _Name = "江华";

        if (!String.IsNullOrEmpty(_Name))
        {
            _result |= _Table.F_Name.Contains(_Name);
        }
        
        return _result;
    }