check_dict.py
1.72 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
# -*- coding: utf-8 -*-
import pyodbc
conn_str = 'DRIVER={ODBC Driver 17 for SQL Server};SERVER=192.168.1.91,1433;DATABASE=wms4_global;UID=sa;PWD=HHrobot123.'
conn = pyodbc.connect(conn_str)
cursor = conn.cursor()
# 查看状态字典
print("=" * 80)
print("【入库单状态字典 receipt_status】")
print("=" * 80)
cursor.execute("""
SELECT di.item_text, di.item_value
FROM jimu_dict_item di
INNER JOIN jimu_dict d ON di.dict_id = d.id
WHERE d.dict_code = 'receipt_status'
ORDER BY CAST(di.item_value AS INT)
""")
for row in cursor.fetchall():
print(f" {row[1]} = {row[0]}")
print("\n" + "=" * 80)
print("【出库单状态字典 shipment_status】")
print("=" * 80)
cursor.execute("""
SELECT di.item_text, di.item_value
FROM jimu_dict_item di
INNER JOIN jimu_dict d ON di.dict_id = d.id
WHERE d.dict_code = 'shipment_status'
ORDER BY CAST(di.item_value AS INT)
""")
for row in cursor.fetchall():
print(f" {row[1]} = {row[0]}")
print("\n" + "=" * 80)
print("【组盘状态字典 container_status】")
print("=" * 80)
cursor.execute("""
SELECT di.item_text, di.item_value
FROM jimu_dict_item di
INNER JOIN jimu_dict d ON di.dict_id = d.id
WHERE d.dict_code = 'container_status'
ORDER BY CAST(di.item_value AS INT)
""")
for row in cursor.fetchall():
print(f" {row[1]} = {row[0]}")
# 查看入库类型字典
print("\n" + "=" * 80)
print("【入库单类型字典 receipt_type】")
print("=" * 80)
cursor.execute("""
SELECT di.item_text, di.item_value
FROM jimu_dict_item di
INNER JOIN jimu_dict d ON di.dict_id = d.id
WHERE d.dict_code = 'receipt_type'
ORDER BY di.sort_order
""")
for row in cursor.fetchall():
print(f" {row[1]} = {row[0]}")
conn.close()