using System;
using System.Collections.Generic;
using System.Linq;
using WX.CRM.BLL.Util;
using WX.CRM.Common;
using WX.CRM.IBLL.Wx;
using WX.CRM.Model.Entity;

namespace WX.CRM.BLL.Wx
{
    public class WX_STOCKRECOMMEND_BL : DbContextRepository<WX_STOCKRECOMMEND>, IWX_STOCKRECOMMEND
    {
        public List<WX_STOCKRECOMMEND> GetList(ref Pager pager, decimal? userId, string stockCode, string stockName, string stime, string etime)
        {
            using (var db = new crmContext())
            {
                var queryData = db.WX_STOCKRECOMMEND.AsQueryable();
                if (userId.HasValue)
                {
                    queryData = queryData.Where(m => m.REFERRERID == userId);
                }
                if (!string.IsNullOrWhiteSpace(stockCode))
                {
                    stockCode = stockCode.Trim();
                    queryData = queryData.Where(m => m.STOCKCODE == stockCode);
                }
                if (!string.IsNullOrWhiteSpace(stockName))
                {
                    stockName = stockName.Trim();
                    queryData = queryData.Where(m => m.STOCKNAME == stockName);
                }
                if (!string.IsNullOrWhiteSpace(stime))
                {
                    DateTime time1 = Convert.ToDateTime(stime);
                    queryData = queryData.Where(m => m.BUYDATE >= time1);
                }
                if (!string.IsNullOrWhiteSpace(etime))
                {
                    DateTime time2 = Convert.ToDateTime(etime).AddDays(1);
                    queryData = queryData.Where(m => m.BUYDATE < time2);
                }
                queryData = queryData.OrderByDescending(m => m.BUYDATE);
                PagerUtil.SetPager<WX_STOCKRECOMMEND>(ref queryData, ref pager);
                return queryData.ToList();
            }
        }
    }
}