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