public async Task <IList <DoctorPaperView> > DoctorPaperViewList(DoctorPaperIn DoctorPaperInfo)
{
var relation = _repository.GetAll().OrderByDescending(a => a.CreatedOn);
var querylist = from a in relation
where !a.IsDelete && a.DoctorID == DoctorPaperInfo.DoctorId && a.CheckState == "success"
select new DoctorPaperView
{
ImageFie = a.ImageFie,
DoctorName = a.DoctorName,
DoctorID = a.DoctorID,
PaperTiltle = a.PaperTiltle,
PaperContent = a.PaperContent,
PaperFrom = a.PaperFrom,
ConsultNumber = a.ConsultNumber,
PaperAddress = a.PaperAddress,
Checker = a.Checker,
CheckState = a.CheckState,
CheckRemark = a.CheckRemark,
CheckTime = a.CheckTime,
Id = a.Id,
CreatedOn = a.CreatedOn,
};
var DoctorPaperList = await querylist.PageBy(DoctorPaperInfo.SkipTotal, DoctorPaperInfo.MaxResultCount).ToListAsync();
return(DoctorPaperList);
}
public async Task <PagedResultDto <DoctorPaper> > DoctorPaperPage(DoctorPaperIn DoctorPaperInfo)
{
//初步过滤
var query = _repository.GetAll().Where(DoctorPaperInfo.Expression);
//获取总数
var tasksCount = query.Count();
//获取总数
var totalpage = tasksCount / DoctorPaperInfo.MaxResultCount;
var DoctorPaperList = await query.PageBy(DoctorPaperInfo.SkipTotal, DoctorPaperInfo.MaxResultCount).ToListAsync();
return(new PagedResultDto <DoctorPaper>(tasksCount, DoctorPaperList.MapTo <List <DoctorPaper> >()));
}
public async Task <PagedResultDto <DoctorPaperView> > DoctorPaperViewPage(DoctorPaperIn DoctorPaperInfo)
{
var relation = _repository.GetAll().OrderByDescending(a => a.CreatedOn).Where(DoctorPaperInfo.Expression);
var sysfrom = _sysrepository.GetAll().Where(t => !t.IsDelete && t.SystemCode == "DoctorPaperFrom");
var sysstate = _sysrepository.GetAll().Where(t => !t.IsDelete && t.SystemCode == "DoctorPaperState");
var query = from a in relation
join b in sysfrom on a.PaperFrom equals b.Code
join c in sysstate on a.CheckState equals c.Code
select new DoctorPaperView
{
ImageFie = a.ImageFie,
DoctorName = a.DoctorName,
DoctorID = a.DoctorID,
PaperTiltle = a.PaperTiltle,
PaperContent = a.PaperContent,
PaperFrom = a.PaperFrom,
ConsultNumber = a.ConsultNumber,
PaperAddress = a.PaperAddress,
Checker = a.Checker,
CheckState = a.CheckState,
CheckRemark = a.CheckRemark,
CheckTime = a.CheckTime,
Id = a.Id,
DoctorPaperFrom = b.Name,
CheckStatus = c.Name,
ConsultID = a.ConsultID,
CreatedOn = a.CreatedOn,
};
//获取总数
var tasksCount = query.Count();
//获取总数
var totalpage = tasksCount / DoctorPaperInfo.MaxResultCount;
var DoctorPaperList = await query.PageBy(DoctorPaperInfo.SkipTotal, DoctorPaperInfo.MaxResultCount).ToListAsync();
return(new PagedResultDto <DoctorPaperView>(tasksCount, DoctorPaperList.MapTo <List <DoctorPaperView> >()));
}
public async Task <IList <DoctorPaper> > DoctorPaperList(DoctorPaperIn DoctorPaperInfo)
{
var DoctorPapers = await _repository.GetAllListAsync(DoctorPaperInfo.Expression);
return(DoctorPapers.ToList());
}
