ProfitCheckHelper.cs 36 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Data;
  5. using MySystem.PxcModels;
  6. using Library;
  7. using LitJson;
  8. namespace MySystem
  9. {
  10. public class ProfitCheckHelper
  11. {
  12. public readonly static ProfitCheckHelper Instance = new ProfitCheckHelper();
  13. private ProfitCheckHelper()
  14. { }
  15. public void Start()
  16. {
  17. try
  18. {
  19. function.WriteLog("导出分润:" + DateTime.Now.ToString(), "分润结果检查");
  20. ExportProfitData(); //导出分润
  21. function.WriteLog("导出补贴:" + DateTime.Now.ToString(), "分润结果检查");
  22. ExportSubsidyData(); //导出补贴
  23. // function.WriteLog("检查分润:" + DateTime.Now.ToString(), "分润结果检查");
  24. // CheckProfit(); //检查分润
  25. // function.WriteLog("检查补贴:" + DateTime.Now.ToString(), "分润结果检查");
  26. // CheckSubsidy(); //检查补贴
  27. function.WriteLog("结束:" + DateTime.Now.ToString(), "分润结果检查");
  28. }
  29. catch (Exception ex)
  30. {
  31. function.WriteLog(DateTime.Now.ToString() + ":" + ex.ToString(), "分润结果检查异常");
  32. }
  33. }
  34. public void ExportProfitData()
  35. {
  36. string Month = DateTime.Now.AddMonths(-1).ToString("yyyyMM");
  37. WebCMSEntities db = new WebCMSEntities();
  38. string StartId = function.CheckInt(function.ReadInstance("/PublicParam/ProfitRewardRecordId/" + Month + ".txt"));
  39. OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["ReadSqlConnStr"].ToString();
  40. string sql = "select tb.MakerCode,tb.RealName,tb.UserLevel,tu.MakerCode tMakerCode,tu.RealName tRealName,Rank,DirectFlag,Name,BrandId,CreditTradeAmt,CreditTradeProfit,QrCreditTradeAmt,QrCreditTradeProfit,NonQrCreditTradeAmt,NonQrCreditTradeProfit,HelpCreditTradeAmt,HelpCreditTradeProfit,NotHelpCreditTradeAmt,NotHelpCreditTradeProfit,ProfitCreditTradeAmt,ProfitCreditTradeProfit,ProfitCreditTradeAmt2,ProfitCreditTradeProfit2,DebitTradeAmt,DebitTradeProfit from (select u.MakerCode,u.RealName,u.UserLevel,SUBSTRING_INDEX(SUBSTRING_INDEX(u.ParentNav,',',4),',',-1) as TopUserId,r.Rank,(case when ProfitType=1 then '直营' else '团队' end) as DirectFlag,k.Name,BrandId,CreditTradeAmt,CreditTradeProfit,QrCreditTradeAmt,QrCreditTradeProfit,NonQrCreditTradeAmt,NonQrCreditTradeProfit,HelpCreditTradeAmt,HelpCreditTradeProfit,NotHelpCreditTradeAmt,NotHelpCreditTradeProfit,ProfitCreditTradeAmt,ProfitCreditTradeProfit,ProfitCreditTradeAmt2,ProfitCreditTradeProfit2,DebitTradeAmt,DebitTradeProfit from (select UserId,ProfitType,BrandId,sum(CreditTradeAmt) as CreditTradeAmt,sum(CreditTradeProfit) as CreditTradeProfit,sum(QrCreditTradeAmt) as QrCreditTradeAmt,sum(QrCreditTradeProfit) as QrCreditTradeProfit,sum(NonQrCreditTradeAmt) as NonQrCreditTradeAmt,sum(NonQrCreditTradeProfit) as NonQrCreditTradeProfit,sum(HelpCreditTradeAmt) as HelpCreditTradeAmt,sum(HelpCreditTradeProfit) as HelpCreditTradeProfit,sum(NotHelpCreditTradeAmt) as NotHelpCreditTradeAmt,sum(NotHelpCreditTradeProfit) as NotHelpCreditTradeProfit,sum(ProfitCreditTradeAmt) as ProfitCreditTradeAmt,sum(ProfitCreditTradeProfit) as ProfitCreditTradeProfit,sum(ProfitCreditTradeAmt2) as ProfitCreditTradeAmt2,sum(ProfitCreditTradeProfit2) as ProfitCreditTradeProfit2,sum(DebitNonCapTradeAmt+DebitCapTradeAmt) as DebitTradeAmt,sum(DebitNonTradeCapProfit+DebitTradeCapProfit) as DebitTradeProfit from ProfitRewardRecord where Id>=" + StartId + " and TradeMonth='" + Month + "' GROUP BY UserId,ProfitType,BrandId) tb left join Users u on tb.UserId=u.Id LEFT JOIN KqProducts k ON k.Id=tb.BrandId left join UserRankWhite r on u.Id=r.Id and r.CreateDate<'" + DateTime.Now.ToString("yyyy-MM") + " 00:00:00' and r.UpdateDate>'" + DateTime.Now.ToString("yyyy-MM") + " 00:00:00' ORDER BY u.MakerCode) tb left join Users tu on tb.TopUserId=tu.Id";
  41. DataTable dt = OtherMySqlConn.dtable(sql);
  42. function.WriteLog(DateTime.Now.ToString() + ":" + dt.Rows.Count, "分润结果检查");
  43. int index = 0;
  44. foreach(DataRow dr in dt.Rows)
  45. {
  46. index += 1;
  47. string MakerCode = dr["MakerCode"].ToString();
  48. string RealName = dr["RealName"].ToString();
  49. string tMakerCode = dr["tMakerCode"].ToString();
  50. string tRealName = dr["tRealName"].ToString();
  51. int UserLevel = int.Parse(function.CheckInt(dr["UserLevel"].ToString()));
  52. int Rank = int.Parse(function.CheckInt(dr["Rank"].ToString()));
  53. string DirectFlag = dr["DirectFlag"].ToString();
  54. string BrandName = dr["Name"].ToString();
  55. int BrandId = int.Parse(function.CheckInt(dr["BrandId"].ToString()));
  56. decimal CreditTradeAmt = decimal.Parse(function.CheckNum(dr["CreditTradeAmt"].ToString()));
  57. decimal CreditTradeProfit = decimal.Parse(function.CheckNum(dr["CreditTradeProfit"].ToString()));
  58. decimal QrCreditTradeAmt = decimal.Parse(function.CheckNum(dr["QrCreditTradeAmt"].ToString()));
  59. decimal QrCreditTradeProfit = decimal.Parse(function.CheckNum(dr["QrCreditTradeProfit"].ToString()));
  60. decimal NonQrCreditTradeAmt = decimal.Parse(function.CheckNum(dr["NonQrCreditTradeAmt"].ToString()));
  61. decimal NonQrCreditTradeProfit = decimal.Parse(function.CheckNum(dr["NonQrCreditTradeProfit"].ToString()));
  62. decimal HelpCreditTradeAmt = decimal.Parse(function.CheckNum(dr["HelpCreditTradeAmt"].ToString()));
  63. decimal HelpCreditTradeProfit = decimal.Parse(function.CheckNum(dr["HelpCreditTradeProfit"].ToString()));
  64. decimal NotHelpCreditTradeAmt = decimal.Parse(function.CheckNum(dr["NotHelpCreditTradeAmt"].ToString()));
  65. decimal NotHelpCreditTradeProfit = decimal.Parse(function.CheckNum(dr["NotHelpCreditTradeProfit"].ToString()));
  66. decimal ProfitCreditTradeAmt = decimal.Parse(function.CheckNum(dr["ProfitCreditTradeAmt"].ToString()));
  67. decimal ProfitCreditTradeProfit = decimal.Parse(function.CheckNum(dr["ProfitCreditTradeProfit"].ToString()));
  68. decimal ProfitCreditTradeAmt2 = decimal.Parse(function.CheckNum(dr["ProfitCreditTradeAmt2"].ToString()));
  69. decimal ProfitCreditTradeProfit2 = decimal.Parse(function.CheckNum(dr["ProfitCreditTradeProfit2"].ToString()));
  70. decimal DebitTradeAmt = decimal.Parse(function.CheckNum(dr["DebitTradeAmt"].ToString()));
  71. decimal DebitTradeProfit = decimal.Parse(function.CheckNum(dr["DebitTradeProfit"].ToString()));
  72. db.ProfitRewardExport.Add(new ProfitRewardExport()
  73. {
  74. CreateDate = DateTime.Now,
  75. Sort = BrandId,
  76. SeoTitle = Month,
  77. MakerCode = MakerCode,
  78. RealName = RealName,
  79. SeoKeyword = tMakerCode,
  80. SeoDescription = tRealName,
  81. UserLevel = UserLevel,
  82. Rank = Rank,
  83. DirectFlag = DirectFlag,
  84. BrandName = BrandName,
  85. CreditTradeAmt = CreditTradeAmt,
  86. CreditTradeProfit = CreditTradeProfit,
  87. QrCreditTradeAmt = QrCreditTradeAmt,
  88. QrCreditTradeProfit = QrCreditTradeProfit,
  89. NonQrCreditTradeAmt = NonQrCreditTradeAmt,
  90. NonQrCreditTradeProfit = NonQrCreditTradeProfit,
  91. HelpCreditTradeAmt = HelpCreditTradeAmt,
  92. HelpCreditTradeProfit = HelpCreditTradeProfit,
  93. NotHelpCreditTradeAmt = NotHelpCreditTradeAmt,
  94. NotHelpCreditTradeProfit = NotHelpCreditTradeProfit,
  95. ProfitCreditTradeAmt = ProfitCreditTradeAmt,
  96. ProfitCreditTradeProfit = ProfitCreditTradeProfit,
  97. ProfitCreditTradeAmt2 = ProfitCreditTradeAmt2,
  98. ProfitCreditTradeProfit2 = ProfitCreditTradeProfit2,
  99. DebitTradeAmt = DebitTradeAmt,
  100. DebitTradeProfit = DebitTradeProfit,
  101. });
  102. if(index % 200 == 0)
  103. {
  104. db.SaveChanges();
  105. }
  106. function.WriteLog(DateTime.Now.ToString() + ":" + index, "分润结果检查");
  107. }
  108. db.SaveChanges();
  109. db.Dispose();
  110. }
  111. public void ExportSubsidyData()
  112. {
  113. string Month = DateTime.Now.AddMonths(-1).ToString("yyyyMM");
  114. WebCMSEntities db = new WebCMSEntities();
  115. string StartId = function.CheckInt(function.ReadInstance("/PublicParam/ProfitSubsidyDetailId/" + Month + ".txt"));
  116. OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["ReadSqlConnStr"].ToString();
  117. DataTable dt = OtherMySqlConn.dtable("select u.MakerCode,u.RealName,u.UserLevel,r.Rank,m.KqSnNo,m.MerchantName,(case when SubsidyType=1 then '直营' else '团队' end) as DirectFlag,k.Name,tb.BrandId,CreditTradeAmt,SubsidyProfit from (select SubsidyUserId,MerchantId,BrandId,SubsidyType,sum(CreditTradeAmt) as CreditTradeAmt,sum(SubsidyProfitRate) as SubsidyProfit from ProfitSubsidyDetail where Id>=" + StartId + " and TradeMonth='" + Month + "' GROUP BY SubsidyUserId,MerchantId,BrandId,SubsidyType) tb left join Users u on tb.SubsidyUserId=u.Id LEFT JOIN KqProducts k ON k.Id=tb.BrandId left join PosMerchantInfo m on tb.MerchantId=m.Id left join UserRankWhite r on u.Id=r.Id and r.CreateDate<'" + DateTime.Now.ToString("yyyy-MM") + "-01 00:00:00' and r.UpdateDate>'" + DateTime.Now.ToString("yyyy-MM") + "-01 00:00:00'");
  118. function.WriteLog(DateTime.Now.ToString() + ":" + dt.Rows.Count, "分润结果检查");
  119. int index = 0;
  120. foreach(DataRow dr in dt.Rows)
  121. {
  122. index += 1;
  123. string MakerCode = dr["MakerCode"].ToString();
  124. string RealName = dr["RealName"].ToString();
  125. int UserLevel = int.Parse(function.CheckInt(dr["UserLevel"].ToString()));
  126. int Rank = int.Parse(function.CheckInt(dr["Rank"].ToString()));
  127. string KqSnNo = dr["KqSnNo"].ToString();
  128. string MerchantName = dr["MerchantName"].ToString();
  129. string DirectFlag = dr["DirectFlag"].ToString();
  130. string BrandName = dr["Name"].ToString();
  131. int BrandId = int.Parse(function.CheckInt(dr["BrandId"].ToString()));
  132. decimal CreditTradeAmt = decimal.Parse(function.CheckNum(dr["CreditTradeAmt"].ToString()));
  133. decimal SubsidyProfit = decimal.Parse(function.CheckNum(dr["SubsidyProfit"].ToString()));
  134. db.ProfitSubsidyExport.Add(new ProfitSubsidyExport()
  135. {
  136. CreateDate = DateTime.Now,
  137. Sort = BrandId,
  138. SeoTitle = Month,
  139. MakerCode = MakerCode,
  140. RealName = RealName,
  141. UserLevel = UserLevel,
  142. Rank = Rank,
  143. KqSnNo = KqSnNo,
  144. MerchantName = MerchantName,
  145. DirectFlag = DirectFlag,
  146. BrandName = BrandName,
  147. CreditTradeAmt = CreditTradeAmt,
  148. SubsidyProfit = SubsidyProfit,
  149. });
  150. if(index % 200 == 0)
  151. {
  152. db.SaveChanges();
  153. }
  154. function.WriteLog(DateTime.Now.ToString() + ":" + index, "分润结果检查");
  155. }
  156. db.SaveChanges();
  157. db.Dispose();
  158. }
  159. public void CheckProfit()
  160. {
  161. DateTime now = DateTime.Now;
  162. string Month = DateTime.Now.AddMonths(-1).ToString("yyyyMM");
  163. WebCMSEntities db = new WebCMSEntities();
  164. bool checkOp = true;
  165. int StartId = 0;
  166. while(checkOp)
  167. {
  168. List<int> ids = new List<int>();
  169. List<ProfitRewardExport> list = db.ProfitRewardExport.Where(m => m.SeoTitle == Month && m.Id > StartId && m.Status == 0).OrderBy(m => m.MakerCode).ThenBy(m => m.DirectFlag).ThenBy(m => m.BrandName).ThenBy(m => m.Id).Take(50).ToList();
  170. function.WriteLog(DateTime.Now.ToString() + ":" + list.Count, "分润结果检查");
  171. if(list.Count > 0)
  172. {
  173. int index = 0;
  174. foreach(ProfitRewardExport sub in list)
  175. {
  176. index += 1;
  177. int BrandId = sub.Sort;
  178. string MakerCode = sub.MakerCode;
  179. decimal TotalProfit = 0;
  180. UserForMakerCode userForMakerCode = db.UserForMakerCode.FirstOrDefault(m => m.MakerCode == MakerCode) ?? new UserForMakerCode();
  181. int UserId = userForMakerCode.UserId;
  182. Users user = db.Users.FirstOrDefault(m => m.Id == UserId);
  183. if(user == null)
  184. {
  185. user = db.Users.FirstOrDefault(m => m.MakerCode == MakerCode) ?? new Users();
  186. UserId = user.Id;
  187. }
  188. string LogString = function.ReadInstance("/ProfitDetailLog/" + Month + "/" + UserId + ".txt");
  189. LogString += "创客编号:" + user.MakerCode + ",创客名称:" + user.RealName + "\n";
  190. int UserLevel = GetLevel(db, UserId, user.UserLevel);
  191. LogString += "创客职级:K" + UserLevel + "\n";
  192. LogString += "分润类型:" + sub.DirectFlag + "\n";
  193. LogString += "分润品牌:" + sub.BrandName + "\n";
  194. if(sub.DirectFlag == "直营")
  195. {
  196. decimal HelpTradeAmt = 0;
  197. decimal NotHelpTradeAmt = 0;
  198. decimal ProfitTradeAmt = 0;
  199. decimal HelpProfit = 0;
  200. decimal NotHelpProfit = 0;
  201. decimal ProfitProfit = 0;
  202. bool check = db.TradeDaySummary.Any(m => m.UserId == user.Id && m.TradeMonth == Month && m.BrandId == BrandId && m.SeoTitle == "self" && m.HelpDirectTradeAmt > 0);
  203. if(check)
  204. {
  205. HelpTradeAmt = db.TradeDaySummary.Where(m => m.UserId == user.Id && m.TradeMonth == Month && m.BrandId == BrandId && m.SeoTitle == "self").Sum(m => m.HelpDirectTradeAmt);
  206. }
  207. LogString += "扶持期交易额:" + HelpTradeAmt + "\n";
  208. check = db.TradeDaySummary.Any(m => m.UserId == user.Id && m.TradeMonth == Month && m.BrandId == BrandId && m.SeoTitle == "self" && m.NotHelpDirectTradeAmt > 0);
  209. if(check)
  210. {
  211. NotHelpTradeAmt = db.TradeDaySummary.Where(m => m.UserId == user.Id && m.TradeMonth == Month && m.BrandId == BrandId && m.SeoTitle == "self").Sum(m => m.NotHelpDirectTradeAmt);
  212. }
  213. LogString += "稳定期交易额:" + NotHelpTradeAmt + "\n";
  214. check = db.TradeDaySummary.Any(m => m.UserId == user.Id && m.TradeMonth == Month && m.BrandId == BrandId && m.SeoTitle == "self" && m.ProfitDirectTradeAmt > 0);
  215. if(check)
  216. {
  217. ProfitTradeAmt = db.TradeDaySummary.Where(m => m.UserId == user.Id && m.TradeMonth == Month && m.BrandId == BrandId && m.SeoTitle == "self").Sum(m => m.ProfitDirectTradeAmt);
  218. }
  219. LogString += "盈利期交易额:" + ProfitTradeAmt + "\n";
  220. if(HelpTradeAmt > 0)
  221. {
  222. decimal percent = GetLevelProfit(BrandId, UserLevel, 1);
  223. HelpProfit = HelpTradeAmt * percent;
  224. LogString += "扶持期分润:" + HelpTradeAmt + " * " + percent + " = " + HelpProfit + "\n";
  225. }
  226. if(NotHelpTradeAmt > 0)
  227. {
  228. decimal percent = GetLevelProfit(BrandId, UserLevel, 0);
  229. NotHelpProfit = NotHelpTradeAmt * percent;
  230. LogString += "稳定期分润:" + NotHelpTradeAmt + " * " + percent + " = " + NotHelpProfit + "\n";
  231. }
  232. if(ProfitTradeAmt > 0)
  233. {
  234. decimal percent = GetLevelProfit(BrandId, UserLevel, 2);
  235. ProfitProfit = ProfitTradeAmt * percent;
  236. LogString += "盈利期分润:" + ProfitTradeAmt + " * " + percent + " = " + ProfitProfit + "\n";
  237. }
  238. TotalProfit += HelpProfit + NotHelpProfit + ProfitProfit;
  239. LogString += "总分润:" + TotalProfit + "\n";
  240. }
  241. else
  242. {
  243. var subusers = db.Users.Select(m => new { m.Id, m.ParentUserId, m.AuthFlag }).Where(m => m.ParentUserId == UserId && m.AuthFlag == 1).ToList();
  244. LogString += "直推人数:" + subusers.Count + "\n";
  245. foreach(var subuser in subusers)
  246. {
  247. Users suser = db.Users.FirstOrDefault(m => m.Id == subuser.Id) ?? new Users();
  248. LogString += "直推创客编号:" + suser.MakerCode + ",直推创客名称:" + suser.RealName + "\n";
  249. int sUserLevel = GetLevel(db, subuser.Id, suser.UserLevel);
  250. LogString += "直推创客职级:K" + sUserLevel + "\n";
  251. if(sUserLevel < UserLevel)
  252. {
  253. decimal HelpTradeAmt = 0;
  254. decimal NotHelpTradeAmt = 0;
  255. decimal ProfitTradeAmt = 0;
  256. decimal HelpProfit = 0;
  257. decimal NotHelpProfit = 0;
  258. decimal ProfitProfit = 0;
  259. bool check = db.TradeDaySummary.Any(m => m.UserId == subuser.Id && m.TradeMonth == Month && m.BrandId == BrandId && m.SeoTitle == "team" && m.HelpNonDirectTradeAmt > 0);
  260. if(check)
  261. {
  262. HelpTradeAmt = db.TradeDaySummary.Where(m => m.UserId == subuser.Id && m.TradeMonth == Month && m.BrandId == BrandId && m.SeoTitle == "team").Sum(m => m.HelpNonDirectTradeAmt);
  263. }
  264. LogString += "扶持期交易额:" + HelpTradeAmt + "\n";
  265. check = db.TradeDaySummary.Any(m => m.UserId == subuser.Id && m.TradeMonth == Month && m.BrandId == BrandId && m.SeoTitle == "team" && m.NotHelpNonDirectTradeAmt > 0);
  266. if(check)
  267. {
  268. NotHelpTradeAmt = db.TradeDaySummary.Where(m => m.UserId == subuser.Id && m.TradeMonth == Month && m.BrandId == BrandId && m.SeoTitle == "team").Sum(m => m.NotHelpNonDirectTradeAmt);
  269. }
  270. LogString += "稳定期交易额:" + NotHelpTradeAmt + "\n";
  271. check = db.TradeDaySummary.Any(m => m.UserId == subuser.Id && m.TradeMonth == Month && m.BrandId == BrandId && m.SeoTitle == "team" && m.ProfitNonDirectTradeAmt > 0);
  272. if(check)
  273. {
  274. ProfitTradeAmt = db.TradeDaySummary.Where(m => m.UserId == subuser.Id && m.TradeMonth == Month && m.BrandId == BrandId && m.SeoTitle == "team").Sum(m => m.ProfitNonDirectTradeAmt);
  275. }
  276. LogString += "盈利期交易额:" + ProfitTradeAmt + "\n";
  277. string UserIdString = "," + subuser.Id + ",";
  278. List<Users> busers = db.Users.Where(m => m.ParentNav.Contains(UserIdString) && m.AuthFlag == 1).ToList();
  279. List<ProfitUsers> busernavs = new List<ProfitUsers>();
  280. foreach (var buser in busers)
  281. {
  282. int bUserLevel = GetLevel(db, buser.Id, buser.UserLevel);
  283. if(bUserLevel >= UserLevel)
  284. {
  285. busernavs.Add(new ProfitUsers()
  286. {
  287. UserId = buser.Id,
  288. UserLevel = bUserLevel,
  289. UserNav = buser.ParentNav,
  290. MakerCode = buser.MakerCode,
  291. RealName = buser.RealName,
  292. });
  293. }
  294. if(bUserLevel > sUserLevel)
  295. {
  296. sUserLevel = bUserLevel;
  297. }
  298. }
  299. string LogHelpTradeAmt = HelpTradeAmt.ToString();
  300. string LogNotHelpTradeAmt = NotHelpTradeAmt.ToString();
  301. string LogProfitTradeAmt = ProfitTradeAmt.ToString();
  302. if(busernavs.Count > 0)
  303. {
  304. LogString += "团队中等级超过K" + UserLevel + ":\n";
  305. LogString += "..................\n";
  306. List<string> ParentNavs = new List<string>();
  307. busernavs = busernavs.OrderBy(m => m.UserNav).ToList();
  308. foreach(ProfitUsers busernav in busernavs)
  309. {
  310. bool op = true; //是否满足条件
  311. string ParentNav = busernav.UserNav + "," + busernav.UserId + ",";
  312. foreach (string subNav in ParentNavs)
  313. {
  314. if (ParentNav.StartsWith(subNav) && ParentNav != subNav)
  315. {
  316. op = false;
  317. }
  318. }
  319. if(op)
  320. {
  321. bool OtherCheck = db.TradeDaySummary.Any(m => m.UserId == busernav.UserId && m.TradeMonth == Month && m.BrandId == BrandId && m.SeoTitle == "team" && m.HelpNonDirectTradeAmt > 0);
  322. decimal OtherHelpTradeAmt = 0;
  323. decimal OtherNotHelpTradeAmt = 0;
  324. decimal OtherProfitTradeAmt = 0;
  325. if(OtherCheck)
  326. {
  327. OtherHelpTradeAmt = db.TradeDaySummary.Where(m => m.UserId == busernav.UserId && m.TradeMonth == Month && m.BrandId == BrandId && m.SeoTitle == "team").Sum(m => m.HelpNonDirectTradeAmt);
  328. }
  329. OtherCheck = db.TradeDaySummary.Any(m => m.UserId == busernav.UserId && m.TradeMonth == Month && m.BrandId == BrandId && m.SeoTitle == "team" && m.NotHelpNonDirectTradeAmt > 0);
  330. if(OtherCheck)
  331. {
  332. OtherNotHelpTradeAmt = db.TradeDaySummary.Where(m => m.UserId == busernav.UserId && m.TradeMonth == Month && m.BrandId == BrandId && m.SeoTitle == "team").Sum(m => m.NotHelpNonDirectTradeAmt);
  333. }
  334. OtherCheck = db.TradeDaySummary.Any(m => m.UserId == busernav.UserId && m.TradeMonth == Month && m.BrandId == BrandId && m.SeoTitle == "team" && m.ProfitNonDirectTradeAmt > 0);
  335. if(OtherCheck)
  336. {
  337. OtherProfitTradeAmt = db.TradeDaySummary.Where(m => m.UserId == busernav.UserId && m.TradeMonth == Month && m.BrandId == BrandId && m.SeoTitle == "team").Sum(m => m.ProfitNonDirectTradeAmt);
  338. }
  339. HelpTradeAmt -= OtherHelpTradeAmt;
  340. NotHelpTradeAmt -= OtherNotHelpTradeAmt;
  341. ProfitTradeAmt -= OtherProfitTradeAmt;
  342. LogString += "\n----创客编号:" + busernav.MakerCode + ",创客名称:" + busernav.RealName + "\n";
  343. LogString += "----创客职级:" + busernav.UserLevel + "\n";
  344. LogString += "----扶持期交易额:" + OtherHelpTradeAmt + "\n";
  345. LogString += "----稳定期交易额:" + OtherNotHelpTradeAmt + "\n";
  346. LogString += "----盈利期交易额:" + OtherProfitTradeAmt + "\n";
  347. if(OtherHelpTradeAmt > 0)
  348. {
  349. LogHelpTradeAmt += " - " + OtherHelpTradeAmt;
  350. }
  351. if(OtherNotHelpTradeAmt > 0)
  352. {
  353. LogNotHelpTradeAmt += " - " + OtherNotHelpTradeAmt;
  354. }
  355. if(OtherProfitTradeAmt > 0)
  356. {
  357. LogProfitTradeAmt += " - " + OtherProfitTradeAmt;
  358. }
  359. }
  360. ParentNavs.Add(ParentNav);
  361. }
  362. }
  363. if(HelpTradeAmt > 0)
  364. {
  365. decimal parentpercent = GetLevelProfit(BrandId, UserLevel, 1);
  366. decimal percent = GetLevelProfit(BrandId, sUserLevel, 1);
  367. HelpProfit = HelpTradeAmt * (parentpercent - percent);
  368. if(LogHelpTradeAmt.Contains("-"))
  369. {
  370. LogHelpTradeAmt = "(" + LogHelpTradeAmt + ")";
  371. }
  372. LogString += "扶持期分润:" + LogHelpTradeAmt + " * (" + parentpercent + " - " + percent + ") = " + HelpProfit + "\n";
  373. }
  374. if(NotHelpTradeAmt > 0)
  375. {
  376. decimal parentpercent = GetLevelProfit(BrandId, UserLevel, 0);
  377. decimal percent = GetLevelProfit(BrandId, sUserLevel, 0);
  378. if(LogNotHelpTradeAmt.Contains("-"))
  379. {
  380. LogNotHelpTradeAmt = "(" + LogNotHelpTradeAmt + ")";
  381. }
  382. NotHelpProfit = NotHelpTradeAmt * (parentpercent - percent);
  383. LogString += "稳定期分润:" + LogNotHelpTradeAmt + " * (" + parentpercent + " - " + percent + ") = " + NotHelpProfit + "\n";
  384. }
  385. if(ProfitTradeAmt > 0)
  386. {
  387. decimal parentpercent = GetLevelProfit(BrandId, UserLevel, 2);
  388. decimal percent = GetLevelProfit(BrandId, sUserLevel, 2);
  389. if(LogProfitTradeAmt.Contains("-"))
  390. {
  391. LogProfitTradeAmt = "(" + LogProfitTradeAmt + ")";
  392. }
  393. ProfitProfit = ProfitTradeAmt * (parentpercent - percent);
  394. LogString += "盈利期分润:" + LogProfitTradeAmt + " * (" + parentpercent + " - " + percent + ") = " + ProfitProfit + "\n";
  395. }
  396. decimal SubTotalProfit = HelpProfit + NotHelpProfit + ProfitProfit;
  397. TotalProfit += SubTotalProfit;
  398. LogString += "总分润:" + SubTotalProfit + "\n";
  399. }
  400. LogString += "--------------------------------------------------------------\n";
  401. }
  402. }
  403. decimal CheckProfit = sub.CreditTradeProfit - TotalProfit;
  404. string Result = "通过";
  405. if(Math.Abs(CheckProfit) > 10)
  406. {
  407. Result = "分润有误";
  408. }
  409. LogString += "系统分润:" + sub.CreditTradeProfit + "\n";
  410. LogString += "核对分润:" + TotalProfit + "\n";
  411. LogString += "核对结果:" + Result + "\n";
  412. LogString += "===================================================================================\n\n\n";
  413. function.WritePage("/ProfitDetailLog/" + Month + "/", UserId + ".txt", LogString);
  414. ProfitRewardExport edit = db.ProfitRewardExport.FirstOrDefault(m => m.Id == sub.Id);
  415. if(edit != null)
  416. {
  417. edit.SeoKeyword = TotalProfit.ToString();
  418. edit.SeoDescription = Result;
  419. edit.Status = 1;
  420. db.SaveChanges();
  421. }
  422. StartId = sub.Id;
  423. function.WriteLog(DateTime.Now.ToString() + "-" + index, "分润结果检查");
  424. }
  425. }
  426. else
  427. {
  428. checkOp = false;
  429. }
  430. }
  431. db.Dispose();
  432. }
  433. public void CheckSubsidy()
  434. {
  435. DateTime now = DateTime.Now;
  436. string Month = DateTime.Now.AddMonths(-1).ToString("yyyyMM");
  437. WebCMSEntities db = new WebCMSEntities();
  438. bool op = true;
  439. int StartId = 0;
  440. while(op)
  441. {
  442. List<ProfitSubsidyExport> list = db.ProfitSubsidyExport.Where(m => m.SeoTitle == Month && m.Id > StartId).OrderBy(m => m.Id).Take(50).ToList();
  443. if(list.Count > 0)
  444. {
  445. foreach(ProfitSubsidyExport sub in list)
  446. {
  447. int BrandId = sub.Sort;
  448. string MakerCode = sub.MakerCode;
  449. UserForMakerCode userForMakerCode = db.UserForMakerCode.FirstOrDefault(m => m.MakerCode == MakerCode) ?? new UserForMakerCode();
  450. int UserId = userForMakerCode.UserId;
  451. Users user = db.Users.FirstOrDefault(m => m.Id == UserId);
  452. if(user == null)
  453. {
  454. user = db.Users.FirstOrDefault(m => m.MakerCode == MakerCode) ?? new Users();
  455. UserId = user.Id;
  456. }
  457. MachineForSnNo machineForSn = db.MachineForSnNo.FirstOrDefault(m => m.SnNo == sub.KqSnNo) ?? new MachineForSnNo();
  458. PosMachinesTwo machine = db.PosMachinesTwo.FirstOrDefault(m => m.Id == machineForSn.SnId) ?? new PosMachinesTwo();
  459. int UserLevel = GetLevel(db, UserId, user.UserLevel);
  460. decimal HelpTradeAmt = 0;
  461. bool check = db.PosMerchantTradeSummay.Any(m => m.MerchantId == machine.BindMerchantId && m.TradeMonth == Month && m.BrandId == BrandId && m.TradeAmount > 0);
  462. if(check)
  463. {
  464. HelpTradeAmt = db.PosMerchantTradeSummay.Where(m => m.MerchantId == machine.BindMerchantId && m.TradeMonth == Month && m.BrandId == BrandId).Sum(m => m.TradeAmount);
  465. }
  466. decimal percent = GetLevelProfit(BrandId, UserLevel, 1);
  467. decimal HelpProfit = (0.001M - percent) * HelpTradeAmt;
  468. decimal CheckProfit = sub.SubsidyProfit - HelpProfit;
  469. string Result = "通过";
  470. if(Math.Abs(CheckProfit) > 0.01M)
  471. {
  472. Result = "补贴有误";
  473. }
  474. ProfitSubsidyExport edit = db.ProfitSubsidyExport.FirstOrDefault(m => m.Id == sub.Id);
  475. if(edit != null)
  476. {
  477. edit.SeoKeyword = HelpProfit.ToString();
  478. edit.SeoDescription = Result;
  479. edit.Status = 1;
  480. db.SaveChanges();
  481. }
  482. StartId = sub.Id;
  483. }
  484. }
  485. else
  486. {
  487. op = false;
  488. }
  489. }
  490. db.Dispose();
  491. }
  492. //获取创客当前等级
  493. private int GetLevel(WebCMSEntities db, int UserId, int UserLevel)
  494. {
  495. DateTime now = DateTime.Now;
  496. DateTime ThisMonth = DateTime.Parse(DateTime.Now.ToString("yyyy-MM") + "-01 00:00:00");
  497. UserRankWhite rank = db.UserRankWhite.FirstOrDefault(m => m.Id == UserId && m.CreateDate < ThisMonth && m.UpdateDate > now);
  498. if (rank != null)
  499. {
  500. if (rank.Rank > UserLevel)
  501. {
  502. UserLevel = rank.Rank;
  503. }
  504. }
  505. return UserLevel;
  506. }
  507. //获取等级分润比例
  508. private decimal GetLevelProfit(int BrandId, int UserLevel, int Help)
  509. {
  510. int LevelKindId = ProfitHelperV2.Instance.GetLevelKindId(BrandId, Help, 1);
  511. ProfitObjectLevels objlevel = RedisDbconn.Instance.Get<ProfitObjectLevels>("pobjlv" + LevelKindId + ":" + UserLevel); //获取当前等级参数
  512. if (objlevel != null)
  513. {
  514. return objlevel.Percents;
  515. }
  516. return 0;
  517. }
  518. }
  519. }