registerservice.java

电信的网厅的整站代码

package com.doone.fj1w.fjmgr.sysmgr;

import java.util.Map;

import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;

import com.doone.data.DataTable;
import com.doone.util.FileLogger;

public class RegisterService {
	
	/**
	 * <code></code>
	 * @param request
	 * @param response
	 * @param _map
	 * @return
	 */
	static public int getOrderMethodCount(ServletRequest request,
			ServletResponse response, Map _map) {
		return 1;
	}

	static public String getOrderMethod(ServletRequest request, ServletResponse response, Map _map) {
		try {
			
			boolean flag = false;
			String param_Statu = (String) _map.get("USERSTATE");
			String[] statu = new String[] { "A","N","L","D"};
			String[] statuName = new String[] {"激活","待激活", "过期","注销" };
			StringBuffer _sb = new StringBuffer();
			_sb.append("<table>");
			_sb.append("<tr>");
			_sb.append("<td style='cursor: default;'>");
			if (param_Statu == null || param_Statu.equals("0")) {
				// 显示所有
				for (int i = 0; i < statu.length; i++) {
					DataTable _dt = Register.getOrderMethod(_map, statu[i]);
					if (_dt == null)
						continue;
					try {
						int count = _dt.getRow(0).getInt("count");
						if (count == 0)
							continue;
						_sb.append("<a href='javascript:' onclick='fnStateClick(this)'");
						_sb.append(" name='ACTION' value='");
						_sb.append(statu[i]);
						_sb.append("' style='color: white;'>");
						_sb.append(statuName[i]);
						_sb.append("</a>(<font color='red'>");
						_sb.append(count);
						_sb.append("</font>) &nbsp;&nbsp;");
						if(statu[i].equals("L")){
							_sb.append("<input type='hidden' name='LOCKCOUNT' value='");
							_sb.append(count);
							_sb.append("'>");
						}
						flag = true;
					} catch (RuntimeException rux) {
						FileLogger.getLogger().warn(rux.getMessage(), rux);
					}
				}
			} else {
				DataTable _dt = Register.getOrderMethod(_map, param_Statu);

				if (_dt != null && _dt.getRows().getCount() > 0) {
					try {
						int count = _dt.getRow(0).getInt("count");
						if (count > 0) {
							int i = 0;
							for (; i < statu.length && !statu[i].equals(param_Statu); i++);

							_sb.append("<a href='javascript:' onclick='fnStateClick(this)'");
							_sb.append(" name='ACTION' value='");
							_sb.append(param_Statu);
							_sb.append("' style='color: white;'>");
							_sb.append(statuName[i]);
							_sb.append("</a>(<font color='red'>");
							_sb.append(count);
							_sb.append("</font>) &nbsp;&nbsp;");
							if(statu[i].equals("L")){
								_sb.append("<input type='hidden' name='LOCKCOUNT' value='");
								_sb.append(count);
								_sb.append("'>");
							}
							flag = true;
						}
					} catch (RuntimeException rux) {
						FileLogger.getLogger().warn(rux.getMessage(), rux);
					}
				}
			}

			if (!flag) {
				_sb.append("<font color='red'>没有符合以上条件的查询记录结果。</font>");
			}
			_sb.append("</td>");
			_sb.append("</tr>");
			_sb.append("</table>");

			return _sb.toString();
		} catch (Exception ex) {
			FileLogger.getLogger().warn(ex.getMessage(), ex);
		}
		return "";
	}

	/**
	 * <p>
	 * 获取查询内容表的所有行总数.
	 * </p>
	 * 
	 * @param request
	 * @param response
	 * @param _map
	 * @return
	 */
	static public int getOrderCount(ServletRequest request, ServletResponse response, Map _map) {
		try {
			if(_map == null )return 0;
			return Register.getOrderListCount(_map,(String)_map.get("ACTION"));
		} catch (Exception ex) {
			FileLogger.getLogger().warn(ex.getMessage(), ex);
		}
		return 0;
	}
	
