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