public int Update(DetailTextDB dbObj) { if (dbObj == null) { return(0); } using (InfocenterEntities context = new InfocenterEntities(EFConnectionString)) { DetailTextDB oldObj = context.DetailTextDBs.FirstOrDefault(o => o.ID == dbObj.ID); if (oldObj != null) { //最大的字段长度为3000 if (dbObj.Text.Length > DALConfig.MaxTextFieldSize) { dbObj.Text.Substring(0, DALConfig.MaxTextFieldSize); } //更新数据库 oldObj.ModifyTime = dbObj.ModifyTime; oldObj.Path = dbObj.Path; oldObj.RTFText = dbObj.RTFText; oldObj.Text = dbObj.Text; return(context.SaveChanges()); } return(0); } }
/// <summary> /// 向数据库中加入一条新记录 /// </summary> /// <param name="dataInfoObject"></param> /// <returns></returns> public int Create(DetailTextDB dbObj) { if (dbObj == null) { return -1; } using (InfocenterEntities context = new InfocenterEntities(DALConfig.ConnectString)) { context.DetailTextDBs.Add(dbObj); return context.SaveChanges(); } }
/// <summary> /// 向数据库中加入一条新记录 /// </summary> /// <param name="dataInfoObject"></param> /// <returns></returns> public int Create(DetailTextDB dbObj) { if (dbObj == null) { return(-1); } using (InfocenterEntities context = new InfocenterEntities(EFConnectionString)) { context.DetailTextDBs.Add(dbObj); Console.WriteLine("详细节点的Create()方法:Text:{0},Path:{1},EFConnectionString:{2}", dbObj.Text, dbObj.Path, EFConnectionString); return(context.SaveChanges()); } }
/// <summary> /// 向数据库中加入一条新记录 /// </summary> /// <param name="dataInfoObject"></param> /// <returns></returns> public int Create(DetailTextDB dbObj) { if (dbObj == null) { return -1; } using (InfocenterEntities context = new InfocenterEntities(EFConnectionString)) { context.DetailTextDBs.Add(dbObj); Console.WriteLine("详细节点的Create()方法:Text:{0},Path:{1},EFConnectionString:{2}", dbObj.Text, dbObj.Path, EFConnectionString); return context.SaveChanges(); } }
public int Create(IDataInfo dataInfoObject) { if (dataInfoObject == null || (dataInfoObject as DetailTextInfo) == null) { return(0); } DetailTextDB dbobj = DetailTextHelper.changeToDetailTextDB(dataInfoObject as DetailTextInfo); int result = repository.Create(dbobj); //将数据库生成的ID值传回 dataInfoObject.ID = dbobj.ID; return(result); }
/// <summary> /// 按照路径提取DetailTextDB对象 /// </summary> /// <param name="nodePath"></param> /// <returns></returns> public DetailTextDB GetDataInfoObjectByPath(string nodePath) { if (String.IsNullOrEmpty(nodePath)) { return(null); } using (InfocenterEntities context = new InfocenterEntities(EFConnectionString)) { DetailTextDB dbobj = context.DetailTextDBs.FirstOrDefault(o => o.Path == nodePath); if (dbobj != null) { return(dbobj); } } return(null); }
public static DetailTextInfo changeToDetailTextInfo(DetailTextDB dbobj) { if (dbobj == null) { return null; } DetailTextInfo obj = new DetailTextInfo() { Text = String.IsNullOrEmpty(dbobj.Text)?"":dbobj.Text, RTFText = dbobj.RTFText==null?"":Encoding.UTF8.GetString(dbobj.RTFText), Path = dbobj.Path, ModifyTime = dbobj.ModifyTime, ID = dbobj.ID }; return obj; }
public static DetailTextInfo changeToDetailTextInfo(DetailTextDB dbobj) { if (dbobj == null) { return(null); } DetailTextInfo obj = new DetailTextInfo() { Text = String.IsNullOrEmpty(dbobj.Text)?"":dbobj.Text, RTFText = dbobj.RTFText == null?"":Encoding.UTF8.GetString(dbobj.RTFText), Path = dbobj.Path, ModifyTime = dbobj.ModifyTime, ID = dbobj.ID }; return(obj); }
/// <summary> /// 根据节点路径提取节点数据,如果未找到,返回null /// </summary> /// <param name="nodePath"></param> /// <returns></returns> public IDataInfo GetDataInfoObjectByPath(string nodePath) { if (String.IsNullOrEmpty(nodePath)) { return(null); } DetailTextDB dbobj = repository.GetDataInfoObjectByPath(nodePath); if (dbobj == null) { return(null); } DetailTextInfo infoObj = DetailTextHelper.changeToDetailTextInfo(dbobj); //设置数据己装入标记 infoObj.HasBeenLoadFromStorage = true; return(infoObj); }
public static DetailTextDB changeToDetailTextDB(DetailTextInfo obj) { if (obj == null) { return null; } //注意数据库中nvarchar最大允许4000个字符 if (obj.Text != null && obj.Text.Length > DALConfig.MaxTextFieldSize) { obj.Text = obj.Text.Substring(0, DALConfig.MaxTextFieldSize); } DetailTextDB dbObj = new DetailTextDB() { ModifyTime = obj.ModifyTime, Path = obj.Path, RTFText = String.IsNullOrEmpty(obj.RTFText) ? null : Encoding.UTF8.GetBytes(obj.RTFText), Text = String.IsNullOrEmpty(obj.Text)?"":obj.Text, ID = obj.ID }; return dbObj; }
public static DetailTextDB changeToDetailTextDB(DetailTextInfo obj) { if (obj == null) { return(null); } //注意数据库中nvarchar最大允许4000个字符 if (obj.Text != null && obj.Text.Length > DALConfig.MaxTextFieldSize) { obj.Text = obj.Text.Substring(0, DALConfig.MaxTextFieldSize); } DetailTextDB dbObj = new DetailTextDB() { ModifyTime = obj.ModifyTime, Path = obj.Path, RTFText = String.IsNullOrEmpty(obj.RTFText) ? null : Encoding.UTF8.GetBytes(obj.RTFText), Text = String.IsNullOrEmpty(obj.Text)?"":obj.Text, ID = obj.ID }; return(dbObj); }
/// <summary> /// 将对象的当前值写入数据库 /// </summary> /// <param name="dataInfoObject"></param> /// <returns></returns> public int UpdateDataInfoObject(IDataInfo dataInfoObject) { DetailTextInfo obj = dataInfoObject as DetailTextInfo; if (obj.Text.Length > DALConfig.MaxTextFieldSize) { obj.Text = obj.Text.Substring(0, DALConfig.MaxTextFieldSize); } if (dataInfoObject == null || obj == null) { return(0); } bool isNew = false; DetailTextDB dbobj = repository.GetDataInfoObjectByPath(obj.Path); if (dbobj == null) { dbobj = new DetailTextDB(); isNew = true; } if (String.IsNullOrEmpty(dbobj.Text) == false && String.IsNullOrEmpty(obj.Text)) { ShowWarningInfo(String.Format("更新节点{0}时,发现数据库记录中的Text字段不为空,但尝试写入一个空的字串,这有可能是个错误,特此提示。", obj.Path)); } dbobj.ModifyTime = obj.ModifyTime; dbobj.Text = obj.Text; dbobj.Path = obj.Path; dbobj.RTFText = (String.IsNullOrEmpty(obj.RTFText))?null:Encoding.UTF8.GetBytes(obj.RTFText); if (isNew) { return(repository.Create(dbobj)); } else { return(repository.Update(dbobj)); } }
/// <summary> /// 将对象的当前值写入数据库 /// </summary> /// <param name="dataInfoObject"></param> /// <returns></returns> public int UpdateDataInfoObject(IDataInfo dataInfoObject) { DetailTextInfo obj=dataInfoObject as DetailTextInfo; if (obj.Text.Length > DALConfig.MaxTextFieldSize) { obj.Text = obj.Text.Substring(0, DALConfig.MaxTextFieldSize); } if (dataInfoObject == null || obj == null) { return 0; } bool isNew = false; DetailTextDB dbobj = repository.GetDataInfoObjectByPath(obj.Path); if (dbobj == null) { dbobj = new DetailTextDB(); isNew = true; } if (String.IsNullOrEmpty(dbobj.Text) == false && String.IsNullOrEmpty(obj.Text)) { ShowWarningInfo(String.Format("更新节点{0}时,发现数据库记录中的Text字段不为空,但尝试写入一个空的字串,这有可能是个错误,特此提示。",obj.Path)); } dbobj.ModifyTime = obj.ModifyTime; dbobj.Text = obj.Text; dbobj.Path = obj.Path; dbobj.RTFText = (String.IsNullOrEmpty(obj.RTFText))?null:Encoding.UTF8.GetBytes(obj.RTFText); if (isNew) { return repository.Create(dbobj); } else { return repository.Update(dbobj); } }
/// <summary> /// 将对象的当前值写入数据库 /// </summary> /// <param name="dataInfoObject"></param> /// <returns></returns> public int UpdateDataInfoObject(IDataInfo dataInfoObject) { DetailTextInfo obj=dataInfoObject as DetailTextInfo; if (obj.Text.Length > DALConfig.MaxTextFieldSize) { obj.Text = obj.Text.Substring(0, DALConfig.MaxTextFieldSize); } if (dataInfoObject == null || obj == null) { return 0; } bool isNew = false; DetailTextDB dbobj = repository.GetDataInfoObjectByPath(obj.Path); if (dbobj == null) { dbobj = new DetailTextDB(); isNew = true; } dbobj.ModifyTime = obj.ModifyTime; dbobj.Text = obj.Text; dbobj.Path = obj.Path; dbobj.RTFText = (String.IsNullOrEmpty(obj.RTFText))?null:Encoding.UTF8.GetBytes(obj.RTFText); if (isNew) { return repository.Create(dbobj); } else { return repository.Update(dbobj); } }
public int Update(DetailTextDB dbObj) { if (dbObj == null) { return 0; } using (InfocenterEntities context = new InfocenterEntities(DALConfig.ConnectString)) { DetailTextDB oldObj = context.DetailTextDBs.FirstOrDefault(o => o.ID == dbObj.ID); if (oldObj != null) { //最大的字段长度为3000 if (dbObj.Text.Length >DALConfig.MaxTextFieldSize) { dbObj.Text.Substring(0, DALConfig.MaxTextFieldSize); } //更新数据库 oldObj.ModifyTime = dbObj.ModifyTime; oldObj.Path = dbObj.Path; oldObj.RTFText = dbObj.RTFText; oldObj.Text = dbObj.Text; return context.SaveChanges(); } return 0; } }