sharepoint列表如何进行随机取几条记录?

sharepoint列表如何进行随机取记录?由于itemid是不连续。可能存在删除添加等操作导致

我们可以采用随机取第几条记录。把记录集合取出来。产生随机第几条数。这里关键是如何产生不重复的随机数

方法如下:

#region//获取随机数
        /// <summary>
        /// 获取随机数
        /// </summary>
        /// <param name="Number">随机个数</param>
        /// <param name="minNum">随机的最小数</param>
        /// <param name="maxNum">随机的最大数</param>
        /// <returns></returns>
        public static int[] GetRandomArray(int Number, int minNum, int maxNum)
        {
            int j;
            int[] b = new int[Number];
            Random r = new Random();
            for (j = 0; j < Number; j++)
            {
                int i = r.Next(minNum, maxNum + 1);
                int num = 0;
                for (int k = 0; k < j; k++)
                {
                    if (b[k] == i)
                    {
                        num = num + 1;
                    }
                }
                if (num == 0)
                {
                    b[j] = i;
                }
                else
                {
                    j = j - 1;
                }
            }
            return b;
        }
        #endregion

 

 

  //得到最大数
                    int maxRandom = list.Items.Count;
                    //最小1
                    int minRandom = 1;
                    //得到随机数组
                    int[] randArr = GetRandomArray(topNumber, minRandom, maxRandom);
                    //读取 
                    SPQuery query = new SPQuery();
//过滤后的记录
                    SPListItemCollection listItemCollection = list.GetItems(query);
                    #region//如果有记录
                    if (listItemCollection !=null && listItemCollection.Count>0)
                    {
                        //foreach
                        //计数器
                        int i = 1;
                        //得到记录计数器
                        int j = 0;
                        foreach(SPListItem randItem in listItemCollection)
                        {
                            #region//若计数器在随机数组里头,如果存在
                            if (((IList)randArr).Contains(i))
                            {
                                //取记录
                                //******************读取id,工号,姓名,图片url,
                                EmployeeEntity randentity = new EmployeeEntity();
                                //
                                randentity.ItemID = randItem["ID"] == null ? string.Empty :
                                    randItem["ID"].ToString();
                                //工号
                                randentity.EmployeeNO = randItem["EmployeeNO"] == null ? string.Empty :
                                  randItem["EmployeeNO"].ToString();
                                //姓名
                                randentity.EmployeeName = randItem["EmployeeName"] == null ? string.Empty :
                                  randItem["EmployeeName"].ToString();
                                //*****************图片url
                                //
                                result.Add(randentity);
                                //计数器+1
                                j++;
                            }
                            //如果已经获取50张,则退出循环
                            if(j == topNumber)
                            {
                                break;
                            }
                            //计数器+1
                            i++;
                            #endregion
                        }
                    }
                    #endregion
posted @ 2014-11-08 12:17  love007  阅读(413)  评论(0编辑  收藏  举报