plansell.java

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

package src.wuyang;

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


public class PlanSell extends ShangObject
{
   /**
计划销售分配号
   */
   private String planSellId;	
   
   /**
部门编号
   */
   private String deptId;
   
   /**
产品编号
   */
   private String productId;
   
   /**
计划数量
   */
   private float planAmount;
   
   /**
计划起始时间
   */
   private Timestamp sellBegTime;
   
 /**
计划结束时间
   */  
   private Timestamp sellEndTime;
   
   
   public PlanSell() 
   {
   	primarykey1Name = "planSellId"; 
	primarykey1Type = 1; 
	tableName = "PlanSell";  
	viewName = "PlanSell";
	numInOnePager = 10;		
   }
  
  
  public int loadAttr(){
    try{
    	planSellId= getRsString(rs,"planSellId");
	deptId = getRsString(rs,"deptId");
	productId = getRsString(rs,"productId");
	planAmount = rs.getFloat("planAmount");
	sellBegTime = rs.getTimestamp("sellBegTime");
	sellEndTime = rs.getTimestamp("sellEndTime");

     } catch(SQLException e) {
   	 e.printStackTrace();
   	 System.out.println("query failed!");
   	 return -1;
      }
      return 1;
    }  
    
 /**
	@accountId	varchar(20)
	,@feeName	varchar(30)
	,@feeMoney	float
	,@feeDate	datetime
 */
 
  public int insert(){
  	String sql= "insert into PlanSell (planSellId,deptId,productId,planAmount,sellBegTime,sellEndTime) values (?,?,?,?,?,?)";
	try{
	     PreparedStatement updStmt=conn.prepareStatement(sql);
	     setStmtString(updStmt, 1, planSellId);
	     setStmtString(updStmt, 2, deptId);
	     setStmtString(updStmt, 3, productId);
	     updStmt.setFloat(4,planAmount);
	     updStmt.setTimestamp(5,sellBegTime);
	     updStmt.setTimestamp(6,sellEndTime);
	     updStmt.executeUpdate();
	     updStmt.close(); 
             return 1;	
   	
   	}catch(SQLException e){
   	     System.out.println(e.getMessage());
   		e.printStackTrace();
   		return -1;
   		}	
     }


 public int update(){
   	String sql= "update PlanSell set planAmount=?,sellBegTime=?,sellEndTime=? where planSellId=" + planSellId;
	try{
	     PreparedStatement updStmt=conn.prepareStatement(sql);
	     updStmt.setFloat(1,planAmount);
	     updStmt.setTimestamp(2,sellBegTime);
	     updStmt.setTimestamp(3,sellEndTime);
	     updStmt.executeUpdate();
	     updStmt.close(); 
             return 1;	
   	
   	}catch(SQLException e){
   	     System.out.println(e.getMessage());
   		e.printStackTrace();
   		return -1;
   		}
   }
   
