private void btnSearch_Click(object sender, EventArgs e)
{
PeilvDAL dal = new PeilvDAL();
string riqi = dtpRiqi.Value.Date.ToString("yyyy-MM-dd");
string liansai = cbLiansai.Text;
DataSet ds = dal.SearchPeilvFromKaijiang(riqi, liansai);
dgPeilv.DataSource = ds.Tables[0];
//更新联赛集合
cbLiansai.Items.Clear();
cbLiansai.Items.Add("全部");
DataSet dsLiansai = new PeilvDAL().GetPeilvLiansaiFromKaijiang(riqi);
foreach (DataRow row in dsLiansai.Tables[0].Rows)
{
cbLiansai.Items.Add(row["liansai"].ToString());
}
cbLiansai.SelectedIndex = 0;
}
private void BindGridView()
{
DataSet ds = new PeilvDAL().GetPeilvDataFromKaijiang();
dgPeilv.DataSource = ds.Tables[0];
SortedSet <string> liansai = new SortedSet <string>();
foreach (DataRow row in ds.Tables[0].Rows)
{
liansai.Add(row["liansai"].ToString());
}
cbLiansai.Items.Clear();
cbLiansai.Items.Add("全部");
foreach (string bisai in liansai)
{
cbLiansai.Items.Add(bisai);
}
cbLiansai.SelectedIndex = 0;
}
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();
}
