/// <summary>
        /// 优惠券明细数据过滤
        /// </summary>
        /// <param name="couponsNo"></param>
        /// <param name="user"></param>
        /// <param name="status"></param>
        /// <param name="faceVal"></param>
        /// <param name="beginTime"></param>
        /// <param name="endTime"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public dynamic GetCouponsDetails(CouponDetail coupondetail, PageInfo pageInfo, out int totalCount)
        {
            var query = _context.CouponDetails.Where(p => p.IsDeleted != 1);

            if (!coupondetail.CouponSN.IsNullOrEmpty())
            {
                query = query.Where(p => p.CouponSN.Contains(coupondetail.CouponSN));
            }
            if (!coupondetail.MemberId.IsNullOrEmpty())
            {//coupondetail.MemberId 传手机号
                var customer = new CustomersService().GetCustomerByWhere(a => a.Mobile.Contains(coupondetail.MemberId) && a.IsDeleted != 1);
                if (customer.Count() > 0)
                {
                    string ids = "";
                    foreach (var item in customer)
                    {
                        ids += item.Id + ",";
                    }
                    query = query.Where(p => ids.Contains(p.MemberId));
                }
            }
            //-1=全部
            if (coupondetail.UseState != -1)
            {
                query = query.Where(a => a.UseState.Equals(coupondetail.UseState));
            }
            if (coupondetail.CouponBatch.IsNotNullOrEmpty())
            {
                query = query.Where(a => a.CouponBatch.Contains(coupondetail.CouponBatch));
            }
            if (coupondetail.Denomination > 0)
            {
                query = query.Where(a => a.Denomination.Equals(coupondetail.Denomination));
            }
            if (coupondetail.BeginValidDate != new DateTime())
            {
                query = query.Where(a => a.BeginValidDate <coupondetail.BeginValidDate && a.EndValidDate> coupondetail.BeginValidDate);
            }
            //if (coupondetail.EndValidDate != new DateTime())
            //{
            //    query = query.Where(a => a.EndValidDate < coupondetail.EndValidDate);
            //}
            totalCount = query.Count();
            var result = (from x in query
                          join cu1 in _context.Customers
                          on x.MemberId equals cu1.Id into temp1
                          join cu2 in _context.Customers
                          on x.UseMemberId equals cu2.Id into temp2
                          from cu1 in temp1.DefaultIfEmpty()
                          from cu2 in temp2.DefaultIfEmpty()
                          where x.IsDeleted != 1
                          select new
            {
                x.CouponSN,
                x.Denomination,
                x.SalesMoney,
                x.CreatedOn,
                x.BeginValidDate,
                x.EndValidDate,
                x.UseDate,
                x.UseState,
                x.UseMemberId,
                x.ConditionMoney,
                UseOrderSN = x.UseOrderSN,
                x.Title,
                OwnerMobile = cu1.Mobile,
                OwnerTel = cu1.Tel,
                OwnerFullName = cu1.FullName,
                UsedMobile = cu2.Mobile,
                UsedTel = cu2.Tel,
                UsedFullName = cu2.FullName,
                CouponBatch = x.CouponBatch
            }).OrderBy(p => p.UseState).ThenByDescending(p => p.CreatedOn).Skip((pageInfo.Page - 1) * pageInfo.Rows).Take(pageInfo.Rows);

            return(result.ToList());
        }