public async Task <JsonResult> GetDataBaseColumnsTree(SystemDataBaseTableDoubleWay doubleWay)
{
var columns = await _dataBaseLogic.GetDataBaseColumns(doubleWay);
IList <TreeEntity> treeEntities = new List <TreeEntity>();
var parentId = CombUtil.NewComb();
TreeEntity treeEntity = new TreeEntity
{
id = parentId,
name = doubleWay.TableName,
nocheck = true
};
treeEntities.Add(treeEntity);
foreach (var co in columns)
{
treeEntity = new TreeEntity
{
pId = parentId,
name = co.ColumnDescription + "(" + co.ColumnName + ")",
code = co.ColumnDescription,
id = co.ColumnName
};
treeEntities.Add(treeEntity);
}
return(Json(treeEntities));
}
/// <summary>
/// 获取对应表列信息
/// </summary>
/// <param name="doubleWayDto"></param>
/// <returns></returns>
public Task <IEnumerable <SystemDataBaseColumnDoubleWay> > GetDataBaseColumns(SystemDataBaseTableDoubleWay doubleWayDto)
{
ResetConnection(doubleWayDto);
return(SqlMapperUtil.SqlWithParams <SystemDataBaseColumnDoubleWay>(ColumnSql, new { tablename = doubleWayDto.TableName }, false));
}
/// <summary>
/// 获取外键信息
/// </summary>
/// <param name="doubleWayDto"></param>
/// <returns></returns>
public Task <IEnumerable <SystemDataBaseFkColumnOutput> > GetdatabsefFkColumn(SystemDataBaseTableDoubleWay doubleWayDto)
{
return(SqlMapperUtil.SqlWithParams <SystemDataBaseFkColumnOutput>(FkSql));
}
public async Task <ViewResultBase> PcCodeGeneration(SystemDataBaseTableDoubleWay doubleWay)
{
return(View(await _dataBaseLogic.GetDataBaseColumns(doubleWay)));
}
/// <summary>
/// 获取外键信息
/// </summary>
/// <param name="doubleWayDto"></param>
/// <returns></returns>
public Task <IEnumerable <SystemDataBaseFkColumnOutput> > GetdatabsefFkColumn(SystemDataBaseTableDoubleWay doubleWayDto)
{
return(_CurrentSelectedDB.SqlWithParams <SystemDataBaseFkColumnOutput>(FkSql));
}
/// <summary>
/// 获取对应表列信息
/// </summary>
/// <param name="doubleWayDto"></param>
/// <returns></returns>
public Task <IEnumerable <SystemDataBaseColumnDoubleWay> > GetDataBaseColumns(SystemDataBaseTableDoubleWay doubleWayDto)
{
var dataBase = ResetConnection(doubleWayDto);
if (_CurrentSelectedDB.ProviderName.IndexOf("Oracle") >= 0)
{
return(_CurrentSelectedDB.SqlWithParams <SystemDataBaseColumnDoubleWay>(ColumnSqlOracle, new { tablename = doubleWayDto.TableName }));
}
else
{
string sql = string.Format(ColumnSqlOracle, dataBase.CatalogName, dataBase.UserId);
return(_CurrentSelectedDB.SqlWithParams <SystemDataBaseColumnDoubleWay>(ColumnSqlSqlServer, new { tablename = doubleWayDto.TableName }));
}
}
/// <summary>
/// 获取外键信息
/// </summary>
/// <param name="doubleWayDto"></param>
/// <returns></returns>
public async Task <IEnumerable <SystemDataBaseFkColumnOutput> > GetdatabsefFkColumn(SystemDataBaseTableDoubleWay doubleWayDto)
{
return(await _dataBaseRepository.GetdatabsefFkColumn(doubleWayDto));
}
/// <summary>
/// 获取对应表列信息
/// </summary>
/// <param name="doubleWayDto"></param>
/// <returns></returns>
public async Task <IEnumerable <SystemDataBaseColumnDoubleWay> > GetDataBaseColumns(SystemDataBaseTableDoubleWay doubleWayDto)
{
return(await _dataBaseRepository.GetDataBaseColumns(doubleWayDto));
}
public async Task <JsonResult> GetdatabsefFkColumn(SystemDataBaseTableDoubleWay doubleWayDto)
{
return(Json(await _dataBaseLogic.GetdatabsefFkColumn(doubleWayDto)));
}
