import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.apache.struts2.ServletActionContext;
import com.gdcct.ctp.comm.utils.PageModel;
import com.gdcct.ctp.comm.web.BaseAction;
import com.gdcct.hospital.core.event.WCMSearchVO;
import com.gdcct.hospital.core.event.WcmClassSearchVO;
import com.trs.client.*;
public class HpWcmAction extends BaseAction {
private List<WCMSearchVO> wcmvoList = new ArrayList<WCMSearchVO>();
private String searchwords;
private long wcmCount;
private List<WcmClassSearchVO> classSearchVo = new ArrayList<WcmClassSearchVO>();
private PageModel pageModel = new PageModel();
private int currentPage;
public static final int PAGESIZE = 10;
private String departmentCode;
@SuppressWarnings("unchecked")
private String keyTovalue(String code){
Map utilMap = new HashMap<String,String>();
utilMap.put("2707","农作物");
utilMap.put("2709","畜禽类");
utilMap.put("2715","果树类");
utilMap.put("2716","水产类");
utilMap.put("2717","花卉类");
utilMap.put("1007","其他专家");
utilMap.put("2719","蔬菜类");
utilMap.put("2020","测试类");
return (String) utilMap.get(code);
}
@SuppressWarnings("unchecked")
public String searchKnolege() throws Exception {
TRSConnection trscon = null;
TRSResultSet resultSet = null;
String method = ServletActionContext.getRequest().getMethod();
if (searchwords != null
&& method.equalsIgnoreCase("get")) {
searchwords=new String(searchwords
.getBytes("ISO-8859-1"), "utf-8");
}
try
{
trscon = new TRSConnection();
trscon.connect("10.10.0.134", "9595", "system", "manager");
if (("".equals(departmentCode)&&"".equals(searchwords))) {
resultSet = trscon.executeSelect("wcmknowlege", searchwords, "", "", "", 0, TRSConstant.TCE_OFFSET, false);//以起始位置/长度方式表示命中点位置。
}
else if ((!(null==(departmentCode)||"".equals(departmentCode)))&&(null==searchwords||"".equals(searchwords))) {
resultSet = trscon.executeSelect("wcmknowlege", "PARENTID="+departmentCode, "", "", "", 0, TRSConstant.TCE_OFFSET, false);//以起始位置/长度方式表示命中点位置。
}//
else if ((null==(departmentCode)||"".equals(departmentCode))&&(!(null==searchwords||"".equals(searchwords)))) {
resultSet = trscon.executeSelect("wcmknowlege", searchwords, "", "", "", 0, TRSConstant.TCE_OFFSET, false);//以起始位置/长度方式表示命中点位置。
}
else{
//String dd="PARENTID="+departmentCode+" and DOCCONTENT="+searchwords+" or DOCTITLE="+searchwords;
resultSet = trscon.executeSelect("wcmknowlege", "PARENTID="+departmentCode+" and DOCCONTENT="+searchwords+" or DOCTITLE="+searchwords, "", "", "", 0, TRSConstant.TCE_OFFSET, false);
}
wcmCount=resultSet.getRecordCount();
System.out.println(resultSet.getRecordCount());
//分页
//定义当前页数大小
int lineSize=15;
resultSet.setPageSize(lineSize);
//总记录数
int allRecorders = resultSet.getPageCount();
//总页数
int totalPageSize=(allRecorders+lineSize-1)/lineSize;
//当前页页数
if(pageModel.getPageIndex()==0){
int currentPage=resultSet.getPage();//传过来
}else{
int currentPage=pageModel.getPageIndex();
}
//*resultSet.setPageSize(14);
pageModel.setPageSize(lineSize);
pageModel.setRecordCount((int)resultSet.getRecordCount());
pageModel.setTotalSize(totalPageSize);//写个overide方法即可
int pagedex = pageModel.getPageIndex();
resultSet.setPage(pagedex);
int tt =resultSet.getPage();//当前页数
//分类显示
int iClassNum= resultSet.classResult("PARENTID","", 10, "", false, false);
System.out.println("ClassCount= " + resultSet.getClassCount());
//Map<Integer, String> hashmap = new HashMap<Integer, String>();
for (int i= 0; i< iClassNum; i++)
{
ClassInfo classInfo= resultSet.getClassInfo(i);
String strName = this.keyTovalue(classInfo.strValue);
WcmClassSearchVO wcmVo= new WcmClassSearchVO();
wcmVo.setClassName(strName);
wcmVo.setClassNo(classInfo.iRecordNum);
classSearchVo.add(wcmVo);
}
// for (int i = 0; i<tt*10&&i<resultSet.getRecordCount(); i++)
for(int x=0;x<(currentPage-1)*lineSize;x++)
{
resultSet.moveTo(0, x);
WCMSearchVO wcmsearchVo = new WCMSearchVO();
wcmsearchVo.setWcmNo((currentPage*lineSize)+(x+1));//依据页码来增加值!
wcmsearchVo.setDoctitle(resultSet.getString("DOCTITLE"));
wcmsearchVo.setChnldesc(resultSet.getString("CHNLDESC"));
wcmsearchVo.setChnlname( keyTovalue(resultSet.getString("PARENTID")));
wcmsearchVo.setDocpubtime(resultSet.getString("DOCPUBTIME"));
wcmsearchVo.setDoccontent(resultSet.getString("DOCCONTENT"));
wcmsearchVo.setDocpuburl(resultSet.getString("DOCPUBURL"));
wcmvoList.add(wcmsearchVo);
}
}
catch (TRSException ex)
{
// 输出错误信息
System.out.println(ex.getErrorCode() + ":" + ex.getErrorString());
ex.printStackTrace();
}
finally
{
// 关闭结果集
if (resultSet != null) resultSet.close();
resultSet = null;
// 断开连接
if (trscon != null) trscon.clean();
trscon = null;
}
return SUCCESS;
}
public List<WcmClassSearchVO> getClassSearchVo() {
return classSearchVo;
}
public void setClassSearchVo(List<WcmClassSearchVO> classSearchVo) {
this.classSearchVo = classSearchVo;
}
public String getSearchwords() {
return searchwords;
}
public PageModel getPageModel() {
return pageModel;
}
public void setPageModel(PageModel pageModel) {
this.pageModel = pageModel;
}
public void setSearchwords(String searchwords) {
this.searchwords = searchwords;
}
public long getWcmCount() {
return wcmCount;
}
public void setWcmCount(long wcmCount) {
this.wcmCount = wcmCount;
}
public List<WCMSearchVO> getWcmvoList() {
return wcmvoList;
}
public void setWcmvoList(List<WCMSearchVO> wcmvoList) {
this.wcmvoList = wcmvoList;
}
public int getCurrentPage() {
return currentPage;
}
public void setCurrentPage(int currentPage) {
this.currentPage = currentPage;
}
public String getDepartmentCode() {
return departmentCode;
}
public void setDepartmentCode(String departmentCode) {
this.departmentCode = departmentCode;
}
}
WCM
最新推荐文章于 2018-11-27 10:59:11 发布