实训九 员工信息管理

1、实训九 员工信息管理实训目的：实训内容：实训过程：员工信息管理界面制作(worker.aspx)全部静态代码如下：无标题页员工信息员工信息添加/修改/查询编号:姓名:密码:性别:男女权限:销售员进货员管理员电话:身份证号:工资:住址:asp:LinkButtonID=LinkButton1runat=serverCommandArgument=CommandName=xiugai修改asp:LinkButtonID=LinkButton2runat=serverCommandArgument=CommandName=del删除编写动态代码（worker.aspx.cs）using System

2、;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 System.Data.Ol

3、eDb;publicpartialclassgongyingshang : System.Web.UI.PageDBfunction db = newDBfunction();protectedvoid Page_Load(object sender, EventArgs e) db.isLogin();if (!IsPostBack) binddata(); void binddata() GridView1.DataSource = db.getDataView(select * from yuangong); GridView1.DataBind(); protectedvoid But

4、ton1_Click(object sender, EventArgs e) string sqlcheck = ;string sql = ;if (Sessionquanxian = null | Sessionquanxian.ToString() != 0) ScriptManager.RegisterStartupScript(this, GetType(), , alert(对不起，您的权限不够!), true);return; else if (TextBox1.Text.Trim().Length 0 & TextBox2.Text.Trim().Length 0 & Text

5、Box3.Text.Trim().Length 0 & TextBox6.Text.Trim().Length 0) if (Button1.Text = 添加) sql = insert into yuangong(bianhao,username,passwd,quanxian,xinbie,tel,address,sfz,gongzi) values( + TextBox1.Text.Trim() + ,; sql += TextBox2.Text.Trim() +, + TextBox3.Text .Trim()+ , + DropDownList1.SelectedValue + ,

6、 + RadioButtonList1.SelectedValue + ,; sql += TextBox5.Text.Trim() + , + TextBox8.Text.Trim() + ,+TextBox6.Text.Trim() + , + TextBox7.Text.Trim()+); sqlcheck = select * from yuangong where bianhao= + TextBox1.Text.Trim() + and sfz= + TextBox6.Text.Trim() + ; else sql = UPDATE yuangong SET bianhao= +

7、 TextBox1.Text.Trim() + ,username= + TextBox2.Text.Trim(); sql+=,passwd=+TextBox3.Text.Trim ()+,quanxian=+DropDownList1.SelectedValue+,xinbie=; sql+=RadioButtonList1.SelectedValue+,tel=+TextBox5.Text.Trim()+,address=+TextBox8.Text.Trim();sql+=,sfz=+TextBox6.Text.Trim()+,gongzi=+TextBox7.Text.Trim()+

8、; sql += where id= + ViewStateid.ToString(); sqlcheck = select * from (select * from yuangong where id + ViewStateid.ToString() + as t1) where bianhao= + TextBox1.Text.Trim() + and sfz= + TextBox6.Text.Trim() + ; if (!db.isExist(sqlcheck) db.sqlExecute(sql); Button1.Text = 添加; binddata(); TextBox1.T

9、ext = ; TextBox2.Text = ; TextBox3.Text = ; TextBox5.Text = ; TextBox6.Text = ; TextBox7.Text = ; TextBox8.Text = ; TextBox1.Focus(); else ScriptManager.RegisterStartupScript(this, GetType(), , alert(该记录已经存在！), true); else ScriptManager.RegisterStartupScript(this, GetType(), , alert(员工编号、姓名、密码、身份证号不

10、能为空), true); protectedvoid GridView1_RowCommand(object sender, GridViewCommandEventArgs e) int id;DataRow dr;if (Sessionquanxian = null | Sessionquanxian.ToString() != 0) ScriptManager.RegisterStartupScript(this, GetType(), , alert(对不起，您的权限不够!), true);return; else if (e.CommandName = xiugai) id = in

11、t.Parse(e.CommandArgument.ToString(); ViewStateid = id; dr = db.getDataRow(select * from yuangong where id= + id); TextBox1.Text = drbianhao.ToString(); TextBox2.Text = drusername.ToString(); TextBox3.Text = drpasswd.ToString(); TextBox5.Text = drtel.ToString(); TextBox6.Text = drsfz.ToString(); TextBox7.Text = drgongzi.ToString(); TextBox8.Text = draddress.ToString(); RadioButtonList1.SelectedValue = drxinbie.ToString(); DropDownList1.SelectedValue = drquanxian.ToString(); Button1.Text = 保存; else db.sqlExecute(delete from yuangong where id= + e.CommandArgument.ToString(); binddata();