/// <summary> /// 操作 /// </summary> /// <param name="item"></param> /// <returns></returns> public IActionResult OnPostBusinessDetailsForm(Data_Business_Details item) { var info = new WriteReturn(); using (var db = new DataContext(AppEtl.Db)) { var table = IFast.Query <Data_Business>(a => a.Id == item.Id).ToItem <Data_Business>(db); var source = IFast.Query <Data_Source>(a => a.Id == item.DataSourceId).ToItem <Data_Source>(db); var key = string.Format(AppEtl.CacheKey.Column, source.Host, item.TableName); var colunm = RedisInfo.Get <List <CacheColumn> >(key, AppEtl.CacheDb).Find(a => a.Name == item.ColumnName); db.BeginTrans(); if (IFast.Query <Data_Business_Details>(a => a.FieldId == item.FieldId).ToCount(db) == 0) { item.FieldId = Guid.NewGuid().ToStr(); info = IFast.Add(item); if (info.IsSuccess) { info = DataSchema.AddColumn(db, table, item, colunm, source); if (info.IsSuccess) { DataSchema.UpdateColumnComment(db, table, item, colunm, source); } } } else { info = IFast.Update <Data_Business_Details>(item, a => a.FieldId == item.FieldId); if (info.IsSuccess) { info.IsSuccess = DataSchema.UpdateColumn(db, table, item, colunm, source); if (info.IsSuccess) { DataSchema.UpdateColumnComment(db, table, item, colunm, source); } } } if (info.IsSuccess) { db.SubmitTrans(); return(new JsonResult(new { success = true, msg = "操作成功" })); } else { db.RollbackTrans(); return(new JsonResult(new { success = false, msg = "操作失败" })); } } }
public IActionResult OnPostDropList(DropListModel item) { using (var db = new DataContext(AppEtl.Db)) { if (item.Type.ToLower() == "source") { var param = new List <DbParameter>(); var temp = DbProviderFactories.GetFactory(db.config.DbType).CreateParameter(); temp.ParameterName = "Key"; temp.Value = item.Key.ToUpper(); param.Add(temp); var data = IFast.Query("DropList.Source", param.ToArray(), db); if (data.Count > 0) { return(new JsonResult(new { success = true, data = data })); } else { return(new JsonResult(new { success = true, data = IFast.Query <Data_Source>(a => a.Id != "").Take(10).ToDics(db) })); } } if (item.Type.ToLower() == "table") { var host = IFast.Query <Data_Source>(a => a.Id == item.HostId, a => new { a.Host }).ToDic(db).GetValue("host").ToStr(); var key = string.Format(AppEtl.CacheKey.Table, host); var data = RedisInfo.Get <List <CacheTable> >(key, AppEtl.CacheDb); data = data.FindAll(a => a.Name.ToUpper().Contains(item.Key.ToUpper())); if (data.Count > 0) { return(new JsonResult(new { success = true, data = data })); } else { return(new JsonResult(new { success = true, data = RedisInfo.Get <List <CacheTable> >(key, AppEtl.CacheDb).Take(10) })); } } if (item.Type.ToLower() == "field") { var host = IFast.Query <Data_Source>(a => a.Id == item.HostId, a => new { a.Host }).ToDic(db).GetValue("host").ToStr(); var key = string.Format(AppEtl.CacheKey.Column, host, item.Table); var data = RedisInfo.Get <List <CacheColumn> >(key, AppEtl.CacheDb); data = data.FindAll(a => a.Name.ToUpper().Contains(item.Key.ToUpper())); if (data.Count > 0) { return(new JsonResult(new { success = true, data = data })); } else { return(new JsonResult(new { success = true, data = RedisInfo.Get <List <CacheColumn> >(key, AppEtl.CacheDb).Take(10) })); } } if (item.Type.ToLower() == "dic") { var param = new List <DbParameter>(); var temp = DbProviderFactories.GetFactory(db.config.DbType).CreateParameter(); temp.ParameterName = "Key"; temp.Value = item.Key.ToUpper(); param.Add(temp); var data = IFast.Query("DropList.Dic", param.ToArray(), db); if (data.Count > 0) { return(new JsonResult(new { success = true, data = data })); } else { return(new JsonResult(new { success = true, data = IFast.Query <Data_Dic>(a => a.Id != "").Take(10).ToDics(db) })); } } return(new JsonResult(new { success = false })); } }
/// <summary> /// 操作 /// </summary> /// <param name="item"></param> /// <returns></returns> public IActionResult OnPostBusinessFormList(Data_Business_List item) { var result = new WriteReturn(); result.IsSuccess = true; using (var db = new DataContext(AppEtl.Db)) { if (IFast.Query <Data_Source>(a => a.Id == item.DataId).ToCount(db) == 0) { return(new JsonResult(new { success = false, msg = "数据源不存在" })); } var data = IFast.Query <Data_Source>(a => a.Id == item.DataId).ToItem <Data_Source>(db); var tableKey = string.Format(AppEtl.CacheKey.Table, data.Host); if (!RedisInfo.Exists(tableKey, AppEtl.CacheDb)) { DataSchema.InitTable(data, false); } var tableList = RedisInfo.Get <List <CacheTable> >(tableKey, AppEtl.CacheDb); foreach (var table in tableList) { var columnKey = string.Format(AppEtl.CacheKey.Column, data.Host, table.Name); if (!RedisInfo.Exists(columnKey, AppEtl.CacheDb)) { DataSchema.InitColumn(data, false, table.Name); } var tableModel = BaseMap.CopyModel <Data_Business, Data_Business_List>(item); tableModel.Id = Guid.NewGuid().ToStr(); tableModel.Name = string.IsNullOrEmpty(table.Comments) ? table.Name : table.Comments; tableModel.TableName = table.Name; if (result.IsSuccess) { result = db.Add(tableModel).writeReturn; } if (result.IsSuccess) { result = DataSchema.CreateTable(db, tableModel); } var columnList = RedisInfo.Get <List <CacheColumn> >(columnKey, AppEtl.CacheDb); var keyName = columnList.Find(a => a.IsKey == true)?.Name; var keyList = columnList.FindAll(a => a.IsKey == true); columnList.ForEach(column => { var columnModel = new Data_Business_Details(); columnModel.FieldId = Guid.NewGuid().ToStr(); columnModel.Id = tableModel.Id; columnModel.DataSourceId = data.Id; columnModel.TableName = table.Name; columnModel.ColumnName = column.Name; columnModel.FieldName = column.Name; columnModel.Key = keyName; if (result.IsSuccess) { result = db.Add(columnModel).writeReturn; } else { BaseLog.SaveLog(string.Format("tableName:{0},error:", table.Name, result.Message), "Error_CreateTable"); } if (result.IsSuccess) { if ((keyList.Count > 1 && keyList.Exists(a => a.Name == columnModel.FieldName))) { result = DataSchema.AddColumn(db, tableModel, columnModel, column, data, false); } else { result = DataSchema.AddColumn(db, tableModel, columnModel, column, data); } if (result.IsSuccess) { DataSchema.UpdateColumnComment(db, tableModel, columnModel, column, data); } } result.IsSuccess = true; }); if (keyList.Count > 1) { DataSchema.AddColumnMoreKey(db, tableModel, keyList); } } if (result.IsSuccess) { return(new JsonResult(new { success = true, msg = "操作成功" })); } else { return(new JsonResult(new { success = false, msg = result.Message })); } } }