protected void ASPxGridViewExporter1_RenderBrick(object sender, ASPxGridViewExportRenderingEventArgs e)
{
StringFormat sFormat = new StringFormat(StringFormatFlags.NoWrap);
BrickStringFormat brickSFormat = new BrickStringFormat(sFormat);
e.XlsxFormatString = sFormat.ToString();
}
public static void ExporterRenderBrick(object sender, ASPxGridViewExportRenderingEventArgs e)
{
if (e.RowType == GridViewRowType.Header)
{
e.Text = e.Text.Replace("<br />", " ");
e.Text = e.Text.Replace("<br/>", " ");
}
}
protected void GridExporter_RenderBrick(object sender, ASPxGridViewExportRenderingEventArgs e)
{
var dataColumn = e.Column as GridViewDataColumn;
if (dataColumn != null && dataColumn.FieldName == "ImagePath" && e.RowType == GridViewRowType.Data)
{
e.ImageValue = GetImageBinaryData(e.Value.ToString());
}
}
protected void GV_PART_ExportRenderBrick(object sender, ASPxGridViewExportRenderingEventArgs e)
{
if (e.RowType == GridViewRowType.Data)
{
if (e.Column.Caption == "材料颜色" || e.Column.Caption == "产品结构")
{
if (e.Value != DBNull.Value)
{
e.TextValue = Convert.ToString(e.Value).Replace("<br />", "\r\n");
}
}
}
}
/// <summary>
/// 导出数据时重新设置文本值。
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void exporter_RenderBrick(object sender, ASPxGridViewExportRenderingEventArgs e)
{
//DataTable dt = this.gridExport.DataSource as DataTable;
//if (dt != null
// && e.RowType == DevExpress.Web.GridViewRowType.Data
// && e.Column != null && e.Column.Index > 1
// && e.Column.Index < dt.Columns.Count - 1)
//{
// string trxType = Convert.ToString(dt.Rows[e.VisibleIndex][1]);
// if (trxType.EndsWith("RATE"))
// {
// e.TextValueFormatString = "#0.00%";
// }
//}
}
/// <summary>
/// 导出数据时重新设置文本值。
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void exporter_RenderBrick(object sender, ASPxGridViewExportRenderingEventArgs e)
{
DataTable dt = this.gridExport.DataSource as DataTable;
if (dt != null &&
e.RowType == DevExpress.Web.GridViewRowType.Data &&
e.Column != null &&
e.Column.Index > 2 &&
e.Column.Index < dt.Columns.Count - 1)
{
string trxType = Convert.ToString(dt.Rows[e.VisibleIndex]["COL_VALUE"]);
if (trxType.EndsWith("RATE"))
{
e.TextValueFormatString = "#0.00%";
}
}
}
protected void ASPxGridViewExporter1_RenderBrick(object sender, ASPxGridViewExportRenderingEventArgs e)
{
#region Styles
if (ASPxRadioButtonList2.Value.ToString() == "r")
{
if (e.RowType == DevExpress.Web.ASPxGridView.GridViewRowType.Title)
{
e.BrickStyle.BackColor = System.Drawing.Color.DarkRed;
e.BrickStyle.ForeColor = System.Drawing.Color.MistyRose;
}
if (e.RowType == DevExpress.Web.ASPxGridView.GridViewRowType.Data)
{
e.BrickStyle.BackColor = System.Drawing.Color.MistyRose;
e.BrickStyle.ForeColor = System.Drawing.Color.Black;
}
}
if (ASPxRadioButtonList2.Value.ToString() == "b")
{
if (e.RowType == DevExpress.Web.ASPxGridView.GridViewRowType.Title)
{
e.BrickStyle.BackColor = System.Drawing.Color.DarkBlue;
e.BrickStyle.ForeColor = System.Drawing.Color.SteelBlue;
}
if (e.RowType == DevExpress.Web.ASPxGridView.GridViewRowType.Data)
{
e.BrickStyle.BackColor = System.Drawing.Color.SteelBlue;
e.BrickStyle.ForeColor = System.Drawing.Color.White;
}
}
if (ASPxRadioButtonList2.Value.ToString() == "g")
{
if (e.RowType == DevExpress.Web.ASPxGridView.GridViewRowType.Title)
{
e.BrickStyle.BackColor = System.Drawing.Color.DarkGreen;
e.BrickStyle.ForeColor = System.Drawing.Color.PaleGreen;
}
if (e.RowType == DevExpress.Web.ASPxGridView.GridViewRowType.Data)
{
e.BrickStyle.BackColor = System.Drawing.Color.PaleGreen;
e.BrickStyle.ForeColor = System.Drawing.Color.Black;
}
}
#endregion
}
protected void gridExporter_RenderBrick(object sender, ASPxGridViewExportRenderingEventArgs e)
{
if (e.RowType != GridViewRowType.Data)
{
return;
}
if ((e.Column as GridViewDataColumn).FieldName == "UnitPrice" && e.RowType != GridViewRowType.Header)
{
if (Convert.ToInt32(e.TextValue) > 15)
{
e.BrickStyle.BackColor = Color.Yellow;
}
else
{
e.BrickStyle.BackColor = Color.Green;
}
}
}
protected void ASPxGridViewExporter1_RenderBrick(object sender, ASPxGridViewExportRenderingEventArgs e)
{
if (e.RowType == DevExpress.Web.ASPxGridView.GridViewRowType.Data && e.Column != null)
{
GridViewDataColumn dataColumn = e.Column as GridViewDataColumn;
if (dataColumn.FieldName.ToUpper() == "HORA")
{
DateTime dt1 = Convert.ToDateTime(e.Value.ToString());
e.Text = string.Format("{0:HH:mm}", dt1);
}
if (dataColumn.FieldName.ToUpper() == "FECHA")
{
DateTime dt = Convert.ToDateTime(e.Value.ToString());
e.Text = string.Format("{0:dd/MM/yyyy}", dt);
}
}
}
/// <summary>
/// 导出数据时重新设置文本值。
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void exporter_RenderBrick(object sender, ASPxGridViewExportRenderingEventArgs e)
{
}
protected void ASPxGridViewExporter1_RenderBrick(object sender, ASPxGridViewExportRenderingEventArgs e)
{
GridViewDataColumn dataColumn = e.Column as GridViewDataColumn;
if (GridViewRowType.Data == e.RowType && e.Column != null && dataColumn.FieldName == "Unidade")
e.BrickStyle.BackColor = System.Drawing.Color.Silver;
}
protected void ASPxGridViewExporter1_RenderBrick(object sender, ASPxGridViewExportRenderingEventArgs e)
{
if (e.RowType == DevExpress.Web.ASPxGridView.GridViewRowType.Title)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.AppendLine(string.Format("Emerson <br/>"));
e.Text = sb.ToString().Replace("<br />", Environment.NewLine);
}
}
