specialitysetting.aspx.cs

C#2.0宝典源码,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.CommonClassLibrary;
using StudentsMIS.Business;

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

    private SpecialityManager manager = new SpecialityManager();

    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(ddListColleges);
        Bind_DataGridSpeciality();
      }      
		}

    private void Bind_DataGridSpeciality()
    {
      if(ddListColleges.SelectedValue.Trim() != "0")
      {
        objCommand = CommandBuilder.BuildOleDbCommand("Select * From speciality Inner Join colleges On speciality.speciality_college=colleges.college_ID Where speciality_college=@SpecialityCollege Order By speciality_ID asc");
        objCommand.Parameters.Add("@SpecialityCollege",ddListColleges.SelectedValue.Trim());
        objAdapter.SelectCommand = objCommand;
        objAdapter.Fill(ds);
        CommandCloser.CloseOleDbCommand(objCommand);
        objAdapter.Dispose();
      }
      else
      {
        ds = CommandBuilder.BuildOleDbDataSet("Select * From speciality Inner Join colleges On speciality.speciality_college=colleges.college_ID Order By speciality_ID asc");      
      }
      dataGridSpeciality.DataSource = ds.Tables[0].DefaultView;
      dataGridSpeciality.DataBind();
    }

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

    }
		#endregion

    protected void btnAddSpeciality_Click(object sender, System.EventArgs e)
    {
      if(txtSpecialityID.Text.Trim()=="")
      {
        ShowMessage("请输入专业编号!");
        return;
      }
      if(ddListColleges.SelectedValue.Trim()=="0")
      {
        ShowMessage("请选择专业所属学院!");
        return;
      }
      if(txtSpecialityName.Text.Trim()=="")
      {
        ShowMessage("请输入专业名称!");
        return;
      }
      try
      {
        string specialityID = ddListColleges.SelectedValue.Trim() + "-" + txtSpecialityID.Text.Trim();
        switch(manager.Insert(specialityID,ddListColleges.SelectedValue.Trim(),txtSpecialityName.Text.Trim()))
        {
          case 0 : ShowMessage("对不起,此专业编号已经存在,不能添加!");break;
          case 1 : ShowMessage("对不起,您学择的学院已经存在您所填写的专业,不能添加!");break;
          case 2 : Bind_DataGridSpeciality();ShowMessage("添加专业操作成功!");break;
        }
      }
      catch(Exception e1)
      {
        ShowMessage(e1.Message);
      }      
    }

    protected void ddListColleges_SelectedIndexChanged(object sender, System.EventArgs e)
    {
      Bind_DataGridSpeciality();
    }

    private void dataGridSpeciality_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 || itemType == ListItemType.EditItem)
      {
        LinkButton myDeleteButton = (LinkButton)e.Item.Cells[4].Controls[0];
        myDeleteButton.Attributes.Add("onclick", "return confirm('您真的要删除此行吗？');");
      }
    }

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

    private void dataGridSpeciality_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
    {
      dataGridSpeciality.EditItemIndex = e.Item.ItemIndex;
      Bind_DataGridSpeciality();
    }

    private void dataGridSpeciality_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
    {
      dataGridSpeciality.EditItemIndex = -1;
      Bind_DataGridSpeciality();
    }

    private void dataGridSpeciality_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
    {
      try
      {
        if(manager.Update(e.Item.Cells[0].Text.Trim(),e.Item.Cells[0].Text.Trim().Substring(0,2),((TextBox)e.Item.Cells[2].Controls[0]).Text.Trim())==0)
        {
          ShowMessage("对不起,此学院已经有您所填的专业名称存在,不能修改!");
          return;
        }
        else
        {
          dataGridSpeciality.EditItemIndex = -1;
          Bind_DataGridSpeciality();
        }
      }
      catch(Exception e1)
      {
        ShowMessage(e1.Message.ToString());
      }
    }
	}
}