日期:2014-05-17 浏览次数:20524 次
function wc1($sql){
$tb='';
$showArr=array();
$q=$this->getAll3($sql);
while ($r=$q->fetch_array(MYSQLI_USE_RESULT)) {
$tb.='<tr><td>'.$r["number"].'</td>';
$tb.=isset($this->show["customer"])?'<td>'.$r["customer"].'</td>':NULL;
$tb.=isset($this->show["orderNo"])?'<td>'.$r["orderNo"].'</td>':NULL;
}
return $tb;
}
function wc2($sql){
$tb='';
$showArr=array();
$q=$this->getAll3($sql);
while ($r=$q->fetch_array(MYSQLI_USE_RESULT)) {
$tb.='<tr><td>'.$r["number"].'</td>';
$tb.=isset($this->show["customer"])?'<td>'.$r["customer"].'</td>':NULL;
$tb.=isset($this->show["orderNo"])?'<td>'.$r["orderNo"].'</td>':NULL;
$tb.=isset($this->show["name"])?'<td>'.$r["name"].'</td>':NULL;
$tb.=isset($this->show["wc"])?'<td>'.$r["wc"].'</td>':NULL;//----------------此处有变化
}
return $tb;
}
function wc3($sql){
$tb='';
$showArr=array();
$q=$this->getAll3($sql);
while ($r=$q->fetch_array(MYSQLI_USE_RESULT)) {
$tb.='<tr><td>'.$r["number"].'</td>';
$tb.=isset($this->show["customer"])?'<td>'.$r["customer"].'</td>':NULL;
$tb.=isset($this->show["orderNo"])?'<td>'.$r["orderNo"].'</td>':NULL;
$tb.=isset($this->show["name"])?'<td>'.$r["name"].'</td>':NULL;
$tb.=isset($this->show["fsaww"])?'<td>'.$r["sfs3"].'</td>':NULL;//----------------此处有变化
}
return $tb;
}
function wc($sql){
$tb='';
$showArr=array();
$q=$this->getAll3($sql);
$dict = array('fsaww' => 'sfs3'); //这里是对照表
while ($r=$q->fetch_array(MYSQLI_USE_RESULT)) {
$tb.='<tr><td>'.$r["number"].'</td>';
foreach($this->show as $k) {
if(isset($dict[$k])) $k = $dict[$k];
$tb.='<td>'.$r[$k].'</td>';
}
}
return $tb;
}
<?php
function wc1($sql, $assoc = array()){
$tb='';
$showArr = array();
$q=$this->getAll3($sql);
while ($r=$q->fetch_array(MYSQLI_USE_RESULT)) {
$tb.='<tr><td>'.$r["number"].'</td>';
if(count($assoc)){
foreach($keys as $k => $v){
$tb .= isset($this->show[$k]) ?'<td>'.$r[$v].'</td>':NULL;
}
}
}
return $tb;
}
wc1($sql, array('customer' => 'customer', 'orderNo' => 'orderNo'));
wc1($sql, array('customer' => 'customer', 'orderNo' => 'orderNo', 'name' => 'name', 'wc' => 'wc'));
wc1($sql, array('customer' => 'customer',&n