public int DeleteDeliveryStorePlace(DeliveryStorePlaceQuery query) { try { return dao.DeleteDeliveryStorePlace(query); } catch (Exception ex) { throw new Exception("DeliveryStorePlaceMgr-->DeleteDeliveryStorePlace-->" + ex.Message, ex); } }
public int DeleteDeliveryStorePlace(DeliveryStorePlaceQuery query) { StringBuilder sbAll = new StringBuilder(); sbAll.AppendFormat("delete from delivery_store_place where dsp_id in ({0})",query.dsp_ids); try { return dbaccess.execCommand(sbAll.ToString()); } catch (Exception ex) { throw new Exception("DeliveryStorePlaceDao-->DeleteDeliveryStorePlace-->" + ex.Message + "sql:" + sbAll.ToString(), ex); } }
public JsonResult DeleteDeliveryStorePlaceByIds() { string json = string.Empty; try { DeliveryStorePlaceQuery query = new DeliveryStorePlaceQuery(); DSPMgr = new DeliveryStorePlaceMgr(connectionString); if (!string.IsNullOrEmpty(Request.Form["rid"])) { query.dsp_ids = Request.Form["rid"].TrimEnd(','); if (DSPMgr.DeleteDeliveryStorePlace(query) > 0) { return Json(new { 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); json = "{success:true,totalCount:0,data:[]}"; } return Json(new { success = "false" }); }