247 prod->wa_base_name = query.value("wa_base_name").toInt(); |
247 prod->wa_base_name = query.value("wa_base_name").toInt(); |
248 |
248 |
249 prod->starter_enable = query.value("starter_enable").toInt() ? true:false; |
249 prod->starter_enable = query.value("starter_enable").toInt() ? true:false; |
250 prod->starter_type = query.value("starter_type").toInt(); |
250 prod->starter_type = query.value("starter_type").toInt(); |
251 prod->starter_sg = query.value("starter_sg").toDouble(); |
251 prod->starter_sg = query.value("starter_sg").toDouble(); |
252 prod->starter_viability = query.value("starter_viability").toInt(); |
252 prod->starter_viability = query.value("starter_viability").toDouble(); |
253 if (query.value("yeast_prod_date").toString().length() == 10) |
253 if (query.value("yeast_prod_date").toString().length() == 10) |
254 prod->yeast_prod_date = query.value("yeast_prod_date").toDate(); |
254 prod->yeast_prod_date = query.value("yeast_prod_date").toDate(); |
255 else |
255 else |
256 prod->yeast_prod_date = QDate(); |
256 prod->yeast_prod_date = QDate(); |
257 prod->yeast_pitchrate = query.value("yeast_pitchrate").toDouble(); |
257 prod->yeast_pitchrate = query.value("yeast_pitchrate").toDouble(); |
833 query.bindValue(":wa_acid_perc", round(prod->wa_acid_perc * 10) / 10); |
833 query.bindValue(":wa_acid_perc", round(prod->wa_acid_perc * 10) / 10); |
834 query.bindValue(":wa_base_name", prod->wa_base_name); |
834 query.bindValue(":wa_base_name", prod->wa_base_name); |
835 query.bindValue(":starter_enable", prod->starter_enable ? 1:0); |
835 query.bindValue(":starter_enable", prod->starter_enable ? 1:0); |
836 query.bindValue(":starter_type", prod->starter_type); |
836 query.bindValue(":starter_type", prod->starter_type); |
837 query.bindValue(":starter_sg", round(prod->starter_sg * 1000) / 1000); |
837 query.bindValue(":starter_sg", round(prod->starter_sg * 1000) / 1000); |
838 query.bindValue(":starter_viability", prod->starter_viability); |
838 query.bindValue(":starter_viability", round(prod->starter_viability * 10) / 10); |
839 query.bindValue(":yeast_prod_date", prod->yeast_prod_date); |
839 query.bindValue(":yeast_prod_date", prod->yeast_prod_date); |
840 query.bindValue(":yeast_pitchrate", round(prod->yeast_pitchrate * 1000) / 1000); |
840 query.bindValue(":yeast_pitchrate", round(prod->yeast_pitchrate * 1000) / 1000); |
841 query.bindValue(":prop1_type", prod->prop_type[0]); |
841 query.bindValue(":prop1_type", prod->prop_type[0]); |
842 query.bindValue(":prop1_volume", round(prod->prop_volume[0] * 1000) / 1000); |
842 query.bindValue(":prop1_volume", round(prod->prop_volume[0] * 1000) / 1000); |
843 query.bindValue(":prop2_type", prod->prop_type[1]); |
843 query.bindValue(":prop2_type", prod->prop_type[1]); |