public void Remove(Model.Suggestion entity)
{
if (entity == null)
{
throw new ArgumentNullException("entity");
}
Remove(entity.SuggestionId);
}
public void Update(Model.Suggestion entity)
{
if (entity == null)
{
throw new ArgumentNullException("entity");
}
string update = string.Format(@"update Suggestion set MyName= @MyName,DepartmentId= @DepartmentId,PurposeSuggestionId= @PurposeSuggestionId,Content= @Content,MoneyNum= @MoneyNum,MoneyNumWrite= @MoneyNumWrite,ReturnMoneyNum= @ReturnMoneyNum,ReturnMoneyNumWrite= @ReturnMoneyNumWrite where SuggestionId = @SuggestionId");
Connection.Execute(update, entity, transaction: Transaction);
}
public void Add(Model.Suggestion entity)
{
if (entity == null)
{
throw new ArgumentNullException("entity");
}
string insert = string.Format(@"insert into Suggestion(MyName,DepartmentId,PurposeSuggestionId,Content,MoneyNum,MoneyNumWrite,ReturnMoneyNum,ReturnMoneyNumWrite) values (@MyName,@DepartmentId,@PurposeSuggestionId,@Content,@MoneyNum,@MoneyNumWrite,@ReturnMoneyNum,@ReturnMoneyNumWrite)");
Connection.Execute(insert, entity, Transaction);
}
