allocatcostquery.jsp

(Java+SQL)-大型企业JAVA的ERP系统

<jsp:useBean id="allocat" class="src.wuyang.Allocat" scope="session"/>
<jsp:useBean id="global" class="src.com.MyGlobal" scope="session"/>
<jsp:setProperty name="allocat" property="*" />

<% if (global.isLogined == false) {
%>
<jsp:forward page="../pub/DBErr.jsp" > 
	<jsp:param name="rtcode" value="-4" />
</jsp:forward>
<%	}
%>


<%! int recordNum; %>
<%
	allocat.whereClause = allocat.getWhereClause(request);
	if (allocat.whereClause.equals("")) {
		recordNum = allocat.query(allocat.whereClause+" allocatState >= 3 and allocatState <> 4 and format = 1","subCompanyId, proposer"); 
	} else {
		recordNum = allocat.query(allocat.whereClause+" and (allocatState >= 3 and allocatState <> 4) and format = 1","subCompanyId, proposer"); 
	}
	allocat.setRecordNum(recordNum);		//设置总记录数
	if(recordNum == -1){
%>
<jsp:forward page="../pub/Err.jsp?ErrNo=3" />
<%
	}else if(recordNum == 0){
%>
<jsp:forward page="../pub/Err.jsp?ErrNo=4" />
<%
	}else{
		allocat.setTotalPage();        //设置总页数            
%>
	<jsp:forward page="AllocatCostList.jsp" > 
		<jsp:param name="browseMode" value="first" />
		<jsp:param name="position" value="0" />
		<jsp:param name="curPage" value="1" />
	</jsp:forward>
<%
	} 
%>