queryullage.java

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

package src.wuyang;

import src.com.*;
import java.sql.*;
import java.io.*;
import java.lang.*;

public class QueryUllage extends ShangObject
{
	/**
申请单编号
	*/
	private String ullageId;

	/**
部门编码
	*/
	private String deptId;

	/**
产品名称
	*/
	private String productName;
	
	/**
规格/型号
	*/
	private String productType;
	
	/**
申请数量
	*/
	private double appQuantity;
	
	/**
预计价格
	*/ 
	private double appPrice;
	
	/**
采购数量
	*/
	private double actQuantity;
	
	/**
采购价格
	*/ 
	private double actPrice;
	
	/**
领用数量
	*/
	private double actGetQuantity;
	
	/**
部门名
	*/
	private String deptName;
	
	   
	/**
状态
	*/
	private int ullageState;
	
	/**
申请日期
	*/ 
	private Timestamp ullageDate;
	
   /**
开始日期
   */
	public String beginDate;
   
   /**
结束日期
   */
	public String endDate;   

	
	public QueryUllage()
	{
   		this.viewName = "v_UlltageProduct";
		numInOnePager=10;
	}
	
	public String getUllageId()
	{
		return ullageId;
	}
	
	public String getDeptId()
	{
		return deptId;
	}
	
	public String getProductName()
	{
		return productName;
	}
	
	public String getProductType()
	{
		return productType;
	}
	
	public double getAppQuantity()
	{
		return appQuantity;
	}
	
	public double getAppPrice()
	{
		return appPrice;
	}
	
	public double getActQuantity()
	{
		return actQuantity;
	}
	
	public double getActPrice()
	{
		return actPrice;
	}
	
	public double getActGetQuantity()
	{
		return actGetQuantity;
	}
	
	public int getUllageState()
	{
		return ullageState;
	}
	
	public Timestamp getUllageDate()
	{
		return ullageDate;
	}
	
	public String getDeptName()
	{
		return deptName;
	}
	
	public String getBeginDate() 
   	{
      		return beginDate;
   	}

   	public String getEndDate() 
   	{
      		return endDate;
   	}
	
	public int loadAttr(){
       	try	{
		ullageId=getRsString(rs,"ullageId");
		deptId=getRsString(rs,"deptId");
		deptName=getRsString(rs,"deptName");
		productName = getRsString(rs,"productName");
	   	productType = getRsString(rs,"productType");
		appQuantity = rs.getDouble("appQuantity");
		appPrice = rs.getDouble("appPrice");
		actQuantity = rs.getDouble("actQuantity");
		actPrice = rs.getDouble("actPrice");
		actGetQuantity = rs.getDouble("actGetQuantity");
		ullageDate = rs.getTimestamp("ullageDate");
		ullageState = rs.getInt("ullageState");
         	return 1;
	 } catch(SQLException e) {
		e.printStackTrace();
		System.out.println("query failed!");
		return -1;   
	 }		 
   }
   
   public int conditionSetup(javax.servlet.ServletRequest request) {
	String beginDaten;
	String beginDatey;
	String beginDater;	
	String endDaten;
	String endDatey;
	String endDater;	
	int yue;
	int state;
	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(""))){
		beginDaten = request.getParameter("beginDaten");
		beginDatey = request.getParameter("beginDatey");
		beginDater = request.getParameter("beginDater");
		beginDate=beginDaten+"-"+beginDatey+"-"+beginDater;
	}
	
	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(""))){
		endDaten = request.getParameter("endDaten");
		endDatey = request.getParameter("endDatey");
		endDater = request.getParameter("endDater");
		endDate=endDaten+"-"+endDatey+"-"+endDater;
	}
	return 0;
   }
   
public String getWhereClause(javax.servlet.ServletRequest request) {
    	String whereClause = "";
    	String str;
	String beginDaten;
	String beginDatey;
	String beginDater;	
	String endDaten;
	String endDatey;
	String endDater;	

	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(""))){
		beginDaten = request.getParameter("beginDaten");
		beginDatey = request.getParameter("beginDatey");
		beginDater = request.getParameter("beginDater");
		beginDate=beginDaten+"-"+beginDatey+"-"+beginDater;
	}
	
	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(""))){
		endDaten = request.getParameter("endDaten");
		endDatey = request.getParameter("endDatey");
		endDater = request.getParameter("endDater");
		endDate=endDaten+"-"+endDatey+"-"+endDater;
	}

    	int queryMode = (new Integer(request.getParameter("queryMode"))).intValue();
	switch(queryMode)
	{
		case 1: // 综合查询
			whereClause = addWhereClause(whereClause, "deptId", "=", "'", request.getParameter("deptId"));
			whereClause = addWhereClause(whereClause, "state", "like", "", request.getParameter("state"));
			whereClause = addWhereClause(whereClause, "productName", "like", "'", request.getParameter("productName"));
			whereClause = addWhereClause(whereClause, "ullageDate", ">=", "'", beginDate);
			whereClause = addWhereClause(whereClause, "ullageDate", "<=", "'", endDate);
			
			break;
			
		case 2: 
			break;

	}
    	return whereClause;
    }
    
   
}