public int UpdateExamResultAnswer(RandomExamResultAnswer examResultAnswer)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_Random_EXAM_ANSWER_U";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_Random_EXAM_result_id", DbType.Int32, examResultAnswer.RandomExamResultId);
db.AddInParameter(dbCommand, "p_Random_EXAM_item_id", DbType.Int32, examResultAnswer.RandomExamItemId);
db.AddInParameter(dbCommand, "p_answer", DbType.String, examResultAnswer.Answer);
db.AddInParameter(dbCommand, "p_exam_time", DbType.Int32, examResultAnswer.ExamTime);
db.AddInParameter(dbCommand, "p_judge_score", DbType.Decimal, examResultAnswer.JudgeScore);
db.AddInParameter(dbCommand, "p_judge_status_id", DbType.Int32, examResultAnswer.JudgeStatusId);
db.AddInParameter(dbCommand, "p_judge_remark", DbType.String, examResultAnswer.JudgeRemark);
int nRecordAffected = db.ExecuteNonQuery(dbCommand);
return(nRecordAffected);
}
public int UpdateExamResultAnswer(RandomExamResultAnswer examResultAnswer)
{
return(dal.UpdateExamResultAnswer(examResultAnswer));
}
public int AddExamResultAnswer(RandomExamResultAnswer examResultAnswer)
{
return(dal.AddExamResultAnswer(examResultAnswer));
}
protected void FillPaper()
{
// QueryString id stands for EXAM_RESULT_ID
string strId = Request.QueryString.Get("id");
string orgid = Request.QueryString.Get("orgid");
// Not pass id
if (string.IsNullOrEmpty(strId))
{
SessionSet.PageMessage = "参数错误！";
return;
}
RandomExamResultBLL randomExamResultBLL = new RandomExamResultBLL();
RandomExamResult randomExamResult = new RandomExamResult();
if (ViewState["NowOrgID"].ToString() != orgid)
{
randomExamResult = randomExamResultBLL.GetRandomExamResultByOrgID(int.Parse(strId), int.Parse(orgid));
}
else
{
randomExamResult = randomExamResultBLL.GetRandomExamResultTemp(int.Parse(strId));
}
int RandomExamId = randomExamResult.RandomExamId;
int randomExamResultId = int.Parse(strId);
OracleAccess db = new OracleAccess();
RandomExamBLL objBll = new RandomExamBLL();
int year = objBll.GetExam(RandomExamId).BeginTime.Year;
RandomExamItemBLL randomItemBLL = new RandomExamItemBLL();
RandomExamSubjectBLL subjectBLL = new RandomExamSubjectBLL();
RandomExamResultAnswerBLL randomExamResultAnswerBLL = new RandomExamResultAnswerBLL();
IList <RandomExamSubject> randomExamSubjects = subjectBLL.GetRandomExamSubjectByRandomExamId(RandomExamId);
IList <RandomExamResultAnswer> examResultAnswers = new List <RandomExamResultAnswer>();
if (ViewState["NowOrgID"].ToString() != orgid)
{
examResultAnswers = randomExamResultAnswerBLL.GetExamResultAnswersByOrgID(int.Parse(strId), int.Parse(orgid));
}
else
{
examResultAnswers = randomExamResultAnswerBLL.GetExamResultAnswers(randomExamResultId);
}
int z = 1;
if (randomExamSubjects != null)
{
for (int i = 0; i < randomExamSubjects.Count; i++)
{
RandomExamSubject paperSubject = randomExamSubjects[i];
IList <RandomExamItem> PaperItems = new List <RandomExamItem>();
if (ViewState["NowOrgID"].ToString() != orgid)
{
PaperItems = randomItemBLL.GetItemsByOrgID(paperSubject.RandomExamSubjectId, randomExamResultId, int.Parse(orgid), year);
}
else
{
PaperItems = randomItemBLL.GetItems(paperSubject.RandomExamSubjectId, randomExamResultId, year);
}
Response.Write("<table width='100%'>");
Response.Write(" <tr > <td class='ExamBigTitle' >");
Response.Write(" " + GetNo(i) + "");
Response.Write(". " + paperSubject.SubjectName + "");
Response.Write(" （共" + paperSubject.ItemCount + "题，共" + System.String.Format("{0:0.##}", paperSubject.ItemCount * paperSubject.UnitScore) + "分）</td></tr >");
if (PaperItems != null)
{
for (int j = 0; j < PaperItems.Count; j++)
{
RandomExamItem paperItem = PaperItems[j];
int k = j + 1;
if (paperItem.TypeId != 5)
{
z = 1;
Response.Write("<tr > <td class='ExamResultItem'> "
+ k + ". " + paperItem.Content + " （" +
System.String.Format("{0:0.##}", paperSubject.UnitScore) +
"分）</td></tr >");
}
else
{
string strSql = "select * from Random_Exam_Item_" + year + " where Item_ID='" +
paperItem.ItemId + "' and Random_Exam_ID=" + RandomExamId;
DataRow dr = db.RunSqlDataSet(strSql).Tables[0].Rows[0];
IList <RandomExamItem> randomExamItems = randomItemBLL.GetItemsByParentItemID(Convert.ToInt32(dr["Parent_Item_ID"]), RandomExamId, year);
Response.Write("<tr > <td class='ExamResultItem'> ("
+ z + "). " + paperItem.Content + " （" + System.String.Format("{0:0.##}", (decimal)paperSubject.UnitScore / (decimal)randomExamItems.Count) +
"分）</td></tr >");
z++;
}
// 组织用户答案
RandomExamResultAnswer theExamResultAnswer = null;
string[] strUserAnswers = new string[0];
string strUserAnswer = string.Empty;
foreach (RandomExamResultAnswer resultAnswer in examResultAnswers)
{
if (resultAnswer.RandomExamItemId == paperItem.RandomExamItemId)
{
theExamResultAnswer = resultAnswer;
break;
}
}
// 若子表无记录，结束页面输出
if (theExamResultAnswer == null)
{
SessionSet.PageMessage = "数据错误！";
}
// 否则组织考生答案
if (theExamResultAnswer.Answer != null || theExamResultAnswer.Answer == string.Empty)
{
strUserAnswers = theExamResultAnswer.Answer.Split(new char[] { '|' });
}
for (int n = 0; n < strUserAnswers.Length; n++)
{
string strN = intToString(int.Parse(strUserAnswers[n]) + 1);
if (n == 0)
{
strUserAnswer += strN;
}
else
{
strUserAnswer += "," + strN;
}
}
//多选
if (paperSubject.ItemTypeId == 2)
{
string[] strAnswer = paperItem.SelectAnswer.Split(new char[] { '|' });
for (int n = 0; n < strAnswer.Length; n++)
{
string strN = intToString(n + 1);
Response.Write(" <tr ><td class='ExamItemAnswer'> "
+ strN + "." + strAnswer[n] + "</td></tr >");
}
}
else if (paperSubject.ItemTypeId == 1 || paperSubject.ItemTypeId == 3 || paperItem.TypeId == 5)
{
//单选
string[] strAnswer = paperItem.SelectAnswer.Split(new char[] { '|' });
for (int n = 0; n < strAnswer.Length; n++)
{
string strN = intToString(n + 1);
Response.Write("<tr > <td class='ExamItemAnswer'> "
+ strN + "." + strAnswer[n] + "</td></tr >");
}
}
if (paperSubject.ItemTypeId == 1 || paperSubject.ItemTypeId == 2 || paperSubject.ItemTypeId == 3 || paperItem.TypeId == 5)
{
// 组织正确答案
string[] strRightAnswers = paperItem.StandardAnswer.Split(new char[] { '|' });
string strRightAnswer = "";
for (int n = 0; n < strRightAnswers.Length; n++)
{
string strN = intToString(int.Parse(strRightAnswers[n]) + 1);
if (n == 0)
{
strRightAnswer += strN;
}
else
{
strRightAnswer += "," + strN;
}
}
string strScore = "0";
if (paperItem.TypeId == 5)
{
if (strRightAnswer == strUserAnswer)
{
strScore = System.String.Format("{0:0.##}", paperItem.Score);
}
}
else
{
if (strRightAnswer == strUserAnswer)
{
strScore = System.String.Format("{0:0.##}", paperSubject.UnitScore);
}
}
if (strScore == "0")
{
Response.Write(" <tr><td class='ExamAnswerZero'> ★标准答案："
+ "<span id='span-" + paperItem.RandomExamItemId + "-0' name='span-" +
paperItem.RandomExamItemId
+ "'>" + strRightAnswer + "</span> 考生答案："
+ "<span id='span-" + paperItem.RandomExamItemId + "-1' name='span-" +
paperItem.RandomExamItemId
+ "'>" + strUserAnswer + "</span> 得分：" + strScore + "</td></tr>");
}
else
{
Response.Write(" <tr><td class='ExamAnswer'> ★标准答案："
+ "<span id='span-" + paperItem.RandomExamItemId + "-0' name='span-" +
paperItem.RandomExamItemId
+ "'>" + strRightAnswer + "</span> 考生答案："
+ "<span id='span-" + paperItem.RandomExamItemId + "-1' name='span-" +
paperItem.RandomExamItemId
+ "'>" + strUserAnswer + "</span> 得分：" + strScore + "</td></tr>");
}
}
}
}
Response.Write(" </table> ");
}
}
else
{
SessionSet.PageMessage = "数据错误！";
return;
}
}
