/// <summary>
/// 查出所有管理员
/// </summary>
/// <returns></returns>
public DataTable CheckAll()
{
string sql = "select * from webHT_Admin";
var result = DBHelp.GetTable(sql);
return(result);
}
/// <summary>
/// 分页 查出n条以内的数据
/// </summary>
/// <param name="number"></param>
/// <param name="n"></param>
/// <returns></returns>
public DataTable CheckAll(int number, int n)
{
string sql = "SELECT TOP " + n + " * FROM webHT_Admin WHERE (adminID not IN (SELECT TOP " + number + " adminID FROM webHT_Admin ORDER BY adminID))ORDER BY adminID";
var result = DBHelp.GetTable(sql);
return(result);
}
/// <summary>
/// 用id查出一个管理员的信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DataTable selectAdmin(int id)
{
string sql = "select * from webHT_Admin where adminID='" + id + "'";
var result = DBHelp.GetTable(sql);
return(result);
}
/// <summary>
/// 用帐号查出管理员信息
/// </summary>
/// <param name="adminName"></param>
/// <returns></returns>
public DataTable selectAdmin(string adminName)
{
string sql = "select * from webHT_Admin where adminName='" + adminName + "'";
var result = DBHelp.GetTable(sql);
return(result);
}
/// <summary>
/// 根据ID查出新闻类型
/// </summary>
/// <returns></returns>
public DataTable selectedNewstype(int id)
{
string sql = "select * from NewsType where news_type_id='" + id + "'";
var dt = DBHelp.GetTable(sql);
return(dt);
}
/// <summary>
/// 分页 查出n条以内的数据
/// </summary>
/// <param name="number"></param>
/// <param name="n"></param>
/// <returns></returns>
public DataTable selectedNewsType(int number, int n)
{
string sql = "SELECT TOP " + n + " * FROM NewsType WHERE (news_type_id not IN (SELECT TOP " + number + " news_type_id FROM NewsType ORDER BY news_type_id))ORDER BY news_type_id";
var result = DBHelp.GetTable(sql);
return(result);
}
/// <summary>
/// 查出所有的新闻类型
/// </summary>
/// <returns></returns>
public DataTable selectedNewsType()
{
string sql = "select * from NewsType";
var result = DBHelp.GetTable(sql);
return(result);
}
/// <summary>
/// 用ID查出新闻
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DataTable selectNews(int id)
{
string sql = "select * from News_detailedList where News_id='" + id + "'";
var result = DBHelp.GetTable(sql);
return(result);
}
/// <summary>
/// 查出n条数据(作为分页)
/// </summary>
/// <param name="number"></param>
/// <param name="n"></param>
/// <returns></returns>
public DataTable selectNews(int number, int n)
{
string sql = "SELECT TOP " + n + " * FROM News_detailedList WHERE (News_id not IN (SELECT TOP " + number + " News_id FROM News_detailedList ORDER BY News_id))ORDER BY News_id";
var result = DBHelp.GetTable(sql);
return(result);
}
