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