emp_info_edit.aspx.cs

贸易有限公司项目管理系统(C#.NET2003),供学习参考！

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 Emp_Info_Edit : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["Name"] == null)
        {
            JS.Alert("您还未登陆或登陆超时！");
            Response.Redirect("Default.aspx");
        }
        if (!IsPostBack)
        {
            string name = Request.QueryString["Name"].ToString();

            SqlConnection con = DB.createCon();
            con.Open();
            SqlCommand cmd = new SqlCommand("select * from Employee where Emp_Name='" + name + "'", con);
            SqlDataReader dr = cmd.ExecuteReader();
            if (dr.Read())
            {
                txtName.Text = dr["Emp_Name"].ToString();
                string sex = dr["Emp_Sex"].ToString();
                if (sex == "男")
                {
                    rbtnMale.Checked = true;
                }
                else
                {
                    rbtnFemale.Checked = true;
                }
                txtBirthday.Text = dr["Emp_Birthday"].ToString();
                txtStartTime.Text = dr["Start_Date"].ToString();
                txtEndTime.Text = dr["End_Date"].ToString();
                txtAddress.Text = dr["Emp_Address"].ToString();
                txtTel.Text = dr["Emp_Tel"].ToString();
                txtEmail.Text = dr["Emp_Email"].ToString();
                txtQQ.Text = dr["Emp_QQ"].ToString();
            }
        }
    }
    protected void btnModify_Click(object sender, ImageClickEventArgs e)
    {
        string department = dropDep.SelectedValue.ToString();
        string birthday = txtBirthday.Text;
        string sex="";
        if(rbtnMale.Checked)
        {
            sex = "男";
        }
        else
        {
            sex = "女";
        }
        string start = txtStartTime.Text;
        string end = txtEndTime.Text;
        string address = txtAddress.Text;
        string tel = txtTel.Text;
        string email = txtEmail.Text;
        string qq = txtQQ.Text;
        string name = Request.QueryString["Name"].ToString();
        string sql="update Employee set Emp_Sex='"+sex+"',Emp_Birthday='"+birthday+"',Dep_Name='"+department+"',Start_Date='"+start+"',End_Date='"+end+"',Emp_Address='"+address+"',Emp_Tel='"+tel+"',Emp_Email='"+email+"',Emp_QQ='"+qq+"'where Emp_Name='"+name+"'";
        try
        {
            DB.sqlDo(sql);
            Response.Redirect("Admin_FriendsList.aspx");
        }
        catch(Exception e3)
        {
            JS.Alert("更新失败");
        }
        

    }
    protected void dropDep_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
}