📄 editproduct.asp
字号:
<!--#include file="../function/connect.asp"-->
<!--#include file="../function/function.asp"-->
<%
IID=request("IID")
strsql="select * from products where product_id=" & IID
Set objRs = Server.CreateObject("adodb.recordset")
objRs.Open strsql,objConn,1,1
if not objrs.eof then
cat1_id=objrs.fields("product_cat1_id")
cat2_id=objrs.fields("product_cat2_id")
product_name=objrs.fields("product_name")
product_code=objrs.fields("product_code")
product_standard=objrs.fields("product_standard")
product_unit=objrs.fields("product_unit")
product_sale_price=objrs.fields("product_sale_price")
product_cost=objrs.fields("product_cost")
product_discount=objrs.fields("product_discount")
product_PY_code=objrs.fields("product_PY_code")
product_desc=objrs.fields("product_desc")
end if
%>
<html>
<head>
<title>添加客户</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="../cssD.css" rel=stylesheet>
<script>
function check()
{
if(document.form1.product_name.value==""){
alert("产品名不能为空");
document.form1.product_name.focus();
return false;
}
}
</script>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<table width="100%" border="1" cellspacing="0" cellpadding="2" bordercolorlight='#000000' bordercolordark='#FFFFFF'>
<form name="form1" method="post" action="../function/UpdateToDB.asp?InsertTable=products&CheckIt=product_name&ModifyID=<%=IID%>&ModifyIDName=product_id&RedirectUrl=../clients/productlist.asp" onsubmit="return check();">
<tr>
<td colspan="4" height="25" class="tablehead"> <div align="center">添加客户信息</div></td>
</tr>
<tr>
<td width="17%" height="22" nowrap><div align="right">产品大类：</div></td>
<td width="35%" height="22">
<%getSelected "product_cat1_id","select * from cat1 ","cat1_name","cat1_id",cat1_id%>
</td>
<td width="18%" height="22" nowrap><div align="right">产品小类：</div></td>
<td width="30%" height="22">
<%getSelected "product_cat2_id","select * from cat2 ","cat2_name","cat2_id",cat2_id%>
</td>
</tr>
<tr>
<td width="17%" height="22" nowrap><div align="right">产品名：</div></td>
<td height="22"> <div align="left">
<input name="product_name" type="text" class="input" id="product_name" size="30" maxlength="50" value="<%=product_name%>">
</div></td>
<td width="18%" height="22" nowrap><div align="right">产品编码：</div></td>
<td width="30%" height="22"><input name="product_code" type="text" class="input" id="product_code" size="30" maxlength="20" value="<%=product_code%>"></td>
</tr>
<tr>
<td width="17%" height="23" nowrap> <div align="right">产品规格：</div></td>
<td height="23"><input name="product_standard" type="text" class="input" id="product_standard" size="30" maxlength="20" value="<%=product_standard%>"></td>
<td width="18%" height="23" nowrap><div align="right">计量单位：</div></td>
<td width="30%" height="23"><input name="product_unit" type="text" class="input" id="product_unit" size="30" maxlength="20" value="<%=product_unit%>"></td>
</tr>
<tr>
<td width="17%" height="22" nowrap><div align="right">销售定价：</div></td>
<td height="22"><input name="product_sale_price" type="text" class="input" id="product_sale_price" size="30" maxlength="20" value="<%=product_sale_price%>"></td>
<td width="18%" height="22" nowrap><div align="right">成本价：</div></td>
<td width="30%" height="22"><input name="product_cost" type="text" class="input" id="product_cost" size="30" maxlength="20" value="<%=product_cost%>"></td>
</tr>
<tr>
<td width="17%" height="22" nowrap> <div align="right">折扣价：</div></td>
<td height="22"><input name="product_discount" type="text" class="input" id="product_discount" size="30" maxlength="20" value="<%=product_discount%>"></td>
<td width="18%" height="22" nowrap> <div align="right">拼音码：</div></td>
<td width="30%" height="22"><input name="product_PY_code" type="text" class="input" id="product_PY_code" size="30" maxlength="20" value="<%=product_PY_code%>"></td>
</tr>
<tr>
<td height="22" nowrap><div align="right">备注信息：</div></td>
<td height="22" colspan="3"><textarea name="product_desc" cols="50" rows="5" class="input" id="product_desc"><%=product_desc%></textarea></td>
</tr>
<tr>
<td colspan="4" height="22"> <div align="center">
<input type="submit" value=" 提 交 " class="button">
<input type="reset" value=" 重 设 " class="button">
</div></td>
</tr>
</form>
</table>
</body>
</html>
<script>
function Openwin(str)
{
window.open(str,"","left=100,top=100,Width=500,Height=400,scrolling=yes");
}
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -