src/database/db_product.cpp

changeset 478
a3653722b0d6
parent 458
ac216a75ca9b
child 482
e13763ec829f
equal deleted inserted replaced
477:27e179759bf2 478:a3653722b0d6
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]);

mercurial