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);
}
}
