예제 #1
0
        /// <summary>
        /// 获取文章详情
        /// </summary>
        /// <returns></returns>
        public ArticleDetial GetArticleDetial(int aid)
        {
            ArticleDetial result = new ArticleDetial();

            try
            {
                result.BaseInfro = GetArchives(aid);
                result.Body      = GetAddonarticle(aid);
                //修改点击次数
                UpdataClickCount(aid);
                //获取当前登录人
                AccountProvider _AccountProvider = new AccountProvider();
                var             user             = _AccountProvider.GetCurrentUser();
                if (user == null)
                {
                    return(result);
                }
                //验证是否被关注
                result.isFouce = IsFocues(result.BaseInfro.writer, user.id);
                //验证是否被收藏
                result.isCollection = IsCollection(result.BaseInfro.id, user.id);
            }
            catch (Exception ex)
            {
                LogFactory _LogFactory = new LogFactory(this.GetType());
                _LogFactory.CreateLog(LogType.Error, "获取文章详情", "GetArticleDetial", ex);
            }
            return(result);
        }
예제 #2
0
        /// <summary>
        /// 获取关注作者列表
        /// </summary>
        /// <param name="Start"></param>
        /// <param name="PageSize"></param>
        /// <returns></returns>
        public List <Concerns> GetConcernsList(int StartRow, int PageSize)
        {
            List <Concerns> result = new List <Concerns>();

            try
            {
                //获取当前用户
                AccountProvider _AccountProvider = new AccountProvider();
                var             user             = _AccountProvider.GetCurrentUser();
                if (user == null || user.id == 0)
                {
                    return(result);
                }
                string      sql     = "select * from de2_concerns where createID=@userID order by createTime DESC";
                MySqlClient _client = new MySqlClient();
                result = _client.ExecuteQuery <Concerns>(sql.ToString(),
                                                         new MySqlParameter("@userID", user.id));
            }
            catch (Exception ex)
            {
                LogFactory _LogFactory = new LogFactory(this.GetType());
                _LogFactory.CreateLog(LogType.Error, "获取关注作者列表", "GetCollectionList", ex);
            }
            return(result);
        }
예제 #3
0
        /// <summary>
        /// 获取头条新闻
        /// </summary>
        /// <param name="Count"></param>
        /// <returns></returns>
        public List <Archives> GetHeadline(int Count)
        {
            List <Archives> Result = new List <Archives>();

            try
            {
                log.SaveLog("开始获取数据!");
                AccountProvider _AccountProvider = new AccountProvider();
                //获取访问权限
                int VewBrowsePermissions = _AccountProvider.GetBrowsePermissions();
                //生成检索语句
                string sql = string.Format("select * from de2_archives where  flag like '%h%' and arcrank!=-1 and( arcrank=0 or arcrank={0} )order by sortrank desc limit @limit", VewBrowsePermissions);

                MySqlClient _client = new MySqlClient();
                log.SaveLog("开始执行SQL!");
                Result = _client.ExecuteQuery <Archives>(sql, new MySqlParameter("@limit", Count));
                log.SaveLog("完成SQL!");
                Result = FromateLitpic(Result);
            }
            catch (Exception ex)
            {
                log.SaveLog("执行错误!" + ex.Message);
                LogFactory _LogFactory = new LogFactory(this.GetType());
                _LogFactory.CreateLog(LogType.Error, "获取头条新闻", "GetHeadline", ex);
            }
            return(Result);
        }
예제 #4
0
        /// <summary>
        /// 添加关注
        /// </summary>
        /// <param name="Data"></param>
        /// <returns></returns>
        public bool AddConcerns(Concerns Data)
        {
            try
            {
                //获取当前用户
                AccountProvider _AccountProvider = new AccountProvider();
                var             user             = _AccountProvider.GetCurrentUser();
                if (user == null || user.id == 0)
                {
                    return(false);
                }
                //判断是否已经关注
                if (IsFocues(Data.authorName, user.id))
                {
                    return(true);
                }

                Data.authorID   = 0;
                Data.createID   = user.id;
                Data.createTime = DateTime.Now;
                string      sql          = "insert into de2_concerns(authorID,authorName,createTime,createID) values(@authorID,@authorName,@createTime,@createID)";
                MySqlClient _MySqlClient = new MySqlClient();
                _MySqlClient.ExecuteNonQuery(sql, new MySqlParameter("@authorID", Data.authorID),
                                             new MySqlParameter("@authorName", Data.authorName),
                                             new MySqlParameter("@createTime", Data.createTime),
                                             new MySqlParameter("@createID", Data.createID));
                return(true);
            }
            catch (Exception ex)
            {
                LogFactory _LogFactory = new LogFactory(this.GetType());
                _LogFactory.CreateLog(LogType.Error, "添加关注", "AddConcerns", ex);
                return(false);
            }
        }
