| | |
|---|
| | | var list = _mapper.Map<List<OrderBanciDTO>>(listRole); |
|---|
| | | return list; |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | public List<OrderBanciDTO> GetJifenBanciList() |
|---|
| | | { |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | ResultDataEntity<OrderBanciDTO> data = new ResultDataEntity<OrderBanciDTO>(); |
|---|
| | | List<OrderBanciDTO> list = new List<OrderBanciDTO>(); |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | var listCode = (from a in _context.SysCodeDtls |
|---|
| | | join b in _context.SysCodes |
|---|
| | | on a.CodeId equals b.Id |
|---|
| | | where a.RecStatus == "A" |
|---|
| | | && b.RecStatus == "A" |
|---|
| | | select new CodeDataEntity() |
|---|
| | | { |
|---|
| | | CodeId = b.Id, |
|---|
| | | CodeTable = b.CodeTable, |
|---|
| | | CodeField = b.CodeField, |
|---|
| | | CodeSn = a.CodeSn, |
|---|
| | | Comments = a.Comments, |
|---|
| | | Contents = a.Contents, |
|---|
| | | RecStatus = a.RecStatus, |
|---|
| | | Sort = a.Sort |
|---|
| | | } |
|---|
| | | ); |
|---|
| | | |
|---|
| | | ///OrderBancis |
|---|
| | | /// |
|---|
| | | |
|---|
| | | |
|---|
| | | var query = (from a in _context.OrderBancis |
|---|
| | | join b in _context.OrderBanciDtls on a.Id equals b.OrderBanciId |
|---|
| | | |
|---|
| | | join d in listCode.Where(x => x.CodeTable == "order_banci_order" && x.CodeField == "kechengleixing_id") |
|---|
| | | on b.Shangxiawu equals d.CodeSn |
|---|
| | | into dzsssss |
|---|
| | | from dzzzzz in dzsssss.DefaultIfEmpty() |
|---|
| | | |
|---|
| | | where a.RecStatus == "A" && b.RecStatus == "A" && b.Jifen != null |
|---|
| | | && a.Shijianend >= DateTime.Now |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | select new OrderBanciDTO |
|---|
| | | { |
|---|
| | | img_url ="", |
|---|
| | | point = b.Jifen, |
|---|
| | | sell_price = b.Jiage, |
|---|
| | | type = "Train", |
|---|
| | | title = a.Mingcheng+"("+ dzzzzz.Comments+")", |
|---|
| | | Id = a.Id, |
|---|
| | | Banci = a.Banci, |
|---|
| | | Mingcheng = a.Mingcheng, |
|---|
| | | Shijian = a.Shijian, |
|---|
| | | ShijianName = a.Shijian.HasValue ? a.Shijian.Value.ToString("yyyy-MM-dd HH:mm") : "", |
|---|
| | | |
|---|
| | | Shijianend = a.Shijianend, |
|---|
| | | ShijianendName = a.Shijianend.HasValue ? a.Shijianend.Value.ToString("yyyy-MM-dd HH:mm") : "", |
|---|
| | | |
|---|
| | | Didian = a.Didian, |
|---|
| | | |
|---|
| | | Renshu = a.Renshu ?? 0, |
|---|
| | | |
|---|
| | | |
|---|
| | | Creater = a.Creater, |
|---|
| | | Createtime = a.Createtime, |
|---|
| | | |
|---|
| | | RecStatus = a.RecStatus, |
|---|
| | | Modifier = a.Modifier, |
|---|
| | | Modifytime = a.Modifytime, |
|---|
| | | |
|---|
| | | |
|---|
| | | Shangxiawu = b.Shangxiawu, |
|---|
| | | Shijiandtl = b.Shijian, |
|---|
| | | Shixiamg = b.Shixiamg, |
|---|
| | | Zhujiangren = b.Zhujiangren, |
|---|
| | | Sort = b.Sort, |
|---|
| | | ShangxiawuName = dzzzzz.Comments, |
|---|
| | | Jiage = b.Jiage, |
|---|
| | | Jifen = b.Jifen, |
|---|
| | | JiageName = b.Jiage.HasValue ? b.Jiage.Value.ToString() : "", |
|---|
| | | JifenName = b.Jifen.HasValue ? b.Jifen.Value.ToString() : "", |
|---|
| | | id = a.Id, |
|---|
| | | |
|---|
| | | } |
|---|
| | | ).OrderByDescending(x => x.Shijian).ThenBy(x=>x.Sort).ToList(); |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | return query; |
|---|
| | | } |
|---|
| | | |
|---|
| | | } |
|---|
| | | } |
|---|
