DevExpreess Gridview 表格的背景颜色 2

/// <summary>
    /// 修改表格的背景颜色
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    private void gridView1_CustomDrawCell(object sender, DevExpress.XtraGrid.Views.Base.RowCellCustomDrawEventArgs e)
    {
        //修改指定单元格的颜色
        if (modifyCellBackColor && e.Column.FieldName == "Work")
        {
            string strName = gridView1.GetRowCellDisplayText(e.RowHandle, gridView1.Columns["Work"]);
            //实现修改指定格的颜色
            if (strName.Equals("技术主管"))
            {
                e.Appearance.BackColor = Color.SkyBlue;
                e.Appearance.BackColor2 = Color.LightCyan;
            }

        }

            //修改指定单元格的颜色
            if (modifyColumnBackColor && e.Column.FieldName == "Sex")
            {
                string strName = gridView1.GetRowCellDisplayText(e.RowHandle, gridView1.Columns["Sex"]);
                //实现修改指定列的颜色
                if (!string.IsNullOrEmpty(strName))
                {
                    e.Appearance.BackColor = Color.OrangeRed;
                }

            }


            DataRow dr = gridView1.GetDataRow(e.RowHandle);
            if (dr != null)
            {
                //修改指定值对应行的背景颜色
                if (modifySingleRowBackColor && dr["Work"].ToString() == "产品经理")
                {
                    e.Appearance.BackColor = Color.SkyBlue;
                }

                //修改指定行背景颜色
                if (modifyMutiRowBackColor && e.RowHandle >= 6 && e.RowHandle <= 8)
                {
                    e.Appearance.BackColor = Color.Pink;
                }

            }


            gridView1.RefreshData();
        }