function getFenyePage($fenyePage){
$sqlHelper=new SqlHelper();
$sql1="select * from empmanage limit "
.($fenyePage->pageNow-1)*$fenyePage->pageSize.",".$fenyePage->pageSize;
$sql2="select count(id) from empmanage";
$sqlHelper->execute_dql_fenye($sql1,$sql2,$fenyePage);
$sqlHelper->close_connect();
}
function getFenyePage($fenyePage)
{
// 创建一个SqlHelper对象实例
$sqlHelper = new SqlHelper();
//根据查询条件构造sql语句
$sql1 = "select * from t_Nation where 1=1";
$sql2 = "select count(nationId) from t_Nation where 1=1";
$condition = "";
$sql1 = $sql1 . $condition . " limit " . ($fenyePage->pageNow - 1) * $fenyePage->pageSize . "," . $fenyePage->pageSize;
$sql2 = $sql2 . $condition;
//调用数据层执行查询操作
$sqlHelper->execute_dql_fenye($sql1, $sql2, $fenyePage);
$sqlHelper->close_connect();
}
function getFenyePage($fenyePage, $zkzh, $name, $kslb, $nation, $byxx, $hkszd, $address, $telephone, $cardNumber, $xjh)
{
// 创建一个SqlHelper对象实例
$sqlHelper = new SqlHelper();
//根据查询条件构造sql语句
$sql1 = "select * from t_StudentInfo where 1=1";
$sql2 = "select count(zkzh) from t_StudentInfo where 1=1";
$condition = "";
if ($zkzh != "") {
$condition = $condition . " and zkzh like '%{$zkzh}%'";
}
if ($name != "") {
$condition = $condition . " and name like '%{$name}%'";
}
if ($kslb != "") {
$condition = $condition . " and kslb like '%{$kslb}%'";
}
if ($nation != "") {
$condition = $condition . " and nation={$nation}";
}
if ($byxx != "") {
$condition = $condition . " and byxx like '%{$byxx}%'";
}
if ($hkszd != "") {
$condition = $condition . " and hkszd like '%{$hkszd}%'";
}
if ($address != "") {
$condition = $condition . " and address like '%{$address}%'";
}
if ($telephone != "") {
$condition = $condition . " and telephone like '%{$telephone}%'";
}
if ($cardNumber != "") {
$condition = $condition . " and cardNumber like '%{$cardNumber}%'";
}
if ($xjh != "") {
$condition = $condition . " and xjh like '%{$xjh}%'";
}
$sql1 = $sql1 . $condition . " limit " . ($fenyePage->pageNow - 1) * $fenyePage->pageSize . "," . $fenyePage->pageSize;
$sql2 = $sql2 . $condition;
//调用数据层执行查询操作
$sqlHelper->execute_dql_fenye($sql1, $sql2, $fenyePage);
$sqlHelper->close_connect();
}
