public JsonResult GetModel(string dataid) { FBDataObject model = this._service.GetModel(dataid); if (string.IsNullOrEmpty(model.ID)) { model.ID = dataid; model.CreateTime = DateTime.Now.ToString(); model.CreateUser = SessionProvider.Provider.Current().UserName; model.LastModifyTime = model.CreateTime; model.LastModifyUser = model.CreateUser; } return(Json(new { res = true, data = model })); }
// GET: FBMeta public JsonResult SaveObjectInfo(string info) { try { JsonSerializerSettings jsetting = new JsonSerializerSettings(); jsetting.NullValueHandling = NullValueHandling.Ignore; FBDataObject model = JsonConvert.DeserializeObject <FBDataObject>(info, jsetting); this._service.AddData(model); return(Json(new { res = true, mes = "保存成功" })); //return Content("213213"); } catch (Exception ex) { return(Json(new { res = true, mes = "保存失败" + ex.Message })); //throw ex; //return Json(new { res = true, mes = "操作失败" + ex.Message }); } }
// GET: FBMeta public JsonResult SaveModel(string data) { try { JsonSerializerSettings jsetting = new JsonSerializerSettings(); jsetting.NullValueHandling = NullValueHandling.Ignore; FBDataObject model = JsonConvert.DeserializeObject <FBDataObject>(data, jsetting); model.LastModifyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); model.LastModifyUser = SessionProvider.Provider.Current().UserName; this._service.AddData(model); return(Json(new { res = true, mes = "保存成功" })); //return Content("213213"); } catch (Exception ex) { return(Json(new { res = false, mes = "保存失败" + ex.Message })); //throw ex; //return Json(new { res = true, mes = "操作失败" + ex.Message }); } }
public JsonResult createMetaData(string data, string type) { try { var lastTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); var lastUser = SessionProvider.Provider.Current().UserName; var entity = Newtonsoft.Json.JsonConvert.DeserializeObject <FBMetaModel>(data); switch (type) { case "0": { FBDataObject model = new FBDataObject(); model.ID = Guid.NewGuid().ToString(); model.Code = entity.Code; model.AiasName = entity.Name; model.TableName = entity.TableName; model.ParentID = entity.ParentID; this._serviceDO.AddObject(model); } break; case "1": { FBDataModel model = new FBDataModel(); model.ID = Guid.NewGuid().ToString(); model.Name = entity.Name; model.Code = entity.Code; model.MainObectID = entity.ModelID; model.parentID = entity.ParentID; this._serviceDM.AddModel(model); } break; case "2": { FBSmartHelp model = new FBSmartHelp(); model.ID = Guid.NewGuid().ToString(); model.Code = entity.Code; model.Name = entity.Name; model.ModelID = entity.ModelID; model.parentID = entity.ParentID; this._serviceHP.addData(model); } break; case "3": { FBForm model = new FBForm(); model.ID = Guid.NewGuid().ToString(); model.Code = entity.Code; model.Name = entity.Name; model.ModelID = entity.ModelID; model.parentID = entity.ParentID; model.Type = entity.FormType; this._serviceFrm.addData(model); } break; case "5": { FBDataSource model = new FBDataSource(); model.ID = Guid.NewGuid().ToString(); model.Code = entity.Code; model.Name = entity.Name; model.parentID = entity.ParentID; this._serviceDS.addData(model); } break; default: break; } return(Json(new { res = true, mes = "删除成功!" })); } catch (Exception ex) { return(Json(new { res = false, mes = "重命名失败" + ex.Message })); } }
public void AddObject(string modelID, string objectID) { //获取数据对象列表 //获取数据对象字段信息 //处理数据 //保存 try { base.Db.BeginTransaction(); if (base.Db.Single <long>(new Sql("select count(1) from FBDataModelObjects where objectid=@0 and modelID=@1", objectID, modelID)) > 0) { throw new Exception("数据模型中已存在该数据对象!"); } List <FBDataModelCols> list = new List <FBDataModelCols>(); FBDataModelObjects model = new FBDataModelObjects(); FBDataObject obj_model = new FBDataObject(); obj_model = base.Db.SingleById <FBDataObject>(objectID); List <FBDataObjectCols> obj_list = new List <FBDataObjectCols>(); obj_list = base.Db.Fetch <FBDataObjectCols>(new Sql(@"select * from FBDataObjectCols where ObjectID=@0", objectID)); model.ID = Guid.NewGuid().ToString(); model.Code = obj_model.Code; model.Name = obj_model.AiasName; model.ModelID = modelID; model.ObjectID = objectID; model.isMain = "0"; model.Label = ""; model.isSave = "1";//默认是否保存勾选 model.Level = "2"; model.ParentID = base.Db.Single <string>( new Sql(@"select id from FBDataModelObjects where ModelID=@0 and level='1' and isMain='1'", modelID)); model.PKCOLName = obj_list.Where(p => p.IsPrimary == "1").ToList()[0].Code; model.Filter = ""; model.Sort = ""; base.Db.Save <FBDataModelObjects>(model); int i = 0; foreach (FBDataObjectCols col in obj_list) { FBDataModelCols mcol = new FBDataModelCols(); mcol.ID = Guid.NewGuid().ToString(); mcol.Code = col.Code; mcol.Name = col.Name; mcol.ModelID = modelID; mcol.ModelObjectID = model.ID; mcol.Label = col.Code; mcol.isCard = "1"; mcol.isList = "1"; mcol.isReadOnly = "0"; mcol.isRelated = "0"; mcol.isUpdate = "1"; mcol.isVirtual = "0"; mcol.VirtualExpress = ""; mcol.RelationID = ""; mcol.ParentID = ""; mcol.Ord = i.ToString(); mcol.Length = col.Length.ToString(); mcol.DataType = col.DataType; mcol.isPrimary = col.IsPrimary; base.Db.Save <FBDataModelCols>(mcol);//保存列表 i++; } this.Db.CompleteTransaction(); } catch (Exception ex) { base.Db.AbortTransaction(); throw ex; } }
public void SaveObjectCols(FBDataObject model) { throw new NotImplementedException(); }
public void AddModel(FBDataModel model) { try { base.Db.BeginTransaction(); //保存元数据 FBMetaData meta = new FBMetaData(); meta.ID = model.ID; meta.Type = "2"; meta.State = "1"; meta.Name = model.Name; meta.Code = model.Code; base.Db.Save <FBMetaData>(meta); //保存数据模型 base.Save(model); //获取数据对象信息 FBDataObject obj = new FBDataObject(); FBDataObjectService svr = new FBDataObjectService(this.context); List <FBDataObjectCols> list = new List <FBDataObjectCols>(); list = svr.GetColumn(model.MainObectID); obj = svr.GetModel(model.MainObectID); //保存主对象 FBDataModelObjects modelmain = new FBDataModelObjects(); modelmain.ID = Guid.NewGuid().ToString(); modelmain.ModelID = model.ID; modelmain.Code = obj.Code; modelmain.Name = obj.AiasName; modelmain.ObjectID = model.MainObectID; var listres = list.Where(p => p.IsPrimary == "1").ToList(); if (listres.Count <= 0) { throw new Exception("数据对象必须定义一个主键!"); } modelmain.PKCOLName = list.Where(p => p.IsPrimary == "1").ToList()[0].Code; modelmain.Level = "1"; modelmain.isMain = "1"; modelmain.Label = obj.Code; modelmain.ParentID = ""; base.Db.Save <FBDataModelObjects>(modelmain);//保存列信息 //保存子对象 foreach (FBDataObjectCols col in list) { FBDataModelCols mcol = new FBDataModelCols(); mcol.ID = Guid.NewGuid().ToString(); mcol.Code = col.Code; mcol.Name = col.Name; mcol.ModelID = model.ID; mcol.ModelObjectID = modelmain.ID; mcol.Label = col.Code; mcol.isCard = "1"; mcol.isList = "1"; mcol.isReadOnly = "0"; mcol.isRelated = "0"; mcol.isUpdate = "1"; mcol.isVirtual = "0"; mcol.VirtualExpress = ""; mcol.RelationID = ""; mcol.ParentID = ""; mcol.Length = col.Length.ToString(); mcol.DataType = col.DataType; mcol.isPrimary = col.IsPrimary; mcol.Ord = col.Ord; Db.Save <FBDataModelCols>(mcol); } FBMeta.AddMeataData(model.ID, model.Code, model.Name, "1", model.parentID, base.Db); this.Db.CompleteTransaction(); } catch (Exception ex) { base.Db.AbortTransaction(); throw ex; } }