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

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<ds.Tables[0].Rows.Count;i++)
{
for(int j=0;j<ds.Tables[0].Columns.Count;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("<script>window.alert('没有有关记录!')</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;
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;
using System.Data.SqlTypes;
namespace WebApplication1
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(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=人事管理系统");

string strCount;
strCount = "select * from 人事表"; con.Open();
SqlCommand com = new SqlCommand(strCount, con);
SqlDataReader dr = com.ExecuteReader();
string strUsername = "", strPassword = "";

while (dr.Read())
{
if (TextBox1.Text == dr["编号"].ToString()||TextBox2.Text == dr["顾客密码"].ToString())
{
strUsername = dr["编号"].ToString();
strPassword = dr["顾客密码"].ToString();

break;
}
}
dr.Close();
con.Close();
if (strUsername == "")
{
Response.Write("<script language=javascript>alert('登录成功！');</script>");
return;
}

}

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;
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 TextBox2_TextChanged(object sender, EventArgs e)
{

}

protected void TextBox5_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=人事管理系统");
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.Tables[0].Rows.Count; i++)
{
for (int j = 0; j < ds.Tables[0].Columns.Count; 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();
TextBox4.Text = ds.Tables[0].Rows[i]["奖励"].ToString();
TextBox5.Text = ds.Tables[0].Rows[i]["保险"].ToString();

find = true;
}

}
}
if (find == false)
{
Response.Write("<script>window.alert('没有有关记录!')</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;
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)
{
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=人事管理系统");
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.Tables[0].Rows.Count;i++)
{
for(int j=0;j<ds.Tables[0].Columns.Count;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();
TextBox4.Text=ds.Tables[0] .Rows[i]["奖励"].ToString();
TextBox5.Text = ds.Tables[0].Rows[i]["保险"].ToString();

find=true;
}

}
}
if (find == false)
{
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;
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 TextBox5_TextChanged(object sender, EventArgs e)
{

}

protected void Button2_Click(object sender, EventArgs e)
{
SqlConnection con=new SqlConnection("server=localhost;Integrated Security=SSPI;database=人事管理系统");
con.Open();
string insert="insert into 人事表(员工号，姓名，性别，职称，学历) values("+""+ TextBox1.Text.Trim() +""+","+"" + TextBox2.Text.Trim() +""+","+ TextBox3.Text.Trim() + "," +""+ TextBox4.Text.Trim() +""+","+"" +TextBox5.Text.Trim() + ""+")";
Response.Write(insert);
SqlCommand cmd1=new SqlCommand(insert,con);

con.Close();
}

protected void Button1_Click(object sender, EventArgs e)
{
Response.Redirect("~/Default.aspx");
}

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{

}
}
}