private void barButtonItem1_ItemClick(object sender, ItemClickEventArgs e) { object _selectedObj = FocusedItem; if (_selectedObj is MD_Namespace) { MD_Namespace _ns = _selectedObj as MD_Namespace; MD_InputModel _model = MenuController.AddInputModel(_ns); if (treeList1.FocusedNode != null && _model != null) { if (treeList1.FocusedNode.Nodes.Count > 0) { TreeListNode _node = treeList1.AppendNode(null, treeList1.FocusedNode); _node.SetValue(this.treeListColumn1, _model); _node.HasChildren = true; _node.ImageIndex = 3; _node.SelectImageIndex = 0; } else { treeList1.FocusedNode.HasChildren = true; } } } }
/// <summary> /// 修改命名空间 /// </summary> /// <param name="_ns"></param> /// <returns></returns> public static bool UpdateNameSapce(MD_Namespace nameSpace) { StringBuilder _sb = new StringBuilder(); _sb.Append("update MD_TBNAMESPACE set DESCRIPTION = @DESCRIPTION,MENUPOSITION=@MENUPOSTION,"); _sb.Append(" DISPLAYTITLE = @DISPLAYTITLE,OWNER = @OWNER,DISPLAYORDER =@DISPLAYORDER,DWDM =@DWDM,CONCEPTS =@CONCEPTS "); _sb.Append(" where NAMESPACE =@NAMESPACE"); SqlParameter[] _param = { new SqlParameter("@DESCRIPTION", SqlDbType.NVarChar, 100), new SqlParameter("@MENUPOSTION", SqlDbType.NVarChar, 50), new SqlParameter("@DISPLAYTITLE", SqlDbType.NVarChar, 50), new SqlParameter("@OWNER", SqlDbType.NVarChar, 50), new SqlParameter("@DISPLAYORDER", SqlDbType.Decimal), new SqlParameter("@DWDM", SqlDbType.NVarChar, 12), new SqlParameter("@CONCEPTS", SqlDbType.NVarChar, 1000), new SqlParameter("@NAMESPACE", SqlDbType.NVarChar, 50) }; _param[0].Value = nameSpace.Description; _param[1].Value = nameSpace.MenuPosition; _param[2].Value = nameSpace.DisplayTitle; _param[3].Value = nameSpace.Owner; _param[4].Value = nameSpace.DisplayOrder; _param[5].Value = nameSpace.DWDM; _param[6].Value = nameSpace.Concepts; _param[7].Value = nameSpace.NameSpace; SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringProfile, CommandType.Text, _sb.ToString(), _param); return(true); }
private void WriteTableDefine_New(MD_Namespace _ns) { using (MetaDataServiceClient _mdc = new MetaDataServiceClient()) { foreach (MD_Table _table in _ns.TableList) { try { this.label2.Text = string.Format("写入表{0}的定义 ....", _table.TableName); Application.DoEvents(); string _newid = GetNewID(_table.TID, "MD_TABLE", "TID", _mdc); string _oldid = _table.TID; IDTable.Add(_oldid, _newid); _table.TID = _newid; _table.NamespaceName = _ns.NameSpace; _table.DWDM = _ns.DWDM; foreach (MD_TableColumn _tc in _table.Columns) { string _newcolumnid = GetNewID(_tc.ColumnID, "MD_TABLECOLUMN", "TCID", _mdc); IDTable.Add(_tc.ColumnID, _newcolumnid); _tc.ColumnID = _newcolumnid; _tc.DWDM = _ns.DWDM; _tc.TID = _table.TID; } _mdc.ImportTableDefine(_table); } catch (Exception ex) { XtraMessageBox.Show(string.Format("导入表{0}时失败!{1}", _table.TableName, ex.Message), "系统提示"); break; } } } }
/// <summary> /// 添加新的命名空间 /// </summary> /// <param name="_ns"></param> /// <returns></returns> public static bool AddNewNameSapce(MD_Namespace _ns) { StringBuilder _sb = new StringBuilder(); _sb.Append("insert into MD_TBNAMESPACE (NAMESPACE,DESCRIPTION,MENUPOSITION,DISPLAYTITLE,OWNER,DISPLAYORDER,DWDM,CONCEPTS) "); _sb.Append(" values (@NAMESPACE,@DESCRIPTION,@MENUPOSITION,@DISPLAYTITLE,@OWNER,@DISPLAYORDER,@DWDM,@CONCEPTS) "); SqlParameter[] _param = { new SqlParameter("@NAMESPACE", SqlDbType.NVarChar, 50), new SqlParameter("@DESCRIPTION", SqlDbType.NVarChar, 100), new SqlParameter("@MENUPOSITION", SqlDbType.NVarChar, 50), new SqlParameter("@DISPLAYTITLE", SqlDbType.NVarChar, 50), new SqlParameter("@OWNER", SqlDbType.NVarChar, 50), new SqlParameter("@DISPLAYORDER", SqlDbType.Decimal), new SqlParameter("@DWDM", SqlDbType.NVarChar, 12), new SqlParameter("@CONCEPTS", SqlDbType.NVarChar, 1000) }; _param[0].Value = _ns.NameSpace; _param[1].Value = _ns.Description; _param[2].Value = _ns.MenuPosition; _param[3].Value = _ns.DisplayTitle; _param[4].Value = _ns.Owner; _param[5].Value = _ns.DisplayOrder; _param[6].Value = _ns.DWDM; _param[7].Value = _ns.Concepts; SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringProfile, CommandType.Text, _sb.ToString(), _param); return(true); }
private void WriteRefCodeDefine(string _oldNameSpace, MD_Namespace _ns, DataSet _ds) { using (MetaDataServiceClient _mdc = new MetaDataServiceClient()) { DataRow[] _refRows = _ds.Tables["MD_REFTABLELIST"].Select(string.Format("NAMESPACE='{0}'", _oldNameSpace)); foreach (DataRow _dr in _refRows) { string _oldid = _dr["RTID"].ToString(); string _newid = GetNewID(_oldid, "MD_REFTABLELIST", "RTID", _mdc); this.IDTable.Add(_oldid, _newid); MD_RefTable _rt = new MD_RefTable( _newid, _ns.NameSpace, _dr.IsNull("REFTABLENAME") ? "" : _dr["REFTABLENAME"].ToString(), _dr.IsNull("REFTABLELEVELFORMAT") ? "" : _dr["REFTABLELEVELFORMAT"].ToString(), _dr.IsNull("DESCRIPTION") ? "" : _dr["DESCRIPTION"].ToString(), _ns.DWDM, _dr.IsNull("DOWNLOADMODE") ? 1 : Convert.ToInt32(_dr["DOWNLOADMODE"]), _dr.IsNull("REFTABLEMODE") ? 1 : Convert.ToInt32(_dr["REFTABLEMODE"]), false ); _mdc.ImportRefTableDefine(_rt); } } }
public void WriteExportFile(MD_Namespace Namespace) { DataContractSerializer s = new DataContractSerializer(typeof(MD_Namespace)); using (FileStream fs = File.Open(this.te_File.EditValue.ToString(), FileMode.Create)) { s.WriteObject(fs, Namespace); } }
public bool SaveNewRefTable(DB_TableMeta TableMeta, MD_Namespace Namespace) { try { OraMetaDataFactroy _of = new OraMetaDataFactroy(); return(_of.SaveNewRefTable(TableMeta, Namespace)); } catch (Exception ex) { throw new FaultException(ex.Message); } }
public bool SaveNewNameSapce(MD_Namespace Namespace) { try { OraMetaDataFactroy _of = new OraMetaDataFactroy(); return(_of.SaveNewNameSapce(Namespace)); } catch (Exception ex) { throw new FaultException(ex.Message); } }
public static MD_InputModel AddInputModel(MD_Namespace _ns) { Dialog_AddInputModel _f = new Dialog_AddInputModel(_ns); if (_f.ShowDialog() == DialogResult.OK) { return(_f.NewInputModel()); } else { return(null); } }
private void LoadInputViewOfNamespace(TreeListNode _fnode, MD_Namespace _ns) { _fnode.Nodes.Clear(); IList <MD_InputModel> _models = DAConfig.DataAccess.GetInputModelOfNamespace(_ns.NameSpace); foreach (MD_InputModel _inputModel in _models) { TreeListNode _node = treeList1.AppendNode(null, _fnode); _node.SetValue(this.treeListColumn1, _inputModel); _node.HasChildren = true; _node.ImageIndex = 3; _node.SelectImageIndex = 0; } }
private void WriteRefTable_New(MD_Namespace _ns) { using (MetaDataServiceClient _mdc = new MetaDataServiceClient()) { foreach (MD_RefTable _rt in _ns.RefTableList) { this.label2.Text = string.Format("写入代码表[{0}]的定义 ....", _rt.RefTableName); Application.DoEvents(); string _newid = GetNewID(_rt.RefTableID, "MD_REFTABLELIST", "RTID", _mdc); _rt.RefTableID = _newid; _rt.NamespaceName = _ns.NameSpace; _rt.DWDM = _ns.DWDM; _mdc.ImportRefTableDefine(_rt); } } }
//保存新 public void SaveNew(MD_Nodes _nodes) { MD_Namespace _ns = new MD_Namespace(); _ns.NameSpace = this.TE_NAMESPACE.EditValue.ToString(); _ns.Description = this.TE_DESCRIPT.EditValue.ToString(); _ns.MenuPosition = (this.TE_MENU.EditValue == null) ? "" : this.TE_MENU.EditValue.ToString(); _ns.DisplayTitle = this.TE_DISPLAY.EditValue.ToString(); _ns.Owner = this.TE_OWNER.EditValue.ToString(); _ns.DisplayOrder = this.TE_ORDER.EditValue.ToString() == "" ? 0 : int.Parse(this.TE_ORDER.EditValue.ToString()); _ns.DWDM = this.TE_DWDM.EditValue.ToString(); _ns.Concepts = this.TE_CONCEPTS.EditValue.ToString(); _ns.Nodes = _nodes; using (MetaDataServiceClient _mdc = new MetaDataServiceClient()) { _mdc.SaveNewNameSapce(_ns); } }
private void ChangedID(MD_Namespace _ns) { IDTable.Clear(); this.label2.Text = "写入命名空间定义 ...."; Application.DoEvents(); MD_Namespace _newns = new MD_Namespace(); _newns.NameSpace = _ns.NameSpace; _newns.Description = _ns.Description; _newns.MenuPosition = _ns.MenuPosition; _newns.DisplayTitle = _ns.DisplayTitle; _newns.Owner = "ZHTJ"; _newns.DisplayOrder = _ns.DisplayOrder; _newns.Concepts = _ns.Concepts; _newns.Nodes = CurrentNode; _newns.DWDM = CurrentNode.DWDM; using (MetaDataServiceClient _mdc = new MetaDataServiceClient()) { _mdc.SaveNewNameSapce(_newns); } _ns.DWDM = CurrentNode.DWDM; _ns.Nodes = CurrentNode; this.label2.Text = "写入表定义 ...."; Application.DoEvents(); WriteTableDefine_New(_ns); this.label2.Text = "写入查询模型定义 ...."; Application.DoEvents(); WriteModelDefine_New(_ns); this.label2.Text = "写入代码表定义 ...."; Application.DoEvents(); WriteRefTable_New(_ns); this.label2.Text = "导入完成 ...."; Application.DoEvents(); XtraMessageBox.Show("导入成功!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.DialogResult = DialogResult.OK; this.Close(); }
/// <summary> /// 导入录入模型 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void bt_ImportModel_ItemClick(object sender, ItemClickEventArgs e) { object _selectedObj = FocusedItem; if (_selectedObj is MD_Namespace) { MD_Namespace _ns = _selectedObj as MD_Namespace; OpenFileDialog _sf = new OpenFileDialog(); _sf.Filter = "备份文件|*.XML"; _sf.FilterIndex = 1; if (_sf.ShowDialog() == DialogResult.OK) { ImportInputModelController _ic = new ImportInputModelController(_sf.FileName, _ns); try { _ic.Import(); XtraMessageBox.Show("导入成功!", "系统提示"); OraMetaDataFactroy _of = new OraMetaDataFactroy(); MD_InputModel _model = _of.GetInputModel(_ns.NameSpace, _ic.ModelName); if (treeList1.FocusedNode != null && _model != null) { if (treeList1.FocusedNode.Nodes.Count > 0) { TreeListNode _node = treeList1.AppendNode(null, treeList1.FocusedNode); _node.SetValue(this.treeListColumn1, _model); _node.HasChildren = true; _node.ImageIndex = 3; _node.SelectImageIndex = 0; } else { treeList1.FocusedNode.HasChildren = true; } } } catch (Exception ex) { XtraMessageBox.Show(ex.Message, "导入失败"); } } } }
private void WriteNamespace(DataTable _dt, DataSet _ds) { using (MetaDataServiceClient _mdc = new MetaDataServiceClient()) { IDTable.Clear(); if (_dt.Rows.Count > 0) { foreach (DataRow _dr in _dt.Rows) { this.label2.Text = "写入命名空间定义 ...."; Application.DoEvents(); string _oldNameSpace = _dr["NAMESPACE"].ToString(); string _NewNamespace = (this.TE_NEWNAME.EditValue == null || this.TE_NEWNAME.EditValue == "") ? _oldNameSpace : this.TE_NEWNAME.EditValue.ToString(); MD_Namespace _ns = new MD_Namespace(); _ns.NameSpace = _NewNamespace; _ns.Description = _dr["DESCRIPTION"].ToString(); _ns.MenuPosition = _dr["MENUPOSITION"].ToString(); _ns.DisplayTitle = _dr["DISPLAYTITLE"].ToString(); _ns.Owner = _dr["OWNER"].ToString(); _ns.DisplayOrder = _dr.IsNull("DISPLAYORDER") ? 0 : Convert.ToInt32(_dr["DISPLAYORDER"]); _ns.Concepts = _dr["CONCEPTS"].ToString(); _ns.Nodes = CurrentNode; _ns.DWDM = CurrentNode.DWDM; _mdc.SaveNewNameSapce(_ns); this.label2.Text = "写入表定义 ...."; Application.DoEvents(); WriteTableDefine(_oldNameSpace, _ns, _ds); this.label2.Text = "写入查询模型定义 ...."; Application.DoEvents(); WriteModelDefine(_oldNameSpace, _ns, _ds); this.label2.Text = "写入代码表定义 ...."; Application.DoEvents(); WriteRefCodeDefine(_oldNameSpace, _ns, _ds); } } } }
private void LoadChildData(TreeListNode _fnode, object _value) { if (_value is MD_Nodes) { MD_Nodes _nodes = _value as MD_Nodes; LoadNamespaceOfNodes(_fnode, _nodes); } if (_value is MD_Namespace) { MD_Namespace _ns = _value as MD_Namespace; LoadInputViewOfNamespace(_fnode, _ns); } if (_value is MD_InputModel) { MD_InputModel _model = _value as MD_InputModel; LoadInputModelDetial(_fnode, _model); } if (_value is MD_Title) { MD_Title _title = _value as MD_Title; switch (_title.TitleType) { case "MD_INPUTCOLUMES": LoadInputModelColumnGroup(_fnode, _title.FatherObj as MD_InputModel); break; case "MD_SAVEDEFINE": Load_SaveDesTables(_fnode, _title.FatherObj as MD_InputModel); break; case "MD_CHILDDEFINE": Load_ChildModel(_fnode, _title.FatherObj as MD_InputModel); break; } } }
/// <summary> /// 删除命名空间 /// </summary> /// <param name="_ns"></param> /// <returns></returns> public static bool DelelteNamespace(MD_Namespace _ns) { using (SqlConnection cn = SqlHelper.OpenConnection()) { SqlTransaction txn = cn.BeginTransaction(); try { SqlParameter[] _param = { new SqlParameter("@NAMESPACE", SqlDbType.NVarChar, 100) }; _param[0].Value = _ns.NameSpace; SqlHelper.ExecuteNonQuery(cn, CommandType.Text, SqlDeleteNamespace, _param); txn.Commit(); return(true); } catch (Exception ex) { txn.Rollback(); return(false); } } }
private void WriteModelDefine_New(MD_Namespace _ns) { using (MetaDataServiceClient _mdc = new MetaDataServiceClient()) { foreach (MD_QueryModel _qv in _ns.QueryModelList) { this.label2.Text = string.Format("写入查询模型[{0}]的定义 ....", _qv.QueryModelName); Application.DoEvents(); _qv.NamespaceName = _ns.NameSpace; string _newid = GetNewID(_qv.QueryModelID, "MD_VIEW", "VIEWID", _mdc); try { IDTable.Add(_qv.QueryModelID, _newid); } catch (Exception e) { throw e; } _qv.QueryModelID = _newid; _qv.DWDM = _ns.DWDM; //处理主表 MD_ViewTable _mainTable = _qv.MainTable; string old_fid = ""; if (_mainTable != null) { old_fid = _mainTable.ViewTableID; try { ChangeTableID(_mainTable, _qv, _mdc); } catch (Exception e) { throw e; } } List <MD_ViewTable> _newTables = new List <MD_ViewTable>(); //处理子表 foreach (MD_ViewTable _vTable in _qv.ChildTables) { try { _vTable.FatherTableID = old_fid; ChangeTableID(_vTable, _qv, _mdc); _newTables.Add(_vTable); } catch (Exception e) { throw e; } } _newTables.Add(_qv.MainTable); _qv.ChildTables = _newTables; //处理关联表 if (_qv.View2ViewGroup != null) { foreach (MD_View2ViewGroup _group in _qv.View2ViewGroup) { ChangeView2ViewGroupID(_group, _qv, _mdc); } } //处理关联指标 if (_qv.View2GuideLines != null) { foreach (MD_View_GuideLine _v2g in _qv.View2GuideLines) { ChangeView2GuideLineID(_v2g, _qv, _mdc); } } //处理关联注册应用 if (_qv.View2Application != null) { foreach (MD_View2App _v2a in _qv.View2Application) { ChangeView2AppID(_v2a, _qv, _mdc); } } bool _ret = _mdc.ImportQueryModelDefine(_qv); if (!_ret) { MessageBox.Show("导入失败!", "系统提示"); } } } }
public Dialog_ExportNamespace(MD_Namespace _ns) { InitializeComponent(); Namespace = _ns; this.panelWait.Visible = false; }
public bool SaveNewNameSapce(MD_Namespace _ns) { return(MetaDataFactroy.SaveNewNameSapce(_ns)); }
public bool SaveNewRefTable(DB_TableMeta _tm, MD_Namespace _namespace) { return(MetaDataFactroy.SaveNewRefTable(_tm, _namespace)); }
public IList <MD_RefTable> GetRefTableAtNamespace(MD_Namespace _ns) { return(MetaDataFactroy.GetRefTableAtNamespace(_ns)); }
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 async Task <bool> SaveNameSapce(MD_Namespace nspace) { var ret = await this.mdService.SaveNameSapce(nspace); return(ret); }
public Dialog_AddInputModel(MD_Namespace _ns) { InitializeComponent(); ns = _ns; }
public IList <MD_QueryModel> GetQueryModelAtNamespace(MD_Namespace _ns) { return(MetaDataFactroy.GetQueryModelAtNamespace(_ns)); }
private void WriteTableDefine(string _oldNameSpace, MD_Namespace _ns, DataSet _ds) { using (MetaDataServiceClient _mdc = new MetaDataServiceClient()) { DataRow[] _TableDefineRows = _ds.Tables["MD_TABLE"].Select(string.Format("NAMESPACE='{0}'", _oldNameSpace)); foreach (DataRow _dr in _TableDefineRows) { DB_TableMeta _tm = new DB_TableMeta(); _tm.TableName = _dr["TABLENAME"].ToString(); _tm.TableComment = _dr["DESCRIPTION"].ToString(); _tm.TableType = _dr["TABLETYPE"].ToString(); string _oldid = _dr["TID"].ToString(); string _newid = GetNewID(_oldid, "MD_TABLE", "TID", _mdc); this.IDTable.Add(_oldid, _newid); MD_Table _tableDefine = new MD_Table( _newid, _ns.NameSpace, _tm.TableName, _tm.TableType, _tm.TableComment, _dr.IsNull("DISPLAYNAME") ? "" : _dr["DISPLAYNAME"].ToString(), _dr.IsNull("MAINKEY") ? "" : _dr["MAINKEY"].ToString(), _ns.DWDM, _dr.IsNull("SECRETFUN") ? "" : _dr["SECRETFUN"].ToString(), _dr.IsNull("EXTSECRET") ? "" : _dr["EXTSECRET"].ToString() ); _tableDefine.Columns = new List <MD_TableColumn>(); DataRow[] _columnRow = _ds.Tables["MD_TABLECOLUMN"].Select(string.Format("TID={0}", _dr["TID"])); foreach (DataRow _dcrow in _columnRow) { string _oldTCid = _dcrow["TCID"].ToString(); string _newTCid = GetNewID(_oldTCid, "MD_TABLECOLUMN", "TCID", _mdc); try { this.IDTable.Add(_oldTCid, _newTCid); } catch (Exception e) { throw e; } MD_TableColumn _tc = new MD_TableColumn( _newTCid, _newid, _dcrow["COLUMNNAME"].ToString(), (_dcrow["ISNULLABLE"].ToString() == "Y"), _dcrow["TYPE"].ToString(), _dcrow.IsNull("PRECISION") ? 1 : Convert.ToInt32(_dcrow["PRECISION"]), _dcrow.IsNull("SCALE") ? 1 : Convert.ToInt32(_dcrow["SCALE"]), _dcrow.IsNull("LENGTH") ? 1 : Convert.ToInt32(_dcrow["LENGTH"]), _dcrow.IsNull("REFDMB") ? "" : _dcrow["REFDMB"].ToString(), _dcrow.IsNull("DMBLEVELFORMAT") ? "" : _dcrow["DMBLEVELFORMAT"].ToString(), _dcrow.IsNull("SECRETLEVEL") ? 0 : Convert.ToInt32(_dcrow["SECRETLEVEL"]), _dcrow.IsNull("DISPLAYTITLE") ? "" : _dcrow["DISPLAYTITLE"].ToString(), _dcrow.IsNull("DISPLAYFORMAT") ? "" : _dcrow["DISPLAYFORMAT"].ToString(), _dcrow.IsNull("DISPLAYLENGTH") ? 1 : Convert.ToInt32(_dcrow["DISPLAYLENGTH"]), _dcrow.IsNull("DISPLAYHEIGHT") ? 1 : Convert.ToInt32(_dcrow["DISPLAYHEIGHT"]), _dcrow.IsNull("DISPLAYORDER") ? 0 : Convert.ToInt32(_dcrow["DISPLAYORDER"]), _dcrow.IsNull("CANDISPLAY") ? true : ((decimal)_dcrow["CANDISPLAY"] > 0), _dcrow.IsNull("COLWIDTH") ? 1 : Convert.ToInt32(_dcrow["COLWIDTH"]), _ns.DWDM, _dcrow.IsNull("CTAG") ? "" : _dcrow["CTAG"].ToString(), "" ); _tableDefine.Columns.Add(_tc); } _mdc.ImportTableDefine(_tableDefine); } } }
public bool SaveNameSapce(MD_Namespace _Namespace) { return(MetaDataFactroy.SaveNameSapce(_Namespace)); }
public async Task <bool> DelNamespace(MD_Namespace nspace) { var ret = await this.mdService.DelNamespace(nspace); return(ret); }
public bool DelNamespace(MD_Namespace _ns) { return(MetaDataFactroy.DelNamespace(_ns)); }