AlipayPayBack2Service.cs 71 KB

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