public DbQueryResult GetManagerSendedMessages(MessageBoxQuery query, UserRole role) { string sender = DataHelper.CleanSearchString(query.Sernder); string filter = string.Format("Sernder='{0}' AND Accepter IN (SELECT UserName FROM aspnet_Users WHERE UserRole = {1})", sender, (int)role); return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, "MessageId", SortAction.Desc, query.IsCount, "vw_Ecshop_ManagerMessageBox", "MessageId", filter, "*")); }
private void BindData() { MessageBoxQuery messageBoxQuery = new MessageBoxQuery(); messageBoxQuery.PageIndex = this.pager.PageIndex; messageBoxQuery.PageSize = this.pager.PageSize; messageBoxQuery.Sernder = HiContext.Current.User.UserName; DbQueryResult memberSendedMessages = CommentBrowser.GetMemberSendedMessages(messageBoxQuery); this.CmessagesList.DataSource = memberSendedMessages.Data; this.CmessagesList.DataBind(); this.pager.TotalRecords = memberSendedMessages.TotalRecords; }
private void GetList(HttpContext context) { MessageBoxQuery messageBoxQuery = new MessageBoxQuery(); messageBoxQuery.Sernder = "admin"; messageBoxQuery.PageIndex = base.CurrentPageIndex; messageBoxQuery.PageSize = base.CurrentPageSize; DataGridViewModel <Dictionary <string, object> > dataList = this.GetDataList(messageBoxQuery); string s = base.SerializeObjectToJson(dataList); context.Response.Write(s); context.Response.End(); }
private void BindData() { MessageBoxQuery query = new MessageBoxQuery(); query.Sernder = "admin"; query.PageIndex = this.pager.PageIndex; query.PageSize = this.pager.PageSize; DbQueryResult managerSendedMessages = NoticeHelper.GetManagerSendedMessages(query, UserRole.Distributor); this.messagesList.DataSource = managerSendedMessages.Data; this.messagesList.DataBind(); this.pager.TotalRecords = managerSendedMessages.TotalRecords; this.pager1.TotalRecords = managerSendedMessages.TotalRecords; }
public DbQueryResult GetManagerReceivedMessages(MessageBoxQuery query) { string text = $"Accepter='{query.Accepter}' AND Sernder IN (SELECT UserName FROM aspnet_Members)"; if (query.MessageStatus == MessageStatus.Replied) { text += " AND IsRead = 1"; } if (query.MessageStatus == MessageStatus.NoReply) { text += " AND IsRead = 0"; } return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, "MessageId", SortAction.Desc, query.IsCount, "vw_Hishop_ManagerMessageBox", "MessageId", text, "*")); }
public DbQueryResult GetManagerReceivedMessages(MessageBoxQuery query, UserRole role) { string text = string.Format("Accepter='{0}' AND Sernder IN (SELECT UserName FROM aspnet_Users WHERE UserRole = {1})", query.Accepter, (int)role); if (query.MessageStatus == MessageStatus.Replied) { text += " AND IsRead = 1"; } if (query.MessageStatus == MessageStatus.NoReply) { text += " AND IsRead = 0"; } return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, "MessageId", SortAction.Desc, query.IsCount, "vw_Ecshop_ManagerMessageBox", "MessageId", text, "*")); }
private void BindData() { MessageBoxQuery query = new MessageBoxQuery(); query.PageIndex = this.pager.PageIndex; query.PageSize = this.pager.PageSize; query.Sernder = HiContext.Current.User.Username; DbQueryResult sendedMessages = SubsiteCommentsHelper.GetSendedMessages(query, UserRole.Member); this.messagesList.DataSource = sendedMessages.Data; this.messagesList.DataBind(); this.pager.TotalRecords = sendedMessages.TotalRecords; this.pager1.TotalRecords = sendedMessages.TotalRecords; }
public override DbQueryResult GetReceivedMessages(MessageBoxQuery query, UserRole role) { string filter = string.Format("Accepter='{0}' AND Sernder", query.Accepter) + ((role == UserRole.SiteManager) ? " = 'admin'" : "<> 'admin'"); if (query.MessageStatus == MessageStatus.Replied) { filter = filter + " AND IsRead = 1"; } if (query.MessageStatus == MessageStatus.NoReply) { filter = filter + " AND IsRead = 0"; } return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, "MessageId", SortAction.Desc, query.IsCount, "vw_Hishop_DistributorMessageBox", "MessageId", filter, "*")); }
private DataGridViewModel <Dictionary <string, object> > GetDataList(MessageBoxQuery query) { DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >(); if (query != null) { DbQueryResult managerSendedMessages = NoticeHelper.GetManagerSendedMessages(query); dataGridViewModel.rows = DataHelper.DataTableToDictionary(managerSendedMessages.Data); dataGridViewModel.total = managerSendedMessages.TotalRecords; foreach (Dictionary <string, object> row in dataGridViewModel.rows) { } } return(dataGridViewModel); }
private void BindData() { MessageBoxQuery messageBoxQuery = new MessageBoxQuery(); messageBoxQuery.PageIndex = this.pager.PageIndex; messageBoxQuery.PageSize = this.pager.PageSize; messageBoxQuery.Accepter = HiContext.Current.User.Username; DbQueryResult memberReceivedMessages = CommentBrowser.GetMemberReceivedMessages(messageBoxQuery); if (((DataTable)memberReceivedMessages.Data).Rows.Count <= 0) { memberReceivedMessages = CommentBrowser.GetMemberReceivedMessages(messageBoxQuery); } this.CmessagesList.DataSource = memberReceivedMessages.Data; this.CmessagesList.DataBind(); this.pager.TotalRecords = memberReceivedMessages.TotalRecords; }
private void GetList(HttpContext context) { MessageBoxQuery messageBoxQuery = new MessageBoxQuery(); messageBoxQuery.Accepter = "admin"; int?intParam = base.GetIntParam(context, "MessageStatus", true); if (intParam.HasValue) { messageBoxQuery.MessageStatus = (MessageStatus)intParam.Value; } messageBoxQuery.PageIndex = base.CurrentPageIndex; messageBoxQuery.PageSize = base.CurrentPageSize; DataGridViewModel <Dictionary <string, object> > dataList = this.GetDataList(messageBoxQuery); string s = base.SerializeObjectToJson(dataList); context.Response.Write(s); context.Response.End(); }
private void BindData() { MessageBoxQuery query = new MessageBoxQuery(); query.PageIndex = this.pager.PageIndex; query.PageSize = this.pager.PageSize; query.Accepter = "admin"; if (!string.IsNullOrEmpty(base.Request.QueryString["MessageStatus"])) { query.MessageStatus = (MessageStatus)int.Parse(base.Request.QueryString["MessageStatus"]); this.statusList.SelectedValue = query.MessageStatus; } DbQueryResult managerReceivedMessages = NoticeHelper.GetManagerReceivedMessages(query, UserRole.Distributor); this.messagesList.DataSource = managerReceivedMessages.Data; this.messagesList.DataBind(); this.pager.TotalRecords = managerReceivedMessages.TotalRecords; this.pager1.TotalRecords = managerReceivedMessages.TotalRecords; }
private void BindData() { MessageBoxQuery query = new MessageBoxQuery(); query.PageIndex = this.pager.PageIndex; query.PageSize = this.pager.PageSize; query.Accepter = HiContext.Current.User.Username; if (!string.IsNullOrEmpty(base.Request.QueryString["MessageStatus"])) { query.MessageStatus = (MessageStatus)int.Parse(base.Request.QueryString["MessageStatus"]); this.statusList.SelectedValue = query.MessageStatus; } DbQueryResult receivedMessages = SubsiteCommentsHelper.GetReceivedMessages(query, UserRole.SiteManager); this.messagesList.DataSource = receivedMessages.Data; this.messagesList.DataBind(); this.pager.TotalRecords = receivedMessages.TotalRecords; this.pager1.TotalRecords = receivedMessages.TotalRecords; }
public abstract DbQueryResult GetManagerSendedMessages(MessageBoxQuery query, UserRole role);
public abstract DbQueryResult GetReceivedMessages(MessageBoxQuery query, UserRole role);
public static DbQueryResult GetMemberReceivedMessages(MessageBoxQuery query) { return(CommentDataProvider.Instance().GetMemberReceivedMessages(query)); }
public DbQueryResult GetMemberSendedMessages(MessageBoxQuery query) { string filter = $"Sernder='{query.Sernder}'"; return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, "MessageId", SortAction.Desc, query.IsCount, "vw_Hishop_MemberMessageBox", "MessageId", filter, "*")); }
public DbQueryResult GetManagerSendedMessages(MessageBoxQuery query) { string filter = $"Sernder='{query.Sernder}' AND Accepter IN (SELECT UserName FROM aspnet_Members)"; return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, "MessageId", SortAction.Desc, query.IsCount, "vw_Hishop_ManagerMessageBox", "MessageId", filter, "*")); }
public override DbQueryResult GetMemberReceivedMessages(MessageBoxQuery query) { string filter = string.Format("Accepter='{0}'", query.Accepter); return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, "MessageId", SortAction.Desc, query.IsCount, "vw_Hishop_MemberMessageBox", "MessageId", filter, "*")); }
public static DbQueryResult GetMemberReceivedMessages(MessageBoxQuery query) { return(new MessageBoxDao().GetMemberReceivedMessages(query)); }
public abstract DbQueryResult GetMemberSendedMessages(MessageBoxQuery query);
public DbQueryResult GetMemberSendedMessages(MessageBoxQuery query) { string filter = string.Format("Sernder='{0}'", DataHelper.CleanSearchString(query.Sernder)); return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, "MessageId", SortAction.Desc, query.IsCount, "vw_Ecshop_MemberMessageBox", "MessageId", filter, "*")); }
public static DbQueryResult GetSendedMessages(MessageBoxQuery query, UserRole role) { return(SubsiteCommentsProvider.Instance().GetSendedMessages(query, role)); }
public static DbQueryResult GetManagerReceivedMessages(MessageBoxQuery query, UserRole role) { return(new MessageBoxDao().GetManagerReceivedMessages(query, role)); }
public static DbQueryResult GetManagerSendedMessages(MessageBoxQuery query) { return(new MessageBoxDao().GetManagerSendedMessages(query)); }
public override DbQueryResult GetSendedMessages(MessageBoxQuery query, UserRole role) { string filter = string.Format("Sernder='{0}' AND Accepter", query.Sernder) + ((role == UserRole.SiteManager) ? " = 'admin'" : "<> 'admin'"); return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, "MessageId", SortAction.Desc, query.IsCount, "vw_Hishop_DistributorMessageBox", "MessageId", filter, "*")); }
public abstract DbQueryResult GetMemberReceivedMessages(MessageBoxQuery query);
public static DbQueryResult GetManagerReceivedMessages(MessageBoxQuery query, UserRole role) { return(CommentsProvider.Instance().GetManagerReceivedMessages(query, role)); }