/**
 *  * 完成業務邏輯，調用本地實體bean
 */
package ejb;

import javax.ejb.SessionBean;
import javax.ejb.SessionContext;
import javax.ejb.CreateException;
import java.util.*;
import javax.naming.*;

public class FahuojiluSessionBean implements SessionBean {
    SessionContext sessionContext;
    public void ejbCreate() throws CreateException {
    }

    public void ejbRemove() {
    }

    public void ejbActivate() {
    }

    public void ejbPassivate() {
    }


    public void setSessionContext(SessionContext sessionContext) {
        this.sessionContext = sessionContext;
    }

    public boolean  delete(String dingDanHao) {
        boolean bool=false;
        try{
            Context ct = new InitialContext();
            FahuojiluHome home = (FahuojiluHome)ct.lookup("Fahuojilu");
            Fahuojilu rm = home.findByPrimaryKey(dingDanHao);
            rm.remove();
            bool=true;
        }catch(java.lang.Exception e){e.printStackTrace();}
       return bool;
    }

    public List selectForUserCode(String code) {
        List lt = new ArrayList();
        try{
            Context ct = new InitialContext();
            FahuojiluHome home = (FahuojiluHome) ct.lookup(
           "Fahuojilu");
            Iterator it = home.findForUserCode(code).iterator();
            while(it.hasNext()){
               Fahuojilu fahuojilu = (Fahuojilu)it.next();
               FahuojiluVo vo = new FahuojiluVo();
               vo.setCount1(fahuojilu.getCount1());
               vo.setDingDanHao(fahuojilu.getDingDanHao());
               vo.setModel(fahuojilu.getModel());
               vo.setName(fahuojilu.getName());
               vo.setNumber(fahuojilu.getNumber());
               vo.setPrice(fahuojilu.getPrice());
               vo.setUserCode(fahuojilu.getUserCode());
               vo.setZhiFu(fahuojilu.getZhiFu());
               lt.add(vo);}
       }catch(java.lang.Exception e){e.printStackTrace();}
        return lt;
    }

    public List selectForDingDanHao(String dingDanHao) {
        List lt = new ArrayList();

 try{
     Context ct = new InitialContext();
     FahuojiluHome home = (FahuojiluHome) ct.lookup(
    "Fahuojilu");
     Iterator it=home.findForDingDanHao(dingDanHao).iterator();
     while(it.hasNext())
     {Fahuojilu fahuojilu=(Fahuojilu)it.next() ;
        FahuojiluVo vo = new FahuojiluVo();
        vo.setCount1(fahuojilu.getCount1());
        vo.setDingDanHao(fahuojilu.getDingDanHao());
        vo.setModel(fahuojilu.getModel());
        vo.setName(fahuojilu.getName());
        vo.setNumber(fahuojilu.getNumber());
        vo.setPrice(fahuojilu.getPrice());
        vo.setUserCode(fahuojilu.getUserCode());
        vo.setZhiFu(fahuojilu.getZhiFu());
        lt.add(vo);
    }
        ;}catch(java.lang.Exception e){e.printStackTrace();}
       return lt;
    }

    public List selectAll() {
        List lt = new ArrayList();

        try{
                Context ct = new InitialContext();
               FahuojiluHome home = (FahuojiluHome) ct.lookup(
              "Fahuojilu");
             Iterator it = home.findForAll().iterator();
             while(it.hasNext()){
                               Fahuojilu fahuojilu = (Fahuojilu)it.next();
                              FahuojiluVo vo = new FahuojiluVo();
                              vo.setCount1(fahuojilu.getCount1());
                              vo.setDingDanHao(fahuojilu.getDingDanHao());
                               vo.setModel(fahuojilu.getModel());
                                vo.setName(fahuojilu.getName());
                              vo.setNumber(fahuojilu.getNumber());
                          vo.setPrice(fahuojilu.getPrice());
                          vo.setUserCode(fahuojilu.getUserCode());
                          vo.setZhiFu(fahuojilu.getZhiFu());
                          lt.add(vo);
                  }
      }catch(java.lang.Exception e){e.printStackTrace();}
        return lt;

    }

    public boolean  inster(String dingDanHao, String userCode, String number,
                          String name, String model, float price, String count1,
                          String zhiFu) {
        boolean bool=false;

   try{

       Context ct = new InitialContext();
       FahuojiluHome home = (FahuojiluHome)ct.lookup("Fahuojilu");


       Fahuojilu rm = home.create(dingDanHao);
       rm.setCount1(count1);
       rm.setModel(model);
       rm.setName(name);
       rm.setNumber(number);
       rm.setPrice(price);
       rm.setUserCode(userCode);
       rm.setZhiFu(zhiFu);
       bool=true;
   }catch(java.lang.Exception e){e.printStackTrace();}
   return bool;

    }
}