public ReferenceUnits GetROSAReferenceUnits(ROSAOutput output)
{
var part = output.Part_Number;
using (var conn = SimpleDbConnection())
{
conn.Open();
ReferenceUnits units = conn.Query <ReferenceUnits>(
@"SELECT X, Y, Z, Part_Number
from ROSAReferenceUnits where
Part_Number = @part ;", new { part }).FirstOrDefault();
return(units);
}
}
public void SaveROSAReferenceUnits(ReferenceUnits units)
{
using (var conn = SimpleDbConnection())
{
conn.Open();
conn.Execute(@"
INSERT OR REPLACE INTO ROSAReferenceUnits
(X, Y, Z, Part_Number)
values
(@X, @Y, @Z, @Part_Number);
",
new
{
X = units.X,
Y = units.Y,
Z = units.Z,
Part_Number = units.Part_Number
});
}
}
