pagination.cs

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

//======================================================
//==     (c)2008 aspxcms inc by NeTCMS v1.0              ==
//==          Forum:bbs.aspxcms.com                   ==
//==         Website:www.aspxcms.com                  ==
//======================================================
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Text;
using System.Reflection;
using System.Text.RegularExpressions;
using NetCMS.Model;
using NetCMS.DALFactory;
using NetCMS.DALProfile;
using NetCMS.Config;

namespace NetCMS.DALSQLServer
{
    public class Pagination : DbBase, IPagination
    {
        //分页查询列表，第一个字段必须是不重复的索引字段，必须有order by 索引字段语句
        //频道管理列表
        protected string[] manage_news_site_list = { "Id", "Id,ChannelID,CName,EName,ChannCName,IsURL,isLock,Domain,ContrTF,ShowNaviTF", "News_site where isRecyle=0 and (ParentID='" + NetCMS.Global.Current.SiteID + "' or ChannelID='" + NetCMS.Global.Current.SiteID + "')", "order by Id desc" };

        protected string[] user_constr_constraccount ={ "id", "id,ConID,bankName,bankaccount,bankcard,bankRealName", "sys_userother where UserNum=@UserNum", "order by id desc" };

        protected string[] user_constr_constrclass ={ "id", "id,Ccid,cName,creatTime", "user_ConstrClass where UserNum=@UserNum", "order by Id desc" };

        protected string[] user_constr_constrlist ={ "id", "id,ConID,Title,creatTime,ClassID,isCheck,Tags", "user_Constr where UserNum=@UserNum", "order by Id desc" };

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

        protected string[] user_constr_constrmoney ={ "id", "id,Money,payTime,constrPayID", "user_constrPay where UserNum=@UserNum", "order by id desc" };

        protected string[] manage_label_style_1 ={ "id", "id,ClassID,Sname,CreatTime,isRecyle", "sys_styleclass where SiteID=@SiteID and isRecyle=0", "order by Id desc" };

        protected string[] manage_label_style_2 ={ "id", "id,styleID,StyleName,CreatTime,Content", "sys_LabelStyle where ClassID=@ClassID and  isRecyle=0 and SiteID=@SiteID", "order by Id desc" };

        protected string[] manage_label_style_3 ={ "id", "id,styleID,StyleName,CreatTime,Content", "sys_LabelStyle where StyleName like cast(@Keyword as nvarchar) and  isRecyle=0 and SiteID=@SiteID", "order by Id desc" };

        protected string[] user_friend_friendlist_1 ={ "id", "id,FriendUserNum,UserNum,bUserNum,UserName,CreatTime", "User_Friend  where UserNum=@UserNum and HailFellow=@HailFellow", "order by Id desc" };

        protected string[] user_friend_friendlist_2 ={ "id", "id,FriendUserNum,UserNum,bUserNum,UserName,CreatTime", "User_Friend  where UserNum=@UserNum", "order by Id desc" };

        protected string[] user_friend_friendmanage ={ "id", "id,HailFellow,FriendName,CreatTime", "User_FriendClass where UserNum=@UserNum or gdfz='1'", "order by Id desc" };

        protected string[] user_info_announce ={ "id", "id,title,Content,creatTime,islock,getPoint,GroupNumber", "user_news  where SiteID=@SiteID and islock=0", "order by Id desc" };

        protected string[] user_info_collection_1 ={ "id", "id,FID,Infotitle,CreatTime,datalib,ChID", "api_faviate where UserNum=@UserNum and APIID=@Api", "order by Id desc" };

        protected string[] user_info_collection_2 ={ "id", "id,FID,Infotitle,CreatTime,datalib,ChID", "api_faviate where UserNum=@UserNum ", "order by Id desc" };

        protected string[] user_info_history_1 ={ "id", "id,GhID,ghtype,Gpoint,iPoint,Money,CreatTime,UserNUM,gtype,content", "user_Ghistory where UserNUM=@UserNum and ghtype = 0", "order by id desc" };

        protected string[] user_info_history_2 ={ "id", "id,GhID,ghtype,Gpoint,iPoint,Money,CreatTime,UserNUM,gtype,content", "user_Ghistory where UserNUM=@UserNum and ghtype = 1", "order by id desc" };

        protected string[] user_info_history_3 ={ "id", "id,GhID,ghtype,Gpoint,iPoint,Money,CreatTime,UserNUM,gtype,content", "user_Ghistory where UserNUM=@UserNum and gtype=@gtype", "order by id desc" };

        protected string[] user_info_history_4 ={ "id", "id,GhID,ghtype,Gpoint,iPoint,Money,CreatTime,UserNUM,gtype,content", "user_Ghistory where UserNUM=@UserNum ", "order by id desc" };

        protected string[] manage_label_SysLabel_List_1 ={ "id", "id,ClassID,ClassName,CreatTime,Content,isRecyle", "sys_LabelClass Where isRecyle=0 And SiteID=@SiteID", "order by Id desc" };

        protected string[] manage_label_SysLabel_List_2 ={ "id", "id,LabelID,Label_Name,CreatTime,Description,Label_Content", "sys_Label Where isRecyle=0 And  isBack=0 And SiteID=@SiteID And ClassID=@ClassID", "order by Id desc" };

        protected string[] manage_label_SysLabel_List_3 ={ "id", "id,LabelID,Label_Name,CreatTime,Description,Label_Content", "sys_Label Where isRecyle=0 And  isBack=0 And isSys=0 and SiteID=@SiteID and (Label_Name like cast(@Keyword as nvarchar) or Description like cast(@Keyword as nvarchar))", "order by Id desc" };

