/// <summary> /// 绑定数据 /// </summary> /// <returns></returns> private bool BindData() { try { using (var db = new huxiuEntities()) { var displayHead = from it in db.Headline where it.HisDisplay == true select new MyDataInfo { Id = it.Id, HId = it.HId, Htitle = it.Htitle, Himg = it.Himg, Hdeadline = it.Hdeadline, HisDisplay = it.HisDisplay }; var queueHead = from it in db.Headline where it.HisDisplay == false select new MyDataInfo { Id = it.Id, HId = it.HId, Htitle = it.Htitle, Himg = it.Himg, Hdeadline = it.Hdeadline, HisDisplay = it.HisDisplay }; DataTable dt_head = transToDataTable(displayHead); DataTable dt_queue = transToDataTable(queueHead); RptDisplaying.DataSource = dt_head; rptQueue.DataSource = dt_queue; RptDisplaying.DataBind(); rptQueue.DataBind(); } return(true); } catch { return(false); } }
protected void btnAdd_Click(object sender, EventArgs e) { if (name.Text.Trim().Length > 0) { using (var db = new huxiuEntities()) { PassageCategory person = new PassageCategory { CategoryName = name.Text.Trim() }; db.PassageCategory.Add(person); if (db.SaveChanges() == 1) { Response.Write("<script>alert('添加成功');location='PassageList.aspx'</script>"); } else { Response.Write("<script>alert('添加失败请重试')</script>"); } } } else { Response.Write("<script>alert('不能为空!')</script>"); } }
protected void Page_Load(object sender, EventArgs e) { Regex r = new Regex("^[1-9]d*|0$"); if (Session["AdminID"] == null) { Response.Write("<script>alert('账户过期请重新登录!');location='login.aspx'</script>"); } else if (!IsPostBack) { if (Request.QueryString["id"] != null && r.IsMatch(Request.QueryString["id"]))//要把是否为空放前面 { int id = Convert.ToInt32(Request.QueryString["id"]); using (var db = new huxiuEntities()) { PassageCategory person = (from it in db.PassageCategory where it.PCategoryId == id select it).FirstOrDefault(); if (person != null) { name.Text = person.CategoryName; } else { Response.Write("<script>alert('地址栏有误');location='/PCategoryList.aspx'</script>"); } } } else { Response.Write("<script>alert('地址栏有误');location='/PCategoryList.aspx'</script>"); } } }
protected void btnEditor_Click(object sender, EventArgs e) { int id = Convert.ToInt32(Request.QueryString["id"]); //标题 内容 不能为空 if (title.Text.Trim().Length > 0 && editor.InnerHtml.Trim().Length > 0) { using (var db = new huxiuEntities()) { Passage person = (from it in db.Passage where it.PassageId == id select it).FirstOrDefault(); person.PassageTitle = title.Text; //标题 person.PassageBody = UeditorHelper.change(editor.InnerHtml); //内容 if (Request.Form["lb"] != "") { person.PassageImage = "~/File/" + Request.Form["lb"]; } person.PassageCategory = Convert.ToInt32(category.SelectedValue); //资讯分类 person.PublishDate = Convert.ToDateTime(dates.Text).ToString("yyyy-MM-dd HH:mm:ss"); //时间 person.AuthorId = Convert.ToInt32(author.SelectedValue); //作者 if (db.SaveChanges() == 1) { Response.Write("<script>alert('编辑成功');location='PassageEditor.aspx?id=" + id + "'</script>"); } else { Response.Write("<script>alert('编辑失败请重试')</script>"); } } } else { Response.Write("<script>alert('不能为空')</script>"); } }
protected string imgUrl; //= "./images/icon-eg.jpeg"; protected void Page_Load(object sender, EventArgs e) { //登陆后,用seesion 初始化 //AdminName 的名字和postUrl,网址跳转管理 if (Session["AdminID"] == null) { Response.Write("<script>alert('账户过期请重新登录!');window.parent.location.href='login.aspx';</script>"); } else if (!IsPostBack) { int adId = Convert.ToInt32(Session["AdminID"].ToString().Trim()); try { using (var db = new huxiuEntities()) { Admin ad = db.Admin.SingleOrDefault(a => a.AdminId == adId); name = ad.AdminName; imgUrl = ad.AdminImage; } } catch { Response.Write("<script>alert('账户过期请重新登录!';location.href='login.aspx')</script>"); } } }
protected void btnAdd_Click(object sender, EventArgs e) { if (title.Text.Trim().Length > 0 && editor.InnerHtml.Trim().Length > 0 && link.Text.Trim().Length > 0) { using (var db = new huxiuEntities()) { News person = new News { NewsTitle = title.Text.Trim(), NewsBody = UeditorHelper.change(editor.InnerHtml), NewsDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), //发表时间 NewsLink = link.Text.Trim(), IsDel = false }; db.News.Add(person); if (db.SaveChanges() == 1) { Response.Write("<script>alert('添加成功');location='NewsList.aspx'</script>"); } else { Response.Write("<script>alert('添加失败请重试')</script>"); } } } else { Response.Write("<script>alert('不能为空')</script>"); } }
protected void btnEditor_Click(object sender, EventArgs e) { if (name.Text.Trim().Length > 0) { using (var db = new huxiuEntities()) { int id = Convert.ToInt32(Request.QueryString["id"]); PassageCategory person = (from it in db.PassageCategory where it.PCategoryId == id select it).FirstOrDefault(); person.CategoryName = name.Text.Trim(); if (db.SaveChanges() == 1) { Response.Write("<script>alert('修改成功');location='/PCategoryList.aspx'</script>"); } else { Response.Write("<script>alert('修改失败请重试')</script>"); } } } else { Response.Write("<script>alert('不能为空')</script>"); } }
protected void btnEditor_Click(object sender, EventArgs e) { int id = Convert.ToInt32(Request.QueryString["id"]); if (title.Text.Trim().Length > 0 && editor.InnerHtml.Trim().Length > 0 && link.Text.Trim().Length > 0) { using (var db = new huxiuEntities())//修改短趣 { News person = (from it in db.News where it.NewsId == id select it).FirstOrDefault(); person.NewsTitle = title.Text.Trim(); //标题 person.NewsBody = UeditorHelper.change(editor.InnerHtml); //内容 // person.NewsDate = Convert.ToDateTime(dates.Text);//发布时间不做修改 person.NewsLink = link.Text.Trim(); //超链接 // person.IsDel = false;//是否删除 if (db.SaveChanges() == 1) { Response.Write("<script>alert('编辑成功');location='NewsEditor.aspx?id=" + id + "'</script>"); } else { Response.Write("<script>alert('编辑失败请重试')</script>"); } } } else { Response.Write("<script>alert('不能为空')</script>"); } }
protected void btnSearch_Click(object sender, EventArgs e) { string content = txtSearch.Text; using (var db = new huxiuEntities()) { var datascore = from it in db.Author orderby it.AuthorName select it; if (content.Length != 0) { datascore = from it in db.Author where it.AuthorName.IndexOf(content) >= 0 orderby it.AuthorName select it; } var ds = datascore.ToList(); if (ds.Count == 0) { Response.Write("<script>alert('很抱歉,没有找到相关内容!')</script>"); } Session["ds"] = ds; DataBindToRepeater(1, ds); lbNow.Text = "1"; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["AdminID"] == null) { Response.Write("<script>alert('账户过期请重新登录!');window.parent.location.href='login.aspx';</script>"); } else if (!IsPostBack) { using (var db = new huxiuEntities()) { List <PassageCategory> pcategory = (from it in db.PassageCategory select it).ToList(); for (int i = 0; i < pcategory.Count; i++) { string idc = pcategory[i].PCategoryId.ToString(); string categoryc = pcategory[i].CategoryName.ToString(); category.Items.Add(new ListItem(categoryc, idc));//循环动态绑定分类 } List <Author> authorlist = (from it in db.Author select it).ToList(); for (int i = 0; i < authorlist.Count; i++) { string idc = authorlist[i].AuthorId.ToString(); string categoryc = authorlist[i].AuthorName.ToString(); author.Items.Add(new ListItem(categoryc, idc));//循环动态绑定作者 } } } }
}/// <summary> /// 绑定主页图片切换 /// </summary> /// <returns></returns> bool bindTurnImg() { //只能显示四条,一位前台只能绑定四条记录 try { using (var db = new huxiuEntities()) { var qurey = from it in db.Headline where it.HisDisplay == true select it; PagedDataSource pds = new PagedDataSource(); pds.AllowPaging = true; pds.PageSize = 4; pds.DataSource = qurey.ToList(); pds.CurrentPageIndex = 0; rptTurnImg.DataSource = pds; rptTurnImg.DataBind(); } return(true); } catch { return(false); } }
protected void btnAdd_Click(object sender, EventArgs e) { if (name.Text.Trim().Length > 0 && Request.Form["lb"].Trim().Length > 0 && summary.Text.Trim().Length > 0) { using (var db = new huxiuEntities()) { Author person = new Author { AuthorName = name.Text, AuthorSex = sex.SelectedValue == "1" ? true : false, AuthorImage = "~/File/" + Request.Form["lb"], AuthorSummary = summary.Text }; db.Author.Add(person); if (db.SaveChanges() == 1) { Response.Write("<script>alert('添加作者成功');location='AuthorList.aspx'</script>"); } else { Response.Write("<script>alert('添加失败请重试')</script>"); } } } else { Response.Write("<script>alert('不能为空')</script>"); } }
/// <summary> /// 本函数实现标记资讯, 短趣,活动 删除列,并且把记录写在 DeleteLog 中 /// </summary> /// <param name="CategoryId"></param> 参数解释:待删除 ID 的所在分类 1 资讯 ; 2 活动; 3 短趣 /// <param name="DelId"></param> 参数解释:待删除 ID /// <param name="OperatorId"></param> 参数解释:本次操作的管理员 ID /// <returns></returns> public bool delItem() { try { //记录准备删除的那条记录 if (!recordDelFlag(true)) { return(false); } using (var db = new huxiuEntities()) { //new 一个 delelog 对象,进行添加操作 DeleteLog addDelLog = new DeleteLog(); addDelLog.DelAdminId = OperatorId; addDelLog.DelTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); addDelLog.Category = CategoryId; addDelLog.LogId = DelId; //添加记录表中 db.DeleteLog.Add(addDelLog); //保存更改 db.SaveChanges(); return(true); } } catch { return(false); } }
protected void btnAdd_Click(object sender, EventArgs e) { //标题 内容 封面 作者 分类 不能为空 if (title.Text.Trim().Length > 0 && editor.InnerHtml.Trim().Length > 0 && Request.Form["lb"].Trim().Length > 0 && author.SelectedValue.Length > 0 && category.SelectedValue.Length > 0) { using (var db = new huxiuEntities()) { Passage passage = new Passage { PassageTitle = title.Text, PassageBody = UeditorHelper.change(editor.InnerHtml), PassageImage = "/File/" + Request.Form["lb"], PassageCategory = Convert.ToInt32(category.SelectedValue), PublishDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), AuthorId = Convert.ToInt32(author.SelectedValue), PageViews = 0, IsDel = false }; db.Passage.Add(passage); if (db.SaveChanges() == 1) { Response.Write("<script>alert('添加成功');location='PassageList.aspx'</script>"); } else { Response.Write("<script>alert('添加失败请重试')</script>"); } } } else { Response.Write("<script>alert('不能为空!')</script>"); } }
/// <summary> /// 记录原始数据项的删除标记 /// </summary> /// <param name="yes_or_no"></param> /// <returns>返回bool类型</returns> private bool recordDelFlag(bool yes_or_no) { try { using (var db = new huxiuEntities()) { switch (CategoryId) { case 1: //查找资讯 Passage delPassage = db.Passage.SingleOrDefault(a => a.PassageId == DelId); delPassage.IsDel = yes_or_no; break; case 2: //查找活动 Activity delActivty = db.Activity.SingleOrDefault(a => a.ActivityId == DelId); delActivty.IsDel = yes_or_no; break; case 3: //查找短趣 News delnews = db.News.SingleOrDefault(a => a.NewsId == DelId); delnews.IsDel = yes_or_no; break; } db.SaveChanges(); } return(true); } catch { return(false); } }
/// <summary> /// 恢复删除 /// </summary> /// <returns></returns> public bool recoverDel() { try { //把原来表里面的数据删除标志位 置 0 if (!recordDelFlag(false)) { return(false); } //删除记录表中的数据 using (var db = new huxiuEntities()) { DeleteLog del = (from it in db.DeleteLog where it.Category == CategoryId && it.LogId == DelId select it).FirstOrDefault(); db.DeleteLog.Remove(del); db.SaveChanges(); } return(true); } catch { return(false); } }
/// <summary> /// 本函数删除相应分类下面的某一条 /// </summary> /// <param name="completeCate"> 相应分类</param> /// <param name="completeId"> 分类下面的id </param> /// <returns>返回 bool</returns> private bool delSourceData(int completeCate, int completeId) { try { using (var db = new huxiuEntities()) { switch (completeCate) { case 1: //查找资讯 Passage delPassage = db.Passage.SingleOrDefault(a => a.PassageId == completeId); db.Passage.Remove(delPassage); break; case 2: //查找活动 Activity delActivty = db.Activity.SingleOrDefault(a => a.ActivityId == completeId); db.Activity.Remove(delActivty); break; case 3: //查找短趣 News delnews = db.News.SingleOrDefault(a => a.NewsId == completeId); db.News.Remove(delnews); break; } db.SaveChanges(); } return(true); } catch { return(false); } }
/// <summary> /// 在大的资讯分类里面筛选出小的资讯分类 /// </summary> /// <param name="PassageLable"></param> /// <returns>返回一个 DataTable 进行分页操作</returns> protected DataTable SelectPassageLable(string PassageLable) { int PassageLableId = 1; //遍历资讯分类表,得到分类名的id using (var db = new huxiuEntities()) { var IdList = from it in db.PassageCategory select it; foreach (var item in IdList) { if (item.CategoryName == PassageLable) { PassageLableId = item.PCategoryId; } } } // 复制一个分类下建立好的 DataTable ,方便之后换了分类继续使用 DataTable copy_dt = new DataTable(); string filterStr = "PassageCate=" + PassageLableId.ToString(); DataRow[] rows = _DT.Select(filterStr); //筛选符合条件的数据 copy_dt = _DT.Clone(); //克隆 _DT 的结构 foreach (DataRow row in rows) { copy_dt.ImportRow(row); //复制行数据到 copy_dt 中 } return(copy_dt); }
/// <summary> /// 删除头条 /// </summary> /// <param name="id"></param> /// <returns></returns> public bool delItem(int id) { try { using (var db = new huxiuEntities()) { Headline delHead = db.Headline.SingleOrDefault(a => a.Id == id); if (!delHead.HisDisplay) //如果删除队列中的项目,队列数量减一 { queueSize--; } else if (displayCount <= 4) //最少头条保留4条 { return(false); } db.Headline.Remove(delHead); db.SaveChanges(); } displayCount--; return(true); } catch { return(false); } }
protected void Page_Load(object sender, EventArgs e) { using (var db = new huxiuEntities()) { var datascore = from it in db.PassageCategory select it; Rpt.DataSource = datascore.ToList(); Rpt.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { Regex r = new Regex("^[1-9]d*|0$"); if (Request.QueryString["id"] != null && r.IsMatch(Request.QueryString["id"])) { int id = Convert.ToInt32(Request.QueryString["id"]); using (var db = new huxiuEntities()) { Activity person = (from it in db.Activity where it.ActivityId == id select it).FirstOrDefault(); if (person != null) { title.Text = person.ActivityTitle; //标题 what.Text = person.ActivityWhat; //内容 img.ImageUrl = person.ActivityImage; //封面 when.Text = person.ActivityWhen.ToString(); //时间 where.Text = person.ActivityWhere; //地点 tips.Text = person.ActivityTips; //备注 List <Activity> people = (from it in db.Activity where it.ActivityId != id select it).ToList(); //相关活动 title1.Text = people[0].ActivityTitle; image1.ImageUrl = people[0].ActivityImage; image1.PostBackUrl = "/ActivityContent.aspx?id=" + people[0].ActivityId; title2.Text = people[1].ActivityTitle; image2.ImageUrl = people[1].ActivityImage; image2.PostBackUrl = "/ActivityContent.aspx?id=" + people[1].ActivityId; title3.Text = people[2].ActivityTitle; image3.ImageUrl = people[2].ActivityImage; image3.PostBackUrl = "/ActivityContent.aspx?id=" + people[2].ActivityId; } else { Response.Write("<script>alert('地址栏有误');location='/ActivityList.aspx'</script>"); } } } else { Response.Write("<script>alert('地址栏有误');location='/ActivityList.aspx'</script>"); } }
/// <summary> /// 生成第一个大分类下的所有删除的项目 /// </summary> /// <param name="Categroy"></param> /// <returns>返回一个 DataTable 进行分页操作</returns> protected DataTable RptRecoverListBind(string Categroy) { //1为资讯,2为活动,3为短趣 using (var db = new huxiuEntities()) { //结果: 资讯标题(id 绑定到跳转链接) 资讯下面的小分类 删除时间 管理员姓名(绑定id到跳转管理员界面) if (Categroy == "资讯") { var ans = from it in db.DeleteLog //在删除记录表中查找大类 where it.Category == 1 orderby it.DelTime descending //降序排序 join disId in db.Passage //联合查询,显示资讯 Id Title on it.LogId equals disId.PassageId join adminInfo in db.Admin //联合查询,显示管理员的名字和 Id on it.DelAdminId equals adminInfo.AdminId select new MyDataInfo { Id = disId.PassageId, Title = disId.PassageTitle, PassageCate = disId.PassageCategory, Time = it.DelTime, AdminName = adminInfo.AdminName, AdminId = it.DelAdminId, Link = "#", DelCate = 1 }; return(transToDataTable(ans)); } //结果: 活动标题(id 绑定到跳转链接) 删除时间 管理员姓名(绑定id到跳转管理员界面) if (Categroy == "活动") { var ans = from it in db.DeleteLog //在删除记录中查找大类 where it.Category == 2 orderby it.DelTime descending //降序排列 join disId in db.Activity on it.LogId equals disId.ActivityId //联合查询,显示活动 id Title join adminInfo in db.Admin on it.DelAdminId equals adminInfo.AdminId //联合查询,显示管理员的名字和 Id select new MyDataInfo { Id = disId.ActivityId, Title = disId.ActivityTitle, Time = it.DelTime, AdminName = adminInfo.AdminName, AdminId = it.DelAdminId, PassageCate = -1, Link = "#", DelCate = 2 }; return(transToDataTable(ans)); } //结果: 短趣标题( 绑定 link 到跳转链接) 删除时间 管理员姓名(绑定id到跳转管理员界面) else { var ans = from it in db.DeleteLog //在删除记录中查找大类 where it.Category == 3 orderby it.DelTime descending //降序排列 join disId in db.News on it.LogId equals disId.NewsId //联合查询,显示短趣 id Title join adminInfo in db.Admin on it.DelAdminId equals adminInfo.AdminId //联合查询,显示管理员的名字和 Id select new MyDataInfo { Id = disId.NewsId, Title = disId.NewsTitle, Link = disId.NewsLink, Time = it.DelTime, AdminName = adminInfo.AdminName, AdminId = it.DelAdminId, PassageCate = -1, DelCate = 3 }; return(transToDataTable(ans)); } } }
protected void lbtLogin_Click(object sender, EventArgs e) { string username = txtUserName.Text.Trim(); string pwd = txtpwd.Text.Trim(); string captcha = txtCaptcha.Text.Trim(); string trueVali = Session["Vnum"].ToString(); System.Text.RegularExpressions.Regex numberReg = new System.Text.RegularExpressions.Regex("^[0-9]+$"); if (username == "" || pwd == "" || captcha == "") { Response.Write("<script>alert('输入不能有空值!');</script>"); } else { pwd = Security.SHA1_Hash(Security.MD5_hash(pwd)); if (numberReg.IsMatch(captcha)) { if (captcha == trueVali) { try { using (var db = new huxiuEntities()) { Admin ad = db.Admin.SingleOrDefault(a => a.AdminName == username && a.AdminPassword == pwd); if (ad == null) { Response.Write("<script>alert('用户名或密码错误,请重新输入!');location.href='login.aspx';</script>"); } else { Session["AdminID"] = ad.AdminId; Response.Write("<script>alert('登录成功!');location.href='huxiu-backstage.html';</script>"); } } } catch { Response.Write("<script>alert('网络阻塞,刷新重试!');location.href='login.aspx';</script>"); } } else { Response.Write("<script>alert('验证码不正确,请重新输入!');location.href='login.aspx';</script>"); } } else { Response.Write("<script>alert('验证码输入不合法!');location.href='login.aspx';</script>"); } } }
protected void Rpt_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "delete") { int authorId = Convert.ToInt32(e.CommandArgument); using (var db = new huxiuEntities()) { Author au = db.Author.SingleOrDefault(a => a.AuthorId == authorId); db.Author.Remove(au); db.SaveChanges(); Response.Write("<script>alert('作者删除成功!');location='AuthorList.aspx';</script>"); } } }
protected void Rpt_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "delete") { int pcId = Convert.ToInt32(e.CommandArgument); using (var db = new huxiuEntities()) { PassageCategory pc = db.PassageCategory.SingleOrDefault(a => a.PCategoryId == pcId); db.PassageCategory.Remove(pc); db.SaveChanges(); Response.Write("<script>alert('分类删除成功!');location='PCategoryList.aspx';</script>"); } } }
protected void btnEditor_Click(object sender, EventArgs e) { int id = Convert.ToInt32(Request.QueryString["id"]); if (title.Text.Trim().Length > 0 && content.Text.Trim().Length > 0 && link.Text.Trim().Length > 0) { //string Pattern = @"^(http|https|ftp)\://([a-zA-Z0-9\.\-]+(\:[a-zA-Z0-9\.&%\$\-]+)*@)?((25[0-5]|2[0-4][0-9]|[0-1]{1}[0-9]{2}|[1-9]{1}[0-9]{1}|[1-9])\.(25[0-5]|2[0-4][0-9]|[0-1]{1}[0-9]{2}|[1-9]{1}[0-9]{1}|[1-9]|0)\.(25[0-5]|2[0-4][0-9]|[0-1]{1}[0-9]{2}|[1-9]{1}[0-9]{1}|[1-9]|0)\.(25[0-5]|2[0-4][0-9]|[0-1]{1}[0-9]{2}|[1-9]{1}[0-9]{1}|[0-9])|([a-zA-Z0-9\-]+\.)*[a-zA-Z0-9\-]+\.[a-zA-Z]{2,4})(\:[0-9]+)?(/[^/][a-zA-Z0-9\.\,\?\'\\/\+&%\$#\=~_\-@]*)*$"; string Pattern = @"(http|https)://[^\s]*"; Regex r = new Regex(Pattern); if (r.IsMatch(link.Text.Trim())) { using (var db = new huxiuEntities())//修改短趣 { News person = (from it in db.News where it.NewsId == id select it).FirstOrDefault(); if (person.NewsTitle == title.Text.Trim() && person.NewsBody == content.Text && person.NewsLink == link.Text.Trim()) { Response.Write("<script>alert('未修改');location='NewsEditor.aspx?id=" + id + "'</script>"); } else { person.NewsTitle = title.Text.Trim(); //标题 person.NewsBody = content.Text; //内容 // person.NewsDate = Convert.ToDateTime(dates.Text);//发布时间不做修改 person.NewsLink = link.Text.Trim(); //超链接 // person.IsDel = false;//是否删除 if (db.SaveChanges() == 1) { Response.Write("<script>alert('编辑成功');location='NewsEditor.aspx?id=" + id + "'</script>"); } else { Response.Write("<script>alert('编辑失败请重试')</script>"); } } } } else { Response.Write("<script>alert('格式错误')</script>"); } } else { Response.Write("<script>alert('不能为空')</script>"); } }
protected void DplistCategory_TextChanged(object sender, EventArgs e) { if (DplistCategory.SelectedValue != "-- > 请选择类别 < --") { if (DplistCategory.SelectedValue == "资讯") { //绑定数据 _DT = RptRecoverListBind("资讯"); pds_dt = _DT.Copy(); JumpPage(pds_dt, 1); //显示资讯下面的详细标签 using (var db = new huxiuEntities()) { var DptDataSource = from it in db.DeleteLog where it.Category == 1 join disId in db.Passage on it.LogId equals disId.PassageId join itOk in db.PassageCategory on disId.PassageCategory equals itOk.PCategoryId select itOk.CategoryName; HashSet <string> hs = new HashSet <string>(DptDataSource);//去出重复字符串 DplistPassageLable.DataSource = hs.ToList(); DplistPassageLable.DataBind(); } DplistPassageLable.Visible = true; ListItem lt = new ListItem(); lt.Text = "-->请选择类别<--"; lt.Selected = true; DplistPassageLable.Items.Add(lt); } else { //绑定数据 _DT = RptRecoverListBind(DplistCategory.SelectedValue); pds_dt = _DT.Copy(); JumpPage(pds_dt, 1); DplistPassageLable.Visible = false; } } else //请选默认显示 资讯 类 { //绑定数据 pds_dt = RptRecoverListBind("资讯"); JumpPage(pds_dt, 1); DplistPassageLable.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { Regex r = new Regex("^[1-9]d*|0$"); if (Session["AdminID"] == null) { Response.Write("<script>alert('账户过期请重新登录!');window.parent.location.href='login.aspx';</script>"); } else if (!IsPostBack) { if (Request.QueryString["id"] != null && r.IsMatch(Request.QueryString["id"])) //要把是否为空放前面 { int id = Convert.ToInt32(Request.QueryString["id"]); //获取id using (var db = new huxiuEntities()) { Activity person = (from it in db.Activity where it.ActivityId == id select it).FirstOrDefault(); if (person != null) { title.Text = person.ActivityTitle; //标题 content.Text = person.ActivityWhat; //内容 image.ImageUrl = person.ActivityImage; //封面 when.Text = person.ActivityWhen.ToString(); //时间 requestedDeliveryDateTextBox.Text = person.ActivityWhen.ToString(); //时间 where.Text = person.ActivityWhere; //地点 tips.Text = person.ActivityTips; //备注 } else { Response.Write("<script>alert('地址栏有误');location='ActivityList.aspx'</script>"); } } } else { Response.Write("<script>alert('地址栏有误');location='ActivityList.aspx'</script>"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["AdminID"] != null) { using (var db = new huxiuEntities()) { var datascore = from it in db.PassageInformation where it.IsDel == false orderby it.PublishDate descending select it; var ds = datascore.ToList(); Session["ds"] = ds; DataBindToRepeater(1, ds); } using (var db = new huxiuEntities()) { var datascore = from it in db.PassageCategory select it; this.DropDownList.DataSource = datascore.ToList(); this.DropDownList.DataValueField = "PCategoryId"; this.DropDownList.DataTextField = "CategoryName"; this.DropDownList.DataBind(); ListItem item = new ListItem(); item.Text = "全部"; item.Value = "0"; this.DropDownList.Items.Insert(0, item); } } else { Response.Write("<script>alert('账户过期请重新登录!');window.parent.location.href='login.aspx';</script>"); } } }
protected void btnAdd_Click(object sender, EventArgs e) { if (title.Text.Trim().Length > 0 && content.Text.Trim().Length > 0 && link.Text.Trim().Length > 0) { //(http|https)://[^\s]* //string Pattern = @"^(http|https|ftp)\://([a-zA-Z0-9\.\-]+(\:[a-zA-Z0-9\.&%\$\-]+)*@)?((25[0-5]|2[0-4][0-9]|[0-1]{1}[0-9]{2}|[1-9]{1}[0-9]{1}|[1-9])\.(25[0-5]|2[0-4][0-9]|[0-1]{1}[0-9]{2}|[1-9]{1}[0-9]{1}|[1-9]|0)\.(25[0-5]|2[0-4][0-9]|[0-1]{1}[0-9]{2}|[1-9]{1}[0-9]{1}|[1-9]|0)\.(25[0-5]|2[0-4][0-9]|[0-1]{1}[0-9]{2}|[1-9]{1}[0-9]{1}|[0-9])|([a-zA-Z0-9\-]+\.)*[a-zA-Z0-9\-]+\.[a-zA-Z]{2,4})(\:[0-9]+)?(/[^/][a-zA-Z0-9\.\,\?\'\\/\+&%\$#\=~_\-@]*)*$"; string Pattern = @"(http|https)://[^\s]*"; Regex r = new Regex(Pattern); if (r.IsMatch(link.Text.Trim())) { using (var db = new huxiuEntities()) { News person = new News { NewsTitle = title.Text.Trim(), NewsBody = content.Text.Trim(), NewsDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), //发表时间 NewsLink = link.Text.Trim(), IsDel = false }; db.News.Add(person); if (db.SaveChanges() == 1) { Response.Write("<script>alert('添加成功');location='NewsList.aspx'</script>"); } else { Response.Write("<script>alert('添加失败请重试')</script>"); } } } else { Response.Write("<script>alert('请输入正确的网址')</script>"); } } else { Response.Write("<script>alert('不能为空')</script>"); } }