?? productordermanage.asp
字號:
<!--#include file="CheckAdminLogined.asp"-->
<!--#include file="../include/connstr.asp"-->
<!--#include file="../include/DefFunction.asp"-->
<% if request("cur_action")="delete" then
conn.execute("delete from tTailor where ID="&request("EditID"))
response.write "<script>alert('已經成功刪除');location.replace('ProductOrderManage.asp?PageNo="&request("PageNo")&"');</script>"
response.end
end if
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="Images/AdminCss.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
</script>
</head>
<body leftmargin="0" topmargin="0">
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="8" colspan="2"></td>
</tr>
<tr>
<td width="76" height="20" rowspan="2"><img src="Images/TopBt.gif" width="67" height="36"></td>
<td width="894" height="10"></td>
</tr>
<tr>
<td>我的位置：后臺管理系統._綜合功能管理._產品訂單管理</td>
</tr>
<tr>
<td height="4" colspan="2"></td>
</tr>
<tr>
<td colspan="2"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="E7E7E7">
<tr>
<td height="20"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="159" height="20" align="center" background="images/title1.gif" class="fontwintitle"><strong>產品訂單管理</strong>
</td>
<td align="right" background="images/title2.gif"> </td>
<td width="10"><img src="images/title3.gif" width="10" height="20"></td>
</tr>
</table></td>
</tr>
<tr valign="top">
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="6" background="images/midder1.gif"><img src="images/midder1.gif" width="6" height="3"></td>
<td height="100%" align="center" valign="top">
<%if request("cur_action")="read" then
conn.execute("update tTailor set ReadFlag=1 where ID="&request("ID"))
set rs_read=conn.execute("select * from tTailor where ID="&request("ID"))
if rs_read.eof and rs_read.bof then
response.write "<script>alert('讀取數據庫時出錯，請與管理員聯系');history.back();</script>"
response.end
end if
%><br>
<table width="98%" border="0" cellpadding="0" cellspacing="1" bgcolor="#333333">
<tr>
<td width="17%" height="21" align="center" bgcolor="f7f7f7">ID</td>
<td width="83%" bgcolor="#FFFFFF"> <%=rs_read("ID")%></td>
</tr>
<tr>
<td height="21" align="center" bgcolor="f7f7f7">產品名稱</td>
<td bgcolor="#FFFFFF"> <%=rs_read("ProductName")%></td>
</tr>
<tr>
<td height="21" align="center" bgcolor="f7f7f7">公司名稱</td>
<td bgcolor="#FFFFFF"> <%=rs_read("Company")%></td>
</tr>
<tr>
<td height="21" align="center" bgcolor="f7f7f7">聯系人</td>
<td bgcolor="#FFFFFF"> <%=rs_read("TrueName")%></td>
</tr>
<tr>
<td height="21" align="center" bgcolor="f7f7f7">電話號碼</td>
<td bgcolor="#FFFFFF"> <%=rs_read("Tel")%></td>
</tr>
<tr>
<td height="21" align="center" bgcolor="f7f7f7">傳真號碼</td>
<td bgcolor="#FFFFFF"> <%=rs_read("Fax")%></td>
</tr>
<tr>
<td height="21" align="center" bgcolor="f7f7f7">電子郵件</td>
<td bgcolor="#FFFFFF"> <%=rs_read("Email")%></td>
</tr>
<tr>
<td height="21" align="center" bgcolor="f7f7f7">郵編</td>
<td bgcolor="#FFFFFF"> <%=rs_read("Zip")%></td>
</tr>
<tr>
<td height="21" align="center" bgcolor="f7f7f7">詳細地址</td>
<td bgcolor="#FFFFFF"> <%=rs_read("Address")%></td>
</tr>
<tr>
<td height="21" align="center" bgcolor="f7f7f7">反饋內容</td>
<td bgcolor="#FFFFFF"> <%=rs_read("Content")%></td>
</tr>
<tr>
<td height="21" align="center" bgcolor="f7f7f7">添加時間</td>
<td bgcolor="#FFFFFF"> <%=rs_read("AddTime")%></td>
</tr>
<tr>
<td height="21" align="center" bgcolor="f7f7f7">來自</td>
<td bgcolor="#FFFFFF"> <%if rs_read("SourceFlag")=0 then response.write "訂單" else response.write "定制"%> </td>
</tr>
<tr>
<td height="21" align="center" bgcolor="f7f7f7">狀態</td>
<td bgcolor="#FFFFFF">
<%if rs_read("ReadFlag")=0 then response.write "未讀" else response.write "已讀"%></td>
</tr>
<tr>
<td height="39" colspan="2" align="center" bgcolor="#FFFFFF"><input type="button" name="Submit2" value="返回" onclick="javascript:history.back();">
<input type="button" name="Submit22" value="刪除" onclick="{if(confirm('確定刪除該條紀錄嗎?')){location.replace('?cur_action=delete&EditID=<%=rs_read("ID")%>&PageNo=<%=request("PageNo")%>')}return false;}"></td>
</tr>
</table>
<br>
<%end if
'----------------------------
PERPAGE =15
PageNo=request("PageNo")
set rs=server.createobject("ADODB.recordset")
sql="select * from tTailor order by AddTime desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "暫時沒有數據!"
else
rs.pagesize = PERPAGE
if isempty(PageNo) or cstr(PageNo)<"1" then PageNo = 1
CurPage=PageNo
if int(PageNo)>=int(rs.pagecount) then CurPage=cint(rs.pagecount)
rs.absolutepage = CurPage
%>
<br> <table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr align="center">
<td colspan="2"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#000000">
<tr align="center" bgcolor="#FFFFFF">
<td width="9%" height="22"><strong>ID</strong></td>
<td width="24%"><strong>產品名稱</strong></td>
<td width="20%"><strong>公司名稱</strong></td>
<td width="14%" height="22" bgcolor="#FFFFFF"><strong>聯系電話</strong></td>
<td width="5%" bgcolor="#FFFFFF"><strong>來自</strong></td>
<td width="9%"><strong>狀態</strong></td>
<td width="19%" height="22"><strong>功能操作</strong></td>
</tr>
<% for i = 1 to rs.pagesize %>
<tr align="center" onMouseOver="this.style.backgroundColor='#e7e7e7';" onMouseOut="this.style.backgroundColor='#ffffff'" bgcolor="#FFFFFF">
<td height="22"><%=rs("ID")%></td>
<td height="22"><%=rs("ProductName")%></td>
<td height="22"><%=rs("Company")%></td>
<td height="22"><%=rs("Tel")%></td>
<td height="22"><%if rs("SourceFlag")=0 then response.write "訂單" else response.write "定制"%></td>
<td height="22"> <% if rs("ReadFlag")=0 then response.write "<font color='ff0000'>未讀</font>" else response.write "已閱"%> </td>
<td height="22"> <a href='?cur_action=read&ID=<%=rs("ID")%>&PageNo=<%=PageNo%>'>詳細信息</a>|<a href="?cur_action=delete&EditID=<%=rs("ID")%>&PageNo=<%=PageNo%>" onclick="{if(confirm('確定刪除該條紀錄嗎?')){return true;}return false;}">刪除</a></td>
</tr>
<% rs.movenext
if rs.eof then
i = i + 1
exit for
end if
next %>
</table></td>
</tr>
<tr>
<td height="8" colspan="2"></td>
</tr>
<tr>
<td width="33%"> 頁次：<b><%=CurPage%></b>/<b><%=rs.pagecount %></b>頁 共<b><%=rs.recordcount %></b>條記錄</td>
<td width="67%" align="right">
<%
if CurPage = 1 then
response.write " 首頁 | 上一頁 | "
else
response.write "<a href='?PageNo=1&T_key="&request("T_key")&"'><b> 首頁 </b></a> | <a href='?PageNo="&CurPage-1&"&T_key="&request("T_key")&"'><b>上一頁</b></a>| "
end if
if CurPage = rs.pagecount then
response.write "后一頁 | 尾頁 "
else
response.write "<a href='?PageNo="&CurPage+1&"&T_key="&request("T_key")&"'><b>后一頁</b> </a>| <a href='?PageNo="&rs.pagecount&"&T_key="&request("T_key")&"'><b>尾頁</b> </a>"
end if
%>
跳轉到：<select name="menu1" onChange="MM_jumpMenu('parent.frames[\'right\']',this,0)">
<% for i=1 to rs.pagecount
if CurPage=i then
response.write "<option value='?PageNo="&i&"&T_key="&request("T_key")&"' selected>第"&i&"頁"
else
response.write "<option value='?PageNo="&i&"&T_key="&request("T_key")&"'>第"&i&"頁"
end if
next
%>
</select></td>
</tr>
</table>
<%end if%>
<br> <br> </td>
<td width="2" background="images/midder2.gif"><img src="images/midder2.gif" width="2" height="3"></td>
</tr>
<tr>
<td valign="top"><img src="images/bottom1.gif" width="6" height="14"></td>
<td height="14" valign="top" background="images/bottom2.gif"><img src="images/bottom2.gif" width="2" height="14"></td>
<td valign="top"><img src="images/bottom3.gif" width="2" height="14"></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -