基于代理价管理的教材征订系统在理工大学的应用

CREATE TABLE textbook (

id INT PRIMARY KEY AUTO_INCREMENT,

title VARCHAR(255) NOT NULL,

isbn VARCHAR(20),

publisher VARCHAR(255)

);

CREATE TABLE agent_price (

id INT PRIMARY KEY AUTO_INCREMENT,

textbook_id INT,

agent_name VARCHAR(255),

price DECIMAL(10, 2),

discount DECIMAL(3, 2),

FOREIGN KEY (textbook_id) REFERENCES textbook(id)

);

]]>

def calculate_final_price(agent_price, quantity):

final_price = agent_price * quantity * (1 - agent_price.discount)

return round(final_price, 2)

]]>