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 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; } } }