Example #1
0
        /// <summary>
        /// 获取最新trends
        /// </summary>
        /// <returns></returns>
        public List <Views.trends> GetNewTrends(int pageIndex, string token = "")
        {
            List <Views.trends> List = new List <Views.trends>();

            DAL.course c  = new DAL.course();
            DataTable  dt = c.GetListByPage(pageIndex, "", " time desc ");

            foreach (DataRow item in dt.Rows)
            {
                List.Add(c.DataRowToTrends(item, token));
            }
            return(List);
        }
Example #2
0
        /// <summary>
        /// 返回搜索后的DataTable
        /// </summary>
        /// <param name="searchKey">搜索关键字</param>
        /// <param name="type">0图文 1视频</param>
        /// <returns></returns>
        public List <Views.course_T> GetListToSelect(int pageIndex, string searchKey, string type)
        {
            List <Views.course_T> list   = new List <Views.course_T>();
            StringBuilder         strSql = new StringBuilder();

            if (searchKey != "")
            {
                strSql.Append(" ( searchkey LIKE @key1 OR content LIKE @key2 ) ");
                strSql.Append(" and type = @type ");
                SqlParameter[] parameters =
                {
                    new SqlParameter("@key1", SqlDbType.NVarChar, 250),
                    new SqlParameter("@key2", SqlDbType.NVarChar, 250),
                    new SqlParameter("@type", SqlDbType.Char, 1)
                };
                parameters[0].Value = string.Format("%{0}%", searchKey.Trim());
                parameters[1].Value = string.Format("%{0}%", searchKey.Trim());
                parameters[2].Value = type.Trim();

                DAL.course c = new DAL.course();
                foreach (DataRow itme in c.GetListByPage(pageIndex, strSql.ToString(), parameters, " time desc").Rows)
                {
                    list.Add(c.DataRowToModel_T(itme));
                }
                return(list);
            }
            else
            {
                strSql.Append(" type = @type ");
                SqlParameter[] parameters =
                {
                    new SqlParameter("@type", SqlDbType.Char, 1)
                };
                parameters[0].Value = type.Trim();
                DAL.course c = new DAL.course();
                foreach (DataRow itme in c.GetListByPage(pageIndex, strSql.ToString(), parameters, " time desc").Rows)
                {
                    list.Add(c.DataRowToModel_T(itme));
                }
                return(list);
            }
        }
Example #3
0
        /// <summary>
        /// 获取动态信息
        /// </summary>
        /// <param name="id"></param>
        /// <param name="pageIndex"></param>
        /// <returns></returns>
        public DataTable GetTrends(string id, int pageIndex)
        {
            //获取所有关注的人
            DAL.follow_       folloew = new follow_();
            DataRowCollection drs     = folloew.GetList("", "", id).Rows;
            StringBuilder     str     = new StringBuilder();

            for (int i = 0; i < drs.Count; i++)
            {
                if (i == 0)
                {
                    str.AppendFormat(" authorid = {0} ", drs[i]["id"].ToString());
                }
                else
                {
                    str.AppendFormat(" or authorid = {0} ", drs[i]["id"].ToString());
                }
            }
            //获取关注的人的教程信息
            DAL.course course = new DAL.course();
            return(course.GetListByPage(pageIndex, "(" + str.ToString() + ") and stats = 0 ", " time desc "));
        }