实训九 员工信息管理.doc

实训九 员工信息管理实训目的：实训内容：实训过程：1 员工信息管理界面制作(worker.aspx)全部静态代码如下： 无标题页    员工信息    员工信息添加/修改/查询    编号: 姓名: 密码: 性别: 男 女     权限: 销售员 进货员 管理员 电话: 身份证号:    工资: 住址: asp:LinkButton ID=LinkButton1 runat=server CommandArgument= CommandName=xiugai修改   asp:LinkButton ID=LinkButton2 runat=server CommandArgument= CommandName=del删除 2 编写动态代码（worker.aspx.cs）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 System.Data.OleDb;public partial class gongyingshang : System.Web.UI.Page DBfunction db = new DBfunction(); protected void Page_Load(object sender, EventArgs e) db.isLogin(); if (!IsPostBack) binddata(); void binddata() GridView1.DataSource = db.getDataView(select * from yuangong); GridView1.DataBind(); protected void Button1_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 & TextBox3.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 + , + 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= + 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()+; 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.Text = ; 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(员工编号、姓名、密码、身份证号不能为空), true); protected void 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 = int.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(); binddat