// 状态列的数据显示文本
private void dvOCN_CLJBXX_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
if (e.Column.FieldName.Equals("OPERATION"))
{
switch (e.Value.ToString().Trim())
{
case "0":
e.DisplayText = "Excel导入";
break;
case "1":
e.DisplayText = "新增";
break;
case "2":
e.DisplayText = "复制新增";
break;
case "3":
e.DisplayText = "修改";
break;
case "4":
e.DisplayText = "删除";
break;
default:
e.DisplayText = "异常";
break;
}
}
}
/// <summary>
/// 设定列表显示信息
/// </summary>
private void gridViewWWHead_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
if (e.Column.FieldName == "WarehouseState")
{
e.DisplayText = CommonHandler.Get_WarehouseState_Desc(e.Value.ToString());
}
}
private void gvFolder_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
if (e.IsForGroupRow)
{
e.DisplayText = string.Format("{0} ({1})", e.DisplayText, CalcGroupCount(e.GroupRowHandle));
}
}
/// <summary>
/// 转换 票别
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridView1_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
if (e.Column.FieldName.ToUpper() == "SA020") //票别
{
if (e.Value.ToString() == "T")
{
e.DisplayText = "税票";
}
else if (e.Value.ToString() == "F")
{
e.DisplayText = "财政票";
}
}
else if (e.Column.FieldName.ToUpper() == "SA008")
{
if (e.Value.ToString() == "0")
{
e.DisplayText = "未结算";
}
else if (e.Value.ToString() == "1")
{
e.DisplayText = "已结算";
}
}
}
private void gvMain_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
ColumnView view = sender as ColumnView;
if (e.Column.FieldName == "KhoiId" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle)
{
Object khoiIdObj = view.GetListSourceRowCellValue(e.ListSourceRowIndex, "KhoiId");
if (!DBNull.Value.Equals(khoiIdObj))
{
int khoiId = (int)khoiIdObj;
e.DisplayText = StaticDataUtil.GetKhoiNameByKhoiId(khoiId);
}
}
else if (e.Column.FieldName == "KhoanThuId" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle)
{
Object khoanThuIdObj = view.GetListSourceRowCellValue(e.ListSourceRowIndex, "KhoanThuId");
if (!DBNull.Value.Equals(khoanThuIdObj))
{
int khoanThuId = (int)khoanThuIdObj;
e.DisplayText = StaticDataUtil.GetKhoanThuNameByKhoanThuId(khoanThuId);
}
}
}
/// <summary>
/// 对显示的字段内容进行转义
/// </summary>
void gridView2_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
string columnName = e.Column.FieldName;
if (e.Column.ColumnType == typeof(DateTime))
{
if (e.Value != null)
{
if (e.Value == DBNull.Value || Convert.ToDateTime(e.Value) <= Convert.ToDateTime("1900-1-1"))
{
e.DisplayText = "";
}
else
{
e.DisplayText = Convert.ToDateTime(e.Value).ToString("yyyy-MM-dd HH:mm");//yyyy-MM-dd
}
}
}
else if (columnName == "PRICE")
{
if (e.Value != null)
{
e.DisplayText = e.Value.ToString().ToDecimal().ToString("C");
}
}
else if (columnName == "AMOUNT")
{
if (e.Value != null)
{
e.DisplayText = e.Value.ToString().ToDecimal().ToString("C");
}
}
}
/// <summary>
/// 对显示的字段内容进行转义
/// </summary>
void gridView1_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
string columnName = e.Column.FieldName;
if (e.Column.ColumnType == typeof(DateTime))
{
if (e.Value != null)
{
if (e.Value == DBNull.Value || Convert.ToDateTime(e.Value) <= Convert.ToDateTime("1900-1-1"))
{
e.DisplayText = "";
}
else
{
e.DisplayText = Convert.ToDateTime(e.Value).ToString("yyyy-MM-dd HH:mm");//yyyy-MM-dd
}
}
}
else if (columnName == "WAREHOUSE")
{
if (e.Value != null)
{
e.DisplayText = BLLFactory <WareHouse> .Instance.FindById(e.Value).Name;
}
}
else if (columnName == "MANUFACTURE")
{
if (e.Value != null)
{
e.DisplayText = BLLFactory <Supplier> .Instance.FindById(e.Value).Name;
}
}
}
private void gvMain_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
ColumnView view = sender as ColumnView;
if (e.Column.FieldName == "GioiTinh" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle)
{
sbyte gioiTinh = (sbyte)view.GetListSourceRowCellValue(e.ListSourceRowIndex, "GioiTinh");
switch (gioiTinh)
{
case 0: e.DisplayText = "Nữ"; break;
case 1: e.DisplayText = "Nam"; break;
}
}
else if (e.Column.FieldName == "TinhThanhPhoId" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle)
{
object tinhId = view.GetListSourceRowCellValue(e.ListSourceRowIndex, "TinhThanhPhoId");
if (tinhId != DBNull.Value)
{
e.DisplayText = StaticDataUtil.GetThanhPhoById(StaticDataFacade.Get(StaticDataKeys.TinhThanhPho) as QLMamNon.Dao.QLMamNonDs.ThanhPhoDataTable, (int)tinhId);
}
}
else if (e.Column.FieldName == "QuanHuyenId" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle)
{
object quanHuyenId = view.GetListSourceRowCellValue(e.ListSourceRowIndex, "QuanHuyenId");
if (quanHuyenId != DBNull.Value)
{
e.DisplayText = StaticDataUtil.GetQuanHuyenById(StaticDataFacade.Get(StaticDataKeys.QuanHuyen) as QLMamNon.Dao.QLMamNonDs.QuanHuyenDataTable, (int)quanHuyenId);
}
}
else if (e.Column.FieldName == "PhuongXaId" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle)
{
object phuongXaId = view.GetListSourceRowCellValue(e.ListSourceRowIndex, "PhuongXaId");
if (phuongXaId != DBNull.Value)
{
e.DisplayText = StaticDataUtil.GetPhuongXaById(StaticDataFacade.Get(StaticDataKeys.PhuongXa) as QLMamNon.Dao.QLMamNonDs.PhuongXaDataTable, (int)phuongXaId);
}
}
else if (e.Column.FieldName == "NgaySinh" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle && e.Value != DBNull.Value)
{
DateTime ngaySinh = (DateTime)e.Value;
if (e.Column.Caption == "Ngay")
{
e.DisplayText = ngaySinh.Day.ToString();
}
else if (e.Column.Caption == "Thang")
{
e.DisplayText = ngaySinh.Month.ToString();
}
else if (e.Column.Caption == "Nam")
{
e.DisplayText = ngaySinh.Year.ToString();
}
}
else if (e.Column.Caption == this.GridViewColumnSequenceName && e.ListSourceRowIndex >= 0)
{
e.DisplayText = String.Format("{0}", e.ListSourceRowIndex + 1);
}
}
private void RowGridBandedView_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
if (e.Column.ColumnEdit is RepositoryItemPictureEdit) // avoid "No image data" text
{
e.DisplayText = "";
}
return;
}
private void grdGrid_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
//ColumnView view = sender as ColumnView;
//if (e.Column.Caption == "Fiyat" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle)
//{
// decimal price = Convert.ToDecimal(e.Value);
// e.DisplayText = string.Format(ciTL, "{0:c}", price);
//}
}
private void gridView1_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
if (e.Column.Name == "colProvincia")
{
AbstractMovimentoContabile app = gridView1.GetRow(e.RowHandle) as AbstractMovimentoContabile;
if (app != null)
{
if (app.Provincia == null)
{
e.DisplayText = "";
}
else
{
e.DisplayText = app.Provincia.Descrizione;
}
}
}
else if (e.Column.Name == "colRegione")
{
AbstractMovimentoContabile app = gridView1.GetRow(e.RowHandle) as AbstractMovimentoContabile;
if (app != null)
{
if (app.Regione == null)
{
e.DisplayText = "";
}
else
{
e.DisplayText = app.Regione.Descrizione;
}
}
}
else if (e.Column.Name == "colCausale")
{
AbstractMovimentoContabile app = gridView1.GetRow(e.RowHandle) as AbstractMovimentoContabile;
if (app != null)
{
if (app.Causale == null)
{
e.DisplayText = "";
}
else
{
e.DisplayText = app.Causale.Descrizione;
}
}
}
else if (e.Column.Name == "colImporto")
{
AbstractMovimentoContabile app = gridView1.GetRow(e.RowHandle) as AbstractMovimentoContabile;
if (app != null)
{
e.DisplayText = app.Importo.ToString("n");
}
}
}
private void AdvBandedGridViewCarRate_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
if (e.Column.FieldName == "START_DATE")
{
if (e.Value != null)
{
e.DisplayText = validCheck.convertDate(e.Value.ToString());
}
}
}
private void gridView1_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
if (e.Column.ColumnType == typeof(DateTime?))
{
DateTime?value = e.Value as DateTime?;
if (value == null || !value.HasValue)
{
e.DisplayText = Properties.Resources.None;
}
}
}
private void ClassifyDisText(DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e, int index)
{
language.InfoId infoId = language.InfoId.VTR_RESULT_CLASSIFY_OTHER;
int outIndex = -1;
dicVehicleTypeClassify.TryGetValue(index, out outIndex);
if (outIndex != -1)
{
e.DisplayText = Program.infoResource.GetLocalizedString(infoId + outIndex - 1);
}
}
private void afbGridView_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
GridView view = (GridView)sender;
if (e.Column == colOPID)
{
e.DisplayText = string.Format("{0:N0} {1}", e.Value, view.GetListSourceRowCellValue(e.ListSourceRowIndex, colOPHM));
}
//e.DisplayText = string.Format("{0:N0} {1}", e.Value, view.GetRowCellValue(e.RowHandle, colOPHM));
}
private void dvgBsDetails_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
if (e.Column.Caption == "SNo")
{
GridView gridView = (GridView)sender;
e.DisplayText = (gridView.GetRowHandle(e.ListSourceRowIndex) + 1).ToString();
if (Convert.ToInt32(e.DisplayText) < 0)
{
e.DisplayText = "";
}
}
}
private void UiVistaEdicion_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
ColumnView view = sender as ColumnView;
if ((e.Column.FieldName == "TOTAL_AMOUNT" || e.Column.FieldName == "PRICE_TO_CHANGE") &&
e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle)
{
decimal price = Convert.ToDecimal(e.Value);
string currencyType = (string)view.GetListSourceRowCellValue(e.ListSourceRowIndex, "CURRENCY");
e.DisplayText = currencyType + " " + price;
}
}
private void GVHD_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
ColumnView view = sender as ColumnView;
if (e.Column.FieldName == "NgayGDV2" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle)
{
if (view.GetListSourceRowCellValue(e.ListSourceRowIndex, "GiaHeThong2").ToString() == "0")
{
e.DisplayText = string.Empty;
}
}
}
private void gridView1_CustomColumnDisplayText(object sender,
DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
if (e.Column.FieldName == "LastPayDate" && !string.IsNullOrEmpty(e.DisplayText))
{
DateTime d = new DateTime(1970, 1, 1);
DateTime dt = DateTime.Parse(e.DisplayText);
if (DateTime.Compare(d, dt) >= 0)
{
e.DisplayText = string.Empty;
}
}
}
/// <summary>
/// 标志转换
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void GridView1_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
if (e.Column.FieldName == "SA008")
{
if (e.Value.ToString() == "1")
{
e.DisplayText = "已结算";
}
else
{
e.DisplayText = "未结算";
}
}
}
/// <summary>
/// 그리드 컬럼의 포맷을 처리한다.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void adView1_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
CPLH plh = new CPLH();
ColumnView view = sender as ColumnView;
if (e.Column.FieldName == CUtil.GetName(CPLH.enumPLH.dist) && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle)
{
double dist = Convert.ToDouble(e.Value);
e.DisplayText = string.Format("{0,4:#0.00}", dist);
}
}
private void GridView1_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
if (e.ListSourceRowIndex < 0)
{
return;
}
if (e.Column == this._colStagePathDir)
{
if (e.Value == null || e.Value.ToString( ) == this.dsCfg.DefaultStgDirVal)
{
e.DisplayText = "<DEFAULT>";
}
}
}
private void gvCredit_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
ColumnView view = sender as ColumnView;
if (e.Column.FieldName == "PaymentStatus" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle)
{
int status = (int)view.GetListSourceRowCellValue(e.ListSourceRowIndex, "PaymentStatus");
switch (status)
{
case 0: e.DisplayText = "Belum Lunas"; break;
case 1: e.DisplayText = "Lunas"; break;
}
}
}
private void GVGD_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
ColumnView view = sender as ColumnView;
if ("NgayBaoLuu SoTienBaoLuu".Contains(e.Column.FieldName))
{
if (e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle)
{
if (int.Parse((view.GetListSourceRowCellValue(e.ListSourceRowIndex, "SoTienBaoLuu") ?? 0).ToString()) == 0)
{
e.DisplayText = string.Empty;
}
}
}
}
private void gvMain_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
ColumnView view = sender as ColumnView;
if (e.Column.FieldName == "GioiTinh" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle)
{
sbyte gioiTinh = (sbyte)view.GetListSourceRowCellValue(e.ListSourceRowIndex, "GioiTinh");
switch (gioiTinh)
{
case 0: e.DisplayText = "Nữ"; break;
case 1: e.DisplayText = "Nam"; break;
}
}
}
private void gridView_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
if (e.Column.FieldName == m_ProgressField)
{
decimal RecQty = SysConvert.ToDecimal(m_GridView.GetRowCellValue(e.RowHandle, m_ProgressField));
decimal Qty = SysConvert.ToDecimal(m_GridView.GetRowCellValue(e.RowHandle, m_MaxinumField));
if (RecQty > 0)
{
e.DisplayText = string.Format("{0}/{1}", RecQty, Qty);
}
else
{
e.DisplayText = "";
}
}
}
void gridView1_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
if (e != null && e.Column.FieldName == "tpago")
{
e.DisplayText = ((Fundraising_PTDM.Enums.EPago)e.Value).ToString();
}
if (e != null && e.Column.FieldName == "ttarjeta")
{
e.DisplayText = ((Fundraising_PTDM.Enums.ETarjeta)e.Value).ToString();
//if (e.RowHandle >= 0)
//{
// if (this.grid_Base11.gridView1.GetRowCellValue(e.RowHandle, "tpago").ToString().Trim() == "2")
// {
// e.DisplayText = ((Fundraising_PTDM.Enums.ETarjeta)e.Value).ToString();
// }
// else
// {
// e.DisplayText = "Ninguno";
// }
//}
//else { e.DisplayText = ((Fundraising_PTDM.Enums.ETarjeta)e.Value).ToString(); }
}
if (e != null && e.Column.FieldName == "proveedor_ta.nombre")
{
if (e.Value != null)
{
//if (this.grid_Base11.gridView1.GetRowCellValue(e.RowHandle, "tpago").ToString().Trim() != "2" || this.grid_Base11.gridView1.GetRowCellValue(e.RowHandle, "ttarjeta").ToString().Trim() != "2")
//{
// if (this.grid_Base11.gridView1.GetRowCellValue(e.RowHandle, "tpago").ToString().Trim() != "7")
// {
// e.DisplayText = "Ninguno";
// }
//}
}
else
{
e.DisplayText = "Ninguno";
}
}
if (e != null && e.Column.FieldName == "status")
{
e.DisplayText = ((Fundraising_PTDM.Enums.EStatus)e.Value).ToString();
}
}
private void gvPurchasing_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
ColumnView view = sender as ColumnView;
if (e.Column.FieldName == "Status" && e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle)
{
int status = (int)view.GetListSourceRowCellValue(e.ListSourceRowIndex, "Status");
switch (status)
{
case 0: e.DisplayText = "Menunggu Persetujuan"; break;
case 1: e.DisplayText = "Disetujui"; break;
case 2: e.DisplayText = "Ada Retur"; break;
}
}
}
private void bandedGridView1_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
ColumnView view = sender as ColumnView;
switch (e.Column.FieldName)
{
case "NgayGDV2":
if (e.ListSourceRowIndex != DevExpress.XtraGrid.GridControl.InvalidRowHandle)
{
if ((view.GetListSourceRowCellValue(e.ListSourceRowIndex, "MaCho2") ?? string.Empty).ToString().Length == 0)
{
e.DisplayText = string.Empty;
}
}
break;
}
}
private void gridView2_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
{
if (e.Column.FieldName == "START_DATE")
{
if (e.Value != null)
{
if (!string.IsNullOrWhiteSpace(e.Value.ToString()))
{
e.DisplayText = validCheck.convertDate(e.Value.ToString());
}
}
}
if (e.Column.FieldName == "END_DATE")
{
if (e.Value != null)
{
if (!string.IsNullOrWhiteSpace(e.Value.ToString()))
{
e.DisplayText = validCheck.convertDate(e.Value.ToString());
}
}
}
if (e.Column.FieldName == "ResDate_Start")
{
if (e.Value != null)
{
if (!string.IsNullOrWhiteSpace(e.Value.ToString()))
{
e.DisplayText = validCheck.convertDate(e.Value.ToString());
}
}
}
if (e.Column.FieldName == "ResDate_End")
{
if (e.Value != null)
{
if (!string.IsNullOrWhiteSpace(e.Value.ToString()))
{
e.DisplayText = validCheck.convertDate(e.Value.ToString());
}
}
}
}
