StatService.cs 165 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698
  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. // activePrizeWithoutDeposit122();
  108. function.WriteLog(DateTime.Now.ToString() + ":end\n\n", "实时处理盒易付0押激活奖励");
  109. }
  110. catch (Exception ex)
  111. {
  112. function.WriteLog(DateTime.Now.ToString() + ":" + ex.ToString(), "实时处理盒易付0押激活奖励异常");
  113. }
  114. Thread.Sleep(30000);
  115. }
  116. }
  117. public void clear()
  118. {
  119. RedisDbconn.Instance.Clear("TotalAmount*");
  120. RedisDbconn.Instance.Clear("TotalCloudPayAmount*");
  121. RedisDbconn.Instance.Clear("TotalPosAmount*");
  122. RedisDbconn.Instance.Clear("TeamTotalAmount*");
  123. RedisDbconn.Instance.Clear("TeamTotalCloudPayAmount*");
  124. RedisDbconn.Instance.Clear("TeamTotalPosAmount*");
  125. // RedisDbconn.Instance.Clear("TotalUser*");
  126. // RedisDbconn.Instance.Clear("TeamTotalUser*");
  127. // RedisDbconn.Instance.Clear("AddUser*");
  128. // RedisDbconn.Instance.Clear("TeamAddUser*");
  129. // RedisDbconn.Instance.Clear("TotalPosMerchant*");
  130. // RedisDbconn.Instance.Clear("TeamTotalPosMerchant*");
  131. RedisDbconn.Instance.Clear("MerTotalAmount*");
  132. }
  133. // 1. 前一天的绑定记录和创客信息匹配,设置商户型创客
  134. public void dosomething1(string date)
  135. {
  136. // TODO: 每天扫描非商户型创客的持有机具数量
  137. SpModels.WebCMSEntities spdb = new SpModels.WebCMSEntities();
  138. WebCMSEntities db = new WebCMSEntities();
  139. DateTime yesterday = DateTime.Parse(date + " 00:00:00");
  140. DateTime today = DateTime.Parse(DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00");
  141. List<SpModels.BindRecord> binds = spdb.BindRecord.Where(m => m.CreateTime >= yesterday && m.CreateTime < today).ToList();
  142. foreach (SpModels.BindRecord bind in binds)
  143. {
  144. string Mobile = bind.MerNewSnNo;
  145. string MerNo = bind.MerNo;
  146. string BeforeNum = "";
  147. string AfterNum = "";
  148. if (Mobile.Contains("****") && Mobile.Length == 11)
  149. {
  150. BeforeNum = Mobile.Substring(0, 3);
  151. AfterNum = Mobile.Substring(7);
  152. }
  153. string Name = bind.MerName;
  154. if (bind.ProductType == "2")
  155. {
  156. if (Name.Contains("-"))
  157. {
  158. Name = Name.Split('-')[1];
  159. }
  160. else if (Name.Contains("_"))
  161. {
  162. Name = Name.Split('_')[1];
  163. }
  164. }
  165. else if (bind.ProductType == "4")
  166. {
  167. Name = bind.SeoTitle;
  168. }
  169. PxcModels.Users user = db.Users.FirstOrDefault(m => m.Mobile.StartsWith(BeforeNum) && m.Mobile.EndsWith(AfterNum) && m.RealName == Name && m.AuthFlag == 1 && m.MerchantType == 0);
  170. if (user != null)
  171. {
  172. bool checkPos = db.PosMachinesTwo.Any(m => m.UserId == user.Id);
  173. if (!checkPos)
  174. {
  175. PxcModels.MachineForSnNo forSnNo = db.MachineForSnNo.FirstOrDefault(m => m.SnNo == bind.MerSnNo) ?? new PxcModels.MachineForSnNo();
  176. PxcModels.PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == forSnNo.SnId && m.UserId != user.Id);
  177. if (pos != null)
  178. {
  179. pos.UserId = user.Id;
  180. user.MerchantType = 1;
  181. PxcModels.PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.KqMerNo == MerNo) ?? new PxcModels.PosMerchantInfo();
  182. merchant.UserId = user.Id;
  183. merchant.MerUserType = 1;
  184. pos.SeoTitle = user.Id.ToString(); // 记录商户型创客的Id
  185. db.SaveChanges();
  186. }
  187. }
  188. }
  189. }
  190. spdb.Dispose();
  191. db.Dispose();
  192. }
  193. // 1. 前一天的商户型创客,判断名下是否3台激活机器,是则变为非商户型创客
  194. public void dosomething11(string date)
  195. {
  196. WebCMSEntities db = new WebCMSEntities();
  197. DateTime yesterday = DateTime.Parse(date + " 00:00:00");
  198. DateTime today = DateTime.Parse(DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00");
  199. var users = db.Users.Select(m => new { m.Id, m.MerchantType }).Where(m => m.MerchantType == 1).ToList();
  200. foreach (var user in users)
  201. {
  202. int machineCount = db.PosMachinesTwo.Count(m => m.UserId == user.Id && m.PosSnType == 0);
  203. int couponCount = db.PosCoupons.Count(m => m.UserId == user.Id && m.IsUse == 0); //判断是否拥有3张券
  204. if (machineCount + couponCount >= 3)
  205. {
  206. Users edit = db.Users.FirstOrDefault(m => m.Id == user.Id);
  207. if (edit != null)
  208. {
  209. edit.MerchantType = 0;
  210. db.SaveChanges();
  211. }
  212. }
  213. }
  214. db.Dispose();
  215. }
  216. public void testStatTrade(string date)
  217. {
  218. string yesterday = date + " 00:00:00";
  219. string today = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  220. string TradeMonth = DateTime.Parse(date).ToString("yyyyMM");
  221. string TradeDate = DateTime.Parse(date).ToString("yyyyMMdd");
  222. 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");
  223. foreach (DataRow dr in dt.Rows)
  224. {
  225. int UserId = int.Parse(dr["UserId"].ToString()); //创客ID
  226. int BrandId = int.Parse(dr["BrandId"].ToString()); //品牌
  227. int MerchantId = int.Parse(dr["MerchantId"].ToString()); //商户Id
  228. int BankCardType = int.Parse(dr["BankCardType"].ToString()); //卡类型
  229. int QrPayFlag = int.Parse(dr["QrPayFlag"].ToString()); //云闪付
  230. decimal TradeAmount = decimal.Parse(dr[5].ToString()); //当日交易额
  231. string content = "{";
  232. content += "\"DateString\":\"" + date + "\",";
  233. content += "\"UserId\":\"" + UserId + "\",";
  234. content += "\"BrandId\":\"" + BrandId + "\",";
  235. content += "\"MerchantId\":\"" + MerchantId + "\",";
  236. content += "\"BankCardType\":\"" + BankCardType + "\",";
  237. content += "\"QrPayFlag\":\"" + QrPayFlag + "\",";
  238. content += "\"TradeAmount\":\"" + TradeAmount + "\"";
  239. content += "}";
  240. RedisDbconn.Instance.AddList("TradeStatQueueTest", content);
  241. }
  242. }
  243. // 3. 前一天的激活记录,根据创客类型,如果是商户型创客,则激活奖励的起始人从此人上级计算。如果不是,则从此人开始计算
  244. public void dosomething3(int posid = 0)
  245. {
  246. WebCMSEntities db = new WebCMSEntities();
  247. DateTime yesterday = DateTime.Now.AddDays(-1);
  248. DateTime today = DateTime.Now;
  249. IQueryable<PosMachinesTwo> posList = db.PosMachinesTwo.Where(m => m.ActivationState == 1 && !string.IsNullOrEmpty(m.SeoKeyword) && m.Detail != "1");
  250. if (posid > 0)
  251. {
  252. posList = posList.Where(m => m.Id == posid);
  253. }
  254. else
  255. {
  256. posList = posList.Where(m => m.ActivationTime >= yesterday && m.ActivationTime < today);
  257. }
  258. foreach (PosMachinesTwo pos in posList.ToList())
  259. {
  260. // PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId && !string.IsNullOrEmpty(m.MerIdcardNo));
  261. // PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId && m.Sort == 1);
  262. PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  263. if (merchant != null && pos.ActivationTime.Value <= pos.BindingTime.Value.AddDays(30))
  264. {
  265. // PosMerchantOtherInfo otherInfo = db.PosMerchantOtherInfo.FirstOrDefault(m => m.CertId == merchant.MerIdcardNo && m.PrizeFlag1 == 0);
  266. // if (otherInfo != null)
  267. // {
  268. // otherInfo.PrizeFlag1 = 1;
  269. // db.SaveChanges();
  270. string ParentNav = "";
  271. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  272. if (user != null)
  273. {
  274. int GetUserId = user.Id;
  275. ParentNav = user.ParentNav;
  276. int TopUserId = 0;
  277. if (!string.IsNullOrEmpty(ParentNav))
  278. {
  279. TopUserId = int.Parse(ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  280. }
  281. decimal ActPrize = decimal.Parse(function.CheckNum(pos.SeoKeyword));
  282. if (pos.BrandId == 1 || pos.BrandId == 3 || pos.BrandId == 4 || pos.BrandId == 5 || pos.BrandId == 6 || pos.BrandId == 8 || pos.BrandId == 9)
  283. {
  284. ActPrize = ActPrize / 100;
  285. }
  286. if (ActPrize > 0)
  287. {
  288. if (ActPrize == 99)
  289. {
  290. ActPrize = 100;
  291. }
  292. else if (ActPrize == 199)
  293. {
  294. ActPrize = 200;
  295. }
  296. else if (ActPrize == 299)
  297. {
  298. ActPrize = 300;
  299. }
  300. else if (ActPrize == 249)
  301. {
  302. ActPrize = 260;
  303. }
  304. if (GetUserId > 0)
  305. {
  306. doActiveReward(db, merchant, pos, GetUserId, ParentNav, TopUserId, ActPrize);
  307. doJk30(db, pos, merchant, GetUserId, ParentNav, TopUserId);
  308. }
  309. }
  310. else if(ActPrize == 0)
  311. {
  312. if(pos.BrandId == 6)
  313. {
  314. doActiveReward(db, merchant, pos, GetUserId, ParentNav, TopUserId, 50);
  315. }
  316. }
  317. PosMachinesTwo edit = db.PosMachinesTwo.FirstOrDefault(m => m.Id == pos.Id);
  318. if(edit != null)
  319. {
  320. edit.Detail = "1";
  321. db.SaveChanges();
  322. }
  323. }
  324. // }
  325. }
  326. }
  327. db.Dispose();
  328. }
  329. //金控活动机返奖励
  330. private void doJk30(WebCMSEntities db, PosMachinesTwo pos, PosMerchantInfo merchant, int GetUserId, string ParentNav, int TopUserId)
  331. {
  332. // DateTime start = DateTime.Parse("2022-04-06 00:00:00");
  333. // DateTime end = DateTime.Parse("2022-07-05 00:00:00");
  334. // if((pos.BrandId == 1 || pos.BrandId == 3) && pos.CreateDate >= start && pos.CreateDate < end)
  335. // {
  336. // decimal amt = 0;
  337. // if(DateTime.Now < DateTime.Parse("2023-05-01 00:00:00"))
  338. // {
  339. // amt = 10;
  340. // }
  341. // if(amt > 0)
  342. // {
  343. // doActiveReward(db, merchant, pos, GetUserId, ParentNav, TopUserId, amt, 0, 1);
  344. // }
  345. // }
  346. }
  347. //无押金激活奖励
  348. public void activePrizeWithoutDeposit(int posid = 0)
  349. {
  350. WebCMSEntities db = new WebCMSEntities();
  351. DateTime yesterday = DateTime.Now.AddDays(-1);
  352. DateTime today = DateTime.Now.AddMinutes(-5);
  353. IQueryable<PosMachinesTwo> posList = db.PosMachinesTwo.Where(m => m.ActivationState == 1 && string.IsNullOrEmpty(m.SeoKeyword) && m.BrandId != 12 && m.BrandId != 13 && m.Detail != "1");
  354. if (posid > 0)
  355. {
  356. posList = posList.Where(m => m.Id == posid);
  357. }
  358. else
  359. {
  360. posList = posList.Where(m => m.ActivationTime >= yesterday && m.ActivationTime < today);
  361. }
  362. foreach (PosMachinesTwo pos in posList.ToList())
  363. {
  364. PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  365. if (merchant != null)
  366. {
  367. string ParentNav = "";
  368. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  369. if (user != null)
  370. {
  371. int GetUserId = user.Id;
  372. ParentNav = user.ParentNav;
  373. int TopUserId = 0;
  374. if (!string.IsNullOrEmpty(ParentNav))
  375. {
  376. TopUserId = int.Parse(ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  377. }
  378. // if(pos.BrandId == 6) //首台无押金机返50
  379. // {
  380. // doActiveReward(db, merchant, pos, GetUserId, ParentNav, TopUserId, 50);
  381. // }
  382. else if((pos.BrandId == 10 || pos.BrandId == 11) && DateTime.Now < DateTime.Parse("2023-05-01 00:00:00") && pos.IsFirst == 1) //首台无押金机返50
  383. {
  384. doActiveReward(db, merchant, pos, GetUserId, ParentNav, TopUserId, 50);
  385. }
  386. else
  387. {
  388. //金控活动机返奖励
  389. doJk30(db, pos, merchant, GetUserId, ParentNav, TopUserId);
  390. }
  391. PosMachinesTwo edit = db.PosMachinesTwo.FirstOrDefault(m => m.Id == pos.Id);
  392. if(edit != null)
  393. {
  394. edit.Detail = "1";
  395. db.SaveChanges();
  396. }
  397. }
  398. }
  399. }
  400. db.Dispose();
  401. }
  402. public void activePrizeWithoutDeposit12(int posid = 0)
  403. {
  404. WebCMSEntities db = new WebCMSEntities();
  405. DateTime yesterday = DateTime.Now.AddDays(-30);
  406. DateTime today = DateTime.Now.AddMinutes(-5);
  407. 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");
  408. if (posid > 0)
  409. {
  410. posList = posList.Where(m => m.Id == posid);
  411. }
  412. else
  413. {
  414. posList = posList.Where(m => m.ActivationTime >= yesterday && m.ActivationTime < today);
  415. }
  416. foreach (PosMachinesTwo pos in posList.ToList())
  417. {
  418. PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  419. if (merchant != null)
  420. {
  421. string ParentNav = "";
  422. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  423. if (user != null)
  424. {
  425. int GetUserId = user.Id;
  426. ParentNav = user.ParentNav;
  427. int TopUserId = 0;
  428. if (!string.IsNullOrEmpty(ParentNav))
  429. {
  430. TopUserId = int.Parse(ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  431. }
  432. //首台无押金机返50
  433. doActiveReward(db, merchant, pos, GetUserId, ParentNav, TopUserId, 50);
  434. PosMachinesTwo item = db.PosMachinesTwo.FirstOrDefault(m => m.Id == pos.Id);
  435. if(item != null)
  436. {
  437. item.Detail = "1";
  438. db.SaveChanges();
  439. }
  440. }
  441. }
  442. }
  443. db.Dispose();
  444. }
  445. public void activePrizeWithoutDeposit122(int posid = 0)
  446. {
  447. WebCMSEntities db = new WebCMSEntities();
  448. DateTime yesterday = DateTime.Now.AddDays(-30);
  449. DateTime today = DateTime.Now.AddMinutes(-5);
  450. DateTime checkTime = DateTime.Parse("2023-08-01 00:00:00");
  451. 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");
  452. if (posid > 0)
  453. {
  454. posList = posList.Where(m => m.Id == posid);
  455. }
  456. else
  457. {
  458. posList = posList.Where(m => m.ActivationTime >= yesterday && m.ActivationTime < today);
  459. }
  460. foreach (PosMachinesTwo pos in posList.ToList())
  461. {
  462. PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  463. if (merchant != null)
  464. {
  465. string ParentNav = "";
  466. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  467. if (user != null)
  468. {
  469. int GetUserId = user.Id;
  470. ParentNav = user.ParentNav;
  471. int TopUserId = 0;
  472. if (!string.IsNullOrEmpty(ParentNav))
  473. {
  474. TopUserId = int.Parse(ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  475. }
  476. string IdCard = merchant.MerIdcardNo;
  477. string IdCardStart = IdCard.Substring(0, 6);
  478. string IdCardEnd = IdCard.Substring(IdCard.Length - 4);
  479. string MerName = merchant.MerchantName;
  480. List<int> BrandIds = new List<int>();
  481. BrandIds.Add(4);
  482. BrandIds.Add(5);
  483. BrandIds.Add(8);
  484. BrandIds.Add(9);
  485. PosMerchantInfo other = db.PosMerchantInfo.FirstOrDefault(m => m.MerIdcardNo.StartsWith(IdCardStart) && m.MerIdcardNo.EndsWith(IdCardEnd) && m.MerchantName.Contains(MerName) && BrandIds.Contains(m.BrandId));
  486. if(other != null)
  487. {
  488. PosMachinesTwo checkpos = db.PosMachinesTwo.FirstOrDefault(m => m.PosSn == other.KqSnNo && m.IsFirst == 1);
  489. if(checkpos != null)
  490. {
  491. doActiveReward(db, merchant, pos, GetUserId, ParentNav, TopUserId, 50);
  492. PosMachinesTwo edit = db.PosMachinesTwo.FirstOrDefault(m => m.Id == pos.Id);
  493. if(edit != null)
  494. {
  495. edit.SeoKeyword = checkpos.SeoKeyword;
  496. edit.UpFeeFlag = checkpos.UpFeeFlag;
  497. edit.DownFeeFlag = checkpos.DownFeeFlag;
  498. edit.UpFeeDate = checkpos.UpFeeDate;
  499. edit.DownFeeDate = checkpos.DownFeeDate;
  500. edit.BindingTime = checkpos.BindingTime;
  501. edit.IsFirst = checkpos.IsFirst;
  502. db.SaveChanges();
  503. if(edit.UpFeeFlag == 1 && edit.DownFeeFlag == 0)
  504. {
  505. string info = "{\"RecordId\":\"\",\"PosId\":\"" + edit.Id + "\",\"Fee\": \"0.63\",\"Kind\": \"1\",\"OpMan\": \"系统\"}";
  506. RedisDbconn.Instance.AddList("SetDepositPostQueue", info);
  507. }
  508. }
  509. }
  510. }
  511. PosMachinesTwo item = db.PosMachinesTwo.FirstOrDefault(m => m.Id == pos.Id);
  512. if(item != null)
  513. {
  514. item.Detail = "1";
  515. db.SaveChanges();
  516. }
  517. }
  518. }
  519. }
  520. db.Dispose();
  521. }
  522. public void doActiveReward(WebCMSEntities db, PosMerchantInfo merchant, PosMachinesTwo pos, int GetUserId, string ParentNav, int TopUserId, decimal ActPrize, int ChangeType = 0, int ActType = 0)
  523. {
  524. bool check = db.ActiveReward.Any(m => m.KqMerNo == merchant.KqMerNo && m.RewardAmount == ActPrize);
  525. bool check1 = db.ActiveReward.Any(m => m.KqSnNo == pos.PosSn && m.RewardAmount == ActPrize);
  526. if (!check && !check1)
  527. {
  528. function.WriteLog(DateTime.Now.ToString() + ":" + pos.PosSn, "实时处理激活奖励");
  529. Users machineUser = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new Users();
  530. db.ActiveReward.Add(new ActiveReward()
  531. {
  532. CreateDate = DateTime.Now,
  533. UpdateDate = DateTime.Now,
  534. UserId = GetUserId, //创客
  535. MerchantId = pos.BindMerchantId, //商户
  536. StandardDate = pos.ActivationTime, //达标日期
  537. RewardAmount = ActPrize, //奖励金额
  538. BrandId = pos.BrandId, //品牌
  539. UserNav = ParentNav, //创客父级
  540. DirectBuddyNo = merchant.UserId, //商户直属创客
  541. KqMerNo = merchant.KqMerNo, //渠道商户编号
  542. KqSnNo = pos.PosSn, //渠道SN号
  543. SnType = pos.PosSnType, //机具类型
  544. SnApplyUserId = pos.BuyUserId, //机具申请创客
  545. ActType = ActType, //激活类型
  546. SnStoreId = pos.StoreId, //SN仓库
  547. RewardTips = "激活奖励", //奖励描述
  548. Remark = "激活奖励", //备注
  549. ActDate = pos.ActivationTime, //激活时间
  550. TopUserId = TopUserId, //顶级创客
  551. SeoTitle = machineUser.RealName,
  552. });
  553. db.SaveChanges();
  554. string IdBrand = GetUserId + "_" + pos.BrandId;
  555. UserMachineData userData = db.UserMachineData.FirstOrDefault(m => m.IdBrand == IdBrand);
  556. if (userData == null)
  557. {
  558. userData = db.UserMachineData.Add(new UserMachineData()
  559. {
  560. IdBrand = IdBrand,
  561. }).Entity;
  562. db.SaveChanges();
  563. }
  564. userData.ActProfit += ActPrize;
  565. db.SaveChanges();
  566. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == GetUserId);
  567. if (account == null)
  568. {
  569. account = db.UserAccount.Add(new UserAccount()
  570. {
  571. Id = GetUserId,
  572. UserId = GetUserId,
  573. }).Entity;
  574. db.SaveChanges();
  575. }
  576. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  577. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  578. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  579. account.BalanceAmount += ActPrize;
  580. account.TotalAmount += ActPrize;
  581. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  582. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  583. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  584. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  585. {
  586. CreateDate = DateTime.Now,
  587. UpdateDate = DateTime.Now,
  588. UserId = GetUserId, //创客
  589. ChangeType = ChangeType, //变动类型
  590. ProductType = pos.BrandId, //产品类型
  591. ChangeAmount = ActPrize, //变更金额
  592. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  593. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  594. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  595. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  596. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  597. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  598. }).Entity;
  599. db.SaveChanges();
  600. string dateString = pos.ActivationTime.Value.ToString("yyyyMMdd");
  601. string monthString = pos.ActivationTime.Value.ToString("yyyyMM");
  602. // 激活奖励列表
  603. List<string> dates = RedisDbconn.Instance.GetList<string>("ActiveRewardDay:" + GetUserId + ":" + pos.BrandId);
  604. if (!dates.Contains(dateString))
  605. {
  606. RedisDbconn.Instance.AddList("ActiveRewardDay:" + GetUserId + ":" + pos.BrandId, dateString);
  607. }
  608. RedisDbconn.Instance.AddNumber("ActiveRewardAmt:" + GetUserId + ":" + pos.BrandId + ":" + dateString, ActPrize);
  609. List<string> months = RedisDbconn.Instance.GetList<string>("ActiveRewardMonth:" + GetUserId + ":" + pos.BrandId);
  610. if (!months.Contains(monthString))
  611. {
  612. RedisDbconn.Instance.AddList("ActiveRewardMonth:" + GetUserId + ":" + pos.BrandId, monthString);
  613. }
  614. RedisDbconn.Instance.AddNumber("ActiveRewardAmt:" + GetUserId + ":" + pos.BrandId + ":" + monthString, ActPrize);
  615. // 激活奖励详情
  616. List<int> actPrizeList = RedisDbconn.Instance.GetList<int>("ActiveRewardDetail:" + GetUserId + ":" + pos.BrandId + ":" + dateString);
  617. if (!actPrizeList.Contains(pos.BindMerchantId))
  618. {
  619. RedisDbconn.Instance.AddList("ActiveRewardDetail:" + GetUserId + ":" + pos.BrandId + ":" + dateString, pos.BindMerchantId);
  620. }
  621. RedisDbconn.Instance.AddNumber("ActiveRewardAmt:mer:" + pos.BindMerchantId + ":" + pos.BrandId + ":" + dateString, ActPrize);
  622. //收支明细
  623. RedisDbconn.Instance.Clear("UserAccount:Income:" + GetUserId + ":" + monthString);
  624. }
  625. }
  626. //根据商户信息发放激活奖励
  627. public void dosomething32(int merid = 0)
  628. {
  629. WebCMSEntities db = new WebCMSEntities();
  630. DateTime yesterday = DateTime.Now.AddHours(-3);
  631. DateTime today = DateTime.Now;
  632. IQueryable<PosMerchantInfo> merList = db.PosMerchantInfo.Where(m => m.ActiveStatus == 1 && !string.IsNullOrEmpty(m.SeoKeyword));
  633. if (merid > 0)
  634. {
  635. merList = merList.Where(m => m.Id == merid);
  636. }
  637. else
  638. {
  639. merList = merList.Where(m => m.MerStandardDate >= yesterday && m.MerStandardDate < today);
  640. }
  641. foreach (PosMerchantInfo merchant in merList.ToList())
  642. {
  643. // PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId && !string.IsNullOrEmpty(m.MerIdcardNo));
  644. // PosMerchantOtherInfo otherInfo = db.PosMerchantOtherInfo.FirstOrDefault(m => m.CertId == merchant.MerIdcardNo && m.PrizeFlag1 == 0);
  645. // if (otherInfo != null)
  646. // {
  647. // otherInfo.PrizeFlag1 = 1;
  648. // db.SaveChanges();
  649. MachineForMerNo forMerNo = db.MachineForMerNo.FirstOrDefault(m => m.MerNo == merchant.MerchantNo) ?? new MachineForMerNo();
  650. PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == forMerNo.SnId) ?? new PosMachinesTwo();
  651. string ParentNav = "";
  652. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  653. if (user != null)
  654. {
  655. int GetUserId = user.Id;
  656. ParentNav = user.ParentNav;
  657. int TopUserId = 0;
  658. if (!string.IsNullOrEmpty(ParentNav))
  659. {
  660. TopUserId = int.Parse(ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  661. }
  662. decimal ActPrize = decimal.Parse(function.CheckNum(merchant.SeoKeyword));
  663. if (pos.BrandId == 1 || pos.BrandId == 3 || pos.BrandId == 4 || pos.BrandId == 5 || pos.BrandId == 6 || pos.BrandId == 8 || pos.BrandId == 9)
  664. {
  665. ActPrize = ActPrize / 100;
  666. }
  667. if (ActPrize > 0)
  668. {
  669. bool check = db.ActiveReward.Any(m => m.KqSnNo == pos.PosSn);
  670. if (!check)
  671. {
  672. if (ActPrize == 99)
  673. {
  674. ActPrize = 100;
  675. }
  676. else if (ActPrize == 199)
  677. {
  678. ActPrize = 200;
  679. }
  680. else if (ActPrize == 299)
  681. {
  682. ActPrize = 300;
  683. }
  684. Users machineUser = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new Users();
  685. db.ActiveReward.Add(new ActiveReward()
  686. {
  687. CreateDate = DateTime.Now,
  688. UpdateDate = DateTime.Now,
  689. UserId = GetUserId, //创客
  690. MerchantId = pos.BindMerchantId, //商户
  691. StandardDate = pos.ActivationTime, //达标日期
  692. RewardAmount = ActPrize, //奖励金额
  693. BrandId = pos.BrandId, //品牌
  694. UserNav = ParentNav, //创客父级
  695. DirectBuddyNo = merchant.UserId, //商户直属创客
  696. KqMerNo = merchant.KqMerNo, //渠道商户编号
  697. KqSnNo = pos.PosSn, //渠道SN号
  698. SnType = pos.PosSnType, //机具类型
  699. SnApplyUserId = pos.BuyUserId, //机具申请创客
  700. ActType = 0, //激活类型
  701. SnStoreId = pos.StoreId, //SN仓库
  702. RewardTips = "激活奖励", //奖励描述
  703. Remark = "激活奖励", //备注
  704. ActDate = pos.ActivationTime, //激活时间
  705. TopUserId = TopUserId, //顶级创客
  706. SeoTitle = machineUser.RealName,
  707. });
  708. db.SaveChanges();
  709. string IdBrand = GetUserId + "_" + pos.BrandId;
  710. UserMachineData userData = db.UserMachineData.FirstOrDefault(m => m.IdBrand == IdBrand);
  711. if (userData == null)
  712. {
  713. userData = db.UserMachineData.Add(new UserMachineData()
  714. {
  715. IdBrand = IdBrand,
  716. }).Entity;
  717. db.SaveChanges();
  718. }
  719. userData.ActProfit += ActPrize;
  720. db.SaveChanges();
  721. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == GetUserId);
  722. if (account == null)
  723. {
  724. account = db.UserAccount.Add(new UserAccount()
  725. {
  726. Id = GetUserId,
  727. UserId = GetUserId,
  728. }).Entity;
  729. db.SaveChanges();
  730. }
  731. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  732. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  733. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  734. account.BalanceAmount += ActPrize;
  735. account.TotalAmount += ActPrize;
  736. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  737. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  738. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  739. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  740. {
  741. CreateDate = DateTime.Now,
  742. UpdateDate = DateTime.Now,
  743. UserId = GetUserId, //创客
  744. ChangeType = 0, //变动类型
  745. ProductType = pos.BrandId, //产品类型
  746. ChangeAmount = ActPrize, //变更金额
  747. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  748. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  749. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  750. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  751. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  752. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  753. }).Entity;
  754. db.SaveChanges();
  755. string dateString = pos.ActivationTime.Value.ToString("yyyyMMdd");
  756. string monthString = pos.ActivationTime.Value.ToString("yyyyMM");
  757. // 激活奖励列表
  758. List<string> dates = RedisDbconn.Instance.GetList<string>("ActiveRewardDay:" + GetUserId + ":" + pos.BrandId);
  759. if (!dates.Contains(dateString))
  760. {
  761. RedisDbconn.Instance.AddList("ActiveRewardDay:" + GetUserId + ":" + pos.BrandId, dateString);
  762. }
  763. RedisDbconn.Instance.AddNumber("ActiveRewardAmt:" + GetUserId + ":" + pos.BrandId + ":" + dateString, ActPrize);
  764. List<string> months = RedisDbconn.Instance.GetList<string>("ActiveRewardMonth:" + GetUserId + ":" + pos.BrandId);
  765. if (!months.Contains(monthString))
  766. {
  767. RedisDbconn.Instance.AddList("ActiveRewardMonth:" + GetUserId + ":" + pos.BrandId, monthString);
  768. }
  769. RedisDbconn.Instance.AddNumber("ActiveRewardAmt:" + GetUserId + ":" + pos.BrandId + ":" + monthString, ActPrize);
  770. // 激活奖励详情
  771. List<int> actPrizeList = RedisDbconn.Instance.GetList<int>("ActiveRewardDetail:" + GetUserId + ":" + pos.BrandId + ":" + dateString);
  772. if (!actPrizeList.Contains(pos.BindMerchantId))
  773. {
  774. RedisDbconn.Instance.AddList("ActiveRewardDetail:" + GetUserId + ":" + pos.BrandId + ":" + dateString, pos.BindMerchantId);
  775. }
  776. RedisDbconn.Instance.AddNumber("ActiveRewardAmt:mer:" + pos.BindMerchantId + ":" + pos.BrandId + ":" + dateString, ActPrize);
  777. }
  778. }
  779. }
  780. // }
  781. }
  782. db.Dispose();
  783. }
  784. //3. 前一天的激活记录,根据创客类型,如果是商户型创客,则开机奖励的起始人从此人上级计算。如果不是,则从此人开始计算
  785. public void dosomething4(string date)
  786. {
  787. WebCMSEntities db = new WebCMSEntities();
  788. DateTime yesterday = DateTime.Parse(date + " 00:00:00");
  789. DateTime today = DateTime.Parse(DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00");
  790. 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();
  791. foreach (PosMachinesTwo pos in posList)
  792. {
  793. if (pos.BindingTime > DateTime.Now.AddDays(-30))
  794. {
  795. decimal ActPrize = decimal.Parse(function.CheckNum(pos.SeoKeyword));
  796. if (ActPrize > 0)
  797. {
  798. // PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId && !string.IsNullOrEmpty(m.MerIdcardNo));
  799. // PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId && m.Sort == 1);
  800. PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  801. if (merchant != null)
  802. {
  803. // PosMerchantOtherInfo otherInfo = db.PosMerchantOtherInfo.FirstOrDefault(m => m.CertId == merchant.MerIdcardNo && m.PrizeFlag2 == 0);
  804. // if (otherInfo != null)
  805. // {
  806. // otherInfo.PrizeFlag2 = 1;
  807. // db.SaveChanges();
  808. // 从机具所属人上级开始分开机奖励
  809. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  810. if (user != null)
  811. {
  812. if (!string.IsNullOrEmpty(user.ParentNav))
  813. {
  814. decimal Prize = 20;
  815. string[] ParentNavs = user.ParentNav.Trim(',').Replace(",,", ",").Split(',');
  816. for (int i = ParentNavs.Length - 1; i >= 0; i--)
  817. {
  818. int UserId = int.Parse(ParentNavs[i]);
  819. Users puser = db.Users.FirstOrDefault(m => m.Id == UserId && m.AuthFlag == 1);
  820. if (puser != null && Prize > 0)
  821. {
  822. int machineCount = db.PosMachinesTwo.Count(m => m.BuyUserId == puser.Id && m.PosSnType == 0 && m.ActivationState == 0); //判断是否拥有3台兑换机
  823. int ActiveCount = db.PosMachinesTwo.Count(m => m.BuyUserId == puser.Id && m.ActivationState == 1); //判断是否拥有3台激活机(不限购买或赠送)
  824. int couponCount = db.PosCoupons.Count(m => m.UserId == puser.Id && m.IsUse == 0); //判断是否拥有3张券
  825. // int BigCount = db.PosMachinesTwo.Count(m => m.UserId == puser.Id && m.BrandId == 3); //判断是否拥有2台大机
  826. // int BigActiveCount = db.PosMachinesTwo.Count(m => m.UserId == puser.Id && m.ActivationState == 1 && m.BrandId == 3); //判断是否拥有2台激活大机(不限购买或赠送)
  827. if (machineCount + ActiveCount + couponCount >= 3)
  828. {
  829. int pTopUserId = 0;
  830. if (!string.IsNullOrEmpty(puser.ParentNav))
  831. {
  832. pTopUserId = int.Parse(puser.ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  833. }
  834. Users machineUser = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new Users();
  835. OpenRewardDetail detail = db.OpenRewardDetail.Add(new OpenRewardDetail()
  836. {
  837. CreateDate = DateTime.Now,
  838. UpdateDate = DateTime.Now,
  839. TradeMonth = yesterday.ToString("yyyyMM"), //交易月
  840. TradeDate = yesterday, //达标日期
  841. UserId = puser.Id, //创客
  842. BrandId = pos.BrandId, //品牌
  843. ProductName = RelationClass.GetKqProductsInfo(pos.BrandId), //产品名称
  844. MerchantId = pos.BindMerchantId, //商户
  845. DirectUserId = merchant.UserId, //商户直属人
  846. SnNo = pos.PosSn, //SN号
  847. MerNo = merchant.KqMerNo, //渠道商户号
  848. SnType = pos.PosSnType, //机具类型
  849. StandardDate = pos.ActivationTime, //商户的激活日期
  850. SnStoreId = pos.StoreId, //SN仓库
  851. MerBuddyType = puser.MerchantType, //商户创客类型
  852. RewardType = 1, //奖励类型 1-开机直接奖励,2-开机间接奖励
  853. RewardTips = "开机奖励", //奖励描述
  854. CreditTradeAmt = pos.CreditTrade, //贷记卡交易总金额
  855. DebitTradeAmt = pos.DebitCardTrade, //借记卡交易总金额
  856. CreditRewardAmount = Prize, //贷记卡交易奖励金额
  857. RewardDesc = "开机奖励", //奖励描述
  858. TopUserId = pTopUserId, //顶级创客
  859. SeoTitle = machineUser.RealName,
  860. }).Entity;
  861. db.OpenReward.Add(new OpenReward()
  862. {
  863. CreateDate = DateTime.Now,
  864. UpdateDate = DateTime.Now,
  865. TradeMonth = yesterday.ToString("yyyyMM"), //交易月
  866. TradeDate = DateTime.Now, //达标日期
  867. UserId = puser.Id, //创客
  868. BrandId = pos.BrandId, //品牌
  869. RewardType = 2, //奖励类型
  870. CreditTradeAmt = pos.CreditTrade, //贷记卡交易总金额
  871. DebitTradeAmt = pos.DebitCardTrade, //借记卡交易总金额
  872. CreditRewardAmount = Prize, //贷记卡交易奖励金额
  873. RewardDesc = "开机奖励", //奖励描述
  874. TopUserId = pTopUserId, //顶级创客
  875. });
  876. string IdBrand = puser.Id + "_" + pos.BrandId;
  877. UserMachineData userData = db.UserMachineData.FirstOrDefault(m => m.IdBrand == IdBrand);
  878. if (userData == null)
  879. {
  880. userData = db.UserMachineData.Add(new UserMachineData()
  881. {
  882. IdBrand = IdBrand,
  883. }).Entity;
  884. db.SaveChanges();
  885. }
  886. userData.OpenProfit += Prize;
  887. db.SaveChanges();
  888. //账户入库
  889. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == puser.Id);
  890. if (account == null)
  891. {
  892. account = db.UserAccount.Add(new UserAccount()
  893. {
  894. Id = puser.Id,
  895. UserId = puser.Id,
  896. }).Entity;
  897. db.SaveChanges();
  898. }
  899. //收支明细入库
  900. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  901. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  902. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  903. account.BalanceAmount += Prize;
  904. account.TotalAmount += Prize;
  905. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  906. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  907. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  908. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  909. {
  910. CreateDate = DateTime.Now,
  911. UpdateDate = DateTime.Now,
  912. UserId = puser.Id, //创客
  913. ChangeType = 50, //变动类型
  914. ProductType = pos.BrandId, //产品类型
  915. ChangeAmount = Prize, //变更金额
  916. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  917. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  918. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  919. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  920. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  921. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  922. }).Entity;
  923. db.SaveChanges();
  924. string dateString = yesterday.ToString("yyyyMMdd");
  925. string monthString = yesterday.ToString("yyyyMM");
  926. // 开机奖励列表
  927. List<string> dates = RedisDbconn.Instance.GetList<string>("OpenRewardDay:" + puser.Id + ":" + pos.BrandId);
  928. if (!dates.Contains(dateString))
  929. {
  930. RedisDbconn.Instance.AddList("OpenRewardDay:" + puser.Id + ":" + pos.BrandId, dateString);
  931. }
  932. RedisDbconn.Instance.AddNumber("OpenRewardAmt:" + puser.Id + ":" + pos.BrandId + ":" + dateString, Prize);
  933. List<string> months = RedisDbconn.Instance.GetList<string>("OpenRewardMonth:" + puser.Id + ":" + pos.BrandId);
  934. if (!months.Contains(monthString))
  935. {
  936. RedisDbconn.Instance.AddList("OpenRewardMonth:" + puser.Id + ":" + pos.BrandId, monthString);
  937. }
  938. RedisDbconn.Instance.AddNumber("OpenRewardAmt:" + puser.Id + ":" + pos.BrandId + ":" + monthString, Prize);
  939. // 开机奖励详情
  940. RedisDbconn.Instance.AddList("OpenRewardDetail:" + puser.Id + ":" + pos.BrandId + ":" + dateString, detail);
  941. Prize = 0;
  942. }
  943. }
  944. }
  945. }
  946. }
  947. // }
  948. }
  949. }
  950. }
  951. }
  952. db.Dispose();
  953. }
  954. //实时获取开机奖励
  955. public void StartOpenReward()
  956. {
  957. Thread th = new Thread(StartOpenRewardDo);
  958. th.IsBackground = true;
  959. th.Start();
  960. }
  961. public void StartOpenRewardDo()
  962. {
  963. while(true)
  964. {
  965. string content = RedisDbconn.Instance.RPop<string>("OpenRewardQueue");
  966. if(!string.IsNullOrEmpty(content))
  967. {
  968. try
  969. {
  970. function.WriteLog("\n\n" + DateTime.Now.ToString() + "\nposid:" + content, "开机奖励发放日志");
  971. int PosId = int.Parse(content);
  972. Thread.Sleep(1000);
  973. WebCMSEntities db = new WebCMSEntities();
  974. PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == PosId && m.ActivationState == 1 && !string.IsNullOrEmpty(m.SeoKeyword) && m.SeoKeyword != "0" && m.CreditTrade >= 1000);
  975. if (pos != null)
  976. {
  977. function.WriteLog("sn:" + pos.PosSn, "开机奖励发放日志");
  978. if (pos.BindingTime > DateTime.Now.AddDays(-30))
  979. {
  980. decimal ActPrize = decimal.Parse(function.CheckNum(pos.SeoKeyword));
  981. function.WriteLog("押金:" + pos.SeoKeyword, "开机奖励发放日志");
  982. if (ActPrize > 0)
  983. {
  984. PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  985. if (merchant != null)
  986. {
  987. function.WriteLog("商户:" + merchant.KqMerNo, "开机奖励发放日志");
  988. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  989. if (user != null)
  990. {
  991. function.WriteLog("所属人:" + user.MakerCode, "开机奖励发放日志");
  992. if (!string.IsNullOrEmpty(user.ParentNav))
  993. {
  994. decimal Prize = 20;
  995. string[] ParentNavs = user.ParentNav.Trim(',').Replace(",,", ",").Split(',');
  996. for (int i = ParentNavs.Length - 1; i >= 0; i--)
  997. {
  998. int UserId = int.Parse(ParentNavs[i]);
  999. Users puser = db.Users.FirstOrDefault(m => m.Id == UserId && m.AuthFlag == 1 && m.Status > -1);
  1000. if (puser != null && Prize > 0)
  1001. {
  1002. function.WriteLog("上级:" + puser.MakerCode, "开机奖励发放日志");
  1003. // int machineCount = db.PosMachinesTwo.Count(m => m.BuyUserId == puser.Id && m.PosSnType == 0 && m.ActivationState == 0); //判断是否拥有3台兑换机
  1004. // int ActiveCount = db.PosMachinesTwo.Count(m => m.BuyUserId == puser.Id && m.ActivationState == 1); //判断是否拥有3台激活机(不限购买或赠送)
  1005. // int couponCount = db.PosCoupons.Count(m => m.UserId == puser.Id && m.IsUse == 0); //判断是否拥有3张券
  1006. // int BigCount = db.PosMachinesTwo.Count(m => m.UserId == puser.Id && m.BrandId == 3); //判断是否拥有2台大机
  1007. // int BigActiveCount = db.PosMachinesTwo.Count(m => m.UserId == puser.Id && m.ActivationState == 1 && m.BrandId == 3); //判断是否拥有2台激活大机(不限购买或赠送)
  1008. // function.WriteLog("条件:machineCount:" + machineCount + ",ActiveCount:" + ActiveCount + ",couponCount:" + couponCount + "", "开机奖励发放日志");
  1009. // if (machineCount + ActiveCount + couponCount >= 3)
  1010. function.WriteLog("条件:LeaderLevel:" + puser.LeaderLevel + ",UserType:" + puser.UserType, "开机奖励发放日志");
  1011. if(puser.LeaderLevel > 0 || puser.UserType == 1)
  1012. {
  1013. bool leaderOp = true;
  1014. if(puser.LeaderLevel > 0 && puser.UserType == 0)
  1015. {
  1016. DateTime now = DateTime.Now;
  1017. leaderOp = db.Leaders.Any(m => m.Id == puser.Id && m.ExpiredDate >= now);
  1018. function.WriteLog("条件:leaderOp:" + leaderOp, "开机奖励发放日志");
  1019. }
  1020. if(leaderOp)
  1021. {
  1022. function.WriteLog("满足条件", "开机奖励发放日志");
  1023. int pTopUserId = 0;
  1024. if (!string.IsNullOrEmpty(puser.ParentNav))
  1025. {
  1026. pTopUserId = int.Parse(puser.ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  1027. }
  1028. Users machineUser = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new Users();
  1029. OpenRewardDetail detail = db.OpenRewardDetail.Add(new OpenRewardDetail()
  1030. {
  1031. CreateDate = DateTime.Now,
  1032. UpdateDate = DateTime.Now,
  1033. TradeMonth = DateTime.Now.ToString("yyyyMM"), //交易月
  1034. TradeDate = DateTime.Now, //达标日期
  1035. UserId = puser.Id, //创客
  1036. BrandId = pos.BrandId, //品牌
  1037. ProductName = RelationClass.GetKqProductsInfo(pos.BrandId), //产品名称
  1038. MerchantId = pos.BindMerchantId, //商户
  1039. DirectUserId = merchant.UserId, //商户直属人
  1040. SnNo = pos.PosSn, //SN号
  1041. MerNo = merchant.KqMerNo, //渠道商户号
  1042. SnType = pos.PosSnType, //机具类型
  1043. StandardDate = pos.ActivationTime, //商户的激活日期
  1044. SnStoreId = pos.StoreId, //SN仓库
  1045. MerBuddyType = puser.MerchantType, //商户创客类型
  1046. RewardType = 1, //奖励类型 1-开机直接奖励,2-开机间接奖励
  1047. RewardTips = "开机奖励", //奖励描述
  1048. CreditTradeAmt = pos.CreditTrade, //贷记卡交易总金额
  1049. DebitTradeAmt = pos.DebitCardTrade, //借记卡交易总金额
  1050. CreditRewardAmount = Prize, //贷记卡交易奖励金额
  1051. RewardDesc = "开机奖励", //奖励描述
  1052. TopUserId = pTopUserId, //顶级创客
  1053. SeoTitle = machineUser.RealName,
  1054. }).Entity;
  1055. db.OpenReward.Add(new OpenReward()
  1056. {
  1057. CreateDate = DateTime.Now,
  1058. UpdateDate = DateTime.Now,
  1059. TradeMonth = DateTime.Now.ToString("yyyyMM"), //交易月
  1060. TradeDate = DateTime.Now, //达标日期
  1061. UserId = puser.Id, //创客
  1062. BrandId = pos.BrandId, //品牌
  1063. RewardType = 2, //奖励类型
  1064. CreditTradeAmt = pos.CreditTrade, //贷记卡交易总金额
  1065. DebitTradeAmt = pos.DebitCardTrade, //借记卡交易总金额
  1066. CreditRewardAmount = Prize, //贷记卡交易奖励金额
  1067. RewardDesc = "开机奖励", //奖励描述
  1068. TopUserId = pTopUserId, //顶级创客
  1069. });
  1070. string IdBrand = puser.Id + "_" + pos.BrandId;
  1071. UserMachineData userData = db.UserMachineData.FirstOrDefault(m => m.IdBrand == IdBrand);
  1072. if (userData == null)
  1073. {
  1074. userData = db.UserMachineData.Add(new UserMachineData()
  1075. {
  1076. IdBrand = IdBrand,
  1077. }).Entity;
  1078. db.SaveChanges();
  1079. }
  1080. userData.OpenProfit += Prize;
  1081. db.SaveChanges();
  1082. //账户入库
  1083. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == puser.Id);
  1084. if (account == null)
  1085. {
  1086. account = db.UserAccount.Add(new UserAccount()
  1087. {
  1088. Id = puser.Id,
  1089. UserId = puser.Id,
  1090. }).Entity;
  1091. db.SaveChanges();
  1092. }
  1093. //收支明细入库
  1094. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  1095. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  1096. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  1097. account.BalanceAmount += Prize;
  1098. account.TotalAmount += Prize;
  1099. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  1100. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  1101. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  1102. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  1103. {
  1104. CreateDate = DateTime.Now,
  1105. UpdateDate = DateTime.Now,
  1106. UserId = puser.Id, //创客
  1107. ChangeType = 50, //变动类型
  1108. ProductType = pos.BrandId, //产品类型
  1109. ChangeAmount = Prize, //变更金额
  1110. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  1111. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  1112. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  1113. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  1114. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  1115. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  1116. }).Entity;
  1117. db.SaveChanges();
  1118. string dateString = DateTime.Now.ToString("yyyyMMdd");
  1119. string monthString = DateTime.Now.ToString("yyyyMM");
  1120. // 开机奖励列表
  1121. List<string> dates = RedisDbconn.Instance.GetList<string>("OpenRewardDay:" + puser.Id + ":" + pos.BrandId);
  1122. if (!dates.Contains(dateString))
  1123. {
  1124. RedisDbconn.Instance.AddList("OpenRewardDay:" + puser.Id + ":" + pos.BrandId, dateString);
  1125. }
  1126. RedisDbconn.Instance.AddNumber("OpenRewardAmt:" + puser.Id + ":" + pos.BrandId + ":" + dateString, Prize);
  1127. List<string> months = RedisDbconn.Instance.GetList<string>("OpenRewardMonth:" + puser.Id + ":" + pos.BrandId);
  1128. if (!months.Contains(monthString))
  1129. {
  1130. RedisDbconn.Instance.AddList("OpenRewardMonth:" + puser.Id + ":" + pos.BrandId, monthString);
  1131. }
  1132. RedisDbconn.Instance.AddNumber("OpenRewardAmt:" + puser.Id + ":" + pos.BrandId + ":" + monthString, Prize);
  1133. // 开机奖励详情
  1134. RedisDbconn.Instance.AddList("OpenRewardDetail:" + puser.Id + ":" + pos.BrandId + ":" + dateString, detail);
  1135. Prize = 0;
  1136. }
  1137. }
  1138. }
  1139. }
  1140. }
  1141. }
  1142. // }
  1143. }
  1144. }
  1145. }
  1146. }
  1147. db.Dispose();
  1148. }
  1149. catch(Exception ex)
  1150. {
  1151. function.WriteLog(DateTime.Now.ToString() + "\r\n" + ex.ToString(), "实时获取开机奖励异常");
  1152. }
  1153. }
  1154. else
  1155. {
  1156. Thread.Sleep(5000);
  1157. }
  1158. }
  1159. }
  1160. public void dosomething42(string date)
  1161. {
  1162. WebCMSEntities db = new WebCMSEntities();
  1163. DateTime yesterday = DateTime.Parse(date + " 00:00:00");
  1164. DateTime today = DateTime.Parse(DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00");
  1165. List<PosMerchantInfo> merList = db.PosMerchantInfo.Where(m => m.ActiveStatus == 1 && m.MerStandardDate >= yesterday && m.MerStandardDate < today && !string.IsNullOrEmpty(m.SeoKeyword) && m.SeoKeyword != "0").ToList();
  1166. foreach (PosMerchantInfo merchant in merList)
  1167. {
  1168. MachineForMerNo forMerNo = db.MachineForMerNo.FirstOrDefault(m => m.MerNo == merchant.MerchantNo) ?? new MachineForMerNo();
  1169. PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == forMerNo.SnId) ?? new PosMachinesTwo();
  1170. if (pos.ActivationTime > DateTime.Now.AddDays(-20) && pos.CreditTrade >= 1000)
  1171. {
  1172. decimal ActPrize = decimal.Parse(function.CheckNum(merchant.SeoKeyword));
  1173. if (ActPrize > 0)
  1174. {
  1175. // PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId && !string.IsNullOrEmpty(m.MerIdcardNo));
  1176. // PosMerchantOtherInfo otherInfo = db.PosMerchantOtherInfo.FirstOrDefault(m => m.CertId == merchant.MerIdcardNo && m.PrizeFlag2 == 0);
  1177. // if (otherInfo != null)
  1178. // {
  1179. // otherInfo.PrizeFlag2 = 1;
  1180. // db.SaveChanges();
  1181. // 从机具所属人上级开始分开机奖励
  1182. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  1183. if (user != null)
  1184. {
  1185. if (!string.IsNullOrEmpty(user.ParentNav))
  1186. {
  1187. decimal Prize = 20;
  1188. string[] ParentNavs = user.ParentNav.Trim(',').Replace(",,", ",").Split(',');
  1189. for (int i = ParentNavs.Length - 1; i >= 0; i--)
  1190. {
  1191. int UserId = int.Parse(ParentNavs[i]);
  1192. Users puser = db.Users.FirstOrDefault(m => m.Id == UserId && m.AuthFlag == 1);
  1193. if (puser != null && Prize > 0)
  1194. {
  1195. int machineCount = db.PosMachinesTwo.Count(m => m.BuyUserId == puser.Id && m.PosSnType == 0 && m.ActivationState == 0); //判断是否拥有3台兑换机
  1196. int ActiveCount = db.PosMachinesTwo.Count(m => m.BuyUserId == puser.Id && m.ActivationState == 1); //判断是否拥有3台激活机(不限购买或赠送)
  1197. int couponCount = db.PosCoupons.Count(m => m.UserId == puser.Id && m.IsUse == 0); //判断是否拥有3张券
  1198. // int BigCount = db.PosMachinesTwo.Count(m => m.UserId == puser.Id && m.BrandId == 3); //判断是否拥有2台大机
  1199. // int BigActiveCount = db.PosMachinesTwo.Count(m => m.UserId == puser.Id && m.ActivationState == 1 && m.BrandId == 3); //判断是否拥有2台激活大机(不限购买或赠送)
  1200. if (machineCount + ActiveCount + couponCount >= 3)
  1201. {
  1202. int pTopUserId = 0;
  1203. if (!string.IsNullOrEmpty(puser.ParentNav))
  1204. {
  1205. pTopUserId = int.Parse(puser.ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  1206. }
  1207. Users machineUser = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new Users();
  1208. OpenRewardDetail detail = db.OpenRewardDetail.Add(new OpenRewardDetail()
  1209. {
  1210. CreateDate = DateTime.Now,
  1211. UpdateDate = DateTime.Now,
  1212. TradeMonth = yesterday.ToString("yyyyMM"), //交易月
  1213. TradeDate = yesterday, //达标日期
  1214. UserId = puser.Id, //创客
  1215. BrandId = pos.BrandId, //品牌
  1216. ProductName = RelationClass.GetKqProductsInfo(pos.BrandId), //产品名称
  1217. MerchantId = pos.BindMerchantId, //商户
  1218. DirectUserId = merchant.UserId, //商户直属人
  1219. SnNo = pos.PosSn, //SN号
  1220. MerNo = merchant.KqMerNo, //渠道商户号
  1221. SnType = pos.PosSnType, //机具类型
  1222. StandardDate = pos.ActivationTime, //商户的激活日期
  1223. SnStoreId = pos.StoreId, //SN仓库
  1224. MerBuddyType = puser.MerchantType, //商户创客类型
  1225. RewardType = 1, //奖励类型 1-开机直接奖励,2-开机间接奖励
  1226. RewardTips = "开机奖励", //奖励描述
  1227. CreditTradeAmt = pos.CreditTrade, //贷记卡交易总金额
  1228. DebitTradeAmt = pos.DebitCardTrade, //借记卡交易总金额
  1229. CreditRewardAmount = Prize, //贷记卡交易奖励金额
  1230. RewardDesc = "开机奖励", //奖励描述
  1231. TopUserId = pTopUserId, //顶级创客
  1232. SeoTitle = machineUser.RealName,
  1233. }).Entity;
  1234. db.OpenReward.Add(new OpenReward()
  1235. {
  1236. CreateDate = DateTime.Now,
  1237. UpdateDate = DateTime.Now,
  1238. TradeMonth = yesterday.ToString("yyyyMM"), //交易月
  1239. TradeDate = DateTime.Now, //达标日期
  1240. UserId = puser.Id, //创客
  1241. BrandId = pos.BrandId, //品牌
  1242. RewardType = 2, //奖励类型
  1243. CreditTradeAmt = pos.CreditTrade, //贷记卡交易总金额
  1244. DebitTradeAmt = pos.DebitCardTrade, //借记卡交易总金额
  1245. CreditRewardAmount = Prize, //贷记卡交易奖励金额
  1246. RewardDesc = "开机奖励", //奖励描述
  1247. TopUserId = pTopUserId, //顶级创客
  1248. });
  1249. string IdBrand = puser.Id + "_" + pos.BrandId;
  1250. UserMachineData userData = db.UserMachineData.FirstOrDefault(m => m.IdBrand == IdBrand);
  1251. if (userData == null)
  1252. {
  1253. userData = db.UserMachineData.Add(new UserMachineData()
  1254. {
  1255. IdBrand = IdBrand,
  1256. }).Entity;
  1257. db.SaveChanges();
  1258. }
  1259. userData.OpenProfit += Prize;
  1260. db.SaveChanges();
  1261. //账户入库
  1262. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == puser.Id);
  1263. if (account == null)
  1264. {
  1265. account = db.UserAccount.Add(new UserAccount()
  1266. {
  1267. Id = puser.Id,
  1268. UserId = puser.Id,
  1269. }).Entity;
  1270. db.SaveChanges();
  1271. }
  1272. //收支明细入库
  1273. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  1274. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  1275. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  1276. account.BalanceAmount += Prize;
  1277. account.TotalAmount += Prize;
  1278. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  1279. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  1280. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  1281. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  1282. {
  1283. CreateDate = DateTime.Now,
  1284. UpdateDate = DateTime.Now,
  1285. UserId = puser.Id, //创客
  1286. ChangeType = 50, //变动类型
  1287. ProductType = pos.BrandId, //产品类型
  1288. ChangeAmount = Prize, //变更金额
  1289. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  1290. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  1291. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  1292. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  1293. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  1294. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  1295. }).Entity;
  1296. db.SaveChanges();
  1297. string dateString = yesterday.ToString("yyyyMMdd");
  1298. string monthString = yesterday.ToString("yyyyMM");
  1299. // 开机奖励列表
  1300. List<string> dates = RedisDbconn.Instance.GetList<string>("OpenRewardDay:" + puser.Id + ":" + pos.BrandId);
  1301. if (!dates.Contains(dateString))
  1302. {
  1303. RedisDbconn.Instance.AddList("OpenRewardDay:" + puser.Id + ":" + pos.BrandId, dateString);
  1304. }
  1305. RedisDbconn.Instance.AddNumber("OpenRewardAmt:" + puser.Id + ":" + pos.BrandId + ":" + dateString, Prize);
  1306. List<string> months = RedisDbconn.Instance.GetList<string>("OpenRewardMonth:" + puser.Id + ":" + pos.BrandId);
  1307. if (!months.Contains(monthString))
  1308. {
  1309. RedisDbconn.Instance.AddList("OpenRewardMonth:" + puser.Id + ":" + pos.BrandId, monthString);
  1310. }
  1311. RedisDbconn.Instance.AddNumber("OpenRewardAmt:" + puser.Id + ":" + pos.BrandId + ":" + monthString, Prize);
  1312. // 开机奖励详情
  1313. RedisDbconn.Instance.AddList("OpenRewardDetail:" + puser.Id + ":" + pos.BrandId + ":" + dateString, detail);
  1314. Prize -= 10;
  1315. }
  1316. }
  1317. }
  1318. }
  1319. }
  1320. // }
  1321. }
  1322. }
  1323. }
  1324. db.Dispose();
  1325. }
  1326. // 4. 前一天的流量卡记录和匹配
  1327. public void ListenFluxRecord()
  1328. {
  1329. Thread th = new Thread(ListenFluxRecordD0);
  1330. th.IsBackground = true;
  1331. th.Start();
  1332. }
  1333. public void ListenFluxRecordD0()
  1334. {
  1335. while(true)
  1336. {
  1337. if(DateTime.Now.Hour > 0)
  1338. {
  1339. CheckFluxForTrade();
  1340. }
  1341. Thread.Sleep(600000);
  1342. }
  1343. }
  1344. public void doFluxRecord()
  1345. {
  1346. function.WriteLog(DateTime.Now.ToString(), "执行流量费返佣");
  1347. SpModels.WebCMSEntities spdb = new SpModels.WebCMSEntities();
  1348. WebCMSEntities db = new WebCMSEntities();
  1349. DateTime start = DateTime.Now.AddDays(-20);
  1350. List<SpModels.TradeFluxRecord> trades = spdb.TradeFluxRecord.Where(m => m.CreateDate >= start && m.Status == 1).ToList();
  1351. foreach (SpModels.TradeFluxRecord trade in trades)
  1352. {
  1353. try
  1354. {
  1355. string OrderNo = trade.TradeSerialNo; //单号
  1356. DateTime TradeDate = trade.CreateDate.Value;
  1357. string TradeMonth = TradeDate.ToString("yyyyMM");
  1358. decimal FeeAmount = trade.FeeAmount; //流量费
  1359. if (trade.ProductType == "1" || trade.ProductType == "4" || trade.ProductType == "6" || trade.ProductType == "8" || trade.ProductType == "9")
  1360. {
  1361. FeeAmount = FeeAmount / 100;
  1362. }
  1363. string TradeSnNo = trade.TradeSnNo; //机具SN
  1364. decimal FluxProfit = 0;
  1365. if (trade.ProductType == "1" && FeeAmount == 60)
  1366. {
  1367. FluxProfit = 24;
  1368. }
  1369. else if (trade.ProductType == "7" && FeeAmount == 46)
  1370. {
  1371. FluxProfit = 10;
  1372. }
  1373. else if (trade.ProductType != "1" && FeeAmount == 48)
  1374. {
  1375. FluxProfit = 12;
  1376. }
  1377. if (FluxProfit > 0)
  1378. {
  1379. MachineForSnNo forSnNo = db.MachineForSnNo.FirstOrDefault(m => m.SnNo == TradeSnNo) ?? new MachineForSnNo();
  1380. PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == forSnNo.SnId) ?? new PosMachinesTwo();
  1381. // PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId && m.Sort == 1);
  1382. PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  1383. if (merchant != null && pos.BrandId != 6)
  1384. {
  1385. bool checkExist = db.FluxProfitDetail.Any(m => m.MerNo == merchant.KqMerNo);
  1386. if (!checkExist && decimal.Parse(function.CheckNum(pos.SeoKeyword)) > 0)
  1387. {
  1388. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new Users();
  1389. int GetUserId = user.Id;
  1390. int TopUserId = 0;
  1391. string ParentNav = user.ParentNav;
  1392. if (!string.IsNullOrEmpty(ParentNav))
  1393. {
  1394. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  1395. if (ParentNavList.Length > 1)
  1396. {
  1397. TopUserId = int.Parse(ParentNavList[1]);
  1398. }
  1399. else if (ParentNavList.Length == 1)
  1400. {
  1401. TopUserId = int.Parse(ParentNavList[0]);
  1402. }
  1403. }
  1404. FluxProfitSummary fluxProfit = db.FluxProfitSummary.FirstOrDefault(m => m.UserId == GetUserId && m.BrandId == pos.BrandId && m.TradeMonth == TradeMonth);
  1405. if (fluxProfit == null)
  1406. {
  1407. fluxProfit = db.FluxProfitSummary.Add(new FluxProfitSummary()
  1408. {
  1409. CreateDate = DateTime.Now,
  1410. UpdateDate = DateTime.Now,
  1411. UserId = GetUserId, //创客
  1412. BrandId = pos.BrandId,
  1413. TopUserId = TopUserId, //顶级创客
  1414. TradeMonth = TradeMonth, //交易月
  1415. MerUserType = user.MerchantType, //商户创客类型
  1416. Remark = "流量卡分佣", //备注
  1417. }).Entity;
  1418. db.SaveChanges();
  1419. }
  1420. fluxProfit.FluxProfitAmt += FluxProfit; //流量分润总金额
  1421. db.FluxProfitDetail.Add(new FluxProfitDetail()
  1422. {
  1423. CreateDate = DateTime.Now,
  1424. UpdateDate = DateTime.Now,
  1425. RecordNo = OrderNo, //单号
  1426. TradeDate = TradeDate.ToString("yyyyMMdd"), //交易日期
  1427. TradeTime = TradeDate.ToString("HHmmss"), //交易时间
  1428. TradeMonth = TradeMonth, //交易月
  1429. UserId = GetUserId, //创客
  1430. MerchantId = pos.BindMerchantId, //商户
  1431. MerchantUserId = pos.UserId, //商户直属人
  1432. MerNo = merchant.KqMerNo, //渠道商户编号
  1433. SnNo = pos.PosSn, //渠道SN号
  1434. FluxOrderNo = OrderNo, //流量扣费单号
  1435. TradeOrderNo = OrderNo, //交易流水号
  1436. TradeAmt = trade.TradeAmount, //商户交易额
  1437. FluxFeeAmt = FeeAmount, //流量费
  1438. FluxProfitAmt = FluxProfit, //流量分润总金额
  1439. PosType = pos.PosSnType.ToString(), //POS类型
  1440. Remark = "流量卡分佣", //备注
  1441. BrandId = pos.BrandId, //品牌
  1442. TopUserId = TopUserId, //顶级创客
  1443. MerUserType = user.MerchantType, //商户创客类型
  1444. });
  1445. string IdBrand = user.Id + "_" + pos.BrandId;
  1446. UserMachineData userData = db.UserMachineData.FirstOrDefault(m => m.IdBrand == IdBrand);
  1447. if (userData == null)
  1448. {
  1449. userData = db.UserMachineData.Add(new UserMachineData()
  1450. {
  1451. IdBrand = IdBrand,
  1452. }).Entity;
  1453. db.SaveChanges();
  1454. }
  1455. userData.FluxProfit += FluxProfit;
  1456. db.SaveChanges();
  1457. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == GetUserId);
  1458. if (account == null)
  1459. {
  1460. account = db.UserAccount.Add(new UserAccount()
  1461. {
  1462. Id = GetUserId,
  1463. UserId = GetUserId,
  1464. }).Entity;
  1465. db.SaveChanges();
  1466. }
  1467. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  1468. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  1469. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  1470. account.BalanceAmount += FluxProfit;
  1471. account.TotalAmount += FluxProfit;
  1472. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  1473. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  1474. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  1475. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  1476. {
  1477. CreateDate = DateTime.Now,
  1478. UpdateDate = DateTime.Now,
  1479. UserId = GetUserId, //创客
  1480. ChangeType = 60, //变动类型
  1481. ProductType = pos.BrandId, //产品类型
  1482. ChangeAmount = FluxProfit, //变更金额
  1483. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  1484. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  1485. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  1486. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  1487. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  1488. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  1489. }).Entity;
  1490. db.SaveChanges();
  1491. }
  1492. SpModels.TradeFluxRecord edit = spdb.TradeFluxRecord.FirstOrDefault(m => m.Id == trade.Id);
  1493. if (edit != null)
  1494. {
  1495. edit.Status = 2;
  1496. spdb.SaveChanges();
  1497. }
  1498. }
  1499. }
  1500. }
  1501. catch (Exception ex)
  1502. {
  1503. function.WriteLog(DateTime.Now.ToString() + "\n$" + trade.Id + "$\n" + ex.ToString(), "流量卡分佣异常");
  1504. }
  1505. }
  1506. spdb.Dispose();
  1507. db.Dispose();
  1508. function.WriteLog(DateTime.Now.ToString() + "\n", "执行流量费返佣");
  1509. }
  1510. public void CheckFluxForTrade()
  1511. {
  1512. function.WriteLog(DateTime.Now.ToString(), "扫描交易记录中的流量费");
  1513. SpModels.WebCMSEntities spdb = new SpModels.WebCMSEntities();
  1514. DateTime start = DateTime.Now.AddDays(-20);
  1515. int StartId = int.Parse(function.CheckInt(function.ReadInstance("/SycnSp/TradeRecordId.txt")));
  1516. List<string> BrandIds = new List<string>();
  1517. BrandIds.Add("1");
  1518. BrandIds.Add("10");
  1519. BrandIds.Add("12");
  1520. 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);
  1521. foreach (var sub in list.ToList())
  1522. {
  1523. try
  1524. {
  1525. SpModels.TradeRecord trade = spdb.TradeRecord.FirstOrDefault(m => m.Id == sub.Id);
  1526. if (trade != null)
  1527. {
  1528. if(trade.ProductType == "1") //金控
  1529. {
  1530. string content = trade.SeoDescription;
  1531. if (!string.IsNullOrEmpty(content))
  1532. {
  1533. content = System.Web.HttpUtility.UrlDecode(content);
  1534. JsonData jsonObj = JsonMapper.ToObject(content);
  1535. decimal terminalDataFlowFee = decimal.Parse(function.CheckNum(jsonObj["terminalDataFlowFee"].ToString()));
  1536. if (terminalDataFlowFee > 0)
  1537. {
  1538. spdb.TradeFluxRecord.Add(new SpModels.TradeFluxRecord()
  1539. {
  1540. SeoDescription = trade.TradeSerialNo,
  1541. FeeAmount = terminalDataFlowFee,
  1542. TradeSerialNo = function.MD5_16(trade.TradeSerialNo),
  1543. CreateDate = trade.CreateDate,
  1544. TradeSnNo = trade.TradeSnNo,
  1545. ProductType = trade.ProductType,
  1546. Status = 1,
  1547. });
  1548. spdb.SaveChanges();
  1549. }
  1550. }
  1551. }
  1552. else if(trade.ProductType == "10" || trade.ProductType == "12") //10联动、12盒易付
  1553. {
  1554. if (trade.DigAmt > 0)
  1555. {
  1556. spdb.TradeFluxRecord.Add(new SpModels.TradeFluxRecord()
  1557. {
  1558. SeoDescription = trade.TradeSerialNo,
  1559. FeeAmount = trade.DigAmt,
  1560. TradeSerialNo = function.MD5_16(trade.TradeSerialNo),
  1561. CreateDate = trade.CreateDate,
  1562. TradeSnNo = trade.TradeSnNo,
  1563. ProductType = trade.ProductType,
  1564. Status = 1,
  1565. });
  1566. spdb.SaveChanges();
  1567. }
  1568. }
  1569. trade.Status = 3;
  1570. spdb.SaveChanges();
  1571. }
  1572. }
  1573. catch (Exception ex)
  1574. {
  1575. function.WriteLog(DateTime.Now.ToString() + "\n$" + sub.Id + "$\n" + ex.ToString(), "扫描交易记录中的流量费异常");
  1576. }
  1577. }
  1578. spdb.Dispose();
  1579. function.WriteLog(DateTime.Now.ToString() + "\n", "扫描交易记录中的流量费");
  1580. doFluxRecord();
  1581. }
  1582. // 每天统计头一天的交易额
  1583. public void StartEverDay(string date)
  1584. {
  1585. string TradeMonth = DateTime.Now.ToString("yyyyMM");
  1586. if(DateTime.Now.Day == 1)
  1587. {
  1588. TradeMonth = DateTime.Now.AddMonths(-1).ToString("yyyyMM");
  1589. }
  1590. else if(DateTime.Now.Day == 2)
  1591. {
  1592. CustomerSqlConn.op("update Users set ThisMonthTrade=0 where ThisMonthTrade>0", MysqlConn.SqlConnStr);
  1593. }
  1594. DataTable list = CustomerSqlConn.dtable("select UserId,sum(HelpNonDirectTradeAmt+HelpNonDirectDebitTradeAmt+NotHelpNonDirectTradeAmt+NotHelpNonDirectDebitTradeAmt+ProfitNonDirectTradeAmt+ProfitNonDirectDebitTradeAmt) from (select UserId,HelpNonDirectTradeAmt,HelpNonDirectDebitTradeAmt,NotHelpNonDirectTradeAmt,NotHelpNonDirectDebitTradeAmt,ProfitNonDirectTradeAmt,ProfitNonDirectDebitTradeAmt from TradeDaySummary where Id>=9790000 and TradeMonth='" + TradeMonth + "' and SeoTitle='team' and UserId>0) tb group by UserId", MysqlConn.SqlConnStr);
  1595. foreach (DataRow dr in list.Rows)
  1596. {
  1597. string UserId = dr["UserId"].ToString();
  1598. string ThisMonthTrade = dr[1].ToString();
  1599. CustomerSqlConn.op("update Users set ThisMonthTrade=" + ThisMonthTrade + " where Id=" + UserId, MysqlConn.SqlConnStr);
  1600. }
  1601. // Thread th = new Thread(StatTradeAmountEverDay);
  1602. // th.IsBackground = true;
  1603. // th.Start(date);
  1604. }
  1605. public void StatTradeAmountEverDay(object sender)
  1606. {
  1607. string date = sender.ToString();
  1608. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), "执行昨天交易额日志");
  1609. WebCMSEntities db = new WebCMSEntities();
  1610. try
  1611. {
  1612. string TradeDate = date.Replace("-", "");
  1613. string TradeMonth = TradeDate.Substring(0, 6);
  1614. string start = date + " 00:00:00";
  1615. string end = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  1616. string startId = "0", endId = "9999999999";
  1617. List<string> uids = new List<string>();
  1618. DataTable startDt = OtherMySqlConn.dtable("select min(Id) from TradeRecord where CreateDate>='" + start + "'");
  1619. if (startDt.Rows.Count > 0)
  1620. {
  1621. startId = startDt.Rows[0][0].ToString();
  1622. }
  1623. function.WriteLog(startId + "\n\n", "执行昨天交易额日志");
  1624. // DataTable endDt = OtherMySqlConn.dtable("select max(Id) from TradeRecord where CreateDate<'" + end + "'");
  1625. // if (endDt.Rows.Count > 0)
  1626. // {
  1627. // endId = endDt.Rows[0][0].ToString();
  1628. // }
  1629. 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 + "')");
  1630. function.WriteLog("交易人数:" + userDt.Rows.Count + "\n\n", "执行昨天交易额日志");
  1631. foreach (DataRow userDr in userDt.Rows)
  1632. {
  1633. int UserId = int.Parse(userDr["Id"].ToString());
  1634. string ParentNav = userDr["ParentNav"].ToString();
  1635. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天交易额日志");
  1636. 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");
  1637. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天交易额日志");
  1638. foreach (DataRow selfDr in selfdt.Rows)
  1639. {
  1640. int BrandId = int.Parse(selfDr["BrandId"].ToString());
  1641. int BankCardType = int.Parse(selfDr["BankCardType"].ToString());
  1642. int QrPayFlag = int.Parse(selfDr["QrPayFlag"].ToString());
  1643. decimal TradeAmount = decimal.Parse(selfDr[3].ToString());
  1644. UserTradeDaySummary selfStat = db.UserTradeDaySummary.FirstOrDefault(m => m.UserId == UserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.BrandId == BrandId && m.QueryCount == QrPayFlag && m.SeoTitle == "self");
  1645. if (selfStat == null)
  1646. {
  1647. selfStat = db.UserTradeDaySummary.Add(new UserTradeDaySummary()
  1648. {
  1649. UserId = UserId,
  1650. TradeMonth = TradeMonth,
  1651. TradeDate = TradeDate,
  1652. BrandId = BrandId,
  1653. QueryCount = QrPayFlag,
  1654. SeoTitle = "self",
  1655. }).Entity;
  1656. db.SaveChanges();
  1657. }
  1658. if (BankCardType == 0)
  1659. {
  1660. selfStat.DirectDebitTradeAmt += TradeAmount;
  1661. }
  1662. else if (BankCardType != 0)
  1663. {
  1664. selfStat.DirectTradeAmt += TradeAmount;
  1665. }
  1666. db.SaveChanges();
  1667. }
  1668. if (!string.IsNullOrEmpty(ParentNav))
  1669. {
  1670. ParentNav += "," + UserId + ",";
  1671. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  1672. foreach (string NavUserIdString in ParentNavList)
  1673. {
  1674. if (!uids.Contains(NavUserIdString + start))
  1675. {
  1676. uids.Add(NavUserIdString + start);
  1677. int NavUserId = int.Parse(NavUserIdString);
  1678. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天交易额日志");
  1679. 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");
  1680. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天交易额日志");
  1681. foreach (DataRow teamDr in teamDt.Rows)
  1682. {
  1683. int BrandId = int.Parse(teamDr["BrandId"].ToString());
  1684. int BankCardType = int.Parse(teamDr["BankCardType"].ToString());
  1685. int QrPayFlag = int.Parse(teamDr["QrPayFlag"].ToString());
  1686. decimal TradeAmount = decimal.Parse(teamDr[3].ToString());
  1687. UserTradeDaySummary teamStat = db.UserTradeDaySummary.FirstOrDefault(m => m.UserId == NavUserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.BrandId == BrandId && m.QueryCount == QrPayFlag && m.SeoTitle == "team");
  1688. if (teamStat == null)
  1689. {
  1690. teamStat = db.UserTradeDaySummary.Add(new UserTradeDaySummary()
  1691. {
  1692. UserId = NavUserId,
  1693. TradeMonth = TradeMonth,
  1694. TradeDate = TradeDate,
  1695. BrandId = BrandId,
  1696. QueryCount = QrPayFlag,
  1697. SeoTitle = "team",
  1698. }).Entity;
  1699. db.SaveChanges();
  1700. }
  1701. if (BankCardType == 0)
  1702. {
  1703. teamStat.NonDirectDebitTradeAmt += TradeAmount;
  1704. }
  1705. else if (BankCardType != 0)
  1706. {
  1707. teamStat.NonDirectTradeAmt += TradeAmount;
  1708. }
  1709. db.SaveChanges();
  1710. }
  1711. }
  1712. }
  1713. }
  1714. }
  1715. if (DateTime.Now.Day >= 2)
  1716. {
  1717. Thread.Sleep(5000);
  1718. DataTable list = OtherMySqlConn.dtable("select UserId,sum(NonDirectTradeAmt) from UserTradeDaySummary where TradeDate='" + TradeDate + "' GROUP BY UserId");
  1719. foreach (DataRow dr in list.Rows)
  1720. {
  1721. string UserId = dr["UserId"].ToString();
  1722. string ThisMonthTrade = dr[1].ToString();
  1723. OtherMySqlConn.op("update Users set ThisMonthTrade=ThisMonthTrade+" + ThisMonthTrade + " where Id=" + UserId);
  1724. }
  1725. }
  1726. }
  1727. catch (Exception ex)
  1728. {
  1729. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "统计昨天的交易额异常");
  1730. }
  1731. db.Dispose();
  1732. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天交易额日志");
  1733. StatMerchantTrade(date);
  1734. }
  1735. //统计商户交易额
  1736. private void StatMerchantTrade(string date)
  1737. {
  1738. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), "执行商户交易额日志");
  1739. // WebCMSEntities db = new WebCMSEntities();
  1740. try
  1741. {
  1742. string start = date + " 00:00:00";
  1743. string end = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  1744. 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 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);
  1745. RedisDbconn.Instance.Clear("PosMerchantAmount:*");
  1746. RedisDbconn.Instance.Clear("PosMerchantAmount:*:" + date.Replace("-", "").Substring(0, 6)); //商户当月交易
  1747. RedisDbconn.Instance.Clear("PosMerchantAmount:*:" + date.Replace("-", "")); //商户当日交易
  1748. // foreach (DataRow selfDr in selfdt.Rows)
  1749. // {
  1750. // int BrandId = int.Parse(selfDr["BrandId"].ToString());
  1751. // int MerchantId = int.Parse(selfDr["MerchantId"].ToString());
  1752. // string TradeDate = selfDr["TradeDate"].ToString();
  1753. // TradeDate = TradeDate.Replace("-", "");
  1754. // string TradeMonth = TradeDate.Substring(0, 6);
  1755. // decimal TradeAmount = decimal.Parse(selfDr["TradeAmount"].ToString());
  1756. // PosMerchantTradeSummay merStat = db.PosMerchantTradeSummay.FirstOrDefault(m => m.MerchantId == MerchantId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.BrandId == BrandId);
  1757. // if (merStat == null)
  1758. // {
  1759. // merStat = db.PosMerchantTradeSummay.Add(new PosMerchantTradeSummay()
  1760. // {
  1761. // MerchantId = MerchantId,
  1762. // TradeMonth = TradeMonth,
  1763. // TradeDate = TradeDate,
  1764. // BrandId = BrandId,
  1765. // }).Entity;
  1766. // db.SaveChanges();
  1767. // }
  1768. // merStat.TradeAmount += TradeAmount;
  1769. // db.SaveChanges();
  1770. // }
  1771. }
  1772. catch (Exception ex)
  1773. {
  1774. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "统计商户的交易额");
  1775. }
  1776. // db.Dispose();
  1777. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行商户交易额日志");
  1778. }
  1779. // 5. 创客升级
  1780. public void StatUserLevel()
  1781. {
  1782. Thread th = new Thread(StatUserLevelDo);
  1783. th.IsBackground = true;
  1784. th.Start();
  1785. }
  1786. public void StatUserLevelDo()
  1787. {
  1788. while (true)
  1789. {
  1790. if(DateTime.Now.Day < 10 && DateTime.Now.Hour > 1)
  1791. {
  1792. string Month = DateTime.Now.AddDays(-1).ToString("yyyy-MM");
  1793. string flag = function.ReadInstance("/ProfitFlag/" + Month + ".txt");
  1794. if (string.IsNullOrEmpty(flag))
  1795. {
  1796. function.WritePage("/ProfitFlag/", Month + ".txt", DateTime.Now.ToString("HH:mm:ss"));
  1797. LogoutUserHelper.Instance.DoWorks(); //每月一号归档注销创客,把伞下创客归到注销创客的上级
  1798. StatUserLevelStart();
  1799. }
  1800. }
  1801. Thread.Sleep(600000);
  1802. }
  1803. }
  1804. public void StatUserLevelStart()
  1805. {
  1806. WebCMSEntities db = new WebCMSEntities();
  1807. MpMainModels.WebCMSEntities mpmaindb = new MpMainModels.WebCMSEntities();
  1808. try
  1809. {
  1810. OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["Pxc1SqlConnStr"].ToString();
  1811. function.WriteLog(DateTime.Now.ToString(), "创客升级日志");
  1812. DateTime start = DateTime.Parse(DateTime.Now.AddMonths(-1).ToString("yyyy-MM") + "-01 00:00:00");
  1813. DateTime end = start.AddDays(1);
  1814. string TradeMonth = DateTime.Now.AddMonths(-1).ToString("yyyyMM");
  1815. List<UserLevelSet> sets = db.UserLevelSet.ToList();
  1816. bool op = true;
  1817. int startid = 0;
  1818. while(op)
  1819. {
  1820. 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();
  1821. function.WriteLog(users.Count.ToString(), "创客升级日志");
  1822. if(users.Count > 0)
  1823. {
  1824. foreach (var subuser in users)
  1825. {
  1826. Users user = db.Users.FirstOrDefault(m => m.Id == subuser.Id);
  1827. if (user != null)
  1828. {
  1829. int BeforeLevel = user.UserLevel;
  1830. int AfterLevel = 0;
  1831. decimal TradeAmount = 0;
  1832. //创客团队交易额
  1833. bool check = db.TradeDaySummary.Any(m => m.UserId == user.Id && m.TradeMonth == TradeMonth && m.SeoTitle == "team");
  1834. if (check)
  1835. {
  1836. 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);
  1837. }
  1838. //助利宝团队交易额
  1839. 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 + "");
  1840. if (checkdt.Rows.Count > 0)
  1841. {
  1842. TradeAmount += decimal.Parse(function.CheckNum(checkdt.Rows[0]["TradeAmount"].ToString()));
  1843. }
  1844. //码牌团队交易额
  1845. check = mpmaindb.UserAmountSummary.Any(m => m.UserId == user.Id && m.TradeMonth == TradeMonth && m.SeoTitle == "team");
  1846. if (check)
  1847. {
  1848. TradeAmount += mpmaindb.UserAmountSummary.Where(m => m.UserId == user.Id && m.TradeMonth == TradeMonth && m.SeoTitle == "team").Sum(m => m.TotalAmount);
  1849. }
  1850. UserLevelSet set = sets.FirstOrDefault(m => m.UpLevelGrowth <= TradeAmount && m.UpLevelIntegral > TradeAmount);
  1851. if (set != null)
  1852. {
  1853. AfterLevel = set.Id;
  1854. }
  1855. // K6以上计算小市场是否达标
  1856. // 升级逻辑
  1857. bool upFlag = true;
  1858. if(AfterLevel > 5)
  1859. {
  1860. 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");
  1861. int index = 0;
  1862. decimal TradeAmt = 0;
  1863. decimal BigTradeAmt = 0;
  1864. foreach(DataRow dr in dt.Rows)
  1865. {
  1866. index += 1;
  1867. if(index == 1)
  1868. {
  1869. BigTradeAmt = decimal.Parse(dr[1].ToString());
  1870. }
  1871. else if(index > 1)
  1872. {
  1873. TradeAmt += decimal.Parse(dr[1].ToString());
  1874. }
  1875. }
  1876. if(TradeAmt < 12000000 || BigTradeAmt < 30000000)
  1877. {
  1878. if(AfterLevel > BeforeLevel && BeforeLevel >= 5) //保级,只升不降
  1879. {
  1880. AfterLevel = BeforeLevel;
  1881. }
  1882. else if(AfterLevel > BeforeLevel && BeforeLevel < 5)
  1883. {
  1884. AfterLevel = 5;
  1885. }
  1886. else if(BeforeLevel > 5)
  1887. {
  1888. AfterLevel = 5;
  1889. }
  1890. else
  1891. {
  1892. upFlag = false;
  1893. }
  1894. }
  1895. }
  1896. if (AfterLevel > BeforeLevel && AfterLevel > 1 && upFlag)
  1897. {
  1898. function.WriteLog("升级:" + user.Id.ToString() + BeforeLevel + "->" + AfterLevel, "创客升级日志");
  1899. user.UserLevel = AfterLevel;
  1900. DateTime checkTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM") + "-01 00:00:00");
  1901. UserRank rank = db.UserRank.FirstOrDefault(m => m.CreateDate >= checkTime && m.UserId == user.Id);
  1902. if(rank == null)
  1903. {
  1904. db.UserRank.Add(new UserRank()
  1905. {
  1906. CreateDate = DateTime.Now,
  1907. UpdateDate = DateTime.Now,
  1908. UserId = user.Id, //创客
  1909. WhiteRank = BeforeLevel,
  1910. Rank = AfterLevel, //当前等级
  1911. StatYear = DateTime.Now.Year, //统计年份
  1912. StatMonth = DateTime.Now.Month, //统计月份
  1913. TradeAmt = TradeAmount, //团队交易总额
  1914. UpgradeFlag = 1, //升级标识
  1915. OperateDate = DateTime.Now, //操作时间
  1916. Status = 1,
  1917. });
  1918. db.SaveChanges();
  1919. }
  1920. else
  1921. {
  1922. rank.TradeAmt = TradeAmount;
  1923. rank.Rank = AfterLevel;
  1924. db.SaveChanges();
  1925. }
  1926. }
  1927. // 降级逻辑
  1928. if(!upFlag && AfterLevel > 5)
  1929. {
  1930. AfterLevel = 5;
  1931. }
  1932. if (AfterLevel < BeforeLevel && BeforeLevel > 1)
  1933. {
  1934. function.WriteLog(user.MakerCode + "-" + user.RealName + ":K" + BeforeLevel + "->K" + AfterLevel, "创客降级日志");
  1935. user.UserLevel = AfterLevel;
  1936. DateTime checkTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM") + "-01 00:00:00");
  1937. UserRank rank = db.UserRank.FirstOrDefault(m => m.CreateDate >= checkTime && m.UserId == user.Id);
  1938. if(rank == null)
  1939. {
  1940. db.UserRank.Add(new UserRank()
  1941. {
  1942. CreateDate = DateTime.Now,
  1943. UpdateDate = DateTime.Now,
  1944. UserId = user.Id, //创客
  1945. WhiteRank = BeforeLevel,
  1946. Rank = AfterLevel, //当前等级
  1947. StatYear = DateTime.Now.Year, //统计年份
  1948. StatMonth = DateTime.Now.Month, //统计月份
  1949. TradeAmt = TradeAmount, //团队交易总额
  1950. UpgradeFlag = 0, //升级标识
  1951. OperateDate = DateTime.Now, //操作时间
  1952. Status = 1,
  1953. });
  1954. db.SaveChanges();
  1955. }
  1956. else
  1957. {
  1958. rank.TradeAmt = TradeAmount;
  1959. rank.Rank = AfterLevel;
  1960. rank.Status = 1;
  1961. db.SaveChanges();
  1962. }
  1963. }
  1964. }
  1965. startid = subuser.Id;
  1966. }
  1967. function.WriteLog(startid.ToString(), "创客升级日志");
  1968. }
  1969. else
  1970. {
  1971. op = false;
  1972. }
  1973. }
  1974. function.WriteLog(DateTime.Now.ToString(), "创客升级日志");
  1975. }
  1976. catch (Exception ex)
  1977. {
  1978. function.WriteLog(ex.ToString(), "创客升级异常");
  1979. }
  1980. db.Dispose();
  1981. mpmaindb.Dispose();
  1982. RedisDbconn.Instance.AddList("DoTableEveryMonthQueue", "1");
  1983. }
  1984. // 统计创客激活数
  1985. public void StartPosActNum()
  1986. {
  1987. Thread th = new Thread(StartPosActNumFor);
  1988. th.IsBackground = true;
  1989. th.Start();
  1990. }
  1991. public void StartPosActNumFor()
  1992. {
  1993. // DateTime end = DateTime.Parse("2022-06-15 00:00:00");
  1994. // DateTime check = DateTime.Parse("2022-06-14");
  1995. // while (check <= end)
  1996. // {
  1997. // StartPosActNumDo(check.ToString("yyyy-MM-dd"));
  1998. // check = check.AddDays(1);
  1999. // }
  2000. while (true)
  2001. {
  2002. if(DateTime.Now.Hour >= 2)
  2003. {
  2004. StartPosActNumEverTime();
  2005. }
  2006. Thread.Sleep(100);
  2007. }
  2008. }
  2009. public void StartPosActNumDo(object sender)
  2010. {
  2011. string date = sender.ToString();
  2012. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), "执行创客激活数日志");
  2013. WebCMSEntities db = new WebCMSEntities();
  2014. try
  2015. {
  2016. string TradeDate = date.Replace("-", "");
  2017. string TradeMonth = TradeDate.Substring(0, 6);
  2018. string start = date + " 00:00:00";
  2019. string end = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  2020. List<string> uids = new List<string>();
  2021. 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 + "')");
  2022. function.WriteLog("人数:" + userDt.Rows.Count + "\n\n", "执行创客激活数日志");
  2023. foreach (DataRow userDr in userDt.Rows)
  2024. {
  2025. int UserId = int.Parse(userDr["Id"].ToString());
  2026. string ParentNav = userDr["ParentNav"].ToString();
  2027. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行创客激活数日志");
  2028. 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");
  2029. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行创客激活数日志");
  2030. foreach (DataRow selfDr in selfdt.Rows)
  2031. {
  2032. int BrandId = int.Parse(selfDr["BrandId"].ToString());
  2033. int QrPayFlag = 0;
  2034. int ActCount = int.Parse(selfDr[1].ToString());
  2035. UserTradeDaySummary selfStat = db.UserTradeDaySummary.FirstOrDefault(m => m.UserId == UserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.BrandId == BrandId && m.QueryCount == QrPayFlag && m.SeoTitle == "self");
  2036. if (selfStat == null)
  2037. {
  2038. selfStat = db.UserTradeDaySummary.Add(new UserTradeDaySummary()
  2039. {
  2040. UserId = UserId,
  2041. TradeMonth = TradeMonth,
  2042. TradeDate = TradeDate,
  2043. BrandId = BrandId,
  2044. QueryCount = QrPayFlag,
  2045. SeoTitle = "self",
  2046. }).Entity;
  2047. db.SaveChanges();
  2048. }
  2049. selfStat.DirectDebitCapNum += ActCount;
  2050. db.SaveChanges();
  2051. }
  2052. if (!string.IsNullOrEmpty(ParentNav))
  2053. {
  2054. ParentNav += "," + UserId + ",";
  2055. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  2056. foreach (string NavUserIdString in ParentNavList)
  2057. {
  2058. if (!uids.Contains(NavUserIdString + start))
  2059. {
  2060. uids.Add(NavUserIdString + start);
  2061. int NavUserId = int.Parse(NavUserIdString);
  2062. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行创客激活数日志");
  2063. 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");
  2064. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行创客激活数日志");
  2065. foreach (DataRow teamDr in teamDt.Rows)
  2066. {
  2067. int BrandId = int.Parse(teamDr["BrandId"].ToString());
  2068. int QrPayFlag = 0;
  2069. int ActCount = int.Parse(teamDr[1].ToString());
  2070. UserTradeDaySummary teamStat = db.UserTradeDaySummary.FirstOrDefault(m => m.UserId == NavUserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.BrandId == BrandId && m.QueryCount == QrPayFlag && m.SeoTitle == "team");
  2071. if (teamStat == null)
  2072. {
  2073. teamStat = db.UserTradeDaySummary.Add(new UserTradeDaySummary()
  2074. {
  2075. UserId = NavUserId,
  2076. TradeMonth = TradeMonth,
  2077. TradeDate = TradeDate,
  2078. BrandId = BrandId,
  2079. QueryCount = QrPayFlag,
  2080. SeoTitle = "team",
  2081. }).Entity;
  2082. db.SaveChanges();
  2083. }
  2084. teamStat.NonDirectDebitCapNum += ActCount;
  2085. db.SaveChanges();
  2086. }
  2087. }
  2088. }
  2089. }
  2090. }
  2091. OtherMySqlConn.op("update PosMachinesTwo set QueryCount=1 where QueryCount=0 and ActivationState=1 and ActivationTime>='" + start + "' and ActivationTime<'" + end + "'");
  2092. }
  2093. catch (Exception ex)
  2094. {
  2095. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "执行创客激活数异常");
  2096. }
  2097. db.Dispose();
  2098. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行创客激活数日志");
  2099. Thread.Sleep(60000);
  2100. }
  2101. public void StartPosActNumEverTime()
  2102. {
  2103. OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["Pxc1SqlConnStr"].ToString();
  2104. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), "实时执行创客激活数日志");
  2105. WebCMSEntities db = new WebCMSEntities();
  2106. try
  2107. {
  2108. DataTable idsDt = OtherMySqlConn.dtable("select Id from PosMachinesTwo where QueryCount=0 and ActivationState=1 and ActivationTime is not null and BuyUserId>0 limit 50");
  2109. if(idsDt.Rows.Count > 0)
  2110. {
  2111. string ids = "";
  2112. foreach (DataRow idsDr in idsDt.Rows)
  2113. {
  2114. ids += idsDr["Id"].ToString() + ",";
  2115. }
  2116. 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')");
  2117. if (userDt.Rows.Count > 0)
  2118. {
  2119. function.WriteLog("人数:" + userDt.Rows.Count + "\n\n", "实时执行创客激活数日志");
  2120. foreach (DataRow userDr in userDt.Rows)
  2121. {
  2122. int UserId = int.Parse(userDr["BuyUserId"].ToString());
  2123. int BrandId = int.Parse(userDr["BrandId"].ToString());
  2124. string TradeDate = userDr[2].ToString();
  2125. int ActCount = int.Parse(function.CheckInt(userDr[3].ToString()));
  2126. int QrPayFlag = 0;
  2127. string TradeMonth = TradeDate.Substring(0, 6);
  2128. string date = TradeDate.Substring(0, 4) + "-" + TradeDate.Substring(4, 2) + "-" + TradeDate.Substring(6, 2);
  2129. string start = date + " 00:00:00";
  2130. string end = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  2131. Users user = db.Users.FirstOrDefault(m => m.Id == UserId) ?? new Users();
  2132. string ParentNav = user.ParentNav;
  2133. UserTradeDaySummary selfStat = db.UserTradeDaySummary.FirstOrDefault(m => m.UserId == UserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.BrandId == BrandId && m.QueryCount == QrPayFlag && m.SeoTitle == "self");
  2134. if (selfStat == null)
  2135. {
  2136. selfStat = db.UserTradeDaySummary.Add(new UserTradeDaySummary()
  2137. {
  2138. UserId = UserId,
  2139. TradeMonth = TradeMonth,
  2140. TradeDate = TradeDate,
  2141. BrandId = BrandId,
  2142. QueryCount = QrPayFlag,
  2143. SeoTitle = "self",
  2144. }).Entity;
  2145. db.SaveChanges();
  2146. }
  2147. selfStat.DirectDebitCapNum += ActCount;
  2148. ParentNav += "," + UserId + ",";
  2149. if (!string.IsNullOrEmpty(ParentNav))
  2150. {
  2151. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  2152. foreach (string NavUserIdString in ParentNavList)
  2153. {
  2154. int NavUserId = int.Parse(NavUserIdString);
  2155. UserTradeDaySummary teamStat = db.UserTradeDaySummary.FirstOrDefault(m => m.UserId == NavUserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.BrandId == BrandId && m.QueryCount == QrPayFlag && m.SeoTitle == "team");
  2156. if (teamStat == null)
  2157. {
  2158. teamStat = db.UserTradeDaySummary.Add(new UserTradeDaySummary()
  2159. {
  2160. UserId = NavUserId,
  2161. TradeMonth = TradeMonth,
  2162. TradeDate = TradeDate,
  2163. BrandId = BrandId,
  2164. QueryCount = QrPayFlag,
  2165. SeoTitle = "team",
  2166. }).Entity;
  2167. db.SaveChanges();
  2168. }
  2169. teamStat.NonDirectDebitCapNum += ActCount;
  2170. }
  2171. }
  2172. }
  2173. db.SaveChanges();
  2174. OtherMySqlConn.op("update PosMachinesTwo set QueryCount=1 where Id in (" + ids.TrimEnd(',') + ")");
  2175. }
  2176. }
  2177. }
  2178. catch (Exception ex)
  2179. {
  2180. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "实时执行创客激活数异常");
  2181. }
  2182. db.Dispose();
  2183. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "实时执行创客激活数日志");
  2184. }
  2185. // 统计新增创客数
  2186. public void StartNewUserNum()
  2187. {
  2188. Thread th = new Thread(StartNewUserNumFor);
  2189. th.IsBackground = true;
  2190. th.Start();
  2191. }
  2192. public void StartNewUserNumFor()
  2193. {
  2194. // DateTime end = DateTime.Parse("2022-06-15 00:00:00");
  2195. // DateTime check = DateTime.Parse("2022-06-14");
  2196. // while (check <= end)
  2197. // {
  2198. // StartNewUserNumDo(check.ToString("yyyy-MM-dd"));
  2199. // check = check.AddDays(1);
  2200. // }
  2201. while (true)
  2202. {
  2203. if(DateTime.Now.Hour >= 2)
  2204. {
  2205. StartNewUserNumEverTime();
  2206. }
  2207. Thread.Sleep(120000);
  2208. }
  2209. }
  2210. public void StartNewUserNumDo(object sender)
  2211. {
  2212. OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["Pxc1SqlConnStr"].ToString();
  2213. string date = sender.ToString();
  2214. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), "执行新增创客数日志");
  2215. WebCMSEntities db = new WebCMSEntities();
  2216. try
  2217. {
  2218. string StatDate = date.Replace("-", "");
  2219. string StatMonth = StatDate.Substring(0, 6);
  2220. string start = date + " 00:00:00";
  2221. string end = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  2222. List<string> uids = new List<string>();
  2223. DataTable userDt = OtherMySqlConn.dtable("select Id,ParentNav from Users where QueryCount=0 and AuthFlag=1 and AuthDate>='" + start + "' and AuthDate<'" + end + "'");
  2224. function.WriteLog("人数:" + userDt.Rows.Count + "\n\n", "执行新增创客数日志");
  2225. foreach (DataRow userDr in userDt.Rows)
  2226. {
  2227. int UserId = int.Parse(userDr["Id"].ToString());
  2228. string ParentNav = userDr["ParentNav"].ToString();
  2229. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行新增创客数日志");
  2230. DataTable selfdt = OtherMySqlConn.dtable("select count(Id) from Users where QueryCount=0 and AuthFlag=1 and AuthDate>='" + start + "' and AuthDate<'" + end + "' and ParentUserId=" + UserId + "");
  2231. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行新增创客数日志");
  2232. foreach (DataRow selfDr in selfdt.Rows)
  2233. {
  2234. int AddCount = int.Parse(selfDr[0].ToString());
  2235. PullnewSummary selfStat = db.PullnewSummary.FirstOrDefault(m => m.UserId == UserId && m.StatMonth == StatMonth && m.StatDate == StatDate && m.SeoTitle == "self");
  2236. if (selfStat == null)
  2237. {
  2238. selfStat = db.PullnewSummary.Add(new PullnewSummary()
  2239. {
  2240. UserId = UserId,
  2241. StatMonth = StatMonth,
  2242. StatDate = StatDate,
  2243. SeoTitle = "self",
  2244. }).Entity;
  2245. db.SaveChanges();
  2246. }
  2247. selfStat.RecUserAuthNum += AddCount;
  2248. db.SaveChanges();
  2249. }
  2250. if (!string.IsNullOrEmpty(ParentNav))
  2251. {
  2252. ParentNav += "," + UserId + ",";
  2253. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  2254. foreach (string NavUserIdString in ParentNavList)
  2255. {
  2256. if (!uids.Contains(NavUserIdString + start))
  2257. {
  2258. uids.Add(NavUserIdString + start);
  2259. int NavUserId = int.Parse(NavUserIdString);
  2260. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行新增创客数日志");
  2261. 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 + ",%'");
  2262. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行新增创客数日志");
  2263. foreach (DataRow teamDr in teamDt.Rows)
  2264. {
  2265. int AddCount = int.Parse(teamDr[0].ToString());
  2266. PullnewSummary teamStat = db.PullnewSummary.FirstOrDefault(m => m.UserId == NavUserId && m.StatMonth == StatMonth && m.StatDate == StatDate && m.SeoTitle == "team");
  2267. if (teamStat == null)
  2268. {
  2269. teamStat = db.PullnewSummary.Add(new PullnewSummary()
  2270. {
  2271. UserId = NavUserId,
  2272. StatMonth = StatMonth,
  2273. StatDate = StatDate,
  2274. SeoTitle = "team",
  2275. }).Entity;
  2276. db.SaveChanges();
  2277. }
  2278. teamStat.RecUserAuthNum += AddCount;
  2279. db.SaveChanges();
  2280. }
  2281. }
  2282. }
  2283. }
  2284. }
  2285. OtherMySqlConn.op("update Users set QueryCount=1 where QueryCount=0 and AuthFlag=1 and AuthDate>='" + start + "' and AuthDate<'" + end + "'");
  2286. }
  2287. catch (Exception ex)
  2288. {
  2289. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "执行新增创客数异常");
  2290. }
  2291. db.Dispose();
  2292. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行新增创客数日志");
  2293. Thread.Sleep(60000);
  2294. }
  2295. public void StartNewUserNumEverTime()
  2296. {
  2297. OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["Pxc1SqlConnStr"].ToString();
  2298. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), "实时执行新增创客数日志");
  2299. WebCMSEntities db = new WebCMSEntities();
  2300. try
  2301. {
  2302. DataTable idsDt = OtherMySqlConn.dtable("select Id from Users where QueryCount=0 and AuthFlag=1 and AuthDate is not null limit 50");
  2303. if(idsDt.Rows.Count > 0)
  2304. {
  2305. string ids = "";
  2306. foreach (DataRow idsDr in idsDt.Rows)
  2307. {
  2308. ids += idsDr["Id"].ToString() + ",";
  2309. }
  2310. 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')");
  2311. if(userDt.Rows.Count > 0)
  2312. {
  2313. function.WriteLog("人数:" + userDt.Rows.Count + "\n\n", "实时执行新增创客数日志");
  2314. foreach (DataRow userDr in userDt.Rows)
  2315. {
  2316. string StatDate = userDr[1].ToString();
  2317. int UserId = int.Parse(userDr["ParentUserId"].ToString());
  2318. string StatMonth = StatDate.Substring(0, 6);
  2319. string date = StatDate.Substring(0, 4) + "-" + StatDate.Substring(4, 2) + "-" + StatDate.Substring(6, 2);
  2320. string start = date + " 00:00:00";
  2321. string end = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  2322. int AddCount = int.Parse(userDr[2].ToString());
  2323. Users user = db.Users.FirstOrDefault(m => m.Id == UserId) ?? new Users();
  2324. string ParentNav = user.ParentNav;
  2325. PullnewSummary selfStat = db.PullnewSummary.FirstOrDefault(m => m.UserId == UserId && m.StatMonth == StatMonth && m.StatDate == StatDate && m.SeoTitle == "self");
  2326. if (selfStat == null)
  2327. {
  2328. selfStat = db.PullnewSummary.Add(new PullnewSummary()
  2329. {
  2330. UserId = UserId,
  2331. StatMonth = StatMonth,
  2332. StatDate = StatDate,
  2333. SeoTitle = "self",
  2334. }).Entity;
  2335. db.SaveChanges();
  2336. }
  2337. selfStat.RecUserAuthNum += AddCount;
  2338. ParentNav += "," + UserId + ",";
  2339. if (!string.IsNullOrEmpty(ParentNav))
  2340. {
  2341. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  2342. foreach (string NavUserIdString in ParentNavList)
  2343. {
  2344. int NavUserId = int.Parse(NavUserIdString);
  2345. PullnewSummary teamStat = db.PullnewSummary.FirstOrDefault(m => m.UserId == NavUserId && m.StatMonth == StatMonth && m.StatDate == StatDate && m.SeoTitle == "team");
  2346. if (teamStat == null)
  2347. {
  2348. teamStat = db.PullnewSummary.Add(new PullnewSummary()
  2349. {
  2350. UserId = NavUserId,
  2351. StatMonth = StatMonth,
  2352. StatDate = StatDate,
  2353. SeoTitle = "team",
  2354. }).Entity;
  2355. db.SaveChanges();
  2356. }
  2357. teamStat.RecUserAuthNum += AddCount;
  2358. }
  2359. }
  2360. }
  2361. db.SaveChanges();
  2362. OtherMySqlConn.op("update Users set QueryCount=1 where Id in (" + ids.TrimEnd(',') + ")");
  2363. }
  2364. }
  2365. }
  2366. catch (Exception ex)
  2367. {
  2368. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "实时执行新增创客数异常");
  2369. }
  2370. db.Dispose();
  2371. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "实时执行新增创客数日志");
  2372. }
  2373. // 每天统计头一天的收益
  2374. public void StatProfit()
  2375. {
  2376. Thread th = new Thread(StatProfitDo);
  2377. th.IsBackground = true;
  2378. th.Start();
  2379. }
  2380. public void StatProfitDo()
  2381. {
  2382. // DateTime end = DateTime.Parse("2022-06-16 00:00:00");
  2383. // DateTime check = DateTime.Parse("2022-06-16");
  2384. // while (check <= end)
  2385. // {
  2386. // StatProfitEverDay(check.ToString("yyyy-MM-dd"));
  2387. // Thread.Sleep(1000);
  2388. // check = check.AddDays(1);
  2389. // }
  2390. while (true)
  2391. {
  2392. if(DateTime.Now.Hour >= 2)
  2393. {
  2394. StatProfitEverDayEverTime();
  2395. }
  2396. Thread.Sleep(120000);
  2397. }
  2398. }
  2399. public void StatProfitEverDay(object sender)
  2400. {
  2401. OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["Pxc1SqlConnStr"].ToString();
  2402. string date = sender.ToString();
  2403. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), "执行昨天收益日志");
  2404. WebCMSEntities db = new WebCMSEntities();
  2405. try
  2406. {
  2407. string TradeDate = date.Replace("-", "");
  2408. string TradeMonth = TradeDate.Substring(0, 6);
  2409. string start = date + " 00:00:00";
  2410. string end = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  2411. string startId = "0";
  2412. List<string> uids = new List<string>();
  2413. DataTable startDt = OtherMySqlConn.dtable("select min(Id) from UserAccountRecord where CreateDate>='" + start + "'");
  2414. if (startDt.Rows.Count > 0)
  2415. {
  2416. startId = startDt.Rows[0][0].ToString();
  2417. }
  2418. function.WriteLog(startId + "\n\n", "执行昨天收益日志");
  2419. 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 + "')");
  2420. function.WriteLog("交易人数:" + userDt.Rows.Count + "\n\n", "执行昨天收益日志");
  2421. foreach (DataRow userDr in userDt.Rows)
  2422. {
  2423. int UserId = int.Parse(userDr["Id"].ToString());
  2424. string ParentNav = userDr["ParentNav"].ToString();
  2425. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天收益日志");
  2426. 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");
  2427. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天收益日志");
  2428. foreach (DataRow selfDr in selfdt.Rows)
  2429. {
  2430. int ChangeType = int.Parse(selfDr["ChangeType"].ToString());
  2431. int ProductType = int.Parse(selfDr["ProductType"].ToString());
  2432. decimal ProfitAmount = decimal.Parse(selfDr[2].ToString());
  2433. UserRebateDetail selfStat = db.UserRebateDetail.FirstOrDefault(m => m.UserId == UserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.RebateType == ChangeType && m.ProductType == ProductType && m.SeoTitle == "self");
  2434. if (selfStat == null)
  2435. {
  2436. selfStat = db.UserRebateDetail.Add(new UserRebateDetail()
  2437. {
  2438. UserId = UserId,
  2439. TradeMonth = TradeMonth,
  2440. TradeDate = TradeDate,
  2441. RebateType = ChangeType,
  2442. ProductType = ProductType,
  2443. SeoTitle = "self",
  2444. }).Entity;
  2445. db.SaveChanges();
  2446. }
  2447. selfStat.CreditRewardAmount += ProfitAmount;
  2448. db.SaveChanges();
  2449. }
  2450. if (!string.IsNullOrEmpty(ParentNav))
  2451. {
  2452. ParentNav += "," + UserId + ",";
  2453. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  2454. foreach (string NavUserIdString in ParentNavList)
  2455. {
  2456. if (!uids.Contains(NavUserIdString + start))
  2457. {
  2458. uids.Add(NavUserIdString + start);
  2459. int NavUserId = int.Parse(NavUserIdString);
  2460. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天收益日志");
  2461. 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");
  2462. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天收益日志");
  2463. foreach (DataRow teamDr in teamDt.Rows)
  2464. {
  2465. int ChangeType = int.Parse(teamDr["ChangeType"].ToString());
  2466. int ProductType = int.Parse(teamDr["ProductType"].ToString());
  2467. decimal ProfitAmount = decimal.Parse(teamDr[2].ToString());
  2468. UserRebateDetail teamStat = db.UserRebateDetail.FirstOrDefault(m => m.UserId == NavUserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.RebateType == ChangeType && m.ProductType == ProductType && m.SeoTitle == "team");
  2469. if (teamStat == null)
  2470. {
  2471. teamStat = db.UserRebateDetail.Add(new UserRebateDetail()
  2472. {
  2473. UserId = NavUserId,
  2474. TradeMonth = TradeMonth,
  2475. TradeDate = TradeDate,
  2476. RebateType = ChangeType,
  2477. ProductType = ProductType,
  2478. SeoTitle = "team",
  2479. }).Entity;
  2480. db.SaveChanges();
  2481. }
  2482. teamStat.CreditRewardAmount += ProfitAmount;
  2483. db.SaveChanges();
  2484. }
  2485. }
  2486. }
  2487. }
  2488. }
  2489. }
  2490. catch (Exception ex)
  2491. {
  2492. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "统计昨天收益异常");
  2493. }
  2494. db.Dispose();
  2495. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天收益日志");
  2496. }
  2497. public void StatProfitEverDayEverTime()
  2498. {
  2499. OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["Pxc1SqlConnStr"].ToString();
  2500. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), "实时统计收益日志");
  2501. WebCMSEntities db = new WebCMSEntities();
  2502. try
  2503. {
  2504. string startId = function.ReadInstance("/UserAccountRecord/Id.txt");
  2505. if(string.IsNullOrEmpty(startId))
  2506. {
  2507. startId = "160653";
  2508. }
  2509. DataTable idsDt = OtherMySqlConn.dtable("select Id from UserAccountRecord where Id>=" + startId + " and QueryCount=0 order by Id limit 50");
  2510. if(idsDt.Rows.Count > 0)
  2511. {
  2512. string ids = "";
  2513. foreach (DataRow idsDr in idsDt.Rows)
  2514. {
  2515. ids += idsDr["Id"].ToString() + ",";
  2516. startId = idsDr["Id"].ToString();
  2517. }
  2518. 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')");
  2519. if (userDt.Rows.Count > 0)
  2520. {
  2521. function.WriteLog("收益人数:" + userDt.Rows.Count + "\n\n", "实时统计收益日志");
  2522. foreach (DataRow userDr in userDt.Rows)
  2523. {
  2524. int UserId = int.Parse(userDr["UserId"].ToString());
  2525. int ChangeType = int.Parse(userDr["ChangeType"].ToString());
  2526. int ProductType = int.Parse(userDr["ProductType"].ToString());
  2527. string TradeDate = userDr[3].ToString();
  2528. decimal ProfitAmount = decimal.Parse(userDr[4].ToString());
  2529. string TradeMonth = TradeDate.Substring(0, 6);
  2530. string date = TradeDate.Substring(0, 4) + "-" + TradeDate.Substring(4, 2) + "-" + TradeDate.Substring(6, 2);
  2531. string start = date + " 00:00:00";
  2532. string end = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  2533. Users user = db.Users.FirstOrDefault(m => m.Id == UserId) ?? new Users();
  2534. string ParentNav = user.ParentNav;
  2535. UserRebateDetail selfStat = db.UserRebateDetail.FirstOrDefault(m => m.UserId == UserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.RebateType == ChangeType && m.ProductType == ProductType && m.SeoTitle == "self");
  2536. if (selfStat == null)
  2537. {
  2538. selfStat = db.UserRebateDetail.Add(new UserRebateDetail()
  2539. {
  2540. UserId = UserId,
  2541. TradeMonth = TradeMonth,
  2542. TradeDate = TradeDate,
  2543. RebateType = ChangeType,
  2544. ProductType = ProductType,
  2545. SeoTitle = "self",
  2546. }).Entity;
  2547. db.SaveChanges();
  2548. }
  2549. selfStat.CreditRewardAmount += ProfitAmount;
  2550. ParentNav += "," + UserId + ",";
  2551. if (!string.IsNullOrEmpty(ParentNav))
  2552. {
  2553. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  2554. foreach (string NavUserIdString in ParentNavList)
  2555. {
  2556. int NavUserId = int.Parse(NavUserIdString);
  2557. UserRebateDetail teamStat = db.UserRebateDetail.FirstOrDefault(m => m.UserId == NavUserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.RebateType == ChangeType && m.ProductType == ProductType && m.SeoTitle == "team");
  2558. if (teamStat == null)
  2559. {
  2560. teamStat = db.UserRebateDetail.Add(new UserRebateDetail()
  2561. {
  2562. UserId = NavUserId,
  2563. TradeMonth = TradeMonth,
  2564. TradeDate = TradeDate,
  2565. RebateType = ChangeType,
  2566. ProductType = ProductType,
  2567. SeoTitle = "team",
  2568. }).Entity;
  2569. db.SaveChanges();
  2570. }
  2571. teamStat.CreditRewardAmount += ProfitAmount;
  2572. }
  2573. }
  2574. }
  2575. db.SaveChanges();
  2576. OtherMySqlConn.op("update UserAccountRecord set QueryCount=1 where Id in (" + ids.TrimEnd(',') + ")");
  2577. function.WritePage("/UserAccountRecord/", "Id.txt", startId);
  2578. }
  2579. }
  2580. }
  2581. catch (Exception ex)
  2582. {
  2583. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "实时统计收益异常");
  2584. }
  2585. db.Dispose();
  2586. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "实时统计收益日志");
  2587. }
  2588. #region 判断品牌互斥条件,根据身份证号
  2589. public bool CheckRepeatByBrand(WebCMSEntities db, int MerchantId)
  2590. {
  2591. int check = db.PosMachinesTwo.Count(m => m.Status > -1 && m.BindMerchantId == MerchantId);
  2592. return false;
  2593. }
  2594. #endregion
  2595. }
  2596. }