package cn.com.goldenwater.dcproj.utils.impexcel.format; import cn.com.goldenwater.dcproj.utils.impexcel.ImpUtil; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Date; import static cn.com.goldenwater.dcproj.utils.impexcel.ImpUtil.ERR; import static cn.com.goldenwater.dcproj.utils.impexcel.ImpUtil.checkIsDate; /** *

* 问题相关字段格式化(导入) *

* * @author liyz * @date 2019/7/12 14:02 **/ public class PblmFieldFormatImp { private static final String TIP1 = "不能为空!"; private static String tipNotEmpty(String value){ if(value == null || "".equals(value)){ return TIP1 + ERR; } return value; } public static String formatGroupName(String value){ return tipNotEmpty(value); } public static String formatRsCode(String value){ return tipNotEmpty(value); } public static String formatObjCode(String value){ return tipNotEmpty(value); } public static String formatAttachSheet(String value){ if(value == null || "".equals(value)){ return TIP1 + ERR; } if(!ImpUtil.checkIsInt(value.replace("-",""))){ return value + ERR; } return value; } public static String formatInspPblmCode(String value){ if(value == null || "".equals(value)){ return TIP1 + ERR; } if(!ImpUtil.checkIsInt(value)){ return value + ERR; } return value; } /** * 问题严重程度 0一般 1较重 2严重 3特别严重 */ public static String formatInspPblmCate(String value){ if(value == null){ return ""; } switch (value) { case "一般": value = "0"; break; case "较重": value = "1"; break; case "严重": value = "2"; break; case "特别严重": value = "3"; break; case "": value = TIP1 + ERR; break; default: value = value + ERR; break; } return value; } /** * 是否典型 1典型 0非典型 */ public static String formatIfCasePblm(String value){ if(value == null || "".equals(value)){ return ""; } switch (value) { case "典型": value = "1"; break; case "非典型": value = "0"; break; default: value = value + ERR; break; } return value; } /** 是否包含多媒体文件 */ public static String formatHasVedio(String value){ if(value == null || "".equals(value)){ return ""; } switch (value) { case "是": value = "1"; break; case "否": value = "0"; break; default: value = value + ERR; } return value; } public static String formatBdNm(String value){ if(value == null || "".equals(value)){ return TIP1 + ERR; } return value; } public static String formatDwNm(String value){ if(value == null || "".equals(value)){ return TIP1 + ERR; } return value; } public static String formatNm(String value){ if(value == null || "".equals(value)){ return TIP1 + ERR; } return value; } public static Date formatCollTime(String value){ if(value == null || "".equals(value.trim())){ return new Date(); } // 可能是年月日格式的,处理一下 value = value.replace("年","-").replace("月","-").replace("日",""); if(checkIsDate(value)){ try { return new SimpleDateFormat("yyyy-MM-dd").parse(value.replace("/","-")); } catch (ParseException e) { e.printStackTrace(); } } return new Date(); } }