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