abstractterminalmessagequerier.java

oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码

/*
 * TerminalMessageDetailQuerier.java
 *
 * Created on 2007年3月1日, 下午2:26
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package com.huashi.util;

import java.sql.SQLException;
import java.util.Date;

/**
 *
 * @author dell
 */
public abstract class AbstractTerminalMessageQuerier extends AbstractQuerier {
    
    Date dateFrom = null;
    Date dateTo = null;
    String tmnlId = "";   
    String ioCon = "";
    String viaCon = "";
    
    /** Creates a new instance of TerminalMessageDetailQuerier */
    public AbstractTerminalMessageQuerier() {
    }

    protected void processDates() {
        Object obj = getParameter("dateFrom");
        
        if (obj instanceof Date) {
            dateFrom = (Date) obj;
        } else {
            dateFrom = DateUtil.parse(DateUtil.format(new Date(), "yyyyMMdd"), "yyyyMMdd");
        }
        
        obj = getParameter("dateTo");
        
        if (obj instanceof Date) {
            dateTo = (Date) obj;
        } else {
            dateTo = new Date(dateFrom.getTime() + 24 * 3600 * 1000);
        }
        
        setParameter("dateFrom", dateFrom);
        setParameter("dateTo", dateTo);
    }
    
    protected void processTmnlId() {
        Object obj = getParameter("tmnlId");
        
        if (obj != null) {
            tmnlId = obj.toString();
        } else {
            tmnlId = "";
        }
    }
    
    protected void processViaCon() {
        boolean viaGw = false;
        boolean viaMss = false;
        boolean viaGprs = false;
        
        Object obj = getParameter("viaGw");
        
        if (obj instanceof Boolean) {
            viaGw = (Boolean) obj;
        }
        
        obj = getParameter("viaMss");
        
        if (obj instanceof Boolean) {
            viaMss = (Boolean) obj;
        }
        
        obj = getParameter("viaGprs");
        
        if (obj instanceof Boolean) {
            viaGprs = (Boolean) obj;
        }
        
        viaCon = "";
        
        if (viaGw) {
            viaCon = "t.via='gw'";
        }
        
        if (viaMss) {
            viaCon += (viaCon.equals("") ? "" : " OR ") + "t.via='mss'";
        }
        
        if (viaGprs) {
            viaCon += (viaCon.equals("") ? "" : " OR ") + "t.via='gprs'";
        }
        
        if (!viaCon.equals("")) {
            viaCon = " AND (" + viaCon + ")";
        }
        
    }
    
    protected void processIoCon() {
        boolean fromTmnl = false;
        boolean toTmnl = false;
        
        Object obj = getParameter("fromTmnl");
        
        if (obj instanceof Boolean) {
            fromTmnl = (Boolean) obj;
        }
        
        obj = getParameter("toTmnl");
        
        if (obj instanceof Boolean) {
            toTmnl = (Boolean) obj;
        }
        
        ioCon = "";
        
        if (fromTmnl) {
            ioCon = "t.io='来自车机'";
        }
        
        if (toTmnl) {
            ioCon += (ioCon.equals("") ? "" : " OR ") + "t.io='发往车机'";
        }
        
        if (!ioCon.equals("")) {
            ioCon = " AND (" + ioCon + ")";
        }
    }
    
    public void processParameters() {
        
        processDates();
        processTmnlId();
        processIoCon();
        processViaCon();
        
    }


    
}