tagcontroller.cs

Maolz个人展示网站源码,全部的代码,.net

using System; 
using System.Text; 
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration; 
using System.Xml; 
using System.Xml.Serialization;
using SubSonic; 
using SubSonic.Utilities;

namespace SubSonic.Generated
{
    /// <summary>
    /// Controller class for Tags
    /// </summary>
    using System.Linq;
    public partial class TagController
    {
        [DataObjectMethod(DataObjectMethodType.Select, false)]
        public List<Tag> FetchAllByZTFB() 
        {
            //Query qry = Tag.CreateQuery().ORDER_BY(Tag.Columns.UseTimes);
            List<Tag> list=DB.Select().From<Tag>().ExecuteAsCollection<TagCollection>().OrderBy(t => t.UseTimes).ToList<Tag>();
            SortedList<int, Tag> minusList = new SortedList<int, Tag>();
            SortedList<int, Tag> plusList = new SortedList<int, Tag>();

            for (int i = 0; i < list.Count; i++) 
            {
                if (i % 2 == 0)
                    plusList.Add((i+1), list[i]);
                else
                    minusList.Add(-(i+1), list[i]);
            }

            List<KeyValuePair<int, Tag>> result = new List<KeyValuePair<int, Tag>>();
            result.AddRange(minusList.TakeWhile(t => t.Key < 0).OrderByDescending(t => t.Key).ToList());
            result.AddRange(plusList.TakeWhile(t => t.Key > 0).OrderByDescending(t => t.Key).ToList());
            List<Tag> l=new List<Tag>();
            result.ForEach(t => l.Add(t.Value));
            return l;
        }

    }

}