public int Update(TraHoldSeatCallBackLogEntity t, string[] properties = null) { using (BrightourDbContext db = new BrightourDbContext()) { return(db.Update(t, properties)); } }
public int Update(TraOrderEntity t, string[] properties = null) { using (BrightourDbContext db = new BrightourDbContext()) { return(db.Update(t, properties)); } }
public int Update(ContactIdentificationInfoEntity t, string[] properties = null) { using (BrightourDbContext db = new BrightourDbContext()) { return(db.Update(t, properties)); } }
public int Update(CorpDepartmentEntity t, string[] properties = null) { using (BrightourDbContext db = new BrightourDbContext()) { return(db.Update(t, properties)); } }
public bool CheckIsExistSameTravel(List <DateTime> startTimeList, List <DateTime> endTimeList, List <string> startNameList, List <string> endNameList, List <string> nameList) { using (BrightourDbContext db = new BrightourDbContext()) { DateTime beginTime = DateTime.Now.AddYears(-1); var select = from order in db.TraOrder.AsNoTracking() join orderStatus in db.TraOrderStatus.AsNoTracking() on order.OrderId equals orderStatus.OrderId join detail in db.TraOrderDetail.AsNoTracking() on order.OrderId equals detail.OrderId join passenger in db.TraPassenger.AsNoTracking() on detail.OdId equals passenger.OdId where orderStatus.IsCancle == 0 && order.OrderType == 1 && startTimeList.Any(x => x == detail.StartTime) && endTimeList.Any(x => x == detail.EndTime) && startNameList.Any(x => x == detail.StartName) && endNameList.Any(x => x == detail.EndName) && nameList.Any(x => x == passenger.Name) && order.CreateTime > beginTime select order.OrderId; //List<int> orderIdList = select.ToList(); if (select.Any()) { OrderList = select.Distinct().ToList(); return(true); } } return(false); }
public TraModOrderDetailEntity Query(int id) { using (BrightourDbContext db = new BrightourDbContext()) { var result = db.TraModDetail.Where(n => n.TravelId == id).ToList(); return(result.First()); } }
public TraHoldSeatCallBackLogEntity Query(int id) { using (BrightourDbContext db = new BrightourDbContext()) { var result = db.TraHoldSeatCallBackLog.Where(n => n.LogId == id).ToList(); return(result.First()); } }
public AccountEntity Query(int id) { using (BrightourDbContext db = new BrightourDbContext()) { var result = db.AccountInfo.Where(n => n.Aid == id).ToList(); return(result.First()); } }
public ProjectNameEntity Query(int id) { using (BrightourDbContext db = new BrightourDbContext()) { var result = db.ProjectNameInfo.FirstOrDefault(n => n.ProjectId == id); return(result); } }
public List <Tra12306AccountEntity> GeTraAddressByExpression(Expression <Func <Tra12306AccountEntity, bool> > predicate) { using (BrightourDbContext db = new BrightourDbContext()) { var result = db.Tra12306AccountEntity.Where(predicate).ToList(); return(result); } }
public Tra12306AccountEntity Query(int id) { using (BrightourDbContext db = new BrightourDbContext()) { var result = db.Tra12306AccountEntity.Where(n => n.PassId == id).ToList(); return(result.First()); } }
public List <TraInterFaceOrderEntity> GetInterFaceOrderListByExpression(Expression <Func <TraInterFaceOrderEntity, bool> > predicate) { using (BrightourDbContext db = new BrightourDbContext()) { var result = db.InterFaceOrder.Where(predicate).ToList(); return(result); } }
public TraOrderEntity Query(int id) { using (BrightourDbContext db = new BrightourDbContext()) { var result = db.TraOrder.Where(n => n.OrderId == id).ToList(); return(result.First()); } }
public int Insert(ContactInfoEntity t) { using (BrightourDbContext db = new BrightourDbContext()) { var log = db.ContactInfo.Add(t); db.SaveChanges(); return(log.Contactid); } }
public int Insert(TraAddressEntity t) { using (BrightourDbContext db = new BrightourDbContext()) { var log = db.TraAddress.Add(t); db.SaveChanges(); return(log.Aid); } }
public int Insert(TraHoldSeatCallBackLogEntity t) { using (BrightourDbContext db = new BrightourDbContext()) { var log = db.TraHoldSeatCallBackLog.Add(t); db.SaveChanges(); return(log.LogId); } }
public int Insert(Tra12306AccountEntity t) { using (BrightourDbContext db = new BrightourDbContext()) { var log = db.Tra12306AccountEntity.Add(t); db.SaveChanges(); return(log.PassId); } }
public int Insert(AccountEntity t) { using (BrightourDbContext db = new BrightourDbContext()) { var log = db.AccountInfo.Add(t); db.SaveChanges(); return(log.Aid); } }
public int Insert(TraModOrderDetailEntity t) { using (BrightourDbContext db = new BrightourDbContext()) { var log = db.TraModDetail.Add(t); db.SaveChanges(); return(log.TravelId); } }
public int Insert(TraOrderEntity t) { using (BrightourDbContext db = new BrightourDbContext()) { var log = db.TraOrder.Add(t); db.SaveChanges(); return(log.OrderId); } }
public int Inster(RegisterCustomerEntity entity) { using (BrightourDbContext db = new BrightourDbContext()) { var log = db.RegisterCustomer.Add(entity); db.SaveChanges(); return(log.Id); } }
public ContactInfoEntity Query(int id) { using (BrightourDbContext db = new BrightourDbContext()) { var result = db.ContactInfo.Where(n => n.Contactid == id).ToList(); if (result.Count == 0) { return(null); } return(result.First()); } }
public CustomerInfoEntity GetCustomerByExpression(Expression <Func <CustomerInfoEntity, bool> > predicate) { using (BrightourDbContext db = new BrightourDbContext()) { var result = db.CustomerInfo.Where(predicate).ToList(); if (result.Count == 0) { return(null); } return(result.First()); } }
public TraModOrderEntity GetTraOrderExpression(Expression <Func <TraModOrderEntity, bool> > predicate) { using (BrightourDbContext db = new BrightourDbContext()) { var result = db.TraModOrder.Where(predicate).ToList(); if (result.Count == 0) { return(null); } return(result.First()); } }
public ServiceFeeConfigEntity GetServiceFeeConfigByExpression(Expression <Func <ServiceFeeConfigEntity, bool> > predicate) { using (BrightourDbContext db = new BrightourDbContext()) { var result = db.ServiceFeeConfig.Where(predicate).ToList(); if (result.Count == 0) { return(null); } return(result.First()); } }
public ServiceFeeConfigEntity Query(int id) { using (BrightourDbContext db = new BrightourDbContext()) { var result = db.ServiceFeeConfig.Where(n => n.SfcId == id).ToList(); if (result.Count == 0) { return(null); } return(result.First()); } }
public List <TraOrderStatusEntity> GetTraOrderStatusListByExpression(Expression <Func <TraOrderStatusEntity, bool> > predicate) { using (BrightourDbContext db = new BrightourDbContext()) { var result = db.TraOrderStatus.Where(predicate).ToList(); if (result.Count == 0) { return(null); } return(result); } }
/// <summary> /// 获取联系人集合信息 /// </summary> /// <param name="predicate"></param> /// <returns></returns> public List <ContactInfoEntity> GetContactInfoListByExpression(Expression <Func <ContactInfoEntity, bool> > predicate) { using (BrightourDbContext db = new BrightourDbContext()) { var result = db.ContactInfo.Where(predicate).ToList(); if (result.Count == 0) { return(null); } return(result); } }
//public QueryCityInofCNBll() //{ // _cityCN = new CTripHotelCityCNDal(); //} public Country Query() { Func <Country> QueryEntity = () => { using (BrightourDbContext context = new BrightourDbContext()) { var cities = from c in context.cTripHotelCityCNs join e in context.cTripHotelCityENs on c.CityId equals e.CityId select new { CityId = c.CityId, CityName = c.CityName, Country = c.Country, CountryName = c.CountryName, CurrentFlag = c.CurrentFlag, PCityId = c.PCityId, Province = c.Province, ProvinceName = c.ProvinceName, EName = e.CityName }; //var cities = _cityCN.Query<CTripHotelCityCNEntity>(a => a.CityId == a.CityId); var country = cities.First(); var result = new Country(); result.Id = country.Country; result.Name = country.CountryName; result.Provinces = new List <Province>(); foreach (var city in cities) { if (!result.Provinces.Where(a => a.Id == city.Province).Any()) { result.Provinces.Add(new Province() { Id = city.Province, Name = city.ProvinceName, Cities = new List <City>() }); } var province = result.Provinces.Where(a => a.Id == city.Province).First(); province.Cities.Add(new City() { Id = city.CityId, Name = city.CityName, EName = city.EName }); } return(result); }; }; return(CacheManager.Get <Country>(CacheKeyEnum.CTripHotelCityCN.ToString(), QueryEntity)); }
public int Delete(TraHoldSeatCallBackLogEntity t) { using (BrightourDbContext db = new BrightourDbContext()) { db.TraHoldSeatCallBackLog.Attach(t); db.TraHoldSeatCallBackLog.Remove(t); int i = db.SaveChanges(); //string sql = $"delete from dbo.Tra_HoldSeatCallBackLog where logid={t.LogId}"; //db.Database.ExecuteSqlCommand(sql); if (i > 0) { return(0); } return(-1); } }