LIOT/EMiS.DataLogic/SystemDAL/WechatPayListDAL.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using EMIS.DataLogic.Repositories;
using EMIS.Entities;
using EMIS.ViewModel;

namespace EMIS.DataLogic.SystemDAL
{
    public class WechatPayListDAL
    {
        public WechatPayListRepository WechatPayListRepository { get; set; }
        public ExaminationRegistrationRepository ExaminationRegistrationRepository { get; set; }

        public IQueryable<CF_WechatPayList> GetWechatPayListQueryable()
        {
            var query = from a in ExaminationRegistrationRepository.Entities.Where(x => x.RecordStatus == (int)EX_ExaminationRegistrationStatus.ForPay || x.RecordStatus == (int)EX_ExaminationRegistrationStatus.Paying)
                        from b in WechatPayListRepository.Entities.Where(x => x.ExaminationRegistrationID == a.ExaminationRegistrationID)
                        select b;
            return query;
        }
    }
}