StatService.cs 187 KB

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