public SqlConnection myConnection;
public SqlCommand myCommand;
public SqlDataSource myDs;
public SqlDataAdapter myAdapter;
public SqlDataReader myReader;
public SqlParameter Para_PageCount, Para_DataCounts,getReturnValue;
public SqlCommandBuilder myCommandBuilder;
public DataSet ds;
public DataTable dt;
public DataRow dr;
public XmlDataSource xmlDs;
public XmlDataDocument xmldataDoc;
public XmlReader xmlReader;
public XmlDocument xmlDoc;
public Int32 PageCount, DataCounts;
public string filename, myLinkUrl;
public int filesize;
public ulong[] Crc32Table;
public string[] TypeList = new string[100];
public string Connections;
/// <summary>
/// 执行存储过程的分页函数
/// </summary>
/// <param name="_dataKey">主键</param>
/// <param name="_tblName">表名称</param>
/// <param name="_getFields">获取的列名称</param>
/// <param name="_pageSize">每页记录数</param>
/// <param name="_page">选择的页码</param>
/// <param name="_sortName">排序的字段</param>
/// <param name="_sortType">排序类型</param>
/// <param name="_searchCondition">查询条件</param>
public void ExePageProcedure(string _dataKey, string _tblName, string _getFields, int _pageSize, int _page, string _sortName, string _sortType, string _searchCondition)
{
Open();
myCommand = new SqlCommand("Proc_Pagination", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("@keyName", SqlDbType.NVarChar, 255);
myCommand.Parameters["@keyName"].Value = _dataKey;
myCommand.Parameters.Add("@tblName", SqlDbType.NVarChar, 255);
myCommand.Parameters["@tblName"].Value = _tblName;
myCommand.Parameters.Add("@strGetFields", SqlDbType.NVarChar, 1000);
myCommand.Parameters["@strGetFields"].Value = _getFields;
myCommand.Parameters.Add("@PageSize", SqlDbType.Int);
myCommand.Parameters["@PageSize"].Value = _pageSize;
myCommand.Parameters.Add("@PageIndex", SqlDbType.Int);
myCommand.Parameters["@PageIndex"].Value = _page;
Para_PageCount = myCommand.Parameters.Add("@PageCount", SqlDbType.Int);
Para_PageCount.Direction = ParameterDirection.Output;
Para_DataCounts = myCommand.Parameters.Add("@DataCount", SqlDbType.Decimal);
Para_DataCounts.Direction = ParameterDirection.Output;
myCommand.Parameters.Add("@SortName", SqlDbType.NVarChar, 255);
myCommand.Parameters["@SortName"].Value = _sortName;
myCommand.Parameters.Add("@SortType", SqlDbType.NVarChar, 255);
myCommand.Parameters["@SortType"].Value = _sortType;
myCommand.Parameters.Add("@SearchCondition", SqlDbType.NVarChar, 1000);
myCommand.Parameters["@SearchCondition"].Value = _searchCondition;
myReader = myCommand.ExecuteReader();
}