def __init__(self, sess, UUID, parent=None):
QtGui.QDialog.__init__(self,parent)
self.ui=Ui_DatabaseDialog()
self.ui.setupUi(self)
self.sess = sess
self.UUID = UUID
self.getData(self.UUID)
class uiShowMore(QtGui.QDialog):
def __init__(self, sess, UUID, parent=None):
QtGui.QDialog.__init__(self,parent)
self.ui=Ui_DatabaseDialog()
self.ui.setupUi(self)
self.sess = sess
self.UUID = UUID
self.getData(self.UUID)
def getData(self, UUID):
with self.sess.begin():
record = self.sess.query (FireworksData).filter_by(UUID = UUID).first()
self.ui.comboBoxType.setCurrentIndex(self.ui.comboBoxType.findText(record.Type))
self.ui.lineEditName.setText(record.Name)
self.ui.lineEditAlias.setText(record.Alias)
self.ui.lineEdit_descript.setText(record.Description)
self.ui.lineEdit_size.setText(str(record.Size))
self.ui.lineEdit_usedEffect.setText(str(record.UsedEffects))
self.ui.lineEdit_Min.setText(str(record.Min))
self.ui.lineEdit_Best.setText(str(record.Best))
self.ui.lineEdit_stock.setText(str(record.Stock))
risTime = record.RisingTime
self.ui.lineEdit_riseTime.setText(str(risTime.total_seconds()))
info = json.loads(record.EffectsInfo)
self.ui.lineEdit_effect1.setText(info["EffectsInfo"][0][0])
self.ui.comboBoxColor1.setCurrentIndex(self.ui.comboBoxColor1.findText(info["EffectsInfo"][0][1]))
self.ui.IconLabel_color1.setAutoFillBackground(True)
self.ui.IconLabel_color1.setStyleSheet("QLabel{background-color:%s}" % info["EffectsInfo"][0][1])
self.ui.lineEdit_durationTime1.setText(str(info["EffectsInfo"][0][2]))
self.ui.lineEdit_effect2.setText(info["EffectsInfo"][1][0])
self.ui.comboBoxColor2.setCurrentIndex(self.ui.comboBoxColor2.findText(info["EffectsInfo"][1][1]))
self.ui.IconLabel_color2.setAutoFillBackground(True)
self.ui.IconLabel_color2.setStyleSheet("QLabel{background-color:%s}" % info["EffectsInfo"][1][1])
self.ui.lineEdit_durationTime2.setText(str(info["EffectsInfo"][1][2]))
self.ui.lineEdit_effect3.setText(info["EffectsInfo"][2][0])
self.ui.comboBoxColor3.setCurrentIndex(self.ui.comboBoxColor3.findText(info["EffectsInfo"][2][1]))
self.ui.IconLabel_color3.setAutoFillBackground(True)
self.ui.IconLabel_color3.setStyleSheet("QLabel{background-color:%s}" % info["EffectsInfo"][2][1])
self.ui.lineEdit_durationTime3.setText(str(info["EffectsInfo"][2][2]))
self.ui.lineEdit_shots.setText(str(record.Shots))
if record.Indoor == 0:
self.ui.radioButton_indoor.setChecked(True)
self.ui.radioButton_outdoor.setChecked(False)
elif record.Indoor == 1:
self.ui.radioButton_indoor.setChecked(False)
self.ui.radioButton_outdoor.setChecked(True)
self.ui.lineEdit_riseHeight.setText(str(record.RisingHeight))
self.ui.lineEdit_diameter.setText(str(record.Diameter))
self.ui.lineEdit_class.setText(record.Class)
self.ui.lineEdit_BAMnumber.setText(record.BAMNumber)
self.ui.lineEdit_ADRclass.setText(record.ADRClass)
self.ui.lineEdit_UNnumber.setText(record.UNNumber)
self.ui.lineEdit_chiper.setText(str(record.Chipher))
self.ui.lineEdit_weightGross.setText(str(record.WeightGross))
self.ui.lineEdit_weightNet.setText(str(record.WeightNet))
self.ui.lineEdit_HorizSafeDistance.setText(str(record.SDHorizontal))
self.ui.lineEdit_VertSafeDistance.setText(str(record.SDVertical))
self.ui.lineEdit_SimEffectID.setText(str(record.EffectID))
self.ui.lineEdit_Rating.setText(record.Rating)
self.ui.lineEdit_information.setText(record.Information)
self.ui.lineEdit_supplier.setText(record.Supplier)
self.ui.lineEdit_producer.setText(record.Producer)
self.ui.lineEdit_itemNo.setText(record.ItemNo)
self.ui.lineEdit_StockPlace.setText(record.StockPlace)
self.ui.lineEdit_Price.setText(str(record.Price))
self.ui.lineEdit_calcFactor.setText(str(record.CalcFactor))
self.ui.textEditNotes.setText(record.Notes)
def cancel(self):
self.close()