async def upcustomersalemanid(ns): """ 更换客户 """ db = DBPools() async with db.sqlorContext('kboss') as sor: try: sql = """ UPDATE customer SET salemanid = ${salemanid}$ WHERE customerid = ${customerid}$ """ await sor.sqlExe(sql,ns) return {'status': True, 'meg': '更换成功'} except: return {'status': False, 'meg': '更换失败'} ret = await upcustomersalemanid(params_kw) return ret