Exemplo n.º 1
0
        /// <summary>
        /// Del_newses the specified bh.
        /// </summary>
        /// <param name="bh">The bh.</param>
        void del_news(int bh)
        {
            //更新静态生成文件
            //NewHtml(null, Convert.ToInt32(Request["class"]));
            //删除新闻生成文件
            //new ROYcms.Templet.NewShow().DelHtml(bh);

            ROYcms_news BLL = new ROYcms_news();

            BLL.Delete(bh);
        }
Exemplo n.º 2
0
        /// <summary>
        /// Repeater_admin_binds the specified classs.
        /// </summary>
        void Repeater_admin_bind()
        {
            switch (Request["t"])
            {
            case "del":
                del_news(Convert.ToInt32(Request["id"]));
                break;

            case "ding":
                if (Request["ding"] == "1")
                {
                    Ding_news(Convert.ToInt32(Request["id"]), 0);
                }
                else
                {
                    Ding_news(Convert.ToInt32(Request["id"]), 1);
                }
                break;

            case "tuijian":
                if (Request["tuijian"] == "1")
                {
                    Tuijian_news(Convert.ToInt32(Request["id"]), 0);
                }
                else
                {
                    Tuijian_news(Convert.ToInt32(Request["id"]), 1);
                }
                break;

            case "K":
                if (Request["K"] == "0")
                {
                    K_news(Convert.ToInt32(Request["id"]), 1);
                }
                else
                {
                    K_news(Convert.ToInt32(Request["id"]), 0);
                }
                break;
            }

            string where = "";
            if (ViewState["KeyWord"] != null)
            {
                where = "(title like '%" + ViewState["KeyWord"].ToString() + "%')  AND ";
            }
            if (ViewState["Time"].ToString() != "0")
            {
                where += "datediff(dd,time,getdate())=" + ViewState["Time"].ToString() + " AND ";
            }
            if (ViewState["State"].ToString() != "0")
            {
                where += "switchs =" + ViewState["State"].ToString() + " AND ";
            }
            if (ViewState["Class"].ToString() != "0" && ViewState["Class"].ToString() != "")
            {
                where += "classname =" + ViewState["Class"].ToString() + " AND ";
            }
            where += "(type = '" + ViewState["ClassKind"].ToString() + "') ";

            try
            {
                ROYcms_news Bll = new ROYcms_news();
                Repeater_admin.DataSource = Bll.GetList(Convert.ToInt32(Application["PageSize"]), Convert.ToInt32(ViewState["Page"]), where, 1);
                Repeater_admin.DataBind();
                ViewState["PageCon"]     = Bll.GetCount(where) / Convert.ToInt32(Application["PageSize"]) + 1;
                ViewState["PageContent"] = Bll.GetCount(where);
            }
            catch //异常处理
            {
                Repeater_admin.DataSource = null;
                Repeater_admin.DataBind();
            }

            keywords.Value       = "";
            ViewState["KeyWord"] = null;

            // Label1.Text = where;
        }
Exemplo n.º 3
0
        /// <summary>
        /// Tuijian_newses the specified bh.
        /// </summary>
        /// <param name="bh">The bh.</param>
        /// <param name="tuijian">The tuijian.</param>
        void Tuijian_news(int bh, int tuijian)
        {
            ROYcms_news BLL = new ROYcms_news();

            BLL.Tuijian_news(bh, tuijian);
        }
Exemplo n.º 4
0
        /// <summary>
        /// Ding_newses the specified bh. //修改一条数据是否置顶  推荐
        /// </summary>
        /// <param name="bh">The bh.</param>
        /// <param name="ding">The ding.</param>
        void Ding_news(int bh, int ding)
        {
            ROYcms_news BLL = new ROYcms_news();

            BLL.Ding_news(bh, ding);
        }
Exemplo n.º 5
0
        //
        /// <summary>
        /// K_newses the specified bh.控制开关 打开 和关闭一条数据
        /// </summary>
        /// <param name="bh">The bh.</param>
        /// <param name="on_of">The on_of.</param>
        void K_news(int bh, int on_of)
        {
            ROYcms_news BLL = new ROYcms_news();

            BLL.K_news(bh, on_of);
        }
Exemplo n.º 6
0
        /// <summary>
        /// Repeater_admin_binds the specified classs.
        /// </summary>
        /// <param name="classs">The classs.</param>
        void Repeater_admin_bind(string classs)
        {
            switch (Request["t"])
            {
            case "del":
                del_news(Convert.ToInt32(Request["id"]));
                break;

            case "ding":
                if (Request["ding"] == "1")
                {
                    Ding_news(Convert.ToInt32(Request["id"]), 0);
                }
                else
                {
                    Ding_news(Convert.ToInt32(Request["id"]), 1);
                }
                break;

            case "tuijian":
                if (Request["tuijian"] == "1")
                {
                    Tuijian_news(Convert.ToInt32(Request["id"]), 0);
                }
                else
                {
                    Tuijian_news(Convert.ToInt32(Request["id"]), 1);
                }
                break;

            case "K":
                if (Request["K"] == "0")
                {
                    K_news(Convert.ToInt32(Request["id"]), 1);
                }
                else
                {
                    K_news(Convert.ToInt32(Request["id"]), 0);
                }
                break;
            }


            int page = 0;

            string where = "";
            if (Request["page"] != null && Request["page"] != "")
            {
                page = Convert.ToInt32(Request["page"]) - 1;
            }
            if (this.keyword != null)
            {
                where = " (title like '%" + this.keyword.Trim() + "%') ";
            }

            if (classs != null)
            {
                where = " classname =" + classs;
            }
            if (Request["day"] != null)
            {
                where = " datediff(dd,time,getdate())=" + Request["day"];
            }

            if (where != "")
            {
                //if (Request["role"] != null && ROYcms.Common.Session.Gets("User") != null)
                //{ where = where + " and bh in(select New_id from ROYcms_new_user where User_id =)" + ROYcms.Common.Session.Gets("Users")[1]; }

                where = where + " and (type = '" + this.ClassKind.ToString() + "') ";
            }
            else
            {
                where = " type = '" + this.ClassKind.ToString() + "' ";
                //if (Request["role"] != null && ROYcms.Common.Session.Gets("User") != null)
                //{ where = where + " and bh in(select New_id from ROYcms_new_user where User_id =)"+ROYcms.Common.Session.Gets("Users")[1]; }
            }

            ROYcms_news Bll = new ROYcms_news();

            pages = Bll.GetCount(where) / 18 + 1; //分页的总数
            PagedDataSource pg = new PagedDataSource();

            pg.DataSource             = Bll.GetList(where + " order by bh desc ").Tables[0].DefaultView;
            pg.AllowPaging            = true;
            pg.PageSize               = 18;
            pg.CurrentPageIndex       = page;
            Repeater_admin.DataSource = pg;
            Repeater_admin.DataBind();
        }