2012年11月2日21:59:36

自己写的sql学习记录：

<!-- 查询机构下面地址的组织订购的报刊数量的排名 -->

<select id="select.DifferentiationDisplayManageDaoImpl.getCustomersOfDifferentiationData" 

parameterClass="String" resultClass="DifferDisplayBean">

select a.*,t3.c_dz from

(select count(t.id) as num,t2.c_y as y ,t2.c_x as x,min(t2.id) as id from t

left outer join  t2 on t2.c_jgid = t.c_jgid

 where t.c_jgid >0 and t2.c_x>0 and t2.c_xzqh = #n_jgdh#

 group by t2.c_x,t2.c_y )a

 left outer join  t_company t3 on t3.id = a.id

 order by num

</select>

 

//延迟加载 之后的使用计算显示extend

public function getExtentForMapToShow(timerLoop:TimerLoop,arr:Array,map:Map):void{

if(arr ==null||arr.length==0){return;}

popupProgressBar(true);

var extent:Extent = getExtent(arr);

var time:int = arr.length/timerLoop.scope+1;

map.extent = extent;

setTimeout(function():void{

popupProgressBar(false);

},timerLoop.delay*time);

}

private function getExtent(arr:Array):Extent{

var extent:Extent = new Extent();

extent.xmax = arr[0].x;

extent.xmin = arr[0].x;

extent.ymax = arr[0].y;

extent.ymin = arr[0].y;

for(var m:int = 0; m < arr.length; m++)

{

if(arr[m].x>extent.xmax){

extent.xmax = arr[m].x;

}

if(arr[m].y>extent.ymax){

extent.ymax = arr[m].y;

}

if(arr[m].x<extent.xmin){

extent.xmin = arr[m].x;

}

if(arr[m].y<extent.ymin){

extent.ymin = arr[m].y;

}

}

return extent;

}

 

 

这一周一看基本上没有写什么有营养的代码，哎