public static ReservationsEntity GetReservationsByID(long rid)
{
ReservationsRepository rr = new ReservationsRepository();
ReservationsInfo info = rr.GetReservationsInfoByID(rid);
return(TranslateReservationsEntity(info));
}
public int CreateNew(ReservationsInfo info)
{
DataCommand command = new DataCommand(ConnectionString, GetDbCommand(ReservationsStatement.InsertSql, "Text"));
command.AddInputParameter("@CustomerID", DbType.Int64, info.CustomerID);
command.AddInputParameter("@CustomerName", DbType.String, info.CustomerName);
command.AddInputParameter("@RType", DbType.String, info.RType);
command.AddInputParameter("@PayType", DbType.Int32, info.PayType);
command.AddInputParameter("@CarID", DbType.Int32, info.CarID);
command.AddInputParameter("@LeaseTime", DbType.Int32, info.LeaseTime);
command.AddInputParameter("@Price", DbType.Decimal, info.Price);
command.AddInputParameter("@Remark", DbType.String, info.Remark);
command.AddInputParameter("@RDate", DbType.DateTime, info.RDate);
command.AddInputParameter("@Status", DbType.Int32, info.Status);
command.AddInputParameter("@CreateDate", DbType.DateTime, info.CreateDate);
return(command.ExecuteNonQuery());
}
private static ReservationsInfo TranslateReservationsInfo(ReservationsEntity reservationsEntity)
{
ReservationsInfo info = new ReservationsInfo();
if (reservationsEntity != null)
{
info.ID = reservationsEntity.ID;
info.CustomerID = reservationsEntity.CustomerID;
info.CustomerName = reservationsEntity.CustomerName;
info.RType = reservationsEntity.RType;
info.PayType = reservationsEntity.PayType;
info.CarID = reservationsEntity.CarID;
info.LeaseTime = reservationsEntity.LeaseTime;
info.Price = reservationsEntity.Price;
info.Remark = reservationsEntity.Remark;
info.RDate = reservationsEntity.RDate;
info.Status = reservationsEntity.Status;
}
return(info);
}
private static ReservationsEntity TranslateReservationsEntity(ReservationsInfo info)
{
ReservationsEntity reservationsEntity = new ReservationsEntity();
if (info != null)
{
reservationsEntity.ID = info.ID;
reservationsEntity.CustomerID = info.CustomerID;
reservationsEntity.CustomerName = info.CustomerName;
reservationsEntity.RType = info.RType;
reservationsEntity.PayType = info.PayType;
reservationsEntity.CarID = info.CarID;
reservationsEntity.LeaseTime = info.LeaseTime;
reservationsEntity.Price = info.Price;
reservationsEntity.Remark = info.Remark;
reservationsEntity.RDate = info.RDate;
reservationsEntity.Status = info.Status;
CustomerEntity customer = null;//CustomerService.GetCustomerByID(info.CustomerID);
reservationsEntity.Customer = customer;
if (info.RType == "SJ" || info.RType == "ZL")//汽车预约
{
CarEntity car = CarService.GetCarEntityById(info.CarID);
reservationsEntity.Car = car;
}
else if (info.RType == "DZ")//充电桩预约
{
ChargingPileEntity chargingPile = ChargeService.GetChargingPileEntityById(info.CarID);
reservationsEntity.ChargingPile = chargingPile;
}
BaseDataEntity pay = BaseDataService.GetBaseDataByPCode("P00").FirstOrDefault(t => t.TypeCode == info.PayType) ?? new BaseDataEntity();
reservationsEntity.PayTypeInfo = pay;//支付信息
}
return(reservationsEntity);
}
public static bool AddReservations(ReservationsEntity entity)
{
int result = 0;
ReservationsRepository rR = new ReservationsRepository();
if (entity != null)
{
ReservationsInfo info = new ReservationsInfo();
info.CarID = entity.CarID;
info.CreateDate = DateTime.Now;
info.CustomerID = entity.CustomerID;
info.CustomerName = entity.CustomerName;
info.LeaseTime = entity.LeaseTime;
info.PayType = entity.PayType;
info.Price = entity.Price;
info.RDate = DateTime.Now;
info.Remark = entity.Remark;
info.RType = entity.RType;
info.Status = entity.Status;
result = rR.CreateNew(info);
}
return(result > 0);
}