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

namespace WX.CRM.BLL.Base
{
    public class BAS_FEEDBACK_BL : DbContextRepository<BAS_FEEDBACK>, IBAS_FEEDBACK
    {
        public List<BAS_FEEDBACK> GetList(ref Pager page, decimal? innerUserId, string content, string stime, string etime)
        {
            using (var db = new crmContext())
            {
                var queryData = db.BAS_FEEDBACK.AsQueryable();
                if (innerUserId.HasValue)
                {
                    queryData = queryData.Where(m => m.INNERUSERID == innerUserId && m.SHOWTYPE == 1);
                }
                if (!string.IsNullOrWhiteSpace(content))
                {
                    content = content.Trim();
                    queryData = queryData.Where(m => m.CONTENT.Contains(content));
                }
                if (!string.IsNullOrWhiteSpace(stime))
                {
                    DateTime dt = Convert.ToDateTime(stime);
                    queryData = queryData.Where(m => m.CTIME > dt);
                }
                if (!string.IsNullOrWhiteSpace(etime))
                {
                    DateTime dt = Convert.ToDateTime(etime).AddDays(1);
                    queryData = queryData.Where(m => m.CTIME < dt);
                }
                queryData = queryData.OrderByDescending(m => m.CTIME);
                PagerUtil.SetPager<BAS_FEEDBACK>(ref queryData, ref page);
                return queryData.ToList();
            }
        }
    }
}