arrivedlogreport.java

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

package src.report;

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


public class ArrivedLogReport extends ShangObject 
{

   /**
定货日
   */
   private Timestamp contractDate;
   
   /**
到货日
   */
   private Timestamp inventoryDate;
   
   /**
定货部门
   */
   private String deptName;
   
   /**
销货单位
   */
   private String customerName;   

   /**
产品编码
   */
   private String productId;
   
   /**
品种
   */
   private String productName;
   
   /**
预定数量
   */
   private double contractProductQty;
      
   /**
实到数量
   */
   private double inventoryQty;      
      
   /**
单价
   */
   private double unitPrice;      
   
   /**
金额
   */
   private double amt;         

   /**
预付金额
   */
   private double prepayAmt;               
   
   /**
余额
   */
   private double spareAmt;                  
      
   /**
备注
   */
   private String remark;
   
   /**
开始日期
   */
   public Timestamp beginDate;
   
   /**
结束日期
   */
   public Timestamp endDate;   

   /**
记录数
   */
   public int countNum;   
   
   public ArrivedLogReport(){
	   numInOnePager = 10;  
   }
   
   public int loadAttr(){
       try{
	   	   contractDate = rs.getTimestamp("contractDate");
	   	   inventoryDate = rs.getTimestamp("inventoryDate");
	   	   deptName = getRsString(rs,"deptName");
	   	   customerName = getRsString(rs,"customerName");
	   	   productId = getRsString(rs,"productId");
	   	   productName = getRsString(rs,"productName");
	   	   contractProductQty = rs.getDouble("contractProductQty");
	   	   inventoryQty = rs.getDouble("inventoryQty");
	   	   unitPrice = rs.getDouble("unitPrice");
	   	   amt = rs.getDouble("amt");
	   	   prepayAmt = rs.getDouble("prepayAmt");
	   	   spareAmt = rs.getDouble("spareAmt");
	   	   remark = getRsString(rs,"remark"); 
	   	   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("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();	
	}		
		//arrivedLogReport(beginDate,endDate);		
		return 0;		
   }	    

  /* 
 	contractDate datetime,    -- 定货日
	inventoryDate datetime,   -- 到货日
	deptName varchar(30),     -- 定货部门
	customerName varchar(30), -- 销货单位
	productId  varchar(10),   -- 产品编码		
	productName  varchar(30), -- 品种	
        contractProductQty float, -- 预定数量
        inventoryQty float,       -- 实到数量	
        unitPrice float,          -- 单价
        amt float,                -- 金额
        prepayAmt float,          -- 预付金额
        spareAmt  float,          -- 余额
        remark varchar(80),       -- 备注
        beginDate datetime, 
	endDate datetime,
        countNum int   
 */ 	
       


	/**
    到货记录表   
   */
   public int arrivedLogReport() {
     int i;
     String sql= "{?=call sp_ArrivedLogReport(?,?,?,?,?,?,?)}";
 
     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);	
        updStmt.setTimestamp(5,beginDate);
        updStmt.setTimestamp(6,endDate);
        updStmt.setInt(7,curPage);
        updStmt.setInt(8,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 Timestamp getContractDate() 
   {
      return contractDate;
   }

   public Timestamp getInventoryDate() 
   {
      return inventoryDate;
   }

   public String getDeptName() 
   {
      return deptName;
   }

   public String getCustomerName() 
   {
      return customerName;
   }
     
   public String getProductId() 
   {
      return productId;
   }
   
   public String getProductName() 
   {
      return productName;
   }
      
   public double getContractProductQty() 
   {
      return contractProductQty;
   }
   
   public double getInventoryQty() 
   {
      return inventoryQty;
   }
   
   public double getUnitPrice() 
   {
      return unitPrice;
   }
   
   public double getAmt() 
   {
      return amt;
   }   

   public double getPrepayAmt() 
   {
      return prepayAmt;
   }

   public double getSpareAmt() 
   {
      return spareAmt;
   }
            
   public String getRemark() 
   {
      return remark;
   }

   public Timestamp getBeginDate() 
   {
      return beginDate;
   }

   public Timestamp getEndDate() 
   {
      return endDate;
   }

   public int getCountNum() 
   {
      return countNum;
   }

}