/// <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(); } } }