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