📄 productedit.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<% Option Explicit %>
<HTML xmlns="http://www.w3.org/1999/xhtml">
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8" />
<META NAME="Keywords" CONTENT="" />
<META NAME="Description" CONTENT="" />
<TITLE>编辑人物</TITLE>
<link rel="stylesheet" href="Images/CssAdmin.css">
<script language="javascript" src="../Script/Admin.js"></script>
</HEAD>
<!--#include file="../Include/Const.asp" -->
<!--#include file="../Include/ConnSiteData.asp" -->
<!--#include file="CheckAdmin.asp"-->
<%
if Instr(session("AdminPurview"),"|33,")=0 then
response.write ("<font color='red')>你不具有该管理模块的操作权限，请返回！</font>")
response.end
end if
'========判断是否具有管理权限
%>
<BODY>
<%
dim Result
Result=request.QueryString("Result")
dim ID,ProductName,ViewFlag,SortName,SortID,SortPath
dim ProductNo,ProductModel,Price,Maker,CommendFlag,NewFlag,GroupID,GroupIdName,Exclusive
dim BigPic,SmallPic,Content,CInfo
ID=request.QueryString("ID")
call ProductEdit()
%>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#6298E1">
<tr>
<td height="24" nowrap><font color="#FFFFFF"><img src="Images/Explain.gif" width="18" height="18" border="0" align="absmiddle"> <strong>人物检索及分类查看：添加，修改，删除人物信息</strong></font></td>
</tr>
<tr>
<td height="24" align="center" nowrap bgcolor="#EBF2F9"><a href="ProductEdit.asp?Result=Add" onClick='changeAdminFlag("添加人物信息")'>添加人物信息</a><font color="#0000FF"> | </font><a href="ProductList.asp" onClick='changeAdminFlag("人物列表")'>查看所有人物信息</a></td>
</tr>
</table>
<br>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#6298E1">
<form name="editForm" method="post" action="ProductEdit.asp?Action=SaveEdit&Result=<%=Result%>&ID=<%=ID%>">
<tr>
<td height="24" nowrap bgcolor="#EBF2F9"><table width="100%" border="0" cellpadding="0" cellspacing="0" id=editProduct idth="100%">
<tr>
<td width="120" height="20" align="right"> </td>
<td> </td>
</tr>
<tr>
<td height="20" align="right">人物名称：</td>
<td><input name="ProductName" type="text" class="textfield" id="ProductName" style="WIDTH: 240;" value="<%=ProductName%>" maxlength="100"> 发布：<input name="ViewFlag" type="checkbox" style='HEIGHT: 13px;WIDTH: 13px;' value="1" checked <%if ViewFlag then response.write ("checked")%>>
* 不少于3个字符</td>
</tr>
<tr>
<td height="20" align="right">所属类别：</td>
<td><input name="SortName" type="text" class="textfield" id="SortName" value="<%=SortName%>" style="WIDTH: 240;background-color:#EBF2F9;" readonly> <a href="javaScript:OpenScript('SelectSort.asp?Result=Products',500,500,'')"><img src="Images/Select.gif" width="30" height="16" border="0" align="absmiddle"></a></td>
</tr>
<tr>
<td height="20" align="right">类别数字：</td>
<td><input name="SortID" type="text" class="textfield" id="SortID" style="WIDTH: 40;background-color:#EBF2F9;" value="<%=SortID%>" readonly><input name="SortPath" type="text" class="textfield" id="SortPath" style="WIDTH: 200;background-color:#EBF2F9;" value="<%=SortPath%>" readonly> *</td>
</tr>
<tr>
<td height="20" align="right">编 号：</td>
<td><input name="ProductNo" type="text" class="textfield" id="ProductNo" style="WIDTH: 240;" value="<%=ProductNo%>" maxlength="100"> * 如果不明确请勿修改</td>
</tr>
<tr>
<td height="20" align="right">年 龄：</td>
<td><input name="ProductModel" type="text" class="textfield" id="ProductModel" style="WIDTH: 240;" value="<%=ProductModel%>" maxlength="100"></td>
</tr>
<tr>
<td height="20" align="right">性 别：</td>
<td><input name="Price" type="text" class="textfield" id="Price" style="WIDTH: 240;" value="<%=Price%>" maxlength="100">选择性别：
<select name="select" onChange="Price.value=this.value;">
<option value="选择">选择性别</option>
<option value="女" <%if Price="女" then response.write ("selected")%>>女</option>
<option value="男" <%if Price="男" then response.write ("selected")%>>男</option>
</select></td>
</tr>
<tr>
<td height="20" align="right">人物推荐：</td>
<td><input name="Maker" type="text" class="textfield" id="Maker" style="WIDTH: 240;" value="<%=Maker%>" maxlength="100"></td>
</tr>
<tr>
<td height="20" align="right">状 态：</td>
<td><input name="CommendFlag" type="checkbox" style="HEIGHT: 13px;WIDTH: 13px;" value="1" <%if CommendFlag then response.write ("checked")%>> 推荐 <input name="NewFlag" type="checkbox" style="HEIGHT: 13px;WIDTH: 13px;" value="1" checked <%if NewFlag then response.write ("checked")%>>
投票显示打开</td>
</tr>
<tr>
<td height="20" align="right">查看权限：</td>
<td><select name="GroupID" class="textfield">
<% call SelectGroup() %>
</select>
<input name="Exclusive" type="hidden" checked> *此项默认不用选择</font></td>
</tr>
<tr>
<td height="20" align="right">人物主图：</td>
<td><input name="BigPic" type="text" class="textfield" style="WIDTH: 240;" value="<%=BigPic%>" maxlength="100"> <a href="javaScript:OpenScript('UpFileForm.asp?Result=BigPic',460,180)"><img src="Images/Upload.gif" width="30" height="16" border="0" align="absmiddle"></a></td>
</tr>
<tr>
<td height="20" align="right">缩 略 图：</td>
<td><input name="SmallPic" type="text" class="textfield" style="WIDTH: 240;" value="<%=SmallPic%>" maxlength="100"> <a href="javaScript:OpenScript('UpFileForm.asp?Result=SmallPic',460,180)"><img src="Images/Upload.gif" width="30" height="16" border="0" align="absmiddle"></a></td>
</tr>
<tr>
<td height="20" align="right" valign="top">信息简介：<br>
<td><textarea name="CInfo" cols="60" rows="5"><%=CInfo%></textarea></td>
</tr>
<tr>
<td height="20" align="right" valign="top">信息内容：<br><input name="flplay" type="hidden" value="1">
<td><INPUT type='hidden' name='Content' value='<%=Content%>'>
<iframe ID="eWebEditor1" src="../WebEditor/ewebeditor.htm?id=Content&style=light" frameborder="0" scrolling="no" width="550" HEIGHT="300"></iframe>
</td>
</tr>
<tr>
<td height="30" align="right"> </td>
<td valign="bottom"><input name="submitSaveEdit" type="submit" class="button" id="submitSaveEdit" value="保存" style="WIDTH: 80;" ></td>
</tr>
<tr>
<td height="20" align="right"> </td>
<td valign="bottom"> </td>
</tr>
</table></td>
</tr>
</form>
</table>
</BODY>
</HTML>
<%
sub ProductEdit()
dim Action,rsRepeat,rs,sql
Action=request.QueryString("Action")
if Action="SaveEdit" then '保存编辑人物信息
set rs = server.createobject("adodb.recordset")
if len(trim(request.Form("ProductName")))<2 then
response.write ("<script language=javascript> alert('人物名称为必填项目！');history.back(-1);</script>")
response.end
end if
if Result="Add" then '创建产品信息
sql="select * from Ameav_Products"
rs.open sql,conn,1,3
rs.addnew
rs("ProductName")=trim(Request.Form("ProductName"))
if Request.Form("ViewFlag")=1 then
rs("ViewFlag")=Request.Form("ViewFlag")
else
rs("ViewFlag")=0
end if
if Request.Form("SortID")="" and Request.Form("SortPath")="" then
response.write ("<script language=javascript> alert('请选择所属分类！');history.back(-1);</script>")
response.end
else
rs("SortID")=Request.Form("SortID")
rs("SortPath")=Request.Form("SortPath")
end if
set rsRepeat = conn.execute("select ProductNo from Ameav_Products where ProductNo='" & trim(Request.Form("ProductNo")) & "'")
if not (rsRepeat.bof and rsRepeat.eof) then '判断此产品编号是否存在
response.write "<script language=javascript> alert('" & trim(Request.Form("ProductNo")) & "此产品编号已经存在，请换一个编号再试试！');history.back(-1);</script>"
response.end
else
rs("ProductNo")=trim(Request.Form("ProductNo"))
end if
rs("ProductModel")=trim(Request.Form("ProductModel"))
rs("Price")=trim(Request.Form("Price"))
rs("Maker")=trim(Request.Form("Maker"))
if Request.Form("CommendFlag")=1 then
rs("CommendFlag")=Request.Form("CommendFlag")
else
rs("CommendFlag")=0
end if
if Request.Form("NewFlag")=1 then
rs("NewFlag")=Request.Form("NewFlag")
else
rs("NewFlag")=0
end if
GroupIdName=split(Request.Form("GroupID"),"┎╂┚")
rs("GroupID")=GroupIdName(0)
rs("Exclusive")=trim(Request.Form("Exclusive"))
rs("BigPic")=trim(Request.Form("BigPic"))
rs("SmallPic")=trim(Request.Form("SmallPic"))
rs("CInfo")=trim(Request.Form("CInfo"))
rs("Content")=Request.Form("Content")
rs("AddTime")=now()
end if
if Result="Modify" then '修改产品信息
sql="select * from Ameav_Products where ID="&ID
rs.open sql,conn,1,3
rs("ProductName")=trim(Request.Form("ProductName"))
if Request.Form("ViewFlag")=1 then
rs("ViewFlag")=Request.Form("ViewFlag")
else
rs("ViewFlag")=0
end if
if Request.Form("SortID")<>"" and Request.Form("SortPath")<>"" then
rs("SortID")=Request.Form("SortID")
rs("SortPath")=Request.Form("SortPath")
else
response.write ("<script language=javascript> alert('请选择所属分类！');history.back(-1);</script>")
response.end
end if
rs("ProductNo")=trim(Request.Form("ProductNo"))
rs("ProductModel")=trim(Request.Form("ProductModel"))
rs("Price")=trim(Request.Form("Price"))
rs("Maker")=trim(Request.Form("Maker"))
if Request.Form("CommendFlag")=1 then
rs("CommendFlag")=Request.Form("CommendFlag")
else
rs("CommendFlag")=0
end if
if Request.Form("NewFlag")=1 then
rs("NewFlag")=Request.Form("NewFlag")
else
rs("NewFlag")=0
end if
GroupIdName=split(Request.Form("GroupID"),"┎╂┚")
rs("GroupID")=GroupIdName(0)
rs("Exclusive")=trim(Request.Form("Exclusive"))
rs("BigPic")=trim(Request.Form("BigPic"))
rs("SmallPic")=trim(Request.Form("SmallPic"))
rs("CInfo")=trim(Request.Form("CInfo"))
rs("Content")=Request.Form("Content")
end if
rs.update
rs.close
set rs=nothing
response.write "<script language=javascript> alert('成功编辑人物信息！');changeAdminFlag('人物列表');location.replace('ProductList.asp');</script>"
else '提取人物信息
if Result="Modify" then
set rs = server.createobject("adodb.recordset")
sql="select * from ameav_Products where ID="& ID
rs.open sql,conn,1,1
if rs.bof and rs.eof then
response.write ("数据库读取记录出错！")
response.end
end if
ProductName=rs("ProductName")
ViewFlag=rs("ViewFlag")
SortName=SortText(rs("SortID"))
SortID=rs("SortID")
SortPath=rs("SortPath")
ProductNo=rs("ProductNo")
ProductModel=rs("ProductModel")
Price=rs("Price")
Maker=rs("Maker")
CommendFlag=rs("CommendFlag")
NewFlag=rs("NewFlag")
GroupID=rs("GroupID")
Exclusive=rs("Exclusive")
BigPic=rs("BigPic")
SmallPic=rs("SmallPic")
CInfo=rs("CInfo")
Content=rs("Content")
rs.close
set rs=nothing
else
ProductNo=year(now)&month(now)&day(now)&hour(now)&minute(now)&second(now)
end if
end if
end sub
%>
<%
sub SelectGroup()
dim rs,sql
set rs = server.createobject("adodb.recordset")
sql="select GroupID,GroupName from ameav_MemGroup"
rs.open sql,conn,1,1
if rs.bof and rs.eof then
response.write("未设组别")
end if
while not rs.eof
response.write("<option value='"&rs("GroupID")&"┎╂┚"&rs("GroupName")&"'")
if GroupID=rs("GroupID") then response.write ("selected")
response.write(">"&rs("GroupName")&"</option>")
rs.movenext
wend
rs.close
set rs=nothing
end sub
%>
<%
'生成所属类别--------------------------
Function SortText(ID)
Dim rs,sql
Set rs=server.CreateObject("adodb.recordset")
sql="Select * From ameav_ProductSort where ID="&ID
rs.open sql,conn,1,1
SortText=rs("SortName")
rs.close
set rs=nothing
End Function
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -