private void FullShowList()
{
BLL.Article bllarticle = new BLL.Article();
int rowcount, pageIndex, pageSize;
pageIndex = 1;
pageSize = 15;
string[] str = "7".Split(',');
int[] typeids = new int[str.Length];
for (int i = 0; i < str.Length; i++)
{
typeids[i] = Convert.ToInt32(str[i]);
}
DataTable dt = bllarticle.getPagerArticle(pageIndex, pageSize, out rowcount, typeids, "");
int pagecount = (rowcount + pageSize - 1) / pageSize;
StringBuilder result = new StringBuilder();
foreach (DataRow dr in dt.Rows)
{
result.AppendFormat("<li><a href=\"javascript:showDetail({0})\" data-transition='slide'>{1}<span class=\"ui-li-count\">{2}</span></a></li>", dr["id"], dr["dbo_title"], ((DateTime)dr["dbo_ptime"]).ToString("yyyy-MM-dd"));
}
NewList = result.ToString();
hidPagecount_list.Value = pagecount.ToString();
hidPageNow_list.Value = pageIndex.ToString();
if (pagecount == pageIndex || pagecount == 0)
{
listMore.InnerHtml = "没有更多内容了";
}
}
public string GetListByPage(string page)
{
BLL.Article bllarticle = new BLL.Article();
int rowcount, pageIndex, pageSize;
pageIndex = Convert.ToInt32(page);
pageSize = 15;
string[] str = "7".Split(',');
int[] typeids = new int[str.Length];
for (int i = 0; i < str.Length; i++)
{
typeids[i] = Convert.ToInt32(str[i]);
}
DataTable dt = bllarticle.getPagerArticle(pageIndex, pageSize, out rowcount, typeids, "");
StringBuilder result = new StringBuilder();
foreach (DataRow dr in dt.Rows)
{
result.AppendFormat("<li><a href=\"javascript:showDetail({0})\" data-transition='slide'>{1}<span class=\"ui-li-count\">{2}</span></a></li>", dr["id"], dr["dbo_title"], ((DateTime)dr["dbo_ptime"]).ToString("yyyy-MM-dd"));
}
return(result.ToString());
}
private void BindData()
{
string strFiter = string.Empty;
if (ViewState["fiter"] != null)
{
strFiter = ViewState["fiter"].ToString();
}
#region 自定义分页
int rowcount, pageIndex, pageSize;
pageIndex = 1;
if (ViewState["pageIndex"] != null)
{
pageIndex = Convert.ToInt32(ViewState["pageIndex"]);
}
else
{
ViewState["pageIndex"] = pageIndex;
}
pageSize = this.GridView1.PageSize;
int[] typeids;
if (ViewState["selectType"] == null)
{
if (currentAdmin.validationSpcAdmin(spcId))
{
typeids = bllarticletype.getTypeIdsBySpcId(Convert.ToInt32(spcId));
}
else
{
string ids = adminOpers.getChannelPower(spcId, currentAdmin.Channels);
string[] strids = ids.Split(',');
typeids = new int[strids.Length];
for (int i = 0; i < strids.Length; i++)
{
typeids[i] = Convert.ToInt32(strids[i]);
}
}
}
else
{
typeids = new int[] { Convert.ToInt32(ViewState["selectType"]) };
}
if (typeids.Length == 0)
{
// Response.Write(sys.alertAndRedirect("", "" + ));
Response.Write("<script type='text/javascript'>alert('专题下未创建任何文章类型，请先添加文章类型');window.location.href='typeAdd.aspx?spcId='" + spcId.ToString() + "</script>");
pnlContent.Visible = false;
return;
}
DataTable dt = bllarticle.getPagerArticle(pageIndex, pageSize, out rowcount, typeids, strFiter);
//DataTable dt = dal.article.getPagerArticle(pageIndex, pageSize, out rowcount, strFiter, spcId);
ShowPageNav(rowcount, pageIndex, pageSize);
#endregion
//没有定义分页，从数据库中查询出所有的内容，数据大的时候效率低
//DataTable dt = dal.article.GetArticleList(strFiter, spcId);
this.GridView1.DataSource = dt;
this.GridView1.DataBind();
}