📄 money_find_frame.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%>
<jsp:directive.page import="com.captainli.dboperation.MoneyClassDA"/>
<jsp:directive.page import="com.captainli.bean.AccountlistShowBean"/>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'money_find_frame.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<link rel="stylesheet" type="text/css" href="../css/sys.css">
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-right:0px;
margin-top: 0px;
background-color: #FFFFFF;
}
.button {font:normal 12px/120% Verdana,'宋体';height:18px;
border-left:1px red solid;
border-top:1px red solid;
border-right:1px red solid;
border-bottom:1px red solid;
background: #dddddd;}
a:link {
color: #1A438E;
text-decoration: underline;
}
a:visited {
text-decoration: underline;
}
a:hover {
text-decoration: none;
color: #000000;
}
a:active {
text-decoration: underline;
}
.button1 {font:normal 12px/120% Verdana,'宋体';height:18px;
border-left:1px red solid;
border-top:1px red solid;
border-right:1px red solid;
border-bottom:1px red solid;
background: #dddddd;}
-->
</style>
<script language="javascript" type="text/javascript">
function del(){
var go = window.confirm("确定要清空所有单据？\n\n删除所有单据将不能恢复！\n\n按“确定”继续，或按“取消”返回。");
if(go){
window.location.href="../money.do?method=moneyDel";
}else{
return false;
}
}
</script>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"></head>
<%
int m_mbc_type = 0;
int m_b_id = 0;
int m_mbc_id = 0;
int m_msc_id = 0;
ArrayList arryAccountlistShow = null;
%>
<%
if(request.getParameter("m_mbc_type") != null && request.getParameter("m_b_id") != null && request.getParameter("m_mbc_id") != null && request.getParameter("m_msc_id") != null){
if(request.getParameter("m_mbc_type").toString().equals("0")){
if(request.getParameter("m_b_id").toString().equals("0")){
if(request.getParameter("m_mbc_id").toString().equals("0")){
if(request.getParameter("m_msc_id").toString().equals("0")){//都选的第一个
arryAccountlistShow = new MoneyClassDA().showMoney();
}else{//帐务小类选了
//通过帐务小类查询
m_msc_id = Integer.parseInt(request.getParameter("m_msc_id").toString());
arryAccountlistShow = new MoneyClassDA().showMoneyByM_msc_id(m_msc_id);
}
}else{//帐务大类选了
if(request.getParameter("m_msc_id").toString().equals("0")){//帐务小类没选
//通过帐务大类查询
m_mbc_id = Integer.parseInt(request.getParameter("m_mbc_id").toString());
arryAccountlistShow = new MoneyClassDA().showMoneyByM_mbc_id(m_mbc_id);
}else{//帐务小类选了
//通过帐务大类和帐务小类查询
m_msc_id = Integer.parseInt(request.getParameter("m_msc_id").toString());
m_mbc_id = Integer.parseInt(request.getParameter("m_mbc_id").toString());
arryAccountlistShow = new MoneyClassDA().showMoneyByM_mbc_idAndM_msc_id(m_mbc_id, m_msc_id);
}
}
}else{//银行帐务选了
if(request.getParameter("m_mbc_id").toString().equals("0")){//帐务大类没选
if(request.getParameter("m_msc_id").toString().equals("0")){//帐务小类没选
//通过银行查询
m_b_id = Integer.parseInt(request.getParameter("m_b_id").toString());
arryAccountlistShow = new MoneyClassDA().showMoneyByM_b_id(m_b_id);
}else{//帐务小类选了
//通过银行 帐务小类查询
m_b_id = Integer.parseInt(request.getParameter("m_b_id").toString());
m_msc_id = Integer.parseInt(request.getParameter("m_msc_id").toString());
arryAccountlistShow = new MoneyClassDA().showMoneyByM_b_idAndM_msc_id(m_b_id, m_msc_id);
}
}else{//帐务大类选了
if(request.getParameter("m_msc_id").toString().equals("0")){//帐务小类没选
//通过银行 帐务大类查询
m_b_id = Integer.parseInt(request.getParameter("m_b_id").toString());
m_mbc_id = Integer.parseInt(request.getParameter("m_mbc_id").toString());
arryAccountlistShow = new MoneyClassDA().showMoneyByM_b_idAndM_mbc_id(m_b_id, m_mbc_id);
}else{//帐务小类选了
//通过银行 帐务大类 帐务大类 查询
m_b_id = Integer.parseInt(request.getParameter("m_b_id").toString());
m_msc_id = Integer.parseInt(request.getParameter("m_msc_id").toString());
m_mbc_id = Integer.parseInt(request.getParameter("m_mbc_id").toString());
arryAccountlistShow = new MoneyClassDA().showMoneyByM_b_idAndM_mbc_idAndM_msc_id(m_b_id, m_mbc_id, m_msc_id);
}
}
}
}else{//帐务类型选了
if(request.getParameter("m_b_id").toString().equals("0")){//银行没选
if(request.getParameter("m_b_id").toString().equals("0")){//帐务大类没选
if(request.getParameter("m_mbc_id").toString().equals("0")){//帐务小类没选
//通过帐务类型 查询
m_mbc_type = Integer.parseInt(request.getParameter("m_mbc_type").toString());
arryAccountlistShow = new MoneyClassDA().showMoneyByM_mbc_type(m_mbc_type);
}else{//帐务小类选了
//通过帐务类型 帐务小类 查询
m_mbc_type = Integer.parseInt(request.getParameter("m_mbc_type").toString());
m_msc_id = Integer.parseInt(request.getParameter("m_msc_id").toString());
arryAccountlistShow = new MoneyClassDA().showMoneyByM_mbc_typeAndM_msc_id(m_mbc_type, m_msc_id);
}
}else{//帐务大类选了
if(request.getParameter("m_mbc_id").toString().equals("0")){//帐务小类没选
//通过帐务类型 帐务大类 查询
m_mbc_type = Integer.parseInt(request.getParameter("m_mbc_type").toString());
m_mbc_id = Integer.parseInt(request.getParameter("m_mbc_id").toString());
arryAccountlistShow = new MoneyClassDA().showMoneyByM_mbc_typeAndM_mbc_id(m_mbc_type, m_mbc_id);
}else{//小类选了
//通过帐务类型 帐务大类 帐务小类 查询
m_mbc_type = Integer.parseInt(request.getParameter("m_mbc_type").toString());
m_mbc_id = Integer.parseInt(request.getParameter("m_mbc_id").toString());
m_msc_id = Integer.parseInt(request.getParameter("m_msc_id").toString());
arryAccountlistShow = new MoneyClassDA().showMoneyByM_mbc_typeAndM_mbc_idAndM_msc_id(m_mbc_type, m_mbc_id, m_msc_id);
}
}
}else{//银行选了
if(request.getParameter("m_mbc_id").toString().equals("0")){//帐务大类没选
if(request.getParameter("m_msc_id").toString().equals("0")){//帐务小类没选
//通过帐务类型 银行 查询
m_mbc_type = Integer.parseInt(request.getParameter("m_mbc_type").toString());
m_b_id = Integer.parseInt(request.getParameter("m_b_id").toString());
arryAccountlistShow = new MoneyClassDA().showMoneyByM_mbc_typeAndM_b_id(m_mbc_type, m_b_id);
}else{//帐务小类选了
//通过帐务类型 银行 帐务小类 查询
m_mbc_type = Integer.parseInt(request.getParameter("m_mbc_type").toString());
m_b_id = Integer.parseInt(request.getParameter("m_b_id").toString());
m_msc_id = Integer.parseInt(request.getParameter("m_msc_id").toString());
arryAccountlistShow = new MoneyClassDA().showMoneyByM_mbc_typeAndM_b_idAndM_msc_id(m_mbc_type, m_b_id, m_msc_id);
}
}else{//帐务大类选了
if(request.getParameter("m_msc_id").toString().equals("0")){//帐务小类没选
//通过 帐务类型 银行 帐务大类 查询
m_mbc_type = Integer.parseInt(request.getParameter("m_mbc_type").toString());
m_b_id = Integer.parseInt(request.getParameter("m_b_id").toString());
m_mbc_id = Integer.parseInt(request.getParameter("m_mbc_id").toString());
arryAccountlistShow = new MoneyClassDA().showMoneyByM_mbc_typeAndM_b_idAndM_mbc_id(m_mbc_type, m_b_id, m_mbc_id);
}else{//小类选了
//通过 帐务类型 银行 帐务大类 帐务小类 查询
m_mbc_type = Integer.parseInt(request.getParameter("m_mbc_type").toString());
m_b_id = Integer.parseInt(request.getParameter("m_b_id").toString());
m_mbc_id = Integer.parseInt(request.getParameter("m_mbc_id").toString());
m_msc_id = Integer.parseInt(request.getParameter("m_msc_id").toString());
arryAccountlistShow = new MoneyClassDA().showMoneyByM_mbc_typeAndM_b_idAndM_mbc_idAndM_msc_id(m_mbc_type, m_b_id, m_mbc_id, m_msc_id);
}
}
}
}
}else{
arryAccountlistShow = new MoneyClassDA().showMoney();
}
%>
<%
if(request.getParameter("start_time") != null && request.getParameter("end_time") != null){
String starttime = request.getParameter("start_time").toString();
String endtime = request.getParameter("end_time").toString();
arryAccountlistShow = new MoneyClassDA().showMoneyByM_time(starttime, endtime);
}else{
arryAccountlistShow = new MoneyClassDA().showMoney();
}
%>
<%
double shouru = new MoneyClassDA().showAmount_jia();
double zhichu = new MoneyClassDA().showAmount_jian();
%>
<%
int intPageSize; //一页显示的记录数
int intRowCount; //记录总数
int intPageCount;//总页数
int intPage; //待显示页码
String strPage; //请求页码
//设置一页显示的记录数
intPageSize = 10;
//取得显示的页码
strPage = request.getParameter("page");
if(strPage == null){//刚打开网页的时候，表明没有参数，此时显示第1页数据
intPage = 1;
}
else{//将字符串转换成整型
intPage = Integer.parseInt(strPage);
//if(intPage <= 1)
// intPage = 1;
}
//获取记录总数
intRowCount = arryAccountlistShow.size();
//记算总页数
intPageCount = (intRowCount + intPageSize-1) / intPageSize;
int startNum = (intPage - 1) * intPageSize;//当前页起始索引
int endNum = startNum + intPageSize;//当前页结束索引
if(endNum >= arryAccountlistShow.size()){
endNum = arryAccountlistShow.size();
}
%>
<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#C4D8ED">
<tr>
<td><img src="../images/system/r_1.gif" alt="" width="6" height="27" /></td>
<td width="100%" background="../images/system/r_0.gif">
<table cellpadding="0" cellspacing="0" width="100%">
<tr>
<td> </td>
<td align="right">收入合计：<%= shouru %> 元，支出合计：<%= zhichu %> 元
<input name="Submit" type="button" class="button1" value=" 清空帐务单据 " onclick="return del()"></td>
</tr>
</table></td>
<td><img src="../images/system/r_2.gif" alt="" width="6" height="27" /></td>
</tr>
<tr>
<td></td>
<td>
<table align="center" cellpadding="4" cellspacing="1" class="toptable grid" border="1">
<tr align="center">
<td class="category">帐务类型</td>
<td class="category" height="30">帐务大类</td>
<td class="category">帐务小类</td>
<td class="category">经办人</td>
<td class="category">经办时间</td>
<td class="category">银行帐务</td>
<td class="category">收入/支出（元）</td>
<td class="category">单据冲红</td>
</tr><%
for(int i = startNum;i < endNum;i++){
AccountlistShowBean bean = (AccountlistShowBean)arryAccountlistShow.get(i);
%>
<tr onMouseOver="this.className='highlight'" onMouseOut="this.className=''" onDblClick="javascript:var win=window.open('../money.do?method=showMoney&m_id=<%= bean.getM_id() %>','','width=600,height=240,top=176,left=161,toolbar=no,location=no,directories=no,status=no,menubar=no,resizable=no,scrollbars=yes');">
<td align="center" height="25"><% if(bean.getM_mbc_type() == 1){ %>收入<%}else{ %>支出<%} %></td>
<td align="center"><%= bean.getMbc_name() %></td>
<td align="center"><%= bean.getMsc_name() %></td>
<td align="center"><%= bean.getL_name() %></td>
<td align="center"><%= bean.getM_time() %></td>
<td align="center"><%= bean.getB_name() %></td>
<td align="center"><% if(bean.getM_mbc_type() == 1){ %>收入：<%= bean.getM_amount() %><%}else{ %>支出：<%= bean.getM_amount() %><%} %></td>
<td align="center"><input type="button" value=" 单据冲红 " class="button" onclick="javascript:window.location.href='../money.do?method=moneyHongChong&m_id=<%= bean.getM_id() %>';"></td>
</tr><%} %>
<tr>
<td colspan="10" height="30" class="category">
<table cellpadding=0 cellspacing=0 width="100%">
<tr>
<td width="20%" align="left" style="color:#FF0000;"> 双击查看详细信息</td>
<td width="80%" align="right"> 第<%= intPage%>页 共<%= intPageCount%>页
<% //以下是分页的“上一页”“下一页”，有上一页就有链接，没有就为文字，下一页同理 %>
<% if(intPage > 1){ %>
<a href="money_find_frame.jsp?page=<%= intPage-1%>&m_mbc_type=<%= m_mbc_type %>&m_b_id=<%= m_b_id %>m_mbc_id=<%= m_mbc_id %>&m_msc_id=<%= m_msc_id %>">上一页</a>
<% }else{ %>
上一页
<%}%>
<% if(intPage < intPageCount){ %>
<a href="money_find_frame.jsp?page=<%= intPage+1%>&m_mbc_type=<%= m_mbc_type %>&m_b_id=<%= m_b_id %>m_mbc_id=<%= m_mbc_id %>&m_msc_id=<%= m_msc_id %>">下一页</a>
<% }else{ %>
下一页
<%}%></td>
</tr>
</table></td>
</tr>
</table>
</td>
<td></td>
</tr>
<tr>
<td><img src="../images/system/r_4.gif" alt="" width="6" height="6" /></td>
<td></td>
<td><img src="../images/system/r_3.gif" alt="" width="6" height="6" /></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -