package src.wuyang;

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


public class Report extends ShangObject 
{
   
   /**
產(chǎn)品編碼
   */
   private String productId;
   
   /**
產(chǎn)品名稱
   */
   private String productName;
   
   /**
規(guī)格/型號(hào)
   */
   private String productDesc;
   
   /**
單位
   */
   private String unit;
   
   /**
產(chǎn)品價(jià)格
   */
   private float unitPrice;
   
   /**
申請(qǐng)數(shù)量
   */
   private float quantity;
   
   /**
進(jìn)出庫(kù)數(shù)量
   */
   private float actQuantity;
   
   /**
業(yè)務(wù)員
   */
   private String proposer;
   
   /**
業(yè)務(wù)部門
   */
   private String deptId;
   
   /**
客戶編號(hào)
   */
   private String customerId;
   
   /**
業(yè)務(wù)員
   */
   private String empName;
   
   /**
業(yè)務(wù)部門
   */
   private String deptName;
   
   /**
客戶編號(hào)
   */
   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;
   }
   
}