private DataTable Content_SelByNid(int siteID, string nids)//需要改为不依靠登录用户获取 { string where = ""; if (string.IsNullOrEmpty(nids)) { DataTable dt = Node_Sel(siteID); foreach (DataRow dr in dt.Rows) { nids += dr["NodeID"] + ","; } nids = nids.TrimEnd(','); } SafeSC.CheckIDSEx(nids); where += " A.NodeID IN(" + nids + ")"; PageSetting setting = new PageSetting() { cpage = CPage, psize = PSize, fields = "A.*,B.synopsis", t1 = "ZL_CommonModel", t2 = "ZL_C_Article", on = "A.ItemID=B.ID", where = where, order = "A.GeneralID DESC" }; return(DBCenter.SelPage(setting)); }
public PageSetting SelPage(int cpage, int psize, string ntype = "", int zstatus = -100, int infoid = -100, string sdate = "", string title = "") { string where = "1=1 "; List <SqlParameter> sp = new List <SqlParameter>(); if (!string.IsNullOrEmpty(ntype)) { SafeSC.CheckIDSEx(ntype); where += " AND NType IN(" + ntype + ")"; } if (zstatus != -100) { where += " AND ZStatus=" + zstatus; } if (infoid != -100) { where += " AND InfoID=" + infoid; } if (!string.IsNullOrEmpty(sdate)) { where += " AND BeginDate>=@sdate"; sp.Add(new SqlParameter("sdate", sdate)); } if (!string.IsNullOrEmpty(title)) { where += " AND Title LIKE @title"; sp.Add(new SqlParameter("title", "%" + title + "%")); } PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where, PK + " DESC", sp); DBCenter.SelPage(setting); return(setting); }
public PageSetting SelPage(int cpage, int psize) { PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, "", "CDate Desc"); DBCenter.SelPage(setting); return(setting); }
//PostContent //public DataTable SelByPid(int pid) //{ // return DBCenter.JoinQuery("A.*,B.salt AS UserFace,B.HoneyName", "ZL_Guest_Bar", "ZL_User", "A.CUser=B.UserID", "Pid=" + pid + " And A.Status>0", "CDATE ASC"); //} /// <summary> /// 查找指定cateid下主贴 /// </summary> public PageSetting SelPage(int cpage, int psize, int cateid, int uid, string key, bool isaudit = false) { string where = "Pid=0 "; if (cateid != 0) { where += " AND CateID=" + cateid; } //匿名用户不提供搜索 if (uid > 0) { where += " AND CUser="******" AND Title LIKE @skey"; } if (isaudit) { where += " AND Status>0 And Status IS NOT NULL"; } string order = "OrderFlag DESC,R_CDate DESC,CDate DESC"; List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter("skey", "%" + key + "%") }; PageSetting setting = PageSetting.Single(cpage, psize, TbView, PK, where, order, sp); DBCenter.SelPage(setting); return(setting); }
//本周热门,如本周无数据,则取总数据 public DataTable SelTop(int num) { string stime = "", etime = ""; DateHelper.GetWeekSE(DateTime.Now, ref stime, ref etime); Sql_Where whereMod = new Sql_Where() { join = "AND", field = "CDate", type = "date", stime = stime, etime = etime }; string where = "Pid = 0 And Status != " + ((int)ConStatus.Recycle); PageSetting setting = new PageSetting() { psize = num, cpage = 1, pk = PK, t1 = TbName, fields = "*", where = where + DBCenter.DB.GetDateSql(whereMod), order = "HitCount DESC" }; DataTable dt = DBCenter.SelPage(setting); if (dt.Rows.Count < 1) { setting.where = where; dt = DBCenter.SelPage(setting); } dt.Columns.Add(new DataColumn("IndexNum", typeof(int))); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["IndexNum"] = (i + 1); } return(dt); }
//---------------------------------------------------------------------------------------------------------- public PageSetting SelPage(int cpage, int psize, Com_Filter filter) { string where = " 1=1"; List <SqlParameter> sp = new List <SqlParameter>(); if (filter.type != "-100") { where += " AND A.QueType=" + DataConvert.CLng(filter.type); } if (!string.IsNullOrEmpty(filter.status)) { SafeSC.CheckIDSEx(filter.status); where += " AND A.Status IN (" + filter.status + ")"; } if (!string.IsNullOrEmpty(filter.uids)) { SafeSC.CheckIDSEx(filter.uids); where += " AND A.UserID IN (" + filter.uids + ")"; } if (!string.IsNullOrEmpty(filter.skey)) { where += " AND A.Qcontent LIKE @skey"; sp.Add(new SqlParameter("skey", "%" + filter.skey + "%")); } if (!string.IsNullOrEmpty(filter.ids)) { SafeSC.CheckIDSEx(filter.ids); where += " AND A.ID IN (" + filter.ids + ")"; } PageSetting setting = PageSetting.Double(cpage, psize, strTableName, "ZL_Grade", "A.ID", "A.QueType=B.GradeID", where, "ID DESC", sp, "A.*,B.GradeName"); DBCenter.SelPage(setting); return(setting); }
public PageSetting SelPage(int cpage, int psize, string inputer = "", int type = -100, string date = "") { string where = " 1=1"; List <SqlParameter> sp = new List <SqlParameter>(); if (!string.IsNullOrEmpty(inputer)) { where += " AND Inputer=@inputer"; sp.Add(new SqlParameter("inputer", inputer)); } if (type != -100) { where += " AND Type=" + type; } if (!string.IsNullOrEmpty(date)) { var newDate = DateTime.MinValue; bool isdate = DateTime.TryParse(date, out newDate); if (isdate) { where += " And Datediff(d,CreateTime,@Date) = 0"; sp.Add(new SqlParameter("Date", newDate)); } } PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where, "", sp); DBCenter.SelPage(setting); return(setting); }
/// <summary> /// 筛选获取数据 /// </summary> /// <param name="Type">0:后台,1:会员中心</param> /// <param name="customPath">后台路径</param> /// <param name="state">0:全部,1:启用,2:禁用</param> /// <returns></returns> public PageSetting SelPage(int cpage, int psize, F_Search filter) { List <SqlParameter> sp = new List <SqlParameter>(); string where = "1=1 "; if (!string.IsNullOrEmpty(filter.name)) { sp.Add(new SqlParameter("name", "%" + filter.name + "%")); where += " AND Name LIKE @name"; } if (filter.elite != -100) { where += " AND EliteLevel=" + filter.elite; } if (filter.type != -100) { where += " AND Type=" + filter.type; } if (filter.groupId != -100) { where += " AND (UserGroup='' OR ','+UserGroup+',' LIKE '%,'+'" + filter.groupId + "'+',%' ) "; } PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where, "OrderID ASC", sp); DBCenter.SelPage(setting); if (filter.type == 1) { for (int i = 0; i < setting.dt.Rows.Count; i++) { DataRow dr = setting.dt.Rows[i]; dr["FileUrl"] = DataConvert.CStr(dr["FileUrl"]).ToLower().Replace("/manage/", "/" + SiteConfig.SiteOption.ManageDir + "/"); } } return(setting); }
/// <summary> /// 用于管理试卷下题目 /// </summary> public PageSetting SelByIDS(int cpage, int psize, string ids, int qtype = 99, string fields = "*") { ids = StrHelper.PureIDSForDB(ids); if (string.IsNullOrEmpty(ids)) { return(null); } if (!SafeSC.CheckIDS(ids)) { return(null); } fields += ",IsRight=0,Remark=''"; //string sql = "SELECT " + fields + ",IsRight=0,Remark='' FROM " + strTableName + " WHERE p_id IN(" + ids + ") "; string where = " p_id IN(" + ids + ")"; if (qtype != 99)//过滤大题 { where += " AND p_Type=" + qtype; } else { where += " AND P_Type!=10"; } PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where, "p_type", null, fields); DBCenter.SelPage(setting); return(setting); }
/// <summary> /// 关键字搜索,并返回关键字对应文章、商品的数量 /// </summary> /// <param name="priority">优先级,1:非推荐,2:推荐,其它:全部</param> /// <returns></returns> public PageSetting SelPage(int cpage, int psize, string skey = "", int priority = 0) { string where = "1=1"; List <SqlParameter> sp = new List <SqlParameter>(); if (!string.IsNullOrEmpty(skey)) { where += " AND KeywordText LIKE @skey"; sp.Add(new SqlParameter("skey", "%" + skey + "%")); } switch (priority) { case 1: where += " AND Priority = 0"; break; case 2: where += " AND Priority > 0"; break; } PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where, "Priority DESC", sp); setting.fields = "(SELECT COUNT(*) FROM ZL_CommonModel WHERE Tagkey LIKE '%'+A.KeywordText+'%') ConCount,(SELECT COUNT(*) FROM ZL_Commodities WHERE Kayword LIKE '%'+A.KeywordText+'%') ComCount,*"; DBCenter.SelPage(setting); return(setting); }
/// <summary> /// 我发送的好友申请 /// </summary> public PageSetting SelMySendApply_SPage(int cpage, int psize, int uid) { PageSetting setting = PageSetting.Double(cpage, psize, TbName, "ZL_User", "A." + PK, "A.TUserID=B.UserID", "A.UserID=" + uid, "", null, "A.*,B.Salt,B.HoneyName,B.UserName"); DBCenter.SelPage(setting); return(setting); }
public PageSetting SelPage(int cpage, int psize, string name = "", string province = "", string city = "", string county = "") { string where = " 1=1"; List <SqlParameter> sp = new List <SqlParameter>(); if (!string.IsNullOrEmpty(name)) { where += " AND SchoolName @LIKE @name"; sp.Add(new SqlParameter("name", name)); } if (!string.IsNullOrEmpty(province)) { where += " AND Province=@province"; sp.Add(new SqlParameter("province", province)); } if (!string.IsNullOrEmpty(city)) { where += " AND City=@city"; sp.Add(new SqlParameter("city", city)); } if (!string.IsNullOrEmpty(county)) { where += " AND County LIKE @county"; sp.Add(new SqlParameter("county", "%" + county + "%")); } PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where, "", sp); DBCenter.SelPage(setting); return(setting); }
public PageSetting SPageByStore(int cpage, int psize, int expUid, int expStatus = -100) { //if (string.IsNullOrEmpty(storeids)) { return new PageSetting() { dt = new DataTable() }; } //SafeSC.CheckIDSEx(storeids); //所有已付款,指定了送货员的订单 string mTbName = "(SELECT A.*,B.PayType,B.PrePayInfo,C.ExpNo FROM ZL_OrderInfo A LEFT JOIN ZL_Payment B ON A.PayMentNo = B.PayNO LEFT JOIN ZL_Order_Exp C ON A.ExpressNum = C.ID WHERE A.Paymentstatus = 1 AND C.ExpNo='" + expUid + "')"; //string where = "A.StoreID IN (" + storeids + ") AND A.Settle=0 AND A.Paymentstatus=1"; string where = "1=1 "; if (expStatus == -100) { } else if (expStatus == 99) { //已完结==预付单支付了尾款,普通订单完成了签收 where += " AND ((A.PayType=1 AND A.PrePayInfo LIKE '%\"status\":99%') OR (A.PayType!=1 AND A.StateLogistics=99))"; } else { where += " AND A.StateLogistics=" + expStatus; } PageSetting setting = PageSetting.Double(cpage, psize, mTbName, "ZL_CommonModel", "A.ID", "A.StoreID=B.GeneralID", where, "", null, "A.*,B.Title StoreName"); DBCenter.SelPage(setting); return(setting); }
public PageSetting SelPage(int cpage, int psize, Com_Filter filter) { PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, ""); DBCenter.SelPage(setting); return(setting); }
public static PageSetting GetTipsList_SPage(int cpage, int psize, int gid) { PageSetting setting = PageSetting.Double(cpage, psize, "ZL_GuestBook", "ZL_User", "A.Gid", "A.UserID=B.UserID", "A.GID=" + gid + " OR A.ParentID=" + gid, "A.ParentID ASC,A.Gid ASC", null, "A.*,B.salt AS UserFace,B.UserName"); DBCenter.SelPage(setting); return(setting); }
/// <summary> /// 分页查询 /// </summary> /// <param name="status">词条状态:0未审核,1通过</param> /// <param name="title">词条名称</param> /// <param name="btype">词条标签</param> /// <param name="bkclass">词条所属类别</param> /// <returns></returns> public PageSetting SelPage(int cpage, int psize, int status = -100, string title = "", string btype = "", int uid = -100, string bkclass = "") { string where = " 1=1"; List <SqlParameter> sp = new List <SqlParameter>(); if (status != -100) { where += " AND Status=" + status; } if (!string.IsNullOrEmpty(title)) { where += " AND Tittle LIKE @title"; sp.Add(new SqlParameter("title", "%" + title + "%")); } if (!string.IsNullOrEmpty(btype)) { where += " AND btype LIKE @btype"; sp.Add(new SqlParameter("btype", "%" + btype + "%")); } if (uid != -100) { where += " AND UserID=" + uid; } if (!string.IsNullOrEmpty(bkclass)) { where += " ANd bkclass=@bkclass"; sp.Add(new SqlParameter("bkclass", bkclass)); } PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where, "", sp); DBCenter.SelPage(setting); return(setting); }
public PageSetting SelWaitQuest_SPage(int cpage, int psize, string quetype = "", int stype = 1, string skey = "") { string where = "1=1"; List <SqlParameter> sp = new List <SqlParameter>(); switch (stype) { case 1: where += " AND Status <> 2"; break; case 2: where += " AND Status = 2"; break; } if (!string.IsNullOrEmpty(quetype)) { where += " AND QueType = @quetype"; sp.Add(new SqlParameter("quetype", quetype)); } if (!string.IsNullOrEmpty(skey)) { where += " AND (Qcontent like @key or Supplyment like @key or QueType like @key)"; sp.Add(new SqlParameter("key", "%" + skey + "%")); } string fields = "*,(SELECT COUNT(*) FROM ZL_Favorite WHERE InfoID=A.ID) Favorite,(SELECT COUNT(*) FROM ZL_GuestAnswer WHERE QueID=A.ID) Answer"; PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where, "AddTime DESC", sp, fields); DBCenter.SelPage(setting); return(setting); }
/// <summary> /// 根据词条名,标签,类别来搜索数据,用于替代其他所有搜索 /// </summary> /// <param name="title">词条名称</param> /// <param name="btype">词条标签</param> /// <param name="bkclass">词条所属类别</param> public PageSetting SelByInfo(int cpage, int psize, string title, string btype, int uid, string bkclass = "") { List <SqlParameter> sp = new List <SqlParameter>(); string where = " Status=1 "; if (!string.IsNullOrEmpty(title)) { where += " AND Tittle LIKE @title"; sp.Add(new SqlParameter("title", "%" + title + "%")); } if (!string.IsNullOrEmpty(btype)) { where += " AND btype LIKE @btype"; sp.Add(new SqlParameter("btype", "%" + btype + "%")); } if (uid > 0) { where += " AND UserID=" + uid; } if (!string.IsNullOrEmpty(bkclass)) { where += " AND bkclass=@bkclass"; sp.Add(new SqlParameter("bkclass", bkclass)); } PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where, PK + " DESC", sp); DBCenter.SelPage(setting); return(setting); }
public PageSetting SelPage_All(int cpage, int psize, int userid = 0, int status = -1, string skey = "") { string where = "1=1"; List <SqlParameter> sp = new List <SqlParameter>(); if (userid > 0) { where += " AND CreateUser="******" AND IsTrue =" + status; } if (!string.IsNullOrEmpty(skey)) { where += " AND RoomName LIKE @name"; sp.Add(new SqlParameter("name", "%" + skey + "%")); } //该班级成员人数字段(按成员类别统计) string stufiled = ",(SELECT COUNT(*) FROM ZL_Exam_Student E WHERE A.RoomID=E.RoomID AND E.StudentType={0}) {1} "; PageSetting setting = PageSetting.Single(cpage, psize, "ZL_Exam_ClassView", PK, where, "Creation DESC", sp); setting.fields = "*" + string.Format(stufiled, 1, "StuCount") + string.Format(stufiled, 2, "TeachCount") + string.Format(stufiled, 3, "FamilyCount"); DBCenter.SelPage(setting); return(setting); }
//---------------------- public PageSetting SelPage(int cpage, int psize, Com_Filter filter) { List <SqlParameter> sp = new List <SqlParameter>(); string where = " 1=1 "; if (!string.IsNullOrEmpty(filter.status) && filter.status != "-100") { where += " AND Status=" + DataConvert.CLng(filter.status); } if (!string.IsNullOrEmpty(filter.skey)) { where += " AND A.Tittle LIKE @key"; sp.Add(new SqlParameter("key", "%" + filter.skey + "%")); } if (!string.IsNullOrEmpty(filter.uids)) { SafeSC.CheckIDSEx(filter.uids); where += " AND UserID IN (" + filter.uids + ")"; } if (!string.IsNullOrEmpty(filter.type)) { where += " AND btype LIKE @btype"; sp.Add(new SqlParameter("btype", "%" + filter.type + "%")); } if (!string.IsNullOrEmpty(filter.nids)) { where += " ANd bkclass=@bkclass"; sp.Add(new SqlParameter("bkclass", filter.nids)); } //if (!string.IsNullOrEmpty(btype)) { where += " AND btype LIKE @btype"; sp.Add(new SqlParameter("btype", "%" + btype + "%")); } //if (!string.IsNullOrEmpty(bkclass)) { where += " ANd bkclass=@bkclass"; sp.Add(new SqlParameter("bkclass", bkclass)); } string fields = "A.*,B.GradeName"; PageSetting setting = PageSetting.Double(cpage, psize, TbName, "ZL_Grade", "A." + PK, "A.BType=B.GradeName", where, "A." + PK + " DESC", sp, fields); DBCenter.SelPage(setting); return(setting); }
//, int uid, int status public PageSetting SelPage(int cpage, int psize, Com_Filter filter) { string where = "1=1 "; List <SqlParameter> sp = new List <SqlParameter>(); if (!string.IsNullOrEmpty(filter.uids)) { where += " AND UserID IN (" + filter.uids + ")"; } if (!string.IsNullOrEmpty(filter.status) && filter.status != "-100") { where += " AND Status=" + DataConvert.CLng(filter.status); } if (!string.IsNullOrEmpty(filter.skey)) { where += " AND Tittle LIKE @skey"; sp.Add(new SqlParameter("skey", "%" + filter.skey + "%")); } //flow if (!string.IsNullOrEmpty(filter.addon)) { where += " AND Flow =@flow"; sp.Add(new SqlParameter("flow", filter.addon)); } PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where); DBCenter.SelPage(setting); return(setting); }
//---------------------------------------------New public PageSetting SelPage(int cpage, int psize, F_Pub filter) { string where = "1=1 "; List <SqlParameter> sp = new List <SqlParameter>(); if (!string.IsNullOrEmpty(filter.pubType)) { SafeSC.CheckIDSEx(filter.pubType); where += " AND PubType IN (" + filter.pubType + ")"; } if (!string.IsNullOrEmpty(filter.pubName)) { sp.Add(new SqlParameter("pname", filter.pubName)); where += " AND PubName=@pname"; } if (filter.hasDel == false) { where += " AND PubIsDel=0"; } if (!string.IsNullOrEmpty(filter.ids)) { SafeSC.CheckIDSEx(filter.ids); where += " AND PubID IN (" + filter.ids + ")"; } PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where, "", sp); DBCenter.SelPage(setting); return(setting); }
//获取焦点数据 public DataTable SelFocus() { //后期改为不获取加密社区 int itemcount = 0; return(DBCenter.SelPage(10, 1, out itemcount, "A.ID", "a.*,b.CateName", TbName, "ZL_GuestCate", "a.CateID=b.CateID", "Pid=0 And A.Status>0 AND CateName !='华成会' AND B.GType=1", "CDate Desc")); }
private DataTable SelPage(out int itemCount) { //0:内容,1:商品,2:论坛,3:问答,4:留言,5:店铺 int s = DataConvert.CLng(Request["s"]); //*节点ID可能有重复,解决:加一个来源参数,S=0:内容表,1:贴吧 //ZL_CommonModel status=99,表名ZL_C_,或ZL_P,或ZL_S string where = " Title Like @key "; if (s != -100) { where += " AND S=" + s; } string order = ""; if (NodeID > 0) { where += " AND NodeID=" + NodeID; } switch (Order) { case 0: order = "CreateTime DESC"; break; case 1: order = "Hits DESC"; break; } SqlParameter[] sp = new SqlParameter[] { new SqlParameter("key", "%" + KeyWord + "%") }; return(DBCenter.SelPage(20, CPage, out itemCount, "ID", "*", "ZL_SearchView", where, order, sp)); }
private PageSetting SelPage(int cpage, int psize, int stepid, int id) { string where = ""; if (id > 0) { where += " A.ID=" + id; } if (stepid > 0) { where += " A.StepID=" + stepid; } PageSetting setting = new PageSetting() { fields = "A.*,B.UserName,B.UserFace,B.GroupName", cpage = cpage, psize = psize, t1 = "ZL_Pro_Msg", t2 = "ZL_User_PlatView", on = "A.CUser=B.UserID", where = where }; setting.dt = DBCenter.SelPage(setting); return(setting); }
public PageSetting SelWaitQuest_SPage(int cpage, int psize, string quetype = "", int stype = 1, string skey = "") { string where = "1=1"; List <SqlParameter> sp = new List <SqlParameter>(); switch (stype) { case 1: where += " AND Status <> 2"; break; case 2: where += " AND Status = 2"; break; } if (!string.IsNullOrEmpty(quetype)) { where += " AND QueType = @quetype"; sp.Add(new SqlParameter("quetype", quetype)); } if (!string.IsNullOrEmpty(skey)) { where += " AND (Qcontent like @key or Supplyment like @key or QueType like @key)"; sp.Add(new SqlParameter("key", "%" + skey + "%")); } PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where, "AddTime DESC", sp); DBCenter.SelPage(setting); return(setting); }
/// <summary> /// 用于前后台|店铺筛选订单(支持快速搜索) /// </summary> public PageSetting SelPage(int cpage, int psize, out double total, int storeid, string orderType, string orderStatus, string payStatus) { string where = "1=1 "; if (storeid != -100) { where += " AND StoreID=" + storeid; } if (!string.IsNullOrEmpty(orderType)) { SafeSC.CheckIDSEx(orderType); where += " AND OrderType IN (" + orderType + ")"; } if (!string.IsNullOrEmpty(orderStatus)) { where += " AND OrderStatus=" + DataConvert.CLng(orderStatus); } if (!string.IsNullOrEmpty(payStatus)) { where += " AND Paymentstatus=" + DataConvert.CLng(payStatus); } PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where, "", null); DBCenter.SelPage(setting); total = DataConvert.CDouble(DBCenter.ExecuteScala(TbName, "SUM(ordersamount)", where)); return(setting); }
public PageSetting SelPage(int cpage, int psize, int queType = -100, int status = -100, int uid = -100, string key = "") { string where = " 1=1"; List <SqlParameter> sp = new List <SqlParameter>(); if (queType != -100) { where += " AND QueType=" + queType; } if (status != -100) { where += " AND Status=" + status; } if (uid != -100) { where += " AND UserID=" + uid; } if (!string.IsNullOrEmpty(key)) { where += " AND Qcontent LIKE @skey"; sp.Add(new SqlParameter("skey", "%" + key + "%")); } PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where, "", sp); DBCenter.SelPage(setting); return(setting); }
public PageSetting SelPage(int cpage, int psize) { PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, ""); DBCenter.SelPage(setting); return(setting); }
public PageSetting SelPage(int cpage, int psize, Com_Filter filter) { List <SqlParameter> sp = new List <SqlParameter>(); string where = " 1=1"; //if (group != -100) { where += " AND [Group]=" + group; } //if (status != -100) { where += " AND Status=" + status; } if (!string.IsNullOrEmpty(filter.skey)) { sp.Add(new SqlParameter("name", "%" + filter.skey + "%")); where += " AND Name LIKE @name"; } if (filter.pid > 0) { where += " And ParentID=" + filter.pid; } else { where += " And ParentID=0"; } //不倒序 PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where, "", sp); DBCenter.SelPage(setting); return(setting); }