OA系统

开发平台：

ASP/ASPX

edit_login.aspx.cs：源码内容

							﻿using System;
using System.Data;
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;
using System.Data.SqlClient;
public partial class web_personnel_edit_login : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        LoginDAO.CheckLogin(Session, Response, "../", 2);
    }
    protected void BtnOk_Click(object sender, EventArgs e)
    {
        if (Session["user_id"] != null)
        {
            int user_id = Convert.ToInt32(Session["user_id"]);
            SqlConnection conn = dbConnection.getConnection();
            conn.Open();
            int flag = 1;
            SqlCommand cmd = new SqlCommand("select id from OA_EMPLOYEE where login_name='" + TxtName.Text + "'", conn);
            try
            {
                int id = Convert.ToInt32(cmd.ExecuteScalar());
                if (id == user_id)
                {
                    flag = 1;
                }
                else
                {
                    flag = 0;
                }
                if (id == 0)
                {
                    flag = 1;
                }
            }
            catch { flag = 0; }
            if (flag == 1)
            {
                cmd = new SqlCommand("update OA_EMPLOYEE set login_name='" + TxtName.Text + "', pwd='" + TxtPwd.Text + "' where id=" + user_id, conn);
                cmd.ExecuteNonQuery();
                Response.Write("<script language='javascript'>alert('更新成功!');</script>");
            }
            else
            {
                Response.Write("<script language='javascript'>alert('已存在相同登錄名的員工!');</script>");
            }
            conn.Close();
        }
    }
}

						