StatService.cs 121 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978
  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(JobMqMsg jobInfo)
  17. {
  18. string content = "";
  19. try
  20. {
  21. string doDate = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
  22. string flag = function.ReadInstance("/Stat/" + doDate + ".txt");
  23. if (string.IsNullOrEmpty(flag))
  24. {
  25. function.WritePage("/Stat/", doDate + ".txt", DateTime.Now.ToString("HH:mm:ss"));
  26. // dosomething1(doDate);
  27. // dosomething11(doDate);
  28. // dosomething2(doDate);
  29. StartEverDay(doDate);
  30. dosomething4(doDate);
  31. ListenFluxRecord(doDate);
  32. }
  33. string Msg = "success";
  34. jobInfo.Status = Msg == "success" ? 1 : 0;
  35. jobInfo.Msg = Msg == "success" ? "执行完成" : Msg;
  36. RabbitMQClient.Instance.SendMsg(Newtonsoft.Json.JsonConvert.SerializeObject(jobInfo), "PublicBack");
  37. }
  38. catch (Exception ex)
  39. {
  40. if (!string.IsNullOrEmpty(content))
  41. {
  42. Dictionary<string, string> data = new Dictionary<string, string>();
  43. data.Add("ErrTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
  44. data.Add("ErrMsg", ex.ToString());
  45. function.WriteLog(Newtonsoft.Json.JsonConvert.SerializeObject(data), "public_err");
  46. }
  47. else
  48. {
  49. function.WriteLog(DateTime.Now.ToString() + ":" + ex.ToString(), "public_service");
  50. }
  51. }
  52. }
  53. public void ActiveReward(JobMqMsg jobInfo)
  54. {
  55. string content = "";
  56. try
  57. {
  58. dosomething3();
  59. string Msg = "success";
  60. jobInfo.Status = Msg == "success" ? 1 : 0;
  61. jobInfo.Msg = Msg == "success" ? "执行完成" : Msg;
  62. RabbitMQClient.Instance.SendMsg(Newtonsoft.Json.JsonConvert.SerializeObject(jobInfo), "PublicBack");
  63. function.WritePage("/static/", "act.txt", DateTime.Now.ToString());
  64. }
  65. catch (Exception ex)
  66. {
  67. if (!string.IsNullOrEmpty(content))
  68. {
  69. Dictionary<string, string> data = new Dictionary<string, string>();
  70. data.Add("ErrTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
  71. data.Add("ErrMsg", ex.ToString());
  72. function.WriteLog(Newtonsoft.Json.JsonConvert.SerializeObject(data), "public_err");
  73. }
  74. else
  75. {
  76. function.WriteLog(DateTime.Now.ToString() + ":" + ex.ToString(), "public_service");
  77. }
  78. }
  79. }
  80. public void clear()
  81. {
  82. RedisDbconn.Instance.Clear("TotalAmount*");
  83. RedisDbconn.Instance.Clear("TotalCloudPayAmount*");
  84. RedisDbconn.Instance.Clear("TotalPosAmount*");
  85. RedisDbconn.Instance.Clear("TeamTotalAmount*");
  86. RedisDbconn.Instance.Clear("TeamTotalCloudPayAmount*");
  87. RedisDbconn.Instance.Clear("TeamTotalPosAmount*");
  88. // RedisDbconn.Instance.Clear("TotalUser*");
  89. // RedisDbconn.Instance.Clear("TeamTotalUser*");
  90. // RedisDbconn.Instance.Clear("AddUser*");
  91. // RedisDbconn.Instance.Clear("TeamAddUser*");
  92. // RedisDbconn.Instance.Clear("TotalPosMerchant*");
  93. // RedisDbconn.Instance.Clear("TeamTotalPosMerchant*");
  94. RedisDbconn.Instance.Clear("MerTotalAmount*");
  95. }
  96. // 1. 前一天的绑定记录和创客信息匹配,设置商户型创客
  97. public void dosomething1(string date)
  98. {
  99. // TODO: 每天扫描非商户型创客的持有机具数量
  100. SpModels.WebCMSEntities spdb = new SpModels.WebCMSEntities();
  101. WebCMSEntities db = new WebCMSEntities();
  102. DateTime yesterday = DateTime.Parse(date + " 00:00:00");
  103. DateTime today = DateTime.Parse(DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00");
  104. List<SpModels.BindRecord> binds = spdb.BindRecord.Where(m => m.CreateTime >= yesterday && m.CreateTime < today).ToList();
  105. foreach (SpModels.BindRecord bind in binds)
  106. {
  107. string Mobile = bind.MerNewSnNo;
  108. string MerNo = bind.MerNo;
  109. string BeforeNum = "";
  110. string AfterNum = "";
  111. if (Mobile.Contains("****") && Mobile.Length == 11)
  112. {
  113. BeforeNum = Mobile.Substring(0, 3);
  114. AfterNum = Mobile.Substring(7);
  115. }
  116. string Name = bind.MerName;
  117. if (bind.ProductType == "2")
  118. {
  119. if (Name.Contains("-"))
  120. {
  121. Name = Name.Split('-')[1];
  122. }
  123. else if (Name.Contains("_"))
  124. {
  125. Name = Name.Split('_')[1];
  126. }
  127. }
  128. else if (bind.ProductType == "4")
  129. {
  130. Name = bind.SeoTitle;
  131. }
  132. PxcModels.Users user = db.Users.FirstOrDefault(m => m.Mobile.StartsWith(BeforeNum) && m.Mobile.EndsWith(AfterNum) && m.RealName == Name && m.AuthFlag == 1 && m.MerchantType == 0);
  133. if (user != null)
  134. {
  135. bool checkPos = db.PosMachinesTwo.Any(m => m.UserId == user.Id);
  136. if (!checkPos)
  137. {
  138. PxcModels.MachineForSnNo forSnNo = db.MachineForSnNo.FirstOrDefault(m => m.SnNo == bind.MerSnNo) ?? new PxcModels.MachineForSnNo();
  139. PxcModels.PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == forSnNo.SnId && m.UserId != user.Id);
  140. if (pos != null)
  141. {
  142. pos.UserId = user.Id;
  143. user.MerchantType = 1;
  144. PxcModels.PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.KqMerNo == MerNo) ?? new PxcModels.PosMerchantInfo();
  145. merchant.UserId = user.Id;
  146. merchant.MerUserType = 1;
  147. pos.SeoTitle = user.Id.ToString(); // 记录商户型创客的Id
  148. RedisDbconn.Instance.Set("PosMachinesTwo:" + pos.Id, pos);
  149. db.SaveChanges();
  150. RedisDbconn.Instance.Set("Users:" + user.Id, user);
  151. RedisDbconn.Instance.Set("PosMerchantInfo:" + merchant.Id, merchant);
  152. }
  153. }
  154. }
  155. }
  156. spdb.Dispose();
  157. db.Dispose();
  158. }
  159. // 1. 前一天的商户型创客,判断名下是否3台激活机器,是则变为非商户型创客
  160. public void dosomething11(string date)
  161. {
  162. WebCMSEntities db = new WebCMSEntities();
  163. DateTime yesterday = DateTime.Parse(date + " 00:00:00");
  164. DateTime today = DateTime.Parse(DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00");
  165. var users = db.Users.Select(m => new { m.Id, m.MerchantType }).Where(m => m.MerchantType == 1).ToList();
  166. foreach (var user in users)
  167. {
  168. int machineCount = db.PosMachinesTwo.Count(m => m.UserId == user.Id && m.PosSnType == 0);
  169. int couponCount = db.PosCoupons.Count(m => m.UserId == user.Id && m.IsUse == 0); //判断是否拥有3张券
  170. if (machineCount + couponCount >= 3)
  171. {
  172. Users edit = db.Users.FirstOrDefault(m => m.Id == user.Id);
  173. if (edit != null)
  174. {
  175. edit.MerchantType = 0;
  176. db.SaveChanges();
  177. RedisDbconn.Instance.Set("Users:" + user.Id, edit);
  178. }
  179. }
  180. }
  181. db.Dispose();
  182. }
  183. public void testStatTrade(string date)
  184. {
  185. string yesterday = date + " 00:00:00";
  186. string today = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  187. string TradeMonth = DateTime.Parse(date).ToString("yyyyMM");
  188. string TradeDate = DateTime.Parse(date).ToString("yyyyMMdd");
  189. 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");
  190. foreach (DataRow dr in dt.Rows)
  191. {
  192. int UserId = int.Parse(dr["UserId"].ToString()); //创客ID
  193. int BrandId = int.Parse(dr["BrandId"].ToString()); //品牌
  194. int MerchantId = int.Parse(dr["MerchantId"].ToString()); //商户Id
  195. int BankCardType = int.Parse(dr["BankCardType"].ToString()); //卡类型
  196. int QrPayFlag = int.Parse(dr["QrPayFlag"].ToString()); //云闪付
  197. decimal TradeAmount = decimal.Parse(dr[5].ToString()); //当日交易额
  198. string content = "{";
  199. content += "\"DateString\":\"" + date + "\",";
  200. content += "\"UserId\":\"" + UserId + "\",";
  201. content += "\"BrandId\":\"" + BrandId + "\",";
  202. content += "\"MerchantId\":\"" + MerchantId + "\",";
  203. content += "\"BankCardType\":\"" + BankCardType + "\",";
  204. content += "\"QrPayFlag\":\"" + QrPayFlag + "\",";
  205. content += "\"TradeAmount\":\"" + TradeAmount + "\"";
  206. content += "}";
  207. RedisDbconn.Instance.AddList("TradeStatQueueTest", content);
  208. }
  209. }
  210. // 3. 前一天的激活记录,根据创客类型,如果是商户型创客,则激活奖励的起始人从此人上级计算。如果不是,则从此人开始计算
  211. public void dosomething3(int posid = 0)
  212. {
  213. WebCMSEntities db = new WebCMSEntities();
  214. DateTime yesterday = DateTime.Now.AddDays(-1);
  215. DateTime today = DateTime.Now;
  216. IQueryable<PosMachinesTwo> posList = db.PosMachinesTwo.Where(m => m.ActivationState == 1 && !string.IsNullOrEmpty(m.SeoKeyword));
  217. if (posid > 0)
  218. {
  219. posList = posList.Where(m => m.Id == posid);
  220. }
  221. else
  222. {
  223. posList = posList.Where(m => m.ActivationTime >= yesterday && m.ActivationTime < today);
  224. }
  225. foreach (PosMachinesTwo pos in posList.ToList())
  226. {
  227. // PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId && !string.IsNullOrEmpty(m.MerIdcardNo));
  228. PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  229. if (merchant != null)
  230. {
  231. // PosMerchantOtherInfo otherInfo = db.PosMerchantOtherInfo.FirstOrDefault(m => m.CertId == merchant.MerIdcardNo && m.PrizeFlag1 == 0);
  232. // if (otherInfo != null)
  233. // {
  234. // otherInfo.PrizeFlag1 = 1;
  235. // db.SaveChanges();
  236. string ParentNav = "";
  237. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  238. if (user != null)
  239. {
  240. int GetUserId = user.Id;
  241. ParentNav = user.ParentNav;
  242. int TopUserId = 0;
  243. if (!string.IsNullOrEmpty(ParentNav))
  244. {
  245. TopUserId = int.Parse(ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  246. }
  247. decimal ActPrize = decimal.Parse(function.CheckNum(pos.SeoKeyword));
  248. if (pos.BrandId == 1 || pos.BrandId == 3 || pos.BrandId == 4 || pos.BrandId == 5 || pos.BrandId == 6)
  249. {
  250. ActPrize = ActPrize / 100;
  251. }
  252. if (ActPrize > 0)
  253. {
  254. if (ActPrize == 99)
  255. {
  256. ActPrize = 100;
  257. }
  258. else if (ActPrize == 199)
  259. {
  260. ActPrize = 200;
  261. }
  262. else if (ActPrize == 299)
  263. {
  264. ActPrize = 300;
  265. }
  266. else if (ActPrize == 249)
  267. {
  268. ActPrize = 260;
  269. }
  270. if (GetUserId > 0)
  271. {
  272. doActiveReward(db, merchant, pos, GetUserId, ParentNav, TopUserId, ActPrize);
  273. }
  274. }
  275. }
  276. // }
  277. }
  278. }
  279. db.Dispose();
  280. }
  281. public void doActiveReward(WebCMSEntities db, PosMerchantInfo merchant, PosMachinesTwo pos, int GetUserId, string ParentNav, int TopUserId, decimal ActPrize, int ChangeType = 0)
  282. {
  283. bool check = db.ActiveReward.Any(m => m.KqMerNo == merchant.KqMerNo && m.RewardAmount == ActPrize);
  284. if (!check)
  285. {
  286. Users machineUser = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new Users();
  287. db.ActiveReward.Add(new ActiveReward()
  288. {
  289. CreateDate = DateTime.Now,
  290. UpdateDate = DateTime.Now,
  291. UserId = GetUserId, //创客
  292. MerchantId = pos.BindMerchantId, //商户
  293. StandardDate = pos.ActivationTime, //达标日期
  294. RewardAmount = ActPrize, //奖励金额
  295. BrandId = pos.BrandId, //品牌
  296. UserNav = ParentNav, //创客父级
  297. DirectBuddyNo = merchant.UserId, //商户直属创客
  298. KqMerNo = merchant.KqMerNo, //渠道商户编号
  299. KqSnNo = pos.PosSn, //渠道SN号
  300. SnType = pos.PosSnType, //机具类型
  301. SnApplyUserId = pos.BuyUserId, //机具申请创客
  302. ActType = 0, //激活类型
  303. SnStoreId = pos.StoreId, //SN仓库
  304. RewardTips = "激活奖励", //奖励描述
  305. Remark = "激活奖励", //备注
  306. ActDate = pos.ActivationTime, //激活时间
  307. TopUserId = TopUserId, //顶级创客
  308. SeoTitle = machineUser.RealName,
  309. });
  310. db.SaveChanges();
  311. string IdBrand = GetUserId + "_" + pos.BrandId;
  312. UserMachineData userData = db.UserMachineData.FirstOrDefault(m => m.IdBrand == IdBrand);
  313. if (userData == null)
  314. {
  315. userData = db.UserMachineData.Add(new UserMachineData()
  316. {
  317. IdBrand = IdBrand,
  318. }).Entity;
  319. db.SaveChanges();
  320. }
  321. userData.ActProfit += ActPrize;
  322. db.SaveChanges();
  323. RedisDbconn.Instance.Set("UserMachineData:" + IdBrand, userData);
  324. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == GetUserId);
  325. if (account == null)
  326. {
  327. account = db.UserAccount.Add(new UserAccount()
  328. {
  329. Id = GetUserId,
  330. UserId = GetUserId,
  331. }).Entity;
  332. db.SaveChanges();
  333. }
  334. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  335. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  336. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  337. account.BalanceAmount += ActPrize;
  338. account.TotalAmount += ActPrize;
  339. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  340. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  341. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  342. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  343. {
  344. CreateDate = DateTime.Now,
  345. UpdateDate = DateTime.Now,
  346. UserId = GetUserId, //创客
  347. ChangeType = ChangeType, //变动类型
  348. ProductType = pos.BrandId, //产品类型
  349. ChangeAmount = ActPrize, //变更金额
  350. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  351. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  352. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  353. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  354. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  355. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  356. }).Entity;
  357. db.SaveChanges();
  358. RedisDbconn.Instance.Set("UserAccount:" + GetUserId, account);
  359. string dateString = pos.ActivationTime.Value.ToString("yyyyMMdd");
  360. string monthString = pos.ActivationTime.Value.ToString("yyyyMM");
  361. // 激活奖励列表
  362. List<string> dates = RedisDbconn.Instance.GetList<string>("ActiveRewardDay:" + GetUserId + ":" + pos.BrandId);
  363. if (!dates.Contains(dateString))
  364. {
  365. RedisDbconn.Instance.AddList("ActiveRewardDay:" + GetUserId + ":" + pos.BrandId, dateString);
  366. }
  367. RedisDbconn.Instance.AddNumber("ActiveRewardAmt:" + GetUserId + ":" + pos.BrandId + ":" + dateString, ActPrize);
  368. List<string> months = RedisDbconn.Instance.GetList<string>("ActiveRewardMonth:" + GetUserId + ":" + pos.BrandId);
  369. if (!months.Contains(monthString))
  370. {
  371. RedisDbconn.Instance.AddList("ActiveRewardMonth:" + GetUserId + ":" + pos.BrandId, monthString);
  372. }
  373. RedisDbconn.Instance.AddNumber("ActiveRewardAmt:" + GetUserId + ":" + pos.BrandId + ":" + monthString, ActPrize);
  374. // 激活奖励详情
  375. List<int> actPrizeList = RedisDbconn.Instance.GetList<int>("ActiveRewardDetail:" + GetUserId + ":" + pos.BrandId + ":" + dateString);
  376. if (!actPrizeList.Contains(pos.BindMerchantId))
  377. {
  378. RedisDbconn.Instance.AddList("ActiveRewardDetail:" + GetUserId + ":" + pos.BrandId + ":" + dateString, pos.BindMerchantId);
  379. }
  380. RedisDbconn.Instance.AddNumber("ActiveRewardAmt:mer:" + pos.BindMerchantId + ":" + pos.BrandId + ":" + dateString, ActPrize);
  381. //收支明细
  382. RedisDbconn.Instance.AddList("UserAccountRecord:" + GetUserId + ":1:" + monthString, userAccountRecord);
  383. RedisDbconn.Instance.AddNumber("UserAccount:" + GetUserId + ":1:" + monthString, ActPrize);
  384. RedisDbconn.Instance.Clear("UserAccount:Income:" + GetUserId + ":" + monthString);
  385. }
  386. }
  387. //根据商户信息发放激活奖励
  388. public void dosomething32(int merid = 0)
  389. {
  390. WebCMSEntities db = new WebCMSEntities();
  391. DateTime yesterday = DateTime.Now.AddHours(-3);
  392. DateTime today = DateTime.Now;
  393. IQueryable<PosMerchantInfo> merList = db.PosMerchantInfo.Where(m => m.ActiveStatus == 1 && !string.IsNullOrEmpty(m.SeoKeyword));
  394. if (merid > 0)
  395. {
  396. merList = merList.Where(m => m.Id == merid);
  397. }
  398. else
  399. {
  400. merList = merList.Where(m => m.MerStandardDate >= yesterday && m.MerStandardDate < today);
  401. }
  402. foreach (PosMerchantInfo merchant in merList.ToList())
  403. {
  404. // PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId && !string.IsNullOrEmpty(m.MerIdcardNo));
  405. // PosMerchantOtherInfo otherInfo = db.PosMerchantOtherInfo.FirstOrDefault(m => m.CertId == merchant.MerIdcardNo && m.PrizeFlag1 == 0);
  406. // if (otherInfo != null)
  407. // {
  408. // otherInfo.PrizeFlag1 = 1;
  409. // db.SaveChanges();
  410. MachineForMerNo forMerNo = db.MachineForMerNo.FirstOrDefault(m => m.MerNo == merchant.MerchantNo) ?? new MachineForMerNo();
  411. PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == forMerNo.SnId) ?? new PosMachinesTwo();
  412. string ParentNav = "";
  413. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  414. if (user != null)
  415. {
  416. int GetUserId = user.Id;
  417. ParentNav = user.ParentNav;
  418. int TopUserId = 0;
  419. if (!string.IsNullOrEmpty(ParentNav))
  420. {
  421. TopUserId = int.Parse(ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  422. }
  423. decimal ActPrize = decimal.Parse(function.CheckNum(merchant.SeoKeyword));
  424. if (pos.BrandId == 1 || pos.BrandId == 3)
  425. {
  426. ActPrize = ActPrize / 100;
  427. }
  428. if (ActPrize > 0)
  429. {
  430. bool check = db.ActiveReward.Any(m => m.KqSnNo == pos.PosSn);
  431. if (!check)
  432. {
  433. if (ActPrize == 99)
  434. {
  435. ActPrize = 100;
  436. }
  437. else if (ActPrize == 199)
  438. {
  439. ActPrize = 200;
  440. }
  441. else if (ActPrize == 299)
  442. {
  443. ActPrize = 300;
  444. }
  445. Users machineUser = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new Users();
  446. db.ActiveReward.Add(new ActiveReward()
  447. {
  448. CreateDate = DateTime.Now,
  449. UpdateDate = DateTime.Now,
  450. UserId = GetUserId, //创客
  451. MerchantId = pos.BindMerchantId, //商户
  452. StandardDate = pos.ActivationTime, //达标日期
  453. RewardAmount = ActPrize, //奖励金额
  454. BrandId = pos.BrandId, //品牌
  455. UserNav = ParentNav, //创客父级
  456. DirectBuddyNo = merchant.UserId, //商户直属创客
  457. KqMerNo = merchant.KqMerNo, //渠道商户编号
  458. KqSnNo = pos.PosSn, //渠道SN号
  459. SnType = pos.PosSnType, //机具类型
  460. SnApplyUserId = pos.BuyUserId, //机具申请创客
  461. ActType = 0, //激活类型
  462. SnStoreId = pos.StoreId, //SN仓库
  463. RewardTips = "激活奖励", //奖励描述
  464. Remark = "激活奖励", //备注
  465. ActDate = pos.ActivationTime, //激活时间
  466. TopUserId = TopUserId, //顶级创客
  467. SeoTitle = machineUser.RealName,
  468. });
  469. db.SaveChanges();
  470. string IdBrand = GetUserId + "_" + pos.BrandId;
  471. UserMachineData userData = db.UserMachineData.FirstOrDefault(m => m.IdBrand == IdBrand);
  472. if (userData == null)
  473. {
  474. userData = db.UserMachineData.Add(new UserMachineData()
  475. {
  476. IdBrand = IdBrand,
  477. }).Entity;
  478. db.SaveChanges();
  479. }
  480. userData.ActProfit += ActPrize;
  481. db.SaveChanges();
  482. RedisDbconn.Instance.Set("UserMachineData:" + IdBrand, userData);
  483. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == GetUserId);
  484. if (account == null)
  485. {
  486. account = db.UserAccount.Add(new UserAccount()
  487. {
  488. Id = GetUserId,
  489. UserId = GetUserId,
  490. }).Entity;
  491. db.SaveChanges();
  492. }
  493. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  494. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  495. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  496. account.BalanceAmount += ActPrize;
  497. account.TotalAmount += ActPrize;
  498. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  499. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  500. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  501. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  502. {
  503. CreateDate = DateTime.Now,
  504. UpdateDate = DateTime.Now,
  505. UserId = GetUserId, //创客
  506. ChangeType = 0, //变动类型
  507. ProductType = pos.BrandId, //产品类型
  508. ChangeAmount = ActPrize, //变更金额
  509. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  510. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  511. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  512. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  513. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  514. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  515. }).Entity;
  516. db.SaveChanges();
  517. RedisDbconn.Instance.Set("UserAccount:" + GetUserId, account);
  518. string dateString = pos.ActivationTime.Value.ToString("yyyyMMdd");
  519. string monthString = pos.ActivationTime.Value.ToString("yyyyMM");
  520. // 激活奖励列表
  521. List<string> dates = RedisDbconn.Instance.GetList<string>("ActiveRewardDay:" + GetUserId + ":" + pos.BrandId);
  522. if (!dates.Contains(dateString))
  523. {
  524. RedisDbconn.Instance.AddList("ActiveRewardDay:" + GetUserId + ":" + pos.BrandId, dateString);
  525. }
  526. RedisDbconn.Instance.AddNumber("ActiveRewardAmt:" + GetUserId + ":" + pos.BrandId + ":" + dateString, ActPrize);
  527. List<string> months = RedisDbconn.Instance.GetList<string>("ActiveRewardMonth:" + GetUserId + ":" + pos.BrandId);
  528. if (!months.Contains(monthString))
  529. {
  530. RedisDbconn.Instance.AddList("ActiveRewardMonth:" + GetUserId + ":" + pos.BrandId, monthString);
  531. }
  532. RedisDbconn.Instance.AddNumber("ActiveRewardAmt:" + GetUserId + ":" + pos.BrandId + ":" + monthString, ActPrize);
  533. // 激活奖励详情
  534. List<int> actPrizeList = RedisDbconn.Instance.GetList<int>("ActiveRewardDetail:" + GetUserId + ":" + pos.BrandId + ":" + dateString);
  535. if (!actPrizeList.Contains(pos.BindMerchantId))
  536. {
  537. RedisDbconn.Instance.AddList("ActiveRewardDetail:" + GetUserId + ":" + pos.BrandId + ":" + dateString, pos.BindMerchantId);
  538. }
  539. RedisDbconn.Instance.AddNumber("ActiveRewardAmt:mer:" + pos.BindMerchantId + ":" + pos.BrandId + ":" + dateString, ActPrize);
  540. //收支明细
  541. RedisDbconn.Instance.AddList("UserAccountRecord:" + GetUserId + ":1:" + monthString, userAccountRecord);
  542. RedisDbconn.Instance.AddNumber("UserAccount:" + GetUserId + ":1:" + monthString, ActPrize);
  543. }
  544. }
  545. }
  546. // }
  547. }
  548. db.Dispose();
  549. }
  550. //3. 前一天的激活记录,根据创客类型,如果是商户型创客,则开机奖励的起始人从此人上级计算。如果不是,则从此人开始计算
  551. public void dosomething4(string date)
  552. {
  553. WebCMSEntities db = new WebCMSEntities();
  554. DateTime yesterday = DateTime.Parse(date + " 00:00:00");
  555. DateTime today = DateTime.Parse(DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00");
  556. 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();
  557. foreach (PosMachinesTwo pos in posList)
  558. {
  559. if (pos.BindingTime > DateTime.Now.AddDays(-30))
  560. {
  561. decimal ActPrize = decimal.Parse(function.CheckNum(pos.SeoKeyword));
  562. if (ActPrize > 0)
  563. {
  564. // PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId && !string.IsNullOrEmpty(m.MerIdcardNo));
  565. PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
  566. if (merchant != null)
  567. {
  568. // PosMerchantOtherInfo otherInfo = db.PosMerchantOtherInfo.FirstOrDefault(m => m.CertId == merchant.MerIdcardNo && m.PrizeFlag2 == 0);
  569. // if (otherInfo != null)
  570. // {
  571. // otherInfo.PrizeFlag2 = 1;
  572. // db.SaveChanges();
  573. // 从机具所属人上级开始分开机奖励
  574. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  575. if (user != null)
  576. {
  577. if (!string.IsNullOrEmpty(user.ParentNav))
  578. {
  579. decimal Prize = 20;
  580. string[] ParentNavs = user.ParentNav.Trim(',').Replace(",,", ",").Split(',');
  581. for (int i = ParentNavs.Length - 1; i >= 0; i--)
  582. {
  583. int UserId = int.Parse(ParentNavs[i]);
  584. Users puser = db.Users.FirstOrDefault(m => m.Id == UserId && m.AuthFlag == 1);
  585. if (puser != null && Prize > 0)
  586. {
  587. int machineCount = db.PosMachinesTwo.Count(m => m.BuyUserId == puser.Id && m.PosSnType == 0); //判断是否拥有3台购买机
  588. int ActiveCount = db.PosMachinesTwo.Count(m => m.BuyUserId == puser.Id && m.ActivationState == 1); //判断是否拥有3台激活机(不限购买或赠送)
  589. int couponCount = db.PosCoupons.Count(m => m.UserId == puser.Id && m.IsUse == 0); //判断是否拥有3张券
  590. // int BigCount = db.PosMachinesTwo.Count(m => m.UserId == puser.Id && m.BrandId == 3); //判断是否拥有2台大机
  591. // int BigActiveCount = db.PosMachinesTwo.Count(m => m.UserId == puser.Id && m.ActivationState == 1 && m.BrandId == 3); //判断是否拥有2台激活大机(不限购买或赠送)
  592. if (machineCount + ActiveCount + couponCount >= 3)
  593. {
  594. int pTopUserId = 0;
  595. if (!string.IsNullOrEmpty(puser.ParentNav))
  596. {
  597. pTopUserId = int.Parse(puser.ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  598. }
  599. Users machineUser = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new Users();
  600. OpenRewardDetail detail = db.OpenRewardDetail.Add(new OpenRewardDetail()
  601. {
  602. CreateDate = DateTime.Now,
  603. UpdateDate = DateTime.Now,
  604. TradeMonth = yesterday.ToString("yyyyMM"), //交易月
  605. TradeDate = yesterday, //达标日期
  606. UserId = puser.Id, //创客
  607. BrandId = pos.BrandId, //品牌
  608. ProductName = RelationClass.GetKqProductsInfo(pos.BrandId), //产品名称
  609. MerchantId = pos.BindMerchantId, //商户
  610. DirectUserId = merchant.UserId, //商户直属人
  611. SnNo = pos.PosSn, //SN号
  612. MerNo = merchant.KqMerNo, //渠道商户号
  613. SnType = pos.PosSnType, //机具类型
  614. StandardDate = pos.ActivationTime, //商户的激活日期
  615. SnStoreId = pos.StoreId, //SN仓库
  616. MerBuddyType = puser.MerchantType, //商户创客类型
  617. RewardType = 1, //奖励类型 1-开机直接奖励,2-开机间接奖励
  618. RewardTips = "开机奖励", //奖励描述
  619. CreditTradeAmt = pos.CreditTrade, //贷记卡交易总金额
  620. DebitTradeAmt = pos.DebitCardTrade, //借记卡交易总金额
  621. CreditRewardAmount = Prize, //贷记卡交易奖励金额
  622. RewardDesc = "开机奖励", //奖励描述
  623. TopUserId = pTopUserId, //顶级创客
  624. SeoTitle = machineUser.RealName,
  625. }).Entity;
  626. db.OpenReward.Add(new OpenReward()
  627. {
  628. CreateDate = DateTime.Now,
  629. UpdateDate = DateTime.Now,
  630. TradeMonth = yesterday.ToString("yyyyMM"), //交易月
  631. TradeDate = DateTime.Now, //达标日期
  632. UserId = puser.Id, //创客
  633. BrandId = pos.BrandId, //品牌
  634. RewardType = 2, //奖励类型
  635. CreditTradeAmt = pos.CreditTrade, //贷记卡交易总金额
  636. DebitTradeAmt = pos.DebitCardTrade, //借记卡交易总金额
  637. CreditRewardAmount = Prize, //贷记卡交易奖励金额
  638. RewardDesc = "开机奖励", //奖励描述
  639. TopUserId = pTopUserId, //顶级创客
  640. });
  641. string IdBrand = puser.Id + "_" + pos.BrandId;
  642. UserMachineData userData = db.UserMachineData.FirstOrDefault(m => m.IdBrand == IdBrand);
  643. if (userData == null)
  644. {
  645. userData = db.UserMachineData.Add(new UserMachineData()
  646. {
  647. IdBrand = IdBrand,
  648. }).Entity;
  649. db.SaveChanges();
  650. }
  651. userData.OpenProfit += Prize;
  652. db.SaveChanges();
  653. RedisDbconn.Instance.Set("UserMachineData:" + IdBrand, userData);
  654. //账户入库
  655. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == puser.Id);
  656. if (account == null)
  657. {
  658. account = db.UserAccount.Add(new UserAccount()
  659. {
  660. Id = puser.Id,
  661. UserId = puser.Id,
  662. }).Entity;
  663. db.SaveChanges();
  664. }
  665. //收支明细入库
  666. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  667. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  668. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  669. account.BalanceAmount += Prize;
  670. account.TotalAmount += Prize;
  671. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  672. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  673. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  674. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  675. {
  676. CreateDate = DateTime.Now,
  677. UpdateDate = DateTime.Now,
  678. UserId = puser.Id, //创客
  679. ChangeType = 50, //变动类型
  680. ProductType = pos.BrandId, //产品类型
  681. ChangeAmount = Prize, //变更金额
  682. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  683. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  684. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  685. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  686. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  687. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  688. }).Entity;
  689. db.SaveChanges();
  690. RedisDbconn.Instance.Set("UserAccount:" + puser.Id, account);
  691. string dateString = yesterday.ToString("yyyyMMdd");
  692. string monthString = yesterday.ToString("yyyyMM");
  693. // 开机奖励列表
  694. List<string> dates = RedisDbconn.Instance.GetList<string>("OpenRewardDay:" + puser.Id + ":" + pos.BrandId);
  695. if (!dates.Contains(dateString))
  696. {
  697. RedisDbconn.Instance.AddList("OpenRewardDay:" + puser.Id + ":" + pos.BrandId, dateString);
  698. }
  699. RedisDbconn.Instance.AddNumber("OpenRewardAmt:" + puser.Id + ":" + pos.BrandId + ":" + dateString, Prize);
  700. List<string> months = RedisDbconn.Instance.GetList<string>("OpenRewardMonth:" + puser.Id + ":" + pos.BrandId);
  701. if (!months.Contains(monthString))
  702. {
  703. RedisDbconn.Instance.AddList("OpenRewardMonth:" + puser.Id + ":" + pos.BrandId, monthString);
  704. }
  705. RedisDbconn.Instance.AddNumber("OpenRewardAmt:" + puser.Id + ":" + pos.BrandId + ":" + monthString, Prize);
  706. // 开机奖励详情
  707. RedisDbconn.Instance.AddList("OpenRewardDetail:" + puser.Id + ":" + pos.BrandId + ":" + dateString, detail);
  708. //收支明细
  709. RedisDbconn.Instance.AddList("UserAccountRecord:" + puser.Id + ":1:" + monthString, userAccountRecord);
  710. RedisDbconn.Instance.AddNumber("UserAccount:" + puser.Id + ":1:" + monthString, Prize);
  711. Prize -= 10;
  712. }
  713. }
  714. }
  715. }
  716. }
  717. // }
  718. }
  719. }
  720. }
  721. }
  722. db.Dispose();
  723. }
  724. public void dosomething42(string date)
  725. {
  726. WebCMSEntities db = new WebCMSEntities();
  727. DateTime yesterday = DateTime.Parse(date + " 00:00:00");
  728. DateTime today = DateTime.Parse(DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00");
  729. List<PosMerchantInfo> merList = db.PosMerchantInfo.Where(m => m.ActiveStatus == 1 && m.MerStandardDate >= yesterday && m.MerStandardDate < today && !string.IsNullOrEmpty(m.SeoKeyword) && m.SeoKeyword != "0").ToList();
  730. foreach (PosMerchantInfo merchant in merList)
  731. {
  732. MachineForMerNo forMerNo = db.MachineForMerNo.FirstOrDefault(m => m.MerNo == merchant.MerchantNo) ?? new MachineForMerNo();
  733. PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == forMerNo.SnId) ?? new PosMachinesTwo();
  734. if (pos.ActivationTime > DateTime.Now.AddDays(-20) && pos.CreditTrade >= 1000)
  735. {
  736. decimal ActPrize = decimal.Parse(function.CheckNum(merchant.SeoKeyword));
  737. if (ActPrize > 0)
  738. {
  739. // PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId && !string.IsNullOrEmpty(m.MerIdcardNo));
  740. // PosMerchantOtherInfo otherInfo = db.PosMerchantOtherInfo.FirstOrDefault(m => m.CertId == merchant.MerIdcardNo && m.PrizeFlag2 == 0);
  741. // if (otherInfo != null)
  742. // {
  743. // otherInfo.PrizeFlag2 = 1;
  744. // db.SaveChanges();
  745. // 从机具所属人上级开始分开机奖励
  746. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
  747. if (user != null)
  748. {
  749. if (!string.IsNullOrEmpty(user.ParentNav))
  750. {
  751. decimal Prize = 20;
  752. string[] ParentNavs = user.ParentNav.Trim(',').Replace(",,", ",").Split(',');
  753. for (int i = ParentNavs.Length - 1; i >= 0; i--)
  754. {
  755. int UserId = int.Parse(ParentNavs[i]);
  756. Users puser = db.Users.FirstOrDefault(m => m.Id == UserId && m.AuthFlag == 1);
  757. if (puser != null && Prize > 0)
  758. {
  759. int machineCount = db.PosMachinesTwo.Count(m => m.UserId == puser.Id && m.PosSnType == 0); //判断是否拥有3台购买机
  760. int ActiveCount = db.PosMachinesTwo.Count(m => m.UserId == puser.Id && m.ActivationState == 1); //判断是否拥有3台激活机(不限购买或赠送)
  761. int couponCount = db.PosCoupons.Count(m => m.UserId == puser.Id && m.IsUse == 0); //判断是否拥有3张券
  762. // int BigCount = db.PosMachinesTwo.Count(m => m.UserId == puser.Id && m.BrandId == 3); //判断是否拥有2台大机
  763. // int BigActiveCount = db.PosMachinesTwo.Count(m => m.UserId == puser.Id && m.ActivationState == 1 && m.BrandId == 3); //判断是否拥有2台激活大机(不限购买或赠送)
  764. if (machineCount + ActiveCount + couponCount >= 3)
  765. {
  766. int pTopUserId = 0;
  767. if (!string.IsNullOrEmpty(puser.ParentNav))
  768. {
  769. pTopUserId = int.Parse(puser.ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
  770. }
  771. Users machineUser = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new Users();
  772. OpenRewardDetail detail = db.OpenRewardDetail.Add(new OpenRewardDetail()
  773. {
  774. CreateDate = DateTime.Now,
  775. UpdateDate = DateTime.Now,
  776. TradeMonth = yesterday.ToString("yyyyMM"), //交易月
  777. TradeDate = yesterday, //达标日期
  778. UserId = puser.Id, //创客
  779. BrandId = pos.BrandId, //品牌
  780. ProductName = RelationClass.GetKqProductsInfo(pos.BrandId), //产品名称
  781. MerchantId = pos.BindMerchantId, //商户
  782. DirectUserId = merchant.UserId, //商户直属人
  783. SnNo = pos.PosSn, //SN号
  784. MerNo = merchant.KqMerNo, //渠道商户号
  785. SnType = pos.PosSnType, //机具类型
  786. StandardDate = pos.ActivationTime, //商户的激活日期
  787. SnStoreId = pos.StoreId, //SN仓库
  788. MerBuddyType = puser.MerchantType, //商户创客类型
  789. RewardType = 1, //奖励类型 1-开机直接奖励,2-开机间接奖励
  790. RewardTips = "开机奖励", //奖励描述
  791. CreditTradeAmt = pos.CreditTrade, //贷记卡交易总金额
  792. DebitTradeAmt = pos.DebitCardTrade, //借记卡交易总金额
  793. CreditRewardAmount = Prize, //贷记卡交易奖励金额
  794. RewardDesc = "开机奖励", //奖励描述
  795. TopUserId = pTopUserId, //顶级创客
  796. SeoTitle = machineUser.RealName,
  797. }).Entity;
  798. db.OpenReward.Add(new OpenReward()
  799. {
  800. CreateDate = DateTime.Now,
  801. UpdateDate = DateTime.Now,
  802. TradeMonth = yesterday.ToString("yyyyMM"), //交易月
  803. TradeDate = DateTime.Now, //达标日期
  804. UserId = puser.Id, //创客
  805. BrandId = pos.BrandId, //品牌
  806. RewardType = 2, //奖励类型
  807. CreditTradeAmt = pos.CreditTrade, //贷记卡交易总金额
  808. DebitTradeAmt = pos.DebitCardTrade, //借记卡交易总金额
  809. CreditRewardAmount = Prize, //贷记卡交易奖励金额
  810. RewardDesc = "开机奖励", //奖励描述
  811. TopUserId = pTopUserId, //顶级创客
  812. });
  813. string IdBrand = puser.Id + "_" + pos.BrandId;
  814. UserMachineData userData = db.UserMachineData.FirstOrDefault(m => m.IdBrand == IdBrand);
  815. if (userData == null)
  816. {
  817. userData = db.UserMachineData.Add(new UserMachineData()
  818. {
  819. IdBrand = IdBrand,
  820. }).Entity;
  821. db.SaveChanges();
  822. }
  823. userData.OpenProfit += Prize;
  824. db.SaveChanges();
  825. RedisDbconn.Instance.Set("UserMachineData:" + IdBrand, userData);
  826. //账户入库
  827. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == puser.Id);
  828. if (account == null)
  829. {
  830. account = db.UserAccount.Add(new UserAccount()
  831. {
  832. Id = puser.Id,
  833. UserId = puser.Id,
  834. }).Entity;
  835. db.SaveChanges();
  836. }
  837. //收支明细入库
  838. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  839. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  840. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  841. account.BalanceAmount += Prize;
  842. account.TotalAmount += Prize;
  843. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  844. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  845. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  846. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  847. {
  848. CreateDate = DateTime.Now,
  849. UpdateDate = DateTime.Now,
  850. UserId = puser.Id, //创客
  851. ChangeType = 50, //变动类型
  852. ProductType = pos.BrandId, //产品类型
  853. ChangeAmount = Prize, //变更金额
  854. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  855. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  856. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  857. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  858. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  859. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  860. }).Entity;
  861. db.SaveChanges();
  862. RedisDbconn.Instance.Set("UserAccount:" + puser.Id, account);
  863. string dateString = yesterday.ToString("yyyyMMdd");
  864. string monthString = yesterday.ToString("yyyyMM");
  865. // 开机奖励列表
  866. List<string> dates = RedisDbconn.Instance.GetList<string>("OpenRewardDay:" + puser.Id + ":" + pos.BrandId);
  867. if (!dates.Contains(dateString))
  868. {
  869. RedisDbconn.Instance.AddList("OpenRewardDay:" + puser.Id + ":" + pos.BrandId, dateString);
  870. }
  871. RedisDbconn.Instance.AddNumber("OpenRewardAmt:" + puser.Id + ":" + pos.BrandId + ":" + dateString, Prize);
  872. List<string> months = RedisDbconn.Instance.GetList<string>("OpenRewardMonth:" + puser.Id + ":" + pos.BrandId);
  873. if (!months.Contains(monthString))
  874. {
  875. RedisDbconn.Instance.AddList("OpenRewardMonth:" + puser.Id + ":" + pos.BrandId, monthString);
  876. }
  877. RedisDbconn.Instance.AddNumber("OpenRewardAmt:" + puser.Id + ":" + pos.BrandId + ":" + monthString, Prize);
  878. // 开机奖励详情
  879. RedisDbconn.Instance.AddList("OpenRewardDetail:" + puser.Id + ":" + pos.BrandId + ":" + dateString, detail);
  880. //收支明细
  881. RedisDbconn.Instance.AddList("UserAccountRecord:" + puser.Id + ":1:" + monthString, userAccountRecord);
  882. RedisDbconn.Instance.AddNumber("UserAccount:" + puser.Id + ":1:" + monthString, Prize);
  883. Prize -= 10;
  884. }
  885. }
  886. }
  887. }
  888. }
  889. // }
  890. }
  891. }
  892. }
  893. db.Dispose();
  894. }
  895. // 4. 前一天的流量卡记录和匹配
  896. public void ListenFluxRecord(string date)
  897. {
  898. Thread th = new Thread(CheckFluxForTrade);
  899. th.IsBackground = true;
  900. th.Start(date);
  901. }
  902. public void doFluxRecord(string date)
  903. {
  904. function.WriteLog(DateTime.Now.ToString(), "执行流量费返佣");
  905. SpModels.WebCMSEntities spdb = new SpModels.WebCMSEntities();
  906. WebCMSEntities db = new WebCMSEntities();
  907. DateTime yesterday = DateTime.Parse(date + " 00:00:00");
  908. DateTime today = DateTime.Parse(DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00");
  909. List<SpModels.TradeFluxRecord> trades = spdb.TradeFluxRecord.Where(m => m.CreateDate >= yesterday && m.CreateDate < today && m.Status == 1).ToList();
  910. foreach (SpModels.TradeFluxRecord trade in trades)
  911. {
  912. try
  913. {
  914. string OrderNo = trade.TradeSerialNo; //单号
  915. DateTime TradeDate = trade.CreateDate.Value;
  916. string TradeMonth = TradeDate.ToString("yyyyMM");
  917. decimal FeeAmount = trade.FeeAmount; //流量费
  918. if (trade.ProductType == "1" || trade.ProductType == "4")
  919. {
  920. FeeAmount = FeeAmount / 100;
  921. }
  922. string TradeSnNo = trade.TradeSnNo; //机具SN
  923. decimal FluxProfit = 0;
  924. if (trade.ProductType == "1" && FeeAmount == 60)
  925. {
  926. FluxProfit = 24;
  927. }
  928. else if (trade.ProductType != "1" && FeeAmount == 48)
  929. {
  930. FluxProfit = 12;
  931. }
  932. if (FluxProfit > 0)
  933. {
  934. MachineForSnNo forSnNo = db.MachineForSnNo.FirstOrDefault(m => m.SnNo == TradeSnNo) ?? new MachineForSnNo();
  935. PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == forSnNo.SnId) ?? new PosMachinesTwo();
  936. PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId) ?? new PosMerchantInfo();
  937. bool checkExist = db.FluxProfitDetail.Any(m => m.MerNo == merchant.KqMerNo);
  938. if (!checkExist)
  939. {
  940. Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new Users();
  941. int GetUserId = user.Id;
  942. int TopUserId = 0;
  943. string ParentNav = user.ParentNav;
  944. if (!string.IsNullOrEmpty(ParentNav))
  945. {
  946. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  947. if (ParentNavList.Length > 1)
  948. {
  949. TopUserId = int.Parse(ParentNavList[1]);
  950. }
  951. else if (ParentNavList.Length == 1)
  952. {
  953. TopUserId = int.Parse(ParentNavList[0]);
  954. }
  955. }
  956. FluxProfitSummary fluxProfit = db.FluxProfitSummary.FirstOrDefault(m => m.UserId == GetUserId && m.BrandId == pos.BrandId && m.TradeMonth == TradeMonth);
  957. if (fluxProfit == null)
  958. {
  959. fluxProfit = db.FluxProfitSummary.Add(new FluxProfitSummary()
  960. {
  961. CreateDate = DateTime.Now,
  962. UpdateDate = DateTime.Now,
  963. UserId = GetUserId, //创客
  964. BrandId = pos.BrandId,
  965. TopUserId = TopUserId, //顶级创客
  966. TradeMonth = TradeMonth, //交易月
  967. MerUserType = user.MerchantType, //商户创客类型
  968. Remark = "流量卡分佣", //备注
  969. }).Entity;
  970. db.SaveChanges();
  971. }
  972. fluxProfit.FluxProfitAmt += FluxProfit; //流量分润总金额
  973. db.FluxProfitDetail.Add(new FluxProfitDetail()
  974. {
  975. CreateDate = DateTime.Now,
  976. UpdateDate = DateTime.Now,
  977. RecordNo = OrderNo, //单号
  978. TradeDate = TradeDate.ToString("yyyyMMdd"), //交易日期
  979. TradeTime = TradeDate.ToString("HHmmss"), //交易时间
  980. TradeMonth = TradeMonth, //交易月
  981. UserId = GetUserId, //创客
  982. MerchantId = pos.BindMerchantId, //商户
  983. MerchantUserId = pos.UserId, //商户直属人
  984. MerNo = merchant.KqMerNo, //渠道商户编号
  985. SnNo = pos.PosSn, //渠道SN号
  986. FluxOrderNo = OrderNo, //流量扣费单号
  987. TradeOrderNo = OrderNo, //交易流水号
  988. TradeAmt = trade.TradeAmount, //商户交易额
  989. FluxFeeAmt = FeeAmount, //流量费
  990. FluxProfitAmt = FluxProfit, //流量分润总金额
  991. PosType = pos.PosSnType.ToString(), //POS类型
  992. Remark = "流量卡分佣", //备注
  993. BrandId = pos.BrandId, //品牌
  994. TopUserId = TopUserId, //顶级创客
  995. MerUserType = user.MerchantType, //商户创客类型
  996. });
  997. string IdBrand = user.Id + "_" + pos.BrandId;
  998. UserMachineData userData = db.UserMachineData.FirstOrDefault(m => m.IdBrand == IdBrand);
  999. if (userData == null)
  1000. {
  1001. userData = db.UserMachineData.Add(new UserMachineData()
  1002. {
  1003. IdBrand = IdBrand,
  1004. }).Entity;
  1005. db.SaveChanges();
  1006. }
  1007. userData.FluxProfit += FluxProfit;
  1008. db.SaveChanges();
  1009. RedisDbconn.Instance.Clear("UserMachineData:" + IdBrand);
  1010. UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == GetUserId);
  1011. if (account == null)
  1012. {
  1013. account = db.UserAccount.Add(new UserAccount()
  1014. {
  1015. Id = GetUserId,
  1016. UserId = GetUserId,
  1017. }).Entity;
  1018. db.SaveChanges();
  1019. }
  1020. decimal BeforeTotalAmount = account.TotalAmount; //变更前总金额
  1021. decimal BeforeFreezeAmount = account.FreezeAmount; //变更前冻结金额
  1022. decimal BeforeBalanceAmount = account.BalanceAmount; //变更前余额
  1023. account.BalanceAmount += FluxProfit;
  1024. account.TotalAmount += FluxProfit;
  1025. decimal AfterTotalAmount = account.TotalAmount; //变更后总金额
  1026. decimal AfterFreezeAmount = account.FreezeAmount; //变更后冻结金额
  1027. decimal AfterBalanceAmount = account.BalanceAmount; //变更后余额
  1028. UserAccountRecord userAccountRecord = db.UserAccountRecord.Add(new UserAccountRecord()
  1029. {
  1030. CreateDate = DateTime.Now,
  1031. UpdateDate = DateTime.Now,
  1032. UserId = GetUserId, //创客
  1033. ChangeType = 60, //变动类型
  1034. ProductType = pos.BrandId, //产品类型
  1035. ChangeAmount = FluxProfit, //变更金额
  1036. BeforeTotalAmount = BeforeTotalAmount, //变更前总金额
  1037. AfterTotalAmount = AfterTotalAmount, //变更后总金额
  1038. BeforeFreezeAmount = BeforeFreezeAmount, //变更前冻结金额
  1039. AfterFreezeAmount = AfterFreezeAmount, //变更后冻结金额
  1040. BeforeBalanceAmount = BeforeBalanceAmount, //变更前余额
  1041. AfterBalanceAmount = AfterBalanceAmount, //变更后余额
  1042. }).Entity;
  1043. db.SaveChanges();
  1044. RedisDbconn.Instance.Clear("UserAccount:" + GetUserId);
  1045. }
  1046. SpModels.TradeFluxRecord edit = spdb.TradeFluxRecord.FirstOrDefault(m => m.Id == trade.Id);
  1047. if (edit != null)
  1048. {
  1049. edit.Status = 2;
  1050. spdb.SaveChanges();
  1051. }
  1052. }
  1053. }
  1054. catch (Exception ex)
  1055. {
  1056. function.WriteLog(DateTime.Now.ToString() + "\n$" + trade.Id + "$\n" + ex.ToString(), "流量卡分佣异常");
  1057. }
  1058. }
  1059. spdb.Dispose();
  1060. db.Dispose();
  1061. function.WriteLog(DateTime.Now.ToString() + "\n", "执行流量费返佣");
  1062. }
  1063. public void CheckFluxForTrade(object sender)
  1064. {
  1065. string date = sender.ToString();
  1066. function.WriteLog(DateTime.Now.ToString(), "扫描金控交易记录中的流量费");
  1067. SpModels.WebCMSEntities spdb = new SpModels.WebCMSEntities();
  1068. DateTime start = DateTime.Parse(date + " 00:00:00");
  1069. DateTime end = start.AddDays(1);
  1070. var list = spdb.TradeRecord.Select(m => new { m.Id, m.CreateDate, m.ProductType }).Where(m => m.CreateDate > start && m.CreateDate < end && m.ProductType == "1").OrderBy(m => m.CreateDate);
  1071. foreach (var sub in list.ToList())
  1072. {
  1073. try
  1074. {
  1075. SpModels.TradeRecord trade = spdb.TradeRecord.FirstOrDefault(m => m.Id == sub.Id);
  1076. if (trade != null)
  1077. {
  1078. string content = trade.SeoDescription;
  1079. if (!string.IsNullOrEmpty(content))
  1080. {
  1081. content = System.Web.HttpUtility.UrlDecode(content);
  1082. JsonData jsonObj = JsonMapper.ToObject(content);
  1083. decimal terminalDataFlowFee = decimal.Parse(function.CheckNum(jsonObj["terminalDataFlowFee"].ToString()));
  1084. if (terminalDataFlowFee > 0)
  1085. {
  1086. spdb.TradeFluxRecord.Add(new SpModels.TradeFluxRecord()
  1087. {
  1088. SeoDescription = trade.TradeSerialNo,
  1089. FeeAmount = terminalDataFlowFee,
  1090. TradeSerialNo = function.MD5_16(trade.TradeSerialNo),
  1091. CreateDate = trade.CreateDate,
  1092. TradeSnNo = trade.TradeSnNo,
  1093. ProductType = trade.ProductType,
  1094. Status = 1,
  1095. });
  1096. spdb.SaveChanges();
  1097. }
  1098. }
  1099. }
  1100. }
  1101. catch (Exception ex)
  1102. {
  1103. function.WriteLog(DateTime.Now.ToString() + "\n$" + sub.Id + "$\n" + ex.ToString(), "扫描金控交易记录中的流量费异常");
  1104. }
  1105. }
  1106. spdb.Dispose();
  1107. function.WriteLog(DateTime.Now.ToString() + "\n", "扫描金控交易记录中的流量费");
  1108. doFluxRecord(date);
  1109. }
  1110. // 每天统计头一天的交易额
  1111. public void StartEverDay(string date)
  1112. {
  1113. OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["Pxc1SqlConnStr"].ToString();
  1114. // if(DateTime.Now.Day == 2)
  1115. // {
  1116. // OtherMySqlConn.op("update Users set ThisMonthTrade=0 where ThisMonthTrade>0");
  1117. // }
  1118. // Thread th = new Thread(StatTradeAmountEverDay);
  1119. // th.IsBackground = true;
  1120. // th.Start(date);
  1121. Thread th = new Thread(StartEverDayDo);
  1122. th.IsBackground = true;
  1123. th.Start();
  1124. }
  1125. public void StartEverDayDo()
  1126. {
  1127. DateTime end = DateTime.Parse("2022-06-06 00:00:00");
  1128. DateTime check = DateTime.Parse("2022-03-11");
  1129. while (check <= end)
  1130. {
  1131. StatTradeAmountEverDay(check.ToString("yyyy-MM-dd"));
  1132. Thread.Sleep(1000);
  1133. check = check.AddDays(1);
  1134. }
  1135. }
  1136. public void StatTradeAmountEverDay(object sender)
  1137. {
  1138. string date = sender.ToString();
  1139. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), "执行昨天交易额日志");
  1140. WebCMSEntities db = new WebCMSEntities();
  1141. try
  1142. {
  1143. string TradeDate = date.Replace("-", "");
  1144. string TradeMonth = TradeDate.Substring(0, 6);
  1145. string start = date + " 00:00:00";
  1146. string end = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  1147. string startId = "0";
  1148. List<string> uids = new List<string>();
  1149. DataTable startDt = OtherMySqlConn.dtable("select min(Id) from TradeRecord where CreateDate>='" + start + "'");
  1150. if (startDt.Rows.Count > 0)
  1151. {
  1152. startId = startDt.Rows[0][0].ToString();
  1153. }
  1154. function.WriteLog(startId + "\n\n", "执行昨天交易额日志");
  1155. DataTable userDt = OtherMySqlConn.dtable("select Id,ParentNav from Users where Id in (select DISTINCT UserId from TradeRecord where Id>=" + startId + " and CreateDate>='" + start + "' and CreateDate<'" + end + "')");
  1156. function.WriteLog("交易人数:" + userDt.Rows.Count + "\n\n", "执行昨天交易额日志");
  1157. foreach (DataRow userDr in userDt.Rows)
  1158. {
  1159. int UserId = int.Parse(userDr["Id"].ToString());
  1160. string ParentNav = userDr["ParentNav"].ToString();
  1161. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天交易额日志");
  1162. DataTable selfdt = OtherMySqlConn.dtable("select BrandId,BankCardType,QrPayFlag,MerHelpFlag,CapFlag,sum(TradeAmount),count(Id) from TradeRecord where Id>=" + startId + " and CreateDate>='" + start + "' and CreateDate<'" + end + "' and UserId=" + UserId + " group by BrandId,BankCardType,QrPayFlag,MerHelpFlag,CapFlag");
  1163. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天交易额日志");
  1164. foreach (DataRow selfDr in selfdt.Rows)
  1165. {
  1166. int BrandId = int.Parse(selfDr["BrandId"].ToString());
  1167. int BankCardType = int.Parse(selfDr["BankCardType"].ToString());
  1168. int QrPayFlag = int.Parse(selfDr["QrPayFlag"].ToString());
  1169. int MerHelpFlag = int.Parse(selfDr["MerHelpFlag"].ToString());
  1170. int CapFlag = int.Parse(selfDr["CapFlag"].ToString());
  1171. decimal TradeAmount = decimal.Parse(selfDr[5].ToString());
  1172. int TradeCount = int.Parse(selfDr[6].ToString());
  1173. TradeDaySummary selfStat = db.TradeDaySummary.FirstOrDefault(m => m.UserId == UserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.BrandId == BrandId && m.QueryCount == QrPayFlag && m.SeoTitle == "self");
  1174. if (selfStat == null)
  1175. {
  1176. selfStat = db.TradeDaySummary.Add(new TradeDaySummary()
  1177. {
  1178. UserId = UserId,
  1179. TradeMonth = TradeMonth,
  1180. TradeDate = TradeDate,
  1181. BrandId = BrandId,
  1182. QueryCount = QrPayFlag,
  1183. SeoTitle = "self",
  1184. }).Entity;
  1185. db.SaveChanges();
  1186. }
  1187. if (BankCardType == 0)
  1188. {
  1189. if(MerHelpFlag == 1)
  1190. {
  1191. selfStat.HelpDirectDebitTradeAmt += TradeAmount;
  1192. if(CapFlag == 1)
  1193. {
  1194. selfStat.HelpDirectDebitCapTradeAmt += TradeAmount;
  1195. selfStat.HelpDirectDebitCapNum += TradeCount;
  1196. }
  1197. }
  1198. else
  1199. {
  1200. selfStat.NotHelpDirectDebitTradeAmt += TradeAmount;
  1201. if(CapFlag == 1)
  1202. {
  1203. selfStat.NotHelpDirectDebitCapTradeAmt += TradeAmount;
  1204. selfStat.NotHelpDirectDebitCapNum += TradeCount;
  1205. }
  1206. }
  1207. }
  1208. else if (BankCardType != 0)
  1209. {
  1210. if(MerHelpFlag == 1)
  1211. {
  1212. selfStat.HelpDirectTradeAmt += TradeAmount;
  1213. }
  1214. else
  1215. {
  1216. selfStat.NotHelpDirectTradeAmt += TradeAmount;
  1217. }
  1218. }
  1219. db.SaveChanges();
  1220. }
  1221. if (!string.IsNullOrEmpty(ParentNav))
  1222. {
  1223. ParentNav += "," + UserId + ",";
  1224. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  1225. foreach (string NavUserIdString in ParentNavList)
  1226. {
  1227. if (!uids.Contains(NavUserIdString + start))
  1228. {
  1229. uids.Add(NavUserIdString + start);
  1230. int NavUserId = int.Parse(NavUserIdString);
  1231. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天交易额日志");
  1232. DataTable teamDt = OtherMySqlConn.dtable("select BrandId,BankCardType,QrPayFlag,MerHelpFlag,CapFlag,sum(TradeAmount),count(Id) from TradeRecord 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 BrandId,BankCardType,QrPayFlag,MerHelpFlag,CapFlag");
  1233. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天交易额日志");
  1234. foreach (DataRow teamDr in teamDt.Rows)
  1235. {
  1236. int BrandId = int.Parse(teamDr["BrandId"].ToString());
  1237. int BankCardType = int.Parse(teamDr["BankCardType"].ToString());
  1238. int QrPayFlag = int.Parse(teamDr["QrPayFlag"].ToString());
  1239. int MerHelpFlag = int.Parse(teamDr["MerHelpFlag"].ToString());
  1240. int CapFlag = int.Parse(teamDr["CapFlag"].ToString());
  1241. decimal TradeAmount = decimal.Parse(teamDr[5].ToString());
  1242. int TradeCount = int.Parse(teamDr[6].ToString());
  1243. TradeDaySummary teamStat = db.TradeDaySummary.FirstOrDefault(m => m.UserId == NavUserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.BrandId == BrandId && m.QueryCount == QrPayFlag && m.SeoTitle == "team");
  1244. if (teamStat == null)
  1245. {
  1246. teamStat = db.TradeDaySummary.Add(new TradeDaySummary()
  1247. {
  1248. UserId = NavUserId,
  1249. TradeMonth = TradeMonth,
  1250. TradeDate = TradeDate,
  1251. BrandId = BrandId,
  1252. QueryCount = QrPayFlag,
  1253. SeoTitle = "team",
  1254. }).Entity;
  1255. db.SaveChanges();
  1256. }
  1257. if (BankCardType == 0)
  1258. {
  1259. if(MerHelpFlag == 1)
  1260. {
  1261. teamStat.HelpNonDirectDebitTradeAmt += TradeAmount;
  1262. if(CapFlag == 1)
  1263. {
  1264. teamStat.HelpDirectDebitCapTradeAmt += TradeAmount;
  1265. teamStat.HelpDirectDebitCapNum += TradeCount;
  1266. }
  1267. }
  1268. else
  1269. {
  1270. teamStat.NotHelpNonDirectDebitTradeAmt += TradeAmount;
  1271. if(CapFlag == 1)
  1272. {
  1273. teamStat.NotHelpDirectDebitCapTradeAmt += TradeAmount;
  1274. teamStat.NotHelpDirectDebitCapNum += TradeCount;
  1275. }
  1276. }
  1277. }
  1278. else if (BankCardType != 0)
  1279. {
  1280. if(MerHelpFlag == 1)
  1281. {
  1282. teamStat.HelpNonDirectTradeAmt += TradeAmount;
  1283. }
  1284. else
  1285. {
  1286. teamStat.NotHelpNonDirectTradeAmt += TradeAmount;
  1287. }
  1288. }
  1289. db.SaveChanges();
  1290. OtherMySqlConn.op("update Users set ThisMonthTrade=ThisMonthTrade+"+TradeAmount+" where Id=" + NavUserId);
  1291. }
  1292. }
  1293. }
  1294. }
  1295. }
  1296. }
  1297. catch (Exception ex)
  1298. {
  1299. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "统计昨天的交易额异常");
  1300. }
  1301. db.Dispose();
  1302. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天交易额日志");
  1303. StatMerchantTrade(date);
  1304. }
  1305. public void StatTradeAmountEverDay2(object sender)
  1306. {
  1307. string date = sender.ToString();
  1308. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), "执行昨天交易额日志");
  1309. WebCMSEntities db = new WebCMSEntities();
  1310. try
  1311. {
  1312. OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["Pxc1SqlConnStr"].ToString();
  1313. string TradeDate = date.Replace("-", "");
  1314. string TradeMonth = TradeDate.Substring(0, 6);
  1315. string start = date + " 00:00:00";
  1316. string end = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  1317. string startId = "0", endId = "9999999999";
  1318. List<string> uids = new List<string>();
  1319. DataTable startDt = OtherMySqlConn.dtable("select min(Id) from TradeRecord where CreateDate>='" + start + "'");
  1320. if (startDt.Rows.Count > 0)
  1321. {
  1322. startId = startDt.Rows[0][0].ToString();
  1323. }
  1324. function.WriteLog(startId + "\n\n", "执行昨天交易额日志");
  1325. // DataTable endDt = OtherMySqlConn.dtable("select max(Id) from TradeRecord where CreateDate<'" + end + "'");
  1326. // if (endDt.Rows.Count > 0)
  1327. // {
  1328. // endId = endDt.Rows[0][0].ToString();
  1329. // }
  1330. function.WriteLog("ap到main开始:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), "执行昨天交易额日志");
  1331. Models.WebCMSEntities maindb = new Models.WebCMSEntities();
  1332. DateTime StartDate = DateTime.Parse(start);
  1333. DateTime EndDate = DateTime.Parse(end);
  1334. int StartTradeId = int.Parse(function.CheckInt(startId));
  1335. bool op = true;
  1336. while (op)
  1337. {
  1338. List<TradeRecord> list = db.TradeRecord.Where(m => m.Id > StartTradeId && m.CreateDate >= StartDate && m.CreateDate < EndDate).OrderBy(m => m.Id).Take(500).ToList();
  1339. if (list.Count > 0)
  1340. {
  1341. foreach (TradeRecord sub in list)
  1342. {
  1343. maindb.TradeRecord.Add(new Models.TradeRecord()
  1344. {
  1345. CreateDate = sub.CreateDate,
  1346. UpdateDate = sub.UpdateDate,
  1347. RecordNo = sub.RecordNo, //单号
  1348. UserId = sub.UserId, //创客
  1349. MerchantId = sub.MerchantId, //商户
  1350. MerNo = sub.MerNo, //渠道商户编号
  1351. MerHelpFlag = sub.MerHelpFlag, //是否属于扶持周期内商户
  1352. HelpMonthCount = sub.HelpMonthCount, //扶持第几个月
  1353. MerBuddyType = sub.MerBuddyType, //商户创客类型
  1354. SnNo = sub.SnNo, //渠道SN号
  1355. TradeDate = sub.TradeDate, //交易日期
  1356. ClearDate = sub.ClearDate, //清算日期
  1357. TradeSerialNo = sub.TradeSerialNo, //交易流水号
  1358. TradeAmount = sub.TradeAmount, //交易金额
  1359. BankCardType = sub.BankCardType, //银行卡类型
  1360. QrPayFlag = sub.QrPayFlag, //云闪付标识
  1361. CapFlag = sub.CapFlag, //借记卡封顶交易标志
  1362. DirectFlag = sub.DirectFlag, //是否直营
  1363. BrandId = sub.BrandId, //品牌
  1364. Remark = sub.Remark, //备注
  1365. TopUserId = sub.TopUserId, //顶级创客
  1366. MerUserId = sub.MerUserId, //商户直属创客
  1367. });
  1368. StartTradeId = sub.Id;
  1369. }
  1370. maindb.SaveChanges();
  1371. }
  1372. else
  1373. {
  1374. op = false;
  1375. }
  1376. }
  1377. maindb.Dispose();
  1378. function.WriteLog("ap到main结束:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), "执行昨天交易额日志");
  1379. OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["SqlConnStr"].ToString();
  1380. 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 + "')");
  1381. function.WriteLog("交易人数:" + userDt.Rows.Count + "\n\n", "执行昨天交易额日志");
  1382. foreach (DataRow userDr in userDt.Rows)
  1383. {
  1384. int UserId = int.Parse(userDr["Id"].ToString());
  1385. string ParentNav = userDr["ParentNav"].ToString();
  1386. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天交易额日志");
  1387. 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");
  1388. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天交易额日志");
  1389. foreach (DataRow selfDr in selfdt.Rows)
  1390. {
  1391. int BrandId = int.Parse(selfDr["BrandId"].ToString());
  1392. int BankCardType = int.Parse(selfDr["BankCardType"].ToString());
  1393. int QrPayFlag = int.Parse(selfDr["QrPayFlag"].ToString());
  1394. decimal TradeAmount = decimal.Parse(selfDr[3].ToString());
  1395. UserTradeDaySummary selfStat = db.UserTradeDaySummary.FirstOrDefault(m => m.UserId == UserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.BrandId == BrandId && m.QueryCount == QrPayFlag && m.SeoTitle == "self");
  1396. if (selfStat == null)
  1397. {
  1398. selfStat = db.UserTradeDaySummary.Add(new UserTradeDaySummary()
  1399. {
  1400. UserId = UserId,
  1401. TradeMonth = TradeMonth,
  1402. TradeDate = TradeDate,
  1403. BrandId = BrandId,
  1404. QueryCount = QrPayFlag,
  1405. SeoTitle = "self",
  1406. }).Entity;
  1407. db.SaveChanges();
  1408. }
  1409. if (BankCardType == 0)
  1410. {
  1411. selfStat.DirectDebitTradeAmt += TradeAmount;
  1412. }
  1413. else if (BankCardType != 0)
  1414. {
  1415. selfStat.DirectTradeAmt += TradeAmount;
  1416. }
  1417. db.SaveChanges();
  1418. }
  1419. // RedisDbconn.Instance.Clear("TotalAmount:" + UserId);
  1420. // RedisDbconn.Instance.Clear("TotalAmount:" + UserId + ":" + TradeMonth);
  1421. // RedisDbconn.Instance.Clear("TotalCloudPayAmount:" + UserId + ":" + TradeMonth);
  1422. // RedisDbconn.Instance.Clear("TotalPosAmount:" + UserId + ":" + TradeMonth);
  1423. // RedisDbconn.Instance.Clear("TotalAmount:" + UserId + ":*:" + TradeMonth);
  1424. // RedisDbconn.Instance.Clear("TotalAmount:" + UserId + ":" + TradeDate);
  1425. // RedisDbconn.Instance.Clear("TotalCloudPayAmount:" + UserId + ":" + TradeDate);
  1426. // RedisDbconn.Instance.Clear("TotalPosAmount:" + UserId + ":" + TradeDate);
  1427. // RedisDbconn.Instance.Clear("TotalAmount:" + UserId + ":*:" + TradeDate);
  1428. if (!string.IsNullOrEmpty(ParentNav))
  1429. {
  1430. ParentNav += "," + UserId + ",";
  1431. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  1432. foreach (string NavUserIdString in ParentNavList)
  1433. {
  1434. if (!uids.Contains(NavUserIdString + start))
  1435. {
  1436. uids.Add(NavUserIdString + start);
  1437. int NavUserId = int.Parse(NavUserIdString);
  1438. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天交易额日志");
  1439. 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");
  1440. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天交易额日志");
  1441. foreach (DataRow teamDr in teamDt.Rows)
  1442. {
  1443. int BrandId = int.Parse(teamDr["BrandId"].ToString());
  1444. int BankCardType = int.Parse(teamDr["BankCardType"].ToString());
  1445. int QrPayFlag = int.Parse(teamDr["QrPayFlag"].ToString());
  1446. decimal TradeAmount = decimal.Parse(teamDr[3].ToString());
  1447. UserTradeDaySummary teamStat = db.UserTradeDaySummary.FirstOrDefault(m => m.UserId == NavUserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.BrandId == BrandId && m.QueryCount == QrPayFlag && m.SeoTitle == "team");
  1448. if (teamStat == null)
  1449. {
  1450. teamStat = db.UserTradeDaySummary.Add(new UserTradeDaySummary()
  1451. {
  1452. UserId = NavUserId,
  1453. TradeMonth = TradeMonth,
  1454. TradeDate = TradeDate,
  1455. BrandId = BrandId,
  1456. QueryCount = QrPayFlag,
  1457. SeoTitle = "team",
  1458. }).Entity;
  1459. db.SaveChanges();
  1460. }
  1461. if (BankCardType == 0)
  1462. {
  1463. teamStat.NonDirectDebitTradeAmt += TradeAmount;
  1464. }
  1465. else if (BankCardType != 0)
  1466. {
  1467. teamStat.NonDirectTradeAmt += TradeAmount;
  1468. }
  1469. db.SaveChanges();
  1470. }
  1471. // RedisDbconn.Instance.Clear("TeamTotalAmount:" + NavUserId);
  1472. // RedisDbconn.Instance.Clear("TeamTotalAmount:" + NavUserId + ":" + TradeMonth);
  1473. // RedisDbconn.Instance.Clear("TeamTotalCloudPayAmount:" + NavUserId + ":" + TradeMonth);
  1474. // RedisDbconn.Instance.Clear("TeamTotalPosAmount:" + NavUserId + ":" + TradeMonth);
  1475. // RedisDbconn.Instance.Clear("TeamTotalAmount:" + NavUserId + ":*:" + TradeMonth);
  1476. // RedisDbconn.Instance.Clear("TeamTotalAmount:" + NavUserId + ":" + TradeDate);
  1477. // RedisDbconn.Instance.Clear("TeamTotalCloudPayAmount:" + NavUserId + ":" + TradeDate);
  1478. // RedisDbconn.Instance.Clear("TeamTotalPosAmount:" + NavUserId + ":" + TradeDate);
  1479. // RedisDbconn.Instance.Clear("TeamTotalAmount:" + NavUserId + ":*:" + TradeDate);
  1480. }
  1481. }
  1482. }
  1483. }
  1484. }
  1485. catch (Exception ex)
  1486. {
  1487. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "统计昨天的交易额异常");
  1488. }
  1489. db.Dispose();
  1490. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行昨天交易额日志");
  1491. StatMerchantTrade(date);
  1492. }
  1493. public void StatTradeAmountEverDaySum()
  1494. {
  1495. // WebCMSEntities db = new WebCMSEntities();
  1496. // OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["Pxc1SqlConnStr"].ToString();
  1497. // DataTable dt = OtherMySqlConn.dtable("select UserId,BrandId,QueryCount,TradeDate,TradeMonth,sum(DirectDebitTradeAmt) as DirectDebitTradeAmt,sum(DirectTradeAmt) as DirectTradeAmt,sum(NonDirectDebitTradeAmt) as NonDirectDebitTradeAmt,sum(NonDirectTradeAmt) as NonDirectTradeAmt from UserTradeDaySummary group by UserId,BrandId,QueryCount,TradeDate,TradeMonth order by UserId,BrandId,QueryCount");
  1498. // string html = "<table>";
  1499. // foreach (DataRow dr in dt.Rows)
  1500. // {
  1501. // html += "<tr>";
  1502. // string TradeDate = dr["TradeDate"].ToString();
  1503. // string TradeMonth = dr["TradeMonth"].ToString();
  1504. // int UserId = int.Parse(dr["UserId"].ToString());
  1505. // int BrandId = int.Parse(dr["BrandId"].ToString());
  1506. // int QrPayFlag = int.Parse(dr["QueryCount"].ToString());
  1507. // decimal DirectDebitTradeAmt = decimal.Parse(dr["DirectDebitTradeAmt"].ToString());
  1508. // decimal DirectTradeAmt = decimal.Parse(dr["DirectTradeAmt"].ToString());
  1509. // decimal NonDirectDebitTradeAmt = decimal.Parse(dr["NonDirectDebitTradeAmt"].ToString());
  1510. // decimal NonDirectTradeAmt = decimal.Parse(dr["NonDirectTradeAmt"].ToString());
  1511. // decimal CurAmount = 0, CurTotalAmount = 0, CurMonthAmount = 0, CurDayAmount = 0;
  1512. // CurTotalAmount = RedisDbconn.Instance.Get<decimal>("TotalAmount:" + UserId); //总交易
  1513. // CurMonthAmount = RedisDbconn.Instance.Get<decimal>("TotalAmount:" + UserId + ":" + TradeDate); //总交易
  1514. // CurDayAmount = RedisDbconn.Instance.Get<decimal>("TotalAmount:" + UserId + ":" + TradeMonth); //总交易
  1515. // CurAmount = RedisDbconn.Instance.Get<decimal>("TotalAmount:" + UserId + ":" + BrandId + ":" + TradeDate); //总交易
  1516. // decimal TotalPosAmount = 0;
  1517. // decimal TotalCloudPayAmount = 0;
  1518. // decimal TeamTotalPosAmount = 0;
  1519. // decimal TeamTotalCloudPayAmount = 0;
  1520. // if (QrPayFlag == 1)
  1521. // {
  1522. // TotalCloudPayAmount = RedisDbconn.Instance.Get<decimal>("TotalCloudPayAmount:" + UserId + ":" + TradeDate); //云闪付小额交易额
  1523. // TeamTotalCloudPayAmount = RedisDbconn.Instance.Get<decimal>("TeamTotalCloudPayAmount:" + UserId + ":" + TradeDate); //POS机刷卡交易额
  1524. // }
  1525. // else
  1526. // {
  1527. // TotalPosAmount = RedisDbconn.Instance.Get<decimal>("TotalPosAmount:" + UserId + ":" + TradeDate); //POS机刷卡交易额
  1528. // TeamTotalPosAmount = RedisDbconn.Instance.Get<decimal>("TeamTotalPosAmount:" + UserId + ":" + TradeDate); //云闪付小额交易额
  1529. // }
  1530. // Users user = db.Users.FirstOrDefault(m => m.Id == UserId) ?? new Users();
  1531. // html += "<td>应得</td>";
  1532. // html += "<td>" + user.MakerCode + "</td>";
  1533. // html += "<td>" + user.RealName + "</td>";
  1534. // html += "<td>" + user.Mobile + "</td>";
  1535. // html += "<td>" + BrandId + "</td>";
  1536. // html += "<td>" + QrPayFlag + "</td>";
  1537. // html += "<td>" + DirectDebitTradeAmt + "</td>";
  1538. // html += "<td>" + DirectTradeAmt + "</td>";
  1539. // html += "<td>" + NonDirectDebitTradeAmt + "</td>";
  1540. // html += "<td>" + NonDirectTradeAmt + "</td>";
  1541. // html += "</tr>";
  1542. // html += "<tr>";
  1543. // html += "<td>当前</td>";
  1544. // html += "<td></td>";
  1545. // html += "<td></td>";
  1546. // html += "<td>当天品牌:" + CurAmount + "</td>";
  1547. // html += "<td>总交易:" + CurTotalAmount + "</td>";
  1548. // html += "<td>当月:" + CurMonthAmount + "</td>";
  1549. // html += "<td>当天:" + CurDayAmount + "</td>";
  1550. // html += "<td>" + TotalPosAmount + "</td>";
  1551. // html += "<td>" + TotalCloudPayAmount + "</td>";
  1552. // html += "<td>" + TeamTotalPosAmount + "</td>";
  1553. // html += "<td>" + TeamTotalCloudPayAmount + "</td>";
  1554. // html += "</tr>";
  1555. // }
  1556. // html += "</table>";
  1557. // db.Dispose();
  1558. // // OtherMySqlConn.connstr = ;
  1559. // function.WritePage("/html/", "1.html", html);
  1560. }
  1561. //统计商户交易额
  1562. private void StatMerchantTrade(string date)
  1563. {
  1564. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), "执行商户交易额日志");
  1565. // WebCMSEntities db = new WebCMSEntities();
  1566. try
  1567. {
  1568. string start = date + " 00:00:00";
  1569. string end = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  1570. OtherMySqlConn.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 CreateDate>='" + start + "' and CreateDate<'" + end + "' 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");
  1571. RedisDbconn.Instance.Clear("PosMerchantAmount:*");
  1572. RedisDbconn.Instance.Clear("PosMerchantAmount:*:" + date.Replace("-", "").Substring(0, 6)); //商户当月交易
  1573. RedisDbconn.Instance.Clear("PosMerchantAmount:*:" + date.Replace("-", "")); //商户当日交易
  1574. // foreach (DataRow selfDr in selfdt.Rows)
  1575. // {
  1576. // int BrandId = int.Parse(selfDr["BrandId"].ToString());
  1577. // int MerchantId = int.Parse(selfDr["MerchantId"].ToString());
  1578. // string TradeDate = selfDr["TradeDate"].ToString();
  1579. // TradeDate = TradeDate.Replace("-", "");
  1580. // string TradeMonth = TradeDate.Substring(0, 6);
  1581. // decimal TradeAmount = decimal.Parse(selfDr["TradeAmount"].ToString());
  1582. // PosMerchantTradeSummay merStat = db.PosMerchantTradeSummay.FirstOrDefault(m => m.MerchantId == MerchantId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.BrandId == BrandId);
  1583. // if (merStat == null)
  1584. // {
  1585. // merStat = db.PosMerchantTradeSummay.Add(new PosMerchantTradeSummay()
  1586. // {
  1587. // MerchantId = MerchantId,
  1588. // TradeMonth = TradeMonth,
  1589. // TradeDate = TradeDate,
  1590. // BrandId = BrandId,
  1591. // }).Entity;
  1592. // db.SaveChanges();
  1593. // }
  1594. // merStat.TradeAmount += TradeAmount;
  1595. // db.SaveChanges();
  1596. // }
  1597. }
  1598. catch (Exception ex)
  1599. {
  1600. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "统计商户的交易额");
  1601. }
  1602. // db.Dispose();
  1603. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行商户交易额日志");
  1604. }
  1605. // 5. 创客升级
  1606. public void StatUserLevel()
  1607. {
  1608. Thread th = new Thread(StatUserLevelDo);
  1609. th.IsBackground = true;
  1610. th.Start();
  1611. }
  1612. public void StatUserLevelDo()
  1613. {
  1614. WebCMSEntities db = new WebCMSEntities();
  1615. try
  1616. {
  1617. function.WriteLog(DateTime.Now.ToString(), "创客升级日志");
  1618. DateTime start = DateTime.Parse(DateTime.Now.AddMonths(-1).ToString("yyyy-MM") + "-01 00:00:00");
  1619. DateTime end = start.AddDays(1);
  1620. string TradeMonth = DateTime.Now.AddMonths(-1).ToString("yyyyMM");
  1621. List<UserLevelSet> sets = db.UserLevelSet.ToList();
  1622. var users = db.Users.Select(m => new { m.Id, m.AuthFlag }).Where(m => m.AuthFlag == 1).ToList();
  1623. function.WriteLog(users.Count.ToString(), "创客升级日志");
  1624. foreach (var subuser in users)
  1625. {
  1626. Users user = db.Users.FirstOrDefault(m => m.Id == subuser.Id);
  1627. if (user != null)
  1628. {
  1629. int BeforeLevel = user.UserLevel;
  1630. int AfterLevel = 0;
  1631. decimal TradeAmount = 0;
  1632. bool check = db.UserTradeDaySummary.Any(m => m.UserId == user.Id && m.TradeMonth == TradeMonth && m.SeoTitle == "team");
  1633. if (check)
  1634. {
  1635. TradeAmount = db.UserTradeDaySummary.Where(m => m.UserId == user.Id && m.TradeMonth == TradeMonth && m.SeoTitle == "team").Sum(m => m.NonDirectTradeAmt);
  1636. }
  1637. UserLevelSet set = sets.FirstOrDefault(m => m.UpLevelGrowth <= TradeAmount && m.UpLevelIntegral > TradeAmount);
  1638. if (set != null)
  1639. {
  1640. AfterLevel = set.Id;
  1641. }
  1642. if (AfterLevel > BeforeLevel && AfterLevel > 1)
  1643. {
  1644. user.UserLevel = AfterLevel;
  1645. db.UserRank.Add(new UserRank()
  1646. {
  1647. CreateDate = DateTime.Now,
  1648. UpdateDate = DateTime.Now,
  1649. UserId = user.Id, //创客
  1650. WhiteRank = BeforeLevel,
  1651. Rank = AfterLevel, //当前等级
  1652. StatYear = DateTime.Now.Year, //统计年份
  1653. StatMonth = DateTime.Now.Month, //统计月份
  1654. TradeAmt = TradeAmount, //团队交易总额
  1655. UpgradeFlag = 1, //升级标识
  1656. OperateDate = DateTime.Now, //操作时间
  1657. });
  1658. db.SaveChanges();
  1659. RedisDbconn.Instance.Set("UserLevelData:" + user.Id, BeforeLevel + "#" + AfterLevel);
  1660. }
  1661. }
  1662. }
  1663. function.WriteLog(DateTime.Now.ToString(), "创客升级日志");
  1664. }
  1665. catch (Exception ex)
  1666. {
  1667. function.WriteLog(ex.ToString(), "创客升级异常");
  1668. }
  1669. db.Dispose();
  1670. ProfitHelper.Instance.StatProfit("202204");
  1671. }
  1672. // 统计创客激活数
  1673. public void StartPosActNum()
  1674. {
  1675. Thread th = new Thread(StartPosActNumFor);
  1676. th.IsBackground = true;
  1677. th.Start();
  1678. }
  1679. public void StartPosActNumFor()
  1680. {
  1681. DateTime end = DateTime.Parse("2022-05-26 00:00:00");
  1682. DateTime check = DateTime.Parse("2022-03-11");
  1683. while (check <= end)
  1684. {
  1685. StartPosActNumDo(check.ToString("yyyy-MM-dd"));
  1686. check = check.AddDays(1);
  1687. }
  1688. }
  1689. public void StartPosActNumDo(object sender)
  1690. {
  1691. OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["Pxc1SqlConnStr"].ToString();
  1692. string date = sender.ToString();
  1693. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), "执行创客激活数日志");
  1694. WebCMSEntities db = new WebCMSEntities();
  1695. try
  1696. {
  1697. string TradeDate = date.Replace("-", "");
  1698. string TradeMonth = TradeDate.Substring(0, 6);
  1699. string start = date + " 00:00:00";
  1700. string end = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  1701. List<string> uids = new List<string>();
  1702. 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 + "')");
  1703. function.WriteLog("人数:" + userDt.Rows.Count + "\n\n", "执行创客激活数日志");
  1704. foreach (DataRow userDr in userDt.Rows)
  1705. {
  1706. int UserId = int.Parse(userDr["Id"].ToString());
  1707. string ParentNav = userDr["ParentNav"].ToString();
  1708. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行创客激活数日志");
  1709. 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");
  1710. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行创客激活数日志");
  1711. foreach (DataRow selfDr in selfdt.Rows)
  1712. {
  1713. int BrandId = int.Parse(selfDr["BrandId"].ToString());
  1714. int QrPayFlag = 0;
  1715. int ActCount = int.Parse(selfDr[1].ToString());
  1716. UserTradeDaySummary selfStat = db.UserTradeDaySummary.FirstOrDefault(m => m.UserId == UserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.BrandId == BrandId && m.QueryCount == QrPayFlag && m.SeoTitle == "self");
  1717. if (selfStat == null)
  1718. {
  1719. selfStat = db.UserTradeDaySummary.Add(new UserTradeDaySummary()
  1720. {
  1721. UserId = UserId,
  1722. TradeMonth = TradeMonth,
  1723. TradeDate = TradeDate,
  1724. BrandId = BrandId,
  1725. QueryCount = QrPayFlag,
  1726. SeoTitle = "self",
  1727. }).Entity;
  1728. db.SaveChanges();
  1729. }
  1730. selfStat.DirectDebitCapNum += ActCount;
  1731. db.SaveChanges();
  1732. }
  1733. if (!string.IsNullOrEmpty(ParentNav))
  1734. {
  1735. ParentNav += "," + UserId + ",";
  1736. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  1737. foreach (string NavUserIdString in ParentNavList)
  1738. {
  1739. if (!uids.Contains(NavUserIdString + start))
  1740. {
  1741. uids.Add(NavUserIdString + start);
  1742. int NavUserId = int.Parse(NavUserIdString);
  1743. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行创客激活数日志");
  1744. 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");
  1745. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行创客激活数日志");
  1746. foreach (DataRow teamDr in teamDt.Rows)
  1747. {
  1748. int BrandId = int.Parse(teamDr["BrandId"].ToString());
  1749. int QrPayFlag = 0;
  1750. int ActCount = int.Parse(teamDr[1].ToString());
  1751. UserTradeDaySummary teamStat = db.UserTradeDaySummary.FirstOrDefault(m => m.UserId == NavUserId && m.TradeMonth == TradeMonth && m.TradeDate == TradeDate && m.BrandId == BrandId && m.QueryCount == QrPayFlag && m.SeoTitle == "team");
  1752. if (teamStat == null)
  1753. {
  1754. teamStat = db.UserTradeDaySummary.Add(new UserTradeDaySummary()
  1755. {
  1756. UserId = NavUserId,
  1757. TradeMonth = TradeMonth,
  1758. TradeDate = TradeDate,
  1759. BrandId = BrandId,
  1760. QueryCount = QrPayFlag,
  1761. SeoTitle = "team",
  1762. }).Entity;
  1763. db.SaveChanges();
  1764. }
  1765. teamStat.NonDirectDebitCapNum += ActCount;
  1766. db.SaveChanges();
  1767. }
  1768. }
  1769. }
  1770. }
  1771. }
  1772. OtherMySqlConn.op("update PosMachinesTwo set QueryCount=1 where QueryCount=0 and ActivationState=1 and ActivationTime>='" + start + "' and ActivationTime<'" + end + "'");
  1773. }
  1774. catch (Exception ex)
  1775. {
  1776. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "执行创客激活数异常");
  1777. }
  1778. db.Dispose();
  1779. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行创客激活数日志");
  1780. Thread.Sleep(60000);
  1781. }
  1782. // 统计新增创客数
  1783. public void StartNewUserNum()
  1784. {
  1785. Thread th = new Thread(StartNewUserNumFor);
  1786. th.IsBackground = true;
  1787. th.Start();
  1788. }
  1789. public void StartNewUserNumFor()
  1790. {
  1791. DateTime end = DateTime.Parse("2022-05-26 00:00:00");
  1792. DateTime check = DateTime.Parse("2022-02-20");
  1793. while (check <= end)
  1794. {
  1795. StartNewUserNumDo(check.ToString("yyyy-MM-dd"));
  1796. check = check.AddDays(1);
  1797. }
  1798. }
  1799. public void StartNewUserNumDo(object sender)
  1800. {
  1801. OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["Pxc1SqlConnStr"].ToString();
  1802. string date = sender.ToString();
  1803. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), "执行新增创客数日志");
  1804. WebCMSEntities db = new WebCMSEntities();
  1805. try
  1806. {
  1807. string StatDate = date.Replace("-", "");
  1808. string StatMonth = StatDate.Substring(0, 6);
  1809. string start = date + " 00:00:00";
  1810. string end = DateTime.Parse(date).AddDays(1).ToString("yyyy-MM-dd") + " 00:00:00";
  1811. List<string> uids = new List<string>();
  1812. DataTable userDt = OtherMySqlConn.dtable("select Id,ParentNav from Users where QueryCount=0 and AuthFlag=1 and AuthDate>='" + start + "' and AuthDate<'" + end + "'");
  1813. function.WriteLog("人数:" + userDt.Rows.Count + "\n\n", "执行新增创客数日志");
  1814. foreach (DataRow userDr in userDt.Rows)
  1815. {
  1816. int UserId = int.Parse(userDr["Id"].ToString());
  1817. string ParentNav = userDr["ParentNav"].ToString();
  1818. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行新增创客数日志");
  1819. DataTable selfdt = OtherMySqlConn.dtable("select count(Id) from Users where QueryCount=0 and AuthFlag=1 and AuthDate>='" + start + "' and AuthDate<'" + end + "' and ParentUserId=" + UserId + "");
  1820. function.WriteLog(UserId + ":" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行新增创客数日志");
  1821. foreach (DataRow selfDr in selfdt.Rows)
  1822. {
  1823. int AddCount = int.Parse(selfDr[0].ToString());
  1824. PullnewSummary selfStat = db.PullnewSummary.FirstOrDefault(m => m.UserId == UserId && m.StatMonth == StatMonth && m.StatDate == StatDate && m.SeoTitle == "self");
  1825. if (selfStat == null)
  1826. {
  1827. selfStat = db.PullnewSummary.Add(new PullnewSummary()
  1828. {
  1829. UserId = UserId,
  1830. StatMonth = StatMonth,
  1831. StatDate = StatDate,
  1832. SeoTitle = "self",
  1833. }).Entity;
  1834. db.SaveChanges();
  1835. }
  1836. selfStat.RecUserAuthNum += AddCount;
  1837. db.SaveChanges();
  1838. }
  1839. if (!string.IsNullOrEmpty(ParentNav))
  1840. {
  1841. ParentNav += "," + UserId + ",";
  1842. string[] ParentNavList = ParentNav.Trim(',').Replace(",,", ",").Split(',');
  1843. foreach (string NavUserIdString in ParentNavList)
  1844. {
  1845. if (!uids.Contains(NavUserIdString + start))
  1846. {
  1847. uids.Add(NavUserIdString + start);
  1848. int NavUserId = int.Parse(NavUserIdString);
  1849. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行新增创客数日志");
  1850. 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 + ",%'");
  1851. function.WriteLog(NavUserId + ":team:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行新增创客数日志");
  1852. foreach (DataRow teamDr in teamDt.Rows)
  1853. {
  1854. int AddCount = int.Parse(teamDr[0].ToString());
  1855. PullnewSummary teamStat = db.PullnewSummary.FirstOrDefault(m => m.UserId == NavUserId && m.StatMonth == StatMonth && m.StatDate == StatDate && m.SeoTitle == "team");
  1856. if (teamStat == null)
  1857. {
  1858. teamStat = db.PullnewSummary.Add(new PullnewSummary()
  1859. {
  1860. UserId = NavUserId,
  1861. StatMonth = StatMonth,
  1862. StatDate = StatDate,
  1863. SeoTitle = "team",
  1864. }).Entity;
  1865. db.SaveChanges();
  1866. }
  1867. teamStat.RecUserAuthNum += AddCount;
  1868. db.SaveChanges();
  1869. }
  1870. }
  1871. }
  1872. }
  1873. }
  1874. OtherMySqlConn.op("update Users set QueryCount=1 where QueryCount=0 and AuthFlag=1 and AuthDate>='" + start + "' and AuthDate<'" + end + "'");
  1875. }
  1876. catch (Exception ex)
  1877. {
  1878. function.WriteLog(DateTime.Now.ToString() + "\n" + ex.ToString(), "执行新增创客数异常");
  1879. }
  1880. db.Dispose();
  1881. function.WriteLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\n\n", "执行新增创客数日志");
  1882. Thread.Sleep(60000);
  1883. }
  1884. #region 判断品牌互斥条件,根据身份证号
  1885. public bool CheckRepeatByBrand(WebCMSEntities db, int MerchantId)
  1886. {
  1887. int check = db.PosMachinesTwo.Count(m => m.Status > -1 && m.BindMerchantId == MerchantId);
  1888. return false;
  1889. }
  1890. #endregion
  1891. }
  1892. }