/// <summary> /// 操作 /// </summary> /// <param name="item"></param> /// <returns></returns> public IActionResult OnPostBusinessForm(Data_Business item) { var info = new WriteReturn(); using (var db = new DataContext(AppEtl.Db)) { db.BeginTrans(); if (IFast.Query <Data_Business>(a => a.Id == item.Id).ToCount(db) == 0) { item.Id = Guid.NewGuid().ToString(); info = db.Add(item).writeReturn; if (info.IsSuccess) { info = DataSchema.CreateTable(db, item); } } else { var oldTableName = IFast.Query <Data_Business>(a => a.Id == item.Id, a => new { a.TableName }).ToDic(db).GetValue("TableName").ToStr(); info = db.Update <Data_Business>(item, a => a.Id == item.Id).writeReturn; if (info.IsSuccess) { if (oldTableName.ToLower() != item.TableName.ToLower()) { DataSchema.DropTable(db, oldTableName); info = DataSchema.CreateTable(db, item); } else { DataSchema.UpdateTableComment(db, item); } } } if (info.IsSuccess) { db.SubmitTrans(); return(new JsonResult(new { success = true, msg = "操作成功" })); } else { db.RollbackTrans(); return(new JsonResult(new { success = false, msg = info.Message })); } } }