| | |
|---|
| | | .Contains(queryObj.SearchValue.ToLower())) |
|---|
| | | // .OrderByDescending((a, b, |
|---|
| | | |
|---|
| | | .OrderBy("CASE WHEN a.STATUS = '已提交' THEN 0 ELSE 1 END, a.IQC_DATE desc, a.ID asc") |
|---|
| | | .OrderBy("CASE WHEN a.EMERGENCY = 1 THEN 0 ELSE 1 END, CASE WHEN a.STATUS = '已提交' THEN 0 ELSE 1 END, a.IQC_DATE desc, a.ID asc") |
|---|
| | | .ToPageList(queryObj.PageIndex, queryObj.Limit, ref totalCount); |
|---|
| | | |
|---|
| | | var emergencyValues = pageList.Select(item => item.EMERGENCY).ToList(); |
|---|
| | |
|---|
| | | return input.Substring(startIndex + 1, length); |
|---|
| | | } |
|---|
| | | |
|---|
| | | public List<QamftpDto> GetAttachments(string releaseNo) |
|---|
| | | public List<QamftpDto> GetAttachments(string ItemNo) |
|---|
| | | { |
|---|
| | | if (string.IsNullOrEmpty(releaseNo)) |
|---|
| | | if (string.IsNullOrEmpty(ItemNo)) |
|---|
| | | { |
|---|
| | | throw new ArgumentException("检验单号不能为空"); |
|---|
| | | } |
|---|
| | |
|---|
| | | try |
|---|
| | | { |
|---|
| | | return db.Queryable<MesQamftp>() |
|---|
| | | .Where(x => x.ReleaseNo == releaseNo) |
|---|
| | | .Where(x => x.ItemNo == ItemNo) |
|---|
| | | .OrderBy(x => x.Fdate, OrderByType.Desc) |
|---|
| | | // .ThenBy(x => x.CreateDate, OrderByType.Desc) |
|---|
| | | .Select(x => new QamftpDto |
|---|
| | | { |
|---|
| | | Id = x.Id, |
|---|
| | | ItemNo = x.ItemNo, |
|---|
| | | itemNo = x.ItemNo, |
|---|
| | | Ftype = x.Ftype, |
|---|
| | | Fattach = x.Fattach, |
|---|
| | | Fversion = x.Fversion, |
|---|
| | |
|---|
| | | CreateDate = x.CreateDate, |
|---|
| | | Company = x.Company, |
|---|
| | | Factory = x.Factory, |
|---|
| | | ReleaseNo = x.ReleaseNo, |
|---|
| | | |
|---|
| | | F_type = x.F_type, |
|---|
| | | LastupdateBy = x.LastupdateBy, |
|---|
| | | LastupdateDate = x.LastupdateDate, |
|---|
