关于树形弹出框选择JS和sql的记录

主页面事件（数据接收事件）

Model.prototype.windowDialog2Receive = function(event){


// var TE_ProjectInfo = this.comp("TE_ProjectInfo");
//声明data
var mainData = this.comp("mainData");
var detailData = this.comp("detailData");

var params = new biz.Request.ActionParam();
params.setString("sIDs", event.data);
params.setString("currID",mainData.getCurrentRowID());
// 调用动作
var me = this;
biz.Request.sendBizRequest({
"context" : this.getContext(),
"action" : "Insertselectmaterialinformation",
"parameters" : params,
"callback" : function(data) {
// data.ignoreError 是否忽略默认的异常处理，默认值true
data.ignoreError = false;
// data.state 请求返回状态，标识请求是否执行成功
if (data.state) {
debugger;
mainData.saveData();
detailData.refreshData();
}
}
});
};

弹出框确定事件（选中的传到主页面）

Model.prototype.result = function(){
//实现返回的逻辑
var dialogData = this.comp("dialogData");
var grid1 = this.comp("grid1");
var sIDs = grid1.getCheckeds();

for(var i=0;i<sIDs.length;i++){
var parent = dialogData.getValueByID("fParent",sIDs[i]);
if(parent){
grid1.setRowChecked(parent,true);
}
}
var sIDs = grid1.getCheckeds();
debugger;
return sIDs;
};
Model.prototype.OKBtnClick = function(event){
this.comp('wReceiver').windowEnsure(this.result());
};

sql语句实现

public static void Insertselectmaterialinformation(String currID,String sIDs){


System.out.println(sIDs);
String uuid = CommonUtils.createGUID();
String strKsql = "select m,m.fParent as fParent,m.fMaterialType as fMaterialType,m.fNodeKind as fNodeKind,m.fTypeCode as fTypeCode from MaterCodeTable m where m in ('"+sIDs.replaceAll(",","','")+"')";


System.out.println(strKsql);
Table table = KSQL.select(strKsql, null, "/SceneTeam/ClassDoor/data", null);
Iterator<Row> rows = table.iterator();
while (rows.hasNext()) {
Row row = rows.next();
String m = row.getString("m");
String fParent = row.getString("fParent");
String fMaterialType = row.getString("fMaterialType");
String fNodeKind = row.getString("fNodeKind");
String fTypeCode = row.getString("fTypeCode");


String isExist = "select m from MasterList m where m.fZBID='"+currID+"' and m like '%"+m+"%'";
Table t = KSQL.select(isExist, null, "/SceneTeam/ClassDoor/data", null);
Iterator<Row> tRow = t.iterator();


if(tRow.hasNext()){
Row r = tRow.next();
String fid = r.getString("m");
uuid = fid.substring(0, 32);
}else{
String inKsql = "";
if("".equals(fNodeKind) || fNodeKind=="" ||fNodeKind==null|| fNodeKind=="null"){
if("".equals(fParent) || fParent=="" || fParent==null || fParent =="null"){
inKsql = "insert into MasterList t (t,t.version,t.fMaterialType,t.fParent,t.fNodeKind,t.fTypeCode,t.fZBID,t.fListType) values('"+uuid+m+"',0,'"+fMaterialType+"','','"+fNodeKind+"','"+fTypeCode+"','"+currID+"','物资发放')";
}else{
inKsql = "insert into MasterList t (t,t.version,t.fMaterialType,t.fParent,t.fNodeKind,t.fTypeCode,t.fZBID,t.fListType) values('"+uuid+m+"',0,'"+fMaterialType+"','"+uuid+fParent+"','"+fNodeKind+"','"+fTypeCode+"','"+currID+"','物资发放')";
}
}else{
if("".equals(fParent) || fParent=="" || fParent==null || fParent =="null"){
inKsql = "insert into MasterList t (t,t.version,tfMaterName,t.fParent,t.fNodeKind,t.fTypeCode,t.fZBID,t.fListType) values('"+uuid+m+"',0,'"+fMaterialType+"','','"+fNodeKind+"','"+fTypeCode+"','"+currID+"','物资发放')";
}else{
inKsql = "insert into MasterList t (t,t.version,t.fMaterName,t.fParent,t.fNodeKind,t.fTypeCode,t.fZBID,t.fListType) values('"+uuid+m+"',0,'"+fMaterialType+"','"+uuid+fParent+"','"+fNodeKind+"','"+fTypeCode+"','"+currID+"','物资发放')";
}
}
System.out.println(inKsql);
KSQL.executeUpdate(inKsql, null, "/SceneTeam/ClassDoor/data", null);


}
}
}
}