private void BindData() { int num; ReceivedMessageQuery query2 = new ReceivedMessageQuery(); query2.PageIndex = this.pager.PageIndex; query2.PageSize = this.pager.PageSize; query2.SortBy = this.messagesList.SortOrderBy; query2.UserName = HiContext.Current.User.Username; ReceivedMessageQuery query = query2; if (!string.IsNullOrEmpty(base.Request.QueryString["MessageStatus"])) { query.MessageStatus = (MessageStatus) int.Parse(base.Request.QueryString["MessageStatus"]); this.statusList.SelectedValue = query.MessageStatus; } if (int.TryParse(base.Request.QueryString["IsRead"], out num)) { query.IsRead = new bool?(Convert.ToBoolean(num)); } if (this.messagesList.SortOrder.ToLower() == "desc") { query.SortOrder = SortAction.Desc; } DbQueryResult receivedMessages = SubsiteCommentsHelper.GetReceivedMessages(query); this.messagesList.DataSource = receivedMessages.Data; this.messagesList.DataBind(); this.pager.TotalRecords = receivedMessages.TotalRecords; this.pager1.TotalRecords = receivedMessages.TotalRecords; }
private void BindData() { int num; ReceivedMessageQuery query = new ReceivedMessageQuery(); query.PageIndex = pager.PageIndex; query.PageSize = pager.PageSize; query.SortBy = messagesList.SortOrderBy; if (!string.IsNullOrEmpty(base.Request.QueryString["MessageStatus"])) { query.MessageStatus = (MessageStatus)int.Parse(base.Request.QueryString["MessageStatus"]); statusList.SelectedValue = query.MessageStatus; } if (int.TryParse(base.Request.QueryString["IsRead"], out num)) { query.IsRead = new bool?(Convert.ToBoolean(num)); } query.UserName = "******"; if (messagesList.SortOrder.ToLower() == "desc") { query.SortOrder = SortAction.Desc; } DbQueryResult distributorReceivedMessages = NoticeHelper.GetDistributorReceivedMessages(query); messagesList.DataSource = distributorReceivedMessages.Data; messagesList.DataBind(); pager.TotalRecords = distributorReceivedMessages.TotalRecords; pager1.TotalRecords = distributorReceivedMessages.TotalRecords; }
void BindData() { ReceivedMessageQuery query = new ReceivedMessageQuery(); query.PageIndex = this.pager.PageIndex; query.PageSize = this.pager.PageSize; query.UserName = HiContext.Current.User.Username; DbQueryResult receivedMessages = CommentsHelper.GetReceivedMessages(query); if (((DataTable) receivedMessages.Data).Rows.Count <= 0) { query.PageIndex = this.messagesList.PageIndex - 1; receivedMessages = CommentsHelper.GetReceivedMessages(query); this.messagesList.DataSource = receivedMessages.Data; } this.messagesList.DataSource = receivedMessages.Data; this.messagesList.DataBind(); this.pager.TotalRecords = receivedMessages.TotalRecords; }
public override DbQueryResult GetReceivedMessages(ReceivedMessageQuery query) { string filter = string.Format("Addressee='{0}'", query.UserName); if (query.MessageStatus == MessageStatus.NoReply) { filter = filter + " AND ReceiveMessageId NOT IN(SELECT ISNULL(ReceiveMessageId,-1) FROM Hishop_SendedMessages)"; } if (query.MessageStatus == MessageStatus.Replied) { filter = filter + " AND ReceiveMessageId IN(SELECT ReceiveMessageId FROM Hishop_SendedMessages)"; } if (query.IsRead.HasValue) { filter = filter + string.Format("AND IsRead = {0} ", query.IsRead.Value ? "1" : "0"); } filter = filter + " AND Addresser IN (SELECT UserName FROM vw_aspnet_Members)"; return DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "Hishop_ReceivedMessages", "ReceiveMessageId", filter, "*"); }
public override DbQueryResult GetReceivedMessages(ReceivedMessageQuery query) { return DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "Hishop_ReceivedMessages", "ReceiveMessageId", string.Format("Addressee='{0}'", query.UserName), "*"); }
public static DbQueryResult GetDistributorReceivedMessages(ReceivedMessageQuery query) { return CommentsProvider.Instance().GetDistributorReceivedMessages(query); }
public abstract DbQueryResult GetDistributorReceivedMessages(ReceivedMessageQuery query);
public abstract DbQueryResult GetReceivedMessages(ReceivedMessageQuery query);
public static DbQueryResult GetReceivedMessagesToAdmin(ReceivedMessageQuery query) { return SubsiteCommentsProvider.Instance().GetReceivedMessagesToAdmin(query); }
public static DbQueryResult GetReceivedMessages(ReceivedMessageQuery query) { return CommentDataProvider.Instance().GetReceivedMessages(query); }