📄 saleledgerview.jsp
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import = "data.*, user.*, method.DataMethod"%>
<%
//设置取得字符串的编码机制
request.setCharacterEncoding("GBK");
String userName = "";
if(session.getAttribute("user") != null){
User user = (User)session.getAttribute("user");
userName = user.getUserName();
}else{
out.print("<h3>请先登陆系统.</h3>");
return;
}
String ledgerDate = "";
if(session.getAttribute("ledgerDate") == null){
out.print("<h3>请先选择账套.</h3>");
return;
}else{
ledgerDate = (String)session.getAttribute("ledgerDate");
}
//创建销售账套数组
String[][] saleLedgers = new String[0][11];
//创建数据类
StockManagementData stockManagementData = new StockManagementData();
//创建方法类
DataMethod dataMethod = new DataMethod();
//根据传入参数取得销售账套数组
int saleType = 0;
if(request.getParameter("selectedIndex") != null){
//取得单据类型
saleType = Integer.parseInt(request.getParameter("saleType"));
int selectedIndex = Integer.parseInt(request.getParameter("selectedIndex"));
String searchValue = request.getParameter("searchValue");
String startDateStr = request.getParameter("startDate");
String endDateStr = request.getParameter("endDate");
if (selectedIndex == 0 | selectedIndex == 1 | selectedIndex == 2 |
selectedIndex == 3 | selectedIndex == 4 | selectedIndex == 5) {
if (searchValue.length() == 0) {
out.print("<h3>请输入查询值</h3>");
return;
}
switch (selectedIndex) {
case 0:
//根据销售单编号取得记录
saleLedgers = stockManagementData.getSaleLedgerByStringField(
ledgerDate, "saleId", searchValue, saleType);
break;
case 1:
//根据客户取得记录
saleLedgers = stockManagementData.getSaleLedgerByStringField(
ledgerDate, "customerName", searchValue, saleType);
break;
case 2:
if(saleType == 0 | saleType == 2){
//根据前台销售员取得记录
saleLedgers = stockManagementData.getSaleLedgerByStringField(
ledgerDate, "counterUser", searchValue, saleType);
}else{
//根据信用销售员取得记录
saleLedgers = stockManagementData.getSaleLedgerByStringField(
ledgerDate, "creditUser", searchValue, saleType);
}
break;
case 3:
//根据现金管理员取得记录
saleLedgers = stockManagementData.getSaleLedgerByStringField(
ledgerDate, "cashUser", searchValue, saleType);
break;
case 4:
//根据送货地址取得记录
saleLedgers = stockManagementData.getSaleLedgerByStringField(
ledgerDate, "address", searchValue, saleType);
break;
case 5:
if(dataMethod.checkInt(searchValue) == 0){
out.print("<h3>按完成状态查询时，输入值必须是整数，"
+ "0表示进行，1表示撤消，2表示完成.</h3>");
return;
}
//根据完成状态取得记录
saleLedgers = stockManagementData.getSaleLedgerByOnProcess(
ledgerDate, saleType, Integer.parseInt(searchValue));
break;
}
}else{
java.sql.Timestamp startDate = dataMethod.transferDate(startDateStr);
java.sql.Timestamp endDate = dataMethod.transferEndDate(endDateStr);
if(startDate == null | endDate == null){
out.print("<h3>日期输入错误，正确的日期格式是"
+ "yyyy-mm-dd（年-月-日），如2004-1-1.</h3>");
return;
}
//根据日期取得记录
saleLedgers = stockManagementData.getSaleLedgerByOrderDate(ledgerDate,
startDate, endDate, saleType);
}
}
//创建表格标题数组
String[] counterColNames = {"单据编号", "单据类型", "客户", "销售员", "柜台", "现金管理员",
"送货地址", "填写日期", "完成日期", "完成状态", "备注"};
String[] creditColNames = {"单据编号", "单据类型", "客户", "柜台", "销售员", "现金管理员",
"送货地址", "填写日期", "完成日期", "完成状态", "备注"};
%>
<html>
<head>
<title>销售单查看页面：用户(<%=userName%>):账套(<%=ledgerDate%>)</title>
</head>
<body bgcolor="#ffffff">
<center>
<h3>销售单查看页面:用户(<%=userName%>):账套(<%=ledgerDate%>)</h3>
<form action="saleledgerview.jsp" method="get">
<p>
单据类型
<select name="saleType">
<option value="0">前台销售单</option>
<option value="1">信用销售单</option>
<option value="2">前台销售退货单</option>
<option value="3">信用销售退货单</option>
</select>
查询条件：
<select name="selectedIndex">
<option value="0">根据单据编号查询</option>
<option value="1">根据客户查询</option>
<option value="2">根据销售员查询</option>
<option value="3">根据现金管理员查询</option>
<option value="4">根据送货地址查询</option>
<option value="5">根据完成状态查询</option>
<option value="6">根据填写日期查询</option>
</select>
查询值：
<input name="searchValue" type="text" size="18">
</p>
<p>
开始日期：
<input name="startDate" type="text" size="17">
结束日期：
<input name="endDate" type="text" size="17">
<input name="search" type="submit" value="查询">
</p>
</form>
<hr size="3" color="#0066FF">
<!--根据销售账套数组显示表格内容-->
<table width="100%" border="1">
<tr align="center">
<%if(saleType == 0 | saleType == 2){
for(int i = 0; i < counterColNames.length; i++){%>
<td><font size="-1"><%=counterColNames[i]%></font></td>
<%}
}else{
for(int i = 0; i < creditColNames.length; i++){%>
<td><font size="-1"><%=creditColNames[i]%></font></td>
<%}
}%>
</tr>
<%for (int i = 0; i < saleLedgers.length; i++){%>
<tr align="left">
<%for(int j = 0; j < saleLedgers[0].length; j++){
if(j == saleLedgers[0].length - 1){%>
<td>
<font size="-1">
<textarea name="remark" cols="10" rows="1"><%=saleLedgers[i][j]%></textarea>
</font>
</td>
<%}else if(j == 0){%>
<td>
<font size="-1">
<a href="salesubledgerview.jsp?saleId=<%=saleLedgers[i][j]%>" target="salesubledger">
<%=saleLedgers[i][j]%>
</a>
</font>
</td>
<%}else{%>
<td><font size="-1"><%=saleLedgers[i][j]%> </font></td>
<%}
}%>
</tr>
<%}%>
</table>
</center>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -