AlipayPayBack2Service.cs 76 KB

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