public override bool GetInfoByDb(string connStr, ref DbModels rel)
{
using (Helper = new DBStructureHelper(connStr))
{
if (Helper.Open())
{
OutputText?.Invoke("开始获取数据库信息(" + Helper.Server + (Helper.Port == "-1" ? "" : ":" + Helper.Port) + " " + Helper.DbName + ")\n", OutputType.Comment);
Helper.Set_DbHander(SetLen);
if (Helper.GetTables(out List <string> tempList, out string errorMsg))
{
rel.DbModel = Helper.GetDbInfo();
OutputText?.Invoke("\n", OutputType.None);
OutputText?.Invoke("\n", OutputType.Comment);
return(true);
}
else
{
OutputText?.Invoke("获取数据库信息失败：" + errorMsg, OutputType.Comment);
return(false);
}
}
else
{
OutputText("打开数据库失败(" + Helper.DbName + ")", OutputType.Comment);
return(false);
}
}
}
public override bool GetInfoByDb(string connStr, ref DbModels rel)
{
rel.Views = new Dictionary <string, ViewInfo>();
using (Helper = new DBStructureHelper(connStr))
{
if (Helper.Open())
{
OutputText("开始获取数据库视图结构(" + Helper.Server + (Helper.Port == "-1" ? "" : ":" + Helper.Port) + " " + Helper.DbName + ")\n", OutputType.Comment);
Helper.Set_DbHander(SetLen);
if (Helper.GetViews(out List <string> tempTrig, out string errorMsg))
{
OutputText(" 获取到 " + tempTrig.Count + " 个视图\n", OutputType.Comment);
foreach (var item in tempTrig)
{
rel.Views.Add(item, Helper.GetViewInfo(item));
}
OutputText("\n", OutputType.None);
OutputText("\n", OutputType.Comment);
return(true);
}
else
{
OutputText("获取视图信息失败：" + errorMsg, OutputType.Comment);
return(false);
}
}
else
{
OutputText("打开数据库失败(" + Helper.DbName + ")", OutputType.Comment);
return(false);
}
}
}
public override bool GetInfoByDb(string connStr, ref DbModels rel)
{
rel.Tables = new Dictionary<string, TableInfo>();
using (Helper = new DBStructureHelper(connStr))
{
if (Helper.Open())
{
OutputText?.Invoke("开始获取数据库表结构(" + Helper.Server + (Helper.Port == "-1" ? "" : ":" + Helper.Port) + " " + Helper.DbName + ")\n", OutputType.Comment);
Helper.Set_DbHander(SetLen);
if (Helper.GetTables(out List<string> tempList, out string errorMsg))
{
OutputText?.Invoke(" 获取到 " + tempList.Count + " 个表\n", OutputType.Comment);
OutputText?.Invoke("...", OutputType.Comment);
foreach (string tabName in tempList)
{
rel.Tables.Add(tabName, Helper.GetTableInfo(tabName));
}
OutputText?.Invoke("\n", OutputType.None);
OutputText?.Invoke("\n", OutputType.Comment);
return true;
}
else
{
OutputText?.Invoke("获取表信息失败：" + errorMsg, OutputType.Comment);
return false;
}
}
else
{
OutputText("打开数据库失败(" + Helper.DbName + ")", OutputType.Comment);
return false;
}
}
}
public override bool GetInfoByDb(string connStr, ref DbModels rel)
{
List <Function> tempList;
string errorMsg;
using (Helper = new DBStructureHelper(connStr))
{
Helper.Set_DbHander(SetLen);
if (Helper.Open())
{
OutputText("开始获取数据库函数结构(" + Helper.Server + (Helper.Port == "-1" ? "" : ":" + Helper.Port) + " " + Helper.DbName + ")\n", OutputType.Comment);
bool tempBool = true;
string spName2 = "";
if (isFun)
{
spName2 = "函数";
tempBool = Helper.GetFuncs(out tempList, out errorMsg);
}
else
{
spName2 = "存储过程";
tempBool = Helper.GetProcs(out tempList, out errorMsg);
}
if (tempBool)
{
OutputText(" 获取到 " + tempList.Count + " 个" + spName2 + "\n", OutputType.Comment);
OutputText("...", OutputType.Comment);
if (isFun)
{
rel.Functions = new Dictionary <string, Function>();
foreach (var item in tempList)
{
item.Info = Helper.GetFuncInfo(item.Name);
rel.Functions.Add(item.Name, item);
}
}
else
{
rel.Procs = new Dictionary <string, Function>();
foreach (var item in tempList)
{
item.Info = Helper.GetProcInfo(item.Name);
rel.Procs.Add(item.Name, item);
}
}
OutputText("\n", OutputType.None);
OutputText("\n", OutputType.Comment);
return(true);
}
else
{
OutputText("获取" + spName2 + "信息失败：" + errorMsg, OutputType.Comment);
return(false);
}
}
else
{
OutputText("打开数据库失败(" + Helper.DbName + ")", OutputType.Comment);
return(false);
}
}
}
