import {
|
deleteData,
|
insert,
|
query,
|
update
|
} from "../common/sqlite";
|
|
|
export default {
|
async saveOrderMaterials(orderNo, materials) {
|
try {
|
for (var i = 0; i < materials.length; i++) {
|
|
const result = await query('select * from order_materials where orderNo = ? and material_name = ?',
|
[orderNo,
|
materials[i].name
|
]);
|
|
if (result.length === 0) {
|
await insert('order_materials', {
|
orderNo: orderNo,
|
material_name: materials[i].name,
|
tab_order: i + 1
|
});
|
}
|
}
|
} catch (e) {
|
console.error('订单物料关系添加错误', e);
|
throw new Error('订单物料关系添加错误' + e)
|
}
|
},
|
|
async updateMatOrder(orderNo, materials) {
|
try {
|
for (var i = 0; i < materials.length; i++) {
|
|
const result = await query('select * from order_materials where orderNo = ? and material_name = ?',
|
[orderNo,
|
materials[i].name
|
]);
|
|
if (result.length === 1) {
|
await update('order_materials', {
|
tab_order: i + 1
|
}, ' orderNo = ? and material_name = ? ', [orderNo,
|
materials[i].name
|
]);
|
}
|
}
|
} catch (e) {
|
console.error('订单物料排序修改错误', e);
|
throw new Error('订单物料排序修改错误' + e)
|
}
|
},
|
|
async deleteOrderMat(orderNo, matName) {
|
try {
|
await deleteData('order_materials', ' orderNo = ? and material_name = ? ', [orderNo, matName])
|
} catch (e) {
|
console.error('订单物料删除错误', e);
|
throw new Error('订单物料删除错误' + e)
|
}
|
},
|
|
async getMaterials(orderNo) {
|
try {
|
const materials = await query('select * from order_materials where orderNo = ? order by tab_order', [
|
orderNo
|
]);
|
return materials;
|
} catch (e) {
|
console.error('物料查询错误', e)
|
}
|
}
|
}
|
