Visual C#.NET数据库开发经典案例解析之医院管理系统

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].[住院记账记录] 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 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].[药品分类]') �