SycnJavaUsersService.cs 3.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using MySystem.PxcModels;
  5. using MySystem.JavaUserModels;
  6. using Library;
  7. using LitJson;
  8. using System.Threading;
  9. namespace MySystem
  10. {
  11. public class SycnJavaUsersService
  12. {
  13. public readonly static SycnJavaUsersService Instance = new SycnJavaUsersService();
  14. private SycnJavaUsersService()
  15. { }
  16. public void Start()
  17. {
  18. Thread th = new Thread(DoWorks);
  19. th.IsBackground = true;
  20. th.Start();
  21. }
  22. public void DoWorks()
  23. {
  24. while (true)
  25. {
  26. try
  27. {
  28. DoQueue();
  29. }
  30. catch (Exception ex)
  31. {
  32. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "同步创客信息异常");
  33. }
  34. Thread.Sleep(1800000);
  35. }
  36. }
  37. public void DoQueue()
  38. {
  39. JavaUserModels.WebCMSEntities javaUser = new JavaUserModels.WebCMSEntities();
  40. PxcModels.WebCMSEntities db = new PxcModels.WebCMSEntities();
  41. DateTime start = DateTime.Now.AddMonths(-3);
  42. DateTime end = DateTime.Now.AddHours(-1);
  43. IQueryable<JavaUserModels.KxsUser> kxsUser = javaUser.KxsUser.Where(m => m.CreateTime >= start && m.CreateTime < end);
  44. int minId = kxsUser.Min(m => m.Id);
  45. int maxId = kxsUser.Max(m => m.Id);
  46. List<int> checkUserIds = db.Users.Select(m => m.Id).Where(m => m >= minId && m <= maxId).ToList();
  47. var users = javaUser.KxsUser.Where(m => m.Id >= minId && m.Id <= maxId && !checkUserIds.Contains(m.Id)).ToList();
  48. function.WriteLog("\n\n\n同步数量:" + users.Count(), "同步创客基本信息");
  49. foreach(var user in users)
  50. {
  51. function.WriteLog(Newtonsoft.Json.JsonConvert.SerializeObject(user), "同步创客基本信息");
  52. int id = user.Id;
  53. int pid = user.Pid;
  54. string pidPath = user.PidPath;
  55. DateTime CreateDate = user.CreateTime.Value;
  56. string MakerCode = user.UserCode;
  57. string Mobile = user.Phone;
  58. string RealName = user.Username;
  59. string HeadPhoto = user.Avatar;
  60. Users edit = db.Users.FirstOrDefault(m => m.Mobile == Mobile);
  61. if(edit != null)
  62. {
  63. db.Users.Remove(edit);
  64. }
  65. UserForMobile forMobile = db.UserForMobile.FirstOrDefault(m => m.Mobile == Mobile);
  66. if(forMobile != null)
  67. {
  68. db.UserForMobile.Remove(forMobile);
  69. }
  70. UserForMakerCode forMakerCode = db.UserForMakerCode.FirstOrDefault(m => m.MakerCode == MakerCode);
  71. if(forMakerCode != null)
  72. {
  73. db.UserForMakerCode.Remove(forMakerCode);
  74. }
  75. db.SaveChanges();
  76. Users add = db.Users.Add(new Users()
  77. {
  78. Id = id,
  79. ParentUserId = pid,
  80. ParentNav = pidPath,
  81. CreateDate = CreateDate,
  82. MakerCode = MakerCode,
  83. Mobile = Mobile,
  84. RealName = RealName,
  85. HeadPhoto = HeadPhoto,
  86. }).Entity;
  87. db.SaveChanges();
  88. db.UserForMobile.Add(new UserForMobile()
  89. {
  90. Mobile = Mobile,
  91. UserId = add.Id
  92. });
  93. db.UserForMakerCode.Add(new UserForMakerCode()
  94. {
  95. MakerCode = MakerCode,
  96. UserId = add.Id
  97. });
  98. db.SaveChanges();
  99. }
  100. javaUser.Dispose();
  101. db.Dispose();
  102. }
  103. }
  104. }