public decimal updateLiveOkoo()
{
DataTable dt = OkooHtml.GetTableOutHtml();
using (DataClassesMatchDataContext match = new DataClassesMatchDataContext(Conn.conn))
{
var ll = match.Live_okoo.Where(e => e.Live_okoo_id > 0);
match.Live_okoo.DeleteAllOnSubmit(ll);//更新后删除
match.SubmitChanges();
foreach (DataRow aa in dt.Rows)
{
if (HtmlTextToStr(aa[15].ToString()) != null)
{
Live_okoo lo = new Live_okoo();
lo.KeyValue = HtmlValueToInt(aa[0].ToString());
lo.LeagueName = HtmlTextToStr(aa[1].ToString());
lo.Match_time = HtmlTextToStr(aa[2].ToString());
lo.MatchOrder1_HomeName = TeamName(aa[3].ToString());
lo.MatchOrder1_HandicapNumber = HtmlTextToStr(aa[4].ToString());
lo.MatchOrder1_AwayName = TeamName(aa[5].ToString());
lo.Ok_1_0 = HtmlTextToStr(aa[6].ToString());
lo.Ok_1_1 = HtmlTextToStr(aa[7].ToString());
lo.Ok_1_2 = HtmlTextToStr(aa[8].ToString());
lo.MatchInfo = HtmlTextToStr(aa[11].ToString());
lo.Match_1_Win = HtmlTextToStr(aa[12].ToString());
lo.Match_1_Drawn = HtmlTextToStr(aa[13].ToString());
lo.Match_1_Lost = HtmlTextToStr(aa[14].ToString());
match.Live_okoo.InsertOnSubmit(lo);
match.SubmitChanges();
}
}
return match.Live_okoo.Max(e => e.Live_okoo_id);
}
}
private void init_table_id_value()
{
using (DataClassesMatchDataContext match = new DataClassesMatchDataContext(Conn.conn))
{
var uri = match.Match_table_xpath.Where(e => e.Uri_host == uri_host).FirstOrDefault();
if (uri.Max_table_id_value.Length > 1)
{
table_id_value = uri.Max_table_id_value;
tablexpath = uri.Max_table_xpath;
}
else
{
if (uri.Second_table_id_value.Length > 1)
{
table_id_value = uri.Second_table_id_value;
tablexpath = uri.Second_table_xpath;
}
else
{
table_id_value = uri.Max_table_xpath;
tablexpath = uri.Max_table_xpath;
}
}
}
}
public decimal updateLiveAibo()
{
DataTable dt = AiboHtml.GetTableOutHtml();
using (DataClassesMatchDataContext match = new DataClassesMatchDataContext(Conn.conn))
{
var ll = match.Live_Aibo.Where(e => e.Live_Aibo_id > 0);
match.Live_Aibo.DeleteAllOnSubmit(ll);//更新后删除
match.SubmitChanges();
foreach (DataRow aa in dt.Rows)
{
if (HtmlTextToStr(aa[3].ToString()) != null) // && HtmlTextToStr(aa[11].ToString()) == null
{
Live_Aibo lo = new Live_Aibo();
lo.KeyValue = HtmlTextToStr(aa[1].ToString());
lo.LeagueName = HtmlTextToStr(aa[2].ToString());
lo.Match_time = HtmlTextToStr(aa[3].ToString());
lo.MatchOrder1_HomeName = AiboTeamName(aa[5].ToString());
lo.MatchOrder1_HandicapNumber = HtmlTextToStr(aa[6].ToString());
lo.MatchOrder1_AwayName = AiboTeamName(aa[7].ToString());
match.Live_Aibo.InsertOnSubmit(lo);
}
}
match.SubmitChanges();
return match.Live_Aibo.Max(e => e.Live_Aibo_id);
}
}
public decimal updateMacauslot()
{
DataTable dt = MacauslotHtml.GetTableInnerText();
DateTime dtt = DateTime.Now.Date;
using (DataClassesMatchDataContext match = new DataClassesMatchDataContext(Conn.conn))
{
foreach (DataRow aa in dt.Rows)
{
if (aa[0].ToString().IndexOf("★") != -1)
if (aa[4].ToString() != null)
if (aa[4].ToString().Length > 1)
{
MacauPredication mp = new MacauPredication();
mp.Record_datetime = dtt;
mp.Home_team = extract(aa[1].ToString());
mp.Away_team = extract(aa[5].ToString());
mp.Macauslot = aa[0].ToString().Trim();
mp.Predication = aa[4].ToString();
match.MacauPredication.InsertOnSubmit(mp);
}
}
match.SubmitChanges();
return match.MacauPredication.Max(e => e.MacauPredication_id);
}
}
public decimal InsertLastHtmlTableToDB()
{
DataTable dt = SevenmResult.GetHtmlTable();
DataClassesMatchDataContext match = new DataClassesMatchDataContext(Conn.conn);
foreach (DataRow aa in dt.Rows)
{
if (HtmlTextToStr(aa[3].ToString()) != null)
{
Result_tb rt = new Result_tb();
rt.Html_position = aa[0].ToString();
rt.Match_type = HtmlTextToStr(aa[1].ToString());
rt.S_time = HtmlTextToStr(aa[2].ToString());
rt.Home_team = HtmlTextToStr(aa[3].ToString());
rt.Full_time_score = HtmlTextToStr(aa[4].ToString());
rt.Away_team = HtmlTextToStr(aa[5].ToString());
rt.Half_time_score = HtmlTextToStr(aa[6].ToString());
rt.Odds = HtmlTextToStr(aa[7].ToString());
rt.Win_loss_big = HtmlTextToStr(aa[8].ToString());
rt.S_date = HtmlDateToStrResult(aa[2].ToString());
rt.Home_team_big = HtmlHrefToStr(aa[3].ToString());
rt.Away_team_big = HtmlHrefToStr(aa[5].ToString());
match.Result_tb.InsertOnSubmit(rt);
}
}
match.SubmitChanges();
return match.Result_tb.Select(e => e.Result_tb_id).Max();
}
private void Form1_Load(object sender, EventArgs ee)
{
注册LicenseCheck();
dataGridView5.Visible = false;
toolStripStatusLabel2.Text = dateTimePicker2.Value.ToString("yyyy-MM-dd");//日历组建日期字符串格式化方法
DateTime? dt, dt1;
using (DataClassesMatchDataContext matches = new DataClassesMatchDataContext(Conn.conn))
{
dt = matches.Result_tb_lib.Max(p => p.Match_time);
if (dt != null)
toolStripStatusLabel3.Text = dt.ToString();
else
toolStripStatusLabel3.Text = "2002.1.1";
dt1 = matches.Live_Table_lib.Max(p => p.Match_time);
toolStripStatusLabel4.Text = dt1.HasValue ? dt1.Value.ToString() : null;
}
treeView5.Nodes.Clear();
loaddatatree.TreeViewMatch(treeView5, "type");
dateTimePicker1.Value = DateTime.Parse(toolStripStatusLabel3.Text);
textBox2.Text = "1";
}
public void top20Algorithm()
{
using (DataClassesMatchDataContext matches = new DataClassesMatchDataContext(Conn.conn))
{
int i = 0;
foreach (var id in idExc)
{
i++;
ProgressBarDelegate.DoSendPMessage(i);
Application.DoEvents();
RowNumberLimit r = new RowNumberLimit(id);
r.initCurveFit();
Match_analysis_result mar = new Match_analysis_result();
mar.Live_table_lib_id = r.live_id;
mar.Pre_algorithm = "top20";
mar.Pre_match_count = r.Top20Count;
mar.Home_goals = r.HomeGoals;
mar.Away_goals = r.AwayGoals;
mar.Home_w = r.hWin;
mar.Home_d = r.hDraw;
mar.Home_l = r.hLose;
mar.Fit_win_loss = r.CureFitWinLoss();
mar.Fit_goals = r.CureFitGoals();
mar.Fit_odd_even = r.CureFitOddEven();
matches.Match_analysis_result.InsertOnSubmit(mar);
//2011.10.8 销毁
r.Dispose();
}
matches.SubmitChanges();
}
}
public int InsertLiveHtmlTableToDB()
{
DataTable dt = SevenmLive.GetHtmlTable();
DataClassesMatchDataContext match = new DataClassesMatchDataContext(Conn.conn);
if (!Conn.CreateTable(typeof(Live_Table))) { return 0; }
//var result = match.Live_Table.Where(r => r.Live_table_id > 0);
//match.Live_Table.DeleteAllOnSubmit(result);
//match.SubmitChanges();
string ddate = null;
string ndate = null; //修改当天完场的问题 2011.6.11
Queue<string> todayDate = new Queue<string>();
foreach (DataRow aa in dt.Rows)
{
if (HtmlDateToStrLive(aa[1].ToString()) != null)
{
if (HtmlDateToStrLive(aa[1].ToString()).IndexOf("最新賽果") == -1)
{
ddate = HtmlDateToStrLive(aa[1].ToString());
ddate = ddate.Replace("年", "-").Replace("月", "-").Replace("日", " ");
todayDate.Enqueue(ddate);
}
else
{
todayDate.Dequeue();//删除第1条 2011.6.11
ndate = todayDate.Peek();//取第1个元素 2011.6.11
ddate = ndate;
}
}
if (HtmlTextToStr(aa[3].ToString()) != null)
{
Live_Table lt = new Live_Table();
lt.Html_position = aa[0].ToString();
lt.Match_type = HtmlTextToStr(aa[2].ToString());
lt.S_time = HtmlTextToStr(aa[3].ToString());
lt.Home_team = HtmlTextToStr(aa[5].ToString());
lt.Full_time_score = HtmlTextToStr(aa[6].ToString());
lt.Away_team = HtmlTextToStr(aa[7].ToString());
lt.Half_time_score = HtmlTextToStr(aa[8].ToString());
lt.S_date = ddate;
lt.Home_team_big = HtmlHrefToStr(aa[5].ToString());
lt.Away_team_big = HtmlHrefToStr(aa[7].ToString());
match.Live_Table.InsertOnSubmit(lt);
}
}
match.SubmitChanges();
return match.Live_Table.Max(e => e.Live_table_id);
}
private void button16_Click(object sender, EventArgs c)
{
using (DataClassesMatchDataContext matches = new DataClassesMatchDataContext(Conn.conn))
{
var idExc = matches.Live_Table_lib
.Where(e => e.Match_time.Value.Date >= DateTime.Now.AddDays(ViewMatchOverDays).Date)
.Select(e => e.Match_type).Distinct();
foreach (string matchtype in idExc)
treeView6.Nodes.Add(matchtype);
}
}
private void SimulinkGRNN()
{
try
{
string result = null;
ExportToExcel.DataGridView2Txt(dataGridView2, nn.tempy, 5);
ExportToExcel.DataGridView2Txt(dataGridView3, nn.tempx, 6);
//exe文件方式
//result = ExportToExcel.SimulinkNN(@"D:\My Documents\MATLAB\mygrnn.exe");
//dll文件方式
result = nn.NewGrnn();
richTextBox3.Text = result;
//dataGridView3.Columns.Add("...", "...");
dataGridView3.Columns.Add("MyGRNN", "MyGRNN");
int colx = dataGridView3.Columns.Count - 1;
int ix = 0;
string[] lines = result.Split(new char[] { '\r', '\n' });
foreach (string line in lines)
if (line != null)
if (line.Trim().Length > 0)
if (line.IndexOf("=") == -1)
{
dataGridView3.Rows[ix].Cells[colx].Value = line; ix++;
}
using (DataClassesMatchDataContext matches = new DataClassesMatchDataContext(Conn.conn))
{
int resultid = 0;
int col = dataGridView3.Columns.Count - 1;
string grnnfit = null;
for (int i = 0; i < dataGridView3.Rows.Count - 1; i++)
{
resultid = Int32.Parse(dataGridView3.Rows[i].Cells[0].Value.ToString());
grnnfit = dataGridView3.Rows[i].Cells[col].Value.ToString();
var mar = matches.Match_analysis_result
.Where(e => e.Analysis_result_id == resultid).First();//查找需要更新的数据
mar.Grnn_fit = grnnfit.Trim();
}
matches.SubmitChanges();
}
//MessageBox.Show("OK");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public ForecastAlgorithm()
{
using (DataClassesMatchDataContext matches = new DataClassesMatchDataContext(Conn.conn))
{
var idLive = matches.Live_Table_lib.Select(e => e.Live_table_lib_id).ToList();//立即加载效率高？
var idAnalysis = matches.Match_analysis_result.Select(e => e.Live_table_lib_id ?? 0).ToList();//可空类型转换
idExc = idLive.Except(idAnalysis).ToList(); //except序列A有的元素序列B没有
}
dMatch.dNew = false;
dMatch.LoadMatchData(true);
}
//private TreeNode _treeViewMatch;
//DataClassesMatchDataContext2 dcmdc2 = new DataClassesMatchDataContext2(Conn.conn);
public LoadAnalysisReview()
{
using (DataClassesMatchDataContext matches = new DataClassesMatchDataContext(Conn.conn))
{
marAll = matches.Match_analysis_result
.Where(e => e.Pre_algorithm != "top20").ToLookup(e => e.Live_table_lib_id);
ltlAll = matches.Live_Table_lib.ToDictionary(e => e.Live_table_lib_id);
lsAll = matches.Live_Single.ToLookup(e => e.Home_team_big + "-" + e.Away_team_big);
mpAll = matches.MacauPredication.OrderByDescending(e => e.MacauPredication_id)
.Where(e => e.Home_team != null && e.Away_team != null)
.ToLookup(e => e.Home_team);
rtlAll = matches.Result_tb_lib.ToDictionary(e => e.Result_tb_lib_id);
}
}
public AuditForecastAlgorithm(int daysDiff)
{
using (DataClassesMatchDataContext matches = new DataClassesMatchDataContext(Conn.conn))
{
idExc = matches.Live_Table_lib
.Where(e => e.Match_time.Value.Date >= DateTime.Now.AddDays(daysDiff).Date)
.Select(e => e.Live_table_lib_id)
.ToList();
//mars = matches.Match_analysis_result; //这里不能放入list，否则更新不了数据， 2011.7.27
lss = matches.Live_Single.ToLookup(e => e.Home_team_big + e.Away_team_big);
}
dMatch.dNew = false;
dMatch.LoadMatchData(true);
}
public void InitMatchOver()
{
if (MatlabMatch.matchover == null)
{
using (DataClassesMatchDataContext matches = new DataClassesMatchDataContext(Conn.conn))
{
var matchover = from p in matches.Match_analysis_result
join q in matches.Result_tb_lib on p.Result_tb_lib_id equals q.Result_tb_lib_id
join t in matches.Live_Table_lib on p.Live_table_lib_id equals t.Live_table_lib_id
select new
{
t.Match_time,
t.Match_type,
t.Home_team,
t.Away_team,
q.Odds,
p.Home_w,
p.Home_d,
p.Home_l,
p.Home_goals,
p.Away_goals,
p.Cross_goals,
p.Fit_win_loss,
p.Recent_scores,
p.Recent_2scores,
p.Recent_3scores,
p.Recent_4scores,
p.Recent_5scores,
p.Recent_6scores,
Lottery_Ticket = q.Full_home_goals - q.Full_away_goals,
q.Full_home_goals,
q.Full_away_goals,
Dodds = ConvertOdd(t.Home_team, q.Odds)
};
//避免干扰 Where(e=>e.Home_w+e.Home_d+e.Home_l>2)
MatlabMatch.matchover = matchover.Where(e=>e.Home_w+e.Home_d+e.Home_l>2).ToDataTable();
}
}
}
public int InsertLiveHtmlTableToDB(string _html)
{
SqlAgilityPackTableXpath tbTag = new SqlAgilityPackTableXpath("live.win.7m.cn");
HtmlAgilityPackGeneric SevenmLivesg = new HtmlAgilityPackGeneric(_html, tbTag.tbTag, 0);//容易出错，主要路径的转换
DataTable dt = SevenmLivesg.GetTableOutHtml(); //容易出错，注意方法的转换
DataClassesMatchDataContext match = new DataClassesMatchDataContext(Conn.conn);
//if (!Conn.CreateTable(typeof(Live_Single))) { return 0; }
foreach (DataRow aa in dt.Rows)
{
if (aa[8] != null)
if (aa[8].ToString() != "")
if (aa[8].ToString().Trim() != "")
{
status = HtmlTextToStr(aa[8].ToString()).Trim();
//北京单场
if (status != "让球")
{
if (status.Length >= 1 && status.Length <= 2)
{
Live_Single ls = new Live_Single();
status = HtmlTextToStr(aa[9].ToString()).Trim();
ls.Html_position = GetNumber(HtmlTextToStr(aa[0].ToString()));
ls.Home_team_big = GetNumber(HtmlHrefToStr(aa[4].ToString()));
ls.Away_team_big = GetNumber(HtmlHrefToStr(aa[6].ToString()));
ls.Status = status;
match.Live_Single.InsertOnSubmit(ls);
}
}
//竞猜
if (status.IndexOf(".") != -1)
{
Live_Single ls = new Live_Single();
ls.Html_position = GetNumber(HtmlTextToStr(aa[0].ToString()));
ls.Home_team_big = GetNumber(HtmlHrefToStr(aa[4].ToString()));
ls.Away_team_big = GetNumber(HtmlHrefToStr(aa[6].ToString()));
ls.Status = status;
match.Live_Single.InsertOnSubmit(ls);
}
}
}
match.SubmitChanges();
return match.Live_Single.Max(e => e.Live_Single_id);
}
public void DeleteRedundancy()
{
using (DataClassesMatchDataContext matches = new DataClassesMatchDataContext(Conn.conn))
{
var idLive = from p in matches.Match_analysis_result
group p by p.Live_table_lib_id into ttt
select new { id = ttt.Key, count = ttt.Count() };
idDelete = idLive.Where(e => e.count > 1).Select(e => e.id).ToList();
if (idDelete == null) return;
foreach (int del in idDelete)
{
var delid = matches.Live_Table_lib.Where(e => e.Live_table_lib_id == del).FirstOrDefault();
matches.Live_Table_lib.DeleteOnSubmit(delid);
var delid2 = matches.Match_analysis_result.Where(e => e.Live_table_lib_id == del).FirstOrDefault();
matches.Match_analysis_result.DeleteOnSubmit(delid2);
}
matches.SubmitChanges();
}
}
public void initTreeNode(int daysDiff, bool ismath, bool bj)
{
//这个连接不能放到class中，不然取的还是缓存的数据？？？？？？？？？？？
//对象和数据库之间会存在不能更新的问题？？？？？？？？？？？
using (DataClassesMatchDataContext matches = new DataClassesMatchDataContext(Conn.conn))
//using (SoccerScoreSqlite matches = new SoccerScoreSqlite(cnn))
{
//if (ismath)
// ltlAll = matches.Live_Table_lib
// .Where(e => matchlist.Contains(e.Match_type))
// .Where(m => m.Match_time.Value.Date >= DateTime.Now.AddDays(daysDiff).Date)
// .OrderBy(m => m.Match_time).ToList();
//else
ltlAll = matches.Live_Table_lib
.Where(m => m.Match_time.Value.Date >= DateTime.Now.AddDays(daysDiff).Date)
.OrderBy(m => m.Match_time)
.ToDictionary(e => e.Live_table_lib_id);
rtlAll = matches.Result_tb_lib
.Where(m => m.Match_time.Value.Date >= DateTime.Now.AddDays(daysDiff).Date)
.ToDictionary(e => e.Result_tb_lib_id);
//loAll = matches.Live_okoo.Where(e => e.Live_okoo_id > 0).ToList();
//mpAll = matches.MacauPredication.OrderByDescending(e => e.MacauPredication_id).ToList();
//lsAll = matches.Live_Single.ToList();
lsAll = matches.Live_Single.ToLookup(e => e.Home_team_big + "-" + e.Away_team_big);
mpAll = matches.MacauPredication.OrderByDescending(e => e.MacauPredication_id)
.Where(e => e.Home_team != null && e.Away_team != null)
.ToLookup(e => e.Home_team);
//处理北京单场
if (bj)
marAll = matches.Match_analysis_result
.Where(e => e.Pre_algorithm != "top20")
.Where(e => e.Live_table_lib_id > 0).ToLookup(e => e.Live_table_lib_id);
else
marAll = matches.Match_analysis_result.ToLookup(e => e.Live_table_lib_id);
}
}
private void button9_Click_1(object sender, EventArgs c)
{
Uri uri = new Uri(textBox3.Text);
string host = uri.Host;
using (DataClassesMatchDataContext match = new DataClassesMatchDataContext(Conn.conn))
{
var eUri = match.Match_table_xpath.Where(e => e.Uri_host == host).FirstOrDefault();
if (eUri == null)
{
Match_table_xpath nUri = new Match_table_xpath();
nUri.Uri_host = host.ToString();
nUri.Max_table_xpath = textBox4.Text;
nUri.Second_table_xpath = textBox6.Text;
nUri.Max_table_id_value = textBox7.Text;
nUri.Second_table_id_value = textBox8.Text;
match.Match_table_xpath.InsertOnSubmit(nUri);
}
else
{
eUri.Uri_host = host.ToString();
eUri.Max_table_xpath = textBox4.Text;
eUri.Second_table_xpath = textBox6.Text;
eUri.Max_table_id_value = textBox7.Text;
eUri.Second_table_id_value = textBox8.Text;
//match.match_table_xpath.InsertOnSubmit(eUri);
}
match.SubmitChanges();
}
MessageBox.Show("OK");
}
private void button30_Click(object sender, EventArgs e)
{
DataClassesMatchDataContext matches = new DataClassesMatchDataContext(Conn.conn);
gridControl1.DataSource = matches.Result_tb_lib;
}
private void toolStripButton_iniLast_Click(object sender, EventArgs e)
{
toolStripLabel1.Text = "updateResultTable";
try
{
this.tabControl1.SelectedTab = this.tabPage1;
if (Conn.CreateTable(typeof(Result_tb)))
Conn.CompressCompact();
#region
Application.DoEvents();
datahtml = false;
WebHistoryDataGet(); //button2.PerformClick();//执行历史网页采集
while (!datahtml) Application.DoEvents();
#endregion
using (DataClassesMatchDataContext matches = new DataClassesMatchDataContext(Conn.conn))
{
int pb = matches.Result_tb.Count();
toolStripProgressBar1.Maximum = pb;
//MessageBox.Show(pb.ToString());
toolStripLabel2.Text = pb.ToString(); Thread.Sleep(1);
}
SevenmResultToSql sevenm = new SevenmResultToSql();
sevenm.UpdateLastMatch();
//执行分析数据的更新
UpdateAnalysisResult_today();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
//获取数据库的数据结构
private void button6_Click(object sender, EventArgs e)
{
using (DataClassesMatchDataContext matches = new DataClassesMatchDataContext(Conn.conn))
{
gridControl1.DataSource = matches.Match_table_xpath;
}
}
public void UpdateLastMatch()
{
int i = 0;
DataClassesMatchDataContext matches = new DataClassesMatchDataContext(Conn.conn);
var rt = matches.Result_tb.OrderBy(o => o.S_date).ThenBy(p => p.S_time);//用lambda表达式简洁
//取临时变量监视
DateTime lib_max_match_time = matches.Result_tb_lib
.Max(p => p.Match_time).Value.AddDays(-3);
//取临时表做监视
List<Result_tb_lib> temp_tb = matches.Result_tb_lib
.Where(p => p.Match_time > lib_max_match_time).ToList();
//取临时表插入
List<Result_tb_lib> update_tb = new List<Result_tb_lib>();
foreach (var m in rt)
{
i++;
ProgressBarDelegate.DoSendPMessage(i);
Application.DoEvents();
if (m.Home_team_big != null)
{
Result_tb_lib rtl = new Result_tb_lib();
rtl.Html_position = Int32.Parse(m.Html_position);
rtl.Home_team_big = Int32.Parse(GetNumber(m.Home_team_big));
rtl.Away_team_big = Int32.Parse(GetNumber(m.Away_team_big));
rtl.Match_type = m.Match_type.Trim();
last_line = m.S_time.LastIndexOf("\n");
temp_time = m.S_time.Substring(last_line, m.S_time.Length - last_line - 1);
rtl.Match_time = DateTime.Parse(m.S_date.Substring(0, 10) + " " + temp_time);
rtl.Odds = m.Odds.Trim();
rtl.Win_loss_big = m.Win_loss_big.Trim();
rtl.Home_team = m.Home_team.Trim();
rtl.Away_team = m.Away_team.Trim();
rtl.Home_red_card = StringCount(m.Home_team, " ", 0);
rtl.Away_red_card = StringCount(m.Away_team, " ", 0);
string bf = m.Full_time_score.Replace(" ", "").Replace(" ", "");
if (m.Full_time_score.IndexOf("-") > 0)
{
rtl.Full_home_goals = Int32.Parse(bf.Substring(0, bf.IndexOf("-")));
rtl.Full_away_goals = Int32.Parse(bf.Substring(bf.IndexOf("-") + 1, bf.Length - bf.IndexOf("-") - 1));
}
if (m.Half_time_score.IndexOf("-") > 0)
{
rtl.Half_home_goals = Int32.Parse(m.Half_time_score.Substring(0, m.Half_time_score.IndexOf("-")));
rtl.Half_away_goals = Int32.Parse(m.Half_time_score.Substring(m.Half_time_score.IndexOf("-") + 1, m.Half_time_score.Length - m.Half_time_score.IndexOf("-") - 1));
}
//如果库中文件的日期太小，直接删除
if (rtl.Match_time >= lib_max_match_time)
{
//数据分区，层次化查询
var rtExist = from p in temp_tb //历史库中的临时表
where p.Match_time.Value.Date == rtl.Match_time.Value.Date //注意这里时间的问题？ 2011.8.30
where p.Home_team_big == rtl.Home_team_big
where p.Away_team_big == rtl.Away_team_big
select p;
//库中没有记录直接插入
if (!rtExist.Any())
{
temp_tb.Add(rtl); //历史库中的临时表做更新
update_tb.Add(rtl);
}
}
//更新后删除
//matches.Result_tb.DeleteOnSubmit(m);
}
}
matches.Result_tb_lib.InsertAllOnSubmit(update_tb);
matches.SubmitChanges();
MessageBox.Show("OK");
}
private void button24_Click_2(object sender, EventArgs eeee)
{
DialogResult result; //Messagebox所属于的类
result = MessageBox.Show(this, "YesOrNo", "你确定要删除分析库？", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)//Messagebox返回的值
{
//提取去年的数据
DateTime dt = DateTime.Now.AddYears(-1);
List<Live_Table_lib> ltls = new List<Live_Table_lib>();
using (DataClassesMatchDataContext matches = new DataClassesMatchDataContext(Conn.conn))
{
var result_tb = matches.Result_tb_lib.Where(e => e.Match_time > dt).OrderBy(e => e.Match_time);
foreach (var r in result_tb)
{
Live_Table_lib ltl = new Live_Table_lib();
ltl.Match_time = r.Match_time;
ltl.Html_position = r.Html_position;
ltl.Match_type = r.Match_type;
ltl.Home_team_big = r.Home_team_big;
ltl.Home_team = r.Home_team;
ltl.Away_red_card = r.Away_red_card;
ltl.Away_team_big = r.Away_team_big;
ltl.Away_team = r.Away_team;
ltl.Away_red_card = r.Away_red_card;
ltl.Full_home_goals = r.Full_home_goals;
ltl.Full_away_goals = r.Full_away_goals;
ltl.Half_home_goals = r.Half_home_goals;
ltl.Half_away_goals = r.Half_away_goals;
ltl.Status = r.Odds;
//matches.Live_Table_lib.InsertOnSubmit(ltl);
ltls.Add(ltl);
}
//matches.SubmitChanges();
}
using (SqlConnection con = new SqlConnection(Conn.conn))
{
con.Open();
using (SqlTransaction tran = con.BeginTransaction())
{
var newOrders = ltls;
SqlBulkCopy bc = new SqlBulkCopy(con,
//SqlBulkCopyOptions.CheckConstraints |
//SqlBulkCopyOptions.FireTriggers |
SqlBulkCopyOptions.KeepNulls, tran);
bc.BulkCopyTimeout = 36000;
bc.BatchSize = 10000;
bc.DestinationTableName = "Live_Table_lib";
bc.WriteToServer(newOrders.AsDataReader());
tran.Commit();
}
con.Close();
}
MessageBox.Show("OK");
}
}
private List<Result_tb_lib> AuditUpdateLastMatch()
{
int i = 0;
DataClassesMatchDataContext matches = new DataClassesMatchDataContext(Conn.conn);
var rt = matches.Result_tb.OrderBy(o => o.S_date).ThenBy(p => p.S_time);//用lambda表达式简洁
//取临时表插入
List<Result_tb_lib> update_tb = new List<Result_tb_lib>();
foreach (var m in rt)
{
i++;
ProgressBarDelegate.DoSendPMessage(i);
Application.DoEvents();
if (m.Home_team_big != null)
{
Result_tb_lib rtl = new Result_tb_lib();
rtl.Html_position = Int32.Parse(m.Html_position);
rtl.Home_team_big = Int32.Parse(GetNumber(m.Home_team_big));
rtl.Away_team_big = Int32.Parse(GetNumber(m.Away_team_big));
rtl.Match_type = m.Match_type.Trim();
last_line = m.S_time.LastIndexOf("\n");
temp_time = m.S_time.Substring(last_line, m.S_time.Length - last_line - 1);
rtl.Match_time = DateTime.Parse(m.S_date.Substring(0, 10) + " " + temp_time);
rtl.Odds = m.Odds.Trim();
rtl.Win_loss_big = m.Win_loss_big.Trim();
rtl.Home_team = m.Home_team.Trim();
rtl.Away_team = m.Away_team.Trim();
rtl.Home_red_card = StringCount(m.Home_team, " ", 0);
rtl.Away_red_card = StringCount(m.Away_team, " ", 0);
string bf = m.Full_time_score.Replace(" ", "").Replace(" ", "");
if (m.Full_time_score.IndexOf("-") > 0)
{
rtl.Full_home_goals = Int32.Parse(bf.Substring(0, bf.IndexOf("-")));
rtl.Full_away_goals = Int32.Parse(bf.Substring(bf.IndexOf("-") + 1, bf.Length - bf.IndexOf("-") - 1));
}
if (m.Half_time_score.IndexOf("-") > 0)
{
rtl.Half_home_goals = Int32.Parse(m.Half_time_score.Substring(0, m.Half_time_score.IndexOf("-")));
rtl.Half_away_goals = Int32.Parse(m.Half_time_score.Substring(m.Half_time_score.IndexOf("-") + 1, m.Half_time_score.Length - m.Half_time_score.IndexOf("-") - 1));
}
update_tb.Add(rtl);
}
}
return update_tb;
}
public void BatchUpdateLastMatch()
{
int i = 0;
DataClassesMatchDataContext matches = new DataClassesMatchDataContext(Conn.conn);
var aulm = AuditUpdateLastMatch().ToLookup(e =>
e.Match_time.Value.Date.ToShortDateString()
+ "----------" + e.Home_team_big
+ "----------" + e.Away_team_big);
var aulmorder = aulm.OrderBy(e => e.Key.Substring(0, 10));
foreach (var au in aulmorder)
{
i++;
ProgressBarDelegate.DoSendPMessage(i);
Application.DoEvents();
matches.Result_tb_lib.InsertOnSubmit(au.First());
}
matches.SubmitChanges();
MessageBox.Show("OK");
}
private void button2_Click(object sender, EventArgs e)
{
using (DataClassesMatchDataContext matches = new DataClassesMatchDataContext(Conn.conn))
{
gridControl1.DataSource = matches.MacauPredication;
}
}
private void button11_Click(object sender, EventArgs e)
{
using (DataClassesMatchDataContext matches = new DataClassesMatchDataContext(Conn.conn))
{
gridControl1.DataSource = matches.Live_Single;
}
}
//此项目不用？？？？？
//批量导入 Result_tb_lib数据，并且做修正 ？
private void BatchUpdateLastMatch()
{
using (DataClassesMatchDataContext matches = new DataClassesMatchDataContext(Conn.conn))
{
int pb = matches.Result_tb.Count();
toolStripProgressBar1.Maximum = pb;
MessageBox.Show(pb.ToString());
}
SevenmResultToSql sevenm = new SevenmResultToSql();
sevenm.BatchUpdateLastMatch();
}
public void top20Algorithm()
{
using (DataClassesMatchDataContext matches = new DataClassesMatchDataContext(Conn.conn))
{
int i = 0;
foreach (int liveid in idExc)
{
i++;
ProgressBarDelegate.DoSendPMessage(i);
Application.DoEvents();
r = new RowNumberLimit(liveid);
r.initCurveFit();
//match_analysis_result mar = new match_analysis_result();
mar = matches.Match_analysis_result
.Where(e => e.Live_table_lib_id == liveid)
.First();//查找需要更新的数据
mar.Live_table_lib_id = r.live_id;
mar.Pre_algorithm = "top20";
mar.Pre_match_count = r.Top20Count;
mar.Home_goals = r.HomeGoals;
mar.Away_goals = r.AwayGoals;
mar.Home_w = r.hWin;
mar.Home_d = r.hDraw;
mar.Home_l = r.hLose;
mar.Fit_win_loss = r.CureFitWinLoss();
mar.Fit_goals = r.CureFitGoals();
mar.Fit_odd_even = r.CureFitOddEven();//直接赋值，修改完成
//2011.9.22 修改成利用积分进行运算
mar.Recent_scores = r.RecentScores; //增加最后一轮的分数
mar.Recent_2scores = r.Recent2Scores;
mar.Recent_3scores = r.Recent3Scores;
mar.Recent_4scores = r.Recent4Scores;
mar.Recent_5scores = r.Recent5Scores;
mar.Recent_6scores = r.Recent6Scores;
//2011.6.22
mar.Cross_goals = r.CrossGoals;
//2011.6.16
//【交战+概率1+拟合+进球+概率30】
mar.Myfit =
//交战
ForecastCross(r.CrossGoals) + ":" +
//概率1
ForecastD(mar.Home_w, mar.Home_d, mar.Home_l) + ":" +
//拟合+进球+概率30
ForecastWL(mar.Fit_win_loss, mar.Home_goals, mar.Away_goals, mar.Home_w, mar.Home_l);
//更新北京单场
sg = lss[r.home_team_big.ToString() + r.away_team_big.ToString()].FirstOrDefault();
if (sg != null)
mar.Pre_algorithm = sg.Html_position;
sgerror = lss[r.away_team_big.ToString() + r.home_team_big.ToString()].FirstOrDefault();
if (sgerror != null)
mar.Pre_algorithm = sgerror.Html_position;
//r.Close();
//缩短数据更新周期
if (i % 100 == 0)
{
matches.SubmitChanges();
//GC.Collect(); GC.Collect(); Application.DoEvents();
}
//2011.10.8. 这里销毁
r.Dispose();
}
matches.SubmitChanges();
}
}
public void InitMatchNow()
{
using (DataClassesMatchDataContext matches = new DataClassesMatchDataContext(Conn.conn))
{
var matchnowf = from p in matches.Match_analysis_result
join t in matches.Live_Table_lib on p.Live_table_lib_id equals t.Live_table_lib_id
where p.Result_tb_lib_id == null || p.Result_fit == "no forecast"
select new
{
p.Analysis_result_id,
t.Match_time,
t.Match_type,
t.Home_team,
t.Away_team,
t.Status,
p.Home_w,
p.Home_d,
p.Home_l,
p.Home_goals,
p.Away_goals,
p.Cross_goals,
p.Fit_win_loss,
p.Recent_scores,
p.Recent_2scores,
p.Recent_3scores,
p.Recent_4scores,
p.Recent_5scores,
p.Recent_6scores,
Dodds = ConvertOdd(t.Home_team, t.Status)
};
MatlabMatch.matchnow = matchnowf.ToDataTable();
}
}
