public ActionResult Index(int page = 1)
{
if (db.CatCurrency.Count() != 0)
{
if (DateTime.Now.Subtract(db.CatCurrency.First().DateLoad) > new TimeSpan(1, 0, 0, 0))
{
CurrencyUpdate();
}
}
else
{
CurrencyUpdate();
}
ViewArticle model = new ViewArticle();
model.Articles = db.Articles.Include(o => o.Category).Include(o => o.Type).Where(o => o.CategoryId < 8).OrderByDescending(o => o.DateOrd);
model.AllCurrency = db.CatCurrency.Where(c => c.curVisible == true);
model.PolezArt = db.Articles.Where(a => a.CategoryId == 13);
model.PagingInfo = new PagingInfo
{
CurrentPage = page,
ItemsPerPage = pageSize,
TotalItems = model.Articles.Count()
};
model.Articles = model.Articles.Skip((page - 1) * pageSize).Take(pageSize);
return(View(model));
}
public JsonResult SaveTree()
{
string result = "";
try
{
string data = Request["data"];
string delNode = Request["delNode"];
ViewArticle <ViewNode> nodes = DataJsonSerializer <ViewArticle <ViewNode> > .JsonToEntity(data);
result = SaveAllNode(nodes.detailList, delNode);
}
catch (Exception ex)
{
result = ex.Message;
}
return(Json(new { Data = result }, JsonRequestBehavior.AllowGet));
}
public ActionResult MoveMenu(int?categ, int?type, int page = 1)
{
ViewArticle model = new ViewArticle();
model.Articles = db.Articles.Include(o => o.Category).Include(o => o.Type).Where(a => a.CategoryId == categ).Where(a => a.TypeId == type).OrderByDescending(o => o.DateOrd);
model.AllCurrency = db.CatCurrency.Where(c => c.curVisible == true);
model.PolezArt = db.Articles.Where(a => a.CategoryId == 13);
model.PagingInfo = new PagingInfo
{
CurrentPage = page,
ItemsPerPage = pageSize,
TotalItems = model.Articles.Count()
};
model.Articles = model.Articles.Skip((page - 1) * pageSize).Take(pageSize);
if (model.Articles.Count() == 0)
{
return(RedirectToAction("Index"));
}
else
{
return(View(model));
}
}
//文章列表
public ActionResult Article(string commandName, int?page)
{
try
{
System.Linq.IQueryable <PersonalWebsite.Models.Article> article;
int year = 0, month = 0;
string type = null;
if (Request["year"] != null && Request["year"] != "")
{
year = Convert.ToInt32(Request["year"]);
}
if (Request["yearMonth"] != null && Request["yearMonth"] != "")
{
year = Convert.ToInt32(Request["yearMonth"].Split('-')[0]);
month = Convert.ToInt32(Request["yearMonth"].Split('-')[1]);
}
if (Request["type"] != null && Request["type"] != "")
{
type = Request["type"];
}
//进行查询
if (year != 0 && month == 0)
{
//使用LINQ进行查询
article = from n in db7.Article
where n.ArticleDate.Year == year
select n;
}
else if (year != 0 && month != 0)
{
//使用LINQ进行查询
article = from n in db7.Article
where n.ArticleDate.Year == year && n.ArticleDate.Month == month
select n;
}
else if (type != null)
{
//使用LINQ进行查询
article = from n in db7.Article
where n.ArticleType == type
select n;
}
else
{
article = from n in db7.Article
select n;
}
//进行分页
article = article.OrderByDescending(n => n.ArticleID);
const int pageItems = 10;
int currentPage = (page ?? 1);
IPagedList <Article> pageArticle = article.ToPagedList(currentPage, pageItems);
ViewArticle varticle = new ViewArticle();
varticle.ArticleList = pageArticle;
varticle.year = year;
varticle.month = month;
varticle.type = type;
return(View("Article", varticle));
}
catch (Exception ex)
{
return(Content("<script>alert('Wrong arguments!');location.href='/Home/Article';</script>"));
}
}
public JsonResult SaveArticle()
{
bool result = false;
string msg = "";
using (TransactionScope scope = new TransactionScope())
{
try
{
string data = Request["data"];
string deleteId = Request["deleteId"];
int nodeId = 0;
int _orders = 1;
ViewArticle <ViewModifyArticle> article = DataJsonSerializer <ViewArticle <ViewModifyArticle> > .JsonToEntity(data);
List <string> decodeList = new List <string>();
var imageList = article.detailList.Where(p => p.Type == "image");
var videoList = article.detailList.Where(p => p.Type == "video");
foreach (ViewModifyArticle detail in article.detailList)
{
string detailId = detail.detailId;
string detailType = detail.Type;
string detailContent = HttpUtility.UrlDecode(detail.Content);
//添加主标题
if (detailType == "title")
{
Node dbNode = db.Nodes.Find(int.Parse(detail.detailId));
nodeId = int.Parse(detailId);
dbNode.nodeName = detailContent;
if (imageList.Count() > 0)
{
dbNode.url = HttpUtility.UrlDecode(imageList.ToList()[0].Content);
}
else
{
dbNode.url = "";//默认图片
}
if (videoList.Count() > 0)
{
dbNode.isVideo = 1;
}
else
{
dbNode.isVideo = 0;
}
if (article.detailList.Count > 1)
{
dbNode.isUsable = 1;
}
else
{
dbNode.isUsable = 0;
}
db.SaveChanges();
}
else
{
if (detail.detailId == "")
{
ArticleDetail details = new ArticleDetail();
details.nodeId = nodeId;
details.detailType = detailType;
details.detailContent = detailContent;
details.souceFileName = HttpUtility.UrlDecode(detail.sourceFileName);
details.orders = _orders;
details.lastUpdateDate = DateTime.Now;
db.ArticleDetail.Add(details);
}
else
{
ArticleDetail details = db.ArticleDetail.Find(int.Parse(detail.detailId));
if ((details.detailType == "image" || details.detailType == "video") && details.detailContent != detailContent)
{
Util.DeleteBlog(details.detailContent);//新文件与原文件不是同一文件，则删除旧文件
}
details.detailContent = detailContent;
details.souceFileName = HttpUtility.UrlDecode(detail.sourceFileName);
details.orders = _orders;
details.lastUpdateDate = DateTime.Now;
}
db.SaveChanges();
_orders++;
}
}
if (deleteId != "")
{
string[] delIdAry = deleteId.TrimEnd('|').Split('|');
foreach (string detailId in delIdAry)
{
ArticleDetail detail = db.ArticleDetail.Find(int.Parse(detailId));
if (detail.detailType == "image" || detail.detailType == "video")
{
Util.DeleteBlog(detail.detailContent);//删除文件
}
db.ArticleDetail.Remove(detail);
db.SaveChanges();
}
}
scope.Complete();
result = true;
msg = "保存成功";
}
catch (Exception ex)
{
msg = ex.Message;
}
finally
{
scope.Dispose();
}
}
return(Json(new { Result = result, Msg = msg }, JsonRequestBehavior.AllowGet));
}
public JsonResult AddNewArticle()
{
bool result = false;
string msg = "";
int nodeId = 0;
using (TransactionScope scope = new TransactionScope())
{
try
{
string parentId = Request["parentId"];
string data = Request["data"];
int _parentId = int.Parse(parentId);
int _orders = 1;
ViewArticle <ViewArticleDetail> article = DataJsonSerializer <ViewArticle <ViewArticleDetail> > .JsonToEntity(data);
List <string> decodeList = new List <string>();
var imageList = article.detailList.Where(p => p.Type == "image");
var videoList = article.detailList.Where(p => p.Type == "video");
foreach (ViewArticleDetail detail in article.detailList)
{
string detailType = detail.Type;
string detailContent = HttpUtility.UrlDecode(detail.Content);
//添加主标题
if (detailType == "title")
{
Node dbNode = new Node();
dbNode.parentId = _parentId;
dbNode.nodeName = detailContent;
if (imageList.Count() > 0)
{
dbNode.url = HttpUtility.UrlDecode(imageList.ToList()[0].Content);
}
else
{
dbNode.url = "";//默认图片
}
dbNode.isArticle = 1;
if (videoList.Count() > 0)
{
dbNode.isVideo = 1;
}
if (article.detailList.Count > 1)
{
dbNode.isUsable = 1;
}
else
{
dbNode.isUsable = 0;
}
dbNode.createPerson = t_userName;
dbNode.createDate = DateTime.Now;
db.Nodes.Add(dbNode);
db.SaveChanges();
nodeId = dbNode.nodeId; //数据库生成的Id
}
else
{
ArticleDetail details = new ArticleDetail();
details.nodeId = nodeId;
details.detailType = detailType;
details.detailContent = detailContent;
details.souceFileName = HttpUtility.UrlDecode(detail.sourceFileName);
details.orders = _orders;
details.lastUpdateDate = DateTime.Now;
db.ArticleDetail.Add(details);
db.SaveChanges();
_orders++;
}
}
scope.Complete();
result = true;
msg = "保存成功";
}
catch (Exception ex)
{
msg = ex.Message;
}
finally
{
scope.Dispose();
}
}
return(Json(new { Result = result, Msg = msg, nodeId = nodeId }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// method to add an article
/// </summary>
/// <param name="viewArticle">article</param>
public void AddArticle(ViewArticle viewArticle)
{
var article = new Article(viewArticle.name, viewArticle.date, viewArticle.content);
articleContext.AddArticle(article);
}
