/// <summary>
/// Hàm Test xử lý
/// </summary>
/// <param name="stt"></param>
/// <param name="config"></param>
/// <param name="bands"></param>
private void ProcessCreateConfig(ColumnConfig config, GridBandCollection bands)
{
// Duyệt qua từng Brand
for (int i = 0; i < bands.Count; i++)
{
// Khởi tạo một config column
// Đưa vào config cha
var tc = this.CreateColumnConfig(bands[i]);
config.Columns.Add(tc);
// Nếu có Brand con thì tiếp tục xử lý
if (bands[i].HasChildren)
{
ProcessCreateConfig(tc, bands[i].Children);
}
// Còn nếu không thì tạo config cho cột con
else
{
for (int j = 0; j < bands[i].Columns.Count; j++)
{
tc.Columns.Add(this.CreateColumnConfig(bands[i].Columns[j]));
}
}
}
}
void ApplyModelBands(GridBandCollection bandCollection, IEnumerable <IModelGridBand> modelGridBands)
{
foreach (var modelGridBand in modelGridBands)
{
var gridBand = GetGridBand(modelGridBand, bandCollection);
AddColumnToGridBand(gridBand, modelGridBand);
ApplyModelBands(gridBand.Children, modelGridBand.GridBands);
}
}
void SynchronizeGridBands(GridBandCollection gridBands)
{
foreach (var gridBand in gridBands.OfType <GridBand>())
{
gridBand.ModelGridBand.Index = gridBand.VisibleIndex;
ApplyModel(gridBand.ModelGridBand, gridBand, SynchronizeValues);
SynchronizeGridBands(gridBand.Children);
}
}
public static int GetMaxLevel(GridBandCollection bandCollection)
{
int max = 0;
foreach (GridBand band in bandCollection)
{
int temp = GetLevel(band);
if (max < temp)
{
max = temp;
}
}
return(max);
}
/// <summary>
/// Tìm tất cả các GridBand
/// </summary>
/// <param name="bgc"></param>
/// <returns></returns>
private IEnumerable <GridBand> FindAllGridBand(GridBandCollection bgc)
{
var bgcc = bgc.Cast <GridBand>();
foreach (var bg in bgcc)
{
yield return(bg);
var bgcChildren = FindAllGridBand(bg.Children);
foreach (var bc in bgcChildren)
{
yield return(bc);
}
}
}
GridBand GetGridBand(IModelGridBand modelGridBand, GridBandCollection bandCollection)
{
var gridBand = FindGridBand(modelGridBand);
if (gridBand == null)
{
gridBand = new GridBand(modelGridBand)
{
Name = GetBandName(modelGridBand)
};
bandCollection.Add(gridBand);
gridBand.Visible = modelGridBand.Index > -1;
}
ApplyModel(modelGridBand, gridBand, ApplyValues);
return(gridBand);
}
//new Method for calculation MaxBandRowCount.[Add By ZhangXiChun 2010-08-09]
private int GetBandRowCount(GridBandCollection bandCollection)
{
int maxRowCount = 0;
foreach (GridBand band in bandCollection)
{
int bandRowCount = 1;
if (band.HasChildren)
{
bandRowCount += GetBandRowCount(band.Children);
}
if (maxRowCount < bandRowCount)
{
maxRowCount = bandRowCount;
}
}
return(maxRowCount);
}
//new export method for multi-row band.[Add By ZhangXiChun 2010-08-09]
private int ExportForBand(int x, int y, int startRow, GridBandCollection bandCollection, int bandRowCount, int floor, Worksheet worksheet)
{
foreach (GridBand band in bandCollection)
{
if (band.ReallyVisible)
{
int originX = x;
worksheet.Rows[startRow + floor].Cells[x].Value = band.Caption;
if (band.HasChildren)
{
x = ExportForBand(x, y, startRow, band.Children, bandRowCount, floor + 1, worksheet);
//TODO: XlsProvider.SetCellStyleAndUnion(originX, startRow + floor, x - originX, 1, GetBandHeaderStyle());
try
{
worksheet.MergedCellsRegions.Add(startRow + floor, originX, startRow + floor, x - 1);
worksheet.Rows[startRow + floor].Cells[originX].CellFormat.Alignment = HorizontalCellAlignment.Center;
worksheet.Rows[startRow + floor].Cells[originX].CellFormat.VerticalAlignment = VerticalCellAlignment.Center;
}
catch (System.Exception)
{
}
}
else
{
int headerRowCount = GridViewForExcel.OptionsView.ShowColumnHeaders == true ? bandRowCount + 1 : bandRowCount;
foreach (GridColumn col in band.Columns)
{
if (col.Visible)
{
if (GridViewForExcel.OptionsView.ShowColumnHeaders == true)
{
worksheet.Rows[startRow + bandRowCount].Cells[x].Value = col.Caption ?? string.Empty;
headerRowCount++;
}
for (y = 0; y < GridViewForExcel.DataRowCount; y++)
{
if (ExportCellsAsDisplayText == true && (!(GridViewForExcel.GetRowCellValue(y, col) is bool) || (col.ColumnEdit != null && col.ColumnEdit.GetType().Name == "RepositoryItemComboBox")))//if type of col's value is bool and editor isn't cbo, then export cell value.[Add by ZhangXiChun 2010-12-03]
{
if ((GridViewForExcel.GetRowCellValue(y, col)) is decimal || (GridViewForExcel.GetRowCellValue(y, col) is int))
{
if (GridViewForExcel.GetRowCellDisplayText(y, col).Contains('%'))
{
worksheet.Rows[y + startRow + headerRowCount].Cells[x].Value = GridViewForExcel.GetRowCellDisplayText(y, col).ToString();
}
else
{
worksheet.Rows[y + startRow + headerRowCount].Cells[x].Value = GridViewForExcel.GetRowCellValue(y, col);
}
}
else
{
worksheet.Rows[y + startRow + headerRowCount].Cells[x].Value = GridViewForExcel.GetRowCellDisplayText(y, col).ToString();
}
}
worksheet.Rows[y + startRow + headerRowCount].Cells[x].Value = GridViewForExcel.GetRowCellValue(y, col) == null ? "" : GridViewForExcel.GetRowCellValue(y, col).ToString();
}
if (GridViewForExcel.OptionsView.ShowFooter == true)
{
if (col.SummaryItem.SummaryType != DevExpress.Data.SummaryItemType.None)
{
if (col.SummaryItem.SummaryValue is int || col.SummaryItem.SummaryValue is decimal)
{
if (col.SummaryText.Contains('%'))
{
worksheet.Rows[y + startRow + headerRowCount].Cells[x].Value = col.SummaryText;
}
else
{
worksheet.Rows[y + startRow + headerRowCount].Cells[x].Value = col.SummaryItem.SummaryValue;
}
}
worksheet.Rows[y + startRow + headerRowCount].Cells[x].Value = col.SummaryText;
}
}
x++;
}
}
//TODO: XlsProvider.SetCellStyleAndUnion(originX, startRow + floor, x - originX, band.HasChildren ? 1 : (floor == 0 ? bandRowCount : bandRowCount - floor), GetBandHeaderStyle());
try
{
worksheet.MergedCellsRegions.Add(startRow + floor, originX, startRow + floor + (band.HasChildren ? 1 : (floor == 0 ? bandRowCount : bandRowCount - floor)) - 1, x - 1);
worksheet.Rows[startRow + floor].Cells[originX].CellFormat.Alignment = HorizontalCellAlignment.Center;
worksheet.Rows[startRow + floor].Cells[originX].CellFormat.VerticalAlignment = VerticalCellAlignment.Center;
}
catch (System.Exception)
{
}
}
}
}
return(x);
}
//public void ExportByInfra(int startCol, int startRow, string fileName)
//{
// Workbook workbook = new Workbook(WorkbookFormat.Excel2007);
// workbook.CellReferenceMode = CellReferenceMode.A1;
// Worksheet worksheet = workbook.Worksheets.Add(GridViewForExcel.Name);
// int x = startCol, originX, bandRowCount, headerRowCount;
// int y = 0;
// int rowCount = GridViewForExcel.DataRowCount;
// x = startCol;
// bandRowCount = 0;
// headerRowCount = GridViewForExcel.OptionsView.ShowColumnHeaders == true ? bandRowCount + 1 : bandRowCount;
// GridColumnCollection colCollection = GridViewForExcel.Columns;
// foreach (GridColumn col in colCollection)
// {
// if (col.Visible)
// {
// worksheet.Rows[startRow].Cells[x].Value = col.Caption;
// for (y = 0; y < rowCount; y++)
// {
// if (ExportCellsAsDisplayText == true && (!(GridViewForExcel.GetRowCellValue(y, col) is bool) || (col.ColumnEdit != null && col.ColumnEdit.GetType().Name == "RepositoryItemComboBox")))//if type of col's value is bool and editor is't cbo, then export cell value.[Add by ZhangXiChun 2010-12-03]
// {
// if ((GridViewForExcel.GetRowCellValue(y, col)) is decimal || (GridViewForExcel.GetRowCellValue(y, col) is int))
// {
// if (GridViewForExcel.GetRowCellDisplayText(y, col).Contains('%'))
// {
// worksheet.Rows[y + startRow + headerRowCount].Cells[x].Value = GridViewForExcel.GetRowCellDisplayText(y, col).ToString();
// }
// else
// {
// worksheet.Rows[y + startRow + headerRowCount].Cells[x].Value = GridViewForExcel.GetRowCellValue(y, col);
// }
// }
// else
// {
// worksheet.Rows[y + startRow + headerRowCount].Cells[x].Value = GridViewForExcel.GetRowCellDisplayText(y, col).ToString();
// }
// }
// else
// {
// worksheet.Rows[y + startRow + headerRowCount].Cells[x].Value = GridViewForExcel.GetRowCellValue(y, col).ToString();
// }
// }
// //if (GridViewForExcel.OptionsView.ShowFooter == true)
// //{
// // if (col.SummaryItem.SummaryType != DevExpress.Data.SummaryItemType.None)
// // {
// // // modi zhang.amei 2012-7-5 13:11:14 数字类型的不需要处理格式
// // // XlsProvider.SetCellString(x, y + startRow + headerRowCount, col.SummaryText);
// // if (col.SummaryItem.SummaryValue is int || col.SummaryItem.SummaryValue is decimal)
// // XlsProvider.SetCellData(x, y + startRow + headerRowCount, col.SummaryItem.SummaryValue);
// // else XlsProvider.SetCellString(x, y + startRow + headerRowCount, col.SummaryText);
// // }
// // XlsProvider.SetCellStyle(x, y + startRow + headerRowCount, GetColumnHeaderStyle());
// //}
// x++;
// }
// }
// /* modified by sun.zeyu 20130111 end */
// workbook.Save(fileName);
//}
public void Export(int startCol, int startRow, string fileName)
{
Workbook workbook = new Workbook(WorkbookFormat.Excel2007);
workbook.CellReferenceMode = CellReferenceMode.A1;
Worksheet worksheet = workbook.Worksheets.Add(GridViewForExcel.Name);
int x = startCol, originX, bandRowCount, headerRowCount;
int y = 0;
int rowCount = GridViewForExcel.DataRowCount;
if (GridViewForExcel is BandedGridView)
{
x = startCol;
GridBandCollection bandCollection = ((BandedGridView)GridViewForExcel).Bands;
bandRowCount = GetBandRowCount(bandCollection); //get MaxBandRowCount.[Add By ZhangXiChun 2010-08-09]
headerRowCount = GridViewForExcel.OptionsView.ShowColumnHeaders == true ? bandRowCount + 1 : bandRowCount; //get HeaderRowCount.[Add By ZhangXiChun 2010-09-08]
if (bandRowCount == 1) //if isn't multi-row band.[Add By ZhangXiChun 2010-08-09]
{
if (((BandedGridView)GridViewForExcel).OptionsView.ShowBands == false)
{
bandRowCount = 0;
headerRowCount = headerRowCount - 1;
}
foreach (GridBand band in bandCollection)
{
if (band.ReallyVisible)
{
originX = x;
if (band.Visible && ((BandedGridView)GridViewForExcel).OptionsView.ShowBands)
{
worksheet.Rows[startRow].Cells[x].Value = band.Caption;
}
GridBandColumnCollection colCollection = band.Columns;
foreach (GridColumn col in colCollection)
{
if (col.Visible)
{
if (GridViewForExcel.OptionsView.ShowColumnHeaders == true) //if ShowColumnHeaders.[Add By ZhangXiChun 2010-09-08]
{
worksheet.Rows[startRow + bandRowCount].Cells[x].Value = col.Caption ?? string.Empty;
}
for (y = 0; y < rowCount; y++)
{
if (ExportCellsAsDisplayText == true && (!(GridViewForExcel.GetRowCellValue(y, col) is bool) || (col.ColumnEdit != null && col.ColumnEdit.GetType().Name == "RepositoryItemComboBox")))//if type of col's value is bool and editor is't cbo, then export cell value.[Add by ZhangXiChun 2010-12-03]
{
if ((GridViewForExcel.GetRowCellValue(y, col)) is decimal || (GridViewForExcel.GetRowCellValue(y, col) is int))
{
if (GridViewForExcel.GetRowCellDisplayText(y, col).Contains('%'))
{
worksheet.Rows[y + startRow + headerRowCount].Cells[x].Value = GridViewForExcel.GetRowCellDisplayText(y, col).ToString();
}
else
{
worksheet.Rows[y + startRow + headerRowCount].Cells[x].Value = GridViewForExcel.GetRowCellValue(y, col);
}
}
worksheet.Rows[y + startRow + headerRowCount].Cells[x].Value = GridViewForExcel.GetRowCellDisplayText(y, col).ToString();
}
else
{
worksheet.Rows[y + startRow + headerRowCount].Cells[x].Value = GridViewForExcel.GetRowCellValue(y, col).ToString();
}
}
if (GridViewForExcel.OptionsView.ShowFooter == true)
{
if (col.SummaryItem.SummaryType != DevExpress.Data.SummaryItemType.None)
{
if (col.SummaryItem.SummaryValue is int || col.SummaryItem.SummaryValue is decimal)
{
if (col.SummaryText.Contains('%'))
{
worksheet.Rows[y + startRow + headerRowCount].Cells[x].Value = col.SummaryText;
}
else
{
worksheet.Rows[y + startRow + headerRowCount].Cells[x].Value = col.SummaryItem.SummaryValue;
}
}
else
{
worksheet.Rows[y + startRow + headerRowCount].Cells[x].Value = col.SummaryText;
}
}
}
x++;
}
}
if (((BandedGridView)GridViewForExcel).OptionsView.ShowBands)
{
//XlsProvider.SetCellStyleAndUnion(originX, startRow, x - originX, bandRowCount, GetBandHeaderStyle());
worksheet.MergedCellsRegions.Add(startRow, originX, startRow + bandRowCount, x);
}
}
}
}
else //if is multi-row band.[Add By ZhangXiChun 2010-08-09]
{
int floor = 0;
ExportForBand(x, y, startRow++, ((BandedGridView)GridViewForExcel).Bands, bandRowCount, floor, worksheet);
}
/* modified by sun.zeyu 20130111 end */
workbook.Save(fileName);
}
else if (GridViewForExcel is GridView)
{
x = startCol;
GridColumnCollection colCollection = GridViewForExcel.Columns;
foreach (GridColumn col in colCollection)
{
if (col.Visible)
{
worksheet.Rows[startRow].Cells[x].Value = col.Caption;
for (y = 0; y < rowCount; y++)
{
if (ExportCellsAsDisplayText == true && (!(GridViewForExcel.GetRowCellValue(y, col) is bool) || (col.ColumnEdit != null && col.ColumnEdit.GetType().Name == "RepositoryItemComboBox")))
{
if ((GridViewForExcel.GetRowCellValue(y, col)) is decimal || (GridViewForExcel.GetRowCellValue(y, col) is int))
{
if (GridViewForExcel.GetRowCellDisplayText(y, col).Contains('%'))
{
worksheet.Rows[y + startRow + 1].Cells[x].Value = GridViewForExcel.GetRowCellDisplayText(y, col).ToString();
}
else
{
worksheet.Rows[y + startRow + 1].Cells[x].Value = GridViewForExcel.GetRowCellValue(y, col);
}
}
else
{
worksheet.Rows[y + startRow + 1].Cells[x].Value = GridViewForExcel.GetRowCellDisplayText(y, col).ToString();
}
}
else
{
worksheet.Rows[y + startRow + 1].Cells[x].Value = GridViewForExcel.GetRowCellValue(y, col).ToString();
}
}
if (GridViewForExcel.OptionsView.ShowFooter == true)
{
if (col.SummaryItem.SummaryType != DevExpress.Data.SummaryItemType.None)
{
if (col.SummaryItem.SummaryValue is int || col.SummaryItem.SummaryValue is decimal)
{
if (col.SummaryText.Contains('%'))
{
worksheet.Rows[y + startRow + 1].Cells[x].Value = col.SummaryText;
}
else
{
worksheet.Rows[y + startRow + 1].Cells[x].Value = col.SummaryItem.SummaryValue;
}
}
else
{
worksheet.Rows[y + startRow + 1].Cells[x].Value = col.SummaryText;
}
}
}
x++;
}
}
/* modified by sun.zeyu 20130111 end */
workbook.Save(fileName);
}
}
public virtual void Export(int startCol, int startRow)
{
int x = startCol, originX;
int y;
int rowCount = _gridView.DataRowCount;
if (_gridView is BandedGridView)
{
x = startCol;
GridBandCollection bandCollection = ((BandedGridView)_gridView).Bands;
foreach (GridBand band in bandCollection)
{
if (band.ReallyVisible)
{
originX = x;
_xlsProvider.SetCellString(x, startRow, band.Caption);
GridBandColumnCollection colCollection = band.Columns;
foreach (GridColumn col in colCollection)
{
if (col.Visible)
{
_xlsProvider.SetCellString(x, startRow + band.RowCount, col.Caption ?? string.Empty);
//_xlsProvider.SetCellStyle(x, startRow + band.RowCount, ConvertAppearanceToCellStyle(col.AppearanceHeader));
_xlsProvider.SetCellStyle(x, startRow + band.RowCount, GetColumnHeaderStyle());
for (y = 0; y < rowCount; y++)
{
if (_exportCellsAsDisplayText == true)
{
_xlsProvider.SetCellString(x, y + startRow + band.RowCount + 1, _gridView.GetRowCellDisplayText(y, col).ToString());
}
else
{
_xlsProvider.SetCellString(x, y + startRow + band.RowCount + 1, _gridView.GetRowCellValue(y, col).ToString());
}
_xlsProvider.SetCellStyle(x, y + startRow + band.RowCount + 1, ConvertAppearanceToCellStyle(col.AppearanceCell));
}
if (_gridView.OptionsView.ShowFooter == true)
{
if (col.SummaryItem.SummaryType != DevExpress.Data.SummaryItemType.None)
{
_xlsProvider.SetCellString(x, y + startRow + band.RowCount + 1, col.SummaryText);
}
//_xlsProvider.SetCellStyle(x, y + startRow + band.RowCount + 1, ConvertAppearanceToCellStyle(col.AppearanceHeader));
_xlsProvider.SetCellStyle(x, y + startRow + band.RowCount + 1, GetColumnHeaderStyle());
}
x++;
}
}
//_xlsProvider.SetCellStyleAndUnion(originX, startRow, x - originX, band.RowCount, ConvertAppearanceToCellStyle(band.AppearanceHeader));
_xlsProvider.SetCellStyleAndUnion(originX, startRow, x - originX, band.RowCount, GetBandHeaderStyle());
}
}
}
else if (_gridView is GridView)
{
x = startCol;
GridColumnCollection colCollection = _gridView.Columns;
foreach (GridColumn col in colCollection)
{
if (col.Visible)
{
_xlsProvider.SetCellString(x, startRow, col.Caption);
//_xlsProvider.SetCellStyle(x, startRow, ConvertAppearanceToCellStyle(col.AppearanceHeader));
_xlsProvider.SetCellStyle(x, startRow, GetColumnHeaderStyle());
for (y = 0; y < rowCount; y++)
{
if (_exportCellsAsDisplayText == true)
{
_xlsProvider.SetCellString(x, y + startRow + 1, _gridView.GetRowCellDisplayText(y, col).ToString());
}
else
{
_xlsProvider.SetCellString(x, y + startRow + 1, _gridView.GetRowCellValue(y, col).ToString());
}
_xlsProvider.SetCellStyle(x, y + startRow + 1, ConvertAppearanceToCellStyle(col.AppearanceCell));
}
if (_gridView.OptionsView.ShowFooter == true)
{
if (col.SummaryItem.SummaryType != DevExpress.Data.SummaryItemType.None)
{
_xlsProvider.SetCellString(x, y + startRow + 1, col.SummaryText);
}
//_xlsProvider.SetCellStyle(x, y + startRow + 1, ConvertAppearanceToCellStyle(col.AppearanceHeader));
_xlsProvider.SetCellStyle(x, y + startRow + 1, GetColumnHeaderStyle());
}
x++;
}
}
}
}
