📄 clientservice.java
字号:
ret.append("<table>");
// StringBuffer sAttchment = new StringBuffer();
// StringBuffer sFILE=new StringBuffer();
for(int j=0;j<contentList.getRows().getCount();j++) {
String sTITLE=contentList.getRow(j).getString("TITLE");
String sLINKID=contentList.getRow(j).getString("CONTENT");
String sCONTENTID=contentList.getRow(j).getString("CONTENT_ID");
String sCONTENTTYPE=contentList.getRow(j).getString("CONTENTTYPE");
String url="sort.jsp?PARENT_ID="+sParentId+"&TEXTORIMAGE="+sTextOrImage+"&MENUCODE="+sMenuCode+"&LINKTYPE="+sLinkType+"&CONTENTID="+sCONTENTID;
boolean bIsint=contentBean.is_int(sLINKID);
String sLINK="";
if (bIsint){
if (sTextOrImage!=null&&sTextOrImage.equals("1")){
sLINK=contentBean.getBoardName(sLINKID);}
else{
if (sCONTENTTYPE!=null&&sCONTENTTYPE.equals("3")){//取业务介绍ID的NAME
sLINK=contentBean.getPurviewName(sLINKID);}
else {
sLINK=contentBean.getContentName(sLINKID);}
}
}//取最新动态+优惠资讯的NAME
else{
sLINK=sLINKID;
}
ret.append("<tr key='" + contentList.getRow(j).getString("CONTENT_ID") + "'><td class='body_td' width='42%' ><a href='javascript:' onclick='edit(\""+sTITLE+"\",\""+sLINK+"\",\""+sCONTENTID+"\",\""+sLINKID+"\",\"2\");'>"+sTITLE+"</a></td>");
ret.append("<td class='body_td' width='43%'>"+sLINK+"</td><td align='center' class='body_td' width='15%'><a href="+url+">↑</a></td></tr>");
}
ret.append("</table>");}
}
catch (Exception ex) {
FileLogger.getLogger().warn(ex.getMessage(), ex);
throw new RuntimeException(ex);
}
return ret.toString();
}
public static int getPlaCardCount(ServletRequest request, ServletResponse response, Map param) {
String sBoardId = (String) param.get("sBoardId");
UpImageBean contentBean = new UpImageBean();
int iCount = 0;
try {
iCount =contentBean.getTextContentCount(sBoardId);
} catch (Exception ex) {
FileLogger.getLogger().error("获取公告记录数时发生异常：", ex);
throw new RuntimeException(ex);
}
return iCount;
}
public static int getNewContentCount(ServletRequest request, ServletResponse response, Map param) {
// int count_new =0,count_pro =0;
int count=0;
String sType = (String) param.get("sType");
String cityCode = (String) param.get("cityCode");
String newsCode="";
if (sType.equals("1"))
{newsCode = "BBS004";//最新动态
}
if (sType.equals("2"))
{newsCode = "BBS006";//优惠资讯
}
String code = newsCode + String.valueOf(Long.parseLong(cityCode));
long newsID = Sys_Purview.getPurviewIdByCode(code);
try {
String snews="";
if (newsID!=0) {
snews=String.valueOf(newsID);
count =BBSFactory.getRecordCountByBoardId(snews);}
} catch (Exception ex) {
FileLogger.getLogger().error("获取新闻记录数时发生异常：", ex);
throw new RuntimeException(ex);
}
return count;
}
public static String getContentList(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"));
FileLogger log = new FileLogger();
if (pageSize == -1 || currentPage == -1) {
log.info("页面参数为空。");
}
else {
log.info("pageSize:" + String.valueOf(pageSize));
log.info("currentPage:" + String.valueOf(currentPage));
}
WebAuth auth = WebAuth.getInstance((HttpServletRequest) request);
// DataTable dt = BBSFactory.getInstance(request).getContentByBoardId(lBoardId, null, currentPage,pageSize);
DataTable dt = ClientDAO.getContextResult(param,auth, currentPage,pageSize);
// ret.append(" <form id='Form1' name='Form1' method='post' action='manager_submit.jsp'>");
ret.append("<table>");
if (dt != null) {
for (int i = 0; i < dt.getRows().getCount(); i++) {
DataRow dr = dt.getRow(i);
String sIcon=dr.getString("Mood_Icon");
String sSrc="";
if ((sIcon!=null)&&(sIcon.length()!=0)&&(sIcon.indexOf("/")==-1)) {
sSrc="images/face/"+sIcon;
}
if ((sIcon!=null)&&(sIcon.length()!=0)&&(sIcon.indexOf("/")!=-1)) {
sSrc=sIcon;
}//判断是心情图标还是扩展图标
ret.append("<tr key='" + dr.getString("content_id") + "'>");
// 小图标列
ret.append("<TD class='body_td' align='left' width='5%'>");
ret.append("<img id='lblState' src='");
ret.append(getStatusImage(dr.getInt("tip_order"), dr.getChar("extract_sign"), dr
.getInt("click_count"), dr.getInt("reply_count"), dr
.getChar("delete_sign"), dr.getString("contenttype")));
ret.append("' title='");
ret.append(getStatusImageInfo(dr.getInt("tip_order"), dr.getChar("extract_sign"), dr
.getInt("click_count"), dr.getInt("reply_count"), dr
.getChar("delete_sign"), dr.getString("contenttype")));
ret.append("'/></TD>");
// 标题列
ret.append("<TD class='body_td' align='left' width='34%'>");
ret.append("<img id='lblMood_Icon' width='15' height='15' src='");
ret.append(sSrc);
ret.append("' />");
if (dr.getChar("EXIST_ATTCH") == '1') {
ret.append("<label id='lblExist_Attch' style='color: red; padding-right: 5px; '>[附件]</lable>");
}
ret.append("<a id='lblTitle' href='javascript:' onclick='window.setTimeout(\"fn_dblClick();\",20); return false;'>");
ret.append(dr.getString("Title"));
ret.append("</a></TD>");
// 用户名称列
ret.append("<TD class='body_td' align='left' width='10%'>");
ret.append("<label id='lblUser_Name'>");
ret.append(dr.getString("User_Name"));
ret.append("</label></TD>");
// 回复/人气列
ret.append("<TD class='body_td' align='left' width='10%'>");
ret.append("<label id='lblReply_Count'>");
ret.append(dr.getString("Reply_Count"));
ret.append("</label>/<label id='lblClick_Count'>");
ret.append(dr.getString("Click_Count"));
ret.append("</label></TD>");
// 最后更新 | 回复人
ret.append("<TD class='body_td' align='left' width='25%'>");
ret.append("<label id='lblLast_Reply_Time'>");
SimpleDateFormat f1 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
if (dr.getValue("Last_Reply_Time") != null)
ret.append(f1.format(dr.getDate("Last_Reply_Time")));
ret.append("</label> | <label id='lblReply_User_Name'>");
ret.append(dr.getString("Reply_User_Name"));
ret.append("</label></TD>");
String action="SETREJECT&PAGETYPE=1";
String actionName="回退";
if(dr.getString("delete_sign")!=null && dr.getString("delete_sign").equals("N")) {
action="SETACCEPT&PAGETYPE=1";
actionName="通过";
}
ret.append("<TD class='body_td' align='left' width='8%'>" +
"<a href='manager_submit.jsp?CONTENT_ID="+dr.getString("content_id")+
"&ACTION="+action+"'>"+actionName+"</a></td>");
/*ret.append("<TD class='body_td' align='left' width='8%'>" +
"<a href='manager_submit.jsp?CONTENT_ID="+dr.getString("content_id")+
"&ACTION=SETACCEPT&PAGETYPE=1'>通过</a></td>" +
"<td class='body_td' align='left' width='8%'>" +
"<a href='manager_submit.jsp?CONTENT_ID="+dr.getString("content_id")+
"&ACTION=SETREJECT&PAGETYPE=1'>回退</a></TD>");*/
ret.append("</tr>");
}
}
ret.append("</table>");
// ret.append("</form>");
}
catch (Exception ex) {
FileLogger.getLogger().warn(ex.getMessage(), ex);
throw new RuntimeException(ex);
}
return ret.toString();
}
/**
* 广告模块配置与备注
* @param request
* @param response
* @param param
* @return
*/
public static String getSimpleContentList(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"));
FileLogger log = new FileLogger();
if (pageSize == -1 || currentPage == -1) {
log.info("页面参数为空。");
}
else {
log.info("pageSize:" + String.valueOf(pageSize));
log.info("currentPage:" + String.valueOf(currentPage));
}
WebAuth auth = WebAuth.getInstance((HttpServletRequest) request);
DataTable dt = ClientDAO.getContextResult(param,auth, currentPage,pageSize);
ret.append("<table>");
if (dt != null) {
for (int i = 0; i < dt.getRows().getCount(); i++) {
DataRow dr = dt.getRow(i);
String sIcon=dr.getString("Mood_Icon");
String sSrc="";
if ((sIcon!=null)&&(sIcon.length()!=0)&&(sIcon.indexOf("/")==-1)) {
sSrc="../images/face/"+sIcon;
}
if ((sIcon!=null)&&(sIcon.length()!=0)&&(sIcon.indexOf("/")!=-1)) {
sSrc=sIcon;
}//判断是心情图标还是扩展图标
ret.append("<tr key='" + dr.getString("content_id") + "'>");
// 小图标列
ret.append("<TD class='body_td' align='left' width='5%'>");
ret.append("<img id='lblState' src='");
String srcState=getStatusImage(dr.getInt("tip_order"), dr.getChar("extract_sign"), dr
.getInt("click_count"), dr.getInt("reply_count"), dr
.getChar("delete_sign"), dr.getString("contenttype"));
srcState="../"+srcState;
ret.append(srcState);
ret.append("' title='");
ret.append(getStatusImageInfo(dr.getInt("tip_order"), dr.getChar("extract_sign"), dr
.getInt("click_count"), dr.getInt("reply_count"), dr
.getChar("delete_sign"), dr.getString("contenttype")));
ret.append("'/></TD>");
// 标题列
ret.append("<TD class='body_td' align='left' width='25%'>");
ret.append("<img id='lblMood_Icon' width='15' height='15' src='");
ret.append(sSrc);
ret.append("' />");
if (dr.getChar("EXIST_ATTCH") == '1') {
ret.append("<label id='lblExist_Attch' style='color: red; padding-right: 5px; '>[附件]</lable>");
}
ret.append("<a id='lblTitle' href='javascript:' onclick='window.setTimeout(\"fn_dblClick();\",20); return false;'>");
ret.append(dr.getString("Title"));
ret.append("</a></TD>");
// 用户名称列
ret.append("<TD class='body_td' align='left' width='20%'>");
ret.append("<label id='lblUser_Name'>");
ret.append(dr.getString("User_Name"));
ret.append("</label></TD>");
//创建时间
ret.append("<TD class='body_td' align='left' width='20%'>");
ret.append("<label id='CREATE_TIME'>");
ret.append(dr.getString("CREATE_TIME"));
ret.append("</label></TD>");
//内容编码
ret.append("<TD class='body_td' align='left' width='15%'>");
ret.append("<label id='CONTENT_CODE'>");
ret.append(dr.getString("CONTENT_CODE"));
ret.append("</label></TD>");
String action="SETREJECT&PAGETYPE=1";
String actionName="回退";
if(dr.getString("delete_sign")!=null &&
dr.getChar("delete_sign")=='D' || dr.getChar("delete_sign")=='N') {
action="SETACCEPT&PAGETYPE=1";
actionName="通过";
}
ret.append("<TD class='body_td' align='left' width='14%'>" +
"<a href='../manager_submit.jsp?CONTENT_ID="+dr.getString("content_id")+
"&ACTION="+action+"'>"+actionName+"</a></td>");
ret.append("</tr>");
}
}
ret.append("</table>");
}
catch (Exception ex) {
FileLogger.getLogger().warn(ex.getMessage(), ex);
throw new RuntimeException(ex);
}
return ret.toString();
}
private static String getStatusImage(int iTip, char cExtract, int iClick, int iReply, char cDelete,
String contentType) {
String ret = "";
if (cDelete == 'D')
ret = "delete";
else if (iTip > 0)
ret = "istop";
else if (cExtract == '1')
ret = "Extract";
else if (cExtract == '2')
ret = "hotinfo";
else if (cExtract == '3')
ret = "newpro";
else {
int hot_sign = Math.max(iClick / 500, iReply / 20);
if (hot_sign > 5)
hot_sign = 5;
ret = "hot" + Integer.toString(hot_sign);
}
/** 2007-04-09
* 修改内容审核（delete_sign=='N'表示未通过，delete_sign=='E'表示通过）
*/
if (cDelete=='E')
ret = ret + "_ok";
return "images/state/" + ret + ".gif";
}
private static String getStatusImageInfo(int iTip, char cExtract, int iClick, int iReply, char cDelete,
String contentType) {
String ret = "";
if (cDelete == 'D')
ret = "delete";
else if (iTip > 0)
ret = "固顶";
else if (cExtract == '1')
ret = "热点内容";
else if (cExtract == '2')
ret = "首页热点信息";
else if (cExtract == '3')
ret = "首页最新产品";
if(cDelete=='E')
ret = ret+" [审核通过]" ;
// if (contentType.equals("02"))
// ret = ret+" [审核通过]" ;
return ret ;
}
public static int getContentCount(ServletRequest request, ServletResponse response, Map param) {
// long lBoardId = Long.parseLong((String) param.get("boardId"));
// int ret = BBSFactory.getInstance(request).getTotalRecordCountByBoardId(lBoardId, null);
int ret=0;
try {
WebAuth auth = WebAuth.getInstance((HttpServletRequest) request);
ret=ClientDAO.getConditionResult(param,auth);
return ret;
}catch(Exception e) {
FileLogger.getLogger().debug("ContentCount:" + String.valueOf(ret));
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -