人事管理系统大数据库源代码
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
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;
namespace WebApplication1
{
public partial class WebForm1 : System.Web.UI.Page
{
protected 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("~/人员信息查询.aspx");
}
protected void Button3_Click(object sender, EventArgs e) {
Response.Redirect("~/人员修改.aspx");
}
protected void Button4_Click(object sender, EventArgs e) {
Response.Redirect("~/部门信息.aspx");
}
protected void Button5_Click(object sender, EventArgs e) {
Response.Redirect("~/工资信息.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 System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace WebApplication1
{
public partial class部门信息 : System.Web.UI.Page
{
protected 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=人事管理系统");
con.Open();
string cmdstr="select * from 部门表";
SqlDataAdapter da=new SqlDataAdapter(cmdstr,con);
DataSet ds=new DataSet();
da.Fill(ds);
for(int i=0;i { for(int j=0;j { String data=(ds.Tables[0].Rows[i][j].ToString()).Trim(); if(data==TextBox1.Text.Trim()) { TextBox2.Text=ds.Tables[0] .Rows[i]["部门代码"].ToString(); TextBox3.Text=ds.Tables[0] .Rows[i]["部门名称"].ToString(); find=true; } } } if (find == false) { Response.Write(""); con.Close(); } } protected void Button2_Click(object sender, EventArgs e) { Response.Redirect("~/Default.aspx");