def getNewNo(): sql = 'select max(no) from goods' results = DBUtil.select(sql) maxNo = results[0]['max(no)'] if maxNo != None: newNo = 'S' + str(int(maxNo.replace('S', '1')) + 1)[1:] return newNo else: # 没有记录,新创建一个 return 'S0001'
def getNewNo(): sql = 'select max(no) from provider' results = DBUtil.select(sql) maxNo = results[0]['max(no)'] if maxNo != '': newNo = 'G' + str(int(maxNo.replace('G', '1')) + 1)[1:] return newNo else: # 没有记录,新创建一个 return 'G00001'
def add(params): goods = Goods(id=DBUtil.next_id(), no=getNewNo(), name=params.name, guige=params.guige, unit=params.unit, conversion=params.conversion, quantity=params.quantity, money=float(params.quantity) * float(params.aprice), aprice=params.aprice) return goods.insert()
def add(params): taizhang = Taizhang(id=DBUtil.next_id(), no=params.no, time=params.time, deal_no=params.deal_no, goods_no=params.goods_no, goods_name=params.goods_name, goods_guige=params.goods_guige, buy_quantity=params.buy_quantity, buy_price=params.buy_price, buy_money=params.buy_money, sale_quantity=params.sale_quantity, sale_price=params.sale_price, sale_money=params.sale_money, store_quantity=params.store_quantity, store_money=params.store_money, store_aprice=params.store_aprice, comment=params.comment) return taizhang.insert()
def add(params): provider = Provider( id=DBUtil.next_id(), no=getNewNo(), name=params.name, code=params.code, shuiwu=params.shuiwu, person=params.person, phone=params.phone, mobile=params.mobile, address=params.address, email=params.email, url=params.url, postcode=params.postcode, fax=params.fax, comment=params.comment, creater=params.creater, createtime=int(time.time() * 1000), ) return provider.insert()
def add(params): customer = Customer( id=DBUtil.next_id(), no=getNewNo(), name=params.name, code=params.code, shuiwu=params.shuiwu, person=params.person, phone=params.phone, mobile=params.mobile, address=params.address, email=params.email, bank=params.bank, bank_no=params.bank_no, postcode=params.postcode, fax=params.fax, comment=params.comment, creater=params.creater, createtime=int(time.time() * 1000), ) return customer.insert()
def add(params): user = User(id=DBUtil.next_id(), name=params.name, cnname=params.cnname, password=params.password) return user.insert()
# -*- coding:utf8 from conf.config import configs from server.db import DBUtil from server.web.urls import * import web, logging from server.web.filter.AuthorizeFilter import loginFilter logging.log_errors = '1' web.config.debug = True DBUtil.create_engine(**configs.db) app = web.application(urls, globals()) print configs.db.host db = web.database(dbn='mysql', host=configs.db.host, port=configs.db.port, db=configs.db.db, user=configs.db.user, pw=configs.db.passwd) store = web.session.DBStore(db, 'sessions') session = web.session.Session(app, store, initializer={'count': 0}) #session = web.session.Session(app, web.session.DiskStore('sessions'), initializer={'count': 0}) web.config._session = session app.add_processor(loginFilter) if __name__ == '__main__': print 'run' app.run()