public bool UpdateRawUnitDeletedStatusById(int Id, int DeletedStatus)
{
if (Id < 0)
{
return false;
}
//修改 直接修改
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
try
{
var type = entities.RawUnit.SingleOrDefault(bt => bt.UnitId == Id);
if (type != null)
{
type.Deleted = DeletedStatus;
entities.SaveChanges();
return true;
}
}
catch (Exception e)
{
e.ToString();
return false;
}
return false;
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List<DishesMenu> QueryAll() {
using (ChooseDishesEntities entities = new ChooseDishesEntities()) {
return entities.DishesMenu.Where(bt=>bt.Deleted == 0 ).ToList();
}
}
public List<TableItem> GetAll()
{
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
return entities.TableItem.Include(typeof(Table).Name).Where(t => t.Deleted == 0).ToList();
}
}
//0添加失败，-1添加重复
public int addLocation(Location location)
{
int flag = 0;
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
//查询编码是否存在
var type = entities.Location.SingleOrDefault(bt => bt.Code == location.Code && bt.Deleted == 0);
if (type == null)
{
//实体绑定数据
entities.Location.Add(location);
try
{
//操作数据库
flag = entities.SaveChanges();
}
catch (Exception ex)
{
ex.ToString();
}
}
else
{
flag = -1;
}
}
return flag;
}
/// <summary>
/// 按参数所在模块查询
/// </summary>
/// <param name="domain"></param>
public List<Config> QueryByDomain(string domain)
{
using (ChooseDishesEntities entities = new ChooseDishesEntities()) {
return entities.Config.Where(c => c.Domain.Equals(domain)).ToList();
}
}
public bool UpdateRawUnit(RawUnit rw)
{
if (rw == null)
{
return false;
}
//修改 直接修改
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
try
{
var type = entities.RawUnit.SingleOrDefault(bt => bt.UnitId == rw.UnitId);
if (type != null)
{
type.Deleted = rw.Deleted;
type.Name = rw.Name;
type.Status = rw.Status;
type.UpdateBy = rw.UpdateBy;
type.UpdateDatetime = rw.UpdateDatetime;
entities.SaveChanges();
return true;
}
}
catch (Exception e)
{
e.ToString();
return false;
}
return false;
}
}
//根据外卖客户id修改外卖客户信息
public bool UpdateTakeoutClientInfo(TakeoutClientInfo info)
{
if (info == null)
{
return false;
}
//修改 直接修改
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
try
{
var type = entities.TakeoutClientInfo.SingleOrDefault(bt => bt.OrderPeopleId == info.OrderPeopleId);
if (type != null)
{
type.Order_people = info.Order_people;
type.Mobile = info.Mobile;
type.Status = info.Status;
type.Telephone = info.Telephone;
type.Update_by = info.Update_by;
type.Update_datetime = info.Update_datetime;
type.Address = info.Address;
type.Deleted = info.Deleted;
entities.SaveChanges();
return true;
}
}
catch (Exception e)
{
e.ToString();
return false;
}
return false;
}
}
//根据外卖客户id修改外卖客户Deleted状态
public bool UpdateTakeoutClientDeletedById(int id,int DeletedStatas)
{
if (id <0)
{
return false;
}
//修改 直接修改
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
try
{
var type = entities.TakeoutClientInfo.SingleOrDefault(bt => bt.OrderPeopleId == id);
if (type != null)
{
type.Deleted = DeletedStatas;
entities.SaveChanges();
return true;
}
}
catch (Exception e)
{
e.ToString();
return false;
}
return false;
}
}
//根据ID查询大类
public DishType LoadParentId(int? id)
{
try
{
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
DishType type = new DishType(); ;
if (id != null)
{
type = (DishType)entities.DishType.Where(info => info.DishTypeId == id && info.Deleted == 0 && info.Status == 0).Single();
if (type == null)
{
type = new DishType();
}
}
return type;
};
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List<DishesMenu> QueryAll() {
using (ChooseDishesEntities entities = new ChooseDishesEntities()) {
return entities.DishesMenu.ToList();
}
}
//新增桌类
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);
}
};
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="employeeId"></param>
public int Add(int employeeId,string username,string passwd) {
using (ChooseDishesEntities entities = new ChooseDishesEntities()) {
Employee employee = entities.Employee.Find(employeeId);
if (null == employee) {
throw new ServiceException("无法找到对应的员工，编号为：【"+employeeId+"】");
}
int authorId=SubjectUtils.GetAuthenticationId();
UserInfo _UserInfo = new UserInfo();
_UserInfo.EmployeeId = employeeId;
if (null != username || null!=passwd) {
_UserInfo.Username = username;
_UserInfo.Salt = CryptoUtils.GetSalt();
_UserInfo.Password = CryptoUtils.MD5Encrypt(passwd);
_UserInfo.CreateBy = SubjectUtils.GetAuthenticationId();
}
_UserInfo.CreateDatetime = DateTime.Now;
entities.UserInfo.Add(_UserInfo);
try
{
entities.SaveChanges();
Log.A(Loggers.USER_NEW, authorId, _UserInfo.UserId);
}catch(DbEntityValidationException e){
throw new ServiceException(e.Message);
}
return _UserInfo.UserId;
}
}
/// <summary>
/// 查询所有用户
/// </summary>
/// <returns></returns>
public List<UserInfo> QueryUsers() {
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
//查询所有非删除的
return entities.UserInfo.Where(t => t.Deleted == 0).ToList();
}
}
public List<Location> queryByLocation()
{
List<Location> local;
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
local = entities.Location.Where(Location => Location.Deleted == 0).ToList();
}
return local;
}
//查询所有折扣方案
public DiscountProgram queryById(int id)
{
DiscountProgram program;
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
program = entities.DiscountProgram.Where(Program => Program.Deleted == 0 && Program.Status == 0&& Program.DiscountId == id).Single();
}
return program;
}
//查询折扣方案明细
public List<DiscountDetail> queryByDetailId(int id)
{
List<DiscountDetail> program;
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
program = entities.DiscountDetail.Where(Detail => Detail.Deleted == 0 && Detail.Status == 0 && Detail.DiscountId == id).ToList();
}
return program;
}
//查询所有折扣方案
public List<DiscountProgram> queryAll()
{
List<DiscountProgram> program;
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
program = entities.DiscountProgram.Where(Program => Program.Deleted == 0 && Program.Status==0).ToList();
}
return program;
}
//TODO 建立与开台关联的关系和获取订单对象
public List<TableItem> GetDetailByTableId(int TableId)
{
List<TableItem> tis;
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
tis=entities.TableItem.Include(typeof(Table).Name).Include(typeof(DeskDishes).Name).Where(t => t.Deleted == 0&&t.TableId==TableId).ToList();
}
return tis;
}
public int Add(string code, string name)
{
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
DishesMenu menu = DishesMenuModel.build(code, name, 1000);
entities.DishesMenu.Add(menu);
entities.SaveChanges();
return menu.MenusId;
}
}
/// <summary>
/// 通过名称获取该值,该接口未查找到相应的值时，抛出异常
/// </summary>
/// <param name="name"></param>
/// <param name="domain"></param>
/// <returns></returns>
public Config Find(string name)
{
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
Config config = entities.Config.Single(c => c.Name.Equals(name));
if (null == config)
{
throw new NotFoundException("参数名【" + name + "】未找到匹配的项！");
}
return config;
}
}
public void Delete(int dishesMenuId)
{
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
var delObj=entities.DishesMenu.Find(dishesMenuId);
if (null == delObj) {
throw new NotFoundException();
}
entities.DishesMenu.Remove(delObj);
entities.SaveChanges();
}
}
/// <summary>
/// 更新指定的参数的值
///
/// </summary>
/// <param name="name"></param>
/// <param name="value"></param>
public void Update(string name, string value) {
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
Config config = entities.Config.Single(c => c.Name.Equals(name));
if (null == config) {
throw new NotFoundException("参数名【"+name+"】未找到匹配的项！");
}
config.Value = value;
entities.SaveChanges();
}
}
public void BatchRemoveDishes(int menuId, int[] dishesIds) {
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
for (int i = 0; i < dishesIds.Length; i++)
{
var id = dishesIds[i];
var type = entities.DishesMenuRef.SingleOrDefault(bt => bt.Deleted == 0 && bt.DishId == id && bt.MenusId == menuId);
if (type != null) {
string sql = " update DishesMenuRef set Deleted = 1 where DishId = " + id + " and MenusId = " +menuId;
entities.Database.ExecuteSqlCommand(sql);
}
}
}
}
public bool UpdateRawMaterial(RawMaterial rw)
{
if (rw == null)
{
return false;
}
//修改 直接修改
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
try
{
var type = entities.RawMaterial.SingleOrDefault(bt => bt.Id == rw.Id);
if (type != null)
{
type.CheckDay = rw.CheckDay;
type.Deleted = rw.Deleted;
type.Detail = rw.Detail;
type.Format = rw.Format;
type.FormulaUnit = rw.FormulaUnit;
type.InGoodsPrice = rw.InGoodsPrice;
type.InGoodsStock = rw.InGoodsStock;
type.InGoodsUnit = rw.InGoodsUnit;
type.IsWeight = rw.IsWeight;
type.MaterialName = rw.MaterialName;
type.OrderRawAdd = rw.OrderRawAdd;
type.Pinying = rw.Pinying;
type.Raw = rw.Raw;
type.RawAddPrice = rw.RawAddPrice;
type.SaleUnit = rw.SaleUnit;
type.Status = rw.Status;
type.StockFormula = rw.StockFormula;
type.StockMax = rw.StockMax;
type.StockMin = rw.StockMin;
type.StockUnit = rw.StockUnit;
type.UpdateBy = rw.UpdateBy;
type.UpdateDatetime = rw.UpdateDatetime;
type.WriteDowns = rw.WriteDowns;
entities.SaveChanges();
return true;
}
}
catch (Exception e)
{
e.ToString();
return false;
}
return false;
}
}
/// <summary>
///
/// </summary>
/// <param name="app"></param>
/// <param name="function"></param>
/// <param name="actor"></param>
/// <param name="itemId"></param>
/// <param name="message"></param>
/// <param name="args"></param>
public void Log(Format format,LogType type, int actor, int objectId,object[] args) {
SystemLog _Log = new SystemLog();
_Log.ItemId = Convert.ToString(objectId);
_Log.Actor = Convert.ToString(actor);
_Log.CreateDatetime = DateTime.Now;
_Log.Module = format.Function.Module.Name;
_Log.Function = format.Function.Name;
_Log.Body = LoggerUtils.Format(format, args);
_Log.OpType = Enum.GetName(typeof(LogType), type);
using (ChooseDishesEntities entities = new ChooseDishesEntities()) {
entities.SystemLog.Add(_Log);
entities.SaveChanges();
}
}
/***餐桌类型****/
#region
//查询所有桌类
public List<TableType> LoadAllTableType()
{
List<TableType> types;
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
types = entities.TableType.Where(
info => info.Deleted == 0
).ToList();
if (types == null || types.Count == 0)
{
types = new List<TableType>();
}
return types;
};
}
public bool ModifyStatus(int TableId, int Status)
{
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
var type = entities.TableItem.SingleOrDefault(bt => bt.Deleted == 0 && bt.TableId == TableId);
if (type != null)
{
type.UpdateBy = SubjectUtils.GetAuthenticationId();
type.UpdateDatetime = DateTime.Now;
type.Status = Status;
entities.SaveChanges();
return true;
}
return false;
}
}
public bool Add(int dishesId, int DishesWayId) {
try
{
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
entities.DischesWayRef.Add(GetDischesWayRef(dishesId, DishesWayId));
entities.SaveChanges();
return true;
}
}
catch (Exception ex)
{
ex.ToString();
throw new ServiceException("新增菜品做法关联失败");
}
}
public int Add(string code, string name)
{
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
var list = entities.DishesMenu.Where(t => t.Deleted == 0 && (t.Code == code || t.Name == name)).ToList();
if (list != null && list.Count > 0)
{
return 0;
}
DishesMenu menu = DishesMenuModel.build(code, name, SubjectUtils.GetAuthenticationId());
entities.DishesMenu.Add(menu);
entities.SaveChanges();
return menu.MenusId;
}
}
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;
};
}