def get_user_count(self):
sql = "select * from user_info"
querys = db_manager.sqlserver().execute_query(sql)
if (len(querys) >= 5):
self.out = '业务办理失败，此用户在全国范围内办理号码已经超过了5个！'
else:
self.out = '审核通过！'
def get_user_count():
order_id = self.in_param
sql = "select * from user_info where id = "+ order_id +""
querys = db_manager.sqlserver().execute_query(sql)
for x in querys:
print x
if(len(querys) >= 5):
self.out_param = '业务办理失败，此用户在全国范围内办理号码已经超过了5个！'
else:
self.out_param = '审核通过！'
def query_test(self):
sql = "select * from user_info"
querys = db_manager.sqlserver().execute_query(sql)
for row in querys:
print(row)
def update_test(self):
sql = "update user_info set user_name = 'aaaa' where user_name = '6666'"
db_manager.sqlserver().execute_update(sql)
def delete_test(self):
sql = "delete from user_info where id='4'"
db_manager.sqlserver().execute_update(sql)
def insert_test(self):
sql = "insert into user_info(user_name,user_pwd) values('ssss','ssssbb')"
db_manager.sqlserver().execute_update(sql)