<td id="row_style"> </td> <td> <input type="submit" name="submit" value=" 添加账户 "></td> </tr></form> </table> <?php } else { echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\">"; $csql = new Dedesql(false); $csql->SetQuery("select * from #@__bank"); $csql->Execute(); $rowcount = $csql->GetTotalRow(); if ($rowcount == 0) { echo "<tr><td> 还没添加银行账户,请先<a href=bank.php?action=new>添加账户</a>。</td></tr>"; } else { echo "<tr class='row_color_head'><td>ID</td><td>银行名称</td><td>银行账号</td><td>金额</td><td>默认</td><td>备注</td><td>修改</td></tr>"; while ($row = $csql->GetArray()) { if ($row['bank_default'] == 1) { $default_yes = "<img src=images/yes.png>"; } else { $default_yes = " "; $delstring = " | <a href=bank_del.php?id=" . $row['id'] . ">删除</a>"; } echo "<tr><td>ID号:" . $row['id'] . "</td><td> " . $row['bank_name'] . "</td><td> " . $row['bank_account'] . "</td><td> ¥" . $row['bank_money'] . "</td><td> " . $default_yes . "</td><td>" . $row['bank_text'] . "</td><td><a href=bank_edit.php?id=" . $row['id'] . ">修改</a>" . $delstring . "</td></tr>"; } } echo "</table>"; $csql->close(); } ?> </td> </tr>
<head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312" /> <link href="style/main.css" rel="stylesheet" type="text/css" /> <script language="javascript" src="include/calendar.js"></script> <script language="javascript" src="include/py.js"></script> <title>产品基本信息录入</title> <script language = "JavaScript"> var onecount; onecount = 0; subcat = new Array(); <?php $count = 0; $rsql = new Dedesql(false); $rsql->SetQuery("select * from #@__categories where reid!=0"); $rsql->Execute(); while ($rs = $rsql->GetArray()) { ?> subcat[<?php echo $count; ?> ] = new Array("<?php echo $rs['categories']; ?> ","<?php echo $rs['reid']; ?> ","<?php echo $rs['id']; ?> "); <?php
function getadid($id) { $s = new Dedesql(false); $query = "select * from #@__staff"; $s->SetQuery($query); $s->Execute(); $rowcount = $s->GetTotalRow(); if ($rowcount == 0) { echo "<a href='system_worker.php?action=new'>请先添加员工</a>"; } else { echo "<select name=\"staff\"><option value=''>=请选择业务员=</option>"; while ($row1 = $s->GetArray()) { if ($id == '' || $row1['id'] != $id) { echo "<option value='" . $row1['s_name'] . "'>" . $row1['s_name'] . "</option>"; } else { echo "<option value='" . $row1['s_name'] . "' selected>" . $row1['s_name'] . "</option>"; } } echo "</select>"; } $s->close(); }
require_once dirname(__FILE__) . "/include/config_rglobals.php"; if ($id == '') { ShowMsg('非法的执行操作', 'system_class.php'); } //检测分类的等级 $username = str_replace($cfg_cookie_encode, '', $_COOKIE["VioomaUserID"]); $dsql = new Dedesql(false); $query = "select * from #@__categories where id='{$id}'"; $dsql->Setquery($query); $dsql->Execute(); $rowcount = $dsql->GetTotalRow(); if ($rowcount == 0) { //非法ID ShowMsg('执行了非法的操作', '-1'); } else { $row = $dsql->GetArray(); if ($row['reid'] == 0) { //删除顶级分类 $msql = new Dedesql(false); $msql->SetQuery("select * from #@__categories where reid='" . $row['id'] . "'"); $msql->Execute(); if ($msql->GetTotalRow() >= 1) { echo "<script language='javascript'>alert('你要删除的顶级分类下有子分类,请先删除其子分类!');history.go(-1);</script>"; } else { $msql->ExecuteNoneQuery("delete from #@__categories where id='{$id}'"); WriteNote('成功删除顶级分类' . $row['categories'], getdatetimemk(time()), getip(), $username); ShowMsg('删除分类成功', 'system_class.php'); } $msql->close(); } else { //删除子分类
} else { echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\">"; $csql = new Dedesql(false); $csql->SetQuery("select * from #@__dw where reid=0"); $csql->Execute(); $rowcount = $csql->GetTotalRow(); if ($rowcount == 0) { echo "<tr><td> 系统里还没有任何计量单位,请先<a href=system_dw.php?action=new>添加基本计量单位</a>。</td></tr>"; } else { echo "<tr class='row_color_head'><td>ID</td><td>名称</td><td>操作</td></tr>"; while ($row = $csql->GetArray()) { echo "<tr><td>ID号:" . $row['id'] . "</td><td><img src=images/cate.gif align=absmiddle> " . $row['dwname'] . "</td><td><a href=system_dw_edit.php?id=" . $row['id'] . ">修改</a> | <a href=system_dw_del.php?id=" . $row['id'] . ">删除</a></td></tr>"; $csql1 = new Dedesql(false); $csql1->SetQuery("select * from #@__dw where reid='" . $row['id'] . "'"); $csql1->Execute(); while ($row1 = $csql1->GetArray()) { echo "<tr class='row_color_gray'><td> ID号:" . $row1['id'] . "</td><td> ├ " . $row1['dwname'] . "</td><td><a href=system_dw_edit.php?id=" . $row1['id'] . ">修改</a> | <a href=system_dw_del.php?id=" . $row1['id'] . ">删除</a></td></tr>"; } $csql1->close(); } } echo "</table>"; $csql->close(); } ?> </td> </tr> </table> </td> <td> </td> </tr>