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].[sf_凭证过帐]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_凭证过帐]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_初始化帐户]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_初始化帐户]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_启用帐户]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_启用帐户]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_期末结帐]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_期末结帐]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_计算资产负债表]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_计算资产负债表]
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].[本期汇总账簿]
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
CREATE TABLE [dbo].[凭证表] (
[凭证编号] [char] (10) NOT NULL ,
[会计期间] [int] NULL ,
[凭证字号] [cha�
C#+SQL Server项目开发实践范例.zip （300个子文件） 
房态之将到.bmp 2KB 房态之自用房.bmp 2KB 房态之自用房.bmp 2KB 房态之将离.bmp 2KB 房态之维修房.bmp 2KB 房态之住房.bmp 2KB 房态之将到.bmp 2KB 房态之空房.bmp 2KB 房态之住房.bmp 2KB 房态之将离.bmp 2KB 房态之维修房.bmp 2KB 房态之空房.bmp 2KB 房态之空.bmp 2KB 房态之空.bmp 2KB SPELL.BMP 1KB NEW.BMP 1KB PRINT.BMP 1KB SPELL.BMP 1KB SAVE.BMP 1KB CHECK.BMP 246B NEW.BMP 246B SAVE.BMP 246B DELETE.BMP 246B PRINT.BMP 246B 尾记录.bmp 246B 下记录.bmp 246B 搜索.bmp 246B 首记录.bmp 246B 新增.bmp 246B 关闭.bmp 246B 保存.bmp 246B 删除.bmp 246B 取消.bmp 246B 上记录.bmp 246B 修改.bmp 246B 计算.bmp 246B 查询选择.bmp 246B 保存.bmp 246B 查询选择.bmp 246B 上记录.bmp 246B 删除.bmp 246B 首记录.bmp 246B 新增.bmp 246B 下记录.bmp 246B 尾记录.bmp 246B 取消.bmp 246B 搜索.bmp 246B 关闭.bmp 246B 计算.bmp 246B 修改.bmp 246B
DataSet1.cs 167KB DataSet1.cs 156KB DataSet1.cs 143KB DataSet1.cs 133KB DataSet1.cs 120KB frmReside.cs 108KB frmSalaryManage.cs 107KB frmPeopleManage.cs 76KB frmReserve.cs 67KB DataSet1.cs 56KB frmCash.cs 51KB frmShuRu.cs 41KB frmBookDoc.cs 41KB frmReaderDoc.cs 40KB frmOrderList.cs 38KB frmZongFen.cs 36KB frmZhangHu.cs 33KB frmReport.cs 33KB frmStudent.cs 32KB frmSupplyInfo.cs 31KB frmTaxInfo.cs 29KB frmGoodsInfo.cs 29KB frmRoomInfo.cs 28KB frmPrize.cs 28KB frmPunish.cs 27KB frmSelectBook.cs 26KB frmSubject.cs 25KB OrderList.cs 23KB frmRoomState.cs 22KB frmBuyBook.cs 22KB frmClass.cs 21KB frmConsume.cs 21KB frmRoomType.cs 20KB frmMingXi.cs 20KB frmSelect.cs 20KB frmKeMu.cs 20KB frmReaderType.cs 19KB frmMoney.cs 18KB frmBorrow.cs 18KB frmDepInfo.cs 17KB frmDepManage.cs 15KB frmMain.cs 15KB frmBase.cs 14KB frmBase.cs 14KB frmBase.cs 14KB frmBase.cs 14KB frmScore.cs 13KB frmBookType.cs 13KB frmPingHeng.cs 11KB frmPeopleQuery.cs 10KB共 300 条
- 1
- 2
- 3
资源评论
