clientservice.java

电信的网厅的整站代码

package com.doone.fj1w.fjmgr.faq;

import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;

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

import com.doone.data.DacClient;
import com.doone.data.DataRow;
import com.doone.data.DataTable;
import com.doone.fj1w.common.ConfigBean;
import com.doone.fj1w.fj1w.faq.Tf_Faq;
import com.doone.util.ExtString;
import com.doone.util.FileLogger;
import com.doone.uurm.StateEnum;

public class ClientService {
	/**
	 * <p>
	 * 获取查询内容表的内容视图.
	 * </p>
	 * 
	 * @param request
	 * @param response
	 * @param _map
	 * @return
	 */
	public static String getFaqList(ServletRequest request,
			ServletResponse response, Map param) {
		StringBuffer ret = new StringBuffer();
		try {
			int pageSize = Integer.parseInt((String) param.get("pageSize"));
			int currentPage = Integer.parseInt((String) param
					.get("currentPage"));
			// long faqCoteId = Long.parseLong((String) param.get("faqCoteId"));
			// String cityCode = (String) param.get("CITY");

			FileLogger log = new FileLogger();
			if (pageSize == -1 || currentPage == -1) {
				log.info("页面参数为空。");
			} else {
				log.info("pageSize:" + String.valueOf(pageSize));
				log.info("currentPage:" + String.valueOf(currentPage));
			}

			DataTable dt = Tf_Faq.getFaqList(param, currentPage * pageSize,
					pageSize);

			ret.append("<table>");
			if (dt != null) {
				for (int i = 0; i < dt.getRows().getCount(); i++) {
					DataRow dr = dt.getRow(i);
					Tf_Faq faq = new Tf_Faq(dr);

					ret.append("<tr key='" + faq.getFaqId() + "'>");
					ret.append("<td class='body_td' align='left' width='35%'>");
					// ret.append("<a href='content.jsp?faqid=");
					// ret.append(faq.getFaqId());
					// ret.append("' target='FAQ'>");
					ret
							.append("<a href='#' onclick='window.setTimeout(\"fnToolReplyContent();\",30);'>");
					ret.append(faq.getTitle());
					ret.append("</a></td>");

					ret.append("<td class='body_td' align='left' width='8%'>");
					ret.append(dr.getString("cityname"));
					ret.append("</td>");

					SimpleDateFormat sdf = new SimpleDateFormat(
							"yyyy-MM-dd HH:mm");

					ret.append("<td class='body_td' align='left' width='15%'>");
					ret.append(sdf.format(faq.getCreateTime()));
					ret.append("</td>");

					ret.append("<td class='body_td' align='left' width='10%'>");
					ret.append(dr.getString("nickname"));
					ret.append("</td>");

					ret.append("<td class='body_td' align='left' width='7%'>");
					ret.append((faq.getSubCount() == 0 ? "未回复" : "已回复"));
					ret.append("</td>");

					ret.append("<td class='body_td' align='left' width='25%'>");
					if (faq.getSubCount() != 0) {
						ret.append(sdf.format(faq.getLastDate()));
						ret.append("&nbsp;|&nbsp;");
						ret.append(faq.getLastNickName());
					} else {
						ret.append("&nbsp;");
					}
					ret.append("</td>");

					ret.append("</tr>");
				}
			}
			ret.append("</table>");

		} catch (Exception ex) {
			FileLogger.getLogger().warn(ex.getMessage(), ex);

			throw new RuntimeException(ex);
		}

		return ret.toString();
	}

	/**
	 * <p>
	 * 分类方式的行.
	 * </p>
	 * 
	 * @param request
	 * @param response
	 * @param _map
	 * @return
	 */
	public static int getFaqMethodCount(ServletRequest request,
			ServletResponse response, Map _map) {
		return 1;
	}

	/**
	 * <p>
	 * 数据查询的分类方式，对每个分类的统计.
	 * </p>
	 * 
	 * @param request
	 * @param response
	 * @param _map
	 * @return
	 */
	public static String getFaqMethod(ServletRequest request,
			ServletResponse response, Map _map) {
		try {
			/**
			 * 状态 statu: 1: 未回复 2: 已回复
			 */
			boolean flag = false;
			String param_Statu = (String) _map.get("STATE");
			String[] statu = new String[] { "1", "2" };
			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 = Tf_Faq.getFaqMethod(_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;");
						flag = true;

					} catch (RuntimeException rux) {
						FileLogger.getLogger().warn(rux.getMessage(), rux);
					}
				}
			} else {
				DataTable _dt = Tf_Faq.getFaqMethod(_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;");
							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
	 */
	public static int getFaqCount(ServletRequest request,
			ServletResponse response, Map param) {
		try {
			if (param == null)
				return 0;
			return Tf_Faq.getCount(param, (String) param.get("ACTION"));

			// ACTION
		} catch (Exception ex) {
			FileLogger.getLogger().warn(ex.getMessage(), ex);
		}
		return 0;
	}

	/**
	 * 汇总方式的行.
	 * 
	 * @param request
	 * @param response
	 * @param param
	 * @return
	 */

	public static int getFaqCount_Total(ServletRequest request,
			ServletResponse response, Map param) {
		return 1;
	}

	/**
	 * 业务咨询详细信息。
	 * 
	 * @param request
	 * @param response
	 * @param _map
	 * @return
	 */
	public static String getFaqList_Total(ServletRequest request,
			ServletResponse response, Map _map) {
		try {
			/**
			 * 状态 statu: 0: 已回复 1: 未回复 2: 全部
			 */
			boolean flag = false;

			String[] statu = new String[] { "0", "1", "2" };
			String[] statuName = new String[] { "已回复", "未回复", "全部" };

			StringBuffer _sb = new StringBuffer();
			_sb.append("<table>");
			_sb.append("<tr>");
			_sb.append("<td style='color: white;cursor: default;'>");

			for (int i = 0; i < statu.length; i++) {
				DataTable _dt = getFaqListByCond(_map, statu[i]);