| | |
| | | into msssss |
| | | from mmm in msssss.DefaultIfEmpty() |
| | | |
| | | join n in _context.PltUsers |
| | | on a.Creater equals n.Id |
| | | into nsssss |
| | | from nnn in nsssss.DefaultIfEmpty() |
| | | |
| | | where a.RecStatus == "A" |
| | | && (string.IsNullOrWhiteSpace(searchEntity.XdTime) || (a.XdTime >= XdTimestart && a.XdTime <= XdTimeend)) |
| | | && (string.IsNullOrWhiteSpace(searchEntity.Ywjl) || ggg.Ywjl == searchEntity.Ywjl.Trim()) |
| | |
| | | Remark = a.Remark, |
| | | |
| | | Creater = a.Creater, |
| | | CreaterName = nnn.UserName, |
| | | Createtime = a.Createtime, |
| | | |
| | | RecStatus = a.RecStatus, |
| | |
| | | |
| | | //if (searchEntity.totalrows == 0) |
| | | searchEntity.totalrows = query.Count(); |
| | | data.Heji1 = Math.Round(query.Sum(x => x.OrderNum) ?? 0, 2); |
| | | data.Heji2 = Math.Round(query.Sum(x => x.Price) ?? 0, 2); |
| | | data.Heji3 = Math.Round(query.Sum(x => x.Money) ?? 0, 2); |
| | | data.Heji4 = Math.Round(query.Sum(x => x.Youhui) ?? 0, 2); |
| | | var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList(); |
| | | data.DangyeHeji1 = Math.Round(lianlist.Sum(x => x.OrderNum) ?? 0, 2); |
| | | data.DangyeHeji2 = Math.Round(lianlist.Sum(x => x.Price) ?? 0, 2); |
| | | data.DangyeHeji3 = Math.Round(lianlist.Sum(x => x.Money) ?? 0, 2); |
| | | data.DangyeHeji4 = Math.Round(lianlist.Sum(x => x.Youhui) ?? 0, 2); |
| | | data.LoadData(searchEntity, lianlist); |
| | | return data; |
| | | } |