Example #1
0
 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();
     }
 }
Example #3
0
 /// <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();
     }
 }
Example #5
0
        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);
        }
Example #6
0
 /// <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;
        }
Example #8
0
        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);
        }
Example #9
0
        /// <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;
        }
Example #11
0
        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);
        }
Example #12
0
        /// <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;
     }
 }