/// <summary> /// 수정 /// </summary> public FiveViewModel Update(FiveViewModel model) { var sql = @"Update Fives Set Note= @Note Where Id = @Id "; _db.Execute(sql, model); return(model); }
/// <summary> /// 입력 메서드 /// </summary> /// <param name="model">FiveViewModel</param> /// <returns>FiveViewModel</returns> public FiveViewModel Add(FiveViewModel model) { string sql = @" Insert into Fives (Note) Values (@Note); Select Cast (SCOPE_IDENTITY() As Int); "; var id = _db.Query <int>(sql, new { Note = model.Note }).SingleOrDefault(); model.Id = id; return(model); }