public List <IIndexClass> GetIndexs() { if (_indexs.Count == 0 && !_isLoadInds) { string sql = "select * from user_indexes where index_type='NORMAL' and dropped='NO'"; DataTable dt = _oracleHelper.ExecuteDataTable(sql); foreach (DataRow item in dt.Rows) { OracleIndexClass oic = new OracleIndexClass(item); oic.SetOracleHelper(_oracleHelper); _indexs.Add(oic); } _isLoadInds = true; } List <IIndexClass> t = new List <IIndexClass>(); t.AddRange(_indexs); return(t); }
internal void DoLoadIndex() { if (!_isLoadIndex) { string type = Convert.ToString(constraint_type); if (type != "R")//不是外键 { string indexName = Convert.ToString(index_name); if (_oracleHelper != null && !string.IsNullOrWhiteSpace(indexName) && oracleIndexClass == null) { string sql = "select * from user_indexes where index_type='NORMAL' and dropped='NO' and index_name='" + index_name + "'"; DataTable dt = _oracleHelper.ExecuteDataTable(sql); if (dt.Rows.Count > 0) { oracleIndexClass = new OracleIndexClass(dt.Rows[0]); } } } _isLoadIndex = true; } }
internal void DoLoadIndex() { if (!_isLoadIndex) { string type = Convert.ToString(constraint_type); if (type != "R")//不是外键 { string indexName = Convert.ToString(index_name); if (_oracleHelper != null && !string.IsNullOrWhiteSpace(indexName) && oracleIndexClass == null) { string sql = "select * from user_indexes where index_type='NORMAL' and dropped='NO' and index_name='" + index_name + "'"; DataTable dt = _oracleHelper.ExecuteDataTable(sql); if (dt.Rows.Count > 0) { oracleIndexClass = new OracleIndexClass(dt.Rows[0]); } } } _isLoadIndex = true; } }
public List<IIndexClass> GetIndexs() { if (_indexs.Count == 0 && !_isLoadInds) { string sql = "select * from user_indexes where index_type='NORMAL' and dropped='NO'"; DataTable dt = _oracleHelper.ExecuteDataTable(sql); foreach (DataRow item in dt.Rows) { OracleIndexClass oic = new OracleIndexClass(item); oic.SetOracleHelper(_oracleHelper); _indexs.Add(oic); } _isLoadInds = true; } List<IIndexClass> t = new List<IIndexClass>(); t.AddRange(_indexs); return t; }