/**
*  Title  財務管理系統
*  @author: trowa
*  Company: http://www.upol.cn
*  Copyright: Copyright (c) 2004
*  @version 1.0
*  費用類型的增加、刪除、修改
*/

package caiwu;
import java.sql.*;

public class PayControl extends Pay{
    public ResultSet rs;


/*
* 添加新的費用記錄
*/
public void addpay(){
DBConnect dbc = null;
        try{
                dbc  = new DBConnect();
                dbc.prepareStatement("INSERT INTO pay ( classid,payerid,paytypeid,money,project,message,addtime,inout ) VALUES ( ?,?,?,?,?,?,?,? )");
                dbc.setInt(1,Classid);
                dbc.setInt(2,Payerid);
                dbc.setInt(3,Paytypeid);
                dbc.setInt(4,Money);
                dbc.setBytes(5,Project.getBytes("gb2312"));
                dbc.setBytes(6,Message.getBytes("gb2312"));
                dbc.setBytes(7,Addtime.getBytes("gb2312"));
                dbc.setInt(8,Inout);
                dbc.executeUpdate();

        }catch(Exception e){
                System.err.println(e);
        }finally{
        try{
                dbc.close();
        }catch(Exception e){
                e.printStackTrace();
                }
        }
}

    /*
    * 修改費用類型名稱
    */
    public void editpay(){
    DBConnect dbc = null;
            try{
                    dbc = new DBConnect();
                    dbc.prepareStatement("UPDATE pay SET classid=?,payerid=?,paytypeid=?,money=?,project=?,message=?,addtime=? WHERE id=?");
                    dbc.setInt(1,Classid);
                    dbc.setInt(2,Payerid);
                    dbc.setInt(3,Paytypeid);
                    dbc.setInt(4,Money);
                    dbc.setBytes(5,Project.getBytes("GB2312"));
                    dbc.setBytes(6,Message.getBytes("GB2312"));
                    dbc.setBytes(7,Addtime.getBytes("GB2312"));
                    dbc.setInt(8,Id);
                    dbc.executeUpdate();
            }catch(Exception e){
                    e.printStackTrace();
            }
            finally{
            try{
                    dbc.close();
            }catch(Exception e){
                    e.printStackTrace();
                    }
            }
}

    /*
    * 刪除費用記錄
    */
    public void delpay(){
            DBConnect dbc = null;
            try{
                    dbc = new DBConnect();
                    dbc.prepareStatement("delete from pay WHERE id=?");
                    dbc.setInt(1,Id);
                    dbc.executeUpdate();
            }catch(Exception e){
                    e.printStackTrace();
            }
            finally{
            try{
                    dbc.close();
            }catch(Exception e){
                    e.printStackTrace();
                    }
            }
}


//結束
    public PayControl() {
    }
}