public int DeleteModel(EventPromoAdditionalPriceGroupQuery model) { try { return dao.DeleteModel(model); } catch (Exception ex) { throw new Exception("EventPromoAdditionalPriceGroupMgr-->DeleteModel-->" + ex.Message, ex); } }
public int DeleteModel(EventPromoAdditionalPriceGroupQuery query) { StringBuilder sbAll = new StringBuilder(); try { sbAll.AppendFormat("set sql_safe_updates=0;delete from event_promo_additional_price_group where group_id in({0});set sql_safe_updates=1;",query.group_ids); return access.execCommand(sbAll.ToString()); } catch (Exception ex) { throw new Exception("EventPromoAdditionalPriceGroupDao-->DeleteModel-->" + ex.Message + sbAll.ToString(), ex); } }
public HttpResponseBase DelEventPromoAdditionalPriceGroup() { string jsonStr = "{success:false}"; try { EventPromoAdditionalPriceGroupQuery query = new EventPromoAdditionalPriceGroupQuery(); if (!string.IsNullOrEmpty(Request.Params["group_ids"])) { query.group_ids = Request.Params["group_ids"].TrimEnd(','); } epapgMgr = new EventPromoAdditionalPriceGroupMgr(mySqlConnectionString); if (epapgMgr.DeleteModel(query) > 0) { jsonStr = "{success:true}"; } } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; }