public async Task <bool> AddMainTableToQueryModel(string queryModelID, MD_Table selectedTable)
{
var ret = await this.mdService.AddMainTableToQueryModel(queryModelID, selectedTable);
MyDA_MetaDataQuery.QueryModelCache.Clear();
return(ret);
}
public async Task <bool> SaveTableDefine(MD_Table table)
{
var ret = await this.mdService.SaveTableDefine(table);
MyDA_MetaDataQuery.QueryModelCache.Clear();
return(ret);
}
public bool ImportTableDefine(MD_Table TableDefine)
{
try
{
OraMetaDataFactroy _of = new OraMetaDataFactroy();
return(_of.ImportTableDefine(TableDefine));
}
catch (Exception ex)
{
throw new FaultException(ex.Message);
}
}
private void simpleButton2_Click(object sender, EventArgs e)
{
if (this.gridView1.SelectedRowsCount < 0)
{
XtraMessageBox.Show("请选择数据表!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
int[] _indexs = this.gridView1.GetSelectedRows();
_selectedTable = this.gridView1.GetRow(_indexs[0]) as MD_Table;
this.DialogResult = DialogResult.OK;
this.Close();
}
public bool AddMainTableToQueryModel(string QueryModelID, MD_Table SelectedTable)
{
try
{
OraMetaDataFactroy _of = new OraMetaDataFactroy();
return(_of.AddMainTableToQueryModel(QueryModelID, SelectedTable));
}
catch (Exception ex)
{
throw new FaultException(ex.Message);
}
}
public async Task <bool> ImportTableDefine(MD_Table table)
{
var ret = await this.mdService.ImportTableDefine(table);
return(ret);
}
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 ImportTableDefine(MD_Table _tableDefine)
{
return(MetaDataFactroy.ImportTableDefine(_tableDefine));
}
public bool AddChildTableToQueryModel(string _queryModelID, string _mainTableID, MD_Table _selectedTable)
{
return(MetaDataFactroy.AddChildTableToQueryModel(_queryModelID, _mainTableID, _selectedTable));
}
public bool SaveTableDefine(MD_Table _table)
{
return(MetaDataFactroy.SaveTableDefine(_table));
}
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 TableManager(MD_Table _tb)
{
InitializeComponent();
TableDefine = _tb;
_initFinished = true;
}
/// <summary>
/// 插入列定义
/// </summary>
/// <param name="_table"></param>
/// <param name="_tc"></param>
public static void InsertColumnDefine(MD_Table _table, MD_TableColumn _tc)
{
try
{
StringBuilder _sb_insert = new StringBuilder();
_sb_insert.Append(" insert into md_tablecolumn (TCID,TID,COLUMNNAME,");
_sb_insert.Append(" ISNULLABLE,TYPE,`PRECISION`,SCALE,");
_sb_insert.Append(" LENGTH,REFDMB,DMBLEVELFORMAT,SECRETLEVEL,");
_sb_insert.Append(" DISPLAYTITLE,DISPLAYFORMAT,DISPLAYLENGTH,DISPLAYHEIGHT,");
_sb_insert.Append(" DISPLAYORDER,CANDISPLAY,COLWIDTH,DWDM,");
_sb_insert.Append(" CTAG,REFWORDTB ) values ");
_sb_insert.Append(" (@TCID,@TID,@COLUMNNAME,");
_sb_insert.Append(" @ISNULLABLE,@TYPE,@PRECISION,@SCALE,");
_sb_insert.Append(" @LENGTH,@REFDMB,@DMBLEVELFORMAT,@SECRETLEVEL,");
_sb_insert.Append(" @DISPLAYTITLE,@DISPLAYFORMAT,@DISPLAYLENGTH,@DISPLAYHEIGHT,");
_sb_insert.Append(" @DISPLAYORDER,@CANDISPLAY,@COLWIDTH,@DWDM,");
_sb_insert.Append(" @CTAG,@REFWORDTB) ");
MySqlParameter[] _param3 =
{
new MySqlParameter("@TCID", MySqlDbType.Int64),
new MySqlParameter("@TID", MySqlDbType.Int64),
new MySqlParameter("@COLUMNNAME", MySqlDbType.VarChar, 50),
new MySqlParameter("@ISNULLABLE", MySqlDbType.VarChar, 100),
new MySqlParameter("@TYPE", MySqlDbType.VarChar, 20),
new MySqlParameter("@PRECISION", MySqlDbType.Int32),
new MySqlParameter("@SCALE", MySqlDbType.Int32),
new MySqlParameter("@LENGTH", MySqlDbType.Int32),
new MySqlParameter("@REFDMB", MySqlDbType.VarChar, 50),
new MySqlParameter("@DMBLEVELFORMAT", MySqlDbType.VarChar, 20),
new MySqlParameter("@SECRETLEVEL", MySqlDbType.Int32),
new MySqlParameter("@DISPLAYTITLE", MySqlDbType.VarChar, 50),
new MySqlParameter("@DISPLAYFORMAT", MySqlDbType.VarChar, 50),
new MySqlParameter("@DISPLAYLENGTH", MySqlDbType.Int32),
new MySqlParameter("@DISPLAYHEIGHT", MySqlDbType.Int32),
new MySqlParameter("@DISPLAYORDER", MySqlDbType.Int32),
new MySqlParameter("@CANDISPLAY", MySqlDbType.Int32),
new MySqlParameter("@COLWIDTH", MySqlDbType.Int32),
new MySqlParameter("@DWDM", MySqlDbType.VarChar, 20),
new MySqlParameter("@CTAG", MySqlDbType.VarChar, 500),
new MySqlParameter("@REFWORDTB", MySqlDbType.VarChar, 50)
};
_param3[0].Value = Convert.ToInt64(_tc.ColumnID);
_param3[1].Value = Convert.ToInt64(_table.TID);
_param3[2].Value = _tc.ColumnName;
_param3[3].Value = _tc.IsNullable ? "Y" : "N";
_param3[4].Value = _tc.ColumnType;
_param3[5].Value = Convert.ToInt32(_tc.Precision);
_param3[6].Value = Convert.ToInt32(_tc.Scale);
_param3[7].Value = Convert.ToInt32(_tc.Length);
_param3[8].Value = _tc.RefDMB;
_param3[9].Value = _tc.DMBLevelFormat;
_param3[10].Value = Convert.ToInt32(_tc.SecretLevel);
_param3[11].Value = _tc.DisplayTitle;
_param3[12].Value = _tc.DisplayFormat;
_param3[13].Value = Convert.ToInt32(_tc.DisplayLength);
_param3[14].Value = Convert.ToInt32(_tc.DisplayHeight);
_param3[15].Value = Convert.ToInt32(_tc.DisplayOrder);
_param3[16].Value = _tc.CanDisplay ? 1 : 0;
_param3[17].Value = Convert.ToInt32(_tc.ColWidth);
_param3[18].Value = _tc.DWDM;
_param3[19].Value = _tc.CTag;
_param3[20].Value = _tc.RefWordTableName;
MysqlDBHelper.ExecuteNonQuery(MysqlDBHelper.conf, CommandType.Text, _sb_insert.ToString(), _param3);
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
Debug.WriteLine(ex.StackTrace);
}
MyDA_MetaDataQuery.ModelLib.Clear();
}
/// <summary>
/// 更新列定义
/// </summary>
/// <param name="_table"></param>
/// <param name="_tc"></param>
public static void UpdateColumnDefine(MD_Table _table, MD_TableColumn _tc)
{
StringBuilder _sb = new StringBuilder();
_sb.Append(" update md_tablecolumn set TID=@TID,COLUMNNAME=@COLUMNNAME,");
_sb.Append(" ISNULLABLE=@ISNULLABLE,TYPE=@TYPE,`PRECISION`=@PRECISION,SCALE=@SCALE,");
_sb.Append(" LENGTH=@LENGTH,REFDMB=@REFDMB,DMBLEVELFORMAT=@DMBLEVELFORMAT,SECRETLEVEL=@SECRETLEVEL,");
_sb.Append(" DISPLAYTITLE=@DISPLAYTITLE,DISPLAYFORMAT=@DISPLAYFORMAT,DISPLAYLENGTH=@DISPLAYLENGTH,DISPLAYHEIGHT=@DISPLAYHEIGHT,");
_sb.Append(" DISPLAYORDER=@DISPLAYORDER,CANDISPLAY=@CANDISPLAY,COLWIDTH=@COLWIDTH,DWDM=@DWDM,");
_sb.Append(" CTAG=@CTAG,REFWORDTB=@REFWORD ");
_sb.Append(" WHERE TCID=@TCID");
MySqlParameter[] _param3 =
{
new MySqlParameter("@TID", MySqlDbType.Int64),
new MySqlParameter("@COLUMNNAME", MySqlDbType.VarChar, 50),
new MySqlParameter("@ISNULLABLE", MySqlDbType.VarChar, 100),
new MySqlParameter("@TYPE", MySqlDbType.VarChar, 20),
new MySqlParameter("@PRECISION", MySqlDbType.Int32),
new MySqlParameter("@SCALE", MySqlDbType.Int32),
new MySqlParameter("@LENGTH", MySqlDbType.Int32),
new MySqlParameter("@REFDMB", MySqlDbType.VarChar, 50),
new MySqlParameter("@DMBLEVELFORMAT", MySqlDbType.VarChar, 20),
new MySqlParameter("@SECRETLEVEL", MySqlDbType.Int32),
new MySqlParameter("@DISPLAYTITLE", MySqlDbType.VarChar, 50),
new MySqlParameter("@DISPLAYFORMAT", MySqlDbType.VarChar, 50),
new MySqlParameter("@DISPLAYLENGTH", MySqlDbType.Int32),
new MySqlParameter("@DISPLAYHEIGHT", MySqlDbType.Int32),
new MySqlParameter("@DISPLAYORDER", MySqlDbType.Int32),
new MySqlParameter("@CANDISPLAY", MySqlDbType.Int32),
new MySqlParameter("@COLWIDTH", MySqlDbType.Int32),
new MySqlParameter("@DWDM", MySqlDbType.VarChar, 20),
new MySqlParameter("@CTAG", MySqlDbType.VarChar, 500),
new MySqlParameter("@REFWORD", MySqlDbType.VarChar, 50),
new MySqlParameter("@TCID", MySqlDbType.Int64)
};
_param3[0].Value = Convert.ToInt64(_table.TID);
_param3[1].Value = _tc.ColumnName;
_param3[2].Value = _tc.IsNullable ? "Y" : "N";
_param3[3].Value = _tc.ColumnType;
_param3[4].Value = Convert.ToInt32(_tc.Precision);
_param3[5].Value = Convert.ToInt32(_tc.Scale);
_param3[6].Value = Convert.ToInt32(_tc.Length);
_param3[7].Value = _tc.RefDMB;
_param3[8].Value = _tc.DMBLevelFormat;
_param3[9].Value = Convert.ToInt32(_tc.SecretLevel);
_param3[10].Value = _tc.DisplayTitle;
_param3[11].Value = _tc.DisplayFormat;
_param3[12].Value = Convert.ToInt32(_tc.DisplayLength);
_param3[13].Value = Convert.ToInt32(_tc.DisplayHeight);
_param3[14].Value = Convert.ToInt32(_tc.DisplayOrder);
_param3[15].Value = _tc.CanDisplay ? 1 : 0;
_param3[16].Value = Convert.ToInt32(_tc.ColWidth);
_param3[17].Value = _tc.DWDM;
_param3[18].Value = _tc.CTag;
_param3[19].Value = _tc.RefWordTableName;
_param3[20].Value = Convert.ToInt64(_tc.ColumnID);
MysqlDBHelper.ExecuteNonQuery(MysqlDBHelper.conf, CommandType.Text, _sb.ToString(), _param3);
MyDA_MetaDataQuery.ModelLib.Clear();
}
