username@email.com
2022-08-27 6e2b929cf381e2320ba6e7dec56c0371124d2b51
zhengcaioa/Services/OrderBanciOrderService.cs
@@ -36,6 +36,10 @@
                {
                    entity.Id = Guid.NewGuid().ToString();
                    dto.Id = entity.Id;
                    if (string.IsNullOrWhiteSpace(dto.OrderId))
                    {
                        entity.OrderId = dto.Id;
                    }
                    _context.OrderBanciOrders.Add(entity);
                }
                else
@@ -59,6 +63,8 @@
                    updateproject.Modifier = entity.Modifier;
                    updateproject.Modifytime = entity.Modifytime;
                    updateproject.Shenfenzheng = entity.Shenfenzheng;
                    updateproject.Jifen = entity.Jifen;
                    updateproject.OrderId = entity.OrderId;
                }
                _context.SaveChanges();
@@ -147,7 +153,7 @@
                              && (string.IsNullOrWhiteSpace(searchEntity.BanciId) || a.BanciId == searchEntity.BanciId.Trim())
                               && ((searchEntity.Kechengleixings==null|| searchEntity.Kechengleixings.Length == 0) || searchEntity.Kechengleixings.Split(new char[] { ',' }).Contains(a.KechengleixingId))
@@ -157,7 +163,7 @@
                             Id = a.Id,
                            
                             Baomingtime = a.Baomingtime,
                             BaomingtimeName =  a.Baomingtime.ToString("yyyy-MM-dd"),
                             BaomingtimeName =  a.Baomingtime.ToString("yyyy-MM-dd HH:mm"),
                             BanciId = a.BanciId,
                             Peixunbanci = a.Peixunbanci,
                          
@@ -172,7 +178,7 @@
                             Xuefei = a.Xuefei??0,
                             Baomingrenshu = a.Baomingrenshu??0,
                             Jine = a.Jine??0,
                             Jifen = a.Jifen ?? 0,
                             Creater = a.Creater,
                             Createtime = a.Createtime,
@@ -187,9 +193,14 @@
            if (searchEntity.totalrows == 0)
            //if (searchEntity.totalrows == 0)
                searchEntity.totalrows = query.Count();
            data.Heji1 = Math.Round(query.Sum(x => x.Xuefei) ?? 0, 2);
            data.Heji2 = Math.Round(new decimal(query.Sum(x => x.Baomingrenshu) ?? 0), 2);
            var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
            data.DangyeHeji1 = Math.Round(lianlist.Sum(x => x.Xuefei) ?? 0, 2);
            data.DangyeHeji2 = Math.Round(new decimal(lianlist.Sum(x => x.Baomingrenshu) ?? 0), 2);
            data.LoadData(searchEntity, lianlist);
            return data;
        }
@@ -246,5 +257,33 @@
           
            return result;
        }
        /// <summary>
        /// 修改主表状态
        /// </summary>
        /// <param name="id">主id</param>
        /// <param name="userid">用户</param>
        /// <returns></returns>
        public ResultEntity DeleteStatus(string OrderId)
        {
            ResultEntity result = new ResultEntity();
            result.Result = true;
            if (string.IsNullOrEmpty(OrderId))
            {
                result.Result = false;
                result.Message = "必须填写订单id";
            }
            var model = _context.OrderBanciOrders.Where(x=>x.OrderId == OrderId).FirstOrDefault();
            if (model != null)
            {
                model.RecStatus = "D";
                model.Modifier = "1";
                model.Modifytime = DateTime.Now;
                _context.SaveChanges();
            }
            return result;
        }
    }
}