ERP系统源代码和设计文档.zip

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'project_manager' AND type = 'R') CREATE ROLE [project_manager] AUTHORIZATION [dbo] GO IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'project_member' AND type = 'R') CREATE ROLE [project_member] AUTHORIZATION [dbo] GO IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'project_member') EXEC sys.sp_executesql N'CREATE SCHEMA [project_member] AUTHORIZATION [project_member]' GO IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'ZTHX-HXXD-ERP') EXEC sys.sp_executesql N'CREATE SCHEMA [ZTHX-HXXD-ERP] AUTHORIZATION [ZTHX-HXXD-ERP]' GO IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'ZTHX-HXXD-ERP') CREATE USER [ZTHX-HXXD-ERP] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[ZTHX-HXXD-ERP] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Msg_SendMsgSet]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Msg_SendMsgSet]( [MsgType] [char](2) NOT NULL, [IfSend] [char](1) NOT NULL, [WaitTime] [char](10) NULL ) ON [PRIMARY] END GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'消息类型' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Msg_SendMsgSet', @level2type=N'COLUMN', @level2name=N'MsgType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否发送' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Msg_SendMsgSet', @level2type=N'COLUMN', @level2name=N'IfSend' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'等待时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Msg_SendMsgSet', @level2type=N'COLUMN', @level2name=N'WaitTime' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'204发送消息设置' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Msg_SendMsgSet' GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Cask_Appertain]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Cask_Appertain]( [AppertainID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, [WrappageCode] [char](20) NOT NULL, [AppertainCode] [char](20) NOT NULL, [AppertainName] [nvarchar](50) NULL CONSTRAINT [DF__Cask_Appe__Apper__50728AF4] DEFAULT (''), [UnitPrice] [decimal](18, 6) NULL, [Quantity] [decimal](18, 6) NULL, [DataType] [int] NULL, [Remark] [nvarchar](50) NULL, CONSTRAINT [PK_CASK_APPERTAIN] PRIMARY KEY CLUSTERED ( [AppertainID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自动编码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Cask_Appertain', @level2type=N'COLUMN', @level2name=N'AppertainID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'包装物编码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Cask_Appertain', @level2type=N'COLUMN', @level2name=N'WrappageCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'附属物编码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Cask_Appertain', @level2type=N'COLUMN', @level2name=N'AppertainCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'附属物名称' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Cask_Appertain', @level2type=N'COLUMN', @level2name=N'AppertainName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单价' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Cask_Appertain', @level2type=N'COLUMN', @level2name=N'UnitPrice' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数量' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @lev