finereport 填报 单元格 JS 触发 提交SQL 事件

var location = this.options.location;

var cr = FR.cellStr2ColumnRow(location);

var col = cr.col;

var row = cr.row;

var ORG_ID = contentPane.getWidgetByCell(FR.columnRow2CellStr({col: col, row: row})).getValue();

//alert(goods);

//var index=goods.indexOf(" 包材名称:");

//var goodsid=goods.substr(5,index-5);

var ORG_NAME = FR.remoteEvaluate("sql(\"FR_DW\",\"SELECT ORG_NAME FROM DIM_HR_ORG WHERE  ORG_ID="+ORG_ID+"\",1,1)");

contentPane.setCellValue(col+1,row,ORG_NAME);