| | |
| | | updateproject.Modifytime = entity.Modifytime; |
| | | updateproject.Sort = entity.Sort; |
| | | updateproject.OrderBanciId = entity.OrderBanciId; |
| | | updateproject.Jiage = entity.Jiage; |
| | | updateproject.Jifen = entity.Jifen; |
| | | |
| | | } |
| | | |
| | |
| | | |
| | | var query = (from a in _context.OrderBanciDtls |
| | | |
| | | join d in listCode.Where(x => x.CodeTable == "order_banci_dtl" && x.CodeField == "shangxiawu") |
| | | join d in listCode.Where(x => x.CodeTable == "order_banci_order" && x.CodeField == "kechengleixing_id") |
| | | on a.Shangxiawu equals d.CodeSn |
| | | into dzsssss |
| | | from dzzzzz in dzsssss.DefaultIfEmpty() |
| | |
| | | RecStatus = a.RecStatus, |
| | | Modifier = a.Modifier, |
| | | Modifytime = a.Modifytime, |
| | | Jiage = a.Jiage, |
| | | Jifen = a.Jifen, |
| | | JiageName = a.Jiage.HasValue? a.Jiage.Value.ToString():"", |
| | | JifenName = a.Jifen.HasValue ? a.Jifen.Value.ToString() : "", |
| | | |
| | | } |
| | | ).OrderBy(x => x.Sort).ToList(); |
| | | |
| | | |
| | | |
| | | if (searchEntity.totalrows == 0) |
| | | //if (searchEntity.totalrows == 0) |
| | | searchEntity.totalrows = query.Count(); |
| | | var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList(); |
| | | data.LoadData(searchEntity, lianlist); |