public PageSetting SelPage(int cpage, int psize, Com_Filter filter) { PageSetting setting = PageSetting.Single(cpage, psize, TbName, 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 (!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); }
//---------------------------------------------------------------------------------------------------------- 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, Com_Filter filter) { string fields = "*"; string where = "1=1"; List <SqlParameter> sp = new List <SqlParameter>(); if (filter.storeId != -100) { where += " AND SpecCate=" + filter.storeId; } if (filter.pid != -100) { where += " AND Pid=" + filter.pid; } if (!string.IsNullOrEmpty(filter.skey)) { where += " AND SpecName LIKE @name"; sp.Add(new SqlParameter("name", "%" + filter.skey + "%")); } if (filter.type != "-100") { where += " AND SpecCate=" + DataConvert.CLng(filter.type); } if (filter.mode == "list") { fields = "A.*,(Select Count(*) From ZL_Special Where Pid=A.SpecID) as ChildCount"; } PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where, "OrderID", sp, fields); 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); }
public PageSetting SelPage(int cpage, int psize, Com_Filter filter) { string where = "1=1"; if (filter.storeId > 0) { where += " AND AppId=" + filter.storeId; } PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where); DBCenter.SelPage(setting); return(setting); }
//-------------- public PageSetting SelPage(int cpage, int psize, Com_Filter filter) { string where = "1=1 "; List <SqlParameter> sp = new List <SqlParameter>(); if (filter.storeId != -100) { where += " AND DicCate=" + filter.storeId; } if (!string.IsNullOrEmpty(filter.skey)) { where += "DicCateName LIKE @skey"; sp.Add(new SqlParameter("skey", "%" + filter.skey + "%")); } PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where, PK + " DESC", sp); DBCenter.SelPage(setting); return(setting); }
public PageSetting SelPage(int cpage, int psize, Com_Filter filter) { //, int taskType = -100, string taskName = "" string where = "1=1 "; List <SqlParameter> sp = new List <SqlParameter>(); if (!string.IsNullOrEmpty(filter.type) && !filter.type.Equals("-100")) { where += " AND TaskType=" + DataConvert.CLng(filter.type); } if (!string.IsNullOrEmpty(filter.skey)) { where += " AND TaskName LIKE @TaskName"; sp.Add(new SqlParameter("TaskName", "%" + filter.skey + "%")); } PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where, PK + " DESC", sp); DBCenter.SelPage(setting); return(setting); }
//public DataTable SelByAppId(int appid, string name = "") //{ // return SelPage(1, int.MaxValue, new Com_Filter() // { // storeId = appid, // uname = name // }).dt; //} public PageSetting SelPage(int cpage, int psize, Com_Filter filter) { List <SqlParameter> sp = new List <SqlParameter>(); string where = "1=1"; string stable = "(SELECT A.UserID,A.OpenID,B.UserName FROM ZL_UserApp A LEFT JOIN ZL_User B ON A.UserID=B.UserID WHERE A.SourcePlat='wechat')"; if (filter.storeId > 0) { where += " AND A.AppID=" + filter.storeId; } if (!string.IsNullOrEmpty(filter.uname)) { where += " AND A.Name LIKE @name"; sp.Add(new SqlParameter("name", "%" + filter.uname + "%")); } PageSetting setting = PageSetting.Double(cpage, psize, "ZL_WX_User", stable, "A.ID", "A.OpenID=B.OpenID", where, "ID DESC", sp, "A.*,B.UserID,B.UserName"); DBCenter.SelPage(setting); return(setting); }
public DataTable SelPage(Com_Filter filter) { return(SelPage(1, int.MaxValue, filter).dt); }