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