DsJian.Data.MySoftDataProvider/LinkRepository.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

// ================================================
// LinkRepository.cs, 链接数据库业务逻辑处理
// Copyright (C) 2010 Benking
// mail:ben.wangzj@gmail.com
// website:http://www.dsjian.com/
//
// This program is free software; you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation; either version 2 of the License, or
// (at your option) any later version.
//
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
// ================================================

using System;
using System.Collections.Generic;
using System.Text;
using DsJian.Interface.Model;
using DsJian.Repository.Model;

namespace DsJian.Repository
{
    /// <summary>
    /// 链接数据库业务逻辑处理
    /// </summary>
    public class LinkRepository : DsJian.Interface.Repositories.ILinkRepository
    {
        /// <summary>
        /// 数据库会话
        /// </summary>
        private SessionRepository repository;
        private TermRepository term_repository;
        public LinkRepository(SessionRepository repository)
        {
            this.repository = repository;
            this.term_repository = new TermRepository(repository);
        }

        /// <summary>
        /// 获取所有链接
        /// </summary>
        /// <returns></returns>
        public IList<ILinks> GetList()
        {
            return repository.GetSession().From<Term_Classify>()
                .InnerJoin<Terms>(Term_Classify._.TermID == Terms._.ID)
                .InnerJoin<Term_Relationship>(Term_Classify._.ID == Term_Relationship._.Term_Classify_ID)
                .InnerJoin<Links>(Term_Relationship._.ObjectID == Links._.ID)
                .Where(Term_Classify._.Classify == Constant.LinkClassify)
                .OrderBy(Links._.AddTimeGMT.Desc)
                .Select(Links._.All)
                .ToList<Links>().ConvertTo<LinksModel, ILinks>();
        }

        /// <summary>
        /// 获取某分类下的所有链接
        /// </summary>