/// <summary>
/// 获取所有表列表
/// </summary>
/// <returns></returns>
public JsonResult GetTable()
{
string connectStr = System.Configuration.ConfigurationManager.AppSettings["DbConnString"];
string databaseName = System.Configuration.ConfigurationManager.AppSettings["DBName"];
string dbType = System.Configuration.ConfigurationManager.AppSettings["DBType"];
DataInfoForJson model = new DataInfoForJson();
model.Data = new List <DataItem>();
try
{
var tables = DataBaseInfo.GetDatabaseTablesInfo(databaseName, connectStr, dbType);
foreach (var item in tables)
{
model.Data.Add(new DataItem()
{
Key = item.Name,
Name = item.Name
});
}
model.Status = 1;
}
catch (Exception e)
{
model.Status = 0;
model.Desc = e.Message;
}
return(Json(model));
}
/// <summary>
/// 获取预置模型及模板数据
/// </summary>
/// <returns></returns>
public JsonResult GetDataCodeFirst()
{
DataInfoForJson model = new DataInfoForJson();
try
{
string nameSpace = AppSettingHelper.GetAppSetting("NameSpaceCodeFirst");
var types = Assembly.GetExecutingAssembly().GetTypes().Where(u => u.Namespace == nameSpace).ToList();
model.DataTable = new List <DataItem>();
model.Data = new List <DataItem>();
var files = context.TempInfo.Where(u => u.TP_Type == (int)Data.TemplateType.ModelFirst).OrderBy(u => u.TP_Order).ToList();
foreach (var item in files)
{
model.Data.Add(new DataItem()
{
Key = item.TP_ID.ToString(),
Name = item.TP_Name
});
}
foreach (var typeInfo in types)
{
DataItem item = new DataItem();
item.Key = typeInfo.FullName;
var attribute = TemplateGenerator.CodeFirstGenerator.CodeFirstHelper.GetModelAttribute <TemplateGenerator.CodeFirstGenerator.ModelAttributes.ItemDisplayNameAttribute>(typeInfo);
if (attribute != null)
{
item.Name = attribute.DisplayName;
}
else
{
item.Name = typeInfo.Name;
}
model.DataTable.Add(item);
}
model.Status = 1;
}
catch (Exception ex)
{
model.Status = 0;
model.Desc = ex.Message;
}
return(Json(model));
}
/// <summary>
/// 获取数据信息
/// </summary>
/// <returns></returns>
public JsonResult GetData()
{
DataInfoForJson model = new DataInfoForJson();
model.Data = new List <DataItem>();
model.DataTable = new List <DataItem>();
try
{
var files = context.TempInfo.Where(u => u.TP_Type == (int)Data.TemplateType.DataFirst).OrderBy(u => u.TP_Order).ToList();
foreach (var item in files)
{
model.Data.Add(new DataItem()
{
Key = item.TP_ID.ToString(),
Name = item.TP_Name
});
}
//TODO 自选数据库
string connectStr = System.Configuration.ConfigurationManager.AppSettings["DbConnString"];
string databaseName = System.Configuration.ConfigurationManager.AppSettings["DBName"];
string dbType = System.Configuration.ConfigurationManager.AppSettings["DBType"];
var tables = DataBaseInfo.GetDatabaseTablesInfo(databaseName, connectStr, dbType);
foreach (var item in tables)
{
model.DataTable.Add(new DataItem()
{
Key = item.Name,
Name = item.Name
});
}
model.Status = 1;
}
catch (Exception e)
{
model.Status = 0;
model.Desc = e.Message;
}
return(Json(model));
}