예제 #5
0
        /// <summary>
        /// 修改目录
        /// </summary>
        /// <param name="Param"></param>
        /// <returns></returns>
        public BaseResopne <string> UpdateResourceMenu(AcademicResources_Menu Param)
        {
            BaseResopne <string> result = new BaseResopne <string>();

            try
            {
                //获取当前登录人
                AccountProvider _AccountProvider = new AccountProvider();
                var             user             = _AccountProvider.GetCurrentUser();
                if (user == null)
                {
                    result.IsSuccess = false;
                    result.Error     = "获取当前用户信息失败";
                    return(result);
                }
                Param.lastModifyTime  = DateTime.Now;
                Param.lastModifyUsrID = user.id;
                string sql = @"update  de2_aresource_menu set title=@title,parentID=@parentID,sourceTypeID=@sourceTypeID,author=@author,lastModifyUsrID=@lastModifyUsrID,lastModifyTime=@lastModifyTime";
                //执行sql
                MySqlClient _Client    = new MySqlClient();
                var         ResourceID = _Client.Inster(sql
                                                        , new MySqlParameter("@title", Param.title)
                                                        , new MySqlParameter("@parentID", Param.parentID)
                                                        , new MySqlParameter("@sourceTypeID", Param.sourceTypeID)
                                                        , new MySqlParameter("@author", Param.author)
                                                        , new MySqlParameter("@lastModifyUsrID", Param.lastModifyUsrID)
                                                        , new MySqlParameter("@lastModifyTime", Param.lastModifyTime));
                //判断文件路径是否为空
                if (!string.IsNullOrEmpty(Param.resourceFile))
                {
                    AcademicResources_File _AcademicResources_File = new AcademicResources_File();
                    _AcademicResources_File.lastModifyTime  = DateTime.Now;
                    _AcademicResources_File.lastModifyUsrID = user.id;
                    _AcademicResources_File.parentID        = Param.id;
                    _AcademicResources_File.sourceTypeID    = Param.sourceTypeID;
                    _AcademicResources_File.targetFileUrl   = Param.resourceFile;
                    _AcademicResources_File.title           = Param.title;
                    UpdateResourcesFile(_AcademicResources_File);
                }
                else
                {
                    result.IsSuccess = false;
                    result.Error     = "资源文件路径为空";
                    return(result);
                }
                result.IsSuccess = true;
            }
            catch (Exception ex)
            {
                LogFactory _LogFactory = new LogFactory(this.GetType());
                _LogFactory.CreateLog(LogType.Error, "修改目录", "UpdateResourceMenu", ex);
                result.IsSuccess = false;
            }
            return(result);
        }
예제 #6
0
        /// <summary>
        /// 权限验证
        /// </summary>
        /// <param name="RoleType"></param>
        /// <returns></returns>
        public bool CheckAuthor(string RoleType)
        {
            //验证是否登陆
            AccountProvider _Provider = new AccountProvider();
            var             user      = _Provider.GetCurrentUser();

            if (user == null)
            {
                return(false);
            }
            return(true);
        }
