web控件使用--左树右表F7
简介:左边以树形结构展示分类,右边以表格显示数据
关键词:左树右表F7、自定义核算项目F7
示例1:用左树右表F7做自定义核算项目,此示例可显示多个类别,如果用自定义核算项目F7则只能显示一个类别
1、选择组件类型
2、设置树查询对象、表格查询对象
树查询对象:com.kingdee.eas.basedata.master.auxacct.app.GeneralGroupQuery
表格查询对象:com.kingdee.eas.basedata.master.auxacct.app.GeneralQuery
3、设置过滤条件
树过滤条件:
waf.parseSql.getFilter("group.id","in",["oJ0AAAAAF+UF0s0M", "oJ0AAAAAf78F0s0M"],"in")
转换后代码: {"subject":[{"left":"id","link":"in","right":["oJ0AAAAAF+UF0s0M","oJ0AAAAAf78F0s0M"]}],"mask":"#0"}
表格过滤条件:
var a = waf.parseSql.getFilter("group.id","in",["oJ0AAAAAF+UF0s0M", "oJ0AAAAAf78F0s0M"],"in"); var b = waf.parseSql.getFilter("isEnabled ","=","1"); var c = waf.parseSql.getFilter("creatorCompany.name","=","软件公司"); waf.parseSql.mergeFilter([a,b,c],"#1and#2and#3")
转换后代码: {"subject":[{"subject":[{"left":"group.id","link":"in","right":["oJ0AAAAAF+UF0s0M","oJ0AAAAAf78F0s0M"]}], "mask":"#0"},{"subject":[{"left":"isEnabled ","link":"=","right":"1"}],"mask":"#0"}, {"subject":[{"left":"creatorCompany.name","link":"=","right":"软件公司"}],"mask":"#0"}], "mask":"#1and#2and#3"}
过滤条件转换可参考:https://waf2.kingdee.com:6999/waf2help/samples/sceneCheck/wafParseSql
4、设置查询关联字段
此字段是表格查询对象与树查询对象的关联字段,在这里使用group
配置如图:
完成:
web控件使用--左树右表F7
简介:左边以树形结构展示分类,右边以表格显示数据关键词:左树右表F7、自定义核算项目F7示例1:用左树右表F7做自定义核算项目,此示例可...
点击下载文档
本文2024-09-22 20:03:04发表“eas cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-eas-111136.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章