查看记录ＳＱＬ.txt

说明: 比较简单的人事档案管理程序,包含了人事档案的大部分功能,做人事档案的兄弟可以看看. 本程序类型：delphi7 + Access2000 桌面数据库 初始用户名/密码:admin

培训记录
select  Cultivate_EmployeeID as 职工编号,Cultivate_Speciality as 培训专业,Cultivate_Mode as 培训方式,Cultivate_StartDate as 开始日期,Cultivate_StopDate as 结束日期,Cultivate_Corp as 培训单位,Cultivate_Outlay as 培训经费,Cultivate_Result as 培训结果  From Cultivate

奖惩记录
select AP_EmployeeID as 职工编号, AP_Type as 奖惩类型,AP_FirstDept as 一级部门,AP_SecondDept as 二级部门,AP_StartDate as 奖惩日期, AP_StartExplain as 奖惩原因,AP_StopDate as 解除日期,AP_StopExplain as 解除原因,

家庭记录
select Family_EmployeeID as 职工编号, Family_Name as 成员姓名,Family_Birthday as 出生日期,Family_Work as 工作单位,Family_Role as 担任职务,Family_polity as 政治面貌,Family_Connection as 关系,Family_Tel as 电话 From Family

请假记录
select Leave_EmployeeID as 职工编号,Leave_Type as 请假类型,Leave_Explain as 请假原因,Leave_StartDate as 开始日期,Leave_StopDate as 结束日期 From Leave

调动记录
select MT_EmployeeID as 职工编号,MT_OleDept as 调动前部门 ,MT_NewDept as 调动后部门,MT_Explain as 调动理由,MT_Date as 调动日期,MT_OlePay as 调动前薪资,MT_NewPay as 调动后薪资 From MoveTo

工作单位记录
select WS_EmployeeID as  职工编号,WS_StartDate as 开始日期,WS_StopDate as 结束日期,WS_Corp as 工作单位,WS_Dept as 工作部门,WS_Role as 担任职务　From WorkStoy