/// <summary>
/// 获取内容列表
/// </summary>
/// <returns></returns>
public static List <Model.MContent> GetContents(int domainid)
{
string sql = @" SELECT TOP 500 * FROM wz_Content WHERE Origin = '微博博主' ";
if (domainid != 0)
{
sql += " AND DomainID = " + domainid;
}
else
{
sql = " SELECT TOP 500 * FROM wz_Content TABLESAMPLE(1 PERCENT) WHERE Origin = '微博博主' ";
//sql = @" SELECT TOP 100 * FROM wz_Content WHERE Origin = '微博博主' ORDER BY NEWID() ";
}
DataTable dt = SqlHelper.ExecuteDataTable(CommandType.Text, sql);
List <Model.MContent> list = new List <Model.MContent>();
foreach (DataRow item in dt.Rows)
{
Model.MContent model = new Model.MContent
{
ArticleID = Convert.ToInt64(item["ArticleID"]),
DomainID = Convert.ToInt32(item["DomainID"]),
Conten = item["Conten"].ToString(),
Abstract = item["Abstract"].ToString(),
ImgUrl = item["ImgUrl"].ToString()
};
list.Add(model);
}
return(list);
}
public ActionResult ArticleInfo(long inArticleID)
{
Model.MContent model = LContent.GetArticle(inArticleID);
ViewModels.VMArticle vModel = new ViewModels.VMArticle();
if (model != null)
{
vModel.ArticleID = model.ArticleID;
vModel.Title = model.Title;
vModel.DomainID = model.DomainID;
vModel.ReleaseTime = ConvertLongToDateTime(model.ReleaseTime).ToShortDateString();
vModel.Conten = model.Conten;
ViewBag.IsLogin = false;
ViewBag.Name = string.Empty;
ViewBag.CatName = GetCatName(vModel.DomainID);
ViewBag.VCount = LVisitorCount.GetVisitorCount().Count;
//获取session,判断是否为空
if (Session["LoginUser"] is ViewModels.VMUser vUser)
{
vModel.IsFavorites = LFavorites.ExistFavorites(vModel.ArticleID, vUser.UID);
Model.MFootmarks footmarks = new Model.MFootmarks
{
UID = vUser.UID,
ArticleID = vModel.ArticleID,
MarkTime = DateTime.Now,
FmTitle = vModel.Title
};
string fmID = LFootmarks.ExistFootmark(vUser.UID, vModel.ArticleID);
if (string.IsNullOrEmpty(fmID))
{
LFootmarks.CreateFootmark(footmarks);
}
else
{
footmarks.FmID = Convert.ToInt32(fmID);
LFootmarks.UpdateFootmark(footmarks);
}
ViewBag.IsLogin = true;
ViewBag.Name = vUser.UserName;
}
}
#region 推荐文章&商品
var raList = LContent.GetRandomArticles(3, vModel.DomainID);
List <ViewModels.VMArticle> vRaList = new List <ViewModels.VMArticle>();
foreach (var item in raList)
{
ViewModels.VMArticle ar = new ViewModels.VMArticle
{
ArticleID = item.ArticleID,
Title = item.Title,
DomainID = item.DomainID,
ReleaseTime = ConvertLongToDateTime(item.ReleaseTime).ToShortDateString(),
ImgSrc = GetSrc(item.Conten)
};
vRaList.Add(ar);
}
ViewData["RelatedArticle"] = vRaList;
ViewData["Items"] = TuiJian(vModel.Title);
#endregion
if (State)
{
return(View("MobileArticleInfo", vModel));
}
return(View(vModel));
}
