collegesetting.aspx.cs

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

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
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.OrganizationSettings
{
	/// <summary>
	/// CollegeSettings 实现学院设置页的界面和操作。
	/// </summary>
	public partial class CollegeSetting : StudentsMIS.Security.BaseAdminPage
	{

    private CollegeManager manager = new CollegeManager();

    private DataSet ds;

    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)
      {
        Bind_DataGridColleges();        
      }      
		}

    private void Bind_DataGridColleges()
    {
      ds = CommandBuilder.BuildOleDbDataSet("select * from colleges ORDER BY college_ID asc");
      dataGridColleges.DataSource = ds.Tables[0].DefaultView;
      dataGridColleges.DataBind();
    }


		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
      this.dataGridColleges.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dataGridColleges_ItemCreated);
      this.dataGridColleges.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dataGridColleges_CancelCommand);
      this.dataGridColleges.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dataGridColleges_EditCommand);
      this.dataGridColleges.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dataGridColleges_UpdateCommand);
      this.dataGridColleges.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dataGridColleges_DeleteCommand);

    }
		#endregion

    private void dataGridColleges_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
    {
      dataGridColleges.EditItemIndex = e.Item.ItemIndex;
      Bind_DataGridColleges();
    }

    private void dataGridColleges_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
    {
      dataGridColleges.EditItemIndex = -1;
      Bind_DataGridColleges();
    }

    private void dataGridColleges_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
    {
      ListItemType itemType = (ListItemType)e.Item.ItemType;
      if (itemType == ListItemType.Item || itemType == ListItemType.AlternatingItem || itemType == ListItemType.SelectedItem)
      {
        LinkButton myDeleteButton = (LinkButton)e.Item.Cells[3].Controls[0];
        myDeleteButton.Attributes.Add("onclick", "return confirm('您真的要删除此行吗？');");
      }
    }

    protected void btnCollegeAdd_Click(object sender, System.EventArgs e)
    {
      if(txtCollegeID.Text.Trim()=="")
      {
        ShowMessage("请填入学院编号!");
        return;
      }
      if(txtCollegeName.Text.Trim()=="")
      {
        ShowMessage("请填入学院名称!");
        return;
      }
      try
      {
        switch(manager.Insert(txtCollegeID.Text.Trim(),txtCollegeName.Text.Trim()))
        {
          case 0 : ShowMessage("对不起,此学院编号已经存在,不能添加!");break;
          case 1 : ShowMessage("对不起,此学院名称已经存在,不能添加!");break;
          case 2 : Bind_DataGridColleges();ShowMessage("添加学院操作完成！");break;
        }
      }
      catch(Exception e1)
      {
        ShowMessage(e1.Message.ToString());
        return;
      }
    }

    private void dataGridColleges_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
    {
      try
      {
        manager.Delete(e.Item.Cells[0].Text.Trim());
        Bind_DataGridColleges();
      }
      catch(Exception e1)
      {
        ShowMessage(e1.Message);
      }      
    }

    private void dataGridColleges_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
    {
      try
      {
        if(manager.Update(e.Item.Cells[0].Text.Trim(),((TextBox)e.Item.Cells[1].Controls[0]).Text.Trim())==0)
        {
          ShowMessage("对不起,此学院名称已经存在,不能修改!");
          return;
        }
        else
        {
          dataGridColleges.EditItemIndex = -1;
          Bind_DataGridColleges();    
        }
      }
      catch(Exception e1)
      {
        ShowMessage(e1.Message.ToString());
        return;
      }
    }
	}
}