| | |
| | | import cn.ksource.core.util.ConvertUtil; |
| | | import cn.ksource.core.util.DateUtil; |
| | | import cn.ksource.core.util.StringUtil; |
| | | import cn.ksource.web.Constants; |
| | | |
| | | import com.lowagie.text.pdf.PRAcroForm; |
| | | |
| | | import org.apache.commons.lang.StringEscapeUtils; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import javax.annotation.Resource; |
| | | |
| | | import java.sql.Struct; |
| | | import java.util.ArrayList; |
| | | import java.util.Arrays; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.*; |
| | | |
| | | /** |
| | | * Created by chenlong |
| | |
| | | sql.append(" and b.code like :flbm "); |
| | | params.put("flbm","%"+code+"%" ); |
| | | } |
| | | sql.append(" group by b.id"); |
| | | sql.append(" group by b.id,b.LV1_id,b.LV2_id,b.LV1_NAME, b.LV2_NAME, b.LV3_NAME, b.CODE"); |
| | | return sql.toString(); |
| | | |
| | | } |