<%
'商易仿淘宝4.0(多用户)
'ACCESS版演示网站：http://www.ftaobao.com(商易仿淘宝商城)
'SQL版演示网站：http://sql.ftaobao.com
'电话：0571-56907100
'QQ：1147100
%>
<style type="text/css">
<!--
.STYLE1 {color: #FFFFFF}
-->
</style>
<body onLoad="show(c91),show(c92)">
<!--#include file="top.asp"-->
<!--#include file="../include/page.asp" -->
<!--#include file="../include/tishi.asp" -->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<table width="762" border="0" align="center" cellpadding="2" cellspacing="0" style='BORDER-COLLAPSE: collapse;MARGIN: 3px'>
  <tr> 
  <td height="22" colspan="2">您的位置： <A href="../index.asp">首页</A> &gt;&gt; <a href="index.asp">会员中心</a>&nbsp;&gt;&gt; 电话订单</td>
  </tr>
  <tr> 
  <td width="180" valign="top"><!--#include file="left.asp"--></td>
<td width="560" height="280" valign="top">
<%Select case request("abc")
case "tel_x"
if shopnet("telname")<>"" and shopnet("telname")<>"" then
telname=shopnet("telname")
tel=shopnet("tel")
telmail=shopnet("telmail")
telusername=shopnet("telusername")
teladd=shopnet("teladd")
youbian=shopnet("youbian")
telbeizhu=shopnet("telbeizhu")
feiyong=shopnet("feiyong")
fahuo=clng(request("fahuo"))
shangpin=shopnet("shangpin")
jiage=shopnet("jiage")
shangpinid=shopnet("shangpinid")
number=shopnet("number")
Set rs = Server.CreateObject("ADODB.Recordset")		 
sql="select * from telorder where id="&shopnet("id")
rs.open sql,conn,1,3 
rs("spn")=spn
rs("userid")=myuserid
rs("youbian")=youbian
rs("telname")=telname
rs("telusername")=telusername
rs("teladd")=teladd
rs("tel")=tel
rs("telmail")=telmail
rs("telbeizhu")=telbeizhu 
rs("feiyong")=feiyong 
rs("fahuo")=fahuo 
rs("shangpin")=shangpin 
rs("jiage")=jiage 
rs("shangpinid")=shangpinid 
rs("number")=number
rs.update 	
rs.close:set rs=Nothing
'商易仿淘宝4.0.1演示地址
'http://www.ftaobao.com
Response.Write("<script>alert(""修改成功"");window.opener.location.href=""telorder.asp"";self.close();</script>")
end if
set rs = conn.execute("select * from telorder where id="&shopnet("id")&"")%>

<table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td><table border="0" align="left" cellpadding="0" cellspacing="0">
                <tr>
                  <td width="1"><IMG SRC="../images/mytaobaobj1_3.gif" WIDTH=3 HEIGHT=25 ALT=""></td>
                  <td width="120" align="center" background="../images/mytaobaobj1_4.gif"><span class="STYLE1">添加电话订单</span></td>
                  <td width="1"><IMG SRC="../images/mytaobaobj1_6.gif" WIDTH=7 HEIGHT=25 ALT=""></td>
                </tr>
              </table>
                <table border="0" align="left" cellpadding="0" cellspacing="0">
                  <tr>
                    <td width="1"><IMG SRC="../images/mytaobaobj1_8.gif" WIDTH=3 HEIGHT=25 ALT=""></td>
                    <td width="120" align="center" background="../images/mytaobaobj1_9.gif"><font color="#FF0000"><span class="C"><a href="telorder.asp">电话订单</a><a href="sh.asp"></a></span></font></td>
                    <td width="1"><IMG SRC="../images/mytaobaobj1_11.gif" WIDTH=7 HEIGHT=25 ALT=""></td>
                  </tr>
                </table>
              <table border="0" align="left" cellpadding="0" cellspacing="0">
                  <tr>
                    <td width="1"><IMG SRC="../images/mytaobaobj1_8.gif" WIDTH=3 HEIGHT=25 ALT=""></td>
                    <td width="120" align="center" background="../images/mytaobaobj1_9.gif"><font color="#FF0000"><span class="C"><a href="sh.asp">送货清单</a></span></font></td>
                    <td width="1"><IMG SRC="../images/mytaobaobj1_11.gif" WIDTH=7 HEIGHT=25 ALT=""></td>
                  </tr>
                </table>
              <table border="0" align="left" cellpadding="0" cellspacing="0">
                  <tr>
                    <td width="1"><IMG SRC="../images/mytaobaobj1_8.gif" WIDTH=3 HEIGHT=25 ALT=""></td>
                    <td width="120" align="center" background="../images/mytaobaobj1_9.gif"><font color="#FF0000"><span class="C"><a href="dingdan.asp">商品订单</a></span></font></td>
                    <td width="1"><IMG SRC="../images/mytaobaobj1_11.gif" WIDTH=7 HEIGHT=25 ALT=""></td>
                  </tr>
              </table></td>
          </tr>
        </table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td height="4" bgcolor="1E88C1"></td>
          </tr>
        </table>

<form method="POST" action="?abc=tel_x&id=<%=rs("id")%>" onSubmit="javascript:return add(this)">
<br>


        <br>




        <table bgcolor="#efefef" border="0" cellpadding="0" cellspacing="1" 
        width="550" align="center" class="9bang">
          <tbody>
            
			<tr>
              <td height="21" colspan="4" align="center" valign="middle" background="../image/bk.gif" bgcolor="#f1f1f1" class="008c5e">&nbsp;</td>
            </tr>
            <tr>
              <td bgcolor="#f1f1f1" class="008c5e" height="25" align="center">用户名</td>
              <td bgcolor="#ffffff" class="008c5e" height="25"><input name="telname" type="text" class="wenbenkuang" id="telname" value="<%=rs("telname")%>" size="20" /></td>
              <td height="25" align="center" bgcolor="#f1f1f1" class="008c5e">联系电话</td>
              <td bgcolor="#ffffff" class="008c5e" height="25"><input name="tel" type="text" class="wenbenkuang" id="tel" value="<%=rs("tel")%>" size="20" /></td>
            </tr>
            <tr>
              <td bgcolor="#f1f1f1" width="100" class="008c5e" height="25" align="center">客户姓名</td>
              <td bgcolor="#ffffff" width="200" class="008c5e" height="25"><input name="telusername" type="text" class="wenbenkuang" id="telusername" value="<%=rs("telusername")%>" size="20" /></td>
              <td width="100" height="25" align="center" bgcolor="#f1f1f1" class="008c5e">邮箱</td>
              <td bgcolor="#ffffff" width="200" class="008c5e" height="25"><input name="telmail" type="text" class="wenbenkuang" id="telmail" value="<%=rs("telmail")%>" size="20" /></td>
            </tr>
            <tr>
              <td bgcolor="#f1f1f1" class="008c5e" width="100" height="25" align="center">收货地址</td>
              <td colspan="3" class="008c5e" bgcolor="#FFFFFF" height="25"><input name="teladd" type="text" class="wenbenkuang" id="teladd" value="<%=rs("teladd")%>" size="50" maxlength="100" /></td>
            </tr>
            <tr>
              <td width="100" height="25" align="center" bgcolor="#f1f1f1" class="008c5e">订单备注</td>
              <td colspan="3" class="008c5e" bgcolor="#FFFFFF" height="25"><input name="telbeizhu" type="text" class="wenbenkuang" id="telbeizhu" value="<%=rs("telbeizhu")%>" size="60" maxlength="100" /></td>
            </tr>
            <tr>
              <td width="100" height="25" align="center" bgcolor="#f1f1f1" class="008c5e">配送费用</td>
              <td colspan="3" class="008c5e" bgcolor="#FFFFFF" height="25"><input name="feiyong" type="text" class="wenbenkuang" id="feiyong" value="<%=rs("feiyong")%>" size="10" maxlength="10" />
                &nbsp;发货方式:
                <select name="select" id="select">
                  <option value="1">EMS</option>
                  <option value="2">快递</option>
                  <option value="3">平邮</option>
                </select>
                &nbsp;&nbsp; 邮编
                <input name="youbian" type="text" class="wenbenkuang" id="youbian" value="<%=rs("youbian")%>" size="10" maxlength="10" /></td>
            </tr>

                    <tr bgcolor="#f1f1f1">
                      <td width="37%" class="008c5e"><div align="center">商品名称</div></td>
                      <td width="22%" class="008c5e"><div align="center">价格</div></td>
                      <td width="20%" class="008c5e"><div align="center">商品ID</div></td>
                      <td width="12%" class="008c5e"><div align="center">数量</div></td>
                    </tr>
                    <tr>
                      <td bgcolor="#FFFFFF" width="37%" class="008c5e" height="18"><div align="center">
                          <input name="shangpin" type="text" class="wenbenkuang" id="shangpin" value="<%=rs("shangpin")%>" size="25" />
                      </div></td>
                      <td bgcolor="#ffffff" width="22%" class="008c5e" height="18"><div align="center"> <font color="#FF0000"></font>
                              <input name="jiage" type="text" class="wenbenkuang" id="jiage" value="<%=rs("jiage")%>" size="15" />
                      </div></td>
                      <td bgcolor="#ffffff" width="20%" class="008c5e" height="18"><div align="center"> <font color="#FF0000"></font>
                              <input name="shangpinid" type="text" class="wenbenkuang" id="shangpinid" value="<%=rs("shangpinid")%>" size="15" />
                      </div></td>
                      <td bgcolor="#ffffff" width="12%" class="008c5e" height="18"><div align="center"> <font color="#FF0000"></font>
                              <input name="number" type="text" class="wenbenkuang" id="number" value="<%=rs("number")%>" size="6" />
                      </div></td>
                    </tr>
            
            <tr>
              <td width="100" height="25" bgcolor="F1F1F1" class="008c5e">&nbsp;</td>
              <td bgcolor="F1F1F1" class="008c5e" colspan="3" height="25"><div align="center">
                  <input name="submit2" type="submit" class="go-wenbenkuang" value="修改" />
                &nbsp;&nbsp;
                <input name="Reset2" type="reset" class="go-wenbenkuang" value="重填" />
                &nbsp;</div></td>
            </tr>
            <tr>
              <td height="21" colspan="4" valign="middle" background="../image/bk1.gif" bgcolor="F1F1F1" class="008c5e">&nbsp;</td>
            </tr>
          </tbody>
        </table>
</form> 
<%rs.close:set rs=nothing
case "tel_add"
if shopnet("telname")<>"" and shopnet("telusername")<>"" then
telname=shopnet("telname")
tel=shopnet("tel")
telmail=shopnet("telmail")
telusername=shopnet("telusername")
teladd=shopnet("teladd")
youbian=shopnet("youbian")
telbeizhu=shopnet("telbeizhu")
feiyong=shopnet("feiyong")
fahuo=shopnet("fahuo")
shangpin=shopnet("shangpin")
jiage=shopnet("jiage")
shangpinid=shopnet("shangpinid")
number=shopnet("number")
'产生订单号
yy=year(date)
mm=right("00"&month(date),2)
dd=right("00"&day(date),2)
riqi=yy & mm & dd
'生成订单号所有所需元素,格式为：小时，分钟，秒
xiaoshi=right("00"&hour(time),2)
fenzhong=right("00"&minute(time),2)
miao=right("00"&second(time),2)
'产生定单号
spn="T"&yy & mm & dd & xiaoshi & fenzhong & miao
Set rs = Server.CreateObject("ADODB.Recordset")		 
sql="select * from telorder"
rs.open sql,conn,1,3 
rs.addnew  
rs("spn")=spn
rs("userid")=myuserid
rs("youbian")=youbian
rs("telname")=telname
rs("telusername")=telusername
rs("teladd")=teladd
rs("tel")=tel
rs("datetime")=sqlnow
rs("telmail")=telmail
rs("telbeizhu")=telbeizhu 
rs("feiyong")=feiyong 
rs("fahuo")=fahuo 
rs("shangpin")=shangpin 
rs("jiage")=jiage 
rs("shangpinid")=shangpinid 
rs("number")=number
rs.update 	
rs.close:set rs=nothing%>

<%response.Write("<Script>alert('电话订单提交成功');window.location='telorder.asp';</script>")
end if
%>     

<script language="javascript">
function checktel(){		 
if(document.telform.telname.value=="" )
{
alert("求购价格不能为空，且不能包含非法字符");
return false;
}

return true;
}
</script>
<form method="POST" action="?abc=tel_add"  name="telform" id ="telform">
        &nbsp; 
        <table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td><table border="0" align="left" cellpadding="0" cellspacing="0">
                <tr>
                  <td width="1"><IMG SRC="../images/mytaobaobj1_3.gif" WIDTH=3 HEIGHT=25 ALT=""></td>
                  <td width="120" align="center" background="../images/mytaobaobj1_4.gif"><span class="STYLE1">添加电话订单</span></td>
                  <td width="1"><IMG SRC="../images/mytaobaobj1_6.gif" WIDTH=7 HEIGHT=25 ALT=""></td>
                </tr>
              </table>
                <table border="0" align="left" cellpadding="0" cellspacing="0">
                  <tr>
                    <td width="1"><IMG SRC="../images/mytaobaobj1_8.gif" WIDTH=3 HEIGHT=25 ALT=""></td>
                    <td width="120" align="center" background="../images/mytaobaobj1_9.gif"><font color="#FF0000"><span class="C"><a href="telorder.asp">电话订单</a><a href="sh.asp"></a></span></font></td>
                    <td width="1"><IMG SRC="../images/mytaobaobj1_11.gif" WIDTH=7 HEIGHT=25 ALT=""></td>
                  </tr>
                </table>
              <table border="0" align="left" cellpadding="0" cellspacing="0">
                  <tr>
                    <td width="1"><IMG SRC="../images/mytaobaobj1_8.gif" WIDTH=3 HEIGHT=25 ALT=""></td>
                    <td width="120" align="center" background="../images/mytaobaobj1_9.gif"><font color="#FF0000"><span class="C"><a href="sh.asp">送货清单</a></span></font></td>
                    <td width="1"><IMG SRC="../images/mytaobaobj1_11.gif" WIDTH=7 HEIGHT=25 ALT=""></td>
                  </tr>
              </table>
              <table border="0" align="left" cellpadding="0" cellspacing="0">
                  <tr>
                    <td width="1"><IMG SRC="../images/mytaobaobj1_8.gif" WIDTH=3 HEIGHT=25 ALT=""></td>
                    <td width="120" align="center" background="../images/mytaobaobj1_9.gif"><font color="#FF0000"><span class="C"><a href="dingdan.asp">商品订单</a></span></font></td>
                    <td width="1"><IMG SRC="../images/mytaobaobj1_11.gif" WIDTH=7 HEIGHT=25 ALT=""></td>
                  </tr>
              </table></td>
          </tr>
        </table>
        <table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td height="4" bgcolor="1E88C1"></td>
          </tr>
        </table>
        
        <br><%msg="添加电话订单客户信息及商品信息"
		wmsg()%>
		<br>
        <table bgcolor=#efefef border=0 cellpadding=0 cellspacing=1 
        width="550" align="center" class="9bang">
          <tbody>
            <tr>
              <td height="21" colspan="4" align="center" valign="middle" background="../image/bk.gif" class="008c5e">&nbsp;</td>
            </tr>
            <tr>
              <td bgcolor=#FFFFFF class="008c5e" height="25" align="center">用户名</td>
              <td bgcolor=#FFFFFF class="008c5e" height="25"><input name=telname type="text" class="wenbenkuang" id="telname" value="" size="20" maxlength="35" /></td>
              <td height="25" align="center" bgcolor=#FFFFFF class="008c5e">联系电话</td>
              <td bgcolor=#FFFFFF class="008c5e" height="25"><input name="tel" type="text" class="wenbenkuang" id="tel" value="" size="20" maxlength="35" /></td>
            </tr>
            <tr> 
              <td bgcolor=#FFFFFF width=100 class="008c5e" height="25" align="center">客户姓名</td>
              <td bgcolor=#FFFFFF width=200 class="008c5e" height="25"><input name="telusername" type="text" class="wenbenkuang" id="telusername" value="" size="20" maxlength="30" /></td>
              <td width=100 height="25" align="center" bgcolor=#FFFFFF class="008c5e">邮箱</td>
              <td bgcolor=#FFFFFF width=200 class="008c5e" height="25"><input name="telmail" type="text" class="wenbenkuang" id="telmail" value="" size="20" maxlength="35" /></td>
            </tr>
            
            <tr> 
              <td bgcolor=#FFFFFF class="008c5e" width="100" height="25" align="center">收货地址</td>
              <td colspan="3" class="008c5e" bgcolor=#FFFFFF height="25"><input name="teladd" type="text" class="wenbenkuang" id="teladd" value="" size="50" maxlength="100"></td>
            </tr>
            <tr> 
              <td width="100" height="25" align="center" bgcolor=#FFFFFF class="008c5e">订单备注</td>
              <td colspan="3" class="008c5e" bgcolor=#FFFFFF height="25"><input name="telbeizhu" type="text" class="wenbenkuang" id="telbeizhu" value="" size="60" maxlength="100"></td>
            </tr>
            <tr> 
              <td width="100" height="25" align="center" bgcolor=#FFFFFF class="008c5e">配送费用</td>
              <td colspan="3" class="008c5e" bgcolor=#FFFFFF height="25"><input name="feiyong" type="text" class="wenbenkuang" id="feiyong" size="10" maxlength="10">
                &nbsp;发货方式:                
                <select name="fahuo" id="fahuo">
                  <option value="1">EMS</option>
                  <option value="2">快递</option>
                  <option value="3">平邮</option>
                </select>
                &nbsp;&nbsp; 邮编                
                <input name="youbian" type="text" class="wenbenkuang" id="youbian" size="10" maxlength="6" /></td>
            </tr>
            <tr>
              <td height="25" colspan="4" bgcolor=#FFFFFF class="008c5e"><table 
        width="98%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#efefef" class="9bang">
                <tbody>
                  <tr bgcolor="#f1f1f1">
                    <td width="37%" bgcolor="#FFFFFF" class="008c5e"><div align="center">商品名称</div></td>
                    <td width="22%" bgcolor="#FFFFFF" class="008c5e"><div align="center">价格</div></td>
                    <td width="20%" bgcolor="#FFFFFF" class="008c5e"><div align="center">商品ID</div></td>
                    <td width="12%" bgcolor="#FFFFFF" class="008c5e"><div align="center">数量</div></td>
                    </tr>
                  <tr>
                    <td bgcolor="#FFFFFF" width="37%" class="008c5e" height="18"><div align="center">
                      <input name="shangpin" type="text" class="wenbenkuang" id="shangpin" size="25" maxlength="38" />
                    </div></td>
                    <td bgcolor="#FFFFFF" width="22%" class="008c5e" height="18"><div align="center"> <font color="#FF0000"></font>
                      <input name="jiage" type="text" class="wenbenkuang" id="jiage" size="15" maxlength="10" />
                    </div></td>
                    <td bgcolor="#FFFFFF" width="20%" class="008c5e" height="18"><div align="center"> <font color="#FF0000"></font>
                            <input name="shangpinid" type="text" class="wenbenkuang" id="shangpinid" size="15" maxlength="5" />
                    </div></td>
                    <td bgcolor="#FFFFFF" width="12%" class="008c5e" height="18"><div align="center"> <font color="#FF0000"></font>
                            <input name="number" type="text" class="wenbenkuang" id="number" size="6" maxlength="5" />
                    </div></td>
                    </tr>
                </tbody>
              </table></td>
            </tr>
            <tr> 
              <td height="25" colspan="4" bgcolor=#FFFFFF class="008c5e"><div align="center">
                  <input name="submit" type="submit" class="go-wenbenkuang" value="提交" ONCLICK="javascript:return checktel()">
                  &nbsp;&nbsp; 
                  <input name="Reset" type="reset" class="go-wenbenkuang" value="重填">
                  &nbsp; 
                  <input name="Submit" type="button" class="go-wenbenkuang" onClick="javascript:window.history.go(-1)" value="返回">
              </div></td>
            </tr>
            <tr>
              <td height="21" colspan="4" valign="middle" background="../image/bk1.gif" bgcolor=F1F1F1 class="008c5e">&nbsp;</td>
            </tr>
          </tbody>
        </table>
      </form> 
<%case else
if request("del")="yes" then
conn.execute("Delete * from telorder where id="&shopnet("id")&"")
end if%>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td><table border="0" align="left" cellpadding="0" cellspacing="0">
      <tr>
        <td width="1"><IMG SRC="../images/mytaobaobj1_3.gif" WIDTH=3 HEIGHT=25 ALT=""></td>
        <td width="120" align="center" background="../images/mytaobaobj1_4.gif"><font color="#FFFFFF">电话订单</a></span></font></td>
        <td width="1"><IMG SRC="../images/mytaobaobj1_6.gif" WIDTH=7 HEIGHT=25 ALT=""></td>
      </tr>
    </table><table border="0" align="left" cellpadding="0" cellspacing="0">
          <tr>
            <td width="1"><IMG SRC="../images/mytaobaobj1_8.gif" WIDTH=3 HEIGHT=25 ALT=""></td>
            <td width="120" align="center" background="../images/mytaobaobj1_9.gif"><font color="#FF0000"><span class="C"><a href="?abc=tel_add">添加电话订单</a><a href="sh.asp"></a></span></font></td>
            <td width="1"><IMG SRC="../images/mytaobaobj1_11.gif" WIDTH=7 HEIGHT=25 ALT=""></td>
          </tr>
      </table><table border="0" align="left" cellpadding="0" cellspacing="0">
          <tr>
            <td width="1"><IMG SRC="../images/mytaobaobj1_8.gif" WIDTH=3 HEIGHT=25 ALT=""></td>
            <td width="120" align="center" background="../images/mytaobaobj1_9.gif"><font color="#FF0000"><span class="C"><a href="sh.asp">送货清单</a></span></font></td>
            <td width="1"><IMG SRC="../images/mytaobaobj1_11.gif" WIDTH=7 HEIGHT=25 ALT=""></td>
          </tr>
      </table><table border="0" align="left" cellpadding="0" cellspacing="0">
          <tr>
            <td width="1"><IMG SRC="../images/mytaobaobj1_8.gif" WIDTH=3 HEIGHT=25 ALT=""></td>
            <td width="120" align="center" background="../images/mytaobaobj1_9.gif"><font color="#FF0000"><span class="C"><a href="dingdan.asp">商品订单</a></span></font></td>
            <td width="1"><IMG SRC="../images/mytaobaobj1_11.gif" WIDTH=7 HEIGHT=25 ALT=""></td>
          </tr>
      </table></td>
  </tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td height="4" bgcolor="1E88C1"></td>
  </tr>
</table>
<table width="570" height="30" border="0" align="center" cellpadding="0" cellspacing="0">
        <form name="form1" method="post" action="?del=yes">
    <tr align="center" valign="top"> 
      <td width="40%"> 
        <div align="center"><br>
          客户名称、地址 
                <input name="keywords" type="text" class="wenbenkuang" size="10">
          <input name="Submit2" type="submit" class="go-wenbenkuang" value="查找">
        </div></td>
            <td width="40%"><br>
              所订产品名称 
              <input name="keywords2" type="text" class="wenbenkuang" size="10"> 
        <input name="Submit22" type="submit" class="go-wenbenkuang" value="查找">      </td>
      <td width="20%"><a href="?abc=tel_add"></a></td>
    </tr></form>
  </table>
  <br>
<table width="100%" border="0" align="center" bgcolor="#CCCCCC" cellpadding="0" cellspacing="1">
  <tr bgcolor="#f1f1f1" valign="middle" align="center"> 
    <td width="102" height="21" valign="middle" background="../image/bk.gif"> <div align="center">订单ID</div></td>
    <td width="126" height="21" valign="middle" background="../image/bk.gif"> <div align="center">订单录入时间</div></td>
    <td width="83" height="21" valign="middle" background="../image/bk.gif">发货方式</td>
    <td width="73" height="21" valign="middle" background="../image/bk.gif">数量</td>
    <td width="81" height="21" valign="middle" background="../image/bk.gif">状态</td>
    <td width="46" height="21" valign="middle" background="../image/bk.gif">修改</td>
    <td width="51" height="21" valign="middle" background="../image/bk.gif">删除</td>
  </tr>
<%set rs=server.createobject("adodb.recordset")
 keywords=shopnet("keywords")
 keywords2=shopnet("keywords2")
  xs=shopnet("xs")
if keywords<>"" then 
   sql="select * from telorder where telname='"&telname&"'order by datetime desc" 
else if keywords2<>"" then 
   sql="select * from telorder where telname='"&telname&"'order by datetime desc"
   else 
   if xs<>"" then
   sql="select * from telorder where telname='"&telname&"' and "&xs&" order by datetime desc "
   else 
   sql="select * from telorder where userid="&myuserid&" order by datetime desc "
    end if
	end if 
	end if
	rs.open sql,conn,3,1
  if rs.eof then
  response.write "<tr><td colspan=7 align=center bgcolor=white height=21 valgin=bottom >没有电话订单！</td></tr>"
  else	
	 
page1("15")
i=1
do while not rs.eof and i<=rs.pagesize%>
  <tr bgcolor="#FFFFFF" valign="middle" align="center"> 
    <td width="102" height="21" valign="middle" > <a href="telorderinfo.asp?id=<% =rs("id")%>" target="_blank">
      <% =rs("spn")%></a></td>
    <td width="126" height="21" valign="middle"> <div align="center"> 
        <%=rs("datetime")%>
      </div></td>
    <td width="83" height="21" valign="middle">
      <%if rs("fahuo")="1" then 
		    response.write "<font color=red>EMS</color>"
		    elseif rs("fahuo")="2" then 
			esponse.write "快递"
		    else   
			response.write "平邮" 
		    end if %>
</td>
    <td width="73" height="21" valign="middle"><%=rs("number")%></td>
    <td width="81" height="21" valign="middle">[ 
      <%if rs("chuli")="0" then 
		   response.write "<font color=red>未收款</color>"
		   elseif rs("chuli")="1" then 
			response.write "已收款"
		   elseif rs("chuli")="2" then
			response.write "已发货" 
		   elseif rs("chuli")="3" then
			response.write "完成" 
		     end if %>
      ]</td>
    <td width="46" height="21" valign="middle"> <a href="?abc=tel_x&id=<% =rs("id")%>">修改</a></td>
    <td width="51" height="21" valign="middle"><a href="?abc=del&del=yes&id=<% =rs("id")%>&page=<%= page %>">删除</a></td>
  </tr>
  <%i=i+1
 rs.MoveNext                                              
 loop %>
  <tr bgcolor="#FFFFFF" valign="middle" align="center"> 
      <td height="21" colspan="7" valign="middle" background="../image/bk1.gif" > 
        <%page2("keywords="&keywords&"&keywords2="&keywords2&"&xs="&xs&"&")
rs.close
set rs=nothing
end if 
%><%=msg%></td>
  </tr>
</table>
<%End Select%></td>
</tr>
</table>
<br>
<!--#include file="../bottom.asp"-->
