如何左部门树形右Grid设备显示部门关联设备

jishuang

1.可以不用设置主从关系，在ln_xxsbkpA中存组织相关的信息
然后在sa_oporg对应的data的onIndexChanged事件中获取到当前组织的信息给ln_xxsbkpA的关系进行过滤
/UI2/SA/OPM/organization/mainActivity.w中就是这样操作的
2.返回table给data参考
http://docs.wex5.com/bex5-ui-question-list-10069/

3.返回的是String，确认获取的值是否正确
  在给data用setValue赋值的时候要确认当前行是否存在

lwcompany

jishuang 发表于 2016-9-9 17:07
1.可以不用设置主从关系，在ln_xxsbkpA中存组织相关的信息
然后在sa_oporg对应的data的onIndexChanged事件 ...

UI2/SA/OPM/organization/mainActivity.w中就是这样操作的？？？？
这个是涉及到单表也没有两个表吧

jishuang

看data上数据过滤的处理方式，不要需要看几个表

lwcompany

再试下

lwcompany

jishuang 发表于 2016-9-9 17:07
1.可以不用设置主从关系，在ln_xxsbkpA中存组织相关的信息
然后在sa_oporg对应的data的onIndexChanged事件 ...

找了很长时间，还是没有解决，是否是下面过滤方式，急急

jishuang

在左边data的onIndexChanged事件中对右边的data设置setFilter并刷新数据

lwcompany

对右边的data设置setFilter并刷新数据？？？？？不明白这句话意思，setfilter这个方法在哪里写

lwcompany

//orgtreePC1下的orgtree  date事件中的indexchanged编程
        var orgTreeData = this.comp("orgTreeData");
        var lnxxsbkpADatadataTables this.com("lnxxsbkpADatadataTables");
         var sname = orgTreeData.getValue("sName");
             event.source.setFilter( "sname","lnxxsbkpADatadataTables.bmmc='"+sname+"'");//对右边data进行过滤
还是不好用呀
后台
public static Table xxsbkpABytree(String concept,String idColumn,String select,String from,String condition,List range,String filter,Boolean distinct,Integer offset,Integer limit,String columns,String orderBy,String aggregate,String aggregateColumns,Map variables,String dataModel,String fnModel,String fBMMC,Boolean includeInherited)
{
Table table =KSQL.select("select ln_xxsbkpA.* ,SA_OPOrg.sName as sName,ln_xxsbkpA.fBMMC as fBMMC,ln_xxsbkpA.fRKMasterID as fRKMasterID,ln_xxsbkpA.fRKRQ as fRKRQ,ln_xxsbkpA.fDWMC as fDWMC,ln_xxsbkpA.fLBMC as fLBMC,ln_xxsbkpA.fRKMC as fRKMC,ln_xxsbkpA.fJZZTMC as fJZZTMC,ln_xxsbkpA.fCWBH as fCWBH,ln_xxsbkpA.fTXM as fTXM,ln_xxsbkpA.fGG as fGG,ln_xxsbkpA.fFPSL as fFPSL,ln_xxsbkpA.fFPJE as fFPJE,ln_xxsbkpA.fSYR as fSYR,ln_xxsbkpA.fCFDD as fCFDD,ln_xxsbkpA.fRKBZ as fRKBZ  from ln_xxsbkpA ln_xxsbkpA optional  join SA_OPOrg SA_OPOrg on ln_xxsbkpA.fBMMC = SA_OPOrg.sName where SA_OPOrg.sValidState = 1" ,null,RKDataModel,null);
      table.getProperties().put(Table.PROP_NAME_ROWID,"ln_xxsbkpA");      
  return table;
}

jishuang

把.w发一下

lwcompany

define(function(require) {
var $ = require("jquery");
var justep = require("$UI/system/lib/justep");
var biz = require("$UI/system/lib/biz");
var OrgKinds = require("$UI/system/service/org/orgKinds");
var OpmUtils = require("$UI/SA/OPM/js/OpmUtils");
var Grid = require("$UI/system/components/justep/grid/grid");

    var orgsname;//后加
    var sname;//后加
var Model = function() {
  this.callParent();
  this.orgKinds = new OrgKinds(this.getContext());
};
Model.prototype.modelModelConstructDone = function(event){
    this.comp("orgKindsData").loadData(this.orgKinds.getTableData());
  this.refreshTreeData(true);
  this.refreshListData();
};
Model.prototype.orgTreeDataIndexChanged = function(event){
     var lnxxsbkpAData = this.comp("lnxxsbkpAData");
     
         lnxxsbkpAData.refreshData();
        // var sname = orgTreeData.getValue("sName");
         
           //  event.source.setFilter( "sname","lnxxsbkpADatadataTables.bmmc='"+sname+"'");//对右边data进行过滤
         
      
};

Model.prototype.orgTreeDataBeforeRefresh = function(event){
};
    Model.prototype.refreshListData = function(toOrgID){
     
       var lnxxsbkpAData = this.comp("lnxxsbkpAData");
  lnxxsbkpAData.refreshData();
  var row = lnxxsbkpAData.getRowByID(toOrgID);
  if (row) {
   lnxxsbkpAData.to(row);
  }
  
    };
Model.prototype.lnxxsbkpADataBeforeRefresh = function(event){
      
       var lnxxsbkpADatadataTables =this.com("lnxxsbkpADatadataTables");
       var orgTreeData =this.comp("orgTreeData");
       var orgTreeID = this.comp("orgTreeGrid").getSelection();
         sname = orgTreeData.getValue("sName");
         event.source.setFilter( "sname","lnxxsbkpADatadataTables.bmmc='"+sname+"'");
};
    //organization
Model.prototype.refreshTreeData = function(isRefreshAll, toOrgFID) {
  debugger;
  var orgTreeData = this.comp("orgTreeData");
  var orgTreeGrid = this.comp("orgTreeGrid");
  
  toOrgFID = toOrgFID ? toOrgFID : orgTreeData.val("sFID");
  this._treeDataRefreshing = true;
  try {
   orgTreeData.refreshData({
    "parent" : isRefreshAll ? null : orgTreeData.getCurrentRow()
   });
   
   if (toOrgFID && !Grid.isVirtualRoot(toOrgFID)) {
    orgTreeGrid.expandByIDPath(OpmUtils.orgFIDtoIDPath(toOrgFID));
   } else if (orgTreeGrid.useVirtualRoot) {
    orgTreeGrid.selectVirtualRoot();
   }
  } finally {
   this._treeDataRefreshing = false;
  }
  debugger;
};
Model.prototype.refreshListData = function(toOrgID) {
  debugger;
  var lnxxsbkpAData = this.comp("lnxxsbkpAData");
  lnxxsbkpAData.refreshData();
  var row = lnxxsbkpAData.getRowByID(toOrgID);
  if (row) {
   lnxxsbkpAData.to(row);
  }
  debugger;
};
//没有用上
    Model.prototype.isTreeLeaf = function(orgKindID){
        var children = this.orgKinds.getChildren(orgKindID);
  var index = $.inArray('psm', children);
  if (index != -1) {
   children.splice(index, 1);
  }
  return (children.length == 0);
    }

return Model;
});