	/**
	 * <p>
	 * 获取查询内容表的内容视图.
	 * </p>
	 * 
	 * @param request
	 * @param response
	 * @param _map
	 * @return
	 */
	static public String getOrderList(ServletRequest request, ServletResponse response, Map _map) {
		StringBuffer _sb = new StringBuffer();
		try {
			int pageSize = Integer.parseInt((String) _map.get("pageSize"));
			int currentPage = Integer.parseInt((String) _map.get("currentPage"));

			if (pageSize == -1 || currentPage == -1) {
				FileLogger.getLogger().info("页面参数为空。");
			} else {
				FileLogger.getLogger().info("pageSize:" + String.valueOf(pageSize));
				FileLogger.getLogger().info("currentPage:" + String.valueOf(currentPage));
			}
			int startrecord = currentPage * pageSize;
			DataTable _dt = Register.getOrderList(_map, startrecord, pageSize);
			_sb.append("<table>");
            //USERID,NAME,CITYCODE,CREATETIME,CARTNAME,CARTNO,EMAIL,USERSTATE,STATE
			if (_dt != null) {

				for (int i = 0; i < _dt.getRows().getCount(); i++) {
					
					String userId		= _dt.getRow(i).getString("USERID");
					String accountId   = _dt.getRow(i).getString("ACCOUNTID");
					String NAME     = _dt.getRow(i).getString("NAME");
					String CITYCODE = _dt.getRow(i).getString("CITYCODE");
					String AREACODE=_dt.getRow(i).getString("AREACODE");
					String creatime = _dt.getRow(i).getString("CREATETIME");
					if(creatime != null && creatime.length() > 16)
						creatime = creatime.substring(0,16);
					String EMAIL    = _dt.getRow(i).getString("EMAIL");
					String USERSTATE= _dt.getRow(i).getString("USERSTATE");
					USERSTATE       = getUSERSTATEName(USERSTATE);
					String STATE    = _dt.getRow(i).getString("STATE");
					STATE           = getSTATEName(STATE);
					_sb.append("<tr key='");
					_sb.append(userId);
					_sb.append("' type='2'>");
					_sb.append("<td class=\"body_td\" align=\"center\" nowrap>");
					_sb.append("<a href=\"javascript:\" onclick='window.setTimeout(\"fn_dblClick();\",10);'>");
					_sb.append(accountId);
					_sb.append("</a>");
					_sb.append("</td><td class=\"body_td\" align=\"left\" nowrap>");
					_sb.append(NAME);
					_sb.append("</td>");
					_sb.append("</td><td class=\"body_td\" align=\"left\" nowrap>");
					_sb.append(CITYCODE);
					_sb.append("</td>");
					_sb.append("<td class=\"body_td\" align=\"left\" nowrap>");
					_sb.append(creatime);
					_sb.append("</td>");
					_sb.append("<td class=\"body_td\" align=\"left\" nowrap>");
					_sb.append(EMAIL);
					_sb.append("</td>");
					_sb.append("<td class=\"body_td\" align=\"left\" nowrap>");
					_sb.append(USERSTATE);
					_sb.append("<font color=red>(");
					_sb.append(STATE);
					_sb.append(")</font>");
					_sb.append("</td><td style=\"display:none\">");
					_sb.append(AREACODE);
					_sb.append("</td></tr>");

				}
			}

			_sb.append("</table>");
		} catch (Exception rux) {
			FileLogger.getLogger().warn(rux.getMessage(), rux);
		}

		return _sb.toString();
	}
  
