using System.Collections.Generic;
using System.Data;
using System.Linq;
using WX.CRM.BLL.Util;
using WX.CRM.Common;
using WX.CRM.DAL.QH;
using WX.CRM.IBLL.QH;
using WX.CRM.Model.Entity;

namespace WX.CRM.BLL.QH
{
    public class QH_TRANSACTIONDETAIL_BL : DbContextRepository<QH_TRANSACTIONDETAIL>, IQH_TRANSACTIONDETAIL
    {
        QH_TRANSACTIONDETAIL_DAL qhtt_dal = new QH_TRANSACTIONDETAIL_DAL();
        public List<QH_TRANSACTIONDETAIL> GetList(ref Pager pager, string userAccount, string year, string quarter)
        {
            DataTable dt = qhtt_dal.GetList(ref pager, userAccount, year, quarter);
            return dt.ToList<QH_TRANSACTIONDETAIL>();
        }
        public List<QH_TRANSACTIONDETAIL> GetList(ref Pager pager, string productName, string exChange, string contractCode, string userAccount, string name)
        {
            using (var db = new crmContext())
            {
                IQueryable<QH_TRANSACTIONDETAIL> queryable = db.QH_TRANSACTIONDETAIL.AsQueryable();
                if (!string.IsNullOrEmpty(productName))
                {
                    queryable = queryable.Where(p => p.PRODUCTNAME == productName);
                }
                if (!string.IsNullOrEmpty(exChange))
                {
                    queryable = queryable.Where(p => p.EXCHANGE == exChange);
                }
                if (!string.IsNullOrEmpty(contractCode))
                {
                    queryable = queryable.Where(p => p.CONTRACTCODE == contractCode);
                }
                if (!string.IsNullOrEmpty(userAccount))
                {
                    queryable = queryable.Where(p => p.USERACCOUNT == userAccount);
                }
                if (!string.IsNullOrEmpty(name))
                {
                    queryable = queryable.Where(p => p.ACCOUNTNAME.Contains(name));
                }
                queryable = queryable.OrderByDescending(p => p.CTIME);
                PagerUtil.SetPager(ref queryable, ref pager);
                return queryable.ToList();
            }
        }

        public List<QH_TRANSACTIONDETAIL> GetList(ref Pager pager, string useraccount)
        {
            using (var db = new crmContext())
            {
                var query = db.QH_TRANSACTIONDETAIL.AsQueryable();
                if (!string.IsNullOrEmpty(useraccount))
                {
                    query = query.Where(m => m.USERACCOUNT == useraccount);
                }
                query = query.OrderByDescending(m => m.CTIME);
                PagerUtil.SetPager(ref query, ref pager);
                return query.ToList();
            }
        }
    }
}