if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BASE_DATA]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[BASE_DATA];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CHECK_INFO]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CHECK_INFO];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WAGE_INFO]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[WAGE_INFO];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[REWARD_PUN]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[REWARD_PUN];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PRO_TITLE]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[PRO_TITLE];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WORK_AGE]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[WORK_AGE];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[USER_TABLE]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[USER_TABLE];
CREATE TABLE [dbo].[BASE_DATA] (
[WORKER_ID] [nvarchar] (15) NOT NULL ,
[ARCHIVES_ID] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[WORKER_NAME] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[DEPARTMENT_NAME] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
[SEX] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[BIRTHDAY] [datetime] NULL,
[NATIVE_PLACE] [nvarchar] (25) COLLATE Chinese_PRC_CI_AS NULL ,
[SCHOOL_AGE] [nvarchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
[MAJOR] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
[GRADUATE_SCH] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[POLITIC_STATUS] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NULL ,
[WORK_TIME] [datetime] NULL,
[COME_TIME] [datetime] NULL,
[LINK_PHONE] [nvarchar] (14) COLLATE Chinese_PRC_CI_AS NULL ,
[ADDRESS] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[PHOTO] [image] NULL ,
[REMARK] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY];
CREATE TABLE [dbo].[CHECK_INFO] (
[WORKER_ID] [nvarchar] (15) not NULL ,
[WORKER_NAME] [nvarchar](8) COLLATE Chinese_PRC_CI_AS NULL ,
[MONTHS] [nvarchar](10) not NULL ,
[MONTH_DAYS] [int] NULL ,
[HOLIDAYS] [int] NULL ,
[REAL_WORK_DAYS] [int] NULL ,
[WORK_DAYS] [int] NULL ,
[BUSINESS_DAYS] [int] NULL ,
[ABSENT_DAYS] [int] NULL ,
[LEAVE_TIMES] [int] NULL ,
[LATE_TIMES] [int] NULL ,
[LEAVE_EARLY_TIMES] [int] NULL ,
[HOLIDAY_OVERTIME] [int] NULL ,
[OTHER_OVERTIME] [int] NULL ,
[REMARK] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY];
CREATE TABLE [dbo].[WAGE_INFO] (
[RECORD_ID] [bigint] IDENTITY (1, 1) NOT NULL ,
[WORKER_ID] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
[WORKER_NAME] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[BASE_WAGE] [float] NULL ,
[ALLOWANCE1] [float] NULL ,
[ALLOWANCE2] [float] NULL ,
[REWARD] [float] NULL ,
[OVERTIME_MONEY] [float] NULL ,
[DEDUCT_CHECK] [float] NULL ,
[AGED_MONEY] [float] NULL ,
[MEDICAL_MONEY] [float] NULL ,
[COMPO_MONEY] [float] NULL ,
[UNEMPLOY_MONEY] [float] NULL ,
[HOUSING_MONEY] [float] NULL ,
[INCOME_TAX] [float] NULL ,
[REAL_WAGE] [float] NULL ,
[GIVE_DATE] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY];
CREATE TABLE [dbo].[REWARD_PUN] (
[RECORD_ID] [bigint] IDENTITY (1, 1) NOT NULL ,
[WORKER_ID] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
[WORKER_NAME] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[RECORD_DATE] [datetime] NULL,
[RECORD_TYPE] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[RECORD_CONTENT] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[RECORD_REASON] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[ALLOW_UNIT] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[REMARK] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY];
CREATE TABLE [dbo].[PRO_TITLE] (
[WORKER_ID] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
[WORKER_NAME] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[ASSESS_DATE] [datetime] NULL,
[ASSESS_UNIT] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[ASSESS_TITLE] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[REMARK] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY];
CREATE TABLE [dbo].[WORK_AGE] (
[RECORD_ID] [bigint] IDENTITY (1, 1) NOT NULL ,
[WORKER_ID] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
[WORKER_NAME] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[BEGIN_DATE] [datetime] NULL,
[OVER_DATE] [datetime] NULL,
[UNIT_NAME] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[WORK_TIME] [float] NULL ,
[DUTY] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[LEVEL1] [nvarchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
[REMARK] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY];
CREATE TABLE [dbo].[USER_TABLE] (
[USER_NAME] [nvarchar] (30) not NULL ,
[USER_PWD] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[POWER_LEVEL] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY];
INSERT INTO USER_TABLE(USER_NAME,USER_PWD,POWER_LEVEL) VALUES
('system','system','系统管理员');
没有合适的资源?快使用搜索试试~ 我知道了~
工资管理系统 SQL数据库课程设计
共291个文件
~1~:29个
~pas:29个
pas:29个
5星 · 超过95%的资源 需积分: 49 188 下载量 81 浏览量
2010-01-08
17:13:47
上传
评论 19
收藏 1.02MB RAR 举报
温馨提示
工资管理系统 SQL数据库课程设计,根据职工的考勤、职务、部门和各种税费,自动求出工资。
资源推荐
资源详情
资源评论
收起资源包目录
工资管理系统 SQL数据库课程设计 (291个子文件)
ENTERPRISE.bdsproj 8KB
tmpImage.bmp 0B
ENTERPRISE.cfg 386B
wageinput.dcu 19KB
checkinput.dcu 16KB
basedata_unit.dcu 13KB
checkinfo_unit.dcu 13KB
wageinfo_unit.dcu 12KB
baseholdUnit1.dcu 12KB
workageinput.dcu 11KB
protitle.dcu 10KB
rewardpunfrm.dcu 10KB
mainfrmUnit2.dcu 9KB
rewardpun_unit.dcu 9KB
checkhold.dcu 9KB
baseinputUnit1.dcu 9KB
wagefind.dcu 9KB
workage_unit.dcu 8KB
pro_titlefind.dcu 8KB
workagefind.dcu 8KB
dblinkfrmUnit4.dcu 7KB
userhold.dcu 7KB
basefindUnit1.dcu 7KB
rewardfind.dcu 7KB
backup.dcu 6KB
protitle_unit.dcu 6KB
loginfrmUnit3.dcu 6KB
useradd.dcu 5KB
usertable_unit.dcu 4KB
movefrmunit1.dcu 4KB
about.dcu 4KB
persondatamod_unit.dcu 2KB
baseholdUnit1.ddp 51B
persondatamod_unit.ddp 51B
loginfrmUnit3.ddp 51B
userhold.ddp 51B
wageinput.ddp 51B
useradd.ddp 51B
workageinput.ddp 51B
checkinput.ddp 51B
wagefind.ddp 51B
dblinkfrmUnit4.ddp 51B
pro_titlefind.ddp 51B
mainfrmUnit2.ddp 51B
backup.ddp 51B
movefrmunit1.ddp 51B
protitle.ddp 51B
baseinputUnit1.ddp 51B
workagefind.ddp 51B
basefindUnit1.ddp 51B
checkhold.ddp 51B
rewardfind.ddp 51B
rewardpunfrm.ddp 51B
checkinput.dfm 9KB
wageinput.dfm 9KB
baseinputUnit1.dfm 7KB
baseholdUnit1.dfm 7KB
workageinput.dfm 5KB
rewardpunfrm.dfm 4KB
protitle.dfm 3KB
checkhold.dfm 3KB
wagefind.dfm 3KB
mainfrmUnit2.dfm 3KB
workagefind.dfm 3KB
pro_titlefind.dfm 3KB
rewardfind.dfm 2KB
dblinkfrmUnit4.dfm 2KB
userhold.dfm 2KB
basefindUnit1.dfm 2KB
useradd.dfm 2KB
backup.dfm 2KB
loginfrmUnit3.dfm 1KB
about.dfm 1KB
movefrmunit1.dfm 1KB
persondatamod_unit.dfm 961B
ENTERPRISE.dof 2KB
ENTERPRISE.dpr 3KB
ENTERPRISE.exe 1.17MB
ENTERPRISE.identcache 2KB
setup.ini 118B
tmpImage.jpg 15KB
PERSONNEL_SYS_Log.LDF 1024KB
ENTERPRISE.bdsproj.local 62B
PERSONNEL_SYS_Data.MDF 1.25MB
wageinput.pas 13KB
basedata_unit.pas 10KB
checkinput.pas 10KB
checkinfo_unit.pas 9KB
wageinfo_unit.pas 8KB
rewardpun_unit.pas 7KB
workage_unit.pas 6KB
workageinput.pas 6KB
baseholdUnit1.pas 6KB
mainfrmUnit2.pas 5KB
protitle.pas 5KB
rewardpunfrm.pas 5KB
workagefind.pas 4KB
checkhold.pas 4KB
protitle_unit.pas 4KB
wagefind.pas 4KB
共 291 条
- 1
- 2
- 3
a442595512
- 粉丝: 3
- 资源: 2
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
- 3
- 4
- 5
前往页