⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 myshhr.asp

📁 购物系统(本版为正式商业版
💻 ASP
📖 第 1 页 / 共 2 页
字号:
rs("username")=checkFFSQLStr(session("username"))
rs("shhrname")=nosql(trim(request("shhrname")))
rs("shhrsex")=nosql(trim(request("shhrsex")))
rs("shhrdz")=nosql(trim(request("shhrdz")))
if trim(request("shhryb"))="" then
rs("shhryb")="000000"
else
rs("shhryb")=nosql(trim(request("shhryb")))
end if
if trim(request("shhrtel"))="" then
rs("shhrtel")="0000000"
else
rs("shhrtel")=nosql(trim(request("shhrtel")))
end if
if trim(request("shhrtel"))="" then
rs("shhremail")="暂无"
else
rs("shhremail")=nosql(trim(request("shhremail")))
end if
rs("shhrdate")=now()
rs.update
rs.close
set rs=nothing
response.write "<script language=javascript>alert('添加成功!');window.location.href='user.asp?action=myshhr';</script>"
response.End
elseif request.QueryString("action")="save" then
id=request.QueryString("id")
if id="" then response.End
			set rs=server.CreateObject("adodb.recordset")
rs.open "select * from shop_myshouhuoren where username='"&checkFFSQLStr(session("username"))&"' and id="&id,conn,1,3
rs("username")=checkFFSQLStr(session("username")))
rs("shhrname")=nosql(trim(request("shhrname")))
rs("shhrsex")=nosql(trim(request("shhrsex")))
rs("shhrdz")=nosql(trim(request("shhrdz")))
rs("shhryb")=nosql(trim(request("shhryb")))
rs("shhrtel")=nosql(trim(request("shhrtel")))
rs("shhremail")=nosql(trim(request("shhremail")))
rs("shhrdate")=now()
rs.update
rs.close
set rs=nothing
response.write "<script language=javascript>alert('修改成功!');window.location.href='user.asp?action=myshhr';</script>"
response.End

elseif request.QueryString("action")="del" then
id=request.QueryString("id")
if id="" then response.End
conn.execute "delete from shop_myshouhuoren where username='"&checkFFSQLStr(session("username"))&"' and id="&id
response.redirect "user.asp?action=myshhr"
elseif request.QueryString("action")="edit" then
id=request.QueryString("id")
if id="" then response.End
			set rs=server.CreateObject("adodb.recordset")
