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));
}
