/// <summary> /// 分页查询 /// </summary> /// <param name="recordCount">输出参数 数据总数</param> /// <param name="criteria">查询条件对象</param> /// <param name="pageSize">每页显示数量</param> /// <param name="pageIndex">当前页索引</param> /// <returns>结果集 泛型</returns> public DataSet QueryDetaildataListPager(out string resultMsg, out decimal recordCount, CriteriaDetaildata criteria, int pageSize = 15, int pageIndex = 1) { recordCount = decimal.Zero; resultMsg = string.Empty; DataSet data = new DataSet(); try { //存储过程名称 string sql = "USP_DETAILDATA_SELECT_SEARCH_PAGER"; //参数添加 IList<DBParameter> parm = new List<DBParameter>(); parm.Add(new DBParameter() { ParameterName = "PagerSize", ParameterValue = pageSize, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "PagerIndex", ParameterValue = pageIndex, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String }); parm.Add(new DBParameter() { ParameterName = "RowCount", ParameterInOut = BaseDict.ParmOut, ParameterType = DbType.String }); //查询执行 using (data = DBHelper.ExecuteDataSet(sql, isStoredProc: true, parm: parm)) { 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 data; }
public DataSet QueryDetaildataListPager(out string resultMsg, out decimal recordCount, CriteriaDetaildata criteria, int pageSize = 10, int pageIndex = 1) { ILogicDetaildata logicData = new LogicDetaildata(); var data = logicData.QueryDetaildataListPager(out resultMsg, out recordCount, criteria, pageSize, pageIndex); return data; }