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