//private void CustomCellMergeColumnGridView()
//{
// for (int i = 0; i < gridView1.Columns.Count; i++)
// {
// if (gridView1.Columns[i].FieldName == "ngaytaodt")
// {
// gridView1.Columns[i].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
// gridView1.Columns[i-1].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
// }
// else
// {
// gridView1.Columns[i].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
// }
// }
//}
private void gridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
GridView currentView = sender as GridView;
for (int i = 0; i < gridView1.Columns.Count; i++)
{
int abc = int.Parse(gridView1.Columns[i].VisibleIndex.ToString());
if (e.Column.VisibleIndex == abc)
{
if (abc % 2 == 0)
{
e.Appearance.BackColor = Color.Pink;
}
else
{
e.Appearance.BackColor = Color.White;
}
}
}
//if (e.Column.VisibleIndex == )
//{
// bool value = Convert.ToBoolean(currentView.GetRowCellValue(e.RowHandle, "Flag_Customer"));
// if (value)
// e.Appearance.BackColor = Color.Red;
//}
//if (e.Column.FieldName == "Vendor")
//{
// bool value = Convert.ToBoolean(currentView.GetRowCellValue(e.RowHandle, "Flat_Vendor"));
// if (value)
// e.Appearance.BackColor = Color.Red;
//}
}
private void dgvDetail_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
int[] rowIndexxx = dgvDetail.GetSelectedRows();
if (rowIndexxx != null && rowIndexxx.Length == 1)
{
//第一行
if (e.RowHandle == rowIndexxx[0])
{
if (cma1.MergeFieldNameList.Contains(e.Column.FieldName))
{
return;
}
e.Appearance.BackColor = Color.LightSkyBlue;
}
else
{
e.Appearance.Reset();
}
}
else
{
e.Appearance.Reset();
}
}
private void gridView2_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
#region gridView2 RowCellStyle
string comm = gridView2.GetRowCellDisplayText(e.RowHandle, gridView2.Columns["COMMENT"]);
string status = gridView2.GetRowCellDisplayText(e.RowHandle, gridView2.Columns["F_STATUS"]);
string pcsP = gridView2.GetRowCellDisplayText(e.RowHandle, gridView2.Columns["PCS_P"]);
bool tm = System.Text.RegularExpressions.Regex.IsMatch(comm, @"Are used in DATE=([A-Za-z0-9\-]+)");
if (comm != "" && tm == true)
{
e.Appearance.ForeColor = Color.Blue;
}
else if (status == "NO")
{
e.Appearance.ForeColor = Color.DarkOrchid;
}
else if (comm != "" && tm == false)
{
e.Appearance.ForeColor = Color.Red;
}
else if (pcsP == "PCS")
{
e.Appearance.BackColor = Color.Pink;
}
#endregion
}
/// <summary>
/// 鼠标移动到哪一行，背景色就为浅蓝色
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
if (e.RowHandle == this.HotTrackRow)
{
e.Appearance.BackColor = Color.CornflowerBlue;
}
}
private void gvwView_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
if (gvwView.GetRowCellValue(e.RowHandle, "Process").ToString().Equals("SET TOTAL"))
{
e.Appearance.BackColor = Color.FromArgb(92, 207, 249);
}
}
private void gridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
/*
* GridView view = sender as GridView;
* //if (e.Column.FieldName == "colIdPersona")
*
* if (e.Column.FieldName == "IdPersona")
* {
* int valor = 0;
* try
* {
* valor = Convert.ToInt32(view.GetRowCellValue(e.RowHandle, view.Columns["IdPersona"]).ToString());
* }
* catch (Exception exception)
* {
* valor = 0;
* }
*
* if (valor == miEntidadPersona.IdPersona)
* {
* Mensajes.MensajeRapido("Coincide");
* e.Appearance.BackColor = Color.Aqua;
* e.Appearance.BackColor2 = Color.LightCyan;
* }
* else
* {
* e.Appearance.BackColor = Color.DarkSlateGray;
* e.Appearance.BackColor2 = Color.Black;
* }
*
* }
*/
}
private void advBandedGridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
//if (e.RowHandle >= 0)
//{
// DevExpress.XtraGrid.Views.Grid.GridView View = sender as GridView;
// string err = View.GetRowCellDisplayText(e.RowHandle, View.Columns["check_memo"]);
// if (err != "Y")
// {
// e.Appearance.BackColor = Color.YellowGreen;
// e.Appearance.BackColor2 = Color.White;
// }
//}
//---------------------------------------------------------------------------
GridView view = sender as GridView;
if (view == null)
{
return;
}
if (e.RowHandle != view.FocusedRowHandle)
{
DevExpress.XtraGrid.Views.Grid.GridView View = sender as GridView;
string err = View.GetRowCellDisplayText(e.RowHandle, View.Columns["check_memo"]);
if (err != "Y")//Cell의 값이 APPLE인 경우 Cell색 변경
{
e.Appearance.BackColor = Color.YellowGreen;
e.Appearance.BackColor2 = Color.White; //그라데이션 처리
}
}
}
private void gridView_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
if (e.RowHandle == HotTrackRow && e.Column.FieldName == "Employee")
{
e.Appearance.Font = new Font(e.Appearance.Font, e.Appearance.Font.Style | FontStyle.Underline);
}
}
private void GridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
GridView View = sender as GridView;
if (e.Column.FieldName == "ThongTin")
{
string category = View.GetRowCellDisplayText(e.RowHandle, View.Columns["ThongTin"]);
if (category == "Hình đang nhập")
{
e.Appearance.BackColor = Color.HotPink;
}
else if (category == "Hình chờ check")
{
e.Appearance.BackColor = Color.OrangeRed;
e.Appearance.ForeColor = Color.White;
}
else if (category == "Hình đang check")
{
e.Appearance.BackColor = Color.Purple;
e.Appearance.ForeColor = Color.White;
}
else if (category == "Hình hoàn thành")
{
e.Appearance.BackColor = Color.Green;
e.Appearance.ForeColor = Color.White;
}
}
}
private void grv_DanhSachSV_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
GridView View = sender as GridView;
if (e.Column.FieldName == "DTB")
{
string DTB = View.GetRowCellDisplayText(e.RowHandle, View.Columns["DTB"]);
if (!string.IsNullOrEmpty(DTB))
{
if (double.Parse(DTB) == 0)
{
e.Appearance.BackColor = Color.FromArgb(150, Color.Salmon);
e.Appearance.BackColor2 = Color.FromArgb(150, Color.White);
}
}
}
if (e.Column.FieldName == "XepLoaiTN")
{
string XepLoaiTN = View.GetRowCellDisplayText(e.RowHandle, View.Columns["XepLoaiTN"]);
if (XepLoaiTN == "Chưa đủ điều kiện TN")
{
e.Appearance.BackColor = Color.FromArgb(150, Color.Salmon);
e.Appearance.BackColor2 = Color.FromArgb(150, Color.White);
}
}
}
private void GVDanhSachCho_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
try
{
GridView View = sender as GridView;
if (e.RowHandle >= 0)
{
string MaCD = View.GetRowCellValue(e.RowHandle, this.col_MaChiDinh_GCDanhSachCho) == null ? string.Empty : View.GetRowCellValue(e.RowHandle, this.col_MaChiDinh_GCDanhSachCho).ToString();
if (!string.IsNullOrEmpty(MaCD))
{
if (MaCD.Substring(0, 2).Equals("XN"))
{
e.Appearance.BackColor = Color.Salmon;
e.Appearance.BackColor2 = Color.SeaShell;
}
else
{
e.Appearance.BackColor = Color.Aqua;
e.Appearance.BackColor2 = Color.AliceBlue;
}
}
}
}
catch { }
}
private void main_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
GridView View = sender as GridView;
if (e.RowHandle >= 0)
{
O_KHOANGAY dl = View.GetRow(e.RowHandle) as O_KHOANGAY;
if (e.Column.FieldName == "StrTrangThai")
{
if (dl.HoatDong)
{
e.Appearance.BackColor = Color.Green;
}
else
{
e.Appearance.BackColor = Color.Crimson;
}
}
if (e.Column.FieldName == "StrNganHang")
{
if (dl.NganHang)
{
e.Appearance.BackColor = Color.Green;
}
else
{
e.Appearance.BackColor = Color.Crimson;
}
}
}
}
private void listGridView_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
GridView gView = sender as GridView;
if (e.Column.FieldName == "Status")
{
string status = gView.GetRowCellDisplayText(e.RowHandle, gView.Columns["Status"]);
switch (status)
{
case "คืนของผิดเงื่อนไข":
e.Appearance.BackColor = Color.PaleVioletRed;
e.Appearance.ForeColor = Color.White;
break;
case "เปลี่ยนสินค้า":
e.Appearance.BackColor = Color.CornflowerBlue;
e.Appearance.ForeColor = Color.White;
break;
case "ลดหนี้/คืนเงิน":
e.Appearance.BackColor = Color.MediumSeaGreen;
e.Appearance.ForeColor = Color.White;
break;
}
}
}
/// <summary>
/// 颜色变化 方法重载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public override void _HTDataDts_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
try
{
base._HTDataDts_RowCellStyle(sender, e);
if (e.Column.FieldName == "FormStatusName")
{
e.Appearance.BackColor = SaleOrderStatusProc.GetGridRowBackColor(SysConvert.ToString(gridView1.GetRowCellValue(e.RowHandle, "FormStatusName")));
}
if (e.Column.FieldName == "OrderStepName")
{
e.Appearance.BackColor = SaleOrderStepProc.GetGridRowBackColor(SysConvert.ToInt32(gridView1.GetRowCellValue(e.RowHandle, "OrderStepID")));
}
if (SysConvert.ToInt32(gridView1.GetRowCellValue(e.RowHandle, "CancelFlag")) == 1)
{
e.Appearance.BackColor = Color.DarkGray;
}
if (e.Column.FieldName == "ReceiveAmount")
{
e.Appearance.BackColor = Color.BurlyWood;
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
private void gridView3_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
var oView = (GridView)sender;
if (e.Column.FieldName == "colElecStatus_text")
{
var ElectricValue = oView.GetRowCellDisplayText(e.RowHandle, "colElecStatus_text").ToString();
if (ElectricValue == "การสื่อสารผิดพลาด")
{
e.Appearance.BackColor = Color.FromName("Red");
e.Appearance.BackColor2 = Color.SeaShell;
e.Appearance.ForeColor = Color.FromName("White");
}
}
if (e.Column.FieldName == "colCutStatus_text")
{
var CutValue = oView.GetRowCellDisplayText(e.RowHandle, "colCutStatus_text").ToString();
if (CutValue == "ตัดไฟ")
{
e.Appearance.BackColor = Color.FromName("Red");
e.Appearance.BackColor2 = Color.SeaShell;
e.Appearance.ForeColor = Color.FromName("White");
}
}
}
private void gridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
if (e.Column.FieldName == "Yayın Tarihi" || e.Column.FieldName == "Revizyon" || e.Column.FieldName == "Rev. Tarihi" || e.Column.FieldName == "Durumu" || e.Column.FieldName == "No")
{
e.Appearance.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
}
}
private void gridView3_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
GridView view = sender as GridView;
if (view == null)
{
return;
}
if (e.RowHandle != view.FocusedRowHandle)
{
DevExpress.XtraGrid.Views.Grid.GridView View = sender as GridView;
string err = View.GetRowCellDisplayText(e.RowHandle, View.Columns["large_name"]);
if (err == "합계")//Cell의 값이 APPLE인 경우 Cell색 변경
{
e.Appearance.BackColor = Color.Cornsilk;
e.Appearance.BackColor2 = Color.Cornsilk; //그라데이션 처리
}
else if (err == "총계")
{
{
e.Appearance.BackColor = Color.Ivory;
e.Appearance.BackColor2 = Color.Ivory; //그라데이션 처리
}
}
}
}
private void gridViewMeetings_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
if (e.RowHandle == HotTrackRow)
{
e.Appearance.Font = new Font(e.Appearance.Font, FontStyle.Underline);
}
}
private void inspectorsGridView_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
GridView v = sender as GridView;
var data = v.GetRow(e.RowHandle) as Inspector;
if (data != null)
{
if (!data.IsActive)
{
e.Appearance.ForeColor = Color.Gray;
}
foreach (InspectorCertificate c in data.Certificates)
{
if (c.Certificate.ExpirationDate <= inspectionDate && data.IsActive)
{
e.Appearance.ForeColor = Color.Red;
}
else
{
if (data.IsActive)
{
e.Appearance.ForeColor = Color.Black;
}
}
}
}
}
private void gv_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
if (e.RowHandle != gv.FocusedRowHandle && (e.RowHandle % 2 == 0))
{
e.Appearance.BackColor = Setting.RowColor();
}
}
private void gridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
GridView view = sender as GridView;
if (e.RowHandle == view.FocusedRowHandle)
{
e.Appearance.BackColor = Color.LawnGreen;
}
}
private void gridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
GridView view = sender as GridView;
if (e.RowHandle != view.FocusedRowHandle)
{//鼠标没有点击的地方，设置为金黄色
//e.Appearance.BackColor = Color.PaleGoldenrod;
}
}
private void gridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
GridView view = sender as GridView;
if (Convert.ToBoolean(view.GetRowCellValue(e.RowHandle, view.Columns["Discontinued"])))
{
e.Appearance.Assign(style);
}
}
private void gridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
GridView view = sender as GridView;
if (view.FocusedRowHandle == e.RowHandle && !view.FocusedColumn.Equals(e.Column))
{
e.Appearance.BackColor = Color.Orange;
}
}
//--------------------------------------------------//
//Event
private void gvwBase2_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
GridView ex = sender as GridView;
if (e.Column.ColumnHandle > 4)
{
if (ex.GetRowCellValue(e.RowHandle, "Div").ToString().ToUpper().Equals("BOTTOM SET"))
{
e.Appearance.BackColor = Color.FromArgb(242, 242, 242);
}
else if (ex.GetRowCellValue(e.RowHandle, "Div").ToString().ToUpper().Equals("STOCKFIT INCOMING SET"))
{
e.Appearance.BackColor = Color.White;
}
}
if (e.Column.ColumnHandle > 5 && (!ex.GetRowCellValue(e.RowHandle, "Plant").ToString().Contains("Total") && !ex.GetRowCellValue(e.RowHandle, "Factory").ToString().Contains("Total")))
{
if (e.CellValue == null || e.CellValue.ToString() == "")
{
return;
}
if (e.Column.FieldName.Contains("Total Inv"))
{
if (Convert.ToDouble(e.CellValue.ToString().Replace(",", "")) < 0)
{
e.Appearance.BackColor = Color.Red;
e.Appearance.ForeColor = Color.White;
}
else if (Convert.ToDouble(e.CellValue.ToString().Replace(",", "")) >= Convert.ToDouble(ex.GetRowCellValue(e.RowHandle, "Target").ToString().Replace(",", "")))
{
e.Appearance.BackColor = Color.Green;
e.Appearance.ForeColor = Color.White;
}
else if (Convert.ToDouble(e.CellValue.ToString().Replace(",", "")) < Convert.ToDouble(ex.GetRowCellValue(e.RowHandle, "Target").ToString().Replace(",", "")))
{
e.Appearance.BackColor = Color.Yellow;
}
}
}
if (e.Column.ColumnHandle > 2)
{
if (ex.GetRowCellValue(e.RowHandle, "Plant").ToString() == "Total")
{
e.Appearance.BackColor = Color.LightCyan;
e.Appearance.ForeColor = Color.Coral;
}
}
if (e.Column.ColumnHandle > 1)
{
if (ex.GetRowCellValue(e.RowHandle, "Factory").ToString() == "G-Total")
{
e.Appearance.BackColor = Color.LightSalmon;
e.Appearance.ForeColor = Color.Black;
}
}
}
private void GridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
GridView view = sender as GridView;
if (e.Column == view.Columns["fix_chef_amt"])
{
e.Appearance.BackColor = Color.LightYellow;
}
}
public void gridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
GridView view = sender as GridView;
string key = e.Column.FieldName + ";" + e.RowHandle.ToString();//bắt lấy cái ô đang thực hiện update
//if (cells.Contains(key))//nếu ô này có sửa data thì nó sẽ nằm trong cái biến mình lưu ở trên
e.Appearance.ForeColor = Color.Red; //sửa nền ô
//else
//e.Appearance.BackColor = Color.White; //đưa màu nền về mặc định hoặc khỏi dùng cái này cũng được, tùy mục đích
}
private void gridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
GridView view = sender as GridView;
if (e.RowHandle == view.FocusedRowHandle)
{
e.Appearance.FontStyleDelta = FontStyle.Bold;
e.Appearance.ForeColor = Color.Black;
}
}
private void gridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
GridView view = sender as GridView;
if (e.Column.FieldName == "StateName")
{
String color = view.GetRowCellValue(e.RowHandle, "Color").ToString();
e.Appearance.BackColor = ColorHelper.ToColor(color);
}
}
private void brvQryDetail_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
bool isAdjust = false;
BaseView baseView = sender as BaseView;
ColumnView colView = (ColumnView)this.grdQryDetail.MainView;
FontStyle fontStyle = FontStyle.Regular;
if (e.RowHandle == colView.FocusedRowHandle)
{
switch (e.Column.FieldName)
{
case "NG_QTY":
fontStyle = FontStyle.Regular;
isAdjust = true;
break;
case "REP_QTY":
fontStyle = FontStyle.Regular;
isAdjust = true;
break;
case "BREAK_QTY":
fontStyle = FontStyle.Regular;
isAdjust = true;
break;
default:
break;
}
if (isAdjust)
{
//Apply the appearance of the SelectedRow
if (baseView.GetType() == typeof(GridView))
{
e.Appearance.Assign(((GridView)baseView).PaintAppearance.SelectedRow);
}
else if (baseView.GetType() == typeof(BandedGridView))
{
e.Appearance.Assign(((BandedGridView)baseView).PaintAppearance.SelectedRow);
}
else
{
//nothing
}
e.Appearance.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
//Just to illustrate how the code works. Remove the following lines to see the desired appearance.
//e.Appearance.Options.UseForeColor = true;
e.Appearance.ForeColor = Color.Red;
e.Appearance.Font = new System.Drawing.Font("Tahoma", 8.25F, fontStyle);
}
}
}