| | |
| | | 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(); |
| | | task.T_START_TIME = DateTime.Now; |
| | | db.Updateable(task).UpdateColumns(it => new { it.S_B_STATE,it.T_START_TIME }).ExecuteCommand(); |
| | | return res; |
| | | } |
| | | internal static bool UpdateStatus(WCSTask task) |
| | |
| | | internal static bool AddActionRecord(string no, int state, string forkliftNo, string extData) |
| | | { |
| | | var db = new SqlHelper<TaskAction>().GetInstance(); |
| | | |
| | | var action = new TaskAction() |
| | | { |
| | | N_ACTION_CODE = state, |
| | |
| | | task.S_B_STATE = WCSTask.GetStateStr(task.N_B_STATE); |
| | | task.T_START_TIME = DateTime.Now; |
| | | task.S_WORKSHOP_NO = agvno; |
| | | db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.T_START_TIME, it.S_WORKSHOP_NO }).ExecuteCommand(); |
| | | db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.S_WORKSHOP_NO }).ExecuteCommand(); |
| | | } |
| | | |
| | | } |