StatService.cs 192 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052305330543055305630573058305930603061306230633064306530663067306830693070307130723073307430753076307730783079308030813082308330843085308630873088308930903091309230933094309530963097309830993100310131023103310431053106310731083109311031113112311331143115311631173118311931203121312231233124312531263127312831293130313131323133313431353136313731383139314031413142314331443145314631473148314931503151315231533154315531563157315831593160316131623163316431653166316731683169317031713172317331743175317631773178317931803181318231833184318531863187318831893190319131923193319431953196319731983199320032013202320332043205320632073208320932103211321232133214321532163217321832193220322132223223322432253226322732283229323032313232323332343235323632373238323932403241324232433244324532463247324832493250325132523253325432553256325732583259326032613262326332643265326632673268326932703271327232733274327532763277327832793280328132823283328432853286328732883289329032913292329332943295329632973298329933003301330233033304330533063307330833093310331133123313
  1. using System;
  2. using System.Collections.Generic;
  3. using Library;
  4. using LitJson;
  5. using System.Linq;
  6. using System.Data;
  7. using System.Threading;
  8. using MySystem.PxcModels;
  9. namespace MySystem
  10. {
  11. public class StatService
  12. {
  13. public readonly static StatService Instance = new StatService();
  14. private StatService()
  15. { }
  16. public void Start()
  17. {
  18. Thread th = new Thread(StartDo);
  19. th.IsBackground = true;
  20. th.Start();
  21. }
  22. public void StartDo()
  23. {
  24. while(true)
  25. {
  26. try
  27. {
  28. if(DateTime.Now.Hour > 0)
  29. {
  30. string doDate = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
  31. string flag = function.ReadInstance("/Stat/" + doDate + ".txt");
  32. if (string.IsNullOrEmpty(flag))
  33. {
  34. function.WritePage("/Stat/", doDate + ".txt", DateTime.Now.ToString("HH:mm:ss"));
  35. StartEverDay(doDate);
  36. StatMerchantTrade(doDate);
  37. }
  38. }
  39. }
  40. catch (Exception ex)
  41. {
  42. function.WriteLog(DateTime.Now.ToString() + ":" + ex.ToString(), "每天重置交易额异常");
  43. }
  44. Thread.Sleep(3600000);
  45. }
  46. }
  47. public void StartActiveReward()
  48. {
  49. Thread th = new Thread(ActiveReward);
  50. th.IsBackground = true;
  51. th.Start();
  52. }
  53. public void ActiveReward()
  54. {
  55. while(true)
  56. {
  57. try
  58. {
  59. function.WriteLog(DateTime.Now.ToString() + ":start", "实时处理激活奖励");
  60. dosomething3();
  61. function.WriteLog(DateTime.Now.ToString() + ":end\n\n", "实时处理激活奖励");
  62. }
  63. catch (Exception ex)
  64. {
  65. function.WriteLog(DateTime.Now.ToString() + ":" + ex.ToString(), "实时处理激活奖励异常");
  66. }
  67. Thread.Sleep(30000);
  68. }
  69. }
  70. public void StartActiveReward1()
  71. {
  72. Thread th = new Thread(ActiveReward1);
  73. th.IsBackground = true;
  74. th.Start();
  75. }
  76. public void ActiveReward1()
  77. {
  78. while(true)
  79. {
  80. try
  81. {
  82. function.WriteLog(DateTime.Now.ToString() + ":start", "实时处理0押激活奖励");
  83. activePrizeWithoutDeposit();
  84. function.WriteLog(DateTime.Now.ToString() + ":end\n\n", "实时处理0押激活奖励");
  85. }
  86. catch (Exception ex)
  87. {
  88. function.WriteLog(DateTime.Now.ToString() + ":" + ex.ToString(), "实时处理0押激活奖励异常");
  89. }
  90. Thread.Sleep(30000);
  91. }
  92. }
  93. public void StartActiveReward2()
  94. {
  95. Thread th = new Thread(ActiveReward2);
  96. th.IsBackground = true;
  97. th.Start();
  98. }
  99. public void ActiveReward2()
  100. {
  101. while(true)
  102. {
  103. try
  104. {
  105. function.WriteLog(DateTime.Now.ToString() + ":start", "实时处理盒易付0押激活奖励");
  106. activePrizeWithoutDeposit12();
  107. function.WriteLog(DateTime.Now.ToString() + ":end\n\n", "实时处理盒易付0押激活奖励");
  108. }
  109. catch (Exception ex)
  110. {
  111. function.WriteLog(DateTime.Now.ToString() + ":" + ex.ToString(), "实时处理盒易付0押激活奖励异常");
  112. }
  113. Thread.Sleep(30000);
  114. }
  115. }
  116. public void StartActiveReward15()
  117. {
  118. Thread th = new Thread(ActiveReward15);
  119. th.IsBackground = true;
  120. th.Start();
  121. }
  122. public void ActiveReward15()
  123. {
  124. while(true)
  125. {
  126. try
  127. {
  128. function.WriteLog(DateTime.Now.ToString() + ":start", "实时处理来客吧0押激活奖励");
  129. activePrizeWithoutDeposit15();
  130. function.WriteLog(DateTime.Now.ToString() + ":end\n\n", "实时处理来客吧0押激活奖励");
  131. }
  132. catch (Exception ex)
  133. {
  134. function.WriteLog(DateTime.Now.ToString() + ":" + ex.ToString(), "实时处理来客吧0押激活奖励异常");
  135. }
  136. Thread.Sleep(30000);
  137. }
  138. }
  139. //广电卡激活奖励
  140. public void StartSimActive()
  141. {
  142. Thread th = new Thread(StartSimActiveListen);
  143. th.IsBackground = true;
  144. th.Start();
  145. }
  146. public void StartSimActiveListen()
  147. {
  148. while(true)
  149. {
  150. try
  151. {
  152. function.WriteLog(DateTime.Now.ToString() + ":start", "实时处理广电卡激活奖励");
  153. StartSimActiveDo();
  154. function.WriteLog(DateTime.Now.ToString() + ":end\n\n", "实时处理广电卡激活奖励");
  155. }
  156. catch (Exception ex)
  157. {
  158. function.WriteLog(DateTime.Now.ToString() + ":" + ex.ToString(), "实时处理广电卡激活奖励异常");
  159. }
  160. Thread.Sleep(29000);
  161. }
  162. }
  163. public void StartSimActiveDo(int posid = 0)
  164. {
  165. WebCMSEntities db = new WebCMSEntities();
  166. DateTime yesterday = DateTime.Now.AddDays(-30);
  167. IQueryable<PosMachinesTwo> posList = db.PosMachinesTwo.Where(m => m.ActivationState == 1 && m.BrandId == 14 && m.CardType > 0 && m.Detail != "1");
  168. if (posid > 0)
  169. {
  170. posList = posList.Where(m => m.Id == posid);
  171. }
  172. else
  173. {
  174. posList = posList.Where(m => m.ActivationTime >= yesterday);
  175. }
  176. foreach (PosMachinesTwo pos in posList.ToList())
  177. {
  178. PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  179. if (merchant != null)
  180. {
  181. string ParentNav = "";
  182. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  183. if (user != null)
  184. {
  185. int GetUserId = user.Id;
  186. ParentNav = user.ParentNav;
  187. int TopUserId = 0;
  188. if (!string.IsNullOrEmpty(ParentNav))
  189. {
  190. TopUserId = int.Parse(ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  191. }
  192. decimal Amount = 19 * 1.5M;
  193. doActiveReward(db, merchant, pos, GetUserId, ParentNav, TopUserId, Amount);
  194. PosMachinesTwo item = db.PosMachinesTwo.FirstOrDefault(m => m.Id == pos.Id);
  195. if(item != null)
  196. {
  197. item.Detail = "1";
  198. db.SaveChanges();
  199. }
  200. }
  201. }
  202. }
  203. db.Dispose();
  204. }
  205. // 1. 前一天的绑定记录和创客信息匹配,设置商户型创客
  206. public void dosomething1(string date)
  207. {
  208. // TODO: 每天扫描非商户型创客的持有机具数量
  209. SpModels.WebCMSEntities spdb = new SpModels.WebCMSEntities();
  210. WebCMSEntities db = new WebCMSEntities();
  211. DateTime yesterday = DateTime.Parse(date + " 00:00:00");
  212. DateTime today = DateTime.Parse(DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00");
  213. List<SpModels.BindRecord> binds = spdb.BindRecord.Where(m => m.CreateTime >= yesterday && m.CreateTime < today).ToList();
  214. foreach (SpModels.BindRecord bind in binds)
  215. {
  216. string Mobile = bind.MerNewSnNo;
  217. string MerNo = bind.MerNo;
  218. string BeforeNum = "";
  219. string AfterNum = "";
  220. if (Mobile.Contains("****") && Mobile.Length == 11)
  221. {
  222. BeforeNum = Mobile.Substring(0, 3);
  223. AfterNum = Mobile.Substring(7);
  224. }
  225. string Name = bind.MerName;
  226. if (bind.ProductType == "2")
  227. {
  228. if (Name.Contains("-"))
  229. {
  230. Name = Name.Split('-')[1];
  231. }
  232. else if (Name.Contains("_"))
  233. {
  234. Name = Name.Split('_')[1];
  235. }
  236. }
  237. else if (bind.ProductType == "4")
  238. {
  239. Name = bind.SeoTitle;
  240. }
  241. PxcModels.Users user = db.Users.FirstOrDefault(m => m.Mobile.StartsWith(BeforeNum) && m.Mobile.EndsWith(AfterNum) && m.RealName == Name && m.AuthFlag == 1 && m.MerchantType == 0);
  242. if (user != null)
  243. {
  244. bool checkPos = db.PosMachinesTwo.Any(m => m.UserId == user.Id);
  245. if (!checkPos)
  246. {
  247. PxcModels.MachineForSnNo forSnNo = db.MachineForSnNo.FirstOrDefault(m => m.SnNo == bind.MerSnNo) ?? new PxcModels.MachineForSnNo();
  248. PxcModels.PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == forSnNo.SnId && m.UserId != user.Id);
  249. if (pos != null)
  250. {
  251. pos.UserId = user.Id;
  252. user.MerchantType = 1;
  253. PxcModels.PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.KqMerNo == MerNo) ?? new PxcModels.PosMerchantInfo();
  254. merchant.UserId = user.Id;
  255. merchant.MerUserType = 1;
  256. pos.SeoTitle = user.Id.ToString(); // 记录商户型创客的Id
  257. db.SaveChanges();
  258. }
  259. }
  260. }
  261. }
  262. spdb.Dispose();
  263. db.Dispose();
  264. }
  265. // 1. 前一天的商户型创客,判断名下是否3台激活机器,是则变为非商户型创客
  266. public void dosomething11(string date)
  267. {
  268. WebCMSEntities db = new WebCMSEntities();
  269. DateTime yesterday = DateTime.Parse(date + " 00:00:00");
  270. DateTime today = DateTime.Parse(DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00");
  271. var users = db.Users.Select(m => new { m.Id, m.MerchantType }).Where(m => m.MerchantType == 1).ToList();
  272. foreach (var user in users)
  273. {
  274. int machineCount = db.PosMachinesTwo.Count(m => m.UserId == user.Id && m.PosSnType == 0);
  275. int couponCount = db.PosCoupons.Count(m => m.UserId == user.Id && m.IsUse == 0); //判断是否拥有3张券
  276. if (machineCount + couponCount >= 3)
  277. {
  278. Users edit = db.Users.FirstOrDefault(m => m.Id == user.Id);
  279. if (edit != null)
  280. {
  281. edit.MerchantType = 0;
  282. db.SaveChanges();
  283. }
  284. }
  285. }
  286. db.Dispose();
  287. }
  288. public void testStatTrade(string date)
  289. {
  290. string yesterday = date + " 00:00:00";
  291. string today = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  292. string TradeMonth = DateTime.Parse(date).ToString("yyyyMM");
  293. string TradeDate = DateTime.Parse(date).ToString("yyyyMMdd");
  294. DataTable dt = dbconn.dtable("select UserId,BrandId,MerchantId,BankCardType,QrPayFlag,sum(TradeAmount) from TradeRecord where CreateDate>='" + yesterday + "' and CreateDate<'" + today + "' group by UserId,BrandId,MerchantId,BankCardType,QrPayFlag");
  295. foreach (DataRow dr in dt.Rows)
  296. {
  297. int UserId = int.Parse(dr["UserId"].ToString()); //创客ID
  298. int BrandId = int.Parse(dr["BrandId"].ToString()); //品牌
  299. int MerchantId = int.Parse(dr["MerchantId"].ToString()); //商户Id
  300. int BankCardType = int.Parse(dr["BankCardType"].ToString()); //卡类型
  301. int QrPayFlag = int.Parse(dr["QrPayFlag"].ToString()); //云闪付
  302. decimal TradeAmount = decimal.Parse(dr[5].ToString()); //当日交易额
  303. string content = "{";
  304. content += "\"DateString\":\"" + date + "\",";
  305. content += "\"UserId\":\"" + UserId + "\",";
  306. content += "\"BrandId\":\"" + BrandId + "\",";
  307. content += "\"MerchantId\":\"" + MerchantId + "\",";
  308. content += "\"BankCardType\":\"" + BankCardType + "\",";
  309. content += "\"QrPayFlag\":\"" + QrPayFlag + "\",";
  310. content += "\"TradeAmount\":\"" + TradeAmount + "\"";
  311. content += "}";
  312. RedisDbconn.Instance.AddList("TradeStatQueueTest", content);
  313. }
  314. }
  315. // 3. 前一天的激活记录,根据创客类型,如果是商户型创客,则激活奖励的起始人从此人上级计算。如果不是,则从此人开始计算
  316. public void dosomething3(int posid = 0)
  317. {
  318. WebCMSEntities db = new WebCMSEntities();
  319. DateTime yesterday = DateTime.Now.AddDays(-1);
  320. DateTime today = DateTime.Now.AddMinutes(-10);
  321. IQueryable<PosMachinesTwo> posList = db.PosMachinesTwo.Where(m => m.ActivationState == 1 && !string.IsNullOrEmpty(m.SeoKeyword) && m.SeoKeyword != "" && m.SeoKeyword != "0" && m.Detail != "1" && m.BrandId != 14);
  322. if (posid > 0)
  323. {
  324. posList = posList.Where(m => m.Id == posid);
  325. }
  326. else
  327. {
  328. posList = posList.Where(m => m.ActivationTime >= yesterday && m.ActivationTime < today);
  329. }
  330. foreach (PosMachinesTwo pos in posList.ToList())
  331. {
  332. PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  333. if (merchant != null && pos.ActivationTime.Value <= pos.BindingTime.Value.AddDays(30))
  334. {
  335. function.WriteLog("机具号:" + pos.PosSn + ";奖励标记:" + pos.Detail + ";", "实时处理激活奖励");
  336. string ParentNav = "";
  337. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  338. if (user != null)
  339. {
  340. int GetUserId = user.Id;
  341. ParentNav = user.ParentNav;
  342. int TopUserId = 0;
  343. if (!string.IsNullOrEmpty(ParentNav))
  344. {
  345. TopUserId = int.Parse(ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  346. }
  347. decimal ActPrize = decimal.Parse(function.CheckNum(pos.SeoKeyword));
  348. KqProducts brand = db.KqProducts.FirstOrDefault(m => m.Id == pos.BrandId) ?? new KqProducts();
  349. if (brand.NoticeMoneyUnit == 2)
  350. {
  351. ActPrize = ActPrize / 100;
  352. }
  353. if (ActPrize > 0)
  354. {
  355. // if (ActPrize == 99)
  356. // {
  357. // ActPrize = 100;
  358. // }
  359. // else if (ActPrize == 199)
  360. // {
  361. // ActPrize = 200;
  362. // }
  363. // else if (ActPrize == 299)
  364. // {
  365. // ActPrize = 300;
  366. // }
  367. // else if (ActPrize == 249)
  368. // {
  369. // ActPrize = 260;
  370. // }
  371. ActPrize = 100;
  372. if (GetUserId > 0)
  373. {
  374. doActiveReward(db, merchant, pos, GetUserId, ParentNav, TopUserId, ActPrize);
  375. function.WriteLog("ActPrize:" + ActPrize + "", "实时处理激活奖励");
  376. }
  377. }
  378. else if(ActPrize == 0)
  379. {
  380. if(pos.BrandId == 6)
  381. {
  382. doActiveReward(db, merchant, pos, GetUserId, ParentNav, TopUserId, 50);
  383. function.WriteLog("ActPrize:50", "实时处理激活奖励");
  384. }
  385. }
  386. PosMachinesTwo edit = db.PosMachinesTwo.FirstOrDefault(m => m.Id == pos.Id);
  387. if(edit != null)
  388. {
  389. edit.Detail = "1";
  390. db.SaveChanges();
  391. }
  392. }
  393. // }
  394. }
  395. }
  396. db.Dispose();
  397. }
  398. //金控活动机返奖励
  399. private void doJk30(WebCMSEntities db, PosMachinesTwo pos, PosMerchantInfo merchant, int GetUserId, string ParentNav, int TopUserId)
  400. {
  401. // DateTime start = DateTime.Parse("2022-04-06 00:00:00");
  402. // DateTime end = DateTime.Parse("2022-07-05 00:00:00");
  403. // if((pos.BrandId == 1 || pos.BrandId == 3) && pos.CreateDate >= start && pos.CreateDate < end)
  404. // {
  405. // decimal amt = 0;
  406. // if(DateTime.Now < DateTime.Parse("2023-05-01 00:00:00"))
  407. // {
  408. // amt = 10;
  409. // }
  410. // if(amt > 0)
  411. // {
  412. // doActiveReward(db, merchant, pos, GetUserId, ParentNav, TopUserId, amt, 0, 1);
  413. // }
  414. // }
  415. }
  416. //无押金激活奖励
  417. public void activePrizeWithoutDeposit(int posid = 0)
  418. {
  419. WebCMSEntities db = new WebCMSEntities();
  420. DateTime yesterday = DateTime.Now.AddDays(-10);
  421. DateTime today = DateTime.Now.AddMinutes(-10);
  422. IQueryable<PosMachinesTwo> posList = db.PosMachinesTwo.Where(m => m.ActivationState == 1 && (string.IsNullOrEmpty(m.SeoKeyword) || m.SeoKeyword == "0") && m.CreditTrade >= 5000 && m.BrandId != 12 && m.BrandId != 13 && m.BrandId != 14 && m.BrandId != 15 && m.BrandId != 16 && m.Detail != "1");
  423. if (posid > 0)
  424. {
  425. posList = posList.Where(m => m.Id == posid);
  426. }
  427. else
  428. {
  429. posList = posList.Where(m => m.ActivationTime >= yesterday && m.ActivationTime < today);
  430. }
  431. foreach (PosMachinesTwo pos in posList.ToList())
  432. {
  433. function.WriteLog(str: "机具号:" + pos.PosSn, "无押金激活奖励日志");
  434. PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  435. if (merchant != null)
  436. {
  437. function.WriteLog("商户号:" + merchant.KqMerNo, "无押金激活奖励日志");
  438. string ParentNav = "";
  439. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  440. if (user != null)
  441. {
  442. function.WriteLog("机具所属人:" + user.Id, "无押金激活奖励日志");
  443. int GetUserId = user.Id;
  444. ParentNav = user.ParentNav;
  445. int TopUserId = 0;
  446. if (!string.IsNullOrEmpty(ParentNav))
  447. {
  448. TopUserId = int.Parse(ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  449. }
  450. function.WriteLog("BindingTime:" + pos.BindingTime, "无押金激活奖励日志");
  451. function.WriteLog("ActivationTime:" + pos.ActivationTime, "无押金激活奖励日志");
  452. if(pos.BindingTime.Value.AddDays(30) >= pos.ActivationTime)
  453. {
  454. function.WriteLog("满足条件", "无押金激活奖励日志");
  455. doActiveReward(db, merchant, pos, GetUserId, ParentNav, TopUserId, 30);
  456. function.WriteLog("已发放", "无押金激活奖励日志");
  457. DateTime now = pos.ActivationTime.Value;
  458. //盟主奖励
  459. if (pos.LeaderUserId > 0 && db.Leaders.Any(m => m.Id == pos.LeaderUserId && m.ExpiredDate > now) && pos.BindingTime > now.AddDays(-30) && pos.CardType < 100)
  460. {
  461. function.WriteLog("大盟主奖发放", "无押金激活奖励日志");
  462. RedisDbconn.Instance.AddList("LeaderPrizeQueue", pos.Id);
  463. }
  464. //运营中心奖励
  465. if (pos.BindingTime > now.AddDays(-30) && pos.CardType < 100)
  466. {
  467. function.WriteLog("运营中心奖发放", "无押金激活奖励日志");
  468. RedisDbconn.Instance.AddList("OperatePrizeQueue", pos.Id);
  469. }
  470. }
  471. PosMachinesTwo edit = db.PosMachinesTwo.FirstOrDefault(m => m.Id == pos.Id);
  472. if(edit != null)
  473. {
  474. edit.Detail = "1";
  475. db.SaveChanges();
  476. }
  477. }
  478. }
  479. function.WriteLog("\n\n\n", "无押金激活奖励日志");
  480. }
  481. db.Dispose();
  482. }
  483. public void activePrizeWithoutDeposit6(int posid = 0)
  484. {
  485. WebCMSEntities db = new WebCMSEntities();
  486. DateTime yesterday = DateTime.Now.AddDays(-30);
  487. DateTime today = DateTime.Now.AddMinutes(-10);
  488. IQueryable<PosMachinesTwo> posList = db.PosMachinesTwo.Where(m => m.ActivationState == 1 && m.CreditTrade >= 5000 && string.IsNullOrEmpty(m.SeoKeyword) && m.BrandId == 6 && m.Detail != "1");
  489. if (posid > 0)
  490. {
  491. posList = posList.Where(m => m.Id == posid);
  492. }
  493. else
  494. {
  495. posList = posList.Where(m => m.ActivationTime >= yesterday && m.ActivationTime < today);
  496. }
  497. foreach (PosMachinesTwo pos in posList.ToList())
  498. {
  499. PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  500. if (merchant != null)
  501. {
  502. string ParentNav = "";
  503. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  504. if (user != null)
  505. {
  506. int GetUserId = user.Id;
  507. ParentNav = user.ParentNav;
  508. int TopUserId = 0;
  509. if (!string.IsNullOrEmpty(ParentNav))
  510. {
  511. TopUserId = int.Parse(ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  512. }
  513. // 立刷30天内刷满5000,无服务费机具,返50
  514. if (pos.BrandId == 6 && pos.BindingTime > DateTime.Now.AddDays(-30))
  515. {
  516. doActiveReward(db, merchant, pos, GetUserId, ParentNav, TopUserId, 50);
  517. }
  518. PosMachinesTwo edit = db.PosMachinesTwo.FirstOrDefault(m => m.Id == pos.Id);
  519. if(edit != null)
  520. {
  521. edit.Detail = "1";
  522. db.SaveChanges();
  523. }
  524. }
  525. }
  526. }
  527. db.Dispose();
  528. }
  529. public void activePrizeWithoutDeposit12(int posid = 0)
  530. {
  531. WebCMSEntities db = new WebCMSEntities();
  532. DateTime yesterday = DateTime.Now.AddDays(-30);
  533. DateTime today = DateTime.Now.AddMinutes(-10);
  534. IQueryable<PosMachinesTwo> posList = db.PosMachinesTwo.Where(m => m.ActivationState == 1 && m.CreditTrade >= 5000 && string.IsNullOrEmpty(m.SeoKeyword) && (m.BrandId == 12 || m.BrandId == 13) && m.Detail != "1");
  535. if (posid > 0)
  536. {
  537. posList = posList.Where(m => m.Id == posid);
  538. }
  539. else
  540. {
  541. posList = posList.Where(m => m.ActivationTime >= yesterday && m.ActivationTime < today);
  542. }
  543. foreach (PosMachinesTwo pos in posList.ToList())
  544. {
  545. PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  546. if (merchant != null)
  547. {
  548. string ParentNav = "";
  549. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  550. if (user != null)
  551. {
  552. int GetUserId = user.Id;
  553. ParentNav = user.ParentNav;
  554. int TopUserId = 0;
  555. if (!string.IsNullOrEmpty(ParentNav))
  556. {
  557. TopUserId = int.Parse(ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  558. }
  559. //首台无押金机返50
  560. if(pos.BindingTime.Value.AddDays(30) >= pos.ActivationTime)
  561. {
  562. doActiveReward(db, merchant, pos, GetUserId, ParentNav, TopUserId, 30);
  563. DateTime now = pos.ActivationTime.Value;
  564. //盟主奖励
  565. if (pos.LeaderUserId > 0 && db.Leaders.Any(m => m.Id == pos.LeaderUserId && m.ExpiredDate > now) && pos.BindingTime > now.AddDays(-30) && pos.CardType < 100)
  566. {
  567. function.WriteLog("大盟主奖发放", "开机奖励在激活中监控");
  568. RedisDbconn.Instance.AddList("LeaderPrizeQueue", pos.Id);
  569. }
  570. //运营中心奖励
  571. if (pos.BindingTime > now.AddDays(-30) && pos.CardType < 100)
  572. {
  573. function.WriteLog("运营中心奖发放", "开机奖励在激活中监控");
  574. RedisDbconn.Instance.AddList("OperatePrizeQueue", pos.Id);
  575. }
  576. }
  577. PosMachinesTwo item = db.PosMachinesTwo.FirstOrDefault(m => m.Id == pos.Id);
  578. if(item != null)
  579. {
  580. item.Detail = "1";
  581. db.SaveChanges();
  582. }
  583. }
  584. }
  585. }
  586. db.Dispose();
  587. }
  588. public void activePrizeWithoutDeposit15(int posid = 0)
  589. {
  590. WebCMSEntities db = new WebCMSEntities();
  591. DateTime yesterday = DateTime.Now.AddDays(-100);
  592. DateTime today = DateTime.Now.AddHours(-1);
  593. IQueryable<PosMachinesTwo> posList = db.PosMachinesTwo.Where(m => m.ActivationState == 1 && m.CreditTrade >= 5000 && string.IsNullOrEmpty(m.SeoKeyword) && (m.BrandId == 15 || m.BrandId == 16) && m.Detail != "1");
  594. if (posid > 0)
  595. {
  596. posList = posList.Where(m => m.Id == posid);
  597. }
  598. else
  599. {
  600. posList = posList.Where(m => m.ActivationTime >= yesterday && m.ActivationTime < today);
  601. }
  602. foreach (PosMachinesTwo pos in posList.ToList())
  603. {
  604. function.WriteLog("机具号:" + pos.PosSn + ";奖励标记:" + pos.Detail + ";", "实时处理来客吧0押激活奖励");
  605. PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  606. if (merchant != null)
  607. {
  608. string ParentNav = "";
  609. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  610. if (user != null)
  611. {
  612. int GetUserId = user.Id;
  613. ParentNav = user.ParentNav;
  614. int TopUserId = 0;
  615. if (!string.IsNullOrEmpty(ParentNav))
  616. {
  617. TopUserId = int.Parse(ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  618. }
  619. //首台无押金机返50
  620. if(pos.BindingTime.Value.AddDays(30) >= pos.ActivationTime)
  621. {
  622. doActiveReward(db, merchant, pos, GetUserId, ParentNav, TopUserId, 30);
  623. DateTime now = pos.ActivationTime.Value;
  624. //盟主奖励
  625. if (pos.LeaderUserId > 0 && db.Leaders.Any(m => m.Id == pos.LeaderUserId && m.ExpiredDate > now) && pos.BindingTime > now.AddDays(-30) && pos.CardType < 100)
  626. {
  627. function.WriteLog("大盟主奖发放", "开机奖励在激活中监控");
  628. RedisDbconn.Instance.AddList("LeaderPrizeQueue", pos.Id);
  629. }
  630. //运营中心奖励
  631. if (pos.BindingTime > now.AddDays(-30) && pos.CardType < 100)
  632. {
  633. function.WriteLog("运营中心奖发放", "开机奖励在激活中监控");
  634. RedisDbconn.Instance.AddList("OperatePrizeQueue", pos.Id);
  635. }
  636. }
  637. function.WriteLog("ActPrize:30", "实时处理来客吧0押激活奖励");
  638. PosMachinesTwo item = db.PosMachinesTwo.FirstOrDefault(m => m.Id == pos.Id);
  639. if(item != null)
  640. {
  641. item.Detail = "1";
  642. db.SaveChanges();
  643. }
  644. }
  645. }
  646. }
  647. db.Dispose();
  648. }
  649. public void activePrizeWithoutDeposit122(int posid = 0)
  650. {
  651. WebCMSEntities db = new WebCMSEntities();
  652. DateTime yesterday = DateTime.Now.AddDays(-30);
  653. DateTime today = DateTime.Now.AddMinutes(-5);
  654. DateTime checkTime = DateTime.Parse("2023-08-01 00:00:00");
  655. IQueryable<PosMachinesTwo> posList = db.PosMachinesTwo.Where(m => m.ActivationState == 1 && m.CreditTrade >= 1000 && m.ActivationTime < checkTime && string.IsNullOrEmpty(m.SeoKeyword) && (m.BrandId == 12 || m.BrandId == 13) && m.Detail != "1");
  656. if (posid > 0)
  657. {
  658. posList = posList.Where(m => m.Id == posid);
  659. }
  660. else
  661. {
  662. posList = posList.Where(m => m.ActivationTime >= yesterday && m.ActivationTime < today);
  663. }
  664. foreach (PosMachinesTwo pos in posList.ToList())
  665. {
  666. PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  667. if (merchant != null)
  668. {
  669. string ParentNav = "";
  670. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  671. if (user != null)
  672. {
  673. int GetUserId = user.Id;
  674. ParentNav = user.ParentNav;
  675. int TopUserId = 0;
  676. if (!string.IsNullOrEmpty(ParentNav))
  677. {
  678. TopUserId = int.Parse(ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  679. }
  680. string IdCard = merchant.MerIdcardNo;
  681. string IdCardStart = IdCard.Substring(0, 6);
  682. string IdCardEnd = IdCard.Substring(IdCard.Length - 4);
  683. string MerName = merchant.MerchantName;
  684. List<int> BrandIds = new List<int>();
  685. BrandIds.Add(4);
  686. BrandIds.Add(5);
  687. BrandIds.Add(8);
  688. BrandIds.Add(9);
  689. PosMerchantInfo other = db.PosMerchantInfo.FirstOrDefault(m => m.MerIdcardNo.StartsWith(IdCardStart) && m.MerIdcardNo.EndsWith(IdCardEnd) && m.MerchantName.Contains(MerName) && BrandIds.Contains(m.BrandId));
  690. if(other != null)
  691. {
  692. PosMachinesTwo checkpos = db.PosMachinesTwo.FirstOrDefault(m => m.PosSn == other.KqSnNo);
  693. if(checkpos != null)
  694. {
  695. doActiveReward(db, merchant, pos, GetUserId, ParentNav, TopUserId, 50);
  696. PosMachinesTwo edit = db.PosMachinesTwo.FirstOrDefault(m => m.Id == pos.Id);
  697. if(edit != null)
  698. {
  699. edit.SeoKeyword = Utils.Instance.TransferDeposit(edit, checkpos.SeoKeyword);
  700. edit.UpFeeFlag = checkpos.UpFeeFlag;
  701. edit.DownFeeFlag = checkpos.DownFeeFlag;
  702. edit.UpFeeDate = checkpos.UpFeeDate;
  703. edit.DownFeeDate = checkpos.DownFeeDate;
  704. edit.BindingTime = checkpos.BindingTime;
  705. edit.IsFirst = checkpos.IsFirst;
  706. db.SaveChanges();
  707. if(edit.UpFeeFlag == 1 && edit.DownFeeFlag == 0)
  708. {
  709. string info = "{\"RecordId\":\"\",\"PosId\":\"" + edit.Id + "\",\"Fee\": \"0.63\",\"Kind\": \"1\",\"OpMan\": \"系统\"}";
  710. RedisDbconn.Instance.AddList("SetDepositPostQueue", info);
  711. }
  712. }
  713. }
  714. }
  715. PosMachinesTwo item = db.PosMachinesTwo.FirstOrDefault(m => m.Id == pos.Id);
  716. if(item != null)
  717. {
  718. item.Detail = "1";
  719. db.SaveChanges();
  720. }
  721. }
  722. }
  723. }
  724. db.Dispose();
  725. }
  726. public void doActiveReward(WebCMSEntities db, PosMerchantInfo merchant, PosMachinesTwo pos, int GetUserId, string ParentNav, int TopUserId, decimal ActPrize, int ChangeType = 0, int ActType = 0)
  727. {
  728. bool check = db.ActiveReward.Any(m => m.KqMerNo == merchant.KqMerNo && m.RewardAmount == ActPrize && m.ActType == ActType);
  729. bool check1 = db.ActiveReward.Any(m => m.KqSnNo == pos.PosSn && m.RewardAmount == ActPrize && m.ActType == ActType);
  730. if (!check && !check1)
  731. {
  732. function.WriteLog(DateTime.Now.ToString() + ":" + pos.PosSn, "实时处理激活奖励");
  733. Users machineUser = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new Users();
  734. db.ActiveReward.Add(new ActiveReward()
  735. {
  736. CreateDate = DateTime.Now,
  737. UpdateDate = DateTime.Now,
  738. UserId = GetUserId, //创客
  739. MerchantId = pos.BindMerchantId, //商户
  740. StandardDate = pos.ActivationTime, //达标日期
  741. RewardAmount = ActPrize, //奖励金额
  742. BrandId = pos.BrandId, //品牌
  743. UserNav = ParentNav, //创客父级
  744. DirectBuddyNo = merchant.UserId, //商户直属创客
  745. KqMerNo = merchant.KqMerNo, //渠道商户编号
  746. KqSnNo = pos.PosSn, //渠道SN号
  747. SnType = pos.PosSnType, //机具类型
  748. SnApplyUserId = pos.BuyUserId, //机具申请创客
  749. ActType = ActType, //激活类型
  750. SnStoreId = pos.StoreId, //SN仓库
  751. RewardTips = "激活奖励", //奖励描述
  752. Remark = "激活奖励", //备注
  753. ActDate = pos.ActivationTime, //激活时间
  754. TopUserId = TopUserId, //顶级创客
  755. SeoTitle = machineUser.RealName,
  756. });
  757. db.SaveChanges();
  758. string IdBrand = GetUserId + "_" + pos.BrandId;
  759. UserMachineData userData = db.UserMachineData.FirstOrDefault(m => m.IdBrand == IdBrand);
  760. if (userData == null)
  761. {
  762. userData = db.UserMachineData.Add(new UserMachineData()
  763. {
  764. IdBrand = IdBrand,
  765. }).Entity;
  766. db.SaveChanges();
  767. }
  768. userData.ActProfit += ActPrize;
  769. db.SaveChanges();
  770. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == GetUserId);
  771. if (account == null)
  772. {
  773. account = db.UserAccount.Add(new UserAccount()
  774. {
  775. Id = GetUserId,
  776. UserId = GetUserId,
  777. }).Entity;
  778. db.SaveChanges();
  779. }
  780. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  781. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  782. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  783. account.BalanceAmount += ActPrize;
  784. account.TotalAmount += ActPrize;
  785. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  786. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  787. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  788. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  789. {
  790. CreateDate = DateTime.Now,
  791. UpdateDate = DateTime.Now,
  792. UserId = GetUserId, //创客
  793. ChangeType = ChangeType, //变动类型
  794. ProductType = pos.BrandId, //产品类型
  795. ChangeAmount = ActPrize, //变更金额
  796. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  797. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  798. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  799. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  800. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  801. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  802. QueryCount = pos.Id, //机具Id
  803. }).Entity;
  804. db.SaveChanges();
  805. }
  806. }
  807. //根据商户信息发放激活奖励
  808. public void dosomething32(int merid = 0)
  809. {
  810. WebCMSEntities db = new WebCMSEntities();
  811. DateTime yesterday = DateTime.Now.AddHours(-3);
  812. DateTime today = DateTime.Now;
  813. IQueryable<PosMerchantInfo> merList = db.PosMerchantInfo.Where(m => m.ActiveStatus == 1 && !string.IsNullOrEmpty(m.SeoKeyword));
  814. if (merid > 0)
  815. {
  816. merList = merList.Where(m => m.Id == merid);
  817. }
  818. else
  819. {
  820. merList = merList.Where(m => m.MerStandardDate >= yesterday && m.MerStandardDate < today);
  821. }
  822. foreach (PosMerchantInfo merchant in merList.ToList())
  823. {
  824. // PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId && !string.IsNullOrEmpty(m.MerIdcardNo));
  825. // PosMerchantOtherInfo otherInfo = db.PosMerchantOtherInfo.FirstOrDefault(m => m.CertId == merchant.MerIdcardNo && m.PrizeFlag1 == 0);
  826. // if (otherInfo != null)
  827. // {
  828. // otherInfo.PrizeFlag1 = 1;
  829. // db.SaveChanges();
  830. MachineForMerNo forMerNo = db.MachineForMerNo.FirstOrDefault(m => m.MerNo == merchant.MerchantNo) ?? new MachineForMerNo();
  831. PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == forMerNo.SnId) ?? new PosMachinesTwo();
  832. string ParentNav = "";
  833. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  834. if (user != null)
  835. {
  836. int GetUserId = user.Id;
  837. ParentNav = user.ParentNav;
  838. int TopUserId = 0;
  839. if (!string.IsNullOrEmpty(ParentNav))
  840. {
  841. TopUserId = int.Parse(ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  842. }
  843. decimal ActPrize = decimal.Parse(function.CheckNum(merchant.SeoKeyword));
  844. KqProducts brand = db.KqProducts.FirstOrDefault(m => m.Id == pos.BrandId) ?? new KqProducts();
  845. if (brand.NoticeMoneyUnit == 2)
  846. {
  847. ActPrize = ActPrize / 100;
  848. }
  849. if (ActPrize > 0)
  850. {
  851. bool check = db.ActiveReward.Any(m => m.KqSnNo == pos.PosSn);
  852. if (!check)
  853. {
  854. if (ActPrize == 99)
  855. {
  856. ActPrize = 100;
  857. }
  858. else if (ActPrize == 199)
  859. {
  860. ActPrize = 200;
  861. }
  862. else if (ActPrize == 299)
  863. {
  864. ActPrize = 300;
  865. }
  866. Users machineUser = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new Users();
  867. db.ActiveReward.Add(new ActiveReward()
  868. {
  869. CreateDate = DateTime.Now,
  870. UpdateDate = DateTime.Now,
  871. UserId = GetUserId, //创客
  872. MerchantId = pos.BindMerchantId, //商户
  873. StandardDate = pos.ActivationTime, //达标日期
  874. RewardAmount = ActPrize, //奖励金额
  875. BrandId = pos.BrandId, //品牌
  876. UserNav = ParentNav, //创客父级
  877. DirectBuddyNo = merchant.UserId, //商户直属创客
  878. KqMerNo = merchant.KqMerNo, //渠道商户编号
  879. KqSnNo = pos.PosSn, //渠道SN号
  880. SnType = pos.PosSnType, //机具类型
  881. SnApplyUserId = pos.BuyUserId, //机具申请创客
  882. ActType = 0, //激活类型
  883. SnStoreId = pos.StoreId, //SN仓库
  884. RewardTips = "激活奖励", //奖励描述
  885. Remark = "激活奖励", //备注
  886. ActDate = pos.ActivationTime, //激活时间
  887. TopUserId = TopUserId, //顶级创客
  888. SeoTitle = machineUser.RealName,
  889. });
  890. db.SaveChanges();
  891. string IdBrand = GetUserId + "_" + pos.BrandId;
  892. UserMachineData userData = db.UserMachineData.FirstOrDefault(m => m.IdBrand == IdBrand);
  893. if (userData == null)
  894. {
  895. userData = db.UserMachineData.Add(new UserMachineData()
  896. {
  897. IdBrand = IdBrand,
  898. }).Entity;
  899. db.SaveChanges();
  900. }
  901. userData.ActProfit += ActPrize;
  902. db.SaveChanges();
  903. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == GetUserId);
  904. if (account == null)
  905. {
  906. account = db.UserAccount.Add(new UserAccount()
  907. {
  908. Id = GetUserId,
  909. UserId = GetUserId,
  910. }).Entity;
  911. db.SaveChanges();
  912. }
  913. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  914. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  915. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  916. account.BalanceAmount += ActPrize;
  917. account.TotalAmount += ActPrize;
  918. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  919. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  920. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  921. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  922. {
  923. CreateDate = DateTime.Now,
  924. UpdateDate = DateTime.Now,
  925. UserId = GetUserId, //创客
  926. ChangeType = 0, //变动类型
  927. ProductType = pos.BrandId, //产品类型
  928. ChangeAmount = ActPrize, //变更金额
  929. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  930. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  931. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  932. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  933. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  934. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  935. }).Entity;
  936. db.SaveChanges();
  937. string dateString = pos.ActivationTime.Value.ToString("yyyyMMdd");
  938. string monthString = pos.ActivationTime.Value.ToString("yyyyMM");
  939. // 激活奖励列表
  940. List<string> dates = RedisDbconn.Instance.GetList<string>("ActiveRewardDay:" + GetUserId + ":" + pos.BrandId);
  941. if (!dates.Contains(dateString))
  942. {
  943. RedisDbconn.Instance.AddList("ActiveRewardDay:" + GetUserId + ":" + pos.BrandId, dateString);
  944. }
  945. RedisDbconn.Instance.AddNumber("ActiveRewardAmt:" + GetUserId + ":" + pos.BrandId + ":" + dateString, ActPrize);
  946. List<string> months = RedisDbconn.Instance.GetList<string>("ActiveRewardMonth:" + GetUserId + ":" + pos.BrandId);
  947. if (!months.Contains(monthString))
  948. {
  949. RedisDbconn.Instance.AddList("ActiveRewardMonth:" + GetUserId + ":" + pos.BrandId, monthString);
  950. }
  951. RedisDbconn.Instance.AddNumber("ActiveRewardAmt:" + GetUserId + ":" + pos.BrandId + ":" + monthString, ActPrize);
  952. // 激活奖励详情
  953. List<int> actPrizeList = RedisDbconn.Instance.GetList<int>("ActiveRewardDetail:" + GetUserId + ":" + pos.BrandId + ":" + dateString);
  954. if (!actPrizeList.Contains(pos.BindMerchantId))
  955. {
  956. RedisDbconn.Instance.AddList("ActiveRewardDetail:" + GetUserId + ":" + pos.BrandId + ":" + dateString, pos.BindMerchantId);
  957. }
  958. RedisDbconn.Instance.AddNumber("ActiveRewardAmt:mer:" + pos.BindMerchantId + ":" + pos.BrandId + ":" + dateString, ActPrize);
  959. }
  960. }
  961. }
  962. // }
  963. }
  964. db.Dispose();
  965. }
  966. //3. 前一天的激活记录,根据创客类型,如果是商户型创客,则开机奖励的起始人从此人上级计算。如果不是,则从此人开始计算
  967. public void dosomething4(string date)
  968. {
  969. WebCMSEntities db = new WebCMSEntities();
  970. DateTime yesterday = DateTime.Parse(date + " 00:00:00");
  971. DateTime today = DateTime.Parse(DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00");
  972. List<PosMachinesTwo> posList = db.PosMachinesTwo.Where(m => m.ActivationState == 1 && m.ActivationTime >= yesterday && m.ActivationTime < today && !string.IsNullOrEmpty(m.SeoKeyword) && m.SeoKeyword != "0" && m.CreditTrade >= 1000).ToList();
  973. foreach (PosMachinesTwo pos in posList)
  974. {
  975. if (pos.BindingTime > DateTime.Now.AddDays(-30))
  976. {
  977. decimal ActPrize = decimal.Parse(function.CheckNum(pos.SeoKeyword));
  978. if (ActPrize > 0)
  979. {
  980. // PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId && !string.IsNullOrEmpty(m.MerIdcardNo));
  981. // PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId && m.Sort == 1);
  982. PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  983. if (merchant != null)
  984. {
  985. // PosMerchantOtherInfo otherInfo = db.PosMerchantOtherInfo.FirstOrDefault(m => m.CertId == merchant.MerIdcardNo && m.PrizeFlag2 == 0);
  986. // if (otherInfo != null)
  987. // {
  988. // otherInfo.PrizeFlag2 = 1;
  989. // db.SaveChanges();
  990. // 从机具所属人上级开始分开机奖励
  991. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  992. if (user != null)
  993. {
  994. if (!string.IsNullOrEmpty(user.ParentNav))
  995. {
  996. decimal Prize = 20;
  997. string[] ParentNavs = user.ParentNav.Trim(',').Replace(",,", ",").Split(',');
  998. for (int i = ParentNavs.Length - 1; i >= 0; i--)
  999. {
  1000. int UserId = int.Parse(ParentNavs[i]);
  1001. Users puser = db.Users.FirstOrDefault(m => m.Id == UserId && m.AuthFlag == 1);
  1002. if (puser != null && Prize > 0)
  1003. {
  1004. int machineCount = db.PosMachinesTwo.Count(m => m.BuyUserId == puser.Id && m.PosSnType == 0 && m.ActivationState == 0); //判断是否拥有3台兑换机
  1005. int ActiveCount = db.PosMachinesTwo.Count(m => m.BuyUserId == puser.Id && m.ActivationState == 1); //判断是否拥有3台激活机(不限购买或赠送)
  1006. int couponCount = db.PosCoupons.Count(m => m.UserId == puser.Id && m.IsUse == 0); //判断是否拥有3张券
  1007. // int BigCount = db.PosMachinesTwo.Count(m => m.UserId == puser.Id && m.BrandId == 3); //判断是否拥有2台大机
  1008. // int BigActiveCount = db.PosMachinesTwo.Count(m => m.UserId == puser.Id && m.ActivationState == 1 && m.BrandId == 3); //判断是否拥有2台激活大机(不限购买或赠送)
  1009. if (machineCount + ActiveCount + couponCount >= 3)
  1010. {
  1011. int pTopUserId = 0;
  1012. if (!string.IsNullOrEmpty(puser.ParentNav))
  1013. {
  1014. pTopUserId = int.Parse(puser.ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  1015. }
  1016. Users machineUser = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new Users();
  1017. OpenRewardDetail detail = db.OpenRewardDetail.Add(new OpenRewardDetail()
  1018. {
  1019. CreateDate = DateTime.Now,
  1020. UpdateDate = DateTime.Now,
  1021. TradeMonth = yesterday.ToString("yyyyMM"), //交易月
  1022. TradeDate = yesterday, //达标日期
  1023. UserId = puser.Id, //创客
  1024. BrandId = pos.BrandId, //品牌
  1025. ProductName = RelationClass.GetKqProductsInfo(pos.BrandId), //产品名称
  1026. MerchantId = pos.BindMerchantId, //商户
  1027. DirectUserId = merchant.UserId, //商户直属人
  1028. SnNo = pos.PosSn, //SN号
  1029. MerNo = merchant.KqMerNo, //渠道商户号
  1030. SnType = pos.PosSnType, //机具类型
  1031. StandardDate = pos.ActivationTime, //商户的激活日期
  1032. SnStoreId = pos.StoreId, //SN仓库
  1033. MerBuddyType = puser.MerchantType, //商户创客类型
  1034. RewardType = 1, //奖励类型 1-开机直接奖励,2-开机间接奖励
  1035. RewardTips = "开机奖励", //奖励描述
  1036. CreditTradeAmt = pos.CreditTrade, //贷记卡交易总金额
  1037. DebitTradeAmt = pos.DebitCardTrade, //借记卡交易总金额
  1038. CreditRewardAmount = Prize, //贷记卡交易奖励金额
  1039. RewardDesc = "开机奖励", //奖励描述
  1040. TopUserId = pTopUserId, //顶级创客
  1041. SeoTitle = machineUser.RealName,
  1042. }).Entity;
  1043. db.OpenReward.Add(new OpenReward()
  1044. {
  1045. CreateDate = DateTime.Now,
  1046. UpdateDate = DateTime.Now,
  1047. TradeMonth = yesterday.ToString("yyyyMM"), //交易月
  1048. TradeDate = DateTime.Now, //达标日期
  1049. UserId = puser.Id, //创客
  1050. BrandId = pos.BrandId, //品牌
  1051. RewardType = 2, //奖励类型
  1052. CreditTradeAmt = pos.CreditTrade, //贷记卡交易总金额
  1053. DebitTradeAmt = pos.DebitCardTrade, //借记卡交易总金额
  1054. CreditRewardAmount = Prize, //贷记卡交易奖励金额
  1055. RewardDesc = "开机奖励", //奖励描述
  1056. TopUserId = pTopUserId, //顶级创客
  1057. });
  1058. string IdBrand = puser.Id + "_" + pos.BrandId;
  1059. UserMachineData userData = db.UserMachineData.FirstOrDefault(m => m.IdBrand == IdBrand);
  1060. if (userData == null)
  1061. {
  1062. userData = db.UserMachineData.Add(new UserMachineData()
  1063. {
  1064. IdBrand = IdBrand,
  1065. }).Entity;
  1066. db.SaveChanges();
  1067. }
  1068. userData.OpenProfit += Prize;
  1069. db.SaveChanges();
  1070. //账户入库
  1071. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == puser.Id);
  1072. if (account == null)
  1073. {
  1074. account = db.UserAccount.Add(new UserAccount()
  1075. {
  1076. Id = puser.Id,
  1077. UserId = puser.Id,
  1078. }).Entity;
  1079. db.SaveChanges();
  1080. }
  1081. //收支明细入库
  1082. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  1083. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  1084. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  1085. account.BalanceAmount += Prize;
  1086. account.TotalAmount += Prize;
  1087. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  1088. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  1089. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  1090. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  1091. {
  1092. CreateDate = DateTime.Now,
  1093. UpdateDate = DateTime.Now,
  1094. UserId = puser.Id, //创客
  1095. ChangeType = 50, //变动类型
  1096. ProductType = pos.BrandId, //产品类型
  1097. ChangeAmount = Prize, //变更金额
  1098. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  1099. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  1100. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  1101. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  1102. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  1103. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  1104. }).Entity;
  1105. db.SaveChanges();
  1106. string dateString = yesterday.ToString("yyyyMMdd");
  1107. string monthString = yesterday.ToString("yyyyMM");
  1108. // 开机奖励列表
  1109. List<string> dates = RedisDbconn.Instance.GetList<string>("OpenRewardDay:" + puser.Id + ":" + pos.BrandId);
  1110. if (!dates.Contains(dateString))
  1111. {
  1112. RedisDbconn.Instance.AddList("OpenRewardDay:" + puser.Id + ":" + pos.BrandId, dateString);
  1113. }
  1114. RedisDbconn.Instance.AddNumber("OpenRewardAmt:" + puser.Id + ":" + pos.BrandId + ":" + dateString, Prize);
  1115. List<string> months = RedisDbconn.Instance.GetList<string>("OpenRewardMonth:" + puser.Id + ":" + pos.BrandId);
  1116. if (!months.Contains(monthString))
  1117. {
  1118. RedisDbconn.Instance.AddList("OpenRewardMonth:" + puser.Id + ":" + pos.BrandId, monthString);
  1119. }
  1120. RedisDbconn.Instance.AddNumber("OpenRewardAmt:" + puser.Id + ":" + pos.BrandId + ":" + monthString, Prize);
  1121. // 开机奖励详情
  1122. RedisDbconn.Instance.AddList("OpenRewardDetail:" + puser.Id + ":" + pos.BrandId + ":" + dateString, detail);
  1123. Prize = 0;
  1124. }
  1125. }
  1126. }
  1127. }
  1128. }
  1129. // }
  1130. }
  1131. }
  1132. }
  1133. }
  1134. db.Dispose();
  1135. }
  1136. //实时获取开机奖励
  1137. public void StartOpenReward()
  1138. {
  1139. Thread th = new Thread(StartOpenRewardDo);
  1140. th.IsBackground = true;
  1141. th.Start();
  1142. }
  1143. public void StartOpenRewardDo()
  1144. {
  1145. while(true)
  1146. {
  1147. string content = RedisDbconn.Instance.RPop<string>("OpenRewardQueue");
  1148. if(!string.IsNullOrEmpty(content))
  1149. {
  1150. try
  1151. {
  1152. function.WriteLog("\n\n" + DateTime.Now.ToString() + "\nposid:" + content, "开机奖励发放日志");
  1153. int PosId = int.Parse(content);
  1154. Thread.Sleep(1000);
  1155. WebCMSEntities db = new WebCMSEntities();
  1156. PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == PosId && m.ActivationState == 1 && ((!string.IsNullOrEmpty(m.SeoKeyword) && m.SeoKeyword != "0" && m.CreditTrade >= 1000) || m.BrandId == 14));
  1157. if (pos != null)
  1158. {
  1159. function.WriteLog("sn:" + pos.PosSn, "开机奖励发放日志");
  1160. bool IsGet = db.OpenRewardDetail.Any(m => m.SnNo == pos.PosSn);
  1161. if (pos.BindingTime > DateTime.Now.AddDays(-30) && !IsGet)
  1162. {
  1163. decimal ActPrize = decimal.Parse(function.CheckNum(pos.SeoKeyword));
  1164. function.WriteLog("押金:" + pos.SeoKeyword, "开机奖励发放日志");
  1165. if (ActPrize > 0 || pos.BrandId == 14)
  1166. {
  1167. PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  1168. if (merchant != null)
  1169. {
  1170. function.WriteLog("商户:" + merchant.KqMerNo, "开机奖励发放日志");
  1171. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  1172. if (user != null)
  1173. {
  1174. function.WriteLog("所属人:" + user.MakerCode, "开机奖励发放日志");
  1175. string ParentNav = function.CheckNull(user.ParentNav) + "," + user.Id + ",";
  1176. if (!string.IsNullOrEmpty(ParentNav))
  1177. {
  1178. decimal Prize = 0;
  1179. if(pos.BrandId == 14)
  1180. {
  1181. Prize = 19 * 0.3M;
  1182. }
  1183. string[] ParentNavs = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  1184. for (int i = ParentNavs.Length - 1; i >= 0; i--)
  1185. {
  1186. int UserId = int.Parse(ParentNavs[i]);
  1187. // Users puser = db.Users.FirstOrDefault(m => m.Id == UserId && m.AuthFlag == 1 && m.Status > -1);
  1188. UserRankItem puser = PosCouponPrizeService.Instance.GetUserLevel(db, UserId);
  1189. if (puser.Id > 0 && Prize > 0)
  1190. {
  1191. function.WriteLog("上级:" + puser.MakerCode, "开机奖励发放日志");
  1192. function.WriteLog("条件:LeaderLevel:" + puser.LeaderLevel + ",UserType:" + puser.UserType, "开机奖励发放日志");
  1193. if(puser.UserType > 0 || puser.LeaderLevel > 0)
  1194. {
  1195. bool leaderOp = true;
  1196. if(puser.LeaderLevel > 0 && puser.UserType == 0)
  1197. {
  1198. DateTime now = DateTime.Now;
  1199. leaderOp = db.Leaders.Any(m => m.Id == puser.Id && m.ExpiredDate >= now);
  1200. function.WriteLog("条件:leaderOp:" + leaderOp, "开机奖励发放日志");
  1201. }
  1202. if(leaderOp)
  1203. {
  1204. function.WriteLog("满足条件", "开机奖励发放日志");
  1205. int pTopUserId = 0;
  1206. if (!string.IsNullOrEmpty(puser.ParentNav))
  1207. {
  1208. pTopUserId = int.Parse(puser.ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  1209. }
  1210. PostOpenReward(db, pos, merchant, puser, Prize);
  1211. Prize = 0;
  1212. }
  1213. }
  1214. }
  1215. }
  1216. }
  1217. }
  1218. // }
  1219. }
  1220. }
  1221. }
  1222. }
  1223. db.Dispose();
  1224. }
  1225. catch(Exception ex)
  1226. {
  1227. function.WriteLog(DateTime.Now.ToString() + "\r\n" + ex.ToString(), "实时获取开机奖励异常");
  1228. }
  1229. }
  1230. else
  1231. {
  1232. Thread.Sleep(5000);
  1233. }
  1234. }
  1235. }
  1236. public void StartLeaderReward()
  1237. {
  1238. Thread th = new Thread(StartLeaderRewardDo);
  1239. th.IsBackground = true;
  1240. th.Start();
  1241. }
  1242. public void StartLeaderRewardDo()
  1243. {
  1244. while(true)
  1245. {
  1246. string content = RedisDbconn.Instance.RPop<string>("LeaderRewardQueue");
  1247. if(!string.IsNullOrEmpty(content))
  1248. {
  1249. try
  1250. {
  1251. function.WriteLog("\n\n" + DateTime.Now.ToString() + "\nposid:" + content, "盟主开机奖励发放日志");
  1252. int PosId = int.Parse(content);
  1253. Thread.Sleep(1000);
  1254. WebCMSEntities db = new WebCMSEntities();
  1255. PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == PosId && m.ActivationState == 1 && m.CreditTrade >= 10000);
  1256. if (pos != null)
  1257. {
  1258. function.WriteLog("sn:" + pos.PosSn, "盟主开机奖励发放日志");
  1259. bool IsGet = db.OpenRewardDetail.Any(m => m.SnNo == pos.PosSn);
  1260. if (!IsGet)
  1261. {
  1262. // decimal ActPrize = decimal.Parse(function.CheckNum(pos.SeoKeyword));
  1263. // function.WriteLog("押金:" + pos.SeoKeyword, "盟主开机奖励发放日志");
  1264. // if (ActPrize > 0)
  1265. // {
  1266. PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  1267. if (merchant != null)
  1268. {
  1269. function.WriteLog("商户:" + merchant.KqMerNo, "盟主开机奖励发放日志");
  1270. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  1271. if (user != null)
  1272. {
  1273. function.WriteLog("所属人:" + user.MakerCode, "盟主开机奖励发放日志");
  1274. string ParentNav = function.CheckNull(user.ParentNav) + "," + user.Id + ",";
  1275. if (!string.IsNullOrEmpty(ParentNav))
  1276. {
  1277. decimal Prize = 50;
  1278. string[] ParentNavs = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  1279. for (int i = ParentNavs.Length - 1; i >= 0; i--)
  1280. {
  1281. int UserId = int.Parse(ParentNavs[i]);
  1282. // Users puser = db.Users.FirstOrDefault(m => m.Id == UserId && m.AuthFlag == 1 && m.Status > -1);
  1283. UserRankItem puser = PosCouponPrizeService.Instance.GetUserLevel(db, UserId);
  1284. if (puser.Id > 0 && Prize > 0)
  1285. {
  1286. function.WriteLog("上级:" + puser.MakerCode, "盟主开机奖励发放日志");
  1287. function.WriteLog("条件:LeaderLevel:" + puser.LeaderLevel + ",UserType:" + puser.UserType, "盟主开机奖励发放日志");
  1288. if(puser.LeaderLevel > 0 || puser.UserType > 0)
  1289. {
  1290. bool leaderOp = true;
  1291. if(puser.LeaderLevel > 0 && puser.UserType == 0)
  1292. {
  1293. DateTime now = DateTime.Now;
  1294. leaderOp = db.Leaders.Any(m => m.Id == puser.Id && m.ExpiredDate >= now);
  1295. function.WriteLog("条件:leaderOp:" + leaderOp, "盟主开机奖励发放日志");
  1296. }
  1297. if(leaderOp)
  1298. {
  1299. function.WriteLog("满足条件", "盟主开机奖励发放日志");
  1300. int pTopUserId = 0;
  1301. if (!string.IsNullOrEmpty(puser.ParentNav))
  1302. {
  1303. pTopUserId = int.Parse(puser.ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  1304. }
  1305. PostOpenReward(db, pos, merchant, puser, Prize);
  1306. Prize = 0;
  1307. }
  1308. }
  1309. }
  1310. }
  1311. }
  1312. }
  1313. // }
  1314. }
  1315. // }
  1316. }
  1317. }
  1318. db.Dispose();
  1319. }
  1320. catch(Exception ex)
  1321. {
  1322. function.WriteLog(DateTime.Now.ToString() + "\r\n" + ex.ToString(), "盟主开机奖励发放异常");
  1323. }
  1324. }
  1325. else
  1326. {
  1327. Thread.Sleep(5000);
  1328. }
  1329. }
  1330. }
  1331. public void dosomething42(string date)
  1332. {
  1333. WebCMSEntities db = new WebCMSEntities();
  1334. DateTime yesterday = DateTime.Parse(date + " 00:00:00");
  1335. DateTime today = DateTime.Parse(DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00");
  1336. List<PosMerchantInfo> merList = db.PosMerchantInfo.Where(m => m.ActiveStatus == 1 && m.MerStandardDate >= yesterday && m.MerStandardDate < today && !string.IsNullOrEmpty(m.SeoKeyword) && m.SeoKeyword != "0").ToList();
  1337. foreach (PosMerchantInfo merchant in merList)
  1338. {
  1339. MachineForMerNo forMerNo = db.MachineForMerNo.FirstOrDefault(m => m.MerNo == merchant.MerchantNo) ?? new MachineForMerNo();
  1340. PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == forMerNo.SnId) ?? new PosMachinesTwo();
  1341. if (pos.ActivationTime > DateTime.Now.AddDays(-20) && pos.CreditTrade >= 1000)
  1342. {
  1343. decimal ActPrize = decimal.Parse(function.CheckNum(merchant.SeoKeyword));
  1344. if (ActPrize > 0)
  1345. {
  1346. // PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId && !string.IsNullOrEmpty(m.MerIdcardNo));
  1347. // PosMerchantOtherInfo otherInfo = db.PosMerchantOtherInfo.FirstOrDefault(m => m.CertId == merchant.MerIdcardNo && m.PrizeFlag2 == 0);
  1348. // if (otherInfo != null)
  1349. // {
  1350. // otherInfo.PrizeFlag2 = 1;
  1351. // db.SaveChanges();
  1352. // 从机具所属人上级开始分开机奖励
  1353. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  1354. if (user != null)
  1355. {
  1356. if (!string.IsNullOrEmpty(user.ParentNav))
  1357. {
  1358. decimal Prize = 20;
  1359. string[] ParentNavs = user.ParentNav.Trim(',').Replace(",,", ",").Split(',');
  1360. for (int i = ParentNavs.Length - 1; i >= 0; i--)
  1361. {
  1362. int UserId = int.Parse(ParentNavs[i]);
  1363. Users puser = db.Users.FirstOrDefault(m => m.Id == UserId && m.AuthFlag == 1);
  1364. if (puser != null && Prize > 0)
  1365. {
  1366. int machineCount = db.PosMachinesTwo.Count(m => m.BuyUserId == puser.Id && m.PosSnType == 0 && m.ActivationState == 0); //判断是否拥有3台兑换机
  1367. int ActiveCount = db.PosMachinesTwo.Count(m => m.BuyUserId == puser.Id && m.ActivationState == 1); //判断是否拥有3台激活机(不限购买或赠送)
  1368. int couponCount = db.PosCoupons.Count(m => m.UserId == puser.Id && m.IsUse == 0); //判断是否拥有3张券
  1369. // int BigCount = db.PosMachinesTwo.Count(m => m.UserId == puser.Id && m.BrandId == 3); //判断是否拥有2台大机
  1370. // int BigActiveCount = db.PosMachinesTwo.Count(m => m.UserId == puser.Id && m.ActivationState == 1 && m.BrandId == 3); //判断是否拥有2台激活大机(不限购买或赠送)
  1371. if (machineCount + ActiveCount + couponCount >= 3)
  1372. {
  1373. int pTopUserId = 0;
  1374. if (!string.IsNullOrEmpty(puser.ParentNav))
  1375. {
  1376. pTopUserId = int.Parse(puser.ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  1377. }
  1378. Users machineUser = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new Users();
  1379. OpenRewardDetail detail = db.OpenRewardDetail.Add(new OpenRewardDetail()
  1380. {
  1381. CreateDate = DateTime.Now,
  1382. UpdateDate = DateTime.Now,
  1383. TradeMonth = yesterday.ToString("yyyyMM"), //交易月
  1384. TradeDate = yesterday, //达标日期
  1385. UserId = puser.Id, //创客
  1386. BrandId = pos.BrandId, //品牌
  1387. ProductName = RelationClass.GetKqProductsInfo(pos.BrandId), //产品名称
  1388. MerchantId = pos.BindMerchantId, //商户
  1389. DirectUserId = merchant.UserId, //商户直属人
  1390. SnNo = pos.PosSn, //SN号
  1391. MerNo = merchant.KqMerNo, //渠道商户号
  1392. SnType = pos.PosSnType, //机具类型
  1393. StandardDate = pos.ActivationTime, //商户的激活日期
  1394. SnStoreId = pos.StoreId, //SN仓库
  1395. MerBuddyType = puser.MerchantType, //商户创客类型
  1396. RewardType = 1, //奖励类型 1-开机直接奖励,2-开机间接奖励
  1397. RewardTips = "开机奖励", //奖励描述
  1398. CreditTradeAmt = pos.CreditTrade, //贷记卡交易总金额
  1399. DebitTradeAmt = pos.DebitCardTrade, //借记卡交易总金额
  1400. CreditRewardAmount = Prize, //贷记卡交易奖励金额
  1401. RewardDesc = "开机奖励", //奖励描述
  1402. TopUserId = pTopUserId, //顶级创客
  1403. SeoTitle = machineUser.RealName,
  1404. }).Entity;
  1405. db.OpenReward.Add(new OpenReward()
  1406. {
  1407. CreateDate = DateTime.Now,
  1408. UpdateDate = DateTime.Now,
  1409. TradeMonth = yesterday.ToString("yyyyMM"), //交易月
  1410. TradeDate = DateTime.Now, //达标日期
  1411. UserId = puser.Id, //创客
  1412. BrandId = pos.BrandId, //品牌
  1413. RewardType = 2, //奖励类型
  1414. CreditTradeAmt = pos.CreditTrade, //贷记卡交易总金额
  1415. DebitTradeAmt = pos.DebitCardTrade, //借记卡交易总金额
  1416. CreditRewardAmount = Prize, //贷记卡交易奖励金额
  1417. RewardDesc = "开机奖励", //奖励描述
  1418. TopUserId = pTopUserId, //顶级创客
  1419. });
  1420. string IdBrand = puser.Id + "_" + pos.BrandId;
  1421. UserMachineData userData = db.UserMachineData.FirstOrDefault(m => m.IdBrand == IdBrand);
  1422. if (userData == null)
  1423. {
  1424. userData = db.UserMachineData.Add(new UserMachineData()
  1425. {
  1426. IdBrand = IdBrand,
  1427. }).Entity;
  1428. db.SaveChanges();
  1429. }
  1430. userData.OpenProfit += Prize;
  1431. db.SaveChanges();
  1432. //账户入库
  1433. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == puser.Id);
  1434. if (account == null)
  1435. {
  1436. account = db.UserAccount.Add(new UserAccount()
  1437. {
  1438. Id = puser.Id,
  1439. UserId = puser.Id,
  1440. }).Entity;
  1441. db.SaveChanges();
  1442. }
  1443. //收支明细入库
  1444. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  1445. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  1446. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  1447. account.BalanceAmount += Prize;
  1448. account.TotalAmount += Prize;
  1449. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  1450. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  1451. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  1452. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  1453. {
  1454. CreateDate = DateTime.Now,
  1455. UpdateDate = DateTime.Now,
  1456. UserId = puser.Id, //创客
  1457. ChangeType = 50, //变动类型
  1458. ProductType = pos.BrandId, //产品类型
  1459. ChangeAmount = Prize, //变更金额
  1460. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  1461. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  1462. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  1463. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  1464. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  1465. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  1466. }).Entity;
  1467. db.SaveChanges();
  1468. string dateString = yesterday.ToString("yyyyMMdd");
  1469. string monthString = yesterday.ToString("yyyyMM");
  1470. // 开机奖励列表
  1471. List<string> dates = RedisDbconn.Instance.GetList<string>("OpenRewardDay:" + puser.Id + ":" + pos.BrandId);
  1472. if (!dates.Contains(dateString))
  1473. {
  1474. RedisDbconn.Instance.AddList("OpenRewardDay:" + puser.Id + ":" + pos.BrandId, dateString);
  1475. }
  1476. RedisDbconn.Instance.AddNumber("OpenRewardAmt:" + puser.Id + ":" + pos.BrandId + ":" + dateString, Prize);
  1477. List<string> months = RedisDbconn.Instance.GetList<string>("OpenRewardMonth:" + puser.Id + ":" + pos.BrandId);
  1478. if (!months.Contains(monthString))
  1479. {
  1480. RedisDbconn.Instance.AddList("OpenRewardMonth:" + puser.Id + ":" + pos.BrandId, monthString);
  1481. }
  1482. RedisDbconn.Instance.AddNumber("OpenRewardAmt:" + puser.Id + ":" + pos.BrandId + ":" + monthString, Prize);
  1483. // 开机奖励详情
  1484. RedisDbconn.Instance.AddList("OpenRewardDetail:" + puser.Id + ":" + pos.BrandId + ":" + dateString, detail);
  1485. Prize -= 10;
  1486. }
  1487. }
  1488. }
  1489. }
  1490. }
  1491. // }
  1492. }
  1493. }
  1494. }
  1495. db.Dispose();
  1496. }
  1497. // 4. 前一天的流量卡记录和匹配
  1498. public void ListenFluxRecord()
  1499. {
  1500. Thread th = new Thread(ListenFluxRecordD0);
  1501. th.IsBackground = true;
  1502. th.Start();
  1503. }
  1504. public void ListenFluxRecordD0()
  1505. {
  1506. while(true)
  1507. {
  1508. if(DateTime.Now.Hour > 0)
  1509. {
  1510. CheckFluxForTrade();
  1511. }
  1512. Thread.Sleep(600000);
  1513. }
  1514. }
  1515. public void doFluxRecord()
  1516. {
  1517. function.WriteLog(DateTime.Now.ToString(), "执行流量费返佣");
  1518. SpModels.WebCMSEntities spdb = new SpModels.WebCMSEntities();
  1519. WebCMSEntities db = new WebCMSEntities();
  1520. DateTime start = DateTime.Now.AddDays(-20);
  1521. List<SpModels.TradeFluxRecord> trades = spdb.TradeFluxRecord.Where(m => m.CreateDate >= start && m.Status == 1).ToList();
  1522. foreach (SpModels.TradeFluxRecord trade in trades)
  1523. {
  1524. try
  1525. {
  1526. string OrderNo = trade.TradeSerialNo; //单号
  1527. DateTime TradeDate = trade.CreateDate.Value;
  1528. string TradeMonth = TradeDate.ToString("yyyyMM");
  1529. decimal FeeAmount = trade.FeeAmount; //流量费
  1530. int BrandId = int.Parse(trade.ProductType);
  1531. KqProducts brand = db.KqProducts.FirstOrDefault(m => m.Id == BrandId) ?? new KqProducts();
  1532. if (brand.NoticeMoneyUnit == 2)
  1533. {
  1534. FeeAmount = FeeAmount / 100;
  1535. }
  1536. string TradeSnNo = trade.TradeSnNo; //机具SN
  1537. decimal FluxProfit = 0;
  1538. if (trade.ProductType == "1" && FeeAmount == 60)
  1539. {
  1540. FluxProfit = 24;
  1541. }
  1542. else if (trade.ProductType == "7" && FeeAmount == 46)
  1543. {
  1544. FluxProfit = 10;
  1545. }
  1546. else if (trade.ProductType != "1" && FeeAmount == 48)
  1547. {
  1548. FluxProfit = 12;
  1549. }
  1550. else if (trade.ProductType != "1" && FeeAmount == 60)
  1551. {
  1552. FluxProfit = 24;
  1553. }
  1554. if (FluxProfit > 0)
  1555. {
  1556. MachineForSnNo forSnNo = db.MachineForSnNo.FirstOrDefault(m => m.SnNo == TradeSnNo) ?? new MachineForSnNo();
  1557. PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == forSnNo.SnId) ?? new PosMachinesTwo();
  1558. // PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId && m.Sort == 1);
  1559. PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  1560. if (merchant != null && pos.BrandId != 6)
  1561. {
  1562. bool checkExist = db.FluxProfitDetail.Any(m => m.MerNo == merchant.KqMerNo);
  1563. if (!checkExist && decimal.Parse(function.CheckNum(pos.SeoKeyword)) > 0)
  1564. {
  1565. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new Users();
  1566. int GetUserId = user.Id;
  1567. int TopUserId = 0;
  1568. string ParentNav = user.ParentNav;
  1569. if (!string.IsNullOrEmpty(ParentNav))
  1570. {
  1571. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  1572. if (ParentNavList.Length > 1)
  1573. {
  1574. TopUserId = int.Parse(ParentNavList[1]);
  1575. }
  1576. else if (ParentNavList.Length == 1)
  1577. {
  1578. TopUserId = int.Parse(ParentNavList[0]);
  1579. }
  1580. }
  1581. FluxProfitSummary fluxProfit = db.FluxProfitSummary.FirstOrDefault(m => m.UserId == GetUserId && m.BrandId == pos.BrandId && m.TradeMonth == TradeMonth);
  1582. if (fluxProfit == null)
  1583. {
  1584. fluxProfit = db.FluxProfitSummary.Add(new FluxProfitSummary()
  1585. {
  1586. CreateDate = DateTime.Now,
  1587. UpdateDate = DateTime.Now,
  1588. UserId = GetUserId, //创客
  1589. BrandId = pos.BrandId,
  1590. TopUserId = TopUserId, //顶级创客
  1591. TradeMonth = TradeMonth, //交易月
  1592. MerUserType = user.MerchantType, //商户创客类型
  1593. Remark = "流量卡分佣", //备注
  1594. }).Entity;
  1595. db.SaveChanges();
  1596. }
  1597. fluxProfit.FluxProfitAmt += FluxProfit; //流量分润总金额
  1598. db.FluxProfitDetail.Add(new FluxProfitDetail()
  1599. {
  1600. CreateDate = DateTime.Now,
  1601. UpdateDate = DateTime.Now,
  1602. RecordNo = OrderNo, //单号
  1603. TradeDate = TradeDate.ToString("yyyyMMdd"), //交易日期
  1604. TradeTime = TradeDate.ToString("HHmmss"), //交易时间
  1605. TradeMonth = TradeMonth, //交易月
  1606. UserId = GetUserId, //创客
  1607. MerchantId = pos.BindMerchantId, //商户
  1608. MerchantUserId = pos.UserId, //商户直属人
  1609. MerNo = merchant.KqMerNo, //渠道商户编号
  1610. SnNo = pos.PosSn, //渠道SN号
  1611. FluxOrderNo = OrderNo, //流量扣费单号
  1612. TradeOrderNo = OrderNo, //交易流水号
  1613. TradeAmt = trade.TradeAmount, //商户交易额
  1614. FluxFeeAmt = FeeAmount, //流量费
  1615. FluxProfitAmt = FluxProfit, //流量分润总金额
  1616. PosType = pos.PosSnType.ToString(), //POS类型
  1617. Remark = "流量卡分佣", //备注
  1618. BrandId = pos.BrandId, //品牌
  1619. TopUserId = TopUserId, //顶级创客
  1620. MerUserType = user.MerchantType, //商户创客类型
  1621. });
  1622. string IdBrand = user.Id + "_" + pos.BrandId;
  1623. UserMachineData userData = db.UserMachineData.FirstOrDefault(m => m.IdBrand == IdBrand);
  1624. if (userData == null)
  1625. {
  1626. userData = db.UserMachineData.Add(new UserMachineData()
  1627. {
  1628. IdBrand = IdBrand,
  1629. }).Entity;
  1630. db.SaveChanges();
  1631. }
  1632. userData.FluxProfit += FluxProfit;
  1633. db.SaveChanges();
  1634. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == GetUserId);
  1635. if (account == null)
  1636. {
  1637. account = db.UserAccount.Add(new UserAccount()
  1638. {
  1639. Id = GetUserId,
  1640. UserId = GetUserId,
  1641. }).Entity;
  1642. db.SaveChanges();
  1643. }
  1644. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  1645. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  1646. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  1647. account.BalanceAmount += FluxProfit;
  1648. account.TotalAmount += FluxProfit;
  1649. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  1650. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  1651. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  1652. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  1653. {
  1654. CreateDate = DateTime.Now,
  1655. UpdateDate = DateTime.Now,
  1656. UserId = GetUserId, //创客
  1657. ChangeType = 60, //变动类型
  1658. ProductType = pos.BrandId, //产品类型
  1659. ChangeAmount = FluxProfit, //变更金额
  1660. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  1661. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  1662. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  1663. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  1664. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  1665. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  1666. }).Entity;
  1667. db.SaveChanges();
  1668. }
  1669. SpModels.TradeFluxRecord edit = spdb.TradeFluxRecord.FirstOrDefault(m => m.Id == trade.Id);
  1670. if (edit != null)
  1671. {
  1672. edit.Status = 2;
  1673. spdb.SaveChanges();
  1674. }
  1675. }
  1676. }
  1677. }
  1678. catch (Exception ex)
  1679. {
  1680. function.WriteLog(DateTime.Now.ToString() + "\n$" + trade.Id + "$\n" + ex.ToString(), "流量卡分佣异常");
  1681. }
  1682. }
  1683. spdb.Dispose();
  1684. db.Dispose();
  1685. function.WriteLog(DateTime.Now.ToString() + "\n", "执行流量费返佣");
  1686. }
  1687. public void CheckFluxForTrade()
  1688. {
  1689. function.WriteLog(DateTime.Now.ToString(), "扫描交易记录中的流量费");
  1690. SpModels.WebCMSEntities spdb = new SpModels.WebCMSEntities();
  1691. DateTime start = DateTime.Now.AddDays(-120);
  1692. int StartId = int.Parse(function.CheckInt(function.ReadInstance("/SycnSp/TradeRecordId.txt")));
  1693. List<string> BrandIds = new List<string>();
  1694. BrandIds.Add("1");
  1695. BrandIds.Add("10");
  1696. BrandIds.Add("12");
  1697. var list = spdb.TradeRecord.Select(m => new { m.Id, m.CreateDate, m.ProductType, m.Status }).Where(m => m.Id >= StartId && m.Status == 2 && m.CreateDate > start && BrandIds.Contains(m.ProductType)).OrderBy(m => m.CreateDate);
  1698. foreach (var sub in list.ToList())
  1699. {
  1700. try
  1701. {
  1702. SpModels.TradeRecord trade = spdb.TradeRecord.FirstOrDefault(m => m.Id == sub.Id);
  1703. if (trade != null)
  1704. {
  1705. if(trade.ProductType == "1") //金控
  1706. {
  1707. string content = trade.SeoDescription;
  1708. if (!string.IsNullOrEmpty(content))
  1709. {
  1710. content = System.Web.HttpUtility.UrlDecode(content);
  1711. JsonData jsonObj = JsonMapper.ToObject(content);
  1712. decimal terminalDataFlowFee = decimal.Parse(function.CheckNum(jsonObj["terminalDataFlowFee"].ToString()));
  1713. if (terminalDataFlowFee > 0)
  1714. {
  1715. spdb.TradeFluxRecord.Add(new SpModels.TradeFluxRecord()
  1716. {
  1717. SeoDescription = trade.TradeSerialNo,
  1718. FeeAmount = terminalDataFlowFee,
  1719. TradeSerialNo = function.MD5_16(trade.TradeSerialNo),
  1720. CreateDate = trade.CreateDate,
  1721. TradeSnNo = trade.TradeSnNo,
  1722. ProductType = trade.ProductType,
  1723. Status = 1,
  1724. });
  1725. spdb.SaveChanges();
  1726. }
  1727. }
  1728. }
  1729. else if(trade.ProductType == "10" || trade.ProductType == "12") //10联动、12盒易付
  1730. {
  1731. if (trade.DigAmt > 0)
  1732. {
  1733. spdb.TradeFluxRecord.Add(new SpModels.TradeFluxRecord()
  1734. {
  1735. SeoDescription = trade.TradeSerialNo,
  1736. FeeAmount = trade.DigAmt,
  1737. TradeSerialNo = function.MD5_16(trade.TradeSerialNo),
  1738. CreateDate = trade.CreateDate,
  1739. TradeSnNo = trade.TradeSnNo,
  1740. ProductType = trade.ProductType,
  1741. Status = 1,
  1742. });
  1743. spdb.SaveChanges();
  1744. }
  1745. }
  1746. trade.Status = 3;
  1747. spdb.SaveChanges();
  1748. }
  1749. }
  1750. catch (Exception ex)
  1751. {
  1752. function.WriteLog(DateTime.Now.ToString() + "\n$" + sub.Id + "$\n" + ex.ToString(), "扫描交易记录中的流量费异常");
  1753. }
  1754. }
  1755. spdb.Dispose();
  1756. function.WriteLog(DateTime.Now.ToString() + "\n", "扫描交易记录中的流量费");
  1757. // doFluxRecord();
  1758. }
  1759. // 每天统计头一天的交易额
  1760. public void StartEverDay(string date)
  1761. {
  1762. string TradeMonth = DateTime.Now.ToString("yyyyMM");
  1763. if(DateTime.Now.Day == 1)
  1764. {
  1765. TradeMonth = DateTime.Now.AddMonths(-1).ToString("yyyyMM");
  1766. }
  1767. else if(DateTime.Now.Day == 2)
  1768. {
  1769. CustomerSqlConn.op("update Users set ThisMonthTrade=0 where ThisMonthTrade>0", MysqlConn.SqlConnStr);
  1770. }
  1771. Dictionary<string, decimal> dic = new Dictionary<string, decimal>();
  1772. DataTable list = CustomerSqlConn.dtable("select UserId,sum(HelpNonDirectTradeAmt+HelpNonDirectDebitTradeAmt+NotHelpNonDirectTradeAmt+NotHelpNonDirectDebitTradeAmt+ProfitNonDirectTradeAmt+ProfitNonDirectDebitTradeAmt) from TradeDaySummary where Id>=15055757 and TradeMonth='" + TradeMonth + "' and SeoTitle='team' and UserId>0 group by UserId", MysqlConn.ReadSqlConnStr);
  1773. foreach (DataRow dr in list.Rows)
  1774. {
  1775. string UserId = dr["UserId"].ToString();
  1776. string ThisMonthTrade = dr[1].ToString();
  1777. dic.Add(UserId, decimal.Parse(function.CheckNum(ThisMonthTrade)));
  1778. }
  1779. list = CustomerSqlConn.dtable("select UserId,sum(ProfitTradeAmt+ProfitDebitTradeAmt) from TradeDaySummary2 where TradeMonth='" + TradeMonth + "' and SeoTitle='team' and UserId>0 group by UserId", MysqlConn.ReadSqlConnStr);
  1780. foreach (DataRow dr in list.Rows)
  1781. {
  1782. string UserId = dr["UserId"].ToString();
  1783. string ThisMonthTrade = dr[1].ToString();
  1784. if(dic.ContainsKey(UserId))
  1785. {
  1786. dic[UserId] += decimal.Parse(function.CheckNum(ThisMonthTrade));
  1787. }
  1788. else
  1789. {
  1790. dic.Add(UserId, decimal.Parse(function.CheckNum(ThisMonthTrade)));
  1791. }
  1792. }
  1793. int index = 0;
  1794. string sql = "";
  1795. foreach(string UserId in dic.Keys)
  1796. {
  1797. index += 1;
  1798. sql += "update Users set ThisMonthTrade=" + dic[UserId] + " where Id=" + UserId + ";";
  1799. if(index >= 200)
  1800. {
  1801. CustomerSqlConn.op(sql, MysqlConn.SqlConnStr);
  1802. sql = "";
  1803. index = 0;
  1804. }
  1805. }
  1806. if(!string.IsNullOrEmpty(sql))
  1807. {
  1808. CustomerSqlConn.op(sql, MysqlConn.SqlConnStr);
  1809. }
  1810. // Thread th = new Thread(StatTradeAmountEverDay);
  1811. // th.IsBackground = true;
  1812. // th.Start(date);
  1813. }
  1814. public void StatTradeAmountEverDay(object sender)
  1815. {
  1816. string date = sender.ToString();
  1817. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), "执行昨天交易额日志");
  1818. WebCMSEntities db = new WebCMSEntities();
  1819. try
  1820. {
  1821. string TradeDate = date.Replace("-", "");
  1822. string TradeMonth = TradeDate.Substring(0, 6);
  1823. string start = date + " 00:00:00";
  1824. string end = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  1825. string startId = "0", endId = "9999999999";
  1826. List<string> uids = new List<string>();
  1827. DataTable startDt = OtherMySqlConn.dtable("select min(Id) from TradeRecord where CreateDate>='" + start + "'");
  1828. if (startDt.Rows.Count > 0)
  1829. {
  1830. startId = startDt.Rows[0][0].ToString();
  1831. }
  1832. function.WriteLog(startId + "\n\n", "执行昨天交易额日志");
  1833. // DataTable endDt = OtherMySqlConn.dtable("select max(Id) from TradeRecord where CreateDate<'" + end + "'");
  1834. // if (endDt.Rows.Count > 0)
  1835. // {
  1836. // endId = endDt.Rows[0][0].ToString();
  1837. // }
  1838. DataTable userDt = OtherMySqlConn.dtable("select Id,ParentNav from Users where Id in (select DISTINCT UserId from TradeRecord where Id>=" + startId + " and Id<=" + endId + " and CreateDate>='" + start + "' and CreateDate<'" + end + "')");
  1839. function.WriteLog("交易人数:" + userDt.Rows.Count + "\n\n", "执行昨天交易额日志");
  1840. foreach (DataRow userDr in userDt.Rows)
  1841. {
  1842. int UserId = int.Parse(userDr["Id"].ToString());
  1843. string ParentNav = userDr["ParentNav"].ToString();
  1844. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天交易额日志");
  1845. DataTable selfdt = OtherMySqlConn.dtable("select BrandId,BankCardType,QrPayFlag,sum(TradeAmount) from TradeRecord where Id>=" + startId + " and Id<=" + endId + " and CreateDate>='" + start + "' and CreateDate<'" + end + "' and UserId=" + UserId + " group by BrandId,BankCardType,QrPayFlag");
  1846. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天交易额日志");
  1847. foreach (DataRow selfDr in selfdt.Rows)
  1848. {
  1849. int BrandId = int.Parse(selfDr["BrandId"].ToString());
  1850. int BankCardType = int.Parse(selfDr["BankCardType"].ToString());
  1851. int QrPayFlag = int.Parse(selfDr["QrPayFlag"].ToString());
  1852. decimal TradeAmount = decimal.Parse(selfDr[3].ToString());
  1853. UserTradeDaySummary selfStat = db.UserTradeDaySummary.FirstOrDefault(m => m.UserId == UserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.BrandId == BrandId && m.QueryCount == QrPayFlag && m.SeoTitle == "self");
  1854. if (selfStat == null)
  1855. {
  1856. selfStat = db.UserTradeDaySummary.Add(new UserTradeDaySummary()
  1857. {
  1858. UserId = UserId,
  1859. TradeMonth = TradeMonth,
  1860. TradeDate = TradeDate,
  1861. BrandId = BrandId,
  1862. QueryCount = QrPayFlag,
  1863. SeoTitle = "self",
  1864. }).Entity;
  1865. db.SaveChanges();
  1866. }
  1867. if (BankCardType == 0)
  1868. {
  1869. selfStat.DirectDebitTradeAmt += TradeAmount;
  1870. }
  1871. else if (BankCardType != 0)
  1872. {
  1873. selfStat.DirectTradeAmt += TradeAmount;
  1874. }
  1875. db.SaveChanges();
  1876. }
  1877. if (!string.IsNullOrEmpty(ParentNav))
  1878. {
  1879. ParentNav += "," + UserId + ",";
  1880. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  1881. foreach (string NavUserIdString in ParentNavList)
  1882. {
  1883. if (!uids.Contains(NavUserIdString + start))
  1884. {
  1885. uids.Add(NavUserIdString + start);
  1886. int NavUserId = int.Parse(NavUserIdString);
  1887. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天交易额日志");
  1888. DataTable teamDt = OtherMySqlConn.dtable("select BrandId,BankCardType,QrPayFlag,sum(TradeAmount) from TradeRecord where Id>=" + startId + " and Id<=" + endId + " and CreateDate>='" + start + "' and CreateDate<'" + end + "' and UserId in (select Id from Users where ParentNav like '%," + NavUserId + ",%' or Id=" + NavUserId + ") group by BrandId,BankCardType,QrPayFlag");
  1889. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天交易额日志");
  1890. foreach (DataRow teamDr in teamDt.Rows)
  1891. {
  1892. int BrandId = int.Parse(teamDr["BrandId"].ToString());
  1893. int BankCardType = int.Parse(teamDr["BankCardType"].ToString());
  1894. int QrPayFlag = int.Parse(teamDr["QrPayFlag"].ToString());
  1895. decimal TradeAmount = decimal.Parse(teamDr[3].ToString());
  1896. UserTradeDaySummary teamStat = db.UserTradeDaySummary.FirstOrDefault(m => m.UserId == NavUserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.BrandId == BrandId && m.QueryCount == QrPayFlag && m.SeoTitle == "team");
  1897. if (teamStat == null)
  1898. {
  1899. teamStat = db.UserTradeDaySummary.Add(new UserTradeDaySummary()
  1900. {
  1901. UserId = NavUserId,
  1902. TradeMonth = TradeMonth,
  1903. TradeDate = TradeDate,
  1904. BrandId = BrandId,
  1905. QueryCount = QrPayFlag,
  1906. SeoTitle = "team",
  1907. }).Entity;
  1908. db.SaveChanges();
  1909. }
  1910. if (BankCardType == 0)
  1911. {
  1912. teamStat.NonDirectDebitTradeAmt += TradeAmount;
  1913. }
  1914. else if (BankCardType != 0)
  1915. {
  1916. teamStat.NonDirectTradeAmt += TradeAmount;
  1917. }
  1918. db.SaveChanges();
  1919. }
  1920. }
  1921. }
  1922. }
  1923. }
  1924. if (DateTime.Now.Day >= 2)
  1925. {
  1926. Thread.Sleep(5000);
  1927. DataTable list = OtherMySqlConn.dtable("select UserId,sum(NonDirectTradeAmt) from UserTradeDaySummary where TradeDate='" + TradeDate + "' GROUP BY UserId");
  1928. foreach (DataRow dr in list.Rows)
  1929. {
  1930. string UserId = dr["UserId"].ToString();
  1931. string ThisMonthTrade = dr[1].ToString();
  1932. OtherMySqlConn.op("update Users set ThisMonthTrade=ThisMonthTrade+" + ThisMonthTrade + " where Id=" + UserId);
  1933. }
  1934. }
  1935. }
  1936. catch (Exception ex)
  1937. {
  1938. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "统计昨天的交易额异常");
  1939. }
  1940. db.Dispose();
  1941. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天交易额日志");
  1942. StatMerchantTrade(date);
  1943. }
  1944. //统计商户交易额
  1945. private void StatMerchantTrade(string date)
  1946. {
  1947. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), "执行商户交易额日志");
  1948. try
  1949. {
  1950. string start = date + " 00:00:00";
  1951. string end = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  1952. CustomerSqlConn.op("insert into PosMerchantTradeSummay (MerchantId,BrandId,TradeDate,TradeMonth,TradeAmount,CreateDate) select *,now() from (select MerchantId,BrandId,DATE_FORMAT(CreateDate,'%Y%m%d') as TradeDate,DATE_FORMAT(CreateDate,'%Y%m') as TradeMonth,sum(TradeAmount) as TradeAmount from TradeRecord where Id>=13000000 and CreateDate>='" + start + "' and CreateDate<'" + end + "' and ActStatus=1 and BrandId!=14 group by MerchantId,BrandId,DATE_FORMAT(CreateDate,'%Y%m%d'),TradeDate,DATE_FORMAT(CreateDate,'%Y%m') order by MerchantId,BrandId,DATE_FORMAT(CreateDate,'%Y%m%d')) tb", MysqlConn.SqlConnStr);
  1953. }
  1954. catch (Exception ex)
  1955. {
  1956. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "统计商户的交易额");
  1957. }
  1958. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行商户交易额日志");
  1959. }
  1960. // 5. 创客升级
  1961. public void StatUserLevel()
  1962. {
  1963. Thread th = new Thread(StatUserLevelDo);
  1964. th.IsBackground = true;
  1965. th.Start();
  1966. }
  1967. public void StatUserLevelDo()
  1968. {
  1969. while (true)
  1970. {
  1971. if(DateTime.Now.Day < 15 && DateTime.Now.Hour >= 0)
  1972. {
  1973. string Month = DateTime.Now.AddDays(-1).ToString("yyyy-MM");
  1974. string flag = function.ReadInstance("/ProfitFlag/" + Month + ".txt");
  1975. if (string.IsNullOrEmpty(flag))
  1976. {
  1977. function.WritePage("/ProfitFlag/", Month + ".txt", DateTime.Now.ToString("HH:mm:ss"));
  1978. LogoutUserHelper.Instance.DoWorks(); //每月一号归档注销创客,把伞下创客归到注销创客的上级
  1979. StatUserLevelStartNew();
  1980. }
  1981. }
  1982. Thread.Sleep(600000);
  1983. }
  1984. }
  1985. public void StatUserLevelStart()
  1986. {
  1987. WebCMSEntities db = new WebCMSEntities();
  1988. MpMainModels.WebCMSEntities mpmaindb = new MpMainModels.WebCMSEntities();
  1989. try
  1990. {
  1991. OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["Pxc1SqlConnStr"].ToString();
  1992. function.WriteLog(DateTime.Now.ToString(), "创客升级日志");
  1993. DateTime start = DateTime.Parse(DateTime.Now.AddMonths(-1).ToString("yyyy-MM") + "-01 00:00:00");
  1994. DateTime end = start.AddDays(1);
  1995. string TradeMonth = DateTime.Now.AddMonths(-1).ToString("yyyyMM");
  1996. List<UserLevelSet> sets = db.UserLevelSet.ToList();
  1997. bool op = true;
  1998. int startid = 0;
  1999. while(op)
  2000. {
  2001. var users = db.Users.Select(m => new { m.Id, m.AuthFlag }).Where(m => m.Id > startid && m.AuthFlag == 1).OrderBy(m => m.Id).Take(500).ToList();
  2002. function.WriteLog(users.Count.ToString(), "创客升级日志");
  2003. if(users.Count > 0)
  2004. {
  2005. foreach (var subuser in users)
  2006. {
  2007. Users user = db.Users.FirstOrDefault(m => m.Id == subuser.Id);
  2008. if (user != null)
  2009. {
  2010. int BeforeLevel = user.UserLevel;
  2011. int AfterLevel = 0;
  2012. decimal TradeAmount = 0;
  2013. //创客团队交易额
  2014. bool check = db.TradeDaySummary.Any(m => m.UserId == user.Id && m.TradeMonth == TradeMonth && m.SeoTitle == "team");
  2015. if (check)
  2016. {
  2017. TradeAmount += db.TradeDaySummary.Where(m => m.UserId == user.Id && m.TradeMonth == TradeMonth && m.SeoTitle == "team").Sum(m => m.HelpNonDirectTradeAmt + m.HelpNonDirectDebitTradeAmt + m.NotHelpNonDirectTradeAmt + m.NotHelpNonDirectDebitTradeAmt + m.ProfitNonDirectTradeAmt + m.ProfitNonDirectDebitTradeAmt);
  2018. }
  2019. //助利宝团队交易额
  2020. DataTable checkdt = OtherMySqlConn.dtable("SELECT SUM(TradeAmount) TradeAmount FROM HelpProfitMerTradeSummay WHERE (MerchantId IN(SELECT MerchantId FROM HelpProfitMerIds WHERE UserId IN(SELECT Id from Users WHERE ParentNav like '%," + user.Id + ",%' OR Id=" + user.Id + "))) AND TradeMonth=" + TradeMonth + "");
  2021. if (checkdt.Rows.Count > 0)
  2022. {
  2023. TradeAmount += decimal.Parse(function.CheckNum(checkdt.Rows[0]["TradeAmount"].ToString()));
  2024. }
  2025. //码牌团队交易额
  2026. check = mpmaindb.UserAmountSummary.Any(m => m.UserId == user.Id && m.TradeMonth == TradeMonth && m.SeoTitle == "team");
  2027. if (check)
  2028. {
  2029. TradeAmount += mpmaindb.UserAmountSummary.Where(m => m.UserId == user.Id && m.TradeMonth == TradeMonth && m.SeoTitle == "team").Sum(m => m.TotalAmount);
  2030. }
  2031. UserLevelSet set = sets.FirstOrDefault(m => m.UpLevelGrowth <= TradeAmount && m.UpLevelIntegral > TradeAmount);
  2032. if (set != null)
  2033. {
  2034. AfterLevel = set.Id;
  2035. }
  2036. // K6以上计算小市场是否达标
  2037. // 升级逻辑
  2038. bool upFlag = true;
  2039. if(AfterLevel > 5)
  2040. {
  2041. DataTable dt = OtherMySqlConn.dtable("select UserId,sum(HelpNonDirectTradeAmt+NotHelpNonDirectTradeAmt+ProfitNonDirectTradeAmt+HelpNonDirectDebitTradeAmt+NotHelpNonDirectDebitTradeAmt+ProfitNonDirectDebitTradeAmt) from TradeDaySummary where UserId in (select Id from Users where ParentUserId=" + user.Id + ") and TradeMonth='" + TradeMonth + "' and SeoTitle='team' group by UserId order by sum(HelpNonDirectTradeAmt+NotHelpNonDirectTradeAmt+ProfitNonDirectTradeAmt+HelpNonDirectDebitTradeAmt+ProfitNonDirectDebitTradeAmt) desc");
  2042. int index = 0;
  2043. decimal TradeAmt = 0;
  2044. decimal BigTradeAmt = 0;
  2045. foreach(DataRow dr in dt.Rows)
  2046. {
  2047. index += 1;
  2048. if(index == 1)
  2049. {
  2050. BigTradeAmt = decimal.Parse(dr[1].ToString());
  2051. }
  2052. else if(index > 1)
  2053. {
  2054. TradeAmt += decimal.Parse(dr[1].ToString());
  2055. }
  2056. }
  2057. if(TradeAmt < 12000000 || BigTradeAmt < 30000000)
  2058. {
  2059. if(AfterLevel > BeforeLevel && BeforeLevel >= 5) //保级,只升不降
  2060. {
  2061. AfterLevel = BeforeLevel;
  2062. }
  2063. else if(AfterLevel > BeforeLevel && BeforeLevel < 5)
  2064. {
  2065. AfterLevel = 5;
  2066. }
  2067. else if(BeforeLevel > 5)
  2068. {
  2069. AfterLevel = 5;
  2070. }
  2071. else
  2072. {
  2073. upFlag = false;
  2074. }
  2075. }
  2076. }
  2077. if (AfterLevel > BeforeLevel && AfterLevel > 1 && upFlag)
  2078. {
  2079. function.WriteLog("升级:" + user.Id.ToString() + BeforeLevel + "->" + AfterLevel, "创客升级日志");
  2080. user.UserLevel = AfterLevel;
  2081. DateTime checkTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM") + "-01 00:00:00");
  2082. UserRank rank = db.UserRank.FirstOrDefault(m => m.CreateDate >= checkTime && m.UserId == user.Id);
  2083. if(rank == null)
  2084. {
  2085. db.UserRank.Add(new UserRank()
  2086. {
  2087. CreateDate = DateTime.Now,
  2088. UpdateDate = DateTime.Now,
  2089. UserId = user.Id, //创客
  2090. WhiteRank = BeforeLevel,
  2091. Rank = AfterLevel, //当前等级
  2092. StatYear = DateTime.Now.Year, //统计年份
  2093. StatMonth = DateTime.Now.Month, //统计月份
  2094. TradeAmt = TradeAmount, //团队交易总额
  2095. UpgradeFlag = 1, //升级标识
  2096. OperateDate = DateTime.Now, //操作时间
  2097. Status = 1,
  2098. });
  2099. db.SaveChanges();
  2100. }
  2101. else
  2102. {
  2103. rank.TradeAmt = TradeAmount;
  2104. rank.Rank = AfterLevel;
  2105. db.SaveChanges();
  2106. }
  2107. }
  2108. // 降级逻辑
  2109. if(!upFlag && AfterLevel > 5)
  2110. {
  2111. AfterLevel = 5;
  2112. }
  2113. if (AfterLevel < BeforeLevel && BeforeLevel > 1)
  2114. {
  2115. function.WriteLog(user.MakerCode + "-" + user.RealName + ":K" + BeforeLevel + "->K" + AfterLevel, "创客降级日志");
  2116. user.UserLevel = AfterLevel;
  2117. DateTime checkTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM") + "-01 00:00:00");
  2118. UserRank rank = db.UserRank.FirstOrDefault(m => m.CreateDate >= checkTime && m.UserId == user.Id);
  2119. if(rank == null)
  2120. {
  2121. db.UserRank.Add(new UserRank()
  2122. {
  2123. CreateDate = DateTime.Now,
  2124. UpdateDate = DateTime.Now,
  2125. UserId = user.Id, //创客
  2126. WhiteRank = BeforeLevel,
  2127. Rank = AfterLevel, //当前等级
  2128. StatYear = DateTime.Now.Year, //统计年份
  2129. StatMonth = DateTime.Now.Month, //统计月份
  2130. TradeAmt = TradeAmount, //团队交易总额
  2131. UpgradeFlag = 0, //升级标识
  2132. OperateDate = DateTime.Now, //操作时间
  2133. Status = 1,
  2134. });
  2135. db.SaveChanges();
  2136. }
  2137. else
  2138. {
  2139. rank.TradeAmt = TradeAmount;
  2140. rank.Rank = AfterLevel;
  2141. rank.Status = 1;
  2142. db.SaveChanges();
  2143. }
  2144. }
  2145. }
  2146. startid = subuser.Id;
  2147. }
  2148. function.WriteLog(startid.ToString(), "创客升级日志");
  2149. }
  2150. else
  2151. {
  2152. op = false;
  2153. }
  2154. }
  2155. function.WriteLog(DateTime.Now.ToString(), "创客升级日志");
  2156. }
  2157. catch (Exception ex)
  2158. {
  2159. function.WriteLog(ex.ToString(), "创客升级异常");
  2160. }
  2161. db.Dispose();
  2162. mpmaindb.Dispose();
  2163. RedisDbconn.Instance.AddList("DoTableEveryMonthQueue", "1");
  2164. }
  2165. public void StatUserLevelStartNew()
  2166. {
  2167. WebCMSEntities db = new WebCMSEntities();
  2168. MpMainModels.WebCMSEntities mpmaindb = new MpMainModels.WebCMSEntities();
  2169. MpMainModels2.WebCMSEntities mpmaindb2 = new MpMainModels2.WebCMSEntities();
  2170. try
  2171. {
  2172. OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["Pxc1SqlConnStr"].ToString();
  2173. function.WriteLog(DateTime.Now.ToString(), "创客升级日志");
  2174. DateTime start = DateTime.Parse(DateTime.Now.AddMonths(-1).ToString("yyyy-MM") + "-01 00:00:00");
  2175. DateTime end = start.AddDays(1);
  2176. string TradeMonth = DateTime.Now.AddMonths(-1).ToString("yyyyMM");
  2177. List<UserLevelSet> sets = db.UserLevelSet.ToList();
  2178. bool op = true;
  2179. int startid = 138681;
  2180. while(op)
  2181. {
  2182. var users = db.Users.Select(m => new { m.Id, m.AuthFlag }).Where(m => m.Id > startid && m.AuthFlag == 1).OrderBy(m => m.Id).Take(500).ToList();
  2183. function.WriteLog(users.Count.ToString(), "创客升级日志");
  2184. if(users.Count > 0)
  2185. {
  2186. foreach (var subuser in users)
  2187. {
  2188. Users user = db.Users.FirstOrDefault(m => m.Id == subuser.Id);
  2189. if (user != null)
  2190. {
  2191. int BeforeLevel = user.UserLevel;
  2192. int AfterLevel = 0;
  2193. decimal TradeAmount = 0;
  2194. //创客团队交易额
  2195. bool check = db.TradeDaySummary.Any(m => m.UserId == user.Id && m.TradeMonth == TradeMonth && m.SeoTitle == "team");
  2196. if (check)
  2197. {
  2198. TradeAmount += db.TradeDaySummary.Where(m => m.UserId == user.Id && m.TradeMonth == TradeMonth && m.SeoTitle == "team").Sum(m => m.HelpNonDirectTradeAmt + m.HelpNonDirectDebitTradeAmt + m.NotHelpNonDirectTradeAmt + m.NotHelpNonDirectDebitTradeAmt + m.ProfitNonDirectTradeAmt + m.ProfitNonDirectDebitTradeAmt);
  2199. }
  2200. //助利宝团队交易额
  2201. DataTable checkdt = OtherMySqlConn.dtable("SELECT SUM(TradeAmount) TradeAmount FROM HelpProfitMerTradeSummay WHERE (MerchantId IN(SELECT MerchantId FROM HelpProfitMerIds WHERE UserId IN(SELECT Id from Users WHERE ParentNav like '%," + user.Id + ",%' OR Id=" + user.Id + "))) AND TradeMonth=" + TradeMonth + "");
  2202. if (checkdt.Rows.Count > 0)
  2203. {
  2204. TradeAmount += decimal.Parse(function.CheckNum(checkdt.Rows[0]["TradeAmount"].ToString()));
  2205. }
  2206. //码牌团队交易额(直联)
  2207. check = mpmaindb.UserAmountSummary.Any(m => m.UserId == user.Id && m.TradeMonth == TradeMonth && m.SeoTitle == "team");
  2208. if (check)
  2209. {
  2210. TradeAmount += mpmaindb.UserAmountSummary.Where(m => m.UserId == user.Id && m.TradeMonth == TradeMonth && m.SeoTitle == "team" && m.IsAct == 1).Sum(m => m.TotalAmount) * 4;
  2211. }
  2212. //码牌团队交易额(银联)
  2213. check = mpmaindb2.UserAmountSummary.Any(m => m.UserId == user.Id && m.TradeMonth == TradeMonth && m.SeoTitle == "team");
  2214. if (check)
  2215. {
  2216. TradeAmount += mpmaindb2.UserAmountSummary.Where(m => m.UserId == user.Id && m.TradeMonth == TradeMonth && m.SeoTitle == "team" && m.IsAct == 1).Sum(m => m.TotalAmount) * 4;
  2217. }
  2218. //广电卡扶持期按1万/张计入职级
  2219. check = db.UserTradeMonthSummary.Any(m => m.UserId == user.Id && m.TradeMonth == TradeMonth && m.SeoTitle == "team" && m.BrandId == 14);
  2220. if (check)
  2221. {
  2222. TradeAmount += db.UserTradeMonthSummary.Where(m => m.UserId == user.Id && m.TradeMonth == TradeMonth && m.SeoTitle == "team" && m.BrandId == 14).Sum(m => m.ActiveBuddyMerStatus) * 10000;
  2223. }
  2224. UserLevelSet set = sets.FirstOrDefault(m => m.UpLevelGrowth <= TradeAmount && m.UpLevelIntegral > TradeAmount);
  2225. if (set != null)
  2226. {
  2227. AfterLevel = set.Id;
  2228. }
  2229. // K6以上计算小市场是否达标
  2230. // 升级逻辑
  2231. bool upFlag = true;
  2232. if(AfterLevel > 5)
  2233. {
  2234. DataTable dt = OtherMySqlConn.dtable("select UserId,sum(HelpNonDirectTradeAmt+NotHelpNonDirectTradeAmt+ProfitNonDirectTradeAmt+HelpNonDirectDebitTradeAmt+NotHelpNonDirectDebitTradeAmt+ProfitNonDirectDebitTradeAmt) from TradeDaySummary where UserId in (select Id from Users where ParentUserId=" + user.Id + ") and TradeMonth='" + TradeMonth + "' and SeoTitle='team' group by UserId order by sum(HelpNonDirectTradeAmt+NotHelpNonDirectTradeAmt+ProfitNonDirectTradeAmt+HelpNonDirectDebitTradeAmt+ProfitNonDirectDebitTradeAmt) desc");
  2235. int index = 0;
  2236. decimal TradeAmt = 0;
  2237. decimal BigTradeAmt = 0;
  2238. foreach(DataRow dr in dt.Rows)
  2239. {
  2240. index += 1;
  2241. if(index == 1)
  2242. {
  2243. BigTradeAmt = decimal.Parse(dr[1].ToString());
  2244. }
  2245. else if(index > 1)
  2246. {
  2247. TradeAmt += decimal.Parse(dr[1].ToString());
  2248. }
  2249. }
  2250. if(TradeAmt < 12000000 || BigTradeAmt < 30000000)
  2251. {
  2252. if(AfterLevel > BeforeLevel && BeforeLevel >= 5) //保级,只升不降
  2253. {
  2254. AfterLevel = BeforeLevel;
  2255. }
  2256. else if(AfterLevel > BeforeLevel && BeforeLevel < 5)
  2257. {
  2258. AfterLevel = 5;
  2259. }
  2260. else if(BeforeLevel > 5)
  2261. {
  2262. AfterLevel = 5;
  2263. }
  2264. else
  2265. {
  2266. upFlag = false;
  2267. }
  2268. }
  2269. }
  2270. if (AfterLevel > BeforeLevel && AfterLevel > 0 && upFlag)
  2271. {
  2272. function.WriteLog("升级:" + user.Id.ToString() + BeforeLevel + "->" + AfterLevel, "创客升级日志");
  2273. user.UserLevel = AfterLevel;
  2274. DateTime checkTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM") + "-01 00:00:00");
  2275. UserRank rank = db.UserRank.FirstOrDefault(m => m.CreateDate >= checkTime && m.UserId == user.Id);
  2276. if(rank == null)
  2277. {
  2278. db.UserRank.Add(new UserRank()
  2279. {
  2280. CreateDate = DateTime.Now,
  2281. UpdateDate = DateTime.Now,
  2282. UserId = user.Id, //创客
  2283. WhiteRank = BeforeLevel,
  2284. Rank = AfterLevel, //当前等级
  2285. StatYear = DateTime.Now.Year, //统计年份
  2286. StatMonth = DateTime.Now.Month, //统计月份
  2287. TradeAmt = TradeAmount, //团队交易总额
  2288. UpgradeFlag = 1, //升级标识
  2289. OperateDate = DateTime.Now, //操作时间
  2290. Status = 1,
  2291. });
  2292. db.SaveChanges();
  2293. }
  2294. else
  2295. {
  2296. rank.TradeAmt = TradeAmount;
  2297. rank.Rank = AfterLevel;
  2298. db.SaveChanges();
  2299. }
  2300. UserRankWhite rankWhite = db.UserRankWhite.FirstOrDefault(m => m.Id == user.Id);
  2301. if(rankWhite != null)
  2302. {
  2303. if(Utils.Instance.GetUserLevel(user.Id) >= rankWhite.Rank)
  2304. {
  2305. user.Version = 0;
  2306. db.SaveChanges();
  2307. }
  2308. }
  2309. }
  2310. // 降级逻辑
  2311. if(!upFlag && AfterLevel > 5)
  2312. {
  2313. AfterLevel = 5;
  2314. }
  2315. // 如果是达标创客,只能降级到K1
  2316. if(AfterLevel == 0 && Utils.Instance.IsStandardUser(user.Id))
  2317. {
  2318. AfterLevel = 1;
  2319. }
  2320. if (AfterLevel < BeforeLevel && BeforeLevel > 0)
  2321. {
  2322. function.WriteLog(user.MakerCode + "-" + user.RealName + ":K" + BeforeLevel + "->K" + AfterLevel, "创客降级日志");
  2323. user.UserLevel = AfterLevel;
  2324. DateTime checkTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM") + "-01 00:00:00");
  2325. UserRank rank = db.UserRank.FirstOrDefault(m => m.CreateDate >= checkTime && m.UserId == user.Id);
  2326. if(rank == null)
  2327. {
  2328. db.UserRank.Add(new UserRank()
  2329. {
  2330. CreateDate = DateTime.Now,
  2331. UpdateDate = DateTime.Now,
  2332. UserId = user.Id, //创客
  2333. WhiteRank = BeforeLevel,
  2334. Rank = AfterLevel, //当前等级
  2335. StatYear = DateTime.Now.Year, //统计年份
  2336. StatMonth = DateTime.Now.Month, //统计月份
  2337. TradeAmt = TradeAmount, //团队交易总额
  2338. UpgradeFlag = 0, //升级标识
  2339. OperateDate = DateTime.Now, //操作时间
  2340. Status = 1,
  2341. });
  2342. db.SaveChanges();
  2343. }
  2344. else
  2345. {
  2346. rank.TradeAmt = TradeAmount;
  2347. rank.Rank = AfterLevel;
  2348. rank.Status = 1;
  2349. db.SaveChanges();
  2350. }
  2351. UserRankWhite rankWhite = db.UserRankWhite.FirstOrDefault(m => m.Id == user.Id);
  2352. if(rankWhite != null)
  2353. {
  2354. if(Utils.Instance.GetUserLevel(user.Id) < rankWhite.Rank)
  2355. {
  2356. user.Version = 3;
  2357. db.SaveChanges();
  2358. }
  2359. }
  2360. }
  2361. }
  2362. startid = subuser.Id;
  2363. }
  2364. function.WriteLog(startid.ToString(), "创客升级日志");
  2365. }
  2366. else
  2367. {
  2368. op = false;
  2369. }
  2370. }
  2371. //查找K0创客,如果商城下单购买一组机具券,则预设为K1
  2372. List<int> productIds = new List<int>();
  2373. productIds.Add(10);
  2374. productIds.Add(11);
  2375. op = true;
  2376. startid = 0;
  2377. while(op)
  2378. {
  2379. var users = db.Users.Select(m => new { m.Id, m.AuthFlag, m.UserLevel }).Where(m => m.Id > startid && m.AuthFlag == 1 && m.UserLevel == 0).OrderBy(m => m.Id).Take(50).ToList();
  2380. if(users.Count > 0)
  2381. {
  2382. foreach (var subuser in users)
  2383. {
  2384. bool hasOrder = db.Orders.Any(m => m.UserId == subuser.Id && m.Status > 0 && productIds.Contains(m.ProductId));
  2385. if(hasOrder)
  2386. {
  2387. Utils.Instance.LeaderPreUserLevel(subuser.Id, 1, DateTime.Parse("2025-01-01 00:00:00"));
  2388. db.UserRank.Add(new UserRank()
  2389. {
  2390. CreateDate = DateTime.Now,
  2391. UpdateDate = DateTime.Now,
  2392. UserId = subuser.Id, //创客
  2393. WhiteRank = 0,
  2394. Rank = 1, //当前等级
  2395. StatYear = DateTime.Now.Year, //统计年份
  2396. StatMonth = DateTime.Now.Month, //统计月份
  2397. TradeAmt = 0, //团队交易总额
  2398. UpgradeFlag = 1, //升级标识
  2399. OperateDate = DateTime.Now, //操作时间
  2400. Status = 1,
  2401. });
  2402. Users user = db.Users.FirstOrDefault(m => m.Id == subuser.Id);
  2403. if(user != null)
  2404. {
  2405. user.Version = 3;
  2406. }
  2407. db.SaveChanges();
  2408. }
  2409. }
  2410. }
  2411. else
  2412. {
  2413. op = false;
  2414. }
  2415. }
  2416. function.WriteLog(DateTime.Now.ToString(), "创客升级日志");
  2417. }
  2418. catch (Exception ex)
  2419. {
  2420. function.WriteLog(ex.ToString(), "创客升级异常");
  2421. }
  2422. db.Dispose();
  2423. mpmaindb.Dispose();
  2424. mpmaindb2.Dispose();
  2425. RedisDbconn.Instance.AddList("DoTableEveryMonthQueue", "1");
  2426. }
  2427. // 统计创客激活数
  2428. public void StartPosActNum()
  2429. {
  2430. Thread th = new Thread(StartPosActNumFor);
  2431. th.IsBackground = true;
  2432. th.Start();
  2433. }
  2434. public void StartPosActNumFor()
  2435. {
  2436. // DateTime end = DateTime.Parse("2022-06-15 00:00:00");
  2437. // DateTime check = DateTime.Parse("2022-06-14");
  2438. // while (check <= end)
  2439. // {
  2440. // StartPosActNumDo(check.ToString("yyyy-MM-dd"));
  2441. // check = check.AddDays(1);
  2442. // }
  2443. while (true)
  2444. {
  2445. if(DateTime.Now.Hour >= 2)
  2446. {
  2447. StartPosActNumEverTime();
  2448. }
  2449. Thread.Sleep(100);
  2450. }
  2451. }
  2452. public void StartPosActNumDo(object sender)
  2453. {
  2454. string date = sender.ToString();
  2455. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), "执行创客激活数日志");
  2456. WebCMSEntities db = new WebCMSEntities();
  2457. try
  2458. {
  2459. string TradeDate = date.Replace("-", "");
  2460. string TradeMonth = TradeDate.Substring(0, 6);
  2461. string start = date + " 00:00:00";
  2462. string end = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  2463. List<string> uids = new List<string>();
  2464. DataTable userDt = OtherMySqlConn.dtable("select Id,ParentNav from Users where Id in (select DISTINCT BuyUserId from PosMachinesTwo where QueryCount=0 and ActivationState=1 and ActivationTime>='" + start + "' and ActivationTime<'" + end + "')");
  2465. function.WriteLog("人数:" + userDt.Rows.Count + "\n\n", "执行创客激活数日志");
  2466. foreach (DataRow userDr in userDt.Rows)
  2467. {
  2468. int UserId = int.Parse(userDr["Id"].ToString());
  2469. string ParentNav = userDr["ParentNav"].ToString();
  2470. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行创客激活数日志");
  2471. DataTable selfdt = OtherMySqlConn.dtable("select BrandId,count(Id) from PosMachinesTwo where QueryCount=0 and ActivationState=1 and ActivationTime>='" + start + "' and ActivationTime<'" + end + "' and BuyUserId=" + UserId + " group by BrandId");
  2472. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行创客激活数日志");
  2473. foreach (DataRow selfDr in selfdt.Rows)
  2474. {
  2475. int BrandId = int.Parse(selfDr["BrandId"].ToString());
  2476. int QrPayFlag = 0;
  2477. int ActCount = int.Parse(selfDr[1].ToString());
  2478. UserTradeDaySummary selfStat = db.UserTradeDaySummary.FirstOrDefault(m => m.UserId == UserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.BrandId == BrandId && m.QueryCount == QrPayFlag && m.SeoTitle == "self");
  2479. if (selfStat == null)
  2480. {
  2481. selfStat = db.UserTradeDaySummary.Add(new UserTradeDaySummary()
  2482. {
  2483. UserId = UserId,
  2484. TradeMonth = TradeMonth,
  2485. TradeDate = TradeDate,
  2486. BrandId = BrandId,
  2487. QueryCount = QrPayFlag,
  2488. SeoTitle = "self",
  2489. }).Entity;
  2490. db.SaveChanges();
  2491. }
  2492. selfStat.DirectDebitCapNum += ActCount;
  2493. db.SaveChanges();
  2494. }
  2495. if (!string.IsNullOrEmpty(ParentNav))
  2496. {
  2497. ParentNav += "," + UserId + ",";
  2498. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  2499. foreach (string NavUserIdString in ParentNavList)
  2500. {
  2501. if (!uids.Contains(NavUserIdString + start))
  2502. {
  2503. uids.Add(NavUserIdString + start);
  2504. int NavUserId = int.Parse(NavUserIdString);
  2505. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行创客激活数日志");
  2506. DataTable teamDt = OtherMySqlConn.dtable("select BrandId,count(Id) from PosMachinesTwo where QueryCount=0 and ActivationState=1 and ActivationTime>='" + start + "' and ActivationTime<'" + end + "' and BuyUserId in (select Id from Users where ParentNav like '%," + NavUserId + ",%' or Id=" + NavUserId + ") group by BrandId");
  2507. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行创客激活数日志");
  2508. foreach (DataRow teamDr in teamDt.Rows)
  2509. {
  2510. int BrandId = int.Parse(teamDr["BrandId"].ToString());
  2511. int QrPayFlag = 0;
  2512. int ActCount = int.Parse(teamDr[1].ToString());
  2513. UserTradeDaySummary teamStat = db.UserTradeDaySummary.FirstOrDefault(m => m.UserId == NavUserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.BrandId == BrandId && m.QueryCount == QrPayFlag && m.SeoTitle == "team");
  2514. if (teamStat == null)
  2515. {
  2516. teamStat = db.UserTradeDaySummary.Add(new UserTradeDaySummary()
  2517. {
  2518. UserId = NavUserId,
  2519. TradeMonth = TradeMonth,
  2520. TradeDate = TradeDate,
  2521. BrandId = BrandId,
  2522. QueryCount = QrPayFlag,
  2523. SeoTitle = "team",
  2524. }).Entity;
  2525. db.SaveChanges();
  2526. }
  2527. teamStat.NonDirectDebitCapNum += ActCount;
  2528. db.SaveChanges();
  2529. }
  2530. }
  2531. }
  2532. }
  2533. }
  2534. OtherMySqlConn.op("update PosMachinesTwo set QueryCount=1 where QueryCount=0 and ActivationState=1 and ActivationTime>='" + start + "' and ActivationTime<'" + end + "'");
  2535. }
  2536. catch (Exception ex)
  2537. {
  2538. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "执行创客激活数异常");
  2539. }
  2540. db.Dispose();
  2541. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行创客激活数日志");
  2542. Thread.Sleep(60000);
  2543. }
  2544. public void StartPosActNumEverTime()
  2545. {
  2546. OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["Pxc1SqlConnStr"].ToString();
  2547. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), "实时执行创客激活数日志");
  2548. WebCMSEntities db = new WebCMSEntities();
  2549. try
  2550. {
  2551. DataTable idsDt = OtherMySqlConn.dtable("select Id from PosMachinesTwo where QueryCount=0 and ActivationState=1 and ActivationTime is not null and BuyUserId>0 limit 50");
  2552. if(idsDt.Rows.Count > 0)
  2553. {
  2554. string ids = "";
  2555. foreach (DataRow idsDr in idsDt.Rows)
  2556. {
  2557. ids += idsDr["Id"].ToString() + ",";
  2558. }
  2559. DataTable userDt = OtherMySqlConn.dtable("select BuyUserId,BrandId,DATE_FORMAT(ActivationTime, '%Y%m%d'),count(Id) from PosMachinesTwo where Id in (" + ids.TrimEnd(',') + ") group by BuyUserId,BrandId,DATE_FORMAT(ActivationTime, '%Y%m%d')");
  2560. if (userDt.Rows.Count > 0)
  2561. {
  2562. function.WriteLog("人数:" + userDt.Rows.Count + "\n\n", "实时执行创客激活数日志");
  2563. foreach (DataRow userDr in userDt.Rows)
  2564. {
  2565. int UserId = int.Parse(userDr["BuyUserId"].ToString());
  2566. int BrandId = int.Parse(userDr["BrandId"].ToString());
  2567. string TradeDate = userDr[2].ToString();
  2568. int ActCount = int.Parse(function.CheckInt(userDr[3].ToString()));
  2569. int QrPayFlag = 0;
  2570. string TradeMonth = TradeDate.Substring(0, 6);
  2571. string date = TradeDate.Substring(0, 4) + "-" + TradeDate.Substring(4, 2) + "-" + TradeDate.Substring(6, 2);
  2572. string start = date + " 00:00:00";
  2573. string end = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  2574. Users user = db.Users.FirstOrDefault(m => m.Id == UserId) ?? new Users();
  2575. string ParentNav = user.ParentNav;
  2576. UserTradeDaySummary selfStat = db.UserTradeDaySummary.FirstOrDefault(m => m.UserId == UserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.BrandId == BrandId && m.QueryCount == QrPayFlag && m.SeoTitle == "self");
  2577. if (selfStat == null)
  2578. {
  2579. selfStat = db.UserTradeDaySummary.Add(new UserTradeDaySummary()
  2580. {
  2581. UserId = UserId,
  2582. TradeMonth = TradeMonth,
  2583. TradeDate = TradeDate,
  2584. BrandId = BrandId,
  2585. QueryCount = QrPayFlag,
  2586. SeoTitle = "self",
  2587. }).Entity;
  2588. db.SaveChanges();
  2589. }
  2590. selfStat.DirectDebitCapNum += ActCount;
  2591. ParentNav += "," + UserId + ",";
  2592. if (!string.IsNullOrEmpty(ParentNav))
  2593. {
  2594. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  2595. foreach (string NavUserIdString in ParentNavList)
  2596. {
  2597. int NavUserId = int.Parse(NavUserIdString);
  2598. UserTradeDaySummary teamStat = db.UserTradeDaySummary.FirstOrDefault(m => m.UserId == NavUserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.BrandId == BrandId && m.QueryCount == QrPayFlag && m.SeoTitle == "team");
  2599. if (teamStat == null)
  2600. {
  2601. teamStat = db.UserTradeDaySummary.Add(new UserTradeDaySummary()
  2602. {
  2603. UserId = NavUserId,
  2604. TradeMonth = TradeMonth,
  2605. TradeDate = TradeDate,
  2606. BrandId = BrandId,
  2607. QueryCount = QrPayFlag,
  2608. SeoTitle = "team",
  2609. }).Entity;
  2610. db.SaveChanges();
  2611. }
  2612. teamStat.NonDirectDebitCapNum += ActCount;
  2613. }
  2614. }
  2615. }
  2616. db.SaveChanges();
  2617. OtherMySqlConn.op("update PosMachinesTwo set QueryCount=1 where Id in (" + ids.TrimEnd(',') + ")");
  2618. }
  2619. }
  2620. }
  2621. catch (Exception ex)
  2622. {
  2623. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "实时执行创客激活数异常");
  2624. }
  2625. db.Dispose();
  2626. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "实时执行创客激活数日志");
  2627. }
  2628. // 统计新增创客数
  2629. public void StartNewUserNum()
  2630. {
  2631. Thread th = new Thread(StartNewUserNumFor);
  2632. th.IsBackground = true;
  2633. th.Start();
  2634. }
  2635. public void StartNewUserNumFor()
  2636. {
  2637. // DateTime end = DateTime.Parse("2022-06-15 00:00:00");
  2638. // DateTime check = DateTime.Parse("2022-06-14");
  2639. // while (check <= end)
  2640. // {
  2641. // StartNewUserNumDo(check.ToString("yyyy-MM-dd"));
  2642. // check = check.AddDays(1);
  2643. // }
  2644. while (true)
  2645. {
  2646. if(DateTime.Now.Hour >= 2)
  2647. {
  2648. StartNewUserNumEverTime();
  2649. }
  2650. Thread.Sleep(120000);
  2651. }
  2652. }
  2653. public void StartNewUserNumDo(object sender)
  2654. {
  2655. OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["Pxc1SqlConnStr"].ToString();
  2656. string date = sender.ToString();
  2657. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), "执行新增创客数日志");
  2658. WebCMSEntities db = new WebCMSEntities();
  2659. try
  2660. {
  2661. string StatDate = date.Replace("-", "");
  2662. string StatMonth = StatDate.Substring(0, 6);
  2663. string start = date + " 00:00:00";
  2664. string end = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  2665. List<string> uids = new List<string>();
  2666. DataTable userDt = OtherMySqlConn.dtable("select Id,ParentNav from Users where QueryCount=0 and AuthFlag=1 and AuthDate>='" + start + "' and AuthDate<'" + end + "'");
  2667. function.WriteLog("人数:" + userDt.Rows.Count + "\n\n", "执行新增创客数日志");
  2668. foreach (DataRow userDr in userDt.Rows)
  2669. {
  2670. int UserId = int.Parse(userDr["Id"].ToString());
  2671. string ParentNav = userDr["ParentNav"].ToString();
  2672. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行新增创客数日志");
  2673. DataTable selfdt = OtherMySqlConn.dtable("select count(Id) from Users where QueryCount=0 and AuthFlag=1 and AuthDate>='" + start + "' and AuthDate<'" + end + "' and ParentUserId=" + UserId + "");
  2674. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行新增创客数日志");
  2675. foreach (DataRow selfDr in selfdt.Rows)
  2676. {
  2677. int AddCount = int.Parse(selfDr[0].ToString());
  2678. PullnewSummary selfStat = db.PullnewSummary.FirstOrDefault(m => m.UserId == UserId && m.StatMonth == StatMonth && m.StatDate == StatDate && m.SeoTitle == "self");
  2679. if (selfStat == null)
  2680. {
  2681. selfStat = db.PullnewSummary.Add(new PullnewSummary()
  2682. {
  2683. UserId = UserId,
  2684. StatMonth = StatMonth,
  2685. StatDate = StatDate,
  2686. SeoTitle = "self",
  2687. }).Entity;
  2688. db.SaveChanges();
  2689. }
  2690. selfStat.RecUserAuthNum += AddCount;
  2691. db.SaveChanges();
  2692. }
  2693. if (!string.IsNullOrEmpty(ParentNav))
  2694. {
  2695. ParentNav += "," + UserId + ",";
  2696. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  2697. foreach (string NavUserIdString in ParentNavList)
  2698. {
  2699. if (!uids.Contains(NavUserIdString + start))
  2700. {
  2701. uids.Add(NavUserIdString + start);
  2702. int NavUserId = int.Parse(NavUserIdString);
  2703. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行新增创客数日志");
  2704. DataTable teamDt = OtherMySqlConn.dtable("select count(Id) from Users where QueryCount=0 and AuthFlag=1 and AuthDate>='" + start + "' and AuthDate<'" + end + "' and ParentNav like '%," + NavUserId + ",%'");
  2705. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行新增创客数日志");
  2706. foreach (DataRow teamDr in teamDt.Rows)
  2707. {
  2708. int AddCount = int.Parse(teamDr[0].ToString());
  2709. PullnewSummary teamStat = db.PullnewSummary.FirstOrDefault(m => m.UserId == NavUserId && m.StatMonth == StatMonth && m.StatDate == StatDate && m.SeoTitle == "team");
  2710. if (teamStat == null)
  2711. {
  2712. teamStat = db.PullnewSummary.Add(new PullnewSummary()
  2713. {
  2714. UserId = NavUserId,
  2715. StatMonth = StatMonth,
  2716. StatDate = StatDate,
  2717. SeoTitle = "team",
  2718. }).Entity;
  2719. db.SaveChanges();
  2720. }
  2721. teamStat.RecUserAuthNum += AddCount;
  2722. db.SaveChanges();
  2723. }
  2724. }
  2725. }
  2726. }
  2727. }
  2728. OtherMySqlConn.op("update Users set QueryCount=1 where QueryCount=0 and AuthFlag=1 and AuthDate>='" + start + "' and AuthDate<'" + end + "'");
  2729. }
  2730. catch (Exception ex)
  2731. {
  2732. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "执行新增创客数异常");
  2733. }
  2734. db.Dispose();
  2735. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行新增创客数日志");
  2736. Thread.Sleep(60000);
  2737. }
  2738. public void StartNewUserNumEverTime()
  2739. {
  2740. OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["Pxc1SqlConnStr"].ToString();
  2741. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), "实时执行新增创客数日志");
  2742. WebCMSEntities db = new WebCMSEntities();
  2743. try
  2744. {
  2745. DataTable idsDt = OtherMySqlConn.dtable("select Id from Users where QueryCount=0 and AuthFlag=1 and AuthDate is not null limit 50");
  2746. if(idsDt.Rows.Count > 0)
  2747. {
  2748. string ids = "";
  2749. foreach (DataRow idsDr in idsDt.Rows)
  2750. {
  2751. ids += idsDr["Id"].ToString() + ",";
  2752. }
  2753. DataTable userDt = OtherMySqlConn.dtable("select ParentUserId,DATE_FORMAT(AuthDate, '%Y%m%d'),count(Id) from Users where Id in (" + ids.TrimEnd(',') + ") group by ParentUserId,DATE_FORMAT(AuthDate, '%Y%m%d')");
  2754. if(userDt.Rows.Count > 0)
  2755. {
  2756. function.WriteLog("人数:" + userDt.Rows.Count + "\n\n", "实时执行新增创客数日志");
  2757. foreach (DataRow userDr in userDt.Rows)
  2758. {
  2759. string StatDate = userDr[1].ToString();
  2760. int UserId = int.Parse(userDr["ParentUserId"].ToString());
  2761. string StatMonth = StatDate.Substring(0, 6);
  2762. string date = StatDate.Substring(0, 4) + "-" + StatDate.Substring(4, 2) + "-" + StatDate.Substring(6, 2);
  2763. string start = date + " 00:00:00";
  2764. string end = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  2765. int AddCount = int.Parse(userDr[2].ToString());
  2766. Users user = db.Users.FirstOrDefault(m => m.Id == UserId) ?? new Users();
  2767. string ParentNav = user.ParentNav;
  2768. PullnewSummary selfStat = db.PullnewSummary.FirstOrDefault(m => m.UserId == UserId && m.StatMonth == StatMonth && m.StatDate == StatDate && m.SeoTitle == "self");
  2769. if (selfStat == null)
  2770. {
  2771. selfStat = db.PullnewSummary.Add(new PullnewSummary()
  2772. {
  2773. UserId = UserId,
  2774. StatMonth = StatMonth,
  2775. StatDate = StatDate,
  2776. SeoTitle = "self",
  2777. }).Entity;
  2778. db.SaveChanges();
  2779. }
  2780. selfStat.RecUserAuthNum += AddCount;
  2781. ParentNav += "," + UserId + ",";
  2782. if (!string.IsNullOrEmpty(ParentNav))
  2783. {
  2784. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  2785. foreach (string NavUserIdString in ParentNavList)
  2786. {
  2787. int NavUserId = int.Parse(NavUserIdString);
  2788. PullnewSummary teamStat = db.PullnewSummary.FirstOrDefault(m => m.UserId == NavUserId && m.StatMonth == StatMonth && m.StatDate == StatDate && m.SeoTitle == "team");
  2789. if (teamStat == null)
  2790. {
  2791. teamStat = db.PullnewSummary.Add(new PullnewSummary()
  2792. {
  2793. UserId = NavUserId,
  2794. StatMonth = StatMonth,
  2795. StatDate = StatDate,
  2796. SeoTitle = "team",
  2797. }).Entity;
  2798. db.SaveChanges();
  2799. }
  2800. teamStat.RecUserAuthNum += AddCount;
  2801. }
  2802. }
  2803. }
  2804. db.SaveChanges();
  2805. OtherMySqlConn.op("update Users set QueryCount=1 where Id in (" + ids.TrimEnd(',') + ")");
  2806. }
  2807. }
  2808. }
  2809. catch (Exception ex)
  2810. {
  2811. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "实时执行新增创客数异常");
  2812. }
  2813. db.Dispose();
  2814. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "实时执行新增创客数日志");
  2815. }
  2816. // 每天统计头一天的收益
  2817. public void StatProfit()
  2818. {
  2819. Thread th = new Thread(StatProfitDo);
  2820. th.IsBackground = true;
  2821. th.Start();
  2822. }
  2823. public void StatProfitDo()
  2824. {
  2825. // DateTime end = DateTime.Parse("2022-06-16 00:00:00");
  2826. // DateTime check = DateTime.Parse("2022-06-16");
  2827. // while (check <= end)
  2828. // {
  2829. // StatProfitEverDay(check.ToString("yyyy-MM-dd"));
  2830. // Thread.Sleep(1000);
  2831. // check = check.AddDays(1);
  2832. // }
  2833. while (true)
  2834. {
  2835. if(DateTime.Now.Hour >= 2)
  2836. {
  2837. StatProfitEverDayEverTime();
  2838. }
  2839. Thread.Sleep(120000);
  2840. }
  2841. }
  2842. public void StatProfitEverDay(object sender)
  2843. {
  2844. OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["Pxc1SqlConnStr"].ToString();
  2845. string date = sender.ToString();
  2846. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), "执行昨天收益日志");
  2847. WebCMSEntities db = new WebCMSEntities();
  2848. try
  2849. {
  2850. string TradeDate = date.Replace("-", "");
  2851. string TradeMonth = TradeDate.Substring(0, 6);
  2852. string start = date + " 00:00:00";
  2853. string end = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  2854. string startId = "0";
  2855. List<string> uids = new List<string>();
  2856. DataTable startDt = OtherMySqlConn.dtable("select min(Id) from UserAccountRecord where CreateDate>='" + start + "'");
  2857. if (startDt.Rows.Count > 0)
  2858. {
  2859. startId = startDt.Rows[0][0].ToString();
  2860. }
  2861. function.WriteLog(startId + "\n\n", "执行昨天收益日志");
  2862. DataTable userDt = OtherMySqlConn.dtable("select Id,ParentNav from Users where Id in (select DISTINCT UserId from UserAccountRecord where Id>=" + startId + " and CreateDate>='" + start + "' and CreateDate<'" + end + "')");
  2863. function.WriteLog("交易人数:" + userDt.Rows.Count + "\n\n", "执行昨天收益日志");
  2864. foreach (DataRow userDr in userDt.Rows)
  2865. {
  2866. int UserId = int.Parse(userDr["Id"].ToString());
  2867. string ParentNav = userDr["ParentNav"].ToString();
  2868. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天收益日志");
  2869. DataTable selfdt = OtherMySqlConn.dtable("select ChangeType,ProductType,sum(ChangeAmount) from UserAccountRecord where Id>=" + startId + " and CreateDate>='" + start + "' and CreateDate<'" + end + "' and UserId=" + UserId + " group by ChangeType,ProductType");
  2870. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天收益日志");
  2871. foreach (DataRow selfDr in selfdt.Rows)
  2872. {
  2873. int ChangeType = int.Parse(selfDr["ChangeType"].ToString());
  2874. int ProductType = int.Parse(selfDr["ProductType"].ToString());
  2875. decimal ProfitAmount = decimal.Parse(selfDr[2].ToString());
  2876. UserRebateDetail selfStat = db.UserRebateDetail.FirstOrDefault(m => m.UserId == UserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.RebateType == ChangeType && m.ProductType == ProductType && m.SeoTitle == "self");
  2877. if (selfStat == null)
  2878. {
  2879. selfStat = db.UserRebateDetail.Add(new UserRebateDetail()
  2880. {
  2881. UserId = UserId,
  2882. TradeMonth = TradeMonth,
  2883. TradeDate = TradeDate,
  2884. RebateType = ChangeType,
  2885. ProductType = ProductType,
  2886. SeoTitle = "self",
  2887. }).Entity;
  2888. db.SaveChanges();
  2889. }
  2890. selfStat.CreditRewardAmount += ProfitAmount;
  2891. db.SaveChanges();
  2892. }
  2893. if (!string.IsNullOrEmpty(ParentNav))
  2894. {
  2895. ParentNav += "," + UserId + ",";
  2896. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  2897. foreach (string NavUserIdString in ParentNavList)
  2898. {
  2899. if (!uids.Contains(NavUserIdString + start))
  2900. {
  2901. uids.Add(NavUserIdString + start);
  2902. int NavUserId = int.Parse(NavUserIdString);
  2903. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天收益日志");
  2904. DataTable teamDt = OtherMySqlConn.dtable("select ChangeType,ProductType,sum(ChangeAmount) from UserAccountRecord where Id>=" + startId + " and CreateDate>='" + start + "' and CreateDate<'" + end + "' and UserId in (select Id from Users where ParentNav like '%," + NavUserId + ",%' or Id=" + NavUserId + ") group by ChangeType,ProductType");
  2905. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天收益日志");
  2906. foreach (DataRow teamDr in teamDt.Rows)
  2907. {
  2908. int ChangeType = int.Parse(teamDr["ChangeType"].ToString());
  2909. int ProductType = int.Parse(teamDr["ProductType"].ToString());
  2910. decimal ProfitAmount = decimal.Parse(teamDr[2].ToString());
  2911. UserRebateDetail teamStat = db.UserRebateDetail.FirstOrDefault(m => m.UserId == NavUserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.RebateType == ChangeType && m.ProductType == ProductType && m.SeoTitle == "team");
  2912. if (teamStat == null)
  2913. {
  2914. teamStat = db.UserRebateDetail.Add(new UserRebateDetail()
  2915. {
  2916. UserId = NavUserId,
  2917. TradeMonth = TradeMonth,
  2918. TradeDate = TradeDate,
  2919. RebateType = ChangeType,
  2920. ProductType = ProductType,
  2921. SeoTitle = "team",
  2922. }).Entity;
  2923. db.SaveChanges();
  2924. }
  2925. teamStat.CreditRewardAmount += ProfitAmount;
  2926. db.SaveChanges();
  2927. }
  2928. }
  2929. }
  2930. }
  2931. }
  2932. }
  2933. catch (Exception ex)
  2934. {
  2935. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "统计昨天收益异常");
  2936. }
  2937. db.Dispose();
  2938. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天收益日志");
  2939. }
  2940. public void StatProfitEverDayEverTime()
  2941. {
  2942. OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["Pxc1SqlConnStr"].ToString();
  2943. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), "实时统计收益日志");
  2944. WebCMSEntities db = new WebCMSEntities();
  2945. try
  2946. {
  2947. string startId = function.ReadInstance("/UserAccountRecord/Id.txt");
  2948. if(string.IsNullOrEmpty(startId))
  2949. {
  2950. startId = "160653";
  2951. }
  2952. DataTable idsDt = OtherMySqlConn.dtable("select Id from UserAccountRecord where Id>=" + startId + " and QueryCount=0 order by Id limit 50");
  2953. if(idsDt.Rows.Count > 0)
  2954. {
  2955. string ids = "";
  2956. foreach (DataRow idsDr in idsDt.Rows)
  2957. {
  2958. ids += idsDr["Id"].ToString() + ",";
  2959. startId = idsDr["Id"].ToString();
  2960. }
  2961. DataTable userDt = OtherMySqlConn.dtable("select UserId,ChangeType,ProductType,DATE_FORMAT(CreateDate, '%Y%m%d'),sum(ChangeAmount) from UserAccountRecord where Id in (" + ids.TrimEnd(',') + ") group by UserId,ChangeType,ProductType,DATE_FORMAT(CreateDate, '%Y%m%d')");
  2962. if (userDt.Rows.Count > 0)
  2963. {
  2964. function.WriteLog("收益人数:" + userDt.Rows.Count + "\n\n", "实时统计收益日志");
  2965. foreach (DataRow userDr in userDt.Rows)
  2966. {
  2967. int UserId = int.Parse(userDr["UserId"].ToString());
  2968. int ChangeType = int.Parse(userDr["ChangeType"].ToString());
  2969. int ProductType = int.Parse(userDr["ProductType"].ToString());
  2970. string TradeDate = userDr[3].ToString();
  2971. decimal ProfitAmount = decimal.Parse(userDr[4].ToString());
  2972. string TradeMonth = TradeDate.Substring(0, 6);
  2973. string date = TradeDate.Substring(0, 4) + "-" + TradeDate.Substring(4, 2) + "-" + TradeDate.Substring(6, 2);
  2974. string start = date + " 00:00:00";
  2975. string end = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  2976. Users user = db.Users.FirstOrDefault(m => m.Id == UserId) ?? new Users();
  2977. string ParentNav = user.ParentNav;
  2978. UserRebateDetail selfStat = db.UserRebateDetail.FirstOrDefault(m => m.UserId == UserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.RebateType == ChangeType && m.ProductType == ProductType && m.SeoTitle == "self");
  2979. if (selfStat == null)
  2980. {
  2981. selfStat = db.UserRebateDetail.Add(new UserRebateDetail()
  2982. {
  2983. UserId = UserId,
  2984. TradeMonth = TradeMonth,
  2985. TradeDate = TradeDate,
  2986. RebateType = ChangeType,
  2987. ProductType = ProductType,
  2988. SeoTitle = "self",
  2989. }).Entity;
  2990. db.SaveChanges();
  2991. }
  2992. selfStat.CreditRewardAmount += ProfitAmount;
  2993. ParentNav += "," + UserId + ",";
  2994. if (!string.IsNullOrEmpty(ParentNav))
  2995. {
  2996. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  2997. foreach (string NavUserIdString in ParentNavList)
  2998. {
  2999. int NavUserId = int.Parse(NavUserIdString);
  3000. UserRebateDetail teamStat = db.UserRebateDetail.FirstOrDefault(m => m.UserId == NavUserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.RebateType == ChangeType && m.ProductType == ProductType && m.SeoTitle == "team");
  3001. if (teamStat == null)
  3002. {
  3003. teamStat = db.UserRebateDetail.Add(new UserRebateDetail()
  3004. {
  3005. UserId = NavUserId,
  3006. TradeMonth = TradeMonth,
  3007. TradeDate = TradeDate,
  3008. RebateType = ChangeType,
  3009. ProductType = ProductType,
  3010. SeoTitle = "team",
  3011. }).Entity;
  3012. db.SaveChanges();
  3013. }
  3014. teamStat.CreditRewardAmount += ProfitAmount;
  3015. }
  3016. }
  3017. }
  3018. db.SaveChanges();
  3019. OtherMySqlConn.op("update UserAccountRecord set QueryCount=1 where Id in (" + ids.TrimEnd(',') + ")");
  3020. function.WritePage("/UserAccountRecord/", "Id.txt", startId);
  3021. }
  3022. }
  3023. }
  3024. catch (Exception ex)
  3025. {
  3026. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "实时统计收益异常");
  3027. }
  3028. db.Dispose();
  3029. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "实时统计收益日志");
  3030. }
  3031. //押金奖励发放
  3032. public void StartPreActPrize()
  3033. {
  3034. Thread th = new Thread(StartPreActPrizeDo);
  3035. th.IsBackground = true;
  3036. th.Start();
  3037. }
  3038. public void StartPreActPrizeDo()
  3039. {
  3040. while(true)
  3041. {
  3042. string content = RedisDbconn.Instance.RPop<string>("DepositActPrizeQueue");
  3043. if(!string.IsNullOrEmpty(content))
  3044. {
  3045. try
  3046. {
  3047. int PosId = int.Parse(content);
  3048. WebCMSEntities db = new WebCMSEntities();
  3049. PxcModels.PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == PosId) ?? new PxcModels.PosMachinesTwo();
  3050. PxcModels.PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId) ?? new PxcModels.PosMerchantInfo();
  3051. PreActPrize(db, pos, merchant, pos.SeoKeyword);
  3052. db.Dispose();
  3053. }
  3054. catch(Exception ex)
  3055. {
  3056. function.WriteLog(DateTime.Now.ToString() + "\nPosId:" + content + "\n" + ex.ToString(), "押金奖励发放异常");
  3057. }
  3058. }
  3059. else
  3060. {
  3061. Thread.Sleep(10000);
  3062. }
  3063. }
  3064. }
  3065. public void PreActPrize(WebCMSEntities db, PosMachinesTwo pos, PosMerchantInfo merchant, string Deposit)
  3066. {
  3067. function.WriteLog(DateTime.Now.ToString() + "\n" + pos.PosSn, "服务费奖励发放日志");
  3068. decimal DepositNumber = decimal.Parse(function.CheckNum(Deposit));
  3069. function.WriteLog("DepositNumber:" + DepositNumber, "服务费奖励发放日志");
  3070. function.WriteLog("BuyUserId:" + pos.BuyUserId, "服务费奖励发放日志");
  3071. if(DepositNumber > 0 && pos.BuyUserId > 0)
  3072. {
  3073. function.WriteLog("满足条件", "服务费奖励发放日志");
  3074. decimal ActPrize = 0;
  3075. if(DepositNumber > 1000)
  3076. {
  3077. DepositNumber = DepositNumber / 100;
  3078. }
  3079. if(DepositNumber == 199) ActPrize = 100;
  3080. if(DepositNumber == 299) ActPrize = 200;
  3081. if(DepositNumber == 249) ActPrize = 160;
  3082. function.WriteLog("ActPrize:" + ActPrize, "服务费奖励发放日志");
  3083. if(ActPrize > 0)
  3084. {
  3085. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new Users();
  3086. int GetUserId = user.Id;
  3087. string ParentNav = user.ParentNav;
  3088. int TopUserId = 0;
  3089. if (!string.IsNullOrEmpty(ParentNav))
  3090. {
  3091. TopUserId = int.Parse(ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  3092. }
  3093. function.WriteLog("发放给:" + GetUserId, "服务费奖励发放日志");
  3094. doActiveReward(db, merchant, pos, GetUserId, user.ParentNav, TopUserId, ActPrize, 0, 1);
  3095. function.WriteLog("已发放", "服务费奖励发放日志");
  3096. }
  3097. }
  3098. function.WriteLog("\n\n\n", "服务费奖励发放日志");
  3099. }
  3100. #region 判断品牌互斥条件,根据身份证号
  3101. public bool CheckRepeatByBrand(WebCMSEntities db, int MerchantId)
  3102. {
  3103. int check = db.PosMachinesTwo.Count(m => m.Status > -1 && m.BindMerchantId == MerchantId);
  3104. return false;
  3105. }
  3106. #endregion
  3107. #region 开机奖励
  3108. public void PostOpenReward(WebCMSEntities db, PosMachinesTwo pos, PosMerchantInfo merchant, UserRankItem puser, decimal Prize)
  3109. {
  3110. Users machineUser = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new Users();
  3111. OpenRewardDetail detail = db.OpenRewardDetail.Add(new OpenRewardDetail()
  3112. {
  3113. CreateDate = DateTime.Now,
  3114. UpdateDate = DateTime.Now,
  3115. TradeMonth = DateTime.Now.ToString("yyyyMM"), //交易月
  3116. TradeDate = DateTime.Now, //达标日期
  3117. UserId = puser.Id, //创客
  3118. BrandId = pos.BrandId, //品牌
  3119. ProductName = RelationClass.GetKqProductsInfo(pos.BrandId), //产品名称
  3120. MerchantId = pos.BindMerchantId, //商户
  3121. DirectUserId = merchant.UserId, //商户直属人
  3122. SnNo = pos.PosSn, //SN号
  3123. MerNo = merchant.KqMerNo, //渠道商户号
  3124. SnType = pos.PosSnType, //机具类型
  3125. StandardDate = pos.ActivationTime, //商户的激活日期
  3126. SnStoreId = pos.StoreId, //SN仓库
  3127. MerBuddyType = puser.MerchantType, //商户创客类型
  3128. RewardType = 1, //奖励类型 1-开机直接奖励,2-开机间接奖励
  3129. RewardTips = "开机奖励", //奖励描述
  3130. CreditTradeAmt = pos.CreditTrade, //贷记卡交易总金额
  3131. DebitTradeAmt = pos.DebitCardTrade, //借记卡交易总金额
  3132. CreditRewardAmount = Prize, //贷记卡交易奖励金额
  3133. RewardDesc = "开机奖励", //奖励描述
  3134. SeoTitle = machineUser.RealName,
  3135. }).Entity;
  3136. db.OpenReward.Add(new OpenReward()
  3137. {
  3138. CreateDate = DateTime.Now,
  3139. UpdateDate = DateTime.Now,
  3140. TradeMonth = DateTime.Now.ToString("yyyyMM"), //交易月
  3141. TradeDate = DateTime.Now, //达标日期
  3142. UserId = puser.Id, //创客
  3143. BrandId = pos.BrandId, //品牌
  3144. RewardType = 2, //奖励类型
  3145. CreditTradeAmt = pos.CreditTrade, //贷记卡交易总金额
  3146. DebitTradeAmt = pos.DebitCardTrade, //借记卡交易总金额
  3147. CreditRewardAmount = Prize, //贷记卡交易奖励金额
  3148. RewardDesc = "开机奖励", //奖励描述
  3149. });
  3150. string IdBrand = puser.Id + "_" + pos.BrandId;
  3151. UserMachineData userData = db.UserMachineData.FirstOrDefault(m => m.IdBrand == IdBrand);
  3152. if (userData == null)
  3153. {
  3154. userData = db.UserMachineData.Add(new UserMachineData()
  3155. {
  3156. IdBrand = IdBrand,
  3157. }).Entity;
  3158. db.SaveChanges();
  3159. }
  3160. userData.OpenProfit += Prize;
  3161. db.SaveChanges();
  3162. //账户入库
  3163. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == puser.Id);
  3164. if (account == null)
  3165. {
  3166. account = db.UserAccount.Add(new UserAccount()
  3167. {
  3168. Id = puser.Id,
  3169. UserId = puser.Id,
  3170. }).Entity;
  3171. db.SaveChanges();
  3172. }
  3173. //收支明细入库
  3174. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  3175. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  3176. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  3177. account.BalanceAmount += Prize;
  3178. account.TotalAmount += Prize;
  3179. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  3180. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  3181. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  3182. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  3183. {
  3184. CreateDate = DateTime.Now,
  3185. UpdateDate = DateTime.Now,
  3186. UserId = puser.Id, //创客
  3187. ChangeType = 50, //变动类型
  3188. ProductType = pos.BrandId, //产品类型
  3189. ChangeAmount = Prize, //变更金额
  3190. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  3191. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  3192. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  3193. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  3194. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  3195. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  3196. }).Entity;
  3197. db.SaveChanges();
  3198. }
  3199. #endregion
  3200. }
  3201. }