def admin_user_netcard_update(netcard_id, db): vdbm = dbm.DbM(db) #数据库字段名参考:netcard_id, nickname, image, commuity_user_id, user_id utf_forms = bottle.request.forms.decode("utf-8") vdbm.update(table='netcard', condition=' where netcard_id=' + netcard_id, form_dict=utf_forms.dict)
def admin_user_livingcard_update(livingcard_id, db): vdbm = dbm.DbM(db) #数据库字段名参考:livingcard_id, name, address, zip_code, house_number, user_id utf_forms = bottle.request.forms.decode("utf-8") vdbm.update(table='livingcard', condition=' where livingcard_id=' + livingcard_id, form_dict=utf_forms.dict)
def admin_user_citizencard_add(db): vdbm = dbm.DbM(db) # 数据库字段名参考:citizen_id, name, identification_type, identification_value, marriage_status, # employment_status, residence_category, resident_status, education_status, politics_status, # migration_status, income_status, nation, gender, relationship, user_id, apartment_id, # age, status, phone utf_forms = bottle.request.forms.decode("utf-8") vdbm.insert(table='citizen_resident', **utf_forms)
def admin_user_partycard_update(partycard_id, db): vdbm = dbm.DbM(db) # 数据库字段名参考:partycard_id, relation, party_branch, position, type, status, join_date, confirm_date, # inspection_person, application_id, user_id utf_forms = bottle.request.forms.decode("utf-8") vdbm.update(table='partycard', condition=' where partycard_id=' + partycard_id, form_dict=utf_forms.dict)
def admin_user_role_update(user_role_id, db): role_id = bottle.request.forms.role_id role_description = bottle.request.forms.role_description user_role_description = bottle.request.forms.user_role_description description_detail = bottle.request.forms.description_detail role_type_id = bottle.request.forms.role_type_id vdbm = dbm.DbM(db) vdbm.update(table='role', condition=' where role_id=' + role_id, role_type_id=role_type_id, description=role_description) vdbm.update(table='user_role', condition=' where user_role_id=' + user_role_id, role_id=role_id, description=user_role_description, description_detail=description_detail)
def admin_user_update(userid, db): password = bottle.request.forms.password email = bottle.request.forms.email name = bottle.request.forms.name identity_number = bottle.request.forms.identity_number card_id = bottle.request.forms.card_id user_type_id = bottle.request.forms.user_type_id # image = bottle.request.files.get('image') # image.save('files') vdbm = dbm.DbM(db) vdbm.update(table='user', condition=' where user_id=' + userid, password=password, email=email, name=name, identity_number=identity_number, card_id=card_id, user_type_id=user_type_id, image='default.jpg')
def admin_user_partycard_add(db): vdbm = dbm.DbM(db) # 数据库字段名参考:partycard_id, relation, party_branch, position, type, status, join_date, confirm_date, # inspection_person, application_id, user_id utf_forms = bottle.request.forms.decode("utf-8") vdbm.insert(table='partycard', **utf_forms)
def admin_user_netcard_add(db): vdbm = dbm.DbM(db) # 数据库字段名参考:netcard_id, nickname, image, commuity_user_id, user_id utf_forms = bottle.request.forms.decode("utf-8") vdbm.insert(table='netcard', **utf_forms)
def admin_user_livingcard_add(db): vdbm = dbm.DbM(db) # 数据库字段名参考:livingcard_id, name, address, zip_code, house_number, user_id utf_forms = bottle.request.forms.decode("utf-8") vdbm.insert(table='livingcard', **utf_forms)
def admin_user_role_add(db): vdbm = dbm.DbM(db) utf_forms = bottle.request.forms.decode("utf-8") vdbm.insert(table='user_role', **utf_forms)