.net多表查询分页存储过程，第一页正常，第二页..都出错
后台调用分页代码：
int currPage = 1;
int PageSize =40;
string tabeName = "TableOrders as a left join Customer as b on a.CustomerID=b.CustomerID left join UseCompanyIp as c on a.OrderID=c.OrderID left join Staff as e on a.StaffID=e.StaffID";
string strFide = "(a.RenewalFee+a.ModificationCost) AS moneycount,a.PaymentCycle,a.ModificationCost,a.SerialNumber,a.state,a.Technology,a.RenewalStatus,a.RenewalFee,a.OldExpirationDate,a.RenewalDate,a.OrderID,a.OrderDate,a.ExpirationDate,a.Remarks,a.StaffID,a.CustomerID,a.PackageID,a.ProductID,b.CustomerName,b.Taofc,c.IpAddress,e.StaffName";
string strSortKey = "a.OrderID";
string strSortField = "a.ExpirationDate ";
public void Bind()
{
int pageCount;
int RecordCount;
Repeater1.DataSource = tableorder.GetPagetable(tabeName, strFide, PageSize,currPage, out pageCount, out RecordCount, strSortField, strSortKey);
Repeater1.DataBind();
this.AspNetPager1.RecordCount = RecordCount;
this.AspNetPager1.CurrentPageIndex = currPage;
this.AspNetPager1.PageSize = PageSize;
}
public DataTable GetPagetable(string TableNames, string Fields, int PageSize, int page, out int pageCount, out int RecordCount, string fldSort, string ID)
{
pageCount = 0;
RecordCount = 0;
DataTable datatable = new DataTable();
using (SqlConnection conn = new SqlConnection(SQLHelper.scon))
{
SqlCommand objcmd = new SqlCommand("proc_ListPage", conn);
objcmd.CommandType = CommandType.StoredProcedure;
SqlParameter[] para ={
new SqlParameter("@tblName",SqlDbType.VarChar,-1),
new SqlParameter("@fldName",SqlDbType.VarChar,-1),
new SqlParameter("@pageSize",SqlDbType.Int),
new SqlParameter("@page",SqlDbType.Int),
new SqlParameter("@pageCount",SqlDbType.Int),
new SqlParameter("@Counts",SqlDbType.Int),
new SqlParameter("@fldSort",SqlDbType.VarChar,-1),
new SqlParameter("@Sort",SqlDbType.Bit),
new SqlParameter("@ID",SqlDbType.VarChar,-1),
};
para[0].Value = TableNames;
para[1].Value = Fields;
para[2].Value = PageSize;
para[3].Value = page;
para[4].Value = pageCount;
para[4].Direction = ParameterDirection.Output;
para[5].Value = RecordCount;
para[5].Direction = ParameterDirection.Output;
para[6].Value = fldSort;
para[7].Value = 1;
para[8].Value = ID;
objcmd.Parameters.AddRange(para);
conn.Open();
SqlDataAdapter adapter = new SqlDataAdapter(objcmd);
adapter.Fill(datatable);
RecordCount = Convert.ToInt32(objcmd.Parameters["@Counts"].Value);
pageCount = Convert.ToInt32(objcmd.Parameters["@pageCount"].Value);
conn.Close();
conn.Dispose();
}
return datatable;
}
正常；第二页和其他页的错误直接上图：
SQL分页存储 