public static DataTable GetTopicPageNationData(ref string[] pa) |
{ |
|
int totalCount = 0; //记返回总记录 |
int totalPageCoun = 0; //返回总页数 |
|
DataTable dt = new DataTable(); |
|
|
using (MySqlConnection conn = new MySqlConnection("Server = localhost; user id = admin; password = 'admin'; database = vrigo; pooling = false")) |
{ |
MySqlDataAdapter da = new MySqlDataAdapter(); |
MySqlCommand cmd = new MySqlCommand(); |
|
cmd.Connection = conn; |
conn.Open(); |
cmd.CommandText = "P_viewPage"; |
cmd.CommandType = CommandType.StoredProcedure; |
cmd.Parameters.Add("$TableName", MySqlDbType.VarChar, 200); |
cmd.Parameters.Add("$FieldList", MySqlDbType.VarChar, 2000); |
cmd.Parameters.Add("$PrimaryKey", MySqlDbType.VarChar, 100); |
cmd.Parameters.Add("$Where", MySqlDbType.VarChar, 1000); |
cmd.Parameters.Add("$Order", MySqlDbType.VarChar, 1000); |
cmd.Parameters.Add("$SortType", MySqlDbType.Int32); |
cmd.Parameters.Add("$RecorderCount", MySqlDbType.Int32); |
cmd.Parameters.Add("$PageSize", MySqlDbType.Int32); |
cmd.Parameters.Add("$PageIndex", MySqlDbType.Int32); |
cmd.Parameters.Add("$TotalCount", MySqlDbType.Int32); |
cmd.Parameters.Add("$TotalPageCount", MySqlDbType.Int32); |
|
cmd.Parameters["$TableName"].Value = "cdb_threads"; |
cmd.Parameters["$FieldList"].Value = "tid,fid,subject,authorid,replies,views"; |
cmd.Parameters["$PrimaryKey"].Value = "tid"; |
cmd.Parameters["$Where"].Value = "fid = 59"; |
cmd.Parameters["$Order"].Value = "asc"; |
cmd.Parameters["$SortType"].Value = 1; |
cmd.Parameters["$RecorderCount"].Value = 0; |
cmd.Parameters["$PageSize"].Value = 3; |
cmd.Parameters["$PageIndex"].Value = 1; |
|
cmd.Parameters["$TotalCount"].Direction = ParameterDirection.Output; |
cmd.Parameters["$TotalPageCount"].Direction = ParameterDirection.Output; |
cmd.ExecuteNonQuery(); |
da.SelectCommand = cmd; |
da.Fill(dt); |
totalCount = int.Parse(cmd.Parameters["$TotalCount"].Value.ToString()); |
totalPageCoun = int.Parse(cmd.Parameters["$TotalPageCount"].Value.ToString()); |
|
pa[0] = totalCount.ToString(); |
pa[1] = totalPageCoun.ToString(); |
|
|
} |
return dt; |
} |