$result = mysql_query($insertSql);
echo "<script>alert('修改成功！');window.parent.leftFrame.window.location.reload();window.location='../menu/menu.php?id=" . $id . "'</script>";
} else {
if ($type == "delete") {
$sql = "select * from menu where pid = {$id}";
$result = mysql_query($sql);
if (mysql_num_rows($result) > 0) {
echo "<script>alert('该目录下还有子目录，不能进行删除操作！');window.location='{$link}?id={$id}'</script>";
return false;
}
deleteTableById($tablename, $id);
echo "<script>alert('删除成功！');window.parent.leftFrame.window.location.reload();window.location='{$link}?id={$pid}'</script>";
} else {
if ($type == "setmenu") {
if ($id) {
deleteTableById("menuset", $id);
}
$imageCount = 1;
$textCount = 1;
$dateCount = 1;
$clobCount = 1;
$fileCount = 1;
$mediaCount = 1;
$sort = $_POST["sort"];
$title = $_POST["title"];
$col_type = $_POST["col_type"];
$isIndex = $_POST["isIndex"];
while (list($key, $row) = each($title)) {
switch ($col_type[$key]) {
case "P":
$col_name = "text" . $textCount++;
$result = mysql_query(str_replace("#tablename#", $tablename, $tableRowSql));
$i = 0;
while ($row = mysql_fetch_object($result)) {
$insertSql = $insertSql . ($i == 0 ? "" : ",") . $row->columnname . " = " . ($_POST[$row->columnname] == null ? "null" : "'" . $_POST[$row->columnname] . "'");
$i++;
}
$insertSql = $insertSql . " where id ={$id}";
//print $insertSql;
$result = mysql_query($insertSql);
if (!$result) {
throw new Exception("错误！，sql为：{$insertSql}");
}
echo "<script>alert('修改成功！');window.location='{$link}" . (substr_count($link, "?") == 0 ? "?" : "&") . "pageNo={$pageNo}'</script>";
} else {
if ($type == "delete") {
deleteTableById($tablename, $id);
echo "<script>alert('删除成功！');window.location='{$link}" . (substr_count($link, "?") == 0 ? "?" : "&") . "pageNo={$pageNo}'</script>";
} else {
if ($type == "ajax") {
$sql = stripcslashes($_REQUEST["sql"]);
$result = mysql_query($sql);
if (!$result) {
throw new Exception("错误！，sql为：{$sql}");
}
$returnList = array();
while ($row = mysql_fetch_object($result)) {
array_push($returnList, $row);
}
echo json_encode(object_decode($returnList));
}
}
