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
没有合适的资源?快使用搜索试试~ 我知道了~
资源详情
资源评论
资源推荐
收起资源包目录
ResviewCRM的ExtJS页面程序 (1904个子文件)
ResInitSvt.ashx 13KB
AddListServer.ashx 10KB
ModifyServerList.ashx 9KB
QueryServerList.ashx 7KB
DownQueryServerList.ashx 7KB
AddApplication.ashx 4KB
Upload_ServerList.ashx 4KB
AddSRRelating.ashx 4KB
AddSrList.ashx 4KB
QueryApplication.ashx 4KB
ModifySrList.ashx 3KB
UpdateSrStatus.ashx 2KB
CVS_DownServerList.ashx 2KB
DelApplicationByAPP_ID.ashx 2KB
DisposeApplication.ashx 2KB
DelServerListBySVS_ID.ashx 2KB
GetServerListForModify.ashx 2KB
ListServer.ashx 1KB
GetSRListBySR_IDForModify.ashx 1KB
GetApplication.ashx 1KB
GetUserByUser_id.ashx 1KB
GetAllSRForModifyByOwner.ashx 1KB
GetDisposeBtn.ashx 1KB
DownListServer.ashx 1KB
GetSrStatusByUSER_ID.ashx 1KB
GetSrList.ashx 1KB
GetMainMenu.ashx 1KB
CVS_DownApplication.ashx 816B
wreg.aspx 34KB
ConfirmInfo.aspx 24KB
ModifyUser.aspx 24KB
MyReceive.aspx 14KB
PointsExchange.aspx 11KB
Order.aspx 10KB
ShopBagList.aspx 9KB
send.aspx 8KB
SingleHeader.aspx 8KB
MyOrder.aspx 7KB
LeaveMessage.aspx 5KB
AddMessage.aspx 5KB
wlogin.aspx 5KB
FreightCalculator.aspx 4KB
ShowMsgDetails.aspx 4KB
ModifyPassword.aspx 4KB
Login.aspx 3KB
SendMessage.aspx 3KB
SearchList.aspx 3KB
DownLoadToExcel.aspx 2KB
GetApplication.aspx 1KB
ListServerInfo.aspx 1KB
AddApplication.aspx 1KB
QuerySRList.aspx 1KB
ListSrInfo.aspx 1KB
UploadServerList.aspx 1KB
UpdateSrStatus.aspx 1KB
AddSrRelating.aspx 1KB
AddListServer.aspx 1KB
AddSRList.aspx 1KB
ModifyServerList.aspx 1KB
ModifySRList.aspx 1KB
Activity.aspx 1KB
index.aspx 946B
MyDefault.aspx 879B
BaseInfo.aspx 805B
error.aspx 742B
Default.aspx 573B
BigPicture.aspx 566B
ListCategory.aspx 565B
ListLine.aspx 558B
ListHeader.aspx 546B
DownApplication.aspx 476B
DownServerList.aspx 469B
Session.aspx 443B
Alipay_Return.aspx 270B
Alipay_Notify.aspx 114B
ResolveAssemblyReference.cache 30KB
ResolveAssemblyReference.cache 22KB
ResolveAssemblyReference.cache 16KB
ResolveAssemblyReference.cache 16KB
ResolveAssemblyReference.cache 13KB
ResolveAssemblyReference.cache 9KB
ResolveAssemblyReference.cache 7KB
ResolveAssemblyReference.cache 4KB
web.config 7KB
Web.Config 3KB
ServerDAL.cs 38KB
WebUtility.cs 28KB
JsonParser.cs 22KB
Order.aspx.cs 20KB
JsonNumber.cs 18KB
SrDAL.cs 17KB
TypeDAL.cs 15KB
ApplicationDAL.cs 14KB
JsonWriter.cs 14KB
ConfirmInfo.aspx.cs 12KB
JsonString.cs 12KB
Freight.cs 11KB
SingleHeader.aspx.cs 11KB
SQLHelper.cs 10KB
PointsExchange.aspx.cs 9KB
共 1904 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
ss_geng
- 粉丝: 319
- 资源: 3220
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0