예제 #7
0
        /// <summary>
        /// 保存资源文件
        /// </summary>
        /// <param name="Data"></param>
        /// <returns></returns>
        public BaseResopne <Int32> SaveResourcesFile(AcademicResources_File Data)
        {
            BaseResopne <Int32> result = new BaseResopne <Int32>();

            try
            {
                //获取当前登录
                AccountProvider _AccountProvider = new AccountProvider();
                var             user             = _AccountProvider.GetCurrentUser();
                if (user == null)
                {
                    result.IsSuccess = false;
                    result.Error     = "获取当前用户信息失败";
                    return(result);
                }
                //判断数据是否存在
                StringBuilder sql = new StringBuilder();
                sql.AppendLine("select count(id) from de2_aresource_file where parentID=@parentID");
                MySqlClient _Client = new MySqlClient();
                var         count   = Convert.ToInt32(_Client.ExecuteScalar(sql.ToString(), new MySqlParameter("@parentID", Data.parentID)));
                if (count == 0)
                {
                    Data.createTime      = DateTime.Now;
                    Data.createUserID    = user.id;
                    Data.lastModifyTime  = DateTime.Now;
                    Data.lastModifyUsrID = user.id;
                    AddResourcesFile(Data);
                }
                else
                {
                    Data.lastModifyTime  = DateTime.Now;
                    Data.lastModifyUsrID = user.id;
                    AddResourcesFile(Data);
                }
            }
            catch (Exception ex)
            {
                LogFactory _LogFactory = new LogFactory(this.GetType());
                _LogFactory.CreateLog(LogType.Error, "保存资源文件", "SaveResourcesFile", ex);
                result.IsSuccess = false;
            }
            return(result);
        }
예제 #8
0
        /// <summary>
        /// 新建工作计划
        /// </summary>
        /// <param name="Data"></param>
        /// <returns></returns>
        public bool AddWorkPlan(WorkPlan Data)
        {
            try
            {
                AccountProvider _AccountProvider = new AccountProvider();
                var             user             = _AccountProvider.GetCurrentUser();
                string          sql = @"insert into de2_workplan  (`year`,startTime,endTime,name,content,scale,addressProvinceID,addressProvince,addressCityID,addressCity,address,createTime,lastModifyTime,createUserID,workPlanTypeID) 
                              values (@`year`,@startTime,@endTime,@name,@content,@scale,@addressProvinceID,@addressProvince,@addressCityID,@addressCity,@address,@createTime,@lastModifyTime,@createUserID,@workPlanTypeID)";
                Data.createTime     = DateTime.Now;
                Data.lastModifyTime = DateTime.Now;
                if (user == null)
                {
                    Data.createUserID = user.id;
                }
                MySqlClient _Client = new MySqlClient();
                Data.id = (int)_Client.Inster(sql,
                                              new MySqlParameter("@`year`", Data.year)
                                              , new MySqlParameter("@startTime", Data.startTime)
                                              , new MySqlParameter("@endTime", Data.endTime)
                                              , new MySqlParameter("@name", Data.name)
                                              , new MySqlParameter("@content", Data.content)
                                              , new MySqlParameter("@scale", Data.scale)
                                              , new MySqlParameter("@addressProvinceID", Data.addressProvinceID)
                                              , new MySqlParameter("@addressProvince", Data.addressProvince)
                                              , new MySqlParameter("@addressCityID", Data.addressCityID)
                                              , new MySqlParameter("@addressCity", Data.addressCity)
                                              , new MySqlParameter("@address", Data.address)
                                              , new MySqlParameter("@createTime", Data.createTime)
                                              , new MySqlParameter("@lastModifyTime", Data.lastModifyTime)
                                              , new MySqlParameter("@createUserID", Data.createUserID)
                                              , new MySqlParameter("@workPlanTypeID", Data.workPlanTypeID));

                SaveWorkPlanContacts(Data);
                return(true);
            }
            catch (Exception ex)
            {
                LogFactory _LogFactory = new LogFactory(this.GetType());
                _LogFactory.CreateLog(LogType.Error, "新建工作计划", "AddWorkPlan", ex);
                return(false);
            }
        }
예제 #9
0
        /// <summary>
        /// 删除学术资源
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public BaseResopne <string> DelAcademicResources(int id)
        {
            BaseResopne <string> result = new BaseResopne <string>();

            try
            {
                //获取当前登录人
                AccountProvider _AccountProvider = new AccountProvider();
                var             user             = _AccountProvider.GetCurrentUser();
                if (user == null)
                {
                    result.IsSuccess = false;
                    result.Error     = "获取当前用户信息失败";
                    return(result);
                }
                //获取资源信息
                var Resource = GetAcademicResources(id);
                if (Resource == null)
                {
                    result.IsSuccess = false;
                    result.Error     = "查询数据不存在";
                    return(result);
                }

                result.IsSuccess = DelAcademicResources(Resource);
                if (!result.IsSuccess)
                {
                    result.Error = "数据删除失败";
                }
            }
            catch (Exception ex)
            {
                LogFactory _LogFactory = new LogFactory(this.GetType());
                _LogFactory.CreateLog(LogType.Error, "删除学术资源", "DelAcademicResources", ex);
                result.IsSuccess = false;
            }
            return(result);
        }
