/** 电子邮件 Grid数据加载 */
public String gridLoad() {
B_V_Ufp_MailExample example = null;
B_V_Ufp_MailExample.Criteria criteria = null;
// 创建查询条件
example = new B_V_Ufp_MailExample();
criteria = example.createCriteria();
String userSysName = SessionFactory.getSessionUserId();
criteria.andIsDeleteEqualTo(0);
if (StringTools.isNotNullAndHasValue(isNew)) {
criteria.andIsNewEqualTo(Integer.valueOf(isNew));
}
if (StringTools.isNotNullAndHasValue(mailType)) {
if (mailType.length() > 1) {
criteria.andSpecificRecsysUserEqualTo(userSysName);
String temps[] = mailType.split(",");
List<Long> listType = new ArrayList<Long>();
for (String temp : temps) {
listType.add(Long.valueOf(temp));
}
criteria.andMailTypeIn(listType);
if (StringTools.isNotNullAndHasValue(isNew)) {
example
.or()
.andSpecificRecsysUserEqualTo(userSysName)
.andIsNewEqualTo(Integer.valueOf(isNew))
.andReplyFlagEqualTo(1);
} else {
// 收邮件显示所有邮件
example.or().andSpecificRecsysUserEqualTo(userSysName).andReplyFlagEqualTo(1);
}
} else {
if ("1".equals(mailType)) {
// 发件箱邮件
criteria.andMailTypeEqualTo(Long.valueOf(mailType));
criteria.andSendSysUserEqualTo(userSysName);
// 同时显示拷贝至发件箱
example.or().andReplyFlagEqualTo(4);
} else {
// 垃圾箱和草稿箱
criteria.andMailTypeEqualTo(Long.valueOf(mailType));
criteria.andReplyFlagEqualTo(3);
}
}
}
// 记录条数的记录
total = mapperMV.countByExample(example);
// 分页
example.or().setLimitValue(getRowStart(), getRowEnd());
// 添加排序
if (sort != null && !"".equals(sort) && order != null && !"".equals(order)) {
if ("sendUser".equals(sort)) {
sort = "SEND_USER";
} else if ("title".equals(sort)) {
sort = "title";
} else if ("sendTime".equals(sort)) {
sort = "send_time";
} else if ("isNew".equals(sort)) {
sort = "is_new";
} else if ("receiverTime".equals(sort)) {
sort = "receiver_time";
} else if ("receiverUser".equals(sort)) {
sort = "receiver_user";
}
example.setOrderByClause(sort + " " + order);
}
// 格式化result 一定要是JSONObject
result = CommonLogic.getResult(total, mapperMV.selectByExample(example));
return SUCCESS;
}
