| | |
|---|
| | | 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) { |
|---|
| | |
|---|
| | | return TN_Task; |
|---|
| | | } |
|---|
| | | |
|---|
| | | public static TN_Task BuildErpTask(TN_Location startLoc, TN_Location endLoc, string cntId, string type, string erpNo) { |
|---|
| | | 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 = startLoc.S_AREA_CODE, |
|---|
| | |
|---|
| | | N_SCHEDULE_TYPE = 1, // NDC |
|---|
| | | N_B_STATE = 0, |
|---|
| | | S_CNTR_CODE = cntId, |
|---|
| | | S_BS_NO = erpNo, |
|---|
| | | S_BS_TYPE = "ERP", |
|---|
| | | 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) { |
|---|
