人事管理系统数据库源代码_第1页
人事管理系统数据库源代码_第2页
人事管理系统数据库源代码_第3页
免费预览已结束，剩余7页可下载查看

下载本文档

版权说明：本文档由用户提供并上传，收益归属内容提供方，若内容存在侵权，请进行举报或认领

文档简介

1、.usingSystem;usingSystem.Collections;usingSystem.Configuration;usingSystem.Data;usingSystem.Linq;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.HtmlControls;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Xml.Linq;namespaceWebApplica

2、tion1publicpartialclass WebForm1: System.Web.UI.Pageprotectedvoid Page_Load( objectsender,EventArgse)protectedvoid Button1_Click(objectsender,EventArgse)Response.Redirect("/ 登录 .aspx" );protectedvoid Button2_Click(objectsender,EventArgse)Response.Redirect("/ 人员信息查询 .aspx" );prote

3、ctedvoid Button3_Click(objectsender,EventArgse)Response.Redirect("/ 人员修改 .aspx" );protectedvoid Button4_Click(objectsender,EventArgse)Response.Redirect("/ 部门信息 .aspx" );word 专业资料.protectedvoid Button5_Click(objectsender,EventArgse)Response.Redirect("/ 工资信息 .aspx" );usin

4、gSystem;usingSystem.Collections;usingSystem.Configuration;usingSystem.Data;usingSystem.Linq;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.HtmlControls;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Xml.Linq;usingSystem.Data.SqlClie

5、nt;namespaceWebApplication1publicpartialclass 部门信息: System.Web.UI.Pageprotectedvoid Page_Load( objectsender,EventArgse)protectedvoid Button1_Click(objectsender,EventArgse)boolfind =false ;SqlConnectioncon= new SqlConnection("server=localhost;IntegratedSecurity=SSPI;database=人事管理系统 ");con.O

