PosCouponPrizeService.cs 34 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806
  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 dosomething2(int OrderId)
  204. {
  205. WebCMSEntities db = new WebCMSEntities();
  206. OpModels.WebCMSEntities opdb = new OpModels.WebCMSEntities();
  207. Orders order = db.Orders.FirstOrDefault(m => m.Id == OrderId);
  208. if(order != null)
  209. {
  210. List<int> ChkIds = new List<int>(); //机具券商品Id集合
  211. ChkIds.Add(10);
  212. ChkIds.Add(11);
  213. ChkIds.Add(77);
  214. ChkIds.Add(78);
  215. ChkIds.Add(79);
  216. //判断是否是指定商品
  217. if(ChkIds.Contains(order.ProductId))
  218. {
  219. int Kind = 0;
  220. if (order.ProductId == 10)
  221. {
  222. Kind = 1;
  223. }
  224. else if (order.ProductId == 11)
  225. {
  226. Kind = 2;
  227. }
  228. int CouponCount = 0;
  229. if(Kind == 1)
  230. {
  231. CouponCount = 3 * order.BuyCount;
  232. }
  233. else if(Kind == 2)
  234. {
  235. CouponCount = 2 * order.BuyCount;
  236. }
  237. UserRankItem orderUser = GetUserLevel(order.UserId);
  238. if(orderUser.UserLevel == 0)
  239. {
  240. }
  241. string ParentNav = orderUser.ParentNav + "," + orderUser.Id + ",";
  242. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  243. Array.Reverse(ParentNavList);
  244. int index = 0;
  245. bool DirectPrizeFlag = false; //推荐奖励发放标识
  246. bool BackAccountFlag = false; //备用金返余额标识
  247. bool BigLeaderFlag = false; //大盟主标记
  248. decimal BuyPrize = 0; //购机奖励
  249. foreach(string ParentId in ParentNavList)
  250. {
  251. UserRankItem parentUser = GetUserLevel(int.Parse(ParentId));
  252. index += 1;
  253. if(index == 1 && (orderUser.LeaderLevel > 0 || orderUser.OperateLevel > 0) && !DirectPrizeFlag)
  254. {
  255. DirectPrizeFlag = true;
  256. }
  257. if(index > 1)
  258. {
  259. if(Utils.Instance.IsStandardUser(parentUser.Id) && !DirectPrizeFlag)
  260. {
  261. DirectPrizeFlag = true;
  262. }
  263. }
  264. if(parentUser.AgoLeaderLevel > 0 && CheckLeaderReserve(db, order.BuyCount, parentUser.Id))
  265. {
  266. //购机奖
  267. if(parentUser.LeaderLevel > 0)
  268. {
  269. decimal CurBuyPrize = GetBuyPrize(parentUser);
  270. decimal GetPrize = CurBuyPrize - BuyPrize;
  271. if(GetPrize > 0)
  272. {
  273. bool PrizeFlag = true;
  274. int ChangeType = 118;
  275. if(parentUser.OperateLevel == 1)
  276. {
  277. ChangeType = 120;
  278. }
  279. if(parentUser.OperateLevel > 1)
  280. {
  281. ChangeType = 128;
  282. if(function.CheckNull(RedisDbconn.Instance.Get<string>("YingXunUser")).Contains("," + orderUser.Id + ","))
  283. {
  284. PrizeFlag = false;
  285. }
  286. }
  287. if(PrizeFlag && !db.UserAccountRecord.Any(m => m.QueryCount == order.Id && m.ChangeType == 128) && GetPrize == 60)
  288. {
  289. OpAccount(db, order.Id, parentUser.Id, GetPrize, order.BuyCount, ChangeType);
  290. }
  291. BuyPrize = CurBuyPrize;
  292. }
  293. }
  294. if(!BackAccountFlag)
  295. {
  296. BackAccountFlag = true;
  297. }
  298. }
  299. else if(parentUser.OperateLevel > 0 && CheckOpReserve(opdb, order.BuyCount, parentUser.Id))
  300. {
  301. //购机奖
  302. decimal CurBuyPrize = GetBuyPrize(parentUser);
  303. decimal GetPrize = CurBuyPrize - BuyPrize;
  304. if(GetPrize > 0)
  305. {
  306. int ChangeType = 120;
  307. if(parentUser.OperateLevel > 1)
  308. {
  309. ChangeType = 128;
  310. }
  311. BuyPrize = CurBuyPrize;
  312. }
  313. if(!BackAccountFlag)
  314. {
  315. BackAccountFlag = true;
  316. }
  317. }
  318. }
  319. }
  320. }
  321. db.Dispose();
  322. opdb.Dispose();
  323. }
  324. /// <summary>
  325. /// 获取创客各种等级
  326. /// </summary>
  327. /// <param name="db"></param>
  328. /// <param name="UserId"></param>
  329. /// <returns></returns>
  330. public UserRankItem GetUserLevel(int UserId)
  331. {
  332. WebCMSEntities db = new WebCMSEntities();
  333. OpModels.WebCMSEntities opdb = new OpModels.WebCMSEntities();
  334. UserRankItem dic = new UserRankItem();
  335. DateTime now = DateTime.Now;
  336. Users user = db.Users.FirstOrDefault(m => m.Id == UserId && m.AuthFlag == 1 && m.Status > -1) ?? new Users();
  337. UserRankWhite userWhite = db.UserRankWhite.FirstOrDefault(m => m.Id == UserId && m.UpdateDate > now) ?? new UserRankWhite();
  338. Leaders leader = db.Leaders.FirstOrDefault(m => m.Id == UserId) ?? new Leaders();
  339. dic.UserLevel = userWhite.Rank > user.UserLevel ? userWhite.Rank : user.UserLevel;
  340. if(leader.ExpiredDate > now)
  341. {
  342. dic.LeaderLevel = leader.LeaderLevel;
  343. }
  344. dic.AgoLeaderLevel = leader.LeaderLevel;
  345. // OpModels.SysAdmin sys = opdb.SysAdmin.FirstOrDefault(m => m.UserId == UserId) ?? new OpModels.SysAdmin();
  346. // if(sys.ExpireDate > now)
  347. // {
  348. dic.OperateLevel = user.UserType;
  349. dic.UserType = user.UserType;
  350. // }
  351. dic.MerchantType = user.MerchantType;
  352. dic.Id = user.Id;
  353. dic.MakerCode = user.MakerCode;
  354. dic.RealName = user.RealName;
  355. dic.ParentUserId = user.ParentUserId;
  356. dic.ParentNav = user.ParentNav;
  357. db.Dispose();
  358. opdb.Dispose();
  359. return dic;
  360. }
  361. /// <summary>
  362. /// 直推奖励
  363. /// </summary>
  364. /// <param name="db"></param>
  365. /// <param name="OrderId"></param>
  366. /// <param name="UserId"></param>
  367. /// <param name="Count"></param>
  368. public void DirectPrize(WebCMSEntities db, int OrderId, int UserId, int Count = 1)
  369. {
  370. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  371. if (account == null)
  372. {
  373. account = db.UserAccount.Add(new UserAccount()
  374. {
  375. Id = UserId,
  376. UserId = UserId,
  377. }).Entity;
  378. db.SaveChanges();
  379. }
  380. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  381. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  382. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  383. account.BalanceAmount += 100 * Count;
  384. account.TotalAmount += 100 * Count;
  385. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  386. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  387. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  388. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  389. {
  390. CreateDate = DateTime.Now,
  391. UpdateDate = DateTime.Now,
  392. UserId = UserId, //创客
  393. ChangeType = 112, //变动类型
  394. ChangeAmount = 100 * Count, //变更金额
  395. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  396. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  397. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  398. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  399. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  400. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  401. QueryCount = OrderId,
  402. }).Entity;
  403. db.SaveChanges();
  404. }
  405. /// <summary>
  406. /// 判断盟主储蓄金足够
  407. /// </summary>
  408. /// <param name="db"></param>
  409. /// <param name="Count"></param>
  410. /// <param name="UserId"></param>
  411. /// <returns></returns>
  412. public bool CheckLeaderReserve(WebCMSEntities db, int Count, int UserId)
  413. {
  414. UserAccount acccount = db.UserAccount.FirstOrDefault(m => m.Id == UserId) ?? new UserAccount();
  415. if(acccount.LeaderReserve >= 400 * Count)
  416. {
  417. return true;
  418. }
  419. return false;
  420. }
  421. /// <summary>
  422. /// 判断运营中心/合伙人额度足够
  423. /// </summary>
  424. /// <param name="db"></param>
  425. /// <param name="Count"></param>
  426. /// <param name="UserId"></param>
  427. /// <returns></returns>
  428. public bool CheckOpReserve(OpModels.WebCMSEntities db, int Count, int UserId)
  429. {
  430. OpModels.UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId) ?? new OpModels.UserAccount();
  431. if(account.TotalAmt >= 400 * Count)
  432. {
  433. return true;
  434. }
  435. return false;
  436. }
  437. public bool CheckOpReserve(OpModels.WebCMSEntities db, decimal Amt, int UserId)
  438. {
  439. OpModels.UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId) ?? new OpModels.UserAccount();
  440. if(account.TotalAmt >= Amt)
  441. {
  442. return true;
  443. }
  444. return false;
  445. }
  446. /// <summary>
  447. /// 扣减/增加盟主储蓄金
  448. /// </summary>
  449. /// <param name="db"></param>
  450. /// <param name="OrderId"></param>
  451. /// <param name="UserId"></param>
  452. /// <param name="Money"></param>
  453. /// <param name="ChangeType"></param>
  454. /// <param name="SourceUserId"></param>
  455. /// <param name="Remark"></param>
  456. public int OpReserve(WebCMSEntities db, int OrderId, int UserId, decimal Money, int ChangeType, int SourceUserId = 0, string Remark = "储备金购买")
  457. {
  458. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  459. if (account == null)
  460. {
  461. account = db.UserAccount.Add(new UserAccount()
  462. {
  463. Id = UserId,
  464. UserId = UserId,
  465. }).Entity;
  466. db.SaveChanges();
  467. }
  468. decimal BeforeAmount = account.LeaderReserve; //变更前总金额
  469. if(ChangeType == 1)
  470. {
  471. account.LeaderReserve += Money;
  472. }
  473. else
  474. {
  475. account.LeaderReserve -= Money;
  476. }
  477. decimal AfterAmount = account.LeaderReserve; //变更后总金额
  478. LeaderReserveRecord add = db.LeaderReserveRecord.Add(new LeaderReserveRecord()
  479. {
  480. CreateDate = DateTime.Now,
  481. ChangeType = ChangeType,
  482. OrderId = OrderId,
  483. Remark = Remark,
  484. AfterAmt = AfterAmount,
  485. BeforeAmt = BeforeAmount,
  486. ChangeAmt = Money,
  487. TradeDate = DateTime.Now.ToString("yyyyMMdd"),
  488. TradeMonth = DateTime.Now.ToString("yyyyMM"),
  489. UserId = UserId,
  490. SourceUserId = SourceUserId,
  491. Sort = GetLeaderReserveRecordType(Remark),
  492. }).Entity;
  493. db.SaveChanges();
  494. return add.Id;
  495. }
  496. private int GetLeaderReserveRecordType(string Remark)
  497. {
  498. Dictionary<int, string> data = new Dictionary<int, string>();
  499. data.Add(11, "兑换机具券,机具券兑换,系统增加(盟主储蓄金),系统扣减(盟主储蓄金),储备金购买");
  500. data.Add(12, "系统增加(可提现余额),系统扣减(可提现余额)");
  501. data.Add(13, "推荐大盟主,推荐小盟主,商城购机,购机奖励");
  502. var item = data.FirstOrDefault(m => m.Value.Contains(Remark));
  503. if(item.Key > 0)
  504. {
  505. return item.Key;
  506. }
  507. return 0;
  508. }
  509. /// <summary>
  510. /// 操作盟主可提现余额
  511. /// </summary>
  512. /// <param name="db"></param>
  513. /// <param name="order"></param>
  514. /// <param name="UserId"></param>
  515. /// <param name="Money"></param>
  516. /// <param name="Count"></param>
  517. /// <param name="Kind"></param>
  518. public void OpLeaderAccount(WebCMSEntities db, Orders order, int UserId, decimal Money, int Count = 1, int ReserveRecordId = 0)
  519. {
  520. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  521. if (account == null)
  522. {
  523. account = db.UserAccount.Add(new UserAccount()
  524. {
  525. Id = UserId,
  526. UserId = UserId,
  527. }).Entity;
  528. db.SaveChanges();
  529. }
  530. int ChangeType = 0;
  531. if(Money == 400)
  532. {
  533. ChangeType = 117;
  534. }
  535. decimal BeforeLeaderBalanceAmount = account.LeaderBalanceAmount; //变更前余额
  536. account.LeaderBalanceAmount += Money * Count;
  537. decimal AfterLeaderBalanceAmount = account.LeaderBalanceAmount; //变更后余额
  538. LeaderAccountRecord leaderAccountRecord = db.LeaderAccountRecord.Add(new LeaderAccountRecord()
  539. {
  540. CreateDate = DateTime.Now,
  541. UpdateDate = DateTime.Now,
  542. UserId = UserId, //创客
  543. ChangeType = ChangeType, //变动类型
  544. ChangeAmount = Money * Count, //变更金额
  545. BeforeBalanceAmount = BeforeLeaderBalanceAmount, //变更前余额
  546. AfterBalanceAmount = AfterLeaderBalanceAmount, //变更后余额
  547. QueryCount = order.Id,
  548. Sort = order.UserId,
  549. }).Entity;
  550. db.SaveChanges();
  551. if(ReserveRecordId > 0)
  552. {
  553. LeaderReserveRecord edit = db.LeaderReserveRecord.FirstOrDefault(m => m.Id == ReserveRecordId);
  554. if(edit != null)
  555. {
  556. edit.AccountRecordId = leaderAccountRecord.Id;
  557. db.SaveChanges();
  558. }
  559. }
  560. }
  561. /// <summary>
  562. /// 操作余额
  563. /// </summary>
  564. /// <param name="db"></param>
  565. /// <param name="order"></param>
  566. /// <param name="UserId"></param>
  567. /// <param name="Money"></param>
  568. /// <param name="Count"></param>
  569. public void OpAccount(WebCMSEntities db, int OrderId, int UserId, decimal Money, int Count = 1, int ChangeType = 0, int Kind = 0)
  570. {
  571. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  572. if (account == null)
  573. {
  574. account = db.UserAccount.Add(new UserAccount()
  575. {
  576. Id = UserId,
  577. UserId = UserId,
  578. }).Entity;
  579. db.SaveChanges();
  580. }
  581. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  582. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  583. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  584. account.BalanceAmount += Money * Count;
  585. account.TotalAmount += Money * Count;
  586. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  587. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  588. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  589. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  590. {
  591. CreateDate = DateTime.Now,
  592. UpdateDate = DateTime.Now,
  593. UserId = UserId, //创客
  594. ChangeType = ChangeType, //变动类型
  595. ChangeAmount = Money * Count, //变更金额
  596. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  597. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  598. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  599. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  600. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  601. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  602. QueryCount = OrderId,
  603. Kind = Kind,
  604. }).Entity;
  605. db.SaveChanges();
  606. }
  607. /// <summary>
  608. /// 操作运营中心/合伙人额度(TotalAmt未使用额度,ValidForGetAmount可提现额度)
  609. /// </summary>
  610. /// <param name="db"></param>
  611. /// <param name="UserId"></param>
  612. /// <param name="Money"></param>
  613. /// <param name="OperateType">(1增加,2减少)</param>
  614. /// <param name="AmountType">(1未使用额度,2可提现额度)</param>
  615. /// <param name="Remark"></param>
  616. /// <param name="record"></param>
  617. public void OperateAmountChange(OpModels.WebCMSEntities db, int UserId, decimal Money, int OperateType, int AmountType, string Remark = "", bool record = false, int OrderId = 0)
  618. {
  619. OpModels.UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  620. if (account == null)
  621. {
  622. account = db.UserAccount.Add(new OpModels.UserAccount()
  623. {
  624. Id = UserId,
  625. UserId = UserId,
  626. }).Entity;
  627. db.SaveChanges();
  628. }
  629. decimal BeforeAmount = account.ValidAmount + account.TotalAmt + account.ValidForGetAmount; //变更前总金额
  630. if(OperateType == 1)
  631. {
  632. if(AmountType == 1)
  633. {
  634. account.TotalAmt += Money;
  635. }
  636. else if(AmountType == 2)
  637. {
  638. account.ValidForGetAmount += Money;
  639. }
  640. else
  641. {
  642. account.ValidAmount += Money;
  643. }
  644. }
  645. else
  646. {
  647. if(AmountType == 1)
  648. {
  649. account.TotalAmt -= Money;
  650. }
  651. else if(AmountType == 2)
  652. {
  653. account.ValidForGetAmount -= Money;
  654. }
  655. else
  656. {
  657. account.ValidAmount -= Money;
  658. }
  659. }
  660. decimal AfterAmount = account.ValidAmount + account.TotalAmt + account.ValidForGetAmount; //变更后总金额
  661. if(record)
  662. {
  663. OpModels.AmountRecord add = db.AmountRecord.Add(new OpModels.AmountRecord()
  664. {
  665. CreateDate = DateTime.Now,
  666. UpdateDate = DateTime.Now,
  667. OperateType = OperateType,
  668. AfterAmount = AfterAmount,
  669. AfterValidForGetAmount = account.ValidForGetAmount,
  670. AfterTotalAmt = account.TotalAmt,
  671. AfterValidAmount = account.ValidAmount,
  672. BeforeAmount = BeforeAmount,
  673. UseAmount = Money,
  674. UserId = UserId,
  675. SeoDescription = Remark,
  676. Version = AmountType,
  677. QueryCount = OrderId,
  678. }).Entity;
  679. OpModels.AmountChangeRecord amountChangeRecord = db.AmountChangeRecord.Add(new OpModels.AmountChangeRecord()
  680. {
  681. AmountType = 2,//1 未使用额度 2 可提现额度 3 关联分仓额度
  682. CreateDate = DateTime.Now,
  683. Title = Remark,
  684. UserId = UserId, //运营中心Id
  685. BeforeAmount = BeforeAmount,//使用前剩余额度
  686. AfterAmount = AfterAmount,//使用后剩余额度
  687. ChangeAmount = Money,//操作金额
  688. OperateType = OperateType,//操作类别
  689. Sort = OrderId,
  690. }).Entity;
  691. }
  692. db.SaveChanges();
  693. }
  694. /// <summary>
  695. /// 给券设置大盟主标记
  696. /// </summary>
  697. /// <param name="db"></param>
  698. /// <param name="LeaderUserId"></param>
  699. /// <param name="Count"></param>
  700. /// <param name="couponIds"></param>
  701. public int SetPosCouponLeaderFlag(WebCMSEntities db, int LeaderUserId, int Count, List<int> couponIds)
  702. {
  703. int SetCount = 0;
  704. UserAccount pacccount = db.UserAccount.FirstOrDefault(m => m.Id == LeaderUserId) ?? new UserAccount();
  705. foreach(int couponId in couponIds)
  706. {
  707. PosCoupons coupon = db.PosCoupons.FirstOrDefault(m => m.Id == couponId);
  708. if(coupon != null && pacccount.LeaderReserve >= 400 * Count)
  709. {
  710. coupon.LeaderUserId = LeaderUserId;
  711. SetCount += 1;
  712. }
  713. }
  714. db.SaveChanges();
  715. return SetCount;
  716. }
  717. /// <summary>
  718. /// 获取购机奖金额
  719. /// </summary>
  720. /// <param name="user"></param>
  721. /// <returns></returns>
  722. public decimal GetBuyPrize(UserRankItem user)
  723. {
  724. if(user.OperateLevel == 1) return 100;
  725. if(user.OperateLevel == 2) return 160;
  726. if(user.OperateLevel == 3) return 180;
  727. if(user.OperateLevel == 4) return 200;
  728. if(user.LeaderLevel > 0) return 100;
  729. return 0;
  730. }
  731. /// <summary>
  732. /// 获取可提现金额
  733. /// </summary>
  734. /// <param name="user"></param>
  735. /// <returns></returns>
  736. public decimal GetWithdrawMoney(UserRankItem user)
  737. {
  738. if(user.OperateLevel == 1) return 400;
  739. // if(user.OperateLevel == 2) return 340;
  740. // if(user.OperateLevel == 3) return 320;
  741. // if(user.OperateLevel == 4) return 300;
  742. if(user.OperateLevel == 2) return 400;
  743. if(user.OperateLevel == 3) return 400;
  744. if(user.OperateLevel == 4) return 400;
  745. if(user.AgoLeaderLevel > 0) return 400;
  746. return 0;
  747. }
  748. /// <summary>
  749. /// 预设职级
  750. /// </summary>
  751. /// <param name="db"></param>
  752. /// <param name="UserId">创客Id</param>
  753. /// <param name="Rank">职级</param>
  754. /// <param name="ExpiredDate">过期时间</param>
  755. public void PreUserLevel(WebCMSEntities db, int UserId, int Rank, DateTime ExpiredDate)
  756. {
  757. UserRankWhite rank = db.UserRankWhite.FirstOrDefault(m => m.Id == UserId);
  758. if(rank == null)
  759. {
  760. rank = db.UserRankWhite.Add(new UserRankWhite()
  761. {
  762. CreateDate = DateTime.Now, //设置时间
  763. UserId = UserId, //用户
  764. Id = UserId,
  765. }).Entity;
  766. db.SaveChanges();
  767. }
  768. rank.Rank = Rank;
  769. rank.UpdateDate = ExpiredDate;
  770. db.SaveChanges();
  771. }
  772. }
  773. }