|
版本: |
|
小版本号: |
|
|
|
数据库: |
|
服务器操作系统: |
|
应用服务器: |
|
客户端操作系统: |
|
浏览器: |
|
|
|
想实现功能:
二个表综合查询出来内容,返回到grid中,从论坛中搜索了例子,可我照着写上却行不通,请大侠指出我哪里不对。
mainActivity.trigger1Click = function(event){
debugger;
var dataModel ="/GOVOA/outfile/data";
var ksql ="SELECT T_OUTFILE.F_GUID, T_OUTFILE.F_ORGANIZATION, "
+" T_OUTFILE.F_DRAFTDEPT, T_OUTFILE.F_TITLE "
+" FROM T_OUTFILE, T_OUTPERSON"
+" WHERE T_OUTFILE.F_GUID = T_OUTPERSON.F_GUID and T_OUTFILE.f_organization='GXKFQ'"
+" ORDER BY T_OUTFILE.F_DRAFTDATE DESC, T_OUTFILE.F_OUTGOINGDATE DESC"; //sql语句已在orcl中通过,能查询出数据。
var actionParam = new justep.Request.ActionParam();
actionParam.setString("dataModel", dataModel);
actionParam.setString("ksql", ksql);
var r = justep.Request.sendBizRequest(null, null, "kqlselect1", actionParam); //走到这里说dataModel是空的,难道上面的值都没传进去?
debugger;
var table = justep.Request.getData(r.responseXML);
var columnIDs = justep.XML.getNodeText(table, "//userdata[@name='relation-alias']").split(","); //这句我不是很明白,看意思应该是调用我要显示在grid哪几列,可是从哪里设置呢?是直接在界面grid表格里自己写上吗?
debugger;
var grid = justep.xbl("grdMain").grid;
for (var i = 0; i < columnIDs.length; i++) {
if (i < grid.getColumnCount()) {
grid.columnIds[i] = columnIDs[i];
grid.setColumnLabel(i, columnIDs[i]);
// 恢复隐藏列
grid.setColumnHidden(i, false);
}
}
// 隐藏多余列
for (var i = columnIDs.length; i < grid.getColumnCount(); i++) {
grid.setColumnHidden(i, true);
}
// 初始化列
grid.initField();
var dataTest = justep.xbl("dataTest");
dataTest.loadXML(table);
};
|
|