集團工資管理系統(tǒng)數據庫課程設計

第一章緒 數據庫管理系 企業(yè)工資管理系 開發(fā)工 第二章員工工資管理系統(tǒng)設計分 應用需求與分 系統(tǒng)模塊劃 系統(tǒng)數據庫設 第三章：企業(yè)工資管理系統(tǒng)應用程序設 系統(tǒng) 系統(tǒng)的數據流 系統(tǒng)的流程 系統(tǒng)模塊的具體劃 跳轉界面設 “選擇登陸用戶模塊”詳細設 管理員登 “登錄模塊”詳細設 主窗體模塊設 員工注冊界面及功 刪除員工信息界面及功 修改及查詢員工工資界面及功 工資設定界面及功 職位管理界面及功 其他功 員工登陸模 第四章：運行與測 系統(tǒng)運 系統(tǒng)測 第五章：實驗心 第一章技術等細節(jié)。SQL語言是關系型數據庫的標準化語言，已得到了廣泛的應用。SQLSERVER數據庫服務器，前臺開發(fā)語言可自選?？稍Ovisualstdio20010作為前臺設計工具，c#作為軟件編程語言，sqlserver2008作為后臺數據庫開發(fā)工具。本第二章員工工資管理系統(tǒng)設計分析·5-2處罰金。5-25-35-35-45-4E-R數據流圖（DFD，dataflowdiagram）是描述數據處理過程的有力工具。數3-登陸登陸3-3-1系統(tǒng)函數：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關于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企業(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工資標準表

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工資標準表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職??位?工資標準表,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職位工資標準表,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