public ActionResult News(int id)
{
NewsBLL newsBLL = new NewsBLL();
NewsObj newsObj = newsBLL.GetNews(id);
if (newsObj != null)
{
ViewBag.news = newsObj;
ViewBag.nextNews = newsBLL.GetNextNews(id, newsObj.CategoryID);
ViewBag.prevNews = newsBLL.GetPrevNews(id, newsObj.CategoryID);
NewsCateObj newsCateObj = newsBLL.GetNewsCateByCateID(newsObj.CategoryID);
int total;
JsonArray cates = newsBLL.GetNewsCates(newsCateObj.ParentID);
if (cates != null)
{
for (int i = 0; i < cates.Count; i++)
{
int categoryID = (int)cates[i]["categoryID"];
cates[i]["news"] = newsBLL.GetNews(categoryID, null, DateTime.MinValue, DateTime.MinValue, 1, 100, out total);
}
}
ViewBag.cates = cates;
}
return(View());
}
public NewsObj GetNextNews(int newsID, int categoryId)
{
using (helper = new SqlHelper())
{
helper.AddIntParameter("@NewsID", newsID);
helper.AddIntParameter("@CategoryID", categoryId);
string sql = "select top 1 Title,Writer,Clicks,PublishDate,Content,Tags,CategoryID,Sort,NewsID from News where NewsID>@NewsID and CategoryID=@CategoryID";
using (SqlDataReader dr = helper.ExecuteReader(sql, CommandType.Text))
{
if (dr.HasRows && dr.Read())
{
NewsObj newsObj = new NewsObj();
newsObj.Title = (string)dr[0];
newsObj.Writer = dr[1] == DBNull.Value ? null : (string)dr[1];
newsObj.Clicks = dr[2] == DBNull.Value ? 0 : (int)dr[2];
newsObj.PublishDate = dr[3] == DBNull.Value ? DateTime.MinValue : (DateTime)dr[3];
newsObj.Content = dr[4] == DBNull.Value ? null : (string)dr[4];
newsObj.Tags = dr[5] == DBNull.Value ? null : (string)dr[5];
newsObj.CategoryID = dr[6] == DBNull.Value ? 0 : (int)dr[6];
newsObj.Sort = dr[7] == DBNull.Value ? DateTime.MinValue : (DateTime)dr[7];
newsObj.NewsID = (int)dr[8];
return(newsObj);
}
return(null);
}
}
}
public ActionResult GetNewsByID(int id)
{
NewsBLL newsBLL = new NewsBLL();
NewsObj result = newsBLL.GetNews(id);
if (result != null)
{
return(Json(new { success = true, data = result, date = result.PublishDate.ToString("yyyy-MM-dd"), time = result.PublishDate.ToString("HH:mm") }));
}
else
{
return(Json(new { success = false, msg = "该新闻不存在" }));
}
}
public ActionResult AddNews()
{
if (!AppData.IsManagerLogin)
{
return(Json(new { success = false, msg = "您未登录后台或会话已过期" }));
}
if (PrivilegeBLL.HasNotPrivilege(AppData.SessionUserID, 201))
{
return(Json(new { success = false, msg = "您没有执行该操作的权限" }));
}
Validation validation = new Validation();
NewsObj newsObj = new NewsObj();
newsObj.CategoryID = validation.GetInt("categoryID");
newsObj.Title = validation.Get("title", false, "请填写新闻标题");
newsObj.Writer = validation.Get("writer");
newsObj.Tags = validation.Get("tags");
newsObj.PublishDate = DateTime.Now;
newsObj.Content = HttpUtility.UrlDecode(validation.Get("content", false, "请填写新闻内容"), Encoding.UTF8);
if (validation.HasError || newsObj.CategoryID == 0)
{
return(Json(new { success = false, msg = "参数错误", errors = validation.GetErrors() }));
}
newsObj.Sort = DateTime.Now;
newsObj.Clicks = 0;
NewsBLL newsBLL = new NewsBLL();
newsBLL.AddNews(newsObj);
if (newsObj.NewsID != 0)
{
return(Json(new { success = true, id = newsObj.NewsID }));
}
else
{
return(Json(new { success = false, msg = "抱歉，添加失败！" }));
}
}
public void ModifyNews(NewsObj newsObj)
{
using (helper = new SqlHelper())
{
helper.BeginTran();
helper.AddIntParameter("@NewsID", newsObj.NewsID);
helper.AddStringParameter("@Title", 400, newsObj.Title);
helper.AddStringParameter("@Writer", 200, newsObj.Writer);
helper.AddIntParameter("@Clicks", newsObj.Clicks);
helper.AddDateTimeParameter("@PublishDate", newsObj.PublishDate);
helper.AddTextParameter("@Content", newsObj.Content);
helper.AddStringParameter("@Tags", 100, newsObj.Tags);
helper.AddIntParameter("@CategoryID", newsObj.CategoryID);
helper.AddDateTimeParameter("@Sort", newsObj.Sort);
string sql = "update News set Title=@Title,Writer=@Writer,Clicks=@Clicks,PublishDate=@PublishDate,Content=@Content,Tags=@Tags,CategoryID=@CategoryID,Sort=@Sort where NewsID=@NewsID";
helper.ExecuteNonQuery(sql, CommandType.Text);
helper.CommitTran();
}
}
public void AddNews(NewsObj newsObj)
{
using (helper = new SqlHelper())
{
helper.BeginTran();
SqlParameter idParam = helper.AddOutputParameter("@NewsID");
helper.AddStringParameter("@Title", 400, newsObj.Title);
helper.AddStringParameter("@Writer", 200, newsObj.Writer);
helper.AddIntParameter("@Clicks", newsObj.Clicks);
helper.AddDateTimeParameter("@PublishDate", newsObj.PublishDate);
helper.AddTextParameter("@Content", newsObj.Content);
helper.AddStringParameter("@Tags", 100, newsObj.Tags);
helper.AddIntParameter("@CategoryID", newsObj.CategoryID);
helper.AddDateTimeParameter("@Sort", newsObj.Sort);
string sql = "insert into News (Title,Writer,Clicks,PublishDate,Content,Tags,CategoryID,Sort) values (@Title,@Writer,@Clicks,@PublishDate,@Content,@Tags,@CategoryID,@Sort) select @NewsID=@@IDENTITY";
helper.ExecuteNonQuery(sql, CommandType.Text);
newsObj.NewsID = (int)idParam.Value;
if (newsObj.Pages != null)
{
helper.ClearParameters();
helper.AddIntParameter("@NewsID", newsObj.NewsID);
helper.AddIntParameter("@Page", 0);
helper.AddTextParameter("@Content", null);
sql = "insert into NewsPages (NewsID,Page,Content) values (@NewsID,@Page,@Content)";
for (int i = 0; i < newsObj.Pages.Count; i++)
{
helper.SetParameter("@Page", newsObj.Pages[i].Page);
helper.SetParameter("@Content", newsObj.Pages[i].Content);
helper.ExecuteNonQuery(sql, CommandType.Text);
}
}
helper.CommitTran();
}
}
public ActionResult ModifyNews()
{
if (!AppData.IsManagerLogin)
{
return(Json(new { success = false, msg = "您未登录后台或会话已过期" }));
}
if (PrivilegeBLL.HasNotPrivilege(AppData.SessionUserID, 202))
{
return(Json(new { success = false, msg = "您没有执行该操作的权限" }));
}
Validation validation = new Validation();
NewsBLL newsBLL = new NewsBLL();
int newsId = validation.GetInt("id");
NewsObj newsObj = newsBLL.GetNews(newsId);
if (newsObj == null)
{
return(Json(new { success = false, msg = "您要修改的新闻不存在" }));
}
newsObj.Title = validation.Get("title", false, "请填写新闻标题");
newsObj.Writer = validation.Get("writer");
newsObj.Tags = validation.Get("tags");
newsObj.Content = HttpUtility.UrlDecode(validation.Get("content", false, "请填写新闻内容"), Encoding.UTF8);
if (validation.HasError)
{
return(Json(new { success = false, msg = "参数错误", errors = validation.GetErrors() }));
}
newsObj.Sort = DateTime.Now;
newsObj.Clicks = 0;
newsBLL.ModifyNews(newsObj);
return(Json(new { success = true }));
}
public void ModifyNews(NewsObj newsObj)
{
dal.ModifyNews(newsObj);
}
public void AddNews(NewsObj newsObj)
{
dal.AddNews(newsObj);
}
