public List<ProductCategorySet> QueryMsg(ProductCategorySetQuery queryModel) { try { StringBuilder strSql = new StringBuilder("select product_id,category_id,brand_id from product_category_set where 1=1 "); if (!string.IsNullOrEmpty(queryModel.product_ids)) { strSql.AppendFormat(" and product_id in ({0}) ", queryModel.product_ids); } if (queryModel.Category_Id != 0) { strSql.AppendFormat(" and category_id = {0} ", queryModel.Category_Id); } return _access.getDataTableForObj<ProductCategorySet>(strSql.ToString()); } catch (Exception ex) { throw new Exception("ProductCategorySetDao-->QueryMsg" + ex.Message, ex); } }
public List<ProductCategorySet> QueryMsg(ProductCategorySetQuery queryModel) { try { return _categorySetDao.QueryMsg(queryModel); } catch (Exception ex) { throw new Exception("ProductCategorySetMgr-->Query(ProductCategorySet QueryMsg)-->" + ex.Message, ex); } }