LogoutUserHelper.cs 3.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Threading;
  4. using System.Linq;
  5. using System.Data;
  6. using MySystem;
  7. using MySystem.PxcModels;
  8. using Library;
  9. using LitJson;
  10. public class LogoutUserHelper
  11. {
  12. public readonly static LogoutUserHelper Instance = new LogoutUserHelper();
  13. private LogoutUserHelper()
  14. {
  15. }
  16. public void Start()
  17. {
  18. Thread th = new Thread(DoWorks);
  19. th.IsBackground = true;
  20. th.Start();
  21. }
  22. // 判断已注销的创客在每月1号,分离创客表之后,伞下自动归到注销创客的上级
  23. public void DoWorks()
  24. {
  25. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "每月归档注销创客日志");
  26. WebCMSEntities db = new WebCMSEntities();
  27. OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["Pxc1SqlConnStr"].ToString();
  28. try
  29. {
  30. string Month = DateTime.Now.ToString("yyyyMM");
  31. string check = function.ReadInstance("/LogoutUser/" + Month + ".txt");
  32. if(string.IsNullOrEmpty(check))
  33. {
  34. function.WritePage("/LogoutUser/", Month + ".txt", DateTime.Now.ToString());
  35. var users = db.Users.Select(m => new { m.Id, m.ParentUserId, m.ParentNav, m.Status }).Where(m => m.Status == -1).ToList();
  36. foreach(var user in users)
  37. {
  38. int ParentUserId = user.ParentUserId;
  39. bool op = true;
  40. while(op)
  41. {
  42. Users puser = db.Users.FirstOrDefault(m => m.Id == user.ParentUserId);
  43. if(puser != null)
  44. {
  45. if(puser.Status > -1)
  46. {
  47. op = false;
  48. RelationForUserSub(db, user.Id, puser);
  49. db.SaveChanges();
  50. }
  51. else
  52. {
  53. ParentUserId = puser.ParentUserId;
  54. }
  55. }
  56. else
  57. {
  58. op = false;
  59. }
  60. }
  61. }
  62. }
  63. }
  64. catch (Exception ex)
  65. {
  66. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "每月归档注销创客异常");
  67. }
  68. db.Dispose();
  69. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "每月归档注销创客日志");
  70. }
  71. private void RelationForUserSub(WebCMSEntities db, int ParentUserId, Users puser)
  72. {
  73. var subusers = db.Users.Select(m => new { m.Id, m.ParentUserId, m.ParentNav }).Where(m => m.ParentUserId == ParentUserId).ToList();
  74. foreach (var subuser in subusers)
  75. {
  76. Users user = db.Users.FirstOrDefault(m => m.Id == subuser.Id);
  77. if (user != null)
  78. {
  79. user.ParentUserId = puser.Id;
  80. user.ParentNav = puser.ParentNav + "," + puser.Id + ",";
  81. RelationForUserSub(db, user.Id, user);
  82. }
  83. }
  84. }
  85. }