void BindData()
{
SendedMessageQuery query = new SendedMessageQuery();
query.PageIndex = this.pager.PageIndex;
query.PageSize = this.pager.PageSize;
query.UserName = HiContext.Current.User.Username;
DbQueryResult sendedMessages = CommentsHelper.GetSendedMessages(query);
this.messagesList.DataSource = sendedMessages.Data;
this.messagesList.DataBind();
this.pager.TotalRecords = sendedMessages.TotalRecords;
}
private void BindData()
{
SendedMessageQuery query = new SendedMessageQuery();
query.UserName = "******";
query.SortBy = messagesList.SortOrderBy;
query.PageIndex = pager.PageIndex;
query.PageSize = pager.PageSize;
if (messagesList.SortOrder.ToLower() == "desc")
{
query.SortOrder = SortAction.Desc;
}
DbQueryResult distributorSendedMessages = NoticeHelper.GetDistributorSendedMessages(query);
messagesList.DataSource = distributorSendedMessages.Data;
messagesList.DataBind();
pager.TotalRecords = distributorSendedMessages.TotalRecords;
pager1.TotalRecords = distributorSendedMessages.TotalRecords;
}
public override DbQueryResult GetSendedMessages(SendedMessageQuery query)
{
return DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "Hishop_SendedMessages", "SendMessageId", string.Format("Addresser='{0}' AND Addressee IN (SELECT UserName FROM vw_aspnet_Members) ", query.UserName), "*");
}
public static DbQueryResult GetSendedMessages(SendedMessageQuery query)
{
return CommentsProvider.Instance().GetSendedMessages(query);
}
public override DbQueryResult GetSendedMessagesToAdmin(SendedMessageQuery query)
{
return DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "Hishop_SendedMessages", "SendMessageId", string.Format("Addresser='{0}'", query.UserName), "*");
}
public abstract DbQueryResult GetDistributorSendedMessages(SendedMessageQuery query);
public abstract DbQueryResult GetSendedMessages(SendedMessageQuery query);
public static DbQueryResult GetSendedMessagesToAdmin(SendedMessageQuery query)
{
return SubsiteCommentsProvider.Instance().GetSendedMessagesToAdmin(query);
}