public static DataTable ProPager(ref PagerInfo pi, string connstr) { SqlParameter[] array = new SqlParameter[] { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@fldName", SqlDbType.VarChar, 255), new SqlParameter("@pageSize", SqlDbType.Int), new SqlParameter("@pageIndex", SqlDbType.Int), new SqlParameter("@IsReCount", SqlDbType.Bit), new SqlParameter("@OrderType", SqlDbType.Bit), new SqlParameter("@strWhere", SqlDbType.VarChar, 1000) }; array[0].Value = pi.Tablename; array[1].Value = pi.fldName; array[2].Value = pi.PageSize; array[3].Value = pi.PageIndex; array[4].Value = 1; bool flag = Operators.CompareString(pi.orderDirection, "asc", false) == 0; if (flag) { array[5].Value = 0; } else { array[5].Value = 1; } flag = (Operators.CompareString(pi.strwhere, "", false) == 0); if (flag) { pi.strwhere = "1=1"; } array[6].Value = pi.strwhere; DataSet dataSet = SqlHelper.ExecuteDataset(connstr, CommandType.StoredProcedure, "UP_GetRecordByPage", array); pi.TotalCount = Conversions.ToInteger(dataSet.Tables[0].Rows[0][0]); pi.PageCount = PagerHelper.PageCount(pi.TotalCount, pi.PageSize); return dataSet.Tables[1]; }
public static string pagerNav(PagerInfo Pi, string url, string Target, string rel, string OtherStr = "", string LastStr = "") { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.AppendLine("<div class=\"panelBar\">"); stringBuilder.AppendLine("<div class=\"pages\" >"); stringBuilder.AppendLine(string.Concat(new string[] { "<span>共", Conversions.ToString(Pi.TotalCount), "条,共", Conversions.ToString(Pi.PageCount), "页</span><span>", OtherStr, "</span>" })); stringBuilder.AppendLine(" </div>"); bool flag = Pi.PageIndex == 0; if (flag) { Pi.PageIndex = 1; } stringBuilder.AppendLine(string.Concat(new string[] { "<ul class=\"pagination2\" target='", Target, "' rel='", rel, "' pageSize='", Conversions.ToString(Pi.PageSize), "' total='", Conversions.ToString(Pi.TotalCount), "' pageIndex='", Conversions.ToString(Pi.PageIndex), "' url='", url, "' ></ul>" })); stringBuilder.AppendLine("</div>"); return stringBuilder.ToString(); }
public static string pagerNavActive(PagerInfo Pi, int activeid, string otherstr = "") { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.AppendLine("<div class=\"pagination\"><ul>"); stringBuilder.AppendLine(" "); bool flag = Pi.PageIndex == 1; checked { if (flag) { stringBuilder.AppendLine("<li class=\"disabled\"><span>«</span></li>"); } else { stringBuilder.AppendLine(string.Concat(new string[] { "<li ><a href=\"?activeid=", Conversions.ToString(activeid), "&page=", Conversions.ToString(Pi.PageIndex - 1), "\">«</a></li>" })); } int arg_96_0 = 1; int pageCount = Pi.PageCount; int num = arg_96_0; while (true) { int arg_12E_0 = num; int num2 = pageCount; if (arg_12E_0 > num2) { break; } flag = (Pi.PageIndex == num); if (flag) { stringBuilder.AppendLine("<li class=\"active\"><span>" + Conversions.ToString(num) + "</span></li>"); } else { stringBuilder.AppendLine(string.Concat(new string[] { "<li ><a href=\"?activeid=", Conversions.ToString(activeid), "&page=", Conversions.ToString(num), "\">", Conversions.ToString(num), "</a></li>" })); } num++; } flag = (Pi.PageIndex == Pi.PageCount); if (flag) { stringBuilder.AppendLine("<li class=\"disabled\"><span>»</span></li>"); } else { stringBuilder.AppendLine(string.Concat(new string[] { "<li ><a href=\"?activeid=", Conversions.ToString(activeid), "&page=", Conversions.ToString(Pi.PageIndex + 1), "\">»</a></li>" })); } stringBuilder.AppendLine(string.Concat(new string[] { "<li ><span>共", Conversions.ToString(Pi.TotalCount), "条,共", Conversions.ToString(Pi.PageCount), "页</span></li>" })); stringBuilder.AppendLine(otherstr); stringBuilder.AppendLine("</ul></div>"); return stringBuilder.ToString(); } }
public static string pagerNav(PagerInfo Pi, int caseid, int mode, string username, string otherstr = "") { StringBuilder stringBuilder = new StringBuilder(); bool flag = Operators.CompareString(username, "", false) != 0; string text; if (flag) { text = string.Concat(new string[] { "&caseid=", Conversions.ToString(caseid), "&mode=", Conversions.ToString(mode), "&blog=", username }); } else { text = "&caseid=" + Conversions.ToString(caseid) + "&mode=" + Conversions.ToString(mode); } flag = (Pi.PageIndex == 1); checked { if (flag) { stringBuilder.AppendLine("<span class=\"disabled\">上一页</li>"); } else { stringBuilder.AppendLine(string.Concat(new string[] { "<span hidefocus=\"\" ><a href=\"?page=", Conversions.ToString(Pi.PageIndex - 1), "&", text, "\">上一页</a></span>" })); } int arg_102_0 = 1; int pageCount = Pi.PageCount; int num = arg_102_0; while (true) { int arg_19E_0 = num; int num2 = pageCount; if (arg_19E_0 > num2) { break; } flag = (Pi.PageIndex == num); if (flag) { stringBuilder.AppendLine("<span class=\"active\"><span>" + Conversions.ToString(num) + "</span></span>"); } else { stringBuilder.AppendLine(string.Concat(new string[] { "<span ><a hidefocus=\"\" href=\"?page=", Conversions.ToString(num), "", text, "\">", Conversions.ToString(num), "</a></span>" })); } num++; } flag = (Pi.PageIndex == Pi.PageCount); if (flag) { stringBuilder.AppendLine("<span class=\"disabled next\">下一页</span>"); } else { stringBuilder.AppendLine(string.Concat(new string[] { "<span ><a class=\"next\" hidefocus=\"\" href=\"?page=", Conversions.ToString(Pi.PageIndex + 1), "", text, "\">下一页</a></span>" })); } stringBuilder.AppendLine(string.Concat(new string[] { "<span>共", Conversions.ToString(Pi.TotalCount), "条,共", Conversions.ToString(Pi.PageCount), "页</span>" })); stringBuilder.AppendLine(otherstr); return stringBuilder.ToString(); } }