/// <summary> /// 获取学术资源列表 /// </summary> /// <param name="Param"></param> /// <returns></returns> public BaseResopne <List <AcademicResources> > GetAcademicResourcesListForManager(GetPeriodicalListParam Param) { return(GetAcademicResourcesList(Param, true)); }
/// <summary> /// 获取学术资源列表应用 /// </summary> /// <param name="Param"></param> /// <returns></returns> public BaseResopne <List <AcademicResources> > GetAcademicResourcesListForApp(GetPeriodicalListParam Param) { return(GetAcademicResourcesList(Param, false)); }
/// <summary> /// 获取学术资源列表 /// </summary> /// <param name="Param"></param> /// <param name="isPublish"></param> /// <returns></returns> private BaseResopne <List <AcademicResources> > GetAcademicResourcesList(GetPeriodicalListParam Param, bool isPublish) { BaseResopne <List <AcademicResources> > result = new BaseResopne <List <AcademicResources> >(); try { StringBuilder sql = new StringBuilder(); StringBuilder sqlCount = new StringBuilder(); sql.AppendLine(@"select dac.id,dac.`name`,dac.parentID,dac.sourceTypeID,dat.typeName as sourceTypeName ,dac.createTime,u.userName as createUserName,dac.createUserID,dac.isMenu ,dac.isChild,dac.author,`year`,periodNumber from de2_aresource dac LEFT JOIN de2_user u on u.id=dac.createUserID LEFT JOIN de2_aresource_type dat on dat.id=dac.sourceTypeID where 1=1"); sql.AppendLine("select count(id) from de2_aresource where 1=1"); //检索条件 if (Param.sourceTypeID != 0) { sql.AppendLine("sourceTypeID=@sourceTypeID"); sqlCount.AppendLine("sourceTypeID=@sourceTypeID"); } //年度 if (!string.IsNullOrEmpty(Param.year)) { sql.AppendLine("`year`=@`year`"); sqlCount.AppendLine("`year`=@`year`"); } //期数 if (!string.IsNullOrEmpty(Param.periodNumber)) { sql.AppendLine("periodNumber=@periodNumber"); sqlCount.AppendLine("periodNumber=@periodNumber"); } //父级ID sql.AppendLine(" parentID=@parentID"); sqlCount.AppendLine(" parentID=@parentID"); //是否发布 sql.AppendLine(" isPublish=@isPublish"); sqlCount.AppendLine(" isPublish=@isPublish"); //排序 sql.AppendLine(" order by dam.createTime @orderByType"); sql.AppendLine(" limit @start,@pageSize "); //执行sql MySqlClient _client = new MySqlClient(); result.Total = Convert.ToInt32(_client.ExecuteScalar(sqlCount.ToString() , new MySqlParameter("@sourceTypeID", Param.sourceTypeID) , new MySqlParameter("@parentID", Param.parenId) , new MySqlParameter("@`year`", Param.year) , new MySqlParameter("@periodNumber", Param.periodNumber) , new MySqlParameter("@isPublish", isPublish))); result.Data = _client.ExecuteQuery <AcademicResources>(sql.ToString() , new MySqlParameter("@sourceTypeID", Param.sourceTypeID) , new MySqlParameter("@orderByType", Param.orderType) , new MySqlParameter("@parentID", Param.parenId) , new MySqlParameter("@isPublish", isPublish) , new MySqlParameter("@`year`", Param.year) , new MySqlParameter("@periodNumber", Param.periodNumber) , new MySqlParameter("@start", Param.StartRow) , new MySqlParameter("@pageSize", Param.PageSize)); result.IsSuccess = true; } catch (Exception ex) { LogFactory _LogFactory = new LogFactory(this.GetType()); _LogFactory.CreateLog(LogType.Error, "获取学术资源列表", "GetAcademicResourcesList", ex); result.IsSuccess = false; } return(result); }