public static async Task Repair_SZCAddToRedis_gp() { while (true) { try { List <string> listRange = new List <string>(); var orderService = new Sports_Manager(); var list = orderService.QueryAllRunningOrder_gp(); if (list.Count > 0) { var max = RedisOrderBusiness.Max_PrizeListCount; //var ctzqlist = from p in list // where p.GameCode == "CTZQ" || p.GameCode == "OZB" || p.GameCode == "SJB" // group p by new { p.GameCode, p.IssuseNumber, p.GameType } into g // select new // { // g.Key // };//"CQSSC", "JX11X5", "SD11X5", "GD11X5", "GDKLSF", "JSKS", "SDKLPK3" var gpclist = list.Where(p => p.GameCode == "CQSSC" || p.GameCode == "JX11X5" || p.GameCode == "SD11X5" || p.GameCode == "GD11X5" || p.GameCode == "GDKLSF" || p.GameCode == "JSKS" || p.GameCode == "SDKLPK3") .GroupBy(p => new { p.GameCode, p.IssuseNumber }).Select(a => a.Key).ToList(); foreach (var item in gpclist) { var gpc = GetRedisList_gp(item.GameCode, item.IssuseNumber, max); if (gpc != null) { listRange.AddRange(gpc); } } var BJDClist = list.Where(p => p.GameCode == "BJDC").GroupBy(p => new { p.GameCode, p.IssuseNumber }).Select(a => a.Key).ToList(); foreach (var item in BJDClist) { var BJDC = GetRedisList_gp(item.GameCode, item.IssuseNumber, max); if (BJDC != null) { listRange.AddRange(BJDC); } } var jclist = list.Where(p => p.GameCode == "JCZQ" || p.GameCode == "JCLQ").GroupBy(p => new { p.GameCode, p.IssuseNumber }).Select(a => a.Key).ToList(); foreach (var item in jclist) { var jc = GetRedisList_gp(item.GameCode, item.IssuseNumber, max); if (jc != null) { listRange.AddRange(jc); } } foreach (var order in list) { if (listRange.Count(a => a.Contains(order.SchemeId)) == 0) { BusinessHelper.AddToRunningOrder(order); } //var flag = GetRedisOrKey(order, Max_PrizeListCount); //if (flag) //{ // var count = orderInfoList.Count(a => a.SchemeId == order.SchemeId); // if (count == 0) // flag = true; // BusinessHelper.AddToRunningOrder(order); //} } } } catch (Exception ex) { } await Task.Delay(10 * 60 * 1000); } }
/// <summary> /// 修复未开奖数字彩订单无法加入redis /// </summary> /// <returns></returns> //public static async Task Repair_SZCAddToRedis() //{ // while (true) // { // try // { // //1.DLT|SSQ|FC3D|PL3|CQSSC|GD11X5|SD11X5|JX11X5 // var GameCodes = "DLT|SSQ|FC3D|PL3|CQSSC|GD11X5|SD11X5|JX11X5"; // var orderService = new Sports_Manager(); // var list = orderService.QueryAllRunningOrder(); // CSRedis.CSRedisClient db = null; // foreach (var item in GameCodes.Split('|', StringSplitOptions.None)) // { // if (item == "CTZQ") // db = RedisHelperEx.DB_Running_Order_CTZQ; // if (new string[] { "SSQ", "DLT", "FC3D", "PL3", "OZB" }.Contains(item)) // db = RedisHelperEx.DB_Running_Order_SCZ_DP; // if (new string[] { "CQSSC", "JX11X5", "SD11X5", "GD11X5", "GDKLSF", "JSKS", "SDKLPK3" }.Contains(item)) // db = RedisHelperEx.DB_Running_Order_SCZ_GP; // //if (db == null) // // throw new Exception(string.Format("找不到{0}对应的库", item)); // var gameList = list.Where(p => p.GameCode == item).ToList(); // foreach (var issuseNumber in gameList.GroupBy(p => p.IssuseNumber)) // { // var issuseNumberList = list.Where(p => p.IssuseNumber == issuseNumber.Key).ToList(); // Dictionary<string, List<RedisOrderInfo>> redisIList = new Dictionary<string, List<RedisOrderInfo>>(); // foreach (var runningItem in issuseNumberList) // { // var fullKey = (item.ToUpper() == "CTZQ" || item.ToUpper() == "OZB") ? string.Format("{0}_{1}_{2}_{3}", runningItem.GameCode, runningItem.GameType, RedisKeys.Key_Running_Order_List, runningItem.IssuseNumber) : // string.Format("{0}_{1}_{2}", runningItem.GameCode, RedisKeys.Key_Running_Order_List, runningItem.IssuseNumber); // //var keycount = db.LLen(fullKey); // List<RedisOrderInfo> redisFullList = new List<RedisOrderInfo>(); // if (!redisIList.Keys.Contains(fullKey)) // { // var redisList = db.LRang(fullKey, 0, -1); // if (redisList != null) // { // foreach (var redisListItem in redisList) // { // var jsonItem = JsonHelper.Deserialize<RedisOrderInfo>(redisListItem); // redisFullList.Add(jsonItem); // } // //redisFullList = redisList; // redisIList.Add(fullKey, redisFullList); // } // } // else // { // redisFullList = redisIList[fullKey]; // } // //判断redis中是否存在 // if (redisFullList.Count > 0) // { // var oldRedisItem = redisFullList.FirstOrDefault(p => p.SchemeId == runningItem.SchemeId); // //不存在,则需要加入redis // if (oldRedisItem == null) // { // BusinessHelper.AddToRunningOrder(runningItem.SchemeId); // } // } // else // { // BusinessHelper.AddToRunningOrder(runningItem.SchemeId); // } // } // } // } // //2.竞彩与北单的加入redis // #region 北单与竞彩 // var bdList = list.Where(p => p.GameCode == "BJDC").ToList(); // var beiDb = RedisHelperEx.DB_Running_Order_BJDC; // foreach (var bdItem in bdList.GroupBy(p => p.IssuseNumber)) // { // var fullKey = string.Format("{0}_{1}_{2}", "BJDC", RedisKeys.Key_Running_Order_List, bdItem.Key); // var redisFullList = beiDb.LRang(fullKey, 0, -1); // //判断北单是否存在于redis // foreach (var bItem in bdList) // { // if (redisFullList != null) // { // var hasOldModel = redisFullList.FirstOrDefault(p => p.EndsWith(bItem.SchemeId)); // if (hasOldModel == null) BusinessHelper.AddToRunningOrder(bItem.SchemeId); // } // else // { // BusinessHelper.AddToRunningOrder(bItem.SchemeId); // } // } // } // //JCZQ // var Max_PrizeListCount = RedisOrderBusiness.Max_PrizeListCount; // var jcDb = RedisHelperEx.DB_Running_Order_JC; // var allJCZQKeys = new List<string>(); // for (int i = 0; i < Max_PrizeListCount; i++) // { // var fullKeyNew = string.Format("{0}_{1}_{2}", "JCZQ", RedisKeys.Key_Running_Order_List, i); // allJCZQKeys.Add(fullKeyNew); // } // var allRedisJCZQList = new List<string>(); // foreach (var item in allJCZQKeys) // { // var jclist = jcDb.LRang(item, 0, -1); // if (jclist != null) // { // allRedisJCZQList.AddRange(jclist); // } // } // var jczqList = list.Where(p => p.GameCode == "JCZQ").ToList(); // //判断JCZQ数据是否在redis存在 // foreach (var item in jczqList) // { // if (allRedisJCZQList.Count > 0) // { // var oldmodel = allJCZQKeys.FirstOrDefault(p => p.EndsWith(item.SchemeId)); // if (oldmodel == null) BusinessHelper.AddToRunningOrder(item.SchemeId); // } // else // { // BusinessHelper.AddToRunningOrder(item.SchemeId); // } // } // //JCLQ // var allJCLQKeys = new List<string>(); // for (int i = 0; i < Max_PrizeListCount; i++) // { // var fullKeyNew = string.Format("{0}_{1}_{2}", "JCLQ", RedisKeys.Key_Running_Order_List, i); // allJCLQKeys.Add(fullKeyNew); // } // var allRedisJCLQList = new List<string>(); // foreach (var item in allJCLQKeys) // { // var jclist = jcDb.LRang(item, 0, -1); // if (jclist != null) // { // allRedisJCLQList.AddRange(jclist); // } // } // var jclqList = list.Where(p => p.GameCode == "JCLQ").ToList(); // //判断JCLQ数据是否在redis存在 // foreach (var item in jclqList) // { // if (allRedisJCLQList.Count > 0) // { // var oldmodel = allJCLQKeys.FirstOrDefault(p => p.EndsWith(item.SchemeId)); // if (oldmodel == null) BusinessHelper.AddToRunningOrder(item.SchemeId); // } // else // { // BusinessHelper.AddToRunningOrder(item.SchemeId); // } // } // #endregion // } // catch (Exception ex) // { // } // await Task.Delay(10 * 60 * 1000); // } //} public static async Task Repair_SZCAddToRedis_dp() { while (true) { try { List <string> listRange = new List <string>(); var orderService = new Sports_Manager(); var list = orderService.QueryAllRunningOrder_dp(); if (list.Count > 0) { var max = RedisOrderBusiness.Max_PrizeListCount; //var ctzqlist = from p in list // where p.GameCode == "CTZQ" || p.GameCode == "OZB" || p.GameCode == "SJB" // group p by new { p.GameCode, p.IssuseNumber, p.GameType } into g // select new // { // g.Key // }; var ctzqlist = list.Where(p => p.GameCode == "CTZQ").GroupBy(p => new { p.GameCode, p.IssuseNumber, p.GameType }).Select(a => a.Key).ToList(); foreach (var item in ctzqlist) { var ctzq = GetRedisList_dp(item.GameCode, item.IssuseNumber, max, item.GameType); if (ctzq != null) { listRange.AddRange(ctzq); } } var ssqlist = list.Where(p => p.GameCode == "SSQ").GroupBy(p => new { p.GameCode, p.IssuseNumber }).Select(a => a.Key).ToList(); foreach (var item in ssqlist) { var ssq = GetRedisList_dp(item.GameCode, item.IssuseNumber, max); if (ssq != null) { listRange.AddRange(ssq); } } var dltlist = list.Where(p => p.GameCode == "DLT").GroupBy(p => new { p.GameCode, p.IssuseNumber }).Select(a => a.Key).ToList(); foreach (var item in dltlist) { var dlt = GetRedisList_dp(item.GameCode, item.IssuseNumber, max); if (dlt != null) { listRange.AddRange(dlt); } } var fc3dlist = list.Where(p => p.GameCode == "FC3D").GroupBy(p => new { p.GameCode, p.IssuseNumber }).Select(a => a.Key).ToList(); foreach (var item in fc3dlist) { var fc3d = GetRedisList_dp(item.GameCode, item.IssuseNumber, max); if (fc3d != null) { listRange.AddRange(fc3d); } } var PL3list = list.Where(p => p.GameCode == "PL3").GroupBy(p => new { p.GameCode, p.IssuseNumber }).Select(a => a.Key).ToList(); foreach (var item in fc3dlist) { var PL3 = GetRedisList_dp(item.GameCode, item.IssuseNumber, max); if (PL3 != null) { listRange.AddRange(PL3); } } foreach (var order in list) { if (listRange.Count(a => a.Contains(order.SchemeId)) == 0) { BusinessHelper.AddToRunningOrder(order); } //var flag = GetRedisOrKey(order, Max_PrizeListCount); //if (flag) //{ // var count = orderInfoList.Count(a => a.SchemeId == order.SchemeId); // if (count == 0) // flag = true; // BusinessHelper.AddToRunningOrder(order); //} } } } catch (Exception ex) { } await Task.Delay(1 * 60 * 60 * 1000); } }