56,912
社区成员




mysql> select * from gygbj3;
+---------+--------------+--------------+--------------+----------+------+------+------------+-------+--------+--------+------+
| 代码 | 大类 | 中类 | 小类 | 名称 | 单位 | 数量 | 规格及材质 | 单重 | 单价 | 制造商 | 备注 |
+---------+--------------+--------------+--------------+----------+------+------+------------+-------+--------+--------+------+
| 1020100 | 电炉主体设备 | 电极升降系统 | 电极升降系统 | 上把持筒 | 套 | 3.0 | Q235B | 3.215 | 0.9500 | jz | |
+---------+--------------+--------------+--------------+----------+------+------+------------+-------+--------+--------+------+
1 row in set (0.00 sec)
mysql> select * from gygbjsl;
+---------+------+
| 代码 | 数量 |
+---------+------+
| 1020100 | 3.0 |
+---------+------+
1 row in set (0.00 sec)
mysql> select * from v_bj;
+---------+--------------+--------------+--------------+----------+-------+--------+------+-------+----------+
| 代码 | 大类 | 中类 | 小类 | 名称 | 单重 | 单价 | 数量 | 重量 | 金额小计 |
+---------+--------------+--------------+--------------+----------+-------+--------+------+-------+----------+
| 1020100 | 电炉主体设备 | 电极升降系统 | 电极升降系统 | 上把持筒 | 3.215 | 0.9500 | 3.0 | 9.645 | 9.1627 |
+---------+--------------+--------------+--------------+----------+-------+--------+------+-------+----------+
1 row in set (0.01 sec)
mysql>