/// <summary>
/// 新增
/// </summary>
/// <param name="car">实体对象</param>
/// <returns></returns>
public override int Insert(CarBrandEntity car)
{
int id = 0;
var list = this.QueryList(car);
if (list.Any())
{
car.BrandLogo = list[0].BrandLogo;
this.Update(car);
id = list[0].Id;
}
else
{
id = CarDataAccess.Insert(
"INSERT INTO hengtu_carbrand(rid,url,brand,logo,tagname,add_time)VALUES(@Rid,@Url,@BrandName,@BrandLogo,@TagName,@AddTime)",
new
{
car.Rid,
car.Url,
car.BrandName,
car.BrandLogo,
car.AddTime
});
}
ShowInfoEventHandler?.Invoke(this, new ViewModelArg <CarBrandEntity> {
Car = car, Type = list.Any() ? 0 : 1
});
return(car.Id = id);
}
/// <summary>
/// 新增
/// </summary>
/// <param name="car">实体对象</param>
/// <returns></returns>
public override int Insert(CarSeriesEntity car)
{
int id = 0;
var list = this.QueryList(car);
if (list.Any())
{
this.Update(car);
id = list[0].Id;
}
else
{
id = CarDataAccess.Insert(
"INSERT INTO hengtu_carmodeldetail(modelid,model,linkurl,reference_price,full_payment_reference,msrp,add_time)" +
"VALUES(@ModelId,@SeriesName,@LinkUrl,@ReferencePrice,@FullPaymentReference,@Msrp,@AddTime)",
new
{
car.ModelId,
car.SeriesName,
car.LinkUrl,
car.ReferencePrice,
car.FullPaymentReference,
car.Msrp,
DateTime.Now,
});
}
ShowInfoEventHandler?.Invoke(this, new ViewModelArg <CarSeriesEntity> {
Car = car, Type = list.Any() ? 0 : 1
});
return(car.Id = id);
}
/// <summary>
/// Handles a show info event raised by a sender.
/// Bubbles up the event to the ShowInfoEventHandler.
/// </summary>
/// <param name="sender">sender of event</param>
/// <param name="e">show message event arguments</param>
protected virtual void HandleShowInfo(object sender, ShowMessageEventArgs e)
{
ShowInfoEventHandler handler = this.ShowInfo;
if (handler != null)
{
handler(this, e);
}
}
/// <summary>
/// Raises this object's show info event.
/// </summary>
/// <param name="message">message</param>
/// <param name="caption">caption</param>
/// <param name="supplementMsg">(optional)supplemental message</param>
protected virtual void OnShowInfo(string message, string caption = null, string supplementMsg = null)
{
ShowInfoEventHandler handler = this.ShowInfo;
if (handler != null)
{
var args = new ShowMessageEventArgs(message, caption, supplementMsg);
handler(this, args);
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="car">实体对象</param>
/// <returns></returns>
public override int Insert(CarModelEntity car)
{
int id = 0;
var list = this.QueryList(car);
if (list.Any())
{
car.ModelName = list[0].ModelName;
this.Update(car);
id = list[0].Id;
}
else
{
id = CarDataAccess.Insert(
"INSERT INTO hengtu_carmodel(brandid,model,linkurl,factory,image,add_time,national_reference_price,msrp,second_hand,displacement,fuel_consumption,gearbox,warranty)" +
"VALUES(@BrandId,@ModelName,@LinkUrl,@Factory,@ImagePath,@AddTime,@NationalReferencePrice,@Msrp,@SecondHand,@Displacement,@FuelConsumption,@Gearbox,@Warranty)",
new
{
car.BrandId,
car.ModelName,
car.LinkUrl,
car.Factory,
car.ImagePath,
car.AddTime,
car.NationalReferencePrice,
car.Msrp,
car.SecondHand,
car.Displacement,
car.FuelConsumption,
car.Gearbox,
car.Warranty
});
}
ShowInfoEventHandler?.Invoke(this, new ViewModelArg <CarModelEntity> {
Car = car, Type = list.Any() ? 0 : 1
});
return(car.Id = id);
}
