Example #1
0
        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秒");
        }
Example #2
0
        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();
        }