private void BindGrid() { DataSet ds = new YucerawdataDAL().GetAllYuceAnalysis(); dgvResult.DataSource = ds.Tables[0]; SetGridColor(); }
private void BindGrid(DateTime touzhushijian) { DataSet ds = new YucerawdataDAL().GetYucerawdataAnalysis(touzhushijian); dgvResult.DataSource = ds.Tables[0]; SetGridColor(); }
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 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(); }