materialdayreport.java

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

package src.report;

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

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

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

   /**
产品名称
   */
   private String productName;
   
   /**
规格/型号
   */
   private String productDesc;
   
   /**
现有库存量
   */
   private double stockQty;
      
   /**
今日进货量
   */
   private double inQty;      
      
   /**
今日调拨出库量
   */
   private double removeQty;      
   
   /**
今日销售出库
   */
   private double salesQty;         

   /**
未提
   */
   private double undrawQty;            
   
   /**
进货记录
   */
   private String inRecord;               
   
   /**
销售记录
   */
   private String salesRecord;                  
      
   /**
开始时间
   */
   public Timestamp beginDate;

   /**
结束时间
   */
   public Timestamp endDate;
   
   /**
记录数
   */
   public int countNum;   
   
   public MaterialDayReport(){
	   numInOnePager = 10;  
   }
   
   public int loadAttr(){
       try{
	   	   wearhouseId = getRsString(rs,"wearhouseId");              
	   	   productId = getRsString(rs,"productId");       
	   	   productName = getRsString(rs,"productName");
	   	   productDesc = getRsString(rs,"productDesc");
	   	   stockQty = rs.getDouble("stockQty");
	   	   inQty = rs.getDouble("inQty");
	   	   removeQty = rs.getDouble("removeQty");
	   	   salesQty = rs.getDouble("salesQty");
	   	   undrawQty = rs.getDouble("undrawQty");
	   	   inRecord = getRsString(rs,"inRecord");	
	   	   salesRecord = getRsString(rs,"salesRecord");
	   	   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 = "0";        	
	
	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");		
		beginDate = getCurDate();		
	}		

	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();	
	}		
		//materialDayReport(wearhouseId,beginDate,endDate);		
		return 0;		
 }

 
  /* 

        productId varchar(10)    -- 产品编码	
	,productName varchar(30)  -- 产品名称
	,productDesc varchar(30)  -- 规格/型号	
        ,stockQty float           -- 现有库存量                
	,inQty float              -- 今日进货量
	,removeQty float          -- 今日调拨出库量
        ,salesQty  float          -- 今日销售出库
	,undrawQty float          -- 未提
        ,inRecord varchar(50)     -- 进货记录
        ,salesRecord varchar(50)  -- 销售记录    
	,dayDate datetime         -- 某一天时间        
        ,countNum int             -- 记录数	
      
 */ 	
       


	/**
    到货记录表   
   */
   public int materialDayReport() {
     int i;
     String sql= "{?=call sp_MaterialDayReport(?,?,?,?,?,?,?,?)}";
 
     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 getStockQty() 
   {
      return stockQty;
   }
   
   public double getInQty() 
   {
      return inQty;
   }
   
   public double getRemoveQty() 
   {
      return removeQty;
   }   

   public double getSalesQty() 
   {
      return salesQty;
   }
   
   public double getUndrawQty() 
   {
      return undrawQty;
   }
   
   public String getInRecord() 
   {
      return inRecord;
   }

   public String getSalesRecord() 
   {
      return salesRecord;
   }
   
   public Timestamp getBeginDate() 
   {
      return beginDate;
   }

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

}