执行多个lanmada表达式查询

 /// <summary>
        /// 执行多个lanmada表达式查询
        /// </summary>
        /// <typeparam name="T">类型</typeparam>
        /// <param name="row">每页条数</param>
        /// <param name="page">当前页</param>
        /// <param name="total">数据条数</param>
        /// <param name="wherelambdas">lanbda表达式集合</param>
        /// <returns></returns>
        public List<T> SearchByKey<T>(int row,int page,ref int total,List<Func<T, bool>> wherelambdas) where T : class,new()
        {
            //获取所有的数据集合
            List<T> list = LoadEntitiesss<T>(s => true);
            List<T> listNew = new List<T>();
            foreach (Func<T,bool> item in wherelambdas)
            {
               list =  list.Where<T>(item).ToList();
            }

            total = list.Count;//获取总条数
            int start = row * (page - 1);//开始数据
            int end = row * page;//结束数据

            if (total > start)
            {
                end = total < end ? total : end;//判断结束 是否大于数据总条数
                for (int i = start; i < end; i++)
                {
                    listNew.Add(list[i]);
                }
            }

            return listNew;
        }

使用方法:   

SearchByKey() 放在公共方法中   写方法的时候 直接继承

public class WLConfirmEnteringWarehouseOrderBLL : BaseBLL

