public function ChangePassword($username, $oldPassword, $newPassword)
{
$result = false;
$sql = "select password from t_admin where username='******'";
//创建一个SqlHelper对象
$sqlHelper = new SqlHelper();
$res = $sqlHelper->execute_dql($sql);
if ($row = mysql_fetch_assoc($res)) {
//比对密码
if (md5($oldPassword) == $row['password']) {
$sql = "update t_admin set password='******' where username='******'";
if ($sqlHelper->execute_dml($sql) != 0) {
$result = true;
} else {
$this->errMessage = "更新失败！";
}
} else {
$this->errMessage = "原始密码不正确";
}
}
//资源
mysql_free_result($res);
//关闭链接
$sqlHelper->close_connect();
return $result;
}
function getEmpListByPage($pageNow, $pageSize)
{
$strNum = ($pageNow - 1) * $pageSize;
$sql = "select * from emp limit {$strNum},{$pageSize}";
$sqlHelper = new SqlHelper();
$re = $sqlHelper->execute_dql($sql);
// $sqlHelper->close_conn();
return $re;
}
public function getPageCount($pageSize)
{
$sql = "select count(id) from student";
$sqlHelper = new SqlHelper();
$res = $sqlHelper->execute_dql($sql);
//calcute
if ($row = mysql_fetch_row($res)) {
$pageCount = ceil($row[0] / $pageSize);
}
//free
return $pageCount;
}
public function checkAdmin($id, $password)
{
$sql = "select password,name from admin where id={$id}";
$sqlhelper = new SqlHelper();
$res = $sqlhelper->execute_dql($sql);
if ($row = mysqli_fetch_assoc($res)) {
if (md5($password) == $row['password']) {
return true;
}
}
mysqli_free_result($res);
$sqlhelper->close_conn();
return false;
}
public function getPagecount($pagesize)
{
$sql = "select count(id) from emp";
$sqlHelper = new SqlHelper();
$res = $sqlHelper->execute_dql($sql);
if ($row = mysql_fetch_row($res)) {
$pagecount = ceil($row[0] / $pagesize);
}
//关闭资源
mysql_free_result($res);
//关闭连接
$sqlHelper->close_connect();
return $pagecount;
}
function getPageCount($pageSize)
{
//查询rowcout
$sql = "select count(id) from brand_wyeth_customer";
$sqlhelper = new SqlHelper();
$res = $sqlhelper->execute_dql($sql);
//计算pagecount
if ($row = mysql_fetch_row()) {
$pagecount = ceil($row[0] / $pageSize);
}
//释放资源关闭链接
mysql_free_result($res);
mysql_close();
return $pagecount;
}
function getPageCount($pageSize)
{
//需要查询$rowCount
$sql = "select count(id) from emp";
$sqlHelper = new SqlHelper();
$res = $sqlHelper->execute_dql($sql);
//这样就可以计算$pageCount
if ($row = mysql_fetch_row($res)) {
$pageCount = ceil($row[0] / $pageSize);
}
//释放资源关闭链接
mysql_fetch_row($res);
$sqlHelper->close_connect();
return $pageCount;
}
public function checkAdmin($id, $password)
{
$sql = "select password,name from userlogin where id={$id}";
$sqlHelper = new SqlHelper();
$res = $sqlHelper->execute_dql($sql);
if ($row = mysql_fetch_assoc($res)) {
if (md5($password) == $row['password']) {
return $row['name'];
}
}
//关闭资源
mysql_free_result($res);
//关闭连接
$sqlHelper->close_connect();
return "";
}
public function chekcAdimn($id, $password)
{
$sql = "select password,name from admin where id={$id}";
//创建一个SqlHelper对象
$sqlHelper = new SqlHelper();
$res = $sqlHelper->execute_dql($sql);
if ($row = mysql_fetch_assoc($res)) {
//比对密码
if (md5($password) == $row['password']) {
return $row['name'];
}
}
//释放资源
mysql_free_result($res);
//关闭链接
$sqlHelper->close_connect();
return "";
}
public function checkAdmin($id, $password)
{
$sql = "select password,name from admin where id={$id}";
//????SqlHelper??
$sqlHelper = new SqlHelper();
$res = $sqlHelper->execute_dql($sql);
if ($row = mysql_fetch_assoc($res)) {
//????
if (md5($password) == $row['password']) {
return $row['name'];
}
}
//????
mysql_free_result($free);
//????
$sqlHelper->close_connect();
return false;
}
function getMessage($getter, $sender)
{
$sql = "select * from messages where getter='{$getter}' and sender='{$sender}' and isGet=0";
//注意此处的sql语句中sender=“$getter”；是加引号的
//file_put_contents("C:/wamp/www/testinfo.log","sql=".$sql."\r\n", FILE_APPEND);
$sqlhelper = new SqlHelper();
$array = $sqlhelper->execute_dql($sql);
//dql返回的是数组
$mesInfo = "<mes>";
for ($i = 0; $i < count($array); $i++) {
$row = $array[$i];
$mesInfo .= " <mesId>{$row['id']}</mesId>\n\t\t\t\t\t\t <sender>{$row['sender']}</sender>\n\t\t\t\t\t\t <getter>{$row['getter']}</getter>\n\t\t\t\t\t\t <content>{$row['content']}</content>\n\t\t\t\t\t\t <sendTime>{$row['sendTime']}</sendTime>";
}
$mesInfo .= "</mes>";
$sqll = "update messages set isGet=1 where getter='{$getter}' and sender='{$sender}'";
// file_put_contents("C:/wamp/www/testinfo.log","sql=".$sql."\r\n", FILE_APPEND);
$sqlhelper->execute_dml($sqll);
//file_put_contents("C:/wamp/www/testinfo.log", $mesInfo."\r\n",FILE_APPEND);
$sqlhelper->close_connect();
return $mesInfo;
}
$sqlHelper = new SqlHelper();
echo '<div class="header" style="height: 50px; position: absolute; background-color: black; width: 100%;">
<a href="javascript:" class="user" target="contentFrame" style="float:right; margin-right:20px; margin-top:-1px; "><img src="images/user.png" title="用户设置" ></a>
<a href="api/search.php" target="contentFrame" style="float:right; margin-right:10px; "><img src="images/search15.png" title="搜索"></a>
<span style="float:right; font-size:13px; margin-top:25px; margin-right:25px;">欢迎，';
echo $username;
echo '！</span>
</div>
<div class="container demo-1">
<div class="column">';
for ($j = 1; $j <= 6; $j++) {
for ($m = 1; $m <= 6; $m++) {
$sql = "select id,name from sys where jizu={$j} and mainsys={$m}";
$res[$j][$m] = $sqlHelper->execute_dql($sql);
$row_cnt[$j][$m] = $res[$j][$m]->num_rows;
$height[$j][$m] = ($row_cnt[$j][$m] / 4 + 2) * 50;
}
}
for ($m = 7; $m <= 9; $m++) {
$sql = "select id,name from sys where jizu=7 and mainsys={$m}";
$res[7][$m] = $sqlHelper->execute_dql($sql);
$row_cnt[7][$m] = $res[7][$m]->num_rows;
$height[7][$m] = ($row_cnt[7][$m] / 4 + 2) * 50;
}
echo "<div id='dl-menu' class='dl-menuwrapper'>\n\t\t\t\t<button class='dl-trigger'>Open Menu</button>\n\t\t\t\t<ul class='dl-menu'>";
//1号机
echo "<li>\n\t\t\t\t\t\t<a href='#'>1号机</a>\n\t\t\t\t\t\t<ul class='dl-submenu'>\n\t\t\t\t\t\t\t<li>\n\t\t\t\t\t\t\t\t<a href='#'>1号锅炉</a>\n\t\t\t\t\t\t\t\t<ul class='dl-submenu' style='width:1000px; height:";
print $height[1][1];
echo "px;'>";
<body>
<?php
$file_to_require = realpath('api/SqlHelper.class.php');
//require "api/SqlHelper.class.php";
require_once $file_to_require;
//header("content-type:text/html;charset=utf-8");
$eid = $_GET['eid'];
//echo $e_sys;
$sqlHelper = new SqlHelper();
$sql_bp = "select * from beipin where eid={$eid}";
$sql_title = "select * from equipments where id={$eid}";
$sql_sg = "select * from shigu where eid={$eid}";
//$sql_lbj="select * from lingbujian where eid=$eid";
$res = $sqlHelper->execute_dql($sql_bp);
$res_title = $sqlHelper->execute_dql($sql_title);
$res_sg = $sqlHelper->execute_dql($sql_sg);
//$res_lbj= $sqlHelper->execute_dql($sql_lbj);
$title = $res_title->fetch_row();
echo '
<div>
<a href="equipment.php?sys=' . $title[2] . '" style="font-size:10px; " ><<返回列表</a>
<h2>';
echo $title[1];
echo '</h2>
</div>
<div class="nTab">
<!-- 标题开始 -->
<div class="TabTitle">
$eid = $xls->sheets[0]['cells'][$i][4];
$data_values .= "('{$name}','{$type}',{$num},{$eid}),";
}
$data_values = substr($data_values, 0, -1);
//去掉最后一个逗号
$query = $sqlHelper->execute_dml("insert into beipin (name,type,num,eid) values {$data_values}");
//批量插入数据表中
if ($query) {
echo '导入成功！';
} else {
echo '导入失败！';
}
}
} elseif ($action == 'export') {
//导出XLS
$result = $sqlHelper->execute_dql("select * from student");
$str = "姓名\t性别\t年龄\t\n";
$str = iconv('utf-8', 'gb2312', $str);
while ($row = $result->fetch_array()) {
$name = iconv('utf-8', 'gb2312', $row['name']);
$sex = iconv('utf-8', 'gb2312', $row['sex']);
$str .= $name . "\t" . $sex . "\t" . $row['age'] . "\t\n";
}
$filename = date('Ymd') . '.xls';
exportExcel($filename, $str);
}
function exportExcel($filename, $content)
{
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/vnd.ms-execl");
header("Content-Type: application/force-download");
<table class="sTab" style="margin:20 auto;" >
<tr>
<td>
<select name="catalog" style="line-height:30px; font-size:20px;">
<option>请选择</option>
<option value="4">设备</option>
<option value="1">备品备件</option>
<option value="2">异动单</option>
<option value="3">模拟单</option>
</select>
</td>
<td><input type="text" name="name" size="50" style="line-height:30px; font-size:20px;" /></td>
<td><input type="submit" value="搜索" class="searchBtn" style="line-height:30px; font-size:20px;"></td></tr>';
$sqlrecent = "SELECT * FROM recentsearch ORDER BY id DESC LIMIT 5";
$res = $sqlHelper->execute_dql($sqlrecent);
$row_cnt = $res->num_rows;
if ($row_cnt != 0) {
echo "<tr><td colspan='3'>最近搜索：";
while ($row = $res->fetch_array()) {
echo "<a href='searchpages.php?name=" . $row['name'] . "&catalog=" . $row['catalog'] . "'>" . $row['name'] . "</a> ";
}
echo "</td></tr>";
}
echo '</table>
</div>
</form>';
/*
if(isset($_POST['name'])){
$name=$_POST['name'];
$e_sys = $_GET['sys'];
$sqlHelper = new SqlHelper();
echo "<h2 style='text-align:center;'>设备管理</h2>";
echo '<form action="" method="post" class="addForm">
<div >
<h4 class="add" style="text-align:center;">添加</h4>
<table class="addTab" style="margin:0 auto; " >
<tr>
<td>名称：</td><td><input type="text" name="name" size="40" /><span style="color:red">*</span></td>
<td><input type="submit" value="确定" class="addBtn"></td></tr>
</table>
</div>
</form>';
$sqls = "select * from equipments where e_sys={$e_sys}";
$ress = $sqlHelper->execute_dql($sqls);
//设备编辑
$i = 1;
echo "<h4 style='text-align:center;' class='show'>编辑</h4>";
echo "<table class='gridtable' style='margin:20px auto;'><tr>";
while ($rows = $ress->fetch_row()) {
echo "<td><input type='checkbox' name='gid[]' value='{$rows['0']}' ></td><td class='editrow' id='{$rows['0']}'>";
echo $rows[1];
echo "</td>";
if ($i % 5 == 0) {
echo "</tr><tr>";
}
$i++;
}
$ress->free();
//删除按钮
echo "名称不能为空";
} else {
$sqladd = "insert into sys (name,jizu,mainsys) values ('{$name}','{$addjizu}','{$addm_sys}')";
$b = $sqlHelper->execute_dml($sqladd);
if ($b == 1) {
echo "添加成功";
} else {
echo "添加失败";
}
}
} else {
if (isset($_POST['edit'])) {
$jizu = $_POST['jizu'];
$m_sys = $_POST['sys'];
$sql = "select * from sys where jizu={$jizu} and mainsys={$m_sys}";
$res = $sqlHelper->execute_dql($sql);
//$row_cnt=$res->num_rows ;
$i = 1;
//$row_cnt = $res -> num_rows;
echo "<table class='gridtable' style='margin-left:50px;'><tr>";
while ($row = $res->fetch_row()) {
echo "<td><input type='checkbox' name='gid[]' value='{$row['0']}' ></td><td class='editrow' id='{$row['0']}'>";
echo $row[1];
echo "</td>";
if ($i % 4 == 0) {
echo "</tr><tr>";
}
$i++;
}
$res->free();
echo "</tr><tr><td colspan='4'>";
})
</script>
</head>
<body>
<?php
$file_to_require = realpath('api/SqlHelper.class.php');
require_once $file_to_require;
//header("content-type:text/html;charset=utf-8");
//require_once('api/valiuser.php');
//checkUserValidate();
$eid = $_GET['eid'];
$sqlHelper = new SqlHelper();
$sql_title = "select * from equipments where id={$eid}";
$res_title = $sqlHelper->execute_dql($sql_title);
$title = $res_title->fetch_row();
echo '
<div style="text-align: center;">
<a href="equipment.php?sys=' . $title[2] . '" style="font-size:10px; " ><<返回列表</a>
<h2 style="font-size:2.5em;">';
echo $title[1];
$res_title->free();
echo '</h2>
</div>
<div class="nTab">
<!-- 标题开始 -->
<div class="TabTitle">
<ul id="myTab0">
<li class="active" onclick="nTabs(this,0);">技术资料</li>
} elseif ($_REQUEST['act'] == 'separate') {
include_once ROOT_PATH . 'includes/lib_order.php';
require_once 'SqlHelper.php';
$sqlhelper = new SqlHelper();
$affiliate = unserialize($GLOBALS['_CFG']['affiliate']);
empty($affiliate) && ($affiliate = array());
$separate_by = $affiliate['config']['separate_by'];
$oid = (int) $_REQUEST['oid'];
$order_id = $oid;
//根据订单Id求买家id
$user_id = $sqlhelper->execute_dql1("select user_id from ydcom_order_info where order_id={$order_id}");
//第1步查询出该笔订单的能产生的佣金
$fencheng1 = 0;
$fencheng2 = 0;
//根据order_id查表ydcom_order_goods中的goods_id
$res0 = $sqlhelper->execute_dql("select goods_id,goods_price from ydcom_order_goods where order_id={$order_id} ");
while ($row0 = mysql_fetch_array($res0)) {
$goods_id = $row0[0];
$goods_price = $row0[1];
//根据goods_id查ydcom_goods中的fengcheng1,和fengcheng2;
$res02 = $sqlhelper->execute_dql("select fencheng1,fencheng2 from ydcom_goods where goods_id={$goods_id} ");
while ($row02 = mysql_fetch_array($res02)) {
$fencheng1 += $row02[0] * $goods_price;
$fencheng2 += $row02[1] * $goods_price;
}
}
//模式一分成
$i = 0;
$b1 = $sqlhelper->execute_dql1("select parent_id from ydcom_users where user_id={$user_id}");
//b1就是上家id
for (; $b1 > 0;) {
<?php
$file_to_require = realpath('api/SqlHelper.class.php');
//require "api/SqlHelper.class.php";
require_once $file_to_require;
require_once 'api/valiread.php';
//验证用户
checkUserValidate();
$grade = $_SESSION['tzgrade'];
header("content-type:text/html;charset=utf-8");
$e_sys = $_GET['sys'];
//echo $e_sys;
$sqlHelper = new SqlHelper();
$sql = "select * from equipments where e_sys={$e_sys}";
$sqltitle = "select name from sys where id={$e_sys}";
$res = $sqlHelper->execute_dql($sql);
$res1 = $sqlHelper->execute_dql($sqltitle);
//$row_cnt=$res->num_rows ;
$row1 = $res1->fetch_row();
$title = $row1[0];
$i = 1;
echo "<h2 style='text-align:center; margin-top:50px;'>{$title}</h2>";
echo "<table class='gridtable'><tr>";
while ($row = $res->fetch_row()) {
if ($grade == 1) {
echo "<td><a href=content.php?eid={$row['0']}>";
} else {
if ($grade == 2) {
echo "<td><a href=contentread.php?eid={$row['0']}>";
}
}
<?php
require_once 'SqlHelper.class.php';
header("content-type:text/html;charset=utf-8");
$eid = $_POST['eid'];
$page = intval($_POST['pageNum']);
$sqlHelper = new SqlHelper();
$sql_bp = "select * from dxjl where eid={$eid}";
$result = $sqlHelper->execute_dql($sql_bp);
$total = $result->num_rows;
//总记录数
$pageSize = 12;
//每页显示数
$totalPage = ceil($total / $pageSize);
//总页数
$startPage = $page * $pageSize;
$arr['total'] = $total;
$arr['pageSize'] = $pageSize;
$arr['totalPage'] = $totalPage;
$firstPage = "select id,dxtime,jilu,file_name from dxjl where eid={$eid} order by id asc limit {$startPage},{$pageSize}";
$query = $sqlHelper->execute_dql($firstPage);
while ($row = $query->fetch_array()) {
$arr['list'][] = array('id' => $row['id'], 'dxtime' => $row['dxtime'], 'jilu' => $row['jilu'], 'file_name' => $row['file_name']);
}
//print_r($arr);
echo json_encode($arr);
$sqlinsert = "insert into recentsearch (name,catalog) values ('{$name}','{$c}')";
$b = $sqlHelper->execute_dml($sqlinsert);
if ($c == 1) {
//查找备品
if (isset($_GET['page'])) {
$page = intval($_GET['page']);
} else {
$page = 1;
}
//获取分页
$offset = $pageSize * ($page - 1);
$prepage = $page - 1;
$nextpage = $page + 1;
//获得所有结果列数
$sqlcnt1 = "select count(*) from beipin where name like '%{$name}%'";
$rescnt1 = $sqlHelper->execute_dql($sqlcnt1);
$cntrow1 = $rescnt1->fetch_array();
$numrow1 = $cntrow1[0];
//分页取出
$sql1 = "select * from beipin where name like '%{$name}%' limit {$offset},{$pageSize}";
$res1 = $sqlHelper->execute_dql($sql1);
//总页数
$totalpage = ceil($numrow1 / $pageSize);
if ($numrow1 == 0) {
echo "<div style='text-align:center; margin-top:30px; color:red;'>找不到该结果</div>";
} else {
$i = 1;
echo "<table class='gridtable' style='margin:0 auto; line-height:30px;'>\n\t\t\t\t\t\t <tr><th width='60px;'>序号</th><th width='600px;'>名称</th><th width='200px;'>型号</th><th width='100px;'>数量</th><th width='100px;'>在装数量</th><th width='100px;'>所属设备</th></tr>\n\t\t\t\t\t\t ";
while ($row1 = $res1->fetch_array()) {
$eid1 = $row1['eid'];
$sqle1 = "select e_name from equipments where id={$eid1}";
