|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
物料选择
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
客户名称
|
Center
|
Center
Center
|
|
Center
|
|
Center
|
|
|
|
|
|
|
|
|
Center
|
|
Center
|
|
搜索
|
|
|
订货日期
|
Center
|
交货日期
|
|
Center
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
送货地址
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
说 明
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Center
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Center
|
|
|
|
|
|
|
序号
|
产品名称
|
金丝路米黄
|
|
|
|
|
|
|
|
|
|
|
|
|
Center
|
|
|
|
|
|
|
|
长
|
长加工方式
|
宽
|
宽加工方式
|
件数
|
出头
|
平方米
|
单价(材料)
|
金额(材料)
|
开槽方式
|
宽度
|
深度
|
|
|
Center
|
|
|
|
|
|
|
1
|
Center
|
Center
Center
|
4, 33, 11, 12, 4, 91, 12, 6Center
|
Center
Center
|
Center
|
|
0.480000
|
50.00
|
24.00
|
Center
Center
|
5.00
|
0.20
|
|
|
|
选择
|
|
|
|
|
|
Center
Center
|
Center
Center
|
|
Center
Center
|
7.00
|
0.30
|
|
|
|
|
|
|
|
|
|
2
|
Center
|
Center
Center
|
4, 33, 13, 12, 4, 91, 14, 6Center
|
Center
Center
|
Center
|
|
1.440000
|
50.00
|
72.00
|
Center
Center
|
5.00
|
0.40
|
|
|
勾选中物料后,点击选择,则物料跳进订单页面
|
|
Center
Center
|
Center
Center
|
|
Center
Center
|
|
|
|
|
|
|
|
|
|
|
|
|
|
总平方米
|
单价
|
金额
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
材料费小计:
|
1.920
|
50.00
|
96.00
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
加工方式
|
加工米数
|
单价
|
金额
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
边型加工费:
|
A方式
|
2.20
|
5.00
|
11.00
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
B方式
|
1.20
|
7.00
|
8.40
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
C方式
|
0.80
|
9.00
|
7.20
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
合计:
|
26.60
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
开槽方式
|
宽度
|
单价
|
金额
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
开槽加工费:
|
Ⅰ
|
10.00
|
30
|
300.00
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Ⅱ
|
7.00
|
20
|
140.00
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Center
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
序号
|
产品名称
|
南洋彩玉
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
长
|
长加工方式
|
宽
|
宽加工方式
|
件数
|
出头
|
平方米
|
单价(材料)
|
金额(材料)
|
开槽方式
|
宽度
|
深度
|
|
|
|
|
|
|
|
|
|
3
|
Center
|
Center
Center
|
4, 33, 31, 12, 4, 91, 32, 6Center
|
Center
Center
|
Center
|
|
0.480000
|
50.00
|
24.00
|
Center
Center
|
5.00
|
0.20
|
|
|
|
|
|
|
|
|
|
Center
Center
|
Center
Center
|
|
Center
Center
|
7.00
|
0.30
|
|
|
|
|
|
|
|
|
|
4
|
Center
|
Center
Center
Center
Center
|
4, 33, 33, 12, 4, 91, 34, 6Center
|
Center
Center
Center
Center
|
Center
|
|
1.440000
|
50.00
|
72.00
|
Center
Center
Center
Center
|
5.00
|
0.40
|
|
|
|
|
|
|
|
|
|
C
|
A
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
总平方米
|
单价
|
金额
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
材料费小计:
|
1.920
|
50.00
|
96.00
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
加工方式
|
加工米数
|
单价
|
金额
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
边型加工费:
|
A方式
|
2.20
|
5.00
|
11.00
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
B方式
|
1.20
|
7.00
|
8.40
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
C方式
|
0.80
|
9.00
|
7.20
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
合计:
|
26.60
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
开槽方式
|
宽度
|
单价
|
金额
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
开槽加工费:
|
Ⅰ
|
10.00
|
30
|
300.00
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Ⅱ
|
7.00
|
20
|
140.00
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
合计
|
440.00
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
材料费合计
|
A
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
加工费合计
|
B
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
订单总计
|
A+B
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Center
Center
|
|
查找选择对应方式,有选择内容则代表该边加工且计算加工的米数,边型加工费按加工方式分组自动合计出加工米数,
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
开槽方式一样,小计单价为手工输入,金额自动计算,小组合计,最下面显示所有加工费合计,材料费总计
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2、
|
长、宽、件数、出头、单价、宽度、深度、为手工录入,
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3、
|
计算公式
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
平方米计算公式=长*(宽+出头)*件数
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
材料金额=平方米*材料单价
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
小组总平方米=材料费合计保留三位小数点,单价为手工输入,金额=总平方*单价 小组合计。
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
小组边型加工费=按加工方式统计该方式的的米数,根据加工方式分组自动增加行。米数*单价=金额,单价为手动录入, 小组合计。
|
|
|
|
|
|
|
|
|
|
|
|
|
|
开槽加工费=宽度*单价,单价为录入,宽度按方式分组显示宽度。 小组合计。
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
加工费合计=所有加工费合计
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
材料费合计=单据所有材料费合计
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4、
|
设计模块
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
基础资料:产品资料、客户资料、人员资料、可树状分类。
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
销售单模块:销售单新增、修改、查询、打印。材料单价可根据客户产品记住历史价格(打印面版必须按上述界面内容显示,软件操作界不可实现可明细信息下拉操作)
|
|
|
|
|
|
|
|
|
|
|
单据查询:查询条件(条件字段:时间,客户,产品名称)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
报表:销售统计日月年销售金额(条件字段:时间,客户,产品名称)按加工方式统计加工费金额(条件字段:加工方式、时间,客户,产品名称)
|
|
|
|
|
|
|
|
|
|
|
|
|
按开槽方式方式统计加工费金额(条件字段:开槽方式、时间,客户,产品名称)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|