{

........

}

 

 /// <summary>
        /// 绑定数据
        /// </summary>
        /// <returns></returns>
        public string GetWLConfirmEnteringWarehouseOrderList()
        {
            string action = ResponseHelper.GetRequestParam("action");
            string first = ResponseHelper.GetRequestParam("first");

            int page = ConvertHelper.ToInt(ResponseHelper.GetRequestParam("page"));
            int row = ConvertHelper.ToInt(ResponseHelper.GetRequestParam("rows"));
            int total = 0;
            if (first.ToLower() == "first")
            {
                return LoadPagerEntities<TPMPurchaseOrder, int>(row, page, s => false, "asc", s => s.purchaseId);
            }
            else
            {
                //客户通知单号
                string custNoticeCode = ResponseHelper.GetRequestParam("custNoticeCode1") == null ? "" : ResponseHelper.GetRequestParam("custNoticeCode1");
                //客户
                string custId = ResponseHelper.GetRequestParam("custId1") == null ? "" : ResponseHelper.GetRequestParam("custId1");
                //内部通知单号
                string innerNoticeCode = ResponseHelper.GetRequestParam("innerNoticeCode1") == null ? "" : ResponseHelper.GetRequestParam("innerNoticeCode1");
                //验收日期
                string checkDateStart = ResponseHelper.GetRequestParam("checkDateStart") == null ? "" : ResponseHelper.GetRequestParam("checkDateStart");
                string checkDateEnd = ResponseHelper.GetRequestParam("checkDateEnd") == null ? "" : ResponseHelper.GetRequestParam("checkDateEnd");
                //上架日期
                string goShelfDateStart = ResponseHelper.GetRequestParam("goShelfDateStart") == null ? "" : ResponseHelper.GetRequestParam("goShelfDateStart");
                string goShelfDateEnd = ResponseHelper.GetRequestParam("goShelfDateEnd") == null ? "" : ResponseHelper.GetRequestParam("goShelfDateEnd");
                //上架确认日期
                string requestConfirmDateStart = ResponseHelper.GetRequestParam("requestConfirmDateStart") == null ? "" : ResponseHelper.GetRequestParam("requestConfirmDateStart");
                string requestConfirmDateEnd = ResponseHelper.GetRequestParam("requestConfirmDateEnd") == null ? "" : ResponseHelper.GetRequestParam("requestConfirmDateEnd");
                //状态
                string status = ResponseHelper.GetRequestParam("status1") == null ? "" : ResponseHelper.GetRequestParam("status1");
                List<Func<TPMPurchaseOrder, bool>> funcList = new List<Func<TPMPurchaseOrder, bool>>();
                #region 条件1
                Func<TPMPurchaseOrder, bool> condition1 = s => true;
                if (custId != "")
                {
                    condition1 = s => s.custId == ConvertHelper.ToInt(custId);
                }
                #endregion
                #region 条件2
                Func<TPMPurchaseOrder, bool> condition2 = s => true;
                if (status == "7")
                {
                    condition2 = s => s.custNoticeCode.Contains(custNoticeCode) && s.innerNoticeCode.Contains(innerNoticeCode) && (s.status == "3" || s.status == "4" || s.status == "5" || s.status == "6");
                }
                else
                {
                    condition2 = s => s.custNoticeCode.Contains(custNoticeCode) && s.innerNoticeCode.Contains(innerNoticeCode) && s.status == status;
                }
                #endregion
                #region 条件3
                //验收日期
                Func<TPMPurchaseOrder, bool> condition3 = s => true;
                if (checkDateStart != "" && checkDateEnd != "")
                {
                    DateTime checkDateStartDate = ConvertHelper.ToDateTime(checkDateStart, "");
                    DateTime checkDateEndDate = ConvertHelper.ToDateTime(checkDateEnd, "");
                    condition3 = s => s.checkDate >= checkDateStartDate && s.checkDate <= checkDateEndDate;
                }
                else if (checkDateStart != "")
                {
                    DateTime checkDateStartDate = ConvertHelper.ToDateTime(checkDateStart, "");
                    condition3 = s => s.checkDate >= checkDateStartDate;
                }
                else if (checkDateEnd != "")
                {
                    DateTime checkDateEndDate = ConvertHelper.ToDateTime(checkDateEnd, "");
                    condition3 = s => s.checkDate <= checkDateEndDate;
                }
                #endregion
                #region 条件4
                Func<TPMPurchaseOrder, bool> condition4 = s => true;
                //上架日期
                if (goShelfDateStart != "" && goShelfDateEnd != "")
                {
                    DateTime goShelfDateStartDate = ConvertHelper.ToDateTime(goShelfDateStart, "");
                    DateTime goShelfDateEndDate = ConvertHelper.ToDateTime(goShelfDateEnd, "");
                    condition4 = s => s.goShelfDate >= goShelfDateStartDate && s.goShelfDate >= goShelfDateEndDate;
                }
                else if (goShelfDateStart != "")
                {
                    DateTime goShelfDateStartDate = ConvertHelper.ToDateTime(goShelfDateStart, "");
                    condition4 = s => s.goShelfDate >= goShelfDateStartDate;
                }
                else if (goShelfDateEnd != "")
                {
                    DateTime goShelfDateEndDate = ConvertHelper.ToDateTime(goShelfDateEnd, "");
                    condition4 = s => s.goShelfDate <= goShelfDateEndDate;
                }
                #endregion
                #region 条件5
                Func<TPMPurchaseOrder, bool> condition5 = s => true;
                //上架确认日期
                if (requestConfirmDateStart != "" && requestConfirmDateEnd != "")
                {
                    DateTime requestConfirmDateStartDate = ConvertHelper.ToDateTime(requestConfirmDateStart, "");
                    DateTime requestConfirmDateEndDate = ConvertHelper.ToDateTime(requestConfirmDateEnd, "");
                    condition5 = s => s.requestGoShelfDate >= requestConfirmDateStartDate && s.requestGoShelfDate <= requestConfirmDateEndDate;
                }
                else if (requestConfirmDateStart != "")
                {
                    DateTime requestConfirmDateStartDate = ConvertHelper.ToDateTime(requestConfirmDateStart, "");
                    condition5 = s => s.requestGoShelfDate >= requestConfirmDateStartDate;
                }
                else if (requestConfirmDateEnd != "")
                {
                    DateTime requestConfirmDateEndDate = ConvertHelper.ToDateTime(requestConfirmDateEnd, "");
                    condition5 = s => s.requestGoShelfDate <= requestConfirmDateEndDate;
                }
                #endregion
                funcList.Add(condition1);
                funcList.Add(condition2);
                funcList.Add(condition3);
                funcList.Add(condition4);
                funcList.Add(condition5);
                List<TPMPurchaseOrder> tPMPurchaseOrderList = SearchByKey<TPMPurchaseOrder>(row, page, ref total, funcList);
                string r = JsonHelper.JsonSerialize(tPMPurchaseOrderList);
                return ResponseHelper.ResponseJson(total.ToString(), r);
            }
        }