/// <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> /// <param name="strIDNum">身份证号</param> /// <param name="strBatchNo">批次号</param> /// <returns>考生信息,JAAJ_ExamineeInfo</returns> public static JAAJ_ExamineeInfo GetExamineeInfoByIDNum(string strIDNum, string strBatchNo) { //string strSqlString = "SELECT * FROM JAAJ_Examinees WHERE nvcIDNum='" + strIDNum + "' AND CHARINDEX(nvcBatchNO,'" + strBatchNo + "')>0 "; string strSqlString = "SELECT * FROM JAAJ_Examinees WHERE nvcIDNum='" + strIDNum + "'"; SqlDatabase odbDataBase = new SqlDatabase(connectionString); DbCommand odbCommand = odbDataBase.GetSqlStringCommand(strSqlString); JAAJ_ExamineeInfo oInfo = null; try { using (IDataReader reader = odbDataBase.ExecuteReader(odbCommand)) { if (reader.Read()) { oInfo = new JAAJ_ExamineeInfo(); ModelHelper.LoadInfoData(oInfo, reader); if (!oInfo.bSex) { oInfo.nvcSexName = PublicMethod.GetEnumShowName(CommonEnum.Sex.Man, (int)CommonEnum.Sex.Man); } else { oInfo.nvcSexName = PublicMethod.GetEnumShowName(CommonEnum.Sex.Woman, (int)CommonEnum.Sex.Woman); } } } } catch (Exception oeException) { 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 }