/// <summary>
/// 判断文章分类标题是否重复
/// </summary>
/// <param name="title">文章分类标题</param>
/// <param name="type">文章分类类型</param>
/// <returns>重复为true,否则为false</returns>
/// <remarks>2013-07-05 杨晗 创建</remarks>
public override bool FeArticleCategoryVerify(string title, ForeStatus.文章分类类型 type)
{
string sql = @"Name=@title and type=@type and status<>@status";
int countBuilder = Context.Select <int>("count(1)")
.From("fearticlecategory")
.Where(sql)
.Parameter("title", title)
.Parameter("type", type)
.Parameter("status", ForeStatus.文章分类状态.作废)
.QuerySingle();
return(countBuilder > 0);
}
/// <summary>
/// 根据文章类型获取所有文章分类
/// </summary>
/// <param name="type">文章分类类型</param>
/// <returns>文章分类集合</returns>
/// <remarks>2013－06-19 杨晗 创建</remarks>
public override IList <FeArticleCategory> GetAll(ForeStatus.文章分类类型 type)
{
#region sql条件
string sql = @"Type=@Type and Status=@Status";
#endregion
var countBuilder = Context.Select <FeArticleCategory>("ft.*")
.From("fearticlecategory ft")
.Where(sql)
.Parameter("Type", (int)type)
.Parameter("Status", (int)ForeStatus.文章分类状态.已审)
.OrderBy("DISPLAYORDER").QueryMany();
return(countBuilder);
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="pageIndex">起始页</param>
/// <param name="type">文章类型</param>
/// <param name="searchStaus">状态</param>
/// <param name="searchName">分类名称</param>
/// <returns>文章类型列表</returns>
/// <remarks>2013－06-17 杨晗 创建</remarks>
public PagedList <FeArticleCategory> Seach(int?pageIndex, ForeStatus.文章分类类型 type,
int?searchStaus, string searchName)
{
pageIndex = pageIndex ?? 1;
searchStaus = searchStaus ?? 0;
var model = new PagedList <FeArticleCategory>();
int count;
var list = IFeArticleCategoryDao.Instance.Seach((int)pageIndex, model.PageSize, type, (int)searchStaus,
searchName, out count);
model.TData = list;
model.TotalItemCount = count;
model.CurrentPageIndex = (int)pageIndex;
return(model);
}
/// <summary>
/// 获取所有文章类别(包含旗下文章)
/// </summary>
/// <param name="type">文章类型</param>
/// <param name="recordNum">记录条数</param>
/// <returns>所有文章类别(包含旗下文章)</returns>
/// <remarks>2013-08-12 杨晗 创建</remarks>
/// <remarks>2013-09-25 邵斌 修改：指定记录条数</remarks>
private IList <CBFeArticleCategory> GetAllArticle(ForeStatus.文章分类类型 type, int?recordNum = null)
{
var list = GetAll(type);
IList <CBFeArticleCategory> cbList = new List <CBFeArticleCategory>();
foreach (var item in list)
{
var model = new CBFeArticleCategory
{
SysNo = item.SysNo,
Type = item.Type,
Name = item.Name,
Description = item.Description,
DisplayOrder = item.DisplayOrder,
Status = item.Status,
FeArticle = IFeArticleDao.Instance.GetListByCategory(item.SysNo, recordNum)
};
cbList.Add(model);
}
return(cbList);
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="pageIndex">起始页</param>
/// <param name="pageSize">每页数量</param>
/// <param name="type">文章类型</param>
/// <param name="searchStaus">状态</param>
/// <param name="searchName">分类名称</param>
/// <param name="count">抛出总条数</param>
/// <returns>文章类型列表</returns>
/// <remarks>2013－06-17 杨晗 创建</remarks>
public override IList <FeArticleCategory> Seach(int pageIndex, int pageSize, ForeStatus.文章分类类型 type,
int searchStaus, string searchName, out int count)
{
#region sql条件
string sql = @"(@Name is null or Name like @Name1)
and (@Status=0 or Status =@Status1)
and (@Type=0 or Type=@Type1)";
#endregion
using (var context = Context.UseSharedConnection(true))
{
count = context.Select <int>("count(1)")
.From("fearticlecategory ft")
.Where(sql)
.Parameter("Name", searchName)
.Parameter("Name1", "%" + searchName + "%")
.Parameter("Status", searchStaus)
.Parameter("Status1", searchStaus)
.Parameter("Type", (int)type)
.Parameter("Type1", (int)type)
.QuerySingle();
var countBuilder = context.Select <FeArticleCategory>("ft.*")
.From("fearticlecategory ft")
.Where(sql)
.Parameter("Name", searchName)
.Parameter("Name1", "%" + searchName + "%")
.Parameter("Status", searchStaus)
.Parameter("Status1", searchStaus)
.Parameter("Type", (int)type)
.Parameter("Type1", (int)type)
.Paging(pageIndex, pageSize).OrderBy("DISPLAYORDER desc").QueryMany();
return(countBuilder);
}
}
/// <summary> /// 根据文章类型获取所有文章分类 /// </summary> /// <param name="type">文章分类类型</param> /// <returns>文章分类集合</returns> /// <remarks>2013－06-19 杨晗 创建</remarks> public abstract IList <FeArticleCategory> GetAll(ForeStatus.文章分类类型 type);
/// <summary>
/// 分页查询
/// </summary>
/// <param name="pageIndex">起始页</param>
/// <param name="pageSize">每页数量</param>
/// <param name="type">文章类型</param>
/// <param name="searchStaus">状态</param>
/// <param name="searchName">分类名称</param>
/// <param name="count">抛出总条数</param>
/// <returns>文章类型列表</returns>
/// <remarks>2013－06-17 杨晗 创建</remarks>
public abstract IList <FeArticleCategory> Seach(int pageIndex, int pageSize, ForeStatus.文章分类类型 type,
int searchStaus, string searchName, out int count);
/// <summary> /// 判断文章分类标题是否重复 /// </summary> /// <param name="title">文章分类标题</param> /// <param name="type">文章分类类型</param> /// <returns>重复为true,否则为false</returns> /// <remarks>2013-07-05 杨晗 创建</remarks> public abstract bool FeArticleCategoryVerify(string title, ForeStatus.文章分类类型 type);
/// <summary>
/// 根据文章类型获取所有文章分类
/// </summary>
/// <param name="type">文章分类类型</param>
/// <returns>文章分类集合</returns>
/// <remarks>2013－06-19 杨晗 创建</remarks>
public IList <FeArticleCategory> GetAll(ForeStatus.文章分类类型 type)
{
return(IFeArticleCategoryDao.Instance.GetAll(type));
}
/// <summary>
/// 判断文章分类标题是否重复
/// </summary>
/// <param name="title">文章分类标题</param>
/// <param name="type">文章分类类型</param>
/// <returns>重复为true,否则为false</returns>
/// <remarks>2013-07-05 杨晗 创建</remarks>
public bool FeArticleCategoryVerify(string title, ForeStatus.文章分类类型 type)
{
return(IFeArticleCategoryDao.Instance.FeArticleCategoryVerify(title, type));
}
