protected void Page_Load(object sender, EventArgs e)
{
TypeId = RequestData.Get <string>("TypeId");
if (!String.IsNullOrEmpty(TypeId))
{
ICriterion crit = null;
SearchCriterion.SetOrder("SendTime", false);
switch (TypeId)
{
case "ToSend":
SearchCriterion.AddSearch("SenderId", this.UserInfo.UserID, SearchModeEnum.Like);
crit = Expression.Or(Expression.Eq("IsSenderDelete", false), Expression.IsNull("IsSenderDelete"));
crit = SearchHelper.IntersectCriterions(crit, Expression.IsNull(SysMessage.Prop_State));
ents = SysMessageRule.FindAll(SearchCriterion, crit);
this.PageState.Add("SysMessageList", ents);
break;
case "Send":
SearchCriterion.AddSearch("SenderId", this.UserInfo.UserID, SearchModeEnum.Like);
crit = Expression.Or(Expression.Eq("IsSenderDelete", false), Expression.IsNull("IsSenderDelete"));
crit = SearchHelper.IntersectCriterions(crit, Expression.IsNotNull(SysMessage.Prop_State));
ents = SysMessageRule.FindAll(SearchCriterion, crit);
this.PageState.Add("SysMessageList", ents);
break;
case "Receive":
crit = Expression.Or(Expression.Eq("IsReceiverDelete", false), Expression.IsNull("IsReceiverDelete"));
crit = SearchHelper.IntersectCriterions(crit, Expression.IsNull(View_SysMessage.Prop_IsFirstView), Expression.Eq(View_SysMessage.Prop_ReceiveId, this.UserInfo.UserID)
, Expression.IsNull(View_SysMessage.Prop_IsDelete));
View_SysMessage[] mgs = View_SysMessage.FindAll(SearchCriterion, crit);
this.PageState.Add("SysMessageList", mgs);
break;
case "ReceiveReaded":
crit = Expression.Or(Expression.Eq("IsReceiverDelete", false), Expression.IsNull("IsReceiverDelete"));
crit = SearchHelper.IntersectCriterions(crit, Expression.IsNotNull(View_SysMessage.Prop_IsFirstView), Expression.Eq(View_SysMessage.Prop_ReceiveId, this.UserInfo.UserID)
, Expression.IsNull(View_SysMessage.Prop_IsDelete));
View_SysMessage[] mgss = View_SysMessage.FindAll(SearchCriterion, crit);
this.PageState.Add("SysMessageList", mgss);
break;
}
}
SysMessage ent = null;
switch (this.RequestAction)
{
case RequestActionEnum.Create:
ent = this.GetPostedData <SysMessage>();
ent.DoCreate();
this.SetMessage("新建成功！");
break;
case RequestActionEnum.Update:
ent = this.GetMergedData <SysMessage>();
ent.DoUpdate();
this.SetMessage("保存成功！");
break;
case RequestActionEnum.Delete:
ent = this.GetTargetData <SysMessage>();
ent.DoDelete();
this.SetMessage("删除成功！");
break;
case RequestActionEnum.Custom:
IList <object> ids = RequestData.GetList <object>("Ids");
if (ids != null && ids.Count > 0)
{
if (RequestActionString == "batchdelete")
{
if (TypeId == "Send" || TypeId == "ToSend")
{
SysMessage[] tents = SysMessage.FindAll(Expression.In("Id", ids.ToList()));
foreach (SysMessage tent in tents)
{
tent.IsSenderDelete = true;
tent.DoDelete();
}
}
else
{
SysMessage[] tents = SysMessage.FindAll(Expression.In("Id", ids.ToList()));
foreach (SysMessage tent in tents)
{
SysMessageReceive receive = SysMessageReceive.FindAllByProperties("MsgId", tent.Id, "ReceiverId", this.UserInfo.UserID)[0];
receive.IsDelete = "1";
receive.DeleteTime = DateTime.Now;
receive.Save();
}
}
}
}
break;
}
}
private void IniPersonalCenter()
{
int taskQuantity = 0;
sql = "select count(Id) from Task where status=0 and OwnerId='" + UserInfo.UserID + "'";
taskQuantity = DataHelper.QueryValue <int>(sql);
sql = "select count(Id)from BJKY_BeAdmin..WfWorkList where (State='New' and isnull(OwnerUserId,'')<>'') and IsSign='" + UserInfo.UserID + "'";
taskQuantity += DataHelper.QueryValue <int>(sql);
sql = @"select Count(Id) from BJKY_IntegratedManage..SurveyQuestion c where (select count(1) from BJKY_IntegratedManage..SurveyCommitHistory t
where t.SurveyId=c.Id and t.SurveyedUserId='" + UserInfo.UserID + "')=0 and (isnull(StatisticsPower,'')='' or PatIndex('%" + UserInfo.UserID + "%',StatisticsPower)>0)";
taskQuantity += DataHelper.QueryValue <int>(sql);
sql = @"select count(Id) from BJKY_MiddleDB..TaskMiddle where (State='New' or State='0') and OwnerUserId='" + UserInfo.UserID + "'";
taskQuantity += DataHelper.QueryValue <int>(sql);
if (taskQuantity > 0)
{
divTask.Style.Remove("background-image");
divTask.Style.Add("background-image", "url(/images/center/task2.png)");
divTaskQuan.Visible = true;
divTaskQuan.InnerHtml = taskQuantity.ToString();
}
else
{
divTask.Style.Remove("background-image");
divTask.Style.Add("background-image", "url(/images/center/task.png)");
divTaskQuan.Visible = false;
}
int noticeQuan = 0;//统计未读通知公告数量通知和公告两种类型的ID TypeId in ('eb9db227-6adc-4dd1-8783-467aadc2d11b','a0365551-9017-49f2-b416-14c6bbd8be9b')
sql = @"select count(Id) from News where (TypeId='a0365551-9017-49f2-b416-14c6bbd8be9b' or TypeId='eb9db227-6adc-4dd1-8783-467aadc2d11b') and
PATINDEX ( '%" + UserInfo.UserID + "%' , ReadState )<=0 and State='2'";
noticeQuan = DataHelper.QueryValue <int>(sql);
if (noticeQuan > 0)
{
divNotice.Style.Remove("background-image");
divNotice.Style.Add("background-image", "url(/images/center/notice2.png)");
NoticeQuan.Visible = true;
NoticeQuan.InnerHtml = noticeQuan.ToString();
}
else
{
divNotice.Style.Remove("background-image");
divNotice.Style.Add("background-image", "url(/images/center/notice.png)");
NoticeQuan.Visible = false;
}
int messageQuan = 0;
ICriterion crit = Expression.Or(Expression.Eq("IsReceiverDelete", false), Expression.IsNull("IsReceiverDelete"));
crit = SearchHelper.IntersectCriterions(crit, Expression.IsNull(View_SysMessage.Prop_IsFirstView), Expression.Eq(View_SysMessage.Prop_ReceiveId, UserInfo.UserID)
, Expression.IsNull(View_SysMessage.Prop_IsDelete));
View_SysMessage[] mgs = View_SysMessage.FindAll(SearchCriterion, crit);
messageQuan = mgs.Length;
if (messageQuan > 0)
{
divMessage.Style.Remove("background-image");
divMessage.Style.Add("background-image", "url(/images/center/message2.png)");
MessageQuan.Visible = true;
MessageQuan.InnerHtml = messageQuan.ToString();
}
else
{
divMessage.Style.Remove("background-image");
divMessage.Style.Add("background-image", "url(/images/center/message.png)");
MessageQuan.Visible = false;
}
}
