topicclass.cs

电脑用户登录注册系统

using System;
using System.Data;
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;
using DataBaseLayer;

public class TopicClass
{
    private int _titleID;    

    public int TitleID
    {
        get { return _titleID; }
        set { _titleID = value; }
    }
    private string _Title;   

    public string Title
    {
        get { return _Title; }
        set { _Title = value; }
    }
    private string _Auther;  

    public string Auther
    {
        get { return _Auther; }
        set { _Auther = value; }
    }
    private string _Content; 

    public string Content
    {
        get { return _Content; }
        set { _Content = value; }
    }
   
    
    private DateTime _CreateTime;  

    public DateTime CreateTime
    {
        get { return _CreateTime; }
        set { _CreateTime = value; }
    }
   


    
   
    public TopicClass()
	{
	}
   

    
    public DataSet getTopicContent(int TitleID)
    {
        string sqlStr = "select Content from LD_Topic where TitleID=" + TitleID;
        DataBase db = new DataBase();
        return db.GetDataSet(sqlStr);
    }

    public DataSet getReplyList(int TitleID)
    {
        string sqlStr = "select ReplyContent from LD_Reply where TitleID=" + TitleID;
        DataBase db = new DataBase();
        return db.GetDataSet(sqlStr);
    }

   
    public bool InsertTopic(TopicClass topic)
    {
        string sqlStr = "insert into LD_Topic(TitleID,Title,Auther,Content,CreateTime,)values('"
        + topic.TitleID + "','" + topic.Title + "','" + Auther + "','" + topic.Content + "','" + topic.CreateTime + "')";
        DataBase db = new DataBase();
        if (db.ExecuteSQL(sqlStr)>0)
            return true;
        return false;
    }

    
  

	
}