| | |
|---|
| | | into msssss |
|---|
| | | from mmm in msssss.DefaultIfEmpty() |
|---|
| | | |
|---|
| | | join s in _context.PltUsers |
|---|
| | | on a.Creater equals s.Id |
|---|
| | | into ssssss |
|---|
| | | from sss in ssssss.DefaultIfEmpty() |
|---|
| | | |
|---|
| | | where a.RecStatus == "A" && a.ChedanStatus == "D" |
|---|
| | | && (string.IsNullOrWhiteSpace(searchEntity.XdTime) || (a.XdTime >= XdTimestart && a.XdTime <= XdTimeend)) |
|---|
| | |
|---|
| | | |
|---|
| | | Creater = a.Creater, |
|---|
| | | Createtime = a.Createtime, |
|---|
| | | |
|---|
| | | CreaterName = sss.UserName, |
|---|
| | | RecStatus = a.RecStatus, |
|---|
| | | Modifier = a.Modifier, |
|---|
| | | Modifytime = a.Modifytime, |
|---|
| | |
|---|
| | | |
|---|
| | | //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.Money) , 2); |
|---|
| | | data.Heji3 = Math.Round(query.Sum(x => x.YishouMoney), 2); |
|---|
| | | data.Heji4 = Math.Round(query.Sum(x => x.WeishouMoney), 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.Money), 2); |
|---|
| | | data.DangyeHeji3 = Math.Round(lianlist.Sum(x => x.YishouMoney) , 2); |
|---|
| | | data.DangyeHeji4 = Math.Round(lianlist.Sum(x => x.WeishouMoney) , 2); |
|---|
| | | data.LoadData(searchEntity, lianlist); |
|---|
| | | return data; |
|---|
| | | } |
|---|
