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