/// <summary>
/// 返回当页记录集(DataTable)跟记录总数
/// </summary>
/// <param name="page">当前页数</param>
/// <param name="pageSize">每页显示记录数</param>
/// <param name="field">字段</param>
/// <param name="sqlOrTable">SQL语句或者表名</param>
/// <param name="condition">条件</param>
/// <param name="order">排序</param>
/// <param name="connectString">连接串</param>
/// <returns>body</returns>
public static body GetListPager(int page, int pageSize, string field, string sqlOrTable, string condition, string order, string connectString)
{
Tools.body body = new Tools.body();
if ("" == field)
{
field = "*";
}
SqlParameter[] parm =
{
new SqlParameter("@PageCurr", page),
new SqlParameter("@PageSize", pageSize),
new SqlParameter("@Field", field),
new SqlParameter("@Table", sqlOrTable),
new SqlParameter("@Condition", condition),
new SqlParameter("@Order", order),
new SqlParameter("@RecordCount", SqlDbType.Int),
};
parm[6].Direction = ParameterDirection.Output;
body.dt = SqlHelper.ExecuteDataset(connectString, CommandType.StoredProcedure, "sp_Get_Current_Page_Record", parm).Tables[0];
body.count = (int)parm[6].Value;
return(body);
}
/// <summary>
/// 返回当页记录集(DataTable)跟记录总数
/// </summary>
/// <param name="strSQL">SQL语句</param>
/// <param name="strOrder">排序</param>
/// <param name="page">当前页数</param>
/// <param name="pagesize">每页显示记录数</param>
/// <param name="strConn">conn连接字符串</param>
/// <returns>DS</returns>
public static body CommonSQL(string strSQL, string strOrder, int page, int pagesize, string field, string strConn)
{
if ("" == field)
{
field = "*";
}
Tools.body body = new Tools.body();
DataSet DS = new DataSet();
SqlConnection conn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand("sp_Get_Current_Page_Record", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter parameter = cmd.Parameters.Add("@PageCurr", SqlDbType.Int);
parameter.Direction = ParameterDirection.Input;
parameter.Value = page;
SqlParameter parameter2 = cmd.Parameters.Add("@PageSize", SqlDbType.Int);
parameter2.Direction = ParameterDirection.Input;
parameter2.Value = pagesize;
SqlParameter parameter3 = cmd.Parameters.Add("@Field", SqlDbType.Int);
parameter3.Direction = ParameterDirection.Input;
parameter3.Value = field;
SqlParameter parameter4 = cmd.Parameters.Add("@Table", SqlDbType.NVarChar);
parameter4.Direction = ParameterDirection.Input;
parameter4.Value = strSQL;
SqlParameter parameter5 = cmd.Parameters.Add("@Condition", SqlDbType.NVarChar);
parameter5.Direction = ParameterDirection.Input;
parameter5.Value = "";
SqlParameter parameter6 = cmd.Parameters.Add("@Order", SqlDbType.NVarChar);
parameter6.Direction = ParameterDirection.Input;
parameter6.Value = strOrder;
SqlParameter parameter7 = cmd.Parameters.Add("@ReCordCount", SqlDbType.BigInt);
parameter7.Direction = ParameterDirection.Output;
conn.Open();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(DS);
adapter.Dispose();
cmd.Dispose();
conn.Close();
conn.Dispose();
body.dt = DS.Tables[0];
body.count = Convert.ToInt32(parameter7.Value.ToString());
DS.Dispose();
return(body);
}
