API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 4th, 2016
92
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.44 KB | None | 0 0
raw download clone embed print report
  1. #Muda codificação para UTF-8
  2. # -*- coding: utf-8 -*-
  3. #importações de modulos
  4.  
  5. import sys
  6. from PyQt4 import QtCore, QtGui
  7. import mysql.connector
  8.  
  9. try:
  10. _fromUtf8 = QtCore.QString.fromUtf8
  11. except AttributeError:
  12. def _fromUtf8(s):
  13. return s
  14.  
  15. try:
  16. _encoding = QtGui.QApplication.UnicodeUTF8
  17. def _translate(context, text, disambig):
  18. return QtGui.QApplication.translate(context, text, disambig, _encoding)
  19. except AttributeError:
  20. def _translate(context, text, disambig):
  21. return QtGui.QApplication.translate(context, text, disambig)
  22.  
  23. #Classe da tela de login
  24. class Login(QtGui.QDialog):
  25. def __init__(self, parent=None):
  26. super(Login, self).__init__(parent)
  27. self.setWindowTitle('InfoCad - Login')
  28. self.setGeometry(400,300,300,250)
  29.  
  30. #Label Login
  31. self.lb_logo = QtGui.QLabel('HL INFORMÁTICA', self)
  32. self.lb_user = QtGui.QLabel('Usuário:', self)
  33. self.lb_pass = QtGui.QLabel('Senha:', self)
  34. self.lb_logo.setGeometry(85, 25, 150, 15)
  35. self.lb_user.setGeometry(40, 60, 60, 30)
  36. self.lb_pass.setGeometry(40, 100, 60, 30)
  37. self.font = QtGui.QFont()
  38. self.font.setBold(True)
  39. self.font.setWeight(75)
  40. self.lb_logo.setFont(self.font)
  41.  
  42.  
  43. #Line Edit Login
  44. self.le_user = QtGui.QLineEdit(self)
  45. self.le_pass = QtGui.QLineEdit(self)
  46. self.le_user.setGeometry(100, 60, 150, 30)
  47. self.le_pass.setGeometry(100, 100, 150, 30)
  48. self.le_pass.setEchoMode(QtGui.QLineEdit.Password)
  49.  
  50. #Botões Login
  51. self.btn_enter = QtGui.QPushButton("Entrar", self)
  52. self.btn_sair = QtGui.QPushButton('Cancelar', self)
  53. self.btn_enter.move(150,190)
  54. self.btn_sair.move(45,190)
  55.  
  56. #Funções Botões
  57. self.btn_enter.clicked.connect(self.validarlogin)
  58. self.btn_sair.clicked.connect(sys.exit)
  59.  
  60. #Metodo de conexão com banco
  61. def ConexaoBanco(self):
  62. BANCO = 'bancohlinfo'
  63. USER = 'hlinforj'
  64. PASSWD = 'salafraria329'
  65. HOST = 'db4free.net'
  66. try:
  67. con = mysql.connector.connect(user=USER, password=PASSWD, host=HOST, database=BANCO)
  68. except mysql as error:
  69. print('Não foi possivel conectar-se ao Banco de Dados', erro)
  70. return con
  71.  
  72. #Testa se usuario e senha estão corretos
  73. def validarlogin(self):
  74. try:
  75. conexao = self.ConexaoBanco()
  76. cursor = conexao.cursor()
  77. usuario = self.le_user.text()
  78. senha = self.le_pass.text()
  79. sql = "SELECT * FROM staff where username like'"+usuario+"' and userpass like'"+senha+"'"
  80. cursor.execute(sql)
  81. valido = cursor.fetchall()
  82.  
  83. if len(valido) > 0:
  84. print('Conectado!')
  85. self.accept()
  86.  
  87. else:
  88. QtGui.QMessageBox.warning(self, 'Erro 157!', 'Usuário ou senha incorretos!')
  89. except mysql as erro:
  90. print('Nao conseguiu conectar', erro)
  91.  
  92. '''
  93. def status(self):
  94. user = self.le_user.text()
  95. passw = self.le_pass.text()
  96.  
  97. if user == 'admin' and passw == '123':
  98.  
  99. print('Conectado!! %s %s' % (user, passw))
  100. self.accept()
  101.  
  102. else:
  103. QtGui.QMessageBox.warning(self, 'Erro 157!', 'Usuário ou senha incorretos!')
  104. '''
  105.  
  106.  
  107. #Classe da tela principal
  108. class Ui_MainWindow(object):
  109. def setupUi(self, MainWindow):
  110. MainWindow.setObjectName(_fromUtf8("MainWindow"))
  111. MainWindow.setEnabled(True)
  112. MainWindow.resize(600, 400)
  113. self.centralwidget = QtGui.QWidget(MainWindow)
  114. self.centralwidget.setObjectName(_fromUtf8("centralwidget"))
  115. self.horizontalLayout_2 = QtGui.QHBoxLayout(self.centralwidget)
  116. self.horizontalLayout_2.setObjectName(_fromUtf8("horizontalLayout_2"))
  117. self.verticalLayout = QtGui.QVBoxLayout()
  118. self.verticalLayout.setObjectName(_fromUtf8("verticalLayout"))
  119. self.lbPesquisar = QtGui.QLabel(self.centralwidget)
  120. self.lbPesquisar.setMaximumSize(QtCore.QSize(60, 20))
  121. self.lbPesquisar.setObjectName(_fromUtf8("lbPesquisar"))
  122. self.verticalLayout.addWidget(self.lbPesquisar)
  123. self.lePesquisar = QtGui.QLineEdit(self.centralwidget)
  124. self.lePesquisar.setMaximumSize(QtCore.QSize(120, 16777215))
  125. self.lePesquisar.setObjectName(_fromUtf8("lePesquisar"))
  126. self.verticalLayout.addWidget(self.lePesquisar)
  127. self.cbpesquisar = QtGui.QComboBox(self.centralwidget)
  128. self.cbpesquisar.setMaximumSize(QtCore.QSize(120, 16777215))
  129. self.cbpesquisar.setObjectName(_fromUtf8("cbpesquisar"))
  130. self.cbpesquisar.addItem(_fromUtf8(""))
  131. self.cbpesquisar.addItem(_fromUtf8(""))
  132. self.cbpesquisar.addItem(_fromUtf8(""))
  133. self.cbpesquisar.addItem(_fromUtf8(""))
  134. self.cbpesquisar.addItem(_fromUtf8(""))
  135. self.cbpesquisar.addItem(_fromUtf8(""))
  136. self.verticalLayout.addWidget(self.cbpesquisar)
  137. spacerItem = QtGui.QSpacerItem(20, 40, QtGui.QSizePolicy.Minimum, QtGui.QSizePolicy.Expanding)
  138. self.verticalLayout.addItem(spacerItem)
  139. self.horizontalLayout_2.addLayout(self.verticalLayout)
  140. self.horizontalLayout = QtGui.QHBoxLayout()
  141. self.horizontalLayout.setObjectName(_fromUtf8("horizontalLayout"))
  142. self.tabWidget = QtGui.QTabWidget(self.centralwidget)
  143. self.tabWidget.setEnabled(False)
  144. self.tabWidget.setObjectName(_fromUtf8("tabWidget"))
  145. self.tab_2 = QtGui.QWidget()
  146. self.tab_2.setObjectName(_fromUtf8("tab_2"))
  147. self.tabWidget.addTab(self.tab_2, _fromUtf8(""))
  148. self.horizontalLayout.addWidget(self.tabWidget)
  149. self.horizontalLayout_2.addLayout(self.horizontalLayout)
  150. MainWindow.setCentralWidget(self.centralwidget)
  151. self.menubar = QtGui.QMenuBar(MainWindow)
  152. self.menubar.setGeometry(QtCore.QRect(0, 0, 600, 19))
  153. self.menubar.setObjectName(_fromUtf8("menubar"))
  154. self.menuClientes = QtGui.QMenu(self.menubar)
  155. self.menuClientes.setObjectName(_fromUtf8("menuClientes"))
  156. self.menuClientes_2 = QtGui.QMenu(self.menuClientes)
  157. self.menuClientes_2.setObjectName(_fromUtf8("menuClientes_2"))
  158. self.menuOrdem_Servi_o = QtGui.QMenu(self.menuClientes)
  159. self.menuOrdem_Servi_o.setObjectName(_fromUtf8("menuOrdem_Servi_o"))
  160. self.menuProduto = QtGui.QMenu(self.menuClientes)
  161. self.menuProduto.setObjectName(_fromUtf8("menuProduto"))
  162. self.menuVendas = QtGui.QMenu(self.menubar)
  163. self.menuVendas.setObjectName(_fromUtf8("menuVendas"))
  164. self.menuSistema = QtGui.QMenu(self.menubar)
  165. self.menuSistema.setObjectName(_fromUtf8("menuSistema"))
  166. self.menuUtilitario = QtGui.QMenu(self.menubar)
  167. self.menuUtilitario.setObjectName(_fromUtf8("menuUtilitario"))
  168. self.menuAjuda = QtGui.QMenu(self.menubar)
  169. self.menuAjuda.setObjectName(_fromUtf8("menuAjuda"))
  170. self.menuSair = QtGui.QMenu(self.menubar)
  171. self.menuSair.setObjectName(_fromUtf8("menuSair"))
  172. MainWindow.setMenuBar(self.menubar)
  173. self.statusbar = QtGui.QStatusBar(MainWindow)
  174. self.statusbar.setObjectName(_fromUtf8("statusbar"))
  175. MainWindow.setStatusBar(self.statusbar)
  176. self.actionNovo = QtGui.QAction(MainWindow)
  177. self.actionNovo.setObjectName(_fromUtf8("actionNovo"))
  178. self.actionNovo_2 = QtGui.QAction(MainWindow)
  179. self.actionNovo_2.setObjectName(_fromUtf8("actionNovo_2"))
  180. self.actionPesquisar = QtGui.QAction(MainWindow)
  181. self.actionPesquisar.setObjectName(_fromUtf8("actionPesquisar"))
  182. self.actionNovo_3 = QtGui.QAction(MainWindow)
  183. self.actionNovo_3.setObjectName(_fromUtf8("actionNovo_3"))
  184. self.actionPesquisar_2 = QtGui.QAction(MainWindow)
  185. self.actionPesquisar_2.setObjectName(_fromUtf8("actionPesquisar_2"))
  186. self.actionNovo_4 = QtGui.QAction(MainWindow)
  187. self.actionNovo_4.setObjectName(_fromUtf8("actionNovo_4"))
  188. self.actionPesquisar_3 = QtGui.QAction(MainWindow)
  189. self.actionPesquisar_3.setObjectName(_fromUtf8("actionPesquisar_3"))
  190. self.actionConfigura_o = QtGui.QAction(MainWindow)
  191. self.actionConfigura_o.setObjectName(_fromUtf8("actionConfigura_o"))
  192. self.actionBackup = QtGui.QAction(MainWindow)
  193. self.actionBackup.setObjectName(_fromUtf8("actionBackup"))
  194. self.actionRestaurar_Backup = QtGui.QAction(MainWindow)
  195. self.actionRestaurar_Backup.setObjectName(_fromUtf8("actionRestaurar_Backup"))
  196. self.actionCalculadora = QtGui.QAction(MainWindow)
  197. self.actionCalculadora.setObjectName(_fromUtf8("actionCalculadora"))
  198. self.actionBloco_de_Notas = QtGui.QAction(MainWindow)
  199. self.actionBloco_de_Notas.setObjectName(_fromUtf8("actionBloco_de_Notas"))
  200. self.actionSobre = QtGui.QAction(MainWindow)
  201. self.actionSobre.setObjectName(_fromUtf8("actionSobre"))
  202. self.actionSobre_2 = QtGui.QAction(MainWindow)
  203. self.actionSobre_2.setObjectName(_fromUtf8("actionSobre_2"))
  204. self.menuClientes_2.addAction(self.actionNovo_2)
  205. self.menuClientes_2.addAction(self.actionPesquisar)
  206. self.menuOrdem_Servi_o.addAction(self.actionNovo_3)
  207. self.menuOrdem_Servi_o.addAction(self.actionPesquisar_2)
  208. self.menuProduto.addAction(self.actionNovo_4)
  209. self.menuProduto.addAction(self.actionPesquisar_3)
  210. self.menuClientes.addAction(self.menuClientes_2.menuAction())
  211. self.menuClientes.addAction(self.menuOrdem_Servi_o.menuAction())
  212. self.menuClientes.addAction(self.menuProduto.menuAction())
  213. self.menuSistema.addAction(self.actionConfigura_o)
  214. self.menuSistema.addSeparator()
  215. self.menuSistema.addAction(self.actionBackup)
  216. self.menuSistema.addAction(self.actionRestaurar_Backup)
  217. self.menuUtilitario.addAction(self.actionCalculadora)
  218. self.menuUtilitario.addAction(self.actionBloco_de_Notas)
  219. self.menuAjuda.addAction(self.actionSobre)
  220. self.menuAjuda.addAction(self.actionSobre_2)
  221. self.menubar.addAction(self.menuClientes.menuAction())
  222. self.menubar.addAction(self.menuVendas.menuAction())
  223. self.menubar.addAction(self.menuSistema.menuAction())
  224. self.menubar.addAction(self.menuUtilitario.menuAction())
  225. self.menubar.addAction(self.menuAjuda.menuAction())
  226. self.menubar.addAction(self.menuSair.menuAction())
  227.  
  228. self.retranslateUi(MainWindow)
  229. self.tabWidget.setCurrentIndex(0)
  230. QtCore.QObject.connect(self.cbpesquisar, QtCore.SIGNAL(_fromUtf8("activated(QString)")), self.lePesquisar.clear)
  231. QtCore.QMetaObject.connectSlotsByName(MainWindow)
  232.  
  233. def retranslateUi(self, MainWindow):
  234. MainWindow.setWindowTitle(_translate("MainWindow", "InfoCad - Sistema de Cadastro", None))
  235. self.lbPesquisar.setText(_translate("MainWindow", "Pesquisar:", None))
  236. self.cbpesquisar.setItemText(0, _translate("MainWindow", "Ordem Serviço", None))
  237. self.cbpesquisar.setItemText(1, _translate("MainWindow", "Nome", None))
  238. self.cbpesquisar.setItemText(2, _translate("MainWindow", "CPF", None))
  239. self.cbpesquisar.setItemText(3, _translate("MainWindow", "Marca", None))
  240. self.cbpesquisar.setItemText(4, _translate("MainWindow", "Modelo", None))
  241. self.cbpesquisar.setItemText(5, _translate("MainWindow", "Telefone", None))
  242. self.tabWidget.setTabText(self.tabWidget.indexOf(self.tab_2), _translate("MainWindow", "Resultado:", None))
  243. self.menuClientes.setTitle(_translate("MainWindow", "Cadastro", None))
  244. self.menuClientes_2.setTitle(_translate("MainWindow", "Cliente", None))
  245. self.menuOrdem_Servi_o.setTitle(_translate("MainWindow", "Ordem Serviço", None))
  246. self.menuProduto.setTitle(_translate("MainWindow", "Produto", None))
  247. self.menuVendas.setTitle(_translate("MainWindow", "Vendas", None))
  248. self.menuSistema.setTitle(_translate("MainWindow", "Sistema", None))
  249. self.menuUtilitario.setTitle(_translate("MainWindow", "Utilitario", None))
  250. self.menuAjuda.setTitle(_translate("MainWindow", "Ajuda", None))
  251. self.menuSair.setTitle(_translate("MainWindow", "Sair", None))
  252. self.actionNovo.setText(_translate("MainWindow", "Novo", None))
  253. self.actionNovo_2.setText(_translate("MainWindow", "Novo", None))
  254. self.actionPesquisar.setText(_translate("MainWindow", "Pesquisar", None))
  255. self.actionNovo_3.setText(_translate("MainWindow", "Novo", None))
  256. self.actionPesquisar_2.setText(_translate("MainWindow", "Pesquisar", None))
  257. self.actionNovo_4.setText(_translate("MainWindow", "Novo", None))
  258. self.actionPesquisar_3.setText(_translate("MainWindow", "Pesquisar", None))
  259. self.actionConfigura_o.setText(_translate("MainWindow", "Configuração", None))
  260. self.actionBackup.setText(_translate("MainWindow", "Backup", None))
  261. self.actionRestaurar_Backup.setText(_translate("MainWindow", "Restaurar Backup", None))
  262. self.actionCalculadora.setText(_translate("MainWindow", "Calculadora", None))
  263. self.actionBloco_de_Notas.setText(_translate("MainWindow", "Bloco de Notas", None))
  264. self.actionSobre.setText(_translate("MainWindow", "Site", None))
  265. self.actionSobre_2.setText(_translate("MainWindow", "Sobre", None))
  266.  
  267. #Roda o sistema
  268. if __name__ == '__main__':
  269.  
  270. app = QtGui.QApplication(sys.argv)
  271. login = Login()
  272.  
  273. if login.exec_() == QtGui.QDialog.Accepted:
  274. MainWindow = QtGui.QMainWindow()
  275. ui = Ui_MainWindow()
  276. ui.setupUi(MainWindow)
  277. MainWindow.show()
  278. sys.exit(app.exec_())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!