PosCouponPrizeService.cs 37 KB

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