//新增桌类
public int SaveTableType(TableType type)
{
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
try
{
Hashtable hash = new Hashtable();//返回结果
List<TableType> types;
//检查类型编号或者类型名称是否重复
types = entities.TableType.Where(info => info.Name == type.Name || info.Code == type.Code).ToList();
if (types != null && types.Count > 0)
{
hash.Add("code", 1);
if (types[0].Name == type.Name)
{
throw new ServiceException("类型名称已经存在，请重新命名！");
}
else if (types[0].Code == type.Code)
{
throw new ServiceException("类型编号已经存在！");
}
}
entities.TableType.Add(type);
entities.SaveChanges();
return type.TableTypeId;
}
catch (Exception e)
{
throw new ServiceException(e.Message);
}
};
}
public TableType LoadTableTypeById(int typeId)
{
TableType type;
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
type = entities.TableType.Where(
info => info.Deleted == 0
&& (info.TableTypeId == typeId)
).ToList()[0];
if (type == null)
{
type = new TableType();
}
return type;
};
}
public void UpdateTypeMethod()
{
try
{
TableType type = new TableType();
type.Code = Code;
type.Name = Name;
type.PeopleMax = Convert.ToInt32(PeopleMax);
type.PeopleMin = Convert.ToInt32(PeopleMin);
//type.Prefix = Prefix;
type.PriceType = (int)PriceType;
type.ServerfreeModel = (int)ServerfreeModel;
type.LowConsCalcType = (int)LowConsCalcType;
type.ServerFeeCalcType = (int)ServerFeeCalcType;
type.Status = 0;
type.Deleted = 0;
type.ColorType = ColorType;
type.CreateDatetime = DateTime.Now;
type.CreateBy = SubjectUtils.GetAuthenticationId();
type.UpdateBy = SubjectUtils.GetAuthenticationId();
type.UpdateDatetime = DateTime.Now;
type.CanDiscount = CanDiscount;
type.InLowConsume = InLowConsume;
TableViewModel tableViewModel = ServiceLocator.Current.GetInstance<TableViewModel>();
if (currentTableTypeId == null)
{//修改窗口修改餐桌类型
type.TableTypeId = tableViewModel.SelectedType.TableTypeId;
}
else//新增窗口修改餐桌类型
{
type.TableTypeId = (int)currentTableTypeId;
}
ServerFeeDetail.UpdateBy = SubjectUtils.GetAuthenticationId();
ServerFeeDetail.ServerfreeAccountType = (int)ServerfreeAccountType;
LowConsumerDetail.ConsumerMode = (int)ConsumerMode;
LowConsumerDetail.UpdateBy = SubjectUtils.GetAuthenticationId();
TableService.UpdateTableTypeAll(type, ServerFeeDetail, LowConsumerDetail);
}
catch (Exception e)
{
throw e;
}
}
public int SaveTypeMethod()
{
try
{
TableType type = new TableType();
type.Code = Code;
type.Name = Name;
type.PeopleMax = Convert.ToInt32(PeopleMax);
type.PeopleMin = Convert.ToInt32(PeopleMin);
//type.Prefix = Prefix;
type.PriceType = (int)PriceType;
type.ServerfreeModel = (int)ServerfreeModel;
type.LowConsCalcType = (int)LowConsCalcType;
type.ServerFeeCalcType = (int)ServerFeeCalcType;
type.Status = 0;
type.Deleted = 0;
type.ColorType = ColorType;
type.CreateDatetime = DateTime.Now;
type.CreateBy = SubjectUtils.GetAuthenticationId();
type.UpdateBy = SubjectUtils.GetAuthenticationId();
type.UpdateDatetime = DateTime.Now;
ServerFeeDetail.CreateBy = SubjectUtils.GetAuthenticationId();
ServerFeeDetail.DataType = 1;
ServerFeeDetail.ServerfreeAccountType = (int)ServerfreeAccountType;
LowConsumerDetail.CreateBy = SubjectUtils.GetAuthenticationId();
LowConsumerDetail.DataType = 2;
LowConsumerDetail.ConsumerMode = (int)ConsumerMode;
int tableTypeId = TableService.SaveTableTypeAll(type, ServerFeeDetail, LowConsumerDetail);
MessageBox.Show("新增成功！");
//刷新界面上的目录树
TableViewModel tableModel = ServiceLocator.Current.GetInstance<TableViewModel>();
_TableTypeTree = tableModel.TableTypeTree;
TableTypeTreeNode tableTypeTreeNode = new TableTypeTreeNode(type.TableTypeId.ToString(), type.Name, tableModel.TableTypeTree[0], false, null);
tableTypeTreeNode.Action = tableModel.LoadTableTypeAction;
tableModel.TableTypeTree[0].Children.Add(tableTypeTreeNode);
return tableTypeId;
}
catch (Exception e)
{
throw new ServiceException(e.Message);
}
}
/// <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);
}
}
/**删除桌类,逻辑删除**/
public void DeleteTableType(int typeId)
{
try
{
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
//检查是否被餐桌关联
List<IShow.ChooseDishes.Data.Table> tableList = LoadTableByTypeId(typeId);
if (tableList != null && tableList.Count > 0)
{
throw new ServiceException("该餐桌类别关联了餐桌，不能删除！");
}
TableType type = new TableType();
type.TableTypeId = typeId;
type.Deleted = 1;
DbEntityEntry<TableType> entry = entities.Entry<TableType>(type);
entry.State = System.Data.Entity.EntityState.Unchanged;//Modified
entry.Property("Deleted").IsModified = true;
entities.Configuration.ValidateOnSaveEnabled = false;
int result = entities.SaveChanges();
entities.Configuration.ValidateOnSaveEnabled = true;
if (result == 1)
{
throw new ServiceException("修改失败！");
}
}
}
catch (Exception e)
{
throw new ServiceException(e.Message);
}
}
public void UpdateTableType(TableType type)
{
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
DbEntityEntry<TableType> entry = entities.Entry<TableType>(type);
entry.State = System.Data.Entity.EntityState.Unchanged;//Modified
entry.Property("Name").IsModified = true;
entry.Property("PeopleMin").IsModified = true;
entry.Property("PeopleMax").IsModified = true;
entry.Property("PriceType").IsModified = true;
entry.Property("ServerfreeModel").IsModified = true;
entry.Property("ColorType").IsModified = true;
entry.Property("UpdateBy").IsModified = true;
entry.Property("UpdateDatetime").IsModified = true;
entry.Property("LowConsCalcType").IsModified = true;
entry.Property("ServerFeeCalcType").IsModified = true;
entry.Property("CanDiscount").IsModified = true;
entry.Property("InLowConsume").IsModified = true;
try
{
entities.Configuration.ValidateOnSaveEnabled = false;
int result = entities.SaveChanges();
entities.Configuration.ValidateOnSaveEnabled = true;
}
catch (Exception e)
{
throw new ServiceException(e.Message);
}
}
}
/// <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("修改失败！");
}
}
