#####场次相关


###获得全部场次记录
GET_ALL_ROUNDS = SELECT * FROM tb_OnLineExam_Round

###获得指定ID的场次记录
GET_ROUND_BY_ID = SELECT * FROM tb_OnLineExam_Round WHERE ID = ?

###获得严格匹配指定名称的场次记录
GET_ROUND_BY_NAME_EXACTLY = SELECT * FROM tb_OnLineExam_Round WHERE Name = ?

###获得匹配指定名称的所有场次记录
GET_ROUNDS_BY_NAME = SELECT * FROM tb_OnLineExam_Round WHERE Name LIKE ?

###获得指定科目ID的所有场次记录
GET_ROUNDS_BY_COURSE_ID = SELECT * FROM tb_OnLineExam_Round WHERE CourseID = ?

###获得指定科目ID的所有打开的场次记录（字符串“打开”的ASCII码为："\u6253\u5f00"）
GET_OPEN_ROUNDS_BY_COURSE_ID = SELECT * FROM tb_OnLineExam_Round WHERE CourseID = ? AND Status = '\u6253\u5f00'

###添加场次记录
ADD_ROUND = INSERT INTO tb_OnLineExam_Round (Name, CourseID, FillingNum, SingleNum, MultiNum, JudgeNum, FillingScore, SingleScore, MultiScore, JudgeScore, TimeOut, Status, DateTime, Organizer, Description) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

###更新指定ID的场次记录
UPDATE_ROUND = UPDATE tb_OnLineExam_Round SET Name = ?, CourseID = ?, FillingNum = ?, SingleNum = ?, MultiNum = ?, JudgeNum = ?, FillingScore = ?, SingleScore = ?, MultiScore = ?, JudgeScore = ?, TimeOut = ?, Status = ?, DateTime = ?, Organizer = ?, Description = ? WHERE ID = ?

###删除指定ID的场次记录
DELETE_ROUND_BY_ID = DELETE FROM tb_OnLineExam_Round WHERE ID = ?

###删除指定科目ID的所有场次记录
DELETE_ROUND_BY_COURSE_ID = DELETE FROM tb_OnLineExam_Round WHERE CourseID = ?

###获得指定场次ID的科目ID
GET_COURSE_ID_BY_ROUND_ID = SELECT CourseID FROM tb_OnLineExam_Round WHERE ID = ?