        protected string[] manage_label_syslabel_bak ={ "id", "id,LabelID,Label_Name,CreatTime", "sys_Label Where SiteID=@SiteID And isRecyle=0 And isBack=1", "order by Id desc" };

        protected string[] user_Rss_RssFeed_1 ={ "id", "id,ClassID,ClassCName,ClassEName,ParentID", "news_Class where ParentID='0' and isURL=0 and isRecyle=0 and isLock=0 and isPage=0 and SiteID=@SiteID", "order by Id desc" };

        protected string[] user_Rss_RssFeed_2 ={ "id", "id,ClassID,ClassCName,ClassEName,ParentID", "news_Class where ParentID=@ParentID and isURL=0 and isRecyle=0 and isLock=0 and isPage=0 and SiteID=@SiteID", "order by Id desc" };

        protected string[] manage_Sys_admin_list = { "a.Id", "a.Id,a.UserNum,b.RealName,b.Email,a.isSuper,a.isLock", "sys_admin a left join sys_User b  on a.UserNum=b.UserNum Where b.isAdmin=1 and a.SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by a.Id desc" };

        protected string[] manage_Sys_admin_list_1 = { "a.Id", "a.Id,a.UserNum,b.RealName,b.Email,a.isSuper,a.isLock", "sys_admin a left join sys_User b  on a.UserNum=b.UserNum Where b.isAdmin=1 and a.SiteID=@SiteID", "order by a.Id desc" };

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

        protected string[] user_photo_Photoalbumlist ={ "id", "id,PhotoalbumName,PhotoalbumID,UserName,Creatime,pwd", "User_Photoalbum where isDisPhotoalbum=0 and UserName=@UserNum", "order by ID desc" };

        protected string[] user_photo_photoclass ={ "id", "id,ClassID,ClassName,Creatime,UserName", "user_PhotoalbumClass where isDisclass=0 and UserName=@UserNum", "order by Id desc" };

        protected string[] manage_Sys_admin_group ={ "id", "id,adminGroupNumber,GroupName,CreatTime", "sys_AdminGroup Where SiteID=@SiteID", "order by Id desc" };
        //地区管理
        protected string[] manage_user_arealist ={ "id", "id,Cid,cityName,creatTime", "Sys_City where Pid='0' and SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by OrderId desc,ID desc" };

        protected string[] manage_user_arealist_City ={ "id", "id,Cid,cityName,creatTime", "Sys_City where Pid=@Cid and SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by Id desc" };

        protected string[] manage_user_discussacti_list_1 ={ "id", "id,AId,Activesubject,UserName,CreaTime,ActiveExpense", "user_DiscussActive where 1=1 and Activesubject like cast(@titlem as nvarchar) and siteID = @RequestSiteId", "order by Id desc" };

        protected string[] manage_user_discussacti_list_2 ={ "id", "id,AId,Activesubject,UserName,CreaTime,ActiveExpense", "user_DiscussActive where 1=1 and Activesubject like cast(@titlem as nvarchar)", "order by Id desc" };
        //投稿后台
        protected string[] manage_Contribution_Constr_chicklist ={ "id", "id,ConID,Title,creatTime,UserNum,Source,Tags,Author,ispass,Contrflg", "User_Constr where substring(Contrflg,3,1) = '1' and isadmidel=0 and isCheck=1 and ispass=0 and SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by Id desc" };

        protected string[] manage_Contribution_Constr_List ={ "id", "id,ConID,Title,creatTime,Source,Tags,Contrflg,Author,ispass", "User_Constr where substring(Contrflg,3,1) = '1' and isadmidel=0 and isCheck=0 and ispass=0 and SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by Id desc" };

        protected string[] manage_news_Special_List ={ "id", "id,SpecialID,SpecialCName,isLock,CreatTime", "news_special Where SiteID=@SiteID  and isRecyle=0 and ParentID='0'", "order by Id Desc" };
        //公告
        protected string[] manage_user_announce ={ "id", "id,title,Content,creatTime,islock,getPoint,GroupNumber,SiteID", "user_news where SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by Id Desc" };

        //好友验证
        protected string[] user_Requestinformation ={ "id", "id,qUsername,bUsername,datatime,Content,ischick", "user_Requestinformation where bUsername='" + NetCMS.Global.Current.UserName + "' and ischick=1", "order by Id Desc" };

        protected string[] manage_user_announce_1 ={ "id", "id,title,Content,creatTime,islock,getPoint,GroupNumber,SiteID", "user_news where SiteID=@SiteID", "order by Id Desc" };
        //稿酬级别
        protected string[] manage_Contribution_Constr_SetParamlist ={ "id", "id,PCId,ConstrPayName,gPoint,iPoint,money,Gunit", "sys_ParmConstr where SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by Id Desc" };

        //稿酬
        protected string[] manage_Contribution_paymentannals ={ "id", "id,constrPayID,userNum,Money,payTime,PayAdmin", "user_constrPay where SiteID='" + NetCMS.Global.Current.SiteID + "'", "order by id Desc" };

        //logs 
        protected string[] user_manage_logs_1 = { "id", "id,logID,Title,Content,creatTime,dateNum,LogDateTime,UserNum,SiteID", "user_userlogs Where UserNum='" + NetCMS.Global.Current.UserNum + "'", "order by creatTime desc,id desc" };

        //网址收藏
        protected string[] user_info_url = { "id", "id,ClassID,URLName,URL,URLColor,CreatTime,Content", "user_URL where UserNum='" + NetCMS.Global.Current.UserNum + "'", "order by id desc" };

        protected string[] user_info_url_1 = { "id", "id,ClassID,URLName,URL,URLColor,CreatTime,Content", "user_URL where ClassID=@ClassID and UserNum='" + NetCMS.Global.Current.UserNum + "'", "order by id desc" };

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