AlipayPayBack2Service.cs 71 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333
  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);
  223. //预设大盟主职级
  224. LeaderPreUserLevel(db, order.UserId, 2);
  225. AddLeader(db, order.UserId, 2);
  226. decimal Prize = decimal.Parse(function.CheckNum(PublicFunction.GetPublicParam(db, "BigLeaderPrize")));
  227. if(Prize > 0 && BeforeLeaderLevel < 2 && user.UserType == 0)
  228. {
  229. LeaderRecommendPrize(db, order, user.Id, Prize, 122);
  230. }
  231. }
  232. }
  233. if (pro.ProductId == 28) //购买小盟主,给上级大盟主返储备金
  234. {
  235. bool check = LeaderBack(db, order);
  236. Users user = db.Users.FirstOrDefault(m => m.Id == order.UserId) ?? new Users();
  237. // if (check) OperateReserveBackFor(db, user.Id, 10000);
  238. //预设小盟主职级
  239. LeaderPreUserLevel(db, order.UserId, 1);
  240. AddLeader(db, order.UserId, 1);
  241. decimal Prize = decimal.Parse(function.CheckNum(PublicFunction.GetPublicParam(db, "SmallLeaderPrize")));
  242. if(Prize > 0 && BeforeLeaderLevel < 1 && user.UserType == 0)
  243. {
  244. LeaderRecommendPrize(db, order, user.Id, Prize, 123);
  245. }
  246. }
  247. }
  248. // 购买盟主储蓄金
  249. if (pro.ProductId == 39 || pro.ProductId == 40)
  250. {
  251. order.Status = 2;
  252. //充值盟主储备金
  253. decimal TotalPrice = 10000;
  254. if(pro.ProductId == 39)
  255. {
  256. TotalPrice = 40000;
  257. }
  258. OpReserve(db, order, order.UserId, TotalPrice, 1);
  259. if(pro.ProductId == 39) //购买大盟主储蓄金,给上级运营中心返可提现金额
  260. {
  261. OperateReserveBackFor(db, order.UserId, 40000);
  262. AddLeader(db, order.UserId, 2);
  263. LeaderPreUserLevel(db, order.UserId, 2);
  264. }
  265. else if(pro.ProductId == 40) //购买小盟主储蓄金,给上级大盟主返储备金
  266. {
  267. LeaderBack(db, order);
  268. AddLeader(db, order.UserId, 1);
  269. LeaderPreUserLevel(db, order.UserId, 1);
  270. }
  271. }
  272. //推荐下单奖励
  273. List<int> LkbIds = new List<int>(); //来客吧组合包
  274. LkbIds.Add(77);
  275. LkbIds.Add(78);
  276. LkbIds.Add(79);
  277. if (pro.ProductId == 10 || pro.ProductId == 11 || LkbIds.Contains(pro.ProductId))
  278. {
  279. bool checkPrize = db.UserAccountRecord.Any(m => m.QueryCount == OrderId && m.ChangeType == 112);
  280. function.WriteLog("OrderId:" + OrderId, "推荐下单奖励监控日志");
  281. function.WriteLog("checkPrize:" + checkPrize, "推荐下单奖励监控日志");
  282. if (checkPrize)
  283. {
  284. Users user = db.Users.FirstOrDefault(m => m.Id == order.UserId);
  285. if (user != null)
  286. {
  287. if(user.LeaderLevel > 0 || user.UserType == 1) //盟主或运营中心
  288. {
  289. //获得100元奖励
  290. OpAccount(db, order, order.UserId, 100, pro.ProductCount);
  291. }
  292. }
  293. }
  294. else
  295. {
  296. Users user = db.Users.FirstOrDefault(m => m.Id == order.UserId);
  297. if (user != null)
  298. {
  299. bool directPrize = false; //直推奖标记
  300. bool bigLeaderPrize = false; //大盟主券标记
  301. bool operateFlag = false; //运营中心标记
  302. bool buyPrize = false; //返100购机奖励标记或返100购机奖励标记-运营中心
  303. int leaderFlag = 0; //返600备用金标记
  304. if(user.LeaderLevel > 0 || user.UserType == 1) //盟主或运营中心
  305. {
  306. if(user.LeaderLevel > 0)
  307. {
  308. UserAccount acccount = db.UserAccount.FirstOrDefault(m => m.Id == order.UserId) ?? new UserAccount();
  309. if(acccount.LeaderReserve >= order.TotalPrice)
  310. {
  311. if(order.PayMode == 4)
  312. {
  313. //扣减备用金
  314. OpReserve(db, order, order.UserId, order.TotalPrice, 0, 0, "商城购机(储备金支付)");
  315. }
  316. }
  317. if(acccount.LeaderReserve >= 400 * pro.ProductCount)
  318. {
  319. //获得100元奖励
  320. OpAccount(db, order, order.UserId, 100, pro.ProductCount);
  321. }
  322. }
  323. else if(user.UserType == 1)
  324. {
  325. //获得100元奖励
  326. OpAccount(db, order, order.UserId, 100, pro.ProductCount);
  327. }
  328. //推荐奖励
  329. DirectPrize(db, order.Id, order.UserId, pro.ProductCount);
  330. //推荐下单上级获得30天的机具循环天数(盟主自己得)
  331. var posList = db.PosMachinesTwo.Select(m => new { m.Id, m.UserId, m.BindingState, m.RecycEndDate }).Where(m => m.UserId == order.UserId && m.BindingState == 0 && m.RecycEndDate != null).ToList();
  332. foreach (var subPos in posList)
  333. {
  334. PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == subPos.Id);
  335. if (pos != null)
  336. {
  337. pos.RecycEndDate = pos.RecycEndDate.Value.AddDays(30);
  338. }
  339. }
  340. db.SaveChanges();
  341. if(order.PayMode == 4 && user.LeaderLevel > 0) //使用盟主储蓄金,并且是盟主
  342. {
  343. if(user.UserType == 1)
  344. {
  345. if(couponIds.Count > 0)
  346. {
  347. UserAccount acccount = db.UserAccount.FirstOrDefault(m => m.Id == user.Id) ?? new UserAccount();
  348. foreach(int couponId in couponIds)
  349. {
  350. PosCoupons coupon = db.PosCoupons.FirstOrDefault(m => m.Id == couponId);
  351. if(coupon != null)
  352. {
  353. if(acccount.LeaderReserve >= 400 * pro.ProductCount)
  354. {
  355. coupon.LeaderUserId = user.Id;
  356. }
  357. coupon.OpId = user.Id;
  358. }
  359. }
  360. }
  361. db.SaveChanges();
  362. }
  363. else
  364. {
  365. //寻找最近运营中心额度大于0的运营中心
  366. int PUserId = user.Id;
  367. bool OperateFlag = true;
  368. bool OncePrizeFlag1 = true;
  369. while(PUserId > 0)
  370. {
  371. Users puser = db.Users.FirstOrDefault(m => m.Id == PUserId);
  372. if(puser != null)
  373. {
  374. if(puser.UserType == 1 && OperateFlag == true) //运营中心
  375. {
  376. if(couponIds.Count > 0)
  377. {
  378. UserAccount acccount = db.UserAccount.FirstOrDefault(m => m.Id == order.UserId) ?? new UserAccount();
  379. foreach(int couponId in couponIds)
  380. {
  381. PosCoupons coupon = db.PosCoupons.FirstOrDefault(m => m.Id == couponId);
  382. if(coupon != null)
  383. {
  384. if(acccount.LeaderReserve >= 400 * pro.ProductCount)
  385. {
  386. coupon.LeaderUserId = user.Id;
  387. }
  388. coupon.OpId = puser.Id;
  389. }
  390. }
  391. db.SaveChanges();
  392. if(acccount.LeaderReserve >= 400 * pro.ProductCount && OncePrizeFlag1)
  393. {
  394. //扣减备用金
  395. OpReserve(db, order, order.UserId, 400 * pro.ProductCount, 2, 0, "商城购机");
  396. //返回到余额
  397. OpLeaderAccount(db, order, order.UserId, 400, pro.ProductCount);
  398. OncePrizeFlag1 = false;
  399. }
  400. OperateFlag = false;
  401. }
  402. else if(LkbIds.Contains(pro.ProductId)) //来客吧组合包
  403. {
  404. UserAccount acccount = db.UserAccount.FirstOrDefault(m => m.Id == order.UserId) ?? new UserAccount();
  405. if(acccount.LeaderReserve >= 400 * pro.ProductCount && OncePrizeFlag1)
  406. {
  407. //扣减备用金
  408. OpReserve(db, order, order.UserId, 400 * pro.ProductCount, 2, 0, "商城购机");
  409. //返回到余额
  410. OpLeaderAccount(db, order, order.UserId, 400, pro.ProductCount);
  411. OncePrizeFlag1 = false;
  412. }
  413. OperateFlag = false;
  414. }
  415. }
  416. PUserId = puser.ParentUserId;
  417. }
  418. else
  419. {
  420. PUserId = 0;
  421. }
  422. }
  423. }
  424. }
  425. else if(order.PayMode == 4 && user.UserType == 1) //使用盟主储蓄金,并且是运营中心
  426. {
  427. if(couponIds.Count > 0)
  428. {
  429. foreach(int couponId in couponIds)
  430. {
  431. PosCoupons coupon = db.PosCoupons.FirstOrDefault(m => m.Id == couponId);
  432. if(coupon != null)
  433. {
  434. coupon.OpId = user.Id;
  435. }
  436. }
  437. } 
  438. db.SaveChanges();
  439. //寻找最近储蓄金充足的大盟主
  440. int PUserId = user.Id;
  441. bool LeaderFlag = true;
  442. bool OncePrizeFlag2 = true;
  443. while(PUserId > 0)
  444. {
  445. Users puser = db.Users.FirstOrDefault(m => m.Id == PUserId);
  446. if(puser != null)
  447. {
  448. if(puser.LeaderLevel == 2 && LeaderFlag == true) //大盟主
  449. {
  450. if(couponIds.Count > 0)
  451. {
  452. UserAccount pacccount = db.UserAccount.FirstOrDefault(m => m.Id == puser.Id) ?? new UserAccount();
  453. foreach(int couponId in couponIds)
  454. {
  455. PosCoupons coupon = db.PosCoupons.FirstOrDefault(m => m.Id == couponId);
  456. if(coupon != null && pacccount.LeaderReserve >= 400 * pro.ProductCount)
  457. {
  458. coupon.LeaderUserId = puser.Id;
  459. }
  460. }
  461. db.SaveChanges();
  462. UserAccount acccount = db.UserAccount.FirstOrDefault(m => m.Id == order.UserId) ?? new UserAccount();
  463. if(acccount.LeaderReserve >= 400 * pro.ProductCount && OncePrizeFlag2)
  464. {
  465. //扣减备用金
  466. OpReserve(db, order, order.UserId, 400 * pro.ProductCount, 2, 0, "商城购机");
  467. //返回到余额
  468. OpLeaderAccount(db, order, order.UserId, 400, pro.ProductCount);
  469. OncePrizeFlag2 = false;
  470. }
  471. LeaderFlag = false;
  472. }
  473. else if(LkbIds.Contains(pro.ProductId))
  474. {
  475. UserAccount acccount = db.UserAccount.FirstOrDefault(m => m.Id == order.UserId) ?? new UserAccount();
  476. if(acccount.LeaderReserve >= 400 * pro.ProductCount && OncePrizeFlag2)
  477. {
  478. //扣减备用金
  479. OpReserve(db, order, order.UserId, 400 * pro.ProductCount, 2, 0, "商城购机");
  480. //返回到余额
  481. OpLeaderAccount(db, order, order.UserId, 400, pro.ProductCount);
  482. OncePrizeFlag2 = false;
  483. }
  484. LeaderFlag = false;
  485. }
  486. }
  487. PUserId = puser.ParentUserId;
  488. }
  489. else
  490. {
  491. PUserId = 0;
  492. }
  493. }
  494. }
  495. else
  496. {
  497. //寻找最近储蓄金充足的大盟主及最近运营中心额度大于0的运营中心(含自身)
  498. int PUserId = user.Id;
  499. int LeaderFlag = 0;
  500. bool OperateFlag = true;
  501. bool OncePrizeFlag3 = true;
  502. while(PUserId > 0)
  503. {
  504. Users puser = db.Users.FirstOrDefault(m => m.Id == PUserId);
  505. if(puser != null)
  506. {
  507. if(puser.LeaderLevel > 0 && puser.LeaderLevel > LeaderFlag && LeaderFlag < 2) //大盟主
  508. {
  509. if(couponIds.Count > 0)
  510. {
  511. if(puser.LeaderLevel == 2)
  512. {
  513. UserAccount pacccount = db.UserAccount.FirstOrDefault(m => m.Id == puser.Id) ?? new UserAccount();
  514. foreach(int couponId in couponIds)
  515. {
  516. PosCoupons coupon = db.PosCoupons.FirstOrDefault(m => m.Id == couponId);
  517. if(coupon != null && pacccount.LeaderReserve >= 400 * pro.ProductCount)
  518. {
  519. coupon.LeaderUserId = puser.Id;
  520. }
  521. }
  522. db.SaveChanges();
  523. }
  524. UserAccount acccount = db.UserAccount.FirstOrDefault(m => m.Id == puser.Id) ?? new UserAccount();
  525. if(acccount.LeaderReserve >= 400 * pro.ProductCount && OncePrizeFlag3)
  526. {
  527. //扣减备用金
  528. OpReserve(db, order, puser.Id, 400 * pro.ProductCount, 2, 0, "商城购机");
  529. //返回到余额
  530. OpLeaderAccount(db, order, puser.Id, 400, pro.ProductCount);
  531. LeaderFlag = puser.LeaderLevel;
  532. OncePrizeFlag3 = false;
  533. }
  534. }
  535. else if(LkbIds.Contains(pro.ProductId))
  536. {
  537. UserAccount acccount = db.UserAccount.FirstOrDefault(m => m.Id == puser.Id) ?? new UserAccount();
  538. if(acccount.LeaderReserve >= 400 * pro.ProductCount && OncePrizeFlag3)
  539. {
  540. //扣减备用金
  541. OpReserve(db, order, puser.Id, 400 * pro.ProductCount, 2, 0, "商城购机");
  542. //返回到余额
  543. OpLeaderAccount(db, order, puser.Id, 400, pro.ProductCount);
  544. LeaderFlag = puser.LeaderLevel;
  545. OncePrizeFlag3 = false;
  546. }
  547. }
  548. }
  549. if(puser.UserType == 1 && OperateFlag == true) //运营中心
  550. {
  551. if(couponIds.Count > 0)
  552. {
  553. foreach(int couponId in couponIds)
  554. {
  555. PosCoupons coupon = db.PosCoupons.FirstOrDefault(m => m.Id == couponId);
  556. if(coupon != null)
  557. {
  558. coupon.OpId = puser.Id;
  559. }
  560. }
  561. db.SaveChanges();
  562. OperateFlag = false;
  563. }
  564. }
  565. PUserId = puser.ParentUserId;
  566. }
  567. else
  568. {
  569. PUserId = 0;
  570. }
  571. }
  572. //运营中心返额度(下单人自己是运营中心)
  573. // OperateReserveBackFor(db, order.UserId, order.TotalPrice);
  574. }
  575. return;
  576. }
  577. int ParentUserId = user.ParentUserId;
  578. // List<int> proids = new List<int>();
  579. // proids.Add(10);
  580. // proids.Add(11);
  581. // 普通创客购买600一组的机具券
  582. bool OncePrizeFlag4 = true;
  583. while(ParentUserId > 0)
  584. {
  585. Users puser = db.Users.FirstOrDefault(m => m.Id == ParentUserId) ?? new Users();
  586. int machineCount = db.PosMachinesTwo.Count(m => m.BuyUserId == ParentUserId && m.PosSnType == 0 && m.ActivationState == 0); //判断是否拥有3台兑换机
  587. int ActiveCount = db.PosMachinesTwo.Count(m => m.BuyUserId == ParentUserId && m.ActivationState == 1); //判断是否拥有3台激活机(不限购买或赠送)
  588. int couponCount = db.PosCoupons.Count(m => m.UserId == ParentUserId && m.IsUse == 0); //判断是否拥有3张券
  589. bool lkb_order = db.Orders.Any(m => m.UserId == ParentUserId && LkbIds.Contains(m.ProductId)); //判断是否已下单来客吧组合包系列产品
  590. function.WriteLog("MakerCode:" + puser.MakerCode, "推荐下单奖励监控日志");
  591. function.WriteLog("machineCount:" + machineCount, "推荐下单奖励监控日志");
  592. function.WriteLog("ActiveCount:" + ActiveCount, "推荐下单奖励监控日志");
  593. if ((machineCount + ActiveCount + couponCount >= 3 || lkb_order || puser.LeaderLevel > 0) && !directPrize)
  594. {
  595. // function.WriteLog("满足条件", "推荐下单奖励监控日志");
  596. // if(puser.LeaderLevel == 0) // 非盟主直推奖励,每个创客第一次下单,上级可得
  597. // {
  598. // List<int> oids = new List<int>();
  599. // var orderpros = db.OrderProduct.Select(m => new { m.OrderId,m.UserId,m.ProductId }).Where(m => m.UserId == order.UserId && proids.Contains(m.ProductId)).ToList();
  600. // foreach(var orderpro in orderpros)
  601. // {
  602. // oids.Add(orderpro.OrderId);
  603. // }
  604. // bool check = db.Orders.Any(m => oids.Contains(m.Id) && m.Status > 0);
  605. // if(!check)
  606. // {
  607. // DirectPrize(db, order.Id, ParentUserId, pro.ProductCount);
  608. // directPrize = true;
  609. // }
  610. // }
  611. // else
  612. // {
  613. // 盟主直推奖励,可以每次下单获得
  614. DirectPrize(db, order.Id, ParentUserId, pro.ProductCount);
  615. directPrize = true;
  616. // }
  617. //推荐下单上级获得30天的机具循环天数
  618. var posList = db.PosMachinesTwo.Select(m => new { m.Id, m.UserId, m.BindingState, m.RecycEndDate }).Where(m => m.UserId == ParentUserId && m.BindingState == 0 && m.RecycEndDate != null).ToList();
  619. foreach (var subPos in posList)
  620. {
  621. PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == subPos.Id);
  622. if (pos != null)
  623. {
  624. pos.RecycEndDate = pos.RecycEndDate.Value.AddDays(30);
  625. }
  626. }
  627. db.SaveChanges();
  628. }
  629. if(puser.LeaderLevel > 0)
  630. {
  631. function.WriteLog("OrderId:" + order.Id, "监控大盟主购机奖励");
  632. function.WriteLog("UserId:" + puser.Id, "监控大盟主购机奖励");
  633. UserAccount acccount = db.UserAccount.FirstOrDefault(m => m.Id == puser.Id) ?? new UserAccount();
  634. function.WriteLog("LeaderReserve:" + acccount.LeaderReserve, "监控大盟主购机奖励");
  635. function.WriteLog("buyPrize:" + buyPrize, "监控大盟主购机奖励");
  636. if(acccount.LeaderReserve >= 400 * pro.ProductCount && !buyPrize)
  637. {
  638. //购机奖励
  639. OpAccount(db, order, puser.Id, 100, pro.ProductCount);
  640. buyPrize = true;
  641. }
  642. function.WriteLog("LeaderReserve:" + acccount.LeaderReserve, "监控大盟主购机奖励");
  643. function.WriteLog("leaderFlag:" + leaderFlag, "监控大盟主购机奖励");
  644. function.WriteLog("OncePrizeFlag4:" + OncePrizeFlag4, "监控大盟主购机奖励");
  645. function.WriteLog("-----------------------------", "监控大盟主购机奖励");
  646. if(acccount.LeaderReserve >= 400 * pro.ProductCount && puser.LeaderLevel > leaderFlag && leaderFlag < 2 && OncePrizeFlag4)
  647. {
  648. //扣减备用金
  649. OpReserve(db, order, puser.Id, 400 * pro.ProductCount, 2, order.UserId, "购机奖励");
  650. //返回到余额
  651. OpLeaderAccount(db, order, puser.Id, 400, pro.ProductCount);
  652. leaderFlag = puser.LeaderLevel;
  653. OncePrizeFlag4 = false;
  654. }
  655. //如果是小盟主,则查找该小盟主关联的大盟主储蓄金是否充足,是则给券打上关联大盟主标记
  656. if(couponIds.Count > 0 && puser.LeaderLevel == 1 && !bigLeaderPrize)
  657. {
  658. LeaderAccountRecord leaderItem = db.LeaderAccountRecord.FirstOrDefault(m => m.Sort == puser.Id && m.LeaderId > 0 && m.LeaderReserve >= 400 * pro.ProductCount);
  659. if(leaderItem != null)
  660. {
  661. leaderItem.LeaderReserve -= 400 * pro.ProductCount;
  662. foreach(int couponId in couponIds)
  663. {
  664. PosCoupons coupon = db.PosCoupons.FirstOrDefault(m => m.Id == couponId);
  665. if(coupon != null)
  666. {
  667. coupon.LeaderUserId = leaderItem.LeaderId;
  668. }
  669. }
  670. db.SaveChanges();
  671. bigLeaderPrize = true;
  672. }
  673. }
  674. //如果是大盟主,则标记大盟主标签
  675. if(couponIds.Count > 0 && puser.LeaderLevel == 2 && acccount.LeaderReserve >= 400 * pro.ProductCount && !bigLeaderPrize)
  676. {
  677. foreach(int couponId in couponIds)
  678. {
  679. PosCoupons coupon = db.PosCoupons.FirstOrDefault(m => m.Id == couponId);
  680. if(coupon != null)
  681. {
  682. coupon.LeaderUserId = puser.Id;
  683. }
  684. }
  685. db.SaveChanges();
  686. bigLeaderPrize = true;
  687. }
  688. }
  689. if(puser.UserType == 1)
  690. {
  691. UserAccount acccount = db.UserAccount.FirstOrDefault(m => m.Id == puser.Id) ?? new UserAccount();
  692. if(!buyPrize)
  693. {
  694. //购机奖励
  695. ChangeAccount(db, order, puser.Id, 100 * pro.ProductCount, 120);
  696. buyPrize = true;
  697. }
  698. //标记标签
  699. if(couponIds.Count > 0 && !operateFlag)
  700. {
  701. foreach(int couponId in couponIds)
  702. {
  703. PosCoupons coupon = db.PosCoupons.FirstOrDefault(m => m.Id == couponId);
  704. if(coupon != null)
  705. {
  706. coupon.OpId= puser.Id;
  707. }
  708. }
  709. db.SaveChanges();
  710. operateFlag = true;
  711. }
  712. }
  713. ParentUserId = puser.ParentUserId;
  714. }
  715. //运营中心返额度
  716. // OperateReserveBackFor(db, order.UserId, order.TotalPrice);
  717. }
  718. }
  719. function.WriteLog("\r\n\r\n", "推荐下单奖励监控日志");
  720. }
  721. //推荐王
  722. if(pro.ProductId == 29)
  723. {
  724. RecommendMethod(order.UserId, order.CreateDate.Value.ToString("yyyyMM"));
  725. }
  726. //购买分仓临时额度
  727. if(pro.ProductId == 30 || pro.ProductId == 31 || pro.ProductId == 32)
  728. {
  729. string SendData = "{\"Kind\":\"1\",\"Data\":{\"OrderId\":\"" + order.Id + "\"}}";
  730. RedisDbconn.Instance.AddList("StoreApplyQueue", SendData);
  731. }
  732. //购买小分仓临时额度
  733. if(pro.ProductId == 56 || pro.ProductId == 57 || pro.ProductId == 58)
  734. {
  735. string SendData = "{\"Kind\":\"1\",\"Data\":{\"OrderId\":\"" + order.Id + "\"}}";
  736. RedisDbconn.Instance.AddList("PreStoreApplyQueue", SendData);
  737. }
  738. }
  739. else
  740. {
  741. if(order.ProductId > 0 && order.ErpMode > 0)
  742. {
  743. //盟主储备金-升级/购买 ErpMode:1-升级,2-购买
  744. if(order.ErpMode > 0)
  745. {
  746. Users user = db.Users.FirstOrDefault(m => m.Id == order.UserId);
  747. if(user != null)
  748. {
  749. if(order.ErpMode == 1)
  750. {
  751. user.LeaderLevel = 2;
  752. db.SaveChanges();
  753. }
  754. OpReserve(db, order, order.UserId, order.TotalPrice, 1);
  755. }
  756. }
  757. }
  758. }
  759. }
  760. }
  761. //小盟主购买逻辑
  762. public bool LeaderBack(WebCMSEntities db, Orders order)
  763. {
  764. int LeaderUserId = order.UserId;
  765. int level = 0;
  766. bool result = true;
  767. while(LeaderUserId > 0)
  768. {
  769. level += 1;
  770. Users user = db.Users.FirstOrDefault(m => m.Id == LeaderUserId);
  771. if(user != null)
  772. {
  773. decimal TotalPrice = 10000;
  774. if((user.LeaderLevel == 2) && level > 1)
  775. {
  776. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == LeaderUserId);
  777. if(account != null)
  778. {
  779. if(account.LeaderReserve >= TotalPrice)
  780. {
  781. OpReserve(db, order, LeaderUserId, TotalPrice, 2, 0, "推荐小盟主");
  782. OpLeaderAccount(db, order, LeaderUserId, TotalPrice, 1, 1);
  783. LeaderUserId = 0;
  784. result = false;
  785. }
  786. else
  787. {
  788. LeaderUserId = user.ParentUserId;
  789. // decimal LeaderReserve = account.LeaderReserve;
  790. // OpReserve(db, order, LeaderUserId, LeaderReserve, 2, 0, "推荐小盟主");
  791. // OpLeaderAccount(db, order, LeaderUserId, LeaderReserve);
  792. }
  793. }
  794. }
  795. else if(user.UserType == 1 && level > 1)
  796. {
  797. OpModels.WebCMSEntities opdb = new OpModels.WebCMSEntities();
  798. OpModels.UserAccount account = opdb.UserAccount.FirstOrDefault(m => m.Id == LeaderUserId) ?? new OpModels.UserAccount();
  799. if(account.TotalAmt > 0)
  800. {
  801. if(account.TotalAmt < TotalPrice)
  802. {
  803. TotalPrice = account.TotalAmt;
  804. }
  805. if(TotalPrice > 0)
  806. {
  807. OperateAmountChange(opdb, LeaderUserId, TotalPrice, 2, 1, "商城购机");
  808. OperateAmountChange(opdb, LeaderUserId, TotalPrice, 1, 2, "商城购机");
  809. LeaderUserId = 0;
  810. result = false;
  811. }
  812. }
  813. }
  814. else
  815. {
  816. LeaderUserId = user.ParentUserId;
  817. }
  818. }
  819. else
  820. {
  821. LeaderUserId = 0;
  822. }
  823. }
  824. return result;
  825. }
  826. //操作储备金
  827. public void OpReserve(WebCMSEntities db, Orders order, int UserId, decimal Money, int ChangeType, int SourceUserId = 0, string Remark = "储备金购买")
  828. {
  829. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  830. if (account == null)
  831. {
  832. account = db.UserAccount.Add(new UserAccount()
  833. {
  834. Id = UserId,
  835. UserId = UserId,
  836. }).Entity;
  837. db.SaveChanges();
  838. }
  839. decimal BeforeAmount = account.LeaderReserve; //变更前总金额
  840. if(ChangeType == 1)
  841. {
  842. account.LeaderReserve += Money;
  843. }
  844. else
  845. {
  846. account.LeaderReserve -= Money;
  847. }
  848. decimal AfterAmount = account.LeaderReserve; //变更后总金额
  849. LeaderReserveRecord add = db.LeaderReserveRecord.Add(new LeaderReserveRecord()
  850. {
  851. CreateDate = DateTime.Now,
  852. ChangeType = ChangeType,
  853. OrderId = order.Id,
  854. Remark = Remark,
  855. AfterAmt = AfterAmount,
  856. BeforeAmt = BeforeAmount,
  857. ChangeAmt = Money,
  858. TradeDate = DateTime.Now.ToString("yyyyMMdd"),
  859. TradeMonth = DateTime.Now.ToString("yyyyMM"),
  860. UserId = UserId,
  861. SourceUserId = SourceUserId,
  862. }).Entity;
  863. db.SaveChanges();
  864. }
  865. //操作余额
  866. public void OpAccount(WebCMSEntities db, Orders order, int UserId, decimal Money, int Count = 1)
  867. {
  868. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  869. if (account == null)
  870. {
  871. account = db.UserAccount.Add(new UserAccount()
  872. {
  873. Id = UserId,
  874. UserId = UserId,
  875. }).Entity;
  876. db.SaveChanges();
  877. }
  878. int ChangeType = 0;
  879. if(Money == 600)
  880. {
  881. ChangeType = 117;
  882. }
  883. else if(Money == 100)
  884. {
  885. ChangeType = 118;
  886. }
  887. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  888. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  889. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  890. account.BalanceAmount += Money * Count;
  891. account.TotalAmount += Money * Count;
  892. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  893. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  894. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  895. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  896. {
  897. CreateDate = DateTime.Now,
  898. UpdateDate = DateTime.Now,
  899. UserId = UserId, //创客
  900. ChangeType = ChangeType, //变动类型
  901. ChangeAmount = Money * Count, //变更金额
  902. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  903. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  904. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  905. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  906. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  907. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  908. QueryCount = order.Id,
  909. }).Entity;
  910. db.SaveChanges();
  911. }
  912. public void ChangeAccount(WebCMSEntities db, Orders order, int UserId, decimal Money, int ChangeType = 0, string Remark = "")
  913. {
  914. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  915. if (account == null)
  916. {
  917. account = db.UserAccount.Add(new UserAccount()
  918. {
  919. Id = UserId,
  920. UserId = UserId,
  921. }).Entity;
  922. db.SaveChanges();
  923. }
  924. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  925. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  926. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  927. account.BalanceAmount += Money;
  928. if(Money > 0)
  929. {
  930. account.TotalAmount += Money;
  931. }
  932. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  933. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  934. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  935. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  936. {
  937. CreateDate = DateTime.Now,
  938. UpdateDate = DateTime.Now,
  939. UserId = UserId, //创客
  940. ChangeType = ChangeType, //变动类型
  941. ChangeAmount = Math.Abs(Money), //变更金额
  942. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  943. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  944. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  945. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  946. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  947. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  948. QueryCount = order.Id,
  949. Remark = Remark,
  950. }).Entity;
  951. db.SaveChanges();
  952. }
  953. //操作盟主可提现余额
  954. public void OpLeaderAccount(WebCMSEntities db, Orders order, int UserId, decimal Money, int Count = 1, int Kind = 0)
  955. {
  956. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  957. if (account == null)
  958. {
  959. account = db.UserAccount.Add(new UserAccount()
  960. {
  961. Id = UserId,
  962. UserId = UserId,
  963. }).Entity;
  964. db.SaveChanges();
  965. }
  966. int ChangeType = 0;
  967. if(Money == 400)
  968. {
  969. ChangeType = 117;
  970. }
  971. int LeaderId = 0;
  972. decimal LeaderReserve = 0;
  973. if(Kind == 1)
  974. {
  975. LeaderId = UserId;
  976. LeaderReserve = Money * Count;
  977. }
  978. decimal BeforeLeaderBalanceAmount = account.LeaderBalanceAmount; //变更前余额
  979. account.LeaderBalanceAmount += Money * Count;
  980. decimal AfterLeaderBalanceAmount = account.LeaderBalanceAmount; //变更后余额
  981. LeaderAccountRecord leaderAccountRecord = db.LeaderAccountRecord.Add(new LeaderAccountRecord()
  982. {
  983. CreateDate = DateTime.Now,
  984. UpdateDate = DateTime.Now,
  985. UserId = UserId, //创客
  986. ChangeType = ChangeType, //变动类型
  987. ChangeAmount = Money * Count, //变更金额
  988. BeforeBalanceAmount = BeforeLeaderBalanceAmount, //变更前余额
  989. AfterBalanceAmount = AfterLeaderBalanceAmount, //变更后余额
  990. QueryCount = order.Id,
  991. Sort = order.UserId,
  992. LeaderId = LeaderId,
  993. LeaderReserve = LeaderReserve,
  994. }).Entity;
  995. db.SaveChanges();
  996. }
  997. public void DirectPrize(WebCMSEntities db, int OrderId, int UserId, int Count = 1)
  998. {
  999. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  1000. if (account == null)
  1001. {
  1002. account = db.UserAccount.Add(new UserAccount()
  1003. {
  1004. Id = UserId,
  1005. UserId = UserId,
  1006. }).Entity;
  1007. db.SaveChanges();
  1008. }
  1009. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  1010. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  1011. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  1012. account.BalanceAmount += 100 * Count;
  1013. account.TotalAmount += 100 * Count;
  1014. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  1015. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  1016. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  1017. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  1018. {
  1019. CreateDate = DateTime.Now,
  1020. UpdateDate = DateTime.Now,
  1021. UserId = UserId, //创客
  1022. ChangeType = 112, //变动类型
  1023. ChangeAmount = 100 * Count, //变更金额
  1024. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  1025. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  1026. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  1027. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  1028. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  1029. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  1030. QueryCount = OrderId,
  1031. }).Entity;
  1032. db.SaveChanges();
  1033. }
  1034. // 推荐王逻辑(下单)
  1035. public void RecommendMethod(int UserId, string TradeMonth)
  1036. {
  1037. string SendData = "{\"Kind\":\"1\",\"Data\":{\"UserId\":\"" + UserId + "\",\"TradeMonth\":\"" + TradeMonth + "\"}}";
  1038. RedisDbconn.Instance.AddList("RecommendActStatQueue", SendData);
  1039. }
  1040. //操作运营中心额度
  1041. public void OperateReserveBackFor(WebCMSEntities maindb, int UserId, decimal Money)
  1042. {
  1043. OpModels.WebCMSEntities db = new OpModels.WebCMSEntities();
  1044. while(UserId > 0)
  1045. {
  1046. Users user = maindb.Users.FirstOrDefault(m => m.Id == UserId);
  1047. if(user != null)
  1048. {
  1049. bool sys = db.SysAdmin.Any(m => m.UserId == UserId);
  1050. if(sys)
  1051. {
  1052. OpModels.UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId) ?? new OpModels.UserAccount();
  1053. if(account.TotalAmt <= 0)
  1054. {
  1055. return;
  1056. }
  1057. if(account.TotalAmt < Money)
  1058. {
  1059. Money = account.TotalAmt;
  1060. }
  1061. if(Money > 0)
  1062. {
  1063. OperateAmountChange(db, UserId, Money, 2, 1, "商城购机");
  1064. OperateAmountChange(db, UserId, Money, 1, 2, "商城购机");
  1065. }
  1066. UserId = 0;
  1067. }
  1068. else
  1069. {
  1070. UserId = user.ParentUserId;
  1071. }
  1072. }
  1073. else
  1074. {
  1075. UserId = 0;
  1076. }
  1077. }
  1078. db.Dispose();
  1079. }
  1080. public void OperateReserveBack(int UserId, decimal Money)
  1081. {
  1082. OpModels.WebCMSEntities db = new OpModels.WebCMSEntities();
  1083. OpModels.UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId) ?? new OpModels.UserAccount();
  1084. if(account.TotalAmt <= 0)
  1085. {
  1086. return;
  1087. }
  1088. if(account.TotalAmt < Money)
  1089. {
  1090. Money = account.TotalAmt;
  1091. }
  1092. if(Money > 0)
  1093. {
  1094. OperateAmountChange(db, UserId, Money, 2, 1, "商城购机");
  1095. OperateAmountChange(db, UserId, Money, 1, 2, "商城购机");
  1096. }
  1097. db.Dispose();
  1098. }
  1099. public void ActReserveBack(int UserId, decimal OpReserve1, decimal OpReserve2, decimal OpReserve3)
  1100. {
  1101. OpModels.WebCMSEntities db = new OpModels.WebCMSEntities();
  1102. if(OpReserve1 > 0) OperateAmountChange(db, UserId, OpReserve1, 1, 1, "机具激活", true);
  1103. if(OpReserve2 > 0) OperateAmountChange(db, UserId, OpReserve2, 1, 2, "机具激活", true);
  1104. if(OpReserve3 > 0) OperateAmountChange(db, UserId, OpReserve3, 1, 3, "机具激活", true);
  1105. db.Dispose();
  1106. }
  1107. public void OperateAmountChange(OpModels.WebCMSEntities db, int UserId, decimal Money, int OperateType, int AmountType, string Remark = "", bool record = false)
  1108. {
  1109. OpModels.UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId);
  1110. if (account == null)
  1111. {
  1112. account = db.UserAccount.Add(new OpModels.UserAccount()
  1113. {
  1114. Id = UserId,
  1115. UserId = UserId,
  1116. }).Entity;
  1117. db.SaveChanges();
  1118. }
  1119. decimal BeforeAmount = account.ValidAmount + account.TotalAmt + account.ValidForGetAmount; //变更前总金额
  1120. if(OperateType == 1)
  1121. {
  1122. if(AmountType == 1)
  1123. {
  1124. // BeforeAmount = account.TotalAmt;
  1125. account.TotalAmt += Money;
  1126. // AfterAmount = account.TotalAmt;
  1127. }
  1128. else if(AmountType == 2)
  1129. {
  1130. // BeforeAmount = account.ValidForGetAmount;
  1131. account.ValidForGetAmount += Money;
  1132. // AfterAmount = account.ValidForGetAmount;
  1133. }
  1134. else
  1135. {
  1136. // BeforeAmount = account.ValidAmount;
  1137. account.ValidAmount += Money;
  1138. // AfterAmount = account.ValidAmount;
  1139. }
  1140. }
  1141. else
  1142. {
  1143. if(AmountType == 1)
  1144. {
  1145. // BeforeAmount = account.TotalAmt;
  1146. account.TotalAmt -= Money;
  1147. // AfterAmount = account.TotalAmt;
  1148. }
  1149. else if(AmountType == 2)
  1150. {
  1151. // BeforeAmount = account.ValidForGetAmount;
  1152. account.ValidForGetAmount -= Money;
  1153. // AfterAmount = account.ValidForGetAmount;
  1154. }
  1155. else
  1156. {
  1157. // BeforeAmount = account.ValidAmount;
  1158. account.ValidAmount -= Money;
  1159. // AfterAmount = account.ValidAmount;
  1160. }
  1161. }
  1162. decimal AfterAmount = account.ValidAmount + account.TotalAmt + account.ValidForGetAmount; //变更后总金额
  1163. if(record)
  1164. {
  1165. OpModels.AmountRecord add = db.AmountRecord.Add(new OpModels.AmountRecord()
  1166. {
  1167. CreateDate = DateTime.Now,
  1168. UpdateDate = DateTime.Now,
  1169. OperateType = OperateType,
  1170. AfterAmount = AfterAmount,
  1171. BeforeAmount = BeforeAmount,
  1172. UseAmount = Money,
  1173. UserId = UserId,
  1174. SeoDescription = Remark,
  1175. Version = AmountType,
  1176. }).Entity;
  1177. }
  1178. db.SaveChanges();
  1179. }
  1180. #endregion
  1181. #region 盟主推荐奖励
  1182. public void LeaderRecommendPrize(WebCMSEntities db, Orders order, int UserId, decimal Money, int ChangeType)
  1183. {
  1184. int level = 0;
  1185. while(UserId > 0)
  1186. {
  1187. level += 1;
  1188. Users user = db.Users.FirstOrDefault(m => m.Id == UserId);
  1189. if(user != null)
  1190. {
  1191. if((user.UserType == 1 || user.LeaderLevel > 0) && level > 1)
  1192. {
  1193. ChangeAccount(db, order, UserId, Money, ChangeType);
  1194. UserId = 0;
  1195. }
  1196. else
  1197. {
  1198. UserId = user.ParentUserId;
  1199. }
  1200. }
  1201. else
  1202. {
  1203. UserId = 0;
  1204. }
  1205. }
  1206. db.Dispose();
  1207. }
  1208. #endregion
  1209. #region 购买盟主预设职级
  1210. public void LeaderPreUserLevel(WebCMSEntities db, int UserId, int LeaderKind)
  1211. {
  1212. int Month = LeaderKind == 1 ? 6 : 12;
  1213. int Rank = LeaderKind == 1 ? 5 : 7;
  1214. UserRankWhite check = db.UserRankWhite.FirstOrDefault(m => m.Id == UserId);
  1215. if(check == null)
  1216. {
  1217. db.UserRankWhite.Add(new UserRankWhite()
  1218. {
  1219. CreateDate = DateTime.Now, //设置时间
  1220. UpdateDate = DateTime.Now.AddMonths(Month), //过期时间
  1221. Rank = Rank,
  1222. UserId = UserId, //用户
  1223. Id = UserId,
  1224. });
  1225. }
  1226. else
  1227. {
  1228. if(check.Rank < Rank)
  1229. {
  1230. check.Rank = Rank;
  1231. check.UpdateDate = DateTime.Now.AddMonths(Month);
  1232. }
  1233. else if(check.Rank == Rank && check.UpdateDate < DateTime.Now.AddMonths(Month))
  1234. {
  1235. check.UpdateDate = DateTime.Now.AddMonths(Month);
  1236. }
  1237. }
  1238. db.SaveChanges();
  1239. }
  1240. #endregion
  1241. #region 记录盟主
  1242. public void AddLeader(WebCMSEntities db, int UserId, int LeaderLevel)
  1243. {
  1244. int Month = LeaderLevel == 1 ? 6 : 12;
  1245. Leaders leader = db.Leaders.FirstOrDefault(m => m.Id == UserId);
  1246. if(leader == null)
  1247. {
  1248. db.Leaders.Add(new Leaders()
  1249. {
  1250. Id = UserId,
  1251. CreateDate = DateTime.Now, //设置时间
  1252. UserId = UserId, //用户
  1253. LeaderLevel = LeaderLevel,
  1254. LastBuyDate = DateTime.Now,
  1255. ExpiredDate = DateTime.Now.AddMonths(Month),
  1256. });
  1257. }
  1258. else
  1259. {
  1260. leader.LeaderLevel = LeaderLevel;
  1261. leader.LastBuyDate = DateTime.Now;
  1262. leader.ExpiredDate = DateTime.Now.AddMonths(Month);
  1263. }
  1264. db.SaveChanges();
  1265. SendLeaderMsg(db, UserId);
  1266. }
  1267. #endregion
  1268. #region 盟主续费通知
  1269. public void SendLeaderMsg(WebCMSEntities db, int UserId)
  1270. {
  1271. string msg = "";
  1272. Users user = db.Users.FirstOrDefault(m => m.Id == UserId) ?? new Users();
  1273. DateTime now = DateTime.Now;
  1274. Leaders leader = db.Leaders.FirstOrDefault(m => m.Id == UserId);
  1275. if(leader != null)
  1276. {
  1277. if(leader.ExpiredDate >= now)
  1278. {
  1279. msg = "尊敬的" + user.RealName + "盟主,恭喜您的盟主已成功开通";
  1280. }
  1281. else
  1282. {
  1283. msg = "尊敬的" + user.RealName + "盟主,恭喜您重新成为盟主";
  1284. }
  1285. }
  1286. else
  1287. {
  1288. msg = "尊敬的" + user.RealName + "盟主,恭喜您的盟主已成功开通";
  1289. }
  1290. RedisDbconn.Instance.AddList("MsgPersonalQueue", Newtonsoft.Json.JsonConvert.SerializeObject(new MsgPersonal()
  1291. {
  1292. UserId = Convert.ToInt32(UserId), //创客
  1293. Title = "开通盟主提醒", //标题
  1294. Content = msg, //内容
  1295. Summary = msg,
  1296. CreateDate = DateTime.Now,
  1297. }));
  1298. }
  1299. #endregion
  1300. }
  1301. }