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