studentschange.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.Business;
using StudentsMIS.CommonClassLibrary;
using StudentsMIS.DataAccess;

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

    private AwardEntity awardentity = new AwardEntity();
    private ChangeEntity changeentity = new ChangeEntity();
    private PunishmentEntity punishmententity = new PunishmentEntity();
    private StudentEntity stuentity = new StudentEntity();
    private StudentManager stumanager = new StudentManager();
    
    private AwardManager awardmanager = new AwardManager();
    private ChangeManager changemanager = new ChangeManager();
    private PunishmentManager punishmentmanager = new PunishmentManager();

    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)
		{
      ds.Tables.Add("awards");
      ds.Tables.Add("changes");
      ds.Tables.Add("punishments");
      if(!Page.IsPostBack)
      {
        if(Request["student_id"]!=null && Request["student_id"].ToString().Trim()!="")
        {
          txtStudentID.Text = Request["student_id"].ToString().Trim();
          Bind_stuBasicInfo(txtStudentID.Text.Trim());
        }
        Bind_dataGridAwards(txtStudentID.Text.Trim());
        Bind_dataGridChanges(txtStudentID.Text.Trim());
        Bind_dataGridPunishments(txtStudentID.Text.Trim());
        BindDownList.Bind_PunishmentTypesList(ddListPunishments);
        BindDownList.Bind_ChangeTypesList(ddListChanges);
      }      
		}

    private void Bind_stuBasicInfo(string id)
    {
      stuentity = (StudentEntity)stumanager.Select(id);
      Label1.Text =stuentity.StudentCollegeName + " " + stuentity.StudentSpecialityName + " " + stuentity.StudentName;
    }

    private void Bind_dataGridAwards(string id)
    {
      objCommand = CommandBuilder.BuildOleDbCommand("Select * From awards Where award_studentID=@StudentID");
      objCommand.Parameters.Add("@StudentID",id);
      objAdapter.SelectCommand = objCommand;
      objAdapter.Fill(ds.Tables["awards"]);
      dataGridAwards.DataSource = ds.Tables["awards"].DefaultView;
      dataGridAwards.DataBind();
    }

    private void Bind_dataGridChanges(string id)
    {
      objCommand = CommandBuilder.BuildOleDbCommand("SELECT changes.*, changeTypes.* FROM changeTypes INNER JOIN changes ON changeTypes.changeType_ID = changes.change_changeType Where change_studentID=@StudentID");
      objCommand.Parameters.Add("@StudentID",id);
      objAdapter.SelectCommand = objCommand;
      objAdapter.Fill(ds.Tables["changes"]);
      dataGridChanges.DataSource = ds.Tables["changes"].DefaultView;
      dataGridChanges.DataBind();
    }

    private void Bind_dataGridPunishments(string id)
    {
      objCommand = CommandBuilder.BuildOleDbCommand("SELECT punishments.*, punishmentTypes.* FROM punishmentTypes INNER JOIN punishments ON punishmentTypes.punishmentType_ID = punishments.punishment_typeID Where punishment_studentID=@StudentID");
      objCommand.Parameters.Add("@StudentID",id);
      objAdapter.SelectCommand = objCommand;
      objAdapter.Fill(ds.Tables["punishments"]);
      dataGridPunishments.DataSource = ds.Tables["punishments"].DefaultView;
      dataGridPunishments.DataBind();
    }

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
      this.dataGridAwards.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dataGridAwards_ItemCreated);
      this.dataGridAwards.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dataGridAwards_DeleteCommand);
      this.dataGridChanges.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dataGridChanges_ItemCreated);
      this.dataGridChanges.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dataGridChanges_DeleteCommand);
      this.dataGridPunishments.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dataGridPunishments_ItemCreated);
      this.dataGridPunishments.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dataGridPunishments_DeleteCommand);

    }
		#endregion

    protected void btnSerch_Click(object sender, System.EventArgs e)
    {
      Bind_stuBasicInfo(txtStudentID.Text.Trim());
      Bind_dataGridAwards(txtStudentID.Text.Trim());
      Bind_dataGridChanges(txtStudentID.Text.Trim());
      Bind_dataGridPunishments(txtStudentID.Text.Trim());
    }

    protected void btnAwardAdd_Click(object sender, System.EventArgs e)
    {
      if(txtAwardContent.Text.Trim()=="")
      {
        ShowMessage("请输入奖励内容!");
        return;
      }
      else if(txtAwardReason.Text.Trim()=="")
      {
        ShowMessage("请输入奖励原因!");
        return;
      }
      else
      {
        awardentity.AwardContent = txtAwardContent.Text.Trim();
        awardentity.AwardReason = txtAwardReason.Text.Trim();
      }      
      awardentity.AwardStudentID = txtStudentID.Text.Trim();   
      awardentity.AwardDate = System.DateTime.Now.Date;

      try
      {
        awardmanager.Insert(awardentity);
        Bind_dataGridAwards(txtStudentID.Text.Trim());
      }
      catch(Exception e1)
      {
        ShowMessage(e1.Message);
      }
    }

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

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

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

    protected void btnChangeAdd_Click(object sender, System.EventArgs e)
    {
      changeentity.ChangeStudentID = txtStudentID.Text.Trim();
      changeentity.ChangeChnageType = ddListChanges.SelectedValue.Trim();
      changeentity.ChangeReason = txtChangeReason.Text.Trim();
      changeentity.ChangeDate = System.DateTime.Now.Date;
      try
      {
        changemanager.Insert(changeentity);
        Bind_dataGridChanges(txtStudentID.Text.Trim());
      }
      catch(Exception e1)
      {
        ShowMessage(e1.Message);
      }
    }

    protected void btnPunishmentAdd_Click(object sender, System.EventArgs e)
    {
      punishmententity.PunishmentStudentID = txtStudentID.Text.Trim();
      punishmententity.PunishmentType = ddListPunishments.SelectedValue.Trim();
      punishmententity.PunishmentReason = txtPunishmentReason.Text.Trim();
      punishmententity.PunishmentDate = System.DateTime.Now.Date;
      try
      {
        punishmentmanager.Insert(punishmententity);
        Bind_dataGridPunishments(txtStudentID.Text.Trim());
      }
      catch(Exception e1)
      {
        ShowMessage(e1.Message);
      }
    }

    private void dataGridAwards_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[5].Controls[0];
        myDeleteButton.Attributes.Add("onclick", "return confirm('您真的要删除此行记录吗？');");
      }
    }

    private void dataGridChanges_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[5].Controls[0];
        myDeleteButton.Attributes.Add("onclick", "return confirm('您真的要删除此行记录吗？');");
      }
    }

    private void dataGridPunishments_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[5].Controls[0];
        myDeleteButton.Attributes.Add("onclick", "return confirm('您真的要删除此行记录吗？');");
      }
    }




	}
}