📄 salescostlist.jsp
字号:
<%@page import="java.sql.*"%>
<jsp:useBean id="saleCost" class="src.wuyang.SaleCost" scope="session"/>
<jsp:useBean id="global" class="src.com.MyGlobal" scope="session"/>
<% if (global.isLogined == false) {
%>
<jsp:forward page="../pub/DBErr.jsp" >
<jsp:param name="rtcode" value="-4" />
</jsp:forward>
<% }
%>
<html>
<head>
<title>个人销售成本汇总</title>
<link rel="stylesheet" href="css.css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<%
//saleCost.setGlobal(global);
//saleCost.conditionSetup(request);
//分页
int position,state,curPage,totalPage;
int numInOnePage = saleCost.getNumInOnePage();
saleCost.listPage(request);
//查询出每页的纪录
position = saleCost.listPosition;
state = saleCost.state;
curPage = saleCost.curPage;
totalPage = saleCost.totalPage;
%>
<body bgcolor="#949B93" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" class="text">
<table width="100%" border="1" height="90%" cellspacing="0" cellpadding="0" align="center" bordercolorlight="#616860" bordercolordark="#CCCCCC" bgcolor="#4c7171" >
<tr>
<td valign="top" >
<blockquote><br><br>
<div align="center"><font class=f16>
个人销售成本汇总表</font><br>
<%= saleCost.getStringDate(saleCost.beginDate,1) %>-<%= saleCost.getStringDate(saleCost.beginDate,2) %>-<%= saleCost.getStringDate(saleCost.beginDate,3) %>
-
<%= saleCost.getStringDate(saleCost.endDate,1) %>-<%= saleCost.getStringDate(saleCost.endDate,2) %>-<%= saleCost.getStringDate(saleCost.endDate,3) %>
<p> </P>
<table width="800" border="1" bordercolorlight="#000000" bordercolordark="#CCCCCC" cellpadding="0" cellspacing="0">
<tr bgcolor="#949b93" class="textb">
<td rowspan="2" class="textb">
<div align="center">部门名称</div>
</td>
<td rowspan="2">
<div align="center">姓名</div>
</td>
<td rowspan="2">
<div align="center">销售收入</div>
</td>
<td rowspan="2">
<div align="center">销售成本</div>
</td>
<td colspan="5">
<div align="center">分配比例前费用</div>
</td>
<td rowspan="2">
<div align="center">税前利润</div>
</td>
<td colspan="4">
<div align="center">业务费用</div>
</td>
<td rowspan="2">个人工资额</td>
<td rowspan="2">
<div align="center">利润</div>
</td>
</tr>
<tr bgcolor="#949b93" class="textb">
<td>
<div align="center">运杂费</div>
</td>
<td>
<div align="center">仓储费</div>
</td>
<td>
<div align="center">资金占用<br>利息</div>
</td>
<td>
<div align="center">二金一费<br>印花税<br>代理费</div>
</td>
<td>
<div align="center">其它费用</div>
</td>
<td>
<div align="center">旅差费</div>
</td>
<td>
<div align="center">通讯费</div>
</td>
<td>
<div align="center">招待费</div>
</td>
<td>
<div align="center">办公费和其他</div>
</td>
</tr>
<%
for(int listCount = 0; listCount < numInOnePage && (saleCost.next() > 0) ; listCount++) {
//while (saleCost.next() > 0) {
%>
<tr class="text">
<td>
<%
if((saleCost.getDeptName()!=null)&&(!saleCost.getDeptName().equals(""))) {
out.println(saleCost.getDeptName());}
else
{out.println(" ");}
%>
</td>
<td align="center">
<%
if((saleCost.getEmployeeName()!=null)&&(!saleCost.getEmployeeName().equals(""))) {
out.println(saleCost.getEmployeeName());}
else
{out.println(" ");}
%>
</td>
<td align="right">
<%
if(saleCost.getSaleMoney()!=0) {
out.println(saleCost.formatDouble(saleCost.getSaleMoney(),2));}
else
{out.println(" ");}
%>
</td>
<td align="right">
<%
if(saleCost.getSaleCost()!=0) {
out.println(saleCost.formatDouble(saleCost.getSaleCost(),2));}
else
{out.println(" ");}
%>
</td>
<td align="right">
<%
if(saleCost.getTransCost()!=0) {
out.println(saleCost.formatDouble(saleCost.getTransCost(),2));}
else
{out.println(" ");}
%>
</td>
<td align="right">
<%
if(saleCost.getStoreCost()!=0) {
out.println(saleCost.formatDouble(saleCost.getStoreCost(),2));}
else
{out.println(" ");}
%>
</td>
<td align="right">
<%
if(saleCost.getIntest()!=0) {
out.println(saleCost.formatDouble(saleCost.getIntest(),2));}
else
{out.println(" ");}
%>
</td>
<td align="right">
<%
if(saleCost.getStamTax()!=0) {
out.println(saleCost.formatDouble(saleCost.getStamTax(),2));}
else
{out.println(" ");}
%>
</td>
<td align="right">
<%
if(saleCost.getOtherCost()!=0) {
out.println(saleCost.formatDouble(saleCost.getOtherCost(),2));}
else
{out.println(" ");}
%>
</td>
<td align="right">
<%
if(saleCost.getProfitBeforeTax()!=0) {
out.println(saleCost.formatDouble(saleCost.getProfitBeforeTax(),2));}
else
{out.println(" ");}
%>
</td>
<td align="right">
<%
if(saleCost.getEventionCost()!=0) {
out.println(saleCost.formatDouble(saleCost.getEventionCost(),2));}
else
{out.println(" ");}
%>
</td>
<td align="right">
<%
if(saleCost.getCommunicateCost()!=0) {
out.println(saleCost.formatDouble(saleCost.getCommunicateCost(),2));}
else
{out.println(" ");}
%>
</td>
<td align="right">
<%
if(saleCost.getServerCost()!=0) {
out.println(saleCost.formatDouble(saleCost.getServerCost(),2));}
else
{out.println(" ");}
%>
</td>
<td align="right">
<%
if(saleCost.getWorkCost()!=0) {
out.println(saleCost.formatDouble(saleCost.getWorkCost(),2));}
else
{out.println(" ");}
%>
</td>
<td align="right">
<%
if(saleCost.getSalary()!=0) {
out.println(saleCost.formatDouble(saleCost.getSalary(),2));}
else
{out.println(" ");}
%>
</td>
<td align="right">
<%
if(saleCost.getProfit()!=0) {
out.println(saleCost.formatDouble(saleCost.getProfit(),2));}
else
{out.println(" ");}
%>
</td>
</tr>
<%}%>
</tr></td>
</blockquote>
</table>
<br>
<table border="0" align="left" class="text">
<tr><td>
<% if (position==0&&state==0){ %>
页码 <%=curPage %> / <%=totalPage%>
<% } else if (position==0&&state==2){ %>
<a href="SalesCostList.jsp?browseMode=next&position=<%=position%>&curPage=<%=curPage%>">下一页</a>   页码 <%=curPage %> / <%=totalPage%>
<% } else if (position>0&&state==-1){ %>
<a href="SalesCostList.jsp?browseMode=previous&position=<%=position%>&curPage=<%=curPage%>">上一页</a>     页码 <%=curPage %> / <%=totalPage%>
<% } else if (position>0&&state==1){ %>
<a href="SalesCostList.jsp?browseMode=previous&position=<%=position%>&curPage=<%=curPage%>">上一页</a>  <a href="SalesCostList.jsp?browseMode=next&position=<%=position%>&curPage=<%=curPage%>">下一页</a>  页码 <%=curPage %> / <%=totalPage%>
<% } %>
</td>
</tr>
</table></body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -