// 新增
public void Add(HRRewardsPunishments vo)
{
var ret = conn.Execute(@"insert HR_REWARDS_PUNISHMENTS(ID,TYPE,TITLE,CONTENT,AMOUNT) values (@Id,@Type,@Title,@Content,@Amount)",
new[] { new { Id = vo.Id,
Type = vo.Type,
Title = vo.Title,
Content = vo.Content,
Amount = vo.Amount } });
Console.WriteLine(string.Format("插入数据库成功{0}", ret));
}
/// <summary>
/// 更新
/// </summary>
/// <returns></returns>
public int Update(HRRewardsPunishments vo)
{
return(conn.Execute(@"update HR_REWARDS_PUNISHMENTS SET Type=@Type,Title=@Title,Content=@Content,Amount=@Amount WHERE id = @Id",
new
{
Id = vo.Id,
Type = vo.Type,
Title = vo.Title,
Content = vo.Content,
Amount = vo.Amount
}));
}
