各位大神
计划使用甘特图插件制作项目管理工具。根据说明使用甘特图链接应用内本地数据库是没有问题的。尝试链接MSSQL数据库失败,可以读取MSSQL中的事项条目,但使用甘特图无法保存数据。
SQL 表结构如下,请大神们帮看看是否数据格式有误。谢谢!
CREATE TABLE [dbo].[tb_process] (
[int_id] [int] IDENTITY(1,1) NOT NULL,
[int_Order] [int] NULL,
[int_Level] [int] NULL,
[vchar_Name] [varchar](255) NULL,
[vchar_Depends] [varchar](255) NULL,
[dttm_Start] [datetime] NULL,
[int_Duration] [int] NULL,
[vchar_CodeName] [varchar](255) NULL,
[vchar_Description] [varchar](4000) NULL,
[int_Progress] [int] NULL,
[vchar_Assigs] [varchar](4000) NULL,
[bit_IsMilestone] [bit] NULL,
[dttm_ActualStart] [datetime] NULL,
[dttm_ActualEnd] [datetime] NULL,
[bit_Collapsed] [bit] NULL,
[vchar_Status] [varchar](50) NULL,
CONSTRAINT [PK_tb_CAT_C_reform_process] PRIMARY KEY CLUSTERED
([int_id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
|