📄 acurrentaccountreportdepsetup.jsp
字号:
<jsp:useBean id="department" class="src.wuyang.Department" scope="page"/>
<jsp:useBean id="employee" class="src.wuyang.Employee" scope="page"/>
<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>
<meta http-equiv="Pragma" content="no-cache">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../pub/style.css">
</head>
<body bgcolor="#949B93" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="1" height="90%" cellspacing="0" cellpadding="0" align="center" bordercolorlight="#616860" bordercolordark="#CCCCCC" bgcolor="#4c7171" >
<tr><td><br>
<table border="0"><tr><td> </td><td>
<form method="post" action="ACurrentAccountReport.jsp">
<%
int flag=0;
String beginDate; /*开始时间*/
String endDate; /*结束时间*/
if((request.getParameter("beginDaten")!=null)&&(request.getParameter("beginDatey")!=null)&&(request.getParameter("beginDater")!=null)&&(!request.getParameter("beginDaten").equals(""))&&(!request.getParameter("beginDatey").equals(""))&&(!request.getParameter("beginDater").equals(""))){
beginDate = request.getParameter("beginDaten")+"-"+request.getParameter("beginDatey")+"-"+request.getParameter("beginDater")+" 0:0:0.0";
%>
<input type="hidden" name="beginDate" value="<%= beginDate%>" >
<%}
if((request.getParameter("endDaten")!=null)&&(request.getParameter("endDatey")!=null)&&(request.getParameter("endDater")!=null)&&(!request.getParameter("endDaten").equals(""))&&(!request.getParameter("endDatey").equals(""))&&(!request.getParameter("endDater").equals(""))){
endDate = request.getParameter("endDaten")+"-"+request.getParameter("endDatey")+"-"+request.getParameter("endDater")+" 0:0:0.0";
%>
<input type="hidden" name="endDate" value="<%= endDate%>" >
<%}%>
<% department.query("","");
while(department.next() > 0) {
flag=1;
String whereClause = "deptId = '" + department.getDeptId()+"'";
int recordNum = employee.query(whereClause,"");
if (recordNum > 0 ) {
%>
部门:<%=department.getDeptName()%>
<table border="1">
<tr>
<td> </td>
<td>销售员/采购员</td>
</tr>
<%
while(employee.next() > 0) {
%>
<tr>
<td><input type="checkbox" name="employeeId" value="<%=employee.getEmployeeId()%>" ></td>
<td><%= employee.getEmpName() %></td>
</tr>
<%
}
%>
</table>
<%
} else {
%>
部门:<input type="checkbox" name="deptId" value="<%=department.getDeptId()%>" ><%=department.getDeptName()%>
<br>
<%
}
}
%>
<br>
<p>
<input type="submit" name="query" value="下一步" />
<input type="reset" value="重置" />
</form>
</td></tr></table>
</td></tr>
</table>
<%if (flag==0) {%>
<jsp:forward page="../pub/DBErr.jsp?rtcode=-110"/>
<%}%>
<br><br>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -