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