Beispiel #1
0
        /// <summary>
        /// 调用分页的存储过程
        /// </summary>
        /// <returns></returns>
        public DataSet GetData()
        {
            dr.InitiCommand();
            dr.CommandText = "PROCE_PAGECHANGE";
            dr.CommandType = CommandType.StoredProcedure;

            dr.AddParameters("TableName", DbType.String, 50, TableName);
            dr.AddParameters("ReFieldsStr", DbType.String, 200, ReFieldsStr);
            dr.AddParameters("OrderString", DbType.String, 200, OrderString);
            dr.AddParameters("WhereString", DbType.String, 500, WhereString);
            dr.AddParameters("OnString", DbType.String, 500, OnString);
            dr.AddParameters("PageSize", DbType.Int32, PageSize);
            dr.AddParameters("PageIndex", DbType.Int32, PageIndex);
            dr.AddParameters("TotalRecord", DbType.Int32, 1);
            DbParameter Value = dr.AddParametersDirection("PageCount", DbType.Int32);

            DataSet data = dr.DataList();//.SqlInquiry(StoredProcedures, parameters);

            PageCount = int.Parse(Value.Value.ToString());
            return(data);
        }