employeeselfin.aspx.cs

asp.net 2.0的教务管理软件源码

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Collections.Generic;
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 Personal_EmployeeSelfIn : System.Web.UI.Page
{
    int formID;
    int em_Duty = 0;
    int em_Department = 0;
    LoginInfo My;

    protected void Page_Load(object sender, EventArgs e)
    {
        My = new LoginInfo(Session["LoginID"]);
        if (!My.IsAdmin()) Response.Redirect("~/Signin.aspx");
        formID = My.LoginID;
        PersonInput.PersonID = formID;
        
        if (!IsPostBack)
        {
            String sql = "SELECT * FROM J_Employee WHERE em_ID=" + formID;
            DataTable dt =DBExec.ExecDataTable(sql);
            if (dt.Rows.Count != 0)
            {
                DataRow sdr = dt.Rows[0];
                tpBuMen.SelectedValue = sdr["em_Department"].ToString();
                tpZhiWu.SelectedValue = Convert.ToInt32(sdr["em_Duty"]);
                lblMessageResult.Text = "修改我的个人资料";
            }
            else
                ErrMsg.Text = "***系统异常*** 没有找到该员工，请与系统管理员联系。";
       }
        else
        {
            em_Duty = Convert.ToInt32(tpZhiWu.SelectedValue);
            em_Department = Convert.ToInt32(tpBuMen.SelectedValue);
        }
    }

    protected void btnOK_Click(object sender, EventArgs e)
    {
       PersonInput.AddorModify();
       List<SqlParameter> sp = new List<SqlParameter>();
       formID = PersonInput.PersonID;
       /*sp.Add(new SqlParameter("@em_ID",formID));
       sp.Add(new SqlParameter("@em_Department", em_Department));
       if (PersonInput.Operation == uctl_PersonInput.Modified)
        {
            sql = "UPDATE J_Employee SET em_Duty=@em_Duty,em_Department=@em_Department WHERE em_ID=@em_ID";
            DBExec.ExecParamQuery(sql, sp);
            lblMessageResult.Text = "成功修改了我的信息";
        }*/
       lblMessageResult.Text = "成功修改了我的信息";
       lblMessageResult.Text += formID + "号：" + PersonInput.PersonName;
    }
    protected void btnChgPass_Click(object sender, EventArgs e)
    {
        string sql;
        string oldPass = txtOldPass.Text;
        string newPass1 = txtNewPass1.Text;
        string newPass2 = txtNewPass2.Text;

        ErrMsg.Text = "";
        if (newPass1 != newPass2 || newPass1 == "")
        {
            ErrMsg.Text += "两个新密码不相同。<br /> ";
        }
        oldPass = Md5Convert.MD5(oldPass);
        sql = "SELECT COUNT(em_ID) FROM J_Employee WHERE em_PassWord='"+oldPass+"' AND em_ID="+My.LoginID;

        if (DBExec.ExecGetInt(sql) == 0)
        {
            ErrMsg.Text += "原密码不符.<br />";
            return;
        }

        newPass1 = Md5Convert.MD5(newPass1);

        sql = "UPDATE J_Employee SET em_PassWord='"+newPass1+"' WHERE em_ID=" + My.LoginID;

        DBExec.ExecNonQuery(sql);

        ErrMsg.Text += "密码修改成功！" ;
    }
}