function main(spreadsheetReport) {
var list = spreadsheetReport.getExpandedPositions("B4"); //获取【删除】字样的所有单元格
for (var i = 0; i < list.length; i++) {
var pos = spreadsheetReport.parseCellIndex(list[i]);//获取坐标
var td = spreadsheetReport.getCell(pos[0], pos[1]); //获取单元格
td.style.cursor = "pointer"; //鼠标变手
td.toDeleteCell = pos[0];
td.onclick = function() {
var modalWindow = jsloader.resolve("freequery.common.modalWindow");
var flag = confirm("确认删除吗?");
if (flag) {
//实际上允许删除的单元格,在这个例子中是C4这个单元格,所以使用2作为列,从0 开始数,需要根据实际情况修改
spreadsheetReport.spreadsheetReportWriteBack.currentEditingPosition = this.toDeleteCell + ":2";
//用下面这些代码不用点击保存,就能直接删除数据
var util = jsloader.resolve("freequery.common.util");
var id=spreadsheetReport.getCell(this.toDeleteCell, 2).innerText; //获取id
var ret = util.remoteInvoke("DataSourceService", "executeUpdate", ["DS.writeback", "delete from user where id='"+id+"'"]); //执行删除数据的sql
if (ret.succeeded){
alert("删除成功");
} else {
alert("删除失败");
}
spreadsheetReport.doRefresh();//刷新报表
}
}
}
}