AlipayPayBack2Service.cs 45 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010
  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 || Kind == 3)
  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, order.Id, "购买大盟主");
  223. //自留券数量清除
  224. CancelStayCoupon(db, order.UserId, 7);
  225. //预设大盟主职级
  226. LeaderPreUserLevel(db, order.UserId, 2);
  227. AddLeader(db, order.UserId, 2);
  228. decimal Prize = decimal.Parse(function.CheckNum(PublicFunction.GetPublicParam(db, "BigLeaderPrize")));
  229. if(Prize > 0 && BeforeLeaderLevel < 2 && user.UserType == 0)
  230. {
  231. LeaderRecommendPrize(db, order, user.Id, Prize, 122);
  232. }
  233. }
  234. }
  235. if (pro.ProductId == 28) //购买小盟主,给上级大盟主返储备金
  236. {
  237. bool check = LeaderBack(db, order);
  238. Users user = db.Users.FirstOrDefault(m => m.Id == order.UserId) ?? new Users();
  239. //自留券数量清除
  240. CancelStayCoupon(db, order.UserId, 5);
  241. if (check) OperateReserveBackFor(db, user.Id, 10000, order.Id, "购买小盟主");
  242. //预设小盟主职级
  243. LeaderPreUserLevel(db, order.UserId, 1);
  244. AddLeader(db, order.UserId, 1);
  245. decimal Prize = decimal.Parse(function.CheckNum(PublicFunction.GetPublicParam(db, "SmallLeaderPrize")));
  246. if(Prize > 0 && BeforeLeaderLevel < 1 && user.UserType == 0)
  247. {
  248. LeaderRecommendPrize(db, order, user.Id, Prize, 123);
  249. }
  250. }
  251. }
  252. // 购买盟主储蓄金
  253. if (pro.ProductId == 39 || pro.ProductId == 40)
  254. {
  255. order.Status = 2;
  256. //充值盟主储备金
  257. decimal TotalPrice = 10000;
  258. if(pro.ProductId == 39)
  259. {
  260. TotalPrice = 40000;
  261. }
  262. OpReserve(db, order, order.UserId, TotalPrice, 1);
  263. if(pro.ProductId == 39) //购买大盟主储蓄金,给上级运营中心返可提现金额
  264. {
  265. OperateReserveBackFor(db, order.UserId, 40000, order.Id);
  266. AddLeader(db, order.UserId, 2);
  267. LeaderPreUserLevel(db, order.UserId, 2);
  268. }
  269. else if(pro.ProductId == 40) //购买小盟主储蓄金,给上级大盟主返储备金
  270. {
  271. LeaderBack(db, order);
  272. AddLeader(db, order.UserId, 1);
  273. LeaderPreUserLevel(db, order.UserId, 1);
  274. }
  275. }
  276. //推荐下单奖励
  277. RedisDbconn.Instance.AddList("PosCouponPrizeQueue", order.Id.ToString());
  278. //推荐王
  279. if(pro.ProductId == 29)
  280. {
  281. RecommendMethod(order.UserId, order.CreateDate.Value.ToString("yyyyMM"));
  282. }
  283. //购买分仓临时额度
  284. if(pro.ProductId == 30 || pro.ProductId == 31 || pro.ProductId == 32)
  285. {
  286. string SendData = "{\"Kind\":\"1\",\"Data\":{\"OrderId\":\"" + order.Id + "\"}}";
  287. RedisDbconn.Instance.AddList("StoreApplyQueue", SendData);
  288. }
  289. //购买小分仓临时额度
  290. if(pro.ProductId == 56 || pro.ProductId == 57 || pro.ProductId == 58)
  291. {
  292. string SendData = "{\"Kind\":\"1\",\"Data\":{\"OrderId\":\"" + order.Id + "\"}}";
  293. RedisDbconn.Instance.AddList("PreStoreApplyQueue", SendData);
  294. }
  295. }
  296. else
  297. {
  298. if(order.ProductId > 0 && order.ErpMode > 0)
  299. {
  300. //盟主储备金-升级/购买 ErpMode:1-升级,2-购买
  301. if(order.ErpMode > 0)
  302. {
  303. Users user = db.Users.FirstOrDefault(m => m.Id == order.UserId);
  304. if(user != null)
  305. {
  306. if(order.ErpMode == 1)
  307. {
  308. user.LeaderLevel = 2;
  309. db.SaveChanges();
  310. }
  311. OpReserve(db, order, order.UserId, order.TotalPrice, 1);
  312. }
  313. }
  314. }
  315. }
  316. }
  317. }
  318. //小盟主购买逻辑
  319. public bool LeaderBack(WebCMSEntities db, Orders order)
  320. {
  321. function.WriteLog("OrderId:" + order.Id, "操作小盟主购买逻辑监控日志");
  322. int LeaderUserId = order.UserId;
  323. int level = 0;
  324. bool result = true;
  325. while(LeaderUserId > 0)
  326. {
  327. level += 1;
  328. Users user = db.Users.FirstOrDefault(m => m.Id == LeaderUserId) ?? new Users();
  329. // UserRankItem user = PosCouponPrizeService.Instance.GetUserLevel(db, LeaderUserId);
  330. if(user.Id > 0)
  331. {
  332. function.WriteLog("UserId:" + user.Id + ";LeaderLevel:" + user.LeaderLevel + ";UserType:" + user.UserType + "", "操作小盟主购买逻辑监控日志");
  333. decimal TotalPrice = 10000;
  334. if((user.LeaderLevel == 2 || user.UserType >= 1) && level > 1)
  335. {
  336. function.WriteLog("够资格", "操作小盟主购买逻辑监控日志");
  337. if(user.LeaderLevel == 2 && result)
  338. {
  339. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == user.Id);
  340. if(account != null)
  341. {
  342. function.WriteLog(str: "LeaderReserve:" + account.LeaderReserve, "操作小盟主购买逻辑监控日志");
  343. if(account.LeaderReserve >= TotalPrice)
  344. {
  345. function.WriteLog("盟主储蓄金够,可返", "操作小盟主购买逻辑监控日志");
  346. int ReserveRecordId = OpReserve(db, order, LeaderUserId, TotalPrice, 2, 0, "推荐小盟主");
  347. OpLeaderAccount(db, order, LeaderUserId, TotalPrice, 1, 1, ReserveRecordId);
  348. LeaderUserId = 0;
  349. result = false;
  350. }
  351. else
  352. {
  353. LeaderUserId = user.ParentUserId;
  354. // decimal LeaderReserve = account.LeaderReserve;
  355. // OpReserve(db, order, LeaderUserId, LeaderReserve, 2, 0, "推荐小盟主");
  356. // OpLeaderAccount(db, order, LeaderUserId, LeaderReserve);
  357. }
  358. }
  359. }
  360. if(user.UserType >= 1 && result)
  361. {
  362. OpModels.WebCMSEntities opdb = new OpModels.WebCMSEntities();
  363. OpModels.UserAccount account = opdb.UserAccount.FirstOrDefault(m => m.Id == user.Id) ?? new OpModels.UserAccount();
  364. function.WriteLog("TotalAmt:" + account.TotalAmt, "操作小盟主购买逻辑监控日志");
  365. // OpModels.SysAdmin sys = opdb.SysAdmin.FirstOrDefault(m => m.Id == LeaderUserId) ?? new OpModels.SysAdmin();
  366. if(account.TotalAmt > 0) // && sys.ExpireDate > DateTime.Now)
  367. {
  368. if(account.TotalAmt < TotalPrice)
  369. {
  370. function.WriteLog("够一部分额度", "操作小盟主购买逻辑监控日志");
  371. TotalPrice = account.TotalAmt;
  372. }
  373. if(TotalPrice > 0)
  374. {
  375. // OperateAmountChange(opdb, LeaderUserId, TotalPrice, 2, 1, "商城购机", true, order.Id);
  376. // OperateAmountChange(opdb, LeaderUserId, TotalPrice, 1, 2, "商城购机", true, order.Id);
  377. function.WriteLog("开始发放", "操作小盟主购买逻辑监控日志");
  378. OpAmountItem item = new OpAmountItem()
  379. {
  380. UserId = LeaderUserId,
  381. OperateType = 0,
  382. ChangeType = 14,
  383. Remark = "购买小盟主",
  384. UseAmount = TotalPrice,
  385. UseValidForGetAmount = TotalPrice,
  386. UseTotalAmt = TotalPrice,
  387. DataType = 1,
  388. DataId = order.Id,
  389. };
  390. RedisDbconn.Instance.AddList("OperateAmountRecordServiceQueue", item);
  391. LeaderUserId = 0;
  392. result = false;
  393. }
  394. }
  395. else
  396. {
  397. LeaderUserId = user.ParentUserId;
  398. }
  399. }
  400. else
  401. {
  402. LeaderUserId = user.ParentUserId;
  403. }
  404. }
  405. else
  406. {
  407. LeaderUserId = user.ParentUserId;
  408. }
  409. }
  410. else
  411. {
  412. LeaderUserId = 0;
  413. }
  414. }
  415. function.WriteLog("\n\n\n", "操作小盟主购买逻辑监控日志");
  416. return result;
  417. }
  418. //操作储备金
  419. private int GetLeaderReserveRecordType(string Remark)
  420. {
  421. Dictionary<int, string> data = new Dictionary<int, string>();
  422. data.Add(11, "兑换机具券,机具券兑换,系统增加(盟主储蓄金),系统扣减(盟主储蓄金),储备金购买");
  423. data.Add(12, "系统增加(可提现余额),系统扣减(可提现余额)");
  424. data.Add(13, "推荐大盟主,推荐小盟主,商城购机,购机奖励");
  425. var item = data.FirstOrDefault(m => m.Value.Contains(Remark));
  426. if(item.Key > 0)
  427. {
  428. return item.Key;
  429. }
  430. return 0;
  431. }
  432. public int OpReserve(WebCMSEntities db, Orders order, int UserId, decimal Money, int ChangeType, int SourceUserId = 0, string Remark = "储备金购买")
  433. {
  434. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  435. if (account == null)
  436. {
  437. account = db.UserAccount.Add(new UserAccount()
  438. {
  439. Id = UserId,
  440. UserId = UserId,
  441. }).Entity;
  442. db.SaveChanges();
  443. }
  444. decimal BeforeAmount = account.LeaderReserve; //变更前总金额
  445. if(ChangeType == 1)
  446. {
  447. account.LeaderReserve += Money;
  448. }
  449. else
  450. {
  451. account.LeaderReserve -= Money;
  452. }
  453. decimal AfterAmount = account.LeaderReserve; //变更后总金额
  454. LeaderReserveRecord add = db.LeaderReserveRecord.Add(new LeaderReserveRecord()
  455. {
  456. CreateDate = DateTime.Now,
  457. ChangeType = ChangeType,
  458. OrderId = order.Id,
  459. Remark = Remark,
  460. AfterAmt = AfterAmount,
  461. BeforeAmt = BeforeAmount,
  462. ChangeAmt = Money,
  463. TradeDate = DateTime.Now.ToString("yyyyMMdd"),
  464. TradeMonth = DateTime.Now.ToString("yyyyMM"),
  465. UserId = UserId,
  466. SourceUserId = SourceUserId,
  467. Sort = GetLeaderReserveRecordType(Remark),
  468. }).Entity;
  469. db.SaveChanges();
  470. return add.Id;
  471. }
  472. //操作余额
  473. public void OpAccount(WebCMSEntities db, Orders order, int UserId, decimal Money, int Count = 1)
  474. {
  475. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  476. if (account == null)
  477. {
  478. account = db.UserAccount.Add(new UserAccount()
  479. {
  480. Id = UserId,
  481. UserId = UserId,
  482. }).Entity;
  483. db.SaveChanges();
  484. }
  485. int ChangeType = 0;
  486. if(Money == 600)
  487. {
  488. ChangeType = 117;
  489. }
  490. else if(Money == 100)
  491. {
  492. ChangeType = 118;
  493. }
  494. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  495. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  496. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  497. account.BalanceAmount += Money * Count;
  498. account.TotalAmount += Money * Count;
  499. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  500. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  501. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  502. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  503. {
  504. CreateDate = DateTime.Now,
  505. UpdateDate = DateTime.Now,
  506. UserId = UserId, //创客
  507. ChangeType = ChangeType, //变动类型
  508. ChangeAmount = Money * Count, //变更金额
  509. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  510. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  511. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  512. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  513. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  514. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  515. QueryCount = order.Id,
  516. }).Entity;
  517. db.SaveChanges();
  518. }
  519. public void ChangeAccount(WebCMSEntities db, Orders order, int UserId, decimal Money, int ChangeType = 0, string Remark = "")
  520. {
  521. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  522. if (account == null)
  523. {
  524. account = db.UserAccount.Add(new UserAccount()
  525. {
  526. Id = UserId,
  527. UserId = UserId,
  528. }).Entity;
  529. db.SaveChanges();
  530. }
  531. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  532. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  533. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  534. account.BalanceAmount += Money;
  535. if(Money > 0)
  536. {
  537. account.TotalAmount += Money;
  538. }
  539. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  540. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  541. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  542. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  543. {
  544. CreateDate = DateTime.Now,
  545. UpdateDate = DateTime.Now,
  546. UserId = UserId, //创客
  547. ChangeType = ChangeType, //变动类型
  548. ChangeAmount = Math.Abs(Money), //变更金额
  549. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  550. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  551. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  552. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  553. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  554. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  555. QueryCount = order.Id,
  556. Remark = Remark,
  557. }).Entity;
  558. db.SaveChanges();
  559. }
  560. //操作盟主可提现余额
  561. public void OpLeaderAccount(WebCMSEntities db, Orders order, int UserId, decimal Money, int Count = 1, int Kind = 0, int ReserveRecordId = 0)
  562. {
  563. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  564. if (account == null)
  565. {
  566. account = db.UserAccount.Add(new UserAccount()
  567. {
  568. Id = UserId,
  569. UserId = UserId,
  570. }).Entity;
  571. db.SaveChanges();
  572. }
  573. int ChangeType = 0;
  574. if(Money == 400)
  575. {
  576. ChangeType = 117;
  577. }
  578. int LeaderId = 0;
  579. decimal LeaderReserve = 0;
  580. if(Kind == 1)
  581. {
  582. LeaderId = UserId;
  583. LeaderReserve = Money * Count;
  584. }
  585. decimal BeforeLeaderBalanceAmount = account.LeaderBalanceAmount; //变更前余额
  586. account.LeaderBalanceAmount += Money * Count;
  587. decimal AfterLeaderBalanceAmount = account.LeaderBalanceAmount; //变更后余额
  588. LeaderAccountRecord leaderAccountRecord = db.LeaderAccountRecord.Add(new LeaderAccountRecord()
  589. {
  590. CreateDate = DateTime.Now,
  591. UpdateDate = DateTime.Now,
  592. UserId = UserId, //创客
  593. ChangeType = ChangeType, //变动类型
  594. ChangeAmount = Money * Count, //变更金额
  595. BeforeBalanceAmount = BeforeLeaderBalanceAmount, //变更前余额
  596. AfterBalanceAmount = AfterLeaderBalanceAmount, //变更后余额
  597. QueryCount = order.Id,
  598. Sort = order.UserId,
  599. LeaderId = LeaderId,
  600. LeaderReserve = LeaderReserve,
  601. }).Entity;
  602. db.SaveChanges();
  603. if(ReserveRecordId > 0)
  604. {
  605. LeaderReserveRecord edit = db.LeaderReserveRecord.FirstOrDefault(m => m.Id == ReserveRecordId);
  606. if(edit != null)
  607. {
  608. edit.AccountRecordId = leaderAccountRecord.Id;
  609. db.SaveChanges();
  610. }
  611. }
  612. }
  613. public void DirectPrize(WebCMSEntities db, int OrderId, int UserId, int Count = 1)
  614. {
  615. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  616. if (account == null)
  617. {
  618. account = db.UserAccount.Add(new UserAccount()
  619. {
  620. Id = UserId,
  621. UserId = UserId,
  622. }).Entity;
  623. db.SaveChanges();
  624. }
  625. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  626. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  627. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  628. account.BalanceAmount += 100 * Count;
  629. account.TotalAmount += 100 * Count;
  630. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  631. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  632. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  633. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  634. {
  635. CreateDate = DateTime.Now,
  636. UpdateDate = DateTime.Now,
  637. UserId = UserId, //创客
  638. ChangeType = 112, //变动类型
  639. ChangeAmount = 100 * Count, //变更金额
  640. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  641. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  642. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  643. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  644. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  645. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  646. QueryCount = OrderId,
  647. }).Entity;
  648. db.SaveChanges();
  649. }
  650. // 推荐王逻辑(下单)
  651. public void RecommendMethod(int UserId, string TradeMonth)
  652. {
  653. string SendData = "{\"Kind\":\"1\",\"Data\":{\"UserId\":\"" + UserId + "\",\"TradeMonth\":\"" + TradeMonth + "\"}}";
  654. RedisDbconn.Instance.AddList("RecommendActStatQueue", SendData);
  655. }
  656. //操作运营中心额度
  657. public void OperateReserveBackFor(WebCMSEntities maindb, int UserId, decimal Money, int OrderId = 0, string Remark = "商城购机")
  658. {
  659. function.WriteLog("OrderId:" + OrderId, "操作运营中心额度监控日志");
  660. OpModels.WebCMSEntities db = new OpModels.WebCMSEntities();
  661. while(UserId > 0)
  662. {
  663. Users user = maindb.Users.FirstOrDefault(m => m.Id == UserId);
  664. if(user != null)
  665. {
  666. function.WriteLog("UserId:" + UserId, "操作运营中心额度监控日志");
  667. // DateTime now = DateTime.Now;
  668. bool sys = db.SysAdmin.Any(m => m.UserId == UserId); // && m.ExpireDate > now);
  669. if(sys)
  670. {
  671. function.WriteLog("是运营中心", "操作运营中心额度监控日志");
  672. OpModels.UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId) ?? new OpModels.UserAccount();
  673. function.WriteLog("TotalAmt:" + account.TotalAmt, "操作运营中心额度监控日志");
  674. if(account.TotalAmt >= Money)
  675. {
  676. // OperateAmountChange(db, UserId, Money, 2, 1, "商城购机", true, OrderId);
  677. // OperateAmountChange(db, UserId, Money, 1, 2, "商城购机", true, OrderId);
  678. function.WriteLog(str: "额度ok", "操作运营中心额度监控日志");
  679. OpAmountItem item = new OpAmountItem()
  680. {
  681. UserId = UserId,
  682. OperateType = 0,
  683. ChangeType = 5,
  684. Remark = Remark,
  685. UseAmount = Money,
  686. UseValidForGetAmount = Money,
  687. UseTotalAmt = Money,
  688. DataType = 1,
  689. DataId = OrderId,
  690. };
  691. RedisDbconn.Instance.AddList("OperateAmountRecordServiceQueue", item);
  692. UserId = 0;
  693. }
  694. else
  695. {
  696. function.WriteLog(str: "额度不够", "操作运营中心额度监控日志");
  697. UserId = user.ParentUserId;
  698. }
  699. }
  700. else
  701. {
  702. UserId = user.ParentUserId;
  703. }
  704. }
  705. else
  706. {
  707. UserId = 0;
  708. }
  709. }
  710. db.Dispose();
  711. function.WriteLog("\n\n\n", "操作运营中心额度监控日志");
  712. }
  713. public void OperateReserveBack(int UserId, decimal Money, int OrderId = 0)
  714. {
  715. OpModels.WebCMSEntities db = new OpModels.WebCMSEntities();
  716. OpModels.UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId) ?? new OpModels.UserAccount();
  717. if(account.TotalAmt <= 0)
  718. {
  719. return;
  720. }
  721. if(account.TotalAmt < Money)
  722. {
  723. Money = account.TotalAmt;
  724. }
  725. if(Money > 0)
  726. {
  727. // OperateAmountChange(db, UserId, Money, 2, 1, "商城购机", true, OrderId);
  728. // OperateAmountChange(db, UserId, Money, 1, 2, "商城购机", true, OrderId);
  729. OpAmountItem item = new OpAmountItem()
  730. {
  731. UserId = UserId,
  732. OperateType = 0,
  733. ChangeType = 5,
  734. Remark = "商城购机",
  735. UseAmount = Money,
  736. UseValidForGetAmount = Money,
  737. UseTotalAmt = Money,
  738. DataType = 2,
  739. DataId = OrderId,
  740. };
  741. RedisDbconn.Instance.AddList("OperateAmountRecordServiceQueue", item);
  742. }
  743. db.Dispose();
  744. }
  745. public void ActReserveBack(int UserId, decimal OpReserve1, decimal OpReserve2, decimal OpReserve3)
  746. {
  747. OpModels.WebCMSEntities db = new OpModels.WebCMSEntities();
  748. if(OpReserve1 > 0) OperateAmountChange(db, UserId, OpReserve1, 1, 1, "机具激活", true);
  749. if(OpReserve2 > 0) OperateAmountChange(db, UserId, OpReserve2, 1, 2, "机具激活", true);
  750. if(OpReserve3 > 0) OperateAmountChange(db, UserId, OpReserve3, 1, 3, "机具激活", true);
  751. db.Dispose();
  752. }
  753. public void OperateAmountChange(OpModels.WebCMSEntities db, int UserId, decimal Money, int OperateType, int AmountType, string Remark = "", bool record = false, int OrderId = 0)
  754. {
  755. OpModels.UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  756. if (account == null)
  757. {
  758. account = db.UserAccount.Add(new OpModels.UserAccount()
  759. {
  760. Id = UserId,
  761. UserId = UserId,
  762. }).Entity;
  763. db.SaveChanges();
  764. }
  765. decimal BeforeAmount = account.ValidAmount + account.TotalAmt + account.ValidForGetAmount; //变更前总金额
  766. if(OperateType == 1)
  767. {
  768. if(AmountType == 1)
  769. {
  770. // BeforeAmount = account.TotalAmt;
  771. account.TotalAmt += Money;
  772. // AfterAmount = account.TotalAmt;
  773. }
  774. else if(AmountType == 2)
  775. {
  776. // BeforeAmount = account.ValidForGetAmount;
  777. account.ValidForGetAmount += Money;
  778. // AfterAmount = account.ValidForGetAmount;
  779. }
  780. else
  781. {
  782. // BeforeAmount = account.ValidAmount;
  783. account.ValidAmount += Money;
  784. // AfterAmount = account.ValidAmount;
  785. }
  786. }
  787. else
  788. {
  789. if(AmountType == 1)
  790. {
  791. // BeforeAmount = account.TotalAmt;
  792. account.TotalAmt -= Money;
  793. // AfterAmount = account.TotalAmt;
  794. }
  795. else if(AmountType == 2)
  796. {
  797. // BeforeAmount = account.ValidForGetAmount;
  798. account.ValidForGetAmount -= Money;
  799. // AfterAmount = account.ValidForGetAmount;
  800. }
  801. else
  802. {
  803. // BeforeAmount = account.ValidAmount;
  804. account.ValidAmount -= Money;
  805. // AfterAmount = account.ValidAmount;
  806. }
  807. }
  808. decimal AfterAmount = account.ValidAmount + account.TotalAmt + account.ValidForGetAmount; //变更后总金额
  809. if(record)
  810. {
  811. OpModels.AmountRecord add = db.AmountRecord.Add(new OpModels.AmountRecord()
  812. {
  813. CreateDate = DateTime.Now,
  814. UpdateDate = DateTime.Now,
  815. OperateType = OperateType,
  816. AfterAmount = AfterAmount,
  817. AfterValidForGetAmount = account.ValidForGetAmount,
  818. AfterTotalAmt = account.TotalAmt,
  819. AfterValidAmount = account.ValidAmount,
  820. BeforeAmount = BeforeAmount,
  821. UseAmount = Money,
  822. UserId = UserId,
  823. SeoDescription = Remark,
  824. Version = AmountType,
  825. QueryCount = OrderId,
  826. }).Entity;
  827. OpModels.AmountChangeRecord amountChangeRecord = db.AmountChangeRecord.Add(new OpModels.AmountChangeRecord()
  828. {
  829. AmountType = AmountType,//1 未使用额度 2 可提现额度 3 关联分仓额度
  830. CreateDate = DateTime.Now,
  831. Title = Remark,
  832. UserId = UserId, //运营中心Id
  833. BeforeAmount = BeforeAmount,//使用前剩余额度
  834. AfterAmount = AfterAmount,//使用后剩余额度
  835. ChangeAmount = Money,//操作金额
  836. OperateType = OperateType,//操作类别
  837. Sort = OrderId,
  838. }).Entity;
  839. }
  840. db.SaveChanges();
  841. }
  842. #endregion
  843. #region 盟主推荐奖励
  844. public void LeaderRecommendPrize(WebCMSEntities db, Orders order, int UserId, decimal Money, int ChangeType)
  845. {
  846. int level = 0;
  847. while(UserId > 0)
  848. {
  849. level += 1;
  850. // Users user = db.Users.FirstOrDefault(m => m.Id == UserId);
  851. UserRankItem user = PosCouponPrizeService.Instance.GetUserLevel(UserId);
  852. if(user != null)
  853. {
  854. if((user.UserType == 1 || user.LeaderLevel > 0) && level > 1)
  855. {
  856. ChangeAccount(db, order, UserId, Money, ChangeType);
  857. UserId = 0;
  858. }
  859. else
  860. {
  861. UserId = user.ParentUserId;
  862. }
  863. }
  864. else
  865. {
  866. UserId = 0;
  867. }
  868. }
  869. db.Dispose();
  870. }
  871. #endregion
  872. #region 购买盟主预设职级
  873. public void LeaderPreUserLevel(WebCMSEntities db, int UserId, int LeaderKind)
  874. {
  875. int Month = LeaderKind == 1 ? 6 : 9;
  876. int Rank = LeaderKind == 1 ? 5 : 7;
  877. LeaderRankWhite check = db.LeaderRankWhite.FirstOrDefault(m => m.Id == UserId);
  878. if(check == null)
  879. {
  880. db.LeaderRankWhite.Add(new LeaderRankWhite()
  881. {
  882. CreateDate = DateTime.Now, //设置时间
  883. UpdateDate = DateTime.Now.AddMonths(Month), //过期时间
  884. Rank = Rank,
  885. UserId = UserId, //用户
  886. Id = UserId,
  887. });
  888. }
  889. else
  890. {
  891. if(check.Rank < Rank)
  892. {
  893. check.Rank = Rank;
  894. check.UpdateDate = DateTime.Now.AddMonths(Month);
  895. }
  896. else if(check.Rank == Rank && check.UpdateDate < DateTime.Now.AddMonths(Month))
  897. {
  898. check.UpdateDate = DateTime.Now.AddMonths(Month);
  899. }
  900. }
  901. db.SaveChanges();
  902. }
  903. //取消自留券数量
  904. public void CancelStayCoupon(WebCMSEntities db, int UserId, int CheckLevel = 5)
  905. {
  906. int myLevel = Utils.Instance.GetUserLevel(UserId);
  907. if(myLevel <= CheckLevel)
  908. {
  909. Users user = db.Users.FirstOrDefault(m => m.Id == UserId);
  910. if(user != null)
  911. {
  912. user.Version = 0;
  913. db.SaveChanges();
  914. }
  915. }
  916. }
  917. #endregion
  918. #region 记录盟主
  919. public void AddLeader(WebCMSEntities db, int UserId, int LeaderLevel)
  920. {
  921. int Month = LeaderLevel == 1 ? 6 : 9;
  922. Leaders leader = db.Leaders.FirstOrDefault(m => m.Id == UserId);
  923. if(leader == null)
  924. {
  925. db.Leaders.Add(new Leaders()
  926. {
  927. Id = UserId,
  928. CreateDate = DateTime.Now, //设置时间
  929. UserId = UserId, //用户
  930. LeaderLevel = LeaderLevel,
  931. LastBuyDate = DateTime.Now,
  932. ExpiredDate = DateTime.Now.AddMonths(Month),
  933. });
  934. }
  935. else
  936. {
  937. leader.LeaderLevel = LeaderLevel;
  938. leader.LastBuyDate = DateTime.Now;
  939. leader.ExpiredDate = DateTime.Now.AddMonths(Month);
  940. }
  941. db.SaveChanges();
  942. SendLeaderMsg(db, UserId);
  943. }
  944. #endregion
  945. #region 盟主续费通知
  946. public void SendLeaderMsg(WebCMSEntities db, int UserId)
  947. {
  948. string msg = "";
  949. Users user = db.Users.FirstOrDefault(m => m.Id == UserId) ?? new Users();
  950. DateTime now = DateTime.Now;
  951. Leaders leader = db.Leaders.FirstOrDefault(m => m.Id == UserId);
  952. if(leader != null)
  953. {
  954. if(leader.ExpiredDate >= now)
  955. {
  956. msg = "尊敬的" + user.RealName + "盟主,恭喜您的盟主已成功开通";
  957. }
  958. else
  959. {
  960. msg = "尊敬的" + user.RealName + "盟主,恭喜您重新成为盟主";
  961. }
  962. }
  963. else
  964. {
  965. msg = "尊敬的" + user.RealName + "盟主,恭喜您的盟主已成功开通";
  966. }
  967. RedisDbconn.Instance.AddList("MsgPersonalQueue", Newtonsoft.Json.JsonConvert.SerializeObject(new MsgPersonal()
  968. {
  969. UserId = Convert.ToInt32(UserId), //创客
  970. Title = "开通盟主提醒", //标题
  971. Content = msg, //内容
  972. Summary = msg,
  973. CreateDate = DateTime.Now,
  974. }));
  975. }
  976. #endregion
  977. }
  978. }