Web开发新体验_ASP.NET.3.5.MVC架构与实战源码(全)

/****** Object: ForeignKey [FK_Address_ContactPerson] Script Date: 02/17/2007 13:21:19 ******/ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_Address_ContactPerson]') AND type = 'F') ALTER TABLE [dbo].[Address] DROP CONSTRAINT [FK_Address_ContactPerson] GO /****** Object: ForeignKey [FK_EmailAddress_ContactPerson] Script Date: 02/17/2007 13:21:19 ******/ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_EmailAddress_ContactPerson]') AND type = 'F') ALTER TABLE [dbo].[EmailAddress] DROP CONSTRAINT [FK_EmailAddress_ContactPerson] GO /****** Object: ForeignKey [FK_PhoneNumber_ContactPerson] Script Date: 02/17/2007 13:21:19 ******/ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_PhoneNumber_ContactPerson]') AND type = 'F') ALTER TABLE [dbo].[PhoneNumber] DROP CONSTRAINT [FK_PhoneNumber_ContactPerson] GO /****** Object: StoredProcedure [dbo].[sprocContactPersonSelectSingleItem] Script Date: 02/17/2007 13:21:19 ******/ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sprocContactPersonSelectSingleItem]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) DROP PROCEDURE [dbo].[sprocContactPersonSelectSingleItem] GO /****** Object: StoredProcedure [dbo].[sprocContactPersonInsertUpdateSingleItem] Script Date: 02/17/2007 13:21:19 ******/ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sprocContactPersonInsertUpdateSingleItem]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) DROP PROCEDURE [dbo].[sprocContactPersonInsertUpdateSingleItem] GO /****** Object: StoredProcedure [dbo].[sprocContactPersonSelectList] Script Date: 02/17/2007 13:21:19 ******/ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sprocContactPersonSelectList]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) DROP PROCEDURE [dbo].[sprocContactPersonSelectList] GO /****** Object: StoredProcedure [dbo].[sprocPhoneNumberSelectSingleItem] Script Date: 02/17/2007 13:21:19 ******/ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sprocPhoneNumberSelectSingleItem]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) DROP PROCEDURE [dbo].[sprocPhoneNumberSelectSingleItem] GO /****** Object: StoredProcedure [dbo].[sprocPhoneNumberSelectList] Script Date: 02/17/2007 13:21:19 ******/ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sprocPhoneNumberSelectList]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) DROP PROCEDURE [dbo].[sprocPhoneNumberSelectList] GO /****** Object: StoredProcedure [dbo].[sprocPhoneNumberInsertUpdateSingleItem] Script Date: 02/17/2007 13:21:19 ******/ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sprocPhoneNumberInsertUpdateSingleItem]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) DROP PROCEDURE [dbo].[sprocPhoneNumberInsertUpdateSingleItem] GO /****** Object: StoredProcedure [dbo].[sprocPhoneNumberDeleteSingleItem] Script Date: 02/17/2007 13:21:19 ******/ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sprocPhoneNumberDeleteSingleItem]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) DROP PROCEDURE [dbo].[sprocPhoneNumberDeleteSingleItem] GO /****** Object: StoredProcedure [dbo].[sprocEmailAddressSelectSingleItem] Script Date: 02/17/2007 13:21:19 ******/ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sprocEmailAddressSelectSingleItem]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) DROP PROCEDURE [dbo].[sprocEmailAddressSelectSingleItem] GO /****** Object: StoredProcedure [dbo].[sprocEmailAddressSelectList] Script Date: 02/17/2007 13:21:19 ******/ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[sprocEmailAddressSelectList]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) DROP PROCEDURE [dbo].[sprocEmailAddressSelectList] GO /****** Object: StoredProcedure [dbo].[sprocEmailAddressInsertUpdateSingleItem] Script Date: 02/17