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"> </td> <td> </td> <td id="table_style" class="r_t"> </td> </tr> <tr>