/// <summary>
/// 新增promotionsamountfare的sql語句，用於事物的調用
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string SavePromoFare(PromotionsAmountFare model)
{
model.Replace4MySQL();
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat("insert into promotions_amount_fare (");
sql.AppendFormat("name,display,delivery_store,group_id,class_id,brand_id,category_id,product_id,type,amount,quantity,start,end,");
sql.AppendFormat("created,active,event_desc,event_type,condition_id,device,kuser,fare_percent,payment_code,off_times,url_by,site,modified,muser,status,vendor_coverage) values ");
sql.AppendFormat("('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}',{14},'{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}','{25}','{26}','{27}','{28}');select @@identity;",
model.name, model.display, model.delivery_store, model.group_id, model.class_id, model.brand_id,
model.category_id, model.product_id, model.type, model.amount, model.quantity, CommonFunction.DateTimeToString(model.start),
CommonFunction.DateTimeToString(model.end),
CommonFunction.DateTimeToString(model.created),
model.active ? 1 : 0, model.event_desc, model.event_type,
model.condition_id, model.device, model.kuser,
model.fare_percent, model.payment_code, model.off_times,
model.url_by, model.site, CommonFunction.DateTimeToString(model.modified), model.muser, model.status, model.vendor_coverage);
return sql.ToString();
}
catch (Exception ex)
{
throw new Exception("PromotionsAmountFareDao-->SavePromoFare-->" + ex.Message, ex);
}
}
/// <summary>
/// 根據編號獲取數據
/// </summary>
/// <param name="model">滿額滿件免運對象</param>
/// <returns>數據列表</returns>
public DataTable Select(PromotionsAmountFare model)
{
model.Replace4MySQL();
StringBuilder sb = new StringBuilder();
sb.Append(@" select id, name,display,delivery_store,group_id,class_id,brand_id,category_id,product_id,type,amount,quantity,start,end,
created,active,event_desc,event_type,condition_id,device,kuser,fare_percent,payment_code,off_times,url_by,
site,modified,muser,status,vendor_coverage from promotions_amount_fare where 1=1");
if (model.id != 0)
{
sb.AppendFormat(" and id='{0}';", model.id);
}
try
{
return _access.getDataTable(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("PromotionsAmountFareDao-->Select-->" + ex.Message + sb.ToString(), ex);
}
}