staff/staffmod.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using dao;
public partial class staff_staffmod : System.Web.UI.Page
{
    string id = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        id = Request.QueryString["id"].ToString();
        if (!IsPostBack)
        {

            string sql = "select * from staff where s_id='" + id + "'";
            DataTable dt = DBHelper.GetDataSet(sql);
            if (dt.Rows.Count > 0)
            {
               this.s_name.Text =dt.Rows[0]["s_name"].ToString();
this.s_sex.Text =dt.Rows[0]["s_sex"].ToString();
this.s_adress.Text =dt.Rows[0]["s_adress"].ToString();
this.s_tel.Text =dt.Rows[0]["s_tel"].ToString();
this.s_email.Text =dt.Rows[0]["s_email"].ToString();


     
            }
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
      string s_name=this.s_name.Text;//姓名
string s_sex=this.s_sex.Text;//性别
string s_adress=this.s_adress.Text;//住址
string s_tel=this.s_tel.Text;//联系电话
string s_email=this.s_email.Text;//邮箱地址

		if(s_name.Length==0){
MessageBox.Show(this.Page,"姓名不能为空");
return ;
}


     
        string sql = "update staff set  s_name='"+s_name+"',s_sex='"+s_sex+"',s_adress='"+s_adress+"',s_tel='"+s_tel+"',s_email='"+s_email+"' where s_id ='"+id+"'";
        int row = 0;
        try
        {
            row = DBHelper.ExecuteCommand(sql);
        }
        catch (Exception ex)
        {