select b_no, b_type, b_product_id,b_proj,b_quantity, b_place_order_peo, b_submit_time, b_stock_id, b_arrival_time, b_integration_leader, b_reviewer, b_review_time from proj_materials_main
and b_no = #{bNo}
and b_type = #{bType}
and b_product_id = #{bProductId}
and b_quantity = #{bQuantity}
and b_place_order_peo = #{bPlaceOrderPeo}
and b_submit_time = #{bSubmitTime}
and b_stock_id = #{bStockId}
and b_arrival_time = #{bArrivalTime}
and b_integration_leader = #{bIntegrationLeader}
and b_reviewer = #{bReviewer}
and b_review_time = #{bReviewTime}
and b_proj = #{bProj}
insert into proj_materials_main
b_no,
b_type,
b_product_id,
b_quantity,
b_place_order_peo,
b_submit_time,
b_stock_id,
b_arrival_time,
b_integration_leader,
b_reviewer,
b_review_time,
b_proj,
#{bNo},
#{bType},
#{bProductId},
#{bQuantity},
#{bPlaceOrderPeo},
#{bSubmitTime},
#{bStockId},
#{bArrivalTime},
#{bIntegrationLeader},
#{bReviewer},
#{bReviewTime},
#{bProj},
update proj_materials_main
b_type = #{bType},
b_product_id = #{bProductId},
b_quantity = #{bQuantity},
b_place_order_peo = #{bPlaceOrderPeo},
b_submit_time = #{bSubmitTime},
b_stock_id = #{bStockId},
b_arrival_time = #{bArrivalTime},
b_integration_leader = #{bIntegrationLeader},
b_reviewer = #{bReviewer},
b_review_time = #{bReviewTime},
b_proj = #{bProj},
where b_no = #{bNo}
delete from proj_materials_main where b_no = #{bNo}
delete from proj_materials_main where b_no in
#{bNo}
delete from proj_materials_bill where p_no in
#{pNo}
delete from proj_materials_bill where p_no = #{pNo}
insert into proj_materials_bill( b_no, b_pro_id, b_type, material_code, material_name, material_model, quantity, unit, total, manufacturer, arrival_state, submit_time, arrival_time, place_order_peo, signed_by, remark, description, p_no) values
( #{item.bNo}, #{item.bProId}, #{item.bType}, #{item.materialCode}, #{item.materialName}, #{item.materialModel}, #{item.quantity}, #{item.unit}, #{item.total}, #{item.manufacturer}, #{item.arrivalState}, #{item.submitTime}, #{item.arrivalTime}, #{item.placeOrderPeo}, #{item.signedBy}, #{item.remark}, #{item.description}, #{item.pNo})