adduser.asp

商务网络站点程序

                      <td align="center"><font color="#000000">银行帐号</font></td>
                      <td align="center"><font color="#000000">开户行</font></td>
                      <td align="center"><font color="#000000">EMAIL</font></td>
                      <td align="center"><font color="#000000">QQ</font></td>
                      <td align="center"><font color="#000000">激活状态</font></td>
                    </tr>
                    <%			
  set rs10=server.createobject("adodb.recordset")
  sql10="select * from user where username = '"&user&"'"
  rs10.open sql10,conn,3,2
  if not rs10.eof  then
%>
                    <tr class="font"> 
                      <td height="24" align="center" bgcolor="#66CC66"><font color="#000000">1、</font></td>
                      <td align="center"><font color="#000000"><%=rs10(3)%></font></td>
                      <td align="center"><font color="#000000"><%=rs10(5)%></font></td>
                      <td align="center"><font color="#000000"><%=rs10(4)%></font></td>
                      <td align="center"><font color="#000000"><%=rs10(7)%></font></td>
                      <td align="center"><font color="#000000"><%=rs10(9)%></font></td>
                      <td align="center"><font color="#000000">未激活</font></td>
                    </tr>
                    <tr class="font"> 
                      <td width="8%" align="center" bgcolor="#66CC66" class="border2"><font color="#000000">地址：</font></td>
                      <td colspan="4" align="center" class="border2"><font color="#000000"><%=rs10(10)%></font></td>
                      <td width="9%" align="center" bgcolor="#66CC66" class="border2"><font color="#000000">邮政编码：</font></td>
                      <td width="20%" align="center" class="border2"><font color="#000000"><%=rs10(11)%></font></td>
                    </tr>
                    <%   end if
set rs11=server.createobject("adodb.recordset")
  sql11="select * from user where username = '"&user1&"'"
  rs11.open sql11,conn,3,2
  if not rs11.eof  then
%>
                    <tr class="font"> 
                      <td height="24" align="center" bgcolor="#66CC66"><font color="#000000">2、</font></td>
                      <td align="center"><font color="#000000"><%=rs11(3)%></font></td>
                      <td align="center"><font color="#000000"><%=rs11(5)%></font></td>
                      <td align="center"><font color="#000000"><%=rs11(4)%></font></td>
                      <td align="center"><font color="#000000"><%=rs11(7)%></font></td>
                      <td align="center"><font color="#000000"><%=rs11(9)%></font></td>
                      <td align="center"><font color="#000000">未激活</font></td>
                    </tr>
                    <tr class="font"> 
                      <td width="8%" align="center" bgcolor="#66CC66"><font color="#000000">地址：</font></td>
                      <td colspan="4" align="center" class="border2"><font color="#000000"><%=rs11(10)%></font></td>
                      <td width="9%" align="center" bgcolor="#66CC66" class="border2"><font color="#000000">邮政编码：</font></td>
                      <td width="20%" align="center" class="border2"><font color="#000000"><%=rs11(11)%></font></td>
                    </tr>
                    <%   end if
set rs12=server.createobject("adodb.recordset")
  sql12="select * from user where username = '"&user2&"'"
  rs12.open sql12,conn,3,2
  if not rs12.eof  then
%>
                    <tr class="font"> 
                      <td height="22" align="center" bgcolor="#66CC66"><font color="#000000">3、</font></td>
                      <td align="center"><font color="#000000"><%=rs12(3)%></font></td>
                      <td align="center"><font color="#000000"><%=rs12(5)%></font></td>
                      <td align="center"><font color="#000000"><%=rs12(4)%></font></td>
                      <td align="center"><font color="#000000"><%=rs12(7)%></font></td>
                      <td align="center"><font color="#000000"><%=rs12(9)%></font></td>
                      <td align="center"><font color="#000000">未激活</font></td>
                    </tr>
                    <tr class="font"> 
                      <td width="8%" align="center" bgcolor="#66CC66"><font color="#000000">地址：</font></td>
                      <td colspan="4" align="center" class="border2"><font color="#000000"><%=rs12(10)%></font></td>
                      <td width="9%" align="center" bgcolor="#66CC66" class="border2"><font color="#000000">邮政编码：</font></td>
                      <td width="20%" align="center" class="border2"><font color="#000000"><%=rs12(11)%></font></td>
                    </tr>
                    <%   end if
set rs13=server.createobject("adodb.recordset")
  sql13="select * from user where username = '"&user3&"'"
  rs13.open sql13,conn,3,2
  if not rs13.eof   then
