slipquery.jsp

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

<jsp:useBean id="querySlip" class="src.wuyang.SalesSlip" 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>
<%	}
%>

<%!int recordNum;%>
<%!String str;%>
<%
	querySlip.whereClause = querySlip.getWhereClause(request);
	
	if(global.roleId==6)
		str = querySlip.whereClause + " and deptId='" + global.deptId + "'";
	   else if (global.roleId==13)
		str = querySlip.whereClause + " and proposer='" + global.loginName + "'";
	      else
	      	str = querySlip.whereClause;
	      	
	recordNum = querySlip.query(str, "slipDate"); 
	querySlip.setRecordNum(recordNum);		//设置总记录数
	if(recordNum == -1){

%>

<jsp:forward page="../pub/Err.jsp?ErrNo=3" />

<%
	}else if(recordNum == 0){
%>

<jsp:forward page="../pub/DBErr.jsp?rtcode=-103" />

<%
	
	}else{
		querySlip.setTotalPage();        //设置总页数            
%>
	<jsp:forward page="SlipList.jsp" > 
		<jsp:param name="browseMode" value="first" />
		<jsp:param name="position" value="0" />
		<jsp:param name="curPage" value="1" />
	</jsp:forward>

<%
	} 
%>