/// <summary>
/// 수정 메서드: Update, UpdateGoods, Edit, Modify
/// </summary>
public GoodsBase UpdateGoods(GoodsBase model)
{
// 인라인 SQL(Ad Hoc 쿼리) 또는 저장 프로시저 지정
var query =
"Update Goods " +
"Set " +
" GoodsName = @GoodsName, " +
" GoodsDescription = @GoodsDescription " +
"Where GoodsId = @GoodsId ";
// 파라미터 추가
var parameters = new DynamicParameters();
parameters.Add("@GoodsName",
value: model.GoodsName,
dbType: DbType.String,
direction: ParameterDirection.Input);
parameters.Add("@GoodsDescription",
value: model.GoodsDescription,
dbType: DbType.String,
direction: ParameterDirection.Input);
parameters.Add("@GoodsId",
value: model.GoodsId,
dbType: DbType.Int32,
direction: ParameterDirection.Input);
// 실행
db.Execute(query, parameters, commandType: CommandType.Text);
return(model);
}
/// <summary>
/// 입력 메서드: Add, AddGoods, Write, Persist, Create
/// </summary>
public GoodsBase AddGoods(GoodsBase model)
{
string sql = @"
Insert Into Goods (GoodsName, GoodsDescription) Values (@GoodsName, @GoodsDescription);
Select Cast(SCOPE_IDENTITY() As Int);
";
model.GoodsId = db.Query <int>(sql, model).Single();
return(model);
}
