/// <summary>
/// 以分组排序方式显示
/// </summary>
private void ShowAsGroupSort()
{
if (CurrentGrid is SinoSZUC_GridControlEx)
{
SinoSZUC_GridControlEx _grid = (SinoSZUC_GridControlEx)CurrentGrid;
_grid.ShowAsGroupSorting = !_grid.ShowAsGroupSorting;
RaiseMenuChanged();
}
}
/// <summary>
/// 以图表方式展示
/// </summary>
private void ShowAsChart()
{
if (_currentGrid is SinoSZUC_GridControlEx)
{
SinoSZUC_GridControlEx _gridEx = _currentGrid as SinoSZUC_GridControlEx;
DataTable _dt = _gridEx.CurrentData();
Dictionary <string, string> _fieldsDict = _gridEx.CurrentFieldsDict();
frmChartShow _f = new frmChartShow(_dt, _fieldsDict);
_application.AddForm(Guid.NewGuid().ToString(), _f);
}
}
/// <summary>
/// 转存到个人分析空间
/// </summary>
private void SaveToPanalize()
{
BaseView _bv = null;
if (_currentGrid is SinoSZUC_GridControlEx)
{
SinoSZUC_GridControlEx _gridEx = _currentGrid as SinoSZUC_GridControlEx;
_bv = _gridEx.CurrentView;
}
if (_currentGrid is SinoSZUC_GridControlEx_FullRelation)
{
SinoSZUC_GridControlEx_FullRelation _gridFullEX = _currentGrid as SinoSZUC_GridControlEx_FullRelation;
_bv = _gridFullEX.CurrentView;
}
if (_bv != null)
{
PAnalize_GridViewData.SaveToPAnalize(_bv);
}
}
/// <summary>
/// 导出
/// </summary>
private void ExportData()
{
BaseView _bv = null;
if (_currentGrid is SinoSZUC_GridControlEx)
{
SinoSZUC_GridControlEx _gridEx = _currentGrid as SinoSZUC_GridControlEx;
_bv = _gridEx.CurrentView;
}
if (_currentGrid is SinoSZUC_GridControlEx_FullRelation)
{
SinoSZUC_GridControlEx_FullRelation _gridFullEX = _currentGrid as SinoSZUC_GridControlEx_FullRelation;
_bv = _gridFullEX.CurrentView;
}
if (_bv != null)
{
SinoSZExport_GridViewData.Export(_bv);
}
}
public string GetFocusedMainKey()
{
try
{
if (_currentGrid is SinoSZUC_GridControlEx)
{
SinoSZUC_GridControlEx _gridEx = _currentGrid as SinoSZUC_GridControlEx;
DataRow _dr = _gridEx.FocusedDataRow;
if (_dr != null)
{
string _mainKeyID = _dr["MAINID"].ToString();
return(_mainKeyID);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return("");
}
/// <summary>
/// 显示详细信息
/// </summary>
private void ShowDetail()
{
switch (this._queryType)
{
case "QueryModel":
if (_currentGrid is SinoSZUC_GridControlEx)
{
SinoSZUC_GridControlEx _gridEx = _currentGrid as SinoSZUC_GridControlEx;
DataRow _dr = _gridEx.FocusedDataRow;
if (_dr != null)
{
string _mainKeyID = _dr["MAINID"].ToString();
frmSinoSZ_DataDetail _form = new frmSinoSZ_DataDetail(this.QueryModel, _mainKeyID);
_application.AddForm(Guid.NewGuid().ToString(), _form);
}
}
break;
case "TaskResult":
XtraMessageBox.Show("任务式查询的数据结果无法查看详细数据!");
break;
}
}
/// <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);
}
