public async Task <IHttpActionResult> GetExamRecord(int ExamID, int DisabledID, int First = 0) { ExamRecord examRecord = await db.ExamRecords.Where(e => e.ExamID == ExamID && e.DisabledID == DisabledID).FirstOrDefaultAsync(); if (First != 0) { examRecord = await db.ExamRecords.Where(e => e.First == First && e.DisabledID == DisabledID && e.ExamID == ExamID).FirstOrDefaultAsync(); } if (examRecord == null) { if (ExamID == 9 || ExamID == 10 || ExamID == 11) { ExamRecord record = new ExamRecord(ExamID, DisabledID, 0, First); db.ExamRecords.Add(record); db.SaveChanges(); return(Ok(record)); } else { var ExamName = db.Categories.Find(ExamID).Name; examRecord = await db.ExamRecords.Where(a => a.Exam.Name == ExamName && a.DisabledID == DisabledID).FirstOrDefaultAsync(); if (examRecord == null) { return(NotFound()); } } } return(Ok(examRecord)); }
public ResponseMessageWrap <int> Insert([FromBody] ExamRecord examRecord) { return(new ResponseMessageWrap <int> { Body = ExamRecordService.Insert(examRecord) }); }
public async Task <IHttpActionResult> ChangeExamState(ExamRecord record) { ExamRecord exam = await db.ExamRecords.Where(x => x.ExamID == record.ExamID && x.DisabledID == record.DisabledID).FirstOrDefaultAsync(); if (exam == null) { return(NotFound()); } else { var er = db.ExamRecords.Where(x => x.DisabledID == record.DisabledID); var flag = false; foreach (var item in er) { if (item.ExamID == 10 || item.ExamID == 11) { flag = true; } } if (flag) { exam.State = ExamState.已完成; } db.SaveChanges(); } return(StatusCode(HttpStatusCode.NoContent)); }
public async Task <IHttpActionResult> ModifyExamRecords(IList <ExamRecord> record) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var answer = record[0]; ExamRecord examRecord = await db.ExamRecords.Where(e => e.ExamID == answer.ExamID && e.DisabledID == answer.DisabledID).FirstOrDefaultAsync(); if (examRecord == null) { return(NotFound()); } if (examRecord.State == ExamState.待审核) { examRecord.State = ExamState.待完成; examRecord.Auditor = answer.Auditor; } else if (examRecord.State == ExamState.待完成) { examRecord.State = ExamState.待回访; examRecord.Complete = answer.Complete; examRecord.FinishTime = DateTime.Now; } await db.SaveChangesAsync(); return(StatusCode(HttpStatusCode.NoContent)); }
public async Task <IHttpActionResult> PutExamRecord(int id, ExamRecord examRecord) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != examRecord.ID) { return(BadRequest()); } db.Entry(examRecord).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ExamRecordExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ResponseMessageWrap <int> Update([FromBody] ExamRecord examRecord) { return(new ResponseMessageWrap <int> { Body = ExamRecordService.Update(examRecord) }); }
public ExamMode GetExamMode(ExamRecord record) { var Exam = new ExamMode(); Exam.ExamTime = record.BeginTime.Value.ToString("HH:mm:ss") + "-" + record.EndTime.Value.ToString("HH:mm:ss"); //获取考试扣分项 var breakeRules = examBreakeRuleRecordRepository.LoadEntities(s => s.ExamRecordId == record.Id); var breakeRulesStr = string.Join(",", breakeRules.Select(s => s.DeductedReason)); Exam.Score = record.Score; Exam.DedictionRules = breakeRulesStr; var Captures = examCaptureRepository.LoadEntities(s => s.ExamRecordId == record.Id); for (int i = 0; i < Captures.Count() && i < 3; i++) { if (i == 0) { Exam.CaptureImageFirstPath = GetImagePath("FirstCaptureImage", Captures[i].Image); } else if (i == 1) { Exam.CaptureImageSecondPath = GetImagePath("SecondCaptureImage", Captures[i].Image); } else if (i == 2) { Exam.CaptureImageThirdPath = GetImagePath("ThirdCaptureImage", Captures[i].Image); } } return(Exam); //简单逻辑 我只需要前面三张照片 }
/// <summary> /// 通过条件查询 /// </summary> /// <param name="WhereString">查询条件</param> /// <returns>ExamRecord实体类对象</returns> public List <ExamRecord> SelectByWhere(string WhereString) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@where", WhereString) }; List <ExamRecord> list = new List <ExamRecord>(); ExamRecord model = null; using (SqlDataReader dr = DBHelper.RunProcedure("ExamRecord_SelectByWhere", param)) { while (dr.Read()) { model = new ExamRecord(); model.ExamRecordId = Convert.ToInt32(dr["ExamRecordId"]); model.ExamId = Convert.ToInt32(dr["ExamId"]); model.PaperId = Convert.ToInt32(dr["PaperId"]); model.UserId = Convert.ToInt32(dr["UserId"]); if (DBNull.Value != dr["CreateDate"]) { model.CreateDate = Convert.ToDateTime(dr["CreateDate"]); } if (DBNull.Value != dr["LastDate"]) { model.LastDate = Convert.ToDateTime(dr["LastDate"]); } if (DBNull.Value != dr["TotalTime"]) { model.TotalTime = Convert.ToInt32(dr["TotalTime"]); } if (DBNull.Value != dr["ExamNumber"]) { model.ExamNumber = Convert.ToInt32(dr["ExamNumber"]); } if (DBNull.Value != dr["LastScore"]) { model.LastScore = Convert.ToInt32(dr["LastScore"]); } if (DBNull.Value != dr["HighScore"]) { model.HighScore = Convert.ToInt32(dr["HighScore"]); } if (DBNull.Value != dr["UserCredit"]) { model.UserCredit = Convert.ToDecimal(dr["UserCredit"]); } if (DBNull.Value != dr["UserCoin"]) { model.UserCoin = Convert.ToDecimal(dr["UserCoin"]); } if (DBNull.Value != dr["IsDelete"]) { model.IsDelete = Convert.ToBoolean(dr["IsDelete"]); } list.Add(model); } } return(list); }
public ExamFinishModel() : base() { VexamRecord = new ExamRecord(); VExamScore = new ExamScore(); Listexam = new ExamScoreInfo(); examList = new List <ExamScoreInfo>(); ListVexamRecord = new List <ExamRecord>(); Listexam.ansowerList = new List <LAnsower>(); }
public ScoreLoader(string schoolYear, string semester, ExamRecord exam, bool isCurrentSemester) { this.SchoolYear = schoolYear; this.Semester = semester; this.Exam = exam; this.ExamID = int.Parse(exam.ID); this.isCurrentSemester = isCurrentSemester; this._DicStudentScoreInfo = new Dictionary <string, StudentScoreInfo>(); }
/// <summary> /// 通过Id查询 /// </summary> /// <param name="Id">主键Id</param> /// <returns>ExamRecord实体类对象</returns> public ExamRecord SelectById(int Id) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@ExamRecordId", Id) }; ExamRecord model = new ExamRecord(); using (SqlDataReader dr = DBHelper.RunProcedure("ExamRecord_SelectById", param)) { if (dr.Read()) { model.ExamRecordId = Convert.ToInt32(dr["ExamRecordId"]); model.ExamId = Convert.ToInt32(dr["ExamId"]); model.PaperId = Convert.ToInt32(dr["PaperId"]); model.UserId = Convert.ToInt32(dr["UserId"]); if (DBNull.Value != dr["CreateDate"]) { model.CreateDate = Convert.ToDateTime(dr["CreateDate"]); } if (DBNull.Value != dr["LastDate"]) { model.LastDate = Convert.ToDateTime(dr["LastDate"]); } if (DBNull.Value != dr["TotalTime"]) { model.TotalTime = Convert.ToInt32(dr["TotalTime"]); } if (DBNull.Value != dr["ExamNumber"]) { model.ExamNumber = Convert.ToInt32(dr["ExamNumber"]); } if (DBNull.Value != dr["LastScore"]) { model.LastScore = Convert.ToInt32(dr["LastScore"]); } if (DBNull.Value != dr["HighScore"]) { model.HighScore = Convert.ToInt32(dr["HighScore"]); } if (DBNull.Value != dr["UserCredit"]) { model.UserCredit = Convert.ToDecimal(dr["UserCredit"]); } if (DBNull.Value != dr["UserCoin"]) { model.UserCoin = Convert.ToDecimal(dr["UserCoin"]); } if (DBNull.Value != dr["IsDelete"]) { model.IsDelete = Convert.ToBoolean(dr["IsDelete"]); } } } return(model); }
internal ExamRecordEditor(ExamRecord record) : this() { ID = record.ID; Name = record.Name; Description = record.Description; DisplayOrder = record.DisplayOrder; Exam = record; }
public SCETakeRecordEditor(SCAttendRecord scattend, ExamRecord exam) { Score = null; Effort = null; Text = string.Empty; RefSCAttendID = scattend.ID; RefExamID = exam.ID; RefStudentID = scattend.RefStudentID; RefCourseID = scattend.RefCourseID; }
public async Task <IHttpActionResult> GetExamRecord(int id) { ExamRecord examRecord = await db.ExamRecords.FindAsync(id); if (examRecord == null) { return(NotFound()); } return(Ok(examRecord)); }
/// <summary> /// Add exam record /// </summary> /// <param name="examRecord"> /// ExamRecord include ExamScore, IsPass, UserId, ExamId, UserAnwser, EffectiveTime, SubmitTime /// </param> /// <returns>Influence row</returns> public int AddExamRecord(ExamRecord examRecord) { try { return(client.AddExamRecord(examRecord)); } catch (RequestExceprion ex) { throw ex; } }
public async Task <IHttpActionResult> PostExamRecord(ExamRecord examRecord) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.ExamRecords.Add(examRecord); await db.SaveChangesAsync(); return(CreatedAtRoute("DefaultApi", new { id = examRecord.ID }, examRecord)); }
public async Task <IHttpActionResult> DeleteExamRecord(int id) { ExamRecord examRecord = await db.ExamRecords.FindAsync(id); if (examRecord == null) { return(NotFound()); } db.ExamRecords.Remove(examRecord); await db.SaveChangesAsync(); return(Ok(examRecord)); }
public int update(ExamRecord examRecord) { String sql = "update examRecord set TaskConfigId=" + examRecord.TaskConfigId + ",XmlConfig='" + examRecord.XmlConfig + "' where BaseKey=" + examRecord.BaseKey; try { return(dbConnection.ExecuteNonQuery(sql)); } catch (Exception) { return(0); } finally { dbConnection.Close(); } }
/// <summary> /// 开始考试 /// </summary> /// <param name="message"></param> public void StartExam(ExamMessage message) { //创建考试记录 写入开始时间 //TODO:GUID //怎样获取当天 ExamRecord record = new ExamRecord(); record.BeginTime = message.SendTime; record.IsPreliminaryExam = message.IsPreliminaryExam; //这个去获取 record.LicensePlate = GetLicensePlateByIdCard(message.ExamStudent.IdCard); record.ExamLine = message.ExamLine; record.ExamStudentId = GetExamStudent(message.ExamStudent.IdCard).Id; record.Score = message.Score; record.GUID = message.GUID; record.CreateTime = DateTime.Now; examRecordRepository.AddEntity(record); }
public void insert(ExamRecord examRecord) { examRecord.BaseKey = this.getMaxKeyValue(); String sql = "insert into examRecord(BaseKey,TaskConfigId,XmlConfig) \n" + "values(" + examRecord.BaseKey + "," + examRecord.TaskConfigId + ",'" + examRecord.XmlConfig + "')"; try { dbConnection.ExecuteNonQuery(sql); } catch (Exception) { } finally { dbConnection.Close(); } }
/// <summary> /// 增加 /// </summary> /// <param name="ExamRecord">ExamRecord实体对象</param> /// <returns>int值,返回自增ID</returns> public int AddReturnId(ExamRecord model) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@ExamId", model.ExamId), new SqlParameter("@PaperId", model.PaperId), new SqlParameter("@UserId", model.UserId), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@LastDate", model.LastDate), new SqlParameter("@TotalTime", model.TotalTime), new SqlParameter("@ExamNumber", model.ExamNumber), new SqlParameter("@LastScore", model.LastScore), new SqlParameter("@HighScore", model.HighScore), new SqlParameter("@UserCredit", model.UserCredit), new SqlParameter("@UserCoin", model.UserCoin), new SqlParameter("@IsDelete", model.IsDelete) }; return(Convert.ToInt32(DBHelper.ExecuteScalar("ExamRecord_AddReturnId", param))); }
/// <summary> /// 增加 /// </summary> /// <param name="ExamRecord">ExamRecord实体对象</param> /// <returns>bool值,判断是否操作成功</returns> public bool Add(ExamRecord model) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@ExamId", model.ExamId), new SqlParameter("@PaperId", model.PaperId), new SqlParameter("@UserId", model.UserId), new SqlParameter("@CreateDate", model.CreateDate), new SqlParameter("@LastDate", model.LastDate), new SqlParameter("@TotalTime", model.TotalTime), new SqlParameter("@ExamNumber", model.ExamNumber), new SqlParameter("@LastScore", model.LastScore), new SqlParameter("@HighScore", model.HighScore), new SqlParameter("@UserCredit", model.UserCredit), new SqlParameter("@UserCoin", model.UserCoin), new SqlParameter("@IsDelete", model.IsDelete) }; return(DBHelper.ExecuteNonQuery("ExamRecord_Add", param)); }
public async Task <IHttpActionResult> ChangeRecord(int ExamID, int DisabledID, int UserID) { ExamRecord examRecord = await db.ExamRecords.Where(e => e.ExamID == ExamID && e.DisabledID == DisabledID).FirstOrDefaultAsync(); if (examRecord == null) { return(NotFound()); } else { if (examRecord.NextID == 2 && examRecord.State == ExamState.待完成) { examRecord.State = ExamState.待回访; examRecord.Complete = UserID; examRecord.FinishTime = DateTime.Now; db.SaveChanges(); } } return(Ok(examRecord)); }
public async Task <IHttpActionResult> BackState(ExamRecord record) { ExamRecord exam = await db.ExamRecords.Where(x => x.ExamID == record.ExamID && x.DisabledID == record.DisabledID).FirstOrDefaultAsync(); if (exam == null) { return(NotFound()); } else { if (exam.State > ExamState.已评估) { return(StatusCode(HttpStatusCode.BadRequest)); } else { exam.State = ExamState.待评估; exam.Evaluated = false; exam.NextID = 3; if (exam.ShowExam != 0) { ExamRecord nextExam = await db.ExamRecords.Where(x => x.ExamID == exam.ShowExam && x.DisabledID == exam.DisabledID).FirstOrDefaultAsync(); if (nextExam != null) { db.ExamRecords.Remove(nextExam); } } var exList = db.ExamRecords.Where(x => x.First == exam.ExamID && x.DisabledID == exam.DisabledID); if (exList.Count() > 0) { db.ExamRecords.RemoveRange(exList); } exam.ShowExam = 0; exam.ShowArea = null; db.SaveChanges(); } } return(StatusCode(HttpStatusCode.NoContent)); }
public async Task <IHttpActionResult> BackExam(ExamRecord record) { ExamRecord exam = await db.ExamRecords.Where(x => x.ExamID == record.ExamID && x.DisabledID == record.DisabledID).FirstOrDefaultAsync(); if (exam == null) { return(NotFound()); } else { if (exam.State == ExamState.待完成) { exam.State = ExamState.待审核; exam.FinishTime = null; } else if (exam.State == ExamState.待审核) { exam.State = ExamState.已评估; } db.SaveChanges(); } return(StatusCode(HttpStatusCode.NoContent)); }
public async Task <IHttpActionResult> ChangeExamNext(int examID, int disabledID, int nextID) { ExamRecord exam = await db.ExamRecords.Where(x => x.ExamID == examID && x.DisabledID == disabledID).FirstOrDefaultAsync(); if (exam == null) { return(NotFound()); } try { if (nextID == 3) { exam.State = ExamState.待评估; exam.NextID = nextID; exam.Evaluated = false; } else { if (nextID == 1) { exam.State = ExamState.待审核; } else if (nextID == 2) { exam.State = ExamState.待完成; } exam.NextID = nextID; } db.SaveChanges(); } catch (Exception) { throw; } return(StatusCode(HttpStatusCode.NoContent)); }
/// <summary> /// Init test init /// </summary> public AfterTest(TestingContent[] questionList, ExamRecord examRecord, bool isTimeOut, int correctNum) { InitializeComponent(); questionListTemp = questionList; examRecordTemp = examRecord; isTimeOutTemp = isTimeOut; correctNumTemp = correctNum; FinishedInit(); this.StartPosition = FormStartPosition.CenterScreen; this.windowClose.Click += new EventHandler(WindowCloseClick); this.windowStatus.Click += new EventHandler(WindowStatusClick); this.windowMin.Click += new EventHandler(WindowMinClick); this.head.MouseDown += new MouseEventHandler(HeadMouseDown); this.head.MouseMove += new MouseEventHandler(HeadMouseMove); RadiusBorder resultPaperInTime = this.finishTimeIn.examResultPaper; RadiusBorder resultPaperOutTime = this.finishTimeOut.examResultPaper; resultPaperInTime.Click += new EventHandler(ResultPaperClick); resultPaperOutTime.Click += new EventHandler(ResultPaperClick); }
public List <ExamRecord> ExamRecordRowMapper(IDataReader dr) { List <ExamRecord> ExamRecordList = new List <ExamRecord>(); try { while (dr.Read()) { ExamRecord examRecord = new ExamRecord(); examRecord.BaseKey = Convert.ToInt32(dr[0]); examRecord.TaskConfigId = Convert.ToInt32(dr[1]); examRecord.XmlConfig = dr[2].ToString(); ExamRecordList.Add(examRecord); } } catch (Exception ex) { } finally { dr.Close(); } return(ExamRecordList); }
/// <summary> /// Add exam record /// </summary> /// <param name="examRecord"></param> public int AddExamRecord(ExamRecord examRecord) { int row = 0; SqlConnection connection = new SqlConnection(CONNECTION_STRING); connection.Open(); SqlCommand command = new SqlCommand("spAddExamRecord", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@Operation", examRecord.IsPass)); command.Parameters.Add(new SqlParameter("@ExamScore", examRecord.ExamScore)); command.Parameters.Add(new SqlParameter("@IsPass", examRecord.IsPass)); command.Parameters.Add(new SqlParameter("@UserId", examRecord.UserId)); command.Parameters.Add(new SqlParameter("@ExamId", examRecord.ExamId)); command.Parameters.Add(new SqlParameter("@UserAnwser", examRecord.UserAnwser)); command.Parameters.Add(new SqlParameter("@EffectiveTime", examRecord.EffectiveTime)); command.Parameters.Add(new SqlParameter("@SubmitTime", examRecord.SubmitTime)); row = command.ExecuteNonQuery(); return(row); }
public async Task <IHttpActionResult> PostAnswers(IList <Answer> answers) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } //试卷编号 var ans = new List <int>(); //试卷的第一题 var ansList = new List <Answer>(); foreach (var a in answers) { if (ans.IndexOf(a.ExamID) == -1) { ans.Add(a.ExamID); ansList.Add(a); } } foreach (var item in ansList) { var answer = item; foreach (var it in answers) { if (it.Area != null && it.ExamID == item.ExamID && it.DisabledID == item.DisabledID) { answer = it; } } var delAnswers = db.Answers.Where(a => a.DisabledID == answer.DisabledID && a.ExamID == answer.ExamID && a.FirstExam == answer.FirstExam); db.Answers.RemoveRange(delAnswers); foreach (var addAns in answers) { if (answer.DisabledID == addAns.DisabledID && answer.ExamID == addAns.ExamID) { db.Answers.Add(addAns); } } var examRecord = await db.ExamRecords.FirstOrDefaultAsync(a => a.DisabledID == answer.DisabledID && a.ExamID == answer.ExamID); if (examRecord != null) { if (examRecord.ExamID == 9 || examRecord.ExamID == 10 || examRecord.ExamID == 11) { examRecord = await db.ExamRecords.FirstOrDefaultAsync(a => a.DisabledID == answer.DisabledID && a.ExamID == answer.ExamID && a.First == answer.FirstExam); if (examRecord.ExamID == 9) { examRecord.State = ExamState.待回访; } else if (examRecord.ExamID == 10 || examRecord.ExamID == 11) { examRecord.State = ExamState.已完成; examRecord.FinishTime = DateTime.Now; examRecord = await db.ExamRecords.FirstOrDefaultAsync(b => b.DisabledID == answer.DisabledID && b.ExamID == examRecord.First); examRecord.State = ExamState.已完成; } } else { examRecord.State = ExamState.已评估; examRecord.Evaluated = false; if (answer.Area != null) { examRecord.ShowArea = answer.Area; } if (answer.ShowExam != 0) { examRecord.ShowExam = answer.ShowExam; } } } else { var newRecord = new ExamRecord(answer.ExamID, answer.DisabledID, 0); db.ExamRecords.Add(newRecord); db.SaveChanges(); var record = await db.ExamRecords.FirstOrDefaultAsync(a => a.DisabledID == answer.DisabledID && a.ExamID == answer.ExamID); if (record.ExamID == 9) { record.State = ExamState.待回访; } else if (record.ExamID == 10 || record.ExamID == 11) { record.State = ExamState.已完成; examRecord.FinishTime = DateTime.Now; } else { record.State = ExamState.已评估; record.Evaluated = false; record.NextID = 3; record.First = answer.FirstExam; } var fisExam = await db.ExamRecords.FirstOrDefaultAsync(a => a.DisabledID == answer.DisabledID && a.ExamID == answer.FirstExam); if (answer.Area != null) { fisExam.ShowArea = answer.Area; } if (answer.ShowExam != 0) { fisExam.ShowExam = answer.ShowExam; } } } await db.SaveChangesAsync(); return(StatusCode(HttpStatusCode.NoContent)); }