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

1、using System;using System.Collections; using System.Configuration;using System.Data;using System.Linq;using System.Web;usingusing using using usingusingnamespaceWebApplication1public partial class WebForm1Pageprotected void Page_Load( object sender, EventArgs e)protected void Button1_Click( object s

2、ender, EventArgs e)Response.Redirect(protected void Button2 Response.Redirect(protected void Button3 Response.Redirect(protected void Button4 Response.Redirect(protected void Button5 Response.Redirect(using System;using System.Collections;using System.Configuration;using System.Data;using System.Lin

3、q;using System.Web; using using"/ 登录 .aspx" );Click( object sender,EventArgse)"/ 人员信息查询 .aspx");Click( object sender,EventArgse)"/ 人员修改 .aspx" );Click( object sender,EventArgse)"/ 部门信息 .aspx" );Click( object sender,EventArgse)/ 工资信息 .aspx" );using using u

4、singusing using namespaceWebApplication1public partial class 部门信息 Pageprotected 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= 系

5、统 ");con.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();ifTex

6、tBox2.Text=ds.Tables0 .Rowsi "部门代码 " .ToString();TextBox3.Text=ds.Tables0 .Rowsi" 部门名称 " .ToString();find= true ; if (find = false )Response.Write( "<script>window.alert(' 没有相关记录 !')</script>" );con.Close();protected void Button2_Click( object sender

7、, EventArgs e)Response.Redirect( "/Default.aspx" );using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;usingusingusingusingusingusingusingusing namespaceWebApplication1public partial class _DefaultPageprotected void Page_Loa

8、d( object sender, EventArgs e)protected void TextBox1_TextChanged( object sender, EventArgs e)protected void Button1_Click( object sender, EventArgs e)stringstrCount;strCount ="select * from 人事表 " con.Open();SqlConnection con = 人事管理系统 ");new SqlConnection ( "server=localhost;Inte

9、grated Security=SSPI;database=SqlCommandcom = new SqlCommand(strCount, con);SqlDataReader dr = com.ExecuteReader(); string strUsername = "" , strPassword ="" ;while (dr.Read()用户密码 " .ToString()if (TextBox1.Text = dr " 编号 ".ToString()|TextBox2.Text = dr strUsername

10、= dr strPassword = dr break ;dr.Close(); con.Close();if (strUsername = Response.Write( return ;编号 " .ToString(); 用户密码 " .ToString();"" )"<script language=javascript>alert('登录成功！');</script>" );protected void Button2_Click( object sender, EventArgs e)

11、 Response.Redirect( "/Default.aspx" );using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;usingusing usingusingusingusingusingnamespaceWebApplication1public partialclass 工资信息 PageprotectedvoidPage_Load( object sender, EventA

12、rgse)protectedvoidTextBox2_TextChanged(objectsender,EventArgs e)protected void Button1_Click( object sender, EventArgs e)bool find = false ;SqlConnection con = new SqlConnection ( "server=localhost;Integrated Security=SSPI;database= 人事管理系统 ");con.Open();string cmdstr = "select * from

13、工资表 "SqlDataAdapter da = new SqlDataAdapter (cmdstr, con);DataSet ds = new DataSet ();da.Fill(ds);( int i = 0; i < ds.Tables0.Rows.Count; i+)forfor ( int j = 0; j < ds.Tables0.Columns.Count; j+)"应发工资 " .ToString(); "岗位津贴 " .ToString(); "奖励 " .ToString(); &quo

14、t;保险 " .ToString();String data = (ds.Tables0.Rowsij.ToString().Trim(); iftrue ;TextBox2.Text = ds.Tables0.Rowsi TextBox3.Text = ds.Tables0.Rowsi TextBox4.Text = ds.Tables0.Rowsi TextBox5.Text = ds.Tables0.Rowsi find =if (find =false )Response.Write( con.Close();"<script>window.alert(

15、'没有相关记录 !')</script>" );protected void Button2_Click( object sender, EventArgse)Response.Redirect("/Default.aspx" );System;System.Collections;System.Configuration;System.Data;System.Linq;System.Web;class 人员信息 Page using using using using using using using using using usi

16、ng using using using namespaceWebApplication1 public partialprotectedvoidPage_Load( object sender, EventArgs e)protectedvoidButton1_Click( objectsender, EventArgse)Response.Redirect("/Default.aspx");bool find = falseSqlConnection con = new SqlConnection ( "server=localhost;Integrated

17、Security=SSPI;database= 人事管理系统 ");con.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.

18、Rowsij.ToString().Trim(); ifTextBox2.Text=ds.Tables0 .RowsiTextBox3.Text=ds.Tables0 .RowsiTextBox4.Text=ds.Tables0 .RowsiTextBox5.Text = ds.Tables0.Rowsi"应发工资 " .ToString();" 岗位津贴 " .ToString(); "奖励" .ToString();" 保险 " .ToString();find= true ;if (find = false

19、)Response.Write( "<script>window.alert(' 没有相关记录 !')</script>" ); con.Close();using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;usingusing using usingusingusing usingnamespaceWebApplication1public partial protectedprotectedprotectedclass 人员修改 Pagevoid Page_Load( object sender, EventArgs e)void TextBox5_TextChanged( object sender, EventArgs e)void Button2_C