public static SearchKeyword AddSearchKeyword(SearchKeyword searchKeyword)
{
string sql =
"INSERT SearchKeywords (Keyword, SearchCount)" +
"VALUES (@Keyword, @SearchCount)";
sql += " ; SELECT @@IDENTITY";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@Keyword", searchKeyword.Keyword),
new SqlParameter("@SearchCount", searchKeyword.SearchCount)
};
int newId = DBHelper.GetScalar(sql, para);
return GetSearchKeywordById(newId);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return null;
}
}
/// <summary>
/// 根据关键字搜索时,进行搜索计数
/// </summary>
/// <param name="keyword"></param>
public static void Search(string keyword)
{
SearchKeyword skw = SearchKeywordService.GetKeyword(keyword);
if (skw == null)
{
skw = new SearchKeyword();
skw.Keyword = keyword;
skw.SearchCount = 1;
SearchKeywordService.AddSearchKeyword(skw);
}
else
{
skw.SearchCount++;
SearchKeywordService.ModifySearchKeyword(skw);
}
}
/// <summary>
/// ���ݹؼ������ݻ�ùؼ��ֶ���
/// </summary>
/// <param name="keyword"></param>
/// <returns></returns>
public static SearchKeyword GetKeyword(string keyword)
{
string sql = "SELECT * FROM SearchKeywords WHERE keyword = @keyword";
using (SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@keyword", keyword)))
{
if (reader.Read())
{
SearchKeyword searchKeyword = new SearchKeyword();
searchKeyword.Id = (int)reader["Id"];
searchKeyword.Keyword = (string)reader["Keyword"];
searchKeyword.SearchCount = (int)reader["SearchCount"];
reader.Close();
return searchKeyword;
}
else
{
reader.Close();
return null;
}
}
}
public static SearchKeyword GetSearchKeywordById(int id)
{
string sql = "SELECT * FROM SearchKeywords WHERE Id = @Id";
try
{
SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@Id", id));
if (reader.Read())
{
SearchKeyword searchKeyword = new SearchKeyword();
searchKeyword.Id = (int)reader["Id"];
searchKeyword.Keyword = (string)reader["Keyword"];
searchKeyword.SearchCount = (int)reader["SearchCount"];
reader.Close();
return searchKeyword;
}
else
{
reader.Close();
return null;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return null;
}
}
public static void DeleteSearchKeyword(SearchKeyword searchKeyword)
{
DeleteSearchKeywordById( searchKeyword.Id );
}
private static IList<SearchKeyword> GetSearchKeywordsBySql( string sql, params SqlParameter[] values )
{
List<SearchKeyword> list = new List<SearchKeyword>();
try
{
DataTable table = DBHelper.GetDataSet( sql, values );
foreach (DataRow row in table.Rows)
{
SearchKeyword searchKeyword = new SearchKeyword();
searchKeyword.Id = (int)row["Id"];
searchKeyword.Keyword = (string)row["Keyword"];
searchKeyword.SearchCount = (int)row["SearchCount"];
list.Add(searchKeyword);
}
return list;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return null;
}
}
public static void ModifySearchKeyword(SearchKeyword searchKeyword)
{
string sql =
"UPDATE SearchKeywords " +
"SET " +
"Keyword = @Keyword, " +
"SearchCount = @SearchCount " +
"WHERE Id = @Id";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@Id", searchKeyword.Id),
new SqlParameter("@Keyword", searchKeyword.Keyword),
new SqlParameter("@SearchCount", searchKeyword.SearchCount)
};
DBHelper.ExecuteCommand(sql, para);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static void ModifySearchKeyword(SearchKeyword searchKeyword)
{
SearchKeywordService.ModifySearchKeyword(searchKeyword);
}
public static void DeleteSearchKeyword(SearchKeyword searchKeyword)
{
SearchKeywordService.DeleteSearchKeyword(searchKeyword);
}
public static SearchKeyword AddSearchKeyword(SearchKeyword searchKeyword)
{
return SearchKeywordService.AddSearchKeyword(searchKeyword);
}
