private void DgvHead_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (DgvHead.Rows[e.RowIndex].Cells[12].Value.ToString() == "ยกเลิก")//สถานะรายงาน
{
DgvHead.Rows[e.RowIndex].DefaultCellStyle.ForeColor = Color.Red;
}
}
/// <summary> 格式化
/// </summary>
private void dgvSyncData_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (e.Value == null || string.IsNullOrEmpty(e.Value.ToString()))
{
return;
}
string fieldNmae = dgvSyncDataLog.Columns[e.ColumnIndex].DataPropertyName;
if (fieldNmae.Equals("business_name"))
{
DataSources.EnumInterfaceType enumInterfaceType = (DataSources.EnumInterfaceType)Convert.ToInt16(e.Value.ToString());
e.Value = DataSources.GetDescription(enumInterfaceType, true);
}
if (fieldNmae.Equals("external_sys"))
{
DataSources.EnumExternalSys enumExternalSys = (DataSources.EnumExternalSys)Convert.ToInt16(e.Value.ToString());
e.Value = DataSources.GetDescription(enumExternalSys, true);
}
if (fieldNmae.Equals("sync_direction"))
{
DataSources.EnumSyncDirection enumSyncDirection = (DataSources.EnumSyncDirection)Convert.ToInt16(e.Value.ToString());
e.Value = DataSources.GetDescription(enumSyncDirection, true);
}
if (fieldNmae.Equals("sync_start_time") || fieldNmae.Equals("sync_end_time"))
{
long ticks = (long)e.Value;
e.Value = Common.UtcLongToLocalDateTime(ticks);
}
}
private void dgvPoints_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
Point p = (Point)dgvPoints.Rows[e.RowIndex].DataBoundItem;
switch (p.Type)
{
case BasicType.ANALOG_STATUS:
if (p.ValueAnalog.HasValue)
dgvPoints["dgvPoints_colValue", e.RowIndex].Value = p.ValueAnalog.ToString();
else
dgvPoints["dgvPoints_colValue", e.RowIndex].Value = "Unknown";
break;
case BasicType.DIGITAL_STATUS:
if (p.ValueDigital.HasValue)
dgvPoints["dgvPoints_colValue", e.RowIndex].Value = p.ValueDigital > 0 ? "ON" : "OFF";
else
dgvPoints["dgvPoints_colValue", e.RowIndex].Value = "Unknown";
break;
default:
break;
}
}
private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if( dataGridView1.Columns[e.ColumnIndex].Name == "tgThucTe"
||
dataGridView1.Columns[e.ColumnIndex].Name == "tgDung"){
if (e.Value != null && e.Value != DBNull.Value)
e.Value = ((TimeSpan)e.Value).Hours.ToString("00") + ":" +
((TimeSpan)e.Value).Minutes.ToString("00");
}
//var hvh = (HistoryNhanVien)dataGridView1.Rows[e.RowIndex].DataBoundItem;
//if (e.ColumnIndex == 0)
//{
// e.Value = hvh.NhanVien.MaThe;
//}
//if (e.ColumnIndex == 1)
//{
// e.Value = hvh.NhanVien.TenNhanVien;
//}
//if (e.ColumnIndex == 2) {
// e.Value = hvh.IsCheckin ? "Checkin" : "Checkout";
//}
//if (e.ColumnIndex == 4) {
// e.Value = (hvh.IsCheckin) ? DateTimeUtil.timeToString(hvh.Ca.GioBatDau) : DateTimeUtil.timeToString(hvh.Ca.GioKetThuc);
//}
//if (e.ColumnIndex == 5)
//{
// e.Value = DateTimeUtil.timeToString( hvh.ThoiGian.TimeOfDay);
//}
}
private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (dataGridView1.Rows[e.RowIndex].Cells["saleheadstatusname"].Value.ToString() == "ยกเลิก")
{
dataGridView1.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.LightPink;
}
}
/// <summary>
/// Handle the data/image binding in data grid cell
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void LocationDataGrid_CellFormatting(object sender, System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
try
{
if (LocationDataGrid.Columns[e.ColumnIndex].Name == "AvailableStatus")
{
if ((this.LocationDataGrid.Rows[e.RowIndex].Cells[7].Value).ToString() == "Available")
{
e.Value = statusList.Images[0];
}
else
{
e.Value = statusList.Images[1];
}
}
if (LocationDataGrid.Columns[e.ColumnIndex].Name == "img")
{
if ((this.LocationDataGrid.Rows[e.RowIndex].Cells[7].Value).ToString() == "Available")
{
e.Value = statusList.Images[2];;
}
else
{
e.Value = statusList.Images[3];
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, Constants.ApplicationName);
}
}
private void dataGridView_CellFormatting( object sender, DataGridViewCellFormattingEventArgs e )
{
if( (e.ColumnIndex == Offset.Index) && (e.Value != null) )
{
byte b = (byte)e.Value;
e.Value = b.ToString( "X2" );
e.FormattingApplied = true;
}
else if( e.ColumnIndex == ActionColumn.Index )
{
if( (e.RowIndex >= 0) && (e.ColumnIndex >= 0) &&
(dataGridView[e.ColumnIndex, e.RowIndex] is DataGridViewComboBoxCell) &&
(dataGridView.Rows[e.RowIndex].DataBoundItem is ActionMenu) )
{
ActionMenu menu = dataGridView.Rows[e.RowIndex].DataBoundItem as ActionMenu;
if( menu.Default != null )
{
ActionMenuEntry a = menu.Default.MenuAction;
if( a != (e.Value as ActionMenuEntry) )
{
e.CellStyle.BackColor = Color.Blue;
e.CellStyle.ForeColor = Color.White;
}
}
}
}
}
private void dgpreview_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (e.RowIndex > -1 && e.ColumnIndex > -1 && dgpreview.SelectedCells.Count > 0)
{
string n = dgpreview.Columns[e.ColumnIndex].Name;
if (dgpreview.Rows[e.RowIndex].DataBoundItem != null)
{
if (n == "ActionInfo" && App.CurrentConfig.SteamIntegrationActivated)
{
GamePreview gp = (GamePreview)dgpreview.Rows[e.RowIndex].DataBoundItem;
string t = "";
string k = Functions.Translation("keys");
if (gp.TargetGame.Keys.Count == 1) k = "key";
else if (gp.TargetGame.Keys.Count == 0) k = Functions.Translation("no key");
string keys = k;
if (gp.TargetGame.Keys.Count > 0) keys = gp.TargetGame.Keys.Count.ToString("N0") + " " + k;
switch (gp.Action)
{
case GamePreview.ImportAction.CreateANewGame:
t = string.Format(Functions.Translation("Create a new game and add {0}"), keys);
break;
case GamePreview.ImportAction.ImportKeysInExistingGame:
t = Functions.Translation("Import in a existing game");
break;
case GamePreview.ImportAction.UserActionRequired:
t = Functions.Translation("Not importable, please import this line manually");
break;
}
if (gp.ActionInfo.Length > 0) t += " (" + gp.ActionInfo + ")";
e.Value = t;
}
}
}
}
private void AmountCellFormating(DataGridView grd, DataGridViewCellFormattingEventArgs e)
{
if (grd.Columns[e.ColumnIndex].Name.Equals("Amount"))
{
e.Value = string.Format("CHF {0}.-", e.Value);
}
}
private void dtLista_CellFormatting(object sender,
System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
if (this.dtLista.Columns[e.ColumnIndex].Name.Equals("IVA"))
{
dtLista.Columns[e.ColumnIndex].Width = 35;
}
if (e.ColumnIndex == 0)
{
dtLista.Columns[e.ColumnIndex].Visible = false;
}
if (e.ColumnIndex == 1)
{
dtLista.Columns[e.ColumnIndex].Width = 75;
}
// Set the background to red for negative values in the Balance column.
if (dtLista.Columns[e.ColumnIndex].Name.Equals("Stock"))
{
if (Convert.ToInt32(e.Value) <= addProducto.getCantidadMinima())
{
e.CellStyle.BackColor = Color.DarkOrange;
}
}
}
private void dataGridView_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
Vehicle vehicle = dataGridView.Rows[e.RowIndex].DataBoundItem as Vehicle;
try
{
if (dataGridView.Columns[e.ColumnIndex].Name == "OriginId")
{
e.Value = vehicle.OriginCustomer.Id;
}
else if (dataGridView.Columns[e.ColumnIndex].Name == "OriginName")
{
e.Value = vehicle.OriginCustomer.Name;
}
else if (dataGridView.Columns[e.ColumnIndex].Name == "CurrentId")
{
e.Value = vehicle.CurrentCustomer.Id;
}
else if (dataGridView.Columns[e.ColumnIndex].Name == "CurrentName")
{
e.Value = vehicle.CurrentCustomer.Name;
}
else if (dataGridView.Columns[e.ColumnIndex].Name == "VehicleType")
{
e.Value = vehicle.Vehicletype.Name;
}
}
catch
{
MessageUtil.ShowTips("错误" + vehicle.Serial);
}
}
private void ChangesViewCellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (changesView.Columns["img"] == null)
{
return;
}
if ((e.ColumnIndex == changesView.Columns["img"].Index) && (e.Value != null))
{
DataGridViewCell cell =
changesView.Rows[e.RowIndex].Cells[e.ColumnIndex];
DataGridViewCell valueCell =
changesView.Rows[e.RowIndex].Cells["EventType"];
var eventType = (int)valueCell.Value;
switch (eventType)
{
case 1:
cell.ToolTipText = "Добавлена пара";
break;
case 2:
cell.ToolTipText = "Отменена пара";
break;
case 3:
cell.ToolTipText = "Изменена аудитория";
break;
default:
cell.ToolTipText = "Страх и ужас";
break;
}
}
}
private void dtLista_CellFormatting(object sender,
System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
//if (this.dtLista.Columns[e.ColumnIndex].Name.Equals("IVA"))
//{
// dtLista.Columns[e.ColumnIndex].Width = 35;
//}
//try
//{
// if (this.dtLista.Columns[e.ColumnIndex].Name.Equals("Codigo"))
// {
// dtLista.Columns[e.ColumnIndex].Visible = false;
// }
//}
//catch { }
// Set the background to red for negative values in the Balance column.
if (dtLista.Columns[e.ColumnIndex].Name.Equals("Stock"))
{
//if (Convert.ToInt32(e.Value) <= addPedido.getCantidadMinima())
//{
// e.CellStyle.BackColor = Color.DarkOrange;
//}
}
}
private void cellFormatter(object sender,
System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
string colName = alarmList.Columns[e.ColumnIndex].Name;
if (colName.Equals("ColumnID"))
{
if (e.Value is Int32)
{
int id = (int)e.Value;
if (id < 0)
{
e.Value = "-";
}
}
}
else if (colName.Equals("ColumnSilent"))
{
if (e.Value is AlarmDefinition.Option)
{
e.Value = (((AlarmDefinition.Option)e.Value) & AlarmDefinition.Option.Silent) != 0;
}
}
else if (colName.Equals("ColumnAutoAck"))
{
if (e.Value is AlarmDefinition.Option)
{
e.Value = (((AlarmDefinition.Option)e.Value) & AlarmDefinition.Option.AutoAck) != 0;
}
}
}
private void gridFiles_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
var row = gridFiles.Rows[e.RowIndex];
var file = (StatusFileForGrid) row.DataBoundItem;
e.CellStyle.BackColor = GetGridFilesLocalColor(file.Type);
e.CellStyle.SelectionBackColor = e.CellStyle.BackColor;
}
private void dgvResult_CellFormatting(object sender, System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
if (e.ColumnIndex == 1)
{
if (e.Value == DBNull.Value) //if DBNull
{
e.CellStyle.BackColor = Color.WhiteSmoke;
}
else
{
string temp = e.Value.ToString();
double dblCellValue = Convert.ToDouble(temp.Substring(0, temp.Length - 2));
temp = dgvResult.Rows[e.RowIndex].Cells[e.ColumnIndex + 1].Value.ToString();
double dblLowLimit = Convert.ToDouble(temp.Substring(0, temp.Length - 2));
temp = dgvResult.Rows[e.RowIndex].Cells[e.ColumnIndex + 2].Value.ToString();
double dblHighLimit = Convert.ToDouble(temp.Substring(0, temp.Length - 2));
if (dblCellValue < dblLowLimit || dblCellValue > dblHighLimit)
{
//e.CellStyle.BackColor = Color.Red;
dgvResult.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.Red;
}
else
{
dgvResult.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.Green;
}
}// end of if DBNull
}
}
/// <summary> 格式化
/// </summary>
private void dgvBakList_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (e.Value == null)
{
return;
}
try
{
string fieldNmae = dgvBakList.Columns[e.ColumnIndex].DataPropertyName;
if (fieldNmae.Equals("bak_time"))
{
long ticks = (long)e.Value;
e.Value = Common.UtcLongToLocalDateTime(ticks);
}
if (fieldNmae.Equals("bak_method"))
{
DataSources.EnumBackupMethod enumStatus = (DataSources.EnumBackupMethod)Convert.ToInt16(e.Value.ToString());
e.Value = DataSources.GetDescription(enumStatus, true);
}
if (fieldNmae.Equals("is_Success"))
{
DataSources.EnumYesNo enumStatus = (DataSources.EnumYesNo)Convert.ToInt16(e.Value.ToString());
e.Value = DataSources.GetDescription(enumStatus, true);
}
}
catch (Exception ex)
{
Utility.Log.Log.writeLineToLog(ex.Message, "选择器-备份记录列表格式化失败");
}
}
private void dgvBirthdays_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
DataGridView dgv = (DataGridView)sender;
if (cbxChooseDisplay.SelectedIndex == 1)
{
if (dgv.Columns[e.ColumnIndex].Name == "name" && e.RowIndex >= 0 && dgv["name", e.RowIndex].Value is string)
{
string modname;
string n = e.Value.ToString();
int spacepos = n.LastIndexOf(" ");
int dashpos = n.LastIndexOf("-");
if(dashpos > spacepos)
{
modname = n.Remove(0, dashpos + 1);
modname = modname.Insert(0, "The ");
}
else
{
modname = n.Remove(0, spacepos);
modname = modname.Insert(0, "The");
}
modname = modname.Insert(modname.Length, "'s");
e.Value = modname;
}
}
}
public void grdBase_onCellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
object grd = sender;
object val = e.Value;
if (e.ColumnIndex == 4 || e.ColumnIndex == 6 || e.ColumnIndex == 7)
{
e.CellStyle.Alignment = DataGridViewContentAlignment.TopCenter;
}
else
{
e.CellStyle.Alignment = DataGridViewContentAlignment.TopLeft;
}
if (e.ColumnIndex == 2)
{
e.CellStyle.WrapMode = DataGridViewTriState.True;
}
if (e.ColumnIndex == 4 || e.ColumnIndex == 6 || e.ColumnIndex == 7)
{
e.CellStyle.Format = FormatString.FormatDate;
}
}
private void DataGridView1OnCellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (dataGridView1.Columns[e.ColumnIndex].DataPropertyName.Contains("."))
e.Value = BindingExtensions.GetValueFromPath(
dataGridView1.Rows[e.RowIndex].DataBoundItem,
dataGridView1.Columns[e.ColumnIndex].DataPropertyName);
}
void OnCellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (e.ColumnIndex == 1)
{
}
}
private void dataGridView_selectedCourses_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (dataGridView_selectedCourses.Columns[e.ColumnIndex].HeaderText == "上课时间")
{
e.Value = Utils.DecodeTime(e.Value.ToString());
}
}
private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (e.ColumnIndex == 0)
{
dataGridView1.Rows[e.RowIndex].HeaderCell.Value = Convert.ToString(e.RowIndex + 1);
}
}
private void DgvPODetail_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (DgvPODetail.Rows[e.RowIndex].Cells[0].Value.ToString() == "0000000000-00")
{
DgvPODetail.Rows[e.RowIndex].DefaultCellStyle.ForeColor = Color.FromArgb(147, 4, 140);
}
}
private void hostsDataGridView_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
hostsDataGridView[e.ColumnIndex, e.RowIndex].Style.BackColor =
HostManager.IsEnabled(hostsDataGridView[HostManager.EnabledColumnNumber, e.RowIndex].Value.ToString())
? Color.LightGreen
: Color.LightGray;
}
public void grdBase_onCellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
object grd = sender;
object val = e.Value;
e.CellStyle.WrapMode = DataGridViewTriState.True;
Type dataType = val.GetType();
if (e.ColumnIndex == 2)
{
e.CellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
}
else
{
if (typeof(int) == dataType || typeof(decimal) == dataType || typeof(float) == dataType || typeof(long) == dataType || typeof(double) == dataType)
{
e.CellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
}
else if (typeof(DateTime) == dataType)
{
e.CellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
e.CellStyle.Format = FormatString.FormatDate;
}
else
{
e.CellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
}
}
}
private void dgvJuridicPersons_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (dgvJuridicPersons.Columns[e.ColumnIndex].Name == "ColumnJuridicPersonAccountId")
{
e.Value = (e.Value as AccountDTO).Code;
}
}
void DgSalesOrdersCellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
SalesOrderLine salesOrderLine = (SalesOrderLine)DgSalesOrders.Rows[e.RowIndex].DataBoundItem;
switch (DgSalesOrders.Columns[e.ColumnIndex].DataPropertyName) {
case "customer" :
e.Value = salesOrderLine.SalesOrder.Customer.name;
break;
case "salesOrderDate" :
e.Value = string.Format( "{0:dd/MM/yyyy}", salesOrderLine.SalesOrder.salesOrderDate);
break;
case "product" :
e.Value = salesOrderLine.Product.description;
break;
case "status" :
e.Value = salesOrderLine.SalesOrderStatus.description;
e.CellStyle.BackColor = GetStatusColor(salesOrderLine.SalesOrderStatus);
break;
}
}
private void dgv_Buscar_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (e.Value != null)
{
e.Value = e.Value.ToString().ToUpper();
e.FormattingApplied = true;
}
}
private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (((FormattedLogMessage)row.DataBoundItem).MessageColor!=System.Drawing.Color.Transparent)
row.DefaultCellStyle.BackColor = ((FormattedLogMessage)row.DataBoundItem).MessageColor;
}
}
private void allOperationDataGridView_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (e.Value is decimal)
{
if (Convert.ToDecimal(e.Value) == 0M)
e.Value = null;
}
}
private void pRODUTODataGridView_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
DataGridView tabela = sender as DataGridView;
if (tabela.Columns[e.ColumnIndex].Name.Equals("colunaPreco")) {
string valor = ((double)e.Value).ToString("0.00");
e.Value = valor;
}
}
private void dgvCrequest_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (e.ColumnIndex == 2) {
if (dgvCrequest.Rows[e.RowIndex].Cells["cStatusId"].Value.ToString() == "1") { // ยกเลิก
dgvCrequest.Rows[e.RowIndex].DefaultCellStyle.ForeColor = Color.Red;
}
}
}
private void outstationChannelMappingsDataGridView_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (e.ColumnIndex == dataGridViewTextBoxColumn5.Index && (e.Value == null || e.Value.Equals("")))
{
e.Value = "Unknown";
e.FormattingApplied = true;
}
}
private void dgvUser_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (dgvUser.Columns[e.ColumnIndex].Name == "PassDataGridViewTextBoxColumn" && e.Value != null)
{
dgvUser.Rows[e.RowIndex].Tag = e.Value;
e.Value = new String('*', e.Value.ToString().Length);
}
}
void steps_DataGridView_CellFormatting(object sender, System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
if (steps_DataGridView.Columns[e.ColumnIndex].Name.Equals("log"))
{
if (e.Value != null)
{
Step thisStep = steps_DataGridView.Rows[e.RowIndex].DataBoundItem as Step;
if (thisStep.Status == eStatus.COMPLETED || thisStep.Status == eStatus.FAILED)
{
string fullLogPath = e.Value.ToString();
e.Value = Path.GetFileName(fullLogPath);
DataGridViewCell thisCell = steps_DataGridView[e.ColumnIndex, e.RowIndex];
thisCell.ToolTipText = fullLogPath;
}
else
{
e.Value = "";
}
}
}
if (steps_DataGridView.Columns[e.ColumnIndex].Name.Equals("status"))
{
Step thisStep = steps_DataGridView.Rows[e.RowIndex].DataBoundItem as Step;
DataGridViewCell thisCell = steps_DataGridView[e.ColumnIndex, e.RowIndex];
if (thisStep.Status == eStatus.READY)
{
e.Value = "";
thisCell.Style.ForeColor = Color.Black;
}
else if (thisStep.Status == eStatus.COMPLETED)
{
e.Value = "Completed";
thisCell.Style.ForeColor = Color.ForestGreen;
DataGridViewRow thisRow = steps_DataGridView.Rows[e.RowIndex];
thisRow.DefaultCellStyle.Font = new Font(e.CellStyle.Font, FontStyle.Regular);
}
else if (thisStep.Status == eStatus.FAILED)
{
e.Value = "Failed";
thisCell.Style.ForeColor = Color.Red;
DataGridViewRow thisRow = steps_DataGridView.Rows[e.RowIndex];
thisRow.DefaultCellStyle.Font = new Font(e.CellStyle.Font, FontStyle.Bold);
}
else if (thisStep.Status == eStatus.SKIPPED)
{
e.Value = "Skipped";
thisCell.Style.ForeColor = Color.DarkGray;
}
else if (thisStep.Status == eStatus.STARTED)
{
e.Value = "In Progress";
thisCell.Style.ForeColor = Color.Orange;
DataGridViewRow thisRow = steps_DataGridView.Rows[e.RowIndex];
thisRow.DefaultCellStyle.Font = new Font(e.CellStyle.Font, FontStyle.Bold);
}
}
}
// Changes how cells are displayed depending on their columns and values.
private void dataGridView1_CellFormatting(object sender,
System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
// Set the background to red for negative values in the Balance column.
if (e.RowIndex > -1 && Convert.ToBoolean(pilotsList_dataGridView1[11, e.RowIndex].Value))
{
pilotsList_dataGridView1.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.FromArgb(255, 255, 198, 198);
}
}
/// <summary>
/// 格式化日期列
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void DataGridViewX1_CellFormatting(object sender, System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
if (e.ColumnIndex == DataGridViewX1.Columns["创建时间"].Index) //格式化日期
{
if (e.Value != null)
{
e.Value = Convert.ToDateTime(e.Value).ToString("yyyy-MM-dd");
}
}
}
private void dataGridView1_CellFormatting(object sender, System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
if (e.Value != null && dataGridView1.Columns[e.ColumnIndex].Name.Equals("planeNameDataGridViewTextBoxColumn"))
{
if (e.Value.ToString().Contains('a'))
{
e.CellStyle.ForeColor = Color.Green;
}
}
}
void dataGridView1_CellFormatting(object sender, System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
switch (e.ColumnIndex)
{
case 1: // TokenID
case 2: // Secret
case 4: // PrivateID
e.Value = encoder((byte[])e.Value);
break;
}
}
//</Snippet050>
// 2 of 2 for How to: Display Images in Cells of the Windows Forms DataGridView Control
//<Snippet055>
private void dataGridView1_CellFormatting(object sender,
System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
if (dataGridView1.Columns[e.ColumnIndex].Name == "Icon")
{
if (e.RowIndex % 5 == 0)
{
Bitmap bmp = new Bitmap(this.GetType(), "Bitmap2.bmp");
e.Value = bmp;
}
}
}
public void cell_formatting(object sender, System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
lock (SCMClient._help_list_sync)
{
try
{
dataGridView.ClearSelection();
foreach (DataGridViewRow row in dataGridView.Rows)
{
var r = row.DataBoundItem as Record;
if (r.APInteracted)
{
row.DefaultCellStyle.BackColor = Color.Green;
row.DefaultCellStyle.ForeColor = Color.White;
}
}
if (dataGridView.Columns[e.ColumnIndex].Name.Equals("NeedsHelp"))
{
if (e.Value.Equals(false))
{
CurrencyManager cm = (CurrencyManager)dataGridView.BindingContext[dataGridView.DataSource];
this.BeginInvoke(new MethodInvoker(() =>
{
cm.SuspendBinding();
dataGridView.Rows[e.RowIndex].Visible = false;
//RemoveRecord(dataGridView.Rows[e.RowIndex].DataBoundItem as Record);
cm.ResumeBinding();
}));
}
else
{
CurrencyManager cm = (CurrencyManager)dataGridView.BindingContext[dataGridView.DataSource];
this.BeginInvoke(new MethodInvoker(() =>
{
cm.SuspendBinding();
dataGridView.Rows[e.RowIndex].Visible = true;
//RemoveRecord(dataGridView.Rows[e.RowIndex].DataBoundItem as Record);
cm.ResumeBinding();
}));
}
}
}
catch
{
Console.WriteLine("Cell Formatting ERROR");
}
}
}
private void dataGridView1_CellFormatting(object sender, System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
if (this.dataGridView1.Columns[e.ColumnIndex].Name.Equals("POS"))
//if a column in the POS table is select, higlight the token cell as well
{
int ri = e.RowIndex;
if (dataGridView1[1, ri].Selected == true)
{
dataGridView1[0, ri].Style.BackColor = Color.LightGray;
}
}
}
private void dg_data_CellFormatting(object sender, System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
// Set the background to red for negative values in the Balance column.
if (dg_data.Columns[e.ColumnIndex].Name.Equals("clm_qty"))
{
Int32 intValue;
if (Int32.TryParse((String)e.Value, out intValue) && (intValue < 10))
{
e.CellStyle.BackColor = Color.Red;
e.CellStyle.SelectionBackColor = Color.DarkRed;
}
}
}
protected override void OnCellFormatting(System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
base.OnCellFormatting(e);
if ((e.CellStyle.FormatProvider is System.ICustomFormatter))
{
System.ICustomFormatter icustomFormatter = e.CellStyle.FormatProvider.GetFormat(typeof(System.ICustomFormatter)) as System.ICustomFormatter;
if (icustomFormatter != null)
{
e.Value = icustomFormatter.Format(e.CellStyle.Format, e.Value, e.CellStyle.FormatProvider);
e.FormattingApplied = true;
}
}
}
//</Snippet10>
//<Snippet20>
// Changes how cells are displayed depending on their columns and values.
private void dataGridView1_CellFormatting(object sender,
System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
//<Snippet21>
// Set the background to red for negative values in the Balance column.
if (dataGridView1.Columns[e.ColumnIndex].Name.Equals("Balance"))
{
Int32 intValue;
if (Int32.TryParse((String)e.Value, out intValue) &&
(intValue < 0))
{
e.CellStyle.BackColor = Color.Red;
e.CellStyle.SelectionBackColor = Color.DarkRed;
}
}
//</Snippet21>
//<Snippet22>
// Replace string values in the Priority column with images.
if (dataGridView1.Columns[e.ColumnIndex].Name.Equals("Priority"))
{
// Ensure that the value is a string.
String stringValue = e.Value as string;
if (stringValue == null)
{
return;
}
// Set the cell ToolTip to the text value.
DataGridViewCell cell = dataGridView1[e.ColumnIndex, e.RowIndex];
cell.ToolTipText = stringValue;
// Replace the string value with the image value.
switch (stringValue)
{
case "high":
e.Value = highPriImage;
break;
case "medium":
e.Value = mediumPriImage;
break;
case "low":
e.Value = lowPriImage;
break;
}
}
//</Snippet22>
}
//code untuk formatiing data di gridview
private void dgvPriceCategory_CellFormatting(object sender, System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
if (dgvPriceCategory.Columns[e.ColumnIndex].Name.Equals("Status"))
{
if (e.Value != null & e.Value.ToString() == "0")
{
e.Value = "Deactive";
}
else if (e.Value != null & e.Value.ToString() == "1")
{
e.Value = "Active";
}
}
}
public void clinetGridView_CellFromatting(Object sender, System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
if (e.ColumnIndex == 7)
{
if (e.Value.ToString() == "ture")
{
e.Value = "女";
}
else
{
e.Value = "男";
}
}
}
private void dataGridViewDetail_CellFormatting(object sender, System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
DataGridViewRow row = dataGridViewDetail.Rows[e.RowIndex];
CostumeRetailAnalysis order = (CostumeRetailAnalysis)row.DataBoundItem;
if (InboundDays.Index == e.ColumnIndex)
{
e.Value = order.InboundDays;
}
else if (UnmovedDays.Index == e.ColumnIndex)
{
e.Value = order.UnmovedDays;
}
}
private void ProductsDataGridView_CellFormatting(object sender, System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
if (e.ColumnIndex == DataGridView1.Columns(3).Index&& e.Value != null)
{
//
if (Convert.ToInt32(e.Value) < 10)
{
e.CellStyle.BackColor = Color.OrangeRed;
e.CellStyle.ForeColor = Color.LightGoldenrodYellow;
}
//
}
//
}
private void dtLista_CellFormatting(object sender,
System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
if (dtLista.Rows.Count > 0)
{
if (e.ColumnIndex > 11)
{
dtLista.Columns[e.ColumnIndex].Visible = false;
}
if (dtLista.Columns[e.ColumnIndex].Name.Equals("Compra") ||
dtLista.Columns[e.ColumnIndex].Name.Equals("Venta") ||
dtLista.Columns[e.ColumnIndex].Name.Equals("VentaConIVA"))
{
// dtLista.Columns["Compra"].Width = 110;
// dtLista.Columns["Venta"].Width = 110;
System.Windows.Forms.DataGridViewCellStyle dataCurrency = new System.Windows.Forms.DataGridViewCellStyle();
dataCurrency.Format = "C4";
dataCurrency.NullValue = "0.0";
dtLista.Columns["Compra"].DefaultCellStyle = dataCurrency;
dtLista.Columns["Venta"].DefaultCellStyle = dataCurrency;
dtLista.Columns["VentaConIVA"].DefaultCellStyle = dataCurrency;
}
// Set the background to red for negative values in the Balance column.
if (dtLista.Columns[e.ColumnIndex].Name.Equals("Stock"))
{
// dtLista.Columns[e.ColumnIndex].Width = 70;
if (Convert.ToInt32(e.Value) <= addProducto.getCantidadMinima())
{
e.CellStyle.BackColor = Color.DarkOrange;
e.CellStyle.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.75F, System.Drawing.FontStyle.Bold);
e.CellStyle.BackColor = Color.DarkOrange;
e.CellStyle.ForeColor = Color.Red;
}
}
//if (this.dtLista.Columns[e.ColumnIndex].Name.Equals("Codigo"))
//{
// dtLista.Columns[e.ColumnIndex].Width = -1;
//}
}
}
protected void grid_CellFormatting(object sender, System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
try
{
this.SuspendLayout();
if (e.RowIndex >= 0)
{
IBaseEntity rowToDraw = (IBaseEntity)((DataGridView)sender).Rows[e.RowIndex].DataBoundItem;
if (rowToDraw != null)
{
if (rowToDraw.deletedDate != null)
{
e.CellStyle.BackColor = Color.LightCoral;
}
Font oFont;
switch (rowToDraw.CurrentState)
{
case ObjectState.delete:
oFont = new Font(e.CellStyle.Font.Name, e.CellStyle.Font.Size, FontStyle.Strikeout);
e.CellStyle.Font = oFont;
break;
case ObjectState.edit:
e.CellStyle.BackColor = Color.Yellow;
break;
case ObjectState.insert:
e.CellStyle.BackColor = Color.LightGreen;
break;
default:
oFont = new Font(e.CellStyle.Font.Name, e.CellStyle.Font.Size, FontStyle.Regular);
e.CellStyle.Font = oFont;
break;
}
}
}
this.ResumeLayout();
}
catch (Exception ex)
{
Display.ShowError(ex.Message);
}
}
/// <summary>
/// Handles the CellFormatting event of the dgrdDisplayStaffInfo control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.Windows.Forms.DataGridViewCellFormattingEventArgs"/> instance containing the event data.</param>
private void dgrdDisplayStaffInfo_CellFormatting(object sender, System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
if (e == null || e.Value == null || !(sender is DataGridView))
{
return;
}
DataGridView view1 = (DataGridView)sender;
object originalValue1 = e.Value;
if (view1.Columns[e.ColumnIndex].DataPropertyName == "Married")
{
if (originalValue1.ToString() == "No" || originalValue1.ToString() == "False")
{
e.Value = "No";
}
else
{
e.Value = "Yes";
}
if (e == null || e.Value == null || !(sender is DataGridView))
{
return;
}
}
DataGridView view = (DataGridView)sender;
object originalValue = e.Value;
if (view.Columns[e.ColumnIndex].DataPropertyName == "Gender")
{
if (originalValue.ToString() == "0" || originalValue.ToString() == "Female")
{
e.Value = "Female";
}
else if (originalValue.ToString() == "1" || originalValue.ToString() == "Male")
{
e.Value = "Male";
}
else
{
e.Value = string.Empty;
}
}
}
private void dgvStoreList_CellFormatting(object sender, System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
if (dgvStoreList.Columns[e.ColumnIndex].Name.Equals("Status"))
{
if (e.Value != null & e.Value.ToString() == "0")
{
e.Value = "Closed";
}
else if (e.Value != null & e.Value.ToString() == "1")
{
e.Value = "Open";
}
else if (e.Value != null & e.Value.ToString() == "2")
{
e.Value = "Renovation";
}
}
}
private void dtLista_CellFormatting(object sender,
System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
try
{
if (dtLista.Columns[e.ColumnIndex].Name.Equals("Estado"))
{
if ((e.Value.ToString()).Contains("COTIZACION"))
{
e.CellStyle.BackColor = Color.OrangeRed;
}
}
}
catch (Exception ex)
{
Datos.Excepciones.Gestionar(ex);
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void dtLista_CellFormatting(object sender, System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
NProducto getProducto = new NProducto();
if (dtLista.Columns[e.ColumnIndex].Name.Equals("Stock"))
{
// dtLista.Columns[e.ColumnIndex].Width = 70;
if (Convert.ToInt32(e.Value) <= getProducto.getCantidadMinima())
{
e.CellStyle.Font = new System.Drawing.Font("Microsoft Sans Serif", 8F, System.Drawing.FontStyle.Bold);
e.CellStyle.BackColor = Color.DarkOrange;
e.CellStyle.ForeColor = Color.Red;
}
}
if (dtLista.Columns[e.ColumnIndex].Name.Equals("Marca"))
{
e.CellStyle.Font = new System.Drawing.Font("Microsoft Sans Serif", 7F, System.Drawing.FontStyle.Bold);
e.CellStyle.ForeColor = Color.Black;
}
}
private void dtgDSPhieuThue_CellFormatting(object sender, System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
if (dtgDSPhieuThue.Columns[e.ColumnIndex].Name.Equals("TinhTrang"))
{
int?tinhTrang = e.Value as int?;
// replace statement checks with your own conditions
if (tinhTrang == 0)
{
e.Value = "Đang thuê";
}
else if (tinhTrang == 1)
{
e.Value = "Đã trả phòng";
}
else
{
e.Value = "Đã thanh toán";
}
}
}
/// <summary>
/// 表格里面的单元格点击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void songsDataGridView_CellFormatting(object sender, System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
if (e != null)
{
if (this.songsDataGridView.Columns[e.ColumnIndex].Name == "Date")
{
if (e.Value != null)
{
try
{
e.Value = DateTime.Parse(e.Value.ToString()).ToLongDateString();
e.FormattingApplied = true;
}
catch (FormatException)
{
Console.WriteLine("{0} is not a valid date.", e.Value.ToString());
}
}
}
}
}
private void clientsDataGridView_CellFormatting(object sender,
System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
{
if (e != null)
{
/*if (this.clientsDataGridView.Columns[e.ColumnIndex].Name == "Release Date")
* {
* if (e.Value != null)
* {
* try
* {
* e.Value = DateTime.Parse(e.Value.ToString())
* .ToLongDateString();
* e.FormattingApplied = true;
* }
* catch (FormatException)
* {
* Console.WriteLine("{0} is not a valid date.", e.Value.ToString());
* }
* }
* }*/
}
}
public FormattingArgs(swf.DataGridViewCellFormattingEventArgs args, GridColumn column, object item, int row)
: base(column, item, row)
{
this.Args = args;
}
