def main(): import sys from library.database import connectDataBaseByInfo from s11main import CS11mainApp app = CS11mainApp(sys.argv, False, 'S11App.ini', False) QtGui.qApp = app QtCore.QTextCodec.setCodecForTr(QtCore.QTextCodec.codecForName(u'utf8')) QtGui.qApp.currentOrgId = lambda: 229525# 230493 # 229525 # 230226 #229525 #229005 connectionInfo = {'driverName' : 'mysql', 'host' : 'pacs', 'port' : 3306, 'database' : 'novros', 'user' : 'dbuser', 'password' : 'dbpassword', 'connectionName' : 'vista-med', 'compressData' : True, 'afterConnectFunc' : None} """ connectionInfo = {'driverName': 'mysql', 'host': 'pes', 'port': 3306, 'database': 's12', 'user': '******', 'password': '******', 'connectionName': 'vista-med', 'compressData': True, 'afterConnectFunc': None} """ QtGui.qApp.db = connectDataBaseByInfo(connectionInfo) CReportF14DS(None).exec_() sys.exit(app.exec_())
def main(): import sys from library.database import connectDataBaseByInfo from s11main import CS11mainApp app = CS11mainApp(sys.argv, False, 'S11App.ini', False) QtGui.qApp = app QtCore.QTextCodec.setCodecForTr(QtCore.QTextCodec.codecForName(u'utf8')) QtGui.qApp.currentOrgId = lambda: 3147 connectionInfo = { 'driverName': 'mysql', 'host': '192.168.0.3', 'port': 3306, 'database': 'pnd5', 'user': '******', 'password': '******', 'connectionName': 'vista-med', 'compressData': True, 'afterConnectFunc': None } QtGui.qApp.db = connectDataBaseByInfo(connectionInfo) CReportReHospitalization(None).exec_() sys.exit(app.exec_())
def main(): import sys from s11main import CS11mainApp from library.database import connectDataBaseByInfo from PyQt4 import QtCore QtGui.qApp = CS11mainApp(sys.argv, False, 'S11App.ini', False) QtCore.QTextCodec.setCodecForTr(QtCore.QTextCodec.codecForName(u'utf8')) connectionInfo = { 'driverName': 'mysql', 'host': 'pz12', 'port': 3306, 'database': 's11', 'user': '******', 'password': '******', 'connectionName': 'vista-med', 'compressData': True, 'afterConnectFunc': None } QtGui.qApp.db = connectDataBaseByInfo(connectionInfo) w = CReportSurgical(None) w.exec_() sys.exit(QtGui.qApp.exec_())
def main(): import sys from s11main import CS11mainApp from library.database import connectDataBaseByInfo QtGui.qApp = CS11mainApp(sys.argv, False, 'S11App.ini', False) QtCore.QTextCodec.setCodecForTr(QtCore.QTextCodec.codecForName(u'utf8')) connectionInfo = { 'driverName': 'mysql', 'host': 'pes', 'port': 3306, 'database': 's12', 'user': '******', 'password': '******', 'connectionName': 'vista-med', 'compressData': True, 'afterConnectFunc': None } QtGui.qApp.db = connectDataBaseByInfo(connectionInfo) QtGui.qApp.userId = 1 w = CHospitalizationTransferPage(None, 1243474) w.show() QtGui.qApp.exec_()
def main(): import sys from library.database import connectDataBaseByInfo app = CS11mainApp(sys.argv, False, 'S11App.ini', False) QtGui.qApp = app QtCore.QTextCodec.setCodecForTr(QtCore.QTextCodec.codecForName(u'utf8')) connectionInfo = { 'driverName': 'mysql', 'host': 'pes', 'port': 3306, 'database': 's12', 'user': '******', 'password': '******', 'connectionName': 'vista-med', 'compressData': True, 'afterConnectFunc': None } db = connectDataBaseByInfo(connectionInfo) query = db.query(u''' SELECT o.organisation_id FROM OrgStructure o INNER JOIN Person p ON p.orgStructure_id = o.id ''') if query.first(): record = query.record() print forceStringEx(record.value('organisation_id').toString()), type( int(forceStringEx(record.value('organisation_id').toString()))) QtGui.qApp.currentOrgId = lambda: int( forceStringEx(record.value('organisation_id').toString())) print '229638_4' QtGui.qApp.db = connectDataBaseByInfo(connectionInfo) sys.exit(CRCReportList(None).exec_())
def main(): import sys from s11main import CS11mainApp from library.database import connectDataBaseByInfo app = CS11mainApp(sys.argv, False, 'S11App.ini', False) QtGui.qApp = app QtCore.QTextCodec.setCodecForTr(QtCore.QTextCodec.codecForName(u'utf8')) QtGui.qApp.currentOrgId = lambda: 386271 QtGui.qApp.currentOrgStructureId = lambda: 34 QtGui.qApp.db = connectDataBaseByInfo({ 'driverName': 'mysql', 'host': 'mos36', 'port': 3306, 'database': 's11', 'user': '******', 'password': '******', 'connectionName': 'vista-med', 'compressData': True, 'afterConnectFunc': None }) CReportMovingB36Monthly(None).exec_()
def main(): import sys from s11main import CS11mainApp from library.database import connectDataBaseByInfo QtGui.qApp = CS11mainApp(sys.argv, False, 'S11App.ini', False) QtCore.QTextCodec.setCodecForTr(QtCore.QTextCodec.codecForName(u'utf8')) connectionInfo = { 'driverName': 'mysql', 'host': '192.168.0.207', 'port': 3306, 'database': 's11vm2', 'user': '******', 'password': '******', 'connectionName': 'vista-med', 'compressData': True, 'afterConnectFunc': None } QtGui.qApp.db = connectDataBaseByInfo(connectionInfo) w = CClientDocumentsCheck(None) w.exec_()
def main(): import sys from s11main import CS11mainApp from library.database import connectDataBaseByInfo QtCore.QCoreApplication.setAttribute(QtCore.Qt.AA_X11InitThreads) QtGui.qApp = CS11mainApp(sys.argv, False, 'S11App.ini', False) QtCore.QTextCodec.setCodecForTr(QtCore.QTextCodec.codecForName(u'utf8')) connectionInfo = { 'driverName': 'mysql', 'host': 'pacs', 'port': 3306, 'database': 's11vm', 'user': '******', 'password': '******', 'connectionName': 'vista-med', 'compressData': True, 'afterConnectFunc': None } QtGui.qApp.db = connectDataBaseByInfo(connectionInfo) w = CCashRegisterWindow(None) w.exec_()
def main(): import sys from s11main import CS11mainApp from library.database import connectDataBaseByInfo app = CS11mainApp(sys.argv, False, 'S11App.ini', False) QtGui.qApp = app QtCore.QTextCodec.setCodecForTr(QtCore.QTextCodec.codecForName(u'utf8')) QtGui.qApp.currentOrgId = lambda: 230493 QtGui.qApp.db = connectDataBaseByInfo({ 'driverName': 'mysql', 'host': '192.168.0.207', 'port': 3306, 'database': 'most03-06-2016', 'user': '******', 'password': '******', 'connectionName': 'vista-med', 'compressData': True, 'afterConnectFunc': None }) CEventServicesCheck(None).exec_()
def openInventoryDocument(self, index): inventoryDocument = self.tblInventoryDocuments.model().getItem( index.row()) dlg = CInventoryDocumentDialog(self) dlg.setDocument(inventoryDocument, editable=False) dlg.exec_() self.reloadInventoryDocuments() if __name__ == '__main__': import sys from library.database import connectDataBaseByInfo from s11main import CS11mainApp QtGui.qApp = CS11mainApp(sys.argv, False, 'S11App.ini', False) QtCore.QTextCodec.setCodecForTr(QtCore.QTextCodec.codecForName('utf8')) QtGui.qApp.applyDecorPreferences() # QtGui.qApp.db = CDatabase() QtGui.qApp.db = connectDataBaseByInfo({ 'driverName': 'mysql', 'host': '192.168.0.3', 'port': 3306, 'database': 'ant_p17', 'user': '******', 'password': '******', 'connectionName': 'vista-med', 'compressData': True, 'afterConnectFunc': None }) # for print templates