예제 #10
0
 /// <summary>
 /// 取消关注
 /// </summary>
 /// <param name="author">作者</param>
 /// <returns></returns>
 public bool CancelConcerns(string author)
 {
     try
     {
         //获取当前登录人
         AccountProvider _AccountProvider = new AccountProvider();
         var             user             = _AccountProvider.GetCurrentUser();
         if (user == null)
         {
             return(false);
         }
         string      sql     = "delete from de2_concerns where authorName=@authorName  and createID=@createID";
         MySqlClient _Client = new MySqlClient();
         _Client.ExecuteNonQuery(sql, new MySqlParameter("@authorName", author), new MySqlParameter("@createID", user.id));
         return(true);
     }
     catch (Exception ex)
     {
         LogFactory _LogFactory = new LogFactory(this.GetType());
         _LogFactory.CreateLog(LogType.Error, "取消关注", "CancelConcerns", ex);
         return(false);
     }
 }
예제 #11
0
        /// <summary>
        /// 获取收藏列表
        /// </summary>
        /// <param name="Start"></param>
        /// <param name="PageSize"></param>
        /// <returns></returns>
        public List <Archives> GetCollectionList(int StartRow, int PageSize)
        {
            List <Archives> result = new List <Archives>();

            try
            {
                //获取当前用户
                AccountProvider _AccountProvider = new AccountProvider();
                var             user             = _AccountProvider.GetCurrentUser();
                if (user == null || user.id == 0)
                {
                    return(result);
                }
                NewsProvider _NewsProvider = new NewsProvider();
                result = _NewsProvider.GetCollectionList(StartRow, PageSize, user.id);
            }
            catch (Exception ex)
            {
                LogFactory _LogFactory = new LogFactory(this.GetType());
                _LogFactory.CreateLog(LogType.Error, "获取收藏列表", "GetCollectionList", ex);
            }
            return(result);
        }
예제 #12
0
 /// <summary>
 /// 取消收藏
 /// </summary>
 /// <param name="aid">文章编号</param>
 /// <returns></returns>
 public bool CancelColletion(int aid)
 {
     try
     {
         //获取当前登录人
         AccountProvider _AccountProvider = new AccountProvider();
         var             user             = _AccountProvider.GetCurrentUser();
         if (user == null)
         {
             return(false);
         }
         string      sql     = "delete from de2_collection where aid=@aid  and createID=@createID";
         MySqlClient _Client = new MySqlClient();
         _Client.ExecuteNonQuery(sql, new MySqlParameter("@aid", aid), new MySqlParameter("@createID", user.id));
         return(true);
     }
     catch (Exception ex)
     {
         LogFactory _LogFactory = new LogFactory(this.GetType());
         _LogFactory.CreateLog(LogType.Error, "删除收藏", "DelColletion", ex);
         return(false);
     }
 }
예제 #13
0
 /// <summary>
 /// 修改工作计划
 /// </summary>
 /// <param name="Data"></param>
 /// <returns></returns>
 public bool UpdateWorkPlan(WorkPlan Data)
 {
     try
     {
         AccountProvider _AccountProvider = new AccountProvider();
         var             user             = _AccountProvider.GetCurrentUser();
         string          sql = "update de2_workplan set `year`=@`year`,startTime=@startTime,endTime=@endTime,name=@name,content=@content,scale=@scale,addressProvinceID=@addressProvinceID,addressProvince=@addressProvince,addressCityID=@addressCityID,addressCity=@addressCity,address=@address,lastModifyTime=@lastModifyTime,workPlanTypeID=@workPlanTypeID where id=@id"; Data.lastModifyTime = DateTime.Now;
         if (user == null)
         {
             Data.createUserID = user.id;
         }
         MySqlClient _Client = new MySqlClient();
         _Client.ExecuteNonQuery(sql,
                                 new MySqlParameter("@`year`", Data.year)
                                 , new MySqlParameter("@startTime", Data.startTime)
                                 , new MySqlParameter("@endTime", Data.endTime)
                                 , new MySqlParameter("@name", Data.name)
                                 , new MySqlParameter("@content", Data.content)
                                 , new MySqlParameter("@scale", Data.scale)
                                 , new MySqlParameter("@addressProvinceID", Data.addressProvinceID)
                                 , new MySqlParameter("@addressProvince", Data.addressProvince)
                                 , new MySqlParameter("@addressCityID", Data.addressCityID)
                                 , new MySqlParameter("@addressCity", Data.addressCity)
                                 , new MySqlParameter("@address", Data.address)
                                 , new MySqlParameter("@lastModifyTime", Data.lastModifyTime)
                                 , new MySqlParameter("@workPlanTypeID", Data.workPlanTypeID)
                                 , new MySqlParameter("@id", Data.id));
         SaveWorkPlanContacts(Data);
         return(true);
     }
     catch (Exception ex)
     {
         LogFactory _LogFactory = new LogFactory(this.GetType());
         _LogFactory.CreateLog(LogType.Error, "修改工作计划", "UpdateWorkPlan", ex);
         return(false);
     }
 }
