+ toBeSql
								+ "'"
								+ DateTimeTool
										.getTomorrowDate("yyyy-MM-dd", to)
								+ "'" + " order by at.finalTime",
						new Object[] { flag, user.getId() });

	}

	/**
	 * @author 陸文邦;
	 * @function 搜索全部任務活動;
	 * @param whereSql
	 *            根據whereSql搜索記錄;
	 * @param type
	 *            根據類型任務活動;
	 * @param to區分重寫方法;
	 * @return 返回本月的任務活動;
	 */
	public List getAllTasksByFuture(Integer flag, User user, String toBeSql,
			Integer to, String type) throws DataAccessException {

		return this
				.getHibernateTemplate()
				.find(
						"from ActivityTask at where at.executeState<>3 and at.flag=? and at.assignerId=? order by at.finalTime"
								+ toBeSql, new Object[] { flag, user.getId() });

	}

	/**
	 * @author 陸文邦;
	 * @function 根據聯系人更新任務;
	 * @param modifyManId;
	 * @param modifyTime;
	 * @param contactId;
	 * @param flag;
	 */
	public void updateTasksByContactId(int modifyManId, String modifyTime,
			int contactId, int flag) throws DataAccessException {

		this
				.getHibernateTemplate()
				.bulkUpdate(
						"update ActivityTask as at set at.flag=?, at.modifyManId=?, at.lastModifyTime=? where at.customerContact.id=? ",
						new Object[] { flag, modifyManId, modifyTime, contactId });

	}

	/**
	 * @author 陸文邦;
	 * @function 更新任務根據ID;
	 * @param modifyManId;
	 * @param modifyTime;
	 * @param contactId;
	 * @param flag;
	 */
	public void updateTaskById(int modifyManId, String modifyTime, int taskId,
			int flag) throws DataAccessException {

		this
				.getHibernateTemplate()
				.bulkUpdate(
						"update ActivityTask as at set at.flag=?, at.modifyManId=?, at.lastModifyTime=? where at.id=? ",
						new Object[] { flag, modifyManId, modifyTime, taskId });

	}

	/**
	 * @author 陸文邦;
	 * @function 查找所有被刪除的任務;
	 * @param modifyManId;
	 * @param modifyTime;
	 * @param contactId;
	 * @param flag;
	 */
	public List getTasksByDelete(User user, int flag)
			throws DataAccessException {

		return getHibernateTemplate()
				.find(
						"from ActivityTask as at where at.assignerId=? and at.flag=? order by at.lastModifyTime desc",
						new Object[] { user.getId(), flag });

	}

	/**
	 * @author 陸文邦;
	 * @function 根據subject模糊查找任務;
	 * @param modifyManId;
	 * @param modifyTime;
	 * @param contactId;
	 * @param flag;
	 */
	public List getTasksBySubjectLike(User user, int flag, String subject)
			throws DataAccessException {

		return getHibernateTemplate()
				.find(
						"from ActivityTask as at where at.assignerId=? and at.flag=? and at.subject like '%"
								+ subject
								+ "%' order by at.lastModifyTime desc",
						new Object[] { user.getId(), flag });

	}

	/**
	 * 函數功能 獲取當前時間是否有任務要提醒; 參數說明@param flag 可用狀態
	 * 
	 * @param user
	 *            用戶
	 * @param dateStr
	 *            日期
	 * @param wakeUpTime
	 *            提醒時間 創建時間:2009-1-17; 程序作者:陸文邦;
	 * @return
	 * @throws ApplicationException
	 */
	public List getTasksByNow(int flag, User user, String dateStr,
			String wakeUpTime) throws ApplicationException {
		return this
				.getHibernateTemplate()
				.find(
						"from ActivityTask at where at.assignerId=? and at.flag=? and at.wakeUpDate=? and at.wakeUpTime=?",
						new Object[] { user.getId(), flag, dateStr, wakeUpTime });
	}

	/**
	 * 程序作者:陸文邦; 創建時間:2009-01-19; 函數功能:獲取需要提醒的數據; 參數說明:@param user 根據該用戶相關的數據
	 * 
	 * @param flag
	 *            可用狀態的數據;
	 * @return list 數據列表;
	 * @throws DataAccessException
	 */
	public List getAllTaskByAlert(User user, int flag)
			throws DataAccessException {
		return this
				.getHibernateTemplate()
				.find(
						"from ActivityTask at where at.assignerId=? and at.flag=? and at.wakeUpTime is not null and at.wakeUpDate is not null order by at.wakeUpDate desc,at.wakeUpTime desc",
						new Object[] { user.getId(), flag });
	}

	/**
	 * 程序作者:陸文邦; 創建時間:2009-02-03; 函數功能:搜索提醒數據;
	 * 
	 * @param id
	 * @return
	 * @throws DataAccessException
	 */
	public List getActivityById(Integer id) throws DataAccessException {
		return this.getHibernateTemplate().find(
				"from ActivityTask at where at.id=" + id);
	}

	/**
	 * 根據指定的對象(ActivityTask)刪除它 param：at 指ActivityTask對象 author：張明強 time:
	 * 2009-02-14
	 * 
	 * @throws DataAccessException
	 */
	public void deleteByObject(ActivityTask at) throws DataAccessException {
		this.getHibernateTemplate().delete(at);
		logger.debug("任務刪除成功！");
	}

	/**
	 * @author LuWenBang
	 * @date 2009_02_17
	 * @param user
	 * @param type
	 * @return
	 * @throws ApplicationException
	 */
	public List getOptionsByUserAndType(User user, int type)
			throws DataAccessException {
		return getHibernateTemplate().find(
				"from UserDefined as ud where ud.user=? and ud.type=?",
				new Object[] { user, type });
	}

	/**
	 * @author LuWenBang
	 * @date 2009_02_18
	 */
	public void saveUserDefined(UserDefined userDefined)
			throws DataAccessException {
		this.getHibernateTemplate().save(userDefined);
	}

	/**
	 * @author LuWenBang
	 * @date 2009_02_18
	 */
	public void saveUserFilter(UserFilter userFilter)
			throws DataAccessException {
		this.getHibernateTemplate().save(userFilter);

	}

	/**
	 * @author LuWenBang
	 * @date 2009_02_18
	 */
	public void saveUserField(UserField userField) throws DataAccessException {
		this.getHibernateTemplate().save(userField);
	}

	/**
	 * @author LuWenBang
	 * @date 2009_02_19
	 * @param usersId
	 * @param flag
	 */
	public List getTaskEvents(final String usersId,final int flag)
			throws DataAccessException {
		return this.getHibernateTemplate().executeFind(new HibernateCallback() {

			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				Query query = session
						.createSQLQuery("select id,(id*0)+1 as tid,subject, functionId,recordId,contact,userAuId as uid,record_name from activity_task a where a.flag="+flag+" and userAuId in ("+usersId+") union all select id,id*0 as tid,subject,functionId,recordId,contact_Id as contact,userId as uid,recordName from event e where e.flag="+flag+" and userId in ("+usersId+")");
				List list = query.list();
				return list;
			}

		});
	}

	/**
	 * @author Administrator
	 * @date 2009_02_20
	 * @function 根據id獲取用戶自定義搜索條件;
	 * @param optionId
	 * @return
	 * @throws DataAccessException
	 */
	public UserDefined getUserDefinedById(int optionId)
			throws DataAccessException {
		return (UserDefined) getHibernateTemplate().get(UserDefined.class,optionId);
	}

	/**
	 * @author LuWenBang
	 * @date 2009_02_20
	 * @function 根據UserDefined搜索過濾符號;
	 * @param userDefined
	 * @return
	 * @throws DataAccessException
	 */
	public List getUserFilterByOption(UserDefined userDefined)
			throws DataAccessException {
		return getHibernateTemplate().find(
				"from UserFilter as uf where uf.userDefined=?", userDefined);
	}

	/**
	 * @author LuWenBang
	 * @date 2009_02_20;
	 * @function 根據UserDefined搜索UserField
	 * @param userDefined
	 * @return
	 * @throws DataAccessException
	 */
	public List getUserFieldByOption(UserDefined userDefined)
			throws DataAccessException {
		return getHibernateTemplate().find(
				"from UserField as uf where uf.userDefined=?", userDefined);
	}
	/**
	 * @author LuWenBang
	 * @date 2009-02-24
	 * @function 修改用戶自定義選項;
	 * @param userDefined
	 * @throws DataAccessException
	 */
	public void updateUserDefined(UserDefined userDefined)
			throws DataAccessException {
		this.getHibernateTemplate().saveOrUpdate(userDefined);
		
	}

	/**
	 * @author LuWenBang
	 * @DATE 2009_02_24
	 * @FUNCTION 獲取用戶視圖過濾字段
	 * @param id
	 * @return
	 * @throws DataAccessException
	 */
	public UserFilter getUserFilter(int id) throws DataAccessException {
		return (UserFilter) getHibernateTemplate().get(UserFilter.class, id);
	}

	/**
	 * @author LuWenBang
	 * @date 2009_02_24
	 * @function 刪除過濾條件
	 * @param userFilter
	 * @throws DataAccessException
	 */
	public void deleteFilter(UserFilter userFilter) throws DataAccessException {
		this.getHibernateTemplate().delete(userFilter);
	}
	/**
	 * @author LuWenBang
	 * @date 2009_02_24;
	 * @function 更新過濾字段;
	 * @param userFilter
	 * @throws DataAccessException
	 */
	public void updateUserFilter(UserFilter userFilter)
			throws DataAccessException {
		this.getHibernateTemplate().saveOrUpdate(userFilter);
	}

	/**
	 * @author LuWenBang
	 * @date 2009_02_24;
	 * @function 修改顯示字段;
	 * @param userField
	 * @throws DataAccessException
	 */
	public void updateUserField(UserField userField) throws DataAccessException {
		this.getHibernateTemplate().saveOrUpdate(userField);
	}
}