工资绩效改版

username@email.com

2023-02-28 67a0042c5f29e4bb0e0b82f6190f2bc51480b45c

 zhengcaioa/Services/FiOrderrecievemoneyService.cs

@@ -192,6 +192,10 @@
                   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))
@@ -200,7 +204,9 @@
                          && (string.IsNullOrWhiteSpace(searchEntity.HuiyuanId) || ggg.HuiyuanId == searchEntity.HuiyuanId.Trim())
                           && (string.IsNullOrWhiteSpace(searchEntity.StartTime) || a.XdTime >= DateTime.Parse(searchEntity.StartTime) )
                            && (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())



@@ -223,7 +229,7 @@
                             YishouMoney = lll.YishouMoney??0,
                             WeishouMoney = (a.Money ?? 0) /*- (a.Youhui ?? 0)*/ - (lll.YishouMoney??0),


                             HuiyuanId = ggg.HuiyuanId,



@@ -231,7 +237,7 @@

                             Creater = a.Creater,
                             Createtime = a.Createtime,

                             CreaterName = sss.UserName,
                             RecStatus = a.RecStatus,
                             Modifier = a.Modifier,
                             Modifytime = a.Modifytime,
@@ -242,7 +248,7 @@
            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"))
                {
@@ -256,7 +262,15 @@

            //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;
        }