人事管理系統(tǒng)大數(shù)據(jù)庫(kù)源代碼_第1頁(yè)
人事管理系統(tǒng)大數(shù)據(jù)庫(kù)源代碼_第2頁(yè)
人事管理系統(tǒng)大數(shù)據(jù)庫(kù)源代碼_第3頁(yè)
已閱讀5頁(yè)，還剩3頁(yè)未讀， 繼續(xù)免費(fèi)閱讀

下載本文檔

版權(quán)說(shuō)明：本文檔由用戶(hù)提供并上傳，收益歸屬內(nèi)容提供方，若內(nèi)容存在侵權(quán)，請(qǐng)進(jìn)行舉報(bào)或認(rèn)領(lǐng)

文檔簡(jiǎn)介

1、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; using System.Xml.Linq;namespa

2、ce WebApplication1 public partial class WebForm1: System.Web.UI. Pageprotected void Page_Load( object sender, EventArgs e) protected void Button1_Click( object sender, EventArgs e) Response.Redirect( "/ 登錄 .aspx" );protected void Button2_Click( object sender, EventArgs e) Response.Redirect

3、( "/ 人員信息查詢(xún) .aspx" ); protected void Button3_Click( object sender, Response.Redirect( "/ 人員修改 .aspx" ); protected void Button4_Click( object sender, Response.Redirect( "/ 部門(mén)信息 .aspx" ); protected void Button5_Click( object sender, Response.Redirect( "/ 工資信息 .aspx&q

4、uot; ); EventArgs e)EventArgs e)EventArgs e)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.WebCont

5、rols.WebParts;using System.Xml.Linq;using System.Data.SqlClient;namespace WebApplication1public partial class 部門(mén)信息 : System.Web.UI. Pageprotected void Page_Load( object sender, EventArgs e)protected void Button1_Click( object sender, EventArgs e)bool find = false ;SqlConnection con= new SqlConnectio

6、n ( "server=localhost;Integrated Security=SSPI;database= 人事管理系統(tǒng) ");con.Open();string cmdstr= "select * from部門(mén)表 "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.Column

7、s.Count;j+)String data=(ds.Tables0.Rowsij.ToString().Trim();if (data=TextBox1.Text.Trim()TextBox2.Text=ds.Tables0 .Rowsi " 部門(mén)代碼 " .ToString();TextBox3.Text=ds.Tables0 .Rowsi" 部門(mén)名稱(chēng) " .ToString();find= true ;if (find = false )Response.Write( "<script>window.alert(' 沒(méi)

8、有相關(guān)記錄 !')</script>" ); con.Close();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;us

9、ing 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 WebApplication1 public partialprotectedclass _Default : System.Web.UI. Pagevoid Page_Loa

10、d( object sender, EventArgs e)protected void TextBox1_TextChanged( object sender, EventArgs e) protected void Button1_Click( object sender, EventArgs e) SqlConnection con = new SqlConnection ( "server=localhost;Integrated Security=SSPI;database= 人事管理系統(tǒng) ");string strCount;strCount = "s

11、elect * from 人事表 " con.Open(); SqlCommandcom = new SqlComman(dstrCount, con); SqlDataReader dr = com.ExecuteReader(); string strUsername = "" , strPassword = "" ;while (dr.Read()"用戶(hù)密碼 if (TextBox1.Text = dr"編號(hào) " .ToString()|TextBox2.Text = dr.ToString() strUse

12、rname = dr"編號(hào) " .ToString();strPassword = dr"用戶(hù)密碼 " .ToString();break ;dr.Close();con.Close();if (strUsername = "" )');</script>" );Response.Write( "<script language=javascript>alert(' 登錄成功！ return ;protected void Button2_Click( object send

13、er, 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.WebControls;using S

14、ystem.Web.UI.WebControls.WebParts; using System.Xml.Linq;using System.Data.SqlClient;namespace WebApplication1 public partial class 工資信息 : System.Web.UI. Pageprotected void Page_Load( object sender, EventArgs e) protected void TextBox2_TextChanged( object sender, EventArgs e) protected void TextBox5

15、_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= 人事管理系統(tǒng) ");con.Open();string cmdstr = "select * from 工資表 " SqlDataAda

16、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.Row

17、siTextBox3.Text = ds.Tables0.RowsiTextBox4.Text = ds.Tables0.RowsiTextBox5.Text = ds.Tables0.Rowsi" 應(yīng)發(fā)工資 " .ToString(); " 崗位津貼 " .ToString(); "獎(jiǎng)勵(lì) " .ToString(); "保險(xiǎn) " .ToString();find =true ;if (find =Response.Write( con.Close();false )"<script>wind

18、ow.alert('沒(méi)有相關(guān)記錄 !')</script>" );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.Securi

19、ty;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 WebApplication1public partial class 人員信息 : System.Web.UI. Pageprotected void Page_Load( object sender, EventArg

20、s e)protected 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

21、.Open();string 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();if (data=TextBox1.Te

22、xt.Trim()應(yīng)發(fā)工資 " .ToString(); "崗位津貼 " .ToString(); 獎(jiǎng)勵(lì) " .ToString();"保險(xiǎn)" .ToString();TextBox2.Text=ds.Tables0 .RowsiTextBox3.Text=ds.Tables0 .RowsiTextBox4.Text=ds.Tables0 .RowsiTextBox5.Text = ds.Tables0.Rowsifind= true ; if (find = false )Response.Write( "<scri

23、pt>window.alert(' 沒(méi)有相關(guān)記錄 !')</script>" );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;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;namespace WebApplication1public partial class 人員修改 : System.Web.UI. Pageprotected void Page_Load( object sender, EventArgs e)protected void TextBox5_TextChanged( object sender, EventArgs

溫馨提示

  • 1. 本站所有資源如無(wú)特殊說(shuō)明，都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請(qǐng)下載最新的WinRAR軟件解壓。
  • 2. 本站的文檔不包含任何第三方提供的附件圖紙等，如果需要附件，請(qǐng)聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶(hù)所有。
  • 3. 本站RAR壓縮包中若帶圖紙，網(wǎng)頁(yè)內(nèi)容里面會(huì)有圖紙預(yù)覽，若沒(méi)有圖紙預(yù)覽就沒(méi)有圖紙。
  • 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
  • 5. 人人文庫(kù)網(wǎng)僅提供信息存儲(chǔ)空間，僅對(duì)用戶(hù)上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理，對(duì)用戶(hù)上傳分享的文檔內(nèi)容本身不做任何修改或編輯，并不能對(duì)任何下載內(nèi)容負(fù)責(zé)。
  • 6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容，請(qǐng)與我們聯(lián)系，我們立即糾正。
  • 7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時(shí)也不承擔(dān)用戶(hù)因使用這些下載資源對(duì)自己和他人造成任何形式的傷害或損失。

最新文檔

評(píng)論

0/150

提交評(píng)論