人事管理系統(tǒng)數(shù)據(jù)庫源代碼

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=人事管理系統(tǒng)); 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(沒有相關(guān)記錄!); 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=人事管理系統(tǒng));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應(yīng)發(fā)工資.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(沒有相關(guān)記錄!); 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=人事管理系統(tǒng)); 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應(yīng)發(fā)工資.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(沒有相關(guān)記錄!); 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