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