/// <summary> /// 获取表内容 /// </summary> /// <param name="owner"></param> /// <param name="name"></param> private void GetTableContentList(string owner, string name) { TableContentGridList.Clear(); DBHelper.GetTableContent(owner, name); var list = (from dt in DBHelper.ReturnTableContent.AsEnumerable() select new TableVo() { Name = dt["COLUMN_NAME"].ToString(), Type = dt["DATA_TYPE"].ToString(), Comments = dt["COMMENTS"].ToString(), Nullable = dt["NULLABLE"].ToString(), DataLength = dt["DATA_LENGTH"].ToString() }).ToList(); for (int i = 0; i < list.Count; i++) { TableVo tablevo = new TableVo() { Name = list[i].Name, Type = list[i].Type, Comments = list[i].Comments, Nullable = list[i].Nullable, DataLength = list[i].DataLength }; TableContentGridList.Add(tablevo); } }
/// <summary> /// 获取表名列 /// </summary> /// <param name="owner"></param> private void GetTableNameList(string owner) { TableNameGridList.Clear(); DBHelper.GetTableName(owner); var list = (from dt in DBHelper.ReturnTableName.AsEnumerable() select new TableVo() { Schema = dt["OWNER"].ToString(), Name = dt["TABLE_NAME"].ToString(), Type = dt["TABLE_TYPE"].ToString(), Comments = dt["COMMENTS"].ToString() }).ToList(); for (int i = 0; i < list.Count; i++) { TableVo tablevo = new TableVo() { Schema = list[i].Schema, Comments = list[i].Comments, Name = list[i].Name, Type = list[i].Type }; TableNameGridList.Add(tablevo); } }