/**根据做法对象id作为参数修改做法 type.Name = odw.Name; type.Status = odw.Status; type.UpdateBy = odw.UpdateBy; //修改人编号 type.UpdateDatetime = odw.UpdateDatetime; //修改时间 type.WayDetail = odw.WayDetail; type.DischesWayId = odw.DischesWayId; type.AddPrice = odw.AddPrice; type.AddPriceByNum = odw.AddPriceByNum; type.Deleted = odw.Deleted; type.PingYing = odw.PingYing; */ public bool UpdateDischesWay(DischesWay odw) { if (odw == null) { return false; } //修改 直接修改 using (ChooseDishesEntities entities = new ChooseDishesEntities()) { var type = entities.DischesWay.SingleOrDefault(bt => bt.DischesWayId == odw.DischesWayId); if (type != null) { type.Name = odw.Name; type.Status = odw.Status; type.UpdateBy = odw.UpdateBy; type.UpdateDatetime = odw.UpdateDatetime; type.WayDetail = odw.WayDetail; type.DischesWayId = odw.DischesWayId; type.AddPrice = odw.AddPrice; type.AddPriceByNum = odw.AddPriceByNum; type.Deleted = odw.Deleted; type.PingYing = odw.PingYing; } entities.SaveChanges(); var newtype = entities.DischesWay.SingleOrDefault(bt => bt.DischesWayId == odw.DischesWayId); if (newtype != null) { return true; } } return false; }
public int addLocation(string name, string no) { int flag = 0; using (ChooseDishesEntities entities = new ChooseDishesEntities()) { Location local = new Location() { Code = no, Name = name, CreateDatetime=DateTime.Now, CreateBy=1, Deleted=0, Status=0 }; entities.Location.Add(local); try { flag = entities.SaveChanges(); } catch (Exception ex) { ex.ToString(); } } return flag; }
//根据做法类型编码删除菜品做法类型,如果删除失败返回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 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; }
//修改菜品做法类型,传入的参数需要包含:DischesWayNameId/Code,Name,Status,Deleted,UpdateBy,UpdateDatetime字段 public bool UpdateDischesWayName(DischesWayName dwn) { //修改 直接修改 using (ChooseDishesEntities entities = new ChooseDishesEntities()) { var type = entities.DischesWayName.SingleOrDefault(bt => bt.DischesWayNameId == dwn.DischesWayNameId); if (type != null) { type.Name = dwn.Name; type.Status = dwn.Status; type.UpdateBy = dwn.UpdateBy; type.UpdateDatetime = dwn.UpdateDatetime; type.Deleted = dwn.Deleted; } entities.SaveChanges(); var newtype = entities.DischesWayName.SingleOrDefault(bt => bt.DischesWayNameId == dwn.DischesWayNameId); if (newtype != null) { return true; } } return false; }
public List<Location> queryByLocation() { List<Location> local; using (ChooseDishesEntities entities = new ChooseDishesEntities()) { local = entities.Location.Where(Location => Location.Deleted==0).ToList(); } return local; }
/**添加做法,传入的对象需要封装如下信息 DischesWayId=1, DischesWayNameId=2, //做法类型id CreateDatetime=DateTime.Now, //创建时间 CreateBy=1, //创建人编号 Code=1, //做法编码 AddPrice=2, //是否加价,默认为0 Deleted=0, //是否删除 Name="三分熟加辣", //做法名称 Status=0, //状态 AddPriceByNum=0, //是否按照分数加价 PingYing="sfsjl", //做法拼音 WayDetail="要三分熟就可以了" //做法说明(非必填) */ public bool AddDischesWay(DischesWay odw) { //添加 using (ChooseDishesEntities entities = new ChooseDishesEntities()) { entities.DischesWay.Add(odw); entities.SaveChanges(); var type = entities.DischesWay.SingleOrDefault(bt => bt.DischesWayId == odw.DischesWayId); if (type != null) { return true; } } return false; }
//删除收银方式 返回true 为修改成功 public bool deleteCashType(int Id) { try { using (ChooseDishesEntities entities = new ChooseDishesEntities()) { var type = entities.CashType.SingleOrDefault(bt => bt.Id == Id); if (type != null) { type.Deleted = 1; entities.SaveChanges(); } else { return false; } } return true; } catch (Exception e) { e.ToString(); return false; } }
//修改收银方式 返回修改成功后的方式 public CashType updateCashType(CashType cashType) { try { if (cashType == null || cashType.Id == null) { return null; } using (ChooseDishesEntities entities = new ChooseDishesEntities()) { var type = entities.CashType.SingleOrDefault(bt => bt.Id == cashType.Id); if (type != null) { type.IsBillIncome = cashType.IsBillIncome; type.IsPaid = cashType.IsPaid; type.IsPrivilege = cashType.IsPrivilege; type.IsScore = cashType.IsScore; type.KeepRecharge = cashType.KeepRecharge; type.Keys = cashType.Keys; type.LossesUsing = cashType.LossesUsing; type.Name = cashType.Name; type.Rate = cashType.Rate; type.ReceptionUseing = cashType.ReceptionUseing; type.RechargeUsing = cashType.RechargeUsing; type.Status = cashType.Status; type.SupplierUsing = cashType.SupplierUsing; type.UpdateBy = type.UpdateBy; type.UpdateDatetime = DateTime.Now; type.UseingKeys = cashType.UseingKeys; entities.SaveChanges(); } } return cashType; } catch (Exception e) { e.ToString(); return null; } }
//添加收银方式 返回添加成功后的收银方式 public CashType addCashType(CashType cashType) { try { if (cashType == null) { return null; } CashType newCashType = null; using (ChooseDishesEntities entities = new ChooseDishesEntities()) { var type = entities.CashType.SingleOrDefault(bt => bt.Code == cashType.Code); if (type != null) { return null; } entities.CashType.Add(cashType); entities.SaveChanges(); var typenew = entities.CashType.SingleOrDefault(bt => bt.Code == cashType.Code); if (typenew != null) { newCashType = type; } } return newCashType; } catch (Exception e) { e.ToString(); return null; } }
///////////////////////////////////////////////////////////////////////////////// //////////////////////////////////////// 滕海东 //////////////////////////////// //加载所有的收银方式 传入收银类型编号 public List<CashType> findCashType(int CashBaseTypeId) { List<CashType> list; using (ChooseDishesEntities entities = new ChooseDishesEntities()) { if (CashBaseTypeId == 0) { list = entities.CashType.ToList(); } else { list = entities.CashType.Where(CashType => CashType.CashBaseTypeId == CashBaseTypeId).ToList(); } } return list; }
public List<Bearing> queryByBearing() { List<Bearing> bear; using (ChooseDishesEntities entities = new ChooseDishesEntities()) { bear = entities.Bearing.Where(Bearing => Bearing.Deleted == 0).ToList(); } return bear; }
/**根据指定编码删除对应做法*/ 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 List<DischesWay> FindAllDischesWay(int wayId) { List<DischesWay> odws; using (ChooseDishesEntities entities = new ChooseDishesEntities()) { odws = entities.DischesWay.Where(dw => dw.DischesWayId == wayId).ToList(); } if (odws != null&&odws.Count>0) { return odws; } return null; }
//查询菜品做法类型 public List<DischesWayName> FindAllDischesWayName() { List<DischesWayName> dws; using (ChooseDishesEntities entities = new ChooseDishesEntities()) { dws = entities.DischesWayName.Where(dw => dw.DischesWayNameId > 0).ToList(); } if (dws != null) { return dws; } return null; }
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 int addBearing(string name, string no) { int flag = 0; using (ChooseDishesEntities entities = new ChooseDishesEntities()) { Bearing bear = new Bearing() { Code = int.Parse(no), Name = name, CreateDatetime = DateTime.Now, CreateBy = 1, Deleted = 1, Status = 1 }; entities.Bearing.Add(bear); try { flag = entities.SaveChanges(); } catch (Exception ex) { ex.ToString(); } } return flag; }