| | |
| | | |
| | | /// <summary> |
| | | /// 刀具查询(支持编号或名称模糊查询) |
| | | /// 上机、报废、维修出库不查询 |
| | | /// </summary> |
| | | /// <param name="searchKey">查询关键字</param> |
| | | /// <param name="pageIndex">页码</param> |
| | |
| | | /// <returns>刀具查询结果</returns> |
| | | public MesCutterLedger QueryTools(string searchKey, int pageIndex, int pageSize) |
| | | { |
| | | var excludeTypes = new[] { "上机", "报废", "维修出库" }; |
| | | var query = Db.Queryable<MesCutterLedger>() |
| | | .Where(t => !excludeTypes.Contains(t.CutterType)) |
| | | .WhereIF(!string.IsNullOrEmpty(searchKey), |
| | | t => t.CutterId.Contains(searchKey) || t.CutterName.Contains(searchKey)); |
| | | |