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

1、using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;usingusingusingusingusingusingnamespace WebApplication1publicpartialclassWebForm1Pageprotectedvoid Page_Load( objectsender,EventArgs e)protectedvoid Button1_Click(objectsender,EventA

2、rgs e)Response.Redirect("/登錄 .aspx" );protectedvoid Button2_Click(objectsender,EventArgs e)Response.Redirect("/人員信息查詢 .aspx" );protectedvoid Button3_Click(objectsender,EventArgs e)Response.Redirect("/人員修改 .aspx" );protectedvoid Button4_Click(objectsender,EventArgs e)Res

3、ponse.Redirect("/部門信息 .aspx" );protectedvoid Button5_Click(objectsender,EventArgs e)Response.Redirect("/工資信息 .aspx" );using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;usingusingusingusingusingusingusingnamespace

4、 WebApplication1publicpartialclass部門信息PageprotectedvoidPage_Load( objectsender,EventArgse)protectedvoidButton1_Click(objectsender,EventArgse)bool find =false ;SqlConnectioncon= new SqlConnection( "server=localhost;Integrated Security=SSPI;database=人事管理系統(tǒng)" );con.Open();stringcmdstr= "s

5、elect * from部門表 " ;SqlDataAdapterda= new SqlDataAdapter (cmdstr,con);DataSet ds= new DataSet ();da.Fill(ds);for ( inti=0;i<ds.Tables0.Rows.Count;i+)for ( intj=0;j<ds.Tables0.Columns.Count;j+)Stringdata=(ds.Tables0.Rowsij.ToString().Trim();ifTextBox2.Text=ds.Tables0 .Rowsi TextBox3.Text=ds

6、.Tables0 .Rowsi" 部門代碼 " .ToString();" 部門名稱 " .ToString();find=true ;if(find =false)Response.Write("<script>window.alert('沒(méi)有相關(guān)記錄!')</script>");con.Close();protectedvoidButton2_Click(objectsender,EventArgs e)Response.Redirect("/Default.aspx")

7、;usingusingusingusingusingusingusingusingusingSystem;System.Collections;System.Configuration;System.Data;System.Linq;System.Web;usingusingusingusingusingnamespace WebApplication1publicpartialclass_DefaultPageprotectedvoidPage_Load( objectsender,EventArgse)protectedvoidTextBox1_TextChanged(objectsend

8、er,EventArgse)protectedvoidButton1_Click(objectsender,EventArgse)SqlConnectioncon =new SqlConnection( "server=localhost;Integrated Security=SSPI;database=人事管理系統(tǒng)" );stringstrCount;strCount ="select * from人事表 " ; con.Open();SqlCommandcom =new SqlCommand(strCount, con);SqlDataReader

9、 dr = com.ExecuteReader();stringstrUsername ="" , strPassword ="" ;while(dr.Read()if(TextBox1.Text = dr" 編號(hào) " .ToString()|TextBox2.Text = dr" 用戶密碼" .ToString()strUsername = drstrPassword = dr" 編號(hào) " .ToString();" 用戶密碼 " .ToString();break ;dr

10、.Close();con.Close();if(strUsername ="" )Response.Write("<script language=javascript>alert('登錄成功！');</script>");return;protectedvoid Button2_Click(objectsender,EventArgs e)Response.Redirect("/Default.aspx");using System;using System.Collections;using

11、 System.Configuration;using System.Data;using System.Linq;using System.Web;usingusingusingusingusingusingusingnamespace WebApplication1publicpartialclass工資信息 Pageprotectedvoid Page_Load( objectsender,EventArgs e)protectedvoid TextBox2_TextChanged(objectsender,EventArgs e)protectedvoid TextBox5_TextC

12、hanged(objectsender,EventArgs e)protectedvoid Button1_Click(objectsender,EventArgs e)bool find =SqlConnectionfalse ;con =new SqlConnection ( "server=localhost;Integrated Security=SSPI;database=人事管理系統(tǒng) " );con.Open();stringcmdstr ="select * from工資表 " ;SqlDataAdapterda =new SqlDataA

13、dapter(cmdstr, con);DataSet ds =new DataSet ();da.Fill(ds);for( inti = 0; i < ds.Tables0.Rows.Count; i+)for( intj = 0; j < ds.Tables0.Columns.Count; j+)Stringdata = (ds.Tables0.Rowsij.ToString().Trim();ifTextBox2.Text = ds.Tables0.RowsiTextBox3.Text = ds.Tables0.RowsiTextBox4.Text = ds.Tables0

14、.RowsiTextBox5.Text = ds.Tables0.Rowsifind =true ;" 應(yīng)發(fā)工資 " .ToString();" 崗位津貼 " .ToString();" 獎(jiǎng)勵(lì) " .ToString();" 保險(xiǎn) " .ToString();if(find =false )Response.Write("<script>window.alert('沒(méi)有相關(guān)記錄 !')</script>");con.Close();protectedvoi

15、d Button2_Click(objectsender,EventArgs e)Response.Redirect("/Default.aspx");using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;usingusingusingusingusingusingusingnamespace WebApplication1publicpartialclass人員信息Pageprotectedv

16、oidPage_Load( objectsender,EventArgse)protectedvoidButton1_Click(objectsender,EventArgse)Response.Redirect("/Default.aspx");protectedvoidButton2_Click(objectsender,EventArgse)bool find =false ;SqlConnectioncon =new SqlConnection( "server=localhost;Integrated Security=SSPI;database=人事管

17、理系統(tǒng)" );con.Open();stringcmdstr= "select * from工資表 " ;SqlDataAdapterda= new SqlDataAdapter(cmdstr,con);DataSet ds= new DataSet ();da.Fill(ds);for ( inti=0;i<ds.Tables0.Rows.Count;i+)for ( intj=0;j<ds.Tables0.Columns.Count;j+)Stringdata=(ds.Tables0.Rowsij.ToString().Trim();ifTextB

18、ox2.Text=ds.Tables0 .Rowsi TextBox3.Text=ds.Tables0 .Rowsi" 應(yīng)發(fā)工資 " .ToString();" 崗位津貼 " .ToString();TextBox4.Text=ds.Tables0 .Rowsi TextBox5.Text = ds.Tables0.Rowsi" 獎(jiǎng)勵(lì) " .ToString();" 保險(xiǎn) " .ToString();find=true ;if(find =false)Response.Write("<script&

19、gt;window.alert('沒(méi)有相關(guān)記錄!')</script>");con.Close();usingusingusingusingusingSystem;System.Collections;System.Configuration;System.Data;System.Linq;using System.Web;usingusingusingusingusingusingusingnamespace WebApplication1publicpartialclass人員修改 Pageprotectedvoid Page_Load( objectsender,EventArgs e)protectedvoid TextBox5_TextChanged(objectsender,EventArgs e)protectedvoid Button2_