The sample of calendar

最新推荐文章于 2024-08-28 13:16:06 发布

最新推荐文章于 2024-08-28 13:16:06 发布 · 145 阅读

文章标签：

#SQL

Java 专栏收录该内容

11 篇文章

订阅专栏

本文介绍了一个用于查询工作日志的公共列表方法的实现细节。该方法可以根据不同的时间类型（如周、月、年或天）及用户ID来检索对应的工作日志记录，并支持模糊搜索。通过调整日期范围参数，系统能返回指定时间段内的所有相关日志。

public List getWorkDailyLogList(String type, Date date,String userId,String queryInfo)
    {
        StringBuffer sql = new StringBuffer("select guid, title as 标题,convert(char(10),createddate,20) as 日期");
        sql.append(getAppRelationCore().getPersonManagementFacade().getColumnStatement("Hr_dailylog")).append(" from Hr_dailyLog where convert(char(10),createddate,20) between ? and ? and creator = ? and title like '%'+?+'%'");
        String params[] = new String[4];
        GregorianCalendar calendar = new GregorianCalendar();
        calendar.setTime(date);
        if(type.equals("week"))
        {
            calendar.set(GregorianCalendar.DAY_OF_WEEK,1);
            params[0] = PortalUtil.convertDateToString(PortalUtil.SQL_DATE_PATTERN, calendar.getTime());
            calendar.set(GregorianCalendar.DAY_OF_WEEK,7);
            params[1] = PortalUtil.convertDateToString(PortalUtil.SQL_DATE_PATTERN, calendar.getTime());
        }
        if(type.equals("month"))
        {
            calendar.set(GregorianCalendar.DAY_OF_MONTH,1);
            params[0] = PortalUtil.convertDateToString(PortalUtil.SQL_DATE_PATTERN, calendar.getTime());
            calendar.set(GregorianCalendar.DAY_OF_MONTH,calendar.getActualMaximum(GregorianCalendar.DAY_OF_MONTH));
            params[1] = PortalUtil.convertDateToString(PortalUtil.SQL_DATE_PATTERN, calendar.getTime());
        }
        if(type.equals("year"))
        {
            calendar.set(GregorianCalendar.DAY_OF_YEAR,1);
            params[0] = PortalUtil.convertDateToString(PortalUtil.SQL_DATE_PATTERN, calendar.getTime());
            calendar.set(GregorianCalendar.DAY_OF_YEAR,calendar.getActualMaximum(GregorianCalendar.DAY_OF_YEAR));
            params[1] = PortalUtil.convertDateToString(PortalUtil.SQL_DATE_PATTERN, calendar.getTime());
        }
        if(type.equals("day"))
        {
            params[0] = PortalUtil.convertDateToString(PortalUtil.SQL_DATE_PATTERN, calendar.getTime());
            params[1] = PortalUtil.convertDateToString(PortalUtil.SQL_DATE_PATTERN, calendar.getTime());
        }
        params[2] = userId;
        params[3] = queryInfo;
        return this.getCommonDAO().findBySQL(sql.toString(),params).getRows(); //To change body of implemented methods use File | Settings | File Templates.
    }