/// <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)); }