protected override IList <FrmMenuGroup> GetMenuGroups(string _pagename) { FrmMenuItem _item; IList <FrmMenuGroup> _ret = new List <FrmMenuGroup>(); FrmMenuGroup _thisGroup = new FrmMenuGroup("数据比对结果"); _thisGroup.MenuItems = new List <FrmMenuItem>(); bool _canUse = !this.backgroundWorker1.IsBusy; if (compareRequest != null && this.QueryModel != null && this.radioGroup1.SelectedIndex == 0 && this.CompareResult != null) { _item = new FrmMenuItem("展示方式", "展示方式", global::SinoSZMetaDataQuery.Properties.Resources.b11, _canUse); _thisGroup.MenuItems.Add(_item); FrmMenuItem _citem = new FrmMenuItem("常规展示", "常规展示", global::SinoSZMetaDataQuery.Properties.Resources.b12, _canUse); _item.ChildMenus.Add(_citem); foreach (DataTable _dt in this.CompareResult.Tables) { if (_dt.TableName != this.QueryModel.MainTable.TableName) { MDModel_Table _mt = MC_QueryModel.GetTableDefine(this.QueryModel, _dt.TableName); if (_mt != null) { _citem = new FrmMenuItem(string.Format("关联展示[{0}]", _mt.TableDefine.DisplayTitle), string.Format("关联展示,{0}", _dt.TableName), global::SinoSZMetaDataQuery.Properties.Resources.b13, _canUse); _item.ChildMenus.Add(_citem); } } } _citem = new FrmMenuItem(string.Format("关联展示[{0}]", "EXCEL文件"), string.Format("关联展示,{0}", "EXCELRESULTDATA"), global::SinoSZMetaDataQuery.Properties.Resources.b13, _canUse); _item.ChildMenus.Add(_citem); _citem = new FrmMenuItem("关联展示[全部]", "全部平铺展示", global::SinoSZMetaDataQuery.Properties.Resources.b14, true); _item.ChildMenus.Add(_citem); } _item = new FrmMenuItem("导出", "导出", global::SinoSZMetaDataQuery.Properties.Resources.x3, _canUse); _thisGroup.MenuItems.Add(_item); _ret.Add(_thisGroup); return(_ret); }
/// <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(); } } }
/// <summary> /// 取菜单组 /// </summary> /// <param name="_pagename"></param> /// <returns></returns> private IList <FrmMenuGroup> GetMenuGroups(string _pagename) { IList <FrmMenuGroup> _ret = new List <FrmMenuGroup>(); if (this.backgroundWorker1.IsBusy && !this.backgroundWorker1.CancellationPending) { FrmMenuGroup _thisGroup = new FrmMenuGroup("查询处理"); _thisGroup.MenuItems = new List <FrmMenuItem>(); FrmMenuItem _item = new FrmMenuItem("取消", "取消", global::SinoSZMetaDataQuery.Properties.Resources.x1, true); _thisGroup.MenuItems.Add(_item); _ret.Add(_thisGroup); } else { FrmMenuGroup _thisGroup = new FrmMenuGroup("数据分析"); _thisGroup.MenuItems = new List <FrmMenuItem>(); FrmMenuItem _item; if (QueryResultData != null) { _item = new FrmMenuItem("展示方式", "展示方式", global::SinoSZMetaDataQuery.Properties.Resources.b11, true); _thisGroup.MenuItems.Add(_item); FrmMenuItem _citem = new FrmMenuItem("常规展示", "常规展示", global::SinoSZMetaDataQuery.Properties.Resources.b12, true); _item.ChildMenus.Add(_citem); foreach (DataTable _dt in QueryResultData.Tables) { if (_dt.TableName != this.QueryModel.MainTable.TableName) { MDModel_Table _mt = MC_QueryModel.GetTableDefine(this.QueryModel, _dt.TableName); _citem = new FrmMenuItem(string.Format("关联展示[{0}]", _mt.TableDefine.DisplayTitle), string.Format("关联展示,{0}", _dt.TableName), global::SinoSZMetaDataQuery.Properties.Resources.b13, true); _item.ChildMenus.Add(_citem); } } _citem = new FrmMenuItem("关联展示[全部]", "全部平铺展示", global::SinoSZMetaDataQuery.Properties.Resources.b14, true); _item.ChildMenus.Add(_citem); } bool _canGroupSort = false; bool _canShowAsChart = true; bool _canShowDetail = true; string _GSbuttonCaption = "分组排序"; if (CurrentGrid is SinoSZUC_GridControlEx) { SinoSZUC_GridControlEx _grid = (SinoSZUC_GridControlEx)CurrentGrid; if (_grid.ShowAsGroupSorting) { _GSbuttonCaption = "取消分组"; _canShowDetail = false; _canGroupSort = true; } else { if (_grid.Grouped) { _canGroupSort = true; } } } else { _canShowAsChart = false; } if (_GSbuttonCaption == "分组排序") { _item = new FrmMenuItem(_GSbuttonCaption, "分组排序", global::SinoSZMetaDataQuery.Properties.Resources.b15, _canGroupSort); _thisGroup.MenuItems.Add(_item); } else { _item = new FrmMenuItem(_GSbuttonCaption, "分组排序", global::SinoSZMetaDataQuery.Properties.Resources.b16, _canGroupSort); _thisGroup.MenuItems.Add(_item); } //_item = new FrmMenuItem("数据透视", "数据透视", global::SinoSZMetaDataQuery.Properties.Resources.b17, _canShowAsChart); //_thisGroup.MenuItems.Add(_item); _item = new FrmMenuItem("图表展示", "图表展示", global::SinoSZMetaDataQuery.Properties.Resources.b18, _canShowAsChart); _thisGroup.MenuItems.Add(_item); //_item = new FrmMenuItem("数据筛选", "数据筛选", global::SinoSZMetaDataQuery.Properties.Resources.DataFilter2, true); //_thisGroup.MenuItems.Add(_item); _ret.Add(_thisGroup); _thisGroup = new FrmMenuGroup("数据处理"); _thisGroup.MenuItems = new List <FrmMenuItem>(); if (!frmSinoSZ_QueryResult.DisableUsePAnalize) { _item = new FrmMenuItem("数据转存", "数据转存", global::SinoSZMetaDataQuery.Properties.Resources.b26, true); _thisGroup.MenuItems.Add(_item); } _item = new FrmMenuItem("导出", "导出", global::SinoSZMetaDataQuery.Properties.Resources.x3, true); _thisGroup.MenuItems.Add(_item); //_item = new FrmMenuItem("添加字段", "添加字段", global::SinoSZMetaDataQuery.Properties.Resources.b27, _canShowAsChart); //_thisGroup.MenuItems.Add(_item); _item = new FrmMenuItem("详细信息", "详细信息", global::SinoSZMetaDataQuery.Properties.Resources.x2, _canShowDetail && CanShowDetailButton); _thisGroup.MenuItems.Add(_item); _ret.Add(_thisGroup); foreach (FrmMenuGroup _extg in this.ExtendMenuGroups) { _ret.Add(_extg); } } return(_ret); }