protected void Page_Load(object sender, EventArgs e) { LoadNewsCat(LoadOldNews()); if (IsPostBack) { MODEL.News model = new MODEL.News(); model.Id = Convert.ToInt32(Context.Request.QueryString["id"]); model.Catid = Convert.ToInt32(Request.Form["selNewsCate"]); model.Ntitle = Request.Form["title"]; model.Ncontent = Request.Form["myeditor"]; BLL.News bllNews = new BLL.News(); if (bllNews.ModifyNews(model) > 0) { Context.Response.Write("<script>alert('修改成功啦!')</script>"); } } }
/// <summary> /// /// </summary> /// <param name="cid"></param> /// <returns></returns> public List<MODEL.News> GetNewsBycid(int cid) { string sql = "select * from news inner join newsCat on news.catid=newsCat.id where news.isdelete=0 and news.catid=@cid order by ncreatedate desc"; MySqlParameter sp = new MySqlParameter("@cid", cid); List<MODEL.News> list = new List<MODEL.News>(); DataTable dt = MySqlHelper.ExcuteDataTable(sql, sp); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { MODEL.News model = new MODEL.News(); LoadEntityData(model, dr); list.Add(model); } } return list; }
public List<MODEL.News> GetAllNews() { using (MagazineDBEntities cntxt = new MagazineDBEntities()) { var newsList = new List<MODEL.News>(); var newsListDAL = cntxt.News.ToList(); foreach (var n in newsListDAL) { var news = new MODEL.News(); news.NewsID = n.NewsID; newsList.Add(news); } return newsList; } }
protected void Page_Load(object sender, EventArgs e) { LoadNewsCat(); if (IsPostBack) { MODEL.News model = new MODEL.News(); model.Ntitle = Request.Form["title"]; model.Ncontent = Request.Form["editor01"]; model.Catid = Convert.ToInt32(Request.Form["selNewsCate"]); BLL.News bllNews = new BLL.News(); if (bllNews.AddNews(model)) { Response.Write("<script>alert('添加成功!')</script>"); } else { Response.Write("失败!请重试!"); } } }