	/**
	 * <code>根据条件解锁过期账号</code>
	 * @param request
	 * @param response
	 * @param _map
	 */
	public static int selectOverDueAccount(ServletRequest request, ServletResponse response, Map _map){
		try{
			if(_map == null){
				FileLogger.getLogger().warn("selectOverDueAccount(ServletRequest,ServletResponse,Map)==>: Map == null");
				return 0;
			}
			
			DataTable dt = Register.selectOverDueAccount(_map);
			
			if (dt != null && dt.getRows().getCount() > 0) {
				String[] detail = new String[3];
				for (int i = dt.getRows().getCount(); --i >= 0;) {
					try {
						
						detail[0] = dt.getRow(i).getString("accountid");
						detail[1] = dt.getRow(i).getString("pwd");
						detail[2] = dt.getRow(i).getString("email");
						/*发送邮件*/
						SendMailOverDue.setDetail(detail[0],detail);
						
					} catch (RuntimeException ruxs) {ruxs.printStackTrace();}
				}
				
				/**激活线程发送邮件*/
				SendMailOverDue sendThread = new SendMailOverDue();
				sendThread.start();
				
				return Register.activeOverDueAccount(_map);
				
			}
		}catch(Exception ex){
			FileLogger.getLogger().warn(ex.getMessage(), ex);
		}
		return 0;
	} 
	
	private static String getUSERSTATEName(String value){
		
		if(value == null || value.equals(""))
		   return "待激活";
		if(value.equals("A"))
			return "激活";
		if(value.equals("N"))
			return "待激活";
		if(value.equals("L"))
			return "锁定";
		return "待激活";
		
	}
	
	private static String getSTATEName(String value){
		
		if(value == null || value.equals(""))
		    return "禁用";
		if(value.equals("E"))
			return "可用";
		return "禁用";
		
	}
	
	/**
	 * <code>添加新帐号</code>
	 * @param request
	 * @param response
	 * @param _map
	 */
	static public int addNewAccount(ServletRequest request, ServletResponse response, Map _map){
		try{			
			if(_map == null){
				FileLogger.getLogger().warn("addNewAccount(ServletRequest,ServletResponse,Map)==>: Map == null");
				return 0;
			}	
			
			DataTable dt = Register.selectExistAccount(_map);
			
			if (dt != null && dt.getRows().getCount() > 0) {
				return 11;
			}
			return Register.activeNewAccount(_map);				
			
		}catch(Exception ex){
			FileLogger.getLogger().warn(ex.getMessage(), ex);
		}
		return 0;
	} 
	/**
	 * <code>修改帐号</code>
	 * @param request
	 * @param response
	 * @param _map
	 */
	static public int updateAccount(ServletRequest request, ServletResponse response, Map _map){
		try{			
			if(_map == null){
				FileLogger.getLogger().warn("updateAccount(ServletRequest,ServletResponse,Map)==>: Map == null");
				return 0;
			}	
			return Register.activeUpdateAccount(_map);	
									
			
		}catch(Exception ex){
			FileLogger.getLogger().warn(ex.getMessage(), ex);
		}
		return 0;
	} 
	/**
	 * <code>取四川报税故障用户详细信息</code>
	 * @param request
	 * @param response
	 * @param _map
	 */	
	public static DataTable getAccInfo(ServletRequest request, ServletResponse response, Map _map)
	throws Exception {
		try {	
			if(_map == null){
				FileLogger.getLogger().warn("getAccInfo(ServletRequest,ServletResponse,Map)==>: Map == null");
				return null;
			}
			return Register.getAccInfo(_map);			
		} catch (Exception e) {
			throw e;
		}
	}
	
	/**
	 * <code>添加帐号类型</code>
	 * @param request
	 * @param response
	 * @param _map
	 */	
	public static int addCustType(ServletRequest request, ServletResponse response, Map _map)
	throws Exception {
		try {	
			if(_map == null){
				FileLogger.getLogger().warn("addCustType(ServletRequest,ServletResponse,Map)==>: Map == null");
				return 0;
			}
			//查看此帐号类型是否存在，1-存在，0-不存在
			if(Register.selectExistCustType(_map)==0)
				return Register.addCustType(_map);			
		} catch (Exception e) {
			throw e;
		}
		return 11;
	}
}