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