public async Task <IActionResult> OnGetAsync(int sqlConnId, string database)
{
if (sqlConnId <= 0)
{
return(Redirect("/NotFound"));
}
var use = await _sqlOnlineApplication.UseDevelopment();
if (use == false)
{
return(Redirect("/Developments/Prompt"));
}
SqlConnId = sqlConnId;
Database = database;
var languageTypeDict = ToolGood.Common.Utils.EnumUtil.GetDescriptions(typeof(ToolGood.SqlOnline.Datas.Enums.EnumTplLanguageType));
var Languages = new Dictionary <string, string>();
foreach (var item in languageTypeDict)
{
Languages[((ToolGood.SqlOnline.Datas.Enums.EnumTplLanguageType)item.Key).ToString()] = item.Value;
}
var list = await _sqlOnlineApplication.GetSqlCodeGens();
var infos = Info_1.Analysis(list, Languages);
Json = infos.ToJson();
return(Page());
}
public static List <Info_1> Analysis(List <SqlCodeGenDto> list, Dictionary <string, string> languages)
{
List <Info_1> result = new List <Info_1>();
var tplTypes = list.Select(q => q.TplType).Distinct().ToList();
foreach (var tplType in tplTypes)
{
Info_1 info = new Info_1();
info.TplTypeId = tplType;
if (info.TplTypeId == 1)
{
info.TplTypeName = "表模板";
}
else if (info.TplTypeId == 2)
{
info.TplTypeName = "存储过程模板";
}
result.Add(info);
var tempList = list.Where(q => q.TplType == tplType).ToList();
info.Items = Info_2.Analysis(tempList, languages);
}
return(result);
}
