public string AddOrUpdate(EventPromoAdditionalPriceProduct model)
{
try
{
return dao.AddOrUpdate(model);
}
catch (Exception ex)
{
throw new Exception("EventPromoAdditionalPriceProductMgr-->AddOrUpdate-->" + ex.Message, ex);
}
}
public string AddOrUpdate(EventPromoAdditionalPriceProduct model)
{
StringBuilder sbStr = new StringBuilder();
try
{
if (model.row_id == 0)
{
sbStr.Append("insert into event_promo_additional_price_product(group_id,product_id,create_user,create_time,add_price,modify_user,modify_time,product_status)");
sbStr.AppendFormat("values({0},{1},{2},'{3}',{4},{5},'{6}',{7})", model.group_id, model.product_id, model.create_user, Common.CommonFunction.DateTimeToString(model.create_time), model.add_price, model.modify_user, Common.CommonFunction.DateTimeToString(model.modify_time), model.product_status);
}
else
{
sbStr.AppendFormat("update event_promo_additional_price_product set group_id={0},product_id={1},add_price={2},modify_user={3},modify_time='{4}',product_status={5} where row_id={6}", model.group_id, model.product_id, model.add_price, model.modify_user, Common.CommonFunction.DateTimeToString(model.modify_time), model.product_status, model.row_id);
}
return sbStr.ToString();
}
catch (Exception ex)
{
throw new Exception("EventPromoAdditionalPriceProductDao-->AddOrUpdate-->" + ex.Message + sbStr.ToString(), ex);
}
}