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");
}
