private void AddNews() { R_News r = new R_News(); r.News_Tital = NewsTitle.Text.Trim(); r.Sort_ID = Convert.ToInt32(News_Sort.SelectedValue); r.News_Content = NewsContent.Value; r.User_ID = Convert.ToInt32(Request.Cookies["user"]["ID"]); r.News_Reading = reading.Checked == true ? 1 : 0; r.News_ImageBool = imageCheck.Checked == true ? 1 : 0; r.News_Images = imageCheck.Checked == true ? Img_Url.Value.Trim() : ""; B_News b = new B_News(); if (b.addNews(r)) { NewsTitle.Text = ""; Img_Url.Value = ""; News_Sort.SelectedIndex = 0; NewsContent.Value = ""; ll_ts.Text = "添加成功!"; //Response.Redirect("Default.aspx"); } else { ll_ts.Text = "添加失败!"; } }
private void pageLode() { B_News b = new B_News(); DataTable dt = b.getNewsByID(id).Tables[0]; NewsTitle = dt.Rows[0]["News_Tital"].ToString(); SiteContent.Value = dt.Rows[0]["News_Content"].ToString(); }
private void pageLode() { if (Request.QueryString["action"] != null) { if(userType == 1||userType == 0) { if ((Request.QueryString["action"].Equals("cancel") && Request.QueryString["id"] != null)) { int id = Convert.ToInt32(Request.QueryString["id"]); B_News b = new B_News(); if (b.CancelNewsReading(id, 0)) { Response.Redirect("index.aspx"); } else { Response.Write("<script>alert('取消失败!')</script>"); } } } else { Response.Write("<script>alert('用户权限不足!')</script>"); } } bindData(); }
/// <summary> /// 根据ID获取数据 /// </summary> /// <param name="id"></param> private void getDataByID(int id) { B_News b = new B_News(); DataTable dt = b.getNewsByID(id).Tables[0]; NewsTitle.Text = dt.Rows[0]["News_Tital"].ToString(); NewsContent.Value = dt.Rows[0]["News_Content"].ToString(); }
private void bindData() { B_Index b = new B_Index(); Links.InnerHtml = b.getLinks(); B_InforData bf = new B_InforData(); hotNews.InnerHtml = bf.getHotNews(); bindNews(); B_News bn = new B_News(); webInfor.InnerHtml = bn.getWebInfor().Tables[0].Rows[0]["News_Content"].ToString(); }
private void bindNewsData() { AspNetPager1.PageSize = Convert.ToInt32(page_rows.SelectedValue); B_News b = new B_News(); //绑定文章表格数据 DataSet ds = b.getNewsData(); PagedDataSource ps = new PagedDataSource(); ps.DataSource = ds.Tables[0].DefaultView; AspNetPager1.RecordCount = ps.Count; ps.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1; ps.AllowPaging = true; ps.PageSize = AspNetPager1.PageSize; R_News.DataSource = ps; R_News.DataBind(); }
private void bindData() { AspNetPager1.PageSize = 10; B_News b = new B_News(); DataSet ds = b.getDataByReading(); PagedDataSource ps = new PagedDataSource(); ps.DataSource = ds.Tables[0].DefaultView; AspNetPager1.RecordCount = ps.Count; ps.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1; ps.AllowPaging = true; ps.PageSize = AspNetPager1.PageSize; R_Reading.DataSource = ps; R_Reading.DataBind(); about.InnerHtml = b.getAbout().Tables[0].Rows[0]["News_Content"].ToString() ; }
private void editNews() { R_News r = new R_News(); r.News_Tital = NewsTitle.Text.Trim(); r.Sort_ID = 8; r.News_Content = NewsContent.Value; r.User_ID = Convert.ToInt32(Request.Cookies["user"]["ID"]); r.ID = id; r.News_Reading = 0; r.News_ImageBool = 0; r.News_Images = ""; B_News b = new B_News(); if (b.editNews(r)) { Response.Redirect("../index.aspx"); } else { ll_ts.Text = "修改失败!"; } }
private void editNews() { R_News r = new R_News(); r.News_Tital = NewsTitle; r.Sort_ID = 8; r.News_Content = SiteContent.Value; r.User_ID = Convert.ToInt32(Request.Cookies["user"]["ID"]); r.ID = id; r.News_Reading = 0; r.News_ImageBool = 0; r.News_Images = ""; B_News b = new B_News(); if (b.editNews(r)) { Response.Write("<script>alert('更新成功')</script>"); } else { ll_ts.Text = "修改失败!"; } }
private void bindData() { B_Index b = new B_Index(); Links.InnerHtml = b.getLinks(); Reading.InnerHtml = b.getDataByReading(); Latestnews.InnerHtml = b.getLatestnews(); hotNews.InnerHtml = b.getHotNews(); imageBox.InnerHtml = b.getDataByImg(); icoBox.InnerHtml = b.getIcoBox(); demo1.InnerHtml = b.getImgList(); _Marknews.InnerHtml = b.getMarknews(); _AgricultTech.InnerHtml = b.getAgricultTech(); _Supply_Infor.InnerHtml = b.getSupply_demandInfor(); _PolicyLaws.InnerHtml = b.getPolicyLaws(); _NYKJ.InnerHtml = b.getNYKJ(); _Economicnews.InnerHtml = b.getEconomicnews(); B_News bn=new B_News(); webInfor.InnerHtml = bn.getWebInfor().Tables[0].Rows[0]["News_Content"].ToString(); }
private void bindData() { B_InforData bf=new B_InforData(); thisCP.NavigateUrl = bf.getCpByID(id)["Sort_Value"].ToString() + ".aspx"; thisCP.Text = bf.getCpByID(id)["Sort_Name"].ToString(); dataTableByID.InnerHtml = bf.getInforByID(id); GetIP g = new GetIP(); R_Read r = new R_Read(); r.News_ID = id; r.Read_IP = g.GetRealIP(); r.Read_Time = DateTime.Now.Date; B_News bn = new B_News(); webInfor.InnerHtml = bn.getWebInfor().Tables[0].Rows[0]["News_Content"].ToString(); B_Index bi=new B_Index(); try { bi.searchRead(r); } catch (Exception ex) { Response.Write(ex.Message); } }
/// <summary> /// 获取新闻分类 /// </summary> private void getSort() { B_News b = new B_News(); //绑定文章分类列表数据 DataSet ds = b.getNews_Sort(); foreach (DataRow r in ds.Tables[0].Rows) { string t = r["Sort_Name"].ToString(); string v = r["ID"].ToString(); ListItem l = new ListItem(t, v);//初始化ListItem的值 News_Sort.Items.Add(l); } }
/// <summary> /// 根据ID获取数据 /// </summary> /// <param name="id"></param> private void getDataByID(int id) { B_News b = new B_News(); DataTable dt = b.getNewsByID(id).Tables[0]; NewsTitle.Text = dt.Rows[0]["News_Tital"].ToString(); News_Sort.Enabled = false; reading.Checked = Convert.ToBoolean(Convert.IsDBNull(dt.Rows[0]["News_Reading"]) == false ? dt.Rows[0]["News_Reading"] : 0); imageCheck.Checked = Convert.ToBoolean(Convert.IsDBNull(dt.Rows[0]["News_ImageBool"]) == false ? dt.Rows[0]["News_ImageBool"] : 0); Img_Url.Value = dt.Rows[0]["News_Images"].ToString(); News_Sort.SelectedValue = dt.Rows[0]["Sort_ID"].ToString(); NewsContent.Value = dt.Rows[0]["News_Content"].ToString(); }
private void pageLode() { if (Request.QueryString["action"] != null ) { if (userType == 0 || userType == 1) { if (Request.QueryString["id"] != null) { B_News b = new B_News(); if (b.deleteByNewsID(Convert.ToInt32(Request.QueryString["id"]))) { Response.Redirect("Default.aspx"); } else { Response.Write("<sciput>alert('删除失败')</sciput>"); } } //if (Request.QueryString["action"].Equals("deleteIDs") && Request.QueryString["ids"] != null) //{ // B_News b = new B_News(); // string[] ids=Request.QueryString["ids"].Split(','); // int count = 0; // foreach (string id in ids) // { // if (b.deleteByNewsID(Convert.ToInt32(id))) // { // count++; // } // else // { // } // } // Response.Write(count); //} } else { Response.Write("<script>alert('用户权限不足,不能删除!')</script>"); } } bindNews_Sort(); bindNewsData(); }
private void bindData() { B_News bn = new B_News(); about.InnerHtml = bn.getAbout().Tables[0].Rows[0]["News_Content"].ToString(); webInfor.InnerHtml = bn.getWebInfor().Tables[0].Rows[0]["News_Content"].ToString(); }