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