人事管理系统数据库源代码.docx
《人事管理系统数据库源代码.docx》由会员分享,可在线阅读,更多相关《人事管理系统数据库源代码.docx(13页珍藏版)》请在冰点文库上搜索。
人事管理系统数据库源代码
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;
namespaceWebApplication1
{
publicpartialclassWebForm1:
System.Web.UI.Page
{
protectedvoidPage_Load(objectsender,EventArgse)
{
}
protectedvoidButton1_Click(objectsender,EventArgse)
{
Response.Redirect("~/登录.aspx");
}
protectedvoidButton2_Click(objectsender,EventArgse)
{
Response.Redirect("~/人员信息查询.aspx");
}
protectedvoidButton3_Click(objectsender,EventArgse)
{
Response.Redirect("~/人员修改.aspx");
}
protectedvoidButton4_Click(objectsender,EventArgse)
{
Response.Redirect("~/部门信息.aspx");
}
protectedvoidButton5_Click(objectsender,EventArgse)
{
Response.Redirect("~/工资信息.aspx");
}
}
}
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;
usingSystem.Data.SqlClient;
namespaceWebApplication1
{
publicpartialclass部门信息:
System.Web.UI.Page
{
protectedvoidPage_Load(objectsender,EventArgse)
{
}
protectedvoidButton1_Click(objectsender,EventArgse)
{
boolfind=false;
SqlConnectioncon=newSqlConnection("server=localhost;IntegratedSecurity=SSPI;database=人事管理系统");
con.Open();
stringcmdstr="select*from部门表";
SqlDataAdapterda=newSqlDataAdapter(cmdstr,con);
DataSetds=newDataSet();
da.Fill(ds);
for(inti=0;i{
for(intj=0;j{
Stringdata=(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();
}
}
protectedvoidButton2_Click(objectsender,EventArgse)
{
Response.Redirect("~/Default.aspx");
}
}
}
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;
usingSystem.Data.SqlClient;
usingSystem.Data.SqlTypes;
namespaceWebApplication1
{
publicpartialclass_Default:
System.Web.UI.Page
{
protectedvoidPage_Load(objectsender,EventArgse)
{
}
protectedvoidTextBox1_TextChanged(objectsender,EventArgse)
{
}
protectedvoidButton1_Click(objectsender,EventArgse)
{
SqlConnectioncon=newSqlConnection("server=localhost;IntegratedSecurity=SSPI;database=人事管理系统");
stringstrCount;
strCount="select*from人事表";con.Open();
SqlCommand=newSqlCommand(strCount,con);
SqlDataReaderdr=.ExecuteReader();
stringstrUsername="",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("alert('登录成功!
');");
return;
}
}
protectedvoidButton2_Click(objectsender,EventArgse)
{
Response.Redirect("~/Default.aspx");
}
}
}
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;
usingSystem.Data.SqlClient;
namespaceWebApplication1
{
publicpartialclass工资信息:
System.Web.UI.Page
{
protectedvoidPage_Load(objectsender,EventArgse)
{
}
protectedvoidTextBox2_TextChanged(objectsender,EventArgse)
{
}
protectedvoidTextBox5_TextChanged(objectsender,EventArgse)
{
}
protectedvoidButton1_Click(objectsender,EventArgse)
{
boolfind=false;
SqlConnectioncon=newSqlConnection("server=localhost;IntegratedSecurity=SSPI;database=人事管理系统");
con.Open();
stringcmdstr="select*from工资表";
SqlDataAdapterda=newSqlDataAdapter(cmdstr,con);
DataSetds=newDataSet();
da.Fill(ds);
for(inti=0;i{
for(intj=0;j{
Stringdata=(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();
}
}
protectedvoidButton2_Click(objectsender,EventArgse)
{
Response.Redirect("~/Default.aspx");
}
}
}
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;
usingSystem.Data.SqlClient;
namespaceWebApplication1
{
publicpartialclass人员信息:
System.Web.UI.Page
{
protectedvoidPage_Load(objectsender,EventArgse)
{
}
protectedvoidButton1_Click(objectsender,EventArgse)
{
Response.Redirect("~/Default.aspx");
}
protectedvoidButton2_Click(objectsender,EventArgse)
{
boolfind=false;
SqlConnectioncon=newSqlConnection("server=localhost;IntegratedSecurity=SSPI;database=人事管理系统");
con.Open();
stringcmdstr="select*from工资表";
SqlDataAdapterda=newSqlDataAdapter(cmdstr,con);
DataSetds=newDataSet();
da.Fill(ds);
for(inti=0;i{
for(intj=0;j{
Stringdata=(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();
}
}
}
}
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;
usingSystem.Data.SqlClient;
namespaceWebApplication1
{
publicpartialclass人员修改:
System.Web.UI.Page
{
protectedvoidPage_Load(objectsender,EventArgse)
{
}
protectedvoidTextBox5_TextChanged(objectsender,EventArgse)
{
}
protectedvoidButton2_Click(objectsender,EventArgse)
{
SqlConnectioncon=newSqlConnection("server=localhost;IntegratedSecurity=SSPI;database=人事管理系统");
con.Open();
stringinsert="insertinto人事表(员工号,姓名,性别,职称,学历)values("+""+TextBox1.Text.Trim()+""+","+""+TextBox2.Text.Trim()+""+","+TextBox3.Text.Trim()+","+""+TextBox4.Text.Trim()+""+","+""+TextBox5.Text.Trim()+""+")";
Response.Write(insert);
SqlCommandcmd1=newSqlCommand(insert,con);
con.Close();
}
protectedvoidButton1_Click(objectsender,EventArgse)
{
Response.Redirect("~/Default.aspx");
}
protectedvoidGridView1_SelectedIndexChanged(objectsender,EventArgse)
{
}
}
}