stockmanagementdata.java~719~

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

  //创建供应商的方法
  public int createSupplier(String[] supplierArray) {
     int result = 0;
     if(supplierArray.length != 16){
       return result;
     }
     try {
       //创建供应商
       result = stockManagementData.createSupplier(supplierArray);
     }catch (Exception ex) {
       ex.printStackTrace();
     }
     return result;
  }
  //更新供应商的方法
  public int updateSupplier(String[] supplierArray) {
     int result = 0;
     if(supplierArray.length != 16){
       return result;
     }
     try {
       //更新供应商
       result = stockManagementData.updateSupplier(supplierArray);
     }catch (Exception ex) {
       ex.printStackTrace();
     }
     return result;
  }
  //删除供应商的方法
  public int deleteSupplier(String supplierName) {
     int result = 0;
     try {
       result = stockManagementData.deleteSupplier(supplierName);
     }catch (Exception ex) {
       ex.printStackTrace();
     }
     return result;
  }
  //根据供应商名字取得记录的方法
  public String[][] getSuppliersBySupplierName(String supplierName){
    String[][] detail = new String[0][16];
    try{
      //根据供应商名字取得记录
      detail = stockManagementData.getSuppliersBySupplierName(supplierName);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //根据地区取得供应商记录的方法
  public String[][] getSuppliersBySupplierZone(String supplierZone){
    String[][] detail = new String[0][16];
    try{
      //根据地区取得记录
      detail = stockManagementData.getSuppliersBySupplierZone(supplierZone);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //创建客户的方法
  public int createCustomer(String[] customerArray) {
     int result = 0;
     if(customerArray.length != 17){
       return result;
     }
     try {
       //创建客户
       result = stockManagementData.createCustomer(customerArray);
     }catch (Exception ex) {
       ex.printStackTrace();
     }
     return result;
  }
  //更新客户的方法
  public int updateCustomer(String[] customerArray) {
     int result = 0;
     if(customerArray.length != 17){
       return result;
     }
     try {
       //更新客户
       result = stockManagementData.updateCustomer(customerArray);
     }catch (Exception ex) {
       ex.printStackTrace();
     }
     return result;
  }
  //删除客户的方法
  public int deleteCustomer(String customerName) {
     int result = 0;
     try {
       result = stockManagementData.deleteCustomer(customerName);
     }catch (Exception ex) {
       ex.printStackTrace();
     }
     return result;
  }
  //根据客户名字取得记录的方法
  public String[][] getCustomersByCustomerName(String customerName){
    String[][] detail = new String[0][17];
    try{
      //根据客户名字取得记录
      detail = stockManagementData.getCustomersByCustomerName(customerName);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //根据地区取得客户记录的方法
  public String[][] getCustomersByCustomerZone(String customerZone){
    String[][] detail = new String[0][17];
    try{
      //根据地区取得记录
      detail = stockManagementData.getCustomersByCustomerZone(customerZone);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //取得信用客户的方法
  public String[][] getCreditCustomer() {
    String[][] detail = new String[0][17];
    try{
      //取得信用客户记录
      detail = stockManagementData.getCreditCustomer();
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //设置客户信用的方法
  public int setCreditCustomer(String customerName, double creditlimit) {
    int result = 0;
    try {
      //设置客户的信用
      result = stockManagementData.setCreditCustomer(customerName, creditlimit);
    }catch (Exception ex) {
      ex.printStackTrace();
    }
    return result;
  }
  //创建仓库
  public int createWarehouse(String[] warehouseArray) {
    int result = 0;
    if(warehouseArray.length != 4){
      return result;
    }
    try {
      //创建仓库
      result = stockManagementData.createWarehouse(warehouseArray);
    }catch (Exception ex) {
      ex.printStackTrace();
    }
    return result;
  }
  //更新仓库
  public int updateWarehouse(String[] warehouseArray) {
    int result = 0;
    if(warehouseArray.length != 4){
      return result;
    }
    try {
      //更新仓库
      result = stockManagementData.updateWarehouse(warehouseArray);
    }catch (Exception ex) {
      ex.printStackTrace();
    }
    return result;
  }
  //删除仓库
  public int deleteWarehouse(String warehouseName) {
    int result = 0;
    try {
      result = stockManagementData.deleteWarehouse(warehouseName);
    }catch (Exception ex) {
      ex.printStackTrace();
    }
    return result;
  }
  //取得所有仓库
  public String[][] getAllWarehouse() {
    String[][] detail = new String[0][4];
    try{
      //取得所有仓库记录
      detail = stockManagementData.getAllWarehouse();
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //创建会计科目
  public int createAccountName(int parentId, String accountNameStr) {
    int result = 0;
    try {
      result = stockManagementData.createAccountName(parentId, accountNameStr);
    }catch (Exception ex) {
      ex.printStackTrace();
    }
    return result;
  }
  //更新会计科目
  public int updateAccountName(int accountId, int parentId, String accountName) {
    int result = 0;
    try {
      result = stockManagementData.updateAccountName(accountId, parentId, accountName);
    }catch (Exception ex) {
      ex.printStackTrace();
    }
    return result;
  }
  //删除会计科目
  public int deleteAccountName(int accountId) {
    int result = 0;
    try {
      result = stockManagementData.deleteAccountName(accountId);
    }catch (Exception ex) {
      ex.printStackTrace();
    }
    return result;
  }
  //根据父标识取得会计科目
  public String[][] getAccountNameByParentid(int parentId) {
    String[][] detail = new String[0][3];
    try{
      detail = stockManagementData.getAccountNameByParentid(parentId);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //取得所有会计科目
  public String[][] getAllAccountName() {
    String[][] detail = new String[0][3];
    try{
      detail = stockManagementData.getAllAccountName();
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //根据操作程序名字取得日志记录的方法
  public String[][] getUserLogByProgramName(String programName) {
    String[][] detail = new String[0][5];
    try{
      detail = stockManagementData.getUserLogByProgramName(programName);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //根据操作内容取得日志记录的方法
  public String[][] getUserLogByOperationContent(String operationContent) {
    String[][] detail = new String[0][5];
    try{
      detail = stockManagementData.getUserLogByOperationContent(operationContent);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //根据用户名字取得日志记录的方法
  public String[][] getUserLogByUserName(String userName) {
    String[][] detail = new String[0][5];
    try{
      detail = stockManagementData.getUserLogByUserName(userName);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //根据操作时间取得日志记录的方法
  public String[][] getUserLogByOperationDate(java.sql.Timestamp startDate,
                                              java.sql.Timestamp endDate) {
    String[][] detail = new String[0][5];
    try{
      detail = stockManagementData.getUserLogByOperationDate(startDate, endDate);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return detail;
  }
  //根据单据编号或者请购员名字或者仓库名字取得库存账套数据表记录的方法
  public String[][] getStockLedgerByStringField(String ledgerDate,
                                                String fieldName,
                                                String fieldValue,
                                                int orderType) {
    String[][] data = new String[0][13];
    try {
      data = stockManagementData.getStockLedgerByStringField(ledgerDate,
          fieldName, fieldValue, orderType);
    }catch (Exception ex) {
      ex.printStackTrace();
    }
    return data;
  }
  //根据订单日期取得库存账套数据表记录的方法
  public String[][] getStockLedgerByOrderDate(String ledgerDate,
                                              java.sql.Timestamp startDate,
                                              java.sql.Timestamp endDate,
                                              int orderType) {
    String[][] data = new String[0][13];
    try {
      data = stockManagementData.getStockLedgerByOrderDate(ledgerDate,
          startDate, endDate, orderType);
    } catch (Exception ex) {
      ex.printStackTrace();
    }
    return data;
  }
  //根据单据编号取得库存账套明细数据表的记录
  public String[][] getStockSubLedgerByOrderId(String ledgerDate,
                                               String orderId) {
    String[][] data = new String[0][6];
    try {
      data = stockManagementData.getStockSubLedgerByOrderId(ledgerDate, orderId);
    }catch (Exception ex) {
      ex.printStackTrace();
    }
    return data;
  }
  //创建库存账套数据表和库存账套明细数据表记录的方法
  public int createStockLedgerAndSub(String ledgerDate, String[] stockLedger,
                                     String[][] stockSubLedger) {
    int result = 0;
    try{
      result = stockManagementData.createStockLedgerAndSub(ledgerDate,
          stockLedger, stockSubLedger);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return result;
  }
  //更新库存账套数据表和库存账套明细数据表记录的方法
  public int updateStockLedgerAndSub(String ledgerDate, String[] stockLedger,
                                     String[][] stockSubLedger) {
    int result = 0;
    try{
      result = stockManagementData.updateStockLedgerAndSub(ledgerDate,
          stockLedger, stockSubLedger);
    }catch(Exception ex){
      ex.printStackTrace();
    }
    return result;