/// <summary> /// 获取当前目录的文件夹 /// </summary> /// <param name="parentID"></param> /// <param name="userID"></param> /// <param name="isSYS"></param> /// <returns></returns> public List <FBMetaData> getFolderList(string parentID, string userID, bool isSYS, bool isFolder, string keyword) { List <FBMetaData> list = new List <FBMetaData>(); FBMetaData model = new FBMetaData(); var sql = new Sql("select FBMetaData.*,FBMetaType.Name as MetaType from FBMetaData left join FBMetaType on FBMetaType.CODE=FBMetaData.type where parentID=@0 ", parentID); if (string.IsNullOrEmpty(parentID)) { sql.Append(new Sql(" or parentID is null")); } sql.Append(new Sql(" order by IsFolder Desc,Type,LastModifyTime desc")); if (isFolder) { sql = new Sql("select FBMetaData.*,FBMetaType.Name as MetaType from FBMetaData left join FBMetaType on FBMetaType.CODE=FBMetaData.type where IsFolder=@0 order by IsFolder Desc,LastModifyTime desc", "1"); } if (!string.IsNullOrEmpty(userID)) { sql = new Sql("select FBMetaData.*,FBMetaType.Name as MetaType from FBMetaData left join FBMetaType on FBMetaType.CODE=FBMetaData.type where IsFolder=@0 and CreateUser=@1 order by IsFolder Desc,LastModifyTime desc", "1", SessionProvider.Provider.Current().UserName); } if (!string.IsNullOrEmpty(keyword)) { sql = new Sql("select FBMetaData.*,FBMetaType.Name as MetaType from FBMetaData left join FBMetaType on FBMetaType.CODE=FBMetaData.type where 1=1 and( FBMetaData.id like '%" + keyword + "%' or FBMetaData.name like '%" + keyword + "%') order by IsFolder Desc,LastModifyTime desc"); } list = Db.Fetch <FBMetaData>(sql); return(list); }
public static void AddMeataData(FBMetaData model, Database db) { model.IsFolder = "1"; model.UserID = SessionProvider.Provider.Current().UserID; model.CreateTime = model.LastModifyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); model.CreateUser = model.LastModifyUser = SessionProvider.Provider.Current().UserName; model.Type = "9"; Save(model, db); }
public List <FBMetaData> searchMetaData(string keyword, string parentID) { List <FBMetaData> list = new List <FBMetaData>(); FBMetaData model = new FBMetaData(); var sql = new Sql("select * from FBMetaData where IsFolder is null and( id like '" + keyword + "'or name like '" + keyword + "%') order by IsFolder Desc,LastModifyTime desc", parentID); list = Db.Fetch <FBMetaData>(sql); return(list); }
public static void UpdateMeataInfo(string name, string code, string id, Database db) { FBMetaData model = new FBMetaData(); model.LastModifyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); model.LastModifyUser = SessionProvider.Provider.Current().UserName; var sql = new Sql("update FBMetaData set name=@0, code=@4 ,LastModifyTime=@1,LastModifyUser=@2 where id=@3", name, model.LastModifyTime, model.LastModifyUser, id, code); db.Execute(sql); }
/// <summary> /// 移动文件夹 /// </summary> /// <param name="data"></param> /// <param name="targetID"></param> /// <param name="db"></param> public static void MoveMetaData(List <string> data, string targetID, Database db) { FBMetaData model = new FBMetaData(); model.LastModifyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); model.LastModifyUser = SessionProvider.Provider.Current().UserName; foreach (var id in data) { var sql = new Sql("update FBMetaData set parentid=@0,LastModifyTime=@1,LastModifyUser=@2 where id=@3", targetID, model.LastModifyTime, model.LastModifyUser, id); db.Execute(sql); } }
public static void UpdateMetaData(string id, string code, string name, Database db) { FBMetaData model = new FBMetaData(); model.ID = id; model.Code = code; model.Name = name; model.LastModifyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); model.LastModifyUser = SessionProvider.Provider.Current().UserName; Sql sql = new Sql("udpate FBMetaData set Code=@0,Name=@1,LastModifyTime=@2,LastModifyUser=@3 where ID=@4", model.Code, model.Name, model.LastModifyTime, model.LastModifyUser, model.ID); db.Execute(sql); }
/// <summary> /// 添加元数据管理 /// </summary> /// <param name="id"></param> /// <param name="code"></param> /// <param name="name"></param> /// <param name="type">0数据对象 1数据模型 2帮助 3表单 4构件</param> /// <param name="db"></param> public static void AddMeataData(string id, string code, string name, string type, string parentID, Database db) { FBMetaData model = new FBMetaData(); model.ID = id; model.Code = code; model.Name = name; model.Type = type; model.IsFolder = "0"; model.ParentID = parentID; model.UserID = SessionProvider.Provider.Current().UserID; model.LastModifyTime = model.CreateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); model.LastModifyUser = model.CreateUser = SessionProvider.Provider.Current().UserName; Save(model, db); }
public JsonResult addFolder(string name, string parentID) { try { FBMetaData model = new FBMetaData(); model.Code = model.Name = name; model.ID = Guid.NewGuid().ToString(); model.ParentID = parentID; model.Type = "9"; this._service.addFolder(model); return(Json(new { res = true, mes = "添加成功" })); } catch (Exception ex) { return(Json(new { res = false, mes = "获取元数据列表失败" + ex.Message })); } }
private static void Save(FBMetaData model, Database db) { db.Save <FBMetaData>(model); }
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; } }
public void addFolder(FBMetaData model) { FBMeta.AddMeataData(model, base.Db); }