/// <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); }
/// <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; }
/// <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); }
/// <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); }
// /// <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); }
/// <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(); }