6、pen();stringcmdstr="select * from部门表 " ;SqlDataAdapterda= new SqlDataAdapter(cmdstr,con);DataSetds= new DataSet ();da.Fill(ds);word 专业资料.for (int i=0;i<ds.Tables0.Rows.Count;i+)for (int j=0;j<ds.Tables0.Columns.Count;j+)Stringdata=(ds.Tables0.Rowsij.ToString().Trim();if(data=TextBox1

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

8、sender,EventArgse)Response.Redirect("/Default.aspx");usingSystem;usingSystem.Collections;usingSystem.Configuration;usingSystem.Data;usingSystem.Linq;usingSystem.Web;word 专业资料.usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.HtmlControls;usingSystem.Web.UI.WebControls;usingSys

9、tem.Web.UI.WebControls.WebParts;usingSystem.Xml.Linq;usingSystem.Data.SqlClient;usingSystem.Data.SqlTypes;namespaceWebApplication1publicpartialclass _Default: System.Web.UI.Pageprotectedvoid Page_Load( objectsender,EventArgse)protectedvoid TextBox1_TextChanged(objectsender,EventArgse)protectedvoid B

10、utton1_Click(objectsender,EventArgse)SqlConnectioncon =new SqlConnection("server=localhost;IntegratedSecurity=SSPI;database=人事管理系统 ");stringstrCount;strCount ="select * from人事表 " ; con.Open();SqlCommand= new SqlCommand(strCount, con);SqlDataReaderdr = .ExecuteReader();stringstrUs

11、ername ="" , strPassword ="" ;while(dr.Read()if (TextBox1.Text = dr" 编号 ".ToString()|TextBox2.Text = dr" 用户密码".ToString()strUsername = dr" 编号 " .ToString();strPassword = dr" 用户密码 ".ToString();word 专业资料.break ;dr.Close();con.Close();if (strU

12、sername ="" )Response.Write("<script language=javascript>alert('登录成功！ ');</script>");return ;protectedvoid Button2_Click(objectsender,EventArgse)Response.Redirect("/Default.aspx");usingSystem;usingSystem.Collections;usingSystem.Configuration;usingSys

13、tem.Data;usingSystem.Linq;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.HtmlControls;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Xml.Linq;usingSystem.Data.SqlClient;namespaceWebApplication1word 专业资料.publicpartialclass 工资信息: Syst

14、em.Web.UI.Pageprotectedvoid Page_Load( objectsender,EventArgse)protectedvoid TextBox2_TextChanged(objectsender,EventArgse)protectedvoid TextBox5_TextChanged(objectsender,EventArgse)protectedvoid Button1_Click(objectsender,EventArgse)boolfind =false ;SqlConnectioncon =new SqlConnection("server=l

15、ocalhost;IntegratedSecurity=SSPI;database=人事管理系统 ");con.Open();stringcmdstr ="select * from工资表 "SqlDataAdapterda =newSqlDataAdapter(cmdstr, con);DataSetds =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+)S

16、tringdata = (ds.Tables0.Rowsij.ToString().Trim();if (data = TextBox1.Text.Trim()TextBox2.Text = ds.Tables0.Rowsi" 应发工资 ".ToString();TextBox3.Text = ds.Tables0.Rowsi" 岗位津贴 ".ToString();TextBox4.Text = ds.Tables0.Rowsi" 奖励 ".ToString();TextBox5.Text = ds.Tables0.Rowsi&quo

17、t; 保险 ".ToString();word 专业资料.find =true ;if (find =false )Response.Write("<script>window.alert('没有相关记录 !')</script>");con.Close();protectedvoid Button2_Click(objectsender,EventArgse)Response.Redirect("/Default.aspx");usingSystem;usingSystem.Collections;us

18、ingSystem.Configuration;usingSystem.Data;usingSystem.Linq;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.HtmlControls;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Xml.Linq;usingSystem.Data.SqlClient;namespaceWebApplication1publicp

19、artialclass 人员信息: System.Web.UI.Pageword 专业资料.protectedvoid Page_Load( objectsender,EventArgse)protectedvoid Button1_Click(objectsender,EventArgse)Response.Redirect("/Default.aspx");protectedvoid Button2_Click(objectsender,EventArgse)boolfind =false ;SqlConnectioncon =new SqlConnection(&qu

20、ot;server=localhost;IntegratedSecurity=SSPI;database=人事管理系统 ");con.Open();stringcmdstr="select * from工资表 " ;SqlDataAdapterda= new SqlDataAdapter(cmdstr,con);DataSetds= 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+)S

21、tringdata=(ds.Tables0.Rowsij.ToString().Trim();if(data=TextBox1.Text.Trim()TextBox2.Text=ds.Tables0 .Rowsi" 应发工资 " .ToString();TextBox3.Text=ds.Tables0 .Rowsi" 岗位津贴 ".ToString();TextBox4.Text=ds.Tables0 .Rowsi" 奖励 " .ToString();TextBox5.Text = ds.Tables0.Rowsi" 保险

22、" .ToString();find= true ;if (find =false )Response.Write("<script>window.alert('没有相关记录 !')</script>");word 专业资料.con.Close();usingSystem;usingSystem.Collections;usingSystem.Configuration;usingSystem.Data;usingSystem.Linq;usingSystem.Web;usingSystem.Web.Security;usi

23、ngSystem.Web.UI;usingSystem.Web.UI.HtmlControls;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Xml.Linq;usingSystem.Data.SqlClient;namespaceWebApplication1publicpartialclass 人员修改: System.Web.UI.Pageprotectedvoid Page_Load( objectsender,EventArgse)protectedvoid TextBox5_TextChanged(objectsender,EventArgse)protectedvoid Button2_Click(ob

人人文库> 全部分类> 应用文书 > 研究报告

温馨提示

  • 1. 本站所有资源如无特殊说明，都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
  • 2. 本站的文档不包含任何第三方提供的附件图纸等，如果需要附件，请联系上传者。文件的所有权益归上传用户所有。
  • 3. 本站RAR压缩包中若带图纸，网页内容里面会有图纸预览，若没有图纸预览就没有图纸。
  • 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
  • 5. 人人文库网仅提供信息存储空间，仅对用户上传内容的表现方式做保护处理，对用户上传分享的文档内容本身不做任何修改或编辑，并不能对任何下载内容负责。
  • 6. 下载文件中如有侵权或不适当内容，请与我们联系，我们立即纠正。
  • 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

最新文档

评论

0/150

提交评论