예제 #14
0
        /// <summary>
        /// 修改学术资源发布状态
        /// </summary>
        /// <param name="Data"></param>
        /// <returns></returns>
        public BaseResopne <string> UpdatePublishStatue(AcademicResources Data)
        {
            BaseResopne <string> result = new BaseResopne <string>();

            try
            {
                //获取当前登录人
                AccountProvider _AccountProvider = new AccountProvider();
                var             user             = _AccountProvider.GetCurrentUser();
                if (user == null)
                {
                    result.IsSuccess = false;
                    result.Error     = "获取当前用户信息失败";
                    return(result);
                }
                Data.lastModifyTime  = DateTime.Now;
                Data.lastModifyUsrID = user.id;

                StringBuilder sql = new StringBuilder();
                sql.AppendLine(@"update  de2_aresource set isPublish=@isPublish,lastModifyTime=@lastModifyTime,lastModifyUsrID=@lastModifyUsrID where id=@id");
                //执行sql语句
                MySqlClient _Client = new MySqlClient();
                _Client.ExecuteNonQuery(sql.ToString()
                                        , new MySqlParameter("@isPublish", Data.isPublish)
                                        , new MySqlParameter("@lastModifyTime", Data.lastModifyTime)
                                        , new MySqlParameter("@lastModifyUsrID", Data.lastModifyUsrID)
                                        , new MySqlParameter("@id", Data.id));
                result.IsSuccess = true;
            }
            catch (Exception ex)
            {
                LogFactory _LogFactory = new LogFactory(this.GetType());
                _LogFactory.CreateLog(LogType.Error, "修改学术资源发布状态", "UpdatePublishStatue", ex);
                result.IsSuccess = false;
            }
            return(result);
        }
예제 #15
0
        /// <summary>
        /// 保存学术资源信息
        /// </summary>
        /// <param name="Data"></param>
        /// <returns></returns>
        public BaseResopne <Int32> AddAcademicResources(AcademicResources Data)
        {
            BaseResopne <Int32> result = new BaseResopne <Int32>();

            try
            {
                //获取当前登录人
                AccountProvider _AccountProvider = new AccountProvider();
                var             user             = _AccountProvider.GetCurrentUser();
                if (user == null)
                {
                    result.IsSuccess = false;
                    result.Error     = "获取当前用户信息失败";
                    return(result);
                }
                Data.createUserID    = user.id;
                Data.createTime      = DateTime.Now;
                Data.lastModifyTime  = DateTime.Now;
                Data.lastModifyUsrID = user.id;
                //生成sql
                StringBuilder sql = new StringBuilder();
                sql.AppendLine(@"insert into de2_aresource (`name`,parentID,sourceTypeID,createTime,createUserID,isChild,author,isPublish,`year`,periodNumber,lastModifyTime,lastModifyUsrID,isMenu) values(@`name`,@parentID,@sourceTypeID,@createTime,@createUserID,@isChild,@author,@isPublish,@`year`,@periodNumber,@lastModifyTime,@lastModifyUsrID,@isMenu)");
                //执行sql语句
                MySqlClient _Client    = new MySqlClient();
                var         ResourceID = _Client.Inster(sql.ToString()
                                                        , new MySqlParameter("@`name`", Data.name)
                                                        , new MySqlParameter("@parentID", Data.parentID)
                                                        , new MySqlParameter("@sourceTypeID", Data.sourceTypeID)
                                                        , new MySqlParameter("@createTime", Data.createTime)
                                                        , new MySqlParameter("@createUserID", Data.createUserID)
                                                        , new MySqlParameter("@isChild", Data.isChild)
                                                        , new MySqlParameter("@author", Data.author)
                                                        , new MySqlParameter("@isPublish", Data.isPublish)
                                                        , new MySqlParameter("@`year`", Data.year)
                                                        , new MySqlParameter("@periodNumber", Data.periodNumber)
                                                        , new MySqlParameter("@lastModifyTime", Data.lastModifyTime)
                                                        , new MySqlParameter("@lastModifyUsrID", Data.lastModifyUsrID)
                                                        , new MySqlParameter("@isMenu", Data.isMenu));
                result.Data = Convert.ToInt32(ResourceID);
                //判断文件路径是否为空
                if (!string.IsNullOrEmpty(Data.resourceFile))
                {
                    AcademicResources_File _AcademicResources_File = new AcademicResources_File();
                    _AcademicResources_File.lastModifyTime  = DateTime.Now;
                    _AcademicResources_File.lastModifyUsrID = user.id;
                    _AcademicResources_File.createTime      = DateTime.Now;
                    _AcademicResources_File.createUserID    = user.id;
                    _AcademicResources_File.parentID        = Convert.ToInt32(ResourceID);
                    _AcademicResources_File.sourceTypeID    = Data.sourceTypeID;
                    _AcademicResources_File.targetFileUrl   = Data.resourceFile;
                    _AcademicResources_File.title           = Data.name;
                    AddResourcesFile(_AcademicResources_File);
                }
                result.IsSuccess = true;
            }
            catch (Exception ex)
            {
                LogFactory _LogFactory = new LogFactory(this.GetType());
                _LogFactory.CreateLog(LogType.Error, "保存学术资源信息", "AddAcademicResources", ex);
                result.IsSuccess = false;
            }
            return(result);
        }
예제 #16
0
        /// <summary>
        /// 根据新闻类型获取新闻列表
        /// </summary>
        /// <param name="StartRow"></param>
        /// <param name="PageSize"></param>
        /// <param name="TypeID"></param>
        /// <param name="Author"></param>
        /// <returns></returns>
        public BaseResopne <List <Archives> > GetNewsByTypeID(int StartRow, int PageSize, string TypeID, string SearchKey)
        {
            BaseResopne <List <Archives> > Result = new BaseResopne <List <Archives> >();

            try
            {
                AccountProvider _AccountProvider = new AccountProvider();
                //获取访问权限
                int VewBrowsePermissions = _AccountProvider.GetBrowsePermissions();

                //生成检索语句
                StringBuilder sql      = new StringBuilder();
                StringBuilder countsql = new StringBuilder();
                sql.AppendLine("select * from de2_archives where arcrank!=-1 and ( arcrank=0 or arcrank=@Permissions)");
                countsql.AppendLine("select count(id) from de2_archives where arcrank!=-1 and ( arcrank=0 or arcrank=@Permissions)");
                if (!string.IsNullOrEmpty(TypeID))
                {
                    if (TypeID.IndexOf(",") > 0)
                    {
                        sql.AppendLine("and typeid in (" + TypeID + ")");
                        countsql.AppendLine("and typeid in (" + TypeID + ")");
                    }
                    else
                    {
                        sql.AppendLine(" and typeid=@typeid ");
                        countsql.AppendLine(" and typeid=@typeid ");
                    }
                }
                if (!string.IsNullOrEmpty(SearchKey))
                {
                    sql.AppendLine(" and (writer like @SearchKey or  title like @SearchKey or  keywords like @SearchKey)");
                    countsql.AppendLine(" and (writer like @SearchKey or  title like @SearchKey or  keywords like @SearchKey) ");
                }

                sql.AppendLine(" order by sortrank desc");
                sql.AppendLine(" limit @start,@count ");
                MySqlClient _client = new MySqlClient();
                Result.Total = Convert.ToInt32(_client.ExecuteScalar(countsql.ToString(),
                                                                     new MySqlParameter("@start", StartRow),
                                                                     new MySqlParameter("@count", PageSize),
                                                                     new MySqlParameter("@Permissions", VewBrowsePermissions),
                                                                     new MySqlParameter("@typeid", TypeID),
                                                                     new MySqlParameter("@SearchKey", "%" + SearchKey + "%")));

                Result.Data = _client.ExecuteQuery <Archives>(sql.ToString(),
                                                              new MySqlParameter("@start", StartRow),
                                                              new MySqlParameter("@count", PageSize),
                                                              new MySqlParameter("@Permissions", VewBrowsePermissions),
                                                              new MySqlParameter("@typeid", TypeID),
                                                              new MySqlParameter("@SearchKey", "%" + SearchKey + "%"));

                Result.Data = FromateLitpic(Result.Data);
            }
            catch (Exception ex)
            {
                LogFactory _LogFactory = new LogFactory(this.GetType());
                _LogFactory.CreateLog(LogType.Error, "根据新闻类型获取新闻列表", "GetNewsByTypeID", ex);
                Result.IsSuccess = false;
                Result.Error     = ex.Message;
            }
            return(Result);
        }
