public IEnumerable <blog_view_article> Query(ArticleViewQueryEntity queryEntity, ref GridPager pager)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
string where = " 1=1";
where += " and blogID=@blogID";
dic.Add("@blogID", queryEntity.BlogID);
if (!String.IsNullOrWhiteSpace(queryEntity.SiteCategoryID))
{
where += " and siteCategoryID=@siteCategoryID";
dic.Add("@siteCategoryID", queryEntity.SiteCategoryID);
}
if (!String.IsNullOrWhiteSpace(queryEntity.CategoryID))
{
where += " and categoryID=@categoryID";
dic.Add("@categoryID", queryEntity.CategoryID);
}
if (!String.IsNullOrWhiteSpace(queryEntity.TopicID))
{
where += " and topicID=@topicID";
dic.Add("@topicID", queryEntity.StartDate);
}
if (!String.IsNullOrWhiteSpace(queryEntity.ArticleIsOriginal))
{
bool b = (Int32.Parse(queryEntity.ArticleIsOriginal) == 1);
where += " and articleIsOriginal=@articleIsOriginal";
dic.Add("@articleIsOriginal", b);
}
if (!String.IsNullOrWhiteSpace(queryEntity.StartDate))
{
where += " and articleDatetim>=@StartDate";
dic.Add("@StartDate", Convert.ToDateTime(queryEntity.StartDate).Date);
}
if (!String.IsNullOrWhiteSpace(queryEntity.EndDate))
{
where += " and articleDatetim<=@EndDate";
dic.Add("@EndDate", Convert.ToDateTime(queryEntity.EndDate).Date);
}
if (!String.IsNullOrWhiteSpace(queryEntity.ArticleTitle))
{
where += " and LOWER(articleTitle) like '%@articleTitle%'";
dic.Add("@articleTitle", queryEntity.ArticleTitle.Trim().ToLower());
}
pager.Where = where;
pager.Parameters = dic;
IEnumerable <Blogs.Entity.blog_view_article> list = GetList(ref pager);
return(list);
}
public IEnumerable <blog_view_article> Query(ArticleViewQueryEntity queryEntity, ref GridPager pager)
{
return(dal.Query(queryEntity, ref pager));
}
public JsonResult GetList(GridPager pager)
{
string blogID = UserInfo.BlogID;
if (!String.IsNullOrEmpty(Request["page"]))
{
pager.CurrentPage = Convert.ToInt32(Request["page"]);
}
if (!String.IsNullOrEmpty(Request["rows"]))
{
pager.PageSize = Convert.ToInt32(Request["rows"]);
}
if (!String.IsNullOrEmpty(Request["limit"]))
{
pager.PageSize = Convert.ToInt32(Request["limit"]);
}
if (!String.IsNullOrEmpty(Request["offset"]))
{
pager.Offset = Convert.ToInt32(Request["offset"]);
}
pager.OrderColumn = Request["sort"];
pager.Order = Request["order"];
ArticleViewQueryEntity queryEntity = new ArticleViewQueryEntity();
queryEntity.BlogID = UserInfo.BlogID + "";
queryEntity.CategoryID = Request["ddlcategorySelect"];
queryEntity.TopicID = Request["ddlTopicSelect"];
queryEntity.ArticleIsOriginal = Request["ddlarticleIsOriginalSelect"];
queryEntity.StartDate = Request["StartDate"];
queryEntity.EndDate = Request["EndDate"];
queryEntity.ArticleTitle = Request["articleTitle"];
string where = " 1=1";
IDictionary <string, object> parameters = new Dictionary <string, object>();
if (!String.IsNullOrWhiteSpace(queryEntity.BlogID))
{
where += " and blogID=@blogID";
parameters.Add("@blogID", queryEntity.BlogID);
}
if (!String.IsNullOrWhiteSpace(queryEntity.SiteCategoryID))
{
where += " and siteCategoryID=@siteCategoryID";
parameters.Add("@siteCategoryID", queryEntity.SiteCategoryID);
}
if (!String.IsNullOrWhiteSpace(queryEntity.CategoryID))
{
where += " and categoryID=@categoryID";
parameters.Add("@categoryID", queryEntity.CategoryID);
}
if (!String.IsNullOrWhiteSpace(queryEntity.TopicID))
{
where += " and topicID=@topicID";
parameters.Add("@topicID", queryEntity.TopicID);
}
if (!String.IsNullOrWhiteSpace(queryEntity.ArticleIsOriginal))
{
bool b = (Int32.Parse(queryEntity.ArticleIsOriginal) == 1);
where += " and articleIsOriginal=@articleIsOriginal";
parameters.Add("@articleIsOriginal", b);
}
if (!String.IsNullOrWhiteSpace(queryEntity.StartDate))
{
where += " and articleDatetim>=@StartDate";
parameters.Add("@StartDate", Convert.ToDateTime(queryEntity.StartDate).Date);
}
if (!String.IsNullOrWhiteSpace(queryEntity.EndDate))
{
where += " and articleDatetim<=@EndDate";
parameters.Add("@EndDate", Convert.ToDateTime(queryEntity.EndDate).Date);
}
if (!String.IsNullOrWhiteSpace(queryEntity.ArticleTitle))
{
where += " and LOWER(articleTitle) like @articleTitle";
parameters.Add("@articleTitle", "%" + queryEntity.ArticleTitle + "%");
//where += " and LOWER(articleTitle) like '%"+ FYJ.Common.StringHelper.SqlFilter(queryEntity.ArticleTitle) + "%'";
}
if (!String.IsNullOrEmpty(Request["search"]))
{
where += " and (LOWER(articleTitle) like @search or articleID=@search1)";
parameters.Add("@search", "%" + Request["search"].Trim() + "%");
parameters.Add("@search1", Request["search"].Trim());
}
pager.Where = where;
pager.Parameters = parameters;
IEnumerable <Blogs.Entity.blog_view_article> list = Utility.ArticleViewBll.GetList(ref pager);
var json = new
{
total = pager.TotalRows,
rows = (from r in list
select new
{
ID = r.articleID,
r.articleID,
r.siteCategoryDisplay,
r.categoryDisplay,
r.topicDisplay,
r.articleTitle,
r.articlePic,
r.articleIsPic,
r.articleIsOriginal,
r.articleIsHidden,
r.articleIsDisabled,
r.articleIsTop,
r.articleClickTimes,
r.articleCommentTimes,
r.articlePostBy,
r.themeID,
r.articlePassword,
r.articleKeywords,
r.articleDescription,
r.articleAuthor,
articleDatetime = r.articleDatetime.ToString("yyyy-MM-dd HH:mm:ss"),
ADD_DATE = r.ADD_DATE.ToString("yyyy-MM-dd HH:mm:ss"),
UPDATE_DATE = r.UPDATE_DATE.ToString("yyyy-MM-dd HH:mm:ss"),
isDisableComment = Utility.CommentBll.isDisableComment(r.articleCommentLimit),
isAllowAnonymousComment = Utility.CommentBll.isDisabledAnonymousComment(r.articleCommentLimit),
isVerifyComment = Utility.CommentBll.isVerifyComment(r.articleCommentLimit)
}).ToArray()
};
return(Json(json, JsonRequestBehavior.AllowGet));
}
