?? tablequery.cs
字號(hào):
using System;
using System.Data;
namespace _211
{
/// <summary>
/// TableQuery 的摘要說(shuō)明。
/// </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);
}
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -