/// <summary> /// 开始考试 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { #region 验证考试是否应该参与考试 JAAJ_ExamInfo oeiJAAJ_ExamInfo = ScoreData.GetCurrentExamInfo(); if (oeiJAAJ_ExamInfo != null) { oeiJAAJ_ExamineeInfo = ScoreData.GetExamineeInfoByIDNum(txtIDNum.Text.Trim(), oeiJAAJ_ExamInfo.nvcBatchNO); if (oeiJAAJ_ExamineeInfo == null) { MessageBox.Show("不存在该考生信息", "提示"); return; } } #endregion #region 调出对应考试科目的试题显示在终端界面上 oepiExamProceInfo = ScoreData.GetExamProceInfoByExamineeID(oeiJAAJ_ExamineeInfo.iExamineeID); if (oepiExamProceInfo != null) { int iSubjectItemID = oepiExamProceInfo.iSubjectItemID; //下面代码可以根据科目子项ID调出对应的子项对应的试题..... } #endregion #region 修改设备状态为忙碌状态 EnumSubmitResult oResult = ScoreData.UpdateDeviceStatus(1); #endregion }
/// <summary> /// 获取当前正在考试信息 /// </summary> /// <returns>当前正在考试信息,JAAJ_ExamInfo</returns> public static JAAJ_ExamInfo GetCurrentExamInfo() { JAAJ_ExamInfo oInfo = null; try { string strSqlString = "SELECT * FROM JAAJ_Exams WHERE iExamStatus=0 "; SqlDatabase odbDataBase = new SqlDatabase(connectionString); DbCommand odbCommand = odbDataBase.GetSqlStringCommand(strSqlString); using (IDataReader reader = odbDataBase.ExecuteReader(odbCommand)) { if (reader.Read()) { oInfo = new JAAJ_ExamInfo(); ModelHelper.LoadInfoData(oInfo, reader); } } } catch (Exception oeException) { oInfo = null; //throw new Exception(oeException.Message, oeException); } return(oInfo); }
private void CanExam(IAsyncResult result) { AsyncResult ar = (AsyncResult)result; MyDelegate md = (MyDelegate)ar.AsyncDelegate; IDCard IC = md.EndInvoke(result); if (IC == null) { Messenger.Default.Send <string>(" 读卡器未连接", "ShowTip"); return; } Name = IC.Name; Sex = IC.Sex; Nation = IC.Nation; Address = IC.Address; IDCode = IC.IDCode; #region 验证考试是否应该参与考试 try { JAAJ_ExamineeInfo oeiJAAJ_ExamineeInfo = null; JAAJ_ExamInfo oeiJAAJ_ExamInfo = ScoreData.GetCurrentExamInfo(); JAAJ_ExamProceInfo oepiJAAJ_ExamProceInfo = null; if (oeiJAAJ_ExamInfo != null) { oeiJAAJ_ExamineeInfo = ScoreData.GetExamineeInfoByIDNum(IDCode, oeiJAAJ_ExamInfo.nvcBatchNO); if (oeiJAAJ_ExamineeInfo != null) { ExamineeID = oeiJAAJ_ExamineeInfo.nvcExamineeGUID; CommonHelper.examineeInfo = oeiJAAJ_ExamineeInfo; oepiJAAJ_ExamProceInfo = ScoreData.GetExamProceInfoByExamineeID(oeiJAAJ_ExamineeInfo.iExamineeID); if (oepiJAAJ_ExamProceInfo != null) { Messenger.Default.Send <string>("", "GoMainView"); return; } } } } catch (Exception ex) { //LogImpl.Error(string.Format("{0}{2}{1}", ex.StackTrace, ex.Message, System.Environment.NewLine)); } Messenger.Default.Send <string>(" 未安排在此考试\n 请联系考务人员解决", "ShowWarning"); #endregion }
private Boolean CanExam(string idCardNo, out string examineeId) { JAAJ_ExamInfo oeiJAAJ_ExamInfo = ScoreData.GetCurrentExamInfo(); if (oeiJAAJ_ExamInfo != null) { var oeiJAAJ_ExamineeInfo = ScoreData.GetExamineeInfoByIDNum(idCardNo, oeiJAAJ_ExamInfo.nvcBatchNO); if (oeiJAAJ_ExamineeInfo != null) { examineeId = oeiJAAJ_ExamineeInfo.nvcExamineeGUID; CommonHelper.examineeInfo = oeiJAAJ_ExamineeInfo; var oepiJAAJ_ExamProceInfo = ScoreData.GetExamProceInfoByExamineeID(oeiJAAJ_ExamineeInfo.iExamineeID); if (oepiJAAJ_ExamProceInfo != null) { return(true); } } } examineeId = string.Empty; return(false); }