商业源码-编程源码-ResviewCRM的ExtJS页面程序.zip

CREATE TABLE [BSERVER] ( [SVS_ID] [int] NULL , [SVS_NAME] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [SVS_SMO_ID] [int] NULL , [SVS_CPU_ID] [int] NULL , [SVS_MEY_ID] [int] NULL , [SVS_HAD_ID] [int] NULL , [SVS_ATY_ID] [int] NULL , [SVS_OS_ID] [int] NULL , [SVS_STORAGE] [int] NULL , [SVS_SN] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [SVS_SHORTDESC] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [SVS_IPADDRESS] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL , [SVS_CREATIONUID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [SVS_CREATE_DT] [datetime] NULL , [SVS_UPDATEUID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [SVS_UPDATE_DT] [datetime] NULL ) ON [PRIMARY] GO CREATE TABLE [BSVSBACKUP] ( [SVS_ID] [int] NULL , [SVS_NAME] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [SVS_SMO_ID] [int] NULL , [SVS_CPU_ID] [int] NULL , [SVS_MEY_ID] [int] NULL , [SVS_HAD_ID] [int] NULL , [SVS_ATY_ID] [int] NULL , [SVS_OS_ID] [int] NULL , [SVS_SN] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [SVS_SHORTDESC] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [SVS_IPADDRESS] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL , [SVS_OPERATEUID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [SVS_OPERATE_DT] [datetime] NULL ) ON [PRIMARY] GO CREATE TABLE [LSVSPOPEDOM] ( [POP_ID] [int] NULL , [POP_USR_ID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [POP_LIST_ADD] [bit] NULL , [POP_LIST_MODIFY] [bit] NULL , [POP_LIST_QUERY] [bit] NULL , [POP_LIST_DEL] [bit] NULL , [POP_LIST_DOWNLOAD] [bit] NULL , [POP_CREATIONUID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [POP_CREATE_DT] [datetime] NULL , [POP_UPDATEUID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [POP_UPDATE_DT] [datetime] NULL , [POP_UPLOAD_ADD] [bit] NULL ) ON [PRIMARY] GO CREATE TABLE [RATYTYPE] ( [ATY_ID] [int] NULL , [ATY_NAME] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [ATY_CREATIONUID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [ATY_CREATE_DT] [datetime] NULL , [ATY_UPDATEUID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [ATY_UPDATE_DT] [datetime] NULL ) ON [PRIMARY] GO CREATE TABLE [RCPUTYPE] ( [CPU_ID] [int] NULL , [CPU_NAME] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [CPU_CREATIONUID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [CPU_CREATE_DT] [datetime] NULL , [CPU_UPDATEUID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [CPU_UPDATE_DT] [datetime] NULL ) ON [PRIMARY] GO CREATE TABLE [RHADTYPE] ( [HAD_ID] [int] NULL , [HAD_NAME] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [HAD_CREATIONUID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [HAD_CREATE_DT] [datetime] NULL , [HAD_UPDATEUID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [HAD_UPDATE_DT] [datetime] NULL ) ON [PRIMARY] GO CREATE TABLE [RMEYTYPE] ( [MEY_ID] [int] NULL , [MEY_NAME] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [MEY_CREATIONUID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [MEY_CREATE_DT] [datetime] NULL , [MEY_UPDATEUID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [MEY_UPDATE_DT] [datetime] NULL ) ON [PRIMARY] GO CREATE TABLE [ROSTYPE] ( [OS_ID] [int] NULL , [OS_NAME] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [OS_CREATIONUID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [OS_CREATE_DT] [datetime] NULL , [OS_UPDATEUID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [OS_UPDATE_DT] [datetime] NULL ) ON [PRIMARY] GO CREATE TABLE [RSERBACKUP] ( [SER_SVS_ID] [int] NULL , [SER_COME_DT] [datetime] NULL , [SER_OWNER] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [SER_PO_NO] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [SER_TEP_ID] [int] NULL , [SER_STR_ID] [int] NULL , [SER_AP_LIST] [text] COLLATE Chinese_PRC_CI_AS NULL , [SER_OPERATEUID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [SER_OPERATE_DT] [datetime] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [RSERVER] ( [SER_SVS_ID] [int] NULL , [SER_COME_DT] [datetime] NULL , [SER_OWNER] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [SER_PO_NO] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [SER_TEP_ID] [int] NULL , [SER_STR_ID] [int] NULL , [SER_AP_LIST] [text] COLLATE Chinese_PRC_CI_AS NULL , [SER_OPERATEUID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [SER_OPERATE_DT] [datetime] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [RSMOTYPE] ( [SMO_ID] [int] NULL , [SMO_NAME] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [SMO_CREATIONUID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [SMO_CREATE_DT] [datetime] NULL , [SMO_UPDATEUID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [SMO_UPDATE_DT] [datetime] NULL ) ON [PRIMARY] GO CREATE TABLE [RSTRTYPE] ( [STR_ID] [int] NULL , [STR_NAME] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [STR_CREATIONUID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [STR_CREATE_DT] [datetime] NULL , [STR_UPDATEUID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [STR_UPDATE_DT] [datetime] NULL ) ON [PRIMARY] GO CREATE TABLE [RTEAMTYPE] ( [TEP_ID] [int] NULL , [TEP_NAME] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [TEP_CREATIONUID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [TEP_CREATE_DT] [datetime] NULL , [TEP_UPDATEUID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [TEP_UPDATE_DT] [datetime] NULL ) ON [PRIMARY] GO CREATE TABLE [SSEQUENCE] ( [SEQ_NUM] [int] NOT NULL , [SEQ_TABLE] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [SEQ_STEP] [int] NOT NULL , [SEQ_CREATIONUID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [SEQ_CREATE_DT] [datetime] NULL , [SEQ_UPDATEUID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , [SEQ_UPDATE_DT] [datetime] NULL , PRIMARY KEY CLUSTERED ( [SEQ_TABLE] ) ON [PRIMARY] ) ON [PRIMARY] GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE PORC_LSVSPOPEDOM_ADD @POP_ID INT OUTPUT, @POP_USR_ID varchar(5), @POP_LIST_ADD bit, @POP_LIST_MODIFY bit, @POP_LIST_QUERY bit, @POP_LIST_DEL BIT, @POP_LIST_DOWNLOAD bit, @POP_CREATIONUID varchar(5), @POP_CREATE_DT datetime AS DECLARE @ID INT IF EXISTS(SELECT * FROM SSEQUENCE WHERE SEQ_TABLE = 'LSVSPOPEDOM') BEGIN SET @POP_ID= (SELECT SEQ_NUM FROM SSEQUENCE WHERE SEQ_TABLE = 'LSVSPOPEDOM') UPDATE SSEQUENCE SET SEQ_NUM = SEQ_NUM + SEQ_STEP, SEQ_UPDATE_DT = GETDATE(),SEQ_UPDATEUID ='SYS' WHERE SEQ_TABLE = 'LSVSPOPEDOM' INSERT INTO [LSVSPOPEDOM]( [POP_ID],[POP_LIST_DEL],[POP_USR_ID],[POP_LIST_ADD],[POP_LIST_MODIFY],[POP_LIST_QUERY],[POP_LIST_DOWNLOAD],[POP_CREATIONUID],[POP_CREATE_DT] )VALUES( @POP_ID,@POP_LIST_DEL,@POP_USR_ID,@POP_LIST_ADD,@POP_LIST_MODIFY,@POP_LIST_QUERY,@POP_LIST_DOWNLOAD,@POP_CREATIONUID,getdate() ) --PRINT '权限记录ID='+@ID END GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO CREATE PROCEDURE PROC_BSERVER_ADD @SVS_ID int output, @SVS_NAME varchar(50), @SVS_SMO_ID int, @SVS_CPU_ID int, @SVS_MEY_ID int, @SVS_HAD_ID int, @SVS_ATY_ID int, @SVS_OS_ID int, @SVS_SN varchar(50), @SVS_SHORTDESC varchar(100), @SVS_IPADDRESS varchar(15), @SVS_CREATIONUID varchar(5) AS IF EXISTS(SELECT * FROM BSERVER WHERE SVS_NAME = @SVS_NAME) BEGIN SET @SVS_ID= (SELECT SVS_ID FROM BSERVER WHERE SVS_NAME = @SVS_NAME) RETURN END IF EXISTS(SELECT * FROM SSEQUENCE WHERE SEQ_TABLE = 'BSERVER') BEGIN SET @SVS_ID= (SELECT SEQ_NUM FROM SSEQUENCE WHERE SEQ_TABLE = 'BSERVER') UPDATE SSEQUENCE SET SEQ_NUM = SEQ_NUM + SEQ_STEP, SEQ_UPDATE_DT = GETDATE(),SEQ_UPDATEUID ='SYS' WHERE SEQ_TABLE = 'BSERVER' INSERT INTO [BSERVER]( [SVS_ID],[SVS_NAME],[SVS_SMO_ID],[SVS_CPU_ID],[SVS_MEY_ID],[SVS_HAD_ID],[SVS_ATY_ID],[SVS_OS_ID],[SVS_SN],[SVS_SHORTDESC],[SVS_IP