//员工状态修改
public int EditEmployeeFlag(Employee employee)
{
int flag = 0;
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
//直接修改的方式
DbEntityEntry <Employee> entry = entities.Entry <Employee>(employee);
entry.State = System.Data.Entity.EntityState.Unchanged;
//设置修改状态为ture 否则数据库不会更新
entry.Property("UpdateDatetime").IsModified = true;
entry.Property("Flag").IsModified = true;
entry.Property("UpdateBy").IsModified = true;
try
{
//关闭实体验证，不关闭验证需要整个对象全部传值
entities.Configuration.ValidateOnSaveEnabled = false;
flag = entities.SaveChanges();
entities.Configuration.ValidateOnSaveEnabled = true;
}
catch (Exception ex)
{
ex.ToString();
}
}
return(flag);
}
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);
}
}
}
//根据做法类型编码删除菜品做法类型,如果删除失败返回false，如果删除成功，则返回true
public bool DeleteDishesWayNameByCode(int id)
{
//先判断是否存在有做法，如果有做法，则不能返回false
List <DischesWay> orgDischesWay = FindAllDishesWayByTypeId(id);
if (orgDischesWay != null && orgDischesWay.Count > 0)
{
return(false);
}
//删除
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
try
{
DischesWayName booktype = new DischesWayName()
{
DischesWayNameId = id,
};
DbEntityEntry <DischesWayName> entry = entities.Entry <DischesWayName>(booktype);
entry.State = System.Data.Entity.EntityState.Deleted;
entities.SaveChanges();
return(true);
}
catch (Exception e)
{
e.ToString();
return(false);
}
}
}
/// <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;
}
}
public bool DeleteRaw(int id)
{
if (id < 0)
{
return(false);
}
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
try
{
Raw booktype = new Raw()
{
RawId = id,
};
DbEntityEntry <Raw> entry = entities.Entry <Raw>(booktype);
entry.State = EntityState.Deleted;
entities.SaveChanges();
return(true);
}
catch (Exception e)
{
e.ToString();
return(false);
}
}
}
public int DelByDepartment(DepartmentInfo departmentInfo)
{
int flag = 0;
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
//直接修改的方式
DbEntityEntry <DepartmentInfo> entry = entities.Entry <DepartmentInfo>(departmentInfo);
entry.State = System.Data.Entity.EntityState.Unchanged;
//设置修改状态为ture 否则数据库不会更新
entry.Property("UpdateBy").IsModified = true;
entry.Property("Deleted").IsModified = true;
entry.Property("UpdateDatetime").IsModified = true;
try
{
//关闭实体验证，不关闭验证需要整个对象全部传值
entities.Configuration.ValidateOnSaveEnabled = false;
flag = entities.SaveChanges();
entities.Configuration.ValidateOnSaveEnabled = true;
}
catch (Exception ex)
{
ex.ToString();
}
}
return(flag);
}
/**删除桌类,逻辑删除**/
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 int delByLocation(string id)
{
int flag = 0;
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
Location local = new Location()
{
LocationId = int.Parse(id),
Deleted = 1,
UpdateBy = 1,
UpdateDatetime = DateTime.Now
};
DbEntityEntry <Location> entry = entities.Entry <Location>(local);
entry.State = System.Data.EntityState.Unchanged;
entry.Property("Deleted").IsModified = true;
entry.Property("UpdateBy").IsModified = true;
entry.Property("UpdateDatetime").IsModified = true;
try
{
entities.Configuration.ValidateOnSaveEnabled = false;
flag = entities.SaveChanges();
entities.Configuration.ValidateOnSaveEnabled = true;
}
catch (Exception ex)
{
ex.ToString();
}
}
return(flag);
}
public bool DeleteMarketTypeById(int id)
{
if (id < 0)
{
return(false);
}
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
try
{
MarketType booktype = new MarketType()
{
Id = id,
};
DbEntityEntry <MarketType> entry = entities.Entry <MarketType>(booktype);
entry.State = EntityState.Deleted;
entities.SaveChanges();
return(true);
}
catch (Exception e)
{
e.ToString();
return(false);
}
}
}
public int editByLocation(string id, string name, string no)
{
int flag = 0;
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
Location local = new Location()
{
LocationId = int.Parse(id),
Code = no,
Name = name,
UpdateBy = 1,
UpdateDatetime = DateTime.Now
};
DbEntityEntry <Location> entry = entities.Entry <Location>(local);
entry.State = System.Data.EntityState.Unchanged;
entry.Property("Code").IsModified = true;
entry.Property("Name").IsModified = true;
entry.Property("UpdateBy").IsModified = true;
entry.Property("UpdateDatetime").IsModified = true;
try
{
flag = entities.SaveChanges();
}
catch (Exception ex)
{
ex.ToString();
}
}
return(flag);
}
/**删除餐桌,逻辑删除**/
public bool DeleteTable(int tableId)
{
try
{
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
IShow.ChooseDishes.Data.Table table = new IShow.ChooseDishes.Data.Table();
table.TableId = tableId;
DbEntityEntry <IShow.ChooseDishes.Data.Table> entry = entities.Entry <IShow.ChooseDishes.Data.Table>(table);
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)
{
return(true);
}
else
{
return(false);
}
}
}
catch (Exception e)
{
throw e;
}
}
//根据做法类型编码删除菜品做法类型,如果删除失败返回false，如果删除成功，则返回true
public bool DeleteDischesWayName(int id)
{
//先判断是否存在有做法，如果有做法，则不能返回false
DischesWayDataService odws = new DischesWayDataService();
List <DischesWay> orgDischesWay = odws.FindAllDischesWay(id);
if (orgDischesWay != null)
{
return(false);
}
//删除
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
DischesWayName booktype = new DischesWayName()
{
DischesWayNameId = id,
};
DbEntityEntry <DischesWayName> entry = entities.Entry <DischesWayName>(booktype);
entry.State = System.Data.EntityState.Deleted;
entities.SaveChanges();
var newtype = entities.DischesWayName.SingleOrDefault(bt => bt.DischesWayNameId == id);
if (newtype != null)
{
//Console.WriteLine(newtype.name);
return(false);
}
else
{
//Console.WriteLine("No Found");
return(true);
}
}
}
//删除外卖单
public bool DeletedTakeoutOrder(int id)
{
if (id < 0)
{
return(false);
}
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
try
{
TakeoutOrder booktype = new TakeoutOrder()
{
TakeoutId = id,
};
DbEntityEntry <TakeoutOrder> entry = entities.Entry <TakeoutOrder>(booktype);
entry.State = EntityState.Deleted;
entities.SaveChanges();
return(true);
}
catch (Exception e)
{
e.ToString();
return(false);
}
}
}
/// <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>
/// 根据指定日期删除创建日期比该日期小的日志
/// deleted SystemLog object from table SystemLog where StartDate less than the parameter date
/// </summary>
/// <param name="date">日期</param>
public void DeleteByDate(DateTime date)
{
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
List <SystemLog> _books;
_books = entities.SystemLog.Where(book => book.CreateDatetime.CompareTo(date) < 0).ToList();
if (_books != null)
{
foreach (var bk in _books)
{
DbEntityEntry <SystemLog> entry = entities.Entry <SystemLog>(bk);
entry.State = EntityState.Deleted;
}
}
entities.SaveChanges();
}
}
//删除折扣方案明细
public bool DeleteDetail(int typeId)
{
bool flag = true;
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
Expression <Func <DiscountDetail, bool> > checkCourse = Detail => Detail.DiscountId == typeId && Detail.Deleted == 0;
//先查询 后修改
List <DiscountDetail> type = entities.DiscountDetail.Where(checkCourse).ToList();
if (type != null && type.Count > 0)
{
foreach (var t in type)
{
t.UpdateBy = SubjectUtils.GetAuthenticationId();
t.UpdateDatetime = DateTime.Now;
t.Deleted = 1;
//直接修改的方式
DbEntityEntry <DiscountDetail> entry = entities.Entry <DiscountDetail>(t);
entry.State = System.Data.Entity.EntityState.Modified;
//设置修改状态为ture 否则数据库不会更新
entry.Property("UpdateBy").IsModified = true;
entry.Property("Deleted").IsModified = true;
entry.Property("UpdateDatetime").IsModified = true;
try
{
//关闭实体验证，不关闭验证需要整个对象全部传值
entities.Configuration.ValidateOnSaveEnabled = false;
var result = entities.SaveChanges();
entities.Configuration.ValidateOnSaveEnabled = true;
if (result <= 0)
{
return(false);
}
}
catch (Exception ex)
{
ex.ToString();
}
}
}
return(flag);
}
}
/**根据指定编码删除对应做法*/
public bool DeleteDischesWay(int id)
{
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
var type = entities.DischesWay.SingleOrDefault(bt => bt.DischesWayId == id);
if (type == null)
{
return(false);
}
DischesWay booktype = new DischesWay()
{
DischesWayId = id,
};
DbEntityEntry <DischesWay> entry = entities.Entry <DischesWay>(booktype);
entry.State = System.Data.EntityState.Deleted;
entities.SaveChanges();
return(true);
}
}
public bool UpdateType(DishType type)
{
try
{
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
DbEntityEntry <DishType> entry = entities.Entry <DishType>(type);
entry.State = System.Data.Entity.EntityState.Unchanged;//Modified
entry.Property("Name").IsModified = true;
entry.Property("Status").IsModified = true;
entry.Property("UpdateDatetime").IsModified = true;
entry.Property("UpdateBy").IsModified = true;
//TODO 如果更新状态为“删除”则要检查是否关联了菜品
try
{
entities.Configuration.ValidateOnSaveEnabled = false;
int result = entities.SaveChanges();
entities.Configuration.ValidateOnSaveEnabled = true;
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
return(false);
}
}
}
catch (Exception e)
{
throw e;
}
}
public bool UpdateTable(IShow.ChooseDishes.Data.Table table)
{
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
DbEntityEntry <IShow.ChooseDishes.Data.Table> entry = entities.Entry <IShow.ChooseDishes.Data.Table>(table);
entry.State = System.Data.Entity.EntityState.Unchanged;//Modified
entry.Property("Name").IsModified = true;
entry.Property("Seat").IsModified = true;
entry.Property("TableTypeId").IsModified = true;
entry.Property("LocationId").IsModified = true;
entry.Property("Status").IsModified = true;
//TODO 是否已经启用，已启用则不能删除
entry.Property("TableId").IsModified = false;
try
{
entities.Configuration.ValidateOnSaveEnabled = false;
int result = entities.SaveChanges();
entities.Configuration.ValidateOnSaveEnabled = true;
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
return(false);
}
}
}
public bool DeleteType(int typeId)
{
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
DishType type = new DishType();
type.DishTypeId = typeId;
type.Deleted = 1;
DbEntityEntry <DishType> entry = entities.Entry <DishType>(type);
entry.State = System.Data.Entity.EntityState.Unchanged;//Modified
entry.Property("Deleted").IsModified = true;
entry.Property("DishTypeId").IsModified = false;
entities.Configuration.ValidateOnSaveEnabled = false;
var result = entities.SaveChanges();
entities.Configuration.ValidateOnSaveEnabled = true;
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
}