Package com.asakusafw.runtime.value

Examples of com.asakusafw.runtime.value.DateTimeOption


        testField(list, "getCVcharOption", DATA.DATETIME_DATETIME_FIMT1, stringOption.modify("2010-10-01 12:01:18"));
        testField(list, "getCVcharOption", DATA.DATETIME_DATETIME_FIMT2, stringOption.modify("2010-10-01 12:01:18"));
        testField(list, "getCVcharOption", DATA.STRING_DATETIME, stringOption.modify("2010-10-01 12:01:18"));

        // C_DATETIMEのテスト
        DateTimeOption dateTimeOption = new DateTimeOption();
        DateTime dateTime = new DateTime();
        dateTimeOption.setNull();
        testField(list, "getCDatetimeOption", DATA.NUMERIC_0, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.NUMERIC_1, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.NUMERIC_MINUS1, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.NUMERIC_MAX, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.NUMERIC_MIN, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.NUMERIC_DECIMAL, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.NUMERIC_OVER_MAX, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.NUMERIC_UNDER_MIN, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.NUMERIC_BIG_VALUE, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.STRING_0, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.STRING_1, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.STRING_MINUS1, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.STRING_MAX, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.STRING_MIN, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.STRING_DECIMAL, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.STRING_OVER_MAX, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.STRING_UNDER_MIN, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.STRING_BIG_VALUE, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.BLANK, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.NULL_STRING, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.BOOL_TRUE, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.BOOL_FALSE, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.NUMERIC_DATE, dateTimeOption);
        dateTime.setElapsedSeconds(DateUtil.getDayFromDate(2010, 1, 1) * 86400L);
        dateTimeOption.modify(dateTime);
        testField(list, "getCDatetimeOption", DATA.DATE_DATE_FMT1, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.DATE_DATE_FMT2, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.DATE_DATETIME_FIMT1, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.DATE_DATETIME_FIMT2, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.STRING_DATE, dateTimeOption);
        dateTimeOption.setNull();
        testField(list, "getCDatetimeOption", DATA.NUMERIC_DATETIME, dateTimeOption);
        dateTime.setElapsedSeconds(DateUtil.getDayFromDate(2010, 10, 1) * 86400L + DateUtil.getSecondFromTime(12, 1, 18));
        dateTimeOption.modify(dateTime);
        testField(list, "getCDatetimeOption", DATA.DATETIME_DATE_FMT1, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.DATETIME_DATE_FMT2, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.DATETIME_DATETIME_FIMT1, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.DATETIME_DATETIME_FIMT2, dateTimeOption);
        testField(list, "getCDatetimeOption", DATA.STRING_DATETIME, dateTimeOption);
View Full Code Here


     * @param cell 対象のセル
     * @return 対応する値
     */
    private DateTimeOption getDateTimeOption(HSSFCell cell) {
        Date date = getDate(cell);
        DateTimeOption op = new DateTimeOption();
        if (date == null) {
            op.setNull();
        } else {
            Calendar cal = Calendar.getInstance();
            cal.setTime(date);
            int y = cal.get(Calendar.YEAR);
            int m = cal.get(Calendar.MONTH);
            int d = cal.get(Calendar.DAY_OF_MONTH);
            int h = cal.get(Calendar.HOUR_OF_DAY);
            int min = cal.get(Calendar.MINUTE);
            int s = cal.get(Calendar.SECOND);
            int days = com.asakusafw.runtime.value.DateUtil.getDayFromDate(y, m + 1, d);
            int secs = com.asakusafw.runtime.value.DateUtil.getSecondFromTime(h, min, s);
            DateTime dt = new DateTime();
            dt.setElapsedSeconds((long) days * 86400 + secs);
            op.modify(dt);
        }
        return op;
    }
