function main(spreadsheetReport, editingCellPosition) {
var row = editingCellPosition.row;//行
var col = editingCellPosition.column;//列
//执行sql,获取序号
var newIdValue = getSqlResult();
//为新增的一行序号单元格赋值
//判断当前编辑的是否是"序号"所在的列,从0开始,所以B列的列序号是1
if (col == 1) { //这里填写的是点击插入单元格所在列
//以下col+0中的0填写的是自动赋值单元格所在列
spreadsheetReport.spreadsheetReportWriteBack.setWriteBackCellData(row + 1, col + 0, newIdValue, newIdValue); //此方法必须保证该单元格设置了填报属性
}
}
/**
* 执行SQL语句,获取结果集
*/
function getSqlResult() {
var util = jsloader.resolve("freequery.common.util");
var ret = util.remoteInvoke("DataSourceService", "execute", ["DS.writeback", "select max(id) + 1 as t from user", 1000, true, false]);
if (ret.succeeded && ret.result) {
var data = ret.result.data;
return data[0][0].value;
}
}