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

1、-.-.-. -. 可修编.using System;using System.Collections; using System.Configuration; usingSystem.Data;using usingSystem.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;nam

2、espace WebApplication1publicpartialclassWebForm1 : System.Web.UI.Pageprotectedvoid Page_Load(object sender, EventArgs e)protectedvoid Button1_Click(object sender, EventArgs e)Response.Redirect(/登录.aspx);protectedvoid Button2_Click(object sender, EventArgs e)Response.Redirect(/人员信息查询.aspx);protectedv

3、oid Button3_Click(object sender, EventArgs e)Response.Redirect(/人员修改.aspx);protectedvoid Button4_Click(object sender, EventArgs e)Response.Redirect(/部门信息.aspx);protectedvoid Button5_Click(object sender, EventArgs e)Response.Redirect(/工资信息.aspx);using System;using System.Collections; using System.Con

4、figuration; usingSystem.Data;using usingSystem.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.SqlClient; namespace WebApplication1publicpartialclass

5、部门信息 : System.Web.UI.Pageprotectedvoid Page_Load(object sender, EventArgs e)protectedvoid Button1_Click(object sender, EventArgs e)bool find =false;SqlConnection con=newSqlConnection(server=localhost;Integrated Security=SSPI;database=人事管理系统); con.Open();string cmdstr=select * from 部 门 表 ; SqlDataAda

6、pter da=newSqlDataAdapter(cmdstr,con); DataSet ds=newDataSet();da.Fill(ds);for(int i=0;ids.Tables0.Rows.Count;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.Tab

7、les0 .Rowsi部门名称.ToString();find=true;if (find = Response.Write(window.alert(没有相关记录!); con.Close();protectedvoid Button2_Click(object sender, EventArgs e)Response.Redirect(/Default.aspx);using System;using System.Collections; using System.Configuration; usingSystem.Data;using usingSystem.Web;using Sy

8、stem.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.SqlClient; using System.Data.SqlTypes; namespace publicpartialclass_Default : System.Web.UI.Pageprotectedvoid Pag

9、e_Load(object sender, EventArgs e)protectedvoid TextBox1_TextChanged(object sender, EventArgs e)protectedvoid Button1_Click(object sender, EventArgs e)SqlConnection con = newSqlConnection(server=localhost;Integrated Security=SSPI;database=人事管理系统);string strCount;strCount=select*from 人事表;con.Open();

10、Sqlmand= newSqlmand(strCount,con);SqlDataReader dr = .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 (strUse

11、rname = )return;Response.Write(alert(登录成功！););protectedvoid Button2_Click(object sender, EventArgs e)Response.Redirect(/Default.aspx);using System;using System.Collections; using System.Configuration; usingSystem.Data;using usingSystem.Web;using System.Web.Security;using System.Web.UI;using System.W

12、eb.UI.HtmlControls; using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts; using System.Xml.Linq;using System.Data.SqlClient;namespace WebApplication1publicpartialclass工资信息 : System.Web.UI.Pageprotectedvoid Page_Load(object sender, EventArgs e)protectedvoid TextBox2_TextChanged(ob

13、ject sender, EventArgse)protectedvoid TextBox5_TextChanged(object sender, EventArgse)protectedvoid Button1_Click(object sender, EventArgs e)bool find = false;SqlConnectioncon = newSqlConnection(server=localhost;Integrated Security=SSPI;databasecon.Open();string cmdstr = select * from 工 资 表 ; SqlData

14、Adapter da = newSqlDataAdapter(cmdstr, DataSet dsnewDataSet();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应发工资.ToString(); Tex

15、tBox3.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();protectedvoid Button2_Click(object sender, EventArgs e)Response.Redirect(/Defau

16、lt.aspx);using System;using System.Collections; using System.Configuration; usingSystem.Data;using usingSystem.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 Sy

17、stem.Data.SqlClient; namespace WebApplication1publicpartialclass人员信息 : System.Web.UI.Pageprotectedvoid Page_Load(object sender, EventArgs e)protectedvoid Button1_Click(object sender, EventArgs e)Response.Redirect(/Default.aspx);protectedvoid Button2_Click(object sender, EventArgs e)bool find =false;

18、SqlConnection con = newSqlConnection(server=localhost;Integrated Security=SSPI;database=人事管理系统); con.Open();string cmdstr=select * from 工 资 表 ; SqlDataAdapter da=newSqlDataAdapter(cmdstr,con); DataSet ds=newDataSet();da.Fill(ds);for(int i=0;ids.Tables0.Rows.Count;i+)for(int j=0;jds.Tables0.Columns.C

19、ount;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.Rowsi保险.ToString();find=true;if (find = Re

20、sponse.Write(window.alert(没有相关记录!); con.Close();using System;using System.Collections; using System.Configuration; usingSystem.Data;using usingSystem.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.SqlClient; namespace WebApplication1publicpartialclass人员修改 : System.Web.UI.Page