分页处理

select * from (SELECT rownum as rew,t1.SALT,to_char(t1.END_TIME,'yyyy-MM-dd HH24:MI:ss') as END_TIME,t1.DEICING_SALT,t1.DEPT_ID,t2.ORGNAME,RANK() OVER(PARTITION BY t1.DEPT_ID ORDER BY t1.END_TIME) as rank FROM SNOW_STATISTICS t1 left join SNOW_ORG t2 on t2.ORGCODE = t1.DEPT_ID where status = 1 ) where rew > 0 and rew <= 4

function getmeltSnowStock(pos,size){
	var select_year = $('#select_year').val();
	var orgCode = $('#select_orgName').val();
	
	var tab1 = "<table style='width:100%;' class='table_two' cellpadding='0' cellspacing='0'>";
	tab1+= "<tbody>" +
		"<tr>"+
		  "<th></th>" +
		  "<th>录入机构</th>" +
		  "<th>防滑盐（吨）</th>" +
		  "<th>固态融雪剂（吨）</th> " +
		  "<th>液态融雪剂（吨）</th> " +
		  "<th>管理处</th>" +
		  "<th>录入人</th>" +
		  "<th>录入时间</th>" +
		  "</tr>";
	var opts = {
			cmd : "queryMeltSnowMaterial",
			meltSnowMaterial : {
				orgCode:orgCode,
				date:select_year,
				isStock:1,
				pos : pos,
				size : size
			}
	};
	
	$.ajax({
			url:"../../meltSnow",
			data: $.toJSON(opts),
			type:"post",
			dataType:"json",
			success:function(data) {
				var result = data.result;
				var reason = data.reason;
				if("OK"==result){
					if(data.meltSnowMaterialList!=null){
						if(data.meltSnowMaterialList.length>0){
							for(var i=0;i<data.meltSnowMaterialList.length;i++){
								if(data.page.pos>=4){
									value = i+4+1;
								}else{
									value = i+1;
								}
								if(i%2 == 0){
									tab1+="<tr class=\"table1-tr2 \" align=\"center\">";
								}else{
									tab1+="<tr class=\"table1-tr1 \" align=\"center\">";
								}
								var num = i+1;
								if(num==data.meltSnowMaterialList.length){
									num="";
								}
								tab1+="<td>"+num+"</td>";
								tab1+="<td>"+changeStrNull(data.meltSnowMaterialList[i].institution)+"</td>";
								tab1+="<td>"+changeNull(data.meltSnowMaterialList[i].salt)+"</td>";
								tab1+="<td>"+changeNull(data.meltSnowMaterialList[i].solidMeltSnow)+"</td>";
								tab1+="<td>"+changeNull(data.meltSnowMaterialList[i].liquidMeltSnow)+"</td>";		
								tab1+="<td>"+changeStrNull(data.meltSnowMaterialList[i].orgName)+"</td>";	
								tab1+="<td>"+changeStrNull(data.meltSnowMaterialList[i].people)+"</td>";	
								tab1+="<td>"+changeStrNull(data.meltSnowMaterialList[i].date)+"</td>";	
								tab1+="</td></tr>";
							}
						}
					}else{
						tab1+="<tr class=\"table1-tr1 \" align=\"center\">";
						tab1+="<td colspan='9'>"+"暂无信息"+"</td>";	
						tab1+="</td></tr>";
					}
					value = 0;
					tab1+="</tbody>";
					tab1+="</table>";
					$("#itemActivitytableA").html(tab1);
					if(data.page!=null){
						totalCount = data.page.totalCount;
						if(totalCount>4){
							$("#totalCountA").html("每页显示4条,共有"+totalCount+"条记录");
							$(".pageA").pagination(totalCount, {
					            num_edge_entries: 1,
					            num_display_entries: 3,
					            callback: pageselectCallback,
					            items_per_page:4,
								current_page:parseInt(opts.meltSnowMaterial.pos/4)
					        });
							$(".pageA").show();	
							$(".everyA").show();	
						}else{
							$(".pageA").hide();	
							$(".everyA").hide();	
						}
					}			
				}else{
					alert(reason);
				}
			},
			error:function(msg){
				alert(msg);
			}
		});
	
	function pageselectCallback(page_index, jq) {
		var currentpage=page_index*4;
		getmeltSnowStock(currentpage,opts.meltSnowMaterial.size);
	};
}