inventoryadjustreport.java

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

package src.report;

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

public class InventoryAdjustReport extends ShangObject 
{
   /**
仓库编码
   */
   public String wearhouseId;
   
   /**
仓库名称
   */
   private String wearhouseName;   

   /**
产品编码
   */
   private String productId;

   /**
产品名称
   */
   private String productName;
   
   /**
规格/型号
   */
   private String productDesc;
   
   /**
   上月库存量
   */
   private double lastStockQty;

   /**
   现有库存量
   */
   private double stockQty;

   /**
本月进货入帐
   */
   private double inQty;      
      
   /**
本月销售
   */
   private double salesQty;         

   /**
本月调拨
   */
   private double allocatQty;         

   /**
调整
   */
   private double adjustQty;            
   
   /**
开始时间
   */
   public Timestamp beginDate;

   /**
结束时间
   */
   public Timestamp endDate;
   
   /**
记录数
   */
   public int countNum;   
   
   public InventoryAdjustReport(){
	   this.numInOnePager = 10;  
   }
   
   public int loadAttr(){
       try{
	   	   wearhouseId = getRsString(rs,"wearhouseId");              
	   	   productId = getRsString(rs,"productId");       
	   	   productName = getRsString(rs,"productName");
	   	   productDesc = getRsString(rs,"productDesc");
	   	   lastStockQty = rs.getDouble("lastStockQty");
	   	   inQty = rs.getDouble("inQty");
	   	   salesQty = rs.getDouble("salesQty");
	   	   allocatQty = rs.getDouble("allocatQty");
	   	   adjustQty = rs.getDouble("adjustQty");
	   	   stockQty = rs.getDouble("stockQty");
	   	   beginDate = rs.getTimestamp("beginDate");
	   	   endDate = rs.getTimestamp("endDate");	   	   
	   	   countNum = rs.getInt("countNum");
	           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;

        if((request.getParameter("wearhouseId")!=null)&&(!request.getParameter("wearhouseId").equals(""))){
              wearhouseId = request.getParameter("wearhouseId");        	
	}
	else
		wearhouseId=null;        	
	
	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=Timestamp.valueOf(beginDaten+"-"+beginDatey+"-"+beginDater+" 0:0:0.0");
	} else {
		yue = new Integer(getStringDate(getCurDate(),2)).intValue() - 1;
	        beginDatey = "" + yue;	
		beginDate = Timestamp.valueOf(getStringDate(getCurDate(),1)+"-"+beginDatey+"-"+getStringDate(getCurDate(),3)+" 0:0:0.0");		
	}		

	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=Timestamp.valueOf(endDaten+"-"+endDatey+"-"+endDater+" 0:0:0.0");
	} else {
		endDate = getCurDate();	
	}		
		//report(wearhouseId,beginDate,endDate);		
		return 0;		
 }

 
  /* 

	wearhouseId varchar(10)   -- 仓库编码		
	,wearhouseName varchar(30)   -- 仓库编码			
        ,productId varchar(10)    -- 产品编码	
	,productName varchar(30)  -- 产品名称
        ,lastStockQty float        -- 上月库存量                
	,inQty float              -- 本月进货入帐
        ,salesQty  float          -- 本月销售
	,adjustQty float          -- 调整
	,beginDate datetime         -- 开始时间  
	,endDate datetime         -- 结束时间  
        ,countNum int             -- 记录数
 */ 	
       


	/**
    到货记录表   
   */
   public int report() {
     int i;
     String sql= "{?=call sp_InventoryAdjustReport(?,?,?,?,?,?,?,?)}";
 
     try{
	CallableStatement updStmt=conn.prepareCall(sql);
	updStmt.registerOutParameter(1, java.sql.Types.INTEGER);/** 注册OUT参数 */
	setStmtString(updStmt, 2, theGlobal.loginName);
	setStmtString(updStmt, 3, theGlobal.ip);
	setStmtString(updStmt, 4, theGlobal.machineName);	
	setStmtString(updStmt, 5, wearhouseId);	
        updStmt.setTimestamp(6,beginDate);
        updStmt.setTimestamp(7,endDate);
        updStmt.setInt(8,curPage);
        updStmt.setInt(9,numInOnePager);
        rs = updStmt.executeQuery();        
        int rtcode = 0; 
	return rtcode;  
      }catch(SQLException E){
      	System.out.println(E.getMessage());
      	return -102;
      }
   }
   
      /**
用于分页显示, 处理如下操作：
next , previous,覆盖原方法
*/
public int listPage(javax.servlet.ServletRequest request) {
   
   String browseMode = (String) request.getParameter("browseMode");
   String position = (String) request.getParameter("position");
   	listPosition = (new Integer(position)).intValue();
   String curentPage = (String) request.getParameter("curPage");
   	curPage = (new Integer(curentPage)).intValue();	
   	
   	if(browseMode.equals("first")){
   		curPage = 1;
   		listPosition = 0;
   		}
   	if(browseMode.equals("next")){         					 /*下翻页*/
	 		   curPage=curPage+1;
			   listPosition=listPosition+numInOnePager;
			   if( (listPosition+numInOnePager)>=recordNum ){
			       state=-1;
			   }else{ 
			       state=1;
			   }
	 	} 
	 	
	 if(browseMode.equals("previous")) {                               /*上翻页*/
	 		curPage=curPage-1;
			listPosition=listPosition-numInOnePager;
			   if (listPosition==0){
			       state=2;
			  } else {
			   	state=1;
			   }
	 	} 

 	/*first(false);
 	previous(false);*/	
									/*重新定位*/
   	/*for (int index = 0; index < listPosition; index++) {
   		next(false);
   	}*/

	return 1;
}


   public String getWearhouseId() 
   {
      return wearhouseId;
   }
   
   public String getWearhouseName() 
   {
      return wearhouseName;
   }
   

   public String getProductId() 
   {
      return productId;
   }

   public String getProductName() 
   {
      return productName;
   }

   public String getProductDesc() 
   {
      return productDesc;
   }

   public double getLastStockQty() 
   {
      return lastStockQty;
   }

   public double getStockQty() 
   {
      return stockQty;
   }

   public double getInQty() 
   {
      return inQty;
   }
   
   public double getSalesQty() 
   {
      return salesQty;
   }
   
   public double getAllocatQty() 
   {
      return allocatQty;
   }
   
   public double getAdjustQty() 
   {
      return adjustQty;
   }
   
   public Timestamp getBeginDate() 
   {
      return beginDate;
   }

   public Timestamp getEndDate() 
   {
      return endDate;
   }
   
   public int getCountNum() 
   {
      return countNum;
   }

}