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


public class DeptMoney extends ShangObject
{
   
   /**
部門編號
   */
   private String deptId;
   private String deptName;
   
   /**
金額
   */
   private float money;
   
   /**
日期
   */
   private Timestamp endDate;
   
   /**
費用編號
   */
   private int feeId;
   private String feeName;
   
   /**
記錄編號
   */
   private int number;
   
   /**
開始日期
   */
	public String begin_Date;
   
   /**
結束日期
   */
	public String end_Date;   


   public String getDeptId() {
      return deptId;}
   public void setDeptId(String aDeptId) {
      deptId = setChnString(aDeptId);}
   
   public String getDeptName() {
      return deptName;}
   public void setDeptName(String aDeptName) {
      deptName = setChnString(aDeptName);}
   
   public float getMoney() {
      return money;}
   public void setMoney(float aMoney) {
      money = aMoney;}
   
   public Timestamp getEndDate() {
      return endDate;}
   public void setEndDate(Timestamp aEndDate) {
      endDate = aEndDate;}
      
   public int getFeeId() {
      return feeId;}
   public void setFeeId(int aFeeId) {
      feeId = aFeeId;}
      
   public String getFeeName() {
      return feeName;}
   public void setFeeName(String aFeeName) {
      feeName = aFeeName;}
      
   public int getNumber() {
      return number;}
   public void setNumber(int aNumber) {
      number = aNumber;}
      
public  DeptMoney(){
	primarykey1Name="number" ;
	primarykey1Type=0;
	tableName ="DeptMoney";
	viewName="V_DeptMoney";
	numInOnePager=10;}

public int loadAttr() {
 	try 	{ 
		deptId= getRsString(rs,"deptId");
		deptName= getRsString(rs,"deptName");
		money= rs.getFloat("money");
		endDate= rs.getTimestamp("endDate");
		feeId= rs.getInt("feeId");
		feeName= getRsString(rs,"feeName");
		number= rs.getInt("number");
	} catch(SQLException e) {
		e.printStackTrace();
		System.out.println("query failed!");
		return -1;
	}
    	return 1;
}

public int insert() {
 	String sql= "{?=call sp_InsertDeptMoney(?,?,?,?)}";
	try	{
		CallableStatement updStmt=conn.prepareCall(sql);
		updStmt.registerOutParameter(1, java.sql.Types.INTEGER);
		setStmtString(updStmt,2,deptId);
		updStmt.setFloat(3,money);
		updStmt.setTimestamp(4,endDate);
		updStmt.setInt(5,feeId);
		updStmt.executeUpdate();
		int rtcode = updStmt.getInt(1);
		updStmt.close();
		return rtcode; 
	}catch(SQLException E){
		System.out.println(E.getMessage());
		return -102;
  	}
}

/**修改1
**
**/

public int update() {
 	String sql= "{?=call sp_UpdateDeptMoney(?,?,?,?,?)}";
	try	{
		CallableStatement updStmt=conn.prepareCall(sql);
		updStmt.registerOutParameter(1, java.sql.Types.INTEGER);
		setStmtString(updStmt,2,deptId);
		updStmt.setFloat(3,money);
		updStmt.setTimestamp(4,endDate);
		updStmt.setInt(5,feeId);
		updStmt.setInt(6,number);
		updStmt.executeUpdate();
		int rtcode = updStmt.getInt(1);
		updStmt.close();
		return rtcode; 
	}catch(SQLException E){
		System.out.println(E.getMessage());
		return -102;
  	}
}

public String getWhereClause(javax.servlet.ServletRequest request) {
    	String whereClause = "";
    	String str;
	String beginDaten;
	String beginDatey;
	String beginDater;	
	String endDaten;
	String endDatey;
	String endDater;	

	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");
		begin_Date=beginDaten+"-"+beginDatey+"-"+beginDater;
	}
	
	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");
		end_Date=endDaten+"-"+endDatey+"-"+endDater;
	}

    	int queryMode = (new Integer(request.getParameter("queryMode"))).intValue();
	switch(queryMode)
	{
		case 1: // 綜合查詢
			whereClause = addWhereClause(whereClause, "deptId", "=", "'", request.getParameter("deptId"));
			whereClause = addWhereClause(whereClause, "endDate", ">=", "'", begin_Date);
			whereClause = addWhereClause(whereClause, "endDate", "<=", "'", end_Date);
			whereClause = addWhereClause(whereClause, "feeId", "=", "", request.getParameter("feeId"));
			
			break;
			
		case 2: 
			break;

	}
    	return whereClause;
    }
    
}