rs.open "select * from shop_myshouhuoren where username='"&checkFFSQLStr(session("username"))&"' and id="&id,conn,1,1
%>
            <table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
               <tr>
                  <td height="1" background="img/lf_directgo_boxdotline.gif"></td>
				                    <td height="1" background="img/lf_directgo_boxdotline.gif"></td>
              </tr><tr  class="a1"> 
                <td height="26" colspan="2"   style='PADDING-LEFT: 20px'><b>请正确填写以下收货人信息</b></td>
              </tr><tr>
                  <td height="1" background="img/lf_directgo_boxdotline.gif"></td>
				                    <td height="1" background="img/lf_directgo_boxdotline.gif"></td>
              <form name="shouhuoxx" method="post" action="myshhr.asp?action=save&id=<%=rs("id")%>" >
                <tr bgcolor="#FFFFFF"> 
                  <td height="23" bgcolor="#FFFFFF"   ><b>&nbsp;&nbsp;收货人姓名:</b></td>
                  <td height="23"   > &nbsp;&nbsp; <b> 
                    <input name="shhrname" type="text" class="wenbenkuang" id="shhrname" value="<%=rs("shhrname")%>">
                      </b></td>
                </tr><tr bgcolor="#FFFFFF">
                  <td height="1" background="img/lf_directgo_boxdotline.gif" bgcolor="#FFFFFF"></td>
				                    <td height="1" background="img/lf_directgo_boxdotline.gif" bgcolor="#FFFFFF"></td>
                <tr bgcolor="#FFFFFF"> 
                  <td height="23" bgcolor="#FFFFFF"   ><b>&nbsp;&nbsp;收货人性别:</b></td>
                  <td height="23" bgcolor="#FFFFFF"   ><b> &nbsp;&nbsp; <b> </b> 
                    <select name="shhrsex" id="sex" class="wenbenkuang">
                      <option value="1" <%if rs("shhrsex")=1 then%>selected<%end if%>>男</option>
                      <option value="2" <%if rs("shhrsex")=2 then%>selected<%end if%>>女</option>
                      <option value="0" <%if rs("shhrsex")=1 then%>selected<%end if%>>保密</option>
                    </select>
                    </b></td>
                </tr><tr bgcolor="#FFFFFF">
                  <td height="1" background="img/lf_directgo_boxdotline.gif" bgcolor="#FFFFFF"></td>
				                    <td height="1" background="img/lf_directgo_boxdotline.gif" bgcolor="#FFFFFF"></td>
                <tr bgcolor="#FFFFFF"> 
                  <td height="23" bgcolor="#FFFFFF"  ><b>&nbsp;&nbsp;详细地址:</b></td>
                  <td height="23" bgcolor="#FFFFFF"  > <b> &nbsp;&nbsp; 
                    <input name="shhrdz" type="text" class="wenbenkuang" id="shhrdz" value="<%=rs("shhrdz")%>" size="40">
                    </b></td>
                </tr><tr bgcolor="#FFFFFF">
                  <td height="1" background="img/lf_directgo_boxdotline.gif" bgcolor="#FFFFFF"></td>
				                    <td height="1" background="img/lf_directgo_boxdotline.gif" bgcolor="#FFFFFF"></td>
                <tr bgcolor="#FFFFFF"> 
                  <td height="23" bgcolor="#FFFFFF"  ><b>&nbsp;&nbsp;收货人邮编:</b></td>
                  <td height="23" bgcolor="#FFFFFF"  > <p><b> &nbsp;&nbsp; 
                      <input name="shhryb" type="text" class="wenbenkuang" id="shhryb" onKeyPress="event.returnValue=IsDigit();" value="<%=rs("shhryb")%>" size="10">
                      </b>我们将按邮政编码划分送货区域,请您正确填写!</p></td>
                </tr><tr bgcolor="#FFFFFF">
                  <td height="1" background="img/lf_directgo_boxdotline.gif" bgcolor="#FFFFFF"></td>
				                    <td height="1" background="img/lf_directgo_boxdotline.gif" bgcolor="#FFFFFF"></td>
                <tr bgcolor="#FFFFFF"> 
                  <td height="23" bgcolor="#FFFFFF"  ><b>&nbsp;&nbsp;收货人电话:</b></td>
                  <td height="23" bgcolor="#FFFFFF"  > <b> &nbsp;&nbsp; 
                    <input name="shhrtel"  type="text" class="wenbenkuang" id="shhrtel" value="<%=rs("shhrtel")%>">
                    </b></td>
                </tr><tr bgcolor="#FFFFFF">
                  <td height="1" background="img/lf_directgo_boxdotline.gif" bgcolor="#FFFFFF"></td>
				                    <td height="1" background="img/lf_directgo_boxdotline.gif" bgcolor="#FFFFFF"></td>
                <tr bgcolor="#FFFFFF"> 
                  <td height="23" bgcolor="#FFFFFF"  ><b>&nbsp;&nbsp;电子邮件:</b></td>
                  <td height="23" bgcolor="#FFFFFF"  > <b> &nbsp;&nbsp; 
                    <input name="shhremail" type="text" class="wenbenkuang" id="shhremail" value="<%=rs("shhremail")%>">
                    </b></td>
                </tr><tr bgcolor="#FFFFFF">
                  <td height="1" background="img/lf_directgo_boxdotline.gif"></td>
				                    <td height="1" background="img/lf_directgo_boxdotline.gif"></td>
                <b><%=trim(request("useremail"))%> </b> 
                <tr bgcolor="#FFFFFF"> 
                  <td height="21" colspan="2" align=center  > <input type="submit" name="Submit4232" class="go-wenbenkuang" value="下一步" onClick="return ssxx();">                  </td>
                </tr>
              </form>
            </table>
            <%
rs.close
set rs=nothing
			else
