| | |
|---|
| | | package com.ld.igds.view.service; |
|---|
| | | |
|---|
| | | import com.bstek.bdf2.core.orm.hibernate.HibernateDao; |
|---|
| | | import com.bstek.dorado.data.provider.Page; |
|---|
| | | import com.ld.igds.models.DicArea; |
|---|
| | | import org.apache.commons.lang3.StringUtils; |
|---|
| | | import org.hibernate.Session; |
|---|
| | | import org.springframework.stereotype.Component; |
|---|
| | | |
|---|
| | | import java.util.HashMap; |
|---|
| | | import java.util.List; |
|---|
| | | import java.util.Map; |
|---|
| | |
|---|
| | | } |
|---|
| | | return list.get(0); |
|---|
| | | } |
|---|
| | | |
|---|
| | | public void pageList(Page<DicArea> page, String key) throws Exception { |
|---|
| | | |
|---|
| | | String hql = " from " + DicArea.class.getName(); |
|---|
| | | |
|---|
| | | Map<String, Object> args = new HashMap<>(); |
|---|
| | | List<DicArea> list; |
|---|
| | | String countHql; |
|---|
| | | if (StringUtils.isNotEmpty(key)) { |
|---|
| | | hql += " where (name like :key1 or simple like:key2)"; |
|---|
| | | args.put("key1", "%" + key + "%"); |
|---|
| | | args.put("key2", "%" + key.toUpperCase() + "%"); |
|---|
| | | |
|---|
| | | countHql = "select count(1) " + hql; |
|---|
| | | hql += " order by code"; |
|---|
| | | |
|---|
| | | this.pagingQuery(page, hql, countHql, args); |
|---|
| | | |
|---|
| | | } else { |
|---|
| | | countHql = "select count(1) " + hql; |
|---|
| | | hql += " order by code"; |
|---|
| | | this.pagingQuery(page, hql, countHql); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | } |
|---|
