Пример #1
0
 public string DeleteMarketProductMap(MarketProductMapQuery model)
 {
     model.Replace4MySQL();
     StringBuilder sql = new StringBuilder();
     try
     {
         sql.Append(@"delete from  market_product_map  where 1=1");
         if (model.map_id != 0)
         {
             sql.AppendFormat(" and map_id ='{0}'", model.map_id);
         }
         if (model.market_category_id != 0)
         {
             sql.AppendFormat(" and market_category_id ='{0}'", model.market_category_id);
         }
         sql.Append(";");
         return sql.ToString();
     }
     catch (Exception ex)
     {
         throw new Exception("MarketProductMapDao.DeleteNewPromoQuestion-->" + ex.Message + sql.ToString(), ex);
     }
 }