集團(tuán)工資管理系統(tǒng)數(shù)據(jù)庫課程設(shè)計(jì)

第一章緒 數(shù)據(jù)庫管理系 企業(yè)工資管理系 開發(fā)工 第二章員工工資管理系統(tǒng)設(shè)計(jì)分 應(yīng)用需求與分 系統(tǒng)模塊劃 系統(tǒng)數(shù)據(jù)庫設(shè) 第三章：企業(yè)工資管理系統(tǒng)應(yīng)用程序設(shè) 系統(tǒng) 系統(tǒng)的數(shù)據(jù)流 系統(tǒng)的流程 系統(tǒng)模塊的具體劃 跳轉(zhuǎn)界面設(shè) “選擇登陸用戶模塊”詳細(xì)設(shè) 管理員登 “登錄模塊”詳細(xì)設(shè) 主窗體模塊設(shè) 員工注冊界面及功 刪除員工信息界面及功 修改及查詢員工工資界面及功 工資設(shè)定界面及功 職位管理界面及功 其他功 員工登陸模 第四章：運(yùn)行與測 系統(tǒng)運(yùn) 系統(tǒng)測 第五章：實(shí)驗(yàn)心 第一章技術(shù)等細(xì)節(jié)。SQL語言是關(guān)系型數(shù)據(jù)庫的標(biāo)準(zhǔn)化語言，已得到了廣泛的應(yīng)用。SQLSERVER數(shù)據(jù)庫服務(wù)器，前臺開發(fā)語言可自選?？稍O(shè)visualstdio20010作為前臺設(shè)計(jì)工具，c#作為軟件編程語言，sqlserver2008作為后臺數(shù)據(jù)庫開發(fā)工具。本第二章員工工資管理系統(tǒng)設(shè)計(jì)分析·5-2處罰金。5-25-35-35-45-4E-R數(shù)據(jù)流圖（DFD，dataflowdiagram）是描述數(shù)據(jù)處理過程的有力工具。數(shù)3-登陸登陸3-3-1系統(tǒng)函數(shù)：usingSystem.Data.SqlClient;namespace企業(yè)工資管理系統(tǒng)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=企業(yè)工資管理系統(tǒng);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關(guān)于ToolStripMenuItem_Click(objectsender,EventArgsForm4f=newForm4();privatevoid員工注冊ToolStripMenuItem_Click(objectsender,EventArgsForm5f=newForm5();privatevoid刪|除員工信息ToolStripMenuItem_Click(objectsender,EventArgsForm6f=newForm6();privatevoid修改員工工資ToolStripMenuItem_Click(objectsender,EventArgsForm8f=newForm8();privatevoid現(xiàn)有工資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企業(yè)工資管理系統(tǒng);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=企業(yè)工資管理系統(tǒng);IntegratedSecurity=True");SqlDataAdaptersdanewSqlDataAdapter("select*from",

DataTabledt=newDataTable();dataGridView1.DataSource=dt;3-7privatevoidbutton1_Click_1(objectsender,EventArgsSqlConnectionsqlconnnewSqlConnection("DataSource=.;InitialCatalog=企業(yè)工資管理系統(tǒng);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=企業(yè)工資管理系統(tǒng);IntegratedSecurity=True");SqlDataAdaptersdanewSqlDataAdapter("select*from",

DataTabledt=newDataTable();dataGridView1.DataSource=dt;3-8privateBooleanSqlConnectionsqlconnnewSqlConnection("DataSource=.;InitialCatalog=企業(yè)工資管理系統(tǒng);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=企業(yè)工資管理系統(tǒng);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=企業(yè)工資管理系統(tǒng);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=企業(yè)工資管理系統(tǒng);IntegratedSecurity=True");SqlDataAdaptersdanewSqlDataAdapter("select*from",DataTabledt=newdataGridView1.DataSource=dt;3-9privatevoidbutton2_Click_1(objectsender,EventArgsififSqlConnectionsqlconnnewSqlConnection("DataSource=.;InitialCatalog=企業(yè)工資管理系統(tǒng);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=企業(yè)工資管理系統(tǒng);IntegratedSecurity=True");SqlDataAdaptersda1newSqlDataAdapter("select*from表,

DataTabledt1=newDataTable();dataGridView1.DataSource=dt1;privatevoidbutton3_Click_1(objectsender,EventArgsprivatevoidbutton1_Click_1(objectsender,EventArgsSqlConnectionsqlconnnewSqlConnection("DataSource=.;InitialCatalog=企業(yè)工資管理系統(tǒng);IntegratedSecurity=True");SqlDataAdaptersdanewSqlDataAdapter("select*from工資標(biāo)準(zhǔn)表

DataTabledt=newDataTable();dataGridView1.DataSource=dt;privatevoidbutton4_Click(objectsender,EventArgstextBox1.Text="";3-10privatevoidbutton2_Click_1(objectsender,EventArgsifSqlConnectionsqlconnnewSqlConnection("DataSource=.;InitialCatalog=企業(yè)工資管理系統(tǒng);IntegratedSecurity=True");SqlDataAdaptersdanewSqlDataAdapter("selectygdutywhereygduty='textBox1.Text.Trim()"'"sqlconn);DataTabledt=newDataTable();if(dt.Rows.Count!=SqlDataAdaptersda1newSqlDataAdapter("selectygdutyfrom工資標(biāo)準(zhǔn)表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=企業(yè)工資管理系統(tǒng);IntegratedSecurity=True");SqlDataAdaptersda2newSqlDataAdapter("selectygduty職??位?工資標(biāo)準(zhǔn)表,DataTabledt2=newDataTable();dataGridView1.DataSource=dt2;privatevoidbutton3_Click_1(objectsender,EventArgsifSqlConnectionsqlconnnewSqlConnection("DataSource=.;InitialCatalog=企業(yè)工資管理系統(tǒng);IntegratedSecurity=True");SqlDataAdaptersdanewSqlDataAdapter("selectygdutywhereygduty='textBox2.Text.Trim()"'"sqlconn);DataTabledt=newDataTable();SqlCommandBuilderscb=newSqlCommandBuilder(sda);sda.DeleteCommand=scb.GetDeleteCommand();SqlDataAdaptersda2new ygduty職位工資標(biāo)準(zhǔn)表,DataTabledt2=newDataTable();dataGridView1.DataSource=dt2;textBox2.Enabled=true;textBox2.Text="";textBox2.Enabled=false;privatevoidbutton4_Click(objectsender,EventArgsprivatevoidbutton1_Click_1(objectsender,EventArgsSqlConnectionsqlconnnewSqlConnection("DataSource=.;InitialCatalog=企業(yè)工資管理系統(tǒng);In