protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
switch (RequestHelper.GetQueryString <string>("Action"))
{
case "delete":
CheckAdminPower("DeleteMessage", PowerCheckType.Single);
int id = RequestHelper.GetQueryString <int>("ID");
if (id > 0)
{
ReceiveMessageBLL.Delete(id);
AdminLogBLL.Add(string.Format("删除已发送消息(ID:{0})", id));
ScriptHelper.Alert("删除成功", "SendMessage.aspx");
}
break;
case "search":
default:
CheckAdminPower("ReadMessage", PowerCheckType.Single);
Title.Text = RequestHelper.GetQueryString <string>("Title");
StartAddDate.Text = RequestHelper.GetQueryString <string>("StartAddDate");
EndAddDate.Text = RequestHelper.GetQueryString <string>("EndAddDate");
ReceiveMessageSearchInfo searchInfo = new ReceiveMessageSearchInfo();
searchInfo.Title = RequestHelper.GetQueryString <string>("Title");
searchInfo.StartDate = RequestHelper.GetQueryString <DateTime>("StartAddDate");
searchInfo.EndDate = RequestHelper.GetQueryString <DateTime>("EndAddDate");
BindControl(ReceiveMessageBLL.SearchList(CurrentPage, PageSize, searchInfo, ref Count), RecordList, MyPager);
break;
}
}
}
protected override void PageLoad()
{
base.PageLoad();
isRead = RequestHelper.GetQueryString <int>("isread");
int currentPage = RequestHelper.GetQueryString <int>("Page");
if (currentPage < 1)
{
currentPage = 1;
}
int pageSize = 10;
int count = 0;
ReceiveMessageSearchInfo searchInfo = new ReceiveMessageSearchInfo();
searchInfo.UserID = base.UserId;
searchInfo.IsRead = isRead;
msgList = ReceiveMessageBLL.SearchList(currentPage, pageSize, searchInfo, ref count);
pager.Init(currentPage, pageSize, count, !string.IsNullOrEmpty(isMobile));
//数量统计
var msgAllList = ReceiveMessageBLL.SearchList(new ReceiveMessageSearchInfo {
UserID = base.UserId
});
allCount = msgAllList.Count;
readCount = msgAllList.Where(m => m.IsRead == 1).Count();
Title = "我的消息";
}
public MssqlCondition PrepareCondition(ReceiveMessageSearchInfo searchEntity)
{
MssqlCondition mssqlCondition = new MssqlCondition();
mssqlCondition.Add("[Title]", searchEntity.Title, ConditionType.Like);
mssqlCondition.Add("[UserID]", searchEntity.UserID, ConditionType.Equal);
mssqlCondition.Add("[Date]", searchEntity.StartDate, ConditionType.MoreOrEqual);
mssqlCondition.Add("[Date]", searchEntity.EndDate, ConditionType.LessOrEqual);
mssqlCondition.Add("[IsRead]", searchEntity.IsRead, ConditionType.Equal);
return(mssqlCondition);
}
public List <ReceiveMessageInfo> SearchReceiveMessageList(ReceiveMessageSearchInfo receiveMessageSearch)
{
MssqlCondition mssqlCondition = new MssqlCondition();
this.PrepareCondition(mssqlCondition, receiveMessageSearch);
List <ReceiveMessageInfo> receiveMessageList = new List <ReceiveMessageInfo>();
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@condition", SqlDbType.NVarChar) };
pt[0].Value = mssqlCondition.ToString();
using (SqlDataReader reader = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "SearchReceiveMessageList", pt))
{
this.PrepareReceiveMessageModel(reader, receiveMessageList);
}
return(receiveMessageList);
}
public List <ReceiveMessageInfo> SearchList(ReceiveMessageSearchInfo searchEntity)
{
using (var conn = new SqlConnection(connectString))
{
string sql = "select * from [ReceiveMessage]";
string condition = PrepareCondition(searchEntity).ToString();
if (!string.IsNullOrEmpty(condition))
{
sql += " where " + condition;
}
sql += " Order by [ID] desc";
return(conn.Query <ReceiveMessageInfo>(sql).ToList());
}
}
public List <ReceiveMessageInfo> SearchList(int currentPage, int pageSize, ReceiveMessageSearchInfo searchEntity, ref int count)
{
using (var conn = new SqlConnection(connectString))
{
ShopMssqlPagerClass pc = new ShopMssqlPagerClass();
pc.TableName = "ReceiveMessage";
pc.Fields = "*";
pc.CurrentPage = currentPage;
pc.PageSize = pageSize;
pc.OrderField = "[Id]";
pc.OrderType = OrderType.Desc;
pc.MssqlCondition = PrepareCondition(searchEntity);
count = pc.Count;
return(conn.Query <ReceiveMessageInfo>(pc).ToList());
}
}
public void PrepareCondition(MssqlCondition mssqlCondition, ReceiveMessageSearchInfo receiveMessageSearch)
{
mssqlCondition.Add("[IsRead]", receiveMessageSearch.IsRead, ConditionType.Equal);
mssqlCondition.Add("[IsAdmin]", receiveMessageSearch.IsAdmin, ConditionType.Equal);
mssqlCondition.Add("[UserID]", receiveMessageSearch.UserID, ConditionType.Equal);
}
public List <ReceiveMessageInfo> SearchReceiveMessageList(int currentPage, int pageSize, ReceiveMessageSearchInfo receiveMessageSearch, ref int count)
{
List <ReceiveMessageInfo> receiveMessageList = new List <ReceiveMessageInfo>();
ShopMssqlPagerClass class2 = new ShopMssqlPagerClass();
class2.TableName = ShopMssqlHelper.TablePrefix + "ReceiveMessage";
class2.Fields = "[ID],[Title],[Content],[Date],[IsRead],[IsAdmin],[FromUserID],[FromUserName],[UserID],[UserName]";
class2.CurrentPage = currentPage;
class2.PageSize = pageSize;
class2.OrderField = "[ID]";
class2.OrderType = OrderType.Desc;
this.PrepareCondition(class2.MssqlCondition, receiveMessageSearch);
class2.Count = count;
count = class2.Count;
using (SqlDataReader reader = class2.ExecuteReader())
{
this.PrepareReceiveMessageModel(reader, receiveMessageList);
}
return(receiveMessageList);
}
/// <summary>
/// 页面加载
/// </summary>
protected override void PageLoad()
{
base.PageLoad();
action = RequestHelper.GetQueryString <string>("Action");
int currentPage = RequestHelper.GetQueryString <int>("Page");
if (currentPage < 1)
{
currentPage = 1;
}
int pageSize = 8;
int count = 0;
switch (action)
{
case "ReceiveMessage":
ReceiveMessageSearchInfo receiveMessageSearch = new ReceiveMessageSearchInfo();
receiveMessageSearch.UserID = base.UserID;
receiveMessageList = ReceiveMessageBLL.SearchReceiveMessageList(currentPage, pageSize, receiveMessageSearch, ref count);
ajaxPagerClass.CurrentPage = currentPage;
ajaxPagerClass.PageSize = pageSize;
ajaxPagerClass.Count = count;
ajaxPagerClass.FirstPage = "<<首页";
ajaxPagerClass.PreviewPage = "<<上一页";
ajaxPagerClass.NextPage = "下一页>>";
ajaxPagerClass.LastPage = "末页>>";
ajaxPagerClass.ListType = false;
ajaxPagerClass.DisCount = false;
ajaxPagerClass.PrenextType = true;
break;
case "SendMessage":
SendMessageSearchInfo sendMessageSearch = new SendMessageSearchInfo();
sendMessageSearch.UserID = base.UserID;
sendMessageList = SendMessageBLL.SearchSendMessageList(currentPage, pageSize, sendMessageSearch, ref count);
ajaxPagerClass.CurrentPage = currentPage;
ajaxPagerClass.PageSize = pageSize;
ajaxPagerClass.Count = count;
ajaxPagerClass.FirstPage = "<<首页";
ajaxPagerClass.PreviewPage = "<<上一页";
ajaxPagerClass.NextPage = "下一页>>";
ajaxPagerClass.LastPage = "末页>>";
ajaxPagerClass.ListType = false;
ajaxPagerClass.DisCount = false;
ajaxPagerClass.PrenextType = true;
break;
case "WriteMessage":
UserFriendSearchInfo userFriendSearch = new UserFriendSearchInfo();
userFriendSearch.UserID = base.UserID;
userFriendList = UserFriendBLL.SearchUserFriendList(userFriendSearch);
break;
case "SearchFriend":
SearchFriend();
break;
case "SendUserMessage":
SendUserMessage();
break;
case "DeleteReceiveMessage":
DeleteReceiveMessage();
break;
case "DeleteSendMessage":
DeleteSendMessage();
break;
default:
break;
}
}
public static List <ReceiveMessageInfo> SearchList(int currentPage, int pageSize, ReceiveMessageSearchInfo searchEntity, ref int count)
{
return(dal.SearchList(currentPage, pageSize, searchEntity, ref count));
}
public static List <ReceiveMessageInfo> SearchList(ReceiveMessageSearchInfo searchEntity)
{
return(dal.SearchList(searchEntity));
}
protected override void PageLoad()
{
base.PageLoad();
this.action = RequestHelper.GetQueryString <string>("Action");
int queryString = RequestHelper.GetQueryString <int>("Page");
if (queryString < 1)
{
queryString = 1;
}
int pageSize = 8;
int count = 0;
switch (this.action)
{
case "ReceiveMessage":
{
ReceiveMessageSearchInfo receiveMessage = new ReceiveMessageSearchInfo();
receiveMessage.UserID = base.UserID;
this.receiveMessageList = ReceiveMessageBLL.SearchReceiveMessageList(queryString, pageSize, receiveMessage, ref count);
this.ajaxPagerClass.CurrentPage = queryString;
this.ajaxPagerClass.PageSize = pageSize;
this.ajaxPagerClass.Count = count;
break;
}
case "SendMessage":
{
SendMessageSearchInfo sendMessage = new SendMessageSearchInfo();
sendMessage.UserID = base.UserID;
this.sendMessageList = SendMessageBLL.SearchSendMessageList(queryString, pageSize, sendMessage, ref count);
this.ajaxPagerClass.CurrentPage = queryString;
this.ajaxPagerClass.PageSize = pageSize;
this.ajaxPagerClass.Count = count;
break;
}
case "WriteMessage":
{
UserFriendSearchInfo userFriend = new UserFriendSearchInfo();
userFriend.UserID = base.UserID;
this.userFriendList = UserFriendBLL.SearchUserFriendList(userFriend);
break;
}
case "SearchFriend":
this.SearchFriend();
break;
case "SendUserMessage":
this.SendUserMessage();
break;
case "DeleteReceiveMessage":
this.DeleteReceiveMessage();
break;
case "DeleteSendMessage":
this.DeleteSendMessage();
break;
}
}
public static List <ReceiveMessageInfo> SearchReceiveMessageList(ReceiveMessageSearchInfo receiveMessage)
{
return(dal.SearchReceiveMessageList(receiveMessage));
}
