itemgrouputil.java

EasyJF信息发布全部源代码！

package com.easyjf.item.business;

import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

import com.easyjf.bbs.business.UserInfo;
import com.easyjf.dbo.DBObject;
import com.easyjf.dbo.EasyJDB;
import com.easyjf.web.tools.DbPageList;
import com.easyjf.web.tools.IPageList;

public class ItemGroupUtil {	
	private static final SimpleDateFormat df=new SimpleDateFormat("yyyy-MM-dd");
	public static IPageList queryEasyJFMember(String orderBy,int pageSize,int pageNo)	
	{		
		DbPageList pList=new DbPageList(UserInfo.class,"types='member' or types='admin' or types='manager'"+(orderBy!=null && (!orderBy.equals(""))?" order by "+orderBy:""),null);	
		pList.doList(pageNo,pageSize);
		return pList;
		}
	public static IPageList queryEasyJFAdmin(String orderBy,int pageSize,int pageNo)	
	{		
		DbPageList pList=new DbPageList(UserInfo.class,"types='admin' or types='manager'"+(orderBy!=null && (!orderBy.equals(""))?" order by "+orderBy:""),null);	
		pList.doList(pageNo,pageSize);
		return pList;
		}
	public static List getTopScore(int topNum,Date date1,Date date2)	
	  {	
		List list=null;
		if(date1!=null && (date2!=null))
		{
			EasyJDB db=EasyJDB.getInstance();
			list=db.query(DBObject.class,"select distinct userName,sum(myScore+otherScore) as score from BBSTermScore where beginTime>='"+df.format(date1)+"' and beginTime<'"+df.format(date2)+"' group by userName order by score desc");
			if(list!=null && list.size()>topNum)
			{
				list=list.subList(0,topNum-1);
			}
		}
		else
		{
		DbPageList pList=new DbPageList(UserInfo.class,"score>=0 order by score desc",null);	
		pList.doList(1,topNum);		
		if(pList!=null)list=pList.getResult();
		}
		return list;
	  }
	
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub

	}

}