|
|
var xm=getItemValueAsString("年度计划");
var ydjh=getItemValueAsString("月度计划");
var sql="select item_月度计划金额, item_月度计划 ,domainid from tlk_实验总额控制 where item_年度计划='"+xm+"'";
var datas = queryBySQL(sql);
var value=0;
for (var iter = datas.iterator();iter.hasNext();)
{
var data = iter.next();
if (data.getItemValueAsString("月度计划")!=ydjh)
{value = value +data.getItemValueAsDouble("月度计划金额");}
}
var aa=getItemValueAsDouble("月度计划金额");
var bb=getItemValueAsDouble("年度计划金额");
var sumValue=value+aa;
if (sumValue>= bb && sumValue!=null)
createAlert(sumValue+"sumValue 超!!"); |
|