/// <summary>
/// 獲取滿額滿件送禮列表頁
/// </summary>
/// <param name="query">TrialProdCateQuery query對象 </param>
/// <param name="totalCount">輸出總行數</param>
/// <returns>List<Model.Query.TrialProdCateQuery>對象</returns>
public List<TrialProdCateQuery> Query(TrialProdCateQuery query, out int totalCount)
{
StringBuilder sql = new StringBuilder();
query.Replace4MySQL();
try
{
sql.Append(" select id,event_id,type,product_id,category_id,start_date,end_date from trial_prod_cate ");
sql.Append(" order by id desc ");
totalCount = 0;
if (query.IsPage)
{
System.Data.DataTable _dt = _access.getDataTable(sql.ToString());
if (_dt != null && _dt.Rows.Count > 0)
{
totalCount = _dt.Rows.Count;
}
sql.AppendFormat(" limit {0},{1}", query.Start, query.Limit);
}
sql.AppendFormat(";");
return _access.getDataTableForObj<TrialProdCateQuery>(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("TrialProdCateDao-->Query-->" + ex.Message + sql.ToString(), ex);
}
}