View Full Code Here

        testGetXXXOptionDo(excelUtils, sheet, DATA.ERROR, TYPES.DATE,  new CellTypeMismatchException("日付"));
        testGetXXXOptionDo(excelUtils, sheet, DATA.FORMULA, TYPES.DATE, new CellTypeMismatchException("日付"));

        // getDateTimeOptionのテスト

        DateTimeOption dateTimeOption = new DateTimeOption();
        DateTime dateTime = new DateTime();

        testGetXXXOptionDo(excelUtils, sheet, DATA.NUMERIC_0, TYPES.DATETIME, new CellTypeMismatchException("日付"));
        testGetXXXOptionDo(excelUtils, sheet, DATA.NUMERIC_1, TYPES.DATETIME, new CellTypeMismatchException("日付"));
        testGetXXXOptionDo(excelUtils, sheet, DATA.NUMERIC_MINUS1, TYPES.DATETIME, new CellTypeMismatchException("日付"));
        testGetXXXOptionDo(excelUtils, sheet, DATA.NUMERIC_DECIMAL, TYPES.DATETIME, new CellTypeMismatchException("日付"));
        testGetXXXOptionDo(excelUtils, sheet, DATA.NUMERIC_OVER_MAX, TYPES.DATETIME, new CellTypeMismatchException("日付"));
        testGetXXXOptionDo(excelUtils, sheet, DATA.NUMERIC_UNDER_MIN, TYPES.DATETIME, new CellTypeMismatchException("日付"));
        testGetXXXOptionDo(excelUtils, sheet, DATA.NUMERIC_BIG_VALUE, TYPES.DATETIME, new CellTypeMismatchException("日付"));
        testGetXXXOptionDo(excelUtils, sheet, DATA.STRING_0, TYPES.DATETIME, new CellTypeMismatchException("日付"));
        testGetXXXOptionDo(excelUtils, sheet, DATA.STRING_1, TYPES.DATETIME, new CellTypeMismatchException("日付"));
        testGetXXXOptionDo(excelUtils, sheet, DATA.STRING_MINUS1, TYPES.DATETIME, new CellTypeMismatchException("日付"));
        testGetXXXOptionDo(excelUtils, sheet, DATA.STRING_DECIMAL, TYPES.DATETIME, new CellTypeMismatchException("日付"));
        testGetXXXOptionDo(excelUtils, sheet, DATA.STRING_OVER_MAX, TYPES.DATETIME, new CellTypeMismatchException("日付"));
        testGetXXXOptionDo(excelUtils, sheet, DATA.STRING_UNDER_MIN, TYPES.DATETIME, new CellTypeMismatchException("日付"));
        testGetXXXOptionDo(excelUtils, sheet, DATA.STRING_BIG_VALUE, TYPES.DATETIME, new CellTypeMismatchException("日付"));
        dateTimeOption.setNull();
        testGetXXXOptionDo(excelUtils, sheet, DATA.BLANK, TYPES.DATETIME, dateTimeOption);
        testGetXXXOptionDo(excelUtils, sheet, DATA.NULL_STRING, TYPES.DATETIME, new CellTypeMismatchException("日付"));
        testGetXXXOptionDo(excelUtils, sheet, DATA.BOOL_TRUE, TYPES.DATETIME, new CellTypeMismatchException("日付"));
        testGetXXXOptionDo(excelUtils, sheet, DATA.BOOL_FALSE, TYPES.DATETIME, new CellTypeMismatchException("日付"));
        testGetXXXOptionDo(excelUtils, sheet, DATA.NUMERIC_DATE, TYPES.DATETIME, new CellTypeMismatchException("日付"));
        dateTime.setElapsedSeconds(DateUtil.getDayFromDate(2010, 1, 1) * 86400L);
        dateTimeOption.modify(dateTime);
        testGetXXXOptionDo(excelUtils, sheet, DATA.DATE_DATE_FMT1, TYPES.DATETIME, dateTimeOption);
        testGetXXXOptionDo(excelUtils, sheet, DATA.DATE_DATE_FMT2, TYPES.DATETIME, dateTimeOption);
        testGetXXXOptionDo(excelUtils, sheet, DATA.DATE_DATETIME_FIMT1, TYPES.DATETIME, dateTimeOption);
        testGetXXXOptionDo(excelUtils, sheet, DATA.DATE_DATETIME_FIMT2, TYPES.DATETIME, dateTimeOption);
        testGetXXXOptionDo(excelUtils, sheet, DATA.STRING_DATE, TYPES.DATETIME, dateTimeOption);
        testGetXXXOptionDo(excelUtils, sheet, DATA.NUMERIC_DATETIME, TYPES.DATETIME, new CellTypeMismatchException("日付"));
        dateTime.setElapsedSeconds(DateUtil.getDayFromDate(2010, 10, 1) * 86400L + DateUtil.getSecondFromTime(12, 1, 18));
        dateTimeOption.modify(dateTime);
        testGetXXXOptionDo(excelUtils, sheet, DATA.DATETIME_DATE_FMT1, TYPES.DATETIME, dateTimeOption);
        testGetXXXOptionDo(excelUtils, sheet, DATA.DATETIME_DATE_FMT2, TYPES.DATETIME, dateTimeOption);
        testGetXXXOptionDo(excelUtils, sheet, DATA.DATETIME_DATETIME_FIMT1, TYPES.DATETIME, dateTimeOption);
        testGetXXXOptionDo(excelUtils, sheet, DATA.DATETIME_DATETIME_FIMT2, TYPES.DATETIME, dateTimeOption);
        testGetXXXOptionDo(excelUtils, sheet, DATA.STRING_DATETIME, TYPES.DATETIME, dateTimeOption);
View Full Code Here

TOP

Related Classes of com.asakusafw.runtime.value.DateTimeOption

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.