def addOneTransaction(jz_id, pro_id, amount):
'''插入一条用户消费记录'''
PrintInfo('插入一条消费信息，用Id%d' % jz_id)
#获取当前时间
now = int(time.time())
timeArray = time.localtime(now)
otherStyleTime = time.strftime("%Y/%m/%d %H:%M:%S", timeArray)
dbManage = DBManage.GetInstance()
dbManage.DBConnect()
cur = dbManage.connect.cursor()
#插入一条消费记录
cur.execute(
'INSERT INTO jz_pro_trans \
(jz_id, pro_id, tran_amount, tran_date)\
values (?,?,?,?)',
(jz_id, pro_id, amount, otherStyleTime))
#更新用户的总额
cur.execute('UPDATE jz_users SET jz_money = (jz_money - %.2f) \
WHERE jz_id = %d' % (amount, jz_id))
dbManage.connect.commit()
cur.execute('SELECT max(tran_id) FROM jz_pro_trans WHERE jz_id = %d' %
jz_id)
tranId = cur.fetchone()
dbManage.DBClose()
if (len(tranId) > 0):
return tranId[0]
else:
return 0
PrintInfo('用户%d插入消费信息成功' % jz_id)
def getAllPrograms():
'''获取所有的消费项目'''
dbManage = DBManage.GetInstance()
dbManage.DBConnect()
cur = dbManage.connect.cursor()
cur.execute('SELECT pro_id, pro_name FROM jz_programs')
programs = cur.fetchall()
dbManage.DBClose()
PrintInfo('获取所有的消费项目成功')
return programs
def addOneUser(jz_NO, jz_name, jz_gender, jz_mobile, jz_birth, jz_money):
'''插入一条用户信息到数据库中'''
PrintInfo('插入一条用户信息，用户名%s' % jz_name)
dbManage = DBManage.GetInstance()
dbManage.DBConnect()
cur = dbManage.connect.cursor()
cur.execute(
'INSERT INTO jz_users \
(jz_NO, jz_name, jz_gender, jz_mobile, jz_birth, jz_money)\
values (?,?,?,?,?,?)',
(jz_NO, jz_name, jz_gender, jz_mobile, jz_birth, jz_money))
dbManage.connect.commit()
dbManage.DBClose()
PrintInfo('用户名%s插入成功' % jz_name)
def getUserInfoByNO(jz_NO):
'''根据手机号获取用户信息'''
PrintInfo('获取用户信息，会员号%s' % jz_NO)
dbManage = DBManage.GetInstance()
dbManage.DBConnect()
cur = dbManage.connect.cursor()
cur.execute('SELECT * FROM jz_users WHERE jz_NO = "%s"' % jz_NO)
userInfo = cur.fetchone()
dbManage.DBClose()
PrintInfo('会员号%s获取成功' % jz_NO)
if (userInfo != None):
userBean = UserInfoBean(userInfo)
return userBean
else:
return None
def __init__(self, enities):
self.enities = enities
db = DBManage.DBManage(host="192.168.1.200",
port="1433",
user="******",
password="******",
database="VIM_VCDB",
charset="UTF-8")
db.getMSSConnetion()
self.cursor = db.QuerySql(self.sql)
row = self.cursor.fetchone()
while row:
self.enities.append(row)
row = self.cursor.fetchone()
db.closeConn()
import xlwt
import sys
import json
import DBManage as db
import calendar
from datetime import date
'''
DB connection
'''
connection = db.DBConnect()
cur = connection.cursor()
def query(lowerLimit, higherLimit):
try:
queryToExc = str(
'SELECT saldos_ahorro.tipo_cuenta,'
'saldos_ahorro.correl_cuenta, '
'cuentas_ahorro.fecha_apertura,'
'asociados.primer_nombre,'
'asociados.segundo_nombre,'
'asociados.apellido_paterno,'
'asociados.apellido_materno,'
'saldos_ahorro.saldo_inicial,'
'saldos_ahorro.intereses_proyectados, saldos_ahorro.intereses_finales, saldos_ahorro.ingresos_programados, saldos_ahorro.ingresos_adicionales, '
'saldos_ahorro.egresos, saldos_ahorro.auxilio_postumo, saldos_ahorro.isr, saldos_ahorro.saldo_final'
' FROM "SVC".saldos_ahorro, "SVC".cuentas_ahorro, "SVC".asociados'
' WHERE asociados.id_asociado_id = cuentas_ahorro.asociado_id'
' AND cuentas_ahorro.asociado_id = saldos_ahorro.asociado_id'
from pg import DB
import DBManage
MS = DBManage.DBManage(host="192.168.1.200",
port="1433",
user="******",
password="******",
database="VIM_VCDB",
charset="UTF-8")
PG = DB(dbname='VM', host='localhost', port=5432, user='******', passwd='123456')
MS.getMSSConnetion()
sql1 = "SELECT [ID] ,[STAT_ROLLUP] ,[NAME] ,[GROUP_NAME] ,[TYPE] ,[UNIT] ,[ASSOCIATE_IDS] ,[STATS_LEVEL] ,[FIXED_COLLECTION_INTERVAL] FROM [VIM_VCDB].[dbo].[VPXV_STAT_COUNTERS]"
cursor1 = MS.QuerySql(sql1)
Tuple = cursor1.fetchone()
while Tuple:
PG.insert('stat_counters',
id=Tuple[0],
stat_rollup=Tuple[1],
name=Tuple[2],
group_name=Tuple[3],
type=Tuple[4],
unit=Tuple[5],
associate_ids=Tuple[6],
stats_level=Tuple[7],
fixed_collection_interval=Tuple[8])
Tuple = cursor1.fetchone()
print("成功！")
MS.closeConn()
def firstInit():
DBManage.resetDB()
DBManage.initializeDB()
ms.mockData(server)
print("App reset successful")
from Server import Server
from ManagementService import ManagementService
import DBManage
from Terminal import Terminal
DBManage.initializeDB()
server = Server()
ms = ManagementService()
listOfTerminals = []
listOfCards = []
def firstInit():
DBManage.resetDB()
DBManage.initializeDB()
ms.mockData(server)
print("App reset successful")
def init():
cards = ms.getAllCards()
reloadTerminals()
for card in cards:
listOfCards.append(card[0])
def reloadTerminals():
listOfTerminals.clear()
terminals = ms.getAllTerminals()