/// <summary>
/// 判断重复数据
/// </summary>
/// <param name="model">分类实体信息</param>
/// <returns>存在返回true，不存在返回flase</returns>
/// <remarks>2013－01-14 苟治国 创建</remarks>
public override bool IsExists(FeNews model)
{
bool result = false;
FeNews entity = Context.Select <FeNews>("*")
.From("FeNews")
.Where("Title= @Title and Sysno != @Sysno")
.Parameter("Title", model.Title)
.Parameter("Sysno", model.SysNo)
.QuerySingle();
if (entity != null && entity.SysNo > 0)
{
result = true;
}
return(result);
}
public JsonResult List(Guid categoryId, string keywords,
int? skip, int? take, string sortField, string orderBy)
{
var xtake = 10;
var xskip = 0;
long total = 0;
if (skip != null)
{
xskip = skip.Value;
}
if (take != null)
{
xtake = take.Value;
}
if (string.IsNullOrEmpty(sortField))
{
sortField = nameof(FeNews.CreatedDate);
}
if (string.IsNullOrEmpty(orderBy))
{
orderBy = "desc";
}
List<FeNews> rows = new List<FeNews>();
List<ContentLanguage> contentLanguages = null;
var tempNews = NewsSearchServices.Search(keywords, LanguageId, new List<Guid>() { categoryId }, null, xskip, xtake,
out contentLanguages, out total);
foreach (var n in tempNews)
{
var i = new FeNews();
i.CreatedDate = n.CreatedDate;
i.Id = n.Id;
i.Published = n.Published;
i.AllowComment = n.AllowComment;
i.Title = contentLanguages.GetValue(i.Id, "Title");
i.UrlImage = contentLanguages.GetValue(i.Id, "UrlImage");
i.SeoUrlFriendly = contentLanguages.GetValue(i.Id, "SeoUrlFriendly");
rows.Add(i);
}
return Json(new { total, rows, success = true }, JsonRequestBehavior.AllowGet);
}
public ActionResult Detail(string urlsegment)
{
if (string.IsNullOrEmpty(urlsegment))
{
return(Content("404 not found news"));
}
var model = new FeNews();
using (var db = new DomainDrivenDesign.CoreCms.Ef.CoreCmsDbContext())
{
var temp = db.UrlFriendlys.FirstOrDefault(
i => i.UrlSegment.Equals(urlsegment, StringComparison.OrdinalIgnoreCase) &&
i.TableName.Equals("News", StringComparison.OrdinalIgnoreCase));
if (temp == null)
{
return(Content("Not found. 404"));
}
var id = temp.Id;
var news = db.News.SingleOrDefault(i => i.Id == id);
model.Id = id;
model.AllowComment = news.AllowComment;
model.Title = db.ContentLanguages.GetValue(id, LanguageId, "Title");
model.ShortDescription = db.ContentLanguages.GetValue(id, LanguageId, "ShortDescription");
model.Description = db.ContentLanguages.GetValue(id, LanguageId, "Description");
model.SeoKeywords = db.ContentLanguages.GetValue(id, LanguageId, "SeoKeywords");
model.UrlImage = db.ContentLanguages.GetValue(id, LanguageId, "UrlImage");
model.SeoDescription = db.ContentLanguages.GetValue(id, LanguageId, "SeoDescription");
}
return(View(model));
}
/// <summary>
/// 判断重复数据
/// </summary>
/// <param name="model">分类实体信息</param>
/// <returns>存在返回true，不存在返回flase</returns>
/// <remarks>2013－01-14 苟治国 创建</remarks>
public bool IsExists(FeNews model)
{
return(IFeNewsDao.Instance.IsExists(model));
}
public JsonResult ListResult(string keywords,
int?skip, int?take, string sortField, string orderBy)
{
var xtake = 10;
var xskip = 0;
long total = 0;
if (skip != null)
{
xskip = skip.Value;
}
if (take != null)
{
xtake = take.Value;
}
if (string.IsNullOrEmpty(sortField))
{
sortField = nameof(FeNews.CreatedDate);
}
if (string.IsNullOrEmpty(orderBy))
{
orderBy = "desc";
}
List <FeNews> rows = new List <FeNews>();
if (!string.IsNullOrEmpty(keywords))
{
List <ContentLanguage> contentLanguages = null;
var tempNews = NewsSearchServices.Search(keywords, LanguageId, new List <Guid>()
{
}, true, xskip, xtake,
out contentLanguages, out total);
if (tempNews.Count == 0)
{
rows.Add(new FeNews()
{
Title = "Not found any content match with keywords"
});
}
else
{
foreach (var n in tempNews)
{
var i = new FeNews();
i.CreatedDate = n.CreatedDate;
i.Id = n.Id;
i.Published = n.Published;
i.Title = contentLanguages.GetValue(n.Id, "Title");
i.ShortDescription = contentLanguages.GetValue(n.Id, "ShortDescription");
i.UrlImage = contentLanguages.GetValue(n.Id, "UrlImage");
i.SeoUrlFriendly = contentLanguages.GetValue(n.Id, "SeoUrlFriendly");
rows.Add(i);
}
}
}
else
{
rows.Add(new FeNews()
{
Title = "No keywords to search"
});
}
return(Json(new { total, rows, success = true }, JsonRequestBehavior.AllowGet));
}
/// <summary> /// 判断重复数据 /// </summary> /// <param name="model">分类实体信息</param> /// <returns>存在返回true，不存在返回flase</returns> /// <remarks>2013－01-14 苟治国 创建</remarks> public abstract bool IsExists(FeNews model);
