teststockmanagementdata.java

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

    result = stockManagementData.checkWarehouse("仓库2");
    this.assertEquals("", 1, result);
  }
  //测试检查商品条形码的方法
  public void testCheckGoodsBarCode() throws Exception{
    String goodsBarCode = "1000";
    int result = stockManagementData.checkGoodsBarCode(goodsBarCode);
    this.assertEquals("", 0, result);
    result = stockManagementData.checkGoodsBarCode("10000003");
    this.assertEquals("", 1, result);
  }
  //测试打开账套是否最新账套的方法
  public void testIsCurrentLedger() throws Exception{
    int result = stockManagementData.isCurrentLedger("200405");
    this.assertEquals("", 1, result);
  }
  //测试恢复库存账套数据表完成状态的方法
  public void testRestoreStockLedgerAndSub() throws Exception{
    String ledgerDate = "200405";
    String orderId = "20040500002";
    String remark = "重新进行填写操作.";
    int result = stockManagementData.restoreStockLedgerAndSub(ledgerDate, orderId, remark);
    this.assertEquals("", 1, result);
  }
  //测试库存账套数据表电子签名的方法
  public void testSignStockLedgerAndSub() throws Exception{
    String ledgerDate = "200405";
    String fieldName = "commitUser";
    String userName = "jack";
    String orderId = "20040500003";
    String remark = "已经向供应商发送了进货单.";
    int result = stockManagementData.signStockLedgerAndSub(ledgerDate, fieldName, userName, orderId, remark);
    this.assertEquals("", 1, result);
  }
  //测试根据完成状态取得库存账套数据表的记录
  public void testGetStockLedgerByOnProcess() throws Exception{
    //根据完成状态取得记录
    String[][] detail = stockManagementData.getStockLedgerByOnProcess(
        "200404", 0, 0);
    this.assertEquals("", 1, detail.length);
  }
  //测试验收员进行库存账套数据表电子签名的方法
  public void testCheckUserSignStockLedgerAndSub() throws Exception{
    String ledgerDate = "200405";
    String userName = "jack";
    String orderId = "20040500005";
    String supplierName = "供应商1";
    String remark = "货物已经验收入库.";
    int result = stockManagementData.checkUserSignStockLedgerAndSub(ledgerDate,
        userName, supplierName, orderId, remark);
    this.assertEquals("", 1, result);
  }
  //测试根据相关联票据标识取得往来账套数据表的记录的方法
  public void testGetCurrentAccountLedgerBylinkId() throws Exception{
    String ledgerDate = "200405";
    String orderId = "st20040500005";
    String[] data = stockManagementData.getCurrentAccountLedgerBylinkId(
        ledgerDate, orderId);
    this.assertEquals("", "供应商1", data[4]);
  }
  //测试根据票据编号、开票据的用户名、供应商名字取得往来账套数据表记录的方法
  public void testGetCurrentAccountLedgerByStringField() throws Exception{
    //根据单据编号取得记录
    String[][] detail = stockManagementData.getCurrentAccountLedgerByStringField(
        "200404", "currentAccountId", "2", 0);
    this.assertEquals("", 1, detail.length);
  }
  //测试根据完成状态取得往来账套数据表记录的方法
  public void testGetCurrentAccountLedgerByOnProcess() throws Exception{
    //根据完成状态取得记录
    String[][] detail = stockManagementData.getCurrentAccountLedgerByOnProcess(
        "200404", 0, 0);
    this.assertEquals("", 1, detail.length);
  }
  //测试根据开票据日期取得往来账套数据表记录的方法
  public void testGetCurrentAccountLedgerByFillDate() throws Exception{
    //创建日期类
    java.util.Calendar date = java.util.Calendar.getInstance();
    date.set(2004, 3, 6, 0, 0, 0);
    date.set(java.util.Calendar.MILLISECOND, 0);
    java.sql.Timestamp startDate = new java.sql.Timestamp(date.getTime().getTime());
    date.set(2004, 3, 7, 23, 59, 59);
    date.set(java.util.Calendar.MILLISECOND, 998);
    java.sql.Timestamp endDate = new java.sql.Timestamp(date.getTime().getTime());
    String[][] detail = stockManagementData.getCurrentAccountLedgerByFillDate("200404", startDate, endDate, 0);
    this.assertEquals("", 1, detail.length);
  }
  //测试现金管理员进行往来账套数据表电子签名的方法
  public void testCashUserSignAccountPayable() throws Exception{
    String ledgerDate = "200405";
    String userName = "jack";
    String[] currentAccountLedger = {"20040500002", "st20040400004", "0", "445",
        "供应商3", "jack", "", "2004-5-25 0:05:38", null, "0", "已经付款."};
    int result = stockManagementData.cashUserSignAccountPayable(ledgerDate,
        userName, currentAccountLedger);
    this.assertEquals("", 1, result);
  }
  //测试根据关联票据标识、记账用户取得现金账套数据表记录的方法
  public void testGetCashLedgerByStringField() throws Exception{
    //根据关联票据标识取得记录
    String[][] detail = stockManagementData.getCashLedgerByStringField(
        "200405", "linkId", "cu20040500002");
    this.assertEquals("", 1, detail.length);
  }
  //测试根据发生日期取得现金账套数据表记录的方法
  public void testGetCashLedgerByFillDate() throws Exception{
    //创建日期类
    java.util.Calendar date = java.util.Calendar.getInstance();
    date.set(2004, 4, 25, 0, 0, 0);
    date.set(java.util.Calendar.MILLISECOND, 0);
    java.sql.Timestamp startDate = new java.sql.Timestamp(date.getTime().getTime());
    date.set(2004, 4, 25, 23, 59, 59);
    date.set(java.util.Calendar.MILLISECOND, 998);
    java.sql.Timestamp endDate = new java.sql.Timestamp(date.getTime().getTime());
    String[][] detail = stockManagementData.getCashLedgerByFillDate("200405",
        startDate, endDate);
    this.assertEquals("", 4, detail.length);
  }
  //测试现金管理员收取退款进行电子签名的方法
  public void testCashUserSignStockLedgerForStockReturn() throws Exception{
    //供应商已付款
    String ledgerDate = "200405";
    String userName = "jack";
    String orderId = "20040500043";
    String supplierName = "供应商1";
    String remark = "退货货物已经收款.";
    int result = stockManagementData.cashUserSignStockLedgerForStockReturn(ledgerDate,
        userName, supplierName, orderId, remark, true);
    this.assertEquals("", 1, result);
    //供应商未付款
    ledgerDate = "200405";
    userName = "jack";
    orderId = "20040500044";
    supplierName = "供应商2";
    remark = "退货货物已经收款.";
    result = stockManagementData.cashUserSignStockLedgerForStockReturn(ledgerDate,
        userName, supplierName, orderId, remark, false);
    this.assertEquals("", 1, result);
  }
  //测试根据会计分录账套数据表的序号取得会计分录明细数据表的记录的方法
  public void testGetAccountEntrySubLedgerByLinkSerialId() throws Exception{
    String ledgerDate = "200404";
    int linkSerialId = 1;
    String[][] data = stockManagementData.getAccountEntrySubLedgerByLinkSerialId(
        ledgerDate, linkSerialId);
    this.assertEquals("", 3, data.length);
  }
  //测试根据会计科目、关联的票据标识、记账用户、审核用户取得会计分录账套数据表记录的方法
  public void testGetAccountEntryLedgerByStringField() throws Exception{
    String ledgerDate = "200404";
    String accountName = "现金";
    String fieldName = "filler";
    String fieldValue = "a";
    String[][] data = stockManagementData.getAccountEntryLedgerByStringField(
        ledgerDate, accountName, fieldName, fieldValue);
    this.assertEquals("", 5, data.length);
  }
  //测试根据会计科目、完成状态取得会计分录账套数据表记录的方法
  public void testGetAccountEntryLedgerByOnProcess() throws Exception{
    String ledgerDate = "200404";
    String accountName = "现金";
    int onProcess = 0;
    String[][] data = stockManagementData.getAccountEntryLedgerByOnProcess(
        ledgerDate, accountName, onProcess);
    this.assertEquals("", 1, data.length);
  }
  //测试根据会计科目、记账日期取得会计分录账套数据表记录的方法
  public void testGetAccountEntryLedgerByFillDate() throws Exception{
    String accountName = "现金";
    //创建日期类
    java.util.Calendar date = java.util.Calendar.getInstance();
    date.set(2004, 3, 5, 0, 0, 0);
    date.set(java.util.Calendar.MILLISECOND, 0);
    java.sql.Timestamp startDate = new java.sql.Timestamp(date.getTime().getTime());
    date.set(2004, 3, 5, 23, 59, 59);
    date.set(java.util.Calendar.MILLISECOND, 998);
    java.sql.Timestamp endDate = new java.sql.Timestamp(date.getTime().getTime());
    String[][] data = stockManagementData.getAccountEntryLedgerByFillDate("200404",
        startDate, endDate, accountName);
    this.assertEquals("", 5, data.length);
  }
  //测试撤消会计分录账套数据表记录完成状态的方法
  public void testCancelAccountEntryLedger() throws Exception{
    String ledgerDate = "200405";
    int serialId = 3;
    int onProcess = 1;
    String remark = "该会计分录已撤消.";
    int result = stockManagementData.cancelOrRestoreAccountEntryLedger(
        ledgerDate, serialId, onProcess, remark);
    this.assertEquals("", 1, result);
  }
  //测试恢复会计分录账套数据表记录完成状态的方法
  public void testRestoreAccountEntryLedger() throws Exception{
    String ledgerDate = "200405";
    int serialId = 3;
    int onProcess = 0;
    String remark = "该会计分录已撤消.(恢复)";
    int result = stockManagementData.cancelOrRestoreAccountEntryLedger(
        ledgerDate, serialId, onProcess, remark);
    this.assertEquals("", 1, result);
  }
  //测试会计分录账套数据表电子签名的方法
  public void testSignAccountEntryLedger() throws Exception{
    String ledgerDate = "200405";
    int serialId = 3;
    String fieldName = "auditUser";
    int onProcess = 2;
    String userName = "jack";
    String remark = "该会计分录已撤消.(恢复)(电子签名)";
    int result = stockManagementData.signAccountEntryLedger(
        ledgerDate, fieldName, userName, serialId, onProcess, remark);
    this.assertEquals("", 1, result);
  }
  //测试会计分录账套数据表的取消电子签名的方法
  public void testUnSignAccountEntryLedger() throws Exception{
    String ledgerDate = "200405";
    int serialId = 3;
    String fieldName = "auditUser";
    int onProcess = 0;
    String userName = "";
    String remark = "该会计分录已撤消.(恢复)(电子签名)(取消电子签名)";
    int result = stockManagementData.signAccountEntryLedger(
        ledgerDate, fieldName, userName, serialId, onProcess, remark);
    this.assertEquals("", 1, result);
  }
  //测试创建会计分录的方法
  public void testCreateAccountEntry() throws Exception{
    /*String ledgerDate = "200405";
    String[] accountEntry = {"st20040500008", "jack", "", "2004-5-20", null, "0", ""};
    String[][] accountSubEntry = {{"0", "流动资产@@存货@@10000001", "20"},
        {"0", "流动资产@@存货@@10000002", "30"}, {"1", "短期负债@@应付账款@@供应商1", "50"}};
    int result = stockManagementData.createAccountEntry(ledgerDate,
        accountEntry, accountSubEntry);
    this.assertEquals("", 1, result);*/
  }
  //测试会计分录更新的方法
  public void testUpdateAccountEntry() throws Exception{
    String ledgerDate = "200405";
    String[] accountEntry = {"5", "st20040500003", "jack", "", "2004-5-30 1:19:33",
        "2004-6-1 11:42:25", "1", "备注"};
    String[][] accountSubEntry = {{"18", "5", "0", "流动资产@@存货@@10000002", "340"},
        {"19", "5", "0", "流动资产@@存货@@10000001", "340"},
        {"20", "5", "1", "短期负债@@应付账款@@供应商2", "680"}};
    int result = stockManagementData.updateAccountEntry(ledgerDate,
        accountEntry, accountSubEntry);
    this.assertEquals("", 1, result);
  }
  //测试创建商品调拔单的方法
  public void testCreateTransferOrder()throws Exception{
    /*String ledgerDate = "200405";
    String[] stockLedger = {
        "", "2", "", "jack", "仓库3", "", "", "", "仓库2", "2004-5-5", "2004-5-15",
        "0", ""};
    String[][] stockSubLedger = {{"", "", "10000001", "10", "-12", "2004-12-5"},
        {"", "", "10000002", "17", "-13", "2004-11-3"}};
    int result = stockManagementData.createTransferOrder(ledgerDate,
        stockLedger, stockSubLedger);
    this.assertEquals("", 1, result);*/
  }
  //测试更新商品调拔单的方法
  public void testUpdateTransferOrder()throws Exception{
    String ledgerDate = "200405";
    String[] stockLedger = {
        "20040500050", "2", "20040500049", "jack", "仓库1", "", "", "", "仓库2", "2004-5-6", "2004-5-16",
        "0", ""};
    String[][] stockSubLedger = {{"229", "20040500050", "10000001", "10", "-5", "2004-12-5"},
        {"230", "20040500050", "10000002", "17", "-8", "2004-11-3"}};
    int result = stockManagementData.updateTransferOrder(ledgerDate,
        stockLedger, stockSubLedger);
    this.assertEquals("", 1, result);
  }
  //测试撤消商品调拔单的方法
  public void testCancelTransferOrder()throws Exception{
    String ledgerDate = "200405";
    String inOrderId = "20040500049";
    String outOrderId = "20040500050";
    int onProcess = 1;
    String remark = "";
    int result = stockManagementData.cancelOrRestoreTransferOrder(ledgerDate,
        inOrderId, outOrderId, onProcess, remark);
    this.assertEquals("", 1, result);
  }
  //测试恢复商品调拔单的方法
  public void testRestoreTransferOrder()throws Exception{
    String ledgerDate = "200405";
    String inOrderId = "20040500049";
    String outOrderId = "20040500050";
    int onProcess = 0;
    String remark = "";
    int result = stockManagementData.cancelOrRestoreTransferOrder(ledgerDate,
        inOrderId, outOrderId, onProcess, remark);
    this.assertEquals("", 1, result);
  }
  //测试库存账套数据表电子签名和更新完成状态的方法
  public void testSignStockLedgerAndSubForFinish() throws Exception{
    String ledgerDate = "200405";
    String fieldName = "checkUser";
    String userName = "jack";
    String orderId = "20040500058";
    int onProcess = 2;
    String remark = "商品调出单已验收.";