GetOne($sqlt); if($rowt['cckt']>0){ $cckt = $rowt['cckt']; }else{ $cckt = 0; } $sqlyes="SELECT SUM( climit ) AS cckyes FROM sea_cck where status=1"; $rowyes = $dsql->GetOne($sqlyes); if($rowyes['cckyes']>0){ $cckyes = $rowyes['cckyes']; }else{ $cckyes = 0; } $sqlno="SELECT SUM( climit ) AS cckno FROM sea_cck where status=0"; $rowno = $dsql->GetOne($sqlno); if($rowno['cckno']>0){ $cckno = $rowno['cckno']; }else{ $cckno = 0; } $w=" where ckey <> '' "; $numPerPage=30; $page = isset($page) ? intval($page) : 1; if($page==0) $page=1; if ($cstatus=="1") {$w.=" and status=1";} elseif($cstatus=="0") {$w.=" and status=0";} else {$w.='';} if (!empty($climit) AND $climit != "all") {$w.=" and climit=$climit";} else {$w.='';} if($action=="search") { $ckey=$_POST['ckey']; if (!empty($ckey)) $w =" where ckey='$ckey'"; } //计算有多少条数据 $csqlStr="select count(*) as dd from sea_cck ".$w; $rowTotal = $dsql->GetOne($csqlStr); if(is_array($rowTotal)){ $TotalResult = $rowTotal['dd']; }else{ $TotalResult = 0; } $TotalPage = ceil($TotalResult/$numPerPage); if ($page>$TotalPage) $page=$TotalPage; $limitstart = ($page-1) * $numPerPage; if($limitstart<0) $limitstart=0; $sqlStr="select * from sea_cck ".$w." ORDER BY `id` DESC limit $limitstart,$numPerPage"; ?>
";} ?> SetQuery($sqlStr); $dsql->Execute('key_list'); while($row=$dsql->GetObject('key_list')) { $id=$row->id; $copy.=$row->ckey."
" ?>
 充值卡管理  【当前总金额元 已充值元 未使用元】
 生成充值卡:数量  张 
   检索:  
   卡号搜索:

 无充值卡信息

 ID 卡号 额度 生成时间 充值时间 用户 状态 操作
ckey;?> climit;?> maketime;?> usetime;?> uname;?> status=="0") echo "未使用"; else echo "已使用";?> 删除
 全选 反选      * 如果需要复制充值卡卡号,请点击显示复制面板
 页次:/ 每页 总收录数据首页 上一页 下一页 尾页  跳转