页面历史

function main(spreadsheetReport, editingCellPosition) {
    var row = editingCellPosition.row;
    var col = editingCellPosition.column;
    //执行sql，获取序号
    var newIdValue = getSqlResult();
    //为新增的一行序号单元格赋值
    
    //判断当前编辑的是否是"序号"所在的列，从0开始，所以B列的列序号是1
    if(col==1){
    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.资源库_业务库","select max(f_ContactID) + 1 as t from  contacts", 1000,true,false]);
    if (ret.succeeded && ret.result) {
        var data = ret.result.data;
        return data[0][0].value;
    }
};