public ActionResult UsersList(string keyword, int pagesize = 10, int pageindex = 1) { WhereClip where = new WhereClip(); if (!string.IsNullOrEmpty(keyword)) { where.Or(new WhereClip(_userinfo._.name, keyword, QueryOperator.Like)); where.Or(new WhereClip(_userinfo._.phone, keyword, QueryOperator.Like)); } int count = DB.Context.Count <_userinfo>(where); List <_userinfo> models = DB.Context.From <_userinfo>().Where(where).OrderByDescending(c => c.id).Page(pagesize, pageindex).ToList(); ViewBag.models = models; InitPages(count, pageindex, pagesize); return(View()); }
public Knowledge[] KnowledgePager(int couid, string kns, string searTxt, int size, int index, out int countSum) { WhereClip wc = new WhereClip(); if (couid > 0) { wc.And(Knowledge._.Cou_ID == couid); } wc.And(Knowledge._.Kn_IsUse == true); if (!string.IsNullOrWhiteSpace(kns)) { WhereClip wcSbjid = new WhereClip(); foreach (string tm in kns.Split(',')) { if (string.IsNullOrWhiteSpace(tm)) { continue; } int sbj = 0; int.TryParse(tm, out sbj); if (sbj == 0) { continue; } wcSbjid.Or(Knowledge._.Kns_ID == sbj); } wc.And(wcSbjid); } if (searTxt != string.Empty) { wc.And(Knowledge._.Kn_Title.Like("%" + searTxt + "%")); } countSum = Gateway.Default.Count <Knowledge>(wc); return(Gateway.Default.From <Knowledge>().Where(wc).OrderBy(Knowledge._.Kn_CrtTime.Desc).ToArray <Knowledge>(size, (index - 1) * size)); }
public int PagerOfCount(int orgid, int sbjid, int couid, int diff, bool?isUse) { WhereClip wc = new WhereClip(); if (orgid > 0) { wc.And(TestPaper._.Org_ID == orgid); } if (sbjid > 0) { WhereClip wcSbjid = new WhereClip(); List <int> list = Business.Do <ISubject>().TreeID(sbjid); foreach (int l in list) { wcSbjid.Or(TestPaper._.Sbj_ID == l); } wc.And(wcSbjid); } if (couid > 0) { wc.And(TestPaper._.Cou_ID == couid); } if (diff > 0) { wc.And(TestPaper._.Tp_Diff == diff); } if (isUse != null) { wc.And(TestPaper._.Tp_IsUse == (bool)isUse); } return(Gateway.Default.Count <TestPaper>(wc)); }
public TestPaper[] PagerCount(int orgid, int sbjid, int couid, int diff, bool?isUse, int count) { WhereClip wc = TestPaper._.Tp_Id > -1; if (orgid > 0) { wc.And(TestPaper._.Org_ID == orgid); } if (sbjid > 0) { WhereClip wcSbjid = new WhereClip(); List <int> list = Business.Do <ISubject>().TreeID(sbjid); foreach (int l in list) { wcSbjid.Or(TestPaper._.Sbj_ID == l); } wc.And(wcSbjid); } if (couid > 0) { wc.And(TestPaper._.Cou_ID == couid); } if (diff > 0) { wc.And(TestPaper._.Tp_Diff == diff); } if (isUse != null) { wc.And(TestPaper._.Tp_IsUse == (bool)isUse); } count = count > 0 ? count : int.MaxValue; return(Gateway.Default.From <TestPaper>().Where(wc).OrderBy(TestPaper._.Tp_CrtTime.Desc).ToArray <TestPaper>(count)); }
public Article[] ArticlePager(int orgid, int?colid, bool?isVerify, bool?isDel, string searTxt, int size, int index, out int countSum) { WhereClip wc = new WhereClip(); if (orgid > 0) { wc.And(Article._.Org_ID == orgid); } if (colid > 0) { WhereClip wcColid = new WhereClip(); List <int> list = Business.Do <IColumns>().TreeID((int)colid); foreach (int l in list) { wcColid.Or(Article._.Col_Id == l); } wc.And(wcColid); } if (searTxt != null && searTxt.Trim() != "") { wc.And(Article._.Art_Title.Like("%" + searTxt + "%")); } if (isVerify != null) { wc.And(Article._.Art_IsVerify == (bool)isVerify); } if (isDel != null) { wc.And(Article._.Art_IsDel == (bool)isDel); } countSum = Gateway.Default.Count <Article>(wc); return(Gateway.Default.From <Article>().Where(wc).OrderBy(Article._.Art_PushTime.Desc).ToArray <Article>(size, (index - 1) * size)); }
public ActionResult ListDirectory(string keyword, int pagesize = 10, int pageindex = 1) { WhereClip where = new WhereClip(); if (!string.IsNullOrEmpty(keyword)) { where.Or(new WhereClip(_directories._.type, keyword, QueryOperator.Like)); where.Or(new WhereClip(_directories._.source, keyword, QueryOperator.Like)); where.Or(new WhereClip(_directories._.explain, keyword, QueryOperator.Like)); } int count = DB.Context.Count <_directories>(where); List <_directories> models = DB.Context.From <_directories>().Where(where).OrderByDescending(c => c.id).Page(pagesize, pageindex).ToList(); ViewBag.models = models; InitPages(count, pageindex, pagesize); return(View()); }
public ActionResult ContractList(string keyword, int pagesize = 10, int pageindex = 1) { WhereClip where = new WhereClip(); if (!string.IsNullOrEmpty(keyword)) { where.Or(new WhereClip(合同记录._.合同内容, keyword, QueryOperator.Like)); where.Or(new WhereClip(合同记录._.合同区域, keyword, QueryOperator.Like)); where.Or(new WhereClip(合同记录._.甲方, keyword, QueryOperator.Like)); } int count = DB.Context.Count <合同记录>(where); List <合同记录> models = DB.Context.From <合同记录>().Where(where).OrderByDescending(c => c.id).Page(pagesize, pageindex).ToList(); List <合同类别> contracttypes = DB.Context.From <合同类别>().ToList(); List <区域代码> contracttareas = DB.Context.From <区域代码>().ToList(); ViewBag.models = models; ViewBag.contracttypes = contracttypes; ViewBag.contracttareas = contracttareas; InitPages(count, pageindex, pagesize); return(View()); }
/// <summary> /// 分页获取 /// </summary> /// <param name="orgid"></param> /// <param name="couid"></param> /// <param name="gcids">考试指南分类,多个id,逗号分隔</param> /// <param name="searTxt"></param> /// <param name="isShow"></param> /// <param name="size"></param> /// <param name="index"></param> /// <param name="countSum"></param> /// <returns></returns> public Guide[] GetGuidePager(int orgid, int couid, string gcids, string searTxt, bool?isShow, int size, int index, out int countSum) { WhereClip wc = new WhereClip(); if (orgid > 0) { wc.And(Guide._.Org_ID == orgid); } if (couid > 0) { wc.And(Guide._.Cou_ID == couid); } if (!string.IsNullOrWhiteSpace(gcids)) { WhereClip wcSbjid = new WhereClip(); foreach (string tm in gcids.Split(',')) { if (string.IsNullOrWhiteSpace(tm)) { continue; } int sbj = 0; int.TryParse(tm, out sbj); if (sbj == 0) { continue; } wcSbjid.Or(Guide._.Gc_ID == sbj); } wc.And(wcSbjid); } if (isShow != null) { wc.And(Guide._.Gu_IsShow == (bool)isShow); } if (searTxt != null && searTxt.Trim() != "") { wc.And(Guide._.Gu_Title.Like("%" + searTxt + "%")); } countSum = Gateway.Default.Count <Guide>(wc); return(Gateway.Default.From <Guide>().Where(wc).OrderBy(Guide._.Gu_PushTime.Desc).ToArray <Guide>(size, (index - 1) * size)); }
public Article[] ArticleCount(int orgid, int colid, int topNum, string order) { WhereClip wc = Article._.Art_IsDel == false && Article._.Art_IsShow == true; if (orgid > 0) { wc.And(Article._.Org_ID == orgid); } //if (colid > 0) wc.And(Article._.Col_Id == colid); if (colid > 0) { WhereClip wcColid = new WhereClip(); List <int> list = Business.Do <IColumns>().TreeID((int)colid); foreach (int l in list) { wcColid.Or(Article._.Col_Id == l); } wc.And(wcColid); } OrderByClip wcOrder = new OrderByClip(); if (order == "hot") { wcOrder = Article._.Art_IsHot.Desc; } if (order == "img") { wcOrder = Article._.Art_IsImg.Desc; } if (order == "rec") { wcOrder = Article._.Art_IsRec.Desc; } if (order == "flux") { wcOrder = Article._.Art_Number.Desc; } Song.Entities.Article[] arts = Gateway.Default.From <Article>().Where(wc).OrderBy(wcOrder && Article._.Art_PushTime.Desc && Article._.Art_CrtTime.Desc).ToArray <Article>(topNum); return(arts); }
public TestPaper[] PaperPager(int orgid, int sbjid, int couid, int diff, bool?isUse, string sear, int size, int index, out int countSum) { WhereClip wc = new WhereClip(); if (orgid > 0) { wc &= TestPaper._.Org_ID == orgid; } if (sbjid > 0) { WhereClip wcSbjid = new WhereClip(); List <int> list = Business.Do <ISubject>().TreeID(sbjid); foreach (int l in list) { wcSbjid.Or(TestPaper._.Sbj_ID == l); } wc.And(wcSbjid); } if (couid > 0) { wc.And(TestPaper._.Cou_ID == couid); } if (diff > 0) { wc.And(TestPaper._.Tp_Diff == diff); } if (isUse != null) { wc.And(TestPaper._.Tp_IsUse == (bool)isUse); } if (sear != null && sear.Trim() != "") { wc.And(TestPaper._.Tp_Name.Like("%" + sear + "%")); } countSum = Gateway.Default.Count <TestPaper>(wc); return(Gateway.Default.From <TestPaper>().Where(wc).OrderBy(TestPaper._.Tp_CrtTime.Desc).ToArray <TestPaper>(size, (index - 1) * size)); }
/// <summary> /// 当前章节有多少道试题 /// </summary> /// <param name="olid"></param> /// <param name="type"></param> /// <param name="isUse"></param> /// <param name="isAll">是否取所有(当前章节下所有子章节的试题一块算)</param> /// <returns></returns> public int QuesOfCount(int olid, int type, bool?isUse, bool isAll) { WhereClip wc = new WhereClip(); if (type > 0) { wc.And(Questions._.Qus_Type == type); } if (isUse != null) { wc.And(Questions._.Qus_IsUse == (bool)isUse); } if (olid > 0 && isAll) { WhereClip wcSbjid = new WhereClip(); List <int> list = TreeID(olid); foreach (int l in list) { wcSbjid.Or(Questions._.Ol_ID == l); } wc.And(wcSbjid); } return(Gateway.Default.Count <Questions>(wc)); }