Пример #1
0
function getlab()
{
    $gsql = new Dedesql(false);
    $query = "select * from #@__lab";
    $gsql->setquery($query);
    $gsql->execute();
    $rowcount = $gsql->gettotalrow();
    if ($rowcount == 0) {
        return "没有仓库,请添加";
    } else {
        echo "<select name='labid'>";
    }
    while ($row = $gsql->getarray()) {
        if ($row['l_default']) {
            echo "<option selected value='" . $row['id'] . "'>" . $row['l_name'] . "</option>";
        } else {
            echo "<option value='" . $row['id'] . "'>" . $row['l_name'] . "</option>";
        }
    }
    echo "</select>";
    $gsql->close();
}
    $bsql = new Dedesql(false);
    $query = "update #@__basic set cp_number='" . $cp_number . "',cp_tm='" . $cp_tm . "',cp_name='" . $cp_name . "',cp_gg='" . $cp_gg . "',cp_categories='" . $cp_categories . "',cp_categories_down='" . $cp_categories_down . "',cp_dwname='" . $cp_dwname . "',cp_jj='" . $cp_jj . "',cp_sale='" . $cp_sale . "',cp_saleall='" . $cp_saleall . "',cp_sdate='" . $cp_sdate . "',cp_edate='" . $cp_edate . "',cp_gys='" . $cp_gys . "',cp_helpword='" . $cp_helpword . "',cp_bz='" . $cp_bz . "' where id='{$id}'";
    $bsql->ExecuteNoneQuery($query);
    showmsg('成功修改了产品基本信息', 'system_basic_cp.php?action=seek');
    $loginip = getip();
    $logindate = getdatetimemk(time());
    $username = str_replace($cfg_cookie_encode, '', $_COOKIE['VioomaUserID']);
    WriteNote('修改产品基本信息' . $cp_name . ' 成功', $logindate, $loginip, $username);
    $bsql->close();
    exit;
}
$seekrs = new Dedesql(falsh);
$squery = "select * from #@__basic where id='{$id}'";
$seekrs->SetQuery($squery);
$seekrs->Execute();
$rowcount = $seekrs->gettotalrow();
if ($rowcount == 0) {
    Showmsg('非法的参数', '-1');
    exit;
}
$row = $seekrs->GetOne();
$seekrs->close();
?>
<body onload="form1.cp_tm.focus()">
<table width="100%" border="0" id="table_style_all" cellpadding="0" cellspacing="0">
  <tr>
    <td id="table_style" class="l_t">&nbsp;</td>
    <td>&nbsp;</td>
    <td id="table_style" class="r_t">&nbsp;</td>
  </tr>
  <tr>