private DataTable MyBind(int psize, int cpage) { M_ModelInfo modMod = modBll.SelReturnModel(pubMod.PubModelID); string where = "1=1 "; List <SqlParameter> sp = new List <SqlParameter>(); if (!string.IsNullOrEmpty(skey.Value)) { if (!IsExistInFieldDT(skey_dp.SelectedValue)) { function.WriteErrMsg("搜索的字段不存在"); } where += " AND " + skey_dp.SelectedValue + " LIKE @skey"; sp.Add(new SqlParameter("skey", "%" + skey.Value.Trim() + "%")); } if (Status != -100) { where += " AND PubStart=" + Status; } if (ParentID > 0) { where += " AND Parentid=" + ParentID; } setting = PageSetting.Single(cpage, psize, modMod.TableName, "ID", where, "ID DESC", sp); DBCenter.SelPage(setting); foreach (DataRow dr in setting.dt.Rows) { dr["PubIP"] = dr["PubIP"] + "(" + IPScaner.IPLocation(DataConvert.CStr(dr["PubIP"])) + ")"; } RPT.ItemCount = setting.itemCount; return(setting.dt); }
/// <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="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); }
/// <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> /// <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); }
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, 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 SelPage(int cpage, int psize, F_User filter) { List <SqlParameter> sp = new List <SqlParameter>(); string where = "1=1 "; if (!string.IsNullOrEmpty(filter.groupIds)) { if (filter.groupIds.Equals("0"))//全部 { } else if (filter.groupIds.Equals("-1"))//未分组 { where += " And Gid IS NULL OR Gid=''"; } else { where += " And Gid Like '%," + DataConvert.CLng(filter.groupIds) + ",%'"; } } if (!string.IsNullOrEmpty(filter.compIds) && !filter.compIds.Equals("0")) { where += " AND CompID=" + DataConvert.CLng(filter.compIds); } if (!string.IsNullOrEmpty(filter.uname)) { sp.Add(new SqlParameter("uname", "%" + filter.uname + "%")); where += " AND (UserName LIKE @uname OR HoneyName LIKE @uname) "; } PageSetting setting = PageSetting.Single(cpage, psize, TbView, PK, where, "", sp); 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, int stype, int uid, string skey, string stime, string etime) { string tbname = GetTbName((SType)stype); List <SqlParameter> sp = new List <SqlParameter>(); string where = "1=1 "; if (uid > 0) { where += " AND UserID=" + uid; } if (!string.IsNullOrEmpty(stime)) { where += " AND HisTime >=@stime"; sp.Add(new SqlParameter("stime", stime)); } if (!string.IsNullOrEmpty(etime)) { where += " AND HisTime <=@etime"; sp.Add(new SqlParameter("etime", etime)); } if (!string.IsNullOrEmpty(skey)) { where += " AND Detail LIKE @skey"; sp.Add(new SqlParameter("skey", "%" + skey + "%")); } PageSetting setting = PageSetting.Single(cpage, psize, tbname, PK, where, "HisTime DESC", sp); DBCenter.SelPage(setting); return(setting); }
public static PageSetting User_SelPage(int cpage, int psize, F_User filter) { List <SqlParameter> sp = new List <SqlParameter>(); string where = "SiteID=" + filter.storeId + " "; //where += " AND Status=0"; switch (filter.utype) { case "employee": where += " AND GroupID=" + ExConast.EmployGroup; break; case "client": default: where += " AND GroupID=" + ExConast.ClientGroup; break; } if (!string.IsNullOrEmpty(filter.uname)) { sp.Add(new SqlParameter("uname", "%" + filter.uname + "%")); where += " AND UserName LIKE @uname"; } if (filter.status != -100) { where += " AND Status=" + filter.status; } PageSetting setting = PageSetting.Single(cpage, psize, "ZL_User", "UserID", where, "UserID DESC", sp); DBCenter.SelPage(setting); return(setting); }
public PageSetting SelPage(int cpage, int psize, string inputer = "", int results = -100, string approver = "", string send = "") { 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 (results != -100) { where += " AND Results=" + results; } if (!string.IsNullOrEmpty(approver)) { where += " AND Approver LIKE @approver"; sp.Add(new SqlParameter("approver", "%" + approver + "%")); } if (!string.IsNullOrEmpty(send)) { where += " AND Send LIKE @send"; sp.Add(new SqlParameter("send", "%" + send + "%")); } PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where, "", sp); DBCenter.SelPage(setting); return(setting); }
public PageSetting SelPage(int cpage, int psize, int pid = -100, string inputer = "", string type = "", string title = "") { string where = " 1=1"; List <SqlParameter> sp = new List <SqlParameter>(); if (pid != -100) { where += " AND ParentID=" + pid; } if (!string.IsNullOrEmpty(inputer)) { where += " AND Inputer LIKE @inputer"; sp.Add(new SqlParameter("inputer", inputer)); } if (!string.IsNullOrEmpty(type)) { where += " AND type LIKE @type"; sp.Add(new SqlParameter("type", type)); } if (!string.IsNullOrEmpty(title)) { where += " AND title LIKE @title"; sp.Add(new SqlParameter("title", title)); } PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where, "", sp); DBCenter.SelPage(setting); return(setting); }
public PageSetting SelPage(int cpage, int psize, string ztype = "", string ids = "", string remind = "", int status = -100, int uid = 0) { string where = "1=1 "; List <SqlParameter> sp = new List <SqlParameter>(); if (!string.IsNullOrEmpty(ztype)) { where += " AND A.ZType=@ztype"; sp.Add(new SqlParameter("ztype", ztype)); } if (!string.IsNullOrEmpty(ids)) { SafeSC.CheckIDSEx(ids); where += " AND A.ID IN (" + ids + ")"; } if (!string.IsNullOrEmpty(remind)) { where += " AND A.Remind=@remind"; sp.Add(new SqlParameter("remind", remind)); } if (status != -100) { where += " AND A.Status=" + status; } if (uid > 0) { where += " AND A.UserID=" + uid; } PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where, PK + " DESC", sp); 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 PageSetting SelPage(int cpage, int psize, Com_Filter filter) { PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, ""); 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> /// <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(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) { PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, ""); DBCenter.SelPage(setting); return(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); }
/// <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); }
//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 PageSetting SelPage(int cpage, int psize) { PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, "", "CDate DESC"); 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); }
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); }
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 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); }
public PageSetting SelPage(int cpage, int psize) { string where = "1=1 "; PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where); DBCenter.SelPage(setting); return(setting); }
//只取正常状态的 private DataTable SelMyLend() { string where = "UserID=" + mu.UserID + " AND OrderType=10 AND OrderStatus IN (0,-2) "; PageSetting setting = PageSetting.Single(1, int.MaxValue, "ZL_Ex_OrderView", "ID", where, "OrderStatus DESC,ID ASC"); DBCenter.SelPage(setting); return(setting.dt); }