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