report.java

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

package src.wuyang;

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


public class Report 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 deptId;
   
   /**
客户编号
   */
   private String customerId;
   
   /**
业务员
   */
   private String empName;
   
   /**
业务部门
   */
   private String deptName;
   
   /**
客户编号
   */
   private String customerName;
   
   
   public Report() 
   {
	numInOnePager = 10;		
   }
  
   
   public int loadAttr(){
    try{
	customerId = getRsString(rs,"customerId");
	proposer = getRsString(rs,"proposer");
	deptId = getRsString(rs,"deptId");
	productId = getRsString(rs,"productId");
	unitPrice = rs.getFloat("unitPrice");
	actQuantity = rs.getFloat("actQuantity");
	productName = getRsString(rs,"productName");
	productDesc = getRsString(rs,"productDesc");
	unit = getRsString(rs,"unit");
	empName = getRsString(rs,"empName");
	deptName = getRsString(rs,"deptName");
	customerName = getRsString(rs,"customerName");
	quantity = rs.getFloat("quantity");

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

public String getWhereClause(javax.servlet.ServletRequest request) {
    	String whereClause = "";
    	int queryMode = (new Integer(request.getParameter("queryMode"))).intValue();
	if(queryMode==1)
		viewName = "V_Slip";
	else			
		viewName = "V_Purch";
	
	whereClause = addWhereClause(whereClause, "productId", "=", "'", request.getParameter("productId"));
	whereClause = addWhereClause(whereClause, "customerId", "=", "'", request.getParameter("customerId"));		
	whereClause = addWhereClause(whereClause, "deptId", "=", "'", request.getParameter("deptId"));		
	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 getCustomerId() 
   {
      return customerId;
   }
   
   public String getProposer() 
   {
      return proposer;
   }
   

   public String getDeptId() 
   {
      return deptId;
   }
   

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

   public float getQuantity() 
   {
      return quantity;
   }

   public String getEmpName() 
   {
      return empName;
   }
   
   public String getCustomerName() 
   {
      return customerName;
   }
   
   public String getDeptName() 
   {
      return deptName;
   }
   
}