/// <summary> /// 新增桌类,包括服务费设置、低消设置 /// </summary> /// <param name="type"></param> /// <param name="serverFeeDetail"></param> /// <param name="lowConsumerDetail"></param> /// <returns></returns> public int SaveTableTypeAll(TableType type, TableTypeDetail serverFeeDetail, TableTypeDetail lowConsumerDetail) { try { int typeId = SaveTableType(type); serverFeeDetail.TableTypeId = typeId; lowConsumerDetail.TableTypeId = typeId; SaveTableTypeDetail(serverFeeDetail); SaveTableTypeDetail(lowConsumerDetail); return typeId; } catch (Exception e) { throw new ServiceException(e.Message); } }
/// <summary> /// 删除 /// </summary> /// <param name="detailId"></param> /// <returns></returns> public bool DeleteTableTypeDetail(int detailId) { try { using (ChooseDishesEntities entities = new ChooseDishesEntities()) { TableTypeDetail detail = new TableTypeDetail(); detail.TableTypeDetailId = detailId; detail.Deleted = 1; DbEntityEntry<IShow.ChooseDishes.Data.TableTypeDetail> entry = entities.Entry<IShow.ChooseDishes.Data.TableTypeDetail>(detail); entry.State = System.Data.Entity.EntityState.Unchanged; entry.Property("Deleted").IsModified = true; entities.Configuration.ValidateOnSaveEnabled = false; int result = entities.SaveChanges(); entities.Configuration.ValidateOnSaveEnabled = false; if (result == 1) { return true; } else { return false; } } } catch (Exception e) { throw e; } }
/// <summary> /// 修改服务费低消设置 /// </summary> /// <param name="detail">服务费设置详细</param> /// <param name="serverFeeMode">服务费模式</param> /// <returns>成功则返回true,失败返回false</returns> public bool UpdateTableTypeDetail(TableTypeDetail detail) { try { using (ChooseDishesEntities entities = new ChooseDishesEntities()) { detail.UpdateBy = SubjectUtils.GetAuthenticationId(); detail.UpdateDatetime = DateTime.Now; DbEntityEntry<IShow.ChooseDishes.Data.TableTypeDetail> entry = entities.Entry<IShow.ChooseDishes.Data.TableTypeDetail>(detail); entry.State = System.Data.Entity.EntityState.Unchanged; entry.Property("StartMoney").IsModified = true; entry.Property("StartGetMoneyTime").IsModified = true; entry.Property("StartUnit").IsModified = true; entry.Property("StartDateTime").IsModified = true; entry.Property("EndDateTime").IsModified = true; entry.Property("OutMoney").IsModified = true; entry.Property("OutTime").IsModified = true; entry.Property("OutTimeFree").IsModified = true; entry.Property("ServerfreeNax").IsModified = true; entry.Property("ServerfreeAccountType").IsModified = true; entry.Property("ServerfreeNum").IsModified = true; entry.Property("Rate").IsModified = true; entry.Property("ConsumerMode").IsModified = true; entry.Property("ConsumerMoney").IsModified = true; entry.Property("UpdateDatetime").IsModified = true; entry.Property("UpdateBy").IsModified = true; //entry.Property("TableTypeDetailId").IsModified = false; entities.Configuration.ValidateOnSaveEnabled = false; int result = entities.SaveChanges(); entities.Configuration.ValidateOnSaveEnabled = false; if (result == 1) { return true; } else { return false; } } } catch (Exception e) { throw e; } }
/// <summary> /// 新增服务费时间单位设置 /// </summary> /// <param name="detail"></param> /// <returns></returns> public bool SaveTableTypeDetail(TableTypeDetail detail) { try { using (ChooseDishesEntities entities = new ChooseDishesEntities()) { detail.Deleted = 0; detail.Status = 0; detail.CreateDatetime = DateTime.Now; detail.UpdateDatetime = DateTime.Now; entities.TableTypeDetail.Add(detail); int result = entities.SaveChanges(); if (result == 1) { return true; } else { return false; } } } catch (Exception e) { throw e; } }
/// <summary> /// 根据ID查询餐桌类别详细设置 /// </summary> /// <param name="tableTypeDetailId"></param> /// <returns></returns> public TableTypeDetail LoadTableTypeDetailById(int tableTypeDetailId) { TableTypeDetail type; using (ChooseDishesEntities entities = new ChooseDishesEntities()) { type = (TableTypeDetail)entities.TableTypeDetail.Where( info => info.Deleted == 0 && info.TableTypeDetailId == tableTypeDetailId ); if (type == null) { type = new TableTypeDetail(); } return type; }; }
/// <summary> /// 修改餐桌类型,包括服务费设置、低消设置 /// </summary> /// <param name="type"></param> /// <param name="serverFeeDetail"></param> /// <param name="lowConsumerDetail"></param> public void UpdateTableTypeAll(TableType type, TableTypeDetail serverFeeDetail, TableTypeDetail lowConsumerDetail) { try { UpdateTableType(type); UpdateTableTypeDetail(serverFeeDetail); UpdateTableTypeDetail(lowConsumerDetail); } catch (Exception e) { throw new ServiceException("修改失败!"); } }