public List <mArticle> fArticlesListMostVisited(int pGet, int pSkip, mArticle pArticle, mHome pHome)
{
var vArticles = (from a in Db.tbl_article
where a.article_visit > 0 && a.article_type == pArticle.article_type
select new mArticle
{
article_id = a.article_id,
article_exp = a.article_exp,
article_title = a.article_title,
article_file = a.article_file,
article_img = a.article_img,
article_img2 = a.article_img2,
article_img3 = a.article_img3,
article_img_alt = a.article_img_alt,
article_summery = a.article_summery,
article_date = a.article_date,
article_writer = a.article_writer,
article_href = a.article_href,
article_code = a.article_code,
article_visit = a.article_visit,
article_type = a.article_type
}).OrderByDescending(b => b.article_id).Skip(pSkip).Take(pGet);
return(vArticles.ToList());
}
public mArticle fGetArticles(mArticle pArticles)
{
try
{
var vArticles = (from a in Db.tbl_article
where a.article_id.Equals(pArticles.article_id)
select new mArticle
{
article_id = a.article_id,
article_img_alt = a.article_img_alt,
article_summery = a.article_summery,
article_exp = a.article_exp,
article_writer = a.article_writer,
article_file = a.article_file,
article_img = a.article_img,
article_img2 = a.article_img2,
article_img3 = a.article_img3,
article_title = a.article_title,
article_date = a.article_date,
article_visit = a.article_visit,
article_img_height = a.article_img_height,
article_img_width = a.article_img_width,
article_href = a.article_href,
article_code = a.article_code,
article_type = a.article_type
}).FirstOrDefault();
return(vArticles);
}
catch (Exception)
{
return(null);
}
}
public bool InsertArticles(mArticle pArticles)
{
try
{
tbl_article vArticle = new tbl_article();
var query = from b in Db.tbl_article
orderby b.article_id descending
select b;
vArticle = query.FirstOrDefault();
tbl_article a = new tbl_article();
a.article_file = pArticles.article_file;
a.article_img = pArticles.article_img;
a.article_img2 = pArticles.article_img2;
a.article_img3 = pArticles.article_img3;
a.article_title = pArticles.article_title;
a.article_summery = pArticles.article_summery;
a.article_writer = pArticles.article_writer;
a.article_date = pArticles.article_date;
a.article_exp = pArticles.article_exp;
a.article_img_alt = pArticles.article_img_alt;
a.article_writer = pArticles.article_writer;
a.article_code = pArticles.article_code;
a.article_href = pArticles.article_href;
a.article_visit = 200;
a.article_id = vArticle.article_id + 1;
a.article_type = pArticles.article_type;
Db.tbl_article.Add(a);
return(Convert.ToBoolean(Db.SaveChanges()));
}
catch (Exception)
{
return(false);
}
}
public ActionResult Article(int page)
{
mHome vHome = new mHome();
mArticle vArticle = new mArticle();
vArticle.article_id = page;
a.fUpdateArticleVisit(page);
vHome.Article = a.fGetArticles(vArticle);
if (vHome == null)
{
vHome = new mHome();
}
mLink vLink = new mLink();
vArticle.article_type = 1;
vLink.link_status = 2;
List <mArticle> aArticle = new List <mArticle>();
List <mNews> aNews = new List <mNews>();
List <mLink> aLinks = new List <mLink>();
aArticle = a.fArticlesList(8, 0, vArticle, vHome);
aNews = b.fNewsList(4, 0);
aLinks = l.fLinkList(12, 0, vLink);
if (aArticle != null && aArticle.Count > 0)
{
vHome.aArticles = aArticle;
}
else
{
vHome.aArticles = new List <mArticle>();
}
if (aNews != null && aNews.Count > 0)
{
vHome.aNews = aNews;
}
else
{
vHome.aNews = new List <mNews>();
}
if (aLinks != null && aLinks.Count > 0)
{
vHome.aLink = aLinks;
}
else
{
vHome.aLink = new List <mLink>();
}
return(View(vHome));
}
public ActionResult representative()
{
try
{
mAbout vAbout = new mAbout();
List <mAbout> aAbout = new List <mAbout>();
vAbout.about_us_type = 5;
mHome vHome = new mHome();
mArticle vArticle = new mArticle();
vAbout = a.fGetAbout(vAbout);
List <mLink> aLinks = new List <mLink>();
List <mProduct> aProduct = new List <mProduct>();
mLink vLink = new mLink();
vLink.link_status = 2;
List <mArticle> aArticle = new List <mArticle>();
aArticle = ar.fArticlesListMostVisited(6, pSkip, vArticle, vHome);
aLinks = l.fLinkList(12, 0, vLink);
if (aArticle != null && aArticle.Count > 0)
{
vHome.aArticles = aArticle;
}
else
{
vHome.aArticles = new List <mArticle>();
}
if (aLinks != null && aLinks.Count > 0)
{
vHome.aLink = aLinks;
}
else
{
vHome.aLink = new List <mLink>();
}
if (vAbout == null)
{
vAbout = new mAbout();
}
else
{
vHome.About = vAbout;
}
return(View(vHome));
}
catch
{
return(RedirectToAction("_Error", "Home"));
}
}
public ActionResult Blog(int page)
{
mHome vHome = new mHome();
mArticle vArticle = new mArticle();
vArticle.article_id = page;
vHome.Article = a.fGetArticles(vArticle);
if (vHome == null)
{
vHome = new mHome();
}
return(View(vHome));
}
public ActionResult Articles()
{
mHome vHome = new mHome();
mLink vLink = new mLink();
mArticle vArticle = new mArticle();
vArticle.article_type = 1;
vLink.link_status = 4;
List <mArticle> aArticle = new List <mArticle>();
List <mNews> aNews = new List <mNews>();
List <mLink> aLinks = new List <mLink>();
if (pSkip == 0)
{
vHome.page_number = 1;
}
else
{
vHome.page_number = (pSkip / 12) + 1;
}
aArticle = ar.fArticlesList(pGet, pSkip, vArticle, vHome);
aNews = b.fNewsList(4, 0);
aLinks = l.fLinkList(12, 0, vLink);
if (aArticle != null && aArticle.Count > 0)
{
vHome.aArticles = aArticle;
}
else
{
vHome.aArticles = new List <mArticle>();
}
if (aNews != null && aNews.Count > 0)
{
vHome.aNews = aNews;
}
else
{
vHome.aNews = new List <mNews>();
}
if (aLinks != null && aLinks.Count > 0)
{
vHome.aLink = aLinks;
}
else
{
vHome.aLink = new List <mLink>();
}
return(View(vHome));
}
public ActionResult Index(int pId)
{
if (fUserControl() == 0)
{
ViewBag.Message = "شما وارد سایت نشده اید...";
return(RedirectToAction("LoginForm", "Login"));
}
mHome vHome = new mHome();
mArticle pArticle = new mArticle();
pArticle.article_type = pId;
List <mArticle> aArticles = new List <mArticle>();
aArticles = a.fArticlesList(pGet, pSkip, pArticle, vHome);
ViewBag.pId = pId;
return(View(aArticles));
}
public ActionResult RemoveArticles(int pId)
{
if (fUserControl() == 0)
{
ViewBag.Message = "شما وارد سایت نشده اید...";
return(RedirectToAction("Login", "LoginForm"));
}
mArticle vArticles = new mArticle();
if (a.fDeleteArticles(pId))
{
return(Json(pId, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(pId, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Instructions()
{
mHome vHome = new mHome();
mLink vLink = new mLink();
mArticle vArticle = new mArticle();
vArticle.article_type = 1;
List <mArticle> aArticle = new List <mArticle>();
vLink.link_status = 1;
List <mLink> aLink = new List <mLink>();
aLink = l.fLinkList(pGet, pSkip, vLink);
aArticle = ar.fArticlesList(pGet, pSkip, vArticle, vHome);
if (pSkip == 0)
{
vHome.page_number = 1;
}
else
{
vHome.page_number = (pSkip / 12) + 1;
}
if (aLink != null && aLink.Count > 0)
{
vHome.aLink = aLink;
}
else
{
vHome.aLink = new List <mLink>();
}
if (aArticle != null && aArticle.Count > 0)
{
vHome.aArticles = aArticle;
}
else
{
vHome.aArticles = new List <mArticle>();
}
return(View(vHome));
}
public ActionResult Blog()
{
mHome vHome = new mHome();
mArticle vArticle = new mArticle();
vArticle.article_type = 2;
List <mArticle> aArticle = new List <mArticle>();
mCategory vCat = new mCategory();
vCat.category_type = 1;
List <mCategory> aCat = new List <mCategory>();
if (pSkip == 0)
{
vHome.page_number = 1;
}
else
{
vHome.page_number = (pSkip / 12) + 1;
}
aArticle = ar.fArticlesList(pGet, pSkip, vArticle, vHome);
aCat = c.fCategoryList(12, 0, vCat.category_type);
if (aArticle != null && aArticle.Count > 0)
{
vHome.aArticles = aArticle;
}
else
{
vHome.aArticles = new List <mArticle>();
}
if (aCat != null && aCat.Count > 0)
{
vHome.aCategory = aCat;
}
else
{
vHome.aCategory = new List <mCategory>();
}
return(View(vHome));
}
public ActionResult ArticleGet(int pId = 0, int pType = 0)
{
if (fUserControl() == 0)
{
ViewBag.Message = "شما وارد سایت نشده اید...";
return(RedirectToAction("LoginForm", "Login"));
}
mArticle vArticles = new mArticle();
if (pId > 0)
{
vArticles.article_id = pId;
vArticles = a.fGetArticles(vArticles);
}
else
{
vArticles = new mArticle();
}
vArticles.article_type = pType;
return(View("_Article", vArticles));
}
public ActionResult Insurance(int page)
{
mHome vHome = new mHome();
mLink vLink = new mLink();
vLink.link_status = 6;
vLink.link_cat = page;
mProduct vProduct = new mProduct();
List <mArticle> aArticle = new List <mArticle>();
mArticle vArticle = new mArticle();
List <mLink> aLinks = new List <mLink>();
aLinks = l.fLinkList(12, 0, vLink);
if (aLinks != null && aLinks.Count > 0)
{
vHome.aLink = aLinks;
}
else
{
vHome.aLink = new List <mLink>();
}
vArticle.article_type = 1;
aArticle = a.fArticlesListMostVisited(10, 0, vArticle, vHome);
if (aArticle != null && aArticle.Count > 0)
{
vHome.aArticles = aArticle;
}
else
{
vHome.aArticles = new List <mArticle>();
}
vProduct.product_id = page;
vHome.Ins = p.fGetInsCat(vProduct);
if (vHome == null)
{
vHome = new mHome();
}
return(View(vHome));
}
/// <summary>
/// 这是一个完整的返回文章列表的方法，内部使用，根据不同的应用场景设置不同的参数来返回数据
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="classID"></param>
/// <param name="AuthorID"></param>
/// <returns></returns>
private List <mArticle> GetArticleList(cGlobal.OrderBy orderby, cGlobal.OrderByRole orderByRole, int pageIndex, int pageSize = 10, int classID = 0, int AuthorID = -1)
{
DAL.dArticle da = new dArticle();
int rowCount = 0;
DataTable d = da.GetArticleList(pageIndex, pageSize, out rowCount, orderby, orderByRole, -1, -1);
if (d == null)
{
return(null);
}
//将datatable转换为list，这个过程可以写一个公共类来处理，但在这个项目就直接转了
List <mArticle> listArticle = new List <mArticle> ();
for (int i = 0; i < d.Rows.Count; i++)
{
mArticle ma = new mArticle();
ma.ID = int.Parse(d.Rows[i]["ID"].ToString());
ma.aCode = d.Rows[i]["aCode"].ToString();
ma.ClassID = int.Parse(d.Rows[i]["ClassID"].ToString());
ma.CoverImg = d.Rows[i]["CoverImg"].ToString();
ma.Title = d.Rows[i]["Title"].ToString();
ma.PublishDate = DateTime.Parse(d.Rows[i]["PublishDate"].ToString());
ma.AuthorID = int.Parse(d.Rows[i]["AuthorID"].ToString());
ma.Author = d.Rows[i]["Author"].ToString();
ma.Remark = d.Rows[i]["Remark"].ToString();
ma.Content = d.Rows[i]["Content"].ToString();
ma.PraiseCount = int.Parse(d.Rows[i]["ZanCount"].ToString());
ma.ClickCount = int.Parse(d.Rows[i]["ClickCount"].ToString());
ma.CommentCount = int.Parse(d.Rows[i]["CommentCount"].ToString());
ma.Tag = d.Rows[i]["Tag"].ToString();
ma.State = int.Parse(d.Rows[i]["State"].ToString());
listArticle.Add(ma);
}
return(listArticle);
}
public bool fUpdateArticles(mArticle pArticles)
{
tbl_article a = new tbl_article();
a.article_id = pArticles.article_id;
a.article_exp = pArticles.article_exp;
a.article_date = pArticles.article_date;
a.article_file = pArticles.article_file;
a.article_img = pArticles.article_img;
a.article_img2 = pArticles.article_img2;
a.article_img3 = pArticles.article_img3;
a.article_img_alt = pArticles.article_img_alt;
a.article_summery = pArticles.article_summery;
a.article_title = pArticles.article_title;
a.article_writer = pArticles.article_writer;
a.article_visit = pArticles.article_visit;
a.article_img = pArticles.article_img;
a.article_type = pArticles.article_type;
a.article_code = pArticles.article_code;
a.article_href = pArticles.article_href;
Db.tbl_article.Attach(a);
Db.Entry(a).State = System.Data.Entity.EntityState.Modified;
return(Convert.ToBoolean(Db.SaveChanges()));
}
public ActionResult ArticlePost(mArticle pArticles)
{
if (fUserControl() == 0)
{
ViewBag.Message = "شما وارد سایت نشده اید...";
return(RedirectToAction("LoginForm", "Login"));
}
if (!(ModelState.IsValid))
{
ViewBag.error = "خطا در اطلاعات ورودی !";
return(View(pArticles));
}
else
{
if ((pArticles.img_file != null) && (pArticles.img_file.ContentLength > 0))
{
if (pArticles.img_file.ContentLength < 10485760)
{
Random rnd = new Random();
string img = rnd.Next().ToString() + ".jpg";
string Path = System.IO.Path.Combine(Server.MapPath("~/images/articles/"));
pArticles.img_file.SaveAs(Path + img);
using (MemoryStream ms = new MemoryStream())
{
pArticles.img_file.InputStream.CopyTo(ms);
byte[] array = ms.GetBuffer();
pArticles.article_img = img;
}
}
else
{
ViewBag.error = "حد اکثر اندازه فایل را رعایت نکرده اید !";
return(View(pArticles));
}
}
if ((pArticles.img_file2 != null) && (pArticles.img_file2.ContentLength > 0))
{
if (pArticles.img_file2.ContentLength < 50485760)
{
Random rnd = new Random();
string img = rnd.Next().ToString() + ".zip";
string Path = System.IO.Path.Combine(Server.MapPath("~/images/articles/"));
pArticles.img_file2.SaveAs(Path + img);
using (MemoryStream ms = new MemoryStream())
{
pArticles.img_file2.InputStream.CopyTo(ms);
byte[] array = ms.GetBuffer();
pArticles.article_file = img;
}
}
else
{
ViewBag.error = "حد اکثر اندازه فایل را رعایت نکرده اید !";
return(View(pArticles));
}
}
if (pArticles.article_id > 0)
{
if (a.fUpdateArticles(pArticles))
{
return(RedirectToAction("index", new { pId = pArticles.article_type }));
}
}
else
{
if (a.InsertArticles(pArticles))
{
return(RedirectToAction("index", new { pId = pArticles.article_type }));
}
}
ViewBag.error = "خطا در انجام عملیات ! ";
}
return(View(pArticles));
}
