reportallocat.java

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

package src.wuyang;

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


public class ReportAllocat extends ShangObject 
{
   
   /**
产品编码
   */
   private String productId;
   
   /**
产品名称
   */
   private String productName;
   
   /**
规格/型号
   */
   private String productDesc;
   
   /**
单位
   */
   private String unit;
   
   /**
产品价格
   */
   private float unitPrice;
   
   /**
申请数量
   */
   private float quantity;
   
   /**
进出库数量
   */
   private float actQuantity;
   
   /**
业务员
   */
   private String proposer;
   
   /**
业务部门
   */
   private String subCompanyId;
   
   /**
业务部门
   */
   private String companyName;

   public ReportAllocat() 
   {
	numInOnePager = 10;		
	viewName = "v_Allocat";
   }
  
   
   public int loadAttr(){
    try{
	subCompanyId = getRsString(rs,"subCompanyId");
	proposer = getRsString(rs,"proposer");
	productId = getRsString(rs,"productId");
	quantity = rs.getFloat("quantity");
	unitPrice = rs.getFloat("unitPrice");
	actQuantity = rs.getFloat("actQuantity");
	productName = getRsString(rs,"productName");
	productDesc = getRsString(rs,"productDesc");
	unit = getRsString(rs,"unit");
	companyName = getRsString(rs,"companyName");

     } catch(SQLException e) {
   	 e.printStackTrace();
   	 return -1;
      }
      return 1;
    }  
    

public String getWhereClause(javax.servlet.ServletRequest request) {
    	String whereClause = "";
	viewName = "v_Allocat";
	
	whereClause = addWhereClause(whereClause, "productId", "=", "'", request.getParameter("productId"));
	whereClause = addWhereClause(whereClause, "subCompanyId", "=", "'", request.getParameter("subCompanyId"));		
	whereClause = addWhereClause(whereClause, "proposer", "=", "'", request.getParameter("proposer"));		
    	
    	return whereClause;
    }  

     
   public String getProductId() 
   {
      return productId;
   }
   
   public String getProductName() 
   {
      return productName;
   }

   public String getProductDesc() 
   {
      return productDesc;
   }

   public String getUnit() 
   {
      return unit;
   }

   public String getProposer() 
   {
      return proposer;
   }
   

   public String getSubCompanyId() 
   {
      return subCompanyId;
   }
   

   public float getUnitPrice() 
   {
      return unitPrice;
   }
   
   public float getActQuantity() 
   {
      return actQuantity;
   }

   public float getQuantity() 
   {
      return quantity;
   }

   public String getCompanyName() 
   {
      return companyName;
   }

}