public async Task <IncomeTotalModel> IncomeTotalModelList(IncomeDevideIn IncomeDevideInfo) { IncomeTotalModel model = new IncomeTotalModel(); var Income = _repository.GetAll().Where(IncomeDevideInfo.Expression); var consulres = _consulrepository.GetAll().Where(t => t.IsDelete == false && t.ConsultState == "success"); var orderres = _orderrepository.GetAll().Where(t => t.IsDelete == false); var ordertraderes = _OrderTradeRecordrepository.GetAll().Where(t => t.IsDelete == false && t.PayType == "wxpay" && t.PaymentSourceCode == "order" && t.PaymentState == "paid"); var consuls = from a in consulres join b in Income on a.ConsultNumber equals b.ConsultNumber select a; var orders = from c in orderres join a in consulres on c.ConsultNumber equals a.ConsultNumber join b in Income on a.ConsultNumber equals b.ConsultNumber select c; var ordertrades = from d in ordertraderes join c in orderres on d.OrderNumber equals c.OrderNumber join a in consulres on c.ConsultNumber equals a.ConsultNumber join b in Income on a.ConsultNumber equals b.ConsultNumber select d; model.incomeDevides = await Income.ToListAsync(); model.yaeherConsultations = await consuls.ToListAsync(); model.orderManages = await orders.ToListAsync(); model.orderTradeRecords = await ordertrades.ToListAsync(); return(model); }
public async Task <IList <IncomeDevide> > IncomeForeignDevideList(IncomeDevideIn IncomeDevideInfo) { var query = _repository.GetAll().Where(IncomeDevideInfo.Expression); var doctor = _doctorrepository.GetAll().Where(t => t.IsDelete == false && t.IsSharing == false); var incomelist = from a in query join b in doctor on a.DoctorID equals b.Id select a; return(await incomelist.ToListAsync()); }
public async Task <PagedResultDto <IncomeDevide> > IncomeDevidePage(IncomeDevideIn IncomeDevideInfo) { //初步过滤 var query = _repository.GetAll().Where(IncomeDevideInfo.Expression); //获取总数 var tasksCount = query.Count(); //获取总数 var totalpage = tasksCount / IncomeDevideInfo.MaxResultCount; var YaeherDoctorList = await query.PageBy(IncomeDevideInfo.SkipCount, IncomeDevideInfo.MaxResultCount).ToListAsync(); return(new PagedResultDto <IncomeDevide>(tasksCount, YaeherDoctorList.MapTo <List <IncomeDevide> >())); }
public async Task <IList <IncomeDevide> > IncomeDevideList(IncomeDevideIn IncomeDevideInfo) { var YaeherDoctors = await _repository.GetAllListAsync(IncomeDevideInfo.Expression); return(YaeherDoctors.ToList()); }