public List <Link> SelectByStatus(int top, Link.StatusAttribute status)
{
List <Link> links = new List <Link>();
LinkDAL dalLink = new LinkDAL();
links = dalLink.SelectByStatus(top, status);
return(links);
}
public List <Link> SelectByStatus(Link.StatusAttribute status)
{
string sqlStr = SELECT + "WHERE [Status] = @Status;";
SqlParameter[] parameters =
{
new SqlParameter("@Status", status)
};
List <Link> links = Readers(SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.Text, sqlStr));
return(links);
}
public int SelectCountByStatus(Link.StatusAttribute status)
{
string sqlStr = "SELECT COUNT('x') FROM [dbo].[Links] WHERE [Status] = @Status;";
SqlParameter[] parameters =
{
new SqlParameter("@Status", status)
};
int count = (int)SqlHelper.ExecuteScalar(SqlHelper.ConnectionString, CommandType.Text, sqlStr, parameters);
return(count);
}
public List <Link> SelectByStatus(int top, Link.StatusAttribute status)
{
string sqlStr = "SELECT TOP (@top) " + SELECT_COLUMNS + "FROM [dbo].[Links] WHERE [Status] = @Status;";
SqlParameter[] parameters =
{
new SqlParameter("@top", top),
new SqlParameter("@Status", status)
};
List <Link> links = Readers(SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.Text, sqlStr, parameters));
return(links);
}
public bool UpdateStatusByUrl(string url, Link.StatusAttribute status)
{
string sqlStr = "UPDATE [dbo].[Links] SET [UpdateTime] = @UpdateTime,[Status] = @Status WHERE Url =@Url";
SqlParameter[] parameters =
{
new SqlParameter("@UpdateTime", DateTime.Now),
new SqlParameter("@Status", status),
new SqlParameter("@Url", url),
};
int row = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString, CommandType.Text, sqlStr, parameters);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
