/// <summary>
/// 判断是否为超级管理员
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int isSuperAdmin(int id)
{
string sql = "select count(*) from webHT_Admin where adminId='" + id + "'and role=1";
int result = DBHelp.CommandScalar(sql);
return(result);
}
/// <summary>
/// 验证管理员是否存在
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public int VerifyAdminName(string name)
{
string sql = "select count(*) from webHT_Admin where adminName='" + name + "'";
int result = DBHelp.CommandScalar(sql);
return(result);
}
/// <summary>
/// 管理员登录
/// </summary>
/// <param name="admin"></param>
/// <returns></returns>
public int adminLogin(Administrator admin)
{
string sql = "select count(*) from webHT_Admin where adminName='" + admin.AdminName + "' and adminPassword='******'";
int count = DBHelp.CommandScalar(sql);
return(count);
}
/// <summary>
/// 数据的条数
/// </summary>
/// <returns></returns>
public int Quantity()
{
string sql = "select count(*) from webHT_Admin";
int result = DBHelp.CommandScalar(sql);
return(result);
}
/// <summary>
/// 查询排序最大的项的值
/// </summary>
/// <returns></returns>
public int getMaxSequence()
{
string sql = "select max(News_sequence) from News_detailedList";
int result = DBHelp.CommandScalar(sql);
return(result);
}
/// <summary>
/// 查出所有数据的条数
/// </summary>
/// <returns></returns>
public int selectNews()
{
string sql = "select count(*) from News_detailedList";
var result = DBHelp.CommandScalar(sql);
return(result);
}
