| | |
| | | SPEC = outTimeCg.S_SPE, |
| | | CARCODE = outTimeCg.S_CAR_CODE, |
| | | WEIGHT = outTimeCg.F_QTY, |
| | | REMELTTIME = DateTime.Now |
| | | REMELTTIME = DateTime.Now, |
| | | SHIFT = "None", |
| | | }; |
| | | SpecHelper.InsertRemeltDetail(target); |
| | | }); |
| | |
| | | db.Updateable<TN_InventoryM>(targetInM).UpdateColumns(it => new { it.EXPIRATION_DAY }).ExecuteCommand(); |
| | | } |
| | | |
| | | targetInM = db.Queryable<TN_InventoryM>().First(a => a.EXPIRATION_DAY > 0 && a.ITEMSTATE == "过期");//已过期的货品,剩余天数改为0 |
| | | if (targetInM != null) |
| | | { |
| | | targetInM.EXPIRATION_DAY = 0; |
| | | db.Updateable<TN_InventoryM>(targetInM).UpdateColumns(it => new { it.EXPIRATION_DAY }).ExecuteCommand(); |
| | | } |
| | | |
| | | // 同步 TN_DayProDetail |
| | | var curDay = System.DateTime.Now.Date; |