📄 pro.asp
字号:
<!--#include file="../inc/function.asp"-->
<!--#include file="../inc/ChkPurview.asp"-->
<%
Dim iCount,Action
If GetUserGPower<>9999 then '省级用户
Call Msg("您没有权限",1,"")
End if
Action=Trim(request("Action"))
%>
<html>
<head>
<title>产品管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../css/mobile_sale.css" rel="stylesheet" type="text/css">
<script src="../js/ChkFrm.js" language=javascript></script>
<SCRIPT language=javascript>
function Checkv()
{
if(document.form1.Pro_MC.value=="")
{
alert("请填写产品名称");
document.form1.Pro_MC.focus();
return false;
}
if(fucCheckNUM(document.form1.Pro_DJ.value)==false)
{
alert("单价,应该为一个数值");
document.form1.Pro_DJ.focus();
return false;
}
}
</script>
<style type="text/css">
<!--
.style1 {color: #FF0000}
-->
</style>
</head>
<body leftmargin="2" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" class="border">
<tr class="topbg">
<td height="22" colspan="2" align="center"><strong>产 品 管 理</strong></td>
</tr>
<tr class="tdbg">
<td width="70" height="30"><strong>管理导航：</strong></td>
<td height="30"><a href="Pro.asp">产品列表</a> | <a href="Pro.asp?Action=Add">添加产品</a>
<!-- | <a href="InLists.asp">库存清单</a>-->
</td>
</tr>
</table>
<%
if Action="Add" then
call AddAdmin()
elseif Action="SaveAdd" then
call SaveAdd()
elseif Action="ModifyPwd" then
call ModifyPwd()
elseif Action="SaveModifyPwd" then
call SaveModifyPwd()
elseif Action="Del" then
call DelAdmin()
else
call main()
end if
Call CONN_End(Conn)
sub main()
Sql = "Select * from T_Product order by Pro_ID desc;"
Call sql_open(Rs,Sql,Conn,1,1)
Call page_code(Rs,20)
If Not Rs.Eof Then
IsFor=True
Else
IsFor=False
Response.write "<center><b><font color=red>暂无内容！</font></b></center>"
End IF
%>
<br>
<table width='100%' border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" class="border">
<tr align="center" class="title">
<td>产品名称/型号</td>
<td>供货商</td>
<td>价格(元)</td>
<td>添加日期</td>
<td width="150" height="22"><strong> 操 作</strong></td>
</tr>
<%
For i= 1 to Rs.PageSize
If Rs.Eof Then Exit For
%>
<tr class="tdbg" onmouseout="this.style.backgroundColor=''" onmouseover="this.style.backgroundColor='#BFDFFF'">
<td><%=Rs("Pro_MC")%></td>
<td align="center"><%=Rs("Pro_CD")%></td>
<td align="center"><span class="style1"><%=Rs("Pro_DJ")%></span></td>
<td align="center"><%=Rs("Pro_InTime")%></td>
<td width="150" align="center">
<%
' Response.write "<a href='../InList/InList.asp?Pro_ID="&Rs("Pro_ID")&"' title='查看此产品进货清单'>进货</a>"
' Response.write " | <a href='../OutOrder/SubOutOrder.asp?Pro_ID="&Rs("Pro_ID")&"' title='查看此产品发货清单'>发货</a> | "
Response.write "<a href='Pro.asp?Action=ModifyPwd&ID=" & rs("Pro_ID") & "' title='修改此产品信息'>修改</a>"
Response.write " | <a href='Pro.asp?Action=Del&ID=" & rs("Pro_ID") & "' onClick=""return confirm('确定要删除此产品吗？');"">删除</a>"
%> </td>
</tr>
<%
Rs.MoveNext
Next
%>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="30"> </td>
<td width="300"><%If IsFor Then Call page_code_down(Rs,"","条记录") %></td>
</tr>
</table>
</td>
</tr></table>
<%
Call Rs_End(Rs)
end sub
sub AddAdmin()
%>
<form action="Pro.asp" method="post" name="form1" onsubmit="javascript:return Checkv();">
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" class="border" >
<tr class="title">
<td height="22" colspan="2"> <div align="center"><strong>新增产品</strong></div></td>
</tr>
<!--
<tr class="tdbg">
<td width="35%" class="tdbg"><strong>类别：</strong></td>
<td width="65%" class="tdbg">
<select name="Pro_Class_ID" id="Pro_Class_ID">
<%Call Opt_N("T_Product_Class","Pro_Class_ID","Pro_Class_Name","",0)%>
</select>
</td>
</tr>
-->
<tr class="tdbg">
<td width="120" class="tdbg"><strong> 产品名称及型号</strong></td>
<td class="tdbg"><input name="Pro_MC" type="text" id="Pro_MC"> 如:中兴A800</td>
</tr>
<!-- <tr class="tdbg">
<td class="tdbg"><strong> 产品型号</strong></td>
<td class="tdbg"><input name="Pro_XH" type="text" id="Pro_XH"></td>
</tr>-->
<tr class="tdbg">
<td class="tdbg"><strong> 单价</strong></td>
<td class="tdbg"><input name="Pro_DJ" type="text" id="Pro_DJ">
(元) </td>
</tr>
<tr class="tdbg">
<td class="tdbg"><strong> 供货商 </strong></td>
<td class="tdbg"><input name="Pro_CD" type="text" id="Pro_CD"></td>
</tr>
<tr class="tdbg">
<td class="tdbg"><strong>产品图片
<input name="Pro_TP" type="hidden" id="Pro_TP" value="">
</strong></td>
<td class="tdbg"><iframe class="TBGen" style="top:2px" ID="UploadFiles" src="../inc/upload.asp" frameborder=0 scrolling=no width="400" height="25"></iframe></td>
</tr>
<tr class="tdbg">
<td class="tdbg"><strong> 产品介绍</strong></td>
<td class="tdbg"><textarea name="Pro_XN" cols="50" rows="6" id="Pro_XN"></textarea></td>
</tr>
<tr class="tdbg">
<td class="tdbg"> </td>
<td class="tdbg"> </td>
</tr>
<tr>
<td height="40" colspan="2" align="center" class="tdbg"><input name="Action" type="hidden" id="Action" value="SaveAdd">
<input type="submit" name="Submit" value=" 添 加 " style="cursor:hand;">
<input name="Cancel" type="button" id="Cancel" value=" 取 消 " onClick="window.location.href='Pro.asp'" style="cursor:hand;"></td>
</tr>
</table>
</form>
<%
end sub
sub ModifyPwd()
Dim Pro_ID
Pro_ID=trim(Request("ID"))
if Pro_ID="" then
Call Msg("请指定要修改的产品", 1,"")
exit sub
else
Pro_ID=Clng(Pro_ID)
end if
Sql="Select * from T_Product where Pro_ID=" & Pro_ID
Call sql_open(Rs,Sql,Conn,1,3)
If Rs.Bof And Rs.EOF Then
Call Msg("不存在此产品", 1,"")
Else
%>
<form method="post" action="Pro.asp" name="form1" onsubmit="javascript:return Checkv();">
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" class="border" >
<tr class="title">
<td height="22" colspan="2"> <div align="center"><strong>修改产品</strong></div></td>
</tr>
<!--
<tr>
<td width="35%" class="tdbg"><strong>类别：</strong></td>
<td width="65%" class="tdbg">
<select name="Pro_Class_ID" id="Pro_Class_ID">
<%Call Opt_N("T_Product_Class","Pro_Class_ID","Pro_Class_Name",Rs("Pro_Class_ID"),0)%>
</select>
</td>
</tr>
-->
<tr class="tdbg">
<td width="120" class="tdbg"><strong> <strong>产品名称及型号</strong></strong></td>
<td class="tdbg"><input name="Pro_MC" type="text" id="Pro_MC" value="<%=Rs("Pro_MC")%>">
如:中兴A800</td>
</tr>
<!--
<tr class="tdbg">
<td class="tdbg"><strong> 产品型号：</strong></td>
<td class="tdbg"><input name="Pro_XH" type="text" id="Pro_XH" value="<%=Rs("Pro_XH")%>"></td>
</tr>
-->
<tr class="tdbg">
<td class="tdbg"><strong> <strong>单价</strong></strong></td>
<td class="tdbg"><input name="Pro_DJ" type="text" id="Pro_DJ" value="<%=Rs("Pro_DJ")%>">
(元) </td>
</tr>
<tr class="tdbg">
<td class="tdbg"><strong> <strong>供货商 </strong></strong></td>
<td class="tdbg"><input name="Pro_CD" type="text" id="Pro_CD" value="<%=Rs("Pro_CD")%>"></td>
</tr>
<td class="tdbg"><strong>产品图片
<input name="Pro_TP" type="hidden" id="Pro_TP" value="<%=Rs("Pro_TP")%>">
</strong></td>
<td class="tdbg"><iframe class="TBGen" style="top:2px" ID="UploadFiles" src="../inc/upload.asp" frameborder=0 scrolling=no width="400" height="25"></iframe></td>
<%if Rs("Pro_TP")<>"" or isnull(Rs("Pro_TP")) then%>
<tr class="tdbg">
<td class="tdbg"><strong>产品图片</strong></td>
<td class="tdbg"><img src="<%=Rs("Pro_TP")%>"></td>
</tr>
<%end if%>
<tr class="tdbg">
<td class="tdbg"><strong> <strong>产品介绍</strong></strong></td>
<td class="tdbg"><textarea name="Pro_XN" cols="50" rows="6" id="Pro_XN"><%=Rs("Pro_XN")%></textarea></td>
</tr>
<tr>
<td colspan="2" align="center" class="tdbg"><input name="Pro_ID" type="hidden" id="Pro_ID" value="<%=Rs("Pro_ID")%>"> <input name="Action" type="hidden" id="Action" value="SaveModifyPwd">
<input type="submit" name="Submit" value="保存修改结果" style="cursor:hand;">
<input name="Cancel" type="button" id="Cancel" value=" 取 消 " onClick="window.location.href='Pro.asp'" style="cursor:hand;"></td>
</tr>
</table>
</form>
<%
End If
Call Rs_End(Rs)
End Sub
%>
</body>
</html>
<%
'增加新组
Sub SaveAdd()
dim Pro_Class_ID,Pro_MC,Pro_DJ,Pro_CD,Pro_XN,Pro_TP
' Pro_XH,
' Pro_Class_ID=trim(Request("Pro_Class_ID"))
Pro_MC=trim(Request("Pro_MC"))
' Pro_XH=trim(Request("Pro_XH"))
Pro_DJ=trim(Request("Pro_DJ"))
Pro_CD=trim(Request("Pro_CD"))
Pro_XN=trim(Request("Pro_XN"))
Pro_TP=trim(Request("Pro_TP"))
if Pro_MC="" then
Call Msg("产品名不能为空", 1,"")
end if
Call Isnum(Pro_DJ,Pro_DJ,1)
Sql="Select * from T_Product where Pro_MC='"&Pro_MC&"'"
Call sql_open(Rs,Sql,Conn,1,3)
if not (rs.bof and rs.EOF) then
Call Msg("数据库中已经存在此产品", 1,"")
Call Rs_End(Rs)
exit sub
end if
rs.addnew
' rs("Pro_Class_ID")=Pro_Class_ID
rs("Pro_MC")=Pro_MC
' rs("Pro_XH")=Pro_XH
rs("Pro_DJ")=Pro_DJ
rs("Pro_CD")=Pro_CD
rs("Pro_XN")=Pro_XN
rs("Pro_TP")=Pro_TP
rs.update
Call Rs_End(Rs)
Call main()
end sub
'修改组
sub SaveModifyPwd()
dim Pro_ID,Pro_Class_ID,Pro_MC,Pro_DJ,Pro_CD,Pro_XN,Pro_TP
' Pro_XH,
Pro_ID=trim(Request("Pro_ID"))
' Pro_Class_ID=trim(Request("Pro_Class_ID"))
Pro_MC=trim(Request("Pro_MC"))
' Pro_XH=trim(Request("Pro_XH"))
Pro_DJ=trim(Request("Pro_DJ"))
Pro_CD=trim(Request("Pro_CD"))
Pro_XN=trim(Request("Pro_XN"))
Pro_TP=trim(Request("Pro_TP"))
' Response.write Pro_TP
' response.end
Call Isnum(Pro_DJ,Pro_DJ,1)
if Pro_ID="" then
Call Msg("请指定要修改的产品", 1,"")
else
Pro_ID=Clng(Pro_ID)
end if
Sql="Select * from T_Product where Pro_ID=" & Pro_ID
Call sql_open(Rs,Sql,Conn,1,3)
if rs.Bof and rs.EOF then
Call Msg("不存在此类别", 1,"")
Call Rs_End(Rs)
exit sub
end if
' rs("Pro_Class_ID")=Pro_Class_ID
rs("Pro_MC")=Pro_MC
' rs("Pro_XH")=Pro_XH
rs("Pro_DJ")=Pro_DJ
rs("Pro_CD")=Pro_CD
rs("Pro_XN")=Pro_XN
if Pro_TP<>"" then
rs("Pro_TP")=Pro_TP
end if
rs.update
rs.Close
set rs=Nothing
call main()
end sub
'删除组
sub DelAdmin()
dim Pro_ID
Pro_ID=trim(Request("ID"))
if Pro_ID="" then
Call Msg("请指定产品", 1,"")
exit sub
end if
if instr(Pro_ID,",")>0 then
Pro_ID=replace(Pro_ID," ","")
sql="Select * from T_Product where Pro_ID in (" & Pro_ID & ")"
else
Pro_ID=clng(Pro_ID)
sql="select * from T_Product where Pro_ID=" & Pro_ID
end if
Call sql_open(Rs,Sql,Conn,1,3)
do while not rs.eof
rs.delete
rs.update
rs.movenext
loop
Call Rs_End(Rs)
call main()
end sub
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -