GongFuServer/webServer/src/model/OrderModel.ts

import { query } from '../sql/query'; // 确保路径是正确的

class OrderModel {
    //获取订单
    async getOrder(order_id: any) {
        return await query(`SELECT * FROM order WHERE order_id = '${order_id}'`)
    }

    //添加订单
    async createOrder(
        orderId: any,
        uid: any,
        level: any,
        amount: any,
        role_id: any,
        role_name: any,
        product_id: any,
        create_time: string
    ) {
        return await query(`INSERT INTO game_order(order_id, uid, level,amount,role_id,role_name,product_id,create_time) VALUES('${orderId}', '${uid}', '${level}', '${amount}', '${role_id}', '${role_name}','${product_id}', '${create_time}')`)
    }
}

module.exports = new OrderModel()