/// <summary> /// 添加一新闻信息 /// </summary> /// <param name="n">网站信息</param> /// <returns>返回是否添加成功</returns> public Boolean AddNews(News n) { try { string sql = "insert into news(type_id,gameid,type,title,keyword,photo,source,news_content,sort_id,is_top,is_red,is_hot,is_slide,is_lock,namecolor)" + "values (@TypeId,@GameId,@Type,@Title,@KeyWord,@Photo,@Source,@NewsContent,@SortId,@IsTop,@IsRed,@IsHot,@IsSlide,@IsLock,@NameColor)"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@TypeId",n.TypeId), new SqlParameter("@GameId",n.GameId), new SqlParameter("@Type",n.Type), new SqlParameter("@Title", n.Title), new SqlParameter("@KeyWord",n.KeyWord), new SqlParameter("@Photo",n.Photo), new SqlParameter("@Source",n.Source), new SqlParameter("@NewsContent",n.NewsContent), new SqlParameter("@SortId",n.SortId), new SqlParameter("@IsTop",n.IsTop), new SqlParameter("@IsRed", n.IsRed), new SqlParameter("@IsHot",n.IsHot), new SqlParameter("@IsSlide",n.IsSlide), new SqlParameter("@IsLock",n.IsLock), new SqlParameter("@NameColor",n.NameColor) }; return db.ExecuteNonQuery(sql, sp); } catch (SqlException ex) { throw new Exception("数据库异常!原因:" + ex.Message); } catch (Exception ex) { throw new Exception("未知异常!原因:" + ex.Message); } }
public Boolean DoAddNews() { if (Session[Keys.SESSION_ADMIN_INFO] == null) { return false; } else { Master master = Session[Keys.SESSION_ADMIN_INFO] as Master; if (rcm.GetRoleCompetence(master.RoleId, 11212)) { News n = new News(); n.GameId = int.Parse(Request["GameId"]); n.Type = int.Parse(Request["Type"]); n.Title = Request["Title"]; n.NameColor = Request["NameColor"]; n.IsHot = Request["IsHot"] == "on" ? 1 : 0; n.IsRed = Request["IsRed"] == "on" ? 1 : 0; n.IsTop = Request["IsTop"] == "on" ? 1 : 0; n.KeyWord = string.IsNullOrEmpty(Request["KeyWord"]) ? "" : Request["KeyWord"]; n.Source = string.IsNullOrEmpty(Request["Source"]) ? "本站" : Request["Source"]; n.SortId = int.Parse(string.IsNullOrEmpty(Request["SortId"]) ? "99" : Request["SortId"]); n.Photo = string.IsNullOrEmpty(Request["Photo"]) ? "" : Request["Photo"]; n.NewsContent = Request["NewsContent"]; return nm.AddNews(n); } else { return false; } } }
public ActionResult News(int N) { News news = new News(); news = nm.GetNews(N); ViewData["NewsTitle"] = news.Title; ViewData["Game"] = gm.GetGame(news.GameId).Name; ViewData["Time"] = news.ReleaseTime; ViewData["NewsContent"] = news.NewsContent; return View(); }
/// <summary> /// 添加一新闻信息 /// </summary> /// <param name="n">网站信息</param> /// <returns>返回是否添加成功</returns> public Boolean AddNews(News n) { return ns.AddNews(n); }
/// <summary> /// 更新一条新闻信息 /// </summary> /// <param name="n">新闻信息</param> /// <returns>返回是否更新成功</returns> public Boolean UpdateNews(News n) { return ns.UpdateNews(n); }
public ActionResult EditNews(int NewsId) { if (Session[Keys.SESSION_ADMIN_INFO] == null) { return RedirectToAction("Login", "Admin"); } else { Master master = Session[Keys.SESSION_ADMIN_INFO] as Master; if (rcm.GetRoleCompetence(master.RoleId, 11211)) { News news = new News(); news = nm.GetNews(NewsId); ViewData["GameId"] = news.GameId; ViewData["Type"] = news.Type; ViewData["Title"] = news.Title; ViewData["NameColor"] = news.NameColor; ViewData["IsHot"] = news.IsHot == 1 ? true : false; ViewData["IsRed"] = news.IsRed == 1 ? true : false; ViewData["IsTop"] = news.IsTop == 1 ? true : false; ViewData["KeyWord"] = news.KeyWord; ViewData["Source"] = news.Source; ViewData["SortId"] = news.SortId; ViewData["Photo"] = news.Photo; ViewData["NewsContent"] = news.NewsContent; ViewData["NewsId"] = news.Id; ViewData["Function"] = "UpdateData('/News/UpdateNews')"; return View("News"); } else { return RedirectToAction("Login", "Admin"); } } }
/// <summary> /// 更新一条新闻信息 /// </summary> /// <param name="n">新闻信息</param> /// <returns>返回是否更新成功</returns> public Boolean UpdateNews(News n) { try { string sql = "update news set type_id=@TypeId,gameid=@GameId,type=@Type,title=@Title,keyword=@KeyWord," + "photo=@Photo,source=@Source,news_content=@NewsContent,sort_id=@SortId,is_top=@IsTop,is_red=@IsRed," + "is_hot=@IsHot,is_slide=@IsSlide,is_lock=@IsLock,namecolor=@NameColor where id=@Id "; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@TypeId",n.TypeId), new SqlParameter("@GameId",n.GameId), new SqlParameter("@Type",n.Type), new SqlParameter("@Title", n.Title), new SqlParameter("@KeyWord",n.KeyWord), new SqlParameter("@Photo",n.Photo), new SqlParameter("@Source",n.Source), new SqlParameter("@NewsContent",n.NewsContent), new SqlParameter("@SortId",n.SortId), new SqlParameter("@IsTop",n.IsTop), new SqlParameter("@IsRed",n.IsRed), new SqlParameter("@IsHot", n.IsHot), new SqlParameter("@IsSlide",n.IsSlide), new SqlParameter("@IsLock",n.IsLock), new SqlParameter("@NameColor",n.NameColor), new SqlParameter("@Id",n.Id) }; return db.ExecuteNonQuery(sql, sp); } catch (SqlException ex) { throw new Exception("数据库异常!原因:" + ex.Message); } catch (Exception ex) { throw new Exception("未知异常!原因:" + ex.Message); } }
/// <summary> /// 获取最新几条新闻 /// </summary> /// <param name="Top">前几条</param> /// <param name="Type">类型</param> /// <param name="GameId">游戏Id</param> /// <returns>返回新闻集合</returns> public List<News> GetNews(int Top, int Type, int GameId) { List<News> list = new List<News>(); try { string sql = ""; SqlParameter[] sp; if (Type > 0) { sql = "select top " + Top + " * from news where type=@Type and gameid=@GameId order by release_time desc"; sp = new SqlParameter[]{ new SqlParameter("@Type",Type), new SqlParameter("@GameId",GameId) }; } else { sql = "select top " + Top + " * from news where gameid=@GameId order by release_time desc"; sp = new SqlParameter[]{ new SqlParameter("@GameId",GameId) }; } using (SqlDataReader reder = db.GetReader(sql, sp)) { while (reder.Read()) { News n = new News((int)reder["id"], (int)reder["type_id"], (int)reder["gameid"], (int)reder["type"], reder["title"].ToString(), reder["keyword"].ToString(), (DateTime)reder["release_time"], reder["photo"].ToString(), reder["source"].ToString(), reder["news_content"].ToString(), (int)reder["sort_id"], reder["seo_title"].ToString(), reder["seo_keyword"].ToString(), reder["seo_desc"].ToString(), (int)reder["is_top"], (int)reder["is_red"], (int)reder["is_hot"], (int)reder["is_slide"], (int)reder["is_lock"], reder["namecolor"].ToString()); list.Add(n); } } } catch (SqlException ex) { throw new Exception("数据库异常!原因:" + ex.Message); } catch (Exception ex) { throw new Exception("未知异常!原因:" + ex.Message); } return list; }
/// <summary> /// 获取一条新闻信息 /// </summary> /// <param name="NewsId">新闻Id</param> /// <returns>返回新闻信息</returns> public News GetNews(int NewsId) { News n = new News(); try { string sql = "select * from news where id=@NewsId"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@NewsId",NewsId) }; using (SqlDataReader reder = db.GetReader(sql, sp)) { while (reder.Read()) { n = new News(NewsId, (int)reder["type_id"], (int)reder["gameid"], (int)reder["type"], reder["title"].ToString(), reder["keyword"].ToString(), (DateTime)reder["release_time"], reder["photo"].ToString(), reder["source"].ToString(), reder["news_content"].ToString(), (int)reder["sort_id"], reder["seo_title"].ToString(), reder["seo_keyword"].ToString(), reder["seo_desc"].ToString(), (int)reder["is_top"], (int)reder["is_red"], (int)reder["is_hot"], (int)reder["is_slide"], (int)reder["is_lock"], reder["namecolor"].ToString()); } } } catch (SqlException ex) { throw new Exception("数据库异常!原因:" + ex.Message); } catch (Exception ex) { throw new Exception("未知异常!原因:" + ex.Message); } return n; }