DsJian.Data.MySoftDataProvider/CommentRepository.cs

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

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

// ================================================
// CommentRepository.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 CommentRepository : DsJian.Interface.Repositories.ICommentRepository
    {
        /// <summary>
        /// 数据库会话
        /// </summary>
        private SessionRepository repository;
        public CommentRepository(SessionRepository repository)
        {
            this.repository = repository;
        }

        /// <summary>
        /// 获取评论数量
        /// </summary>
        /// <returns></returns>
        public int GetCount()
        {
            return repository.GetSession().From<Comments>().Count();
        }

        /// <summary>
        /// 获取用户评论数量
        /// </summary>
        /// <param name="userId"></param>
        /// <returns></returns>
        public int GetCountByUser(int userId)
        {
            return repository.GetSession().From<Comments>().LeftJoin<Posts>(Comments._.PostID == Posts._.ID)
                .Where(Posts._.PostAuthor == userId)
                .Count();
        }