诊断情况标签
  • 新建
  • 修改
  • 删除
  新建诊断情况

国际ICD编码:

疾病名称:

助记码:
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="数据库中相关无数据!";} ?>
"; } ?>
ID 国际ICD编号 疾病名称 助记码 状态  
 
       
=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 "
  • 下页 »
  • "; } ?>