ID_, DATA_TYPE_, WAREHOUSE_, INOUT_DATE_, SOURCE_, DESCRIPTON_, APPLICANT_, ORG_, APPROVER_, APPROVED_DATE_, SN_, MEMO_, IS_DELE_, CREATE_BY_, CREATE_ORG_ID_, CREATE_TIME_, UPDATE_BY_, UPDATE_TIME_, VERSION_, LAST_TIME_ update cmgt_material_quantity i,cmgt_material_warehouse_inout_detail w set i.QUANTITY_ = (i.QUANTITY_ + w.QUANTITY_) where i.ID_ = w.QUANTITY_ID_ and w.WAREHOUSE_INOUT_ID_ = #{wid} and w.IS_DELE_ = '0' and i.IS_DELE_='0'; update cmgt_material_quantity i,cmgt_material_warehouse_inout_detail d,cmgt_material_warehouse_inout w set i.QUANTITY_ = (i.QUANTITY_ - d.QUANTITY_) where i.MATERIAL_ID_ = d.MATERIAL_INFO_ID_ and w.ID_ = d.WAREHOUSE_INOUT_ID_ and i.ID_ = d.QUANTITY_ID_ and i.warehouse_ = #{warehouse} and w.warehouse_ = #{warehouse} and d.WAREHOUSE_INOUT_ID_ = #{wid} and d.IS_DELE_ = '0' and i.IS_DELE_='0'; select (i.QUANTITY_ + w.QUANTITY_ - #{nowNum}) from cmgt_material_quantity i,cmgt_material_warehouse_inout_detail w where i.ID_ = w.QUANTITY_ID_ and i.ID_ = #{qid} and w.WAREHOUSE_INOUT_ID_ = #{wid} and w.IS_DELE_ = '0' and i.IS_DELE_='0';