publicList<NoticeState>GetNoticeByToUserID(Searchsearch){//search.userId=3;stringsql="select*fromNoticesWHEREID>0";varparam=newDynamicParameters();sql+="ANDToUserIDLIKE@toUserID";param.Add("toUserID","%"+search.userId.ToString()+"%");if(search.ID>0){sql+="ANDid=@id";param.Add("id",search.ID);}varNoticeState=newList<NoticeState>();NoticeState.AddRange(_workingDB.Query<NoticeState>(sql,param).ToList());stringsql2="select*fromIsReadNoticeswhereNoticeID=@noticeIDANDUserID=@uid";foreach(varninNoticeState){IsReadNoticeisReadNotices=_workingDB.Query<IsReadNotice>(sql2,new{noticeID=n.ID,uid=search.userId}).SingleOrDefault();if(isReadNotices!=null){n.statusMsg=isReadNotices.statusMsg;n.Remarks=isReadNotices.Remarks;}}returnNoticeState;}