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 SaveData()
{
//保存新加表
int _index = this.gridView1.FocusedRowHandle;
if (_index >= 0)
{
using (MetaDataServiceClient _mdc = new MetaDataServiceClient())
{
DB_TableMeta _tm = (DB_TableMeta)this.gridView1.GetRow(_index);
return(_mdc.SaveNewTable(_tm, _namespace));
}
}
return(false);
}
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 SaveNewRefTable(DB_TableMeta _tm, MD_Namespace _namespace)
{
return(MetaDataFactroy.SaveNewRefTable(_tm, _namespace));
}
