源码
//列变色(在数据库中添加列"背景颜色")
private void gridView1_RowCellStyle(object sender, RowCellStyleEventArgs e)
{
try
{
if (gridView1.Columns.Contains(gridView1.Columns["背景颜色"]))
{
if (Convert.ToString(gridView1.GetRowCellValue(e.RowHandle, gridView1.Columns["背景颜色"])) != "")
{
string[] strColor = Convert.ToString(gridView1.GetRowCellValue(e.RowHandle, gridView1.Columns["背景颜色"])).Split(',');
int nA = Convert.ToInt16(strColor[0]);
int nB = Convert.ToInt16(strColor[1]);
int nC = Convert.ToInt16(strColor[2]);
if (e.Column.FieldName == "订单齐套率")
{
e.Appearance.BackColor = Color.FromArgb(nA, nB, nC);
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("错误信息:" + ex.Message, "出现错误");
}
}
//行变色,字体变色方法
private void gridView1_RowStyle(object sender, RowStyleEventArgs e)
{
try
{
if (gridView1.Columns.Contains(gridView1.Columns["背景颜色"]))
{
if (Convert.ToString(gridView1.GetRowCellValue(e.RowHandle, gridView1.Columns["背景颜色"])) != "")
{
string[] strColor = Convert.ToString(gridView1.GetRowCellValue(e.RowHandle, gridView1.Columns["背景颜色"])).Split(',');
int nA = Convert.ToInt16(strColor[0]);
int nB = Convert.ToInt16(strColor[1]);
int nC = Convert.ToInt16(strColor[2]);
//e.Appearance.BackColor = Color.FromArgb(nA, nB, nC);
}
}
}
catch
{
}
try
{
if (gridView1.Columns.Contains(gridView1.Columns["字体颜色"]))
{
if (Convert.ToString(gridView1.GetRowCellValue(e.RowHandle, gridView1.Columns["字体颜色"])) != "")
{
string[] strColor = Convert.ToString(gridView1.GetRowCellValue(e.RowHandle, gridView1.Columns["字体颜色"])).Split(',');
int nA = Convert.ToInt16(strColor[0]);
int nB = Convert.ToInt16(strColor[1]);
int nC = Convert.ToInt16(strColor[2]);
//e.Appearance.ForeColor = Color.FromArgb(nA, nB, nC);
}
}
}
catch
{
}
}
字体、背景色
private void bandedGridView1_RowCellStyle(object sender, RowCellStyleEventArgs e)
{
GridView currentView = sender as GridView;
DataRow row = this.bandedGridView1.GetDataRow(e.RowHandle);
//行变色
if (row["序号"].ToString() == "")
{
e.Appearance.BackColor = Color.FromArgb(89,89,89);
e.Appearance.ForeColor = Color.FromArgb(255,255,255);
e.Appearance.BorderColor = Color.Black;
e.Appearance.Font = new System.Drawing.Font("宋体", 10, FontStyle.Bold);
}
//列变色
if (e.Column.FieldName == "品种数" || e.Column.FieldName == "常用品种数" || e.Column.FieldName == "库存总量"
|| e.Column.FieldName == "60天以上库存量" || e.Column.FieldName == "物料种类" || e.Column.FieldName == "库存量1"
|| e.Column.FieldName == "物料品种1" || e.Column.FieldName == "库存量2" || e.Column.FieldName == "物料品种2"
|| e.Column.FieldName == "库存量3" || e.Column.FieldName == "种类")
{
e.Appearance.ForeColor = Color.FromArgb(216, 138, 76);
e.Appearance.BorderColor = Color.Black;
e.Appearance.Font = new System.Drawing.Font("宋体", 10, FontStyle.Bold);
}
}