...
var p1 = spreadsheetReport.paramPanelObj.findParamByName( 'DeptTree' ); var p2 = spreadsheetReport.paramPanelObj.findParamByName( '日期' ); var util = jsloader.resolve( "freequery.common.util" ); //删除已有的汇总 var sql = "delete from factyear where dateid='" + p2.value + "' and deptid='" + p1.value + "'" ; var ret = util.remoteInvoke( "DataSourceService" , "executeUpdate" , [ "DS.回写" , sql]); if (ret && ret.succeeded) { //计算汇总 var sql = "insert into factyear (deptid,dateid,metricid,val) " + "select '" + p1.value + "','" + p2.value + "',metricid,sum(val) " + " from factyear where dateid='" + p2.value + "' and deptid<>'" + p1.value + "' group by metricid " ; var ret = util.remoteInvoke( "DataSourceService" , "executeUpdate" , [ "DS.回写" , sql]); if (ret && ret.succeeded) { spreadsheetReport.doRefresh(); return true ; } } |