pagination.cs

最好用的站点内容管理系统 全部源代码都有

        protected string[] manage_user_discussclass_2 ={ "id", "id,DcID,Cname,Content", "User_DiscussClass where indexnumber='0' and Cname like cast(@titlem as nvarchar)", "order by Id desc" };

        protected string[] manage_user_discussclass_3 ={ "id", "id,DcID,Cname,Content", "User_DiscussClass where indexnumber='0' and Cname like cast(@titlem as nvarchar) and SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by Id desc" };

        protected string[] manage_user_discuss_1 ={ "id", "id,DisID,Cname,UserName,Creatime,Authoritymoney", "user_Discuss where siteID = @RequestSiteId and Cname like cast(@titlem as nvarchar)", "order by Id desc" };

        protected string[] manage_user_discuss_2 ={ "id", "id,DisID,Cname,UserName,Creatime,Authoritymoney", "user_Discuss where Cname like cast(@titlem as nvarchar) and SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by Id desc" };

        protected string[] user_message_Message_box_1 ={ "Id", "Id,Mid,Title,content,UserNum,Send_DateTime,LevelFlag,FileTF,isRead", "user_Message where Rec_UserNum=@UserNum and isRdel=0 and isRecyle=0", "order by Id desc" };

        protected string[] user_message_Message_box_2 ={ "id", "id,Mid,Title,content,UserNum,Send_DateTime,LevelFlag,FileTF,isRead", "user_Message where UserNum=@UserNum and issDel=0 and issRecyle=0", "order by Id desc" };

        protected string[] user_message_Message_box_3 ={ "id", "id,Mid,Title,content,UserNum,Send_DateTime,LevelFlag,FileTF,isRead", "user_Message where UserNum=@UserNum and SortType=1 and issDel=0 and issRecyle=0", "order by Id desc" };

        protected string[] user_message_Message_box_4 ={ "id", "id,Mid,Title,content,UserNum,Send_DateTime,LevelFlag,FileTF,isRead", "user_Message where ((Rec_UserNum=@UserNum and isRecyle=1) or (UserNum=@UserNum and issRecyle=1)) and issDel=0", "order by Id desc" };

        protected string[] user_discuss_discussacti_list ={ "id", "id,AId,Activesubject,UserName,CreaTime,ActiveExpense", "user_DiscussActive", "order by Id desc" };

        protected string[] user_discuss_discussactiestablish_list ={ "id", "id,AId,Activesubject,UserName,CreaTime", "user_DiscussActive where UserName=@cjUserName", "order by Id desc" };

        protected string[] user_discuss_discussactijoin_list = { "a.Id", "a.Id,a.AId,Activesubject,a.UserName,b.CreaTime,b.PId", "user_DiscussActive a inner join user_DiscussActiveMember b on a.AId=b.AId", "order by a.Id desc" };

        protected string[] user_discuss_discussManage_list ={ "id", "id,DisID,Cname,UserName,Creatime,Authoritymoney,Browsenumber", "user_Discuss where SUBSTRING(Authority, 1, 1) = '1'", "order by Id desc" };

        protected string[] user_discuss_discussManageestablish_list ={ "id", "id,DisID,Cname,UserName,Creatime,Browsenumber", "user_Discuss where UserName=@UserName", "order by Id desc" };

        protected string[] user_discuss_discussManagejoin_list = { "a.Id", "a.Id,a.DisID,Cname,a.UserName,b.Creatime,b.Member,a.Browsenumber", "user_Discuss a inner join user_DiscussMember b on a.DisID=b.DisID where b.UserNum=@UserNum", "order by a.Id desc" };

        protected string[] user_discuss_discussPhotoalbumlist ={ "id", "id,PhotoalbumName,PhotoalbumID,UserName,Creatime,pwd", "User_Photoalbum where isDisPhotoalbum=1 and DisID=@DisID", "order by ID desc" };
        //新闻栏目
        protected string[] manage_news_class_list ={ "id", "id,ClassID,ClassCName,ClassEname,ParentID,OrderID,IsURL,IsLock,[Domain],NaviShowtf,isPage", "News_Class where isRecyle!=1 and ParentID='0' " + NetCMS.Common.Public.getSessionStr() + "", "order by OrderID Desc,id desc" };

        protected string[] manage_news_class_list_1 ={ "id", "id,ClassID,ClassCName,ClassEname,ParentID,OrderID,IsURL,IsLock,[Domain],NaviShowtf,isPage", "News_Class where isRecyle!=1 and ParentID='0' and SiteID=@SiteID", "order by OrderID Desc,id desc" };
        //讨论组
        protected string[] user_discuss_discussphotoclass ={ "id", "id,ClassID,ClassName,Creatime,UserName", "user_PhotoalbumClass where isDisclass=1 and DisID=@DisID", "order by Id desc" };

        protected string[] user_discuss_discussTopi_commentary ={ "id", "id,creatTime,DtID,ParentID,UserNum", "User_DiscussTopic where ParentID=@DtIDs or (ParentID='0' and  DtID=@DtIDs)", "order by creatTime asc,id asc" };

        protected string[] user_discuss_discussTopi_list ={ "id", "id,VoteTF,DtID,Title,UserNum,creatTime", "User_DiscussTopic where ParentID='0' and DisID=@DisID", "order by Id desc" };

        protected string[] user_info_applyads = { "AdID", "AdID,adName,adType,ClickNum,ShowNum,creatTime,isLock,TimeOutDay", "ads Where CusID=@CusID ", "order by ID" };

        protected string[] General_manage_1 ={ "id", "id,Cname,gType,URL,EmailURL,isLock,SiteID", "news_Gen where SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by ID desc" };

        protected string[] General_manage_2 ={ "id", "id,Cname,gType,URL,EmailURL,isLock,SiteID", "news_Gen where SiteID='" + NetCMS.Global.Current.SiteID + "' and gType=@gType", "order by ID desc" };

        protected string[] user_discuss_discussphoto ={ "id", "id,PhotoID,PhotoName,PhotoTime,UserNum,PhotoContent,PhotoalbumID,PhotoUrl", "user_photo where PhotoalbumID=@PhotoalbumID", "order by ID desc" };

        protected string[] manage_news_SortPage ={ "id", "id,ClassID,ClassCName,ClassEname,ParentID,OrderID", "News_Class where isRecyle!=1 and ParentID='0' and ModelID='0'", "order by OrderID desc" };
        //自由标签
        protected string[] manage_label_FreeLabel_List ={ "id", "id,LabelID,LabelName,LabelSQL,StyleContent,Description,CreatTime,SiteID", "sys_LabelFree where SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by ID desc" };
        //PSF
        protected string[] manage_publish_psf ={ "id", "id,psfID,psfName,LocalDir,RemoteDir,isSub,CreatTime,isRecyle,SiteID", "sys_PSF where isRecyle=0 and SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by ID desc" };
        //计划任务
        protected string[] manage_publish_siteTask ={ "id", "id,taskID,TaskName,isIndex,ClassID,News,TimeSet,CreatTime,SiteID", "sys_SiteTask where SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by ID desc" };

        protected string[] Manage_Stat_View_1 ={ "id", "id,statid,classname", "stat_class where SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by ID desc" };

        protected string[] Manage_Stat_View_2 ={ "id", "id,vtime,vwhere,vwidth,vOS,vsoft,vpage", "stat_Info where classid=@viewid and SiteID=@SiteID ", "order by ID desc" };
        //常规列表 
        protected string[] configuration_system_Genlist_1 ={ "id", "Cname", "News_Gen where gType=@gType and isLock=0 and SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by Id desc" };
        //友情连接------------------后台分类
        protected string[] manage_Friend_Friend_List_1 ={ "id", "id,ClassID,ClassCName,Content", "friend_class where ParentID='0' and SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by ID desc" };

        protected string[] manage_Friend_Friend_List_2 ={ "id", "id,Name,ClassID,Type,Author,Url,Lock,isAdmin", "friend_link where SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by ID desc" };
        //友情连接------------------前台
        protected string[] user_friend_friend ={ "id", "id,Name,ClassID,Type,Author,Url,Lock,isAdmin", "friend_link where Author='" + NetCMS.Global.Current.UserNum + "'", "order by ID desc" };
        //归档
        protected string[] manage_news_History_Manage ={ "id", "id,NewsTitle,NewsType,Author,Souce,oldTime,CheckStat,isLock,DataLib", "old_News", "order by ID desc" };
        //调查
        protected string[] manage_survey_ManageVote ={ "Rid", "Rid,IID,TID,OtherContent,VoteIp,VoteTime,UserNumber,SiteID", "vote_Manage where SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by RID desc" };

        protected string[] manage_survey_setClass_1 ={ "vid", "vid,ClassName,Description", "vote_Class WHERE SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by vid desc" };

        protected string[] manage_survey_setClass_2 ={ "vid", "vid,ClassName,Description", "vote_Class where VID like cast(@VID as nvarchar) and SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by vid desc" };

        protected string[] manage_survey_setClass_3 ={ "vid", "vid,ClassName,Description", "vote_Class where ClassName like cast(@ClassName as nvarchar) and SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by vid desc" };

        protected string[] manage_survey_setClass_4 ={ "vid", "vid,ClassName,Description", "vote_Class where Description like cast(@Description as nvarchar) and SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by vid desc" };
        //调查选项
        protected string[] manage_survey_VoteItem_1 ={ "a.TID", "a.TID,IID,ItemName,a.ItemMode,PicSrc,DisColor,VoteCount,ItemDetail,Title", "vote_Item a inner join Vote_Topic b on a.TID=b.TID where a.TID like cast(@TID as nvarchar) and a.SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by a.TID desc" };

        protected string[] manage_survey_VoteItem_2 ={ "a.TID", "a.TID,IID,ItemName,a.ItemMode,PicSrc,DisColor,VoteCount,ItemDetail,Title", "vote_Item a inner join Vote_Topic b on a.TID=b.TID where a.SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by a.TID desc" };

        protected string[] manage_survey_VoteItem_3 ={ "a.TID", "a.TID,IID,ItemName,a.ItemMode,PicSrc,DisColor,VoteCount,ItemDetail,Title", "vote_Item a inner join Vote_Topic b on a.TID=b.TID where ItemName like cast(@ItemName as nvarchar) and a.SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by a.TID desc" };

        protected string[] manage_survey_VoteItem_4 ={ "a.TID", "a.TID,IID,ItemName,a.ItemMode,PicSrc,DisColor,VoteCount,ItemDetail,Title", "vote_Item a inner join Vote_Topic b on a.TID=b.TID where PicSrc like cast(@PicSrc as nvarchar) and a.SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by a.TID desc" };

        protected string[] manage_survey_VoteItem_5 ={ "a.TID", "a.TID,IID,ItemName,a.ItemMode,PicSrc,DisColor,VoteCount,ItemDetail,Title", "vote_Item a inner join Vote_Topic b on a.TID=b.TID where DisColor like cast(@DisColor as nvarchar) and a.SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by a.TID desc" };

        protected string[] manage_survey_VoteItem_6 ={ "a.TID", "a.TID,IID,ItemName,a.ItemMode,PicSrc,DisColor,VoteCount,ItemDetail,Title", "vote_Item a inner join Vote_Topic b on a.TID=b.TID where VoteCount like cast(@VoteCount as nvarchar) and a.SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by a.TID desc" };

        protected string[] manage_survey_VoteItem_7 ={ "a.TID", "a.TID,IID,ItemName,a.ItemMode,PicSrc,DisColor,VoteCount,ItemDetail,Title", "vote_Item a inner join Vote_Topic b on a.TID=b.TID where ItemDetail like cast(@ItemDetail as nvarchar) and a.SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by a.TID desc" };
        //投票主题
        protected string[] manage_survey_VoteTopic_1 ={ "TID", "TID,a.VID,Title,Type,DisMode,StartDate,EndDate,ItemMode,ClassName", "Vote_Topic a inner join Vote_Class b on a.VID=b.VID where a.SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by TID desc" };

        protected string[] manage_survey_VoteTopic_2 ={ "TID", "TID,a.VID,Title,Type,DisMode,StartDate,EndDate,ItemMode,ClassName", "Vote_Topic a inner join Vote_Class b on a.VID=b.VID where Title like cast(@Title as nvarchar) and a.SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by TID desc" };

        protected string[] manage_survey_VoteTopic_3 ={ "TID", "TID,a.VID,Title,Type,DisMode,StartDate,EndDate,ItemMode,ClassName", "Vote_Topic a inner join Vote_Class b on a.VID=b.VID where a.VID like cast(@VID as nvarchar) and a.SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by TID desc" };

        protected string[] manage_survey_VoteTopic_4 ={ "TID", "TID,a.VID,Title,Type,DisMode,StartDate,EndDate,ItemMode,ClassName", "Vote_Topic a inner join Vote_Class b on a.VID=b.VID where StartDate like cast(@StartDate as nvarchar) and a.SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by TID desc" };

        protected string[] manage_survey_VoteTopic_5 ={ "TID", "TID,a.VID,Title,Type,DisMode,StartDate,EndDate,ItemMode,ClassName", "Vote_Topic a inner join Vote_Class b on a.VID=b.VID where EndDate like cast(@EndDate as nvarchar) and a.SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by TID desc" };

        protected string[] manage_survey_VoteTopic_6 ={ "TID", "TID,a.VID,Title,Type,DisMode,StartDate,EndDate,ItemMode,ClassName", "Vote_Topic a inner join Vote_Class b on a.VID=b.VID where ItemMode like cast(@ItemMode as nvarchar) and a.SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by TID desc" };
        //自定义字段
        protected string[] manage_Sys_DefineTable_Manage = { "DefineId", "DefineId,DefineInfoId,DefineName,ParentInfoId", "define_class where ParentInfoId='0' and SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by DefineId desc" };
        //前台显示文章
        protected string[] user_ShowUser_1 = { "id", "ConID,id,Title,creatTime,ClassID", "user_Constr where UserNum=@UserNum and ClassID=@ClassID and isuserdel=0", "order by Id desc" };

        protected string[] user_ShowUser_1_1 = { "id", "ConID,id,Title,creatTime,ClassID", "user_Constr where UserNum=@UserNum and isuserdel=0", "order by Id desc" };

        protected string[] user_ShowUser_2 ={ "id", "id,PhotoalbumName,PhotoalbumID,pwd", "User_Photoalbum where isDisPhotoalbum=0 and UserName=@UserNum", "order by ID desc" };
        //显示相册

        protected string[] user_show_showphoto ={ "id", "id,PhotoID,PhotoName,PhotoTime,UserNum,PhotoContent,PhotoalbumID,PhotoUrl", "user_photo where PhotoalbumID=@PhotoalbumID", "order by ID desc" };

        //模型列表
        protected string[] manage_channel_list ={ "a.id", "a.id,a.channelName,a.channelDescript,a.channelItem,a.channelEItem,a.islock,a.isHTML,a.DataLib,a.issys,a.binddomain,(select channelName from " + UIConfig.dataRe + "sys_channel b where b.id=a.parentID) as cNames", "sys_channel a", "order by a.ID desc" };

        protected string[] manage_channel_value ={ "id", "id,OrderID,CName,EName,ChID,islock,isUser,vType,vLength,fieldLength,isNulls,isSearch,vHeight,HTMLedit", "sys_channelvalue where ChID=@ChID", "order by OrderID desc,id DESC" };