8,497
社区成员
发帖
与我相关
我的任务
分享
var Check = (from S in DC.Study
join P in DC.Patient on S.PatientID equals P.pID
join R in DC.Result on S.StuID equals R.sID
where S.rMod == _mod
select new {P,S};
if(!string.IsNullOrEmpty(_Date))
{
Check=Check.Where(c=>c.S.beginDate <= _Date && c.S.endDate <=_Date);
}
var result=Check.Select(c=>new
{
姓名 = c.P.pName,
性别 = c.P.SexTitle,
年龄 = DateTime.Now.Year - Convert.ToDateTime(c.P.birdat).Year,
是否打印 = c.S.IsPrinted,
}).Distinct();