   public String getWhereClause(javax.servlet.ServletRequest request)
   {
   	String whereClause="";
   	String sellBegTimeFrom="";
   	String sellBegTimeTo="";
   	String sellEndTimeFrom="";
   	String sellEndTimeTo="";
   	System.out.println("planSellId"+request.getParameter("planSellId"));
   	System.out.println("deptId"+request.getParameter("deptId"));
   	whereClause=addWhereClause(whereClause, "planSellId", "=", "'",request.getParameter("planSellId"));
   	whereClause=addWhereClause(whereClause, "deptId", "=", "'",request.getParameter("deptId"));
   	whereClause=addWhereClause(whereClause, "productId", "=", "'",request.getParameter("productId"));
   	if (((request.getParameter("sellBegTimeFromn")!=null)&&(!request.getParameter("sellBegTimeFromn").equals("")))&&((request.getParameter("sellBegTimeFromy")!=null)&&(!request.getParameter("sellBegTimeFromy").equals("")))&&((request.getParameter("sellBegTimeFromr")!=null)&&(!request.getParameter("sellBegTimeFromr").equals(""))))
   	{
   		sellBegTimeFrom=request.getParameter("sellBegTimeFromn")+"-"+request.getParameter("sellBegTimeFromy")+"-"+request.getParameter("sellBegTimeFromr");
   		whereClause=addWhereClause(whereClause, "sellBegTime", ">=", "'",sellBegTimeFrom);
   	}
   	if (((request.getParameter("sellBegTimeTon")!=null)&&(!request.getParameter("sellBegTimeTon").equals("")))&&((request.getParameter("sellBegTimeToy")!=null)&&(!request.getParameter("sellBegTimeToy").equals("")))&&((request.getParameter("sellBegTimeTor")!=null)&&(!request.getParameter("sellBegTimeTor").equals(""))))
   	{
   		sellBegTimeTo=request.getParameter("sellBegTimeTon")+"-"+request.getParameter("sellBegTimeToy")+"-"+request.getParameter("sellBegTimeTor");
   		whereClause=addWhereClause(whereClause, "sellBegTime", "<", "'",sellBegTimeTo);
   	}
   	if (((request.getParameter("sellEndTimeFromn")!=null)&&(!request.getParameter("sellEndTimeFromn").equals("")))&&((request.getParameter("sellEndTimeFromy")!=null)&&(!request.getParameter("sellEndTimeFromy").equals("")))&&((request.getParameter("sellEndTimeFromr")!=null)&&(!request.getParameter("sellEndTimeFromr").equals(""))))
   	{
   		sellEndTimeFrom=request.getParameter("sellEndTimeFromn")+"-"+request.getParameter("sellEndTimeFromy")+"-"+request.getParameter("sellEndTimeFromr");
   		whereClause=addWhereClause(whereClause, "sellEndTime", ">=", "'",sellEndTimeFrom);
   	}
   	if (((request.getParameter("sellEndTimeTon")!=null)&&(!request.getParameter("sellEndTimeTon").equals("")))&&((request.getParameter("sellEndTimeToy")!=null)&&(!request.getParameter("sellEndTimeToy").equals("")))&&((request.getParameter("sellEndTimeTor")!=null)&&(!request.getParameter("sellEndTimeTor").equals(""))))
   	{
   		sellEndTimeTo=request.getParameter("sellEndTimeTon")+"-"+request.getParameter("sellEndTimeToy")+"-"+request.getParameter("sellEndTimeTor");
   		whereClause=addWhereClause(whereClause, "sellEndTime", "<", "'",sellEndTimeTo);
   	}
   	return whereClause;
   }	   		 

     
   /**
* Access method for the accountId property.
*
* @return   the current value of the accountId property
   */
   public String getDeptId() 
   {
      return deptId;
   }
   
   /**
* Sets the value of the accountId property.
*
* @param aAccountId the new value of the accountId property
   */
   public void setDeptId(String aDeptId) 
   {
      deptId = setChnString(aDeptId);
   }
   
   /**
* Access method for the feeName property.
*
* @return   the current value of the feeName property
   */
   public String getProductId() 
   {
      return productId;
   }
   
   /**
* Sets the value of the feeName property.
*
* @param afeeName the new value of the feeName property
   */
   public void setProductId(String aProductId) 
   {
      productId = setChnString(aProductId);
   }
   
   /**
* Access method for the feeMoney property.
*
* @return   the current value of the feeMoney property
   */
   public float getPlanAmount() 
   {
      return planAmount;
   }
   
   /**
* Sets the value of the feeMoney property.
*
* @param aFeeMoney the new value of the feeMoney property
   */
   public void setPlanAmount(float aPlanAmount) 
   {
      planAmount = aPlanAmount;
   }
   
   /**
* Access method for the feeDate property.
*
* @return   the current value of the feeDate property
   */
   public Timestamp getSellBegTime() 
   {
      return sellBegTime;
   }
   
   /**
* Sets the value of the feeDate property.
*
* @param aFeeDate the new value of the feeDate property
   */
   public void setSellBegTime(Timestamp aSellBegTime) 
   {
      sellBegTime = aSellBegTime;
   }

   public Timestamp getSellEndTime() 
   {
      return sellEndTime;
   }
   
   /**
* Sets the value of the feeDate property.
*
* @param aFeeDate the new value of the feeDate property
   */
   public void setSellEndTime(Timestamp aSellEndTime) 
   {
      sellEndTime = aSellEndTime;
   }
   
   public void setPlanSellId(String aSellPlanId)
   {
      	planSellId=aSellPlanId;
   }
   
   public String getPlanSellId()
   {
   	return planSellId;
   }

}