/// <summary>
/// 判断某管理员名的管理员是否已存在
/// </summary>
/// <param name="adminName">要检索的管理员名</param>
/// <returns>存在状态</returns>
public bool IsExist(string adminName)
{
string strSql = "SELECT COUNT(*) FROM ZL_Manager WHERE AdminName=@AdminName";
SqlParameter[] cmdParams = new SqlParameter[] { new SqlParameter("@AdminName", SqlDbType.NVarChar, 20) };
cmdParams[0].Value = adminName;
return(SqlHelper.ExistsSql(strSql, cmdParams));
}
/// <summary>
/// 判断某管理员是否已存在
/// </summary>
/// <param name="adminName">要检索的管理员ID</param>
/// <returns>存在状态</returns>
public bool IsExist(int adminID)
{
string strSql = "SELECT AdminID FROM ZL_Manager WHERE AdminID=@adminID";
SqlParameter[] cmdParams = new SqlParameter[] { new SqlParameter("@adminID", SqlDbType.Int) };
cmdParams[0].Value = adminID;
return(SqlHelper.ExistsSql(strSql, cmdParams));
}
public bool ExistsAdminName(string adminName)
{
SqlParameter[] cmdParams = new SqlParameter[] { new SqlParameter("@AdminName", SqlDbType.NVarChar, 50) };
cmdParams[0].Value = adminName;
return(SqlHelper.ExistsSql("SELECT Count(*) FROM ZL_AdminProfile WHERE AdminName=@AdminName", cmdParams));
}
