public List <ArticleEntity> SearchArticle(ArticleSearchEntity searchObject) { IBaseDataSvc channel = CreateChannel(); var result = channel.SearchArticle(searchObject); channel.Dispose(); return(result); }
/// <summary> /// 文章列表 /// </summary> /// <returns></returns> public ActionResult Index(ArticleSearchEntity search) { if (!search.type.HasValue) { search.type = 0; } if (!search.bType.HasValue) { search.bType = 0; } if (!search.pageIndex.HasValue) { search.pageIndex = 1; } if (!search.isJingHua.HasValue) { search.isJingHua = 0; } int pageSize = Site.Config.PageConfig.WebArticlePageSize; var list = new List <ArticleWebEntity>(); int dataCount = 0; //文章 var articlesList = Articles.SearchArticlesByTypes(search.type.Value, search.bType.Value, search.pageIndex.Value, pageSize, search.isJingHua.Value, out dataCount); if (articlesList != null) { //用户 var userlist = Users.GetUsersByIds(articlesList.Select(n => n.UserId).ToArray()); list.AddRange(from articleVModel in articlesList let user = userlist.FirstOrDefault(n => n.Id == articleVModel.UserId) select new ArticleWebEntity() { Article = articleVModel, User = user }); } ViewBag.ArticleTypeName = "活动列表"; if (search.type > 0) { var articleType = ArticleTypes.GetArticleTypeVModelById(search.type.Value); if (articleType != null) { ViewBag.ArticleTypeName = articleType.Name; } } ViewBag.Search = search; ViewData["HeadNavCurrent"] = search.type; PagedList <ArticleWebEntity> pageList = list.ToPagedList(search.pageIndex.Value, pageSize); pageList.TotalItemCount = (int)dataCount; pageList.CurrentPageIndex = search.pageIndex.Value; return(View(pageList)); }
public List <ArticleEntity> SearchArticle(ArticleSearchEntity searchObject) { //execute using (var db = VinaGerman.Database.VinagermanDatabase.GetDatabaseInstance()) { try { db.OpenConnection(); return(db.Resolve <IArticleDB>().SearchArticle(searchObject)); } finally { db.CloseConnection(); } } }
public List <ArticleEntity> SearchArticle(ArticleSearchEntity searchObject) { List <ArticleEntity> result = null; string sqlStatement = "SELECT " + Environment.NewLine + "Article.ArticleId," + Environment.NewLine + "Article.CategoryId," + Environment.NewLine + "Article.ArticleNo," + Environment.NewLine + "Article.Description," + Environment.NewLine + "Article.Unit," + Environment.NewLine + "Article.Deleted" + Environment.NewLine + "FROM Article " + Environment.NewLine + "WHERE Deleted=0 " + Environment.NewLine; if (searchObject.SearchText != null && searchObject.SearchText.Length > 0) { sqlStatement += "AND (ArticleNo LIKE N'%" + searchObject.SearchText + "%')" + Environment.NewLine; } //execute result = Connection.Query <ArticleEntity>(sqlStatement, null, Transaction).ToList(); return(result); }
/// <summary> /// 二级分类 /// </summary> /// <param name="search"></param> /// <returns></returns> public ActionResult ErJiNav(ArticleSearchEntity search) { return(View(search)); }
public List <ArticleEntity> SearchArticle(ArticleSearchEntity searchObject) { return(Factory.Resolve <IArticleBL>().SearchArticle(searchObject)); }