/// <summary>
/// 分页
/// </summary>
/// <param name="TableViewName"></param>
/// <param name="Key"></param>
/// <param name="SelectStr"></param>
/// <param name="Criteria"></param>
/// <param name="Sort"></param>
/// <param name="CurrentPage"></param>
/// <param name="PageSize"></param>
/// <param name="TotalCount"></param>
/// <returns></returns>
public DataTable GetListT(string TableViewName, string Key, string SelectStr, string Criteria, string Sort, ref long CurrentPage, long PageSize, ref long TotalCount)
{
DataTable dt = null;
SqlParameter[] parameters =
{
new SqlParameter("@TableViewName", SqlDbType.VarChar, 255),
new SqlParameter("@Key", SqlDbType.VarChar, 50),
new SqlParameter("@SelectStr", SqlDbType.VarChar, 500),
new SqlParameter("@Criteria", SqlDbType.VarChar, 8000),
new SqlParameter("@Sort", SqlDbType.VarChar, 255),
new SqlParameter("@Page", SqlDbType.BigInt),
new SqlParameter("@CurrentPageRow", SqlDbType.BigInt),
new SqlParameter("@TotalCount", SqlDbType.BigInt)
};
parameters[0].Value = TableViewName;
parameters[1].Value = Key;
parameters[2].Value = SelectStr;
parameters[3].Value = Criteria;
parameters[4].Value = Sort;
parameters[5].Direction = ParameterDirection.InputOutput;
parameters[5].Value = CurrentPage;
parameters[6].Value = PageSize;
parameters[7].Direction = ParameterDirection.InputOutput;
DataSet ds = crm.RunProcedureShow("GetDataList", parameters, "ds");
if (ds == null)
{
return(null);
}
dt = ds.Tables["ds"];
if (dt != null)
{
if (PageSize > 0)
{
TotalCount = Convert.ToInt64(parameters[7].Value);
CurrentPage = Convert.ToInt64(parameters[5].Value);
}
else
{
TotalCount = Convert.ToInt64(dt.Rows.Count);
if (TotalCount > 0)
{
CurrentPage = 1;
}
else
{
CurrentPage = 0;
}
}
}
return(dt);
}