| | |
| | | public static void CheckInbound() { |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | var info = ""; |
| | | |
| | | |
| | | try { |
| | | // 查产线是否有物料信息 |
| | | foreach (var prod in Settings.ProductionLines) { |
| | |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | var info = ""; |
| | | |
| | | const string taskName = TaskName.C成品胶出库; |
| | | var taskInfo = Settings.GetTaskInfo(ETask.C成品胶出库); |
| | | var taskName = taskInfo.TaskName; |
| | | |
| | | try { |
| | | var orderList = db.Queryable<TN_Outbound_Order>() |
| | |
| | | |
| | | } |
| | | |
| | | |
| | | //// BEG 查找6个月以前的任务表和任务动作表 |
| | | //var oldTaskList = db.Queryable<TN_Task>() |
| | | // .Where(t => t.T_MODIFY < DateTime.Now.AddMonths(-6)) |
| | | // .Where(t => t.N_B_STATE == 3 && t.S_B_STATE == "完成") |
| | | // .ToList(); |
| | | |
| | | //var oldTaskActionList = db.Queryable<TN_Task, TN_Task_Action>((t, a) => t.S_CODE == a.S_TASK_CODE) |
| | | // .Where(t => t.T_MODIFY < DateTime.Now.AddMonths(-6)) |
| | | // .Where(t => t.N_B_STATE == 3 && t.S_B_STATE == "完成") |
| | | // .Select((t, a) => a) |
| | | // .ToList(); |
| | | //// END |
| | | |
| | | //using (var tran = db.Ado.UseTran()) { |
| | | // // 在出库轮询中处理,查找任务单是否有半年前且已经完成的任务,如果有则删除 |
| | | // // 这个操作不影响正常流程,如果失败也不需要回滚 |
| | | // //if (db.Deleteable<TN_Task>() |
| | | // // .Where(t => t.T_MODIFY < DateTime.Now.AddMonths(-6)) |
| | | // // .Where(t => t.N_B_STATE == 3 && t.S_B_STATE == "完成") |
| | | // // .ExecuteCommand() <= 0) { |
| | | // // info = $"轮询{taskName}单时尝试删除半年前的任务失败"; |
| | | // // LogHelper.Info(info); |
| | | // //} |
| | | // if (db.Deleteable<TN_Task>(oldTaskList).ExecuteCommand() <= 0 |
| | | // && db.Deleteable<TN_Task_Action>(oldTaskActionList).ExecuteCommand() <= 0) { |
| | | // info = $"轮询{taskName}单时尝试删除半年前的任务失败"; |
| | | // LogHelper.Info(info); |
| | | // } |
| | | //} |
| | | |
| | | } |
| | | catch (Exception ex) { |
| | | info = $"轮询:{taskName}:发生了异常:{ex.Message}"; |
| | |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | var info = ""; |
| | | |
| | | const string taskName = TaskName.C抽检_出库; |
| | | var taskInfo = Settings.GetTaskInfo(ETask.C抽检出库); |
| | | var taskName = taskInfo.TaskName; |
| | | |
| | | try { |
| | | var orderList = db.Queryable<TN_Spot_Check>() |
| | |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | var info = ""; |
| | | |
| | | const string taskName = TaskName.Y移库; |
| | | var taskInfo = Settings.GetTaskInfo(ETask.Y移库); |
| | | var taskName = taskInfo.TaskName; |
| | | |
| | | try { |
| | | var orderList = db.Queryable<TN_Relocation_List>() |