studentsmanagement.aspx.cs

c#开发宝典 光盘内容。本光盘主要为书中的源程序

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using StudentsMIS.DataAccess;
using StudentsMIS.Business;
using StudentsMIS.CommonClassLibrary;

namespace StudentsMIS.Web.StudentsManagement
{
	/// <summary>
	/// StudentsManagement 的摘要说明。
	/// </summary>
	public partial class StudentsManagement : StudentsMIS.Security.BaseUserPage
	{

    private string Key="",Value="";

    private StudentManager manager = new StudentManager();

    private OleDbCommand objCommand;
    private OleDbDataAdapter objAdapter = new OleDbDataAdapter();
    private DataSet ds = new DataSet();

    private void ShowMessage(string msg)
    {
      msg = msg.Replace("\'",@"\'").Replace('\"','\"');
      Response.Write("<script defer language='javascript'>alert('" + msg + "')</script>");
    }
  
		protected void Page_Load(object sender, System.EventArgs e)
		{
      if(!Page.IsPostBack)
      {
        BindDownList.Bind_CollegeList(ddListCollege);
        BindDownList.Bind_SpecialityList(ddListSpeciality,"0");
        BindDownList.Bind_ClassList(ddListClass,"0");
        Bind_dataGridStudents();
      }
      btnDelete.Attributes.Add("onclick","return confirm('您真的要删除这(些)记录吗？');");
		}

    private void Bind_dataGridStudents()
    {
      string sqlAppend = "";
      if(Key!="" && Value!="")
      {
        sqlAppend = " Where " + Key + "=@" + Key;
      }      
      objCommand = CommandBuilder.BuildOleDbCommand("SELECT students.student_ID, students.student_name, students.student_sex,student_enterYear,student_stuType,student_native,classes.class_name, speciality.speciality_name, colleges.college_name FROM colleges INNER JOIN (speciality INNER JOIN (classes INNER JOIN students ON classes.class_ID = students.student_class) ON speciality.speciality_ID = classes.class_speciality) ON colleges.college_ID = speciality.speciality_college" + sqlAppend + " Order By student_ID asc");
      objCommand.Parameters.Add("@"+Key,Value);
      objAdapter.SelectCommand = objCommand;
      objAdapter.Fill(ds);
      dataGridStudents.DataSource = ds.Tables[0].DefaultView;
      dataGridStudents.DataBind();
    }

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
      this.dataGridStudents.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.dataGridStudents_PageIndexChanged);

    }
		#endregion

    protected void ddListCollege_SelectedIndexChanged(object sender, System.EventArgs e)
    {
      BindDownList.Bind_SpecialityList(ddListSpeciality,ddListCollege.SelectedValue.Trim());
      BindDownList.Bind_ClassList(ddListClass,ddListSpeciality.SelectedValue.Trim());
      Key = "college_ID";
      Value = ddListCollege.SelectedValue.Trim();
      Bind_dataGridStudents();
    }

    protected void ddListSpeciality_SelectedIndexChanged(object sender, System.EventArgs e)
    {
      BindDownList.Bind_ClassList(ddListClass,ddListSpeciality.SelectedValue.Trim());
      Key = "speciality_ID";
      Value = ddListSpeciality.SelectedValue.Trim();
      Bind_dataGridStudents();
    }

    protected void ddListClass_SelectedIndexChanged(object sender, System.EventArgs e)
    {
      Key = "student_class";
      Value = ddListClass.SelectedValue.Trim();
      Bind_dataGridStudents();
    }

    protected void btnSearch_Click(object sender, System.EventArgs e)
    {
      if(txtValue.Text.Trim()=="")
      {
        ShowMessage("请输入查找条件!");
        return;
      }
      if(ddListKey.SelectedValue=="0")
      {
        Key = "student_ID";
        Value = txtValue.Text.Trim();
        Bind_dataGridStudents();
      }
      else
      {
        Key = "student_name";
        Value = txtValue.Text.Trim();
        Bind_dataGridStudents();
      }
    }

    protected void btnSelect_Click(object sender, System.EventArgs e)
    {
      foreach(DataGridItem item in dataGridStudents.Items)
      {
        if(((HtmlInputCheckBox)item.Cells[0].FindControl("stu_id")).Checked)
        {
          Response.Redirect("StudentsSelect.aspx?student_id="+item.Cells[1].Text.Trim());
          break;
        }
      }
    }

    protected void btnInsert_Click(object sender, System.EventArgs e)
    {
      Response.Redirect("StudentsInsert.aspx");
    }

    protected void btnUpdate_Click(object sender, System.EventArgs e)
    {
      foreach(DataGridItem item in dataGridStudents.Items)
      {
        if(((HtmlInputCheckBox)item.Cells[0].FindControl("stu_id")).Checked)
        {
          Response.Redirect("StudentsUpdate.aspx?student_id="+item.Cells[1].Text.Trim());
          break;
        }
      }
    }

    protected void btnDelete_Click(object sender, System.EventArgs e)
    {
      foreach(DataGridItem item in dataGridStudents.Items)
      {
        if(((HtmlInputCheckBox)item.Cells[0].FindControl("stu_id")).Checked)
        {
          try
          {
            manager.Delete(item.Cells[1].Text.Trim());
          }
          catch(Exception e1)
          {
            ShowMessage(e1.Message);
          }
          break;
        }
      }
      Bind_dataGridStudents();
    }

    private void dataGridStudents_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
    {
      dataGridStudents.CurrentPageIndex = e.NewPageIndex;
      Bind_dataGridStudents();
    }

    protected void btnChange_Click(object sender, System.EventArgs e)
    {
      foreach(DataGridItem item in dataGridStudents.Items)
      {
        if(((HtmlInputCheckBox)item.Cells[0].FindControl("stu_id")).Checked)
        {
          Response.Redirect("StudentsChange.aspx?student_id="+item.Cells[1].Text.Trim());
          break;
        }
      }
    }

    


	}
}