人事管理系统数据库源代码.docx
- 文档编号:29284760
- 上传时间:2023-07-21
- 格式:DOCX
- 页数:13
- 大小:15.92KB
人事管理系统数据库源代码.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(" ');"); 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) { } } }
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 人事管理系统 数据库 源代码
![提示](https://static.bdocx.com/images/bang_tan.gif)