| | |
| | | try |
| | | { |
| | | bool res = false; |
| | | LogHelper.Info($"任务:{TN_Task.S_CODE}开始创建"); |
| | | db.BeginTran(); |
| | | res = db.Insertable(TN_Task).ExecuteCommand() > 0; |
| | | if (res) |
| | | if (res) |
| | | { |
| | | var Startmodel = db.Queryable<Location>().Where(a => a.S_CODE.Trim() == TN_Task.S_START_LOC).First(); |
| | | var Endmodel = db.Queryable<Location>().Where(a => a.S_CODE.Trim() == TN_Task.S_END_LOC).First(); |
| | |
| | | Startmodel.N_LOCK_STATE = 2; |
| | | Startmodel.S_LOCK_STATE = Location.GetLockStateStr(2); |
| | | res = db.Updateable(Startmodel).UpdateColumns(it => new { it.N_LOCK_STATE, it.S_LOCK_STATE }).ExecuteCommand() > 0; |
| | | } |
| | | else |
| | | { |
| | | LogHelper.Info($"任务:{TN_Task.S_CODE}生成失败,起点货位不可用"); |
| | | db.RollbackTran(); |
| | | return false; |
| | | } |
| | | if (Endmodel != null && Endmodel.S_LOCK_STATE.Trim() == "无") |
| | | { |
| | |
| | | LogHelper.Info($"任务:{TN_Task.S_CODE}生成失败"); |
| | | db.RollbackTran(); |
| | | } |
| | | return res; |
| | | return res; |
| | | } |
| | | catch (Exception ex) |
| | | { |