tb_DataSet表(账套配置表)详解

作者:C/S框架网|www.csframewo 发布日期:2021/11/25 12:00:31

tb_DataSet表(账套配置表)详解

目录(Index)

1. tb_DataSet表
2. 使用sa账号连接账套数据库
3. 登录系统，选择账套
4. 无法选择账套主要原因与解决方案
错误原因
解决方案

1. tb_DataSet表

CSFrameworkV5_System数据库 tb_DataSet表，配置账套数据库连接方式。

配置帐套数据库主要参数：服务器IP、数据库名称、用户、密码。

SQL Code:

CREATE TABLE [dbo].[tb_DataSet](
[isid] [int] IDENTITY(1,1) NOT NULL,
[DataSetID] [varchar](20) NOT NULL,
[DataSetName] [nvarchar](40) NOT NULL,
[DatabaseType] [varchar](10) NULL,
[RemoteServerIP] [varchar](50) NOT NULL,
[RemoteServerPort] [int] NULL,
[LocalServerIP] [varchar](50) NULL,
[LocalServerPort] [int] NULL,
[DBName] [varchar](250) NOT NULL,
[DBUserName] [varchar](50) NULL,
[DBUserPassword] [varchar](250) NULL,
[Remark] [nvarchar](250) NULL,
[PermissionInherited] [char](1) NULL,
[IsVisible] [char](1) NULL,
[IsUse] [char](1) NULL,
CONSTRAINT [PK_tb_DataSet] PRIMARY KEY CLUSTERED
(
[isid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'账套编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_DataSet', @level2type=N'COLUMN',@level2name=N'DataSetID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'账套名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_DataSet', @level2type=N'COLUMN',@level2name=N'DataSetName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据库类型，支持SqlServer,Oracle,MySQL' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_DataSet', @level2type=N'COLUMN',@level2name=N'DatabaseType'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据库服务器外网IP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_DataSet', @level2type=N'COLUMN',@level2name=N'RemoteServerIP'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据库服务器外网端口' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_DataSet', @level2type=N'COLUMN',@level2name=N'RemoteServerPort'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据库服务器内网IP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_DataSet', @level2type=N'COLUMN',@level2name=N'LocalServerIP'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据库服务器内网端口' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_DataSet', @level2type=N'COLUMN',@level2name=N'LocalServerPort'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据库名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_DataSet', @level2type=N'COLUMN',@level2name=N'DBName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_DataSet', @level2type=N'COLUMN',@level2name=N'DBUserName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_DataSet', @level2type=N'COLUMN',@level2name=N'DBUserPassword'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_DataSet', @level2type=N'COLUMN',@level2name=N'Remark'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'启用继承权限' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_DataSet', @level2type=N'COLUMN',@level2name=N'PermissionInherited'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否可用' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_DataSet', @level2type=N'COLUMN',@level2name=N'IsVisible'
GO

//来源:C/S框架网 | www.csframework.com | QQ:23404761

字段说明：