username@email.com
2023-11-02 558dae4a18d393ac38daa43a354e8bc9a22e4e26
zhengcaioa/Services/OrderBanciService.cs
@@ -52,8 +52,66 @@
                    updateproject.Modifier = entity.Modifier;
                    updateproject.Modifytime = entity.Modifytime;
                    updateproject.Mingcheng = entity.Mingcheng;
                    updateproject.Renshu = entity.Renshu;
                    updateproject.Renshu = entity.Renshu;
                    updateproject.Hang = entity.Hang;
                    updateproject.Lie = entity.Lie;
                }
                if(entity.Hang.HasValue && entity.Lie.HasValue)
                {
                    var orderBanciZuoweis = _context.OrderBanciZuoweis.Where(x =>x.RecStatus == "A" &&  x.BanciId == entity.Id).ToList();
                    for(int i=0;i< entity.Hang.Value; i++)
                    {
                        for (int j = 0; j < entity.Lie.Value; j++)
                        {
                            var orderBanciZuowei = orderBanciZuoweis.Where(x => x.RowNo == (i + 1) && x.ColNo == (j + 1)).FirstOrDefault();
                            if(orderBanciZuowei == null)
                            {
                                var orderBanciZuoweisss = new OrderBanciZuowei();
                                orderBanciZuoweisss.Id =  Guid.NewGuid().ToString();
                                orderBanciZuoweisss.BanciId = entity.Id;
                                orderBanciZuoweisss.ZuoweiId = (i + 1)+"-"+ (j + 1);
                                orderBanciZuoweisss.SeatNo = (i + 1) + "-" + (j + 1) + "座";
                                orderBanciZuoweisss.Status = "0";
                                orderBanciZuoweisss.RowNo = (i+1);
                                orderBanciZuoweisss.ColNo = (j+1);
                                orderBanciZuoweisss.RecStatus = "A";
                                orderBanciZuoweisss.Creater = string.IsNullOrEmpty(entity.Creater)? entity.Modifier : entity.Creater;
                                orderBanciZuoweisss.Createtime = DateTime.Now;
                                orderBanciZuoweisss.Modifier = orderBanciZuoweisss.Creater;
                                orderBanciZuoweisss.Modifytime = orderBanciZuoweisss.Createtime;
                                _context.OrderBanciZuoweis.Add(orderBanciZuoweisss);
                            }
                        }
                    }
                    //删除多余的座位
                    var orderBanciZuoweisdel = orderBanciZuoweis.Where(x => x.RowNo > entity.Hang.Value || x.ColNo > entity.Lie.Value).ToList();
                    if (orderBanciZuoweisdel != null && orderBanciZuoweisdel.Count > 0)
                    {
                        foreach (var orderBanciZuowei in orderBanciZuoweisdel)
                        {
                            orderBanciZuowei.RecStatus = "D";
                        }
                    }
                }
                else
                {
                    //如果没有座位就删除所有座位
                  var orderBanciZuoweis  =  _context.OrderBanciZuoweis.Where(x => x.RecStatus == "A" && x.BanciId == entity.Id).ToList();
                    if(orderBanciZuoweis!=null && orderBanciZuoweis.Count > 0)
                    {
                        foreach ( var orderBanciZuowei in orderBanciZuoweis)
                        {
                            orderBanciZuowei.RecStatus = "D";
                        }
                    }
                }
                _context.SaveChanges();
                resultEntity.ReturnID = entity.Id;
@@ -166,6 +224,10 @@
                             Mingcheng = a.Mingcheng,
                             Renshu = a.Renshu??0,
                             Hang = a.Hang ?? 0,
                             Lie = a.Lie ?? 0,
                             Creater = a.Creater,
@@ -300,7 +362,8 @@
                             Didian = a.Didian,
                             Renshu = a.Renshu ?? 0,
                             Hang = a.Hang ?? 0,
                             Lie = a.Lie ?? 0,
                             Creater = a.Creater,
                             Createtime = a.Createtime,
@@ -330,5 +393,63 @@
            return query;
        }
        public ResultEntity saveZuowei(OrderBanciZuoweiDTO dto)
        {
            ResultEntity resultEntity = new ResultEntity();
            try
            {
                var entity = _mapper.Map<OrderBanciZuowei>(dto);
                if (String.IsNullOrEmpty(entity.Id))
                {
                    entity.Id = Guid.NewGuid().ToString();
                    dto.Id = entity.Id;
                    _context.OrderBanciZuoweis.Add(entity);
                }
                else
                {
                    var updateproject = _context.OrderBanciZuoweis.Find(entity.Id);
                    updateproject.BanciId = entity.BanciId;
                    updateproject.ZuoweiId = entity.ZuoweiId;
                    updateproject.SeatNo = entity.SeatNo;
                    updateproject.Status = entity.Status;
                    updateproject.RowNo = entity.RowNo;
                    updateproject.ColNo = entity.ColNo;
                    updateproject.RecStatus = entity.RecStatus;
                    updateproject.Modifier = entity.Modifier;
                    updateproject.Modifytime = entity.Modifytime;
                }
                _context.SaveChanges();
                resultEntity.ReturnID = entity.Id;
                resultEntity.Result = true;
            }
            catch (Exception ex)
            {
                resultEntity.Result = false;
                resultEntity.Message = "保存失败,请联系管理员";
            }
            return resultEntity;
        }
        public List<OrderBanciZuoweiDTO> GetOrderBanciZuoweiList(string banciId)
        {
            var listRole = _context.OrderBanciZuoweis.Where(r => r.RecStatus == "A" && r.BanciId == banciId).OrderBy(x=>x.RowNo).ThenBy(x=>x.ColNo).ToList();
            var list = _mapper.Map<List<OrderBanciZuoweiDTO>>(listRole);
            return list;
        }
    }
}