#region getjsondata
/// <summary>
/// 得到json数据
/// </summary>
/// <param name="ds">dataset</param>
/// <param name="keyfileds">查找的字段,例: id,name,content</param>
/// <returns></returns>
public static string getjsondata(dataset ds,string keyfileds)
{
stringbuilder html = new stringbuilder();
string[] alist;
alist = keyfileds.split(',');
html.append("[");
for (int i = 0; i < ds.tables[0].rows.count; i++)
{
html.append("{");
int j = 0;
foreach (string str in alist)
{
html.append("_"+ j++ +":"" + ds.tables[0].rows[i][str].tostring() + "",");
}
html.remove(html.length - 1, 1);
html.append("},");
}
html.remove(html.length - 1, 1);
html.append("]");
return html.tostring();
}
#endregion#region 分页样式 1 2 3 4 5 6 7 8 ...
/// <summary>
/// 分页样式 1 2 3 4 5 6 7 8 ...
/// </summary>
/// <param name="count"></param>
/// <returns></returns>
public static string getpager(jsonmodel jm)
{
stringbuilder html = new stringbuilder();
html.append("<div class='page_span'>");
html.append("<a href='网页特效:content(1)'>首页</a>");
//计算总页数
if (jm.count % jm.pageindexcount == 0)
jm.pagecount = jm.count / jm.pageindexcount;
else
jm.pagecount = jm.count / jm.pageindexcount + 1;//计算开始页-结束页
if (jm.currentpageindex <= jm.pagecount)
{
if (jm.currentpageindex / jm.extpage >= 1 && jm.currentpageindex <= jm.pagecount)
{
int extpage = jm.currentpageindex / jm.extpage;
jm.startpage = extpage * jm.extpage - 1;
jm.endpage = jm.startpage + jm.extpage+1;
}
else
{
jm.endpage = jm.startpage + jm.extpage+1;
}
}
if (jm.endpage > jm.pagecount)
jm.endpage = jm.pagecount;
if (jm.startpage < 1)
jm.startpage = 1;
for (int i = jm.startpage; i <= jm.endpage; i++)
{
if (i == jm.currentpageindex)
{
html.append("<a href='javascript:content(" + i + ")'>");
html.append("<font color=red >" + i + "</font>");
html.append("</a>");
}
else
{html.append("<a href='javascript:content(" + i + ")'>");
html.append(i);
html.append("</a>");
}}
html.append("<a href='javascript:content(" + jm.pagecount + ")'>末页</a>");
html.append("</div>");
return html.tostring();
}
#endregion#region 分页样式 上一页 下一页
/// <summary>
///
/// </summary>
/// <param name="jm">jm.currentpageindex 当前页,jm.pagecount总页</param>
/// <returns></returns>
public static string getsmiplepager(jsonmodel jm)
{
stringbuilder html = new stringbuilder();//计算总页数
if (jm.count % jm.pageindexcount == 0)
jm.pagecount = jm.count / jm.pageindexcount;
else
jm.pagecount = jm.count / jm.pageindexcount + 1;html.append("<div class='page_span'>");
html.append("<a href='javascript:content(1)'>首页</a>");
if (jm.currentpageindex > 1)
{
html.append("<a href='javascript:content(" + (jm.currentpageindex - 1) + ")'>上一页</a>");
}
if (jm.currentpageindex < jm.pagecount)
{
html.append("<a href='javascript:content(" + (jm.currentpageindex + 1) + ")'>下一页</a>");
}
html.append("<a href='javascript:content(" + jm.pagecount + ")'>末页</a>");//搜索框
html.append(" <input id='t_page' style='width:30px;border:1px solid #acacac' class='btn' /> <input type='button' value='go' onclick='if($("#t_page").val()=="")alert("请输入页码"); else if($("#t_page").val()>" + jm.pagecount + "||$("#t_page").val()==0){alert("请输入正确的页码!")}else{content($("#t_page").val())}'>");
html.append("</div>");
return html.tostring();
}
#endregion
首页 1 2 3 4 5 末页