人力資源管理人力資源管理系統(tǒng)講義

{人力資源管理}人力資源管理系統(tǒng)講義1.21.管理人員角色和目標(biāo)的改變HR

1：N

1

23SQLServerhrmbook。后面幾小節(jié)我們CREATETABLE[dbo].[[內(nèi)部編號(hào)[類別號(hào)[單位編號(hào)[單位地址[帳號(hào)[開(kāi)戶全稱CREATETABLE[dbo].[[內(nèi)部編號(hào)[職員編號(hào)[出生日期[年齡[籍貫[民族[文化程度[婚姻狀況[電子郵件地址CREATETABLE[dbo].[[用戶編號(hào)[部門[姓名[性別[密碼[臨時(shí)補(bǔ)[水電費(fèi)[住房公積金[工傷保險(xiǎn)[級(jí)數(shù)[工資上限[備注[浮動(dòng)工資[合同補(bǔ)[糧副補(bǔ)[房補(bǔ)[臨時(shí)補(bǔ)[職務(wù)工資[工齡工資[考核工資[獎(jiǎng)金[水電費(fèi)[請(qǐng)假扣除[考勤扣除[罰款[養(yǎng)老保險(xiǎn)[失業(yè)保險(xiǎn)[生育保險(xiǎn)[工傷保險(xiǎn)CREATETABLE[dbo].[[序號(hào)[獎(jiǎng)勵(lì)金額CREATETABLE[dbo].[[序號(hào)[懲罰金額ALTERTABLE[dbo].[月工資統(tǒng)計(jì)表ALTERTABLE[dbo].[工資發(fā)放歷史表ALTERTABLE[dbo].[職?獎(jiǎng)勵(lì)表ALTERTABLE[dbo].[職?懲罰表dropprocedure[dbo].[sf_形資表dropprocedure[dbo].[sf_計(jì)dropprocedure[dbo].[sf_放dropprocedure[dbo].[sf_updateset=0whereupdateset=0whereisnullupdateset=0whereisnullupdateset=0whereisnullupdateset=0whereisnullupdateset=0whereisnullupdateset=0whereisnullupdateset=0whereisnullupdateset=0whereisnullupdateset=0whereisnullupdateset=0whereisnullselectxmonth=fromupdatesetupdateset=0whereisnullupdatesetupdateset=0whereisnullexecsf_updatesetupdatesetupdatesetfromwhere<=xgzhjorderbyselectxsl=casewhen>1thenwhere=xgzsxselectxgrsds=xgrsds+(xgzhj-deletefromselectxfromashwhereh.notin(selectfromexecsf_where=xselect*fromwhere=x以選擇【薪資福利管理】|545啟動(dòng)MicrosoftVisual2003,在主菜單中選擇【文件】|【新建】|列表框中選擇【W(wǎng)indow6.3StatusBar622對(duì)象（控件）取值（說(shuō)明53取值（說(shuō)明機(jī)構(gòu)設(shè)置及編GetInstanceState,此函數(shù)主要作用是用來(lái)實(shí)現(xiàn)單4.4這樣可以使對(duì)數(shù)據(jù)庫(kù)的訪問(wèn)更加簡(jiǎn)單。選擇【文件】|【添加新項(xiàng)】命令添加一個(gè)名為“”的類文件。IDisposable4.5Visual744取值（說(shuō)明frmDepManage選擇【文件】｜'TreeNodeDatafrmDepManageInitTree'InitTreeTreeViewTreeNode=dr("TreeNodeTagTreeViewfrmDepManageLoadbtnModifyclickbtnAddBssClickbtnAddEqlClickbtnAddSubClickSQLtreenodeabsIndextreenodeItemLeveltreenodeParentIndexTreeViewSQLstrSQL+="deletefromstrSQL="updateset=b.拼音編碼,"strSQL+="fromasa,zzjgtempasb"btnDelClick“frmDepInfo855取值（說(shuō)明DataGriddgdDepInfoDataSet11SqlDataAdapter1996.7frmPeopleManage106取值（說(shuō)明ComboBoxItemsSqlDataAdapter1TextBoxComboBoxTextBoxComboBoxTextBoxDataBindingsTextTextBoxComboBoxDataGridfrmPeopleManageLoadcbbDepCodeDimstrSQLAsString="selectfrom"IfiCurrentLine=-ToolBarButtonClickSqlDataAdapter1If("你確認(rèn)要?jiǎng)h除此條記錄嗎SqlDataAdapter1cbbDepCodeTextChangedDimstrSQLAsString="selectfrom"115frmPeopleQuery1277取值（說(shuō)明frmPeopleQueryDimstrSQLAsString="selectstrSQL+="fromasa,asb"frmPeopleQueryLoadDataGridTableStylebtnSearchClickfrmSalaryManage1488取值（說(shuō)明TextBoxLoadDataLoadDataGridStyleDataGridDimstrSQL="selectstrSQL+="fromasa,asb"frmSalaryManageLoadbtnGetSalaryClickbtnCalSalaryClickIf("是否發(fā)放dgdSalaryInfoCurrentCellChangedIfiCurrentLine=-BindingContext(DataSet11,"月工資統(tǒng)計(jì)表

119取值（說(shuō)明SqlDataAdapterhrmbookfrmTaxInfoLoadDataSet11.Tables("個(gè)人所得稅表DataSet11.Tables("個(gè)人所得稅表dgdTaxInfo=DataSet11.Tables("個(gè)人所得稅表DataSet11.Tables("個(gè)人所得稅表ToolBar1ButtonClickDataSet11If("你確認(rèn)要?jiǎng)h除此條記錄嗎SqlDataAdapter1DataSet11.Tables("17176.1110取值（說(shuō)明4.1219取值（說(shuō)明frmPrizeSetDataGridDataGridDataSet11.Tables("職?獎(jiǎng)勵(lì)表DataSet11.Tables("職?獎(jiǎng)勵(lì)表=DataSet11.Tables("職?