人力资源管理人力资源管理系统讲义

{人力资源管理}人力资源管理系统讲义1.21.管理人员角色和目标的改变HR

1：N

1

23SQLServerhrmbook。后面几小节我们CREATETABLE[dbo].[[内部编号[类别号[单位编号[单位地址[帐号[开户全称CREATETABLE[dbo].[[内部编号[职员编号[出生日期[年龄[籍贯[民族[文化程度[婚姻状况[电子邮件地址CREATETABLE[dbo].[[用户编号[部门[姓名[性别[密码[临时补[水电费[住房公积金[工伤保险[级数[工资上限[备注[浮动工资[合同补[粮副补[房补[临时补[职务工资[工龄工资[考核工资[奖金[水电费[请假扣除[考勤扣除[罚款[养老保险[失业保险[生育保险[工伤保险CREATETABLE[dbo].[[序号[奖励金额CREATETABLE[dbo].[[序号[惩罚金额ALTERTABLE[dbo].[月工资统计表ALTERTABLE[dbo].[工资发放历史表ALTERTABLE[dbo].[职☺奖励表ALTERTABLE[dbo].[职☺惩罚表dropprocedure[dbo].[sf_形资表dropprocedure[dbo].[sf_计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启动MicrosoftVisual2003,在主菜单中选择【文件】|【新建】|列表框中选择【Window6.3StatusBar622对象（控件）取值（说明53取值（说明机构设置及编GetInstanceState,此函数主要作用是用来实现单4.4这样可以使对数据库的访问更加简单。选择【文件】|【添加新项】命令添加一个名为“”的类文件。IDisposable4.5Visual744取值（说明frmDepManage选择【文件】｜'TreeNodeDatafrmDepManageInitTree'InitTreeTreeViewTreeNode=dr("TreeNodeTagTreeViewfrmDepManageLoadbtnModifyclickbtnAddBssClickbtnAddEqlClickbtnAddSubClickSQLtreenodeabsIndextreenodeItemLeveltreenodeParentIndexTreeViewSQLstrSQL+="deletefromstrSQL="updateset=b.拼音编码,"strSQL+="fromasa,zzjgtempasb"btnDelClick“frmDepInfo855取值（说明DataGriddgdDepInfoDataSet11SqlDataAdapter1996.7frmPeopleManage106取值（说明ComboBoxItemsSqlDataAdapter1TextBoxComboBoxTextBoxComboBoxTextBoxDataBindingsTextTextBoxComboBoxDataGridfrmPeopleManageLoadcbbDepCodeDimstrSQLAsString="selectfrom"IfiCurrentLine=-ToolBarButtonClickSqlDataAdapter1If("你确认要删除此条记录吗SqlDataAdapter1cbbDepCodeTextChangedDimstrSQLAsString="selectfrom"115frmPeopleQuery1277取值（说明frmPeopleQueryDimstrSQLAsString="selectstrSQL+="fromasa,asb"frmPeopleQueryLoadDataGridTableStylebtnSearchClickfrmSalaryManage1488取值（说明TextBoxLoadDataLoadDataGridStyleDataGridDimstrSQL="selectstrSQL+="fromasa,asb"frmSalaryManageLoadbtnGetSalaryClickbtnCalSalaryClickIf("是否发放dgdSalaryInfoCurrentCellChangedIfiCurrentLine=-BindingContext(DataSet11,"月工资统计表

119取值（说明SqlDataAdapterhrmbookfrmTaxInfoLoadDataSet11.Tables("个人所得税表DataSet11.Tables("个人所得税表dgdTaxInfo=DataSet11.Tables("个人所得税表DataSet11.Tables("个人所得税表ToolBar1ButtonClickDataSet11If("你确认要删除此条记录吗SqlDataAdapter1DataSet11.Tables("17176.1110取值（说明4.1219取值（说明frmPrizeSetDataGridDataGridDataSet11.Tables("职☺奖励表DataSet11.Tables("职☺奖励表=DataSet11.Tables("职☺