calendarperioddaoimpl.java

一个关于tlms的一个小程序 看看能否帮助到别人

/**
 * Created by szmx
 * User: ozhang
 * Date: Apr 6, 2006
 * Time: 6:00:04 PM

 */
package com.szmx.tlms.finance.dao.impl;

import com.szmx.tlms.GlobalConstants;
import com.szmx.tlms.finance.dao.CalendarPeriodDAO;
import com.szmx.tlms.finance.model.CalendarPeriod;
import com.szmx.framework.base.dao.impl.BaseDaoImpl;
import com.szmx.framework.base.model.Pagination;
import com.szmx.framework.util.DateUtil;
import com.szmx.framework.util.StringUtil;
import org.apache.commons.collections.map.HashedMap;

import java.text.ParseException;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;


public class CalendarPeriodDAOImpl extends BaseDaoImpl implements CalendarPeriodDAO {
    /**
     * @param paginationObj
     * @param paraMap
     * @return Pagination
     */
    public Pagination getCalendarPeriods(final Pagination paginationObj, final Map paraMap) {
        CalendarPeriod calendarPeriodBean = (CalendarPeriod) paraMap.get("calendarPeriodBean");
        Map pMap = new HashMap();
        if (calendarPeriodBean != null) {
            pMap.put("company", calendarPeriodBean.getCompany());
            pMap.put("periodYear", calendarPeriodBean.getPeriodYear());
            pMap.put("periodNum", calendarPeriodBean.getPeriodNum());

            if (!StringUtil.isNull(calendarPeriodBean.getPeriodName())) {
                String periodName = calendarPeriodBean.getPeriodName();
                periodName = "%" + periodName.trim() + "%";
                pMap.put("periodName", periodName);
            }
            String startDateStr = (String) paraMap.get("startDate");
            String endDateStr = (String) paraMap.get("endDate");
            try {
                if (!StringUtil.isNull(startDateStr)) {
                    Date startDate = DateUtil.convertStringToDate(GlobalConstants.DATE_PATTERN, startDateStr.trim());
                    pMap.put("startDate", startDate);
                }
                if (!StringUtil.isNull(endDateStr)) {
                    Date endDate = DateUtil.convertStringToDate(GlobalConstants.DATE_PATTERN, endDateStr.trim());
                    pMap.put("endDate", endDate);
                }
            } catch (ParseException e) {
                if (logger.isDebugEnabled()) {
                    logger.debug(e);
                }
            }
        }
        return findPageByCombinedHsql("searchCalendarPeriodList", pMap, paginationObj);
    }

    public List getCalendarPeriods(final CalendarPeriod calendarPeriod) {
        if (calendarPeriod == null) {
            return null;
        }

        return findListByCombinedHsql("searchCalendarPeriod", this.generateQueryConditions(calendarPeriod));
    }

    private Map generateQueryConditions(final CalendarPeriod calendarPeriod) {
        Map map = new HashedMap();

        map.put("company", calendarPeriod.getCompany());
        if (!StringUtil.isNull(calendarPeriod.getPeriodName())) {
            map.put("periodName", "%" + calendarPeriod.getPeriodName() + "%");
        }
        map.put("periodYear", calendarPeriod.getPeriodYear());
        map.put("periodNum", calendarPeriod.getPeriodNum());
        map.put("startDate", calendarPeriod.getStartDate());
        map.put("endDate", calendarPeriod.getEndDate());

        return map;
    }
}