showemployeeinfo.aspx.cs

一个小型的人事管理系统

using System;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
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;

public partial class ShowEmployeeInfo : System.Web.UI.Page
{
 /*   private string EmployeeID;
    private string Email;
    private string BossName;
    private string DeptName;
    private string Telephone;
*/
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Request.QueryString["id"] != null &&
                Request.QueryString["id"].ToString() != Session["EmployeeID"].ToString())
            {
                ShowInfo(Request.QueryString["id"].ToString());
                ButtonUpdate.Visible = false;
                LabelCanUpdate.Visible = false;
                TextBoxIntro.ReadOnly = true;
            }
            else
            {
                ShowInfo(Session["EmployeeID"].ToString());
                ButtonUpdate.Visible = true;
                LabelCanUpdate.Visible = true;
                TextBoxIntro.ReadOnly = false;
            }
        }
    }
    protected void ShowInfo(string EmployeeID)
    {
        String strconn = System.Configuration.ConfigurationManager.AppSettings["SQLCONNECTION"];
        String DeptID;
        SqlConnection myconn = new SqlConnection(strconn);
        String strself = "SELECT tblEmployee.DeptID,Name,EmployeeID,Email,DeptName,SelfIntro,Telephone FROM tblEmployee,tblDepartment" +
            " WHERE tblEmployee.DeptID = tblDepartment.DeptID AND tblEmployee.EmployeeID = '" + EmployeeID.ToString() + "'";
        SqlCommand dbself = new SqlCommand(strself, myconn);
        myconn.Open();
        SqlDataReader drEmployee = dbself.ExecuteReader();
        drEmployee.Read();
        DeptID = drEmployee["DeptID"].ToString();
        LabelEmployeeID.Text= drEmployee["EmployeeID"].ToString();
        LabelEmail.Text = drEmployee["Email"].ToString();
        LabelDeptName.Text = drEmployee["DeptName"].ToString();
        LabelTelephone.Text = drEmployee["Telephone"].ToString();
        LabelName.Text = drEmployee["Name"].ToString();
        TextBoxIntro.Text = drEmployee["SelfIntro"].ToString();
        myconn.Close();

        String strboss = "Select Name AS BossName FROM tblEmployee,tblDepartment"
        + " WHERE tblEmployee.EmployeeID = tblDepartment.ManagerID AND tblDepartment.DeptID ='" + DeptID + "'";
        SqlCommand dbboss = new SqlCommand(strboss, myconn);
        myconn.Open();
        SqlDataReader drBoss = dbboss.ExecuteReader();
        drBoss.Read();
        LabelBossName.Text = drBoss["BossName"].ToString();
        myconn.Close();
    }
    protected void UpdateIntro(string EmployeeID,string text)
    {   //取消加班申请，注意是做一个更新操作
        String strconn = System.Configuration.ConfigurationManager.AppSettings["SQLCONNECTION"];
        SqlConnection myconn = new SqlConnection(strconn);
        String strsql = "UPDATE tblEmployee SET SelfIntro = '" + text.ToString() + 
            "' WHERE EmployeeID = '" + EmployeeID.ToString() + "'";
        SqlCommand mycmd = new SqlCommand(strsql, myconn);
        myconn.Open();
        mycmd.ExecuteNonQuery();
        myconn.Close();
    }
    protected void ButtonUpdate_Click(object sender, EventArgs e)
    {
    //    if (!IsPostBack)
    //    {
            UpdateIntro(Session["EmployeeID"].ToString(), TextBoxIntro.Text);
            ShowInfo(Session["EmployeeID"].ToString());
    //    }
    }
}