private void frmUserPaper_Load(object sender, EventArgs e)
{
answer = UserAnswerBll.GetUserAnswer(UserID, Date, PaperID);
lblPaper.Text = answer.PaperName;
lblTime.Text = answer.ExamTime;
txtSingleProblem.Text = answer.SingleProblem.ToString();
txtMultiProblem.Text = answer.MultiProblem.ToString();
txtJudgeProblem.Text = answer.JudgeProblem.ToString();
txtFillBlankProblem.Text = answer.FillBlankProblem.ToString();
dataGridView1.DataSource = UserAnswerBll.QuestionFillDs(UserID, Date, PaperID).Tables[0];
getcolumn();
}
/// <summary>
/// 获取用户考试试卷和考试时间
/// </summary>
/// <param name="userID">用户编号</param>
/// <returns>UserAnswer类型，返回用户答案模板的信息</returns>
public UserAnswer GetUserAnswer(string userID,string date,string paperID)
{
string str = "select distinct PaperName,UserAnswer.examTime from UserAnswer left join Paper on UserAnswer.PaperID=Paper.PaperID where userID=@userID and UserAnswer.examTime=@examTime and not exists(select *from score where userID=@userID and examTime=@examTime and PaperID=@paperID)";
SH.SqlCom(str, CommandType.Text);
SH.SqlPar("@userID", userID);
SH.SqlPar("@examTime", date);
SH.SqlPar("@paperID", paperID);
UserAnswer Answer = new UserAnswer();
Answer.PaperName = SH.SqlFillDs().Tables[0].Rows[0].ItemArray[0].ToString();
Answer.ExamTime = SH.SqlFillDs().Tables[0].Rows[0].ItemArray[1].ToString();
return Answer;
}