集团工资管理系统数据库课程设计

第一章绪 数据库管理系 企业工资管理系 开发工 第二章员工工资管理系统设计分 应用需求与分 系统模块划 系统数据库设 第三章：企业工资管理系统应用程序设 系统 系统的数据流 系统的流程 系统模块的具体划 跳转界面设 “选择登陆用户模块”详细设 管理员登 “登录模块”详细设 主窗体模块设 员工注册界面及功 删除员工信息界面及功 修改及查询员工工资界面及功 工资设定界面及功 职位管理界面及功 其他功 员工登陆模 第四章：运行与测 系统运 系统测 第五章：实验心 第一章技术等细节。SQL语言是关系型数据库的标准化语言，已得到了广泛的应用。SQLSERVER数据库服务器，前台开发语言可自选。可设visualstdio20010作为前台设计工具，c#作为软件编程语言，sqlserver2008作为后台数据库开发工具。本第二章员工工资管理系统设计分析·5-2处罚金。5-25-35-35-45-4E-R数据流图（DFD，dataflowdiagram）是描述数据处理过程的有力工具。数3-登陆登陆3-3-1系统函数：usingSystem.Data.SqlClient;namespace企业工资管理系统publicpartialclassloading:publicprivatevoidtimer1_Tick_1(objectsender,EventArgsif(this.Opacity>this.Opacity=this.Opacity-elseif(this.Opacity>0.01){this.Opacity=this.Opacity-0.04;}this.timer1.Enabled=false;Form10login=newForm10();“选择登陆用户模块”privatevoidbutton1_Click(objectsender,EventArgs f=newForm16();privatevoidbutton2_Click(objectsender,EventArgsForm11f=newForm11();privatevoidbutton3_Click(objectsender,EventArgsApplication.Exit“登录模块”3-4-13-4-2核心代码

