public SearchLogStastics ToModel(SqlDataReader reader)
{
SearchLogStastics searchLog = new SearchLogStastics();
searchLog.Word = (string)ToModelValue(reader, "Word");
searchLog.SearchCount = (long)ToModelValue(reader, "SearchCount");
return(searchLog);
}
public SearchLogStastics Add
(SearchLogStastics searchLog)
{
string sql = "INSERT INTO T_SearchLogStastics (Word, SearchCount) VALUES (@Word, @SearchCount)";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@Word", ToDBValue(searchLog.Word)),
new SqlParameter("@SearchCount", ToDBValue(searchLog.SearchCount)),
};
SqlHelper.ExecuteNonQuery(sql, para);
return(searchLog);
}
public int Update(SearchLogStastics searchLog)
{
string sql =
"UPDATE T_SearchLogStastics " +
"SET " +
"SearchCount = @SearchCount"
+ " WHERE Word = @Word";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@Word", ToDBValue(searchLog.Word)),
new SqlParameter("@SearchCount", ToDBValue(searchLog.SearchCount))
};
return(SqlHelper.ExecuteNonQuery(sql, para));
}
public int Update(SearchLogStastics searchLog)
{
return(new SearchLogStasticsDao().Update(searchLog));
}
public SearchLogStastics Add(SearchLogStastics searchLog)
{
return(new SearchLogStasticsDao().Add(searchLog));
}
