/// <summary>
/// 获取公告列表
/// </summary>
/// <param name="request">查询参数</param>
/// <returns>公告列表</returns>
public IList <BsNotice> GetList(NoticeRequest request)
{
var dataList = DBContext.Select <BsNotice>("*").From("Agent_BsNotice");
Action <string, string, object> setWhere = (@where, name, value) => dataList.AndWhere(@where).Parameter(name, value);
return(dataList.QueryMany());
}
public void Notice()
{
var request = new NoticeRequest(MessageRequests.Notice);
request.Parse();
Assert.Equal(MessageType.ChannelMessage, request.Type);
Assert.Null(request.NickName);
Assert.Equal("#GSP!room!test", request.ChannelName);
}
private void RefreshNotices()
{
//StatusText.Text = "güncelleniyor..";
NoticeRequest.OnDataLoaded = (list) =>
{
this.Dispatcher.Invoke(DispatcherPriority.Background, new Action(() =>
{
//StatusText.Text = "güncellendi: " + DateTime.Now.ToString();
DuyuruList.ItemsSource = list.ToList();
}));
};
NoticeRequest.GetNotices(Settings.MonitorId);
}
/// <summary>
/// 获取公告分页列表
/// </summary>
/// <param name="request">查询参数</param>
/// <returns>公告分页列表</returns>
public PagedList <BsNotice> GetPagerList(NoticeRequest request)
{
var dataCount = DBContext.Select <int>("count(0)").From("Agent_BsNotice");
var dataList = DBContext.Select <BsNotice>("*").From("Agent_BsNotice");
Action <string, string, object> setWhere = (@where, name, value) =>
{
dataCount.AndWhere(where).Parameter(name, value);
dataList.AndWhere(where).Parameter(name, value);
};
return(new PagedList <BsNotice>
{
TData = dataList.Paging(request.CurrentPageIndex.GetHashCode(), request.PageSize.GetHashCode()).OrderBy("SysNo desc").QueryMany(),
CurrentPageIndex = request.CurrentPageIndex.GetHashCode(),
TotalCount = dataCount.QuerySingle()
});
}
/// <summary>
/// 获取公告分页列表
/// </summary>
/// <param name="request">查询参数</param>
/// <returns>公告分页列表</returns>
public PagedList <BsNotice> GetPagerList(NoticeRequest request)
{
return(Using <IBsNotice>().GetPagerList(request));
}
/// <summary>
/// 获取公告列表
/// </summary>
/// <param name="request">查询参数</param>
/// <returns>公告列表</returns>
public List <BsNotice> GetList(NoticeRequest request)
{
var list = Using <IBsNotice>().GetList(request);
return(list.ToList());
}
