using System;
using System.Data;

namespace _211
{
	/// <summary>
	/// TableQuery 的摘要說明。
	/// </summary>
	public sealed class TableQuery
	{
		public static DataTable UserQuery()
		{
			return DBQuery.OpenTable("Admin");
		}

		public static DataTable LinkQuery()
		{
			return DBQuery.OpenTable("Link");
		}

		public static string LinkUrlQuery(string LID)
		{
			return DBQuery.ExecuteScalar("select LinkUrl from [Link] where LinkId="+LID).ToString();
		}

		public static DataTable DownQuery()
		{
			return DBQuery.OpenTable("Down","DownId",false);
		}

		public static string DownUrlQuery(string DID)
		{
			return DBQuery.ExecuteScalar("select DownUrl from [Down] where DownId="+DID).ToString();
		}

		public static DataTable DownTypeQuery()
		{
			return DBQuery.OpenTable("DownType");
		}

		public static DataTable ClassQuery()
		{
			return DBQuery.OpenTable("Class");
		}

		public static DataTable ItemQuery(string CID)
		{
			string[] co={"ClassId="+CID};
			return DBQuery.OpenTable("Item",co,true);
		}

		public static string ItemNameQuery(int IID)
		{
			return DBQuery.ExecuteScalar("select ItemName from [Item] where ItemId="+IID.ToString()).ToString();
		}

		public static DataTable ArticleItemQuery(string IID,int count)
		{
			string[] col={"ArticleId","ArticleTitle","AddTime"};
			string[] cod={"ItemId="+IID};
			return DBQuery.OpenTable("Article",count,col,cod,"ArticleId",false);
		}

		public static DataTable ArticleQuery(int pagesize,int page,string CID)
		{
			string[] col={"Article.ArticleId","Article.ArticleTitle","Item.ItemName"};
			string[] cod={"Class.ClassId="+CID,"Item.ClassId=Class.ClassId","Article.ItemId=Item.ItemId"};

			return DBQuery.OpenTable("[Article],[Class],[Item]",col,cod,"ArticleId",false,pagesize,page);
		}

		public static DataTable ArticleSimpleQuery(int pagesize,int page,string IID)
		{
			string[] col={"Article.ArticleId","Article.ArticleTitle","Item.ItemName"};
			string[] cod={"Item.ItemId="+IID,"Article.ItemId=Item.ItemId"};

			return DBQuery.OpenTable("[Article],[Item]",col,cod,"ArticleId",false,pagesize,page);
		}

		public static DataTable ArticleItemByPageQuery(int pagesize,int page,string IID)
		{
			string[] col={"Article.ArticleId","Article.ArticleTitle","Article.AddTime"};
			string[] cod={"Item.ItemId="+IID,"Article.ItemId=Item.ItemId"};

			return DBQuery.OpenTable("[Article],[Item]",col,cod,"ArticleId",false,pagesize,page);
		}

		public static DataTable DownQuery(int pagesize,int page)
		{
			string[] col={"DownId","DownName","DownUrl","AddTime"};

			return DBQuery.OpenTable("Down",col,"DownId",false,pagesize,page);
		}
	}
}