Fm.Tags/Tags_sql.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using Fm.DataAccess;
using System.Data;
using System.Data.Common;
using System.Collections;

namespace Fm.Tags
{
    /// <summary>
    /// 标签解析数据读取类
    /// </summary>
    public class Tags_sql
    {
        /// <summary>
        /// 获取公告浏览次数
        /// </summary>
        /// <param name="aff_id"></param>
        /// <returns></returns>
        public IList GetAfficheCount(int aff_id)
        {

            DbCommand db = DataAccess.DataAccess.db.GetStoredProcCommand("Fm_GetAffiche_count");
            DataAccess.DataAccess.db.AddInParameter(db, "@aff_id", DbType.Int32, aff_id);
            return DataAccess.DataAccess.GetData.Select<DbCommand>(db);
        }
        /// <summary>
        /// 获取网站公告信息
        /// </summary>
        /// <param name="count"></param>
        /// <returns></returns>
        public IList GetAffiche(int count)
        {
            DbCommand db = DataAccess.DataAccess.db.GetStoredProcCommand("Fm_GetAffiche");
            DataAccess.DataAccess.db.AddInParameter(db,"@count",DbType.Int32,count);
            return DataAccess.DataAccess.GetData.Select<DbCommand>(db);
        }
/**************************************文档部分Start*******************************************/
        /// <summary>
        /// 获取文被顶的次数和被踩的次数
        /// </summary>
        /// <param name="docid"></param>
        /// <param name="type"></param>
        /// <returns></returns>
        public IList GetArticleTopTread(int docid, int type)
        {
            DbCommand db = DataAccess.DataAccess.db.GetStoredProcCommand("Tags_gettoportread");
            DataAccess.DataAccess.db.AddInParameter(db,"@docid",DbType.Int32,docid);
            DataAccess.DataAccess.db.AddInParameter(db,"@type",DbType.Int32,type);
            return DataAccess.DataAccess.GetData.Select<DbCommand>(db);
        }
        /// <summary>
        /// 获取文章浏览次数
        /// </summary>
        /// <param name="aid"></param>
        /// <returns></returns>
        public IList GetArticleClick(int docid)
        {
            DbCommand db = DataAccess.DataAccess.db.GetStoredProcCommand("Tags_getclick");