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
;
}
}