/// <summary> /// 根据返填需要修改的考生 /// </summary> /// <param name="candidate"></param> /// <returns></returns> public Candidateinherit UpdateById(int candidateId) { SqlSugarClient sugarClient = Educationcontext.GetClient(); Candidateinherit candidateinherit = sugarClient.Queryable <Candidate, TestRoom, ExamRoom, Company, TestTime>((CD, TR, ER, CP, TT) => CD.CompanyID == CP.Id && CD.ExamRoomID == ER.Id && CD.TestRoomID == TR.ID && CD.ExamNumber == TT.ExamNumberId).Select((CD, TR, ER, CP, TT) => new Candidateinherit { Certificates = CD.Certificates, CompanyName = CP.Name, DocumentType = CD.DocumentType, Enable = CD.Enable, ExamNumber = CD.ExamNumber, ExamRoomName = ER.Name, Field = CD.Field, ID = CD.ID, LongExam = TT.LongExam, Name = CD.Name, Photo = CD.Photo, ProgressOfAnswer = TT.ProgressOfAnswer, RemainderLength = TT.RemainderLength, SeatNumber = CD.SeatNumber, Sex = CD.Sex, TestRoomName = TR.Name, TimeUsed = TT.TimeUsed }).Where(m => m.ID == candidateId).First(); return(candidateinherit); }
/// <summary> /// 根据准考证号显示考生信息 /// </summary> /// <param name="examNumber"></param> /// <returns></returns> public Candidateinherit GetCandidatesByExamNumber(string examNumber) { Candidateinherit candidate = null; try { SqlSugarClient sugarClient = Educationcontext.GetClient(); //var candidate = sugarClient.Queryable<Candidate>().First(s=>s.ExamNumber==examNumber); candidate = sugarClient.SqlQueryable <Candidateinherit>(" select * from ( select a.*,c.`Name` as CompanyName,b.`Name` as TestRoomName, d.`Name` as ExamRoomName from candidate a,testroom b, examroom c ,company d where a.TestRoomID=b.Id and a.CompanyID=d.Id and a.ExamRoomID=c.Id) info where ExamNumber =" + examNumber).Single(); return(candidate); } catch (Exception) { return(candidate); } }