/// <summary>
/// 查询前台显示的公告列表
/// </summary>
/// <param name="agent"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public BulletinInfo_Collection QueryDisplayBulletins(int agent, int pageIndex, int pageSize)
{
pageIndex = pageIndex < 0 ? 0 : pageIndex;
pageSize = pageSize > BusinessHelper.MaxPageSize ? BusinessHelper.MaxPageSize : pageSize;
string QueryArticleList_sql = SqlModule.DataModule.FirstOrDefault(x => x.Key == "Data_QueryBulletinList_Web").SQL;
var collection = DB.CreateSQLQuery(QueryArticleList_sql)
.SetInt("BulletinAgent", agent)
.SetInt("PageIndex", pageIndex)
.SetInt("PageSize", pageSize).List <BulletinInfo_Query>().ToList();
var returnmodel = new BulletinInfo_Collection();
returnmodel.BulletinList = collection;
string QueryArticleList_Count_sql = SqlModule.DataModule.FirstOrDefault(x => x.Key == "Data_QueryBulletinList_Web_Total").SQL;
var totalCount = DB.CreateSQLQuery(QueryArticleList_Count_sql)
.SetInt("BulletinAgent", agent).First <int>();
returnmodel.TotalCount = totalCount;
return(returnmodel);
//string QueryArticleCount_sql = SqlModule.DataModule.FirstOrDefault(x => x.Key == "Data_QueryArticleList_TotalCount").SQL;
//var list = CreateOutputQuery(Session.GetNamedQuery("Data_QueryBulletinList_Web"))
// .AddInParameter("BulletinAgent", (int)agent)
// .AddInParameter("PageIndex", pageIndex)
// .AddInParameter("PageSize", pageSize)
// .AddOutParameter("TotalCount", "Int32")
// .List(out outputs);
//totalCount = (int)outputs["TotalCount"];
//return list;
}
/// <summary>
/// 获取公告列表
/// </summary>
/// <param name="count">获取公告的条数</param>
/// <returns>公告列表</returns>
public static List <BulletinInfo_Query> GetNoticeList(int count)
{
_noticeList = WCFClients.ExternalClient.QueryDisplayBulletinCollection(BulletinAgent.Local, 0, 15, UserToken);
if (_noticeList == null)
{
_noticeList = WCFClients.ExternalClient.QueryDisplayBulletinCollection(BulletinAgent.Local, 0, 15, UserToken);
}
return(_noticeList.BulletinList.OrderByDescending(a => a.IsPutTop).OrderByDescending(a => a.CreateTime).Take(count).ToList());
}
/// <summary>
/// 查询前台显示的公告列表
/// </summary>
public BulletinInfo_Collection QueryDisplayBulletins(BulletinAgent agent, int pageIndex, int pageSize)
{
using (var bulletinManager = new BulletinManager())
{
int totalCount;
var list = bulletinManager.QueryDispayBulletinList(agent, pageIndex, pageSize, out totalCount);
var collection = new BulletinInfo_Collection
{
TotalCount = totalCount,
};
collection.LoadList(list);
return(collection);
}
}
/// <summary>
/// 查询后台管理的公告列表
/// </summary>
public BulletinInfo_Collection QueryManagementBulletins(string key, EnableStatus status, int priority, int isPutTop, int pageIndex, int pageSize)
{
using (var bulletinManager = new BulletinManager())
{
int totalCount;
var list = bulletinManager.QueryAdminBulletinList(key, status, priority, isPutTop, pageIndex, pageSize, out totalCount);
var collection = new BulletinInfo_Collection
{
TotalCount = totalCount,
};
collection.LoadList(list);
return(collection);
}
}