From cbe19ea6066a600cbd0b5110db5d43f8252d14a8 Mon Sep 17 00:00:00 2001
From: Administrator <admin@example.com>
Date: 星期四, 13 六月 2024 11:23:53 +0800
Subject: [PATCH] L撤成交进度相关改进
---
code_attribute/gpcode_manager.py | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/code_attribute/gpcode_manager.py b/code_attribute/gpcode_manager.py
index c09906c..3776155 100644
--- a/code_attribute/gpcode_manager.py
+++ b/code_attribute/gpcode_manager.py
@@ -36,7 +36,7 @@
def get_code_name(cls, code):
if code in cls.__code_name_dict:
return cls.__code_name_dict[code]
- fresults = cls.__mysqldb.select_one(f"select code_name from code_name where code = {code}")
+ fresults = cls.__mysqldb.select_one(f"select code_name from code_name where code = '{code}'")
if fresults:
cls.__code_name_dict[code] = fresults[0]
return fresults[0]
@@ -45,11 +45,11 @@
@classmethod
def add_code_name(cls, code, name):
cls.__code_name_dict[code] = name
- fresults = cls.__mysqldb.select_one(f"select code_name from code_name where code = {code}")
+ fresults = cls.__mysqldb.select_one(f"select code_name from code_name where code = '{code}'")
if fresults:
- cls.__mysqldb.execute(f"update code_name set code_name ='{name}', update_time = now() where code= {code}")
+ cls.__mysqldb.execute(f"update code_name set code_name ='{name}', update_time = now() where code= '{code}'")
else:
- cls.__mysqldb.execute(f"insert into code_name(code,code_name,update_time ) values({code},'{name}',now())")
+ cls.__mysqldb.execute(f"insert into code_name(code,code_name,update_time ) values('{code}','{name}',now())")
@classmethod
def add_first_code_name(cls, code, name):
--
Gitblit v1.8.0