| | |
| | | LocationHelper.LockLoc(task.S_END_LOC, "出库锁", 2); |
| | | } |
| | | |
| | | if (task.S_TYPE.Contains("出库")&&task.S_SCHEDULE_TYPE.Contains("agv") ) |
| | | { |
| | | var location = db.Queryable<Location>().Where(a => a.S_CODE == task.S_END_LOC).First(); |
| | | location.N_CURRENT_NUM = 0; |
| | | db.Updateable(location).UpdateColumns(it => new { it.N_CURRENT_NUM}).ExecuteCommand(); |
| | | db.Deleteable<Container>().Where(it => it.S_CODE == task.S_CNTR_CODE).ExecuteCommand(); |
| | | db.Deleteable<LocCntrRel>().Where(it => it.S_CNTR_CODE == task.S_CNTR_CODE).ExecuteCommand(); |
| | | db.Deleteable<CntrItemRel>().Where(it => it.S_CNTR_CODE == task.S_CNTR_CODE).ExecuteCommand(); |
| | | } |
| | | //if (task.S_TYPE.Contains("出库")&&task.S_SCHEDULE_TYPE.Contains("agv") ) |
| | | //{ |
| | | // var location = db.Queryable<Location>().Where(a => a.S_CODE == task.S_END_LOC).First(); |
| | | // location.N_CURRENT_NUM = 0; |
| | | // db.Updateable(location).UpdateColumns(it => new { it.N_CURRENT_NUM}).ExecuteCommand(); |
| | | // db.Deleteable<Container>().Where(it => it.S_CODE == task.S_CNTR_CODE).ExecuteCommand(); |
| | | // db.Deleteable<LocCntrRel>().Where(it => it.S_CNTR_CODE == task.S_CNTR_CODE).ExecuteCommand(); |
| | | // db.Deleteable<CntrItemRel>().Where(it => it.S_CNTR_CODE == task.S_CNTR_CODE).ExecuteCommand(); |
| | | //} |
| | | } |
| | | |
| | | |