if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同变动子集_劳动合同编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[合同变动子集] DROP CONSTRAINT 合同变动子集_劳动合同编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同补充子集_劳动合同编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[合同补充子集] DROP CONSTRAINT 合同补充子集_劳动合同编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同解除子集_劳动合同编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[合同解除子集] DROP CONSTRAINT 合同解除子集_劳动合同编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同续签子集_劳动合同编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[合同续签子集] DROP CONSTRAINT 合同续签子集_劳动合同编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同终止子集_劳动合同编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[合同终止子集] DROP CONSTRAINT 合同终止子集_劳动合同编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[劳动争议子集_劳动合同编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[劳动争议子集] DROP CONSTRAINT 劳动争议子集_劳动合同编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[干部调整与交流子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[干部调整与交流子集] DROP CONSTRAINT 干部调整与交流子集_职员编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[个人简历子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[个人简历子集] DROP CONSTRAINT 个人简历子集_职员编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[个人年度汇总台帐子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[个人年度汇总台帐子集] DROP CONSTRAINT 个人年度汇总台帐子集_职员编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同管理子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[合同管理子集] DROP CONSTRAINT 合同管理子集_职员编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[兼任职务子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[兼任职务子集] DROP CONSTRAINT 兼任职务子集_职员编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[军转干部子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[军转干部子集] DROP CONSTRAINT 军转干部子集_职员编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[离休退休子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[离休退休子集] DROP CONSTRAINT 离休退休子集_职员编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[社会保险子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[社会保险子集] DROP CONSTRAINT 社会保险子集_职员编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[生育保险信息子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[生育保险信息子集] DROP CONSTRAINT 生育保险信息子集_职员编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[失业保险信息子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[失业保险信息子集] DROP CONSTRAINT 失业保险信息子集_职员编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[行政党派职务子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[行政党派职务子集] DROP CONSTRAINT 行政党派职务子集_职员编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[行政及党内惩罚_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[行政及党内惩罚] DROP CONSTRAINT 行政及党内惩罚_职员编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[行政及党内奖励_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[行政及党内奖励] DROP CONSTRAINT 行政及党内奖励_职员编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[学历及学位子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[学历及学位子集] DROP CONSTRAINT 学历及学位子集_职员编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[养老保险信息子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[养老保险信息子集] DROP CONSTRAINT 养老保险信息子集_职员编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[医疗保险子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[医疗保险子集] DROP CONSTRAINT 医疗保险子集_职员编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[政治面貌及党籍情况_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[政治面貌及党籍情况] DROP CONSTRAINT 政治面貌及党籍情况_职员编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[职工参险信息子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[职工参险信息子集] DROP CONSTRAINT 职工参险信息子集_职员编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_职员离职登记表_职员基本信息表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[职员离职登记表] DROP CONSTRAINT FK_职员离职登记表_职员基本信息表
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[职员主要关系人信息表_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[职员主要关系人信息表] DROP CONSTRAINT 职员主要关系人信息表_职员编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[主要论文著作子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[主要论文著作子集] DROP CONSTRAINT 主要论文著作子集_职员编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[住房公积金子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[住房公积金子集] DROP CONSTRAINT 住房公积金子集_职员编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[专业技术职务子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[专业技术职务子集] DROP CONSTRAINT 专业技术职务子集_职员编号_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[上年工资统计]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[上年工资统计]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[专业技术职务子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[专业技术职务子集]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[个人年度汇总台帐子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[个人年度汇总台帐子集]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[个人所得税表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[个人所得税表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[个人简历子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[个人简历子集]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[主要论文著作子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[主要论文著作子集]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[人事变更历史表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[人事变更历史表]
没有合适的资源?快使用搜索试试~ 我知道了~
个人税务系统,用SQLSERVER2000和VS2005开发的源码
共75个文件
cs:15个
bmp:12个
resx:11个
3星 · 超过75%的资源 需积分: 10 25 下载量 93 浏览量
2009-05-03
21:59:58
上传
评论
收藏 691KB RAR 举报
温馨提示
个人税务系统,里面提供开发源码和数据库的原文件以及脚本
资源推荐
资源详情
资源评论
收起资源包目录
.rar (75个子文件)
Icon
计算.bmp 246B
新增.bmp 246B
删除.bmp 246B
下记录.bmp 246B
尾记录.bmp 246B
hrm.ico 1KB
上记录.bmp 246B
取消.bmp 246B
搜索.bmp 246B
保存.bmp 246B
查询选择.bmp 246B
首记录.bmp 246B
修改.bmp 246B
代码
人力资源管理系统.csproj.user 2KB
DataSet1.xsx 1KB
PayoffHistory.resx 15KB
AmendStafferInfo.cs 57KB
DataSet2.xsx 165B
DataSet1.cs 152KB
OrgInfo.cs 21KB
PayoffHistory.cs 12KB
HortationManage.resx 31KB
bin
Debug
人力资源管理系统.exe 448KB
人力资源管理系统.pdb 524KB
DataSet1.xsd 8KB
obj
Debug
人力资源管理系统.HortationManage.resources 27KB
人力资源管理系统.AmendStafferInfo.resources 41KB
人力资源管理系统.exe 448KB
人力资源管理系统.SetOrgInfo.resources 18KB
人力资源管理系统.IncomeTax.resources 20KB
人力资源管理系统.SalaryManage.resources 46KB
人力资源管理系统.LookupStafferInfo.resources 15KB
人力资源管理系统.PayoffHistory.resources 12KB
人力资源管理系统.pdb 524KB
人力资源管理系统.DataGridNoActiveCellColumn.resources 188B
人力资源管理系统.MainFrm.resources 13KB
temp
TempPE
DataSet2.cs.dll 15KB
DataSet11.cs.dll 32KB
Dataset3.cs.dll 6KB
DataSet1.cs.dll 76KB
人力资源管理系统.PunishmentManage.resources 27KB
人力资源管理系统.OrgInfo.resources 19KB
Release
人力资源管理系统.exe 440KB
temp
TempPE
DataSet2.cs.dll 15KB
DataSet1.cs.dll 96KB
DataGridNoActiveCellColumn.resx 2KB
MainFrm.cs 12KB
HortationManage.cs 26KB
DataSet11.xsd 3KB
DataSet2.cs 24KB
hrm.ico 1KB
PunishmentManage.cs 26KB
DataSet11.cs 39KB
AmendStafferInfo.resx 47KB
MainFrm.resx 15KB
SetOrgInfo.cs 38KB
人力资源管理系统.sln 917B
DataGridNoActiveCellColumn.cs 602B
DataSet2.xsd 2KB
SalaryManage.cs 82KB
LookupStafferInfo.resx 18KB
PunishmentManage.resx 31KB
OrgInfo.resx 23KB
IncomeTax.cs 23KB
LookupStafferInfo.cs 13KB
IncomeTax.resx 24KB
SalaryManage.resx 52KB
SetOrgInfo.resx 21KB
AssemblyInfo.cs 2KB
人力资源管理系统.csproj 10KB
建库脚本
人力资源管理.sql 97KB
hrmbook_log.ldf 1024KB
hrmbook.bak 1.14MB
hrmbook.mdf 1.38MB
人力资源管理实例程序.sql 14KB
共 75 条
- 1
资源评论
- llxmut2015-01-27参考了下,自己又在上面修改了下,还是可以用的
yuzhuo0820
- 粉丝: 0
- 资源: 7
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功