testresultbyteacher.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 testResultByTeacher : System.Web.UI.Page
{
    string courseName;
    protected void Page_Load(object sender, EventArgs e)
    {
        
        if (Session["teacherId"] == null)
        {
            Response.Redirect("Default.aspx");
        }
        else
            if (!Page.IsPostBack)
            {
                string teacherId = Convert.ToString(Session["teacherId"]);
                string courseId = (new projClass()).getTeacherCourseId(teacherId);
                Session["courseId"] = courseId;
                courseName = (new projClass()).getCourseNameAsCourseId(courseId);
                BindGrid();
            }
    }
    void BindGrid()
    {
        DataSet ds = new DataSet();
        ds = (new projClass()).getScoreAsStuIdAndCourseId1((new projClass()).getTeacherCourseId(Convert.ToString(Session["teacherId"])));
        DataTable dt = ds.Tables["scoreInfo"];
        DataView dv = new DataView(dt);
        if (this.dd_stu.SelectedItem.Text == "学号")
            dv.RowFilter = "courseName like '%" + courseName + "%' and stuId like '%" + this.txtName.Text.Trim() + "%'";
        else dv.RowFilter = "courseName like '%" + courseName + "%' and stuName like '%" + this.txtName.Text.Trim() + "%'";
        this.GridView1.DataSource = dv;
        this.GridView1.DataBind();
        if(dv.Count==0){
            this.Label1.Text ="没有记录！！";
        }else{
            this.Label1.Text = "共有"+dv.Count.ToString()+"条记录";
        }
       
    }
    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)
            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();
    }
    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "Detail")
        {
            int index = Convert.ToInt32(e.CommandArgument);
            //DataKey key = GridView1.DataKeys[index];
            string courseName = GridView1.DataKeys[index]["courseName"].ToString();
            string stuId = GridView1.DataKeys[index]["stuId"].ToString();
            Session["stuId"] = stuId;
            Session["courseName"] = courseName;
            Response.Redirect("testStudentWenDa.aspx");
        }
    }
}