package com.web.report.service.internal;
|
|
import com.sun.mail.util.MailSSLSocketFactory;
|
|
import org.apache.commons.lang3.StringUtils;
|
import org.slf4j.Logger;
|
import org.slf4j.LoggerFactory;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.core.env.Environment;
|
import org.springframework.core.io.FileSystemResource;
|
import org.springframework.mail.SimpleMailMessage;
|
import org.springframework.mail.javamail.JavaMailSender;
|
import org.springframework.mail.javamail.JavaMailSenderImpl;
|
import org.springframework.mail.javamail.MimeMessageHelper;
|
import org.springframework.stereotype.Component;
|
|
import javax.annotation.PostConstruct;
|
import javax.mail.internet.InternetAddress;
|
import javax.mail.internet.MimeMessage;
|
import java.io.File;
|
import java.security.GeneralSecurityException;
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
import java.util.Properties;
|
|
/**
|
* 根据存储过程名称获取需要返回的map
|
* @author fyx
|
* @ClassName
|
* @Description
|
*/
|
@Component
|
public class ImpUtils {
|
|
private static final Logger logger = LoggerFactory.getLogger(ImpUtils.class);
|
|
/**
|
* 发送邮件
|
* @param subject 主题
|
* @param toUsers 收件人
|
* @param ccUsers 抄送人
|
* @param content 邮件内容
|
* @param attachfiles 附件列表 List<Map<String, String>> key: name && file
|
* @throws SQLException
|
*/
|
public static Map getMapByPro(String pro_name,ResultSet rs) throws SQLException{
|
Map m = new HashMap();
|
switch(pro_name){
|
case "APP_ZHICHENGQM_HZ":
|
m.put("RELEASE_NO", getEmpty(rs.getString("RELEASE_NO")));//检验单号
|
m.put("LOT_NO", getEmpty(rs.getString("LOT_NO")));//批次
|
m.put("PROC_NO", getEmpty(rs.getString("PROC_NO")));//工序
|
m.put("PROC_NAME", getEmpty(rs.getString("PROC_NAME")));//工序名称
|
m.put("ITEM_NO", getEmpty(rs.getString("ITEM_NO")));//产品编码
|
m.put("ITEM_NAME", getEmpty(rs.getString("ITEM_NAME")));//
|
m.put("FCHECK_RESU", getEmpty(rs.getString("FCHECK_RESU")));
|
m.put("FCHECK_ITEM", getEmpty(rs.getString("FCHECK_ITEM")));
|
m.put("FSTAND", getEmpty(rs.getString("FSTAND")));
|
m.put("FUP_ALLOW", getEmpty(rs.getString("FUP_ALLOW")));
|
m.put("FDOWN_ALLOW", getEmpty(rs.getString("FDOWN_ALLOW")));
|
m.put("CHECK_QTY", getEmpty(rs.getString("CHECK_QTY")));
|
m.put("FSPEC_REQU", getEmpty(rs.getString("FSPEC_REQU")));
|
|
break;
|
case "APP_BANCHENGPEING_INOUT":
|
m.put("TASK_NO", getEmpty(rs.getString("TASK_NO")));
|
m.put("BOARD_ITEM", getEmpty(rs.getString("BOARD_ITEM")));
|
m.put("BOARD_NAME", getEmpty(rs.getString("BOARD_NAME")));
|
m.put("PROC_NO", getEmpty(rs.getString("PROC_NO")));
|
m.put("LINE_NAME", getEmpty(rs.getString("LINE_NAME")));
|
m.put("TR", getEmpty(rs.getString("TR")));
|
m.put("CC", getEmpty(rs.getString("CC")));
|
m.put("UNIT", getEmpty(rs.getString("UNIT")));
|
m.put("RQ", getEmpty(rs.getString("RQ")));
|
|
break;
|
case "APP_BANCHENGPING_CCMX":
|
m.put("TASK_NO", getEmpty(rs.getString("TASK_NO")));
|
m.put("ITEM_BARCODE", getEmpty(rs.getString("ITEM_BARCODE")));
|
m.put("ITEM_NO", getEmpty(rs.getString("ITEM_NO")));
|
m.put("LOT_NO", getEmpty(rs.getString("LOT_NO")));
|
m.put("QUANTITY", getEmpty(rs.getString("QUANTITY")));
|
m.put("CREATE_BY", getEmpty(rs.getString("CREATE_BY")));
|
m.put("CREATE_DATE", getEmpty(rs.getString("CREATE_DATE")));
|
m.put("FBZ", getEmpty(rs.getString("FBZ")));
|
m.put("LINE_NO", getEmpty(rs.getString("LINE_NO")));
|
m.put("PROC_NO", getEmpty(rs.getString("PROC_NO")));
|
m.put("UNIT", getEmpty(rs.getString("UNIT")));
|
break;
|
case "APP_BANCHENGPING_TRMX":
|
m.put("TASK_NO", getEmpty(rs.getString("TASK_NO")));
|
m.put("LINE_NO", getEmpty(rs.getString("LINE_NO")));
|
m.put("PROC_NO", getEmpty(rs.getString("PROC_NO")));
|
m.put("MACHINE_CODE", getEmpty(rs.getString("MACHINE_CODE")));
|
m.put("ITEM_BARCODE", getEmpty(rs.getString("ITEM_BARCODE")));
|
m.put("ITEM_CODE", getEmpty(rs.getString("ITEM_CODE")));
|
m.put("QUANTITY", getEmpty(rs.getString("QUANTITY")));
|
m.put("UNIT", getEmpty(rs.getString("UNIT")));
|
m.put("ITEM_LOT", getEmpty(rs.getString("ITEM_LOT")));
|
m.put("FBZ", getEmpty(rs.getString("FBZ")));
|
m.put("CREATE_DATE", getEmpty(rs.getString("CREATE_DATE")));
|
break;
|
case "APP_ZY_DATA":
|
m.put("BARCODE", getEmpty(rs.getString("BARCODE")));
|
m.put("SCANTIME", getEmpty(rs.getString("SCANTIME")));
|
m.put("RESULT", getEmpty(rs.getString("RESULT")));
|
m.put("FWEIGHT", getEmpty(rs.getString("FWEIGHT")));
|
m.put("FW_TIME", getEmpty(rs.getString("FW_TIME")));
|
m.put("FW_RESULT", getEmpty(rs.getString("FW_RESULT")));
|
m.put("LWEIGHT", getEmpty(rs.getString("LWEIGHT")));
|
m.put("LW_TIME", getEmpty(rs.getString("LW_TIME")));
|
m.put("FILLINGNUM_PV", getEmpty(rs.getString("FILLINGNUM_PV")));
|
m.put("FILLINGNUM_SV", getEmpty(rs.getString("FILLINGNUM_SV")));
|
m.put("DEVIATION_PV", getEmpty(rs.getString("DEVIATION_PV")));
|
m.put("DEVIATION_SV", getEmpty(rs.getString("DEVIATION_SV")));
|
m.put("LOTNO", getEmpty(rs.getString("LOTNO")));
|
m.put("LINENO", getEmpty(rs.getString("LINENO")));
|
m.put("TAG", getEmpty(rs.getString("TAG")));
|
m.put("ROWNUMS", getEmpty(rs.getString("ROWNUMS")));
|
m.put("COLUMNNUMS", getEmpty(rs.getString("COLUMNNUMS")));
|
break;
|
}
|
|
return m;
|
}
|
//值为"null"或者null转换成""
|
private static String getEmpty(String str){
|
if(str == null){
|
return "";
|
}
|
if(StringUtils.equals("null", str)){
|
return "";
|
}
|
|
String[] strs = str.split("\\.");
|
if(strs.length > 0){
|
if(strs[0].equals("") || strs[0]==null){
|
return "0"+str;
|
}
|
}
|
return str;
|
}
|
}
|
