package zichan;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class TCardModle {
    public TCardModle() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    String sql;
    Connection conn;
    Card cad;
    public TCardModle(Card ps) {
        cad=ps;
        conn=(new DBConnt()).getConnection();
    }
    void CleanCard(){
        cad.jtfAssetId.setText("");
        cad.jtfAssetName.setText("");
        cad.jtfCateId.setText("");
        cad.jtfEmpno.setText("");
        cad.jtfIsreturn.setText("");
        cad.jtfModelp.setText("");
        cad.jtfPrice.setText("");
        cad.jtfPurchaseDate.setText("");
        cad.jtfRemarks.setText("");
        cad.jtfRetdate.setText("");
        cad.jtfStatus.setText("");
        cad.jtfSubCateId.setText("");
        cad.jtfUseby.setText("");
        cad.jtfUsedate.setText("");
    }

public void selAssetId(String id){
        if(conn==null){
            System.out.println("找不到驅動程序");
        }
        CleanCard();
        try{
            sql="select a.assetid,rtrim(a.asset_name),a.cateid,a.subcateid,rtrim(a.model),a.price,a.purchase_date,a.status,a.useby,rtrim(a.remarks),b.empno,b.usedate,b.retdate,b.isreturn from asset a LEFT OUTER JOIN lend b on (a.assetid=b.assetid) where a.assetid = "+Integer.parseInt(id);
            Statement sta=conn.createStatement();
            ResultSet rs=sta.executeQuery(sql);

            if(rs.next()){
                cad.jtfAssetId.setText(rs.getString(1));
                cad.jtfAssetName.setText(rs.getString(2));
                cad.jtfCateId.setText(rs.getString(3));
                cad.jtfSubCateId.setText(rs.getString(4));
                cad.jtfModelp.setText(rs.getString(5));
                cad.jtfPrice.setText(rs.getString(6));
                cad.jtfPurchaseDate.setText(rs.getString(7));
                cad.jtfStatus.setText(rs.getString(8));
                cad.jtfUseby.setText(rs.getString(9));
                cad.jtfRemarks.setText(rs.getString(10));
                cad.jtfEmpno.setText(rs.getString(11));
                cad.jtfUsedate.setText(rs.getString(12));
                cad.jtfRetdate.setText(rs.getString(13));
                cad.jtfIsreturn.setText(rs.getString(14));
            }
            rs.close();
            sta.close();
        }catch(SQLException c){
            System.out.println(c);
        }

}


    public void selAssetName(String name){
        if(conn==null){
            conn=(new DBConnt()).getConnection();
        }
        CleanCard();
        try{
            sql="select a.assetid,rtrim(a.asset_name),a.cateid,a.subcateid,rtrim(a.model),a.price,a.purchase_date,a.status,a.useby,rtrim(a.remarks),b.empno,b.usedate,b.retdate,b.isreturn from asset a LEFT OUTER JOIN lend b on (a.assetid=b.assetid) where a.asset_name = '"+name+"'" ;
            Statement sta=conn.createStatement();
            ResultSet rs=sta.executeQuery(sql);

            if(rs.next()){
             cad.jtfAssetId.setText(rs.getString(1));
             cad.jtfAssetName.setText(rs.getString(2));
             cad.jtfCateId.setText(rs.getString(3));
             cad.jtfSubCateId.setText(rs.getString(4));
             cad.jtfModelp.setText(rs.getString(5));
             cad.jtfPrice.setText(rs.getString(6));
             cad.jtfPurchaseDate.setText(rs.getString(7));
             cad.jtfStatus.setText(rs.getString(8));
             cad.jtfUseby.setText(rs.getString(9));
             cad.jtfRemarks.setText(rs.getString(10));
             cad.jtfEmpno.setText(rs.getString(11));
             cad.jtfUsedate.setText(rs.getString(12));
             cad.jtfRetdate.setText(rs.getString(13));
             cad.jtfIsreturn.setText(rs.getString(14));


            }
            rs.close();
            sta.close();
        }catch(SQLException a){
                System.out.println(a);

            }

    }

    private void jbInit() throws Exception {
    }
}