DXperience又出新版本啦!最新发布的DXperience 12.2可轻松创建各种 Microsoft Office应用。下面我们就用DXperience 12.2一起创建一个漂亮的Win8界面风格的实时项目管理。我们将用到XtraScheduler的甘特图视图、Ribbon和数据网格。
数据库模式
首先定义数据库框架,将Microsoft® SQL Server 作为我们的后端,用来存储命令和任务。打开SQL Server Management Studio ,创建一个新的数据库:"DXProjectManager"以及树形表格:Appointments, Resources 和 TaskDependencies。示例代码如下:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
|
CREATE TABLE [dbo].[Appointments] (
[UniqueId] [
int
] IDENTITY (1, 1) NOT NULL ,
[Type] [
int
] NULL ,
[StartDate] [smalldatetime] NULL ,
[EndDate] [smalldatetime] NULL ,
[AllDay] [bit] NULL ,
[Subject] [nvarchar] (max) NULL ,
[Location] [nvarchar] (max) NULL ,
[Description] [nvarchar](max) NULL ,
[Status] [
int
] NULL ,
[Label] [
int
] NULL ,
[ResourceId] [
int
] NULL ,
[ResourceIds] [nvarchar](max) NULL ,
[ReminderInfo] [nvarchar](max) NULL ,
[RecurrenceInfo] [nvarchar](max) NULL ,
[PercentComplete] [
int
] NULL,
[CustomField1] [nvarchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[Resources] (
[Id] [
int
] IDENTITY (1, 1) NOT NULL ,
[IdSort] [
int
] NULL ,
[ParentId] [
int
] NULL ,
[Description] [nvarchar] (max) NULL ,
[Color] [
int
] NULL ,
[Image] [image] NULL ,
[CustomField1] [nvarchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[TaskDependencies](
[Id] [
int
] IDENTITY(1,1) NOT NULL,
[ParentId] [
int
] NULL,
[DependentId] [
int
] NULL,
[Type] [
int
] NOT NULL,
GO
|