CRMFileRead.java 3.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990
  1. package com.miniframe.tools.file;
  2. import com.google.gson.Gson;
  3. import com.miniframe.core.ext.UtilTools;
  4. import com.miniframe.model.mdo.MdoProComval;
  5. import com.miniframe.model.mdo.MdoProComvalSQLBuilder;
  6. import com.miniframe.model.mdo.dao.MdoProComvalMapper;
  7. import com.miniframe.websocket.WebsocketEndPoint;
  8. import java.io.BufferedReader;
  9. import java.io.File;
  10. import java.io.FileReader;
  11. import java.io.IOException;
  12. import java.util.List;
  13. public class CRMFileRead {
  14. public static void readFile(File file, String pid) {
  15. MdoProComvalMapper comvalDao = UtilTools.getBean(MdoProComvalMapper.class);
  16. MdoProComvalSQLBuilder sb =new MdoProComvalSQLBuilder();
  17. MdoProComvalSQLBuilder.Criteria sc = sb.createCriteria();
  18. sc.andPidEqualTo(pid);
  19. sc.andTypeEqualTo(2);
  20. sb.setOrderByClause("step asc");
  21. List<MdoProComval> comvals =comvalDao.selectByExample(sb);
  22. int con =0;
  23. if(comvals!=null||!comvals.isEmpty()){
  24. con=comvals.size();
  25. }
  26. int i= 0;
  27. String line;
  28. // 使用try-with-resources语句确保资源被正确关闭
  29. try (BufferedReader br = new BufferedReader(new FileReader(file))) {
  30. int size=0;
  31. // 逐行读取,直到文件末尾
  32. while ((line = br.readLine()) != null) {
  33. line=line.trim().replaceAll("\\s+"," ").trim();//替换多个空格为一个空格
  34. if(line.startsWith("Zone")||line.startsWith("Title")){
  35. continue;
  36. }
  37. if(line.startsWith("DATAPACKING")){
  38. continue;
  39. }
  40. if(line.startsWith("Variables")){
  41. // line=line.replace("\"","");
  42. // line=line.replace("Variables =","").trim();
  43. continue;
  44. }
  45. if(line.startsWith("Nodes")){
  46. line=line.replace("Nodes = ","").trim();
  47. size =Integer.valueOf(line.split(" ")[0]);
  48. continue;
  49. }
  50. if(i>=size){
  51. break;
  52. }
  53. if(i>con && i<size){
  54. String[] vals = line.split(" ");
  55. MdoProComval comval =new MdoProComval();
  56. comval.setId(UtilTools.getUUid());
  57. comval.setPid(pid);
  58. comval.setStep(i);
  59. comval.setVars("v1 v2");
  60. comval.setVals(vals[0]+" "+vals[1]);
  61. comval.setType(2);//"1-列表数据 2-几何数据 3-压力数据"
  62. comvalDao.insert(comval);
  63. WebsocketEndPoint webs = (WebsocketEndPoint) UtilTools.getBean("websocketEndPoint");
  64. Gson gson = new Gson();
  65. webs.sendMessageToUser(String.valueOf(pid),gson.toJson(comval));
  66. MdoProComval comval2 =new MdoProComval();
  67. comval2.setId(UtilTools.getUUid());
  68. comval2.setPid(pid);
  69. comval2.setStep(i);
  70. comval2.setVars("x cp");
  71. comval2.setVals(vals[0]+" "+vals[9]);
  72. comval2.setType(3);//"1-列表数据 2-几何数据 3-压力数据"
  73. comvalDao.insert(comval2);
  74. webs.sendMessageToUser(String.valueOf(pid),gson.toJson(comval2));
  75. }
  76. i++;
  77. }
  78. } catch (IOException e) {
  79. // 异常处理
  80. e.printStackTrace();
  81. }
  82. }
  83. }