物品资产统计软件开发代码

物品资产统计软件开发代码

以下是一个简单的物品资产统计软件的Python代码框架，使用Flask作为Web框架，SQLite作为数据库：

python

from flask import Flask, render_template, request, redirect, url_for, flash
from flask_sqlalchemy import SQLAlchemy
import os

app = Flask(__name__)
app.config['SECRET_KEY'] = 'your-secret-key'
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///inventory.db'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db = SQLAlchemy(app)

# 数据库模型
class Item(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(100), nullable=False)
    category = db.Column(db.String(50))
    quantity = db.Column(db.Integer, default=0)
    location = db.Column(db.String(100))
    purchase_date = db.Column(db.String(20))
    price = db.Column(db.Float)
    description = db.Column(db.Text)
    barcode = db.Column(db.String(50), unique=True)
    
    def __repr__(self):
        return f'<Item {self.name}>'

# 创建数据库表
@app.before_first_request
def create_tables():
    db.create_all()

# 路由
@app.route('/')
def index():
    items = Item.query.all()
    return render_template('index.html', items=items)

@app.route('/add', methods=['GET', 'POST'])
def add_item():
    if request.method == 'POST':
        name = request.form['name']
        category = request.form['category']
        quantity = int(request.form['quantity'])
        location = request.form['location']
        purchase_date = request.form['purchase_date']
        price = float(request.form['price'])
        description = request.form['description']
        barcode = request.form['barcode']