📄 upgrade.jsp
字号:
if(tryFlg.equals("1")){
servNoneys=servNoneys+Integer.valueOf(strService[i][2]).intValue();
}
//}
}else{
out.println("<td> </td>");
}
i++;
}
out.println("</tr>");
}
}
// System.out.println("服务 ："+servNoneys);
%>
</table></td>
<td width="5%"> </td>
</tr>
<tr>
<td colspan="3"><hr width="650" color="#cccccc" size="1" /> </td>
</tr>
<tr>
<td height="8" class="m" style="PADDING-TOP: 7px" colspan="3" align="center"><%=igec.site.base.business.DataUtilBusiness.getFieldValue("NAME","TAB_IGECMEBSEV","WHERE ID='S00001'")%></td>
</tr>
<tr>
<td height="5" colspan="3"><hr width="650" color="#cccccc" size="1" /></td>
</tr>
<tr>
<td> </td>
<td align="center" >
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<%
sqlTemp="";
if("1".equals(tryFlg)){
//sqlTemp="select a.PARA from TAB_IGECMEBPVXN a,TAB_MEBUPREG b where a.regid=b.id and b.MEBID='"+user.getStrUserId()+"' and b.TYPE='1' and b.DNFLAG='1' and a.menuid='S00001'";
sqlTemp="select parentid FROM TAB_NEWSTYPE WHERE USEFLAG='1' and id in(select a.PARA from TAB_IGECMEBPVXN a,TAB_MEBUPREG b where a.regid=b.id and b.MEBID='"+user.getStrUserId()+"' and b.TYPE='1' and b.DNFLAG='1' and a.menuid='S00001')";
strService = igec.site.base.business.DataUtilBusiness.getValues("SELECT id,title,parentid FROM TAB_NEWSTYPE WHERE PARENTID='0' AND USEFLAG='1' and id in("+sqlTemp+") union SELECT id,title,parentid FROM TAB_NEWSTYPE WHERE parentid in("+sqlTemp+" and parentid='0')");
}else{
strService = igec.site.base.business.DataUtilBusiness.getValues("SELECT id,title,parentid FROM TAB_NEWSTYPE WHERE PARENTID='0' AND USEFLAG='1'");
}
if(strService!=null){
for(int i=0;i<strService.length;i++){
servSql="";
sqlTemp="";
if(tryFlg.equals("1")){
sqlTemp="select a.PARA from TAB_IGECMEBPVXN a,TAB_MEBUPREG b where a.regid=b.id and b.MEBID='"+user.getStrUserId()+"' and b.TYPE='1' and b.DNFLAG='1' and a.menuid='S00001'";
servSql="SELECT ID,TITLE,MONEY FROM TAB_NEWSTYPE WHERE PARENTID='" + strService[i][0] + "' and id in("+sqlTemp+") AND USEFLAG='1' ORDER BY XH";
}else{
servSql="SELECT ID,TITLE,MONEY FROM TAB_NEWSTYPE WHERE PARENTID='" + strService[i][0] + "' AND USEFLAG='1' ORDER BY XH";
}
String strNewsType[][] = igec.site.base.business.DataUtilBusiness.getValues(servSql);
out.println("<tr><td colspan=\"5\" bgcolor=\"rgb(239,248,254)\" align=\"left\"> " + strService[i][1] + "</td></tr>");
if(strNewsType.length>0){
for(int n=0;n<strNewsType.length;){
out.println("<tr align=\"left\">");
for(int t=0;t<5;t++){
if(n<strNewsType.length){
String strServicePath=igec.site.base.business.SysUtilBusiness.getStrPath(strNewsType[n][0],"PARENTID","TITLE","TAB_NEWSTYPE");
strServicePath=strServicePath.substring(strServicePath.indexOf(">")+1);
out.println("<td><input type=\"Checkbox\" name=\"newstype\" value=\"" + strNewsType[n][0] + "\" money=\"" + strNewsType[n][2] + "\" onclick=\"javascript:countCost('newstype');\" "+disabledStr+"> " + strServicePath + "(" + strNewsType[n][2] + "元/年)</td>");
if(tryFlg.equals("1")){
//String sunNum=igec.site.base.business.DataUtilBusiness.getFieldValue("count(id)", "TAB_NEWSTYPE","where PARENTID='"+strNewsType[n][0]+"'");
//System.out.println(sunNum);
//if(sunNum.equals("0"))
newsTypeMoneys=newsTypeMoneys+(Integer.valueOf(strNewsType[n][2])).intValue();
}
}else{
out.println("<td> </td>");
}
n++;
}
out.println("</tr>");
}
}else{
String strNewsType2[][] = igec.site.base.business.DataUtilBusiness.getValues("SELECT ID,TITLE,MONEY FROM TAB_NEWSTYPE WHERE id='" + strService[i][0] + "' AND USEFLAG='1' ORDER BY XH");
out.println("<tr align=\"left\">");
out.println("<td><input type=\"Checkbox\" name=\"newstype\" value=\"" + strNewsType2[0][0] + "\" money=\"" + strNewsType2[0][2] + "\" onclick=\"javascript:countCost(this);\" "+disabledStr+"> " + strNewsType2[0][1] + "(" + strNewsType2[0][2] + "元/年)</td>");
out.println("</tr>");
}
}
}
//System.out.println("新闻："+newsTypeMoneys);
%>
</table></td>
<td> </td>
</tr>
<tr>
<td class="m" style="PADDING-RIGHT: 14px" colspan="3"><hr width="650" color="#cccccc" size="1" /></td>
</tr>
<tr>
<td class="m" style="PADDING-RIGHT: 14px" colspan="3" align="center"><%=igec.site.base.business.DataUtilBusiness.getFieldValue("NAME","TAB_IGECMEBSEV","WHERE ID='S00020'")%></td>
</tr>
<tr>
<td colspan="3"><hr width="650" color="#cccccc" size="1" /></td>
</tr>
<tr>
<td > </td>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<%
strService = igec.site.base.business.DataUtilBusiness.getValues("SELECT PID FROM (SELECT (SELECT COUNT(*) FROM TAB_IGECSMSINFO WHERE PID=a.ID AND USEFLAG='1') AS SONNUM,PID FROM TAB_IGECSMSINFO a WHERE USEFLAG='1') as t WHERE SONNUM=0 GROUP BY PID ORDER BY PID");
if(strService!=null){
for(int i=0;i<strService.length;i++){
out.println("<tr><td colspan=\"5\" bgcolor=\"rgb(239,248,254)\" align=\"left\"> " + igec.site.base.business.SysUtilBusiness.getStrPath(strService[i][0],"PID","TITLE","TAB_IGECSMSINFO") + "</td></tr>");
servSql="";
sqlTemp="";
if(tryFlg.equals("1")){
sqlTemp="select a.PARA from TAB_IGECMEBPVXN a,TAB_MEBUPREG b where a.regid=b.id and b.MEBID='"+user.getStrUserId()+"' and b.TYPE='1' and b.DNFLAG='1' and a.menuid='S00020'";
servSql="SELECT ID,TITLE,COSTMN FROM TAB_IGECSMSINFO WHERE PID='" + strService[i][0] + "' and id in("+sqlTemp+") AND USEFLAG='1' ORDER BY XH";
//System.out.println("servSql 1 "+servSql);
}else{
servSql="SELECT ID,TITLE,COSTMN FROM TAB_IGECSMSINFO WHERE PID='" + strService[i][0] + "' AND USEFLAG='1' ORDER BY XH";
}
String strNewsType[][] = igec.site.base.business.DataUtilBusiness.getValues("SELECT ID,TITLE,COSTMN FROM TAB_IGECSMSINFO WHERE PID='" + strService[i][0] + "' AND USEFLAG='1' ORDER BY XH");
for(int n=0;n<strNewsType.length;){
out.println("<tr align=\"left\">");
for(int t=0;t<5;t++){
if(n<strNewsType.length){
out.println("<td><input type=\"Checkbox\" name=\"sms\" value=\"" + strNewsType[n][0] + "\" money=\"" + strNewsType[n][2] + "\" onclick=\"javascript:countCost('sms');\" "+disabledStr+"> " + strNewsType[n][1] + "(" + strNewsType[n][2] + "元/年)</td>");
if(tryFlg.equals("1")){
smsMoneys=smsMoneys+(Integer.valueOf(strNewsType[n][2])).intValue();
}
}else{
out.println("<td> </td>");
}
n++;
}
out.println("</tr>");
}
}
}
//System.out.println("短信："+smsMoneys);
%>
<tr><td colspan="5" align="left">待接收短信的手机号码：<input type="text" name="recMobile" id="recMobile" size="15" maxlength="13" label="接收短信的手机号码" value="<%=igec.site.base.business.DataUtilBusiness.getFieldValue("MOBILE","TAB_IGECMEBADV","WHERE MEBID='" + user.getStrUserId() + "'")%>" ValueFormat="mobile"></td></tr>
</table></td>
<td > </td>
</tr>
<tr>
<td class="m" style="PADDING-RIGHT: 14px" colspan="3"><hr width="650" color="#cccccc" size="1" /> </td>
</tr>
<tr>
<td colspan="3"><table cellspacing="0" cellpadding="0" width="100%" border="0">
<tbody>
<tr height="30">
<td width="20%">购买服务年数</td><td align="left"><select name="BuyYear" id="BuyYear" EmptyDisable label="购买服务年数" onchange="javascript:yearNum('BuyYear');"><option value="1">一年</option><option value="2">二年</option><option value="3">三年</option><option value="4">四年</option><option value="5">五年</option></select></td><td width="20%"> </td>
</tr>
<tr height="30">
<td width="20%">站内短信条数</td><td align="left"><select name="BuySmsNum" id="BuySmsNum" EmptyDisable label="站内短信条数" onchange="javascript:siteMsgNum('BuySmsNum',<%=strTemtMsgNum%>);"><option value="0">0条</option><option value="1">1000条</option><option value="2">2000条</option><option value="3">3000条</option><option value="4">4000条</option><option value="5">5000条</option></select> 价格：<%=strTemtMsgNum%>元/1000条</td><td width="20%"> </td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td colspan="3"> </td>
</tr>
<tr>
<td colspan="3" class="S" style="BORDER-TOP: rgb(225,233,239) 1px solid; BACKGROUND-COLOR: rgb(239,248,254)" valign="middle" align="center">
<table cellspacing="0" cellpadding="0" width="50%" border="0">
<tbody>
<tr>
<td ><input class="button1" style="COLOR: rgb(132,4,4)" type="submit" value="确认提交" name="submit" /></td>
</tr>
</tbody>
</table> </td>
</tr>
</tbody>
</form>
</table></td>
</tr>
</tbody>
</table></td>
</tr>
</tbody>
</table>
<br />
<br />
<script language=javascript>
allSltMoneys=parseInt("<%=servNoneys+newsTypeMoneys+smsMoneys%>");
document.all["allMoneys"].value=(<%=servNoneys+newsTypeMoneys+smsMoneys%>);
document.onkeydown=nextpage
function nextpage(event) {
event = event ? event : (window.event ? window.event : null);
if (event.keyCode==13) userlogin();
}
function isSelectService(obj) {
if(allSltMoneys<=0){
alert("请选择相应服务进行升级！");
return false;
}else{
return Check(obj);
}
}
</script>
<script language="JavaScript">
function userlogin(){
document.loginform.submit();
}
</script>
</div>
</div>
<!--end/content-->
<!--left-->
<div id="leftmenu">
<!--menu-->
<div id="tree1"></div>
<!--end/menu-->
</div>
<!--end/left-->
</div>
<script language="javascript" src="<%=strOfficeStyle%>/menu.jsp?iid=<%=request.getParameter("iid")%>"></script>
<script type="text/javascript">treeInit();</script>
<%@ include file="../bot.jsp"%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -