public int Add
(Model.SerachKeyword searchKeyword)
{
string sql = "INSERT INTO keywords_c (searchdatetime, keyword, clientaddress) VALUES (@searchdatetime, @keyword, @clientaddress)";
NpgsqlParameter[] para = new NpgsqlParameter[]
{
new NpgsqlParameter("@searchdatetime", searchKeyword.SearchDateTime),
new NpgsqlParameter("@keyword", searchKeyword.Keyword),
new NpgsqlParameter("@clientaddress", searchKeyword.ClinetAddress),
};
return(SqlHelper.ExecuteNonQuery(sql, para));
}
public int Add
(Model.SerachKeyword searchKeyword)
{
string sql = "INSERT INTO Keywords (SearchDateTime, KeyWord, ClientAddress) output inserted.KeywordID VALUES (@SearchDateTime, @KeyWord, @ClientAddress)";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@SearchDateTime",searchKeyword.SearchDateTime),
new SqlParameter("@KeyWord", searchKeyword.Keyword),
new SqlParameter("@ClientAddress", searchKeyword.ClinetAddress),
};
return SqlHelper.ExecuteNonQuery(sql, para);
}
