DepositReturnStatService.cs 5.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132
  1. using System;
  2. using System.Collections.Generic;
  3. using Library;
  4. using LitJson;
  5. using System.Linq;
  6. using System.Data;
  7. using System.Threading;
  8. using MySystem.PxcModels;
  9. namespace MySystem
  10. {
  11. public class DepositReturnStatService
  12. {
  13. public readonly static DepositReturnStatService Instance = new DepositReturnStatService();
  14. private DepositReturnStatService()
  15. { }
  16. public void Start()
  17. {
  18. Thread th = new Thread(StartEverDay);
  19. th.IsBackground = true;
  20. th.Start();
  21. }
  22. public void StartEverDay()
  23. {
  24. while(true)
  25. {
  26. if(DateTime.Now.Day <= 15 && DateTime.Now.Hour > 1 && DateTime.Now.Hour < 13)
  27. {
  28. try
  29. {
  30. StartEverDayDo();
  31. }
  32. catch(Exception ex)
  33. {
  34. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "每月统计押金达标数据异常");
  35. }
  36. }
  37. Thread.Sleep(60000);
  38. }
  39. }
  40. public void StartEverDayDo()
  41. {
  42. string Month = DateTime.Now.ToString("yyyyMM");
  43. string chk = function.ReadInstance("/DepositReturn/" + Month + ".txt");
  44. if(!string.IsNullOrEmpty(chk))
  45. {
  46. return;
  47. }
  48. function.WritePage("/DepositReturn/", Month + ".txt", DateTime.Now.ToString());
  49. WebCMSEntities db = new WebCMSEntities();
  50. int startid = int.Parse(function.CheckInt(function.ReadInstance("/DepositReturn/" + Month + "MerchantId.txt")));
  51. bool op = true;
  52. while(op)
  53. {
  54. List<PosMerchantInfo> merchants = db.PosMerchantInfo.Where(m => m.Id > startid && m.ActiveStatus == 1 && m.StandardStatus == 0).OrderBy(m => m.Id).Take(50).ToList();
  55. if(merchants.Count > 0)
  56. {
  57. foreach(PosMerchantInfo merchant in merchants)
  58. {
  59. function.WriteLog("商户ID:" + merchant.Id, "每月统计押金达标情况");
  60. // string start = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff");
  61. int StandardMonths = merchant.StandardMonths;
  62. int StandardStatus = merchant.StandardStatus;
  63. function.WriteLog("StandardMonths:" + StandardMonths, "每月统计押金达标情况");
  64. function.WriteLog("StandardStatus:" + StandardStatus, "每月统计押金达标情况");
  65. DateTime ActDate = merchant.CreateDate.Value;
  66. if(merchant.MerStandardDate == null)
  67. {
  68. PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.PosSn == merchant.KqSnNo && m.ActivationState == 1 && m.ActivationTime != null);
  69. if(pos != null)
  70. {
  71. ActDate = pos.ActivationTime.Value;
  72. }
  73. }
  74. else
  75. {
  76. ActDate = merchant.MerStandardDate.Value;
  77. }
  78. int MonthNum = StandardMonths;
  79. for (int i = StandardMonths + 1; i <= 10; i++)
  80. {
  81. string TradeMonth = ActDate.AddMonths(i).ToString("yyyyMM");
  82. if(int.Parse(TradeMonth) < int.Parse(DateTime.Now.ToString("yyyyMM")))
  83. {
  84. decimal TradeAmount = 0;
  85. bool CheckAmount = db.PosMerchantTradeSummay.Any(m => m.MerchantId == merchant.Id && m.TradeMonth == TradeMonth);
  86. if(CheckAmount)
  87. {
  88. TradeAmount = db.PosMerchantTradeSummay.Where(m => m.MerchantId == merchant.Id && m.TradeMonth == TradeMonth).Sum(m => m.TradeAmount);
  89. }
  90. if(TradeAmount >= 10000)
  91. {
  92. MonthNum = i;
  93. }
  94. else
  95. {
  96. StandardStatus = -1;
  97. break;
  98. }
  99. }
  100. }
  101. function.WriteLog("MonthNum:" + MonthNum, "每月统计押金达标情况");
  102. if(MonthNum >= 10)
  103. {
  104. StandardStatus = 4;
  105. }
  106. function.WriteLog("StandardStatus:" + StandardStatus + "\n\n", "每月统计押金达标情况");
  107. PosMerchantInfo edit = db.PosMerchantInfo.FirstOrDefault(m => m.Id == merchant.Id);
  108. if(edit != null)
  109. {
  110. edit.StandardMonths = MonthNum;
  111. edit.StandardStatus = StandardStatus;
  112. db.SaveChanges();
  113. }
  114. // string end = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff");
  115. startid = merchant.Id;
  116. }
  117. }
  118. else
  119. {
  120. op = false;
  121. }
  122. function.WritePage("/DepositReturn/", Month + "MerchantId.txt", startid.ToString());
  123. }
  124. db.Dispose();
  125. }
  126. }
  127. }