3-4-3privatevoidbutton1_Click(objectsender,EventArgsstringsqlconstr"DataSource=.;InitialCatalog=企业工资管理系统;IntegratedSecurity=True";SqlConnectionsqlc=newSqlConnection(sqlconstr);textBox1.Text="";textBox2.Text="";stringsqlcomstring="select*from管理员信息表where+this.textBox1.Text+"'andpassword='"+this.textBox2.Text+"'";SqlCommandsqlcom=newSqlCommand(sqlcomstring,sqlc);SqlDataReadersqlread=sqlcom.ExecuteReader();if

Form3gljm=newForm3();textBox1.Text="";textBox2.Text="";MessageBox.Show("catch(SqlExceptionMessageBox.Show(ex.Message,"privatevoidbutton2_Click(objectsender,EventArgs3-5-1privatevoid退出ToolStripMenuItem1_Click(objectsender,EventArgsprivatevoid关于ToolStripMenuItem_Click(objectsender,EventArgsForm4f=newForm4();privatevoid员工注册ToolStripMenuItem_Click(objectsender,EventArgsForm5f=newForm5();privatevoid删¦除员工信息ToolStripMenuItem_Click(objectsender,EventArgsForm6f=newForm6();privatevoid修改员工工资ToolStripMenuItem_Click(objectsender,EventArgsForm8f=newForm8();privatevoid现有工资ToolStripMenuItem_Click(objectsender,EventArgsForm7f=newForm7();privatevoid职位管理ToolStripMenuItem_Click(objectsender,EventArgsForm9f=newForm9();privatevoid返回登录ToolStripMenuItem_Click(objectsender,EventArgsForm10l=newForm10();privatevoid帮助ToolStripMenuItem_Click(objectsender,EventArgsForm15f=new3.4.33-6privatevoidbutton1_Click_1(objectsender,EventArgsSqlConnectionsqlconn=newSqlConnection("DataSource=.;Initial企业工资管理系统;Integratedif(textBox1.Text.Trim().Equals("")||

SqlDataAdaptersda=newSqlDataAdapter("select*from员 whereygno='"+textBox1.Text.Trim()+"'",sqlconn);DataTabledt=newDataTable();if(dt.Rows.Count!=员工信息表"

SqlDataAdaptersda1=newSqlDataAdapter("select*DataTabledt1=newDataTable();DataRowdr=dt1.NewRow();dr["ygno"]=textBox1.Text.Trim();dr["ygname"]=textBox2.Text.Trim();dr["ygduty"]=textBox3.Text.Trim();dr["ygtel"]=textBox4.Text.Trim();SqlCommandBuilderscb=newSqlCommandBuilder(sda1);sda1.InsertCommand=scb.GetInsertCommand();catch(SqlExceptionMessageBox.Show(ex.Message,"privatevoidbutton2_Click_1(objectsender,EventArgstextBox1.Focusprivatevoidbutton3_Click(objectsender,EventArgsprivatevoidbutton4_Click(objectsender,EventArgsSqlConnectionsqlconnnewSqlConnection("DataSource=.;InitialCatalog=企业工资管理系统;IntegratedSecurity=True");SqlDataAdaptersdanewSqlDataAdapter("select*from",

DataTabledt=newDataTable();dataGridView1.DataSource=dt;3-7privatevoidbutton1_Click_1(objectsender,EventArgsSqlConnectionsqlconnnewSqlConnection("DataSource=.;InitialCatalog=企业工资管理系统;IntegratedSecurity=True");ifSqlDataAdaptersdanewSqlDataAdapter("select*fromwhereygno='"+textBox1.Text.Trim()+"'",sqlconn);DataTabledt=newDataTable();if(dt.Rows.Count==MessageBoxButtonsmbox=MessageBoxButtons.OKCancel;DialogResultresult;resultMessageBox.Show("""删除记录",MessageBoxIcon.Question,MessageBoxDefaultButton.Button1);if(result==DialogResult.OK)SqlCommandBuilderscb=newSqlCommandBuilder(sda);sda.DeleteCommand=scb.GetDeleteCommand();MessageBox.Show("删除成功"privatevoidbutton2_Click_1(objectsender,EventArgs{textBox1.Text=""; textBox1.Focus();}privatevoidbutton3_Click(objectsender,EventArgs{privatevoidbutton4_Click(objectsender,EventArgsSqlConnectionsqlconnnewSqlConnection("DataSource=.;InitialCatalog=企业工资管理系统;IntegratedSecurity=True");SqlDataAdaptersdanewSqlDataAdapter("select*from",

DataTabledt=newDataTable();dataGridView1.DataSource=dt;3-8privateBooleanSqlConnectionsqlconnnewSqlConnection("DataSource=.;InitialCatalog=企业工资管理系统;IntegratedSecurity=True");SqlDataAdaptersdanewSqlDataAdapter("select*fromwhereygno='"+textBox1.Text.Trim()+"'",sqlconn);DataTabledt=newDataTable();if(dt.Rows.Count==returnfalse;{button1.Enabled=true;returntrue;privatevoidbutton1_Click_1(objectsender,EventArgsSqlConnectionsqlconn=newSqlConnection("DataCatalog=企业工资管理系统;IntegratedSecurity=True");if(!ishaved())SqlDataAdaptersdanewSqlDataAdapter("select*fromwhereygno='"+textBox1.Text.Trim()+"'",sqlconn);DataTabledt=newDataTable();dt.Rows[0]["ygname"]=textBox2.Text.Trim();dt.Rows[0]["ygduty"]=textBox3.Text.Trim();dt.Rows[0]["ygtel"]=textBox4.Text.Trim();dt.Rows[0]["yuexin"]=textBox5.Text.Trim();dt.Rows[0]["jiangjin"]=textBox6.Text.Trim();dt.Rows[0]["chufa"]=textBox7.Text.Trim();SqlCommandBuilderscb=newSqlCommandBuilder(sda);sda.UpdateCommand=scb.GetUpdateCommand();privatevoidbutton3_Click_1(objectsender,EventArgsprivatevoidbutton4_Click_1(objectsender,EventArgsSqlConnectionsqlconnnewSqlConnection("DataSource=.;InitialCatalog=企业工资管理系统;IntegratedSecurity=True");SqlDataAdaptersdanewSqlDataAdapter("select*fromwhereygno='"+textBox1.Text.Trim()+"'",sqlconn);DataTabledt=newDataTable();if(dt.Rows.Count== button1.Enabled=textBox2.Text=dt.Rows[0]["ygname"].ToString();textBox3.Text=dt.Rows[0]["ygduty"].ToString();textBox4.Text=dt.Rows[0]["ygtel"].ToString();textBox5.Text=dt.Rows[0]["yuexin"].ToString();textBox6.Text=dt.Rows[0]["jiangjin"].ToString();textBox7.Text=dt.Rows[0]["chufa"].ToString();privatevoidbutton2_Click(objectsender,EventArgs textBox1.Text="";privatevoidbutton5_Click(objectsender,EventArgsSqlConnectionsqlconnnewSqlConnection("DataSource=.;InitialCatalog=企业工资管理系统;IntegratedSecurity=True");SqlDataAdaptersdanewSqlDataAdapter("select*from",DataTabledt=newdataGridView1.DataSource=dt;3-9privatevoidbutton2_Click_1(objectsender,EventArgsififSqlConnectionsqlconnnewSqlConnection("DataSource=.;InitialCatalog=企业工资管理系统;IntegratedSecurity=True");SqlDataAdaptersdanewSqlDataAdapter("select*fromwhereygduty='"+comboBox1.Text.Trim()+"'",sqlconn);DataTabledt=newDataTable();dt.Rows[0]["jbgz"]=textBox1.Text.Trim();SqlCommandBuilderscb=newSqlCommandBuilder(sda);sda.UpdateCommand=scb.GetUpdateCommand();SqlConnectionsqlconn1newSqlConnection("DataSource=.;InitialCatalog=企业工资管理系统;IntegratedSecurity=True");SqlDataAdaptersda1newSqlDataAdapter("select*from表,

DataTabledt1=newDataTable();dataGridView1.DataSource=dt1;privatevoidbutton3_Click_1(objectsender,EventArgsprivatevoidbutton1_Click_1(objectsender,EventArgsSqlConnectionsqlconnnewSqlConnection("DataSource=.;InitialCatalog=企业工资管理系统;IntegratedSecurity=True");SqlDataAdaptersdanewSqlDataAdapter("select*from工资标准表

DataTabledt=newDataTable();dataGridView1.DataSource=dt;privatevoidbutton4_Click(objectsender,EventArgstextBox1.Text="";3-10privatevoidbutton2_Click_1(objectsender,EventArgsifSqlConnectionsqlconnnewSqlConnection("DataSource=.;InitialCatalog=企业工资管理系统;IntegratedSecurity=True");SqlDataAdaptersdanewSqlDataAdapter("selectygdutywhereygduty='textBox1.Text.Trim()"'"sqlconn);DataTabledt=newDataTable();if(dt.Rows.Count!=SqlDataAdaptersda1newSqlDataAdapter("selectygdutyfrom工资标准表whereygduty='"+textBox1.Text.Trim()+"'",sqlconn);DataTabledt1=newDataTable();DataRowdr=dt1.NewRow();dr["ygduty"]=textBox1.Text.Trim();SqlCommandBuilderscb=newSqlCommandBuilder(sda1);sda1.InsertCommand=scb.GetInsertCommand();SqlConnectionsqlconn2newSqlConnection("DataSource=.;InitialCatalog=企业工资管理系统;IntegratedSecurity=True");SqlDataAdaptersda2newSqlDataAdapter("selectygduty职¡ã位?工资标准表,DataTabledt2=newDataTable();dataGridView1.DataSource=dt2;privatevoidbutton3_Click_1(objectsender,EventArgsifSqlConnectionsqlconnnewSqlConnection("DataSource=.;InitialCatalog=企业工资管理系统;IntegratedSecurity=True");SqlDataAdaptersdanewSqlDataAdapter("selectygdutywhereygduty='textBox2.Text.Trim()"'"sqlconn);DataTabledt=newDataTable();SqlCommandBuilderscb=newSqlCommandBuilder(sda);sda.DeleteCommand=scb.GetDeleteCommand();SqlDataAdaptersda2new ygduty职位工资标准表,DataTabledt2=newDataTable();dataGridView1.DataSource=dt2;textBox2.Enabled=true;textBox2.Text="";textBox2.Enabled=false;privatevoidbutton4_Click(objectsender,EventArgsprivatevoidbutton1_Click_1(objectsender,EventArgsSqlConnectionsqlconnnewSqlConnection("DataSource=.;InitialCatalog=企业工资管理系统;In