repaymaildo.asp

蓝芒3.0A最新所有功能完整破解版

<% ModuleCode="M0510" %>
<!--#include file="../../Include/Reference.asp"-->
<%
Call PrintPageHead
PostID=Request.Form("ID")
UserID=session("UserID")
%>
<!--#include file="../../Include/connect.asp"-->
<%
strSQL="Select * from v_MailList Where PostID='" & PostID & "'"
if Session("ISADMIN")<>"YES" then
	strSQL = strSQL & " and UserID=" & Session("UserID")
end if

Set Rs= Server.CreateObject("ADODB.Recordset")
Rs.open strSQL,Cn,1,1
If Rs.Eof Then
	Response.Write "<br><br><P align='center' class='titletext'>对不起, 找不到此邮局或者您没有权限！</p>"
else
%>
<!--#include file="MailMenu.asp"-->
<!--#include file="../../Include/WEBCtrl.asp"-->
<%
	ProdYear=Request.Form("ProdYear")
	BuyYear=Request.Form("BuyYear")

	if BuyYear="" or (not IsNumeric(BuyYear)) then
		Response.Write "<br><br><br><p align='center' class='titletext'>请输入购买的年限！"
		Call PrintPageBottom
		Response.End
	end if
	HowLong=Cint(BuyYear)*Cint(ProdYear)
	BeginDate=Rs("ETime")
	EndDate=DateAdd("yyyy",HowLong,BeginDate)
	strEndDate=FormatDate(EndDate)

	Set Rs1 = Server.CreateObject("ADODB.Recordset")
	strSQL="Select HaveMoney, LevelCode from T_DNS_UserInfo Where UserID=" & UserID
	Rs1.open strSQL,Cn
	if Rs1.eof then
		Rs1.Close
		Response.Write "<br><br><br><p align='center' class='titletext'>用户错误，无法购买！"
		Call PrintPageBottom
		Response.End
	else
		UserLevel=Rs1("LevelCode")
		HaveMoney=CCur(Rs1("HaveMoney"))
	end if
	Rs1.Close
	
	strSQL="Select ProdPrice from T_DNS_ProdPrice Where ProdCode='" & Rs("ProdCode") & "' and LevelCode='" & UserLevel & "' and ProdYear='" & ProdYear & "'"
	Rs1.open strSQL,Cn
	if Rs1.eof then
		Rs1.Close
		Response.Write "<br><br><br><p align='center' class='titletext'>错误，无法购买！"
		Call PrintPageBottom
		Response.End
	else
		HowMuch=CInt(HowLong)*CCur(Rs1("ProdPrice"))
	end if
	Rs1.Close
	Set Rs1=Nothing
	
	if HaveMoney<HowMuch then
		Response.Write "<br><br><br><p align='center' class='titletext'>对不起，您的帐户余额不足，请先给您的帐户充值！"
		Call PrintPageBottom
		Response.End
	end if
	
	strSQL="exec SP_RePay " & +_
		"" & Rs("UserID") & "," & +_
		"" & Session("UserID") & "," & +_
		"" & HowMuch & "," & +_
		"" & HowLong & "," & +_
		"'" & Rs("UOID") & "'," & +_
		"'" & Request.ServerVariables("REMOTE_ADDR") & "'"
	Set RsResult = Cn.Execute(strSQL)
	if RsResult("result")="1" then
		Response.Write "<br><br><P align='center' class='titletext'>产品续费成功！</p>"
	else
		Response.Write "<br><br><P align='center' class='titletext'>" & RsResult("msg") & "</p>"
	end if
	RsResult.Close
	Set RsResult=Nothing


end if

Rs.Close
Set Rs=Nothing
Cn.Close
Set Cn=Nothing
Call PrintPageBottom
%>

<%
Function FormatDate(iDate)
	FormatDate=DatePart("yyyy",iDate) & "-" & DatePart("m",iDate) & "-" & DatePart("d",iDate)
End Function
%>