左右选基础配置
概述
左右/上下选基础配置:
用于对关系数据进行批量增加和修改。
左右选：用于列数比较少，数据比较多的业务。
上下选：用于列数比较多，数据相对比较少的业务。
参数
参数
// choose[必须]:对应配置Choose结点的Name值
// param[可选]:JSON格式参数如{param1:"aaa",param2:"bbb"}
// opentype[可选]:打开左右选方式[open|showmodaldialog|showmodelessdialog]，默认为模态 showmodaldialog
// width[模态时可选]:模态窗口的宽度
// height[模态时可选]:模态窗口的高度
// entity[可选]:默认当前实体
// mappingId[可选]:默认当前MappingId
// uniqueNo:
// urlParam:自定义Url参数
// parentId[外键Id值]:默认当前Url的ParentId
// fKField[外键Id字段名称]:默认当前Url的FKField
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
调用方法
var json1 = {choose:"choosename",param:{param1:"aaa",param2:"bbb"},width:"800px",height:"500px"}; wm.c.commonOpenMultiselect(json1);
1
示例
在其它(<Other>)配置下的ChooseList结点形式存在。ChooseList中有若干个Choose节点，用以区分各个Choose节点的是Name属性。
Choose配置分为二种：简单的一对一配置，一对多配置(左边一个，右边多个)
- 一对一配置：对应的页面为
Pages/multiselect/multiselect.aspx
1.1 Choose节点的属性设置如下：
1.2 Choose节点的子结点如下：
1.3 调用方法例子
1.3.1左右选页面调用方法：
function showMultiSelect()
{
var grid = window[__gridId];
var scRows=grid.getDoRows(true,"请先选中要维护的数据！");
if(!scRows)
return;
var id=scRows[0].idd;
var json1 = {choose:"multiselect",parentId:id,fKField:"外键Id名称",urlParam:{param1:"aaa",param2:"bbb"},width:"800px",height:"500px"};
wm.c.commonOpenMultiselect(json1);
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
1.3.2左右通用保存方法：
<Button Target="Grid" RuleName="" Name="cmd确定" Text="确定" ToolTip="确定" Type="Button" Image="WebToolBar/16_Setting.gif" DisplayMode="TextAndImage" Script="wm.c.multiSelectSave()" />
wm.c.multiSelectSave()
1
2
3
4
5
2
3
4
5
1.3 配置文件例子
<ChooseList>
<Choose Name="multiselect" Layout="LeftRight" ChooseKeyField="Demo_WH_MateriallId">
<Query Name="Demo_WH_Materiall" ColCount="2" AutoWidth="false">
<Column Field="Demo_WH_MateriallId" FieldType="VarChar" CaptionText="物料名称" EditType="Combo" FilterType="Like" Width="100">
<Map Mode="ParentTable">
<ParentTable Name="Demo_WH_Materiall" PTText="Caption" PTValue="Demo_WH_MateriallId"/>
</Map>
</Column>
</Query>
<LeftPart Name="Demo_WH_InEntry" Entity="Demo_WH_InEntry" Simple="true">
<Column Field="Demo_WH_InId" FieldType="VarChar" CaptionText="PId" EditType="TextBox" Width="0" IsDisplay="true"></Column>
<Column Field="Demo_WH_MateriallId" FieldType="VarChar" CaptionText="物料名称" EditType="Dropdown" Width="100">
<Map Mode="ParentTable">
<ParentTable Name="Demo_WH_Materiall" PTText="Caption" PTValue="Demo_WH_MateriallId"/>
</Map>
</Column>
<Column Field="InNumber" FieldType="Int32" CaptionText="数量" EditType="TextBox" Width="0" IsDisplay="true"></Column>
<Column Field="CreatedBy" FieldType="VarChar" CaptionText="入库人" EditType="Dropdown" Enabled="No" Width="0" Default="{@sysuserid}">
<Map Mode="ParentTable">
<ParentTable Name="SysUser" PTText="FullName" PTValue="SysUserId"/>
</Map>
</Column>
<Column Field="CreatedOn" FieldType="DateTime" CaptionText="入库时间" EditType="TextBox" Enabled="No" Width="0" Default="{@now}" DataFmt="yyyy-MM-dd HH:mm:ss"></Column>
<DataSource Type="SqlServer">
<![CDATA[
select Demo_WH_MateriallId,newid() Demo_WH_InEntryId,'{@Request['ParentId']}' Demo_WH_InId
,null InNumber,null CreatedBy,null CreatedOn
from Demo_WH_Materiall
where Demo_WH_MateriallId not in(select Demo_WH_MateriallId from Demo_WH_InEntry where Demo_WH_InId='{@Request['ParentId']}')
]]>
</DataSource>
<DataSource Type="Oracle">
<![CDATA[
select Demo_WH_MateriallId,newid() Demo_WH_InEntryId,'{@Request['ParentId']}' Demo_WH_InId
,0 InNumber,null CreatedBy,null CreatedOn
from Demo_WH_Materiall
where Demo_WH_MateriallId not in(select Demo_WH_MateriallId from Demo_WH_InEntry where Demo_WH_InId='{@Request['ParentId']}')
]]>
</DataSource>
</LeftPart>
<RightPart Name="Demo_WH_InEntry" Entity="Demo_WH_InEntry" Simple="true" AllowEdit="true" OpenType="Grid">
<Column Field="Demo_WH_InId" FieldType="VarChar" CaptionText="PId" EditType="TextBox" Width="0" IsDisplay="true"></Column>
<Column Field="Demo_WH_MateriallId" FieldType="VarChar" CaptionText="物料名称" EditType="Dropdown" Width="100" Enabled="No">
<Map Mode="ParentTable">
<ParentTable Name="Demo_WH_Materiall" PTText="Caption" PTValue="Demo_WH_MateriallId"/>
</Map>
</Column>
<Column Field="InNumber" FieldType="Int32" CaptionText="数量" EditType="TextBox" Width="60" IsDisplay="true"></Column>
<Column Field="CreatedBy" FieldType="VarChar" CaptionText="入库人" EditType="Dropdown" Enabled="Yes" Width="60" Default="{@sysuserid}">
<Map Mode="ParentTable">
<ParentTable Name="SysUser" PTText="FullName" PTValue="SysUserId"/>
</Map>
</Column>
<Column Field="CreatedOn" FieldType="DateTime" CaptionText="入库时间" EditType="TextBox" Enabled="No" Width="120" Default="{@now}" DataFmt="yyyy-MM-dd HH:mm:ss"></Column>
<DataSource Type="SqlServer">
<![CDATA[
select * from Demo_WH_InEntry where Demo_WH_InId='{@Request['ParentId']}'
]]>
</DataSource>
<DataSource Type="Oracle">
<![CDATA[
select * from Demo_WH_InEntry where Demo_WH_InId='{@Request['ParentId']}'
]]>
</DataSource>
</RightPart>
<Buttons>
<Button Target="Grid" RuleName="" Name="cmd确定" Text="确定" ToolTip="确定" Type="Button" Image="WebToolBar/16_Setting.gif" DisplayMode="TextAndImage" Script="wm.c.multiSelectSave()" />
<Button Target="Grid" RuleName="" Name="cmd取消" Text="取消" ToolTip="取消" Type="Button" Image="WebToolBar/16_Setting.gif" DisplayMode="TextAndImage" Script="wm.c.formClose(false)" />
</Buttons>
<Scripts>
<Script Type="Grid">
<![CDATA[
]]>
</Script>
</Scripts>
</Choose>
</ChooseList>
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
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
例-简单左右选配置
概述
简单左右选配置：
调用的是Pages/multiselect/multiselect.aspx页面
参数
function showMultiSelect()
{
var grid = window[__gridId];
var scRows=grid.getDoRows(true,"请先选中要维护的数据！");
if(!scRows)
return;
var Id=scRows[0].idd;
var json1 = {choose:"multiselect",param:{param1:Id,param2:"aaa"},width:"800px",height:"500px"};
wm.c.commonOpenMultiselect(json1);
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
示例
- 配置调用方法：
function showMultiSelect()
{
var grid = window[__gridId];
var scRows=grid.getDoRows(true,"请先选中要维护的数据！");
if(!scRows)
return;
var id=scRows[0].idd;
var json1 = {choose:"multiselect",parentId:id,urlParam:{param1:'p1',param2:"p2"},width:"800px",height:"500px"};
wm.c.commonOpenMultiselect(json1);
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
- 配置文件例子：
<ChooseList>
<Choose Name="multiselect" Layout="LeftRight" ChooseKeyField="Demo_WH_MateriallId">
<Query Name="Demo_WH_Materiall" ColCount="2" AutoWidth="false">
<Column Field="Demo_WH_MateriallId" FieldType="VarChar" CaptionText="物料名称" EditType="Combo" FilterType="Like" Width="100">
<Map Mode="ParentTable">
<ParentTable Name="Demo_WH_Materiall" PTText="Caption" PTValue="Demo_WH_MateriallId"/>
</Map>
</Column>
</Query>
<LeftPart Name="Demo_WH_InEntry" Entity="Demo_WH_InEntry" Simple="true">
<Column Field="Demo_WH_InId" FieldType="VarChar" CaptionText="PId" EditType="TextBox" Width="0" IsDisplay="true"></Column>
<Column Field="Demo_WH_MateriallId" FieldType="VarChar" CaptionText="物料名称" EditType="Dropdown" Width="100">
<Map Mode="ParentTable">
<ParentTable Name="Demo_WH_Materiall" PTText="Caption" PTValue="Demo_WH_MateriallId"/>
</Map>
</Column>
<Column Field="InNumber" FieldType="Int32" CaptionText="数量" EditType="TextBox" Width="0" IsDisplay="true"></Column>
<Column Field="CreatedBy" FieldType="VarChar" CaptionText="入库人" EditType="Dropdown" Enabled="No" Width="0" Default="{@sysuserid}">
<Map Mode="ParentTable">
<ParentTable Name="SysUser" PTText="FullName" PTValue="SysUserId"/>
</Map>
</Column>
<Column Field="CreatedOn" FieldType="DateTime" CaptionText="入库时间" EditType="TextBox" Enabled="No" Width="0" Default="{@now}" DataFmt="yyyy-MM-dd HH:mm:ss"></Column>
<DataSource Type="SqlServer">
<![CDATA[
select Demo_WH_MateriallId,newid() Demo_WH_InEntryId,'{@Request['ParentId']}' Demo_WH_InId
,null InNumber,null CreatedBy,null CreatedOn
from Demo_WH_Materiall
where Demo_WH_MateriallId not in(select Demo_WH_MateriallId from Demo_WH_InEntry where Demo_WH_InId='{@Request['ParentId']}')
]]>
</DataSource>
<DataSource Type="Oracle">
<![CDATA[
select Demo_WH_MateriallId,newid() Demo_WH_InEntryId,'{@Request['ParentId']}' Demo_WH_InId
,0 InNumber,null CreatedBy,null CreatedOn
from Demo_WH_Materiall
where Demo_WH_MateriallId not in(select Demo_WH_MateriallId from Demo_WH_InEntry where Demo_WH_InId='{@Request['ParentId']}')
]]>
</DataSource>
</LeftPart>
<RightPart Name="Demo_WH_InEntry" Entity="Demo_WH_InEntry" Simple="true" AllowEdit="true" OpenType="Grid">
<Column Field="Demo_WH_InId" FieldType="VarChar" CaptionText="PId" EditType="TextBox" Width="0" IsDisplay="true"></Column>
<Column Field="Demo_WH_MateriallId" FieldType="VarChar" CaptionText="物料名称" EditType="Dropdown" Width="100" Enabled="No">
<Map Mode="ParentTable">
<ParentTable Name="Demo_WH_Materiall" PTText="Caption" PTValue="Demo_WH_MateriallId"/>
</Map>
</Column>
<Column Field="InNumber" FieldType="Int32" CaptionText="数量" EditType="TextBox" Width="60" IsDisplay="true"></Column>
<Column Field="CreatedBy" FieldType="VarChar" CaptionText="入库人" EditType="Dropdown" Enabled="Yes" Width="60" Default="{@sysuserid}">
<Map Mode="ParentTable">
<ParentTable Name="SysUser" PTText="FullName" PTValue="SysUserId"/>
</Map>
</Column>
<Column Field="CreatedOn" FieldType="DateTime" CaptionText="入库时间" EditType="TextBox" Enabled="No" Width="120" Default="{@now}" DataFmt="yyyy-MM-dd HH:mm:ss"></Column>
<DataSource Type="SqlServer">
<![CDATA[
select * from Demo_WH_InEntry where Demo_WH_InId='{@Request['ParentId']}'
]]>
</DataSource>
<DataSource Type="Oracle">
<![CDATA[
select * from Demo_WH_InEntry where Demo_WH_InId='{@Request['ParentId']}'
]]>
</DataSource>
</RightPart>
<Buttons>
<Button Target="Grid" RuleName="" Name="cmd确定" Text="确定" ToolTip="确定" Type="Button" Image="WebToolBar/16_Setting.gif" DisplayMode="TextAndImage" Script="wm.c.multiSelectSave()" />
<Button Target="Grid" RuleName="" Name="cmd取消" Text="取消" ToolTip="取消" Type="Button" Image="WebToolBar/16_Setting.gif" DisplayMode="TextAndImage" Script="wm.c.formClose(false)" />
</Buttons>
<Scripts>
<Script Type="Grid">
<![CDATA[
]]>
</Script>
</Scripts>
</Choose>
</ChooseList>
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
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
- 注意事项：
要求左边网格与右边网格配置列一致。
例-大数据量的左右选页面
概述
大数据量左右选配置：
调用的是MultiSelect.aspx页面。左右两边都是网格，左边网格启用分页。
参数
//设置用户角色
function SetUserRole(){
var grid = window[__gridId];
var scRows=grid.getDoRows(true,"请先选中要维护的数据！");
if(!scRows)
return;
var id=scRows[0].idd;
var json1 = {choose:"multiselect",choose:"SysUserRole",parentId:id,fKField:"外键Id名称",urlParam:{param1:"aaa",param2:"bbb"},width:"800px",height:"500px"};
wm.c.commonOpenMultiselect(json1);
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
示例
这个例子说明，怎么配置大数据量左右选，用到配置组合查询。启用左边网格分页。
1.在ToolBar节点下的Scripts/Script节点增加js
//设置用户角色
function SetUserRole(){
var grid = window[__gridId];
var scRows=grid.getDoRows(true,"请先选中要维护的数据！");
if(!scRows)
return;
var id=scRows[0].idd;
var json1 = {choose:"multiselect",choose:"SysUserRole",parentId:id,fKField:"外键Id名称",urlParam:{param1:"aaa",param2:"bbb"},width:"800px",height:"500px"};
wm.c.commonOpenMultiselect(json1);
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
2.工具栏配置：
<Button Target="Grid" Name="cmd查看" Text="设置用户角色" ToolTip="设置用户角色" Type="Normal" Image="WebToolBar/16_Setting.gif" DisplayMode="TextAndImage" Script="SetUserRole()" >
</Button>;
1
2
3
4
5
2
3
4
5
3.Choose节点配置：
<!--设置用户角色-->
<Choose Name="SysUserRole" Title="角色用户设置"
ChooseKeyField="SysUserId" HasCheck="true"
HasRadio="False" HasTree="False" FilterCol="SysBusinessUnitId" HasQuery="true" >
<Query Name="Demo_WH_Materiall" ColCount="2" AutoWidth="false">
<Column Field="SysBusinessUnitId" FieldType="VarChar" CaptionText="部门" EditType="DropdownTree" FilterType="Equal" Width="200" IsVirtual="true" FilterDepth="-1">
<Map Mode="DataSource">
<DataSource Type="SqlServer">
<![CDATA[
select SysBusinessUnitId,Caption,s.ParentSysUnitId from (select SysBusinessUnitId,Caption,DisplayOrder from SysBusinessUnit where IsDisabled<>'1' and IsDeleted<>'1') t left join SysUnitRelation s on s.ChildSysUnitId=t.SysBusinessUnitId order by DisplayOrder,Caption
]]>
</DataSource>
<DataSource Type="Oracle">
<![CDATA[
select SysBusinessUnitId,Caption,s.ParentSysUnitId from (select SysBusinessUnitId,Caption,DisplayOrder from SysBusinessUnit where IsDisabled<>'1' and IsDeleted<>'1') t left join SysUnitRelation s on s.ChildSysUnitId=t.SysBusinessUnitId order by DisplayOrder,Caption
]]>
</DataSource>
</Map>
</Column>
<Column Field="FullName" FieldType="VarChar" CaptionText="用户名称" EditType="Textbox" FilterType="Like" Width="200">
</Column>
</Query>
<LeftPart TableName="SysUserRole" Align="left" HasCheckBox="true" Title="角色用户设置"
Simple="true" PageSize="100" HasStatusBar="true"
>
<Column Field="SysUserRoleId" FieldType="varchar" Caption="Id" EditType="Textbox" IsDisplay="False" IsKeyValue="True" ></Column>
<Column Field="SysRoleId" FieldType="varchar" Caption="角色Id" EditType="Textbox" IsDisplay="False" ></Column>
<Column Field="FullName" FieldType="varchar" Caption="用户名称" EditType="Textbox" ></Column>
<Column Field="SysUserId" FieldType="varchar" Caption="用户Id" EditType="Textbox" IsDisplay="True" Width="0"></Column>
<DataSource Type="SqlServer">
<![CDATA[
select '' as SysUserRoleId,
--su.SysRoleId,
FullName,
'' SysRoleId,
u.SysUserId as SysUserId
from SysUser u --left join SysUserRole su on u.sysuserid=su.sysuserid
where SysUserId not in
(
select distinct SysUserId from SysUserRole ur2 where SysRoleId in ('@SelectedUserId')
and '{@ispostback}'='0' and ur2.SysUserId is not null
union all
select distinct u2.SysUserId from SysUser u2 where u2.SysUserId in ('{@Request['ChooseKeys']}')
and '{@ispostback}'='1' and u2.SysUserId is not null
)
and
(
'{@Search['SysBusinessUnitId']}'=''
or SysUserId in(
select distinct SysUserId from SysUserUnit ur2
where --SysBusinessUnitId in ('{@Search['SysBusinessUnitId']}')
'{@Search['SysBusinessUnitId']}' like '%'+SysBusinessUnitId+'%'
and ur2.SysUserId is not null
)
)
and isdeleted<>'1'
]]>
</DataSource>
<DataSource Type="Oracle">
<![CDATA[
select '' as SysUserRoleId,
--su.SysRoleId,
FullName,
'' SysRoleId,
u.SysUserId as SysUserId
from SysUser u --left join SysUserRole su on u.sysuserid=su.sysuserid
where SysUserId not in
(
select distinct SysUserId from SysUserRole ur2 where SysRoleId in ('@SelectedUserId')
and '{@ispostback}'='0' and ur2.SysUserId is not null
union all
select distinct ur2.SysUserId from SysUser ur2 where upper(ur2.SysUserId) in ('{@Request['ChooseKeys']}')
and '{@ispostback}'='1' and ur2.SysUserId is not null
)
and
(
'{@Search['SysBusinessUnitId']}' is null
or SysUserId in(
select distinct ur2.SysUserId from SysUserUnit ur2
where --SysBusinessUnitId in ('{@Search['SysBusinessUnitId']}')
'{@Search['SysBusinessUnitId']}' like '%' || ur2.SysBusinessUnitId || '%'
and ur2.SysUserId is not null
)
)
and isdeleted<>'1'
]]>
</DataSource>
</LeftPart>
<RightPart TableName="SysUserRole" Title="bbbb">
<Column Field="SysUserRoleId" FieldType="varchar" Caption="Id" EditType="Textbox" IsDisplay="False" IsVirtual="false"></Column>
<Column Field="SysRoleId" FieldType="varchar" Caption="角色Id" EditType="Textbox" IsDisplay="False" IsVirtual="false"></></Column>
<Column Field="FullName" FieldType="varchar" Caption="用户名称" EditType="Textbox" IsVirtual="true"></>
</Column>
<Column Field="SysUserId" FieldType="varchar" Caption="用户Id" EditType="Textbox" IsDisplay="True" Width="0" IsVirtual="false"></Column>
<DataSource Type="SqlServer">
<![CDATA[
select '' as SysUserRoleId,
SysUserId,
FullName,
'' as SysRoleId
from SysUser
where SysUserId in
(
select distinct ur.SysUserId from SysUserRole ur where ur.SysRoleId in ('@SelectedUserId')
and ur.SysUserId is not null
)
and isdeleted<>'1'
]]>
</DataSource>
<DataSource Type="Oracle">
<![CDATA[
select '' as SysUserRoleId,
SysUserId,
FullName,
'' as SysRoleId
from SysUser
where SysUserId in
(
select distinct ur.SysUserId from SysUserRole ur where ur.SysRoleId in ('{@SelectedUserId')
and ur.SysUserId is not null
)
and isdeleted<>'1'
]]>
</DataSource>
</RightPart>
<OKButton Caption="保存" Script="OKBUTTONFUN()">
<![CDATA[
function OKBUTTONFUN()
{
wm.c.multiSelectSave();
}
]]>
</OKButton>
</Choose>
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
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
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
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
4.注意事项
1)数据源里可以用到urlParam传过来的参数，如当前的
{@request[param1
]},
同时支持[{@Search'字段']}伪变量
2)Choose节点配置属性 ChooseKeyField="左右两边关联字段" 如ChooseKeyField="SysUserId"
3)LeftPart节点要配置属性Simple="true" HasQuery="True" PageSize="100" HasStatusBar="true"启用左边网格的分页
4)抓取数据并保存用multiSelectSave访求 如
//保存角色用户
function OKBUTTONFUN(){
wm.c.multiSelectSave();
}
相关链接
左右选基础配置