政务督查 政协提案查询列表 sin sql_sysquery False MeetingType supersql 0 会议类别 MeetingId supersql 0 属于哪个会议 Keyword supersql 关键字 TitleLen supersql 50 标题长度 true true SELECT TOP @pagesize * FROM PE_GV_Proposal, PE_GV_Meeting WHERE PE_GV_Proposal.MeetingId = PE_GV_Meeting.MeetingId AND PE_GV_Proposal.Status > 0 AND IsPublic = 1 AND PE_GV_Meeting.MeetingType = @MeetingType AND ProposalTitle like '%@Keyword%' AND PE_GV_Proposal.MeetingId=@MeetingId AND PE_GV_Proposal.ProposalId NOT IN(SELECT TOP @startrow PE_GV_Proposal.ProposalId FROM PE_GV_Proposal, PE_GV_Meeting WHERE PE_GV_Proposal.MeetingId = PE_GV_Meeting.MeetingId AND Status > 0 AND IsPublic = 1 AND ProposalTitle like '%@Keyword%' AND PE_GV_Meeting.MeetingType = @MeetingType AND ProposalTitle like '%@Keyword%' AND PE_GV_Proposal.MeetingId=@MeetingId ORDER BY InputTime DESC) ORDER BY InputTime DESC SELECT TOP @pagesize * FROM PE_GV_Proposal, PE_GV_Meeting WHERE PE_GV_Proposal.MeetingId = PE_GV_Meeting.MeetingId AND PE_GV_Proposal.Status > 0 AND IsPublic = 1 AND PE_GV_Meeting.MeetingType = @MeetingType AND ProposalTitle like '%@Keyword%' AND PE_GV_Proposal.MeetingId=@MeetingId AND PE_GV_Proposal.ProposalId NOT IN(SELECT TOP @startrow PE_GV_Proposal.ProposalId FROM PE_GV_Proposal, PE_GV_Meeting WHERE PE_GV_Proposal.MeetingId = PE_GV_Meeting.MeetingId AND Status > 0 AND IsPublic = 1 AND PE_GV_Meeting.MeetingType = @MeetingType AND ProposalTitle like '%@Keyword%' AND PE_GV_Proposal.MeetingId=@MeetingId ORDER BY InputTime DESC) ORDER BY InputTime DESC select count(*) from PE_GV_Proposal, PE_GV_Meeting WHERE PE_GV_Proposal.MeetingId = PE_GV_Meeting.MeetingId AND PE_GV_Proposal.Status > 0 AND IsPublic = 1 AND PE_GV_Meeting.MeetingType = @MeetingType AND ProposalTitle like '%@Keyword%' AND PE_GV_Proposal.MeetingId=@MeetingId ]]>

• [] {PE.SiteConfig.ApplicationPath/}Government/Supervision/ProposalContent.aspx?ProposalId=

]]> True 标记之间写分页SQL查询语句 select count(id) from database]]> 请先建立SQL分页语句