saleslistreport.java

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

package src.report;

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

public class SalesListReport extends ShangObject 
{
   /**
部门名称
   */
   private String deptName;

   /**
姓名
   */
   private String empName;

   /**
产品名称
   */
   private String productName;

   /**
销售金额
   */
   private double totalPrice;

   /**
开始日期
   */
   public Timestamp beginDate;

   /**
结束日期
   */
   public Timestamp endDate;   

   /**
记录数
   */
   public int countNum;   
   
   public SalesListReport(){
	   this.numInOnePager = 10;  
   }
   
   public int loadAttr(){
       try{
	   	   deptName = getRsString(rs,"deptName");       
	   	   empName = getRsString(rs,"empName");       	   	   
	   	   productName = getRsString(rs,"productName");  
	   	   totalPrice = rs.getDouble("totalPrice");
	   	   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");
	        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");	
 		        salesListReport(beginDate,endDate);
		}
		return 0;
	} else {
	
		beginDate = Timestamp.valueOf(getStringDate(getCurDate(),1)+"-"+getStringDate(getCurDate(),2)+"-"+"01"+" 0:0:0.0");
		yue = new Integer(getStringDate(getCurDate(),2)).intValue() + 1;
	        endDatey = "" + yue;	
		endDate=Timestamp.valueOf(getStringDate(getCurDate(),1)+"-"+endDatey+"-"+"01"+" 0:0:0.0");	
		salesListReport(beginDate,endDate);	
		return 1;
	} 
	
	

 }
 */
  /* 
        purchId varchar(10)      -- 采购申请编号	
        ,needDate datetime	   -- 用款日期
	,deptName varchar(30)     -- 用款部门
        ,customerId varchar(10)   -- 收款单位编号                	
	,customerName varchar(30) -- 收款单位
	,useFor varchar(30)       -- 资金用途
	,productName  varchar(30) -- 产品名称
        ,prepayQty float          -- 预定数量	
        ,unitPrice float          -- 单价
        ,prepayAmt float          -- 预付金额
	,useWay int               -- 付款方式
        ,bank varchar(30)         -- 开户银行                        		        
        ,bankAccount varchar(20)  -- 银行帐号    
        ,appDate datetime         -- 申请日期                        		                                            		        
        ,comment varchar(50)       -- 备注
        ,beginDate datetime 
	,endDate datetime
        ,countNum int
 */ 	
       


	/**
    到货记录表   
   */
   public int salesListReport(String aDeptId,String aEmployeeId,java.sql.Timestamp aBeginDate,java.sql.Timestamp aEndDate) {
     int i;
     String sql= "{?=call sp_SalesListReport(?,?,?,?,?,?,?)}";
 
     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, aDeptId);
	setStmtString(updStmt, 6, aEmployeeId);	
        updStmt.setTimestamp(7,aBeginDate);
        updStmt.setTimestamp(8,aEndDate);
        rs = updStmt.executeQuery();        
        int rtcode = 0; 
	return rtcode;  
      }catch(SQLException E){
      	System.out.println(E.getMessage());
      	return -102;
      }
   }
   
   public String getDeptName() 
   {
      return deptName;
   }
   
   public String getEmpName() 
   {
      return empName;
   }

   public String getProductName() 
   {
      return productName;
   }

   public double getTotalPrice() 
   {
      return totalPrice;
   }
   
   public Timestamp getBeginDate() 
   {
      return beginDate;
   }

   public Timestamp getEndDate() 
   {
      return endDate;
   }

   public int getCountNum() 
   {
      return countNum;
   }

}