0 and id=".$ICD_ID;
}
elseif ($searchTXT!=""){
$sqlWhere=" from ICD10 where ICDState>0 and (icd_code like '%".$searchTXT."%' or icd_name like '%".$searchTXT."%' or zjm like '%".$searchTXT."%')";
}else{
$sqlWhere=" from ICD10 where ICDState>0";
}
//组成计算总页数SQL
$total_sql = "select id $sqlWhere";
//组成显示结果SQL
$Result_sql = "select id,icd_code,icd_name,zjm,ICDState,row_number() over (order by id desc) n $sqlWhere";
//附加结果SQL
$Additional_sql = "";
//计算总页数
$data = sqlsrv_query( $conn, $total_sql, array(), array( "Scrollable" => 'keyset' ));
if($data == true){$total_records=sqlsrv_num_rows($data);}else{$total_records=0;}//总行数
$total_page=ceil($total_records/$page_size); //总页数
//避免page小于0或大于总页数
$page=$page<=0?1:$page;
$page=$page>$total_page?$total_page:$page;
//计算开始和结束行数
$pageStart = ($page-1)*$page_size;
$pageEnd = $pageStart+$page_size;
$sqlPage = " where sqlData.n > $pageStart and sqlData.n <= $pageEnd " ;
$sql = "select * $Additional_sql from ($Result_sql) sqlData ".$sqlPage." order by sqlData.n" ;
$data = sqlsrv_query($conn,$sql);
if($data == true){
if (sqlsrv_rows_affected($data)==0) {
$SystemMessageType=2;
$SystemMessageTXT="数据库中相关无数据!";
$y=0;
}
}else{$SystemMessageType=4;$SystemMessageTXT="数据库中相关无数据!";}
?>
=1) {?>
$total_records) {$ShowingMax=$total_records;}
?>
1) {?>
-
« 上页";
}else{
echo "
- « 上页 "; } $acc4=0; for($i=1;$i<=$total_page;$i++) { if ($i==$page) {echo "
- $i ";} elseif ($i<=3 or $i>($total_page-3) ) {echo "
- $i ";} elseif ($acc4==0){echo "
- ... ";$acc4=$i<$page ? 1 : 2;} elseif ($acc4==1 and $i>$page+3){echo "
- ... ";$acc4=2;} elseif ($acc4==1 and $i>=$page-3){echo "
- $i ";} } if ($page>=$total_page) { echo "
- 下页 » "; }else{ echo "
- 下页 » "; } ?>