public void Update(AdKeywordInfo entity)
{
using (var conn = new SqlConnection(connectString))
{
string sql = @"UPDATE AdKeyword SET Name = @Name, Url = @Url, OrderId = @OrderId, Remark = @Remark, Tm = @Tm
where Id=@Id";
conn.Execute(sql, entity);
}
}
public int Add(AdKeywordInfo entity)
{
using (var conn = new SqlConnection(connectString))
{
string sql = @"INSERT INTO AdKeyword( Name,Url,OrderId,Remark,Tm) VALUES(@Name,@Url,@OrderId,@Remark,@Tm);
select SCOPE_IDENTITY()";
return(conn.Query <int>(sql, entity).Single());
}
}
public static void Update(AdKeywordInfo entity)
{
dal.Update(entity);
CacheHelper.Remove(cacheKey);
}
public static int Add(AdKeywordInfo entity)
{
entity.Id = dal.Add(entity);
CacheHelper.Remove(cacheKey);
return(entity.Id);
}