public bool Clear(MessageManageType manageType, string userName, string messageIdList)
{
string format = string.Empty;
switch (manageType)
{
case MessageManageType.Inbox:
format = "UPDATE PE_Message SET IsDelInbox = 1 WHERE Incept = '{0}' AND IsDelInbox = 0 {1}";
break;
case MessageManageType.Outbox:
format = "UPDATE PE_Message SET IsDelSendbox = 1 WHERE Sender = '{0}' AND IsDelSendbox = 0 AND IsSend = 0 {1}";
break;
case MessageManageType.IsSend:
format = "UPDATE PE_Message SET IsDelSendbox = 1 WHERE Sender = '{0}' AND IsDelSendbox = 0 AND IsSend = 1 {1}";
break;
case MessageManageType.Recycle:
format = "DELETE FROM PE_Message WHERE Incept = '{0}' AND IsDelInbox = 1 AND IsDelSendbox = 2 {1} ; DELETE FROM PE_Message WHERE Sender = '{0}' AND IsDelSendbox = 1 AND IsDelInbox = 2 {1} ; DELETE FROM PE_Message WHERE Sender = '{0}' AND IsDelSendbox = 1 AND IsSend = 0 {1} ; Update PE_Message Set IsDelSendbox = 2 WHERE Sender = '{0}' AND IsDelSendbox = 1 {1} ; Update PE_Message Set IsDelInbox = 2 WHERE Incept = '{0}' AND IsDelInbox = 1 {1} ";
break;
default:
return(false);
}
string str2 = string.Empty;
if (!string.IsNullOrEmpty(messageIdList))
{
str2 = " AND MessageID In(" + DBHelper.ToValidId(messageIdList) + ")";
}
return(DBHelper.ExecuteSql(string.Format(format, DBHelper.FilterBadChar(userName), str2)));
}
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;
}
public static bool Clear(MessageManageType manageType, string userName, string messageIdList)
{
if ((messageIdList != null) && !DataValidator.IsValidId(messageIdList))
{
return(false);
}
if (string.IsNullOrEmpty(userName))
{
return(false);
}
return(dal.Clear(manageType, DataSecurity.FilterBadChar(userName), messageIdList));
}
private static string GetNodeContent(MessageManageType manageType)
{
switch (manageType)
{
case MessageManageType.Inbox:
return("收件箱");
case MessageManageType.Outbox:
return("草稿箱");
case MessageManageType.IsSend:
return("已发送");
case MessageManageType.Recycle:
return("废件箱");
}
return("收件箱");
}
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 int Count(MessageSearchField searchField, string keyword, string userName, MessageManageType manageType)
{
return(dal.Count());
}
public static bool Clear(MessageManageType manageType, string userName)
{
return(Clear(manageType, userName, null));
}
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));
}
