多页签网格页面
概述
（静态）多页签网格页面：
主要是针对一类似的业务查询操作的一种页岩，如工作内容这种页岩
可支持一次查询一个页签，一次查询多个页签。
参数
原理：在一个主网格里配置多个从表网格，同时隐藏主表网格，查询动态将查询条件加入到从表，然后查询从表
要配置 １个主表网格，１个查询，多个从表网格
示例
多页签网格配置：
１。配置主网格
１）主网格属性 Height="0"
２）Childs 节点AutoSize="True" Mode="Tab"
如下
<!--
说明：多页签查询页面配置
主网格配置Height="0"
从表配置：Childs AutoSize="True" Mode="Tab" Height="100%"
每个child： Height="100%"
查询配置：QueryFun="__CommonSearchForAllChild('all')" ButtonText="查询(所有)"
HasAdvancedSearchButton="true"
AdvancedQueryFun="__CommonSearchForAllChild('single')" AdvancedButtonText="查询(当前)"
-->
<GridList>
<Grid Name="SysLog" UniqueNo="0" Height="0" HasDetail="false" FreezedIndex="0" AllowEdit="true" HasRowHeader="true" HasChecked="false" Code="1000" PageSize="50" WinWidth="600px" WinHeight="414px" OpenType="showmodaldialog">
<Column Field="FullName" FieldType="VarChar" CaptionText="操作人" Width="100"></Column>
<Column Field="SysUserId" FieldType="VarChar" CaptionText="操作人" Width="0"></Column>
<Column Field="DisPlayText" FieldType="VarChar" CaptionText="操作类型" Width="120"></Column>
<Column Field="LogType" FieldType="VarChar" CaptionText="操作类型" Width="0"></Column>
<Column Field="EntAndMap" FieldType="VarChar" CaptionText="操作业务" Width="*"></Column>
<Column Field="SysLogId" FieldType="VarChar" CaptionText="操作类型" Width="0"></Column>
<Column Field="LogDate" FieldType="DateTime" CaptionText="操作时间" Width="150" SortOrder="Desc" DataFormatString="yyyy-MM-dd HH:mm:ss"></Column>
<DataSource Type="SqlServer">
<![CDATA[
select a.{@Search['LogEntity']}Id SysLogId,
a.LogDate,
c.FullName,
c.SysUserId,
d.DisPlayText,
a.LogType,
a.LogContent,a.EntAndMap
from {@Search['LogEntity']} a
join SysUser c on a.SysUserId=c.SysUserId
join StringMap d on d.Entity='SysLog' and d.AttributeName='LogType' and d.AttributeValue=a.LogType
]]>
</DataSource>
<DataSource Type="Oracle">
<![CDATA[
select a.{@Search['LogEntity']}Id SysLogId,
a.LogDate,
c.FullName,
c.SysUserId,
d.DisPlayText,
a.LogType,
a.LogContent,a.EntAndMap
from {@Search['LogEntity']} a
join SysUser c on a.SysUserId=c.SysUserId
join StringMap d on d.Entity='SysLog' and d.AttributeName='LogType' and d.AttributeValue=a.LogType
]]>
</DataSource>
<Childs AutoSize="True" Mode="Tab">
<Child Name="SysLogEntry" UniqueNo="0" Height="100%" Title="用户日志细目" FKField="SysLogId">
<PageURL>
<![CDATA[Pages/Grid/Grid.aspx?LogType=User]]>
</PageURL>
</Child>
<Child Name="SysLogEntry" UniqueNo="1" Height="100%" Title="系统日志细目" FKField="SysLogId">
<PageURL>
<![CDATA[Pages/Grid/Grid.aspx?LogType=Sys]]>
</PageURL>
</Child>
</Childs>
</Grid>
</GridList>
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
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
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
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
２。配置查询
1)查询当前按钮的配置 ```QueryFun="__CommonSearchForAllChild('all')" ButtonText="查询(所有)"``
2)查询所有按钮的配置AdvancedQueryFun="__CommonSearchForAllChild('single')"AdvancedButtonText="查询(当前)"
如下
<Query Entity="SysLog" UniqueNo="0" ColCount="3" AutoWidth="false"
QueryFun="__CommonSearchForAllChild('all')" ButtonText="查询(所有)"
HasAdvancedSearchButton="true"
AdvancedQueryFun="__CommonSearchForAllChild('single')" AdvancedButtonText="查询(当前)"
>
<Column Field="LogEntity" CaptionText="日志类型" FieldType="VarChar" Enabled="Yes" FilterType="Equal" InputType="DropDown" DropDownMode="Data" InnerValue="DisPlayValue" DisplayValue="DisplayText" Default="SysLog" Width="90">
<Map Mode="DataSource">
<DataSource Type="SqlServer">
<![CDATA[
select 'SysLog' v,'当前日志' t
union
select 'SysHisToryLog' v,'历史日志' t
]]>
</DataSource>
<DataSource Type="Oracle">
<![CDATA[
select 'SysLog' v,'当前日志' t from dual
union
select 'SysHisToryLog' v,'历史日志' t from dual
]]>
</DataSource>
</Map>
<Events>
<Event Name="afterChange" Script="changeLogEntity"></Event>
</Events>
</Column>
<Column Field="LogDate" CaptionText=" 操作时间" FieldType="DateTime" Enabled="Yes" FilterType="Between" InputType="calendar" DataFormatString="yyyy-MM-dd HH:mm" Width="125px"></Column>
<Column Field="SysUserId" TableName="SysUser" CaptionText="操作人" FieldType="VarChar" Enabled="True" FilterType="Like" InputType="DropDown" DropDownMode="Data" InnerValue="DisPlayValue" DisplayValue="DisplayText" Width="90">
<Map Mode="DataSource">
<DataSource Type="SqlServer">
<![CDATA[
select '' v,'全部' t
union
select SysUserId v, FullName t
from SysUser
where (IsDeleted='0' or IsDeleted is null) and (IsDisabled='0' or IsDisabled is null)
]]>
</DataSource>
<DataSource Type="Oracle">
<![CDATA[
select '' v,'全部' t from dual
union
select SysUserId v, FullName t
from SysUser where (IsDeleted='0' or IsDeleted is null) and (IsDisabled='0' or IsDisabled is null)
]]>
</DataSource>
</Map>
</Column>
<Column Field="LogType" CaptionText=" 操作类型" FieldType="VarChar" Enabled="Yes" FilterType="Like" EditType="DropDown" Width="90">
<Map Mode="DataSource">
<DataSource Type="SqlServer">
<![CDATA[
select '' v,'全部' t
union
Select AttributeValue v,DisplayText t from StringMap where Entity='SysLog' and AttributeName='LogType'
]]>
</DataSource >
<DataSource Type="Oracle">
<![CDATA[
select '' v,'全部' t from dual
union
Select AttributeValue v,DisplayText t from StringMap where Entity='SysLog' and AttributeName='LogType'
]]>
</DataSource>
</Map>
</Column>
<Column Field="EntAndMap" CaptionText="操作业务" FieldType="varchar" Enabled="Yes" FilterType="Like" EditType="TextBox" Width="270">
</Column>
<Scripts>
<Script>
<![CDATA[
function changeLogEntity()
{
window.document.frames["I_SysLogEntry"].wm.c.gridChildRefresh("LogEntity",wm.c.getSearch().getNamedItem("LogEntity").getValue());
return true;
}
]]>
</Script>
</Scripts>
</Query>
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
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
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
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
3.各子网格的配置
与普通网格配置 一下 ，可以通过[{@Search'查询字段']}伪变量取得主风格查询的值。
4.最终结果：
相关链接
网格基础配置 Childs节点 Child节点 查询栏基础配置