예제 #17
0
        /// <summary>
        /// 修改学术资源信息
        /// </summary>
        /// <param name="Data"></param>
        /// <returns></returns>
        public BaseResopne <string> UpdateAcademicResources(AcademicResources Data)
        {
            BaseResopne <string> result = new BaseResopne <string>();

            try
            {
                //获取当前登录人
                AccountProvider _AccountProvider = new AccountProvider();
                var             user             = _AccountProvider.GetCurrentUser();
                if (user == null)
                {
                    result.IsSuccess = false;
                    result.Error     = "获取当前用户信息失败";
                    return(result);
                }
                Data.lastModifyTime  = DateTime.Now;
                Data.lastModifyUsrID = user.id;
                //生成sql
                StringBuilder sql = new StringBuilder();
                sql.AppendLine(@"update  de2_aresource set `name`=@`name`,parentID=@parentID,sourceTypeID=@sourceTypeID,isChild=@,author=@,isPublish=@isPublish,`year`=@`year`,periodNumber=@periodNumber,lastModifyTime=@lastModifyTime,lastModifyUsrID=@lastModifyUsrID,isMenu=@isMenu where id=@id");
                //执行sql语句
                MySqlClient _Client = new MySqlClient();
                _Client.ExecuteNonQuery(sql.ToString()
                                        , new MySqlParameter("@`name`", Data.name)
                                        , new MySqlParameter("@parentID", Data.parentID)
                                        , new MySqlParameter("@sourceTypeID", Data.sourceTypeID)
                                        , new MySqlParameter("@isChild", Data.isChild)
                                        , new MySqlParameter("@author", Data.author)
                                        , new MySqlParameter("@isPublish", Data.isPublish)
                                        , new MySqlParameter("@`year`", Data.year)
                                        , new MySqlParameter("@periodNumber", Data.periodNumber)
                                        , new MySqlParameter("@lastModifyTime", Data.lastModifyTime)
                                        , new MySqlParameter("@lastModifyUsrID", Data.lastModifyUsrID)
                                        , new MySqlParameter("@isMenu", Data.isMenu)
                                        , new MySqlParameter("@id", Data.id));
                //判断文件路径是否为空
                if (string.IsNullOrEmpty(Data.resourceFile))
                {
                    AcademicResources_File _AcademicResources_File = new AcademicResources_File();
                    _AcademicResources_File.lastModifyTime  = DateTime.Now;
                    _AcademicResources_File.lastModifyUsrID = user.id;
                    _AcademicResources_File.parentID        = Data.id;
                    _AcademicResources_File.sourceTypeID    = Data.sourceTypeID;
                    _AcademicResources_File.targetFileUrl   = Data.resourceFile;
                    _AcademicResources_File.title           = Data.name;
                    UpdateResourcesFile(_AcademicResources_File);
                }
                else
                {
                    DelResourcesFileByParent(Data.id);
                }
                result.IsSuccess = true;
            }
            catch (Exception ex)
            {
                LogFactory _LogFactory = new LogFactory(this.GetType());
                _LogFactory.CreateLog(LogType.Error, "修改学术资源信息", "UpdateAcademicResources", ex);
                result.IsSuccess = false;
            }
            return(result);
        }