| | |
| | | db.Updateable<TN_InventoryM>(targetInM).UpdateColumns(it => new { it.EXPIRATION_DAY }).ExecuteCommand(); |
| | | } |
| | | |
| | | var targetInM_De = db.Queryable<TN_InventoryM>().LeftJoin<TN_Task>((o, i) => o.RFID == i.S_CNTR_CODE). |
| | | Where((o, i) => i.N_B_STATE == 4 || i.S_B_STATE == "错误").ToList();//错误的任务删除对应的库存信息 |
| | | if (targetInM_De.Count>0) |
| | | { |
| | | db.Deleteable<TN_InventoryM>(targetInM_De).ExecuteCommand(); |
| | | } |
| | | |
| | | // 同步 TN_DayProDetail |
| | | var curDay = System.DateTime.Now.Date; |
| | | var targetEPDs = db.Queryable<TN_EquipProDetail>().Where(a => a.DOWNLINETIME >= curDay && a.DOWNLINETIME <= curDay.AddDays(1)).ToList(); |