private void ActivityGridCellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (e.RowIndex < 0 || e.ColumnIndex < 0)
return;
e.Value = string.Empty;
e.FormattingApplied = true;
}
private void cellformatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if(grid.Columns[e.ColumnIndex].Name == "lane_id")
{
rvalue = Convert.ToInt32(e.Value);
//e.CellStyle.BackColor = Color.Red;
}
if(rvalue < 10)
{
this.grid.Rows[rvalue].DefaultCellStyle.BackColor = Color.Red;
}
else if(rvalue < 20)
{
this.grid.Rows[rvalue].DefaultCellStyle.BackColor = Color.Green;
}
else
{
this.grid.Rows[rvalue].DefaultCellStyle.BackColor = Color.Yellow;
}
}
/// <summary>
/// Metodo que cambia el formato de las celdas del grid de detalles de la venta.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// Usuario Creo: Juan Alberto Hernández Negrete.
/// Fecha Creo: 27 Noviembre 2013 18:31 Hrs.
/// Usuario Modifico:
/// Fecha Modifico:
private void Grid_Resultado_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
e.CellStyle.Font = new System.Drawing.Font("Consolas Black", 8F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
}
private void dgHistoryWaterFee_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (e.RowIndex < 0 || e.ColumnIndex < 0)
{
return;
}
if (dgHistoryWaterFee.Columns[e.ColumnIndex].Name == "INVOICECANCEL")
{
object objInvoiceCancel = e.Value;
if (objInvoiceCancel != null && objInvoiceCancel != DBNull.Value)
{
if (objInvoiceCancel.ToString() == "0")
{
e.Value = "正常";//如果有正常状态的发票就不能打印第二次 只能先作废再打印
}
else if (objInvoiceCancel.ToString() == "1")
{
e.Value = "冲减作废";
}
else if (objInvoiceCancel.ToString() == "2")
{
e.Value = "损坏作废";
}
else if (objInvoiceCancel.ToString() == "3")
{
e.Value = "未打作废";
}
}
else
{
e.Value = "未打发票";
}
}
if (dgHistoryWaterFee.Columns[e.ColumnIndex].Name == "CHARGETYPEID")
{
object objChargeType = e.Value;
if (objChargeType != null && objChargeType != DBNull.Value)
{
if (objChargeType.ToString() == "1")
{
e.Value = "现金";//如果有正常状态的发票就不能打印第二次 只能先作废再打印
}
else if (objChargeType.ToString() == "1")
{
e.Value = "作废";
}
}
}
if (dgHistoryWaterFee.Columns[e.ColumnIndex].Name == "chargeState")
{
object objChargeType = e.Value;
if (objChargeType != null && objChargeType != DBNull.Value)
{
if (objChargeType.ToString() == "3")
{
e.Value = "已收费";//如果有正常状态的发票就不能打印第二次 只能先作废再打印
}
else if (objChargeType.ToString() == "2")
{
e.Value = "挂账";
}
else if (objChargeType.ToString() == "1")
{
e.Value = "未收费";
}
}
}
}
private void dtDados_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
dtDados.Columns["Descricao"].Width = 350;
}
//表格内容格式化，设定正负向，类别，区域
private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (e.RowIndex != dataGridView1.NewRowIndex)
{
switch (dataGridView1.Columns[e.ColumnIndex].Name.ToLower())
{
case "focuslevel":
string txtFocus = dataGridView1.Rows[e.RowIndex].Cells["focuslevel"].Value.ToString();
switch (txtFocus)
{
case "1":
e.Value = "置顶";
e.CellStyle.ForeColor = Color.Blue;
break;
case "2":
e.Value = "重点关注";
e.CellStyle.ForeColor = Color.Red;
break;
case "3":
e.Value = "关注";
e.CellStyle.ForeColor = Color.Green;
break;
case "99":
e.Value = "";
e.CellStyle.ForeColor = Color.Green;
break;
}
e.CellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
break;
case "title_link":
//设定正负向
string title = dataGridView1.Rows[e.RowIndex].Cells["title"].Value.ToString();
e.Value = title;
break;
case "part_img":
//设定正负向
string part = dataGridView1.Rows[e.RowIndex].Cells["part"].Value.ToString();
string url = Application.StartupPath.ToString();
if (part.Equals("1"))
{
url += "\\icons\\u.png";
}
else
{
url += "\\icons\\d.png";
}
e.Value = File.ReadAllBytes(url);
break;
case "kid":
switch (dataGridView1.Rows[e.RowIndex].Cells["kid"].Value.ToString())
{
case "0":
e.Value = "常规舆情";
break;
case "1":
e.Value = "敏感舆情";
break;
case "2":
e.Value = "重点舆情";
break;
case "3":
e.Value = "突发舆情";
break;
}
break;
case "pid":
switch (dataGridView1.Rows[e.RowIndex].Cells["pid"].Value.ToString())
{
case "0":
e.Value = "全网";
break;
case "1":
e.Value = "博客";
break;
case "2":
e.Value = "论坛";
break;
case "3":
e.Value = "微博";
break;
case "4":
e.Value = "主流媒体";
break;
case "5":
e.Value = "贴吧";
break;
case "6":
e.Value = "微信";
break;
case "7":
e.Value = "定制";
break;
}
break;
case "sheng":
e.Value = dataGridView1.Rows[e.RowIndex].Cells["sheng"].Value.ToString() + dataGridView1.Rows[e.RowIndex].Cells["shi"].Value.ToString() + dataGridView1.Rows[e.RowIndex].Cells["xian"].Value.ToString();
break;
}
}
}
private void uclstGrdItem_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
//uclstGrdItem.Rows[e.RowIndex].DefaultCellStyle.SelectionBackColor = Color.Yellow;
//uclstGrdItem.Rows[e.RowIndex].DefaultCellStyle.SelectionForeColor = Color.Black;
//uclstGrdItem.Rows[e.RowIndex].DefaultCellStyle.Font = new Font("verdana", 9);
}
private void colourGridView_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
//log.Debug("CellFormatting");
}
private void dtvAgendamento_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
}
private void dgvDSNV_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (dgvDSNV.Columns[e.ColumnIndex].Name == "colAnhNhanVien")
{
try
{
e.Value = new Bitmap(e.Value.ToString());
}
catch
{
}
}
if (dgvDSNV.Columns[e.ColumnIndex].Name == "colNgayVaoLam")
{
if (DateTime.Parse(e.Value.ToString()).ToShortDateString() != "01/01/0001")
{
e.Value = DateTime.Parse(e.Value.ToString()).ToShortDateString();
}
}
if (dgvDSNV.Columns[e.ColumnIndex].Name == "colNgayThoiViec")
{
if (e.Value != null)
{
e.Value = DateTime.Parse(e.Value.ToString()).ToShortDateString();
}
}
if (dgvDSNV.Columns[e.ColumnIndex].Name == "colGioiTinh")
{
if (Convert.ToBoolean(e.Value) == true)
{
e.Value = "Nam";
}
else
{
e.Value = "Nữ";
}
}
if (dgvDSNV.Columns[e.ColumnIndex].Name == "colChucVu")
{
ChucVu_BUS bus = new ChucVu_BUS();
List <clsChucVu_DTO> lstChucVu = bus.LayDanhSachChucVu();
clsChucVu_DTO dtoChucVu = lstChucVu.First(u => u.MaChucVu == e.Value.ToString());
e.Value = dtoChucVu.TenChucVu;
}
if (dgvDSNV.Columns[e.ColumnIndex].Name == "colTrangThai")
{
TrangThaiNV_BUS bus = new TrangThaiNV_BUS();
List <clsTrangThaiNV_DTO> lstTrangThaiNV = bus.LayDanhSachTrangThaiNhanVien();
clsTrangThaiNV_DTO dtoTrangThaiNV = lstTrangThaiNV.First(u => u.MaTrangThaiNV == Convert.ToInt32(e.Value.ToString()));
e.Value = dtoTrangThaiNV.TenTrangThaiNV;
}
foreach (DataGridViewRow r in dgvDSNV.Rows)
{
if (Convert.ToInt32(r.Cells["colTrangThai"].Value) == 2) // Đã nghỉ việc
{
r.DefaultCellStyle.ForeColor = Color.Gray;
}
else if (Convert.ToInt32(r.Cells["colTrangThai"].Value) == 3) // Đang chờ vào làm
{
r.DefaultCellStyle.ForeColor = Color.Blue;
}
else
{
r.DefaultCellStyle.ForeColor = Color.Black;
}
}
}
private void dgvMemoria_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
//int vermelho = (int)(255 * ((double)dgvMemoria.Rows[e.RowIndex].Cells[e.ColumnIndex].Value - min) / (max - min));
//e.CellStyle.BackColor = Color.FromArgb(vermelho, 0, 255 - vermelho);
}
private void DGV_Brief_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
e.CellStyle.SelectionBackColor = Color.FromArgb(220, 217, 217);
e.CellStyle.SelectionForeColor = Color.Black;
}
private void ly_sales_contract_detailDataGridView_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
DataGridView dgv = sender as DataGridView;
if (e.RowIndex > -1)
{
if ((dgv.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.GetType() == typeof(decimal) ||
dgv.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.GetType() == typeof(double) ||
dgv.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.GetType() == typeof(int)))
{
if (Convert.ToDecimal(dgv.Rows[e.RowIndex].Cells[e.ColumnIndex].Value) == 0)
{
e.Value = "";
}
}
}
}
private void DG_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
DG.Rows[e.RowIndex].DefaultCellStyle.SelectionBackColor = Color.Bisque;
DG.Rows[e.RowIndex].DefaultCellStyle.SelectionForeColor = Color.Black;
DG.Rows[e.RowIndex].DefaultCellStyle.Font = new Font("verdana", 9);
}
private void grdArtigos_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
}
private void OnCellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (e.RowIndex < 0)
{
return;
}
DataGridView grd = sender as DataGridView;
int RowIndex = e.RowIndex;
try
{
if (RowIndex % 2 == 0)
{
grd.Rows[RowIndex].DefaultCellStyle.BackColor = Color.LightBlue; // ColorFromHex("f0f4c3");
}
else
{
grd.Rows[RowIndex].DefaultCellStyle.BackColor = Color.LightSteelBlue; // ColorFromHex("050505");
}
if (grd.Rows[RowIndex].Cells[13].Value != null)
{
int days2ship = 0;
if (int.TryParse(grd.Rows[RowIndex].Cells[13].Value.ToString(), out days2ship) == true)
{
if (days2ship <= -20) // Warning: Delayed past 10 days
{
grd.Rows[RowIndex].DefaultCellStyle.BackColor = Color.Red;
grd.Rows[RowIndex].DefaultCellStyle.ForeColor = Color.White;
}
else if (days2ship > -20 && days2ship < -8) // Less than one week
{
grd.Rows[RowIndex].DefaultCellStyle.BackColor = Color.Yellow;
grd.Rows[RowIndex].DefaultCellStyle.ForeColor = Color.Black;
}
}
}
//if (grd.Rows[RowIndex].Cells[13].Value.ToString().ToUpper().Contains("CORR") == true) // Black Corrupt
//{
// grd.Rows[RowIndex].DefaultCellStyle.BackColor = Color.Black;
// grd.Rows[RowIndex].DefaultCellStyle.ForeColor = Color.White;
//}
//else if (grd.Rows[RowIndex].Cells[13].Value.ToString().ToUpper().Contains("FAIL") == true && // Red = Good packet, but bad CRC
// (grd.Rows[RowIndex].Cells[8].Value.ToString().ToUpper().Contains("READREQ") == true || grd.Rows[RowIndex].Cells[8].Value.ToString().ToUpper().Contains("READRESP") == true ||
// grd.Rows[RowIndex].Cells[8].Value.ToString().ToUpper().Contains("WRITEREQ") == true || grd.Rows[RowIndex].Cells[8].Value.ToString().ToUpper().Contains("WRITERESP") == true ||
// grd.Rows[RowIndex].Cells[8].Value.ToString().ToUpper().Contains("PINGREQ") == true || grd.Rows[RowIndex].Cells[8].Value.ToString().ToUpper().Contains("PINGRESP") == true))
//{
// grd.Rows[RowIndex].DefaultCellStyle.BackColor = Color.Red;
// grd.Rows[RowIndex].DefaultCellStyle.ForeColor = Color.White;
//}
//else if (grd.Rows[RowIndex].Cells[8].Value.ToString().ToUpper().Contains("READREQ") == true)
//{
// grd.Rows[RowIndex].DefaultCellStyle.BackColor = ColorFromHex("d4e157");
//}
//else if (grd.Rows[RowIndex].Cells[8].Value.ToString().ToUpper().Contains("READRESP") == true)
//{
// grd.Rows[RowIndex].DefaultCellStyle.BackColor = ColorFromHex("f0f4c3");
//}
//else if (grd.Rows[RowIndex].Cells[8].Value.ToString().ToUpper().Contains("WRITE") == true)
//{
// if (grd.Rows[RowIndex].Cells[8].Value.ToString().ToUpper().Contains("REQ") == true)
// {
// grd.Rows[RowIndex].DefaultCellStyle.BackColor = ColorFromHex("e3f2fd");
// }
// else if (grd.Rows[RowIndex].Cells[8].Value.ToString().ToUpper().Contains("RESP") == true)
// {
// grd.Rows[RowIndex].DefaultCellStyle.BackColor = ColorFromHex("7986cb");
// }
//}
//else if (grd.Rows[RowIndex].Cells[8].Value.ToString().ToUpper().Contains("PING") == true)
//{
// if (grd.Rows[RowIndex].Cells[8].Value.ToString().ToUpper().Contains("REQ") == true)
// {
// grd.Rows[RowIndex].DefaultCellStyle.BackColor = ColorFromHex("ffff8d");
// }
// else if (grd.Rows[RowIndex].Cells[8].Value.ToString().ToUpper().Contains("RESP") == true)
// {
// grd.Rows[RowIndex].DefaultCellStyle.BackColor = ColorFromHex("ffff00");
// }
//}
//else
//{
// grd.Rows[RowIndex].DefaultCellStyle.BackColor = Color.Black;
// grd.Rows[RowIndex].DefaultCellStyle.ForeColor = Color.White;
//}
}
catch (Exception etry)
{
}
}
private void dgvCells_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (dgvCells.DataSource == null)
{
return;
}
if (dgvCells.IsStatusRow(e.RowIndex))
{
e.CellStyle.BackColor = Color.Silver;
e.CellStyle.Font = new Font(e.CellStyle.Font, FontStyle.Bold);
if (dgvCells.Columns[e.ColumnIndex].Name.Contains("Image"))
{
e.Value = Properties.Resources.Empty;
}
return;
}
DataGridViewRow r = dgvCells.Rows[e.RowIndex];
switch (dgvCells.Columns[e.ColumnIndex].Name)
{
case "grcCellStateImage":
if ((bool)r.Cells["grcHasCellContent"].Value)
{
e.Value = Properties.Resources.Box_full;
}
else
{
e.Value = Properties.Resources.Empty;
}
break;
case "grcLockedImage":
if ((bool)r.Cells["grcLocked"].Value)
{
e.Value = Properties.Resources.Lock1;
}
else
{
e.Value = Properties.Resources.Empty;
}
break;
case "grcForFrames":
if (r.Cells["grcIsForFrames"].Value == DBNull.Value)
{
e.CellStyle.BackColor =
e.CellStyle.ForeColor =
Color.Silver;
}
break;
case "grcIsRankChanged":
DataRow rd = ((DataRowView)dgvCells.Rows[e.RowIndex].DataBoundItem).Row;
if (rd != null && Convert.ToInt32(rd["Rank"]) != Convert.ToInt32(rd["PreRank"]))
{
e.Value = Properties.Resources.Edit;
}
else
{
e.Value = Properties.Resources.Empty;
}
break;
}
// неактуальные - курсивом вся строка
if (!Convert.ToBoolean(r.Cells["grcActual"].Value))
{
e.CellStyle.Font = new Font(e.CellStyle.Font, FontStyle.Italic);
}
}
private void gvPurchasePlanList_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
}
private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
// dataGridView1.Rows[e.RowIndex].HeaderCell.Value = e.RowIndex + 1.ToString();
}
private void DgvListaPreturi_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
e.CellStyle.BackColor = Color.White;
e.CellStyle.ForeColor = Color.Black;
}
private void dgvCliente_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) => (sender as DataGridView).DefaultCellStyle.Format = "C2";
private void DGrid_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
DGrid.Rows[e.RowIndex].Cells["dgRadif"].Value = e.RowIndex + 1;
}
private void DataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
e.CellStyle.BackColor = Color.FromArgb(28, 30, 32);
}
private void grdSucursal_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
}
private void dgvResult_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
SetRound(e);
SetWinner(e);
}
void DgReportSheet_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (e.RowIndex == -1 || e.ColumnIndex == -1)
{
return;
}
if (e.ColumnIndex < startColumnIndex || e.ColumnIndex > endColumnIndex)
{
DataGridViewCell cell = dgReportSheet.Rows[e.RowIndex].Cells["Relation"];
string relation = (string)cell.Value;
if (relation == "Direct Ancestor")
{
e.CellStyle.Font = boldFont;
}
}
else
{
DataGridViewCellStyle style = dgReportSheet.DefaultCellStyle;
DataGridViewCell cell = dgReportSheet.Rows[e.RowIndex].Cells[e.ColumnIndex];
int value = (int)cell.Value;
styles.TryGetValue(value, out style);
if (style != null)
{
e.CellStyle.BackColor = style.BackColor;
e.CellStyle.ForeColor = style.ForeColor;
e.CellStyle.SelectionForeColor = e.CellStyle.SelectionBackColor;
cell.InheritedStyle.BackColor = style.BackColor;
cell.InheritedStyle.ForeColor = style.ForeColor;
cell.InheritedStyle.SelectionForeColor = cell.InheritedStyle.SelectionBackColor;
switch (value)
{
case 0:
cell.ToolTipText = "Not alive at time of census.";
break;
case 1:
if (e.ColumnIndex == C1939.Index)
{
if (cbCensusSearchProvider.SelectedItem.Equals("Find My Past"))
{
cell.ToolTipText = $"No census information entered. Double click to search {cbCensusSearchProvider.SelectedItem}.";
}
else
{
cell.ToolTipText = $"No census information entered. No search on {cbCensusSearchProvider.SelectedItem} available.";
}
}
else
{
cell.ToolTipText = $"No census information entered. Double click to search {cbCensusSearchProvider.SelectedItem}.";
}
break;
case 2:
cell.ToolTipText = "Census entered but no Lost Cousins flag set.";
break;
case 3:
cell.ToolTipText = "Census entered and not a Lost Cousins year.";
break;
case 4:
cell.ToolTipText = "Census entered and flagged as entered on Lost Cousins.";
break;
case 5:
cell.ToolTipText = "Lost Cousins flagged but no Census entered.";
break;
case 6:
cell.ToolTipText = $"On Census outside {_country}";
break;
case 7:
cell.ToolTipText = $"Likely outside {_country} on census date";
break;
case 8:
cell.ToolTipText = "Known to be missing from the census";
break;
}
}
}
}
private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
DataGridViewRow CurrentRow = dataGridView1.Rows[e.RowIndex];
CurrentRow.HeaderCell.Value = (e.RowIndex + 1).ToString();
}
private void dgvMarks_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
}
private void DataGridView_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (e.Value == null)
{
return;
}
else if (String.IsNullOrWhiteSpace(e.Value.ToString()))
{
return;
}
if (e.ColumnIndex == this.dataGridView.Columns["cpuColumn"].Index)
{
DataGridViewCell cell = this.dataGridView.Rows[e.RowIndex].Cells[e.ColumnIndex];
String info = "";
MySqlCommand cmd = new MySqlCommand(String.Format(
"SELECT * FROM cpus WHERE id={0}", cell.Value), conn);
using (MySqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
info += dr.GetValue(1).ToString().Trim() + " "
+ dr.GetValue(2).ToString().Trim() + " " + dr.GetValue(3).ToString().Trim();
}
}
cell.ToolTipText = info;
}
else if (e.ColumnIndex == this.dataGridView.Columns["memoryColumn"].Index)
{
DataGridViewCell cell = this.dataGridView.Rows[e.RowIndex].Cells[e.ColumnIndex];
String info = "";
MySqlCommand cmd = new MySqlCommand(String.Format(
"SELECT * FROM memory WHERE id={0}", cell.Value), conn);
using (MySqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
info += dr.GetValue(1).ToString().Trim() + " "
+ dr.GetValue(2).ToString().Trim() + " ";
if (!String.IsNullOrWhiteSpace(dr.GetValue(3).ToString()))
{
info += dr.GetValue(3).ToString().Trim() + "GHz ";
}
if (!String.IsNullOrWhiteSpace(dr.GetValue(4).ToString()))
{
info += dr.GetValue(4).ToString().Trim() + "Gb";
}
}
}
cell.ToolTipText = info;
}
else if (e.ColumnIndex == this.dataGridView.Columns["motherboardColumn"].Index)
{
DataGridViewCell cell = this.dataGridView.Rows[e.RowIndex].Cells[e.ColumnIndex];
String info = "";
MySqlCommand cmd = new MySqlCommand(String.Format(
"SELECT * FROM motherboards WHERE id={0}", cell.Value), conn);
using (MySqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
info += dr.GetValue(1).ToString().Trim() + " "
+ dr.GetValue(2).ToString().Trim() + " " + dr.GetValue(3).ToString().Trim()
+ " " + dr.GetValue(4).ToString().Trim();
}
}
cell.ToolTipText = info;
}
else if (e.ColumnIndex == this.dataGridView.Columns["graphicsCardColumn"].Index)
{
DataGridViewCell cell = this.dataGridView.Rows[e.RowIndex].Cells[e.ColumnIndex];
String info = "";
MySqlCommand cmd = new MySqlCommand(String.Format(
"SELECT * FROM graphics_cards WHERE id={0}", cell.Value), conn);
using (MySqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
info += dr.GetValue(1).ToString().Trim() + " "
+ dr.GetValue(2).ToString().Trim() + " ";
if (!String.IsNullOrWhiteSpace(dr.GetValue(3).ToString()))
{
info += dr.GetValue(3).ToString().Trim() + "Gb";
}
}
}
cell.ToolTipText = info;
}
else if (e.ColumnIndex == this.dataGridView.Columns["hardDriveColumn"].Index)
{
DataGridViewCell cell = this.dataGridView.Rows[e.RowIndex].Cells[e.ColumnIndex];
String info = "";
MySqlCommand cmd = new MySqlCommand(String.Format(
"SELECT * FROM internal_hard_drives WHERE id={0}", cell.Value), conn);
using (MySqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
info += dr.GetValue(1).ToString().Trim() + " "
+ dr.GetValue(2).ToString().Trim();
if (!String.IsNullOrWhiteSpace(dr.GetValue(3).ToString()))
{
info += " " + dr.GetValue(3).ToString().Trim() + "Gb";
}
}
}
cell.ToolTipText = info;
}
else if (e.ColumnIndex == this.dataGridView.Columns["keyboardColumn"].Index)
{
DataGridViewCell cell = this.dataGridView.Rows[e.RowIndex].Cells[e.ColumnIndex];
String info = "";
MySqlCommand cmd = new MySqlCommand(String.Format(
"SELECT * FROM keyboards WHERE id={0}", cell.Value), conn);
using (MySqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
info += dr.GetValue(1).ToString().Trim() + " "
+ dr.GetValue(2).ToString().Trim();
}
}
cell.ToolTipText = info;
}
else if (e.ColumnIndex == this.dataGridView.Columns["monitorColumn"].Index)
{
DataGridViewCell cell = this.dataGridView.Rows[e.RowIndex].Cells[e.ColumnIndex];
String info = "";
MySqlCommand cmd = new MySqlCommand(String.Format(
"SELECT * FROM monitors WHERE id={0}", cell.Value), conn);
using (MySqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
info += dr.GetValue(1).ToString().Trim() + " "
+ dr.GetValue(2).ToString().Trim() + " " + dr.GetValue(3).ToString().Trim() + "\"";
}
}
cell.ToolTipText = info;
}
else if (e.ColumnIndex == this.dataGridView.Columns["mouseColumn"].Index)
{
DataGridViewCell cell = this.dataGridView.Rows[e.RowIndex].Cells[e.ColumnIndex];
String info = "";
MySqlCommand cmd = new MySqlCommand(String.Format(
"SELECT * FROM mouses WHERE id={0}", cell.Value), conn);
using (MySqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
info += dr.GetValue(1).ToString().Trim() + " "
+ dr.GetValue(2).ToString().Trim();
}
}
cell.ToolTipText = info;
}
}
private void dgUsuarios_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
dgUsuarios.Rows[e.RowIndex].Cells["editar"].ToolTipText = "Clique aqui para editar";
}
// Gets image from url
private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
LoadImages(e);
}
// Changes the foreground color of cells in the "Ratings" column
// depending on the number of stars.
private void dataGridView1_CellFormatting(object sender,
DataGridViewCellFormattingEventArgs e)
{
if (e.ColumnIndex == dataGridView1.Columns["Rating"].Index
&& e.Value != null)
{
switch (e.Value.ToString().Length)
{
case 1:
e.CellStyle.SelectionForeColor = Color.Red;
e.CellStyle.ForeColor = Color.Red;
break;
case 2:
e.CellStyle.SelectionForeColor = Color.Yellow;
e.CellStyle.ForeColor = Color.Yellow;
break;
case 3:
e.CellStyle.SelectionForeColor = Color.Green;
e.CellStyle.ForeColor = Color.Green;
break;
case 4:
e.CellStyle.SelectionForeColor = Color.Blue;
e.CellStyle.ForeColor = Color.Blue;
break;
}
}
}
private void DataGridViewIsi_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
}