view_bbs.cs

来自「这是我制作的一个小论坛源码··能够简单实现发表帖子··管理帖子·后台管理等功能」· CS 代码 · 共 41 行

using System;
using System.Data;
using System.Data.SqlClient;

namespace da
{
	/// <summary>
	/// view_bbs 的摘要说明。
	/// </summary>
	public class view_bbs
	{
		public view_bbs()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public DataSet Getview_bbsTitle()
		{			
			da d=new da();
			DataSet ds = d.Select("select * from VIEW_Bbs where iBbsSubject is null order by  dBbsDate desc" ,"VIEW_Bbs");
			return ds;
		}

		public DataSet GetView_bbsHead()
		{
			da d=new da();
			DataSet myds=d.Select("select * from VIEW_Bbs where iBbsSubject is  null and iBbsID='iBbs'" ,"VIEW_Bbs");
			return myds;
		}

		public DataSet GetView_bbsContent(string iBbsid)
		{
			da d=new da();
			DataSet myds=d.Select("select * from VIEW_Bbs where iBbsid="+iBbsid+" or iBbsSubject="+iBbsid+"","VIEW_Bbs");
			return myds;

		}
	}
}