public void CreateLiveCollection() { MatchAnalysis manalysis = new MatchAnalysis(); manalysis.CommandTimeout = 0; manalysis.ContextOptions.LazyLoadingEnabled = true; manalysis.live_Table_lib.MergeOption = MergeOption.NoTracking; DateTime dt_now = DateTime.Now.AddDays(-1); var today_ma = manalysis.live_Table_lib.Where(e => e.match_time.Value > dt_now); foreach (var ma in today_ma) { LiveDataETLsDocument ldata = new LiveDataETLsDocument(); ldata._id = ma.live_table_lib_id*1000; ldata.live = 1; ldata.html_position = ma.html_position; ldata.home_team_big = ma.home_team_big; ldata.away_team_big = ma.away_team_big; ldata.match_type = ma.match_type; ldata.match_time = ma.match_time; ldata.asia_odds = ma.status; ldata.home_team = ma.home_team; ldata.away_team = ma.away_team; ldata.home_red_card = ma.home_red_card; ldata.away_red_card = ma.away_red_card; ldata.full_home_goals = ma.full_home_goals; ldata.full_away_goals = ma.full_away_goals; ldata.half_home_goals = ma.half_home_goals; ldata.half_away_goals = ma.half_away_goals; if (LiveMatchETL.matches.Contains(ldata.match_type)) mongo_LiveDataETL.MongoDropColCreateCol.Insert(ldata); } Console.WriteLine("live_Table_lib->mongo->ok"); }
public void CreateLiveCollection() { MatchAnalysis manalysis = new MatchAnalysis(); manalysis.CommandTimeout = 0; manalysis.ContextOptions.LazyLoadingEnabled = true; manalysis.live_Table_lib.MergeOption = MergeOption.NoTracking; DateTime dt_now = DateTime.Now.AddDays(-1); var today_ma = manalysis.Live_Single.ToLookup(e => e.Home_team_big + "," + e.Away_team_big); ScorePredict sp = new ScorePredict(); var docs = sp.mongo_ScorePredict.QueryMongo(); foreach (var doc in docs) { string match = doc.home_team_big.ToString() + "," + doc.away_team_big.ToString(); if (today_ma.Contains(match)) { ScorePredictForCnDocument spc = new ScorePredictForCnDocument(); spc._id = doc._id; spc.match_type = doc.match_type; spc.match_time = (DateTime)doc.match_time.Value.AddHours(8);//修正时间的问题 spc.home_team = doc.home_team; spc.away_team = doc.away_team; spc.asia_odds = ConvertOdd(doc.home_team, doc.asia_odds); spc.pnn_310values = doc.pnn_310values; spc.grnn_310values = doc.grnn_310values; spc.grnn_home_goals = doc.grnn_home_goals; spc.grnn_away_goals = doc.grnn_away_goals; if (Math.Abs(spc.asia_odds) > 0.25 && spc.pnn_310values * spc.asia_odds > 0 && spc.grnn_310values * spc.asia_odds > 0 && spc.grnn_home_goals != spc.grnn_away_goals) spc.cn_odds = "***"; mongo_ScorePredictForCn.MongoDropColCreateCol.Insert(spc); } } Console.WriteLine("ScorePredictForCnDocument->mongo->ok"); }
public void CreateCollection() { MatchAnalysis manalysis = new MatchAnalysis(); manalysis.CommandTimeout = 0; manalysis.ContextOptions.LazyLoadingEnabled = true; manalysis.live_Table_lib.MergeOption = MergeOption.NoTracking; ILookup<string, result_tb_lib> lookup_matchType = manalysis.result_tb_lib.ToLookup(e => e.match_type); LiveDataETLs ldata = new LiveDataETLs(); foreach (var today_m in ldata.mongo_LiveDataETL.QueryMongo()) { CreateHostCollection(lookup_matchType, today_m); CreateAwayCollection(lookup_matchType, today_m); CreateJzCollection(lookup_matchType, today_m); } Console.WriteLine("HistoryDataTopDetail->mongo->ok"); }