📄 right.asp

📁 家庭理财系统方便您与家人管理财产
💻 ASP
字号:
<!--#include file="Inc/const.asp"-->
<!--#include file="cookies.asp"-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<meta http-equiv="Content-Type" content="text/html; charset=GB2312" />
<title>雷诺家庭财务管理系统HomeIO2.0</title>
<link href="Images/admin_css.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="98%" border="0" align="left" cellpadding="0" cellspacing="0">
  <tr>
    <td height="30"><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="15" height="30"><img src="images/tab_03.gif" width="15" height="30" /></td>
        <td width="24" background="images/tab_05.gif"><img src="images/311.gif" width="16" height="16" /></td>
        <td width="1373" background="images/tab_05.gif" class="title1">系统信息</td>
        <td width="14"><img src="images/tab_07.gif" width="14" height="30" /></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="9" background="images/tab_12.gif">&nbsp;</td>
        <td bgcolor="#f3ffe3">
			<%
			dim stryear,foryear
			stryear=year(date())
			foryear=stryear-1
			%>
          <table border="0" align="center" cellpadding="3" cellspacing="1" class="admintable1">
            <tr>
              <td width="33%" align="left" bgcolor="#FFFFFF" style="height:30px;">去年的收入总数：<font color="blue"><b>￥<%=db("SELECT SUM(I_sd) FROM [{pre}in] where year(I_date)="&foryear&"",1)(0)%></b></font>&nbsp;<input type='button' class="sub" onClick="window.location.href='o_excel.asp?mysql=<%=Server.URLEncode("SELECT * FROM [{pre}in] where year(I_date)="&foryear&" order by I_date desc")%>&mytype=i'" value="导出Excel" name="go" id="go"></td>
              <td width="33%" align="left" bgcolor="#FFFFFF">去年的支出总数：<font color="blue"><b>￥<%=db("SELECT SUM(O_sj) FROM [{pre}out] where year(O_date)="&foryear&"",1)(0)%></b></font>&nbsp;<input type='button' class="sub" onClick="window.location.href='o_excel.asp?mysql=<%=Server.URLEncode("SELECT * FROM [{pre}out] where year(O_date)="&foryear&" order by O_date desc")%>&mytype=o'" value="导出Excel" name="go" id="go"></td>
              <td align="left" bgcolor="#FFFFFF">去年的收入-支出：<font color="blue"><b>￥<%=db("SELECT SUM(I_sd) FROM [{pre}in] where year(I_date)="&foryear&"",1)(0)-db("SELECT SUM(O_sj) FROM [{pre}out] where year(O_date)="&foryear&"",1)(0)%></b></font></td>
            </tr>
            <tr>
              <td width="33%" align="left" bgcolor="#FFFFFF" style="height:30px;">今年已经收入了：<font color="blue"><b>￥<%=db("SELECT SUM(I_sd) FROM [{pre}in] where year(I_date)="&stryear&"",1)(0)%></b></font> <font color="blue">[<a href="in.asp">管理</a>]</font></td>
              <td width="33%" align="left" bgcolor="#FFFFFF">今年已经支出了：<font color="blue"><b>￥<%=db("SELECT SUM(O_sj) FROM [{pre}out] where year(O_date)="&stryear&"",1)(0)%></b></font> <font color="blue">[<a href="out.asp">管理</a>]</font></td>
              <td align="left" bgcolor="#FFFFFF"></td>
            </tr>
	    <tr>
              <td width="33%" align="left" bgcolor="#FFFFFF" style="height:30px;">全部收入统计数：<font color="blue"><b>￥<%=db("SELECT SUM(I_sd) FROM [{pre}in]",1)(0)%></b></font>&nbsp;<input type='button' class="sub" onClick="window.location.href='o_excel.asp?mysql=<%=Server.URLEncode("SELECT * FROM [{pre}in] order by I_date desc")%>&mytype=i'" value="导出Excel" name="go" id="go"></td>
              <td width="33%" align="left" bgcolor="#FFFFFF">全部支出统计数：<font color="blue"><b>￥<%=db("SELECT SUM(O_sj) FROM [{pre}out]",1)(0)%></b></font>&nbsp;<input type='button' class="sub" onClick="window.location.href='o_excel.asp?mysql=<%=Server.URLEncode("SELECT * FROM [{pre}out] order by O_date desc")%>&mytype=o'" value="导出Excel" name="go" id="go"></td>
              <td align="left" bgcolor="#FFFFFF">总的收入-支出：<font color="blue"><b>￥<%=db("SELECT SUM(I_sd) FROM [{pre}in]",1)(0)-db("SELECT SUM(O_sj) FROM [{pre}out]",1)(0)%></b></font></td>
            </tr>
          </table>
          <table border="0" cellspacing="2" cellpadding="3"  align="center" class="admintable1" style="margin-top:5px;">
		    <tr> 
              <td colspan="2" align=left class="admintitle">说明</td>
            </tr>
            <tr> 
              <td width="50%" height="100" bgcolor="#FFFFFF" style="text-align:left;"><font color="#FF0000"><b>简单介绍一下HomeIO2.0特点：</b></font><ol>
		<li>简单实用，免费送给大家。只要安装IIS5.0或更高版本就可以运行。</li>
		<li>可以按成员、按时间来录入、分析和统计常见的收入和支出。</li>
		<li>独特的统计列表导出为Excel表格功能，更加方便用户统计，编辑，打印。</li>
              </ol>
	      </td>
              <td bgcolor="#FFFFFF" style="text-align:left;line-height:21px;border-left:1px dashed #BFD99C"></td>
            </tr>
          </table>
          <table border="0" cellspacing="2" cellpadding="3"  align="center" class="admintable1" style="margin-top:5px;">
            <tr>
              <td align="left" class="admintitle">网站初始化</td>
            </tr>
            <tr>
              <td height="80" bgcolor="#FFFFFF" style="text-align:left;line-height:40px;">&nbsp;</td>
            </tr>
          </table></td>
        <td width="9" background="images/tab_16.gif">&nbsp;</td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td height="29"><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="15" height="29"><img src="images/tab_20.gif" width="15" height="29" /></td>
        <td background="images/tab_21.gif">&nbsp;</td>
        <td width="14"><img src="images/tab_22.gif" width="14" height="29" /></td>
      </tr>
    </table></td>
  </tr>
</table>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -