AlipayPayBack2Service.cs 65 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Data;
  5. using System.Threading;
  6. using MySystem.PxcModels;
  7. using Library;
  8. using LitJson;
  9. namespace MySystem
  10. {
  11. public class AlipayPayBack2Service
  12. {
  13. public readonly static AlipayPayBack2Service Instance = new AlipayPayBack2Service();
  14. private AlipayPayBack2Service()
  15. { }
  16. public void Start()
  17. {
  18. Thread th = new Thread(dosomething);
  19. th.IsBackground = true;
  20. th.Start();
  21. }
  22. private void dosomething()
  23. {
  24. bool op = true;
  25. while (op)
  26. {
  27. string content = RedisDbconn.Instance.RPop<string>("PayCallBack2");
  28. if (!string.IsNullOrEmpty(content))
  29. {
  30. try
  31. {
  32. sloveAlipayCallBack(content);
  33. }
  34. catch(Exception ex)
  35. {
  36. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "支付宝支付回调异常");
  37. }
  38. }
  39. else
  40. {
  41. Thread.Sleep(2000);
  42. }
  43. }
  44. }
  45. public void sloveAlipayCallBack(string content)
  46. {
  47. JsonData jsonObj = JsonMapper.ToObject(content);
  48. string OrderNo = jsonObj["out_trade_no"].ToString();
  49. string TradeNo = jsonObj["transaction_id"].ToString();
  50. decimal TotalFee = decimal.Parse(function.CheckNum(jsonObj["total_fee"].ToString()));
  51. WebCMSEntities db = new WebCMSEntities();
  52. OrderForNo forNo = db.OrderForNo.FirstOrDefault(m => m.OrderNo == OrderNo);
  53. if (forNo != null)
  54. {
  55. string[] ids = forNo.OrderIds.Split(',');
  56. foreach (string idString in ids)
  57. {
  58. int OrderId = int.Parse(idString);
  59. DoOrderV2(db, OrderId);
  60. Orders order = db.Orders.FirstOrDefault(m => m.Id == OrderId && m.Status > 0);
  61. if(order != null)
  62. {
  63. Products product = db.Products.FirstOrDefault(m => m.Id == order.ProductId) ?? new Products();
  64. if(product.ProductKind == 2)
  65. {
  66. order.Status = 2;
  67. order.SendStatus = 1;
  68. order.SendDate = DateTime.Now;
  69. db.SaveChanges();
  70. }
  71. }
  72. }
  73. }
  74. db.Dispose();
  75. }
  76. #region 新订单流程
  77. public void DoOrderV2(WebCMSEntities db, int OrderId)
  78. {
  79. Orders order = db.Orders.FirstOrDefault(m => m.Id == OrderId && m.Status <= 0);
  80. if (order != null)
  81. {
  82. order.Status = 1;
  83. order.PayDate = DateTime.Now;
  84. order.PayStatus = 1;
  85. db.SaveChanges();
  86. if(order.ParentOrderId > 0)
  87. {
  88. int total = db.Orders.Count(m => m.ParentOrderId == order.ParentOrderId);
  89. int paycount = db.Orders.Count(m => m.ParentOrderId == order.ParentOrderId && m.Status > 0);
  90. if(paycount >= total)
  91. {
  92. // order = db.Orders.FirstOrDefault(m => m.Id == order.ParentOrderId && m.Status == 0);
  93. // if (order != null)
  94. // {
  95. // order.Status = 2;
  96. // order.PayDate = DateTime.Now;
  97. // order.PayStatus = 1;
  98. // OrderId = order.Id;
  99. // }
  100. DoOrderV2(db, order.ParentOrderId);
  101. }
  102. return;
  103. }
  104. OrderProduct pro = db.OrderProduct.FirstOrDefault(m => m.OrderId == OrderId);
  105. if (pro != null)
  106. {
  107. order.ProductId = pro.ProductId;
  108. //扣减对应商品的库存
  109. Products product = db.Products.FirstOrDefault(m => m.Id == pro.ProductId);
  110. if(product != null)
  111. {
  112. product.Stock -= pro.ProductCount;
  113. product.BuyCount += pro.ProductCount;
  114. }
  115. db.SaveChanges();
  116. if(order.ErpMode > 0)
  117. {
  118. pro.ProductId = order.ProductId;
  119. }
  120. List<int> couponIds = new List<int>();
  121. if (pro.ProductId == 10 || pro.ProductId == 11 || pro.ProductId == 27 || pro.ProductId == 28 || pro.ProductId == 34 || pro.ProductId == -2)
  122. {
  123. order.Status = 2;
  124. int BuyCount = pro.ProductCount;
  125. int Kind = 0;
  126. int BeforeLeaderLevel = 0;
  127. if (pro.ProductId == 10 || pro.ProductId == 34)
  128. {
  129. Kind = 1;
  130. }
  131. else if (pro.ProductId == 11 || pro.ProductId == -2)
  132. {
  133. Kind = 2;
  134. }
  135. else if (pro.ProductId == 28)
  136. {
  137. Users user = db.Users.FirstOrDefault(m => m.Id == order.UserId && m.LeaderLevel == 0);
  138. if(user != null)
  139. {
  140. BeforeLeaderLevel = user.LeaderLevel;
  141. user.LeaderLevel = 1;
  142. }
  143. }
  144. else if (pro.ProductId == 27)
  145. {
  146. Users user = db.Users.FirstOrDefault(m => m.Id == order.UserId && m.LeaderLevel < 2);
  147. if(user != null)
  148. {
  149. BeforeLeaderLevel = user.LeaderLevel;
  150. user.LeaderLevel = 2;
  151. }
  152. }
  153. if(Kind <= 2 && (pro.ProductId == 10 || pro.ProductId == 11 || pro.ProductId == 34 || pro.ProductId == -2))
  154. {
  155. // 购买600一组机具券,返券
  156. int CouponCount = 0;
  157. if(Kind == 1)
  158. {
  159. CouponCount = 3 * pro.ProductCount;
  160. }
  161. else if(Kind == 2)
  162. {
  163. CouponCount = 2 * pro.ProductCount;
  164. }
  165. if(pro.ProductId == 34) //助利宝商机券购买,50张起购
  166. {
  167. CouponCount = 50 * pro.ProductCount;
  168. }
  169. string Codes = "";
  170. var coupons = db.PosCoupons.Where(m => m.IsLock == 0 && m.IsUse == 0 && m.UserId == 0 && m.QueryCount == Kind).OrderBy(m => m.Id).Take(CouponCount).ToList();
  171. int RecordId = 0;
  172. if(coupons.Count > 0 && (pro.ProductId == 34 || pro.ProductId == -2))
  173. {
  174. var adds = db.HelpProfitExchange.Add(new HelpProfitExchange()
  175. {
  176. CreateDate = DateTime.Now, //创建时间
  177. UserId = order.UserId,
  178. ExchangeCount = coupons.Count,
  179. }).Entity;
  180. db.SaveChanges();
  181. RecordId = adds.Id;
  182. }
  183. foreach (var coupon in coupons) // TODO: 数量多的话,会慢
  184. {
  185. PosCoupons item = db.PosCoupons.FirstOrDefault(m => m.Id == coupon.Id);
  186. if (item != null)
  187. {
  188. item.CreateDate = DateTime.Now;
  189. item.UserId = order.UserId;
  190. item.UpdateDate = DateTime.Now.AddDays(180);
  191. if(pro.ProductId == 34 || pro.ProductId == -2)
  192. {
  193. item.HelpProfitFlag = 1;
  194. db.HelpProfitExchangeDetail.Add(new HelpProfitExchangeDetail()
  195. {
  196. CreateDate = DateTime.Now, //创建时间
  197. UserId = order.UserId,
  198. PosCouponId = item.Id,
  199. ExchangeCode = item.ExchangeCode,
  200. RecordId = RecordId,
  201. });
  202. }
  203. Codes += item.ExchangeCode + ",";
  204. couponIds.Add(coupon.Id);
  205. }
  206. }
  207. order.SnNos = Codes.TrimEnd(',');
  208. }
  209. db.SaveChanges();
  210. if (pro.ProductId == 27 || pro.ProductId == 28)
  211. {
  212. //充值盟主储备金
  213. decimal TotalPrice = 10000;
  214. if(pro.ProductId == 27)
  215. {
  216. TotalPrice = 40000;
  217. }
  218. OpReserve(db, order, order.UserId, TotalPrice, 1);
  219. Users user = db.Users.FirstOrDefault(m => m.Id == order.UserId) ?? new Users();
  220. if(pro.ProductId == 27)
  221. {
  222. OperateReserveBackFor(db, user.Id, 40000);
  223. //预设大盟主职级
  224. LeaderPreUserLevel(db, order.UserId, 2);
  225. AddLeader(db, order.UserId, 2);
  226. decimal Prize = decimal.Parse(function.CheckNum(PublicFunction.GetPublicParam(db, "BigLeaderPrize")));
  227. if(Prize > 0 && BeforeLeaderLevel < 2 && user.UserType == 0)
  228. {
  229. LeaderRecommendPrize(db, order, user.Id, Prize, 122);
  230. }
  231. }
  232. }
  233. if (pro.ProductId == 28) //购买小盟主,给上级大盟主返储备金
  234. {
  235. bool check = LeaderBack(db, order);
  236. Users user = db.Users.FirstOrDefault(m => m.Id == order.UserId) ?? new Users();
  237. if (check) OperateReserveBackFor(db, user.Id, 10000);
  238. //预设小盟主职级
  239. LeaderPreUserLevel(db, order.UserId, 1);
  240. AddLeader(db, order.UserId, 1);
  241. decimal Prize = decimal.Parse(function.CheckNum(PublicFunction.GetPublicParam(db, "SmallLeaderPrize")));
  242. if(Prize > 0 && BeforeLeaderLevel < 1 && user.UserType == 0)
  243. {
  244. LeaderRecommendPrize(db, order, user.Id, Prize, 123);
  245. }
  246. }
  247. }
  248. // 购买盟主储蓄金
  249. if (pro.ProductId == 39 || pro.ProductId == 40)
  250. {
  251. order.Status = 2;
  252. //充值盟主储备金
  253. decimal TotalPrice = 10000;
  254. if(pro.ProductId == 39)
  255. {
  256. TotalPrice = 40000;
  257. }
  258. OpReserve(db, order, order.UserId, TotalPrice, 1);
  259. if(pro.ProductId == 39) //购买大盟主储蓄金,给上级运营中心返可提现金额
  260. {
  261. OperateReserveBackFor(db, order.UserId, 40000);
  262. AddLeader(db, order.UserId, 2);
  263. LeaderPreUserLevel(db, order.UserId, 2);
  264. }
  265. else if(pro.ProductId == 40) //购买小盟主储蓄金,给上级大盟主返储备金
  266. {
  267. LeaderBack(db, order);
  268. AddLeader(db, order.UserId, 1);
  269. LeaderPreUserLevel(db, order.UserId, 1);
  270. }
  271. }
  272. //推荐下单奖励
  273. if (pro.ProductId == 10 || pro.ProductId == 11)
  274. {
  275. bool checkPrize = db.UserAccountRecord.Any(m => m.QueryCount == OrderId && m.ChangeType == 112);
  276. function.WriteLog("OrderId:" + OrderId, "推荐下单奖励监控日志");
  277. function.WriteLog("checkPrize:" + checkPrize, "推荐下单奖励监控日志");
  278. if (checkPrize)
  279. {
  280. Users user = db.Users.FirstOrDefault(m => m.Id == order.UserId);
  281. if (user != null)
  282. {
  283. if(user.LeaderLevel > 0 || user.UserType == 1) //盟主或运营中心
  284. {
  285. //获得100元奖励
  286. OpAccount(db, order, order.UserId, 100, pro.ProductCount);
  287. }
  288. }
  289. }
  290. else
  291. {
  292. Users user = db.Users.FirstOrDefault(m => m.Id == order.UserId);
  293. if (user != null)
  294. {
  295. bool directPrize = false; //直推奖标记
  296. bool bigLeaderPrize = false; //大盟主券标记
  297. bool operateFlag = false; //运营中心标记
  298. bool buyPrize = false; //返100购机奖励标记或返100购机奖励标记-运营中心
  299. int leaderFlag = 0; //返600备用金标记
  300. if(user.LeaderLevel > 0 || user.UserType == 1) //盟主或运营中心
  301. {
  302. if(user.LeaderLevel > 0)
  303. {
  304. UserAccount acccount = db.UserAccount.FirstOrDefault(m => m.Id == order.UserId) ?? new UserAccount();
  305. if(acccount.LeaderReserve >= order.TotalPrice)
  306. {
  307. if(order.PayMode == 4)
  308. {
  309. //扣减备用金
  310. OpReserve(db, order, order.UserId, order.TotalPrice, 0, 0, "商城购机(储备金支付)");
  311. }
  312. //获得100元奖励
  313. OpAccount(db, order, order.UserId, 100, pro.ProductCount);
  314. }
  315. }
  316. else if(user.UserType == 1)
  317. {
  318. //获得100元奖励
  319. OpAccount(db, order, order.UserId, 100, pro.ProductCount);
  320. }
  321. //推荐奖励
  322. DirectPrize(db, order.Id, order.UserId, pro.ProductCount);
  323. //推荐下单上级获得30天的机具循环天数(盟主自己得)
  324. var posList = db.PosMachinesTwo.Select(m => new { m.Id, m.UserId, m.BindingState, m.RecycEndDate }).Where(m => m.UserId == order.UserId && m.BindingState == 0 && m.RecycEndDate != null).ToList();
  325. foreach (var subPos in posList)
  326. {
  327. PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == subPos.Id);
  328. if (pos != null)
  329. {
  330. pos.RecycEndDate = pos.RecycEndDate.Value.AddDays(30);
  331. }
  332. }
  333. db.SaveChanges();
  334. if(order.PayMode == 4 && user.LeaderLevel > 0) //使用盟主储蓄金,并且是盟主
  335. {
  336. if(user.UserType == 1)
  337. {
  338. if(couponIds.Count > 0)
  339. {
  340. UserAccount acccount = db.UserAccount.FirstOrDefault(m => m.Id == user.Id) ?? new UserAccount();
  341. foreach(int couponId in couponIds)
  342. {
  343. PosCoupons coupon = db.PosCoupons.FirstOrDefault(m => m.Id == couponId);
  344. if(coupon != null)
  345. {
  346. if(acccount.LeaderReserve >= 400 * pro.ProductCount)
  347. {
  348. coupon.LeaderUserId = user.Id;
  349. }
  350. coupon.OpId = user.Id;
  351. }
  352. }
  353. }
  354. db.SaveChanges();
  355. }
  356. else
  357. {
  358. //寻找最近运营中心额度大于0的运营中心
  359. int PUserId = user.Id;
  360. bool OperateFlag = true;
  361. bool OncePrizeFlag1 = true;
  362. while(PUserId > 0)
  363. {
  364. Users puser = db.Users.FirstOrDefault(m => m.Id == PUserId);
  365. if(puser != null)
  366. {
  367. if(puser.UserType == 1 && OperateFlag == true) //运营中心
  368. {
  369. if(couponIds.Count > 0)
  370. {
  371. UserAccount acccount = db.UserAccount.FirstOrDefault(m => m.Id == order.UserId) ?? new UserAccount();
  372. foreach(int couponId in couponIds)
  373. {
  374. PosCoupons coupon = db.PosCoupons.FirstOrDefault(m => m.Id == couponId);
  375. if(coupon != null)
  376. {
  377. if(acccount.LeaderReserve >= 400 * pro.ProductCount)
  378. {
  379. coupon.LeaderUserId = user.Id;
  380. }
  381. coupon.OpId = puser.Id;
  382. }
  383. }
  384. db.SaveChanges();
  385. if(acccount.LeaderReserve >= 400 * pro.ProductCount && OncePrizeFlag1)
  386. {
  387. //扣减备用金
  388. OpReserve(db, order, order.UserId, 400 * pro.ProductCount, 2, 0, "商城购机");
  389. //返回到余额
  390. OpLeaderAccount(db, order, order.UserId, 400, pro.ProductCount);
  391. OncePrizeFlag1 = false;
  392. }
  393. OperateFlag = false;
  394. }
  395. }
  396. PUserId = puser.ParentUserId;
  397. }
  398. else
  399. {
  400. PUserId = 0;
  401. }
  402. }
  403. }
  404. }
  405. else if(order.PayMode == 4 && user.UserType == 1) //使用盟主储蓄金,并且是运营中心
  406. {
  407. if(couponIds.Count > 0)
  408. {
  409. foreach(int couponId in couponIds)
  410. {
  411. PosCoupons coupon = db.PosCoupons.FirstOrDefault(m => m.Id == couponId);
  412. if(coupon != null)
  413. {
  414. coupon.OpId = user.Id;
  415. }
  416. }
  417. db.SaveChanges();
  418. //寻找最近储蓄金充足的大盟主
  419. int PUserId = user.Id;
  420. bool LeaderFlag = true;
  421. bool OncePrizeFlag2 = true;
  422. while(PUserId > 0)
  423. {
  424. Users puser = db.Users.FirstOrDefault(m => m.Id == PUserId);
  425. if(puser != null)
  426. {
  427. if(puser.LeaderLevel == 2 && LeaderFlag == true) //大盟主
  428. {
  429. if(couponIds.Count > 0)
  430. {
  431. UserAccount pacccount = db.UserAccount.FirstOrDefault(m => m.Id == puser.Id) ?? new UserAccount();
  432. foreach(int couponId in couponIds)
  433. {
  434. PosCoupons coupon = db.PosCoupons.FirstOrDefault(m => m.Id == couponId);
  435. if(coupon != null && pacccount.LeaderReserve >= 400 * pro.ProductCount)
  436. {
  437. coupon.LeaderUserId = puser.Id;
  438. }
  439. }
  440. db.SaveChanges();
  441. UserAccount acccount = db.UserAccount.FirstOrDefault(m => m.Id == order.UserId) ?? new UserAccount();
  442. if(acccount.LeaderReserve >= 400 * pro.ProductCount && OncePrizeFlag2)
  443. {
  444. //扣减备用金
  445. OpReserve(db, order, order.UserId, 400 * pro.ProductCount, 2, 0, "商城购机");
  446. //返回到余额
  447. OpLeaderAccount(db, order, order.UserId, 400, pro.ProductCount);
  448. OncePrizeFlag2 = false;
  449. }
  450. LeaderFlag = false;
  451. }
  452. }
  453. PUserId = puser.ParentUserId;
  454. }
  455. else
  456. {
  457. PUserId = 0;
  458. }
  459. }
  460. }
  461. else
  462. {
  463. //寻找最近储蓄金充足的大盟主及最近运营中心额度大于0的运营中心(含自身)
  464. int PUserId = user.Id;
  465. int LeaderFlag = 0;
  466. bool OperateFlag = true;
  467. bool OncePrizeFlag3 = true;
  468. while(PUserId > 0)
  469. {
  470. Users puser = db.Users.FirstOrDefault(m => m.Id == PUserId);
  471. if(puser != null)
  472. {
  473. if(puser.LeaderLevel > 0 && puser.LeaderLevel > LeaderFlag && LeaderFlag < 2) //大盟主
  474. {
  475. if(couponIds.Count > 0)
  476. {
  477. if(puser.LeaderLevel == 2)
  478. {
  479. UserAccount pacccount = db.UserAccount.FirstOrDefault(m => m.Id == puser.Id) ?? new UserAccount();
  480. foreach(int couponId in couponIds)
  481. {
  482. PosCoupons coupon = db.PosCoupons.FirstOrDefault(m => m.Id == couponId);
  483. if(coupon != null && pacccount.LeaderReserve >= 400 * pro.ProductCount)
  484. {
  485. coupon.LeaderUserId = puser.Id;
  486. }
  487. }
  488. db.SaveChanges();
  489. }
  490. UserAccount acccount = db.UserAccount.FirstOrDefault(m => m.Id == puser.Id) ?? new UserAccount();
  491. if(acccount.LeaderReserve >= 400 * pro.ProductCount && OncePrizeFlag3)
  492. {
  493. //扣减备用金
  494. OpReserve(db, order, puser.Id, 400 * pro.ProductCount, 2, 0, "商城购机");
  495. //返回到余额
  496. OpLeaderAccount(db, order, puser.Id, 400, pro.ProductCount);
  497. LeaderFlag = puser.LeaderLevel;
  498. OncePrizeFlag3 = false;
  499. }
  500. }
  501. }
  502. if(puser.UserType == 1 && OperateFlag == true) //运营中心
  503. {
  504. if(couponIds.Count > 0)
  505. {
  506. foreach(int couponId in couponIds)
  507. {
  508. PosCoupons coupon = db.PosCoupons.FirstOrDefault(m => m.Id == couponId);
  509. if(coupon != null)
  510. {
  511. coupon.OpId = puser.Id;
  512. }
  513. }
  514. db.SaveChanges();
  515. OperateFlag = false;
  516. }
  517. }
  518. PUserId = puser.ParentUserId;
  519. }
  520. else
  521. {
  522. PUserId = 0;
  523. }
  524. }
  525. //运营中心返额度(下单人自己是运营中心)
  526. // OperateReserveBackFor(db, order.UserId, order.TotalPrice);
  527. }
  528. return;
  529. }
  530. int ParentUserId = user.ParentUserId;
  531. // List<int> proids = new List<int>();
  532. // proids.Add(10);
  533. // proids.Add(11);
  534. // 普通创客购买600一组的机具券
  535. bool OncePrizeFlag4 = true;
  536. while(ParentUserId > 0)
  537. {
  538. Users puser = db.Users.FirstOrDefault(m => m.Id == ParentUserId) ?? new Users();
  539. int machineCount = db.PosMachinesTwo.Count(m => m.BuyUserId == ParentUserId && m.PosSnType == 0 && m.ActivationState == 0); //判断是否拥有3台兑换机
  540. int ActiveCount = db.PosMachinesTwo.Count(m => m.BuyUserId == ParentUserId && m.ActivationState == 1); //判断是否拥有3台激活机(不限购买或赠送)
  541. int couponCount = db.PosCoupons.Count(m => m.UserId == ParentUserId && m.IsUse == 0); //判断是否拥有3张券
  542. function.WriteLog("MakerCode:" + puser.MakerCode, "推荐下单奖励监控日志");
  543. function.WriteLog("machineCount:" + machineCount, "推荐下单奖励监控日志");
  544. function.WriteLog("ActiveCount:" + ActiveCount, "推荐下单奖励监控日志");
  545. if ((machineCount + ActiveCount + couponCount >= 3 || puser.LeaderLevel > 0) && !directPrize)
  546. {
  547. // function.WriteLog("满足条件", "推荐下单奖励监控日志");
  548. // if(puser.LeaderLevel == 0) // 非盟主直推奖励,每个创客第一次下单,上级可得
  549. // {
  550. // List<int> oids = new List<int>();
  551. // var orderpros = db.OrderProduct.Select(m => new { m.OrderId,m.UserId,m.ProductId }).Where(m => m.UserId == order.UserId && proids.Contains(m.ProductId)).ToList();
  552. // foreach(var orderpro in orderpros)
  553. // {
  554. // oids.Add(orderpro.OrderId);
  555. // }
  556. // bool check = db.Orders.Any(m => oids.Contains(m.Id) && m.Status > 0);
  557. // if(!check)
  558. // {
  559. // DirectPrize(db, order.Id, ParentUserId, pro.ProductCount);
  560. // directPrize = true;
  561. // }
  562. // }
  563. // else
  564. // {
  565. // 盟主直推奖励,可以每次下单获得
  566. DirectPrize(db, order.Id, ParentUserId, pro.ProductCount);
  567. directPrize = true;
  568. // }
  569. //推荐下单上级获得30天的机具循环天数
  570. var posList = db.PosMachinesTwo.Select(m => new { m.Id, m.UserId, m.BindingState, m.RecycEndDate }).Where(m => m.UserId == ParentUserId && m.BindingState == 0 && m.RecycEndDate != null).ToList();
  571. foreach (var subPos in posList)
  572. {
  573. PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == subPos.Id);
  574. if (pos != null)
  575. {
  576. pos.RecycEndDate = pos.RecycEndDate.Value.AddDays(30);
  577. }
  578. }
  579. db.SaveChanges();
  580. }
  581. if(puser.LeaderLevel > 0)
  582. {
  583. function.WriteLog("OrderId:" + order.Id, "监控大盟主购机奖励");
  584. function.WriteLog("UserId:" + puser.Id, "监控大盟主购机奖励");
  585. UserAccount acccount = db.UserAccount.FirstOrDefault(m => m.Id == puser.Id) ?? new UserAccount();
  586. function.WriteLog("LeaderReserve:" + acccount.LeaderReserve, "监控大盟主购机奖励");
  587. function.WriteLog("buyPrize:" + buyPrize, "监控大盟主购机奖励");
  588. if(acccount.LeaderReserve >= 400 * pro.ProductCount && !buyPrize)
  589. {
  590. //购机奖励
  591. OpAccount(db, order, puser.Id, 100, pro.ProductCount);
  592. buyPrize = true;
  593. }
  594. function.WriteLog("LeaderReserve:" + acccount.LeaderReserve, "监控大盟主购机奖励");
  595. function.WriteLog("leaderFlag:" + leaderFlag, "监控大盟主购机奖励");
  596. function.WriteLog("OncePrizeFlag4:" + OncePrizeFlag4, "监控大盟主购机奖励");
  597. function.WriteLog("-----------------------------", "监控大盟主购机奖励");
  598. if(acccount.LeaderReserve >= 400 * pro.ProductCount && puser.LeaderLevel > leaderFlag && leaderFlag < 2 && OncePrizeFlag4)
  599. {
  600. //扣减备用金
  601. OpReserve(db, order, puser.Id, 400 * pro.ProductCount, 2, order.UserId, "购机奖励");
  602. //返回到余额
  603. OpLeaderAccount(db, order, puser.Id, 400, pro.ProductCount);
  604. leaderFlag = puser.LeaderLevel;
  605. OncePrizeFlag4 = false;
  606. }
  607. //如果是大盟主,则标记大盟主标签
  608. if(couponIds.Count > 0 && puser.LeaderLevel == 2 && acccount.LeaderReserve >= 400 * pro.ProductCount && !bigLeaderPrize)
  609. {
  610. foreach(int couponId in couponIds)
  611. {
  612. PosCoupons coupon = db.PosCoupons.FirstOrDefault(m => m.Id == couponId);
  613. if(coupon != null)
  614. {
  615. // TODO: 判断是否在盟主可提现记录里有没有未使用的储蓄金
  616. coupon.LeaderUserId = puser.Id;
  617. }
  618. }
  619. db.SaveChanges();
  620. bigLeaderPrize = true;
  621. }
  622. }
  623. if(puser.UserType == 1)
  624. {
  625. UserAccount acccount = db.UserAccount.FirstOrDefault(m => m.Id == puser.Id) ?? new UserAccount();
  626. if(!buyPrize)
  627. {
  628. //购机奖励
  629. ChangeAccount(db, order, puser.Id, 100 * pro.ProductCount, 120);
  630. buyPrize = true;
  631. }
  632. //标记标签
  633. if(couponIds.Count > 0 && !operateFlag)
  634. {
  635. foreach(int couponId in couponIds)
  636. {
  637. PosCoupons coupon = db.PosCoupons.FirstOrDefault(m => m.Id == couponId);
  638. if(coupon != null)
  639. {
  640. coupon.OpId= puser.Id;
  641. }
  642. }
  643. db.SaveChanges();
  644. operateFlag = true;
  645. }
  646. }
  647. ParentUserId = puser.ParentUserId;
  648. }
  649. //运营中心返额度
  650. // OperateReserveBackFor(db, order.UserId, order.TotalPrice);
  651. }
  652. }
  653. function.WriteLog("\r\n\r\n", "推荐下单奖励监控日志");
  654. }
  655. //推荐王
  656. if(pro.ProductId == 29)
  657. {
  658. RecommendMethod(order.UserId, order.CreateDate.Value.ToString("yyyyMM"));
  659. }
  660. //购买分仓临时额度
  661. if(pro.ProductId == 30 || pro.ProductId == 31 || pro.ProductId == 32)
  662. {
  663. string SendData = "{\"Kind\":\"1\",\"Data\":{\"OrderId\":\"" + order.Id + "\"}}";
  664. RedisDbconn.Instance.AddList("StoreApplyQueue", SendData);
  665. }
  666. //购买小分仓临时额度
  667. if(pro.ProductId == 56 || pro.ProductId == 57 || pro.ProductId == 58)
  668. {
  669. string SendData = "{\"Kind\":\"1\",\"Data\":{\"OrderId\":\"" + order.Id + "\"}}";
  670. RedisDbconn.Instance.AddList("PreStoreApplyQueue", SendData);
  671. }
  672. }
  673. else
  674. {
  675. if(order.ProductId > 0 && order.ErpMode > 0)
  676. {
  677. //盟主储备金-升级/购买 ErpMode:1-升级,2-购买
  678. if(order.ErpMode > 0)
  679. {
  680. Users user = db.Users.FirstOrDefault(m => m.Id == order.UserId);
  681. if(user != null)
  682. {
  683. if(order.ErpMode == 1)
  684. {
  685. user.LeaderLevel = 2;
  686. db.SaveChanges();
  687. }
  688. OpReserve(db, order, order.UserId, order.TotalPrice, 1);
  689. }
  690. }
  691. }
  692. }
  693. }
  694. }
  695. //小盟主购买逻辑
  696. public bool LeaderBack(WebCMSEntities db, Orders order)
  697. {
  698. int LeaderUserId = order.UserId;
  699. int level = 0;
  700. bool result = true;
  701. while(LeaderUserId > 0)
  702. {
  703. level += 1;
  704. Users user = db.Users.FirstOrDefault(m => m.Id == LeaderUserId);
  705. if(user != null)
  706. {
  707. if(user.LeaderLevel == 2 && level > 1)
  708. {
  709. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == LeaderUserId);
  710. if(account != null)
  711. {
  712. decimal TotalPrice = 10000;
  713. if(account.LeaderReserve >= TotalPrice)
  714. {
  715. OpReserve(db, order, LeaderUserId, TotalPrice, 2, 0, "推荐小盟主");
  716. OpLeaderAccount(db, order, LeaderUserId, TotalPrice, 1, 1);
  717. LeaderUserId = 0;
  718. result = false;
  719. }
  720. else
  721. {
  722. LeaderUserId = user.ParentUserId;
  723. // decimal LeaderReserve = account.LeaderReserve;
  724. // OpReserve(db, order, LeaderUserId, LeaderReserve, 2, 0, "推荐小盟主");
  725. // OpLeaderAccount(db, order, LeaderUserId, LeaderReserve);
  726. }
  727. }
  728. }
  729. else
  730. {
  731. LeaderUserId = user.ParentUserId;
  732. }
  733. }
  734. else
  735. {
  736. LeaderUserId = 0;
  737. }
  738. }
  739. return result;
  740. }
  741. //操作储备金
  742. public void OpReserve(WebCMSEntities db, Orders order, int UserId, decimal Money, int ChangeType, int SourceUserId = 0, string Remark = "储备金购买")
  743. {
  744. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  745. if (account == null)
  746. {
  747. account = db.UserAccount.Add(new UserAccount()
  748. {
  749. Id = UserId,
  750. UserId = UserId,
  751. }).Entity;
  752. db.SaveChanges();
  753. }
  754. decimal BeforeAmount = account.LeaderReserve; //变更前总金额
  755. if(ChangeType == 1)
  756. {
  757. account.LeaderReserve += Money;
  758. }
  759. else
  760. {
  761. account.LeaderReserve -= Money;
  762. }
  763. decimal AfterAmount = account.LeaderReserve; //变更后总金额
  764. LeaderReserveRecord add = db.LeaderReserveRecord.Add(new LeaderReserveRecord()
  765. {
  766. CreateDate = DateTime.Now,
  767. ChangeType = ChangeType,
  768. OrderId = order.Id,
  769. Remark = Remark,
  770. AfterAmt = AfterAmount,
  771. BeforeAmt = BeforeAmount,
  772. ChangeAmt = Money,
  773. TradeDate = DateTime.Now.ToString("yyyyMMdd"),
  774. TradeMonth = DateTime.Now.ToString("yyyyMM"),
  775. UserId = UserId,
  776. SourceUserId = SourceUserId,
  777. }).Entity;
  778. db.SaveChanges();
  779. }
  780. //操作余额
  781. public void OpAccount(WebCMSEntities db, Orders order, int UserId, decimal Money, int Count = 1)
  782. {
  783. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  784. if (account == null)
  785. {
  786. account = db.UserAccount.Add(new UserAccount()
  787. {
  788. Id = UserId,
  789. UserId = UserId,
  790. }).Entity;
  791. db.SaveChanges();
  792. }
  793. int ChangeType = 0;
  794. if(Money == 600)
  795. {
  796. ChangeType = 117;
  797. }
  798. else if(Money == 100)
  799. {
  800. ChangeType = 118;
  801. }
  802. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  803. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  804. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  805. account.BalanceAmount += Money * Count;
  806. account.TotalAmount += Money * Count;
  807. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  808. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  809. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  810. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  811. {
  812. CreateDate = DateTime.Now,
  813. UpdateDate = DateTime.Now,
  814. UserId = UserId, //创客
  815. ChangeType = ChangeType, //变动类型
  816. ChangeAmount = Money * Count, //变更金额
  817. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  818. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  819. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  820. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  821. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  822. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  823. QueryCount = order.Id,
  824. }).Entity;
  825. db.SaveChanges();
  826. }
  827. public void ChangeAccount(WebCMSEntities db, Orders order, int UserId, decimal Money, int ChangeType = 0, string Remark = "")
  828. {
  829. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  830. if (account == null)
  831. {
  832. account = db.UserAccount.Add(new UserAccount()
  833. {
  834. Id = UserId,
  835. UserId = UserId,
  836. }).Entity;
  837. db.SaveChanges();
  838. }
  839. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  840. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  841. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  842. account.BalanceAmount += Money;
  843. if(Money > 0)
  844. {
  845. account.TotalAmount += Money;
  846. }
  847. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  848. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  849. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  850. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  851. {
  852. CreateDate = DateTime.Now,
  853. UpdateDate = DateTime.Now,
  854. UserId = UserId, //创客
  855. ChangeType = ChangeType, //变动类型
  856. ChangeAmount = Math.Abs(Money), //变更金额
  857. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  858. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  859. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  860. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  861. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  862. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  863. QueryCount = order.Id,
  864. Remark = Remark,
  865. }).Entity;
  866. db.SaveChanges();
  867. }
  868. //操作盟主可提现余额
  869. public void OpLeaderAccount(WebCMSEntities db, Orders order, int UserId, decimal Money, int Count = 1, int Kind = 0)
  870. {
  871. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  872. if (account == null)
  873. {
  874. account = db.UserAccount.Add(new UserAccount()
  875. {
  876. Id = UserId,
  877. UserId = UserId,
  878. }).Entity;
  879. db.SaveChanges();
  880. }
  881. int ChangeType = 0;
  882. if(Money == 400)
  883. {
  884. ChangeType = 117;
  885. }
  886. int LeaderId = 0;
  887. decimal LeaderReserve = 0;
  888. if(Kind == 1)
  889. {
  890. LeaderId = UserId;
  891. LeaderReserve = Money * Count;
  892. }
  893. decimal BeforeLeaderBalanceAmount = account.LeaderBalanceAmount; //变更前余额
  894. account.LeaderBalanceAmount += Money * Count;
  895. decimal AfterLeaderBalanceAmount = account.LeaderBalanceAmount; //变更后余额
  896. LeaderAccountRecord leaderAccountRecord = db.LeaderAccountRecord.Add(new LeaderAccountRecord()
  897. {
  898. CreateDate = DateTime.Now,
  899. UpdateDate = DateTime.Now,
  900. UserId = UserId, //创客
  901. ChangeType = ChangeType, //变动类型
  902. ChangeAmount = Money * Count, //变更金额
  903. BeforeBalanceAmount = BeforeLeaderBalanceAmount, //变更前余额
  904. AfterBalanceAmount = AfterLeaderBalanceAmount, //变更后余额
  905. QueryCount = order.Id,
  906. LeaderId = LeaderId,
  907. LeaderReserve = LeaderReserve,
  908. }).Entity;
  909. db.SaveChanges();
  910. }
  911. public void DirectPrize(WebCMSEntities db, int OrderId, int UserId, int Count = 1)
  912. {
  913. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  914. if (account == null)
  915. {
  916. account = db.UserAccount.Add(new UserAccount()
  917. {
  918. Id = UserId,
  919. UserId = UserId,
  920. }).Entity;
  921. db.SaveChanges();
  922. }
  923. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  924. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  925. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  926. account.BalanceAmount += 100 * Count;
  927. account.TotalAmount += 100 * Count;
  928. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  929. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  930. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  931. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  932. {
  933. CreateDate = DateTime.Now,
  934. UpdateDate = DateTime.Now,
  935. UserId = UserId, //创客
  936. ChangeType = 112, //变动类型
  937. ChangeAmount = 100 * Count, //变更金额
  938. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  939. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  940. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  941. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  942. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  943. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  944. QueryCount = OrderId,
  945. }).Entity;
  946. db.SaveChanges();
  947. }
  948. // 推荐王逻辑(下单)
  949. public void RecommendMethod(int UserId, string TradeMonth)
  950. {
  951. string SendData = "{\"Kind\":\"1\",\"Data\":{\"UserId\":\"" + UserId + "\",\"TradeMonth\":\"" + TradeMonth + "\"}}";
  952. RedisDbconn.Instance.AddList("RecommendActStatQueue", SendData);
  953. }
  954. //操作运营中心额度
  955. public void OperateReserveBackFor(WebCMSEntities maindb, int UserId, decimal Money)
  956. {
  957. OpModels.WebCMSEntities db = new OpModels.WebCMSEntities();
  958. while(UserId > 0)
  959. {
  960. Users user = maindb.Users.FirstOrDefault(m => m.Id == UserId);
  961. if(user != null)
  962. {
  963. bool sys = db.SysAdmin.Any(m => m.UserId == UserId);
  964. if(sys)
  965. {
  966. OpModels.UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId) ?? new OpModels.UserAccount();
  967. if(account.TotalAmt <= 0)
  968. {
  969. return;
  970. }
  971. if(account.TotalAmt < Money)
  972. {
  973. Money = account.TotalAmt;
  974. }
  975. if(Money > 0)
  976. {
  977. OperateAmountChange(db, UserId, Money, 2, 1, "商城购机");
  978. OperateAmountChange(db, UserId, Money, 1, 2, "商城购机");
  979. }
  980. UserId = 0;
  981. }
  982. else
  983. {
  984. UserId = user.ParentUserId;
  985. }
  986. }
  987. else
  988. {
  989. UserId = 0;
  990. }
  991. }
  992. db.Dispose();
  993. }
  994. public void OperateReserveBack(int UserId, decimal Money)
  995. {
  996. OpModels.WebCMSEntities db = new OpModels.WebCMSEntities();
  997. OpModels.UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId) ?? new OpModels.UserAccount();
  998. if(account.TotalAmt <= 0)
  999. {
  1000. return;
  1001. }
  1002. if(account.TotalAmt < Money)
  1003. {
  1004. Money = account.TotalAmt;
  1005. }
  1006. if(Money > 0)
  1007. {
  1008. OperateAmountChange(db, UserId, Money, 2, 1, "商城购机");
  1009. OperateAmountChange(db, UserId, Money, 1, 2, "商城购机");
  1010. }
  1011. db.Dispose();
  1012. }
  1013. public void ActReserveBack(int UserId, decimal OpReserve1, decimal OpReserve2, decimal OpReserve3)
  1014. {
  1015. OpModels.WebCMSEntities db = new OpModels.WebCMSEntities();
  1016. if(OpReserve1 > 0) OperateAmountChange(db, UserId, OpReserve1, 1, 1, "机具激活", true);
  1017. if(OpReserve2 > 0) OperateAmountChange(db, UserId, OpReserve2, 1, 2, "机具激活", true);
  1018. if(OpReserve3 > 0) OperateAmountChange(db, UserId, OpReserve3, 1, 3, "机具激活", true);
  1019. db.Dispose();
  1020. }
  1021. public void OperateAmountChange(OpModels.WebCMSEntities db, int UserId, decimal Money, int OperateType, int AmountType, string Remark = "", bool record = false)
  1022. {
  1023. OpModels.UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  1024. if (account == null)
  1025. {
  1026. account = db.UserAccount.Add(new OpModels.UserAccount()
  1027. {
  1028. Id = UserId,
  1029. UserId = UserId,
  1030. }).Entity;
  1031. db.SaveChanges();
  1032. }
  1033. decimal BeforeAmount = account.ValidAmount + account.TotalAmt + account.ValidForGetAmount; //变更前总金额
  1034. if(OperateType == 1)
  1035. {
  1036. if(AmountType == 1)
  1037. {
  1038. // BeforeAmount = account.TotalAmt;
  1039. account.TotalAmt += Money;
  1040. // AfterAmount = account.TotalAmt;
  1041. }
  1042. else if(AmountType == 2)
  1043. {
  1044. // BeforeAmount = account.ValidForGetAmount;
  1045. account.ValidForGetAmount += Money;
  1046. // AfterAmount = account.ValidForGetAmount;
  1047. }
  1048. else
  1049. {
  1050. // BeforeAmount = account.ValidAmount;
  1051. account.ValidAmount += Money;
  1052. // AfterAmount = account.ValidAmount;
  1053. }
  1054. }
  1055. else
  1056. {
  1057. if(AmountType == 1)
  1058. {
  1059. // BeforeAmount = account.TotalAmt;
  1060. account.TotalAmt -= Money;
  1061. // AfterAmount = account.TotalAmt;
  1062. }
  1063. else if(AmountType == 2)
  1064. {
  1065. // BeforeAmount = account.ValidForGetAmount;
  1066. account.ValidForGetAmount -= Money;
  1067. // AfterAmount = account.ValidForGetAmount;
  1068. }
  1069. else
  1070. {
  1071. // BeforeAmount = account.ValidAmount;
  1072. account.ValidAmount -= Money;
  1073. // AfterAmount = account.ValidAmount;
  1074. }
  1075. }
  1076. decimal AfterAmount = account.ValidAmount + account.TotalAmt + account.ValidForGetAmount; //变更后总金额
  1077. if(record)
  1078. {
  1079. OpModels.AmountRecord add = db.AmountRecord.Add(new OpModels.AmountRecord()
  1080. {
  1081. CreateDate = DateTime.Now,
  1082. UpdateDate = DateTime.Now,
  1083. OperateType = OperateType,
  1084. AfterAmount = AfterAmount,
  1085. BeforeAmount = BeforeAmount,
  1086. UseAmount = Money,
  1087. UserId = UserId,
  1088. SeoDescription = Remark,
  1089. Version = AmountType,
  1090. }).Entity;
  1091. }
  1092. db.SaveChanges();
  1093. }
  1094. #endregion
  1095. #region 盟主推荐奖励
  1096. public void LeaderRecommendPrize(WebCMSEntities db, Orders order, int UserId, decimal Money, int ChangeType)
  1097. {
  1098. int level = 0;
  1099. while(UserId > 0)
  1100. {
  1101. level += 1;
  1102. Users user = db.Users.FirstOrDefault(m => m.Id == UserId);
  1103. if(user != null)
  1104. {
  1105. if((user.UserType == 1 || user.LeaderLevel > 0) && level > 1)
  1106. {
  1107. ChangeAccount(db, order, UserId, Money, ChangeType);
  1108. UserId = 0;
  1109. }
  1110. else
  1111. {
  1112. UserId = user.ParentUserId;
  1113. }
  1114. }
  1115. else
  1116. {
  1117. UserId = 0;
  1118. }
  1119. }
  1120. db.Dispose();
  1121. }
  1122. #endregion
  1123. #region 购买盟主预设职级
  1124. public void LeaderPreUserLevel(WebCMSEntities db, int UserId, int LeaderKind)
  1125. {
  1126. int Month = LeaderKind == 1 ? 6 : 12;
  1127. int Rank = LeaderKind == 1 ? 5 : 7;
  1128. UserRankWhite check = db.UserRankWhite.FirstOrDefault(m => m.Id == UserId);
  1129. if(check == null)
  1130. {
  1131. db.UserRankWhite.Add(new UserRankWhite()
  1132. {
  1133. CreateDate = DateTime.Now, //设置时间
  1134. UpdateDate = DateTime.Now.AddMonths(Month), //过期时间
  1135. Rank = Rank,
  1136. UserId = UserId, //用户
  1137. Id = UserId,
  1138. });
  1139. }
  1140. else
  1141. {
  1142. if(check.Rank < Rank)
  1143. {
  1144. check.Rank = Rank;
  1145. check.UpdateDate = DateTime.Now.AddMonths(Month);
  1146. }
  1147. else if(check.Rank == Rank && check.UpdateDate < DateTime.Now.AddMonths(Month))
  1148. {
  1149. check.UpdateDate = DateTime.Now.AddMonths(Month);
  1150. }
  1151. }
  1152. db.SaveChanges();
  1153. }
  1154. #endregion
  1155. #region 记录盟主
  1156. public void AddLeader(WebCMSEntities db, int UserId, int LeaderLevel)
  1157. {
  1158. int Month = LeaderLevel == 1 ? 6 : 12;
  1159. Leaders leader = db.Leaders.FirstOrDefault(m => m.Id == UserId);
  1160. if(leader == null)
  1161. {
  1162. db.Leaders.Add(new Leaders()
  1163. {
  1164. Id = UserId,
  1165. CreateDate = DateTime.Now, //设置时间
  1166. UserId = UserId, //用户
  1167. LeaderLevel = LeaderLevel,
  1168. LastBuyDate = DateTime.Now,
  1169. ExpiredDate = DateTime.Now.AddMonths(Month),
  1170. });
  1171. }
  1172. else
  1173. {
  1174. leader.LeaderLevel = LeaderLevel;
  1175. leader.LastBuyDate = DateTime.Now;
  1176. leader.ExpiredDate = DateTime.Now.AddMonths(Month);
  1177. }
  1178. db.SaveChanges();
  1179. SendLeaderMsg(db, UserId);
  1180. }
  1181. #endregion
  1182. #region 盟主续费通知
  1183. public void SendLeaderMsg(WebCMSEntities db, int UserId)
  1184. {
  1185. string msg = "";
  1186. Users user = db.Users.FirstOrDefault(m => m.Id == UserId) ?? new Users();
  1187. DateTime now = DateTime.Now;
  1188. Leaders leader = db.Leaders.FirstOrDefault(m => m.Id == UserId);
  1189. if(leader != null)
  1190. {
  1191. if(leader.ExpiredDate >= now)
  1192. {
  1193. msg = "尊敬的" + user.RealName + "盟主,恭喜您的盟主已成功开通";
  1194. }
  1195. else
  1196. {
  1197. msg = "尊敬的" + user.RealName + "盟主,恭喜您重新成为盟主";
  1198. }
  1199. }
  1200. else
  1201. {
  1202. msg = "尊敬的" + user.RealName + "盟主,恭喜您的盟主已成功开通";
  1203. }
  1204. RedisDbconn.Instance.AddList("MsgPersonalQueue", Newtonsoft.Json.JsonConvert.SerializeObject(new MsgPersonal()
  1205. {
  1206. UserId = Convert.ToInt32(UserId), //创客
  1207. Title = "开通盟主提醒", //标题
  1208. Content = msg, //内容
  1209. Summary = msg,
  1210. CreateDate = DateTime.Now,
  1211. }));
  1212. }
  1213. #endregion
  1214. }
  1215. }