/// <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)); }