人事管理系统数据库源代码.doc

《人事管理系统数据库源代码.doc》由会员分享，可在线阅读，更多相关《人事管理系统数据库源代码.doc（58页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、Four short words sum up what has lifted most successful individuals above the crowd: a little bit more.-author-date人事管理系统数据库源代码using System;using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web

2、.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;namespace WebApplication1 public partial class WebForm1 : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) protected void Button1_Click(object se

3、nder, EventArgs e) Response.Redirect(/登录.aspx); protected void Button2_Click(object sender, EventArgs e) Response.Redirect(/人员信息查询.aspx); protected void Button3_Click(object sender, EventArgs e) Response.Redirect(/人员修改.aspx); protected void Button4_Click(object sender, EventArgs e) Response.Redirect

4、(/部门信息.aspx); protected void Button5_Click(object sender, EventArgs e) Response.Redirect(/工资信息.aspx); 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;u

5、sing System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;namespace WebApplication1 public partial class 部门信息 : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) protected void Button1_Click(object sender, EventArg

6、s e) bool find =false; SqlConnection con=new SqlConnection(server=localhost;Integrated Security=SSPI;database=人事管理系统); con.Open(); string cmdstr=select * from 部门表; SqlDataAdapter da=new SqlDataAdapter(cmdstr,con); DataSet ds=new DataSet(); da.Fill(ds); for(int i=0;ids.Tables0.Rows.Count;i+) for(int

7、j=0;jds.Tables0.Columns.Count;j+) String data=(ds.Tables0.Rowsij.ToString().Trim(); if(data=TextBox1.Text.Trim() TextBox2.Text=ds.Tables0 .Rowsi部门代码.ToString(); TextBox3.Text=ds.Tables0 .Rowsi部门名称.ToString(); find=true; if (find = false) Response.Write(window.alert(没有相关记录!); con.Close(); protected v

8、oid Button2_Click(object sender, EventArgs e) Response.Redirect(/Default.aspx); 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.Web

9、Controls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;using System.Data.SqlTypes;namespace WebApplication1 public partial class _Default : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) protected void TextBox1_TextChanged(object

10、sender, EventArgs e) protected void Button1_Click(object sender, EventArgs e) SqlConnection con = new SqlConnection(server=localhost;Integrated Security=SSPI;database=人事管理系统); string strCount; strCount = select * from 人事表; con.Open(); SqlCommand com = new SqlCommand(strCount, con); SqlDataReader dr

11、= com.ExecuteReader(); string strUsername = , strPassword = ; while (dr.Read() if (TextBox1.Text = dr编号.ToString()|TextBox2.Text = dr用户密码.ToString() strUsername = dr编号.ToString(); strPassword = dr用户密码.ToString(); break; dr.Close(); con.Close(); if (strUsername = ) Response.Write(alert(登录成功！);); retu

12、rn; protected void Button2_Click(object sender, EventArgs e) Response.Redirect(/Default.aspx); 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 Sy

13、stem.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;namespace WebApplication1 public partial class 工资信息 : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) protected void TextBox2_TextChanged(object sender, EventArg

14、s e) protected void TextBox5_TextChanged(object sender, EventArgs e) protected void Button1_Click(object sender, EventArgs e) bool find = false; SqlConnection con = new SqlConnection(server=localhost;Integrated Security=SSPI;database=人事管理系统); con.Open(); string cmdstr = select * from 工资表; SqlDataAda

15、pter da = new SqlDataAdapter(cmdstr, con); DataSet ds = new DataSet(); da.Fill(ds); for (int i = 0; i ds.Tables0.Rows.Count; i+) for (int j = 0; j ds.Tables0.Columns.Count; j+) String data = (ds.Tables0.Rowsij.ToString().Trim(); if (data = TextBox1.Text.Trim() TextBox2.Text = ds.Tables0.Rowsi应发工资.To

16、String(); TextBox3.Text = ds.Tables0.Rowsi岗位津贴.ToString(); TextBox4.Text = ds.Tables0.Rowsi奖励.ToString(); TextBox5.Text = ds.Tables0.Rowsi保险.ToString(); find = true; if (find = false) Response.Write(window.alert(没有相关记录!); con.Close(); protected void Button2_Click(object sender, EventArgs e) Response

17、.Redirect(/Default.aspx); 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;usin

18、g System.Xml.Linq;using System.Data.SqlClient;namespace WebApplication1 public partial class 人员信息 : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) protected void Button1_Click(object sender, EventArgs e) Response.Redirect(/Default.aspx); protected void Button2_Click(object s

19、ender, EventArgs e) bool find =false; SqlConnection con = new SqlConnection(server=localhost;Integrated Security=SSPI;database=人事管理系统); con.Open(); string cmdstr=select * from 工资表; SqlDataAdapter da=new SqlDataAdapter(cmdstr,con); DataSet ds=new DataSet(); da.Fill(ds); for(int i=0;ids.Tables0.Rows.C

20、ount;i+) for(int j=0;jds.Tables0.Columns.Count;j+) String data=(ds.Tables0.Rowsij.ToString().Trim(); if(data=TextBox1.Text.Trim() TextBox2.Text=ds.Tables0 .Rowsi应发工资.ToString(); TextBox3.Text=ds.Tables0 .Rowsi岗位津贴.ToString(); TextBox4.Text=ds.Tables0 .Rowsi奖励.ToString(); TextBox5.Text = ds.Tables0.R

21、owsi保险.ToString(); find=true; if (find = false) Response.Write(window.alert(没有相关记录!); con.Close(); 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;usin

22、g System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;namespace WebApplication1 public partial class 人员修改 : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) protected void TextBox5_TextChanged(object sender, Even

23、tArgs e) protected void Button2_Click(object sender, EventArgs e) SqlConnection con=new SqlConnection(server=localhost;Integrated Security=SSPI;database=人事管理系统); con.Open(); string insert=insert into 人事表(员工号，姓名，性别，职称，学历) values(+ TextBox1.Text.Trim() +,+ + TextBox2.Text.Trim() +,+ TextBox3.Text.Trim

24、() + , + TextBox4.Text.Trim() +,+ +TextBox5.Text.Trim() + +);Response.Write(insert);SqlCommand cmd1=new SqlCommand(insert,con);con.Close(); protected void Button1_Click(object sender, EventArgs e) Response.Redirect(/Default.aspx); protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) -