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