public void Update(WorkingHourTableRow row)
{
#region SQL
const string sql = @"
UPDATE
workinghours
SET
starttime = @starttime
, endtime = @endtime
WHERE
ymd = @ymd
";
#endregion
Connection.Execute(sql, row);
}
public void Insert(WorkingHourTableRow row)
{
#region SQL
const string sql = @"
INSERT INTO
workinghours
(
ymd
, starttime
, endtime
)
VALUES
(
@ymd
, @starttime
, @endtime
)
";
#endregion
Connection.Execute(sql, row);
}