| | |
| | | using HH.WCS.JiaTong.util; |
| | | using HH.WCS.JiaTong_DCJ.util; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.IdentityModel.Protocols.WSTrust; |
| | |
| | | using System.Text; |
| | | using System.Threading.Tasks; |
| | | |
| | | namespace HH.WCS.JiaTong.wms |
| | | namespace HH.WCS.JiaTong_DCJ.wms |
| | | { |
| | | internal class WCSHelper |
| | | { |
| | |
| | | { |
| | | var res = false; |
| | | var db = new SqlHelper<WCSTask>().GetInstance(); |
| | | |
| | | |
| | | task.S_B_STATE = status; |
| | | |
| | | db.Updateable(task).UpdateColumns(it => new { it.S_B_STATE }).ExecuteCommand(); |
| | |
| | | if (task != null) |
| | | { |
| | | |
| | | |
| | | |
| | | task.T_START_TIME = DateTime.Now; |
| | | task.S_WORKSHOP_NO = agvno; |
| | | db.Updateable(task).UpdateColumns(it => new { it.T_START_TIME, it.S_WORKSHOP_NO }).ExecuteCommand(); |
| | |
| | | { |
| | | 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(); |
| | | if (Startmodel != null && Startmodel.S_LOCK_STATE.Trim() == "æ ") |
| | | if (Startmodel != null && (string.IsNullOrEmpty(Startmodel.S_LOCK_STATE) || Startmodel.S_LOCK_STATE.Trim() == "æ ")) |
| | | { |
| | | Startmodel.N_LOCK_STATE = 2; |
| | | Startmodel.S_LOCK_STATE = Location.GetLockStateStr(2); |
| | |
| | | db.RollbackTran(); |
| | | return false; |
| | | } |
| | | if (Endmodel != null && Endmodel.S_LOCK_STATE.Trim() == "æ ") |
| | | if (Endmodel != null && (string.IsNullOrEmpty(Endmodel.S_LOCK_STATE) || Endmodel.S_LOCK_STATE.Trim() == "æ ")) |
| | | { |
| | | Endmodel.N_LOCK_STATE = 1; |
| | | Endmodel.S_LOCK_STATE = Location.GetLockStateStr(1); |