testresult.aspx.cs

在线考试系统 主要真对考试 开发的个人项目

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;

public partial class testResult : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["adminId"] == null)
        {
            Response.Redirect("Default.aspx");
        }
        else
            if (!Page.IsPostBack)
            {

                this.DropDownList1.Items.Add("所有科目");
                DataSet ds = new DataSet();
                ds = (new projClass()).getCourses();
                foreach (DataRow row in ds.Tables[0].Rows)
                {
                    this.DropDownList1.Items.Add(row["courseName"].ToString());
                }
                BindGrid();
            }
    }
    void BindGrid()
    {
        DataSet ds = new DataSet();
        ds = (new projClass()).getScoreAsStuIdAndCourseId();
        DataTable dt = ds.Tables["scoreInfo"];
        DataView dv = new DataView(dt);       
        if (!(this.DropDownList1.SelectedItem.Text == "所有科目"))
        {
            if (this.dd_stu.SelectedItem.Text == "学号")
                dv.RowFilter = "courseName like '%" + this.DropDownList1.SelectedItem.Text + "%' and stuId like '%" + this.txtName.Text.Trim() + "%'";
            else dv.RowFilter = "courseName like '%" + this.DropDownList1.SelectedItem.Text + "%' and stuName like '%" + this.txtName.Text.Trim() + "%'";
        }
        else
        {
            if (this.dd_stu.SelectedItem.Text == "学号")
                dv.RowFilter = "stuId like '%" + this.txtName.Text.Trim() + "%'";
            else dv.RowFilter = "stuName like '%" + this.txtName.Text.Trim() + "%'";
        }
        this.GridView1.DataSource = dv;
        this.GridView1.DataBind();
        if (dv.Count == 0)
        {
            this.Label1.Text = "没有记录！！";
        }
        else
        {
            this.Label1.Text = "";
        }

        
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        this.GridView1.PageIndex = e.NewPageIndex;
        BindGrid();
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {        
        string stuId =GridView1.DataKeys[e.RowIndex]["stuId"].ToString();
        string courseName = GridView1.DataKeys[e.RowIndex]["courseName"].ToString();
        //this.Label1.Text = stuId + "   " + courseName;
        string courseId = (new projClass()).getCourseIdAsCourseName(courseName);        
        int count = (new projClass()).deleteScoreInfo(stuId, courseId);     
        if(count==0){
            this.Label1.Text = "删除失败";
        }else
            this.Label1.Text = "删除成功";
        BindGrid();
    }
   
  
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        this.Label1.Text = "开始修改";
        TextBox tbx_score = (TextBox)this.GridView1.Rows[e.RowIndex].Cells[3].Controls[0];
        string stuId = GridView1.DataKeys[e.RowIndex]["stuId"].ToString();
        string score = tbx_score.Text.Trim();
        int stuScore = Convert.ToInt32(score);
        string courseName = GridView1.DataKeys[e.RowIndex]["courseName"].ToString();
        string courseId = (new projClass()).getCourseIdAsCourseName(courseName);
        int count = (new projClass()).updateScore(stuId, courseId, 1, stuScore);
        if (count == 0||IsNum(score))
            this.Label1.Text = "更新失败，您输入的可能不是数字！！！";
        GridView1.EditIndex = -1;
        BindGrid();
        this.Label1.Text = " 更新成功！！！";
    }
    public static bool IsNum(string str)
    {
        for (int i = 0; i < str.Length; i++)
        {
            if (str[i] < '0' || str[i] > '9')
                return false;
        }
        return true;
    }

    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;        
        BindGrid();
    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        BindGrid();
    }
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        BindGrid();
    }
}