%><table width="98%" border="0" align="center" cellpadding="0" cellspacing="1">
              <tr>
                  <td height="1" background="img/lf_directgo_boxdotline.gif"></td>
				                    <td height="1" background="img/lf_directgo_boxdotline.gif"></td><tr  class="a1"> 
                <td height="26" colspan="2"   style='PADDING-LEFT: 20px'><b>请正确填写以下收货人信息</b></td>
              </tr><tr>
                  <td height="1" background="img/lf_directgo_boxdotline.gif"></td>
				                    <td height="1" background="img/lf_directgo_boxdotline.gif"></td>
              <form name="shouhuoxx" method="post" action="myshhr.asp?action=add" onSubmit="ssxx">
                <tr bgcolor="#FFFFFF"> 
                  <td width="117" height="23" bgcolor="#FFFFFF"   ><b>&nbsp;&nbsp;收货人姓名:</b></td>
                  <td width="463" height="23"   > &nbsp;&nbsp; <b> 
                    <input name="shhrname" type="text" class="wenbenkuang" id="shhrname">
                      </b></td>
                </tr><tr>
                  <td height="1" background="img/lf_directgo_boxdotline.gif"></td>
				                    <td height="1" background="img/lf_directgo_boxdotline.gif"></td>
                <tr bgcolor="#FFFFFF"> 
                  <td height="23" bgcolor="#FFFFFF"   ><b>&nbsp;&nbsp;收货人性别:</b></td>
                  <td width="463" height="23"   ><b> &nbsp;&nbsp; <b> </b> 
                    <select name="shhrsex" id="shhrsex" class="wenbenkuang">
                      <option value="1">男</option>
                      <option value="2">女</option>
                      <option value="0">保密</option>
                    </select>
                    </b></td>
                </tr><tr>
                  <td height="1" background="img/lf_directgo_boxdotline.gif"></td>
				                    <td height="1" background="img/lf_directgo_boxdotline.gif"></td>
                <tr bgcolor="#FFFFFF"> 
                  <td width="117" height="23" bgcolor="#FFFFFF"  ><b>&nbsp;&nbsp;详细地址:</b></td>
                  <td height="23" width="463"  > <b> &nbsp;&nbsp; 
                    <input name="shhrdz" type="text" class="wenbenkuang" id="shhrdz" size="40">
                    </b></td>
                </tr><tr>
                  <td height="1" background="img/lf_directgo_boxdotline.gif"></td>
				                    <td height="1" background="img/lf_directgo_boxdotline.gif"></td>
                <tr bgcolor="#FFFFFF"> 
                  <td width="117" height="23" bgcolor="#FFFFFF"  ><b>&nbsp;&nbsp;收货人邮编:</b></td>
                  <td height="23" width="463"  > 
                    <p><b> &nbsp;&nbsp; 
                      <input name="shhryb" type="text" class="wenbenkuang" id="shhryb" size="10" onKeyPress="event.returnValue=IsDigit();">
                      </b>我们将按邮政编码划分送货区域,请您正确填写!</p></td>
                </tr><tr>
                  <td height="1" background="img/lf_directgo_boxdotline.gif"></td>
				                    <td height="1" background="img/lf_directgo_boxdotline.gif"></td>
                <tr bgcolor="#FFFFFF"> 
                  <td width="117" height="23" bgcolor="#FFFFFF"  ><b>&nbsp;&nbsp;收货人电话:</b></td>
                  <td height="23" width="463"  > <b> &nbsp;&nbsp; 
                    <input name="shhrtel" class="wenbenkuang"  type="text" id="shhrtel">
                    </b></td>
                </tr><tr>
                  <td height="1" background="img/lf_directgo_boxdotline.gif"></td>
				                    <td height="1" background="img/lf_directgo_boxdotline.gif"></td>
                <tr bgcolor="#FFFFFF"> 
                  <td width="117" height="23" bgcolor="#FFFFFF"  ><b>&nbsp;&nbsp;电子邮件:</b></td>
                  <td height="23" width="463"  > <b> &nbsp;&nbsp; 
                    <input name="shhremail" type="text" id="shhremail" class="wenbenkuang">
                    </b></td>
                </tr><tr>
                  <td height="1" background="img/lf_directgo_boxdotline.gif"></td>
				                    <td height="1" background="img/lf_directgo_boxdotline.gif"></td>
                <b><%=trim(request("useremail"))%> </b> 
                <tr bgcolor="#FFFFFF"> 
                  <td height="21" colspan="2" align=center  > 
                    <input type="submit" name="Submit423" class="go-wenbenkuang" value="下一步" onClick="return ssxx();"> 
                  </td>
                </tr>
              </form>
            </table>
          <%end if
%>          </td>
        </tr>
      </table></td>
  </tr>
</table>
<!--#include file="copyright.asp"-->
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -