back.cs

来自「这个是个未完成品 演示地址：http://www.yyzyq.com 」· CS 代码 · 共 66 行

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>
/// Back 的摘要说明
/// </summary>
public class Back :SqlDataBase 
{
	public Back()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}

    /// <summary>
    /// 返回回复信息引用内容
    /// </summary>
    /// <param name="backid">回复ID</param>
    /// <returns></returns>
    public DataView GetBackContent(string backid)
    {
        return GetDv("select name,left(content,50) as backcontent from v_back where id=" + backid);
    }

    /// <summary>
    /// 返回回复信息
    /// </summary>
    /// <param name="themeid">主题编号</param>
    /// <returns></returns>
    public DataView DvBack(string themeid)
    {
        return GetDv("select * from v_back where themeid=" + themeid);
    }

    /// <summary>
    /// 添加回复信息
    /// </summary>
    /// <param name="content">回复内容</param>
    /// <param name="sender">回复人ID</param>
    /// <param name="themeid">主题ID</param>
    /// <returns></returns>
    public bool AddBack(string content, string sender, string themeid)
    {
        SqlParameter[] prams ={
									   MakeInParam("@content",SqlDbType.VarChar ,4000,content),
									   MakeInParam("@sender",SqlDbType.Int ,4,sender),
                                       MakeInParam("@themeid",SqlDbType.Int,4,themeid)
							    };
        try
        {
            RunProc("Up_AddBack", prams);
            return true;
        }
        catch { return false; }
    }
}