| | |
| | | var db = new SqlHelper<TN_Task>().GetInstance(); |
| | | task.S_B_STATE = TN_Task.GetStateStr(task.N_B_STATE); |
| | | task.T_MODIFY = DateTime.Now; |
| | | db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.T_MODIFY }).ExecuteCommand(); |
| | | res = db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.T_MODIFY }).ExecuteCommand() > 0; |
| | | return res; |
| | | } |
| | | internal static bool UpdateEQNo(TN_Task task) { |
| | |
| | | S_END_LOC = endLoc.S_CODE, |
| | | S_TYPE = type, |
| | | N_PRIORITY = 3, // 初始优先级默认为:3 |
| | | N_SCHEDULE_TYPE = 3, // 国自 |
| | | N_SCHEDULE_TYPE = 1, // NDC |
| | | N_B_STATE = 0, |
| | | S_CNTR_CODE = cntId, |
| | | }; |
| | |
| | | return TN_Task; |
| | | } |
| | | |
| | | public static TN_Task BuildTask(TN_Loc_Container locCntrRel, TN_Location endLoc, string cntId, string type) { |
| | | var fromLoc = LocationHelper.GetLocation(locCntrRel.S_LOC_CODE); |
| | | |
| | | public static TN_Task BuildTask(TN_Location startLoc, TN_Location endLoc, string cntId, string type, string op_no, string erp_no = "") { |
| | | TN_Task TN_Task = new TN_Task() { |
| | | S_CODE = GenerateTaskNo(), |
| | | S_START_AREA = fromLoc.S_AREA_CODE, |
| | | S_START_AREA = startLoc.S_AREA_CODE, |
| | | S_END_AREA = endLoc.S_AREA_CODE, |
| | | S_START_LOC = fromLoc.S_CODE, |
| | | S_START_LOC = startLoc.S_CODE, |
| | | S_END_LOC = endLoc.S_CODE, |
| | | S_TYPE = type, |
| | | N_PRIORITY = 3, // 初始优先级默认为:3 |
| | | N_SCHEDULE_TYPE = 3, // 国自 |
| | | N_SCHEDULE_TYPE = 1, // NDC |
| | | N_B_STATE = 0, |
| | | S_CNTR_CODE = cntId, |
| | | S_OP_CODE = op_no, |
| | | S_BS_NO = erp_no, |
| | | S_BS_TYPE = erp_no == "" ? "" : "ERP", |
| | | }; |
| | | |
| | | return TN_Task; |
| | |
| | | /// <summary> |
| | | /// 创建搬送任务 |
| | | /// </summary> |
| | | /// <param name="no">编号</param> |
| | | /// <param name="from">起点</param> |
| | | /// <param name="to">终点</param> |
| | | /// <param name="taskType">任务类型</param> |
| | |
| | | internal static void Begin(TN_Task task, string forklift_no) { |
| | | var db = new SqlHelper<TN_Task>().GetInstance(); |
| | | if (task != null) { |
| | | if (task.N_B_STATE == 1) { |
| | | if (task.N_B_STATE == 1 || task.N_B_STATE == 0) { // 添加当task状态为0时也可以触发 |
| | | task.N_B_STATE = 2; |
| | | task.S_B_STATE = TN_Task.GetStateStr(task.N_B_STATE); |
| | | task.T_START_TIME = System.DateTime.Now; |
| | | task.S_EQ_NO = forklift_no; |
| | | db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.T_START_TIME, it.S_EQ_NO }).ExecuteCommand(); |
| | | } |
| | | |
| | | } |
| | | } |
| | | internal static void End(TN_Task task) { |