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

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\");

}

实用标准

}

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(\"\");

}

}

文案大全

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++)

\"].ToString();

\"].ToString();

文案大全

{

String data = (ds.Tables[0].Rows[i][j].ToString()).Trim();

if (data == TextBox1.Text.Trim())

{

TextBox2.Text = ds.Tables[0].Rows[i][\"应发工资 TextBox3.Text = ds.Tables[0].Rows[i][\"岗位津贴 TextBox4.Text = ds.Tables[0].Rows[i][\"奖励\"].ToString();

TextBox5.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\");

}

}

}

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文案大全

{

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();

实用标准

TextBox4.Text=ds.Tables[0] .Rows[i][\"奖励\"].ToString();

TextBox5.Text = ds.Tables[0].Rows[i][\"保险\"].ToString();

find=true;

}

文案大全

}

}

if (find == false)

{

Response.Write(\"\");

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)

{

}

}

}

文案大全