| | |
|---|
| | | 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)) |
|---|
| | |
|---|
| | | && (string.IsNullOrWhiteSpace(searchEntity.EndTime) || a.XdTime <= DateTime.Parse(searchEntity.EndTime).AddSeconds(1)) |
|---|
| | | && ((searchEntity.HuiyuanIds == null || searchEntity.HuiyuanIds.Length == 0) || searchEntity.HuiyuanIds.Contains(ggg.HuiyuanId)) |
|---|
| | | && ((searchEntity.OrderTypes == null || searchEntity.OrderTypes.Length == 0) || searchEntity.OrderTypes.Contains(a.OrderType)) |
|---|
| | | |
|---|
| | | && (string.IsNullOrWhiteSpace(searchEntity.OrderType1) || a.OrderType1 == searchEntity.OrderType1.Trim()) |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | |
|---|
| | | |
|---|
| | | Creater = a.Creater, |
|---|
| | | Createtime = a.Createtime, |
|---|
| | | |
|---|
| | | CreaterName = sss.UserName, |
|---|
| | | RecStatus = a.RecStatus, |
|---|
| | | Modifier = a.Modifier, |
|---|
| | | Modifytime = a.Modifytime, |
|---|
| | |
|---|
| | | if ( !string.IsNullOrWhiteSpace(searchEntity.Fkzt)){ |
|---|
| | | if (searchEntity.Fkzt.Trim().Equals("01")) |
|---|
| | | { |
|---|
| | | query = query.Where(x => x.YishouMoney <= 0).OrderByDescending(x => x.OrderNo).ToList(); |
|---|
| | | query = query.Where(x => x.YishouMoney <= 0 && x.WeishouMoney>0).OrderByDescending(x => x.OrderNo).ToList(); |
|---|
| | | } |
|---|
| | | else if (searchEntity.Fkzt.Trim().Equals("02")) |
|---|
| | | { |
|---|
| | |
|---|
| | | |
|---|
| | | //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; |
|---|
| | | } |
|---|
