package com.yc.utils;
|
|
|
import com.yc.action.grid.AttendEntity;
|
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* 分页类
|
*
|
* @author 邓文峰
|
* 2010-2-23
|
**/
|
@SuppressWarnings({"unchecked"})
|
public class Page {
|
private int pageSize = 50;//每页记录数
|
private List data;//装载数据
|
private int totalRowNum;//总记录数
|
private int startRowNum = 1;//开始行号
|
private int pageNum;//当前页
|
private int endRowNum;//结束行号
|
private int totalPageNum;//总页数
|
private String where = "";//查询条件
|
private String tableName;//表名
|
private String orderBy = "";//排序
|
private String sql = "*";//查询体
|
private String id;//主键
|
private int flag = 0;//标记,1表示需要显示数据
|
private String parms = "";//18类型的参数列表
|
private String filter = "";//启动表单过滤条件
|
private String dataformid = "";//dataformid功能
|
private String type = "";//窗体类型
|
private int formid = 0;//功能号
|
private String expr = "";//查询时权限控制
|
private String cssexpr = "";//css样式限控制
|
private String tipsexpr = "";//css样式限控制
|
private int pos;//分页位置
|
public boolean isNull = false;
|
private String rowSpan = "";
|
private String dataGroup = "";//数据组权限sql条件语句
|
private String cp = "";//复单操作的标记
|
private int isCp = 0;//表示当前是复单操作
|
private String excelTitle;//保存excel动态标题
|
private int isGantt = 0;
|
private int isTree = 0;//18类型是否显示为树
|
private String expanded = "";
|
private String picFild = "";
|
private String tbCols = "";//统计列
|
private String tbColsOut = "";//统计列输出
|
private String groupby = "";
|
private List celllign;
|
private String where1;
|
private List displayformat;
|
private List grid3Data;//第3表的数据,用在excel导出
|
private String keys;//15类型功能号的二,三表关联字段
|
private Object resultMap;
|
private String newTbCols = "";//38类型保存页脚本汇总字段
|
private String userCode;
|
private String UserName;
|
private String PROC_NAME = "SP_viewPageV4";
|
private int firstIndex;//取分页时第一次调用
|
private Map tbColsMap;
|
private String formName;
|
private Map<String, AttendEntity> attachmentType;
|
private int orgPageSize;
|
private String grid3FormId;
|
private String[] grid3Titles;
|
private String[] grid3Fields;
|
private String fieldsExprs;
|
|
public String getFieldsExprs() {
|
return fieldsExprs;
|
}
|
|
public void setFieldsExprs(String fieldsExprs) {
|
this.fieldsExprs = fieldsExprs;
|
}
|
|
public String getFormName() {
|
return formName;
|
}
|
|
public void setFormName(String formName) {
|
this.formName = formName;
|
}
|
|
public String getPROC_NAME() {
|
return PROC_NAME;
|
}
|
|
public void setPROC_NAME(String PROC_NAME) {
|
this.PROC_NAME = PROC_NAME;
|
}
|
|
public int getFirstIndex() {
|
return firstIndex;
|
}
|
|
public void setFirstIndex(int firstIndex) {
|
this.firstIndex = firstIndex;
|
}
|
|
public String getUserName() {
|
return UserName;
|
}
|
|
public void setUserName(String userName) {
|
UserName = userName;
|
}
|
|
public String getNewTbCols() {
|
return newTbCols;
|
}
|
|
public void setNewTbCols(String newTbCols) {
|
this.newTbCols = newTbCols;
|
}
|
|
public Object getResultMap() {
|
return resultMap;
|
}
|
|
public void setResultMap(Object resultMap) {
|
this.resultMap = resultMap;
|
}
|
|
public String getKeys() {
|
return keys;
|
}
|
|
public void setKeys(String keys) {
|
this.keys = keys;
|
}
|
|
public List getGrid3Data() {
|
return grid3Data;
|
}
|
|
public void setGrid3Data(List grid3Data) {
|
this.grid3Data = grid3Data;
|
}
|
|
public List getDisplayformat() {
|
return displayformat;
|
}
|
|
public void setDisplayformat(List displayformat) {
|
this.displayformat = displayformat;
|
}
|
|
public String getWhere1() {
|
return where1;
|
}
|
|
public void setWhere1(String where1) {
|
this.where1 = where1;
|
}
|
|
public List getCelllign() {
|
return celllign;
|
}
|
|
public void setCelllign(List celllign) {
|
this.celllign = celllign;
|
}
|
|
private int autopaging = 3;
|
private Map<String, String> env;
|
private Map<String, String> tbExpr;//统计列用的权限表达式,在计算里面过滤权限=0的情况
|
|
public Map<String, String> getTbExpr() {
|
return tbExpr;
|
}
|
|
public void setTbExpr(Map<String, String> tbExpr) {
|
this.tbExpr = tbExpr;
|
}
|
|
public Map<String, String> getEnv() {
|
return env;
|
}
|
|
public void setEnv(Map<String, String> env) {
|
this.env = env;
|
}
|
|
public int getAutopaging() {
|
return autopaging;
|
}
|
|
public void setAutopaging(int autopaging) {
|
this.autopaging = autopaging;
|
}
|
|
public String getGroupby() {
|
return groupby;
|
}
|
|
public void setGroupby(String groupby) {
|
this.groupby = groupby;
|
}
|
|
public String getTbColsOut() {
|
return tbColsOut;
|
}
|
|
public void setTbColsOut(String tbColsOut) {
|
this.tbColsOut = tbColsOut;
|
}
|
|
public String getTbCols() {
|
return tbCols;
|
}
|
|
public void setTbCols(String tbCols) {
|
this.tbCols = tbCols;
|
}
|
|
public String getTipsexpr() {
|
return tipsexpr;
|
}
|
|
public void setTipsexpr(String tipsexpr) {
|
this.tipsexpr = tipsexpr;
|
}
|
|
public String getCssexpr() {
|
return cssexpr;
|
}
|
|
public void setCssexpr(String cssexpr) {
|
this.cssexpr = cssexpr;
|
}
|
|
public String getPicFild() {
|
return picFild;
|
}
|
|
public void setPicFild(String picFild) {
|
this.picFild = picFild;
|
}
|
|
public String getExpanded() {
|
return expanded;
|
}
|
|
public void setExpanded(String expanded) {
|
this.expanded = expanded;
|
}
|
|
public int getIsTree() {
|
return isTree;
|
}
|
|
public void setIsTree(int isTree) {
|
this.isTree = isTree;
|
}
|
|
public int getIsGantt() {
|
return isGantt;
|
}
|
|
public void setIsGantt(int isGantt) {
|
this.isGantt = isGantt;
|
}
|
|
public String getExcelTitle() {
|
return excelTitle;
|
}
|
|
public void setExcelTitle(String excelTitle) {
|
this.excelTitle = excelTitle;
|
}
|
|
public int getIsCp() {
|
return isCp;
|
}
|
|
public void setIsCp(int isCp) {
|
this.isCp = isCp;
|
}
|
|
public String getCp() {
|
return cp;
|
}
|
|
public void setCp(String cp) {
|
this.cp = cp;
|
}
|
|
public String getDataGroup() {
|
return dataGroup;
|
}
|
|
public void setDataGroup(String dataGroup) {
|
this.dataGroup = dataGroup;
|
}
|
|
public String getRowSpan() {
|
return rowSpan;
|
}
|
|
public void setRowSpan(String rowSpan) {
|
this.rowSpan = rowSpan;
|
}
|
|
public int getPos() {
|
return pos;
|
}
|
|
public void setPos(int pos) {
|
this.pos = pos;
|
}
|
|
public String getExpr() {
|
return expr;
|
}
|
|
public void setExpr(String expr) {
|
this.expr = expr;
|
}
|
|
public String getType() {//增加单据 by 13-3-14 去掉,在面板控制
|
// if(type.trim().equalsIgnoreCase("9|0")||type.trim().equalsIgnoreCase("17|0")||type.trim().equalsIgnoreCase("15|0"))
|
// return " and formid in("+formid+")";//去掉 and 修改为 or
|
// else
|
return "";
|
}
|
|
public void setType(String type, int formid) {
|
this.type = type;
|
this.formid = formid;
|
}
|
|
public String getWinType() {//取窗体类型
|
return this.type;
|
}
|
|
public int getFormid() {
|
return formid;
|
}
|
|
public void setFormid(int formid) {
|
this.formid = formid;
|
}
|
|
public String getDataformid() {
|
return "";
|
//dataformid取值已在前端拼接处理好,这里不再需要 by danaus 2023-04-11 15:30
|
/* if (dataformid == "" || "".equals(dataformid) || dataformid == null)
|
return "";
|
else {
|
if (dataformid.indexOf("@p@") > 0) {//只有单据才有DocStatus 修改为 or 的关系 ,by13-3-13
|
String[] temp = dataformid.split("@p@");
|
return " or (formid in(" + temp[0] + ") and DocStatus=" + temp[1] + ")";
|
} else {
|
return " or formid in(" + dataformid + ")";
|
}
|
}*/
|
}
|
|
public void setDataformid(String dataformid) {
|
this.dataformid = dataformid;
|
}
|
|
public String getFilter() {
|
return filter;
|
}
|
|
public void setFilter(String filter) {
|
this.filter += filter;
|
}
|
|
public String getParms() {
|
return parms;
|
}
|
|
public void setParms(String parms) {
|
this.parms = parms;
|
}
|
|
public int getFlag() {
|
return flag;
|
}
|
|
public void setFlag(int flag) {
|
this.flag = flag;
|
}
|
|
public String getId() {
|
return id;
|
}
|
|
public void setId(String id) {
|
this.id = id;
|
}
|
|
public String getSql() {
|
return sql;
|
}
|
|
public void setSql(String sql) {
|
this.sql = sql;
|
}
|
|
public String getTableName() {
|
return tableName;
|
}
|
|
public void setTableName(String tableName) {
|
this.tableName = tableName;
|
}
|
|
public String getOrderBy() {
|
return orderBy;
|
}
|
|
public void setOrderBy(String orderBy) {
|
this.orderBy = orderBy;
|
}
|
|
public String getWhere() {
|
where = where.equalsIgnoreCase("null") || "doccode=".equalsIgnoreCase(where) ? "" : where;
|
if (where == "") this.isNull = true;
|
return where;
|
|
}
|
|
public void setWhere(String where) {
|
this.where = where;
|
}
|
|
public int getPageSize() {
|
return pageSize == 0 ? 50 : pageSize;
|
}
|
|
public void setPageSize(int pageSize) {
|
this.pageSize = pageSize;
|
}
|
|
public List getData() {
|
return data;
|
}
|
|
public void setData(List data) {
|
this.data = data;
|
}
|
|
public int getTotalRowNum() {
|
return totalRowNum;
|
}
|
|
public void setTotalRowNum(int totalRowNum) {
|
this.totalRowNum = totalRowNum;
|
}
|
|
public int getStartRowNum() {
|
return startRowNum;
|
}
|
|
public void setStartRowNum(int startRowNum) {
|
this.startRowNum = startRowNum;
|
}
|
|
public int getPageNum() {
|
return pageNum;
|
}
|
|
public void setPageNum(int pageNum) {
|
this.pageNum = pageNum;
|
}
|
|
public int getEndRowNum() {
|
return endRowNum;
|
}
|
|
public void setEndRowNum(int endRowNum) {
|
this.endRowNum = endRowNum;
|
}
|
|
public int getTotalPageNum() {
|
return totalPageNum;
|
}
|
|
public void setTotalPageNum(int totalPageNum) {
|
this.totalPageNum = totalPageNum;
|
}
|
|
|
public String getUserCode() {
|
return userCode;
|
}
|
|
public void setUserCode(String userCode) {
|
this.userCode = userCode;
|
}
|
|
public void setTbColsMap(Map tbColsMap) {
|
this.tbColsMap = tbColsMap;
|
}
|
|
public Map getTbColsMap() {
|
return tbColsMap;
|
}
|
|
public void setAttachmentType(Map<String, AttendEntity> attachmentType) {
|
this.attachmentType = attachmentType;
|
}
|
|
public Map<String, AttendEntity> getAttachmentType() {
|
return attachmentType;
|
}
|
|
public void setOrgPageSize(int orgPageSize) {
|
this.orgPageSize = orgPageSize;
|
}
|
|
public int getOrgPageSize() {
|
return orgPageSize;
|
}
|
|
public void setGrid3FormId(String grid3FormId) {
|
this.grid3FormId = grid3FormId;
|
}
|
|
public String getGrid3FormId() {
|
return grid3FormId;
|
}
|
|
public void setGrid3Titles(String[] grid3Titles) {
|
this.grid3Titles = grid3Titles;
|
}
|
|
public String[] getGrid3Titles() {
|
return grid3Titles;
|
}
|
|
public void setGrid3Fields(String[] grid3Fields) {
|
this.grid3Fields = grid3Fields;
|
}
|
|
public String[] getGrid3Fields() {
|
return grid3Fields;
|
}
|
}
|