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