private void PageDataBind(string keyword, MessageSearchField searchField)
{
if (!string.IsNullOrEmpty(keyword))
{
this.ShowAdminMessageList.SearchField = searchField;
this.ShowAdminMessageList.SearchKeyword = keyword;
switch (searchField)
{
case MessageSearchField.Title:
this.SmpNavigator.AdditionalNode = "主题中含有 <span style='Color:#F00'> " + keyword + " </span> 的短消息";
return;
case MessageSearchField.Content:
this.SmpNavigator.AdditionalNode = "内容中含有 <span style='Color:#F00'> " + keyword + " </span> 的短消息";
return;
case MessageSearchField.Incept:
this.SmpNavigator.AdditionalNode = "收件人为 <span style='Color:#F00'> " + keyword + " </span> 的短消息";
return;
case MessageSearchField.Sender:
this.SmpNavigator.AdditionalNode = "发件人为 <span style='Color:#F00'> " + keyword + " </span> 的短消息";
return;
case MessageSearchField.OnePeople:
this.SmpNavigator.AdditionalNode = "<span style='Color:#F00'> " + keyword + " </span> 的短消息";
return;
}
this.SmpNavigator.AdditionalNode = "所有短消息";
}
}
private void PageDataBind(string keyword, MessageSearchField searchField, MessageManageType manageType)
{
string str;
this.Page.Title = GetNodeContent(manageType);
this.ShowUserMessageList.ManageType = manageType;
this.ShowUserMessageList.SearchField = searchField;
this.ShowUserMessageList.SearchKeyword = keyword;
switch (searchField)
{
case MessageSearchField.Title:
str = "主题中含有 <span style='Color:#F00'> " + keyword + " </span> 的短消息";
break;
case MessageSearchField.Content:
str = "内容中含有 <span style='Color:#F00'> " + keyword + " </span> 的短消息";
break;
case MessageSearchField.Incept:
str = "收件人为 <span style='Color:#F00'> " + keyword + " </span> 的短消息";
break;
case MessageSearchField.Sender:
str = "发件人为 <span style='Color:#F00'> " + keyword + " </span> 的短消息";
break;
default:
str = "所有短消息";
break;
}
this.YourPosition.AdditionalNode = GetNodeContent(manageType) + " >> " + str;
}
protected void Page_Load(object sender, EventArgs e)
{
MessageManageType manageType = (MessageManageType)BasePage.RequestInt32("ManageType");
string text = this.TxtKeyword.Text;
MessageSearchField searchField = (MessageSearchField)DataConverter.CLng(this.DropSearch.SelectedValue);
if (string.IsNullOrEmpty(PEContext.Current.User.UserName))
{
this.BtnSubmit.Enabled = false;
}
if (!string.IsNullOrEmpty(text) && (searchField != MessageSearchField.All))
{
this.PageDataBind(text, searchField, (MessageManageType)DataConverter.CLng(this.DropManageType.SelectedValue));
}
else
{
this.ShowUserMessageList.ManageType = manageType;
this.Page.Title = GetNodeContent(manageType);
this.YourPosition.AdditionalNode = GetNodeContent(manageType) + " >> 所有短消息";
}
}
public static IList <MessageInfo> GetMessageList(MessageSearchField searchField, string keyword, int maxNumberRows, int startRowIndexId)
{
return(dal.GetMessageList(startRowIndexId, maxNumberRows, searchField, DataSecurity.FilterBadChar(keyword)));
}
public static int Count(MessageSearchField searchField, string keyword, string userName, MessageManageType manageType)
{
return(dal.Count());
}
public static int Count(MessageSearchField searchField, string keyword)
{
return(dal.Count());
}
public static IList <MessageInfo> GetMessageList(int startRowIndexId, int maxNumberRows, string userName, MessageManageType manageType, MessageSearchField searchField, string keyword)
{
if (string.IsNullOrEmpty(userName))
{
return(new List <MessageInfo>());
}
return(dal.GetMessageList(startRowIndexId, maxNumberRows, DataSecurity.FilterBadChar(userName), manageType, searchField, DataSecurity.FilterBadChar(keyword)));
}
public IList <MessageInfo> GetMessageList(int startRowIndexId, int maxNumberRows, string userName, MessageManageType manageType, MessageSearchField searchField, string keyword)
{
Database db = DatabaseFactory.CreateDatabase();
StringBuilder builder = new StringBuilder();
switch (manageType)
{
case MessageManageType.Inbox:
builder.Append("IsSend = 1 AND IsDelInbox = 0 AND Incept = '" + DBHelper.FilterBadChar(userName) + "'");
break;
case MessageManageType.Outbox:
builder.Append("Sender = '" + userName + "' AND IsSend = 0 AND IsDelSendbox = 0");
break;
case MessageManageType.IsSend:
builder.Append("Sender = '" + userName + "' AND IsSend = 1 AND IsDelSendbox = 0");
break;
case MessageManageType.Recycle:
builder.Append("((Sender = '" + userName + "' AND IsDelSendbox = 1) OR (Incept = '" + DBHelper.FilterBadChar(userName) + "' AND IsDelInbox = 1))");
break;
default:
builder.Append("IsSend = 1 AND IsDelInbox = 0 AND Incept = '" + DBHelper.FilterBadChar(userName) + "'");
break;
}
if ((searchField != MessageSearchField.All) && !string.IsNullOrEmpty(keyword))
{
builder.Append(" AND " + searchField.ToString() + " LIKE '%" + DBHelper.FilterBadChar(keyword) + "%'");
}
DbCommand storedProcCommand = db.GetStoredProcCommand("PR_Common_GetList");
db.AddInParameter(storedProcCommand, "@Filter", DbType.String, builder.ToString());
return(this.GetList(startRowIndexId, maxNumberRows, db, storedProcCommand));
}
public IList <MessageInfo> GetMessageList(int startRowIndexId, int maxNumberRows, MessageSearchField searchType, string keyword)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand storedProcCommand = db.GetStoredProcCommand("PR_Common_GetList");
if ((searchType != MessageSearchField.All) && !string.IsNullOrEmpty(keyword))
{
if (searchType == MessageSearchField.OnePeople)
{
string str = "Sender LIKE '%" + DBHelper.FilterBadChar(keyword) + "%' OR Incept LIKE '%" + DBHelper.FilterBadChar(keyword) + "%'";
db.AddInParameter(storedProcCommand, "@Filter", DbType.String, str);
}
else
{
db.AddInParameter(storedProcCommand, "@Filter", DbType.String, searchType.ToString() + " LIKE '%" + DBHelper.FilterBadChar(keyword) + "%'");
}
}
else
{
db.AddInParameter(storedProcCommand, "@Filter", DbType.String, "");
}
return(this.GetList(startRowIndexId, maxNumberRows, db, storedProcCommand));
}