%>
                    <tr class="font"> 
                      <td height="25" align="center" bgcolor="#66CC66"><font color="#000000">4、</font></td>
                      <td align="center"><font color="#000000"><%=rs13(3)%></font></td>
                      <td align="center"><font color="#000000"><%=rs13(5)%></font></td>
                      <td align="center"><font color="#000000"><%=rs13(4)%></font></td>
                      <td align="center"><font color="#000000"><%=rs13(7)%></font></td>
                      <td align="center"><font color="#000000"><%=rs13(9)%></font></td>
                      <td align="center"><font color="#000000">未激活</font></td>
                    </tr>
                    <tr class="font"> 
                      <td width="8%" align="center" bgcolor="#66CC66"><font color="#000000">地址：</font></td>
                      <td colspan="4" align="center" class="border2"><font color="#000000"><%=rs13(10)%></font></td>
                      <td width="9%" align="center" bgcolor="#66CC66" class="border2"><font color="#000000">邮政编码：</font></td>
                      <td width="20%" align="center" class="border2"><font color="#000000"><%=rs13(11)%></font></td>
                    </tr>
                    <%end if%>
<%	set rs4=server.createobject("adodb.recordset")
   sql4="select * from admin where id = 0"
   rs4.open sql4,conn,3,2  
   if not rs4.eof  and rs4("key")=1 then
%>				
                    <tr class="font"> 
                      <td height="22" align="center" bgcolor="#66CC66"><font color="#000000">5、</font></td>
                      <td align="center"><font color="#000000"><%=rs4("name")%></font></td>
                      <td align="center"><font color="#000000"><%=rs4("card")%></font></td>
                      <td align="center"><font color="#000000"><%=rs4("bank")%></font></td>
                      <td align="center"><font color="#000000"><%=rs4("email")%></font></td>
                      <td align="center"><font color="#000000"><%=rs4("QQ")%></font></td>
                      <td align="center"><font color="#000000">未激活</font></td>
                    </tr>
                    <tr class="font"> 
                      <td width="8%" align="center" bgcolor="#66CC66"><font color="#000000">地址：</font></td>
                      <td height="22" colspan="4" align="center"><font color="#000000"><%=rs4("address")%></font></td>
                      <td width="9%" align="center" bgcolor="#66CC66"><font color="#000000">邮政编码：</font></td>
                      <td height="22" align="center"><font color="#000000"><%=rs4("postcard")%></font></td>
                    </tr><%end if%>
					
                  </table>
                </td>
              </tr>
            </table>
            <br>
          </div>
          <table width="64%" border="0" align="center" height="46">
            <tr bgcolor="#66CC66"> 
              <td colspan="6"> 
                <div align="center"><font size="2"><font size="3" color="#0000CC">付费金额</font></font></div>
              </td>
            </tr>
            <tr> 
              <td height="22"> 
                <div align="center"><font color="#000000" size="2">1号</font></div>
              </td>
              <td height="22"> 
                <div align="center"><font color="#000000" size="2">2号</font></div>
              </td>
              <td height="22"> 
                <div align="center"><font color="#000000" size="2">3号</font></div>
              </td>
              <td height="22"> 
                <div align="center"><font color="#000000" size="2">4号</font></div>
              </td>
              <td height="22"> 
                <div align="center"><font color="#000000" size="2">5号</font></div>
              </td>
            </tr>
            <tr> 
              <td height="23"> 
                <div align="center"><font color="#FF0000"><font size="2"><font color="#990000">10</font><font size="2" color="#990000">元</font></font></font></div>
              </td>
              <td height="23"> 
                <div align="center"><font color="#FF0000"><font size="2"><font color="#990000">10</font><font size="2" color="#990000">元</font></font></font></div>
              </td>
              <td height="23"> 
                <div align="center"><font color="#FF0000"><font size="2"><font color="#990000">10</font><font size="2" color="#990000">元</font></font></font></div>
              </td>
              <td height="23"> 
                <div align="center"><font color="#FF0000"><font size="2"><font color="#990000">10</font><font size="2" color="#990000">元</font></font></font></div>
              </td>
              <td height="23"> 
                <div align="center"><font color="#FF0000"><font size="2"><font color="#990000">10</font><font size="2" color="#990000">元</font></font></font></div>
              </td>
            </tr>
          </table>
          <br>
          <div align="center" class="font" style="width: 710; height: 24"><strong><font color="#0033FF">注意：5号为系统空间管理维护费不加入循环。如果有空号说明该会员因违规被开除，所以不用寄，银行账号为0说明该会员委托系统代收，请把他的款寄给5号。</font></strong> 
          </div>
          <p align="center"><font size="2"> </font></p>
        </div>
      </td>
    </tr>
  </table>
</div>
</body>
</html>