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));
}
