public void ToStaticContent(int count) { int[] ids = bllarticletype.getTypeIdsBySpcId(spcId); if (ids.Length == 0) { this.lblMessage.Text = "没有内容可以生成!"; return; } string strIds = string.Empty; for (int i = 0; i < ids.Length; i++) { strIds += ids[i].ToString(); if (i != ids.Length - 1) { strIds += ","; } } DataTable dt = bllarticle.GetList("dbo_typeid in(" + strIds + ") order by id desc").Tables[0]; string strDir = sys.getSpcDir(spcId); for (int i = 0; i < dt.Rows.Count; i++) { sys.ToStaticContent(strDir, Convert.ToInt32(dt.Rows[i]["id"]), Convert.ToDateTime(dt.Rows[i]["dbo_ptime"])); } this.lblMessage.Text = "频道内容页生成成功!生成" + dt.Rows.Count.ToString() + "页.执行时间:" + DateTime.Now.ToString("yyyy年MM月dd日hh时mm分ss秒"); }
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(); }