userpaper.aspx.cs

基于Asp.net三层结构的在线考试系统

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using OnLineExam.BusinessLogicLayer;
using System.Data.SqlClient;
using OnLineExam.DataAccessLayer;
public partial class Web_UserPaper : System.Web.UI.Page
{
    private int  paperid;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string loginName = Session["userID"].ToString();
            Users user = new Users();
            user.LoadData(loginName);
            labUser.Text = user.UserName;    
            InitData();
        }
    }
   
    //初始化试卷，从数据库中将试题取出
    protected void InitData()
    {
        string userid = Request.QueryString["UserID"].ToString();
        paperid = int.Parse(Request.QueryString["PaperID"].ToString());

        DataBase DB = new DataBase();

        DataSet ds = DB.GetDataSetSql("select * from [UserAnswer] where UserID='" + userid + "'");
       DataRow[] row = ds.Tables[0].Select();      
       foreach (DataRow rs in row)
       {           
           lblExamtime.Text = rs["ExamTime"].ToString();         
       }
           

        SqlParameter[] Params1 = new SqlParameter[3];
        Params1[0] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, paperid);            
        Params1[1] = DB.MakeInParam("@Type", SqlDbType.VarChar, 10, "单选题");
        Params1[2] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 50, userid);  
        DataSet ds1 = DB.GetDataSet("Proc_UserAnswer", Params1);
        GridView1.DataSource = ds1;
        GridView1.DataBind();
       ((Label)GridView1.HeaderRow.FindControl("Label27")).Text = ((Label)GridView1.Rows[0].FindControl("Label4")).Text;


        SqlParameter[] Params2 = new SqlParameter[3];
        Params2[0] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, paperid);            
        Params2[1] = DB.MakeInParam("@Type", SqlDbType.VarChar, 10, "多选题");
        Params2[2] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 50, userid);        
        DataSet ds2 = DB.GetDataSet("Proc_UserAnswer", Params2);
        GridView2.DataSource = ds2;
        GridView2.DataBind();
       ((Label)GridView2.HeaderRow.FindControl("Label28")).Text = ((Label)GridView2.Rows[0].FindControl("Label8")).Text;


        SqlParameter[] Params3 = new SqlParameter[3];
        Params3[0] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, paperid );                
        Params3[1] = DB.MakeInParam("@Type", SqlDbType.VarChar, 10, "判断题");
        Params3[2] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 50, userid);         
        DataSet ds3 = DB.GetDataSet("Proc_UserAnswer", Params3);
        GridView3.DataSource = ds3;
        GridView3.DataBind();
       ((Label)GridView3.HeaderRow.FindControl("Label29")).Text = ((Label)GridView3.Rows[0].FindControl("Label12")).Text;

        SqlParameter[] Params4 = new SqlParameter[3];
        Params4[0] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, paperid );        
        Params4[1] = DB.MakeInParam("@Type", SqlDbType.VarChar, 10, "填空题");
        Params4[2] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 50, userid);      
        DataSet ds4 = DB.GetDataSet("Proc_UserAnswer", Params4);
        GridView4.DataSource = ds4;
        GridView4.DataBind();
       ((Label)GridView4.HeaderRow.FindControl("Label30")).Text = ((Label)GridView4.Rows[0].FindControl("Label17")).Text;

        SqlParameter[] Params5 = new SqlParameter[3];
        Params5[0] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, paperid );              
        Params5[1] = DB.MakeInParam("@Type", SqlDbType.VarChar, 10, "问答题");
        Params5[2] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 50, userid);        
        DataSet ds5 = DB.GetDataSet("Proc_UserAnswer", Params5);
        GridView5.DataSource = ds5;
        GridView5.DataBind();
        ((Label)GridView5.HeaderRow.FindControl("Label31")).Text = ((Label)GridView5.Rows[0].FindControl("Label21")).Text;

        int score1 = 0;
        int singlemark = int.Parse(((Label)GridView1.Rows[0].FindControl("Label4")).Text);//取出单选题的每题分值
        foreach (GridViewRow dr in GridView1.Rows)
        {
            if (((Label)dr.FindControl("Label3")).Text.Trim() == "A")
            {
                ((RadioButton)dr.FindControl("RadioButton1")).Checked=true;
            }
           else if (((Label)dr.FindControl("Label3")).Text.Trim() == "B")
            {
                ((RadioButton)dr.FindControl("RadioButton2")).Checked = true;
            }
           else if (((Label)dr.FindControl("Label3")).Text.Trim() == "C")
            {
                ((RadioButton)dr.FindControl("RadioButton3")).Checked = true;
            }
           else if (((Label)dr.FindControl("Label3")).Text.Trim() == "D")
            {
                ((RadioButton)dr.FindControl("RadioButton4")).Checked = true;
            }
            if (((Label)dr.FindControl("Label3")).Text.Trim() == ((Label)dr.FindControl("Label23")).Text.Trim())
            {
                score1 = score1 + singlemark;
                sinScore.Text = Convert.ToString(score1);
            }  
        }
        
        int score2 = 0;
        int multimark = int.Parse(((Label)GridView2.Rows[0].FindControl("Label8")).Text);//取出多选题每题分值
        foreach (GridViewRow dr in GridView2.Rows)
        {
            if (((Label)dr.FindControl("Label7")).Text.Trim() == "A")
            {
                ((CheckBox)dr.FindControl("CheckBox1")).Checked = true;
            }
            if (((Label)dr.FindControl("Label7")).Text.Trim() == "B")
            {
                ((CheckBox)dr.FindControl("CheckBox2")).Checked = true;
            }
            if (((Label)dr.FindControl("Label7")).Text.Trim() == "C")
            {
                ((CheckBox)dr.FindControl("CheckBox3")).Checked = true;
            }
            if (((Label)dr.FindControl("Label7")).Text.Trim() == "D")
            {
                ((CheckBox)dr.FindControl("CheckBox4")).Checked = true;
            }
            if (((Label)dr.FindControl("Label7")).Text.Trim() == "AB")
            {
                ((CheckBox)dr.FindControl("CheckBox1")).Checked = true;
                ((CheckBox)dr.FindControl("CheckBox2")).Checked = true;               
            }
            if (((Label)dr.FindControl("Label7")).Text.Trim() == "AC")
            {
                ((CheckBox)dr.FindControl("CheckBox1")).Checked = true;
                ((CheckBox)dr.FindControl("CheckBox3")).Checked = true;               
            }
            if (((Label)dr.FindControl("Label7")).Text.Trim() == "AD")
            {
                ((CheckBox)dr.FindControl("CheckBox1")).Checked = true;
                ((CheckBox)dr.FindControl("CheckBox4")).Checked = true;
            }
            if (((Label)dr.FindControl("Label7")).Text.Trim() == "BC")
            {
                ((CheckBox)dr.FindControl("CheckBox2")).Checked = true;
                ((CheckBox)dr.FindControl("CheckBox3")).Checked = true;               
            }
            if (((Label)dr.FindControl("Label7")).Text.Trim() == "BD")
            {
                ((CheckBox)dr.FindControl("CheckBox2")).Checked = true;
                ((CheckBox)dr.FindControl("CheckBox4")).Checked = true;
            }
            if (((Label)dr.FindControl("Label7")).Text.Trim() == "CD")
            {
                ((CheckBox)dr.FindControl("CheckBox3")).Checked = true;
                ((CheckBox)dr.FindControl("CheckBox4")).Checked = true;
            }
            if (((Label)dr.FindControl("Label7")).Text.Trim() == "ABC")
            {
                ((CheckBox)dr.FindControl("CheckBox1")).Checked = true;
                ((CheckBox)dr.FindControl("CheckBox2")).Checked = true;
                ((CheckBox)dr.FindControl("CheckBox3")).Checked = true;              
            }
            if (((Label)dr.FindControl("Label7")).Text.Trim() == "ABD")
            {
                ((CheckBox)dr.FindControl("CheckBox1")).Checked = true;
                ((CheckBox)dr.FindControl("CheckBox2")).Checked = true;
                ((CheckBox)dr.FindControl("CheckBox4")).Checked = true;
            }
            if (((Label)dr.FindControl("Label7")).Text.Trim() == "ACD")
            {
                ((CheckBox)dr.FindControl("CheckBox1")).Checked = true;
                ((CheckBox)dr.FindControl("CheckBox3")).Checked = true;
                ((CheckBox)dr.FindControl("CheckBox4")).Checked = true;
            }
            if (((Label)dr.FindControl("Label7")).Text.Trim() == "ABCD")
            {
                ((CheckBox)dr.FindControl("CheckBox1")).Checked = true;
                ((CheckBox)dr.FindControl("CheckBox2")).Checked = true;
                ((CheckBox)dr.FindControl("CheckBox3")).Checked = true;
                ((CheckBox)dr.FindControl("CheckBox4")).Checked = true;
            }
            if (((Label)dr.FindControl("Label7")).Text.Trim() == ((Label)dr.FindControl("Label27")).Text.Trim())
            {
                score2 = score2 + multimark;
                mulScore.Text = Convert.ToString(score2);
            }               
        }
        int score3 = 0;
        int judgemark = int.Parse(((Label)GridView3.Rows[0].FindControl("Label12")).Text);//取出判断题每题分值
        foreach (GridViewRow dr in GridView3.Rows)//对判断题每题进行判断用户选择答案
        {
            if (bool.Parse(((Label)dr.FindControl("Label11")).Text.Trim()))
            {
                ((CheckBox)dr.FindControl("CheckBox5")).Checked = true;
            }
            if (((Label)dr.FindControl("Label11")).Text.Trim() == ((Label)dr.FindControl("Label41")).Text.Trim())
            {
                score3 = score3 + judgemark;
                judScore.Text = Convert.ToString(score3);
            }     
        }
        int score4 = 0;
        int fillmark = int.Parse(((Label)GridView4.Rows[0].FindControl("Label17")).Text);//取出填空题每题分值
        foreach (GridViewRow dr in GridView4.Rows)//对填空题每题进行判断用户选择答案
        {
            string str = "";
            str = ((TextBox)dr.FindControl("TextBox1")).Text.Trim();
            if (str == ((Label)dr.FindControl("Label26")).Text.Trim())
            {
                score4 = score4 + fillmark;
                filScore.Text = Convert.ToString(score4);
            }
        }
       
    }
 
    protected void Button1_Click(object sender, EventArgs e)
    {
        int quemark = 0;
        int maxMark = int.Parse(((Label)GridView5.Rows[0].FindControl("Label21")).Text);
        int flag = 1;
        foreach (GridViewRow dr in GridView5.Rows)
        {
            if (int.Parse(((TextBox)dr.FindControl("tbxqueScore")).Text.Trim()) > maxMark)
            {
                lblQuestion.Text = "问答题每道的得分不能超过每道题的分数!";               
                 flag =0;
            }
        }
       if(flag==1)
       {        
          foreach (GridViewRow dr in GridView5.Rows)
            {
                    quemark = quemark + int.Parse(((TextBox)dr.FindControl("tbxqueScore")).Text.Trim());
                    queScore.Text = Convert.ToString(quemark);
                    sumScore.Text = Convert.ToString(Convert.ToInt32(sinScore.Text) + Convert.ToInt32(mulScore.Text) + Convert.ToInt32(judScore.Text) + Convert.ToInt32(filScore.Text) + Convert.ToInt32(queScore.Text));
             }
            lblQuestion.Text = "";
           
        }       
    }
      
    protected void imgBtnReturn_Click(object sender, ImageClickEventArgs e)
    {
        Server.Transfer("UserPaperList.aspx");
    }
    protected void imgBtnSave_Click(object sender, ImageClickEventArgs e)
    {
        Scores insertScore = new Scores();  //创建Scores类对象
        insertScore.UserID = Request.QueryString["UserID"].ToString();
        insertScore.ExamTime = Convert.ToDateTime(lblExamtime.Text);
        insertScore.PaperID = int.Parse(Request.QueryString["PaperID"].ToString());
        insertScore.Score = Convert.ToInt32(sumScore.Text);
        insertScore.PingYu = tbxPingyu.Text;

        Paper paper = new Paper();
        paper.UserID= Request.QueryString["UserID"].ToString();
        paper.PaperID = int.Parse(Request.QueryString["PaperID"].ToString());
        paper.state = "已评阅";

       if (!insertScore.CheckScore(insertScore.UserID, insertScore.PaperID)) //使用CheckScore方法验证成绩是否存在
       {
            if (insertScore.InsertByProc()) //调用InsertByProc方法向数据库中插入成绩
            {
                paper.UpdateByProc(paper.UserID, paper.PaperID,paper.state);
                lblMessage.Text = "成绩保存成功!";
            }
            else
            {
                lblMessage.Text = "成绩保存失败!";
            }
       }
       else
       {
           lblMessage.Text = "该用户的成绩已存在,请先删除成绩再评阅!";
       }
    }
}