)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO
SET ANSI_PADDING OFF
⑧实践经历表(practicedata)：
USE [humanmanage]
GO
/****** 对象: Table [dbo].[practicedata] 脚本日期: 03/07/2012 19:50:18 ******/
SET ANSI_NULLS ON GO
SET QUOTED_IDENTIFIER ON GO
SET ANSI_PADDING ON GO
CREATE TABLE [dbo].[practicedata]( (
[practiceid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO
SET ANSI_PADDING OFF
[practiceid] [int] IDENTITY(1,1) NOT NULL,
[name1] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[practicetime] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [practiceunit] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [practicecontent] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_practicedata_1] PRIMARY KEY CLUSTERED
⑨工作经历表(workdata)：ID,状态名称
USE [humanmanage]
GO
/****** 对象: Table [dbo].[workdata] 脚本日期: 03/07/2012 19:51:01 ******/
SET ANSI_NULLS ON GO
SET QUOTED_IDENTIFIER ON GO
SET ANSI_PADDING ON GO
CREATE TABLE [dbo].[workdata](
[workid] [int] IDENTITY(1,1) NOT NULL,
[name1] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
1
(
[worktime] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [workunit] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [station] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [situation] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL, [reterence] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [rphone] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
CONSTRAINT [PK_workdata_1] PRIMARY KEY CLUSTERED
[workid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO
SET ANSI_PADDING OFF
⑩社保缴纳表(insuredata)：ID,打卡时间,状态ID,职工ID
USE [humanmanage]
GO
/****** 对象: Table [dbo].[insuredata] 脚本日期: 03/07/2012 19:51:49 ******/
SET ANSI_NULLS ON GO
SET QUOTED_IDENTIFIER ON GO
SET ANSI_PADDING ON GO
CREATE TABLE [dbo].[insuredata]( (
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO
SET ANSI_PADDING OFF
1
[id] [int] IDENTITY(1,1) NOT NULL,
[name1] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [department] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [nowposition] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [paytime] [datetime] NULL, [paybase] [money] NULL, [personpay] [money] NULL, [companypay] [money] NULL,
CONSTRAINT [PK_insuredata_1] PRIMARY KEY CLUSTERED
1
5重庆巨能集团人事管理系统软件结构及程序模块设计
5.1软件结构
5.1.1 顶级结构
图5.1顶级结构 Fig451 Top-level structure
5.1.2第二层界面结构
图5.2第二层界面结构
Fig5.2 The second layer of the interface structure
5.2程序模块描述
5.2.1登录模块
1
①流程图：
图5.3登录模块 Fig5.3 Login module
②界面设计如下
图5.4登录界面 Fig5.4 Login screen
5.4.2员工基本资料模块
①流程图
1