private void BindGrid(DateTime touzhushijian) { DataSet ds = new YucerawdataDAL().GetYucerawdataAnalysis(touzhushijian); dgvResult.DataSource = ds.Tables[0]; SetGridColor(); }
private void TouzhuByMingren() { //重新绑定 DateTime date = dtpTouzhushijian.Value.Date; DataSet dsYuce = new YucerawdataDAL().GetYucerawdataAnalysisHasMingRen(date); PeilvDAL dal = new PeilvDAL(); string riqi = dtpTouzhushijian.Value.Date.ToString("yyyy-MM-dd"); string liansai = "全部"; DataSet ds = dal.SearchPeilv(riqi, liansai); dgvTuijian.DataSource = ds.Tables[0]; foreach (DataRow row in dsYuce.Tables[0].Rows) { //string kedui = row["kedui"].ToString(); //string zhudui = row["zhudui"].ToString(); string kedui = row["keduireal"].ToString(); string zhudui = row["zhuduireal"].ToString(); string yucespf = row["yucespf"].ToString(); string hasrangqiu = row["hasrangqiu"].ToString(); string rangqiushu = row["rangqiushu"].ToString(); foreach (DataGridViewRow gridRow in dgvTuijian.Rows) { if (gridRow.Index == dgvTuijian.Rows.Count - 1) { continue; } if (gridRow.Cells[2].Value.ToString().Equals(zhudui) || gridRow.Cells[3].Value.ToString().Equals(kedui)) { if (hasrangqiu.Equals("0") && gridRow.Cells[4].Value.ToString().Equals("0")) { char[] chars = yucespf.ToCharArray(); foreach (char ch in chars) { if (ch <= '9' && ch >= '0') { switch (ch) { case '0': SetCellColor(gridRow.Cells[7]); break; case '1': SetCellColor(gridRow.Cells[6]); break; case '3': SetCellColor(gridRow.Cells[5]); break; } } } } else if (hasrangqiu.Equals("1") && !gridRow.Cells[4].Value.ToString().Equals("0")) { char[] chars = yucespf.ToCharArray(); foreach (char ch in chars) { if (ch <= '9' && ch >= '0') { switch (ch) { case '0': SetCellColor(gridRow.Cells[7]); break; case '1': SetCellColor(gridRow.Cells[6]); break; case '3': SetCellColor(gridRow.Cells[5]); break; } } } } } } } TouzhuByNatureForMingren(); }
private void btnAnalysisCaike_Click(object sender, EventArgs e) { //获取最新预测数据 YucerawdataDAL dal = new YucerawdataDAL(); DataSet ds = dal.GetYucerawdata(); foreach (DataRow row in ds.Tables[0].Rows) { string url = row["url"].ToString(); string caizhongtype = row["caizhongtype"].ToString(); string title = row["title"].ToString(); string p2 = row["p2"].ToString(); string p3 = row["p3"].ToString(); string p8 = row["p8"].ToString(); //分析数据 int zhongkuohaoIndex = title.IndexOf("["); int zhongkuohaoIndex2 = title.IndexOf("]"); string yuceren = ""; if (zhongkuohaoIndex != -1) { yuceren = title.Substring(zhongkuohaoIndex + 1, zhongkuohaoIndex2 - zhongkuohaoIndex - 1); } string zhudui = ""; string kedui = ""; if (p2.IndexOf(":") != -1) { p2 = PreHandleData2(p2); string[] splitP2 = p2.Split(' '); kedui = splitP2[splitP2.Length - 1]; zhudui = splitP2[splitP2.Length - 3]; //去除主队和客队中包含的括号 kedui = DeleteKuohao(kedui); zhudui = DeleteKuohao(zhudui); } else { int vsIndex = p2.ToUpper().IndexOf("VS"); string preVs = p2.Substring(0, vsIndex).Replace(" ", ""); string postVs = p2.Substring(vsIndex + 2); kedui = postVs.Replace(" ", "").Replace(" ", ""); int lastKonggeIndex = preVs.Trim().LastIndexOf(" "); if (lastKonggeIndex != -1) { zhudui = preVs.Substring(lastKonggeIndex).Trim(); } else { zhudui = preVs.Trim(); } //去除主队和客队中包含的括号 kedui = DeleteKuohao(kedui); zhudui = DeleteKuohao(zhudui); } //获取比赛时间 string bisaishijian = ""; p3 = PreHandleData3(p3); int bisaiIndex = p3.IndexOf("比赛时间:"); bisaishijian = p3.Substring(bisaiIndex + 5); //获取推荐及让球数 string spf = ""; string rangqiushu = "0"; int hasrangqiu = 0; p8 = PreHandleData8(p8); int maohaoIndex = p8.IndexOf(":"); if (maohaoIndex == -1) { maohaoIndex = p8.IndexOf("推荐") + 1; } int qiankuohaoIndex = p8.IndexOf("("); int houkuohaoIndex = p8.IndexOf(")"); //这个分支适用于模式: 竞彩足球让球胜平负推荐:0(维冈竞技让1球) if (qiankuohaoIndex != -1 && qiankuohaoIndex > maohaoIndex && houkuohaoIndex == p8.Length - 1) { spf = p8.Substring(maohaoIndex + 1, qiankuohaoIndex - maohaoIndex - 1); } else if (qiankuohaoIndex != -1 && qiankuohaoIndex > maohaoIndex && houkuohaoIndex != p8.Length - 1) { spf = p8.Substring(houkuohaoIndex + 1); } else { spf = p8.Substring(maohaoIndex + 1); } if (p8.IndexOf("无让球") != -1 || p8.IndexOf("没有让球") != -1 || p8.IndexOf("不让球") != -1) { } else { if (p8.IndexOf("让球") != -1 || p8.IndexOf(")球") != -1) { //让球(-1)和让(-1)球模式 int rangIndex = p8.LastIndexOf("让"); int qiuIndex = p8.LastIndexOf("球"); if (rangIndex != -1 && qiuIndex > rangIndex + 1) { rangqiushu = p8.Substring(rangIndex + 1, qiuIndex - rangIndex - 1); switch (rangqiushu) { case "一": rangqiushu = "1"; break; case "二": rangqiushu = "2"; break; case "三": rangqiushu = "3"; break; case "四": rangqiushu = "4"; break; case "五": rangqiushu = "5"; break; case "六": rangqiushu = "6"; break; case "七": rangqiushu = "7"; break; case "八": rangqiushu = "8"; break; case "九": rangqiushu = "9"; break; case "十": rangqiushu = "10"; break; } } else { rangqiushu = p8.Substring(qiankuohaoIndex + 1, houkuohaoIndex - qiankuohaoIndex - 1); } } else { int rangIndex = p8.LastIndexOf("让"); int qiuIndex = p8.LastIndexOf("球"); if (rangIndex != -1) { rangqiushu = p8.Substring(rangIndex + 1, qiuIndex - rangIndex - 1); } else if (qiankuohaoIndex != -1) { rangqiushu = p8.Substring(qiankuohaoIndex + 1, houkuohaoIndex - qiankuohaoIndex - 1); } } } if (rangqiushu == "0") { hasrangqiu = 0; } else { hasrangqiu = 1; } //保存分析数据 Yuceanalysis analy = new Yuceanalysis(); analy.Url = url; analy.Zhudui = zhudui; analy.Kedui = kedui; analy.Yucetype = caizhongtype; analy.Bisaishijian = Convert.ToDateTime(bisaishijian); analy.Touzhushijian = Convert.ToDateTime(bisaishijian).AddHours(-11).Date; analy.Rangqiushu = rangqiushu; analy.Hasrangqiu = hasrangqiu; analy.OperateTime = DateTime.Now; analy.Operator = "吴林"; analy.Yucespf = spf; analy.Yuceren = yuceren; dal.InsertYuceanalysis(analy); } MessageBox.Show("分析成功!"); }
private void btnSearch_Click(object sender, EventArgs e) { DateTime touzhushijian = dateTimePicker1.Value.Date; YucerawdataDAL dal = new YucerawdataDAL(); DataSet ds = dal.GetYucePeilv(touzhushijian); DataTable dt = new DataTable(); dt.Columns.Add("主队", typeof(string)); dt.Columns.Add("客队", typeof(string)); dt.Columns.Add("时间", typeof(string)); dt.Columns.Add("预测结果", typeof(string)); dt.Columns.Add("赔率", typeof(string)); dt.Columns.Add("让球数", typeof(string)); dt.Columns.Add("是否中奖", typeof(string)); foreach (DataRow row in ds.Tables[0].Rows) { string zhudui = row["zhuduireal"].ToString(); string kedui = row["keduireal"].ToString(); string riqi = row["riqi"].ToString(); string rangqiu = row["rangqiu"].ToString(); string yucespf = row["yucespf"].ToString(); string lucky = row["lucky"].ToString(); foreach (char ch in yucespf.ToCharArray()) { if (ch <= '9' && ch >= '0') { DataRow newrow = dt.NewRow(); newrow["主队"] = zhudui; newrow["客队"] = kedui; newrow["时间"] = riqi; newrow["让球数"] = rangqiu; string spfresult = row["spfresult1"].ToString(); if (rangqiu == "0") { spfresult = row["spfresult1"].ToString(); } else { spfresult = row["rqspfresult1"].ToString(); } //if (lucky == "0") //{ // newrow["是否中奖"] = "未中奖"; //} //else if (lucky == "1") //{ // newrow["是否中奖"] = "已中奖"; //} switch (ch) { case '3': if (!string.IsNullOrEmpty(spfresult)) { if (spfresult == "3") { newrow["是否中奖"] = "已中奖"; } else { newrow["是否中奖"] = "未中奖"; } } newrow["预测结果"] = "胜"; newrow["赔率"] = row["shengsp"].ToString(); break; case '1': if (!string.IsNullOrEmpty(spfresult)) { if (spfresult == "1") { newrow["是否中奖"] = "已中奖"; } else { newrow["是否中奖"] = "未中奖"; } } newrow["赔率"] = row["pingsp"].ToString(); newrow["预测结果"] = "平"; break; case '0': if (!string.IsNullOrEmpty(spfresult)) { if (spfresult == "0") { newrow["是否中奖"] = "已中奖"; } else { newrow["是否中奖"] = "未中奖"; } } newrow["预测结果"] = "负"; newrow["赔率"] = row["fusp"].ToString(); break; } dt.Rows.Add(newrow); } } } DataView dv = dt.DefaultView; dv.Sort = "赔率 Asc ,主队 Asc "; DataTable dt2 = dv.ToTable(); dataGridView1.DataSource = dt2; //修改grid样式用于看清 foreach (DataGridViewRow gridRow in dataGridView1.Rows) { if (gridRow.Cells["是否中奖"].Value != null && gridRow.Cells["是否中奖"].Value.ToString() == "已中奖") { gridRow.DefaultCellStyle.BackColor = Color.Red; } } }
private void BindGrid() { DataSet ds = new YucerawdataDAL().GetAllYuceAnalysis(); dgvResult.DataSource = ds.Tables[0]; SetGridColor(); }