def get_column_value(db_table_name, condition_column_name, condition_column_value, select_column_name): select_column_value = MySqlOperate().get_one_column_value( db_table_name, condition_column_name, condition_column_value, select_column_name) print("select_column_value:", select_column_value) return select_column_value
def get_partner_taskid(reportno): # 获取案件在系统中的taskid taskid = get_task_id(reportno) sql = "SELECT task_id FROM zbcf_partner_test.t_partner_operate_record WHERE task_id like '%s%%' and provider !='共享公司' order by id desc LIMIT 1" % taskid workid = MySqlOperate().mysql_execute(sql) print("获取partner服务的内部workid为", workid) return workid
def get_task_id(report_no): task_id_value = MySqlOperate().get_one_column_value( 'zbcf_business_test.t_cs_task_info', 'case_no', report_no, 'id') try: if task_id_value: print("task_id_value:", task_id_value) return task_id_value except Exception as e: print("无订单可以销案!", e)
def get_user_id(login_name): # user_id_value = MySqlOperate().get_one_encryption_column_value('zbcf_business_test.t_us_login', 'mobile', mobile, 'id') user_id_value = MySqlOperate().get_one_column_value( 'zbcf_business_test.t_us_login', 'login_name', login_name, 'id') try: if user_id_value: print("user_id_value:", user_id_value) return str(user_id_value) except Exception as e: print("兼业人员接单失败,中台无订单!", e)
def get_order_status(report_no): order_status = MySqlOperate().get_one_column_value( 'zbcf_business_test.t_od_order', 'case_no', report_no, 'order_status') # print('status:', order_status) return order_status
def get_car_model_id(report_no): car_model_id_value = MySqlOperate().get_one_column_value( 'zbcf_business_test.t_wk_car_model', 'case_no', report_no, 'id') print("id:", car_model_id_value) return car_model_id_value
def get_work_id(order_no): work_id_value = MySqlOperate().get_one_column_value( 'zbcf_business_test.t_wk_parttime_survey', 'order_no', order_no, 'id') print("id:", work_id_value) return work_id_value
def get_company_id(report_no): company_id_value = MySqlOperate().get_one_column_value( 'db_zbcf_casecenter_test.t_report_info', 'report_no', report_no, 'company_id') print("company_id:", company_id_value) return company_id_value
def get_confirm(order_no): confirm_value = MySqlOperate().get_one_column_value( 'zbcf_business_test.t_wk_parttime_survey', 'order_no', order_no, 'confirm') print("confirm_value:", confirm_value) return confirm_value
def get_order_no(report_no): order_no_value = MySqlOperate().get_one_column_value( 'zbcf_business_test.t_od_order', 'case_no', report_no, 'order_no') # print("order_no_value:", order_no_value) return order_no_value
def get_company_id_value(company_name): company_id_value = MySqlOperate().get_one_column_value( 'zbcf_business_test.t_us_company_info', 'company_name', company_name, 'id') return company_id_value
def get_member_id(mobile): memberid = MySqlOperate().get_one_encryption_column_value( 'zbcf_business_test.t_us_member_info', 'mobile', mobile, 'id') return memberid