import DB
import datetime
from decimal import Decimal
db = DB.DB()
a = input("请输入会员卡号:".decode("UTF-8").encode("GBK"))
#print a
info = db.getsinglesBySql("select * from t_m_pay where vch_memberno like %s or vch_memberno ='' order by vch_memberno" %(a))
if len(info)==0:
print "没有你要查询的结果".decode("UTF-8").encode("GBK")
for i in range(0,len(info)):
# print tuple(info[i])
# print info[i]
tranData =[x.strftime('%Y-%m-%d %H:%M:%S') if isinstance(x,datetime.datetime) else float(x) if isinstance(x,Decimal)else x for x in info[i]] #格式化
print tranData
import datetime
from decimal import Decimal
db = DB.DB()
a = input("请输入会员卡号:".decode("UTF-8").encode("GBK"))
#print a
info = db.getsinglesBySql("select * from t_m_pay where vch_memberno like %s or vch_memberno ='' order by vch_memberno" %(a))
if len(info)==0:
print "没有你要查询的结果".decode("UTF-8").encode("GBK")
for i in range(0,len(info)):
# print tuple(info[i])
# print info[i]
tranData =[x.strftime('%Y-%m-%d %H:%M:%S') if isinstance(x,datetime.datetime) else float(x) if isinstance(x,Decimal)else x for x in info[i]] #格式化
print tranData