<%
response.buffer=false
%>
<!--#include virtual="/incs/config.asp" -->
<!--#include virtual="/incs/top.asp" -->


<%
chk_log()
chk_newpwr 1,2,2

module=trim(SafeRequestform("module"))
dbname=trim(SafeRequestform("dbname"))
sqnme=dbname
if module="" or dbname="" then
call errorpage(-2,"对不起，请选择您需要升级的数据库！")
end if
conn.open constr
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
rs.open query,conn,1,1
if rs.recordcount<>1 then
call errorpage(-2,"对不起，您所选择的数据库不存在或者您无权执行此操作！")
end if

if rs("sq_regtpe")<>1 then
call errorpage(-2,"对不起，试用数据库无法使用升级功能！")
end if
if rs("sq_regstt")<>1 then
call errorpage(-2,"对不起，您所选择的数据库不处在正常状态，无法操作！")
end if
if rs("sq_exptme")<=now() then
call errorpage(-2,"对不起，您的数据库已过期，请先续费！")
end if
if trim(lcase(rs("sq_unme")))<>trim(lcase(session("usrname"))) then
query="select * from memlst where u_nme='"&rs("sq_unme")&"'"
rs1.open query,conn,1,1
entryuser=rs("sq_unme")
entrypass=trim(rs1("u_pss"))
agentname=session("usrname")
agentpass=session("usrpass")
rs1.close
end if

rs.close
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''表单处理 
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''具体操作
select case module
case "prd"

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''表单处理 
   substrContent = "entryclass:sql_odr"&Vend
   substrContent =substrContent& "entrytype:prd"&Vend
   substrContent =substrContent& "entryuser:"&entryuser&Vend
   substrContent =substrContent& "entrypass:"&entrypass&Vend
   substrContent =substrContent& "agentname:"&agentname&Vend
   substrContent =substrContent& "agentpass:"&agentpass&Vend
   substrContent = substrContent & "dbname:" &dbname& Vend
   substrContent = substrContent & "newprd:"& trim(SafeRequestform("newprd")) & Vend
   substrContent = substrContent & "newprice:"& trim(SafeRequestform("newprice")) & Vend
   substrContent = substrContent & "." & Vend

end select

   doresult = hzsocket(substrContent)
   left5=left(doresult,5)
   If left5= "10000" Then
      call okpage( "/master/pdtmng/sql_mng/sql_upd.asp?sqnme=" & dbname)
   Else
      call errorpage(-2,doresult)
   end if

''''''''''''''''''''''''
%>
