<!--#include virtual="/incs/config.asp" -->
<!--#include virtual="/incs/top.asp" -->
<%
chk_log()
chk_newpwr 1,2,1

	sqnme=SafeRequest("sqnme")
	If sqnme="" Then
	call errorpage(-2,"对不起，参数错误！")
	End If
if session("sysclass")>=5 then
query="select * from v_sqllst   where sq_nme ='"&sqnme&"'"
elseif session("sysclass")>=4 then
query="select * from v_sqllst  where sq_nme ='"&sqnme&"'  and  ((("&session("sysarestr")&" or u_myare=0) and u_rotnme='') or u_rotnme='"&session("usrname")&"')"
else
query="select * from v_sqllst   where sq_nme ='"&sqnme&"' sq_unme='"&session("usrname")&"'"
end if
conn.open constr
rs.open query,conn,1,1
if rs.recordcount<>1 then
     call errorpage(-2,"对不起，该订单不存在或者不属于您的会员号，管理员请先切换到该订单会员！...")
elseif cint(rs("sq_regtpe"))<>0 then
     call errorpage(-2,"对不起，数据库类型有误！...")

elseif cint(rs("sq_regstt"))=0 then
     call errorpage(-2,"对不起，该数据库还没有开通！...")
else
        sq_prd=ucase(trim(rs("sq_prd")))
        sq_nme=trim(rs("sq_nme"))
		If rs("sq_addtme")<> "" Then
			sq_addtme=left(replace(rs("sq_addtme")," ","   "),10)
		End If
		If rs("sq_exptme")<> "" Then
			sq_exptme=left(replace(rs("sq_exptme")," ","   "),10)
		End If
			g_nme=trim(rs("g_nme"))
			sq_prcstr=rs("sq_prcstr")
			years=rs("years")
			 g_sst=rs("sq_sst")
query="select * from memlst where u_nme='"&rs("sq_unme")&"'"
rs1.open query,conn,1,1
if not rs1.eof then
ownerclass=rs1("u_prc")
owneruser=rs("sq_unme")
end if
rs1.close
end if
rs.close
%>
<script>
	function chk_frm2()
	{
		
		 
		if (confirm("如果确认，系统将扣除续费的相应款项！"))
		return true;
		else
		return false;	
		
	}
	</script>
<table cellspacing=2 cellpadding=0 width="100%" border=0>
  <tbody> 
  <tr> 
    <td  colspan=2 valign="middle"> 
      <table class=line cellspacing=0 cellpadding=0 width="100%" 
                  border=0 align="center">
        <tbody> 
        <tr> 
          <td valign=bottom width="25%" height=20><b>数据库列表</b><a class=commonface href="index.asp"><font color="#FF0000">（查询）</font></a></td>
          <td valign=bottom noWrap align=right 
                        width="75%"><a class=commonface  href="sql_lst.asp?querytype=8">今天新开通</a> 
            | <a  class=commonface href="sql_lst.asp?querytype=9">本周新开通</a> | 
            <a class=commonface  href="sql_lst.asp?querytype=10">本周到期</a> | <a  class=commonface href="sql_lst.asp?querytype=11">本月到期</a></td>
        </tr>
        <tr> 
          <td align=middle width="100%" colspan=2 height=5></td>
        </tr>
        <tr> 
          <td align=middle width="100%" colspan=2 height=2 class=menuline></td>
        </tr>
        </tbody> 
      </table>
      <br>
    </td>
  </tr>
  <tr> 
    <td  colspan=2 valign="middle" height="28"> 
      <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
        <tr> 
          <td> 
            <!--#include file="menu.asp"-->
          </td>
        </tr>
      </table>
      <table   bordercolor="#5785B2" cellpadding="0" cellspacing="0" id="AutoNumber3" style="border-collapse: collapse" width="100%" align="center">
        <form action="sql_try_rez.asp" name=renew method=post>
          <tr> 
            <td valign="top"> 
              <div align="center"><font color="#0000FF"><b><font color="#0000B5"><br>
                数据库转正</font></b></font><br>
                <br>
                <div align="center"> </div>
                <table border=0 cellpadding=0 
                        cellspacing=0 class=datalist align="center"  width="80%">
                  <tbody> 
                  <tr > 
                    <th class=datalistheader width="35%" align=center> 
                      <div align="center">需要转正的产品</div>
                    </th>
                    <th class=datalistheader align="left" > 
                      <input type="text" name="textfield" class=normalform  readonly size="30" value="<%=sq_nme%>" style="background-color:#cccccc;color:#ff0000">
                    </th>
                  </tr>
                  <%if trim(owneruser)<>trim(entryuser) then %>
                  <tr > 
                    <td height="28" class=datalistgrida  align=center>注意事项</td>
                    <td height="28" class=datalistgrida>该产品所属会员为：<b><%=owneruser%></b>，转正将扣除会员 
                      <b><%=owneruser%></b> 的款项！ </td>
                  </tr>
                  <%end if %>
                  <tr > 
                    <td height="25" class=datalistgrida  align=center>产品类型</td>
                    <td height="25" class=datalistgrida > 
                      <input type="text" name="textfield2" class=normalform readonly size="30" value="<%=g_nme%>（<%=sq_prd%>）" >
                    </td>
                  </tr>
                  <tr > 
                    <td height="25"  class=datalistgrida  align=center>请选择购买时间</td>
                    <td height="25" class=datalistgrida > 
                      <input type="text" name="years" class=normalform   size="10" value="<%=years%>">
                      X 
                      <select name="sq_prcstr" style="font-size: 9pt" size="1" >
                        <% 
					  
					  query="select * from v_prclst where p_prd='"&sq_prd&"' and p_cls="&ownerclass&" order by p_tmetpe,p_yar"
					  rs2.open query,conn,1,1
					  while not rs2.eof 
					  p_yar=rs2("p_yar")
					  if p_yar="1" then
					  p_yar=""
					  end if
					  response.write "<option value='"&rs2("p_prcstr")&"'>"&rs2("p_prc")&"元/"&p_yar&tmenmes(rs2("p_tmetpe"))&"</option>"
					  rs2.movenext
					  wend
					  rs2.close
					  %>
                      </select>
                      <input type=hidden name=proid value="<%=sq_prd%>">
                      <input type=hidden name=dbname value="<%=sq_nme%>">
                    </td>
                  </tr>
                  <tr > 
                        <td   a class=datalistgrida align="center" >特殊价格：</td>
                        <td  class=datalistgrida align="left" colspan=2 > 
                          <input type="text" name="newprice" class=normalform   size="28">
                          元 (如果特殊价格不为空，则所扣金额以特殊价格为准；特别注意：如果特殊价格填写为0，则扣款时将扣0元) 
                        </td>
                      </tr>
                  </tbody> 
                </table>
              </div>
              <div align="center"><br>
                <input type="submit" name="Submit" value="转 正" class=btxx onClick="javascript:return chk_frm2();">
                <input type="reset" name="Submit2" value="放 弃"  class=btxx >
                <br>
                <br>
              </div>
            </td>
          </tr>
        </form>
        <tr> 
          <td> 
            <table width="100%" border="0" cellspacing="0" cellpadding="0" style="display:none;" id=identity>
              <tr> 
                <td>&nbsp; </td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
    </td>
  </tr>
  </tbody> 
</table>
<!--#include virtual="/incs/bottom.asp"-->




