/// <summary> /// 导出EXCEL时触发。 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void exporter_RenderBrick(object sender, DevExpress.Web.ASPxGridViewExportRenderingEventArgs e) { if (e.RowType == DevExpress.Web.GridViewRowType.Data && e.Column != null) { e.Text = Convert.ToString(e.TextValue); } }
protected void ASPxGridViewExporter1_RenderBrick(object sender, DevExpress.Web.ASPxGridViewExportRenderingEventArgs e) { StringFormat sFormat = new StringFormat(StringFormatFlags.NoWrap); BrickStringFormat brickSFormat = new BrickStringFormat(sFormat); e.XlsxFormatString = sFormat.ToString(); }
protected void grvExport_RenderBrick(object sender, DevExpress.Web.ASPxGridViewExportRenderingEventArgs e) { GridViewDataColumn dataColumn = e.Column as GridViewDataColumn; if (e.RowType == GridViewRowType.Data && dataColumn != null && dataColumn.VisibleIndex == 8) { string strCoCode = e.GetValue("CoCode").ToString(); if (strCoCode != string.Empty) { using (COMPANY_BO objT24_COMPANY_BO = new COMPANY_BO()) { COMPANY objT24_COMPANY = objT24_COMPANY_BO.GetByCOMPANY_CODE(strCoCode); if (objT24_COMPANY != null) { e.TextValue = objT24_COMPANY.COMPANY_NAME; } } } } dataColumn = e.Column as GridViewDataColumn; if (e.RowType == GridViewRowType.Data && dataColumn != null && dataColumn.VisibleIndex == 9) { if (e.GetValue("IsUsed") != null) { bool strStatus = Convert.ToBoolean(e.GetValue("IsUsed")); if (strStatus) { e.TextValue = "Đã cấp"; } else { e.TextValue = "Đã xóa"; } } else { e.TextValue = "Đã cấp"; } } }
protected void grvExport_RenderBrick(object sender, DevExpress.Web.ASPxGridViewExportRenderingEventArgs e) { GridViewDataColumn dataColumn = e.Column as GridViewDataColumn; if (e.RowType == GridViewRowType.Data && dataColumn != null && dataColumn.VisibleIndex == 7) { if (e.GetValue("Serials") != null) { string strSerials = e.GetValue("Serials").ToString(); if (!string.IsNullOrEmpty(strSerials)) { strSerials = Commons.Common.FormatSerial(strSerials.Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries).ToList()); } e.TextValue = strSerials; } else { e.TextValue = string.Empty; } } dataColumn = e.Column as GridViewDataColumn; if (e.RowType == GridViewRowType.Data && dataColumn != null && dataColumn.VisibleIndex == 9) { string strCoCode = e.GetValue("CO_CODE").ToString(); if (strCoCode != string.Empty) { using (DataModel.COMPANY_BO objT24_COMPANY_BO = new DataModel.COMPANY_BO()) { DataModel.COMPANY objT24_COMPANY = objT24_COMPANY_BO.GetByCOMPANY_CODE(strCoCode); if (objT24_COMPANY != null) { e.TextValue = objT24_COMPANY.COMPANY_NAME; } } } } dataColumn = e.Column as GridViewDataColumn; if (e.RowType == GridViewRowType.Data && dataColumn != null && dataColumn.VisibleIndex == 10) { if (e.GetValue("IsUsed") != null) { bool strStatus = Convert.ToBoolean(e.GetValue("IsUsed")); if (strStatus) { e.TextValue = "Đã cấp mã"; } else { e.TextValue = "Đã xóa"; } } else { e.TextValue = "Đã cấp mã"; } } }