/// <summary> /// 取得考试过程详细信息 /// </summary> /// <param name="ProcessID"></param> /// <returns></returns> public static ExamProcessShowModel GetExamProessInfo(int ProcessID) { string SQL = @"Select U.Name As UserName, U.Sex, U.Email, U.PhoneNo, U.Addres, U.Education, U.School, U.Subject, Process.BeginTime, Process.EndTime, datediff(minute, Process.BeginTime,Process.EndTime ) As UsedTime, Process.Evaluate, Paper.Name as PaperName From ExamUser U Inner Join ExamProcess Process On Process.UserID = U.ID Inner Join ExamPaper Paper On Paper.ID = Process.ExamPaperID Where Process.Id = @ProcessID"; DataTable tb = new DataTable(); ExamProcessShowModel model=null; using (SqlHelper helper = new SqlHelper()) { try { List<SqlParameter> parameters = new List<SqlParameter>(); parameters.Add(new SqlParameter("@ProcessID", ProcessID)); tb = helper.ExecuteDataTable(SQL, CommandType.Text, parameters); if (tb.Rows.Count > 0) { model = new ExamProcessShowModel(); model.UserName = tb.Rows[0]["UserName"].ToString().Trim(); model.UserSex = tb.Rows[0]["Sex"].ToString(); model.Email = tb.Rows[0]["Email"].ToString().Trim(); model.PhoneNo = tb.Rows[0]["PhoneNo"].ToString().Trim(); model.Addres = tb.Rows[0]["Addres"].ToString().Trim(); model.Education = tb.Rows[0]["Education"].ToString().Trim(); model.School = tb.Rows[0]["School"].ToString().Trim(); model.Subject = tb.Rows[0]["Subject"].ToString().Trim(); model.PaperName = tb.Rows[0]["PaperName"].ToString().Trim(); model.BeginTime = (DateTime)tb.Rows[0]["BeginTime"]; model.EndTime = (DateTime)tb.Rows[0]["EndTime"]; model.UsedTime = tb.Rows[0]["UsedTime"].ToString() + "分钟"; model.Evaluate = tb.Rows[0]["Evaluate"].ToString().Trim(); } } catch (Exception ex) { return null; } } return model; }
/// <summary> /// 取得考试过程列表信息 /// </summary> public static IList<ExamProcessShowModel> GetExamProessList() { string SQL = @"Select P.Id,P.UserID,U.Name As UserName,P.ExamPaperID As PaperID,Paper.Name As PaperName,P.BeginTime,P.EndTime ,datediff(minute, P.BeginTime,P.EndTime ) As UsedTime, P.Evaluate from ExamProcess P Inner Join ExamUser U On U.Id = P.UserID Inner Join ExamPaper Paper On Paper.Id = P.ExamPaperID Order By P.EndTime Desc"; DataTable tb = new DataTable(); List<ExamProcessShowModel> lists = new List<ExamProcessShowModel>(); ExamProcessShowModel model; using (SqlHelper helper = new SqlHelper()) { try { List<SqlParameter> parameters = new List<SqlParameter>(); tb = helper.ExecuteDataTable(SQL, CommandType.Text, parameters); for (int i = 0; i < tb.Rows.Count; i++) { model = new ExamProcessShowModel(); model.Id = (int)tb.Rows[i]["Id"]; model.UserID = (int)tb.Rows[i]["UserID"]; model.UserName = tb.Rows[i]["UserName"].ToString(); model.PaperID = (int)tb.Rows[i]["PaperID"]; model.PaperName = tb.Rows[i]["PaperName"].ToString(); model.BeginTime = (DateTime)tb.Rows[i]["BeginTime"]; model.EndTime = (DateTime)tb.Rows[i]["EndTime"]; model.UsedTime = tb.Rows[i]["UsedTime"].ToString() + "分钟"; model.Evaluate = tb.Rows[i]["Evaluate"].ToString(); lists.Add(model); } } catch (Exception ex) { return null; } } return lists; }