admin_again.aspx.cs

该程序是写的一个学生成绩管理系统是在 2005 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 GROUP.Manage;

public partial class admin_again : System.Web.UI.Page
{
    //创建公共类BaseClass（包含与数据库操作的方法）的对象  
    BaseClass BaseClass1 = new BaseClass();
    protected void Page_Load(object sender, EventArgs e)
    {
        String strSql = "select DISTINCT 班级.班级名称,班级.班级编号 from 班级 where 班级.教职工编号 = '" + Session[0].ToString() + "' order by 班级.班级编号";
        DataTable dt = BaseClass1.ReadTable(strSql);
        if (DropDownList1.Items.Count == 1)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                DropDownList1.Items.Add(dt.Rows[i].ItemArray[0].ToString().Insert(2, "级").Insert(7, "班"));
            }
        }
    }
    void bindgrig(int flag)
    {
        string str1 = DropDownList1.Text.Substring(0, 2) + DropDownList1.Text.Substring(3, 4);
        String strSql = "select DISTINCT 教程.学期,课程.课程名称,学生.姓名,成绩.成绩,成绩.备注,班级.班级编号 from 教程,课程,学生,成绩,班级 where 班级.班级名称 = '" + str1 + "'and 教程.班级编号 = 班级.班级编号 and 成绩.教程编号 = 教程.教程编号 and (成绩.成绩 < 60 or 成绩.备注 <> 0) and 课程.课程编号 = 教程.课程编号 and 学生.学生编号 = 成绩.学生编号";
        DataTable dt = BaseClass1.ReadTable(strSql);        
        if (dt.Rows.Count == 0)
        {
            return;
        }
        Session["banji"] = dt.Rows[0].ItemArray[5].ToString(); 
        DataTable dat = new DataTable();
        DataColumn dc1 = new DataColumn("学期", Type.GetType("System.String"));
        DataColumn dc2 = new DataColumn("课程名称", Type.GetType("System.String"));
        DataColumn dc3 = new DataColumn("学生姓名", Type.GetType("System.String"));
        DataColumn dc4 = new DataColumn("原始成绩", Type.GetType("System.String"));
        DataColumn dc5 = new DataColumn("补考成绩", Type.GetType("System.String"));
        DataColumn dc6 = new DataColumn("补考次数", Type.GetType("System.String"));
        dat.Columns.Add(dc1);
        dat.Columns.Add(dc2);
        dat.Columns.Add(dc3);
        dat.Columns.Add(dc4);
        dat.Columns.Add(dc5);
        dat.Columns.Add(dc6);
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            DataRow dr = dat.NewRow();
            dr[0] = dt.Rows[i].ItemArray[0].ToString().Insert(2,"年第").Insert(5,"学期");
            dr[1] = dt.Rows[i].ItemArray[1].ToString();
            dr[2] = dt.Rows[i].ItemArray[2].ToString();
            if (dt.Rows[i].ItemArray[3].ToString().Equals("60"))
            {
                dr[3] = dt.Rows[i].ItemArray[4].ToString();
                dr[4] = dt.Rows[i].ItemArray[3].ToString();
            }
            else
            {
                dr[3] = dt.Rows[i].ItemArray[3].ToString();
                if (dt.Rows[i].ItemArray[3].ToString() != "")
                {
                    dr[5] = dt.Rows[i].ItemArray[4].ToString();
                }
            }
            dat.Rows.Add(dr);
        }
        //填充记录        
        //设置GridView数据源
        GridView1.DataSource = dat;
        //显示数据
        GridView1.DataBind();
        if (flag == 1)
        {
            bindgrig2(dat, GridView1.PageIndex);
        }
    }
    void bindgrig2(DataTable dt,int t)
    {
        int flag;
        if (((t + 1) * 10) <= dt.Rows.Count)
        {
            flag = 10;
        }
        else 
        {
            flag = dt.Rows.Count - t * 10;
        }
        DropDownList2.Items.Clear();
        DropDownList3.Items.Clear();
        DropDownList2.Items.Add("请选择学生：");
        DropDownList3.Items.Add("请选择学生：");
        for (int i = 0;i < flag; i++)
        {
            DropDownList2.Items.Add(dt.Rows[t * 10 + i].ItemArray[0].ToString() + " " + dt.Rows[t * 10 + i].ItemArray[1].ToString() + " " + dt.Rows[t * 10 + i].ItemArray[2].ToString());
            DropDownList3.Items.Add(dt.Rows[t * 10 + i].ItemArray[0].ToString() + " " + dt.Rows[t * 10 + i].ItemArray[1].ToString() + " " + dt.Rows[t * 10 + i].ItemArray[2].ToString());
        }
    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        bindgrig(1);
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        //设置GridView显示页面序号
        GridView1.PageIndex = e.NewPageIndex;
        //更新GridView显示
        bindgrig(1);

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (DropDownList2.SelectedIndex == 0)
        {
            DropDownList2.Text = DropDownList3.Items[1].ToString();            
            return;
        }
        string str1 = DropDownList2.Text.Substring(0, 2) + DropDownList2.Text.Substring(4, 1);       
        int i = DropDownList2.Text.LastIndexOf(" ");
        string str2 = DropDownList2.Text.Substring(8,i-8);
        string str3 = DropDownList2.Text.Substring(i+1);
        string strSql = "select 成绩.编号,成绩.成绩 from 教程,课程,学生,成绩,班级 where 学生.姓名 = '" + str3 + "' and 学生.班级编号 = '" + Session["banji"].ToString() + "' and 成绩.学生编号 = 学生.学生编号 and 课程.课程名称 = '" + str2 + "' and 教程.课程编号 = 课程.课程编号 and 教程.学期 = '" + str1 + "' and 成绩.教程编号 = 教程.教程编号";
        DataTable dt = BaseClass1.ReadTable(strSql);
        strSql = "update 成绩 set 成绩 = 60 , 备注 = " + dt.Rows[0].ItemArray[1].ToString() + " where 成绩.编号 = '" + dt.Rows[0].ItemArray[0].ToString() + "'";
        BaseClass1.execsql(strSql);
        bindgrig(0);
        if (DropDownList2.SelectedIndex == (DropDownList2.Items.Count - 2))
        {
            DropDownList2.Text = DropDownList2.Items[DropDownList2.SelectedIndex + 1].ToString();
        }
        else if (DropDownList2.SelectedIndex == (DropDownList2.Items.Count - 1))
        {
            DropDownList2.Text = DropDownList2.Items[1].ToString();
        }
        else
        {
            DropDownList2.Text = DropDownList2.Items[DropDownList2.SelectedIndex + 1].ToString();
        }
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        if (DropDownList3.SelectedIndex == 0)
        {
            DropDownList3.Text = DropDownList3.Items[1].ToString();
            return;
        }
        string str1 = DropDownList3.Text.Substring(0, 2) + DropDownList3.Text.Substring(4, 1);
        int i = DropDownList3.Text.LastIndexOf(" ");
        string str2 = DropDownList3.Text.Substring(8, i - 8);
        string str3 = DropDownList3.Text.Substring(i + 1);
        string strSql = "select 成绩.编号,成绩.备注 from 教程,课程,学生,成绩,班级 where 学生.姓名 = '" + str3 + "' and 学生.班级编号 = '" + Session["banji"].ToString() + "' and 成绩.学生编号 = 学生.学生编号 and 课程.课程名称 = '" + str2 + "' and 教程.课程编号 = 课程.课程编号 and 教程.学期 = '" + str1 + "' and 成绩.教程编号 = 教程.教程编号";
        DataTable dt = BaseClass1.ReadTable(strSql);
        if (TextBox2.Text == "")
        {
            strSql = "update 成绩 set 成绩 = " + dt.Rows[0].ItemArray[1].ToString() + " , 备注 = null where 成绩.编号 = '" + dt.Rows[0].ItemArray[0].ToString() + "'";
        }
        else
        {
            strSql = "update 成绩 set 成绩 = " + dt.Rows[0].ItemArray[1].ToString() + " , 备注 = " + TextBox2.Text + " where 成绩.编号 = '" + dt.Rows[0].ItemArray[0].ToString() + "'";
        }        
        BaseClass1.execsql(strSql);
        bindgrig(0);
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        if (DropDownList2.SelectedIndex == 0)
        {
            DropDownList2.Text = DropDownList3.Items[1].ToString();
            return;
        }
        string str1 = DropDownList2.Text.Substring(0, 2) + DropDownList2.Text.Substring(4, 1);
        int i = DropDownList2.Text.LastIndexOf(" ");
        string str2 = DropDownList2.Text.Substring(8, i - 8);
        string str3 = DropDownList2.Text.Substring(i + 1);
        string strSql = "select 成绩.编号,成绩.备注 from 教程,课程,学生,成绩,班级 where 学生.姓名 = '" + str3 + "' and 学生.班级编号 = '" + Session["banji"].ToString() + "' and 成绩.学生编号 = 学生.学生编号 and 课程.课程名称 = '" + str2 + "' and 教程.课程编号 = 课程.课程编号 and 教程.学期 = '" + str1 + "' and 成绩.教程编号 = 教程.教程编号";
        DataTable dt = BaseClass1.ReadTable(strSql);
        int j;
        if (dt.Rows[0].ItemArray[1].ToString() == "")
        {
            j = 1;
        }
        else
        {
            j = Int16.Parse(dt.Rows[0].ItemArray[1].ToString()) + 1;
        }
        strSql = "update 成绩 set 备注 = " + j + " where 成绩.编号 = '" + dt.Rows[0].ItemArray[0].ToString() + "'";
        BaseClass1.execsql(strSql);
        bindgrig(0);
        if (DropDownList2.SelectedIndex == (DropDownList2.Items.Count - 2))
        {
            DropDownList2.Text = DropDownList2.Items[DropDownList2.SelectedIndex + 1].ToString();
        }
        else if (DropDownList2.SelectedIndex == (DropDownList2.Items.Count - 1))
        {
            DropDownList2.Text = DropDownList2.Items[1].ToString();
        }
        else
        {
            DropDownList2.Text = DropDownList2.Items[DropDownList2.SelectedIndex + 1].ToString();
        }
    }
}