| | |
| | | import com.yc.action.grid.GridUtils; |
| | | import net.sf.json.JSONArray; |
| | | |
| | | import org.apache.commons.lang3.StringUtils; |
| | | import org.apache.poi.hssf.usermodel.HSSFCell; |
| | | import org.apache.poi.hssf.usermodel.HSSFCellStyle; |
| | | import org.apache.poi.hssf.usermodel.HSSFDataFormat; |
| | |
| | | import org.springframework.jdbc.support.rowset.SqlRowSet; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import com.yc.action.grid.PoiExcelWriter; |
| | | import com.yc.entity.Json38; |
| | | import com.yc.service.new38type.Type38Impl.ExcelPO; |
| | | import com.yc.service.new38type.Type38Impl.Pov; |
| | | import com.yc.service.BaseService; |
| | | import com.yc.utils.JOSNUtils; |
| | | import com.yc.utils.Page; |
| | | |
| | | import java.io.File; |
| | | import java.io.FileOutputStream; |
| | | import java.io.IOException; |
| | | import java.io.OutputStream; |
| | | import java.math.BigDecimal; |
| | | import java.text.DecimalFormat; |
| | | |
| | | import com.yc.utils.DateUtil; |
| | | |
| | | |
| | | |
| | | @Service("type38Impl") |
| | |
| | | //private static final String DELETE_PANEL_DATA = "delete _sysStatis where formid in ? and StatisID in ?"; |
| | | |
| | | @Override |
| | | public List<Map<String, Object>> selecttype(int formid,String usercode) { |
| | | public List<Map<String, Object>> selecttype(int formid, String usercode, String statisIds) { |
| | | // TODO Auto-generated method stub |
| | | String sql="set nocount on; select formID,StatisID,StatisName,activedyn,usercode from _sysStatis where formid="+formid+" and isnull(usercode,'') in ('',"+"'"+usercode+"'"+") order by usercode asc ,StatisID asc"; |
| | | String statisidList=""; |
| | | if(StringUtils.isNotBlank(statisIds)){ |
| | | statisidList=" and isnull(StatisID,'') in ( select list from getinstr('"+statisIds+"')) "; |
| | | } |
| | | String sql="set nocount on; select formID,StatisID,StatisName,activedyn,usercode from _sysStatis where formid="+formid+" and isnull(usercode,'') in ('',"+"'"+usercode+"'"+") "+statisidList+" order by usercode asc ,StatisID asc"; |
| | | return this.jdbcTemplate.queryForList(sql); |
| | | } |
| | | @Override |