/** * 发邮件时保存邮件,并发送邮件 * * @param sqlSession * @param mapper * @param mapperRelation * @param mapperContent * @param record * @param recordRelation * @param recordContent * @param sendTime * @param sendUser * @param sendSysUser * @return */ private String saveMail( B_T_Ufp_Mail_Attribute record, B_T_Ufp_Mail_Relation recordRelation, B_T_Ufp_Mail_Content recordContent, String sendTime, String sendUser, String sendSysUser, int replyFlag, C_T_Sys_FileExample example, C_T_Sys_FileExample.Criteria criteria) throws Exception { String returnMsg; // 向邮件属性表 添加 String uuid = new GUID().toString(); String isFile = null; // 所有收邮件人:收件人、抄送人和暗送人 String allReceiverSysUser = null; if (b_T_Ufp_Mail_Relation != null) { allReceiverSysUser = b_T_Ufp_Mail_Relation.getUserId(); if (b_T_Ufp_Mail_Attribute != null) { if (StringTools.isNotNullAndHasValue(allReceiverSysUser)) { allReceiverSysUser = allReceiverSysUser + "," + b_T_Ufp_Mail_Attribute.getCopySysUser() + "," + b_T_Ufp_Mail_Attribute.getDarkSysUser(); } else { allReceiverSysUser = b_T_Ufp_Mail_Attribute.getCopySysUser() + "," + b_T_Ufp_Mail_Attribute.getDarkSysUser(); } } } else { allReceiverSysUser = ""; if (b_T_Ufp_Mail_Attribute != null) { if (StringTools.isNotNullAndHasValue(allReceiverSysUser)) { allReceiverSysUser = allReceiverSysUser + "," + b_T_Ufp_Mail_Attribute.getCopySysUser() + "," + b_T_Ufp_Mail_Attribute.getDarkSysUser(); } else { allReceiverSysUser = b_T_Ufp_Mail_Attribute.getCopySysUser() + "," + b_T_Ufp_Mail_Attribute.getDarkSysUser(); } } } try { // 更新附件表的主文档ID FileIdUpdata.Updata(newFileIds, uuid); criteria.andMainIdEqualTo(uuid); List<C_T_Sys_File> listFile = mapperFT.selectByExample(example); if (listFile != null) { if (listFile.size() > 0) { isFile = "1"; // 有附件 } else { isFile = "0"; // 没有附件 } } else { isFile = "0"; // 没有附件 } } catch (Exception e) { e.printStackTrace(); } b_T_Ufp_Mail_Attribute.setUuid(uuid); b_T_Ufp_Mail_Attribute.setSendTime(sendTime); b_T_Ufp_Mail_Attribute.setSendUser(sendUser); b_T_Ufp_Mail_Attribute.setSendSysUser(sendSysUser); b_T_Ufp_Mail_Attribute.setIsReceipt(Integer.valueOf(booleanToString(isReceipt))); // 回执 // b_T_Ufp_Mail_Attribute.setIsSendMsg(Integer.valueOf(booleanToString(isSendMsg)));//是否发送短消息 mapperMAT.insertSelective(b_T_Ufp_Mail_Attribute); // 向邮件联系表添加(发送箱里面的邮件特定收件人统一不设置) b_T_Ufp_Mail_Relation.setUuid(uuid); if (StringTools.isNullOrNoValue(isPaper)) { if ("false".equals(mailType)) { // 未勾选保存至发件箱复选框,则保存至垃圾箱 b_T_Ufp_Mail_Relation.setMailType(Long.valueOf("3")); b_T_Ufp_Mail_Relation.setReplyFlag(3); // 垃圾箱标志:3 } else { // 1:默认勾选保存至发件箱 b_T_Ufp_Mail_Relation.setMailType(Long.valueOf(booleanToString(mailType))); b_T_Ufp_Mail_Relation.setReplyFlag(replyFlag); // 收邮件默认值:1 } } else { mailType = "2"; b_T_Ufp_Mail_Relation.setMailType(Long.valueOf(mailType)); // 存原稿保存至草稿箱 b_T_Ufp_Mail_Relation.setReplyFlag(3); // 存草稿箱标志:3 } b_T_Ufp_Mail_Relation.setIsNew(0); // 新邮件 b_T_Ufp_Mail_Relation.setMailAttributeId(uuid); b_T_Ufp_Mail_Relation.setMailContentId(uuid); b_T_Ufp_Mail_Relation.setReceiverTime(sendTime); // 未收邮件日期为发件日期 b_T_Ufp_Mail_Relation.setIsFile(Integer.valueOf(isFile)); // 有无附件标志 mapperMRT.insertSelective(b_T_Ufp_Mail_Relation); // 向邮件正文表添加 b_T_Ufp_Mail_Content.setUuid(uuid); mapperMCT.insertSelective(b_T_Ufp_Mail_Content); // 给所有收邮件人:收件人、抄送人和暗送人发邮件 String isuserxt = ""; if (StringTools.isNullOrNoValue(isPaper) || !"2".equals(isPaper)) { if (StringTools.isNotNullAndHasValue(allReceiverSysUser)) { String temps[] = allReceiverSysUser.split(","); String guid = null; for (String temp : temps) { if (isuserxt.indexOf(temp) < 0) { if (StringTools.isNotNullAndHasValue(temp.trim())) { guid = new GUID().toString(); addForAllRecUser(guid); String darkSysUser = b_T_Ufp_Mail_Attribute.getDarkSysUser(); // 循环变量值包含在暗送人中时,设置信息 if (darkSysUser.indexOf(temp) > -1) { b_T_Ufp_Mail_Attribute.setTipDarkInfo("你是这封邮件的密送人,所以不会显示在收件人中。"); } b_T_Ufp_Mail_Attribute.setUuid(guid); b_T_Ufp_Mail_Attribute.setSendTime(sendTime); b_T_Ufp_Mail_Attribute.setSendUser(sendUser); b_T_Ufp_Mail_Attribute.setSendSysUser(sendSysUser); b_T_Ufp_Mail_Attribute.setIsReceipt( Integer.valueOf(booleanToString(isReceipt))); // 回执 // b_T_Ufp_Mail_Attribute.setIsSendMsg(Integer.valueOf(booleanToString(isSendMsg)));//是否发送短消息 mapperMAT.insertSelective(b_T_Ufp_Mail_Attribute); // 向邮件联系表添加 b_T_Ufp_Mail_Relation.setUuid(guid); b_T_Ufp_Mail_Relation.setMailType( Long.valueOf("7")); // 7:发邮件时,发送给所有收邮件人(allReceiverSysUser)的邮件标志 b_T_Ufp_Mail_Relation.setIsNew(0); // 新邮件 b_T_Ufp_Mail_Relation.setMailAttributeId(guid); b_T_Ufp_Mail_Relation.setMailContentId(guid); b_T_Ufp_Mail_Relation.setReceiverTime(sendTime); // 未收邮件日期为发件日期 b_T_Ufp_Mail_Relation.setReplyFlag(replyFlag); // 收邮件默认值:1 b_T_Ufp_Mail_Relation.setIsFile(Integer.valueOf(isFile)); // 有无附件标志 b_T_Ufp_Mail_Relation.setSpecificRecsysUser(temp); // 设置指定收件人系统名 mapperMRT.insertSelective(b_T_Ufp_Mail_Relation); // 向邮件正文表添加 b_T_Ufp_Mail_Content.setUuid(guid); mapperMCT.insertSelective(b_T_Ufp_Mail_Content); } if (isuserxt.equals("")) { isuserxt += "," + temp + ","; } else { isuserxt += temp + ","; } } } } } returnMsg = Constants.SAVE_SUCCESSFUL_MSG; return returnMsg; }
/** * 回复,转发邮件 * * @param sqlSession * @param mapper * @param mapperRelation * @param mapperContent * @param record * @param recordRelation * @param recordContent * @param sendTime * @param sendUser * @param sendSysUser * @return * @throws IllegalAccessException * @throws UnsupportedEncodingException */ private String replyTrunMail( B_T_Ufp_Mail_Attribute record, B_T_Ufp_Mail_Relation recordRelation, B_T_Ufp_Mail_Content recordContent, String sendTime, String sendUser, String sendSysUser, C_T_Sys_FileExample example, C_T_Sys_FileExample.Criteria criteria) throws IllegalAccessException, UnsupportedEncodingException { String returnMsg; String uuid = new GUID().toString(); // 更新附件表的主文档ID String isFile = null; try { replyMailFile(example, criteria, uuid); criteria.andMainIdEqualTo(uuid); List<C_T_Sys_File> listFile = mapperFT.selectByExample(example); if (listFile != null) { if (listFile.size() > 0) { isFile = "1"; // 有附件 } else { isFile = "0"; // 没有附件 } } else { isFile = "0"; // 没有附件 } } catch (Exception e) { e.printStackTrace(); } // 收件人未收邮件 b_T_Ufp_Mail_Relation.setUuid(uuid); b_T_Ufp_Mail_Relation.setMailType(Long.valueOf(mailTypeS)); b_T_Ufp_Mail_Relation.setMailAttributeId(uuid); b_T_Ufp_Mail_Relation.setMailContentId(uuid); b_T_Ufp_Mail_Relation.setReceiverTime(sendTime); b_T_Ufp_Mail_Relation.setReplyFlag(1); // 正常回复 b_T_Ufp_Mail_Relation.setIsFile(Integer.valueOf(isFile)); // 有无附件 if (b_T_Ufp_Mail_Relation != null) { b_T_Ufp_Mail_Relation.setSpecificRecsysUser(b_T_Ufp_Mail_Relation.getUserId()); } mapperMRT.insertSelective(b_T_Ufp_Mail_Relation); // 插入邮件属性表 b_T_Ufp_Mail_Attribute.setUuid(uuid); b_T_Ufp_Mail_Attribute.setSendTime(sendTime); // 回复时:发件箱中的发送时间 b_T_Ufp_Mail_Attribute.setSendUser(sendUser); b_T_Ufp_Mail_Attribute.setSendSysUser(sendSysUser); b_T_Ufp_Mail_Attribute.setIsReceipt(Integer.valueOf(booleanToString(isReceipt))); // 回执选项 mapperMAT.insertSelective(b_T_Ufp_Mail_Attribute); // 插入邮件正文表 b_T_Ufp_Mail_Content.setUuid(uuid); mapperMCT.insertSelective(recordContent); // 发件箱显示 String newUuid = new GUID().toString(); String isNewFile = null; // 更新附件表的主文档ID try { replyMailFile(example, criteria, newUuid); example.clear(); criteria = example.createCriteria(); criteria.andMainIdEqualTo(newUuid); List<C_T_Sys_File> listFile = mapperFT.selectByExample(example); if (listFile != null) { if (listFile.size() > 0) { isNewFile = "1"; // 有附件 } else { isNewFile = "0"; // 没有附件 } } else { isNewFile = "0"; // 没有附件 } } catch (Exception e) { e.printStackTrace(); } b_T_Ufp_Mail_Relation.setUuid(newUuid); b_T_Ufp_Mail_Relation.setMailType(Long.valueOf("1")); b_T_Ufp_Mail_Relation.setMailAttributeId(uuid); b_T_Ufp_Mail_Relation.setMailContentId(uuid); b_T_Ufp_Mail_Relation.setReceiverTime(sendTime); b_T_Ufp_Mail_Relation.setReplyFlag(2); // 自己发的回复信息 b_T_Ufp_Mail_Relation.setIsFile(Integer.valueOf(isNewFile)); // 有无附件 mapperMRT.insertSelective(b_T_Ufp_Mail_Relation); // 插入邮件属性表 b_T_Ufp_Mail_Attribute.setUuid(newUuid); b_T_Ufp_Mail_Attribute.setSendTime(sendTime); // 回复时:发件箱中的发送时间 b_T_Ufp_Mail_Attribute.setSendUser(sendUser); b_T_Ufp_Mail_Attribute.setSendSysUser(sendSysUser); b_T_Ufp_Mail_Attribute.setIsReceipt(Integer.valueOf(booleanToString(isReceipt))); // 回执选项 b_T_Ufp_Mail_Attribute.setIsSendMsg(Integer.valueOf(booleanToString(isSendMsg))); // 是否发送短消息 mapperMAT.insertSelective(b_T_Ufp_Mail_Attribute); // 插入邮件正文表 b_T_Ufp_Mail_Content.setUuid(newUuid); mapperMCT.insertSelective(b_T_Ufp_Mail_Content); if ("0".equals(isReplyTrun)) { returnMsg = "回复成功!"; } else if ("1".equals(isReplyTrun)) { returnMsg = "转发成功!"; } else { returnMsg = Constants.SAVE_SUCCESSFUL_MSG; } return returnMsg; }