loan python

3
import sys import mysql.connector from loanc import * class MyForm(QtGui.QDialog): def __init__(self,parent=None): QtGui.QWidget.__init__(self,parent) self.ui=Ui_Dialog() self.ui.setupUi(self) self.condatbase() QtCore.QObject.connect(self.ui.calculate, QtCore.SIGNAL('clicked()'), self.calculate1) QtCore.QObject.connect(self.ui.database, QtCore.SIGNAL('clicked()'), self.database1) def calculate1(self): global expo if len(self.ui.amountloan.text())!=0: a=int(self.ui.amountloan.text()) else: a=0

Upload: cyrene-palparan

Post on 16-Aug-2015

217 views

Category:

Documents


1 download

DESCRIPTION

d

TRANSCRIPT

import sysimport mysql.connectorfrom loanc import *class MyForm(QtGui.QDialog):def __init__(self,parent!one):QtGui.Q"idget.__init__(self,parent)self.ui#i_Dialog()self.ui.setup#i(self)self.condat$ase()Qt%ore.Q&$'ect.connect(self.ui.calculate, Qt%ore.()G!*+(,clic-ed(),),self.calculate.)Qt%ore.Q&$'ect.connect(self.ui.data$ase, Qt%ore.()G!*+(,clic-ed(),),self.data$ase.)def calculate.(self):glo$al e/poif len(self.ui.amountloan.te/t())01:aint(self.ui.amountloan.te/t())else:a1if len(self.ui.interest.te/t())01:$int(self.ui.interest.te/t())else:$1if len(self.ui.noofmos.te/t())01:cint(self.ui.noofmos.te/t())else:c1e/po(a*($2.311)*(.4($2.311))**c)2(((.4($2.311))**c)5.)self.ui.totalinterest.set6e/t(str(e/po))def data$ase.(self):

connmysql.connector.connect(user,root,,pass7ord,,,8ost,local8ost,,data$ase,loan,)cursor.conn.cursor()c8osenclassself.ui.com$o9o/.item6e/t(self.ui.com$o9o/.current)nde/())e/po.:;c8osenclass.3cursor..e/ecute( loanoutput (>6 loan_output?s"@>A> emp_name ?s%6emp_name from loanoutput