public static CommandDefinition Insert(BUSINESS_WMS_KIT_SPEC record)
{
return(new CommandDefinition(
@"INSERT INTO [BUSINESS.WMS.KIT_SPEC] (
[GUID_RECORD], [PARENT_GUID], [CHILD_GUID], [CHILD_UOM_GUID], [BASE_QTY], [BATCH_GUID], [HIDDEN], [DELETED])
VALUES (@GUID_RECORD, @PARENT_GUID, @CHILD_GUID, @CHILD_UOM_GUID, @BASE_QTY, @BATCH_GUID, @HIDDEN, @DELETED)", record));
}
public static CommandDefinition Update(BUSINESS_WMS_KIT_SPEC record)
{
return(new CommandDefinition(
@"UPDATE [BUSINESS.WMS.KIT_SPEC] SET
[PARENT_GUID] = @PARENT_GUID,
[CHILD_GUID] = @CHILD_GUID,
[CHILD_UOM_GUID] = @CHILD_UOM_GUID,
[BASE_QTY] = @BASE_QTY,
[BATCH_GUID] = @BATCH_GUID
[HIDDEN] = @HIDDEN
[DELETED] = @DELETED
WHERE GUID_RECORD = @GUID_RECORD", record));
}
private ProductSpecification ToDTO(BUSINESS_WMS_KIT_SPEC record)
{
return(new ProductSpecification
{
BaseQty = record.BASE_QTY,
ChildId = record.CHILD_GUID,
ChildUomId = record.CHILD_UOM_GUID,
ParentId = record.PARENT_GUID,
Child = new Product
{
Id = record.CHILD_GUID
},
ChildUom = new Data.Business.Uom
{
Id = record.CHILD_UOM_GUID
},
Id = record.GUID_RECORD,
Parent = new Product
{
Id = record.PARENT_GUID
}
});
}
