/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from Navigation");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
return(SqlHelperBook.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在某分类记录
/// </summary>
public bool ExistsNode(int nid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from ShuMu");
strSql.Append(" where nid=@nid ");
SqlParameter[] parameters =
{
new SqlParameter("@nid", SqlDbType.Int, 4)
};
parameters[0].Value = nid;
return(SqlHelperBook.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在书架记录
/// </summary>
public bool Exists2(int usid, int nid, int sid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from Favorites");
strSql.Append(" where usid=@usid");
strSql.Append(" and nid=@nid");
strSql.Append(" and sid=@sid and types=0");
SqlParameter[] parameters =
{
new SqlParameter("@usid", SqlDbType.Int, 4),
new SqlParameter("@nid", SqlDbType.Int, 4),
new SqlParameter("@sid", SqlDbType.Int, 4)
};
parameters[0].Value = usid;
parameters[1].Value = nid;
parameters[2].Value = sid;
return(SqlHelperBook.Exists(strSql.ToString(), parameters));
}