void bindDataToGrid(String condition)
{
String userId = "";
String status = "";
String messageType = "";
if (Session["userId"] != null)
{
userId = this.Session["userId"].ToString(); ;
}
else
{
logger.Info("userId=null" );
}
if (Session["status"] != null)
{
status = this.Session["status"].ToString(); ;
}
if (Session["messageType"] != null)
{
messageType = this.Session["messageType"].ToString(); ;
}
logger.Info("userId=" + userId);
logger.Info("messageType=" + messageType);
AgentExamDao examDao = new ChinaUnion_DataAccess.AgentExamDao();
IList<Exam> examList = examDao.GetList(condition, userId, messageType);
// this.lblAgentNo.Text = agentNo;
this.lblUserId.Text = userId;
// int index = 1;
DataTable dt = new DataTable();
dt.Columns.Add("seq");
dt.Columns.Add("userId");
dt.Columns.Add("subject");
dt.Columns.Add("status");
dt.Columns.Add("validateStartTime");
dt.Columns.Add("validateEndTime");
DataRow row = null;
if (examList != null && examList.Count > 0)
{
foreach (Exam exam in examList)
{
row = dt.NewRow();
row["seq"] = exam.sequence;
row["userId"] = userId;
row["subject"] = exam.subject;
row["status"] = exam.status;
if (String.IsNullOrEmpty(exam.status))
{
row["status"] = "未开始";
}
row["validateStartTime"] = exam.validateStartTime;
row["validateEndTime"] = exam.validateEndTime;
// dt.Rows.Add(row);
if (status.Equals("new") )
{
dt.Rows.Add(row);
}
if (status.Equals("finish") && !String.IsNullOrEmpty(exam.status))
{
dt.Rows.Add(row);
}
}
}
else
{
this.lblMessag.Text = "未找到" + "记录!";
}
GridView1.DataSource = dt.DefaultView;
GridView1.DataBind();
}
private void dgExam_SelectionChanged(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
if (this.dgExam.CurrentRow != null)
{
if (this.dgExam[0, this.dgExam.CurrentRow.Index].Value != null)
{
String examSeq = this.dgExam[0, this.dgExam.CurrentRow.Index].Value.ToString();
AgentExamDao examDao = new ChinaUnion_DataAccess.AgentExamDao();
IList<AgentExam> examList = examDao.GetList(examSeq);
this.dgScore.Rows.Clear();
dgScore.Columns.Clear();
dgScore.Columns.Add("用户编号", "用户编号");
dgScore.Columns.Add("成绩", "成绩");
foreach (AgentExam exam in examList)
{
AgentExamScoreDao agentExamScoreDao = new AgentExamScoreDao();
IList<ExamQuestion> examQuestionList = agentExamScoreDao.GetUserExamQuestion(examSeq, exam.userId);
int wrongCount = 0;
foreach (ExamQuestion examQuestion in examQuestionList)
{
if (examQuestion.standardAnswer != null && !examQuestion.standardAnswer.Equals(examQuestion.answer))
{
wrongCount++;
}
}
int totalCount = examQuestionList.Count;
int rightCount = totalCount - wrongCount;
String strMessage = "总共：" + totalCount + "题,答对：" + rightCount + "题,答错：" + wrongCount;
dgScore.Rows.Add();
DataGridViewRow row = dgScore.Rows[dgScore.RowCount - 1];
row.Cells["用户编号"].Value = exam.userId;
row.Cells["成绩"].Value = strMessage;
dgScore.ColumnHeadersDefaultCellStyle.WrapMode = DataGridViewTriState.False;
dgScore.AutoResizeColumns();
//this.dgScore.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
//this.dgScore.AutoResizeColumns();
}
}
}
this.Cursor = Cursors.Default;
}