public FileResult ExportFile(string tableStr)
{
if (string.IsNullOrEmpty(tableStr))
{
return(File("text/plain", "dbd.md"));
}
var outInfo = "## 数据库描述导出信息\n";
var tableList = tableStr.Split(';').ToList();
foreach (var item in tableList)
{
var tableInfo = item.Split('/').Where(g => !string.IsNullOrEmpty(g)).ToList();
if (tableInfo.Count < 2)
{
outInfo += $"### 导出 `{item}` 表参数不正确\n\n";
}
else
{
outInfo += $"### `{item}表信息导出`\n";
var desc = DbMapManager.FetchTableDescruption(tableInfo[0], tableInfo[1]);
var data = DbMapManager.FetchTableMap(tableInfo[0], tableInfo[1]);
desc = string.IsNullOrWhiteSpace(desc) ? "暂无描述" : desc;
outInfo += $"{DbMapManager.ConvertToMdStr(desc, data)}\n";
}
}
var output = new MemoryStream();
var writer = new StreamWriter(output, System.Text.Encoding.UTF8);
writer.Write(outInfo);
writer.Flush();
output.Position = 0;
return(File(output, "text/plain", "dbd.md"));
}
public JsonResult FetchTableDetail(string DbName, string TableName)
{
if (string.IsNullOrWhiteSpace(DbName) || string.IsNullOrWhiteSpace(TableName))
{
return(Json(new
{
Code = 0,
Info = "参数格式不正确"
}));
}
var data = DbMapManager.FetchTableMap(DbName, TableName);
return(Json(new
{
Tablename = TableName,
Description = DbMapManager.FetchTableDescruption(DbName, TableName),
Data = data.Select(g => new SimpleDbMapModel
{
FieldName = g.FieldName,
FieldType = g.FieldType,
ByteCount = g.ByteCount,
FieldSize = g.FieldSize,
IsNullable = g.IsNullable,
Description = g.Description
})
}));
}
public JsonResult AddTableMap(string DbName, string TableName)
{
if (string.IsNullOrWhiteSpace(DbName) || string.IsNullOrWhiteSpace(TableName))
{
return(Json(new
{
Code = 0,
Info = "参数格式不正确"
}, JsonRequestBehavior.AllowGet));
}
var result = DbMapManager.AddTableMap(DbName, TableName);
return(Json(new
{
Code = 1,
Data = result
}, JsonRequestBehavior.AllowGet));
}
public JsonResult SelectTablesByDbName(string DbName, bool isCurrent = true)
{
if (string.IsNullOrWhiteSpace(DbName))
{
return(Json(new
{
Code = 0,
Info = "参数格式不正确"
}));
}
var result = DbMapManager.SelectTablesByDbName(DbName, isCurrent);
return(Json(new
{
Code = 1,
Data = result.OrderBy(g => g).ToList()
}));
}
public JsonResult FetchTableDescruption(string DbName, string TableName)
{
if (string.IsNullOrWhiteSpace(DbName) || string.IsNullOrWhiteSpace(TableName))
{
return(Json(new
{
Code = 0,
Info = "参数格式不正确"
}));
}
var result = DbMapManager.FetchTableDescruption(DbName, TableName);
return(Json(new
{
Code = result == null ? 0 : 1,
Info = result
}));
}
public JsonResult UpdateDescription(int TableId, int FieldId, string Description)
{
if (TableId < 1 || FieldId < 1 || string.IsNullOrWhiteSpace(Description))
{
return(Json(new
{
Code = 0,
Info = "参数格式不正确"
}));
}
var result = DbMapManager.UpdateDescription(TableId, FieldId, Description);
return(Json(new
{
Code = result,
Info = result > 0 ? "修改成功" : "修改失败"
}));
}
public JsonResult FetchTableMap(string DbName, string TableName)
{
if (string.IsNullOrWhiteSpace(DbName) || string.IsNullOrWhiteSpace(TableName))
{
return(Json(new
{
Code = 0,
Info = "参数格式不正确"
}));
}
var result = DbMapManager.FetchTableMap(DbName, TableName);
return(Json(new
{
Code = 1,
Data = result
}));
}
public JsonResult SetTableDescription(string DbName, string TableName, string Description)
{
if (string.IsNullOrWhiteSpace(DbName) || string.IsNullOrWhiteSpace(TableName) ||
string.IsNullOrWhiteSpace(Description))
{
return(Json(new
{
Code = 0,
Info = "参数格式不正确"
}));
}
var result = DbMapManager.SetTableDescription(DbName, TableName, Description);
return(Json(new
{
Code = result,
Info = result == 0 ? "参数不正确" : "修改成功"
}));
}
public JsonResult DbMapList(bool isCurrent = false)
{
var result = DbMapManager.GetDbList(isCurrent).OrderBy(g => g).ToList();
return(Json(result));
}
public ActionResult DbMap()
{
var result = DbMapManager.GetDbList().OrderBy(g => g).ToList();
return(View(result));
}
public JsonResult GetTableList()
{
var result = DbMapManager.GetTableList();
return(Json(result));
}
