public QueryModelManager(MD_QueryModel _qm) { InitializeComponent(); _queryModel = _qm; RefreshData(); _initFinished = true; }
private void ChangeView2ViewGroupID(MD_View2ViewGroup _group, MD_QueryModel _qv, SinoSZClientBase.MetaDataService.MetaDataServiceClient _mdc) { if (_group == null) { return; } _group.QueryModelID = _qv.QueryModelID; string _newid = GetNewID(_group.ID, "MD_VIEW2VIEWGROUP", "ID", _mdc); try { IDTable.Add(_group.ID, _newid); } catch (Exception e) { throw e; } _group.ID = _newid; if (_group.View2Views != null && _group.View2Views.Count > 0) { foreach (MD_View2View _v2v in _group.View2Views) { ChangeView2ViewID(_v2v, _group, _mdc); } } }
private void ChangeTableID(MD_ViewTable _table, MD_QueryModel _qv, MetaDataServiceClient _mdc) { if (_table == null) { return; } _table.NamespaceName = _qv.NamespaceName; string _newtid = IDTable[_table.TableID]; _table.TableID = _newtid; _table.DWDM = _qv.DWDM; _table.QueryModelID = _qv.QueryModelID; string _newid = GetNewID(_table.ViewTableID, "MD_VIEWTABLE", "VTID", _mdc); try { IDTable.Add(_table.ViewTableID, _newtid); } catch (Exception e) { throw e; } _table.ViewTableID = _newid; if (_table.FatherTableID != "") { _table.FatherTableID = IDTable[_table.FatherTableID]; } foreach (MD_ViewTableColumn _vtc in _table.Columns) { string _newVTCid = GetNewID(_vtc.ViewTableColumnID, "MD_VIEWTABLECOLUMN", "VTCID", _mdc); _vtc.ViewTableColumnID = _newVTCid; _vtc.ColumnID = IDTable[_vtc.ColumnID]; _vtc.DWDM = _qv.DWDM; } }
public async Task <bool> SaveNewQueryModel(MD_QueryModel queryModel) { var ret = await this.mdService.SaveNewQueryModel(queryModel); MyDA_MetaDataQuery.QueryModelCache.Clear(); return(ret); }
public Dialog_AddMainTable(MD_QueryModel _qm) { InitializeComponent(); _queryModel = _qm; using (MetaDataServiceClient _mdc = new MetaDataServiceClient()) { List <MD_Table> _tlist = _mdc.GetTablesAtNamespace(_qm.NamespaceName).ToList <MD_Table>(); this.gridControl1.DataSource = _tlist; } }
internal void InitData(MD_QueryModel _qv) { QueryModel = _qv; if (_qv != null) { this.TE_DES.EditValue = _qv.Description; this.TE_DISPLAY.EditValue = _qv.DisplayTitle; } _initFinished = true; RaiseDataChanged(); }
public static MDModel_QueryModel GetQueryModelDefine(string QueryModelName) { if (!QueryModelLib.ContainsKey(QueryModelName)) { using (MetaDataQueryServiceClient _sc = new MetaDataQueryServiceClient()) { MD_QueryModel _qv = _sc.GetMDQueryModelDefine(QueryModelName); QueryModelLib.Add(QueryModelName, MC_QueryModel.CreateQuery_ModelDefine(_qv)); } } return(QueryModelLib[QueryModelName]); }
public bool SaveQueryModel(MD_QueryModel QueryModel) { try { OraMetaDataFactroy _of = new OraMetaDataFactroy(); return(_of.SaveQueryModel(QueryModel)); } catch (Exception ex) { throw new FaultException(ex.Message); } }
public bool ImportQueryModelDefine(MD_QueryModel QueryModel) { try { OraMetaDataFactroy _of = new OraMetaDataFactroy(); return(_of.ImportQueryModelDefine(QueryModel)); } catch (Exception ex) { throw new FaultException(ex.Message); } }
public MD_QueryModel GetMDQueryModelDefine(string QueryModelName) { if (!QueryModelCache.ContainsKey(QueryModelName)) { OraMetaDataFactroy _OMDFactroy = new OraMetaDataFactroy(); MD_QueryModel _qv = _OMDFactroy.GetQueryModelByName(QueryModelName); _qv.MainTable = _OMDFactroy.GetMainTableOfQueryModel(_qv); _qv.ChildTables = _OMDFactroy.GetChildTableOfQueryModel(_qv); QueryModelCache.Add(QueryModelName, _qv); } return(QueryModelCache[QueryModelName]); }
private void ShowQueryModelInfo(MD_QueryModel _qv) { SinoUC_QME_QueryModelInfo _uc = new SinoUC_QME_QueryModelInfo(); _uc.DataChanged += new EventHandler <EventArgs>(_uc_DataChanged); _uc.MenuChanged += new EventHandler <EventArgs>(_uc_MenuChanged); _uc.InitData(_qv); _uc.Dock = DockStyle.Fill; this.panel1.Controls.Clear(); this.panel1.Controls.Add(_uc); CurrentItem = _uc as IControlMenu; }
private void InitViewExRight(TreeListNode _fnode, MD_QueryModel _qm) { using (MetaDataServiceClient _mdc = new MetaDataServiceClient()) { IList <MD_QueryModel_ExRight> _erList = _mdc.GetQueryModelExRights(_qm.QueryModelID, "0"); foreach (MD_QueryModel_ExRight _right in _erList) { TreeListNode _node = treeList1.AppendNode(null, _fnode); _node.ImageIndex = 1; _node.SelectImageIndex = 0; _node.SetValue(this.treeListColumn1, _right); _node.HasChildren = true; } } }
private void InitView2Application(TreeListNode _fnode, MD_QueryModel _qm) { using (MetaDataServiceClient _mdc = new MetaDataServiceClient()) { List <MD_View2App> _vgList = _mdc.GetView2ApplicationList(_qm.QueryModelID).ToList <MD_View2App>(); foreach (MD_View2App _gl in _vgList) { TreeListNode _node = treeList1.AppendNode(null, _fnode); _node.ImageIndex = 2; _node.SelectImageIndex = 0; _node.SetValue(this.treeListColumn1, _gl); _node.HasChildren = false; } } }
private void InitView2GuideLine(TreeListNode _fnode, MD_QueryModel _qm) { IList <MD_View_GuideLine> _vgList; using (MetaDataServiceClient _mdc = new MetaDataServiceClient()) { _vgList = _mdc.GetView2GuideLineList(_qm.QueryModelID); } foreach (MD_View_GuideLine _gl in _vgList) { TreeListNode _node = treeList1.AppendNode(null, _fnode); _node.ImageIndex = 1; _node.SelectImageIndex = 0; _node.SetValue(this.treeListColumn1, _gl); _node.HasChildren = true; } }
private void LoadMainTable(TreeListNode _fnode, MD_QueryModel _qv) { using (MetaDataServiceClient _mdc = new MetaDataServiceClient()) { MD_ViewTable _mainTable = _mdc.GetMainTableOfQueryModel(_qv.QueryModelID); if (_mainTable != null) { TreeListNode _newnode = treeList1.AppendNode(null, _fnode); _newnode.SetValue(this.treeListColumn1, _mainTable); _newnode.ImageIndex = 2; _newnode.SelectImageIndex = 0; _newnode.HasChildren = true; _mainTable.QueryModelID = _qv.QueryModelID; _qv.MainTable = _mainTable; } } }
private void ChangeView2GuideLineID(MD_View_GuideLine _v2g, MD_QueryModel _qv, MetaDataServiceClient _mdc) { if (_v2g == null) { return; } _v2g.ViewID = _qv.QueryModelID; string _newid = GetNewID(_v2g.ID, "MD_VIEW2GUIDELINE", "ID", _mdc); try { IDTable.Add(_v2g.ID, _newid); } catch (Exception e) { throw e; } _v2g.ID = _newid; }
private void ChangeView2AppID(MD_View2App _v2a, MD_QueryModel _qv, MetaDataServiceClient _mdc) { if (_v2a == null) { return; } _v2a.ViewID = _qv.QueryModelID; string _newid = GetNewID(_v2a.ID, "MD_VIEW2APPLICATION", "ID", _mdc); try { IDTable.Add(_v2a.ID, _newid); } catch (Exception e) { throw e; } _v2a.ID = _newid; }
/// <summary> /// 取选择的查询模型 /// </summary> /// <returns></returns> private List <MD_QueryModel> GetSelectQueryModel() { List <MD_QueryModel> _ret = new List <MD_QueryModel>(); foreach (TreeListNode _node in this.treeList1.Nodes) { object _stobj = _node.GetValue("State"); if (_stobj != null) { int _st = (int)_stobj; if (_st == 1) { MD_QueryModel _qm = _node.GetValue("COLUMN1") as MD_QueryModel; _ret.Add(_qm); } } } return(_ret); }
private List <MD_GuideLineDetailParameter> InitDetailParm(MD_GuideLineDetailDefine _detailDefine) { using (MetaDataServiceClient _mdc = new MetaDataServiceClient()) { List <MD_GuideLineDetailParameter> _ret = new List <MD_GuideLineDetailParameter>(); switch (_detailDefine.QueryDetailType) { case "查询模型": MD_QueryModel _model = _mdc.GetQueryModelByName(_detailDefine.DetailMethodID); MD_ViewTable _viewTable = _mdc.GetMainTableOfQueryModel(_model.QueryModelID); this.comboBoxEdit1.Properties.Items.Clear(); this.comboBoxEdit1.EditValue = null; foreach (MD_ViewTableColumn _col in _viewTable.Columns) { SelectTableColumn _item = new SelectTableColumn(_col); if (_col.TableColumn.ColumnName == _viewTable.Table.MainKey) { _item.Title += " [主键] "; } this.comboBoxEdit1.Properties.Items.Add(_item); } this.te_Type.EditValue = ""; this.te_Title.EditValue = ""; this.te_Value.EditValue = ""; break; case "指标定义": MD_GuideLine _gl = _mdc.GetGuideLineDefine(_detailDefine.DetailMethodID); List <MD_GuideLineParameter> _gParam = MC_GuideLine.GetParametersFromMeta(_gl.GuideLineMeta); foreach (MD_GuideLineParameter _p in _gParam) { _ret.Add(new MD_GuideLineDetailParameter(_p.ParameterName, _p.DisplayTitle, _p.ParameterType, "")); } break; } return(_ret); } }
public MD_QueryModel SaveNew() { using (MetaDataServiceClient _mdc = new MetaDataServiceClient()) { _queryModel = new MD_QueryModel(); _queryModel.Description = (this.TE_DES.EditValue == null) ? "" : this.TE_DES.EditValue.ToString(); _queryModel.DisplayTitle = (this.TE_DISPLAY.EditValue == null) ? this.TE_MODELNAME.EditValue.ToString() : this.TE_DISPLAY.EditValue.ToString(); _queryModel.DisplayOrder = Convert.ToInt32((this.TE_DISPLAYORDER.EditValue == null) ? "0" : this.TE_DISPLAYORDER.EditValue.ToString()); _queryModel.QueryModelName = this.TE_MODELNAME.EditValue.ToString(); _queryModel.IsFixQuery = (this.TE_TYPE.Items[0].CheckState == CheckState.Checked); _queryModel.IsRelationQuery = (this.TE_TYPE.Items[1].CheckState == CheckState.Checked); _queryModel.IsDataAuditing = (this.TE_TYPE.Items[2].CheckState == CheckState.Checked); _queryModel.QueryInterface = (this.te_Ics.EditValue.ToString()); _queryModel.NamespaceName = (_nameSpace == null) ? "" : _nameSpace.NameSpace; _queryModel.DWDM = _nameSpace.DWDM; _queryModel.EXTMeta = (this.te_ExtMeta.EditValue == null) ? "" : this.te_ExtMeta.EditValue.ToString(); _mdc.SaveNewQueryModel(_queryModel); } _haveChange = false; RaiseDataChanged(); return(_queryModel); }
public bool SaveQueryModel(MD_QueryModel _queryModel) { return(MetaDataFactroy.SaveQueryModel(_queryModel)); }
public async Task <bool> ImportQueryModelDefine(MD_QueryModel queryModel) { var ret = await this.mdService.ImportQueryModelDefine(queryModel); return(ret); }
private void WriteModelDefine(string _oldNameSpace, MD_Namespace _ns, DataSet _ds) { using (MetaDataServiceClient _mdc = new MetaDataServiceClient()) { DataRow[] _qvDefineRows = _ds.Tables["MD_VIEW"].Select(string.Format("NAMESPACE='{0}'", _oldNameSpace)); foreach (DataRow _dr in _qvDefineRows) { string _oldid = _dr["VIEWID"].ToString(); string _newid = GetNewID(_oldid, "MD_VIEW", "VIEWID", _mdc); this.IDTable.Add(_oldid, _newid); MD_QueryModel _qv = new MD_QueryModel( _newid, _ns.NameSpace, _dr.IsNull("VIEWNAME") ? "" : _dr["VIEWNAME"].ToString(), _dr.IsNull("DESCRIPTION") ? "" : _dr["DESCRIPTION"].ToString(), _dr.IsNull("DISPLAYNAME") ? "" : _dr["DISPLAYNAME"].ToString(), _ns.DWDM, _dr.IsNull("IS_GDCX") ? false : ((decimal)_dr["IS_GDCX"] > 0), _dr.IsNull("IS_GLCX") ? false : ((decimal)_dr["IS_GLCX"] > 0), _dr.IsNull("IS_SJSH") ? false : ((decimal)_dr["IS_SJSH"] > 0), _dr.IsNull("DISPLAYORDER") ? 0 : Convert.ToInt32(_dr["DISPLAYORDER"]), "ORA_JSIS" ); _qv.ChildTables = new List <MD_ViewTable>(); DataRow[] _childTableRows = _ds.Tables["MD_VIEWTABLE"].Select(string.Format("VIEWID='{0}'", _oldid)); foreach (DataRow _ctRow in _childTableRows) { string _oldVTid = _ctRow["VTID"].ToString(); string _newVTid = GetNewID(_oldVTid, "MD_VIEWTABLE", "VTID", _mdc); string _newTid = IDTable[_ctRow["TID"].ToString()]; this.IDTable.Add(_oldVTid, _newVTid); int _displayType = 0; if (_ds.Tables["MD_VIEWTABLE"].Columns.Contains("DISPLAYTYPE")) { _displayType = _ctRow.IsNull("DISPLAYTYPE") ? 0 : Convert.ToInt32(_ctRow["DISPLAYTYPE"]); } string _intApp = ""; if (_ds.Tables["MD_VIEWTABLE"].Columns.Contains("INTEGRATEDAPP")) { _intApp = _ctRow.IsNull("INTEGRATEDAPP") ? "" : _ctRow["INTEGRATEDAPP"].ToString(); } MD_ViewTable _vt = new MD_ViewTable( _newVTid, _newid, _newTid, _ctRow["TABLETYPE"].ToString(), _ctRow.IsNull("TABLERELATION") ? "" : _ctRow["TABLERELATION"].ToString(), _ctRow.IsNull("CANCONDITION") ? "" : _ctRow["CANCONDITION"].ToString(), _ctRow.IsNull("DISPLAYNAME") ? "" : _ctRow["DISPLAYNAME"].ToString(), _ctRow.IsNull("DISPLAYORDER") ? 0 : Convert.ToInt32(_ctRow["DISPLAYORDER"]), _ns.DWDM, _ctRow.IsNull("FATHERID") ? "" : _ctRow["FATHERID"].ToString(), 0, _displayType, _intApp ); _qv.ChildTables.Add(_vt); _vt.Columns = new List <MD_ViewTableColumn>(); DataRow[] _vtRows = _ds.Tables["MD_VIEWTABLECOLUMN"].Select(string.Format("VTID='{0}'", _oldVTid)); foreach (DataRow _vtRow in _vtRows) { string _oldVTCid = _vtRow["VTCID"].ToString(); string _newVTCid = GetNewID(_oldVTCid, "MD_VIEWTABLECOLUMN", "VTCID", _mdc); string _newTCid = IDTable[_vtRow["TCID"].ToString()]; MD_ViewTableColumn _vtc = new MD_ViewTableColumn( _newVTCid, _newVTid, _newTCid, _vtRow.IsNull("CANCONDITIONSHOW") ? false : ((decimal)_vtRow["CANCONDITIONSHOW"] > 0), _vtRow.IsNull("CANRESULTSHOW") ? false : ((decimal)_vtRow["CANRESULTSHOW"] > 0), _vtRow.IsNull("DEFAULTSHOW") ? false : ((decimal)_vtRow["DEFAULTSHOW"] > 0), _vtRow.IsNull("FIXQUERYITEM") ? false : ((decimal)_vtRow["FIXQUERYITEM"] > 0), _vtRow.IsNull("CANMODIFY") ? false : ((decimal)_vtRow["CANMODIFY"] > 0), _ns.DWDM, 0, 0 ); _vt.Columns.Add(_vtc); } } _mdc.ImportQueryModelDefine(_qv); } } }
public Dialog_AddView2GL(MD_QueryModel _qv) { InitializeComponent(); QueryModel = _qv; this.uC_View2GLInfo1.V2GID = Guid.NewGuid().ToString(); }
public bool ImportQueryModelDefine(MD_QueryModel _qv) { return(MetaDataFactroy.ImportQueryModelDefine(_qv)); }
public IList <MD_ViewTable> GetChildTableOfQueryModel(MD_QueryModel _queryModel) { return(MetaDataFactroy.GetChildTableOfQueryModel(_queryModel)); }
private void LoadChildData(TreeListNode _fnode, object _value) { using (MetaDataServiceClient _mdc = new MetaDataServiceClient()) { MD_Title _mt; MD_Namespace _ns; if (_value is MD_Nodes) { _fnode.Nodes.Clear(); MD_Nodes _node = _value as MD_Nodes; IList <MD_Namespace> _namespaces = _mdc.GetNameSpaceAtNode(_node.DWDM); if (_node.NameSpaces == null) { _node.NameSpaces = new List <MD_Namespace>(); } foreach (MD_Namespace _space in _namespaces) { TreeListNode _newnode = treeList1.AppendNode(null, _fnode); _newnode.SetValue(this.treeListColumn1, _space); _newnode.ImageIndex = 1; _newnode.SelectImageIndex = 0; _newnode.HasChildren = true; _node.NameSpaces.Add(_space); } _mt = new MD_Title("菜单定义", "MD_MENU", _node); TreeListNode _newnode2 = treeList1.AppendNode(null, _fnode); _newnode2.SetValue(this.treeListColumn1, _mt); _newnode2.ImageIndex = 1; _newnode2.SelectImageIndex = 0; _newnode2.HasChildren = true; } if (_value is MD_Namespace) { _fnode.Nodes.Clear(); _ns = _value as MD_Namespace; _mt = new MD_Title("数据表", "MD_TABLE", _ns); TreeListNode _newnode = treeList1.AppendNode(null, _fnode); _newnode.SetValue(this.treeListColumn1, _mt); _newnode.ImageIndex = 1; _newnode.SelectImageIndex = 0; _newnode.HasChildren = true; _mt = new MD_Title("查询模型", "MD_QUERYMODEL", _ns); _newnode = treeList1.AppendNode(null, _fnode); _newnode.ImageIndex = 1; _newnode.SelectImageIndex = 0; _newnode.SetValue(this.treeListColumn1, _mt); _newnode.HasChildren = true; _mt = new MD_Title("代码表", "MD_REFTABLE", _ns); _newnode = treeList1.AppendNode(null, _fnode); _newnode.ImageIndex = 1; _newnode.SelectImageIndex = 0; _newnode.SetValue(this.treeListColumn1, _mt); _newnode.HasChildren = true; } if (_value is MD_Title) { _fnode.Nodes.Clear(); MD_Title _mdtitle = _value as MD_Title; switch (_mdtitle.TitleType) { case "MD_TABLE": _ns = (MD_Namespace)_mdtitle.FatherObj; IList <MD_Table> _tables = _mdc.GetTablesAtNamespace(_ns.NameSpace); if (_ns.TableList == null) { _ns.TableList = new List <MD_Table>(); } foreach (MD_Table _tb in _tables) { TreeListNode _newnode = treeList1.AppendNode(null, _fnode); _newnode.SetValue(this.treeListColumn1, _tb); _newnode.HasChildren = true; _newnode.ImageIndex = 2; _newnode.SelectImageIndex = 0; _ns.TableList.Add(_tb); _tb.NamespaceName = _ns.NameSpace; } break; case "MD_QUERYMODEL": _ns = (MD_Namespace)_mdtitle.FatherObj; IList <MD_QueryModel> _models = _mdc.GetQueryModelAtNamespace(_ns.NameSpace); if (_ns.QueryModelList == null) { _ns.QueryModelList = new List <MD_QueryModel>(); } foreach (MD_QueryModel _model in _models) { TreeListNode _newnode = treeList1.AppendNode(null, _fnode); _newnode.SetValue(this.treeListColumn1, _model); _newnode.ImageIndex = 1; _newnode.SelectImageIndex = 0; _newnode.HasChildren = true; _ns.QueryModelList.Add(_model); _model.Namespace = _ns; } break; case "MD_REFTABLE": _ns = (MD_Namespace)_mdtitle.FatherObj; IList <MD_RefTable> _refTables = _mdc.GetRefTableAtNamespace(_ns.NameSpace); if (_ns.RefTableList == null) { _ns.RefTableList = new List <MD_RefTable>(); } foreach (MD_RefTable _rt in _refTables) { TreeListNode _newnode = treeList1.AppendNode(null, _fnode); _newnode.SetValue(this.treeListColumn1, _rt); _newnode.ImageIndex = 2; _newnode.SelectImageIndex = 0; _newnode.HasChildren = false; _ns.RefTableList.Add(_rt); _rt.Namespace = _ns; } break; case "MD_MENU": MD_Nodes _node = (MD_Nodes)_mdtitle.FatherObj; IList <MD_Menu> _menuTable = _mdc.GetMenuDefineOfNode(_node.DWDM); foreach (MD_Menu _menu in _menuTable) { TreeListNode _newnode = treeList1.AppendNode(null, _fnode); _newnode.SetValue(this.treeListColumn1, _menu); if (_menu.MenuType.Length > 3 && _menu.MenuType.Substring(0, 3) == "WEB") { _newnode.ImageIndex = 4; _newnode.SelectImageIndex = 0; } else if (_menu.MenuType.Length > 3 && _menu.MenuType.Substring(0, 3) == "SL_") { _newnode.ImageIndex = 5; _newnode.SelectImageIndex = 0; } else { _newnode.ImageIndex = 2; _newnode.SelectImageIndex = 0; } _newnode.HasChildren = true; _menu.NodeID = _node.ID; _menu.MD_Nodes = _node; } break; case "MD_CONCEPTGROUP": InitConceptGroup(_fnode); break; case "MD_VIEW_GUIDELINE": InitView2GuideLine(_fnode, (MD_QueryModel)_mdtitle.FatherObj); break; case "MD_VIEW_APPLICATION": InitView2Application(_fnode, (MD_QueryModel)_mdtitle.FatherObj); break; case "MD_VIEW_EXRIGHT": InitViewExRight(_fnode, (MD_QueryModel)_mdtitle.FatherObj); break; } } if (_value is MD_QueryModel_ExRight) { _fnode.Nodes.Clear(); MD_QueryModel_ExRight _fright = _value as MD_QueryModel_ExRight; IList <MD_QueryModel_ExRight> _erList = _mdc.GetQueryModelExRights(_fright.ModelID, _fright.ID); foreach (MD_QueryModel_ExRight _right in _erList) { TreeListNode _node = treeList1.AppendNode(null, _fnode); _node.ImageIndex = 1; _node.SelectImageIndex = 0; _node.SetValue(this.treeListColumn1, _right); _node.HasChildren = true; } } if (_value is MD_QueryModel) { _fnode.Nodes.Clear(); MD_QueryModel _qm = _value as MD_QueryModel; MD_ViewTable _mainTable = _mdc.GetMainTableOfQueryModel(_qm.QueryModelID); if (_mainTable != null) { TreeListNode _newnode = treeList1.AppendNode(null, _fnode); _newnode.SetValue(this.treeListColumn1, _mainTable); _newnode.ImageIndex = 2; _newnode.SelectImageIndex = 0; _newnode.HasChildren = true; _mainTable.QueryModelID = _qm.QueryModelID; _qm.MainTable = _mainTable; } List <MD_View2ViewGroup> _v2vGroup = _mdc.GetView2ViewGroupOfQueryModel(_qm.QueryModelID).ToList <MD_View2ViewGroup>(); if (_v2vGroup != null && _v2vGroup.Count > 0) { foreach (MD_View2ViewGroup _g in _v2vGroup) { TreeListNode _newnode = treeList1.AppendNode(null, _fnode); _newnode.SetValue(this.treeListColumn1, _g); _newnode.ImageIndex = 3; _newnode.SelectImageIndex = 0; _newnode.HasChildren = true; _g.QueryModelID = _qm.QueryModelID; } } _mt = new MD_Title("关联数据指标", "MD_VIEW_GUIDELINE", _qm); TreeListNode _newqxnode2 = treeList1.AppendNode(null, _fnode); _newqxnode2.ImageIndex = 8; _newqxnode2.SelectImageIndex = 0; _newqxnode2.SetValue(this.treeListColumn1, _mt); _newqxnode2.HasChildren = true; _mt = new MD_Title("集成应用展示", "MD_VIEW_APPLICATION", _qm); TreeListNode _newAppnode = treeList1.AppendNode(null, _fnode); _newAppnode.ImageIndex = 8; _newAppnode.SelectImageIndex = 0; _newAppnode.SetValue(this.treeListColumn1, _mt); _newAppnode.HasChildren = true; _mt = new MD_Title("扩展权限定义", "MD_VIEW_EXRIGHT", _qm); TreeListNode _newqxnode = treeList1.AppendNode(null, _fnode); _newqxnode.ImageIndex = 6; _newqxnode.SelectImageIndex = 0; _newqxnode.SetValue(this.treeListColumn1, _mt); _newqxnode.HasChildren = true; } if (_value is MD_View2ViewGroup) { _fnode.Nodes.Clear(); MD_View2ViewGroup _v2vg = _value as MD_View2ViewGroup; List <MD_View2View> _v2vs = _mdc.GetView2ViewList(_v2vg.ID, _v2vg.QueryModelID).ToList <MD_View2View>(); if (_v2vs != null) { foreach (MD_View2View _v in _v2vs) { TreeListNode _newnode = treeList1.AppendNode(null, _fnode); _v.QueryModelID = _v2vg.QueryModelID; _v.ViewGroupID = _v2vg.ID; _newnode.SetValue(this.treeListColumn1, _v); _newnode.ImageIndex = 2; _newnode.SelectImageIndex = 0; _newnode.HasChildren = true; } } } if (_value is MD_Table) { _fnode.Nodes.Clear(); MD_Table _tb = _value as MD_Table; List <MD_Table2View> _t2vs = _mdc.GetTable2ViewList(_tb.TID).ToList <MD_Table2View>(); if (_t2vs != null) { foreach (MD_Table2View _t2v in _t2vs) { TreeListNode _newnode = treeList1.AppendNode(null, _fnode); _newnode.SetValue(this.treeListColumn1, _t2v); _newnode.ImageIndex = 2; _newnode.SelectImageIndex = 0; _newnode.HasChildren = true; } } } if (_value is MD_ViewTable) { _fnode.Nodes.Clear(); MD_ViewTable _vt = _value as MD_ViewTable; if (_vt.ViewTableType == MDType_ViewTable.MainTable) { MetaDataServiceClient _msc = new MetaDataServiceClient(); IList <MD_ViewTable> _childTables = _msc.GetChildTableOfQueryModel(_vt.QueryModelID); foreach (MD_ViewTable _cvt in _childTables) { TreeListNode _newnode = treeList1.AppendNode(null, _fnode); _newnode.SetValue(this.treeListColumn1, _cvt); _newnode.ImageIndex = 2; _newnode.SelectImageIndex = 0; _newnode.HasChildren = true; _cvt.QueryModelID = _vt.QueryModelID; } } } if (_value is MD_Menu) { MD_Menu _fmenu = _value as MD_Menu; IList <MD_Menu> _menuTable = _mdc.GetSubMenuDefine(_fmenu.MenuID); foreach (MD_Menu _menu in _menuTable) { TreeListNode _newnode = treeList1.AppendNode(null, _fnode); _newnode.SetValue(this.treeListColumn1, _menu); if (_menu.MenuType.Length > 3 && _menu.MenuType.Substring(0, 3) == "WEB") { _newnode.ImageIndex = 4; _newnode.SelectImageIndex = 0; } else if (_menu.MenuType.Length > 3 && _menu.MenuType.Substring(0, 3) == "SL_") { _newnode.ImageIndex = 5; _newnode.SelectImageIndex = 0; } else { _newnode.ImageIndex = 2; _newnode.SelectImageIndex = 0; } _newnode.HasChildren = true; _menu.NodeID = _fmenu.MD_Nodes.ID; _menu.MD_Nodes = _fmenu.MD_Nodes; } } if (_value is MD_ConceptGroup) { MD_ConceptGroup _cGroup = _value as MD_ConceptGroup; List <MD_ConceptItem> _itemDefines = _mdc.GetSubConceptTagDefine(_cGroup.Name).ToList <MD_ConceptItem>(); _cGroup.Items = _itemDefines; _fnode.Nodes.Clear(); foreach (MD_ConceptItem _item in _itemDefines) { TreeListNode _newnode = treeList1.AppendNode(null, _fnode); _newnode.SetValue(this.treeListColumn1, _item); _newnode.HasChildren = false; } } } }
public MD_ViewTable GetMainTableOfQueryModel(MD_QueryModel _qm) { return(MetaDataFactroy.GetMainTableOfQueryModel(_qm)); }
/// <summary> /// 建立查询模型 /// </summary> /// <param name="_queryModel"></param> /// <returns></returns> public static MDModel_QueryModel CreateQuery_ModelDefine(MD_QueryModel _queryModel) { //通过查询模型的基础定义建立查询时模型定义 MDModel_QueryModel _ret = new MDModel_QueryModel(); _ret.NameSpaceName = _queryModel.NamespaceName; _ret.QueryModelName = _queryModel.QueryModelName; _ret.FullQueryModelName = _queryModel.FullName; _ret.QueryInterface = _queryModel.QueryInterface; _ret.DisplayName = _queryModel.DisplayTitle; MDModel_Table _mtable = new MDModel_Table(_queryModel.QueryModelName, _queryModel.QueryModelID, _queryModel.MainTable); _ret.MainTable = _mtable; _ret.ChildTables = new List <MDModel_Table>(); _ret.ChildTableDict = new Dictionary <string, MDModel_Table>(); foreach (MD_ViewTable _ctable in _queryModel.ChildTables) { MDModel_Table _ct = new MDModel_Table(_queryModel.QueryModelName, _queryModel.QueryModelID, _ctable); _ret.ChildTables.Add(_ct); _ret.ChildTableDict.Add(_ct.TableName, _ct); } //重建字段的别名 int _aliasIndex = 0; _ret.MainTable.AliasDict = new Dictionary <string, MDModel_Table_Column>(); foreach (MDModel_Table_Column _mtc in _ret.MainTable.Columns) { string _aliasName = "A" + _aliasIndex.ToString(); _mtc.ColumnAlias = _aliasName; _aliasIndex++; _ret.MainTable.AliasDict.Add(_aliasName, _mtc); } foreach (MDModel_Table _ctable in _ret.ChildTableDict.Values) { int _childIndex = 0; int _cIndex = _childIndex; if (_ctable.TableDefine.ViewTableRelationType == MDType_ViewTableRelation.SingleChildRecord) { _cIndex = _aliasIndex; } else { _cIndex = _childIndex; } _ctable.AliasDict = new Dictionary <string, MDModel_Table_Column>(); foreach (MDModel_Table_Column _mtc in _ctable.Columns) { string _aliasName = "A" + _cIndex.ToString(); _cIndex++; _mtc.ColumnAlias = _aliasName; _ctable.AliasDict.Add(_aliasName, _mtc); } if (_ctable.TableDefine.ViewTableRelationType == MDType_ViewTableRelation.SingleChildRecord) { _aliasIndex = _cIndex; } } return(_ret); }
public MD_QueryModel SaveData() { _model = this.queryModelManager1.SaveNew(); return(_model); }