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

1、using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;namespace WebApplication1 protected void Page_Load( object sender, EventArgs e) protected void Button1_Click( object sender, EventArgs e) Response.Redirect( "/ 登錄 .aspx" );

2、protected void Button2_Click( object sender, EventArgs e) Response.Redirect( "/ 人員信息查詢 .aspx" ); protected void Button3_Click( object sender, Response.Redirect( "/ 人員修改 .aspx" ); protected void Button4_Click( object sender, Response.Redirect( "/ 部門信息 .aspx" ); protected

3、 void Button5_Click( object sender, Response.Redirect( "/ 工資信息 .aspx" ); EventArgs e)EventArgs e)EventArgs e)using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;namespace WebApplication1public partial class 部門信息 : protected

4、void Page_Load( 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= 人事管理系統(tǒng) ");con.Open();string cmdstr= "select * from部門表 "SqlDataAdapter

5、 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();TextBox2.Text=ds.Tables0 .Rowsi " 部門代碼 " .ToString();TextBox3.Text=ds.Tables

6、0 .Rowsi" 部門名稱 " .ToString();find= true ;if (find = false )Response.Write( "<script>window.alert(' 沒有相關(guān)記錄 !')</script>" ); con.Close();protected void Button2_Click( object sender, EventArgs e)Response.Redirect( "/Default.aspx" );using System;using Sy

7、stem.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;public partialprotectedclass _Default : void Page_Load( object sender, EventArgs e)protected void TextBox1_TextChanged( object sender, EventArgs e) protected void Button1_Click( object sender, EventArgs

8、e) SqlConnection con = new SqlConnection ( "server=localhost;Integrated Security=SSPI;database= 人事管理系統(tǒng) ");string strCount;strCount = "select * from 人事表 " con.Open(); SqlCommandcom = new SqlComman(dstrCount, con); SqlDataReader dr = com.ExecuteReader(); string strUsername = "

9、" , 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 = "" )'

10、;);</script>" );Response.Write( "<script language=javascript>alert(' 登錄成功！ return ;protected void Button2_Click( object sender, EventArgs e) Response.Redirect( "/Default.aspx" );using System;using System.Collections;using System.Configuration;using System.Data;usi

11、ng System.Linq;using System.Web;namespace WebApplication1 public partial class 工資信息 : protected void Page_Load( object sender, EventArgs e) protected void TextBox2_TextChanged( object sender, EventArgs e) protected void TextBox5_TextChanged( object sender, EventArgs e) protected void Button1_Click(

12、object sender, EventArgs e) bool find = false ;SqlConnection con = new SqlConnection ( "server=localhost;Integrated Security=SSPI;database= 人事管理系統(tǒng) ");con.Open();string cmdstr = "select * from 工資表 " SqlDataAdapter da = new SqlDataAdapter (cmdstr, con); DataSet ds = new DataSet ();

13、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 = TextBox2.Text = ds.Tables0.RowsiTextBox3.Text = ds.Tables0.RowsiTextBox4.Text = ds.Tables0.RowsiTextBox5.Text = ds.Tables0

14、.Rowsi" 應(yīng)發(fā)工資 " .ToString(); " 崗位津貼 " .ToString(); "獎勵 " .ToString(); "保險 " .ToString();find =true ;if (find =Response.Write( con.Close();false )"<script>window.alert('沒有相關(guān)記錄 !')</script>" );protected void Button2_Click( object sen

15、der, EventArgs e) Response.Redirect( "/Default.aspx" ); using System;using System.Collections; using System.Configuration;using System.Data;using System.Linq;using System.Web;namespace WebApplication1public partial class 人員信息 : protected void Page_Load( object sender, EventArgs e)protected

16、 void Button1_Click( object sender, EventArgs e)Response.Redirect( "/Default.aspx" );protected void Button2_Click( object sender, EventArgs e)bool find = false ;SqlConnection con = new SqlConnection ( "server=localhost;Integrated Security=SSPI;database= 人事管理系統(tǒng) ");con.Open();strin

17、g cmdstr= "select * from工資表 "SqlDataAdapter 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();應(yīng)發(fā)工資 " .ToString(); "崗位

18、津貼 " .ToString(); 獎勵 " .ToString();"保險" .ToString();TextBox2.Text=ds.Tables0 .RowsiTextBox3.Text=ds.Tables0 .RowsiTextBox4.Text=ds.Tables0 .RowsiTextBox5.Text = ds.Tables0.Rowsifind= true ; if (find = false )Response.Write( "<script>window.alert(' 沒有相關(guān)記錄 !')<

19、;/script>" );con.Close();using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;namespace WebApplication1public partial class 人員修改 : protected void Page_Load( object sender, EventArgs e)protected void TextBox5_TextChanged( object sender, EventArgs e) protected void Button2_Click( object sender, Ev