theme.cs

这个是个未完成品 演示地址：http://www.yyzyq.com 仅以此例给正在学习编程爱好.net的朋友 希望能给大家带来帮助

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>
/// Theme 的摘要说明
/// </summary>
public class Theme :SqlDataBase
{
    public Theme()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}

    /// <summary>
    /// 首页热门话题
    /// </summary>
    /// <returns></returns>
    public DataView DvThemeListHot()
    {
        return GetDv("select top 34 *,left(title,20) as biaoti from v_theme order by browsecount desc");
    }

    /// <summary>
    /// 获取标题
    /// </summary>
    /// <param name="id">帖子ID</param>
    /// <returns></returns>
    public string GetTitle(string id)
    {
        return RunSqlReturn("select title from theme where id=" + id);
    }

    
    /// <summary>
    /// 返回指定用户发表的前10个主题
    /// </summary>
    /// <param name="id">用户ID</param>
    /// <returns></returns>
    public DataView Dv_VThemeUserTop(string id)
    {
        return GetDv("select top 10 * from v_theme where sender =" + id+ " and smallid <> 36 order by sendtime desc");
    }

    /// <summary>
    /// 返回最新的100个帖子
    /// </summary>
    /// <returns></returns>
    public DataView Dv_VThemeNewTheme()
    {
        return GetDv("select top 100 * from v_theme where smallid <> 36 order by sendtime desc");
    }

    /// <summary>
    /// 返回精华帖子
    /// </summary>
    /// <returns></returns>
    public DataView Dv_VThemePink()
    {
        return GetDv("SELECT * FROM [V_Theme] WHERE (themetype = 2) order by browsecount desc");
    }

    /// <summary>
    /// 返回大类下最后回复的20个帖子
    /// </summary>
    /// <param name="bigid">大类ID</param>
    /// <returns></returns>
    public DataView Dv_VThemeNewBig(string bigid)
    {
        return GetDv("SELECT top 20 * FROM [V_Theme] WHERE (bigid = "+bigid+") or (bigid = "+bigid+" and themetype=4) or themetype=5 order by orderby,lastdate desc");
    }

    /// <summary>
    /// 通过帖子ID返回帖子视图
    /// </summary>
    /// <param name="themeid"></param>
    /// <returns></returns>
    public DataView Dv_VTheme(string themeid)
    {
        return GetDv("select * from v_theme where id=" + themeid);
    }

    /// <summary>
    /// 获取帖子列表置顶帖子视图
    /// </summary>
    /// <param name="bigid">大类ID</param>
    /// <param name="smallid">小类ID</param>
    /// <returns></returns>
    public DataView Dv_VThemeListUp(string bigid, string smallid)
    {
        return GetDv("SELECT * FROM [V_Theme] WHERE (themetype=3 and (smallid="+smallid+"))  or (themetype=4 and (bigid = "+bigid+")) or themetype=5 order by orderby");
    }

    /// <summary>
    /// 通过小类ID返回帖子列表视图
    /// </summary>
    /// <param name="smallid">小类ID</param>
    /// <returns></returns>
    public DataView Dv_VThemeList(string smallid)
    {
        return GetDv("SELECT * FROM [V_Theme] WHERE ([smallid] = "+smallid+") and orderby = 3 order by lastdate desc");
    }
    
    /// <summary>
    /// 获取编辑主题信息
    /// </summary>
    /// <param name="themeid">主题ID</param>
    /// <returns></returns>
    public DataView GetThemeEdit(string themeid)
    {
        return GetDv("select * from theme where id=" + themeid);
    }
     
   
    /// <summary>
    /// 添加主题表
    /// </summary>
    /// <param name="title">标题</param>
    /// <param name="content">内容</param>
    /// <param name="sender">发布人</param>
    /// <param name="smallid">小类ID</param>
    /// <param name="typeid">帖子类型</param>
    /// <returns></returns>
    public string AddTheme(string title, string content, string sender, string smallid,string typeid)
    {        
        SqlParameter[] prams ={
									   MakeInParam("@title",SqlDbType.VarChar ,200,title),
									   MakeInParam("@content",SqlDbType.Text ,20000,content),
									   MakeInParam("@sender",SqlDbType.Int ,4,sender),
									   MakeInParam("@smallid",SqlDbType.Int ,4,smallid),
									   MakeInParam("@typeid",SqlDbType.Int ,4,typeid),
                                       MakeOutParam("@themeid",SqlDbType.Int,4)
							    };
        try
        {
            RunProc("Up_AddTheme", prams);
            return prams[5].Value.ToString();
        }
        catch { return "0"; }
    }

    /// <summary>
    /// 修改主题表
    /// </summary>
    /// <param name="themeid">主题ID</param>
    /// <param name="title">标题</param>
    /// <param name="content">内容</param>
    /// <returns></returns>
    public bool ChangeTheme(string themeid, string title, string content,string typeid)
    {
        string strSql = "update Theme set title ='" + title + "',content ='" + content + "',typeid="+typeid+" where id=" + themeid;
        try
        {
            RunSql(strSql);
            return true;
        }
        catch { return false; };
    }

    /// <summary>
    /// 帖子浏览次数
    /// </summary>
    /// <param name="id">帖子ID</param>
    /// <returns></returns>
    public bool ChangeThemeCount(string id)
    {
        #region
        SqlParameter[] prams ={
									   MakeInParam("@id",SqlDbType.VarChar ,50,id)
        };
        try
        {
            RunProc("Up_ChangeThemeCount", prams);
            return true;
        }
        catch
        {
            return false;
        }
        #endregion
    }

    /// <summary>
    /// 帖子操作，置顶加精等
    /// </summary>
    /// <param name="id">帖子ID</param>
    /// <param name="type">类型ID:2为精华,3为版置顶,4为区置顶,5为版置顶</param>
    /// <returns></returns>
    public bool ChangeThemeZt(string id,int type)
    {
        #region 
        SqlParameter[] prams = {
                                        MakeInParam("@id",SqlDbType.Int ,4,id),
                                        MakeInParam("@type",SqlDbType.Int ,4,type)
        };
        try
        {
            RunProc("Up_ThemeWork", prams);
            return true;
        }
        catch { return false; }
        #endregion
    }
    
   
    /// <summary>
    /// 删除帖子
    /// </summary>
    /// <param name="id">帖子ID</param>
    /// <returns></returns>
    public bool ChangeThemeDel(string id)
    {
        #region
        string strSql = "update Theme set smallid=36 where id=" + id;
        try
        {
            RunSql(strSql);
            return true;
        }
        catch
        {
            return false;
        }
        #endregion
    }

    /// <summary>
    /// 用户发表过的主题
    /// </summary>
    /// <param name="name">用户ID</param>
    /// <returns></returns>
    public DataView DvUserTheme(string id)
    {
        return GetDv("select * from v_theme where sender =" + id + " order by sendtime desc");
    }

    /// <summary>
    /// 返回用户最近参与过的20个帖子
    /// </summary>
    /// <param name="id">用户ID</param>
    /// <returns></returns>
    public DataView DvUserJoinPost(string id)
    {
        return GetDv("SELECT TOP 20 * FROM V_Theme WHERE (id IN (SELECT DISTINCT (themeid)  FROM back  WHERE dbo.back.sender = "+id+")) ORDER BY id DESC");
    }

}