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