private void gridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
int mergedCellCountForCurrenRH = 0;
if (mergedRows.Count > 0)
{
mergedCellCountForCurrenRH = mergedRows[e.RowHandle];
}
if ((e.RowHandle + mergedCellCountForCurrenRH) % 2 == 0)
{
e.Appearance.BackColor = Color.AliceBlue;
;
}
}
private void gridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
if (e != null)
{
if (e.RowHandle % 2 == 0)
{
e.Appearance.BackColor = Color.AliceBlue;
}
else
{
e.Appearance.BackColor = Color.White;
}
}
}
private void gridView2_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
try
{
if (SysConvert.ToDecimal(gridView2.GetRowCellValue(e.RowHandle, "Qty")) > 0)
{
e.Appearance.BackColor = Color.Pink;
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
private void gridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
try
{
if (e.Column.FieldName == "GBStatusName")
{
e.Appearance.BackColor = ItemGBQuery.GetGridRowBackColor(SysConvert.ToString(gridView1.GetRowCellValue(e.RowHandle, "GBStatusName")));
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
private void grvData_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
decimal slMua = TextUtils.ToDecimal(grvData.GetRowCellValue(e.RowHandle, gridColumn11));
decimal slDaVe = TextUtils.ToDecimal(grvData.GetRowCellValue(e.RowHandle, gridColumn12));
int status = TextUtils.ToInt(grvData.GetRowCellValue(e.RowHandle, colStatus));
string thongSo = TextUtils.ToString(grvData.GetRowCellValue(e.RowHandle, colSpecifications));
string dateEnd = TextUtils.ToString(grvData.GetRowCellDisplayText(e.RowHandle, gridColumn18));
string orderCode = TextUtils.ToString(grvData.GetRowCellValue(e.RowHandle, colOrderCode));
if ((slMua > slDaVe && status > 1 && thongSo != "TPA") || (dateEnd == "" && orderCode != ""))
{
e.Appearance.BackColor = Color.Yellow;
}
}
private void gvListChungTu_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
ChungTuBanHangChiTietHangHoaBHInfor ct = (ChungTuBanHangChiTietHangHoaBHInfor)gvListChungTu.GetRow(e.RowHandle);
if (ct != null)
{
if (ct.LoaiGiaoDich == 1 && (e.Column.FieldName.Equals("LoaiGiaoDich") || e.Column.FieldName.Equals("TenKho") || e.Column.FieldName.Equals("NgayLap")))
{
e.Appearance.BackColor = tsslGiamGia.BackColor;
e.Appearance.ForeColor = tsslGiamGia.ForeColor;
//e.Appearance.Font = new Font("Arial", 9, FontStyle.Italic);
}
}
}
/// <summary>
/// Change the color of selected rows to highlight them.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <remarks>Created: Theo Crous 28/08/2012</remarks>
private void grvLines_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
DB.VW_Line FocusedRow = grvLines.GetRow(e.RowHandle) as DB.VW_Line;
if (FocusedRow == null)
{
return;
}
if ((FocusedRow.IsReconned.HasValue && FocusedRow.IsReconned.Value))
{
e.Appearance.BackColor = Color.FromArgb(249, 239, 187);
}
}
/// <summary>
/// RowCellStyleEmp
/// </summary>
/// <param name="e"></param>
internal void RowCellStyleEmp(DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
if (e.Column == Viewer.gvEmployee.FocusedColumn && e.RowHandle == Viewer.gvEmployee.FocusedRowHandle)
{
e.Appearance.BackColor = Color.FromArgb(251, 165, 8);
e.Appearance.BackColor2 = Color.White;
}
else
{
e.Appearance.BackColor = Color.Transparent;
e.Appearance.BackColor2 = Color.Transparent;
}
Viewer.gvEmployee.Invalidate();
}
private void gridView_Clientes_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
try
{
//var data = gridView_Clientes.GetRow(e.RowHandle) as fa_Cliente_Tabla_Info;
//if (data == null)
// return;
//if (data.info_cliente.Estado == "I")
// e.Appearance.ForeColor = Color.Red;
}
catch (Exception ex)
{
Log_Error_bus.Log_Error(ex.ToString());
}
}
private void gridView2_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
try
{
string strResult = gv_WXF.GetRowCellValue(e.RowHandle, "计划状态").ToString();
if (strResult == "已下发")
{
e.Appearance.BackColor = Color.Yellow;//改变背景色
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void gvNonCashBenefit_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
if (e.Column == colCostValue1)
{
EmployeePayslip_NoncashBenefitViewModel Row = (EmployeePayslip_NoncashBenefitViewModel)gvNonCashBenefit.GetRow(e.RowHandle);
if (Row == null)
{
return;
}
if (e.RowHandle != gvNonCashBenefit.FocusedRowHandle && Row.NonCashBenefitCostValueType == eNonCashBenefitCostValueType.Fixed)
{
e.Appearance.BackColor = Color.Cornsilk;
}
}
}
private void gridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
if (e.RowHandle != -1)
{
if (e.Column.Name == "PalletLocationColumn")
{
DataRow dr = detailView.GetDataRow(e.RowHandle);
if (!Convert.ToBoolean(dr["IsEnabled"]))
{
e.Appearance.BackColor = Color.Red;
}
}
}
}
private void gridView_Pedido_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
try
{
//var data = gridView_Pedido.GetRow(e.RowHandle) as pre_PedidoXPresupuesto_det_Info;
//if (data == null)
// return;
//if (data.Estado == "I")
// e.Appearance.ForeColor = Color.Red;
}
catch (Exception ex)
{
Log_Error_bus.Log_Error(ex.ToString());
}
}
private void gridViewVentaFono_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
try
{
var data = gridViewVentaFono.GetRow(e.RowHandle) as fa_venta_telefonica_Info;
if (data.Estado == "I")
{
e.Appearance.ForeColor = Color.Red;
}
}
catch (Exception ex)
{
Log_Error_bus.Log_Error(ex.ToString());
}
}
/// <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 == "SendName")
{
e.Appearance.BackColor = FHFormStatusProc.GetGridRowBackColor(SysConvert.ToString(gridView1.GetRowCellValue(e.RowHandle, "SendName")));
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
private void gVVenta_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
var estado = gVVenta.GetRowCellValue(e.RowHandle, gVVenta.Columns["Estado"]);
switch (estado)
{
case "E":
e.Appearance.ForeColor = Color.OrangeRed;
break;
case "I":
//e.Appearance.ForeColor = Color.Green;
break;
}
}
private void gridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
try
{
if (e.RowHandle >= 0)
{
if (gridView1.GetRowCellValue(e.RowHandle, gridColbChoose).ToString().Trim() == "√")
{
e.Appearance.BackColor = Color.MediumSeaGreen;
}
}
}
catch
{ }
}
private void grvCommand_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
if (e.RowHandle >= 0 && e.Column.FieldName == "CommandName")
{
try
{
var row = grvCommand.GetRow(e.RowHandle).As <MobileOperationCommands>();
if (row != null)
{
e.Appearance.BackColor = Color.FromArgb(row.BackgroundColor);
e.Appearance.ForeColor = Color.FromArgb(row.ForeColor);
}
}catch {}
}
}
private void gridDepoHareket_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
if (e.Column == colHareket)
{
var durum = gridDepoHareket.GetRowCellValue(e.RowHandle, colHareket);
if (durum.ToString() == "Stok Çıkış")
{
e.Appearance.BackColor = Color.Chocolate;
}
else
{
e.Appearance.BackColor = Color.LightGreen;
}
}
}
public void appearance_cell(DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
if (e.CellValue == null)
{
return;
}
switch (e.CellValue.ToString())
{
case "В работе":
e.Appearance.BackColor = Color.FromArgb(255, 153, 0);
break;
case "Построение разъемов":
e.Appearance.BackColor = Color.FromArgb(255, 153, 0);
break;
case "Разработка приостановлена":
e.Appearance.BackColor = Color.FromArgb(102, 0, 204);
break;
case "Ожидание проверки":
e.Appearance.BackColor = Color.FromArgb(255, 255, 0);
break;
case "Разработка остановлена":
e.Appearance.BackColor = Color.FromArgb(255, 0, 0);
break;
case "Разработка модели приостановлена":
e.Appearance.BackColor = Color.FromArgb(102, 0, 204);
break;
case "Разработка модели остановлена":
e.Appearance.BackColor = Color.FromArgb(255, 0, 0);
break;
case "Разработка модели завершена":
e.Appearance.BackColor = Color.FromArgb(0, 255, 0);
break;
case "Модель нуждается в доработке":
e.Appearance.BackColor = Color.FromArgb(0, 0, 255);
break;
case null:
break;
}
}
private void grdView_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
try
{
if (e.Column.AbsoluteIndex >= 7)
{
string ValueCell = grdView.GetRowCellValue(e.RowHandle, grdView.Columns[e.Column.FieldName]).ToString();
if (ValueCell.Length > 1)
{
ValueCell = ValueCell.Substring(0, 1);
}
switch (ValueCell)
{
case "Y":
e.Appearance.BackColor = Color.Yellow;
e.Appearance.ForeColor = Color.Yellow;
break;
case "G":
e.Appearance.BackColor = Color.Green;
e.Appearance.ForeColor = Color.Green;
break;
case "R":
e.Appearance.BackColor = Color.Red;
e.Appearance.ForeColor = Color.Red;
break;
case "S":
e.Appearance.BackColor = Color.SkyBlue;
e.Appearance.ForeColor = Color.SkyBlue;
break;
case "C":
e.Appearance.BackColor = Color.Silver;
e.Appearance.ForeColor = Color.Silver;
break;
default:
break;
}
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
}
}
private void bdgrdView_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
try
{
//if (bdgrdView.GetRowCellValue(e.RowHandle, "HMS").ToString().Contains("CURR"))
//{
// e.Appearance.BackColor = Color.FromArgb(255, 187, 0);
// e.Appearance.ForeColor = Color.White;
//}
if (gvwView.GetRowCellValue(e.RowHandle, "DIV").ToString().Contains("POD"))
{
e.Appearance.BackColor = Color.FromArgb(254, 255, 198);
e.Appearance.ForeColor = Color.Black;
}
if (gvwView.GetRowCellValue(e.RowHandle, "DIV").ToString().Contains("POH"))
{
e.Appearance.BackColor = Color.FromArgb(244, 192, 19);
e.Appearance.ForeColor = Color.Black;
}
if (e.Column.FieldName.Contains("RATE"))
{
if (e.CellValue.ToString().Contains("G"))
{
e.Appearance.BackColor = Color.LimeGreen;
e.Appearance.ForeColor = Color.Black;
}
else if (e.CellValue.ToString().Contains("R"))
{
e.Appearance.BackColor = Color.Red;
e.Appearance.ForeColor = Color.White;
}
else if (e.CellValue.ToString().Contains("Y"))
{
e.Appearance.BackColor = Color.Yellow;
e.Appearance.ForeColor = Color.Black;
}
}
//if (gvwView.GetRowCellValue(e.RowHandle, "HMS").ToString().Contains("TOTAL"))
//{
// e.Appearance.BackColor = Color.FromArgb(254, 255, 198);
// e.Appearance.ForeColor = Color.Black;
//}
}
catch (Exception ex)
{ }
}
private void gvwBase_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
try
{
double temp = 0.0;
// // Value of previous row.
double temp2 = 0.0;
//if (gvwBase.RowCount == 0) return;
if (gvwBase.GetRowCellDisplayText(e.RowHandle, "DIV") == "Order") // && e.Column.FieldName.Contains("H"))
{
e.Appearance.ForeColor = Color.Blue; //to mau het dong
}
if (gvwBase.GetRowCellDisplayText(e.RowHandle, "DIV") == "JIT Plan" && e.Column.AbsoluteIndex > 2) // && e.Column.FieldName.Contains("H"))
{
e.Appearance.BackColor = Color.Yellow; //to mau het dong
}
if (gvwBase.GetRowCellDisplayText(e.RowHandle, "DIV") == "Out" && e.Column.FieldName.Contains("H"))
{
double.TryParse(e.CellValue.ToString(), out temp); //out
double.TryParse(gvwBase.GetRowCellValue(e.RowHandle - 1, e.Column.FieldName).ToString(), out temp2); //order
if (temp > 0 && temp == temp2) //if out = order
{
// Green.
e.Appearance.ForeColor = Color.Green;
// Black.
// e.Appearance.ForeColor = Color.FromArgb(0, 0, 0);
}
else if (temp > 0 && temp != temp2) //if out = order
{
// Green.
e.Appearance.ForeColor = Color.Red;
// Black.
// e.Appearance.ForeColor = Color.White;
}
if (e.Column.FieldName.Contains("H"))
{
e.Appearance.Font = new Font(e.Appearance.Font.FontFamily, e.Appearance.Font.Size, FontStyle.Bold);
}
}
}
catch { }
}
private void gvwView_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
if (e.Column.FieldName.Contains("RATE"))
{
if (e.CellValue.ToString().Replace("%", "") != "")
{
if (Convert.ToDouble(e.CellValue.ToString().Replace("%", "").Trim()) > i_max)
{
e.Appearance.BackColor = Color.Green;
e.Appearance.ForeColor = Color.White;
}
else if (Convert.ToDouble(e.CellValue.ToString().Replace("%", "").Trim()) >= i_min && Convert.ToDouble(e.CellValue.ToString().Replace("%", "").Trim()) <= i_max)
{
e.Appearance.BackColor = Color.Yellow;
e.Appearance.ForeColor = Color.Black;
}
else
{
e.Appearance.BackColor = Color.Red;
e.Appearance.ForeColor = Color.White;
}
}
}
//else if (e.Column.FieldName.Contains("MC"))
//{
// if (e.CellValue.ToString() != "")
// {
// if (e.CellValue.ToString().Contains("COMP") )
// {
// e.Appearance.BackColor = Color.SkyBlue;
// e.Appearance.ForeColor = Color.Black;
// }
// else if (e.CellValue.ToString().Contains("TPU"))
// {
// e.Appearance.BackColor = Color.LightCoral;
// e.Appearance.ForeColor = Color.Black;
// }
// else
// {
// e.Appearance.BackColor = Color.White;
// e.Appearance.ForeColor = Color.Black;
// }
// }
// //e.Appearance.BackColor = Color.FromArgb(255, 255, 192);
// //e.Appearance.ForeColor = Color.Black;
// //e.Appearance.Font = new System.Drawing.Font("Calibri", 16, FontStyle.Regular);
//}
}
private void gridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
if (e.RowHandle < 0 || e.CellValue == null)
{
return;
}
if (e.Column == this.colCurrentPrice)
{
var changePercentageString = this.gridView1.GetRowCellValue(e.RowHandle, this.colChangePercentage).ToString();
var changePercentage = decimal.Parse(changePercentageString.Substring(0, changePercentageString.Length - 1));
if (changePercentage > 0)
{
e.Appearance.ForeColor = System.Drawing.Color.Red;
}
else if (changePercentage < 0)
{
e.Appearance.ForeColor = System.Drawing.Color.Green;
}
}
else if (e.Column == this.colSubjectNetProfitRate || e.Column == this.colChangePercentage || e.Column == this.colStockProfitRate)
{
var cellValueString = e.CellValue.ToString();
var cellValue = decimal.Parse(cellValueString.Substring(0, cellValueString.Length - 1));
if (cellValue > 0)
{
e.Appearance.ForeColor = System.Drawing.Color.Red;
}
else if (cellValue < 0)
{
e.Appearance.ForeColor = System.Drawing.Color.Green;
}
}
else if (e.Column == this.colSubjectNetProfit || e.Column == this.colStockProfit)
{
var cellValue = decimal.Parse(e.CellValue.ToString());
if (cellValue > 0)
{
e.Appearance.ForeColor = System.Drawing.Color.Red;
}
else if (cellValue < 0)
{
e.Appearance.ForeColor = System.Drawing.Color.Green;
}
}
}
private void grvCanhBaoSanBay_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
if (e.RowHandle == grvCanhBaoSanBay.FocusedRowHandle)
{
e.Appearance.BackColor = Color.Green;
if (e.Column.FieldName != "NoiDung")
{
e.Appearance.ForeColor = Color.White;
}
else
{
e.Appearance.ForeColor = Color.Beige;
}
e.Appearance.Font = new Font(Font.FontFamily, 8, FontStyle.Bold);
}
}
private void gridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
try
{
if (e.RowHandle >= 0)
{
decimal d = ReturnObjectToDecimal(gridView1.GetRowCellDisplayText(e.RowHandle, gridView1.Columns["缺料数量"]), 6);
if (d > 0)
{
e.Appearance.BackColor = Color.Tomato;
}
}
}
catch
{ }
}
private void viewDuLieu_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
if (e.RowHandle >= 0)
{
DevExpress.XtraGrid.Views.Grid.GridView view = sender as DevExpress.XtraGrid.Views.Grid.GridView;
if (e.Column.FieldName == "QuantityNG" || view.GetRowCellValue(e.RowHandle, "PartNo").ToString() == "Mã vạch bị NOT FOUND + NG")
{
e.Appearance.ForeColor = Color.Red;
}
else if (e.Column.FieldName == "QuantityOK")
{
e.Appearance.ForeColor = Color.Blue;
e.Appearance.Font = new Font("Segoe UI", 10F, FontStyle.Bold);
}
}
}
private void gvwBase_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
if (gvwBase.GetRowCellValue(e.RowHandle, gvwBase.Columns["DIVISION"]).ToString().Contains("GREEN"))
{
e.Appearance.BackColor = Color.LightSkyBlue;
}
if (gvwBase.GetRowCellValue(e.RowHandle, gvwBase.Columns["DIVISION"]).ToString().Contains("RED"))
{
e.Appearance.BackColor = Color.Red;
}
if (gvwBase.GetRowCellValue(e.RowHandle, gvwBase.Columns["DIVISION"]).ToString().Contains("YELLOW"))
{
e.Appearance.BackColor = Color.Yellow;
}
}
private void gridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
//try
//{
// if (e.RowHandle >= 0)
// {
// string s1 = gridView1.GetRowCellValue(e.RowHandle, gridView1.Columns["bChoose"]).ToString().Trim();
// if (s1 == "√")
// {
// e.Appearance.BackColor = Color.MediumSeaGreen;
// }
// }
//}
//catch
//{ }
}
