/// <summary>
/// ��ҳ��ѯ
/// </summary>
/// <param name="recordCount">������� ��������</param>
/// <param name="criteria">��ѯ��������</param>
/// <param name="pageSize">ÿҳ��ʾ����</param>
/// <param name="pageIndex">��ǰҳ����</param>
/// <returns>����� ����</returns>
public IList<ModelCategory> QueryCategoryListPager(out string resultMsg, out decimal recordCount, CriteriaCategory.Pager criteria, int pageSize = 10, int pageIndex = 1)
{
recordCount = decimal.Zero;
resultMsg = string.Empty;
IList<ModelCategory> list = new List<ModelCategory>();
try
{
//�洢��������
string sql = "USP_CATEGORY_SELECT_SEARCH_PAGER";
//�������
IList<DBParameter> parm = new List<DBParameter>();
parm.Add(new DBParameter() { ParameterName = "PageSize", ParameterValue = pageSize, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String });
parm.Add(new DBParameter() { ParameterName = "PageIndex", ParameterValue = pageIndex, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String });
parm.Add(new DBParameter() { ParameterName = "RowCount", ParameterInOut = BaseDict.ParmOut, ParameterType = DbType.String });
//��ѯִ��
using (IDataReader dr = DBHelper.ExecuteReader(sql, true, parm))
{
//DataReader ת���� List
list = GetModel(dr);
foreach (var item in parm)
{
//��ȡ�������ֵ
if (item.ParameterName == "RowCount")
{
decimal.TryParse(item.ParameterValue.ToString(), out recordCount);
break;
}
}
}
}
catch (Exception ex)
{
resultMsg = string.Format("{0} {1}", BaseDict.ErrorPrefix, ex.ToString());
}
return list;
}
public void SetCriteriaCategory(string text)
{
CriteriaCategory.SelectByText(text);
}
