Python信息系統(tǒng)實驗：倉庫管理

這是給物流管理專業(yè)設(shè)計的倉庫信息管理實驗。盡量采用基本的方式組織數(shù)據(jù)、模塊與實驗。同時體現(xiàn)Browser-Application Server-Database 的三層邏輯。

實驗要求

軟件

• 開發(fā)工具：Python+ Flask+HTML
• 數(shù)據(jù)庫：SQLite
• 架構(gòu)：三層架構(gòu)（Browser+Application Servier+Database）

倉庫管理實驗

模擬一個簡單的倉庫的以下基本管理過程：

• 1）庫位查詢：查詢庫位編碼及其容量
• 2）增加庫位
• 3）刪除庫位
• 4）入庫：商品編碼、庫位
• 5）出庫：商品編碼
• 6）商品庫位查詢：根據(jù)商品編碼找?guī)煳?/li>
• 7）庫位統(tǒng)計

數(shù)據(jù)庫表格

• StorageUnit: scode text, ssize int;
• Storage: scode text, ccode text, cname text, status text (=in, out)

Web Flask

關(guān)于Flask請參考前文。Flask可以做很復(fù)雜的應(yīng)用，但是本文僅僅利用其最簡單的能力完成幾個頁面和功能之間的切換。

幾分鐘做個Web應(yīng)用

from flask import Flask
from flask import session, redirect, url_for, request
from flask import render_template

數(shù)據(jù)訪問接口

關(guān)于數(shù)據(jù)庫及其訪問接口，請參考前文。

Python數(shù)據(jù)庫

from Data import Data

導(dǎo)航

采用三組菜單導(dǎo)航

• 基本功能組：主頁index、關(guān)于about、登錄login
• 對存儲單元的操縱，主要是列表顯示StorageUnitList、增加StorageUnitAdd和刪除StorageUnitDelete
• 對存儲記錄的操縱，主要是列表顯示StorageList、增加StorageAdd和刪除StorageDelete
• 對于Add和Delete這兩類Action，生成表單Form和執(zhí)行更新分開來，，例如StorageAdd生成Form，而StorageAddExe執(zhí)行
• 在login，StorageUnitAddExe，StorageUnitDeleteExe，StorageAddExe，StorageDeleteExe中，通過session或request操縱交互數(shù)據(jù)。

app = Flask(__name__)

@app.route('/')
def index():
    if 'username' in session:
        return redirect(url_for('StorageUnitList'))
    else:
        return redirect(url_for('login'))

@app.route('/about')
def about():
    return render_template('about.html', name='Flask')

@app.route('/login', methods=['GET', 'POST'])
def login():
    if request.method == 'POST':
        u = request.form['username']
        if u is None or len(u)==0:
            return redirect(url_for('login'))
        session['username'] = u
        return redirect(url_for('StorageUnitList'))
    return '''
        <center>
        Warehouse management<br><br>
        <table border=1>
        <form action="" method="post">
            <tr>
            <td>user name</td>
            <td><input type=text name=username></td>
            </tr>
            <tr>
            <td></td>
            <td><input type=submit value=Login></td>
            </tr>
        </form>
        </table>
        </center>
    '''

@app.route('/StorageUnitList')
def StorageUnitList():
    db = Data()
    db.createDatabase()
    d = db.selectStorageUnit()
    return render_template('StorageUnitList.html', data=d)

@app.route('/StorageUnitAdd', methods=['GET', 'POST'])
def StorageUnitAdd():
    return '''
        <center>
        Warehouse management --> add a Storage Unit<br><br>
        <table border=1>
        <form action="StorageUnitAddExe" method="post">
            <tr>
                <td>code</td>
                <td><input type=text name=scode></td>
            </tr>
            <tr>
                <td>size</td>
                <td><input type=text name=ssize></td>
            </tr>
            <tr>
                <td></td>
                <td><input type=submit value=OK></td>
            </tr>
        </form>
        </table>
        </center>
    '''

@app.route('/StorageUnitAddExe', methods=['GET', 'POST'])
def StorageUnitAddExe():
    scode = request.form['scode']
    ssize = request.form['ssize']
    if scode is not None and len(scode)>0 and \
        ssize is not None and len(ssize)>0:
        db = Data()
        db.createDatabase()
        db.insertStorageUnit(scode,ssize);
    return redirect(url_for('StorageUnitList'))

@app.route('/StorageUnitDelete', methods=['GET', 'POST'])
def StorageUnitDelete():
    return '''
        <center>
        Warehouse management --> delete a Storage Unit<br><br>
        <table border=1>
        <form action="StorageUnitDeleteExe" method="post">
            <tr>
                <td>code</td>
                <td><input type=text name=scode></td>
            </tr>
            <tr>
                <td></td>
                <td><input type=submit value=OK></td>
            </tr>
        </form>
        </table>
        </center>
    '''

@app.route('/StorageUnitDeleteExe', methods=['GET', 'POST'])
def StorageUnitDeleteExe():
    scode = request.form['scode']
    if scode is not None and len(scode)>0:
        db = Data()
        db.createDatabase()
        db.deleteStorageUnit(scode);
    return redirect(url_for('StorageUnitList'))



@app.route('/StorageList')
def StorageList():
    db = Data()
    db.createDatabase()
    d = db.selectStorage()
    return render_template('StorageList.html', data=d)

@app.route('/StorageAdd', methods=['GET', 'POST'])
def StorageAdd():
    return '''
        <center>
        Warehouse management --> add a Storage<br><br>
        <table border=1>
        <form action="StorageAddExe" method="post">
            <tr>
                <td>storage unit code </td>
                <td><input type=text name=scode></td>
            </tr>
            <tr>
                <td>goods code </td>
                <td><input type=text name=ccode></td>
            </tr>
            <tr>
                <td>goods name </td>
                <td><input type=text name=cname></td>
            </tr>
            <tr>
                <td>status </td>
                <td><input type=text name=status></td>
            </tr>
            <tr>
                <td></td>
                <td><input type=submit value=OK></td>
            </tr>
        </form>
        </table>
        </center>
    '''

@app.route('/StorageAddExe', methods=['GET', 'POST'])
def StorageAddExe():
    scode = request.form['scode']
    ccode = request.form['ccode']
    cname = request.form['cname']
    status = request.form['status']
    if scode is not None and len(scode)>0 and ccode is not None and \
        len(ccode)>0 and cname is not None and \
        len(cname)>0 and status is not None and len(status)>0:
        db = Data()
        db.createDatabase()
        if len(db.selectStorageUnitBy(scode))>0:
            db.insertStorage(scode,ccode,cname,status);
    return redirect(url_for('StorageList'))

@app.route('/StorageDelete', methods=['GET', 'POST'])
def StorageDelete():
    return '''
        <center>
        Warehouse management --> delete a Storage Unit<br><br>
        <table border=1>
        <form action="StorageDeleteExe" method="post">
            <tr>
                <td>storage unit code</td>
                <td><input type=text name=scode></td>
            </tr>
            <tr>
                <td>goods code</td>
                <td><input type=text name=ccode></td>
            </tr>
            <tr>
                <td></td>
                <td><input type=submit value=OK></td>
            </tr>
        </form>
        </table>
        </center>
    '''

@app.route('/StorageDeleteExe', methods=['GET', 'POST'])
def StorageDeleteExe():
    scode = request.form['scode']
    ccode = request.form['ccode']
    if scode is not None and len(scode)>0 and \
        ccode is not None and len(ccode)>0:
        db = Data()
        db.createDatabase()
        db.deleteStorage(scode, ccode);
    return redirect(url_for('StorageList'))

# set the secret key:
app.secret_key = 'A0Zr98j/3yX R~XHH!jmN]LWX/,?RT**^4'

if __name__ == '__main__':
    app.run()

# Flask:
# http://docs.jinkan.org/docs/flask/index.html
# Template:
# http://docs.jinkan.org/docs/jinja2/

Web頁面

• 如上代碼所隱含，使用了一個靜態(tài)文件，即about.html；
• 使用了兩個模板文件，用于生成檢索數(shù)據(jù)庫表生成的列表，即StorageList.html和StorageUnitList.html；
• 注意在login，StorageUnitAdd，StorageUnitDelete，StorageAdd，StorageDelete中都生成了Form，這些內(nèi)容是在瀏覽器前端顯示的。

about.html

<html>
<body>
<center>
Warehouse management: this is just a test application for demonstrating logistics information systems.<br>
<br>
<table border=1>
<tr>
    <td colspan=4>Menu</td>
</tr>
<tr>
    <td>Storage Unit</td>
    <td>[<a href='/StorageUnitList'>list</a>]</td>
    <td>[<a href='/StorageUnitAdd'>add</a>]</td>
    <td>[<a href='/StorageUnitDelete'>delete</a>]</td>
</tr>
<tr>
    <td>Storage</td>
    <td>[<a href='/StorageList'>list</a>]</td>
    <td>[<a href='/StorageAdd'>add</a>]</td>
    <td>[<a href='/StorageDelete'>delete</a>]</td>
</tr>
<tr>
    <td>System</td>
    <td>[<a href='about'>about</a>]</td>
    <td>[<a href='login'>login</a>]</td>
    <td>[<a href='/'>index</a>]</td>
</tr>
<table>
</center>
</body>
</html>

StorageList.html

<html>
<body>
<center>
Warehouse management -> Storage<br>
<br>
<table border=1>
<tr>
    <td colspan=4>Menu</td>
</tr>
<tr>
    <td>Storage Unit</td>
    <td>[<a href='/StorageUnitList'>list</a>]</td>
    <td>[<a href='/StorageUnitAdd'>add</a>]</td>
    <td>[<a href='/StorageUnitDelete'>delete</a>]</td>
</tr>
<tr>
    <td>Storage</td>
    <td>[<a href='/StorageList'>list</a>]</td>
    <td>[<a href='/StorageAdd'>add</a>]</td>
    <td>[<a href='/StorageDelete'>delete</a>]</td>
</tr>
<tr>
    <td>System</td>
    <td>[<a href='about'>about</a>]</td>
    <td>[<a href='login'>login</a>]</td>
    <td>[<a href='/'>index</a>]</td>
</tr>
<table>

<br>
<table border=1>
<tr>
    <td>Storage Unit Code</td>
    <td>Goods Code</td>
    <td>Goods Name</td>
    <td>Status</td>
<tr>
{% for a in data %}
    <tr>
      <td>{{ a[0] }}</td>
      <td>{{ a[1] }}</td>
      <td>{{ a[2] }}</td>
      <td>{{ a[3] }}</td>
    </tr>
{% endfor %}
<table>
</center>
</body>
</html>

StorageUnitList.html

<html>
<body>
<center>
Warehouse management -> Storage Units<br>
<br>
<table border=1>
<tr>
    <td colspan=4>Menu</td>
</tr>
<tr>
    <td>Storage Unit</td>
    <td>[<a href='/StorageUnitList'>list</a>]</td>
    <td>[<a href='/StorageUnitAdd'>add</a>]</td>
    <td>[<a href='/StorageUnitDelete'>delete</a>]</td>
</tr>
<tr>
    <td>Storage</td>
    <td>[<a href='/StorageList'>list</a>]</td>
    <td>[<a href='/StorageAdd'>add</a>]</td>
    <td>[<a href='/StorageDelete'>delete</a>]</td>
</tr>
<tr>
    <td>System</td>
    <td>[<a href='about'>about</a>]</td>
    <td>[<a href='login'>login</a>]</td>
    <td>[<a href='/'>index</a>]</td>
</tr>
<table>

<br>
<table border=1>
<tr><td>Code</td><td>Size</td><tr>
{% for a in data %}
    <tr>
        <td>{{ a[0] }}</td>
        <td>{{ a[1] }}</td>
    </tr>
{% endfor %}
<table>
</center>
</body>
</html>

測試

在Anaconda Spyder中執(zhí)行index.py，得到：

 * Serving Flask app "index" (lazy loading)
 * Environment: production
   WARNING: This is a development server. Do not use it in a production deployment.
   Use a production WSGI server instead.
 * Debug mode: off
 * Running on http://127.0.0.1:5000/ (Press CTRL+C to quit)

在瀏覽器輸入以下網(wǎng)址測試: http://127.0.0.1:5000/

Login

Storage Unit: List

Storage Unit: Add

Storage Unit: Delete

Storage: List

Storage: Add

Storage: Delete

私信小編01 領(lǐng)取完整代碼