stockmanagementdatabean.java

一个使用java 写的进销存代码 使用了ejb 等技术 是学习j2ee的好

  public int deleteGoods(String goodsBarCode) {
     int result = 0;
     try {
       goods = goodsHome.findByPrimaryKey(goodsBarCode);
       goods.remove();
       result = 1;
     }catch (Exception ex) {
       ex.printStackTrace();
     }
     return result;
  }
  //根据类别取得商品的方法
  public String[][] getGoodsByGoodsCategory(int goodsCategory){
    String[][] detail = new String[0][13];
    try{
      //根据类别取得商品记录
      Collection col = goodsHome.findByGoodsCategory(goodsCategory);
      if(col.size() > 0){
        Iterator iterator = col.iterator();
        //重新创建数组
        detail = new String[col.size()][13];
        int i = 0;
        while (iterator.hasNext()) {
          //取得远程接口
          goods = (Goods) PortableRemoteObject.narrow(
              iterator.next(), Goods.class);
          detail[i][0] = goods.getGoodsBarCode();
          detail[i][1] = String.valueOf(goods.getCategoryId());
          detail[i][2] = goods.getGoodsName();
          detail[i][3] = goods.getGoodsNickName();
          detail[i][4] = goods.getGoodsAssistantName();
          detail[i][5] = goods.getGoodsPYName();
          detail[i][6] = goods.getUnit();
          detail[i][7] = goods.getSpecification();
          detail[i][8] = goods.getProducer();
          detail[i][9] = String.valueOf(goods.getUpperLimit());
          detail[i][10] = String.valueOf(goods.getLowerLimit());
          detail[i][11] = String.valueOf(dataMethod.round(goods.getSalePrice()));
          detail[i][12] = String.valueOf(dataMethod.round(goods.getDiscount()));
          i++;
        }
      }
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //根据条形码取得商品的方法
  public String[][] getGoodsByGoodsBarCode(String goodsBarCode){
    String[][] detail = new String[0][13];
    try{
      //根据条形码取得商品记录
      Collection col = goodsHome.findByGoodsBarCode("%" + goodsBarCode + "%");
      if(col.size() > 0){
        Iterator iterator = col.iterator();
        //重新创建数组
        detail = new String[col.size()][13];
        int i = 0;
        while (iterator.hasNext()) {
          //取得远程接口
          goods = (Goods) PortableRemoteObject.narrow(
              iterator.next(), Goods.class);
          detail[i][0] = goods.getGoodsBarCode();
          detail[i][1] = String.valueOf(goods.getCategoryId());
          detail[i][2] = goods.getGoodsName();
          detail[i][3] = goods.getGoodsNickName();
          detail[i][4] = goods.getGoodsAssistantName();
          detail[i][5] = goods.getGoodsPYName();
          detail[i][6] = goods.getUnit();
          detail[i][7] = goods.getSpecification();
          detail[i][8] = goods.getProducer();
          detail[i][9] = String.valueOf(goods.getUpperLimit());
          detail[i][10] = String.valueOf(goods.getLowerLimit());
          detail[i][11] = String.valueOf(dataMethod.round(goods.getSalePrice()));
          detail[i][12] = String.valueOf(dataMethod.round(goods.getDiscount()));
          i++;
        }
      }
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //根据商品名字取得商品的方法
  public String[][] getGoodsByGoodsName(String goodsName){
    String[][] detail = new String[0][13];
    try{
      //根据商品名字取得商品记录
      Collection col = goodsHome.findByGoodsName("%" + goodsName + "%");
      if(col.size() > 0){
        Iterator iterator = col.iterator();
        //重新创建数组
        detail = new String[col.size()][13];
        int i = 0;
        while (iterator.hasNext()) {
          //取得远程接口
          goods = (Goods) PortableRemoteObject.narrow(
              iterator.next(), Goods.class);
          detail[i][0] = goods.getGoodsBarCode();
          detail[i][1] = String.valueOf(goods.getCategoryId());
          detail[i][2] = goods.getGoodsName();
          detail[i][3] = goods.getGoodsNickName();
          detail[i][4] = goods.getGoodsAssistantName();
          detail[i][5] = goods.getGoodsPYName();
          detail[i][6] = goods.getUnit();
          detail[i][7] = goods.getSpecification();
          detail[i][8] = goods.getProducer();
          detail[i][9] = String.valueOf(goods.getUpperLimit());
          detail[i][10] = String.valueOf(goods.getLowerLimit());
          detail[i][11] = String.valueOf(dataMethod.round(goods.getSalePrice()));
          detail[i][12] = String.valueOf(dataMethod.round(goods.getDiscount()));
          i++;
        }
      }
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //根据生产厂商取得商品的方法
  public String[][] getGoodsByProducer(String producer){
    String[][] detail = new String[0][13];
    try{
      //根据生产厂商取得商品记录
      Collection col = goodsHome.findByProducer("%" + producer + "%");
      if(col.size() > 0){
        Iterator iterator = col.iterator();
        //重新创建数组
        detail = new String[col.size()][13];
        int i = 0;
        while (iterator.hasNext()) {
          //取得远程接口
          goods = (Goods) PortableRemoteObject.narrow(
              iterator.next(), Goods.class);
          detail[i][0] = goods.getGoodsBarCode();
          detail[i][1] = String.valueOf(goods.getCategoryId());
          detail[i][2] = goods.getGoodsName();
          detail[i][3] = goods.getGoodsNickName();
          detail[i][4] = goods.getGoodsAssistantName();
          detail[i][5] = goods.getGoodsPYName();
          detail[i][6] = goods.getUnit();
          detail[i][7] = goods.getSpecification();
          detail[i][8] = goods.getProducer();
          detail[i][9] = String.valueOf(goods.getUpperLimit());
          detail[i][10] = String.valueOf(goods.getLowerLimit());
          detail[i][11] = String.valueOf(dataMethod.round(goods.getSalePrice()));
          detail[i][12] = String.valueOf(dataMethod.round(goods.getDiscount()));
          i++;
        }
      }
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //取得折扣商品的方法
  public String[][] getDiscountGoods() {
    String[][] detail = new String[0][13];
    try{
      //取得打折商品记录
      Collection col = goodsHome.findDiscountGoods();
      if(col.size() > 0){
        Iterator iterator = col.iterator();
        //重新创建数组
        detail = new String[col.size()][13];
        int i = 0;
        while (iterator.hasNext()) {
          //取得远程接口
          goods = (Goods) PortableRemoteObject.narrow(
              iterator.next(), Goods.class);
          detail[i][0] = goods.getGoodsBarCode();
          detail[i][1] = String.valueOf(goods.getCategoryId());
          detail[i][2] = goods.getGoodsName();
          detail[i][3] = goods.getGoodsNickName();
          detail[i][4] = goods.getGoodsAssistantName();
          detail[i][5] = goods.getGoodsPYName();
          detail[i][6] = goods.getUnit();
          detail[i][7] = goods.getSpecification();
          detail[i][8] = goods.getProducer();
          detail[i][9] = String.valueOf(goods.getUpperLimit());
          detail[i][10] = String.valueOf(goods.getLowerLimit());
          detail[i][11] = String.valueOf(dataMethod.round(goods.getSalePrice()));
          detail[i][12] = String.valueOf(dataMethod.round(goods.getDiscount()));
          i++;
        }
      }
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //设置商品折扣的方法
  public int setGoodsDiscount(String goodsBarCode, double discount) {
    int result = 0;
    try {
      goods = goodsHome.findByPrimaryKey(goodsBarCode);
      goods.setDiscount(discount);
      result = 1;
    }catch (Exception ex) {
      ex.printStackTrace();
    }
    return result;
  }
  //创建供应商的方法
  public int createSupplier(String[] supplierArray) {
     int result = 0;
     if(supplierArray.length != 16){
       return result;
     }
     try {
       //创建供应商
       supplierHome.create(supplierArray[0], supplierArray[1], supplierArray[2],
                           supplierArray[3], supplierArray[4], supplierArray[5],
                           supplierArray[6], supplierArray[7], supplierArray[8],
                           supplierArray[9], supplierArray[10], supplierArray[11],
                           supplierArray[12], supplierArray[13],
                           supplierArray[14], supplierArray[15]);
       result = 1;
     }catch (Exception ex) {
       ex.printStackTrace();
     }
     return result;
  }
  //更新供应商的方法
  public int updateSupplier(String[] supplierArray) {
     int result = 0;
     if(supplierArray.length != 16){
       return result;
     }
     try {
       supplier = supplierHome.findByPrimaryKey(supplierArray[0]);
       //更新供应商
       supplier.setSupplierZone(supplierArray[1]);
       supplier.setPyCode(supplierArray[2]);
       supplier.setAbbreviation(supplierArray[3]);
       supplier.setCompanyPhone(supplierArray[4]);
       supplier.setLinkman(supplierArray[5]);
       supplier.setMobilePhone(supplierArray[6]);
       supplier.setFax(supplierArray[7]);
       supplier.setFixedPhone(supplierArray[8]);
       supplier.setAddress(supplierArray[9]);
       supplier.setZipCode(supplierArray[10]);
       supplier.setBankName(supplierArray[11]);
       supplier.setBankAccount(supplierArray[12]);
       supplier.setEmail(supplierArray[13]);
       supplier.setHomesite(supplierArray[14]);
       supplier.setRemark(supplierArray[15]);
       result = 1;
     }catch (Exception ex) {
       ex.printStackTrace();
     }
     return result;
  }
  //删除供应商的方法
  public int deleteSupplier(String supplierName) {
     int result = 0;
     try {
       supplier = supplierHome.findByPrimaryKey(supplierName);
       //删除供应商
       supplier.remove();
       result = 1;
     }catch (Exception ex) {
       ex.printStackTrace();
     }
     return result;
  }
  //根据供应商名字取得记录的方法
  public String[][] getSuppliersBySupplierName(String supplierName){
    String[][] detail = new String[0][16];
    try{
      //根据供应商名字取得记录
      Collection col = supplierHome.findBySupplierName("%" + supplierName + "%");
      if(col.size() > 0){
        Iterator iterator = col.iterator();
        //重新创建数组
        detail = new String[col.size()][16];
        int i = 0;
        while (iterator.hasNext()) {
          //取得远程接口
          supplier = (Supplier) PortableRemoteObject.narrow(
              iterator.next(), Supplier.class);
          detail[i][0] = supplier.getSupplierName();
          detail[i][1] = supplier.getSupplierZone();
          detail[i][2] = supplier.getPyCode();
          detail[i][3] = supplier.getAbbreviation();
          detail[i][4] = supplier.getCompanyPhone();
          detail[i][5] = supplier.getLinkman();
          detail[i][6] = supplier.getMobilePhone();
          detail[i][7] = supplier.getFax();
          detail[i][8] = supplier.getFixedPhone();
          detail[i][9] = supplier.getAddress();
          detail[i][10] = supplier.getZipCode();
          detail[i][11] = supplier.getBankName();
          detail[i][12] = supplier.getBankAccount();
          detail[i][13] = supplier.getEmail();
          detail[i][14] = supplier.getHomesite();
          detail[i][15] = supplier.getRemark();
          i++;
        }
      }
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //根据地区取得供应商记录的方法
  public String[][] getSuppliersBySupplierZone(String supplierZone){
    String[][] detail = new String[0][16];
    try{
      //根据地区取得记录
      Collection col = supplierHome.findBySupplierZone("%" + supplierZone + "%");
      if(col.size() > 0){
        Iterator iterator = col.iterator();
        //重新创建数组
        detail = new String[col.size()][16];
        int i = 0;
        while (iterator.hasNext()) {
          //取得远程接口
          supplier = (Supplier) PortableRemoteObject.narrow(
              iterator.next(), Supplier.class);
          detail[i][0] = supplier.getSupplierName();
          detail[i][1] = supplier.getSupplierZone();
          detail[i][2] = supplier.getPyCode();
          detail[i][3] = supplier.getAbbreviation();
          detail[i][4] = supplier.getCompanyPhone();
          detail[i][5] = supplier.getLinkman();
          detail[i][6] = supplier.getMobilePhone();
          detail[i][7] = supplier.getFax();
          detail[i][8] = supplier.getFixedPhone();
          detail[i][9] = supplier.getAddress();
          detail[i][10] = supplier.getZipCode();
          detail[i][11] = supplier.getBankName();
          detail[i][12] = supplier.getBankAccount();
          detail[i][13] = supplier.getEmail();