public IList<Core.Business.KeyWords> GetAllKeyWords(int PageSize)
{
IList<Core.Business.KeyWords> keyWordslist = new List<Core.Business.KeyWords>();
SqlServerUtility sql = new SqlServerUtility(SqlConnection);
SqlDataReader reader = sql.ExecuteSqlReader("SELECT TOP(" + PageSize + ") [Id],[KeyWord] FROM [KeyWords];");
if (reader != null)
{
while (reader.Read())
{
Core.Business.KeyWords keyWords = new Core.Business.KeyWords();
if (!reader.IsDBNull(0)) keyWords.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) keyWords.KeyWord = reader.GetString(1);
if (!reader.IsDBNull(2)) keyWords.Count = reader.GetInt32(2);
keyWords.MarkOld();
keyWordslist.Add(keyWords);
}
reader.Close();
}
return keyWordslist;
}
public IList<CY.UME.Core.Business.KeyWords> GetHotKeyWords(int PageSize)
{
IList<Core.Business.KeyWords> keyWordslist = new List<Core.Business.KeyWords>();
SqlServerUtility sql = new SqlServerUtility(SqlConnection);
sql.AddParameter("@PageSize", SqlDbType.Int, PageSize);
SqlDataReader reader = sql.ExecuteSPReader("USP_KeyWords_Select_DESC");
if (reader != null)
{
while (reader.Read())
{
Core.Business.KeyWords keyWords = new Core.Business.KeyWords();
if (!reader.IsDBNull(0)) keyWords.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) keyWords.KeyWord = reader.GetString(1);
if (!reader.IsDBNull(2)) keyWords.Count = reader.GetInt32(2);
keyWords.MarkOld();
keyWordslist.Add(keyWords);
}
reader.Close();
}
return keyWordslist;
}
public Core.Business.KeyWords Select(Int64 id)
{
SqlServerUtility sql = new SqlServerUtility(SqlConnection);
sql.AddParameter("@Id", SqlDbType.BigInt, id);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectKeyWords);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.KeyWords keyWords = new Core.Business.KeyWords();
if (!reader.IsDBNull(0)) keyWords.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) keyWords.KeyWord = reader.GetString(1);
if (!reader.IsDBNull(2)) keyWords.Count = reader.GetInt32(2);
reader.Close();
return keyWords;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
public CY.UME.Core.Business.KeyWords Load(String KeyWord)
{
SqlServerUtility sql = new SqlServerUtility(SqlConnection);
sql.AddParameter("@KeyWord", SqlDbType.NVarChar, KeyWord);
SqlDataReader reader = sql.ExecuteSPReader("USP_KeyWords_Select_By_KeyWord");
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.KeyWords keyWords = new Core.Business.KeyWords();
if (!reader.IsDBNull(0)) keyWords.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) keyWords.KeyWord = reader.GetString(1);
if (!reader.IsDBNull(2)) keyWords.Count = reader.GetInt32(2);
reader.Close();
return keyWords;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
