listuser1.asp

佳可商务购物程序v1.0

          <option value="<%=rs_s("ShengNo")%>" ><%=trim(rs_s("ShengName"))%></option>
<%
     end if
    rs_s.movenext
wend
rs_s.close
set rs_s=nothing
%>
    </select> 
    <select size="1" name="szShi">
<%
set rs_s=server.createobject("adodb.recordset")
sql="select * from szShi where shengid="&tmpShengid&" order by shiorder"
rs_s.open sql,conn,1,1
while not rs_s.eof
%>
          <option value="<%=rs_s("ShiNo")%>" <%if rs("szShi")=rs_s("ShiNo") then%>selected<%end if%>><%=trim(rs_s("ShiName"))%></option>
<%
    rs_s.movenext
wend
rs_s.close
set rs_s=nothing
%>
    </select> 
                                    </td>
                                  </tr>
                                  <tr> 
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">详细地址：</td>
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"> 
                                      <input name="shouhuodizhi" type="text" id="shouhuodizhi" size="30" value="<%=trim(rs("shouhuodizhi"))%>">
                                    </td>
                                  </tr>
                                  <tr> 
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">邮编：</td>
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"> 
                                      <input name="youbian" type="text" id="youbian" size="12" value="<%=rs("youbian")%>" maxlength=6 onKeyPress="event.returnValue=IsDigit();">
                                    </td>
                                  </tr>
                                  <tr> 
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">联系电话：</td>
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"> 
                                      <input name="usertel" type="text" id="usertel" size="12" value="<%=trim(rs("usertel"))%>">
                                    </td>
                                  </tr>
                                  <tr> 
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">推荐人：</td>
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"> 
                                      <input name="MomName" type="text" id="usertel" size="12" value="<%=trim(rs("MomName"))%>">
                                    </td>
                                  </tr>
                                  <tr> 
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">身份证：</td>
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"> 
                                      <input name="MomNo" type="text" id="usertel" size="12" value="<%=trim(rs("MomNo"))%>" maxlength=18 onKeyPress="event.returnValue=IsDigit();">
                                    </td>
                                  </tr>
                                  <tr> 
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">推荐时期：</td>
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"> 
                                      <input name="yuchan" type="text" id="usertel" size="12" value="<%=trim(rs("yuchan"))%>" maxlength=8 onKeyPress="event.returnValue=IsDigit();">
                                    </td>
                                  </tr>
                                  <tr> 
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">性别：</td>
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"><select name=babysex ID=Select1><option value=3 <%if rs("babysex")=3 then%>selected<%end if%>>请选择</option><option value=0 <%if rs("babysex")=0 then%>selected<%end if%>>男</option><option value=1 <%if rs("babysex")=1 then%>selected<%end if%>>女</option></select>
                                    </td>
                                  </tr>
                                  <tr> 
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">送货方式：</td>
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"> 
    <%
	set rs_s=Server.createobject("adodb.recordset")
	rs_s.open "select * from shop_songhuo where songid="&rs("songhuofangshi"),conn,1,1
	response.write rs_s("subject")
	rs_s.close
	set rs_s=nothing
	%>
                                    </td>
                                  </tr>
                                  <tr> 
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">支付方式：</td>
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"> 
    <%
	set rs_s=Server.createobject("adodb.recordset")
	rs_s.open "select * from shop_songhuo where songid="&rs("zhifufangshi"),conn,1,1
	response.write rs_s("subject")
	rs_s.close
	set rs_s=nothing
	%>
                                    </td>
                                  </tr>
                                  <tr> 
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">用户金额：</td>
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"> 
                                      <input name="xbjq" type="text" id="usertel" size="12" value="<%=trim(rs("xbjq"))%>">
                                    </td>
                                  </tr>
                                  <tr> 
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">注册时间：</td>
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"><%=rs("adddate")%></td>
                                  </tr>
                                  <tr> 
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">最后登陆时间：</td>
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"><%=rs("lastlogin")%></td>
                                  </tr>
                                  <tr> 
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">登陆次数：</td>
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"><%=rs("logins")%>次</td>
                                  </tr>
                                  <tr> 
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">已下订单数：</td>
                                    <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"> 
                                      <%dim rs2
			set rs2=server.CreateObject("adodb.recordset")
			rs2.open "select distinct(dingdan) from shop_action where username='"&trim(rs("username"))&"' ",conn,1,1
			response.write rs2.recordcount&"笔订单"
			rs2.close
			set rs2=nothing
			%>
                                    </td>
                                  </tr>
                                  <tr> 
                                    <td height="28" colspan="2" bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">查找此用户的所有定单： 
                                      <select name="zhuangtai" onChange="var jmpURL=this.options[this.selectedIndex].value ; if(jmpURL!='') {window.location=jmpURL;} else {this.selectedIndex=0 ;}" ><base target=Right> 
                                        <option value="" selected>--选择查讯状态--</option>
                                        <option value="editdingdan.asp?zhuangtai=0&namekey=<%=trim(rs("username"))%>" >全部订单状态</option>
                                        <option value="editdingdan.asp?zhuangtai=1&namekey=<%=trim(rs("username"))%>" >未作任何处理</option>
                                        <option value="editdingdan.asp?zhuangtai=2&namekey=<%=trim(rs("username"))%>" >用户已经划出款</option>
                                        <option value="editdingdan.asp?zhuangtai=3&namekey=<%=trim(rs("username"))%>" >服务商已经收到款</option>
                                        <option value="editdingdan.asp?zhuangtai=4&namekey=<%=trim(rs("username"))%>" >服务商已经发货</option>
                                        <option value="editdingdan.asp?zhuangtai=5&namekey=<%=trim(rs("username"))%>" >用户已经收到货</option>
                                      </select>
                                    </td>
                                  </tr>
                                  <%rs.close
			set rs=nothing
			conn.close
			set conn=nothing%>
                                  <tr> 
                                    <td height="28" colspan="2" bgcolor="#E8F1FF"> 
                                      <div align="center"> 
                                        <input type="submit" name="Submit" value="确认提交">
                                        &nbsp;&nbsp;&nbsp; 
                                        <input type="button" name="Submit2" value="返回上一页" onClick='javascript:history.go(-1)'>
                                      </div>
                                    </td>
                                  </tr>
                                </table>
                              </form>
                            </td>
                          </tr>
                        </table>
                      </td>
                    </tr>
                  </table>
                </td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
    </td>
  </tr>
</table>
<!--#include file="copyright.asp"-->

</body>
</html>