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); }