| | |
| | | /// </summary> |
| | | /// <param name="lastTime"></param> |
| | | /// <returns></returns> |
| | | public static List<MaltInformation> getMaltInfoList(DateTime lastTime) |
| | | public static List<IwmsSemiBcscan> getMaltInfoList(DateTime lastTime) |
| | | { |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | return db.Queryable<MaltInformation>().Where( a => a.last_modify_time >= lastTime).OrderByDescending( a => a.last_modify_time).ToList(); |
| | | return db.Queryable<IwmsSemiBcscan>().Where( a => a.last_modify_time > lastTime).OrderByDescending( a => a.last_modify_time).ToList(); |
| | | } |
| | | |
| | | /// <summary> |
| | |
| | | /// </summary> |
| | | /// <param name="lastTime"></param> |
| | | /// <returns></returns> |
| | | public static List<TableOfBarcodeStatus> getMaltStatusList(DateTime lastTime) |
| | | public static List<IwmsSemiBldBcstatus> getMaltStatusList(DateTime lastTime) |
| | | { |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | return db.Queryable<TableOfBarcodeStatus>().Where(a => a.last_modify_time >= lastTime && a.bld_date == null).OrderByDescending(a => a.last_modify_time).ToList(); |
| | | return db.Queryable<IwmsSemiBldBcstatus>().Where(a => DateTime.Parse(a.last_modify_time) > lastTime && a.mcngrp > 1).OrderByDescending(a => a.last_modify_time).ToList(); |
| | | } |
| | | |
| | | public static List<Overage> getOverageList(DateTime lastTime) |
| | | /// <summary> |
| | | /// 查询物料条码信息列表 |
| | | /// </summary> |
| | | /// <param name="lastTime"></param> |
| | | /// <returns></returns> |
| | | public static List<IwmsSemiBldBcsample> getSampleMaltStatusList(DateTime lastTime) |
| | | { |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | return db.Queryable<Overage>().Where(a => a.last_modify_time >= lastTime ).OrderByDescending(a => a.last_modify_time).ToList(); |
| | | return db.Queryable<IwmsSemiBldBcsample>().Where(a => DateTime.Parse(a.last_modify_time) > lastTime && a.mcngrp > 1).OrderByDescending(a => a.last_modify_time).ToList(); |
| | | } |
| | | |
| | | /// <summary> |