AlipayPayBack2Service.cs 74 KB

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