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