/// <summary>
/// 通过元数据添加Band
/// </summary>
/// <param name="_mtable"></param>
private void CreateBandColumn(MDQuery_ResultTable _resultTable, DefaultBoolean _canSort)
{
Font UseFont = null;
GridBand _band = null;
try
{
_band = this.bandedGridView1.Bands.Add();
UseFont = new System.Drawing.Font("Tahoma", 9F, System.Drawing.FontStyle.Bold);
_band.AppearanceHeader.Font = UseFont;
MDModel_Table _tableDefine = MC_QueryModel.GetTableDefine(QueryModel, _resultTable.TableName);
_band.Caption = _tableDefine.TableDefine.DisplayTitle;
int i = 1;
foreach (MDQuery_TableColumn _rc in _resultTable.Columns)
{
BandedGridColumn _col = this.bandedGridView1.Columns.Add();
_col.OptionsColumn.ReadOnly = this.ReadOnly;
_col.OptionsColumn.AllowSort = _canSort;
_col.Caption = _rc.ColumnTitle;
_col.FieldName = _rc.TableName + "_" + _rc.ColumnName;
_col.Visible = true;
_col.VisibleIndex = i++;
_col.Width = 150;
FieldsDictionary.Add(_col.FieldName, new RealColumnDefine(_rc.TableName, _rc.ColumnAlias));
this.bandedGridView1.Columns.Add(_col);
_band.Columns.Add(_col);
}
_band = null;
UseFont = null;
}
finally
{
if (_band != null)
{
_band.Dispose();
}
if (UseFont != null)
{
UseFont.Dispose();
}
}
}
private void CreateExcelBandColumn(DataTable _excelResultData)
{
GridBand _band = this.bandedGridView1.Bands.Add();
try
{
_band.AppearanceHeader.Font = new System.Drawing.Font("Tahoma", 9F, System.Drawing.FontStyle.Bold);
_band.Caption = "EXCEL文件";
int i = 1;
foreach (DataColumn _dc in _excelResultData.Columns)
{
if (_dc.ColumnName != "MAINID")
{
BandedGridColumn _col = this.bandedGridView1.Columns.Add();
_col.OptionsColumn.ReadOnly = this.ReadOnly;
_col.OptionsColumn.AllowSort = DefaultBoolean.False;
_col.Caption = _dc.Caption;
_col.FieldName = "EXCEL_" + _dc.ColumnName;
_col.Visible = true;
_col.VisibleIndex = i++;
_col.Width = 150;
FieldsDictionary.Add(_col.FieldName, new RealColumnDefine("EXCEL", _dc.ColumnName));
this.bandedGridView1.Columns.Add(_col);
_band.Columns.Add(_col);
}
}
_band = null;
}
finally
{
if (_band != null)
{
_band.Dispose();
}
}
}