appealvpdndao.java

电信的网厅的整站代码

package com.doone.fj1w.fjmgr.appealvpdn;

import java.util.LinkedList;
import java.util.Map;

import com.doone.data.DacClient;
import com.doone.data.DataTable;
import com.doone.fj1w.common.DAOHelper;
import com.doone.util.ExtString;
import com.doone.util.FileLogger;

public class AppealvpdnDAO {

	/**
	 * @author qiuzb
	 * @version 2007-03-07
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public static int getConditionResult(Map map) throws Exception{
		try {
			StringBuffer sql = new StringBuffer();
			sql.append("select count(s.STATE) as count from tf_appealvpdn s ");
			sql.append("where s.STATE = ?");
			LinkedList linkList = new LinkedList();
			linkList.add((String)map.get("STATE"));
			
			sql.append(parseCondition(map,linkList));

			DacClient client = new DacClient();
			DataTable dataTable = client.executeQuery(sql.toString(),linkList.toArray());
			return dataTable.getRow(0).getInt("count");
		} catch (Exception ex) {
			throw ex;
		}
	}
	
	/**
	 * 
	 * @param map
	 * @param startrecord
	 * @param recordnum
	 * @return
	 * @throws Exception
	 */
	public static DataTable getContextResult(Map map, int startrecord,int recordnum)throws Exception{
		try {
			int endrecord = recordnum;
			if (startrecord < 0) {startrecord = 0;}
			if (endrecord > 0 && startrecord > 0) {
				endrecord = startrecord + recordnum;
			}
			
			StringBuffer sql = new StringBuffer();
			sql.append("select s.VPDNID,s.WEBORDER,s.USERID,s.LINKMAN,s.CITYCODE,");
			sql.append("decode(s.ORDERTYPE,'1','拟写障碍单','2','障碍催促单','3','信息回馈单' ) as ORDERTYPE,");
			sql.append("s.CREATETIME,decode(s.STATE,'1','待处理','2','转派','3','挂起','8','作废','9','完成') as state ");
			sql.append("from tf_appealvpdn s ");
			sql.append("where s.STATE = ?");
			LinkedList linkList = new LinkedList();
			linkList.add((String)map.get("STATE"));
			
			sql.append(parseCondition(map,linkList));
			
			return DAOHelper.executePageList(startrecord, endrecord, 
					                         sql.toString(),linkList.toArray());
		} catch (Exception ex) {
			throw ex;
		}
	}
	
	
	/**
	 * 解释条件入参.
	 * @param map
	 * @param linkList
	 * LINKMAN,STATE,CITYCODE,VPDNTYPEID,CREATETIME,,FINISHTIME,USERID,STORENAME
	 * @return
	 */
	public static String parseCondition(Map map,LinkedList linkList) {
		try {
			StringBuffer buffer = new StringBuffer();
			
			if(!ExtString.turnStr((String)map.get("LINKMAN")).equals("")) {
				buffer.append(" and s.LINKMAN = ? ");
				linkList.add((String)map.get("LINKMAN"));
			}
			if(!ExtString.turnStr((String)map.get("WEBORDER")).equals("")) {
				buffer.append(" and s.WEBORDER = ?");
				linkList.add((String)map.get("WEBORDER"));
			}
			if(!ExtString.turnStr((String)map.get("CITY")).equals("")) {
				buffer.append(" and s.CITYCODE = ?");
				linkList.add((String)map.get("CITY"));
			}
			if(!ExtString.turnStr((String)map.get("ORDERTYPE")).equals("")) {
				buffer.append(" and s.ORDERTYPE = ?");
				linkList.add((String)map.get("ORDERTYPE"));
			}
			if(!ExtString.turnStr((String)map.get("VPDNTYPEID")).equals("")) {
				buffer.append(" and s.VPDNTYPEID = ?");
				linkList.add((String)map.get("VPDNTYPEID"));
			}
			if(!ExtString.turnStr((String)map.get("CREATETIME")).equals("")) {
				buffer.append(" and s.CREATETIME >= to_date(?,'YYYY-MM-DD HH24:MI:SS')");
				linkList.add((String)map.get("CREATETIME"));
			}
			if(!ExtString.turnStr((String)map.get("FINISHTIME")).equals("")) {
				buffer.append(" and s.INTIME <= to_date(?,'YYYY-MM-DD HH24:MI:SS')");
				linkList.add((String)map.get("FINISHTIME"));
			}
			if(!ExtString.turnStr((String)map.get("USERID")).equals("")) {
				buffer.append(" and s.USERID like ?");
				linkList.add((String)map.get("USERID")+"%");
			}
			if(!ExtString.turnStr((String)map.get("SORT")).equals("")) {
				buffer.append(" order by s.CREATETIME ");
				buffer.append((String)map.get("SORT"));
			}
			return buffer.toString();
		} catch (Exception ex) {
			FileLogger.getLogger().warn(ex.getMessage(),ex);
		}
		return "";
	}

	
}