復制代碼 代碼如下:

using System.Linq.Expressions;

public static class PredicateExtensionses
{
public static Expression<Func<T, bool>> True<T>() { return f => true; }

public static Expression<Func<T, bool>> False<T>() { return f => false; }

public static Expression<Func<T, bool>> Or<T>(this Expression<Func<T, bool>> exp_flow, Expression<Func<T, bool>> expression2)
{

var invokedExpression = System.Linq.Expressions.Expression.Invoke(expression2, exp_flow.Parameters.Cast<System.Linq.Expressions.Expression>());

return System.Linq.Expressions.Expression.Lambda<Func<T, bool>>(System.Linq.Expressions.Expression.Or(exp_flow.Body, invokedExpression), exp_flow.Parameters);

}
public static Expression<Func<T, bool>> And<T>(this Expression<Func<T, bool>> exp_flow, Expression<Func<T, bool>> expression2)
{

var invokedExpression = System.Linq.Expressions.Expression.Invoke(expression2, exp_flow.Parameters.Cast<System.Linq.Expressions.Expression>());

return System.Linq.Expressions.Expression.Lambda<Func<T, bool>>(System.Linq.Expressions.Expression.And(exp_flow.Body, invokedExpression), exp_flow.Parameters);

}

}

復制代碼 代碼如下:

private void ListDataBind(int pageIndex)
{
int rowCount = 0;
int pageCount = 0;
int pageSize = 30;
Expression<Func<FeedBack, bool>> expr = PredicateExtensionses.True<FeedBack>();
GetCondition(ref expr);
var hs = from h in hm.AllFeedBacks.Where(expr) select h;//延遲加載,數據庫沒有任何操作
if (pageIndex == 1)//如果是第一次取數據,需要獲取符合條件的總記錄條數
{
rowCount = hs.Count();//數據庫進行一次Count操作
}
else//之后的記錄條數,從分頁控件持久態的屬性中獲取,省去一次Count查詢
{
rowCount = PageNavigator1.RecordCount;
}
pageCount = rowCount > pageSize ? Convert.ToInt32((rowCount - 1) / pageSize) + 1 : 1;//通用分頁算法
if (pageIndex > pageCount)
{
pageIndex = pageCount;
}
var pageData = hs.Skip(pageSize * (pageIndex - 1)).Take(pageSize);//這里也是延遲加載,數據庫此時不操作
FeedBackManageList.DataSource = pageData;//這里才正式加載數據,僅僅向數據庫發出請求30條記錄SQL
FeedBackManageList.DataBind();
PageNavigator1.RecordCount = rowCount;// 給分頁控件一些數據
PageNavigator1.PageCount = pageCount;//給分頁控件一些數據
PageNavigator1.PageIndex = pageIndex;//給分頁控件一些數據
}

復制代碼 代碼如下:

private void GetCondition(ref Expression<Func<FeedBack, bool>> expr) {
int isLock = Int32.Parse(ddlIsLock.SelectedValue);
if (isLock > -1)
{
expr = expr.And(c => (c.IsLock == isLock));//一次組合
}
string keyword = tbxKeyword.Text.FilterInjectStr();
if (!keyword.IsNullOrEmpty())
{
expr = expr.And(c => (c.HotelName.IndexOf(keyword) > -1)); //二次組合
}
}