}
  //測(cè)試根據(jù)操作內(nèi)容取得日志記錄的方法
  public void testUserLogFindByOperationContent() throws Exception{
    String[][] detail = stockManagementData.getUserLogByOperationContent("%刪除%");
    this.assertEquals("", 2, detail.length);
  }
  //測(cè)試根據(jù)用戶名取得日志記錄的方法
  public void testUserLogFindByUserName() throws Exception{
    String[][] detail = stockManagementData.getUserLogByUserName("%ame%");
    this.assertEquals("", 23, detail.length);
  }
  //測(cè)試根據(jù)日期范圍取得日志記錄的方法
  public void testUserLogFindByOperationDate() throws Exception{
    //創(chuàng)建日期類(lèi)
    java.util.Calendar date = java.util.Calendar.getInstance();
    date.set(2004, 4, 4, 0, 0, 0);
    java.sql.Timestamp startDate = new java.sql.Timestamp(date.getTime().getTime());
    date.set(2004, 4, 8, 23, 59, 59);
    java.sql.Timestamp endDate = new java.sql.Timestamp(date.getTime().getTime());
    String[][] detail = stockManagementData.getUserLogByOperationDate(startDate, endDate);
    this.assertEquals("", 69, detail.length);
  }
  //測(cè)試根據(jù)單據(jù)編號(hào)或者請(qǐng)購(gòu)員名字或者倉(cāng)庫(kù)名字取得庫(kù)存賬套數(shù)據(jù)表記錄的方法
  public void testGetStockLedgerByStringField() throws Exception{
    //根據(jù)單據(jù)編號(hào)取得記錄
    String[][] detail = stockManagementData.getStockLedgerByStringField(
        "200404", "orderId", "1", 0);
    this.assertEquals("", 1, detail.length);
    //根據(jù)請(qǐng)購(gòu)員名字取得記錄
    detail = stockManagementData.getStockLedgerByStringField("200404",
        "submitUser", "請(qǐng)", 0);
    this.assertEquals("", 5, detail.length);
    //根據(jù)倉(cāng)庫(kù)名字取得記錄
    detail = stockManagementData.getStockLedgerByStringField("200404", "warehouse", "倉(cāng)", 0);
    this.assertEquals("", 3, detail.length);
  }
  //測(cè)試根據(jù)訂單日期取得庫(kù)存賬套數(shù)據(jù)表記錄的方法
  public void testGetStockLedgerByOrderDate() throws Exception{
    //創(chuàng)建日期類(lèi)
    java.util.Calendar date = java.util.Calendar.getInstance();
    date.set(2004, 3, 1, 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, 20, 23, 59, 59);
    date.set(java.util.Calendar.MILLISECOND, 998);
    java.sql.Timestamp endDate = new java.sql.Timestamp(date.getTime().getTime());
    String[][] detail = stockManagementData.getStockLedgerByOrderDate("200404", startDate, endDate, 0);
    this.assertEquals("", 5, detail.length);
  }
  //測(cè)試根據(jù)單據(jù)編號(hào)取得庫(kù)存賬套明細(xì)數(shù)據(jù)表的記錄
  public void testGetStockSubLedgerByOrderId() throws Exception{
    //根據(jù)單據(jù)編號(hào)取得記錄
    String[][] detail = stockManagementData.getStockSubLedgerByOrderId(
        "200404", "20040400001");
    this.assertEquals("", 2, detail.length);
  }
  //測(cè)試創(chuàng)建庫(kù)存賬套數(shù)據(jù)表和庫(kù)存賬套明細(xì)數(shù)據(jù)表記錄的方法
  public void testCreateStockLedgerAndSub() throws Exception{
    /*String ledgerDate = "200405";
    String[] stockLedger = {
        "", "0", "供應(yīng)商1", "jack", "", "", "", "", "倉(cāng)庫(kù)1", "2004-5-5", "2004-5-15",
        "0", ""};
    String[][] stockSubLedger = {{"", "", "10000001", "10", "50", "2004-12-5"},
        {"", "", "10000002", "17", "20", "2004-11-3"}};
    int result = stockManagementData.createStockLedgerAndSub(ledgerDate, stockLedger, stockSubLedger);
    this.assertEquals("", 1, result);*/
  }
  //測(cè)試更新庫(kù)存賬套數(shù)據(jù)表和庫(kù)存賬套明細(xì)數(shù)據(jù)表記錄的方法
  public void testUpdateStockLedgerAndSub() throws Exception{
   /* String ledgerDate = "200405";
    String[] stockLedger = {
        "20040500002", "0", "供應(yīng)商1(u)", "jack(u)", "jack", "(u)", "(u)", "(u)",
        "倉(cāng)庫(kù)1(u)", "2004-5-6", "2004-5-16", "0", "(u)"};
    String[][] stockSubLedger = {{"21", "20040500002", "10000001", "8.6", "30", "2004-12-8"},
        {"22", "20040500002", "10000002", "16.5", "12", "2004-12-9"}};
    int result = stockManagementData.updateStockLedgerAndSub(ledgerDate, stockLedger, stockSubLedger);
    this.assertEquals("", 1, result);*/
  }
  //測(cè)試撤消庫(kù)存賬套數(shù)據(jù)表記錄的方法
  public void testCancelStockLedgerAndSub() throws Exception{
    String ledgerDate = "200405";
    String orderId = "20040500002";
    String remark = "倉(cāng)庫(kù)1不需要該存貨.";
    int result = stockManagementData.cancelStockLedgerAndSub(ledgerDate, orderId, remark);
    this.assertEquals("", 1, result);
  }
  //測(cè)試恢復(fù)庫(kù)存賬套數(shù)據(jù)表完成狀態(tài)的方法
  public void testRestoreStockLedgerAndSub() throws Exception{
    String ledgerDate = "200405";
    String orderId = "20040500002";
    String remark = "重新進(jìn)行填寫(xiě)操作.";
    int result = stockManagementData.restoreStockLedgerAndSub(ledgerDate, orderId, remark);
    this.assertEquals("", 1, result);
  }
  //測(cè)試庫(kù)存賬套數(shù)據(jù)表電子簽名的方法
  public void testSignStockLedgerAndSub() throws Exception{
    String ledgerDate = "200405";
    String fieldName = "commitUser";
    String userName = "jack";
    String orderId = "20040500003";
    String remark = "已經(jīng)向供應(yīng)商發(fā)送了進(jìn)貨單.";
    int result = stockManagementData.signStockLedgerAndSub(ledgerDate, fieldName, userName, orderId, remark);
    this.assertEquals("", 1, result);
  }
  //測(cè)試根據(jù)完成狀態(tài)取得庫(kù)存賬套數(shù)據(jù)表的記錄
  public void testGetStockLedgerByOnProcess() throws Exception{
    //根據(jù)完成狀態(tài)取得記錄
    String[][] detail = stockManagementData.getStockLedgerByOnProcess(
        "200404", 0, 0);
    this.assertEquals("", 1, detail.length);
  }
  //測(cè)試創(chuàng)建會(huì)計(jì)分錄的方法
  public void testCreateAccountEntry() throws Exception{
    /*String ledgerDate = "200405";
    String[] accountEntry = {"st20040500005", "jack", "", "2004-5-20", null, "0", ""};
    String[][] accountSubEntry = {{"0", "流動(dòng)資產(chǎn)@@存貨@@10000001", "20"},
        {"0", "流動(dòng)資產(chǎn)@@存貨@@10000002", "30"}, {"1", "短期負(fù)債@@應(yīng)付賬款@@供應(yīng)商1", "50"}};
    int result = stockManagementData.createAccountEntry(ledgerDate,
        accountEntry, accountSubEntry, false, null);
    this.assertEquals("", 1, result);*/
  }
  //測(cè)試創(chuàng)建往來(lái)賬套的方法
  public void testCreateCurrentAccountLedger() throws Exception{
    /*String ledgerDate = "200405";
    String[] currentAccountLedger = {
        "st20040500005", "0", "50.6", "供應(yīng)商1", "jack", "", "2004-5-20", null,
        "0", ""};
    int result = stockManagementData.createCurrentAccountLedger(ledgerDate,
        currentAccountLedger, false, null);
    this.assertEquals("", 1, result);*/
  }
  //測(cè)試驗(yàn)收員進(jìn)行庫(kù)存賬套數(shù)據(jù)表電子簽名的方法
  public void testCheckUserSignStockLedgerAndSub() throws Exception{
    String ledgerDate = "200405";
    String userName = "jack";
    String orderId = "20040500005";
    String supplierName = "供應(yīng)商1";
    String remark = "貨物已經(jīng)驗(yàn)收入庫(kù).";
    int result = stockManagementData.checkUserSignStockLedgerAndSub(ledgerDate,
        userName, supplierName, orderId, remark);
    this.assertEquals("", 1, result);
  }
  //測(cè)試根據(jù)相關(guān)聯(lián)票據(jù)標(biāo)識(shí)取得往來(lái)賬套數(shù)據(jù)表的記錄的方法
  public void testGetCurrentAccountLedgerBylinkId() throws Exception{
    String ledgerDate = "200405";
    String orderId = "st20040500005";
    String[] data = stockManagementData.getCurrentAccountLedgerBylinkId(
        ledgerDate, orderId);
    this.assertEquals("", "供應(yīng)商1", data[4]);
  }
  //測(cè)試根據(jù)票據(jù)編號(hào)、開(kāi)票據(jù)的用戶名、供應(yīng)商名字取得往來(lái)賬套數(shù)據(jù)表記錄的方法
  public void testGetCurrentAccountLedgerByStringField() throws Exception{
    //根據(jù)單據(jù)編號(hào)取得記錄
    String[][] detail = stockManagementData.getCurrentAccountLedgerByStringField(
        "200404", "currentAccountId", "2", 0);
    this.assertEquals("", 1, detail.length);
  }
  //測(cè)試根據(jù)完成狀態(tài)取得往來(lái)賬套數(shù)據(jù)表記錄的方法
  public void testGetCurrentAccountLedgerByOnProcess() throws Exception{
    //根據(jù)完成狀態(tài)取得記錄
    String[][] detail = stockManagementData.getCurrentAccountLedgerByOnProcess(
        "200404", 0, 0);
    this.assertEquals("", 1, detail.length);
  }
  //測(cè)試根據(jù)開(kāi)票據(jù)日期取得往來(lái)賬套數(shù)據(jù)表記錄的方法
  public void testGetCurrentAccountLedgerByFillDate() throws Exception{
    //創(chuàng)建日期類(lèi)
    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);
  }
  //測(cè)試創(chuàng)建現(xiàn)金賬套的方法
  public void testCreateCashLedger() throws Exception{
    /*String ledgerDate = "200405";
    String[] cashLedger = {
        "cu20040500001", "0", "jack", "50.6", "2004-5-20"};
    int result = stockManagementData.createCashLedger(ledgerDate,
        cashLedger, false, null);
    this.assertEquals("", 1, result);*/
  }
  //測(cè)試現(xiàn)金管理員進(jìn)行往來(lái)賬套數(shù)據(jù)表電子簽名的方法
  public void testCashUserSignAccountPayable() throws Exception{
    String ledgerDate = "200405";
    String userName = "jack";
    String[] currentAccountLedger = {"20040500002", "st20040400004", "0", "445",
        "供應(yīng)商3", "jack", "", "2004-5-25 0:05:38", null, "0", ""};
    int result = stockManagementData.cashUserSignAccountPayable(ledgerDate,
        userName, currentAccountLedger);
    this.assertEquals("", 1, result);
  }
  //測(cè)試根據(jù)關(guān)聯(lián)票據(jù)標(biāo)識(shí)、記賬用戶取得現(xiàn)金賬套數(shù)據(jù)表記錄的方法
  public void testGetCashLedgerByStringField() throws Exception{
    //根據(jù)關(guān)聯(lián)票據(jù)標(biāo)識(shí)取得記錄
    String[][] detail = stockManagementData.getCashLedgerByStringField(
        "200405", "linkId", "cu20040500002");
    this.assertEquals("", 1, detail.length);
  }
  //測(cè)試根據(jù)發(fā)生日期取得現(xiàn)金賬套數(shù)據(jù)表記錄的方法
  public void testGetCashLedgerByFillDate() throws Exception{
    //創(chuàng)建日期類(lèi)
    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);
  }
  //測(cè)試現(xiàn)金管理員收取退款進(jìn)行電子簽名的方法
  public void testCashUserSignStockLedgerForStockReturn() throws Exception{
    //供應(yīng)商已付款
    String ledgerDate = "200405";
    String userName = "jack";
    String orderId = "20040500043";
    String supplierName = "供應(yīng)商1";
    String remark = "退貨貨物已經(jīng)收款.";
    int result = stockManagementData.cashUserSignStockLedgerForStockReturn(ledgerDate,
        userName, supplierName, orderId, remark, true);
    this.assertEquals("", 1, result);
    //供應(yīng)商未付款
    ledgerDate = "200405";
    userName = "jack";
    orderId = "20040500044";
    supplierName = "供應(yīng)商2";
    remark = "退貨貨物已經(jīng)收款.";
    result = stockManagementData.cashUserSignStockLedgerForStockReturn(ledgerDate,
        userName, supplierName, orderId, remark, false);
    this.assertEquals("", 1, result);
  }
  //測(cè)試根據(jù)會(huì)計(jì)分錄賬套數(shù)據(jù)表的序號(hào)取得會(huì)計(jì)分錄明細(xì)數(shù)據(jù)表的記錄的方法
  public void testGetAccountEntrySubLedgerByLinkSerialId() throws Exception{
    String ledgerDate = "200404";
    int linkSerialId = 1;
    String[][] data = stockManagementData.getAccountEntrySubLedgerByLinkSerialId(
        ledgerDate, linkSerialId);
    this.assertEquals("", 3, data.length);
  }
  //測(cè)試根據(jù)會(huì)計(jì)科目、關(guān)聯(lián)的票據(jù)標(biāo)識(shí)、記賬用戶、審核用戶取得會(huì)計(jì)分錄賬套數(shù)據(jù)表記錄的方法
  public void testGetAccountEntryLedgerByStringField() throws Exception{
    String ledgerDate = "200404";
    String accountName = "現(xiàn)金";
    String fieldName = "filler";
    String fieldValue = "a";
    String[][] data = stockManagementData.getAccountEntryLedgerByStringField(
        ledgerDate, accountName, fieldName, fieldValue);
    this.assertEquals("", 5, data.length);
  }
  //測(cè)試根據(jù)會(huì)計(jì)科目、完成狀態(tài)取得會(huì)計(jì)分錄賬套數(shù)據(jù)表記錄的方法
  public void testGetAccountEntryLedgerByOnProcess() throws Exception{
    String ledgerDate = "200404";
    String accountName = "現(xiàn)金";
    int onProcess = 0;
    String[][] data = stockManagementData.getAccountEntryLedgerByOnProcess(
        ledgerDate, accountName, onProcess);
    this.assertEquals("", 1, data.length);