PosCouponPrizeService.cs 35 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838
  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 PosCouponPrizeService
  12. {
  13. public readonly static PosCouponPrizeService Instance = new PosCouponPrizeService();
  14. private PosCouponPrizeService()
  15. { }
  16. public void Start()
  17. {
  18. Thread th = new Thread(ready);
  19. th.IsBackground = true;
  20. th.Start();
  21. }
  22. private void ready()
  23. {
  24. bool op = true;
  25. while (op)
  26. {
  27. string content = RedisDbconn.Instance.RPop<string>("PosCouponPrizeQueue");
  28. if (!string.IsNullOrEmpty(content))
  29. {
  30. try
  31. {
  32. dosomething(int.Parse(function.CheckInt(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 dosomething(int OrderId)
  46. {
  47. WebCMSEntities db = new WebCMSEntities();
  48. OpModels.WebCMSEntities opdb = new OpModels.WebCMSEntities();
  49. Orders order = db.Orders.FirstOrDefault(m => m.Id == OrderId);
  50. if(order != null)
  51. {
  52. List<int> ChkIds = new List<int>(); //机具券商品Id集合
  53. ChkIds.Add(10);
  54. ChkIds.Add(11);
  55. ChkIds.Add(77);
  56. ChkIds.Add(78);
  57. ChkIds.Add(79);
  58. //判断是否是指定商品
  59. if(ChkIds.Contains(order.ProductId))
  60. {
  61. int Kind = 0;
  62. if (order.ProductId == 10)
  63. {
  64. Kind = 1;
  65. }
  66. else if (order.ProductId == 11)
  67. {
  68. Kind = 2;
  69. }
  70. int CouponCount = 0;
  71. if(Kind == 1)
  72. {
  73. CouponCount = 3 * order.BuyCount;
  74. }
  75. else if(Kind == 2)
  76. {
  77. CouponCount = 2 * order.BuyCount;
  78. }
  79. UserRankItem orderUser = GetUserLevel(order.UserId);
  80. if(orderUser.UserLevel == 0)
  81. {
  82. PreUserLevel(db, order.UserId, 1, DateTime.Parse("2025-01-01 00:00:00"));
  83. }
  84. string ParentNav = orderUser.ParentNav + "," + orderUser.Id + ",";
  85. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  86. Array.Reverse(ParentNavList);
  87. int index = 0;
  88. bool DirectPrizeFlag = false; //推荐奖励发放标识
  89. bool BackAccountFlag = false; //备用金返余额标识
  90. bool BigLeaderFlag = false; //大盟主标记
  91. decimal BuyPrize = 0; //购机奖励
  92. foreach(string ParentId in ParentNavList)
  93. {
  94. UserRankItem parentUser = GetUserLevel(int.Parse(ParentId));
  95. index += 1;
  96. if(index == 1 && (orderUser.LeaderLevel > 0 || orderUser.OperateLevel > 0) && !DirectPrizeFlag)
  97. {
  98. DirectPrize(db, order.Id, order.UserId, order.BuyCount);
  99. DirectPrizeFlag = true;
  100. }
  101. if(index > 1)
  102. {
  103. if(Utils.Instance.IsStandardUser(parentUser.Id) && !DirectPrizeFlag)
  104. {
  105. DirectPrize(db, order.Id, parentUser.Id, order.BuyCount);
  106. DirectPrizeFlag = true;
  107. }
  108. }
  109. if(parentUser.AgoLeaderLevel > 0 && CheckLeaderReserve(db, order.BuyCount, parentUser.Id))
  110. {
  111. //购机奖
  112. if(parentUser.LeaderLevel > 0)
  113. {
  114. decimal CurBuyPrize = GetBuyPrize(parentUser);
  115. decimal GetPrize = CurBuyPrize - BuyPrize;
  116. if(GetPrize > 0)
  117. {
  118. bool PrizeFlag = true;
  119. int ChangeType = 118;
  120. if(parentUser.OperateLevel == 1)
  121. {
  122. ChangeType = 120;
  123. }
  124. if(parentUser.OperateLevel > 1)
  125. {
  126. ChangeType = 128;
  127. if(function.CheckNull(RedisDbconn.Instance.Get<string>("YingXunUser")).Contains("," + orderUser.Id + ","))
  128. {
  129. PrizeFlag = false;
  130. }
  131. }
  132. if(PrizeFlag)
  133. {
  134. OpAccount(db, order.Id, parentUser.Id, CurBuyPrize - BuyPrize, order.BuyCount, ChangeType);
  135. }
  136. BuyPrize = CurBuyPrize;
  137. }
  138. }
  139. if(!BackAccountFlag)
  140. {
  141. BackAccountFlag = true;
  142. //扣减备用金
  143. int ReserveRecordId = OpReserve(db, order.Id, parentUser.Id, GetWithdrawMoney(parentUser) * order.BuyCount, 2, order.UserId, "购机奖励");
  144. //返回到余额
  145. OpLeaderAccount(db, order, parentUser.Id, GetWithdrawMoney(parentUser), order.BuyCount, ReserveRecordId);
  146. }
  147. //给券打大盟主标记
  148. if(parentUser.LeaderLevel == 2 && !BigLeaderFlag)
  149. {
  150. BigLeaderFlag = true;
  151. if(!string.IsNullOrEmpty(order.SnNos))
  152. {
  153. List<string> codes = order.SnNos.Split(',').ToList();
  154. List<int> couponIds = db.PosCoupons.Where(m => codes.Contains(m.ExchangeCode)).OrderBy(m => m.Id).Take(CouponCount).ToList().Select(m => m.Id).ToList();
  155. SetPosCouponLeaderFlag(db, parentUser.Id, order.BuyCount, couponIds);
  156. }
  157. }
  158. }
  159. else if(parentUser.OperateLevel > 0 && CheckOpReserve(opdb, order.BuyCount, parentUser.Id))
  160. {
  161. //购机奖
  162. decimal CurBuyPrize = GetBuyPrize(parentUser);
  163. decimal GetPrize = CurBuyPrize - BuyPrize;
  164. if(GetPrize > 0)
  165. {
  166. int ChangeType = 120;
  167. if(parentUser.OperateLevel > 1)
  168. {
  169. ChangeType = 128;
  170. }
  171. OpAccount(db, order.Id, parentUser.Id, GetPrize, order.BuyCount, ChangeType);
  172. BuyPrize = CurBuyPrize;
  173. }
  174. if(!BackAccountFlag)
  175. {
  176. BackAccountFlag = true;
  177. decimal GetAmount = GetWithdrawMoney(parentUser) * order.BuyCount;
  178. //扣减备用金
  179. // OperateAmountChange(opdb, parentUser.Id, GetAmount, 2, 1, "商城购机", true, order.Id);
  180. // //返回到余额
  181. // OperateAmountChange(opdb, parentUser.Id, GetAmount, 1, 2, "商城购机", true, order.Id);
  182. OpAmountItem item = new OpAmountItem()
  183. {
  184. UserId = parentUser.Id,
  185. OperateType = 0,
  186. ChangeType = 5,
  187. Remark = "商城购机",
  188. UseAmount = GetAmount,
  189. UseValidForGetAmount = GetAmount,
  190. UseTotalAmt = GetAmount,
  191. DataType = 1,
  192. DataId = order.Id,
  193. };
  194. RedisDbconn.Instance.AddList("OperateAmountRecordServiceQueue", item);
  195. }
  196. }
  197. }
  198. }
  199. }
  200. db.Dispose();
  201. opdb.Dispose();
  202. }
  203. public void Start2()
  204. {
  205. Thread th = new Thread(ready2);
  206. th.IsBackground = true;
  207. th.Start();
  208. }
  209. private void ready2()
  210. {
  211. bool op = true;
  212. while (op)
  213. {
  214. string content = RedisDbconn.Instance.RPop<string>("PosCouponPrizeQueue2");
  215. if (!string.IsNullOrEmpty(content))
  216. {
  217. try
  218. {
  219. dosomething(int.Parse(function.CheckInt(content)));
  220. }
  221. catch
  222. {
  223. }
  224. }
  225. else
  226. {
  227. Thread.Sleep(5000);
  228. }
  229. }
  230. }
  231. public void dosomething2(int OrderId)
  232. {
  233. WebCMSEntities db = new WebCMSEntities();
  234. OpModels.WebCMSEntities opdb = new OpModels.WebCMSEntities();
  235. Orders order = db.Orders.FirstOrDefault(m => m.Id == OrderId);
  236. if(order != null)
  237. {
  238. List<int> ChkIds = new List<int>(); //机具券商品Id集合
  239. ChkIds.Add(10);
  240. ChkIds.Add(11);
  241. ChkIds.Add(77);
  242. ChkIds.Add(78);
  243. ChkIds.Add(79);
  244. //判断是否是指定商品
  245. if(ChkIds.Contains(order.ProductId))
  246. {
  247. int Kind = 0;
  248. if (order.ProductId == 10)
  249. {
  250. Kind = 1;
  251. }
  252. else if (order.ProductId == 11)
  253. {
  254. Kind = 2;
  255. }
  256. int CouponCount = 0;
  257. if(Kind == 1)
  258. {
  259. CouponCount = 3 * order.BuyCount;
  260. }
  261. else if(Kind == 2)
  262. {
  263. CouponCount = 2 * order.BuyCount;
  264. }
  265. UserRankItem orderUser = GetUserLevel(order.UserId);
  266. if(orderUser.UserLevel == 0)
  267. {
  268. }
  269. string ParentNav = orderUser.ParentNav + "," + orderUser.Id + ",";
  270. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  271. Array.Reverse(ParentNavList);
  272. int index = 0;
  273. bool DirectPrizeFlag = false; //推荐奖励发放标识
  274. bool BackAccountFlag = false; //备用金返余额标识
  275. bool BigLeaderFlag = false; //大盟主标记
  276. decimal BuyPrize = 0; //购机奖励
  277. foreach(string ParentId in ParentNavList)
  278. {
  279. UserRankItem parentUser = GetUserLevel(int.Parse(ParentId));
  280. index += 1;
  281. if(index == 1 && (orderUser.LeaderLevel > 0 || orderUser.OperateLevel > 0) && !DirectPrizeFlag)
  282. {
  283. DirectPrizeFlag = true;
  284. }
  285. if(index > 1)
  286. {
  287. if(Utils.Instance.IsStandardUser(parentUser.Id) && !DirectPrizeFlag)
  288. {
  289. DirectPrizeFlag = true;
  290. }
  291. }
  292. if(parentUser.AgoLeaderLevel > 0 && CheckLeaderReserve(db, order.BuyCount, parentUser.Id))
  293. {
  294. //购机奖
  295. if(parentUser.LeaderLevel > 0)
  296. {
  297. decimal CurBuyPrize = GetBuyPrize(parentUser);
  298. decimal GetPrize = CurBuyPrize - BuyPrize;
  299. if(GetPrize > 0)
  300. {
  301. bool PrizeFlag = true;
  302. int ChangeType = 118;
  303. if(parentUser.OperateLevel == 1)
  304. {
  305. ChangeType = 120;
  306. }
  307. if(parentUser.OperateLevel > 1)
  308. {
  309. ChangeType = 128;
  310. if(function.CheckNull(RedisDbconn.Instance.Get<string>("YingXunUser")).Contains("," + orderUser.Id + ","))
  311. {
  312. PrizeFlag = false;
  313. }
  314. }
  315. if(PrizeFlag && !db.UserAccountRecord.Any(m => m.QueryCount == order.Id && m.ChangeType == ChangeType))
  316. {
  317. OpAccount(db, order.Id, parentUser.Id, GetPrize, order.BuyCount, ChangeType);
  318. }
  319. BuyPrize = CurBuyPrize;
  320. }
  321. }
  322. if(!BackAccountFlag)
  323. {
  324. BackAccountFlag = true;
  325. }
  326. }
  327. else if(parentUser.OperateLevel > 0 && CheckOpReserve(opdb, order.BuyCount, parentUser.Id))
  328. {
  329. //购机奖
  330. decimal CurBuyPrize = GetBuyPrize(parentUser);
  331. decimal GetPrize = CurBuyPrize - BuyPrize;
  332. if(GetPrize > 0)
  333. {
  334. int ChangeType = 120;
  335. if(parentUser.OperateLevel > 1)
  336. {
  337. ChangeType = 128;
  338. }
  339. BuyPrize = CurBuyPrize;
  340. }
  341. if(!BackAccountFlag)
  342. {
  343. BackAccountFlag = true;
  344. }
  345. }
  346. }
  347. }
  348. }
  349. db.Dispose();
  350. opdb.Dispose();
  351. }
  352. /// <summary>
  353. /// 获取创客各种等级
  354. /// </summary>
  355. /// <param name="db"></param>
  356. /// <param name="UserId"></param>
  357. /// <returns></returns>
  358. public UserRankItem GetUserLevel(int UserId)
  359. {
  360. WebCMSEntities db = new WebCMSEntities();
  361. OpModels.WebCMSEntities opdb = new OpModels.WebCMSEntities();
  362. UserRankItem dic = new UserRankItem();
  363. DateTime now = DateTime.Now;
  364. Users user = db.Users.FirstOrDefault(m => m.Id == UserId && m.AuthFlag == 1 && m.Status > -1) ?? new Users();
  365. UserRankWhite userWhite = db.UserRankWhite.FirstOrDefault(m => m.Id == UserId && m.UpdateDate > now) ?? new UserRankWhite();
  366. Leaders leader = db.Leaders.FirstOrDefault(m => m.Id == UserId) ?? new Leaders();
  367. dic.UserLevel = userWhite.Rank > user.UserLevel ? userWhite.Rank : user.UserLevel;
  368. if(leader.ExpiredDate > now)
  369. {
  370. dic.LeaderLevel = leader.LeaderLevel;
  371. }
  372. dic.AgoLeaderLevel = leader.LeaderLevel;
  373. // OpModels.SysAdmin sys = opdb.SysAdmin.FirstOrDefault(m => m.UserId == UserId) ?? new OpModels.SysAdmin();
  374. // if(sys.ExpireDate > now)
  375. // {
  376. dic.OperateLevel = user.UserType;
  377. dic.UserType = user.UserType;
  378. // }
  379. dic.MerchantType = user.MerchantType;
  380. dic.Id = user.Id;
  381. dic.MakerCode = user.MakerCode;
  382. dic.RealName = user.RealName;
  383. dic.ParentUserId = user.ParentUserId;
  384. dic.ParentNav = user.ParentNav;
  385. db.Dispose();
  386. opdb.Dispose();
  387. return dic;
  388. }
  389. /// <summary>
  390. /// 直推奖励
  391. /// </summary>
  392. /// <param name="db"></param>
  393. /// <param name="OrderId"></param>
  394. /// <param name="UserId"></param>
  395. /// <param name="Count"></param>
  396. public void DirectPrize(WebCMSEntities db, int OrderId, int UserId, int Count = 1)
  397. {
  398. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  399. if (account == null)
  400. {
  401. account = db.UserAccount.Add(new UserAccount()
  402. {
  403. Id = UserId,
  404. UserId = UserId,
  405. }).Entity;
  406. db.SaveChanges();
  407. }
  408. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  409. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  410. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  411. account.BalanceAmount += 100 * Count;
  412. account.TotalAmount += 100 * Count;
  413. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  414. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  415. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  416. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  417. {
  418. CreateDate = DateTime.Now,
  419. UpdateDate = DateTime.Now,
  420. UserId = UserId, //创客
  421. ChangeType = 112, //变动类型
  422. ChangeAmount = 100 * Count, //变更金额
  423. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  424. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  425. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  426. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  427. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  428. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  429. QueryCount = OrderId,
  430. }).Entity;
  431. db.SaveChanges();
  432. }
  433. /// <summary>
  434. /// 判断盟主储蓄金足够
  435. /// </summary>
  436. /// <param name="db"></param>
  437. /// <param name="Count"></param>
  438. /// <param name="UserId"></param>
  439. /// <returns></returns>
  440. public bool CheckLeaderReserve(WebCMSEntities db, int Count, int UserId)
  441. {
  442. UserAccount acccount = db.UserAccount.FirstOrDefault(m => m.Id == UserId) ?? new UserAccount();
  443. if(acccount.LeaderReserve >= 400 * Count)
  444. {
  445. return true;
  446. }
  447. return false;
  448. }
  449. /// <summary>
  450. /// 判断运营中心/合伙人额度足够
  451. /// </summary>
  452. /// <param name="db"></param>
  453. /// <param name="Count"></param>
  454. /// <param name="UserId"></param>
  455. /// <returns></returns>
  456. public bool CheckOpReserve(OpModels.WebCMSEntities db, int Count, int UserId)
  457. {
  458. OpModels.UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId) ?? new OpModels.UserAccount();
  459. if(account.TotalAmt >= 400 * Count)
  460. {
  461. return true;
  462. }
  463. return false;
  464. }
  465. public bool CheckOpReserve(OpModels.WebCMSEntities db, decimal Amt, int UserId)
  466. {
  467. OpModels.UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId) ?? new OpModels.UserAccount();
  468. if(account.TotalAmt >= Amt)
  469. {
  470. return true;
  471. }
  472. return false;
  473. }
  474. /// <summary>
  475. /// 扣减/增加盟主储蓄金
  476. /// </summary>
  477. /// <param name="db"></param>
  478. /// <param name="OrderId"></param>
  479. /// <param name="UserId"></param>
  480. /// <param name="Money"></param>
  481. /// <param name="ChangeType"></param>
  482. /// <param name="SourceUserId"></param>
  483. /// <param name="Remark"></param>
  484. public int OpReserve(WebCMSEntities db, int OrderId, int UserId, decimal Money, int ChangeType, int SourceUserId = 0, string Remark = "储备金购买")
  485. {
  486. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  487. if (account == null)
  488. {
  489. account = db.UserAccount.Add(new UserAccount()
  490. {
  491. Id = UserId,
  492. UserId = UserId,
  493. }).Entity;
  494. db.SaveChanges();
  495. }
  496. decimal BeforeAmount = account.LeaderReserve; //变更前总金额
  497. if(ChangeType == 1)
  498. {
  499. account.LeaderReserve += Money;
  500. }
  501. else
  502. {
  503. account.LeaderReserve -= Money;
  504. }
  505. decimal AfterAmount = account.LeaderReserve; //变更后总金额
  506. LeaderReserveRecord add = db.LeaderReserveRecord.Add(new LeaderReserveRecord()
  507. {
  508. CreateDate = DateTime.Now,
  509. ChangeType = ChangeType,
  510. OrderId = OrderId,
  511. Remark = Remark,
  512. AfterAmt = AfterAmount,
  513. BeforeAmt = BeforeAmount,
  514. ChangeAmt = Money,
  515. TradeDate = DateTime.Now.ToString("yyyyMMdd"),
  516. TradeMonth = DateTime.Now.ToString("yyyyMM"),
  517. UserId = UserId,
  518. SourceUserId = SourceUserId,
  519. Sort = GetLeaderReserveRecordType(Remark),
  520. }).Entity;
  521. db.SaveChanges();
  522. return add.Id;
  523. }
  524. private int GetLeaderReserveRecordType(string Remark)
  525. {
  526. Dictionary<int, string> data = new Dictionary<int, string>();
  527. data.Add(11, "兑换机具券,机具券兑换,系统增加(盟主储蓄金),系统扣减(盟主储蓄金),储备金购买");
  528. data.Add(12, "系统增加(可提现余额),系统扣减(可提现余额)");
  529. data.Add(13, "推荐大盟主,推荐小盟主,商城购机,购机奖励");
  530. var item = data.FirstOrDefault(m => m.Value.Contains(Remark));
  531. if(item.Key > 0)
  532. {
  533. return item.Key;
  534. }
  535. return 0;
  536. }
  537. /// <summary>
  538. /// 操作盟主可提现余额
  539. /// </summary>
  540. /// <param name="db"></param>
  541. /// <param name="order"></param>
  542. /// <param name="UserId"></param>
  543. /// <param name="Money"></param>
  544. /// <param name="Count"></param>
  545. /// <param name="Kind"></param>
  546. public void OpLeaderAccount(WebCMSEntities db, Orders order, int UserId, decimal Money, int Count = 1, int ReserveRecordId = 0)
  547. {
  548. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  549. if (account == null)
  550. {
  551. account = db.UserAccount.Add(new UserAccount()
  552. {
  553. Id = UserId,
  554. UserId = UserId,
  555. }).Entity;
  556. db.SaveChanges();
  557. }
  558. int ChangeType = 0;
  559. if(Money == 400)
  560. {
  561. ChangeType = 117;
  562. }
  563. decimal BeforeLeaderBalanceAmount = account.LeaderBalanceAmount; //变更前余额
  564. account.LeaderBalanceAmount += Money * Count;
  565. decimal AfterLeaderBalanceAmount = account.LeaderBalanceAmount; //变更后余额
  566. LeaderAccountRecord leaderAccountRecord = db.LeaderAccountRecord.Add(new LeaderAccountRecord()
  567. {
  568. CreateDate = DateTime.Now,
  569. UpdateDate = DateTime.Now,
  570. UserId = UserId, //创客
  571. ChangeType = ChangeType, //变动类型
  572. ChangeAmount = Money * Count, //变更金额
  573. BeforeBalanceAmount = BeforeLeaderBalanceAmount, //变更前余额
  574. AfterBalanceAmount = AfterLeaderBalanceAmount, //变更后余额
  575. QueryCount = order.Id,
  576. Sort = order.UserId,
  577. }).Entity;
  578. db.SaveChanges();
  579. if(ReserveRecordId > 0)
  580. {
  581. LeaderReserveRecord edit = db.LeaderReserveRecord.FirstOrDefault(m => m.Id == ReserveRecordId);
  582. if(edit != null)
  583. {
  584. edit.AccountRecordId = leaderAccountRecord.Id;
  585. db.SaveChanges();
  586. }
  587. }
  588. }
  589. /// <summary>
  590. /// 操作余额
  591. /// </summary>
  592. /// <param name="db"></param>
  593. /// <param name="order"></param>
  594. /// <param name="UserId"></param>
  595. /// <param name="Money"></param>
  596. /// <param name="Count"></param>
  597. public void OpAccount(WebCMSEntities db, int OrderId, int UserId, decimal Money, int Count = 1, int ChangeType = 0, int Kind = 0)
  598. {
  599. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  600. if (account == null)
  601. {
  602. account = db.UserAccount.Add(new UserAccount()
  603. {
  604. Id = UserId,
  605. UserId = UserId,
  606. }).Entity;
  607. db.SaveChanges();
  608. }
  609. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  610. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  611. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  612. account.BalanceAmount += Money * Count;
  613. account.TotalAmount += Money * Count;
  614. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  615. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  616. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  617. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  618. {
  619. CreateDate = DateTime.Now,
  620. UpdateDate = DateTime.Now,
  621. UserId = UserId, //创客
  622. ChangeType = ChangeType, //变动类型
  623. ChangeAmount = Money * Count, //变更金额
  624. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  625. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  626. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  627. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  628. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  629. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  630. QueryCount = OrderId,
  631. Kind = Kind,
  632. }).Entity;
  633. db.SaveChanges();
  634. }
  635. /// <summary>
  636. /// 操作运营中心/合伙人额度(TotalAmt未使用额度,ValidForGetAmount可提现额度)
  637. /// </summary>
  638. /// <param name="db"></param>
  639. /// <param name="UserId"></param>
  640. /// <param name="Money"></param>
  641. /// <param name="OperateType">(1增加,2减少)</param>
  642. /// <param name="AmountType">(1未使用额度,2可提现额度)</param>
  643. /// <param name="Remark"></param>
  644. /// <param name="record"></param>
  645. public void OperateAmountChange(OpModels.WebCMSEntities db, int UserId, decimal Money, int OperateType, int AmountType, string Remark = "", bool record = false, int OrderId = 0)
  646. {
  647. OpModels.UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  648. if (account == null)
  649. {
  650. account = db.UserAccount.Add(new OpModels.UserAccount()
  651. {
  652. Id = UserId,
  653. UserId = UserId,
  654. }).Entity;
  655. db.SaveChanges();
  656. }
  657. decimal BeforeAmount = account.ValidAmount + account.TotalAmt + account.ValidForGetAmount; //变更前总金额
  658. if(OperateType == 1)
  659. {
  660. if(AmountType == 1)
  661. {
  662. account.TotalAmt += Money;
  663. }
  664. else if(AmountType == 2)
  665. {
  666. account.ValidForGetAmount += Money;
  667. }
  668. else
  669. {
  670. account.ValidAmount += Money;
  671. }
  672. }
  673. else
  674. {
  675. if(AmountType == 1)
  676. {
  677. account.TotalAmt -= Money;
  678. }
  679. else if(AmountType == 2)
  680. {
  681. account.ValidForGetAmount -= Money;
  682. }
  683. else
  684. {
  685. account.ValidAmount -= Money;
  686. }
  687. }
  688. decimal AfterAmount = account.ValidAmount + account.TotalAmt + account.ValidForGetAmount; //变更后总金额
  689. if(record)
  690. {
  691. OpModels.AmountRecord add = db.AmountRecord.Add(new OpModels.AmountRecord()
  692. {
  693. CreateDate = DateTime.Now,
  694. UpdateDate = DateTime.Now,
  695. OperateType = OperateType,
  696. AfterAmount = AfterAmount,
  697. AfterValidForGetAmount = account.ValidForGetAmount,
  698. AfterTotalAmt = account.TotalAmt,
  699. AfterValidAmount = account.ValidAmount,
  700. BeforeAmount = BeforeAmount,
  701. UseAmount = Money,
  702. UserId = UserId,
  703. SeoDescription = Remark,
  704. Version = AmountType,
  705. QueryCount = OrderId,
  706. }).Entity;
  707. OpModels.AmountChangeRecord amountChangeRecord = db.AmountChangeRecord.Add(new OpModels.AmountChangeRecord()
  708. {
  709. AmountType = 2,//1 未使用额度 2 可提现额度 3 关联分仓额度
  710. CreateDate = DateTime.Now,
  711. Title = Remark,
  712. UserId = UserId, //运营中心Id
  713. BeforeAmount = BeforeAmount,//使用前剩余额度
  714. AfterAmount = AfterAmount,//使用后剩余额度
  715. ChangeAmount = Money,//操作金额
  716. OperateType = OperateType,//操作类别
  717. Sort = OrderId,
  718. }).Entity;
  719. }
  720. db.SaveChanges();
  721. }
  722. /// <summary>
  723. /// 给券设置大盟主标记
  724. /// </summary>
  725. /// <param name="db"></param>
  726. /// <param name="LeaderUserId"></param>
  727. /// <param name="Count"></param>
  728. /// <param name="couponIds"></param>
  729. public int SetPosCouponLeaderFlag(WebCMSEntities db, int LeaderUserId, int Count, List<int> couponIds)
  730. {
  731. int SetCount = 0;
  732. UserAccount pacccount = db.UserAccount.FirstOrDefault(m => m.Id == LeaderUserId) ?? new UserAccount();
  733. foreach(int couponId in couponIds)
  734. {
  735. PosCoupons coupon = db.PosCoupons.FirstOrDefault(m => m.Id == couponId);
  736. if(coupon != null && pacccount.LeaderReserve >= 400 * Count)
  737. {
  738. coupon.LeaderUserId = LeaderUserId;
  739. SetCount += 1;
  740. }
  741. }
  742. db.SaveChanges();
  743. return SetCount;
  744. }
  745. /// <summary>
  746. /// 获取购机奖金额
  747. /// </summary>
  748. /// <param name="user"></param>
  749. /// <returns></returns>
  750. public decimal GetBuyPrize(UserRankItem user)
  751. {
  752. if(user.OperateLevel == 1) return 100;
  753. if(user.OperateLevel == 2) return 160;
  754. if(user.OperateLevel == 3) return 180;
  755. if(user.OperateLevel == 4) return 200;
  756. if(user.LeaderLevel > 0) return 100;
  757. return 0;
  758. }
  759. /// <summary>
  760. /// 获取可提现金额
  761. /// </summary>
  762. /// <param name="user"></param>
  763. /// <returns></returns>
  764. public decimal GetWithdrawMoney(UserRankItem user)
  765. {
  766. if(user.OperateLevel == 1) return 400;
  767. // if(user.OperateLevel == 2) return 340;
  768. // if(user.OperateLevel == 3) return 320;
  769. // if(user.OperateLevel == 4) return 300;
  770. if(user.OperateLevel == 2) return 400;
  771. if(user.OperateLevel == 3) return 400;
  772. if(user.OperateLevel == 4) return 400;
  773. if(user.AgoLeaderLevel > 0) return 400;
  774. return 0;
  775. }
  776. /// <summary>
  777. /// 预设职级
  778. /// </summary>
  779. /// <param name="db"></param>
  780. /// <param name="UserId">创客Id</param>
  781. /// <param name="Rank">职级</param>
  782. /// <param name="ExpiredDate">过期时间</param>
  783. public void PreUserLevel(WebCMSEntities db, int UserId, int Rank, DateTime ExpiredDate)
  784. {
  785. UserRankWhite rank = db.UserRankWhite.FirstOrDefault(m => m.Id == UserId);
  786. if(rank == null)
  787. {
  788. rank = db.UserRankWhite.Add(new UserRankWhite()
  789. {
  790. CreateDate = DateTime.Now, //设置时间
  791. UserId = UserId, //用户
  792. Id = UserId,
  793. }).Entity;
  794. db.SaveChanges();
  795. }
  796. rank.Rank = Rank;
  797. rank.UpdateDate = ExpiredDate;
  798. db.SaveChanges();
  799. }
  800. }
  801. }