<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>
