teststockmanagementdatacactus1.java

EJB做的工业进销存系统 EJB做的工业进销存系统

  }
  //测试根据会计科目、记账日期取得会计分录账套数据表记录的方法
  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 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 testSignStockLedgerAndSubForFinish() throws Exception{
    String ledgerDate = "200405";
    String fieldName = "checkUser";
    String userName = "jack";
    String orderId = "20040500058";
    int onProcess = 2;
    String remark = "商品调出单已验收.";
    int result = stockManagementData.signStockLedgerAndSubForFinish(ledgerDate,
        fieldName, userName, orderId, onProcess, remark);
    this.assertEquals("", 1, result);
  }
  //测试根据仓库名字取得盘点数据的方法
  public void testGetStocktakeQuantityByWarehouse()  throws Exception{
    String ledgerDate = "200405";
    String warehouse = "仓库1";
    int onProcess = 2;
    String[][] data = stockManagementData.getStocktakeQuantityByWarehouse(
        ledgerDate, warehouse, onProcess);
    this.assertEquals("", 4, data.length);
  }
  //测试根据仓库名字汇总显示商品数量和金额的方法
  public void testGetStockByWarehouse()  throws Exception{
    String ledgerDate = "200405";
    String warehouse = "仓库1";
    int onProcess = 2;
    String[][] data = stockManagementData.getStockByWarehouse(
        ledgerDate, warehouse, onProcess);
    this.assertEquals("", 27, data.length);
  }
  //测试根据商品条形码汇总显示商品在各个仓库的数量和金额的方法
  public void testGetStockByGoodsBarcode()  throws Exception{
    String ledgerDate = "200405";
    String goodsBarcode = "10000005";
    int onProcess = 2;
    String[][] data = stockManagementData.getStockByGoodsBarcode(
        ledgerDate, goodsBarcode, onProcess);
    this.assertEquals("", 8, data.length);
  }
  //测试查询过期商品的方法
  public void testGetStockByUsefulLife()  throws Exception{
    String ledgerDate = "200405";
    String usefulLife = "2004-6-1";
    int onProcess = 2;
    String[][] data = stockManagementData.getStockByUsefulLife(
        ledgerDate, usefulLife, onProcess);
    this.assertEquals("", 3, data.length);
  }
  //测试创建销售账套数据表和销售账套明细数据表记录的方法
  public void testCreateSaleLedgerAndSub() throws Exception{
    /*String ledgerDate = "200405";
    String[] saleLedger = {
        "", "0", "顾客", "jack", "", "", "", "2004-5-5", "2004-5-15",
        "0", ""};
    String[][] saleSubLedger = {{"", "", "10000001", "15.2", "10"},
        {"", "", "10000002", "18.5", "17"}};
    int result = stockManagementData.createSaleLedgerAndSub(ledgerDate, saleLedger, saleSubLedger);
    this.assertEquals("", 1, result);*/
  }
  //测试更新销售账套数据表和销售账套明细数据表记录的方法
  public void testUpdateSaleLedgerAndSub() throws Exception{
    String ledgerDate = "200405";
    String[] saleLedger = {
        "20040500001", "0", "顾客", "jack", "", "", "", "2004-5-6", "2004-5-6",
        "0", ""};
    String[][] saleSubLedger = {{"6", "20040500001", "10000001", "15.2", "3"},
        {"7", "20040500001", "10000002", "18.5", "5"}};
    int result = stockManagementData.updateSaleLedgerAndSub(ledgerDate, saleLedger, saleSubLedger);
    this.assertEquals("", 1, result);
  }
  //测试销售账套数据表电子签名和更新完成状态的方法
  public void testSignSaleLedgerAndSubForFinish() throws Exception{
    String ledgerDate = "200405";
    String fieldName = "counterUser";
    String userName = "jack";
    String orderId = "20040500001";
    int onProcess = 1;
    String remark = "销售单已撤消.";
    int result = stockManagementData.signSaleLedgerAndSub(ledgerDate,
        fieldName, userName, orderId, onProcess, remark);
    this.assertEquals("", 1, result);
  }
  //测试根据单据编号取得销售账套明细数据表的记录
  public void testGetSaleSubLedgerBySaleId() throws Exception{
    //根据单据编号取得记录
    String[][] detail = stockManagementData.getSaleSubLedgerBySaleId(
        "200404", "20040400001");
    this.assertEquals("", 1, detail.length);
  }
  //测试根据字符串字段取得销售账套数据表记录的方法
  public void testGetSaleLedgerByStringField() throws Exception{
    //根据单据编号取得记录
    String[][] detail = stockManagementData.getSaleLedgerByStringField(
        "200404", "saleId", "2004", 0);
    this.assertEquals("", 1, detail.length);
  }
  //测试根据填写日期取得销售账套数据表记录的方法
  public void testGetSaleLedgerByOrderDate() throws Exception{
    //创建日期类
    java.util.Calendar date = java.util.Calendar.getInstance();
    date.set(2004, 3, 10, 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, 10, 23, 59, 59);
    date.set(java.util.Calendar.MILLISECOND, 998);
    java.sql.Timestamp endDate = new java.sql.Timestamp(date.getTime().getTime());
    String[][] detail = stockManagementData.getSaleLedgerByOrderDate("200404", startDate, endDate, 1);
    this.assertEquals("", 1, detail.length);
  }
  //测试根据完成状态取得销售账套数据表的记录
  public void testGetSaleLedgerByOnProcess() throws Exception{
    //根据完成状态取得记录
    String[][] detail = stockManagementData.getSaleLedgerByOnProcess(
        "200404", 1, 0);
    this.assertEquals("", 1, detail.length);
  }
  //测试前台销售员进行销售账套数据表电子签名的方法
  public void testCounterUserSignSaleLedgerAndSub() throws Exception{
    String ledgerDate = "200405";
    String userName = "jack";
    String remark = "已签名";
    String warehouse = "柜台1";
    int result = stockManagementData.counterUserSignSaleLedgerAndSub(ledgerDate,
        userName, remark, warehouse);
    this.assertEquals("", 1, result);
  }
  //测试信用销售员进行销售账套数据表电子签名的方法
  public void testCreditUserSignSaleLedgerAndSub() throws Exception{
    String ledgerDate = "200405";
    String userName = "jack";
    String remark = "已签名";
    String warehouse = "柜台1";
    String saleId = "20040500011";
    String customerName = "客户1";
    int result = stockManagementData.creditUserSignSaleLedgerAndSub(ledgerDate,
        userName, remark, warehouse, saleId, customerName);
    this.assertEquals("", 1, result);
  }
  //测试现金管理员进行应收账款电子签名的方法
  public void testCashUserSignAccountReceivable() throws Exception{
    String ledgerDate = "200405";
    String userName = "jack";
    String[] currentAccountLedger = {"20040500012", "sa20040500011", "1", "466.5",
        "客户1", "jack", "", "2004-6-11 12:19:52", null, "0", "已签名."};
    int result = stockManagementData.cashUserSignAccountReceivable(ledgerDate,
        userName, currentAccountLedger);
    this.assertEquals("", 1, result);
  }
  //测试根据关联标识、退货单的商品条形码取得库存账套的销售出库单明细账的数据
  public void testGetStockSaleOutBySaleOrderLink() throws Exception{
    String ledgerDate = "200405";
    String saleOrderLink = "sajack";
    String saleId = "20040500015";
    String[][] data = stockManagementData.getStockSaleOutBySaleOrderLink(
        ledgerDate, saleOrderLink, saleId);
    this.assertEquals("", 3, data.length);
  }
  //测试前台销售员进行销售退货单电子签名的方法
  public void testCountUserSignSaleReturn() throws Exception{
    String ledgerDate = "200405";
    String userName = "jack";
    String remark = "已签名";
    String warehouse = "柜台1";
    String saleId = "20040500015";
    //销售退货，库存数量增加
    String[][] stockSubLedger = {
        {"", "", "10000001", "15.2", "1", "2004-05-20"},
    };
    int result = stockManagementData.counterUserSignSaleReturn(ledgerDate,
        saleId, userName, remark, warehouse, stockSubLedger);
    this.assertEquals("", 1, result);
  }
  //测试信用销售员进行销售退货单电子签名的方法
  public void testCreditUserSignSaleReturn() throws Exception{
    String ledgerDate = "200405";
    String userName = "jack";
    String remark = "已签名";
    String warehouse = "柜台1";
    String customerName = "客户1";
    String saleId = "20040500020";
    //销售退货，库存数量增加
    String[][] stockSubLedger = {
        {"", "", "10000001", "3.7", "10", "2004-11-5"},
    };
    int result = stockManagementData.creditUserSignSaleReturn(ledgerDate,
        saleId, userName, remark, warehouse, customerName,stockSubLedger, true);
    this.assertEquals("", 1, result);
  }
}